Curated OER
Investigation of Hooke's Law Lab
Students determine the spring constant by conducting an investigation. In this physics lesson, students collect data and create a graph of force vs. displacement. They compare the results of two different methods to find spring constant.
Curated OER
Ballistic Pendulum Lab
Students determine the muzzle velocity of projectile launcher. In this physics lesson, students compare the pendulum method and kinematic method in calculating the initial velocity. They analyze data and discuss results in class.
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
Students 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 visualization.
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
Learners 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
Young scholars 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 lesson has students working together to generate a spreadsheet of data found. Students will use this information to describe why Earth...
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
Learners 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 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