Untitled drawing (2)

 

If you have a task you want your entire class to do, here is a spreadsheet tip that can make the process easier.

Create a Google Spreadsheet

spreadsheet

 

Blue Share Button

Click on the blue share button in the upper right hand corner. Change the sharing rights to anyone with the link can edit.

change sharing

 

anyone with the link can edit alice keeler

 

Alternatively you can copy and paste the email address of all your students into the sharing settings. This will allow you to restrict who can type on what tab.

Create a Tab

By pressing on the plus icon in the bottom left of the spreadsheet you can create a tab per student.

add a tab

 

If you create a template to help students organize their work you can click on the arrow on the tab (hover over the tab, it appears) and choose to duplicate.

duplicate the tab alice keeler

 

Rename the Tabs

Double click on the tabs to put the students name on the tab.

Protect the Sheet

If you are concerned about students editing the tabs of other students you can protect the sheet. This only works if you expressly entered the email address of the students into the sharing settings. Click on the arrow of the tab and choose to “Protect sheet…”

protect sheet alice keeler

 

Choose the 3rd option “Me, and the collaborators selected below:” Check box the student who can edit that tab.

share with specific people alice keeler

 

Share the Link

Share the link to the spreadsheet with the students. This means you have one document to check over. It also makes it easy to see each students progress and to give them comments as they work on it. Simply click on the different tabs.

Hint: If you go to a tab and copy the URL while on that that tab, the link goes directly to that tab. This means each student has a unique URL pointing to their work.