+
Lesson Plan
Curated OER

Pets Galore!

For Teachers 4th
Fourth graders conduct a class survey on the number of pets that the 4th grade owns and they record that data in their math notebooks. They make a bar graph displaying the results using a spreadsheet through Microsoft Excel.
+
Lesson Plan
Curated OER

Graph It

For Teachers 1st - 2nd
Students create a spreadsheet and graph using Open House attendance data.
+
Lesson Plan
Curated OER

Do You Measure Up?

For Teachers 4th - 5th
Students measure their height and then they will input the information into a spreadsheet. After the data is entered, students will use the material gathered to create a bar graph showing the heights of people in their class.
+
Lesson Plan
Curated OER

The Numbers Tell the Story

For Teachers 3rd - 9th
Students demonstrate how to gather and interpret statistical data. For 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...
+
Lesson Plan
Curated OER

Reading Graphs

For Teachers 6th - 9th
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.
+
Lesson Plan
Curated OER

Graphing Data on Ellis Island

For Teachers 3rd
Third graders use data to make a bar graph. In this graphing and social studies lesson plan, 3rd graders use data about where Ellis Island immigrants came from to complete a bar graph on Microsoft Excel.
+
Lesson Plan
Curated OER

Excel temperature Graphs

For Teachers 4th - 6th
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.
+
Lesson Plan
Curated OER

Using Fractions to Represent M&M Colors

For Teachers 9th - 11th
Students investigate the concept of fraction and tangible application. In this algebra lesson, students use fractions to solve real life scenarios. They convert between fractions and decimals and identify the numerator and denominator.
+
Activity
Teach Engineering

Air Pollution in the Pacific Northwest

For Teachers 6th - 8th Standards
Scholars investigate levels of nitrogen dioxide in the Pacific Northwest by examining the role of nitrogen in air pollution and how remote sensing can be used to measure nitrogen levels. An Excel spreadsheet calculates the difference...
+
Worksheet
K12 Reader

Displaying Data

For Students 2nd - 3rd Standards
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...
+
Lesson Plan
Curated OER

Spreadsheet Graphs

For Teachers Higher Ed
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...
+
Lesson Plan
Curated OER

Line Graphs

For Teachers 7th
Seventh graders create a line graph and identify when to use line graphs. In this line graphs lesson, 7th graders analyze the average temperatures of various cities. Students graph the data they collected.
+
Lesson Plan
Curated OER

Name Count and Graph

For Teachers 6th - 8th
Learners find the frequency of a name in selected states by using the Internet. They input data into a spread sheet. They create a graph that illustrates the gathered information.
+
Lesson Plan
Curated OER

Back-To-School Shopping

For Teachers 5th
Fifth graders estimate the prices of items to be bought for back to school. They use catalogs and/or advertisements to research the cost of each of the items. They use problem solving strategies and a spreadsheet template to determine...
+
Lesson Plan
Curated OER

Finding Caterpillars

For Teachers 4th - 6th
Students examine how animals protect themselves from predators and camouflage themselves. They participate in a simulation in which they locate red and green yarn "caterpillars," organize their data, and generate a bar graph using...
+
Lesson Plan
Curated OER

Food for Thought

For Teachers 3rd
Third graders conduct a survey of their class' favorite foods voting on 3-4 favorites overall. They then go to the computer lab and examine how to produce a horizontal bar graph by graphing the favorite foods of the class.
+
Lesson Plan
PHET

Soda Bottle Magnetometer

For Teachers 6th - 8th Standards
Introduce learners to set of complete instructions that describe how to build a magnetometer that works just like the ones professional photographers use to predict auroras. The diagrams are wonderfully descriptive, and the written...
+
Workbook
Math Mammoth

Grade 1 Worktext

For Students K - 2nd Standards
Use graphing, counting, and number lines to help first graders learn about addition and subtraction. An array of worksheets and activities are an excellent resource for your math lesson, whether you are focusing on counting skills or...
+
Worksheet
Curated OER

Data Handling

For Students 6th
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...
+
Lesson Plan
Curated OER

Our Favorite Season Lesson Plan

For Teachers 5th
Fifth graders complete a survey about their favorite season of the year. Using Excel, they create a graph using the chart wizard and copy it into Microsoft Word. They explore the relationship between the survey and the bar graph.
+
Lesson Plan
Curated OER

Rouge River Data

For Teachers 3rd - 5th
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.
+
Lesson Plan
Curated OER

Enhancing Writing Through Technology

For Teachers 1st - 3rd
Students participate in a class survey of their favorite activity to do in the snow and organize the results in a graph. They write a paragraph about the graph using language from a class-developed word web and include both an opening...
+
Lesson Plan
Curated OER

What Goes Up Must Come Down!!

For Teachers 5th
Fifth graders look at actual sunrise and sunset times for their hometown to determine a pattern in the amount of daylight. They collect their data in Excel and create a chart to help them identify the pattern, then write an explanation...
+
Lesson Plan
Curated OER

Predicting Temperature: An Internet/Excel Learning Experience

For Teachers 3rd
Third graders use the Internet (www.weather.com) to find the high temperature for our locale and the high temperature for another city around the world. They keep track of the temperature in these two locations for 10 days.