Curated OER
Pet Count Excel Graphing
Students used collected data to distinguish what pets they have or would like to have. They correlate findings with appropriate technology--Excel. At the end of the lesson they tabulate a bar chart and present their findings to the class.
Curated OER
Which Amusement Park Would You Choose?
Students analyze data related to amusement parks and create a spreadsheet to display the data. They read the data and predict which amusement park they think is safer, create a spreadsheet and graph, and write a proposal based on their...
Alabama Learning Exchange
The State Capital of Stem and Leaf
Students explore the concept of stem and leaf plots. In this stem and leaf plots lesson, students plot the 50 US states' capitals on a stem and leaf plot according to the first letter of each state. Students compare their stem and leaf...
Curated OER
Reading Graphs
Students read graphs and charts to interpret results. In this algebra lesson, students interpret bar, line and pictographs. They draw conclusions and make predicitons based on these charts.
Curated OER
BUS: Farming: It's A Fact (Ag)
Students create two different types of graphs from the information in the "Farm Facts" booklet (i.e., bar graph, pie chart, etc.). They calculate where your food dollars are spent (on and off farm).
Curated OER
Speed + Graphing = Winners!
Fifth graders take addition timed tests every day for a two week period. Using the data from the timed tests, they create a bar graph using Microsoft Excel computer software, a personal bar graph using graph paper and colored pencils,...
Curated OER
Excel temperature Graphs
Learners 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. Learners will find the average weather and add a trend line to their graph.
Curated OER
The Numbers Tell the Story
Students demonstrate how to gather and interpret statistical data. In this data analysis lesson, students search for statistics on the health effects of smoking and place the information into charts. Students create these charts online...
K12 Reader
Displaying Data
It's important to learn how to display data to make the information easier for people to understand. A reading activity prompts kids to use context clues to answer five comprehension questions after reading several paragraphs about...
Curated OER
Meet The Graphs
Students identify two types of graphs. They analyze and interpret authentic data shown in bar and pie graphs and complete a graph given specific data. Perform simple functions within an Excel document:
Curated OER
Spreadsheet Graphs
Students create graphs using information from spreadsheets. They select a topic from the following choices: website use, digital cameras, spreadsheets, calculators or educational software. They tally the class results and create an...
Curated OER
Data Handling
In this data handling worksheet, 6th graders solve and complete 4 various types of problems. First, they draw a bar chart to represent the information provided in the table shown. Then, students show beneath the table how to work out the...
Curated OER
I Can Build It.....Yes I Can!
Kindergartners listen to a story read by their teacher, then use magnetic shape pieces to construct simple designes. They "build" their own house using pre-cut paper shapes. This age-appropriate lesson would be an excellent choice for...
Curated OER
Area graphics for 7th graders
Students randomly select dimensions for three geometric shapes (square, right triangle and circle). From the graphs they compare and contrast the graphical results of each shape.
Curated OER
Rouge River Data
Students participate in using Excel sofware in order to create graphs. They create the graphs using data that they gathered during the Rouge River Field Trip they attended. The produce bar graphs from the excel spreadsheets.
Curated OER
Delicious Graphing
Fourth graders sort trail mix by type and use that information to create different types of graphs for comparing.
Curated OER
Toy Dissection Graph
Students explore simple machines and how they are made. They examine the parts of the simple machine and collect information about its parts. Using Excel, students create circle and bar graphs from the collected data.
Curated OER
Circling Around the CEENBoT Way!
Students investigate the forces present in a rotating body. In this physics lesson, students calculate centripetal force using a mathematical equation. They answer a quiz and writing prompt at the end of the lesson.
Curated OER
Electric Field Mapping / Equipotential Lines
Students determine the equipotential lines surrounding a charged object. In this physics activity, students draw lines to identify areas. They relate the spacing of the field lines to the strength of the charge.
Curated OER
Family Vacation
Young scholars use math to plan a trip by houseboat down the Mississippi River. They research and obtain information on the Mississippi River and its surroundings and use multiple graphs to represent their data.
Curated OER
Analyzing Health
Third graders analyze their health. In this analysis lesson plan, 3rd graders rate their health on a 1-10 scale. They then tally the scores from the class and create a data chart. Then they answer true and false questions based on...
Curated OER
Comuter Technology-Applying Spreadsheet Information
Students create spreadsheets and practice sorting within the spreadsheet with three different activities. Students manipulate different materials such as addresses, real estate sales, and athletic participation numbers.
Curated OER
The Great Chile Challenge
Fifth graders gather data, create a graph, and interpret information. They build vocabulary by negotiating the ideas that go into the graphs which they create. They use Excel to print a variety of graphs based on how much they like Chile...