This issue continues using Google to develop resources for our conference. In this issue, we develop a template for printing name badges. The name badges include participant names and contact information. The contact information is embedded in a Quick Response code. The badge also includes the conference logo designed in Google Drawings.
In this issue, we develop a schedule in Google Sheets. The schedule uses the data validation option to provide a selector. This selector is used to place presentations in the schedule throughout the day. It isn't used to validate the information in the schedule. We use it to develop the schedule.
In this issue, we will look at the collected information. We took steps to validate the information on the form. The validation didn’t include spell checking or formatting. Some of the formatting issues we encounter include capitalization, unwanted spaces, and misspellings. This information needs to be reviewed before it appears in the presentation schedule. This corrected information is sent to the presenters for verification.
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.