This issue takes a look at using VLOOKUP in Google Sheets. I use this function in Google Sheets often. Few teachers have heard of it or its purpose. I use this function often when developing flexible solutions and searches. I use a real-world example in the lesson.
Google Sheets and pivot tables are a good way to help students make sense of data. We will learn how to use use a pivot table to organize the information in the data sheet. This pivot table will help answer some questions we have about volcanoes. Use the questions in this article as part of your lesson. Start by asking students these questions before looking at the data. This starts the questioning and thinking process in their minds.
In the June 15 issue of Digital Maestro Magazine, I take a look at using Google Sheets as a graphing calculator. In the issue, I explore the use of Sheets to plot linear equations. I also take a look at plotting Sine and Cosine functions. The examples include instructions for creating templates which teachers can use during classroom presentation or instruction.