Instructional Uses
Class Resources Sheet
The process consists of a teacher structuring a sheet to resemble a course calendar with columns such as date, date, unit and chapter. By including columns such as: assignments, notes, slides, homework and video playlists, a teacher can efficiently organize an entire course into one sheet.
As the class progresses, additional sheets can be added as tabs across the bottom to differentiate between quarters, semesters or units of study.
Research Planning & Archiving
Helping students organize an extensive research process is a challenging task and Google Sheets can provide students with a structured approach to organizing, categorizing, and tracking their research process.
By creating headings such as “Source,” “Original Text,” and “Summary,” students can effectively keep track of the sources they are discovering, as well as the most critical elements within those sources, bolstering their overall understanding of the concept.
Mystery Pixel Activities
Mystery Pixel activities are meant to be fun, interactive, projects that are self-checking for students in Google Sheets. Students plug in their answers inside of a Google Sheet to reveal a FUN picture.
Using conditional formatting, teachers can design fun and creative mystery pixels to support student learning!
Easy to assign in Google Classroom or Schoology!
To learn how to create mystery pixels, click the button below!
Student Portfolios
Rethinking the combination of Google Forms with Google Sheets can transform the use of these tools into a simple digital portfolio tool. The process relies on a recent update to Google Forms, which allows a form responder to upload a file as a response type within the form itself. The process, as outlined in the image above, consists of a student creating a Google Form as the entry tool to archive elements and artifacts for their digital portfolio. Because students can now upload files (image, document, audio, video, etc.), there is increased flexibility around the types of artifacts students can include within their portfolio.