Fundraiser thermometer graphic with Google Sheets. We are using Google Sheets to create our fundraiser thermometer. The sheet will display daily updated totals on the web. The thermometer will be dynamic with changing colors and updated information.
Create histograms with Google Sheets. Histograms are used in statistics. They are used to show the frequency of a set of continuous data. Numerical data can be discrete or continuous. Discrete data is counted. Continuous data is measured. Examples of discrete data include the number of students in a class or the number of faces on a die. Continuous data can take any value. Examples of continuous data include a person’s height or weight.
This is part of a four-part series on publishing Google Charts. Published charts are live. Any changes made to the working chart are reflected in the published chart. Updates are not automatic for all forms of published charts. Updates have to be manually pushed to the published version.
In this lesson, we are creating an assignment generator for time measurement. The assignment generator will generate assignments for students to calculate the number of minutes in a given number of seconds. It will also create assignments for students to calculate the number of hours given minutes and seconds.
This lesson covers the process for creating a Least Common Multiple(LCM) and Greatest Common Factor (GCF) assignment generator. The generator is created with Google Sheets. The content is sent to a Google Doc and distributed to students.
In this lesson, we are creating a crossword puzzle assignment in Google Sheets. We will use scripts to help us fill in the vocabulary in a crossword-style format. We will use some conditional formatting to help students know where the words go in the crossword puzzle. We will use Notes to provide reference information and clues for the words.
In this lesson, we are creating an assignment generator for elementary age students. The generator uses emoji graphics to create a table of objects. Students use that table to create bar charts. Use the assignment generator to familiarize students with data and bar charts.
In this lesson, we are creating a fraction assignment generator. This generator creates an assignment generator for reducing fractions. This assignment generator is an extension of the least common multiple and greatest common factor generator.
In this lesson, we are creating a math assignment generator. We are using Google Sheets to generate math problems. The math problems include basics like addition, subtraction, division, and multiplication. The problems are copied to a Google Doc and formatted for distribution to students.
This lesson demonstrates how to use Google Sheets to create a normal distribution, Bell curve, chart. We use data from NOAA. We create a normal distribution chart for all the recorded earthquakes. Along the way we learn to use several statistical functions.
In this lesson, we are going to create a chart that plots the data for two time periods. These periods range from 1998 to 2008 and 2009 to 2019. The chart is useful when making comparisons. We will be able to see twenty years of data and compare decades of earthquakes.
A lesson I created a while ago on bar charts has gained lots of interest. I thought it would be a good idea to create a lesson for line charts. I like to bundle concepts in my lessons. So we are going to query and organize data before creating the line chart. The creation of line charts is easy. Gathering and organizing data is hard. The data for this lesson is from the National Oceanographic and Atmospheric Administration, NOAA. NOAA has interactive data for earthquakes, volcanoes, and weather. I have a link below to the site.
Bar graphs are used to compare groups of information. Bar graphs compare groups of data at one point in time or across time. In this lesson, we will create a basic bar chart using Google Sheets.
Bar graphs are great when working with multiple groups of data. They are helpful when looking for patterns. Groups of data provide opportunities to look at data from different perspectives.