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.

Microsoft Teams in the Classroom

Microsoft Teams is part of Office 365 for business. The business application provides services specific to educational institutions. Teams combine a variety of services to help collaboration and communication. The main page in Teams highlights conversations. We will focus most of our attention in this article on the Conversations portal.

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.