Activity
1
1
Teach Engineering

Searching for Bigfoot and Others Like Him

For Teachers 7th - 9th
Individuals create a GIS data layer in Google Earth that displays information about where one might find seven different cryptids. The class members research to find data on cryptid sightings they can include in their data...
Activity
Howard Hughes Medical Institute

Gorongosa: Scientific Inquiry and Data Analysis

For Teachers 9th - 12th Standards
How does the scientific process begin? Introduce ecology scholars to scientific inquiry through an insightful, data-driven lesson. Partners examine data from an ongoing research study to determine the questions it answers. The resource...
Activity
Howard Hughes Medical Institute

Measuring Biodiversity in Gorongosa

For Teachers 9th - 12th
Take your biology class' understanding of biodiversity to a whole new level! Ecology scholars use data to calculate three different diversity indices based on the organisms in the Gorongosa National Park. The four-part activity uses an...
Lesson Plan
Curated OER

Graphing

For Teachers 5th
Fifth graders create graphs based on climate in South Carolina. They read and interpret information in a chart and construct a graphy from the information in the chart. They create a spreadsheet using Excel and publish 2 graphs.
Lesson Plan
Curated OER

Using a Spreadsheet

For Teachers 8th - 10th
Young scholars create a spreadsheet to analyze data. In this technology lesson, students develop and use an Excel spreadsheet to log their data. They solve real life word problems as they set it up using the spreadsheet.
Lesson Plan
Curated OER

A Comparison Study of Water Vapor Data to Precipitation over North America

For Teachers 10th - 12th
Students use NASA satellite data to compare water vapor over the United States.  In this data analysis lesson students use an Excel spreadsheet to map their data. 
Lesson Plan
Curated OER

Web Page Construction - 3 Easy Ways

For Teachers 3rd - 8th
Students create web pages by using Microsoft FrontPage and HTML with Microsoft Notepad, and use a web-based template found on the Internet to create web sites for non-profit organizations or businesses with which students are familiar.
Lesson Plan
Curated OER

Data Collection

For Teachers 3rd - 5th
Students write a journal exercise that relates to pets. They collect information from each other in order to practice making and interpreting bar graphs. They Continue building different kinds of graphs with the group.
Lesson Plan
Curated OER

The Nifty Fifty-What's Your Size?

For Teachers 3rd - 5th
Students explore state populations. In this state geography lesson, students use a variety of technology tools to research and graph population and area of assigned states.
Lesson Plan
Curated OER

Building My Dream House

For Teachers 7th - 8th
Students create their dream house using a spreadsheet for measurements. In this measurements and drawings lesson, students apply concepts of units and conversions as they build and create different shapes. They use Google Sketch-up...
Lesson Plan
Curated OER

Lesson 14: Genetic Disorders

For Teachers 9th - 10th
Young scholars create PowerPoint presentation on the topic they researched. In this biology lesson plan, students fill out a storyboard about their topic. They share their project in class.
Lesson Plan
Curated OER

DNA Technology

For Teachers 9th - 10th
Young scholars prepare PowerPoint presentation on DNA and cells. In this biology lesson, students create a storyboard of their presentation. They share the finished project in class. 
Lesson Plan
Curated OER

Functioning as a Team

For Teachers 9th - 12th
Students work as a team to build a freestanding bridge from newspapers and masking tape and analyze the effectiveness of their group. In this teamwork lesson, students view and summarize a video on Service Learning Projects. Students...
Website
Other

Function X: Microsoft Excel Tutorial

For Students 9th - 10th
This site offers tutorials and examples on how to use Microsoft Excel applications and experiment with it.
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.
Handout
Other

The Excel Addict

For Students 9th - 10th
The Excel Addict offers free tips, tutorials, newsletters, and more relating to the spreadsheet and database program, Microsoft 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: 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: 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: 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 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: 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.
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...