Handout
Computer Hope

Computer Hope: Microsoft Shortcut Keys

For Students 9th - 10th
Explains basic key terminology and computer shortcut keys (keyboard shortcuts), and lists shortcuts for these Microsoft applications: Windows, Excel, Word, Internet Explorer, FrontPage, and Outlook.
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: 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: 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: 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...
Website
Goodwill

Gcf Global: Office 2016

For Students 9th - 10th
Links to tutorials on the Microsoft Office 2016 suite including Excel 2016, Word 2016, PowerPoint 2016, and Access 2016.
Lesson Plan
Science Education Resource Center at Carleton College

Serc: The Digital Divide: A Data Analysis Activity Using Subtotals

For Teachers 10th - 12th
A lesson plan that includes a PowerPoint learning module for students. The purpose of the lesson is to teach how to use Excel to analyze a large amount of data, in this case from the US Census. The example being used is the accessibility...
Activity
TeachEngineering

Teach Engineering: Using Graph Theory to Analyze Drama

For Teachers 9th - 10th
Students analyze dramatic works using graph theory. They gather data, record it in Microsoft Excel and use Cytoscape (a free, downloadable application) to generate graphs that visually illustrate the key characters (nodes) and...
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...
Activity
TeachEngineering

Teach Engineering: Applying Hooke's Law to Cancer Detection

For Teachers 10th - 12th
Students explore Hooke's law while working in small groups at their lab benches. They collect displacement data for springs with unknown spring constants, k, by adding various masses of known weight. After exploring Hooke's law and...
Activity
TeachEngineering

Teach Engineering: You Be the Radiologist!

For Teachers 10th - 12th
In addition to the associated lesson, this activity functions as a summative assessment for the Using Stress and Strain to Detect Cancer unit. In this activity, students will create a 1-D strain plot in Microsoft Excel depicting the...
Lesson Plan
TeachEngineering

Teach Engineering: Stress, Strain and Hooke's Law

For Teachers 10th - 12th
This lesson offers an introduction to Hooke's Law as well as stress-strain relationships. Students will first learn the governing equations. Then students will work through several example problems first individually, then as a class. In...
Lesson Plan
TeachEngineering

Teach Engineering: Presenting Painless Breast Cancer Detection!

For Teachers 10th - 12th
This lesson culminates the unit with the Go Public phase of the legacy cycle. In the associated activity, students must depict a tumor amidst healthy body tissue using a graph in Microsoft Excel. In addition, students will design a...
Interactive
Goodwill

Gcf Global: Excel Formulas

For Students 9th - 10th
In this interactive tutorial, learn how to create formulas to solve real-world problems.
Activity
Texas Instruments

Texas Instruments: Stretching Slinkies

For Teachers 6th - 8th
This lesson provides students with the opportunity to explore the TI-84 graphing calculator in conjunction with Microsoft Excel. Students can use the "Stretching Slinkies" worksheet to record and enter data. They will either: enter data...
Lesson Plan
Science Education Resource Center at Carleton College

Serc: Quantitative Reasoning and Analytical Writing in a Global Climate Change

For Teachers 9th - 10th
In this lesson students use Microsoft Excel to manipulate and statistically analyze large climate databases of precipitation., temperature, stream discharge, tree ring data, ice core data, and ENSO to determine climate relationships and...
Handout
Wikimedia

Wikipedia: Ms Dos

For Students 9th - 10th
Wikipedia gives an excellent definition of Microsoft's original disk operating system, MS-DOS, including hyperlinked terms and more.
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 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: 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,...

Other popular searches