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 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.
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.
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 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.
A Google classroom must be created every year and assignments must be re-created every year. As teachers, we don’t teach the same way each year but the materials and resources remain fairly consistent. It would be nice if we could refer to these resources without the need to re-create the classroom and assignments.
OneNote Class Notebook is a service from Microsoft Office 365. It helps teachers create and distribute digital notebooks to students using OneNote. Through OneNote, we can distribute and collect assignments using a familiar notebook format. The app is available for a variety of devices.