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
Students 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
Personal: Let's Go Shopping
This personal site provides a student activity that allows learners to practice spreadsheet skills in inputting data and creating function formulas. The activity is based on the collection and comparison of shopping receipts using max,...
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: Using an Excel Checkbook
Students will use a spreadsheet to enter checkbook transactions and reconcile.
Council for Economic Education
Econ Ed Link: Loan Amortization Mortgage
How to amortize a loan using an Excel spreadsheet.
NC State University
North Carolina State University: Spreadsheets in Science
Intriguing lesson from North Carolina State University using a spreadsheet to solve real world science problems. Contains downloadable files for student activities.
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 instructional activity has students working together to generate a spreadsheet of data found. Students will use this information to...
Science Education Resource Center at Carleton College
Serc: Analyzing Plate Motion Using Earth Scope Gps Data
In this chapter, you will access Global Positioning System (GPS) data from the Plate Boundary Observatory (PBO) and analyze the data in a spreadsheet to measure the motion of GPS stations in the Pacific Northwest. From your analyses, you...
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...
NASA
Nasa: Sea Surface Temperature Trends of the Gulf Stream
Students investigate changes in the surface temperatures of the Gulf Stream over the course of the seasons using data collected by NASA's satellites. The data is inputted into a spreadsheet and graphed.
Alabama Learning Exchange
Alex: Virtual Tours of Colleges and Careers
Lesson introducing students to the You University TV website as a way to prepare for college and/or a career. Students are given time to research colleges and careers through the website and add information to a spreadsheet.
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 lesson quantitative skills in geologic context are reinforced. Young scholars 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...
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