Lesson Plan
Curated OER

Country Comparisons in Current Events Class

For Teachers 6th - Higher Ed
Students collect political, socioeconomic, geographical, and other data about 10 countries and record their data in a spreadsheet. The information is used to fuel current events discussions.
Lesson Plan
Curated OER

Credit Cards: The Good, the Bad, and the ugly

For Teachers 10th - 12th
Students study how dangerous credit cards can be. They see why it is important to pay off credit card bills as soon as they can. They use MS Excel to display and understand the data. They fill out questions using the data from their...
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

Graph Lesson

For Teachers 1st
First graders collect data on different eye colors of each student in their classroom. They input the data that they gathered in an Excel spreadsheet and then create a graph in Excel.
Lesson Plan
Curated OER

Houses and Cars and Loans

For Teachers 8th - 10th
Students create a spreadsheet to track their spending. In this algebra lesson, students use loan formulas to calculate the payback amount plus interest on a loan. They calculate how much money they would need to buy a car and house.
Lesson Plan
Curated OER

Party Math

For Teachers 10th - 12th
Students create a spreadsheet that they will use to plan a small party or outing. They calculate expenses and stay within a budget amount for their party.
Lesson Plan
Curated OER

How Much Does That Car Cost?

For Teachers 8th - 12th
Students calculate how much it costs to buy a used car and finance it through a bank. They select a car from the newspaper, conduct Internet research on current auto loan interest information for four different states, and create a...
Lesson Plan
Curated OER

The Write Stuff

For Teachers 4th
Fourth graders share a previously written portfolio piece and the class guesses the genre. Students use tally marks to keep track of how many of each piece there are in class. Once the data collection is complete, 4th graders create a...
Lesson Plan
Curated OER

Graph Frenzy!!

For Teachers 6th - 7th
Students brainstorm for a survey question to ask classmates. They survey their classmates. They enter the results into a spreadsheet and create the best graph for the information. They share their graphs with the class.
Lesson Plan
Curated OER

Graphing My Path to Success

For Teachers 7th
Seventh graders examine their school performance through self-assessment of strengths and weaknesses. They construct a line graph, plotting all courses and achievements. Students use graph paper and colored pencils for each activity. If...
Lesson Plan
Statistics Education Web

Are Female Hurricanes Deadlier than Male Hurricanes?

For Teachers 9th - 12th Standards
The battle of the sexes? Scholars first examine data on hurricane-related deaths and create graphical displays. They then use the data and displays to consider whether hurricanes with female names result in more deaths than hurricanes...
Lesson Plan
Curated OER

Lesson Plan Outline for Rainbow Science

For Students 7th - 12th Standards
Young scientists study light reflection and refraction as they determine the critical angle, the rainbow angle, and color separation in rainbows. Teams record the data they collect in a shared spreadsheet and discuss results with the class.
Lesson Plan
1
1
Bonneville

Making Observations and Recording Data for Solar Powered Water Pumping

For Teachers 2nd - 5th Standards
Get pumped about an activity with water pumps. The fifth of seven installments in the Understanding Science and Engineering unit has pupils learn how to make observations, record data, and create data displays. Each group measures the...
Lesson Plan
Curated OER

ACC Basketball Statistics

For Teachers 6th - 8th
Students use math skills and create a spreadsheet. In this statistics and computer skills lesson, students gather ACC basketball statistics, convert fractions to decimals and then percents. Students use the gathered information to create...
Lesson Plan
Curated OER

T-Shirt Lettering

For Teachers 3rd - 8th
Students determine the cost of a t-shirt using a variety of mathematical operations to solve problems. Then they use a spreadsheet to calculate the cost of lettering a t-shirt and display this information in a graph.
Lesson Plan
Curated OER

Money Math: Lessons for Life

For Teachers 11th - Higher Ed
Students develop a budget for a college student using all of the influences that the student would have.  In this budgeting lesson plan, students use real life examples to create a budget spreadsheet.  Students read and study...
Lesson Plan
Curated OER

Triangle Midsegment

For Teachers 9th - 12th Standards
Learn how to calculate the length and midsegments of triangles. Students differentiate between similar and congruent triangles. They create a spreadsheet with their findings.
Lesson Plan
Curated OER

4 Month Budget Spreadsheet

For Teachers 8th
Eighth graders create and maintain a spreadsheet budget based on a predetermined salary. They have an opportunity to make "investments and purchases." Budget records be kept for an imaginary 4 month period.
Lesson Plan
Curated OER

PowerPoint Project for Creating a New Business

For Teachers 9th - 12th
Students create a mock new business for which they design a PowerPoint presentation. They include company information, financial statements, graphs, advertising and management promotion pages in the final presentation.
Lesson Plan
Curated OER

Creating a Newscast on the Cold War

For Teachers 5th - 7th
Learners research the events of a specific year of the Cold War. In this Cold War lesson, students investigate the causes of the Cold War and highlight the events of a particular year.  Learners create a...
Lesson Plan
Curated OER

Creating a Bar Graph Using a Spreadsheet: Dice Rolling Probabilities

For Teachers 10th
Tenth graders explore the concept of spreadsheets. They create a simple spreadsheet and chart from given data. Students perform basic formatting procedures on their chart. They use spreadsheet functions to perform calculations.
Lesson Plan
Curated OER

Technology Integration Lesson Plan: Civil War Spreadsheet

For Teachers 8th
Eighth graders discuss and analyze Civil War data, manually graph data on handout, work with partners to enter data into spreadsheets, and create charts on spreadsheet for each data set.
Lesson Plan
Curated OER

Creating a Nutrition Table in MicroSoftExcel

For Teachers 6th - 8th
Middle schoolers access the internet to find Nutritional information from a restaurant of their choice and compile their information into an excel spreadsheet.
Lesson Plan
Curated OER

Volcano Spreadsheet and Graph

For Teachers 4th
Fourth graders find the height of selected volcanoes and convert their measurements to feet. Students interpret information from a graph. They also write math questions that require the use of a class created graph. Students use a...

Other popular searches