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: M2: L1: From the Ground Up: Create Basic Formulas
In Module 2 Lesson 1 of this course on spreadsheets, students begin learning how to create formulas in a spreadsheet. They learn also about the importance of remembering the correct order of operations. 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...
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: Spreadsheet Software Applications: M4: L1: Chart It! Working With Charts
In Module 4 Lesson 1 of this course on spreadsheets, students learn how to build a chart from their spreadsheet data so that it is easier to interpret. Includes a glossary and slideshow tutorials.
Department of Defense
Do Dea: Spreadsheet Software: M5: L3: Customization: Modifying a Worksheet
In Module 5 Lesson 3 of this course on spreadsheets, students learn how to work with two or more spreadsheet workbooks at the same time where they have related data and how to create different customized views. Includes slideshow tutorials.
Department of Defense
Do Dea: Spreadsheet Software: M5: L4: Work With Me! Collaboration Options
In Module 5 Lesson 4 of this course on spreadsheets, students will learn how to collaborate on a spreadsheet document while working from different locations. Includes slideshow tutorials.
Department of Defense
Do Dea: Spreadsheet Software: M6: L3: Outside the Box: Get External Data
In Module 6 Lesson 3 of this course on spreadsheets, students will learn how to import data that is in different formats and from a variety of sources, and transpose and format it. 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.
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...
Teachnology
Teachnology: Spreadsheet Guide for Teachers
A Spreadsheet is a wonderful tool with applications well beyond simple calculations. This site provides a collection of lesson plans, tutorials and worksheets that help bring spreadsheets into the classroom.
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...
National Council of Teachers of Mathematics
The Math Forum: A Collection of Secondary Math Units
Teachers of grades 9-12 can explore these seven math units for their classes. Data collection and analysis, problem solving with spreadsheets, and linear transformation are just a few of the topics covered here.
Microsoft
Microsoft Education Lesson Plan: Candy Is Dandy
Explore color distribution of M&M candies using this detailed lesson plan. An engaging integrated lesson that requires understanding of spreadsheets and formulas, and logical reasoning. Links to related websites.
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...
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.
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.
Other
Anguilla Library: Lessons for Achieving Computer Literacy
This site presents lessons on software usage by members of a computer club. Lessons include Basic Dos Systems, Windows, Spreadsheets, Basic Programming, and more.
Other
Sun Associates: Basic Tools for Educators
Many teachers have found that the technology tools that are most accessible and versatile are those broadly classified as "Applications." This page discusses the many ways that spreadsheets, word processors, databases, and presentation...
TeachEngineering
Teach Engineering: Energy Perspectives
Students utilize data tables culled from the US DOE Energy Information Agency to create graphs that illustrate what types of energy we use and how we use it. An MS Excel workbook with several spreadsheets of data is provided. Students...
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...
Google
Google for Education: Working With Large Tables of Data
Young scholars work with large tables of GPS data and sort, manipulate, and visualize the data so it can be easily understood.
Other popular searches
- Excel Spreadsheets
- Microsoft Excel Spreadsheets
- Meteorology and Spreadsheets
- Using Excel Spreadsheets
- Math Using Spreadsheets
- Heart Rate and Spreadsheets
- Creating Spreadsheets
- Math Spreadsheets
- Using Spreadsheets
- Spreadsheets Charts
- Excel Spreadsheets Graph
- Excel Spreadsheets Planets