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

Finding Mean, Mode and Median in the Computer Lab

For Teachers 5th - 12th
Students create spreadsheets which will display and figure mean, median, and mode of a set of numbers.
Lesson Plan
Curated OER

Scale Basketball

For Teachers 9th - 12th
Students understand that a spreadsheet can be used to find the best scale to use in a model. They place the distances of the planets of the solar system to the Sun in one column of the spreadsheet. Students try different scales so that...
Lesson Plan
Curated OER

Graphs and Spreadsheets

For Teachers K - 12th
Students collect data and present it in a graph and/or a spreadsheet, depending on their previous understanding of technology.
Lesson Plan
Curated OER

Math Hunt

For Teachers 3rd - 6th
Students, in groups, explore their school to find examples of patterns, geometric shapes, and fractions. They take measurements and make computations of what they find. They record their findings in a spreadsheet, make graphs, and share...
Lesson Plan
Curated OER

Supermarket Smarts

For Teachers 9th - 12th
Students examine how a consumer can make informed choices. They visit stores with a prepared shopping list, record the prices on a spreadsheet, create graphs, and create a Powerpoint presentation comparing the total cost of stores and a...
Lesson Plan
Curated OER

Snow Cover By Latitude

For Teachers 6th - 8th
Students create graphs comparing the amount of snow cover along selected latitudes using data sets from a NASA website. They create a spreadsheet and a bar graph on the computer, and analyze the data.
Lesson Plan
Curated OER

Growing Barley and Detecting the Presence of Amino Acids

For Teachers 9th - 12th
Pupils produce the greatest mass of plant material possible for 100 seeds of barley, and detect amino acids in barley plant material. They develop rules for the investigation, conduct the experiment, and prepare a computer spreadsheet...
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

Virginia's Historical Figures

For Teachers 4th
Fourth graders write full paragraphs about important historical figures from Virginia's history. They research an the historical figure before word processing three complete paragraphs using facts and appropriate clipart. They compare...
Lesson Plan
Curated OER

Get A Life

For Teachers 9th - 12th
Students explore choosing a career and living on a budget. They receive an alternative identity and must make choices and decisions based upon given situations. Students research possible solutions, and use spreadsheet technology to...
Lesson Plan
Curated OER

Finding Patterns with the Hundreds Chart

For Teachers 2nd - 3rd
Students review their numbers up to one hundred. Using a chart, they compare and predict patterns that might be in the numbers. They practice skip counting and grouping numbers. Using a spreadsheet, they graph different sets of numbers...
Lesson Plan
Curated OER

Money Math

For Teachers 6th - 12th
Students explore the use of money in daily life. Through activities and real-life simulations, students write and balance a checkbook, explore the importance of budgeting, saving, and expenses. Using spreadsheet technology, they examine...
Lesson Plan
Curated OER

The Stock Market Game

For Teachers 5th - 9th
Students explore the stock market. They choose a company and research the company's financial report. Students select 4-10 stocks and become an advocate for one stock. Using spreadsheet software, students compare stocks. They analyze...
Lesson Plan
Curated OER

Candy Bar Survey

For Teachers 2nd
Second graders investigate the skill of graphing data by using candy bars to create context for the instructional activity. They use technology for graphing and organizing information like a spreadsheet. The instructional activity...
Lesson Plan
Curated OER

The Dangers of Being Obese/Overweight

For Teachers 3rd
Third graders determine if they are eating healthy. In this healthy living lesson, 3rd graders watch a video titled Happy Health and review the food pyramid. Students create a spreadsheet where they list their food intake for the week...
Lesson Plan
Curated OER

Using a Statistical Procedure To Search A Database For Out of the Ordinary Values

For Teachers 7th - 10th
Students develop a spreadsheet containing formulas and find summaries for them.  For this investigative lesson students choose a topic, investigate it and use MS Excel to sort data. 
Lesson Plan
Curated OER

Using A Volunteer Acquired Database Constructed On The Internet, Examine the Relationship between Dissolved Oxygen and Water Temperature

For Teachers 9th
Ninth graders access a database and open a spreadsheet.  In this oxygen and water temperature lesson students save the database, sort it and generate scatter plot graphs. 
Lesson Plan
Curated OER

Stock and Inventory

For Teachers 5th - 8th
Young scholars create databases. In this spreadsheet lesson, students take stock of their toys and create databases. Young scholars consider good business practices as they listen to guest speaker discuss how to control inventory.
Worksheet
Curated OER

Place Value: Making Change with Canadian Money

For Students 2nd - 3rd
For this place value:  making change with Canadian money worksheet, students use a spreadsheet and certain coins to practice and record how much change would be given from a $5 bill.  A parent or tutor adjusts the questions to...
Lesson Plan
Curated OER

Examining newspapers

For Teachers 8th - 12th
Students compare and contrast tabloid and broadsheet papers. In this journalism lesson, students examine how techniques and form differs from one type of publication to the other. The culminating activity is for students to take what...
Lesson Plan
Curated OER

Egyptian Weather Lesson

For Teachers 6th - 8th
Students chart temperatures in Egypt on spreadsheet to determine how weather conditions affect lifestyles.
Lesson Plan
Curated OER

Save Our Forests

For Teachers 5th
Fifth graders discuss the forest products industry and its affects upon their communities. They inventory the wood and paper products they consume and determine how it translates into the number of trees cut. Using a spreadsheet, they...
Lesson Plan
Curated OER

Power Metering Project

For Teachers 9th - 12th
Young scholars collect and analyze variable data and understand the concept of electrical power.  In this energy lesson plan students use a spreadsheet to manage their data and create box plots. 

Other popular searches