+
Lesson Plan
Curated OER

Are We Couch Potatoes or Busy Bees? Data Analysis of Physical Activity in School

For Teachers 4th - 9th
Students study practical data analysis within the constraints of the scientific method.  In this data lesson students collect and enter data into a computer spreadsheet then create graphs.
+
Lesson Plan
Curated OER

Statistics and Graphing with Accelerated Math

For Teachers 3rd - 7th
Students create charts and graphs, using a spreadsheet program, of their results from their accelerated math lessons. Students discover how graphs can be used to interpret data in our everyday lives as well as how several different...
+
Lesson Plan
Curated OER

Making a Spreadsheet

For Teachers 5th - 8th
Young scholars explore spreadsheet software.  In this personal finance and computer technology activity, students develop a vacation spreadsheet on the computer.  Young scholars represent hotel, food, transportation, and entertainment...
+
Lesson Plan
Curated OER

Graphing

For Teachers 5th - 12th
Young scholars gather statistical information on a chosen topic and place it into a spreadsheet. Using th Excel chart wizard, students create tables, graphs and charts of their information. They interpret the data and share it with the...
+
Lesson Plan
Curated OER

Metrically Me!

For Teachers 4th - 6th
Students define the parts of a database, search strategies to locate information electronically, create/modify databases, etc. and enter data into a prepared spreadsheet to perform calculations.
+
Lesson Plan
Curated OER

It's Your Life - Safe or Sorry/Safety Issues

For Teachers 6th - 8th
Students examine and chart data about safety hazards and unsafe situations. In this safety hazard lesson, students examine newspapers and web sites to investigate injuries from safety hazards. They make a spreadsheet using the data and...
+
Lesson Plan
Curated OER

Cross Cultural Transportation and Resources Exchange

For Teachers 10th - 11th
Students examine various modes of transportation. They explore regional transportation options and discover options available in their area. Students survey types of transportation people use in their area. Using spreadsheet data,...
+
Worksheet
Curated OER

Data Handling

For Students 7th - 9th
In this data handling worksheet, learners interpret data found in table, graphs and charts. They organize data and draw bar charts. This two-page worksheet contains 2 multi-step problems.
+
Lesson Plan
Curated OER

The Numbers Tell the Story

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

EXCEL It!

For Teachers 5th - 8th
Students surf the Web gathering information about graphs. The data collected is incorporated into an Excel spreadsheet and graphs of varying nature generated to further enhance student understanding.
+
Lesson Plan
Curated OER

Math Lesson: What Do You Want to Know? - Country Statistics

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

Earth Energy Budget Pre Lab

For Teachers 4th - 7th
Students explore energy by conducting an in class experiment. In this climate change lesson, students conduct a water vapor experiment in a soda bottle. Students utilize graphs and charts to analyze the results of the experiment and help...
+
Lesson Plan
Curated OER

Using Excel To Teach Probability And Graphing

For Teachers 3rd - 8th
Students engage in the use of technology to investigate the mathematical concepts of probability and graphing. They use the skills of predicting an outcome to come up with reasonable possibilities. Students also practice using a...
+
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

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

Comuter Technology-Applying Spreadsheet Information

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

Graphing Pockets

For Teachers 2nd
Second graders explore graphing. They count the number of pockets on their clothes and use Microsoft Excel to enter their data. Students create a class graph displaying their findings.
+
Lesson Plan
Curated OER

Pet Count Excel Graphing

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

A Fishy Tale

For Teachers 8th
Eighth graders do a research project on a particular species of Atlantic seafood and record and graph information pertaining to commercial landings of that species of seafood. They use a website and an Appleworks spreadsheet.
+
Lesson Plan
Curated OER

Virtual Field Trip

For Teachers 5th - 7th
Are we there yet?  Young trip planners learn about their state and plan a trip. They will select sites to see in three cities in their state, and record associated costs in a spreadsheet. While this was originally designed as a...
+
Lesson Plan
Curated OER

Graphing Favorite Holidays

For Teachers 1st - 3rd
Students create spreadsheets and bar graphs based on results of survey of favorite holidays.
+
Lesson Plan
Curated OER

Math: Football Fever Fun

For Teachers 5th - 8th
Students compile statistics from high school or other football team and construct a spreadsheet on which to record their findings. Using Chart Wizard to analyze the data, they construct charts and graphs for a visual display of the...
+
Lesson Plan
Curated OER

Twelve Days of Christmas

For Teachers 6th - 8th
Learners create charts and graphs using a spreadsheet. They chart the number of each gift given day by day from the song, "The Twelve Days of Christmas." They create a bar graph and a circle graph from their data on the spreadsheet.
+
Lesson Plan
Curated OER

Lemonade Business

For Teachers 12th
Twelfth graders use all features of Microsoft Excel and Microsoft Power Point to create charts and graphs. They use charts and graphs to make a Power Point Presentation.