Department of Defense
Do Dea: M1: L4: Starting Here, Starting Now! Beginning a Spreadsheet
In Module 1 Lesson 4 of this course on spreadsheets, students create their first spreadsheet using Microsoft Excel. Includes slideshow tutorials.
Science Education Resource Center at Carleton College
Serc: Creating a Household Budget
In this Spreadsheets Across the Curriculum PowerPoint module, students create a household budget by tracking their expenditures over a month-long period. Students use Microsoft Excel to create a spreadsheet to track their own...
Department of Defense
Do Dea: Spreadsheet Software: M6: L4: Show Me Your Skills: Practice Skills
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...
Department of Defense
Do Dea: Spreadsheet Software: M2: L5: Show Me Your Skills: Practice Skills
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...
Georgia State University
Georgia State University: Creating Spreadsheets Using Ms Excel
This Georgia State University site gives in outline form the basic principles of using spreadsheet software. At the end of the outlines, specific uses for spreadsheets in recordkeeping are suggested.
Department of Defense
Do Dea: Spreadsheet Software: M2: L1: From the Ground Up: Create Basic Formulas
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.
National Council of Teachers of Mathematics
The Math Forum: Spreadsheet Basics
A simple introduction on how to create a spreadsheet.
Other
Making a Word Find With Microsoft Excel
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.
Department of Defense
Do Dea: Spreadsheet Software: M5: L3: Customization: Modifying a Worksheet
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.
Alabama Learning Exchange
Alex: Creating a Payroll Spreadsheet
Spreadsheet software allows you to calculate numbers arranged in rows and columns for specific financial tasks. This activity allows students to create an "Employee Work/Pay Schedule" spreadsheet to reinforce spreadsheet skills. Students...
Utah Education Network
Uen: Design Your Own Bedroom
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...
The Franklin Institute
Frankin Institute Online: Group Graphing
This site from The Franklin Institute explores how to make a simple graph using a spreadsheet to portray survey data. It also gives a set of interesting sports-related web sites so that students can get statistical inforamtion.
Alabama Learning Exchange
Alex: How Much Will This Lifestyle Cost?
Students will create a detailed monthly budget using a spreadsheet. The budget will depend on an individual's earning potential as determined by career choice and education. This is a project-based, Commerce and Information Technology...
Google
Google for Education: Energy Analysis
Students collect data on energy production and consumption around the world. They input the data into a spreadsheet and use spreadsheet functions to analyze it. Finally, they upload the data into a fusion table to create a visualization.
PBS
Pbs: Personal Spending Spreadsheet
This activity helps students create their own personal spending plan.
Google
Google for Education: Energy Analysis
By creating a spreadsheet, students can learn more about energy production and consumption around the world. Students have to research the data to be analyzed in the spreadsheet. An example of the spreadsheet is given in this lesson plan.
Alabama Learning Exchange
Alex: French Internet Clothes Shopping
Students practice clothing vocabulary and computer spreadsheet skills by visiting authentic French online clothing catalogs. They choose articles of clothing for purchase for themselves and family members and create a spreadsheet to...
Science Education Resource Center at Carleton College
Serc: Westward Ho! How Far Is Yonder Mountain
In this activity quantitative skills in geologic context are reinforced. Students create a spreadsheet to calculate the distance of a peak using vertical angles sighted from a wagon train heading directly for the peak. The spreadsheet...
Texas Instruments
Texas Instruments: Numb3 Rs: Up to Speed
Based off of the hit television show NUMB3RS, this lesson builds upon the familiar d=rt formula for distance to include elements of acceleration as well. The lesson is framed in the context of traffic flow theory, but makes some very...
Other
Tonya Skinner Business Ed Lesson Plans: Grocery Shopping
This personal site provides a student activity that allows learners to plan a class party while organizing the budget details in a spreadsheet program. Learners will demonstrate computer skills in inputting data, formatting data, and...
TeachEngineering
Teach Engineering: Measuring G
Using the LEGO MINDSTORMS NXT kit, students construct experiments to measure the time it takes a free falling body to travel a specified distance. Students use the touch sensor, rotational sensor, and the NXT brick to measure the time of...
Texas Instruments
Texas Instruments: Grandparents and Special Friends Day
This lesson was designed for our Grandparents and Special Friends day. It can be used for any visitation day, or an open house. The lesson is designed to review percent of a whole and the sector of the circle representing the percentage....
Science Education Resource Center at Carleton College
Serc: Mn Step: Statistical Analysis of Lincoln
For this activity, students first work in groups to collect information about a set of pennies. They measure and record the mass for each one in a table using a spreadsheet program if possible. They also record its year and, for 1982...
Other
Personal: Let's Go Shopping
This personal site provides a student activity that allows learners to practice spreadsheet skills in inputting data and creating function formulas. The activity is based on the collection and comparison of shopping receipts using max,...