Teacher Tech blog with Alice Keeler

Paperless Is Not a Pedagogy

Alice Keeler

Google Sheets: Students Protect Their Work

Google sheets students protect their work

Google Sheets: Students Protect Their Work

Google sheets students protect their work

I am a big fan of collaborative documents. Having all students in the class on the same spreadsheet allows you to collect student ideas and crowdsource information. Once concern about collaborative documents is students accidentally deleting each others work. If a spreadsheet is explicitly shared with the students, Google Classroom does this automatically, the student can protect their contribution.
Protect Range

Right Click

After selecting a cell or a range of cells, the student will right-click to reveal a menu of options. Students choose “Protect range.”
Protect Range

Name Range

Students can name the range they wish to protect and click the blue “Set permissions” button.
Set and name permissions

Customize Sharing Permissions

The next screen reveals who has editing permissions on that range. Students should click on “Custom.”
custom range

Students should choose the option “Only you and the spreadsheet owner.” While students can lock other students out of editing portions of the spreadsheet, they can not restrict the teacher (owner).
only you and the spreadsheet owner

Tips

  • Students can click on the row indicator to highlight the entire row. Right click on the row indicator to protect the entire row.
  • Students can create a tab in the spreadsheet and protect the entire sheet by clicking on the arrow on the tab and choosing “Protect sheet.”
    click on spreadsheet tab to reveal protect sheet
  • Use alicekeeler.com/rostertab to create a sheet in the spreadsheet for each student. Students can protect their sheet from editing.

 

 

5 Easy Steps for Teaching with Digital Tools

Introducing digital tools into your teaching can seem challenging at first. There are many tools out there, and it might feel like there’s a lot to learn. But with easy steps for teaching with digital tools, you can start simply and gradually. There’s no need to dive in all at once – just take it one step at a time. Taking easy steps for teaching with digital tools starts with trying something!

Read More »
Students Prepare to Present

Help Your Students Prepare to Present

Maximize student success in presentations with ‘Speaker Notes by AliceKeeler,’ the ideal Google Slides add-on. Enhance how students prepare to present with easy transfer of speaker notes to Google Docs, promoting effective communication skills. Dive into the world of engaging, technology-aided presentations and empower students to shine in their academic endeavors. Discover the key to transforming student presentations into interactive, skill-building experiences.

Read More »

Infographic 7 Basic Steps for a Google Form

New to using Google Forms? This tool is essential for teachers to not only save time but to be adaptive to student needs. Use Forms to survey students, play games, personalize instruction, and assessment. This infographic on the 7 basic steps for a Google Form will help you get started.

Read More »

Online Workshop: Get Your Add-on Published

How can you make Google Workspace (Docs/Sheets/Slides) even better? You can create custom Add-ons with Google Apps Script. Wondering How to Get Your Google Workspace Add-on Published? Join Alice Keeler, Google Developer Expert, to learn the steps to get your Add-on officially published.

Read More »

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d