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.
Lesson Plan
Google

Google for Education: Data Aggregation and Decomposition (Python)

For Teachers 9th - 10th
Students learn how to use and analyze data to draw conclusions about information collected from classmates. Then they use computational thinking by collecting and aggregating data onto a spreadsheet, identifying patterns in their data,...
Lesson Plan
Google

Google for Education: Sorting the World's Cities (Python)

For Teachers 9th - 10th
The second of two similar lessons where students learn how a Python program can organize and sort data. When taught in conjunction with Sorting the World's Cities with Excel, students make the connection between writing a program and...
Lesson Plan
NASA

Nasa: Sea Surface Temperature Trends of the Gulf Stream

For Teachers 9th - 10th
Students investigate changes in the surface temperatures of the Gulf Stream over the course of the seasons using data collected by NASA's satellites. The data is inputted into a spreadsheet and graphed.
Lesson Plan
National Council of Teachers of Mathematics

The Math Forum: Seventh Grade Mathematics: Data Sense

For Teachers 6th - 8th
This site has some interesting ways to collect and evaluate data. There are some activities about note taking, spreadsheets, surveys, and a cool bridge construction project. Teachers may want to use this site as a resource for some...
Interactive
University of Oregon

Magnet Lab: University of Oregon Virtual Laboratory

For Students 9th - 10th
The collection of interactive physics applets offered by the University of Oregon is an excellent resource for students. The applets are grouped in broad subject areas including astrophysics, energy and environment, mechanics and...
Activity
Texas Instruments

Texas Instruments: Social Security Issues

For Teachers 9th - 10th
In this activity, you will look at the relationship between the age at which you start drawing social security and the amount drawn. Both graphs and spreadsheets will be used.
Lesson Plan
Science Education Resource Center at Carleton College

Serc: Using Microsoft Excel to Explore Gravity Forces and Accelerations

For Teachers 9th - 10th
Students will learn about the force of gravity and the factors that affect it, and use and analyze the universal gravitation equation using Excel spreadsheets.
Activity
Science Education Resource Center at Carleton College

Serc: Average Rates of Change and Trend Lines

For Students 9th - 10th
In this Spreadsheets Across the Curriculum activity, students calculate the average rate of change and graph a scatter plot of status high school dropout rate for 1975-2002. The module combines interpretation of rate of change in the...
Lesson Plan
Science Education Resource Center at Carleton College

Serc: The Mole in Chemistry: Determining the Number of Atoms in Everyday Items

For Teachers 9th - 10th
Students explore the concept of the mole as a measure of quantity. They build spreadsheets that allow them to convert between moles, grams, and atomic mass units for given quantities of everyday items, elements, and simple chemical...
Interactive
American Association of Physics Teachers

Com Padre Digital Library: Open Source Physics: Data Tool Program

For Students 9th - 10th
Use this online data analysis tool to build graphs and display results from scientific investigations. Data can be entered directly with the keyboard or imported from, and exported to spreadsheets.
Activity
Other

Fast Food Fun

For Students 9th - 10th
Use your knowledge of spreadsheets to analyze the calories and fat content of fast food choices. This project gives links to a USDA site and a final report format. A sample spreadsheet and grading rubric is also provided.
Website
Other

Think Free Office

For Students 9th - 10th
ThinkFree allows you to create, view, publish, edit, and share word processing documents, spreadsheets, and presentations, all online. Sign up and have access to all of your documents from anywhere that you have web access. The website...
Unit Plan
Goodwill

Gcf Global: Google Drive

For Students 9th - 10th
In this tutorial, learn how to use this cloud-based program to create and share documents, spreadsheets, presentations, and more.
Lesson Plan
Alabama Learning Exchange

Alex: Becoming a Wise Consumer: Creating a Budget

For Teachers 6th - 8th
In this instructional activity, students will learn how to become a wise consumer by creating a budget based on needs and wants. Students will create a weekly budget with a variable income using the interactive app MWB: My Weekly Budget...
Article
Khan Academy

Khan Academy: File Types

For Students 9th - 10th
Computers store all files as binary data, long strings of 111s and 000s. Files represent all types of data: images, videos, documents, text files, spreadsheets, and applications. Files are stored as binary data.
Handout
National Council of Teachers of Mathematics

The Math Forum: Spreadsheet Basics

For Students 9th - 10th
A simple introduction on how to create a spreadsheet.
Lesson Plan
Other

Laus Dnet: Grade 5 Excel Lesson Plan

For Teachers 3rd - 5th
In this online instructional activity, students will survey students in their school to determine their favorite type of hand-held ice cream. Before performing the survey, students will make predictions about which ice creams they think...
Lesson Plan
Science Education Resource Center at Carleton College

Serc: Take a Deep Breath on the Appalachian Trail

For Teachers 10th - 12th
A lesson plan that includes a PowerPoint learning module for students. They will examine spreadsheet data on air quality in Great Smoky National Parks, and solve problems using ratio and proportion. The exercises will help them to...
Activity
Other

Making a Word Find With Microsoft Excel

For Teachers 9th - 10th
Teachers and students can create a word find using Excel. It will help them learn to manipulate columns and rows and format and lock cells. This plan is based upon 10 word or phrases on any topic.
Lesson Plan
Utah Education Network

Uen: Design Your Own Bedroom

For Teachers 6th - 8th
Many students dream of designing their ideal bedroom. In this exercise, students will be required to limit their designs by size (as a specific volume) and price (a specific amount). They must design the floor plan, including furniture...
Lesson Plan
Science Education Resource Center at Carleton College

Serc: Rainfall and Elevation: A Charting and Critical Thinking Exercise

For Teachers 9th - 10th
In this lab, students will learn to organize and present data in a visual way so that they can then summarize in writing their conclusions about the relationships between the data.
Professional Doc
PBS

Wnet: Thirteen: Ntti: Managing Students With Computers Best Practices

For Teachers 9th - 10th
Explore ideas on the best practices for integrating computer technology into your classroom. Investigate whole-class presentations, computer teams, independent work, and special issues and challenges in the computer classroom.
Lesson Plan
Science Education Resource Center at Carleton College

Serc: Simple vs. Compound Interest Spreadsheeting the Difference

For Teachers 9th - 10th
A lesson plan that includes a PowerPoint learning module for students. The goal of the instructional activity is to learn the difference between simple and compound interest and to use the functions in Excel to perform the calculations...

Other popular searches