Hi, what do you want to do?
Google
Google for Education: Applyng Discrete and Continuous Data in a Spreadsheet
Students collect data in a spreadsheet and learn to use various functions and analysis tools to better see patterns in their eating habits.
Alabama Learning Exchange
Alex: Creating a Payroll Spreadsheet
Spreadsheet software allows you to calculate numbers arranged in rows and columns for specific financial tasks. This activity allows students to create an "Employee Work/Pay Schedule" spreadsheet to reinforce spreadsheet skills. Students...
Science Education Resource Center at Carleton College
Serc: Simple vs. Compound Interest Spreadsheeting the Difference
A lesson plan that includes a PowerPoint learning module for students. The goal of the lesson is to learn the difference between simple and compound interest and to use the functions in Excel to perform the calculations and graph the data.
Science Education Resource Center at Carleton College
Serc: The "Perfect" Date: Ranking and Rating Decisions With a Spreadsheet
A lesson plan that includes a PowerPoint learning module for students. The purpose of the lesson is to use spreadsheets to explore a rating and ranking method for choosing someone to date. They look at the problems that arise when...
PBS
Pbs: Personal Spending Spreadsheet
This activity helps students create their own personal spending plan.
Google
Google for Education: Patterns in the Periodic Table
Students study trends in the periodic table of elements, supplemented by the use of spreadsheet functions. The spreadsheet functions presented can be used on any data set.
Google
Google for Education: Energy Analysis
Young scholars collect data on energy production and consumption around the world. They input the data into a spreadsheet and use spreadsheet functions to analyze it. Finally, they upload the data into a fusion table to create a...
Google
Google for Education: Sorting the World's Cities (Excel)
Students learn to organize, sort, and display data in a Microsoft Excel spreadsheet using latitude data for 120 major world cities.
Google
Google for Education: Sorting the World's Cities (Python)
The second of two similar lessons where students learn how a Python program can organize and sort data. When taught in conjunction with Sorting the World's Cities with Excel, students make the connection between writing a program and...
Science Education Resource Center at Carleton College
Serc: Cycles of the Sun and Moon
Young scholars download sunrise and sunset data along with moon phase data, and graph these data sets together in a spreadsheet in order to visualize the cycles of the seasons and the moon.
Other
Tonya Skinner Business Ed Lesson Plans: Grocery Shopping
This personal site provides a student activity that allows learners to plan a class party while organizing the budget details in a spreadsheet program. Learners will demonstrate computer skills in inputting data, formatting data, and...
Utah Education Network
Uen: Design Your Own Bedroom
Many students dream of designing their ideal bedroom. In this exercise, students will be required to limit their designs by size (as a specific volume) and price (a specific amount). They must design the floor plan, including furniture...
Council for Economic Education
Econ Ed Link: Loan Amortization Mortgage
How to amortize a loan using an Excel spreadsheet.
Science Education Resource Center at Carleton College
Serc: Know Your Neighbors: Researching the Planets
Students will study planets and moons in our solar system by working online and other resources. This lesson has students working together to generate a spreadsheet of data found. Students will use this information to describe why Earth...
Google
Google for Education: Data Aggregation and Decomposition (Python)
Students learn how to use and analyze data to draw conclusions about information collected from classmates. Then they use computational thinking by collecting and aggregating data onto a spreadsheet, identifying patterns in their data,...
Science Education Resource Center at Carleton College
Serc: Reasoning About Center and Spread: How Do Students Spend Their Time?
Using their own habits for data, students predict how much time they spend on different activities each day, and how much variability each activity is likely to have. They then collect data into a class spreadsheet and look at the...
Other
Ontario Council for Technology Education: Designing a Tool Storage Board [Pdf]
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...
Google
Google for Education: Data Aggregation and Decomposition (Excel)
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.
Google
Google for Education: Energy Analysis
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.
Science Education Resource Center at Carleton College
Serc: Westward Ho! How Far Is Yonder Mountain
In this instructional 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...
Alabama Learning Exchange
Alex: French Internet Clothes Shopping
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...
Science Education Resource Center at Carleton College
Serc: Mn Step: Statistical Analysis of Lincoln
For this activity, learners 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...
Science Education Resource Center at Carleton College
Serc: Take a Deep Breath on the Appalachian Trail
A lesson plan that includes a PowerPoint learning module for learners. 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...
Microsoft
Microsoft Education Lesson Plan: Making Money From Lemons
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...
Other popular searches
- Spreadsheets
- Excel Spreadsheets
- Budget Spreadsheet
- Favorite Foods Spreadsheet
- Microsoft Excel Spreadsheets
- Candy Wrapper Spreadsheet
- Basic Spreadsheet Skills
- Spreadsheet Lesson Plans
- Meteorology and Spreadsheets
- Using Excel Spreadsheets
- Amusement Park Spreadsheet
- Creating a Spreadsheet