![]() This formula will take the students’ selection, vertically locate the task from a list you’ve created, and automatically pull it up for students. ![]() Use the VLOOKUP formula to pull in questions based on what students want to work on. Google Sheets’ vLookupĭo you have a list of task cards that you’d like students to complete AND have their answers checked? =hyperlink(“web URL address”, “title of the link”) 5. Link to anchor chart images, online exploration exercises, or Slides with questions like the example above. The Hyperlink formula will accomplish just that! Combine the Hyperlink formula with the IF formula to provide students with reteach pieces or interventions. What if I want students to explore a website, watch a video, or reference a digital classroom material within an activity? Learn and practice with her Google Sheets template on her blog post. This Geometry example, created by Mandi Tolen, utilizes the same IF formula and conditional formatting to automatically have a hidden picture appear if students answer questions correctly. Learn how to get started with conditional formatting. If it wasn’t, students needed to work through their problems again, encouraging error analysis conversations and academic collaboration. In the Algebra 2 example below, students solved three problems within a skill set and Google Sheets automatically checked if their total was correct. ![]() Checkboxes can turn green once selected by using “TEXT EQUALS TRUE” under the Conditional Formatting menu. Insert checkboxes as a way for students to monitor their progress through a blended learning unit.Check student solutions to a mathematics or science problem.Highlight student responses on a discussion board that contains a certain word or phrase.This can apply to both text and numbers, depending on your need. Google Sheets provides you with ways to automatically color code responses to provide that “instant check” of student work. What if I’d like students’ responses to be automatically color-coded?Ĭonditional Formatting makes this process efficient and an absolute time saver. ![]() Struggling to take your Google Sheets beyond data collection and surveys? Do you think spreadsheets are only helpful when investigating trends within your classroom? While Google Sheets can provide you with ways of analyzing your data to impact your instruction, let’s explore five tricks that can take you far beyond those capabilities.
0 Comments
Leave a Reply. |