The custom number format allows you to have text and numbers in the same cell in a Google Sheet. This adds visual clarity to your spreadsheet and helps the user enter data. Calculations are still possible as Google Sheets ignores the text you have entered and uses the numerical data in the cell.
There are many uses for Google Sheets in the classroom. I like to be able to have my own class list where I can keep track of my students. I would use a sheet for attendance, recording homework, anecdotal notes and marks. Many LMS’s can do this, but I like the ability to customise what I see and enter, Google Sheets allow me to do this easily.
ClassroomScreen is a brilliant, FREE tool that allows you to customise a screen with widgets (tools) that will support classroom management and engagement. Your and your students will love how easily and quickly you can communicate with it. The symbols are great for learning about visual literacy too.
A major sticking point with moving from Excel to Google Sheets was the lack of ability to use macros. A macro will let you automate calculations and other aspects in spreadsheets. For instance, if you regularly tally up marks, allocate a grade and then draw a graph or chart of the results for your class, the you can create a macro to do this for you. Google Sheets now have the capacity to write and run you own macros. This will increase your efficiency and save you time.