TCEA

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 Forms Validation

This is the first issue in a five-part series. The series covers various tools I use to gather information for a conference held by my district. The tools have changed over time. The tools I use now revolve around the Google environment. I use Google Forms to collect presenter, participant, and vendor information. I use Google Sheets to organize the conference schedule. I use Sheets to create and printing conference badges. Sheets is also used to develop the online conference schedule.

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.