Lesson Plan
Curated OER

To Drink or not to Drink

For Teachers 7th
Seventh graders discuss water quality, water availability and water resources and how water is used in the world around them. They view a video on water quality then test for pH, temperature and dissolved oxygen to indicate water quality.
Lesson Plan
Curated OER

Weights and Measures

For Teachers 6th - 8th
Learners master the gathering, averaging and graphing of data. They practice conversion to metric measures. They gain fluency in the use of technology tools for math operations.
Lesson Plan
Curated OER

Interpreting and creating tables

For Teachers 3rd - 5th
Students observe examples and discuss how to interpret them. They then brainstorm examples of possible questions students could use to create a table. They take time to formulate a question and collect data.
Website
Other

The University of Arizona: Study Finance: Getting Started With Excel

For Students 9th - 10th
A great tutorial that takes you through all the steps you need for mastering the Microsoft Excel spreadsheet application.
Unit Plan
Department of Defense

Do Dea: Spreadsheet Software: M6: L4: Show Me Your Skills: Practice Skills

For Students 9th - 10th
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...
Unit Plan
Department of Defense

Do Dea: Spreadsheet Software: M6: L1: Designing Spaces: Using Templates

For Students 9th - 10th
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.
Unit Plan
Department of Defense

Do Dea: Spreadsheet Software: M2: L1: From the Ground Up: Create Basic Formulas

For Students 9th - 10th
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.
Lesson Plan
Other

Laus Dnet: Grade 5 Excel Lesson Plan

For Teachers 3rd - 5th
In this online lesson, 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 will be the...
Unit Plan
Department of Defense

Do Dea: Spreadsheet Software: M2: L5: Show Me Your Skills: Practice Skills

For Students 9th - 10th
In Module 2 Lesson 5 of this course on spreadsheets, students review what they have learned in the previous four lessons about formulas, functions, and manipulating a spreadsheet. Content is stored in the Resources section. Practice...
Unit Plan
Department of Defense

Do Dea: Spreadsheet Software: M2:l3: Working Smarter: Copy Formulas and Functions

For Students 9th - 10th
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.
Unit Plan
Department of Defense

Do Dea: Spreadsheet Software: M5: L3: Customization: Modifying a Worksheet

For Students 9th - 10th
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.
Unit Plan
Department of Defense

Do Dea: M1: L4: Starting Here, Starting Now! Beginning a Spreadsheet

For Students 9th - 10th
In Module 1 Lesson 4 of this course on spreadsheets, students create their first spreadsheet using Microsoft Excel. Includes slideshow tutorials.
Unit Plan
Department of Defense

Do Dea: Spreadsheets: M1:l3: Operating System and Spreadsheet Applications Screen

For Students 9th - 10th
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.
Unit Plan
Department of Defense

Do Dea: Spreadsheet Software: M2: L2: Shortcuts Anyone? Calculate With Functions

For Students 9th - 10th
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.
Unit Plan
Department of Defense

Do Dea: Spreadsheet Software Applications: M6: L2: Clean Up: Using Data Tools

For Students 9th - 10th
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.
Unit Plan
Department of Defense

Do Dea: Spreadsheet Software: M3: L5: Show Me Your Skills: Practice Skills

For Students 9th - 10th
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,...
Unit Plan
Department of Defense

Do Dea: Spreadsheet Software: M4: L5: Show Me Your Skills: Practice Skills

For Students 9th - 10th
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...
Unit Plan
Department of Defense

Do Dea: Spreadsheet Software: M4: L3: What's That Layout? Enhancing Charts

For Students 9th - 10th
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...
Unit Plan
Department of Defense

Do Dea: Spreadsheet Software: M5: L1: Layout and Lay Up: Managing Workbooks

For Students 9th - 10th
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...
Unit Plan
Department of Defense

Do Dea: Spreadsheet Software: M5: L4: Work With Me! Collaboration Options

For Students 9th - 10th
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.
Unit Plan
Department of Defense

Do Dea: Spreadsheet Software Applications: M2: L4: Manipulate Data

For Students 9th - 10th
In Module 2 Lesson 4 of this course on spreadsheets, students learn how to alter the information in a spreadsheet by manipulating it and formatting. Includes slideshow tutorials.
Unit Plan
Department of Defense

Do Dea: Spreadsheet Software: M5: L5: Show Me Your Skills: Practice Skills

For Students 9th - 10th
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...
Unit Plan
Department of Defense

Do Dea: Spreadsheet Software: M3: L1: Layout Options: Formatting a Worksheet

For Students 9th - 10th
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.
Unit Plan
Department of Defense

Do Dea: Spreadsheet Software: M4: L4: And This! Inserting Objects and Content

For Students 9th - 10th
In Module 4 Lesson 4 of this course on spreadsheets, students learn how to insert text, graphics, and charts into a spreadsheet. They will learn how to import and export data and images between different types of documents. Includes a...