Lesson Plan
Curated OER

What Can I Afford?

For Teachers 6th - 8th
Students explore the concept of cell phone plans. In this cell phone plan instructional activity, students research the cost of cell phones. Students compare various cell phone plans and decide on which phone plan is best for them.
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.
Activity
Teach Engineering

Applying Statistics to Nano-Circuit Dimensions in Fabrication

For Students 11th - 12th Standards
Do flexible circuits change dimensions during fabrication? Groups use GeoGebra software to measure the length of pictures of flexible nano-circuits. To determine if the circuits change dimensions, future engineers use Microsoft...
Lesson Plan
Curated OER

This is the Way We Go To School

For Teachers 2nd
Second graders create and utilize a graph using the Excel computer program. They gather data regarding how the students get to school, tally the numbers for the class, and create a bar graph on paper and using Excel.
Lesson Plan
Curated OER

Using SWMP Data

For Teachers 9th - 12th
Students are introduced to the SWMP system which tracks short-and long-term changes in water. Using this data, they plot and interpret the data on a graph to determine how human activities are lowering the water quality. They also...
Lesson Plan
Curated OER

Remembering Our Veterans Data Management Project

For Teachers 7th
Seventh graders utilize data collected from various sources based on Canadian military statistics to consolidate their understanding of data management. Students plan and create a PowerPoint presentation using this data including in...
Lesson Plan
Curated OER

It's In The Chocolate Chips

For Teachers 6th - 8th
Students investigate which brand of chocolate chip cookies contains the most chocolate. They analyze and compare data using Microsoft Word and Microsoft Excel. They communicate the results with Microsoft PowerPoint.
Lesson Plan
West Contra Costa Unified School District

Correlation and Line of Best Fit

For Teachers 8th - 10th Standards
Computers are useful for more than just surfing the Internet. Pupils first investigate scatter plots and estimate correlation coefficients. Next, they use Microsoft Excel to create scatter plots and determine correlation...
Lesson Plan
Curated OER

Graphing

For Teachers 5th - 12th
Students 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 class.
Lesson Plan
Curated OER

Basic Excel

For Teachers 1st - 4th
Students explore basic Excel spreadsheets.  In this spreadsheet lesson plan, students enter Alaska weather information and  perform calculations. Students title the columns on the spreadsheet and format the cells. ...
Lesson Plan
Curated OER

How do We Treat Our Environment?

For Teachers 7th
Seventh graders explore the concept of collecting data. In this data collection instructional activity, 7th graders survey others about their environmental habits. Students graph their data.
Lesson Plan
Curated OER

Using Imported Data in Excel

For Teachers 7th - 10th
Students import atmospheric data from the internet. In this earth science lesson, students graph the data they collected. They complete the worksheet after the activity.
Lesson Plan
Curated OER

Simple Bar Graphs Using Excel

For Teachers 6th - 8th
Students create original survey questions, and develop a bar graph of the data on paper. They input the survey data using two variables onto an Excel bar graph spreadsheet.
Lesson Plan
Curated OER

NCAA Basketball finals

For Teachers 6th - 8th
Young scholars read and interpret graphs of data sets. The data is used to devise reasons as to why teams in the NCAA Basketball finals from the 1950'sand up have the highest scores.
Lesson Plan
Curated OER

Survey Project

For Teachers 8th
Eighth graders create a website using FrontPage. They use inserted forms to collect survey information and use Microsoft Excel and MS Word to create a presentation of the survey and the results.
Lesson Plan
Curated OER

Bats and Hot Dogs

For Teachers 7th - 10th
Students identify patterns and relationships from data that is collected and solve variables.  In this investigative lesson students study ocean productivity, the nitrogen cycle and phytoplankton then answer questions.
Interactive
Curated OER

Among the Hidden - Population Math Activity

For Students 6th - 10th
In this population instructional activity, students collect data on population by researching the Census Bureau and then make online graphs and answer short answer questions about the data. Students complete 5 problems total.
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, 3rd graders use data about where Ellis Island immigrants came from to complete a bar graph on Microsoft Excel.
Lesson Plan
Curated OER

Using Excel to Draw a Best Fit Line

For Teachers 6th - 8th
Middle schoolers create line graphs for given data in Microsoft Excel. Students follow step by step instructions on how to create their graph, including how to create a trend line. Middle schoolers print graphs without trend lines and...
Lesson Plan
Curated OER

Is Portland, Oregon Experiencing Global Warming?

For Teachers 6th - 9th
Students use data to determine if the climate in Portland has changed over the years.  In this weather instructional activity students complete line graphs and study long wave radiation. 
Lesson Plan
Curated OER

Think GREEN - Utilizing Renewable Solar Energy

For Teachers 7th - 12th
Young scholars use data to find the best renewable energy potential.  For this solar energy lesson students import data into Excel and explain how solar energy is beneficial. 
Lesson Plan
Curated OER

Investigating Seasonal Variability in NO2 Concentrations

For Teachers 8th - 10th
Students study different formats of data and determine the nitrogen dioxide concentrations.  In this seasons lesson students understand the different relationships that NO2 can have.
Lesson Plan
Curated OER

Speed + Graphing = Winners!

For Teachers 5th
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,...
Worksheet
Curated OER

Endangered Species

For Students 9th - 12th
In this geography worksheet, high schoolers identify how to manipulate data on a range of endangered species. They create a bar graph of endangered animals from Africa, Asia, Australia, North America, or South America. Students use a...