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.
The lessons in this issue originated with a request. Teachers needed a way for students to access an application like ComicLife. Students in our district have one to one access to Chromebooks. ComicLife is not available for Chromebooks. They wanted an alternative.
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.
Integrating technology into the curriculum doesn’t have to be an elaborate process. In this issue I take the mBot and use it to teach basic science and math concepts. All we need is a few basic lines of code for the robot.
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.
The goal of 3D printers in the classroom should be to apply classroom concepts. In this issue we dive into the creation of a product. This product reinforces math skills in geometry. The finished product allows students to apply basic science concepts. These concepts include mass, velocity, and acceleration.
There are many similarities between Google Slides, PowerPoint, and Keynote. There are several advanced features in PowerPoint and Keynote that are not yet available in Google Slides. One feature that is available in Google Slides, which is also available in PowerPoint and Keynote, makes it a good application for creating interactive slides and stories. This feature allows us to create links to slides. We will use this feature to develop parts of our interactive story.
I will be taking a different spin on the tale of the "Three Little Pigs". The focus is not on the story but on the skills. What you learn here can be applied to other interactive presentations. Interactive slides can be used with research topics in content areas like science, math, history, and social studies.
Google Classroom is an assignment distribution and collection service. It was rolled out in August of 2014. Many school districts, including mine, were given a preview before it was released. The service is web-based so there is nothing to install. Any browser works with Google Classroom but I recommend using the Chrome browser.
Miro:bit is a device that originated with the BBC in the UK. This device is available to students in the UK for computer education. The goal is to provide an affordable way to teach students computer technology and programming.
In the July 15, 2018 issue of Digital Maestro Magazine, I cover the various options for sharing and collaborating on Google documents. This includes Docs for word processing. The word processor is quite capable of handling many of the common writing tasks. Some features are not as robust as those from Microsoft Word. Docs really shine when it comes to sharing and collaboration.
In the July 1, 2018 issue of Digital Maestro Magazine, I explore the use of Scratch for teaching basic geometry skills. The first lessons begin with the basics. We draw squares and rectangles. Within each project, we learn to use the power of coding to calculate the perimeter and area.
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.
The mBot from Makeblock is a robot ideal for learning STEAM concepts. STEAM refers to Science, Technology, Engineering, Arts, and Math. STEAM is an extension of STEM with the inclusion of Arts. I like to include Research to form STREAM. Research incorporates reading and writing. It also includes vocabulary and academic language.
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.
Tinkercad is a free online service with applications for designing 3D models and electronic circuits. The circuit simulator has basic electronic components for assembling a variety of circuits. The simulator provides a way for us to integrate lessons on electricity. Students assemble circuits in a structured environment. The simulator is easy to use and appropriate for students of all ages.
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.
Thinking maps are graphic organizers. They provide a common visual language for communication and collaboration. They are visual tools to inspire lifelong learning. Students become better thinkers, problem solvers, and decision makers. There are eight different types of thinking maps. Each map links to a specific cognitive process.