Lesson Plan
Other

Ontario Council for Technology Education: Designing a Tool Storage Board [Pdf]

For Teachers 10th - 12th
Students begin this project by taking an inventory of hand tools at home. They then categorize their tools and make a detailed list in a spreadsheet. After research on tool storage, they will choose materials and a tool board style, then...
Lesson Plan
Google

Google for Education: Data Aggregation and Decomposition (Excel)

For Teachers 9th - 10th
By using Microsoft Excel, students collect, decompose, and re-aggregate class data. Students use computational thinking skills by decomposing long lists of information and writing basic algorithms to help analyze data.
Lesson Plan
Google

Google for Education: Energy Analysis

For Teachers 9th - 10th
By creating a spreadsheet, students can learn more about energy production and consumption around the world. Students have to research the data to be analyzed in the spreadsheet. An example of the spreadsheet is given in this lesson plan.
Lesson Plan
Science Education Resource Center at Carleton College

Serc: Westward Ho! How Far Is Yonder Mountain

For Teachers 9th - 10th
In this activity quantitative skills in geologic context are reinforced. Students create a spreadsheet to calculate the distance of a peak using vertical angles sighted from a wagon train heading directly for the peak. The spreadsheet...
Lesson Plan
Alabama Learning Exchange

Alex: French Internet Clothes Shopping

For Teachers 9th - 10th
Students practice clothing vocabulary and computer spreadsheet skills by visiting authentic French online clothing catalogs. They choose articles of clothing for purchase for themselves and family members and create a spreadsheet to...
Lesson Plan
Cyberbee

Adventures of Cyberbee: Graphing

For Teachers Pre-K - 1st Standards
Teacher-directed lesson plan focusing on data analysis, graphing, and probability. Lesson includes a video and engaging spreadsheet activities.
Lesson Plan
Science Education Resource Center at Carleton College

Serc: Mn Step: Statistical Analysis of Lincoln

For Teachers 9th - 10th
For this activity, students first work in groups to collect information about a set of pennies. They measure and record the mass for each one in a table using a spreadsheet program if possible. They also record its year and, for 1982...
Lesson Plan
Science Education Resource Center at Carleton College

Serc: Take a Deep Breath on the Appalachian Trail

For Teachers 10th - 12th
A lesson plan that includes a PowerPoint learning module for students. They will examine spreadsheet data on air quality in Great Smoky National Parks, and solve problems using ratio and proportion. The exercises will help them to...
Lesson Plan
Microsoft

Microsoft Education Lesson Plan: Making Money From Lemons

For Teachers 3rd - 8th
Simulation where learners apply mathematics and economics concepts in the lemonade business. Learners set up a virtual lemonade stand and must determine production costs, product variables, and profits. Students record data collected on...
Lesson Plan
Science Education Resource Center at Carleton College

Serc: Resource Usage Project and Journal

For Teachers 9th - 10th
Learners pick a resource and track their use of it over the course of one week. Students record their data in a spreadsheet, write a summary of it, and draw conclusions from their usage patterns. A detailed student handout is provided.
Lesson Plan
Science Education Resource Center at Carleton College

Serc: Creating a Household Budget

For Teachers 9th - 10th
In this Spreadsheets Across the Curriculum PowerPoint module, students create a household budget by tracking their expenditures over a month-long period. Students use Microsoft Excel to create a spreadsheet to track their own...
Lesson Plan
Council for Economic Education

Econ Ed Link: Education: Weigh Your Options

For Teachers 9th - 10th
Getting and keeping a job often requires special education or training. While an employer may provide or pay for some additional education or training, workers often have to obtain it on their own. In this lesson, students use a weighted...
Lesson Plan
Alabama Learning Exchange

Alex: Charting the Weather

For Teachers 3rd - 5th
During this lesson, students will gather data from temperature and water gauges set up on the playground to learn about weather patterns. Then students will build a spreadsheet with data related to temperature, wind direction and amount...
Lesson Plan
Alabama Learning Exchange

Alex: Find a Pattern Using Children's Literature

For Teachers 6th - 8th
Young scholars use the problem-solving strategy of "find a pattern" to predict the number of grains of rice Rani (from the book, One Grain of Rice: A Mathematical Folktale by Demi) will receive after 30 days. Students use a spreadsheet...
Lesson Plan
Alabama Learning Exchange

Alex: Math Is Functional

For Teachers 9th - 10th Standards
This lesson is a technology-based activity in which students extend graphing of linear functions to the use of spreadsheet software. After students have become proficient in constructing a table of values, students are able to...
Lesson Plan
Alabama Learning Exchange

Alex: There's Perimeter in the School!

For Teachers 3rd - 5th
Students will work in groups to measure the perimeter of items around the school. They will record their data on a spreadsheet in the form of a line plot.
Lesson Plan
Alabama Learning Exchange

Alex: The Elephants Truncate Roots

For Teachers 6th - 8th Standards
Learners will learn the process of finding where the square root of 2 is on the number line by truncating the square of a number between 1 and 2. They will also work with other square roots to learn how to order them on the number line....
Lesson Plan
Alabama Learning Exchange

Alex: Bloodstain Pattern Doesn't Lie

For Teachers 9th - 10th
Students will formulate a hypothesis about the relationship (linear, direct, indirect, etc.) between the distance a drop of blood falls and the diameter of the splatter it makes. To test their hypothesis, the students will work...
Lesson Plan
Alabama Learning Exchange

Alex: How Much Will This Lifestyle Cost?

For Teachers 9th - 10th
Students will create a detailed monthly budget using a spreadsheet. The budget will depend on an individual's earning potential as determined by career choice and education. This is a project-based, Commerce and Information Technology...
Lesson Plan
Alabama Learning Exchange

Alex: Can I Afford This House?

For Teachers 9th - 10th
In this instructional activity, students will prepare a spreadsheet that provides information about purchasing a house. Using functions and formulas, they will determine if they can afford the house. This is a Commerce and Information...
Lesson Plan
Alabama Learning Exchange

Alex: Scale Drawings

For Teachers 9th - 10th
During this instructional activity students practice measuring and converting to scaled measurements. Students measure various places on campus, such as a classroom or the gym. They place their findings on a spreadsheet. After converting...
Lesson Plan
Alabama Learning Exchange

Alex: Watch That Plant Grow

For Teachers 6th - 8th
This lesson allows students to explore horticulture within a controlled environment, a greenhouse. Students engage in hands-on activities as they grow their own plants and chart data concerning the conditions related to plant growth in a...
Lesson Plan
Alabama Learning Exchange

Alex: Trading and Tracking Stock Portfolios Online

For Teachers 9th - 10th
Student teams will trade stocks and track the progress of their Alabama Stock Market Simulation portfolio by using spreadsheet software and the Internet. They will relate the information to a previous social studies unit on economics and...
Lesson Plan
Other

Nearpod: Spreadsheets: Using Formulas

For Teachers 9th - 10th
In this lesson on spreadsheets, students explore the different parts of a spreadsheet and use equations within spreadsheets to learn about their applications.

Other popular searches