Curated OER
The Joy of Giving
Children identify wants and needs, bake and sell cookies to raise money, and then go to the mall to purchase gifts for Christmas stockings that are donated to the Salvation Army. They then perform Graphing activities to help children...
Curated OER
Integration and the "Barrier Breakers": Black Baseball 1945-1960
Students explore integration of Major League Baseball, identify important individual baseball players who played key roles in integration, and analyze historical information through charts, graphs, and statistics.
Curated OER
Exploring Technology in Careers
Learners discover how technology is used in the workplace. In this careers lesson, students compare and contrast careers and how technology is incorporated into each of them. Learners set goals to achieve their ideal career.
Curated OER
Graphing Weights and Measures
Learners practice gathering, averaging, and graphing data. They practice converting measurements to the metric system. Students graph their results and present them to the class.
Curated OER
Slopes, Hopes, & Speed
Students investigate the sport of skiing through Internet research in this multi-task lesson. They compare and generalize the results of five individuals by using mean, median, and mode.
Curated OER
Ballistic Pendulum Lab
Students determine the muzzle velocity of projectile launcher. In this physics lesson, students compare the pendulum method and kinematic method in calculating the initial velocity. They analyze data and discuss results in class.
Curated OER
How Are Students Doing on the AP exams?
Young scholars compile and analyze data pertaining to College Credit AP Exams. They pose questions - Which exam is the easiest? - determine answers from their data and display their results.
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...