Google Sheets

Bar Charts with Google Sheets

Bar Graphs represent data visually as a series of bars. They are often presented to students in formative assessments. Teachers rarely take the time to create graphs from data for assessments or lessons. I didn’t use them at first either. Creating graphs is time consuming. I needed to do something because my students often missed easy problems when it came to questions from a graph or table. I was often surprised because we covered them during practice for the larger state assessments. It wasn’t until they started to develop their own that they began to make the crucial connections.

Google Sheets Response Cleaning

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.

Google Sheet Pivot Table

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.

Google Sheets to Graph Linear Equations

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.