About a month ago I published a post about using If Functions in Google Sheets to facilitate student learning adventures. Since then, I’ve been playing around with combining if functions and a HyperDoc learning cycle. I thought about the way the workspace within a sheet was laid out (cells made up of rows and columns) and decided multiplication would work best. During the creation process, several more unique features naturally fit the task I had in mind.
Data Validation – This handy feature allows you to create a dropdown list inside of a cell. Students have to answer multiple choice questions in the Evaluate tab.
Sharing a Spreadsheet with another student allows for collaboration and peer feedback. Students answer a word problem created by their peers on the Share tab.
Fill tool to change the color of the cell is perfect for creating arrays or skip counting on a number line. Color coding direction and answer boxes allowed for some consistency. Blue boxes contain directions while white boxes identify where the students type in their answers.
Assigning a script to an image is the feature I used on the Apply tab. When students click on the dice, a random number is generated to replicate the roll.
The lesson may not be intuitive to you or your students so I created a walkthrough video. Click here to make a copy of the If Function HyperDoc. Let me know how it goes in the comments section.