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: 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: 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.
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: 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: 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: 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: M3: L2: In the Library: Calculate With Functions

For Students 9th - 10th
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....
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: 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...
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: 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: M6: L3: Outside the Box: Get External Data

For Students 9th - 10th
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.
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 Applications: M4: L1: Chart It! Working With Charts

For Students 9th - 10th
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.
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.
Interactive
Goodwill

Gcf Global: Excel Tips

For Students 9th - 10th
Learn these Excel tips and tricks so you can do more with this popular spreadsheet program.
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: 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: Spreadsheet Software: M1: L2: Ethical and Efficient Use of Computers

For Students 9th - 10th
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.
Activity
TeachEngineering

Teach Engineering: Graphing Your Social Network

For Teachers 9th - 10th
Students analyze their social networks using graph theory. They gather data on their own social relationships, either from Facebook interactions or the interactions they have throughout the course of a day, recording it in Microsoft...
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: 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
Other

Learn the Net: Download Files

For Students 9th - 10th
This resource provides an excellent set of instructions on how to save files to your hard drive and how to download software, as well as an overview on file formats and extensions.