Curated OER
Student Costs Data Table
Students compare and contrast two routes selected for a virtual field trip. They create a data table of educational activities, lodging, and meal costs using Microsoft Excel software.
Curated OER
Generate Measurement Data Word Problems
Bar and line graphs are an excellent way to visually analyze data: give your scholars practice both analyzing graphs and creating their own! First, they examine five basic bar graphs, indicating the number of squares on specific days....
Curated OER
Graphing Pendulum Results
Sixth graders set up a pendulum experiment deciding which variable to manipulate (length of string or weight on the string). They create a hypothesis, collect necessary equipment, and write out each step of their experiment. They then...
Code.org
Making Data Visualizations
Relax ... now visualize the data. Introduce pupils to creating charts from a single data set. Using chart tools included in spreadsheet programs class members create data visualizations that display data. The activity encourages...
Curated OER
Hopes and Dreams: A Spreadsheet Lesson Using Excel
Fourth graders read "The Far Away Drawer" by Harriet Diller and discuss the story as a class. After discussion, 4th graders create a t-shirt GLYPH about their hopes and dreams,share their information with the class and create spreadsheets.
Curated OER
Creating Circle Graphs with Microsoft Excel
Seventh graders will learn how to construct circle graphs using paper and pencil. Then they will learn how to construct circle graphs using Microsoft Excel. This lesson uses technology and shows learners how to cross skills into the...
Curated OER
Graphing on the Computer
Students create a bar graph on the computer using given information from the teacher. They create a bar graph using their own information chart (they need to create one on separate paper first). They utilize Microsoft Excel for this...
Curated OER
Excel Lesson Plan Coin Statistics
Second graders determine the difference between making a prediction and determining actual information. They design a spreadsheet for a coin flipping activity on which they include their predictions and what actual happens when they flip...
Curated OER
Balloon Graphing
Fourth graders explore data, charts and graphs. They create graphs using titles, labels, axes, intervals, and scale correctly. Students enter their data into Excel and create a graph.
Curated OER
Graphing Your Favorite Pizza Topping
Fifth graders can survey the students just in their classroom, the grade level, or other grade levels. Upon finishing the surveys and compiling the data, the students can input their results in an Excel template or create their own...
Curated OER
Student Costs Graph
Young scholars calculate the mileage, gasoline costs, and travel time and costs for a vacation. They conduct a virtual field trip, and create a comparison graph of costs using Microsoft Excel software.
Curated OER
Reading Graphs
Learners read graphs and charts to interpret results. In this algebra activity, students interpret bar, line and pictographs. They draw conclusions and make predicitons based on these charts.
Curated OER
Data Handling
In this data handling worksheet, students interpret data found in table, graphs and charts. They organize data and draw bar charts. This two-page worksheet contains 2 multi-step problems.
Curated OER
Fairy Tales
Sixth graders explore the elements of fairy tales. For this fairy tales lesson, 6th graders analyze several versions of Cinderella from around the world. Students graph fairy tale elements using Excel and create Venn diagrams comparing...
Curated OER
Math Lesson: What Do You Want to Know? - Country Statistics
Students are able to identify the characteristics of a variety of graphs (i.e. bar graph, line graph, pie graph, scatter plot, population pyramids, etc.) They recognize how the type of data to be presented plays a role in choosing the...
Curated OER
The Numbers Tell the Story
Students demonstrate how to gather and interpret statistical data. In this data analysis lesson plan, students search for statistics on the health effects of smoking and place the information into charts. Students create these charts...
Curated OER
Earth Energy Budget Pre Lab
Learners explore energy by conducting an in class experiment. In this climate change lesson, students conduct a water vapor experiment in a soda bottle. Learners utilize graphs and charts to analyze the results of the experiment and help...
Curated OER
Organizing Data
In this organizing data worksheet, 7th graders solve seven different types of problems related to data. They first identify the type of data as categorical, discrete or continuous from the information given. Then, students use Excel to...
Curated OER
What's My Pattern?
Students recognize, describe and extend patterns in three activities. They organize data, find patterns and describe the rule for the pattern as well as use the graphing calculator to graph the data to make and test predictions. In the...
Curated OER
Excel temperature Graphs
Students gather data about the weather in Nome, Alaska. In this Nome Temperature lesson, students create an excel graph to explore the weather trends in Nome. Students will find the average weather and add a trend line to their graph.
Curated OER
Skittle it Up
Students make a graph. In this graphing and Excel lesson, students work in groups and are given a bag of skittles. Students count the number of each color skittle and create a table in Excel. Students learn how to make a pie graph using...
Curated OER
Graphing
Fifth graders create graphs based on climate in South Carolina. They read and interpret information in a chart and construct a graphy from the information in the chart. They create a spreadsheet using Excel and publish 2 graphs.
Curated OER
Graphing Data on Ellis Island
Third graders use data to make a bar graph. In this graphing and social studies lesson, 3rd graders use data about where Ellis Island immigrants came from to complete a bar graph on Microsoft Excel.
Curated OER
Creating Bar Graphs and Pie Graphs
Second graders observe a demonstration of the creation of a bar graph and a pie graph of their favorite colors. They gather information about various topics from their classmates, then organize the information, creating a bar and a pie...