Unit Plan
Department of Defense

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

For Students 9th - 10th
In Module 1 Lesson 5 of this course on spreadsheets, students review what they have learned in the previous four lessons. Content is stored in the Resources section. Practice tasks are not available online so teachers would need to...
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: 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: M4: L2: What Are the Conditions? Calculate With Functions

For Students 9th - 10th
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.
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: Spreadsheets: M5: L2:loans and Investments: Calculate With Functions

For Students 9th - 10th
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.
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: 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: L3: Can You Draw It? Working With Shapes

For Students 9th - 10th
In Module 3 Lesson 3 of this course on spreadsheets, students learn how to insert shapes into a spreadsheet and enhance them by resizing, rotating, changing line width, adding color and text, etc. Includes slideshow tutorials.
Lesson Plan
Discovery Education

Discovery Education: A Nation's Voice

For Teachers 9th - 10th Standards
A Nation's Voice is a lesson plan that uses internet sites, magazines and books, electronic encyclopedias and databases to understand the policy making of the U.S.

Other popular searches