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...
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
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...
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...
Other
Think Free Office
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...
Goodwill
Gcf Global: Excel Formulas
In this interactive tutorial, learn how to create formulas to solve real-world problems.
Goodwill
Gcf Global: Excel Formulas: Simple Formulas
One of the most powerful features in Excel is the ability to calculate numerical information using formulas. Just like a calculator, Excel can add, subtract, multiply, and divide. In this lesson, we'll show you how to use cell references...
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
Laus Dnet: Grade 5 Excel Lesson Plan
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...