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.
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,...
Lesson Plan
Discovery Education

Sonar & Echolocation

For Teachers 9th - 12th Standards
A well-designed, comprehensive, and attractive slide show supports direct instruction on how sonar and echolocation work. Contained within the slides are links to interactive websites and instructions for using apps on a mobile device to...
Lesson Plan
Curated OER

Fish and Clips

For Teachers 1st - 2nd
Youngsters test magnetic strength by measuring the mass of paper clips that they "hook" with a magnet. Your first and second graders should love the hands-on activities associated with this plan. The reproducible materials are quite good...
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

Student Costs Graph

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

Tracking Your Favorite Web Sites

For Teachers 9th
Ninth graders track the hit count on their favorite web sites.  In this Algebra I activity, 9th graders record the number of hits on their favorite web site for twenty days.  Students explore the data to determine if the...
Lesson Plan
Curated OER

Graphically Speaking

For Teachers 4th - 6th
Students discover the links between population and Congressional representation. In this government lesson, students research population statistics and create spreadsheets that compare population to the number of Congress members per state.
Lesson Plan
Curated OER

Alzheimer's Disease

For Teachers 9th - 12th
Investigate Alzheimer's disease. Conduct research using a variety of resources, obtain information, and input the data into a Microsoft Excel spreadsheet. Identify trends in the data and categorize them for an audience.
Lesson Plan
Curated OER

Blast the Fats

For Teachers 3rd - 4th
Young scholars examine the fats found in foods. In this nutrition activity, students identify the types and amounts of fats found in foods as they research food labels and the Internet. Young scholars classify the fats and record their...