See all student responses to multiple questions in one place! A Google Sheets spreadsheet is a document. If you can do it in a Google Text Document you can probably also do it in a Google Sheets spreadsheet. I like to say “The Answer is Always a Spreadsheet.” Incorporating spreadsheets into your class provides students with a valuable life skill. Spreadsheets are not scary if you use them! Get students using spreadsheets.
Make Use of Tabs
One of many things that is awesome about a spreadsheet is that you can add multiple sheets. This allows you to chunk up the assignment into parts. Students complete the questions or activity on the first sheet and then go onto the next sheet. This in and of itself is a great life skill. Simply feeling comfortable to look for multiple sheets in a spreadsheet will help everyone!
Create multiple answer boxes in your spreadsheet. I like to use the paint can to fill the cells in yellow to indicate to the students where to put the answer.
I got a little fancy with this spreadsheet, but notice how there are multiple sheets along the bottom. Students start with the first sheet and put their name in the yellow box. Then move onto the next sheet to do the next activity.
Add a sheet to the spreadsheet and name it “Responses” (or whatever you want.) The idea is all of those yellow answer boxes all come to a single answer sheet. This helps you to avoid having to click on every tab in the student spreadsheet to see if they did the activity.
The formula you need to create a responses sheet is the EQUALS SIGN. That is it!! On the responses tab type an equals sign into a cell. Then click on the tab that has a yellow answer box and click on where the student is expected to insert a response. Press Enter. Repeat this for every answer box in the spreadsheet. When students type into the yellow boxes their answer will populate on the responses answer sheet.
Hide the Answer Responses
Tip: HIDE this answer sheet. You want students to put their answers on the individual tabs, not type them onto the answer sheet. Click on the tiny triangle on the tab and choose “Hide sheet.”
View Hidden Sheet
When reviewing a spreadsheet that a student has completed, go to the View menu and select “Hidden sheets.” You can then reveal the responses sheet to find all the responses in one place! No having to go tab to tab.