Curated OER
Weather
Students create a spreadsheet and chart using data collected. In this weather lesson, students select five cities from their state, including the city they live in. Students take daily temperature readings from all five cities. ...
Curated OER
Carbon Dating
Simulate C-14 decay using M&M and Reese's Pieces candies. In this scatter-plot lesson, students perform an experiment to simulate the half life of C-14. Information is plotted on a scatter-plot. Students answer four comprehension...
Curated OER
Home Sales Records
Teach your class how to calculate monthly payments on a home mortgage. In this percent instructional activity, students calculate the monthly payment on a home mortgage, and compare different lengths of time and the interest rates for...
Curated OER
Money Math: Lessons for Life
Students develop a budget for a college student using all of the influences that the student would have. In this budgeting lesson plan, students use real life examples to create a budget spreadsheet. Students read and study sample...
Curated OER
Endangered Species
In this geography learning exercise, students identify how to manipulate data on a range of endangered species. They create a bar graph of endangered animals from Africa, Asia, Australia, North America, or South America. Students use a...
Curated OER
Which Amusement Park Would You Choose?
Learners analyze data related to amusement parks and create a spreadsheet to display the data. They read the data and predict which amusement park they think is safer, create a spreadsheet and graph, and write a proposal based on their...
Curated OER
Sales Spreadsheet
Students use Excel spreadsheets to organize purchases, discounts, sales prices, and sales tax. Students follow step by step instructions and enter formulas as well as use the auto sum feature to calculate required calculations.
Curated OER
Using Excel, the Internet, And Word To Create a Spreadsheet, Chart, And Instructions
Students improve data entry in a spreadsheet.
Curated OER
State Economy Chart
Fifth graders research and record statistics on the economy of an assigned state. They create a spreadsheet in Excel to report the data and a 3D Pie graph using the Chart Wizard in Excel to represent their states' data.
Curated OER
Graphing Favorite Fruit
Third graders take poll and sort data, enter the data to create a spreadsheet and create bar and pie graphs.
Curated OER
Microsoft Office Excel
Middle schoolers use Microsoft Office Excel. In this technology lesson plan, students enter data on a spreadsheet using Excel. This programs tallies data and presents it using graphs.
Curated OER
Lesson 5: Designing an Experiment
The intent of this lesson is to introduce young scientists to the steps of the scientific method. To this end, they consider the question, "Which brand of battery lasts longest?" In this case, the experiment is carried out as a class,...
Curated OER
Shopping Around
Third graders select a recipe and compare prices for ingredients at two different stores. They select the best place to buy the ingredients and answer questions about the process. They include their data on a spreadsheet related to their...
Curated OER
Microsoft Access Lesson Plan
Third graders read children's literature during the school year and compile a list of books and genres in an Access database. They print out a report of all the different books and genres of they read over the whole school year.
Curated OER
What are they like Today
Sixth graders compare the modern day countries that exist in the areas they study in Ancient History. They use a spreadsheet on the computer to organize data that includes population of the countries, along with other various types of...
Curated OER
Kindergarten Class Favorites
Students discuss their favorite foods, a list of four favorite food are compiled on the board or a chart. They each vote for their favorite food and the data is entered onto a spread sheet and a graph is created while the students watch...
Curated OER
Spreadsheet Function Machine
Students create a spreadsheet to analyze functions. In this algebra lesson, students use spreadsheets to find the intersection of systems of equations. They identify the dependent and independent function as it relates to a line.
Curated OER
Using a Spreadsheet
Students create a spreadsheet to analyze data. In this technology activity, students develop and use an Excel spreadsheet to log their data. They solve real life word problems as they set it up using the spreadsheet.
Curated OER
Investing
Students collect data on investments and draw conclusions. In this algebra lesson, students analyze exponential graphs as they relate to money. They discuss the cause of an account balance being high or low.
Curated OER
Don't Lose Your Load!
Pupils create graphs using collected data. In this algebra lesson, students use spreadsheet in Excel to create graphs to interpret their data and make predictions. They rewrite word problems using algebraic expressions.
Curated OER
Measuring and Observing Weather Phenomena
In this weather instructional activity, students take the temperature and record data over a period of time of 1 month. Students then make a spreadsheet of their data and include variables that contribute to the weather.
Curated OER
Computer Skills
Students research computer information and use it to find the mean of things. In this computer skills instructional activity students are given activities in which they calculate and use a spreadsheet to enter data on the mean of their...
Curated OER
Making a Spreadsheet
Students explore spreadsheet software. In this personal finance and computer technology lesson, students develop a vacation spreadsheet on the computer. Students represent hotel, food, transportation, and entertainment costs on a graph...
Curated OER
Checking Test Comparability/Scattergrams
Students construct a scattergram graph. In this statistics lesson, students graph data by hand and using a spreadsheet program. They establish lines of best fit and draw conclusions using their graphs.