Science Education Resource Center at Carleton College
Serc: Salmon Use of Geomorphically Restored Streams at Point Reyes Nat. Seashore
A lesson plan with an accompanying PowerPoint learning module for students where they learn about coho salmon and a repair done to a culvert in Point Reyes National Seashore. The repair was intended to help the salmon make their journey...
National Council of Teachers of Mathematics
The Math Forum: Algebraic Problem Solving Using Spreadsheets
A unit is presented on instructing students how to build and use spreadsheets for algebraic problem solving. Easy-to-follow steps are provided along with problems for students to practice.
Science Education Resource Center at Carleton College
Serc: Yellowstone! A National Park on a Hot Spot
A lesson plan with an accompanying PowerPoint learning module for students where they learn about the volcanic features of Yellowstone National Park. They use spreadsheets to make various calculations, such as the volume of material...
Science Education Resource Center at Carleton College
Serc: The Digital Divide: A Data Analysis Activity Using Subtotals
A lesson plan that includes a PowerPoint learning module for students. The purpose of the lesson plan is to teach how to use Excel to analyze a large amount of data, in this case from the US Census. The example being used is the...
Department of Defense
Do Dea: Spreadsheets: M1:l3: Operating System and Spreadsheet Applications Screen
In Module 1 Lesson 3 of this course on spreadsheets, students begin learning how to use Microsoft Excel to create spreadsheets. Slideshows walk them through how to navigate the menus and tools of Excel.
Department of Defense
Do Dea: Spreadsheets: M4: L2: What Are the Conditions? Calculate With Functions
In Module 4 Lesson 2 of this course on spreadsheets, students learn how to use conditional formatting to more easily analyze data. Includes slideshow tutorials.
Department of Defense
Do Dea: Spreadsheets: M5: L2:loans and Investments: Calculate With Functions
In Module 5 Lesson 2 of this course on spreadsheets, students will learn how to use the advanced Financial, Logical and Date & Time functions to analyze spreadsheet data. Includes slideshow tutorials.
Georgia State University
Georgia State University: Creating Spreadsheets Using Ms Excel
This Georgia State University site gives in outline form the basic principles of using spreadsheet software. At the end of the outlines, specific uses for spreadsheets in recordkeeping are suggested.
Department of Defense
Do Dea: Spreadsheet Software: M6: L1: Designing Spaces: Using Templates
In Module 6 Lesson 1 of this course on spreadsheets, students learn how to use the templates in Excel to save time when making new spreadsheets. Includes slideshow tutorials.
Department of Defense
Do Dea: Spreadsheet Software Applications: M6: L2: Clean Up: Using Data Tools
In Module 6 Lesson 2 of this course on spreadsheets, students learn how to use data validation tools in Excel to minimize errors in manual data entry. Includes slideshow tutorials.
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.
BBC
Bbc Bitesize: Spreadsheets
Spreadsheets are used to store information and data. Once we have our information in a spreadsheet we can run powerful calculations, make graphs and charts and analyse patterns.
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
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.
Love To Know Media
Your Dictionary: Sample Lesson Plans for 7th Grade Computer Terms
This site offers links to a list of computer terms middle schoolers need to know; it also offers links to lesson plans teaching things like using spreadsheets.
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 instructional activity is to learn the difference between simple and compound interest and to use the functions in Excel to perform the calculations...
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.
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.
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...