A firm rule when using Google Sheets spreadsheets (or Excel)… you only input information ONCE! If you have a roster of students’ names, do not type them in again ever. You put the name into the spreadsheet ONCE. Only Put In Once in Google Sheets. Even if you need it on multiple sheets.
Tracking Across Sheets
Let’s say you have a spreadsheet where on each tab you are tracking different things about each student. Attendance on one sheet, behavior tracking on another, materials check out on a third. This requires each student’s name on each of the sheets.
The easiest spreadsheet formula is simply an equals sign. When you want to have a value, such as a student’s name, a second time in the spreadsheet press the equals key in the cell you want the value to show up again.
After the equals sign, click on the cell that contains the original value. This is known as cell referencing. You REFERENCE the cell instead of retyping the value.
Only Put In Once in Google Sheets
The advantage to using cell referencing is when you update the original value, any references will update.
Even if you have multiple sheets in your spreadsheet you should only put in once in Google Sheets. On a different sheet type an equals sign and click on the original sheet.
Absolute Cell Reference
ABSOLUTELY we only put information into a spreadsheet once. In the case of the roster there is a list of names in A2, A3, A4, etc… the next name moves.
But what if there was no “next.”
When the value is only in one place use ABSOLUTE CELL REFERENCING. This locks down the location to always be in the same place.
The dollar sign locks down the row and column.
Who doesn’t love a good keyboard shortcut?
Single click on the cell and press F4
The F4 key will automatically add the dollar signs for you. This is a huge time saver. If you are on a Mac you may need to hold down the Fn key to access the F4 key.
Unfortunately Google Forms™ does not have version history. HOWEVER, Martin Hawksey saves the day with his Google Forms History Add-on.
Google Keep is a tool I use daily, can not live without it. Here are 5 Features of Google Keep You Are Not Using.
Google Form fonts have been limited. Here is how you can customize your Google Forms to choose from a variety of Font styles.
Here are 5 Google Jamboard Templates to help you engage your students. Get students collaborating and critically thinking with Google Jamboard.