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.
eBook
Khan Academy

Khan Academy: Unit: Intro to Sql: Querying and Managing Data

For Students 9th - 10th
Learn how to use SQL to store, query, and manipulate data. SQL is a special-purpose programming language designed for managing data in a relational database, and is used by a huge number of apps and organizations.
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: 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
REMC Association of Michigan

Remc Association of Michigan: 21 Things4 Students: 13. Dig the Data

For Students 3rd - 8th
This tutorial contains ten quests. You will learn to create spreadsheets and charts, use formulas, and make decisions based on data. The first five quests has students plan a party and in the last five, they collect and analyze data for...
Unit Plan
Other

Oslis: Learn How to Do Research, Find Information, Cite Sources

For Students 9th - 10th Standards
Excellent site outlining each step for Internet research at the middle school and secondary levels. This site focuses on a variety of information literacy topics, from how to research, find and evaluate information, and cite sources....
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.