Monday, November 21, 2016

Research Topic Sign Up Cross Out When Taken

I just worked through a process where Mr. Gosse, Chemistry teacher, wanted students to sign up for research topics.  He created a Google Sheet that will be shared with students.  He added formulas to the right side of the sheet so that the topics are crossed out when a student adds their name.

Because the entire sheet needs to be shared with students in an editing mode, he wanted to know if certain cells (the topics on the right side) could be protected.

They can.

Students will now choose their topic and add their name all within the Google Sheets app on their iPad.


Related Posts Plugin for WordPress, Blogger...