+
Lesson Plan
Curated OER

Weather

For Teachers 5th - 7th
Students create a spreadsheet and chart using data collected.  In this weather lesson, students select five cities from their state, including the city they live in.  Students take daily temperature readings from all five cities. ...
+
Lesson Plan
Curated OER

Carbon Dating

For Teachers 9th - 12th Standards
Simulate C-14 decay using M&M and Reese's Pieces candies. In this scatter-plot activity, students perform an experiment to simulate the half life of C-14. Information is plotted on a scatter-plot. Students answer four comprehension...
+
Lesson Plan
Curated OER

Home Sales Records

For Teachers 9th - 12th Standards
Teach your class how to calculate monthly payments on a home mortgage. For this percent lesson, students calculate the monthly payment on a home mortgage, and compare different lengths of time and the interest rates for national median...
+
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 sample...
+
Worksheet
Curated OER

Endangered Species

For Students 9th - 12th
For this geography worksheet, students 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...
+
Lesson Plan
Curated OER

Which Amusement Park Would You Choose?

For Teachers 5th - 10th
Students analyze data related to amusement parks and create a spreadsheet to display the data. They read the data and predict which amusement park they think is safer, create a spreadsheet and graph, and write a proposal based on their...
+
Lesson Plan
Curated OER

Sales Spreadsheet

For Teachers 6th - 8th
Students use Excel spreadsheets to organize purchases, discounts, sales prices, and sales tax. Students follow step by step instructions and enter formulas as well as use the auto sum feature to calculate required calculations.
+
Lesson Plan
Curated OER

Using Excel, the Internet, And Word To Create a Spreadsheet, Chart, And Instructions

For Teachers 7th - 12th
Young scholars improve data entry in a spreadsheet.
+
Lesson Plan
Curated OER

State Economy Chart

For Teachers 5th
Fifth graders research and record statistics on the economy of an assigned state. They create a spreadsheet in Excel to report the data and a 3D Pie graph using the Chart Wizard in Excel to represent their states' data.
+
Lesson Plan
Curated OER

Graphing Favorite Fruit

For Teachers 3rd
Third graders take poll and sort data, enter the data to create a spreadsheet and create bar and pie graphs.
+
Lesson Plan
Curated OER

Microsoft Office Excel

For Teachers 6th - 8th
Pupils use Microsoft Office Excel. In this technology activity, students enter data on a spreadsheet using Excel. This programs tallies data and presents it using graphs. 
+
Lesson Plan
Curated OER

Lesson 5: Designing an Experiment

For Teachers 4th - 6th
The intent of this lesson is to introduce young scientists to the steps of the scientific method. To this end, they consider the question, "Which brand of battery lasts longest?" In this case, the experiment is carried out as a class,...
+
Lesson Plan
Curated OER

Shopping Around

For Teachers 3rd
Third graders select a recipe and compare prices for ingredients at two different stores. They select the best place to buy the ingredients and answer questions about the process. They include their data on a spreadsheet related to their...
+
Lesson Plan
Curated OER

Microsoft Access Lesson Plan

For Teachers 3rd
Third graders read children's literature during the school year and compile a list of books and genres in an Access database. They print out a report of all the different books and genres of they read over the whole school year.
+
Lesson Plan
Curated OER

What are they like Today

For Teachers 6th
Sixth graders compare the modern day countries that exist in the areas they study in Ancient History. They use a spreadsheet on the computer to organize data that includes population of the countries, along with other various types of...
+
Lesson Plan
Curated OER

Kindergarten Class Favorites

For Teachers K
Students discuss their favorite foods, a list of four favorite food are compiled on the board or a chart. They each vote for their favorite food and the data is entered onto a spread sheet and a graph is created while the students watch...
+
Lesson Plan
Curated OER

Spreadsheet Function Machine

For Teachers 7th - 8th
Learners create a spreadsheet to analyze functions. In this algebra lesson, students use spreadsheets to find the intersection of systems of equations. They identify the dependent and independent function as it relates to a line.
+
Lesson Plan
Curated OER

Using a Spreadsheet

For Teachers 8th - 10th
Young scholars create a spreadsheet to analyze data. In this technology lesson, students develop and use an Excel spreadsheet to log their data. They solve real life word problems as they set it up using the spreadsheet.
+
Lesson Plan
Curated OER

Investing

For Teachers 8th - 10th
Students collect data on investments and draw conclusions. In this algebra lesson, students analyze exponential graphs as they relate to money. They discuss the cause of an account balance being high or low.
+
Lesson Plan
Curated OER

Don't Lose Your Load!

For Teachers 9th - 11th
Students create graphs using collected data. In this algebra lesson plan, students use spreadsheet in Excel to create graphs to interpret their data and make predictions. They rewrite word problems using algebraic expressions.
+
Worksheet
Curated OER

Measuring and Observing Weather Phenomena

For Students 4th - 6th
In this weather worksheet, students take the temperature and record data over a period of time of 1 month. Students then make a spreadsheet of their data and include variables that contribute to the weather.
+
Lesson Plan
Curated OER

Computer Skills

For Teachers 5th - 8th
Students research computer information and use it to find the mean of things.  In this computer skills activity students are given activities in which they calculate and use a spreadsheet to enter data on the mean of their assignment. 
+
Lesson Plan
Curated OER

Making a Spreadsheet

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

Checking Test Comparability/Scattergrams

For Teachers 7th - 12th
Students construct a scattergram graph. In this statistics lesson, students graph data by hand and using a spreadsheet program. They establish lines of best fit and draw conclusions using their graphs.