Other
Nearpod: Spreadsheets: Using Formulas
In this lesson on spreadsheets, students explore the different parts of a spreadsheet and use equations within spreadsheets to learn about their applications.
Science Education Resource Center at Carleton College
Serc: Using Microsoft Excel to Explore Gravity Forces and Accelerations
Students will learn about the force of gravity and the factors that affect it, and use and analyze the universal gravitation equation using Excel spreadsheets.
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.
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...
Science Education Resource Center at Carleton College
Serc: Creating a Household Budget
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...
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 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...
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.
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.
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,...
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...
Other
Laus Dnet: Grade 5 Excel Lesson Plan
In this online instructional activity, students will survey students in their school to determine their favorite type of hand-held ice cream. Before performing the survey, students will make predictions about which ice creams they think...
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,...
Alabama Learning Exchange
Alex: Comparing Two Fossil Localities
During this lesson plan young scholars go on a field trip to locate fossils. Students investigate their findings and identify them using resources from the Internet. They then videoconference to compare/contrast their hypotheses with...
Alabama Learning Exchange
Alex: Becoming a Wise Consumer: Creating a Budget
In this lesson, students will learn how to become a wise consumer by creating a budget based on needs and wants. Students will create a weekly budget with a variable income using the interactive app MWB: My Weekly Budget available on...