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.
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.
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: 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.
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...
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.
Department of Defense
Do Dea: Spreadsheets: M1:l3: Operating System and Spreadsheet Applications Screen
In Module 1 Lesson 3 of this course on spreadsheets, students begin learning how to use Microsoft Excel to create spreadsheets. Slideshows walk them through how to navigate the menus and tools of Excel.
National Council of Teachers of Mathematics
The Math Forum: Spreadsheet Basics
A simple introduction on how to create a spreadsheet.
PBS
Pbs: Personal Spending Spreadsheet
This activity helps students create their own personal spending plan.
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 learners to create an "Employee Work/Pay Schedule" spreadsheet to reinforce spreadsheet skills. Students...
Google
Google for Education: Energy Analysis
Young scholars 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...
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.
Science Education Resource Center at Carleton College
Serc: Westward Ho! How Far Is Yonder Mountain
In this lesson quantitative skills in geologic context are reinforced. Young scholars create a spreadsheet to calculate the distance of a peak using vertical angles sighted from a wagon train heading directly for the peak. The...
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...
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
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.
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,...
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...
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...
Goodwill
Gcf Global: Excel Formulas: Functions
A function is a predefined formula that performs calculations using specific values in a particular order. All spreadsheet programs include common functions that can be used for quickly finding the sum, average, count, maximum value, and...
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.
Computer Hope
Computer Hope: Tips Relating to Microsoft Excel
A listing of various tips that can be used with Microsoft Excel. Find out ways to work better and more efficiently with this spreadsheet program.
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...