A Spreadsheet Can Do That?

Think a spreadsheet can only be used to analyze data and create charts and graphs? Think again. Explore different ways a spreadsheet can be used for digital discussions, critical thinking adventures, and other ideas you never knew you needed! Below are some of my favorite Google Sheets activities that use the apps unique features in ways that make learning engaging and fun.

Teacher Tools Using Google Add-Ons

Google add-ons let you do more with your Google Docs and Sheets by adding new, useful features such as creating a tab for each student in your class or creating a spreadsheet for collaborative discussions with each topic on its own tab. Most add-ons are created by third-party developers and published to the add-on store.

Conditional Formatting

Cells, rows, or columns can be formatted to change text or background color if they meet certain conditions. For example, if they contain a certain word or a number. Click here for a full video tutorial.

Data Validation

Google Sheets supports a built-in mechanism called data validation rules. Data validation rules allow you to constrain the values that can be entered into a worksheet cell. You can create a dropdown list inside of any cell. Click here for a full video tutorial.

If Functions

A Google Sheets IF function allows you to use decision making in a worksheet. The If function tests to see if a certain condition in a cell is true or false. You then use cell referencing to pull data from one sheet to the next. Read more about them here and here.

Interactive Educational Games

Easily turn a Google Spreadsheet into fun activities such as flash cards, quiz shows, bingo, word search games and so much more. Click here for a full video tutorial.

Charts and Graphs

When creating a spreadsheet, you frequently find yourself wanting to analyze your data. you can even display your data in the form of a chart or graph.

Sheets Tips and How-Tos

Login to Launchpad to view the following Hoonuit Tutorials, (NEISD Teachers Only)

Leave a Reply

Your email address will not be published.