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...
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.
Department of Defense
Do Dea: Spreadsheet Software: M1: L2: Ethical and Efficient Use of Computers
In Module 1 Lesson 2 of this course, students are introduced to issues related to copyright, public domain, and licensing agreements. They will also learn about industry certification for this course on spreadsheet applications.
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.
NASA
Nasa: Cosmic Chemistry: An Elemental Question
Explore the periodic table like never before! This downloadable program module for students comes absolutely complete with teacher modules, student assessments, PowerPoints, Excel spreadsheets, historical text readings and more. Students...
Department of Defense
Do Dea: Spreadsheet Software: M3: L5: Show Me Your Skills: Practice Skills
In Module 3 Lesson 5 of this course on spreadsheets, students review what they have learned in the previous four lessons about adding shapes and graphics to spreadsheets, using drawing tools to format them, using the autosum function,...
Department of Defense
Do Dea: Spreadsheet Software: M3: L1: Layout Options: Formatting a Worksheet
In Module 3 Lesson 1 of this course on spreadsheets, students will learn how to use the formatting tools in spreadsheets to enhance their appearance. Includes slideshow tutorials.
Department of Defense
Do Dea: Spreadsheet Software: M5: L1: Layout and Lay Up: Managing Workbooks
In Module 5 Lesson 1 of this course on spreadsheets, students learn how to work with large spreadsheets that extend beyond the screen. They will change the view, use split windows, freeze rows and columns, remove gridlines, etc. Includes...
Department of Defense
Do Dea: Spreadsheet Software: M5: L5: Show Me Your Skills: Practice Skills
In Module 5 Lesson 5 of this course on spreadsheets, students review what they have learned in the previous four lessons about working with large spreadsheets, using advanced functions to analyze data, working on more than one workbook...
Department of Defense
Do Dea: Spreadsheet Software: M6: L4: Show Me Your Skills: Practice Skills
In Module 6 Lesson 4 of this course on spreadsheets, which is the final lesson of the course, students review what they have learned in the previous three lessons about using templates, using data validation tools, and importing data...
Department of Defense
Do Dea: Spreadsheet Software: M2: L2: Shortcuts Anyone? Calculate With Functions
In Module 2 Lesson 2 of this course on spreadsheets, students learn how to use the built-in functions in Excel so that they don't have to retype a formula each time they use it. Includes slideshow tutorials.
Department of Defense
Do Dea: Spreadsheet Software: M4: L3: What's That Layout? Enhancing Charts
In Module 4 Lesson 3 of this course on spreadsheets, students learn how to use advanced features of Excel to simplify analysis of their data, for example, to make predictions about future trends or to take mini-snapshots of data trends...
Department of Defense
Do Dea: M1: L4: Starting Here, Starting Now! Beginning a Spreadsheet
In Module 1 Lesson 4 of this course on spreadsheets, students create their first spreadsheet using Microsoft Excel. Includes slideshow tutorials.
Department of Defense
Do Dea: Spreadsheet Software: M2:l3: Working Smarter: Copy Formulas and Functions
In Module 2 Lesson 3 of this course on spreadsheets, students learn how to save time when setting up a spreadsheet by copying functions and formulas. Includes slideshow tutorials.
Department of Defense
Do Dea: Spreadsheet Software: M3: L2: In the Library: Calculate With Functions
In Module 3 Lesson 2 of this course on spreadsheets, students learn about naming cells and cell ranges and how a name moves with the range it is attached to. Names can also be used in constructing absolute cell reference formulas....
Department of Defense
Do Dea: Spreadsheet Software: M4: L5: Show Me Your Skills: Practice Skills
In Module 4 Lesson 5 of this course on spreadsheets, students review what they have learned in the previous four lessons about building charts, using conditional formatting, and enhancing their spreadsheet by inserting images, text, and...
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...