Lesson Plan
Curated OER

How Do You Spend Your Time?

For Teachers 7th - 8th
Students keep records and determine how much time they spend on certain activities. They insert the data into a spreadsheet. Students graphically display data in a bar graph and a circle graph.
Lesson Plan
Curated OER

Geography Fieldwork River Study

For Teachers 8th
Eighth graders collect, record, and analyze data from a local river and input the data into the computer. They collect and record the information, discuss the data collected, and enter the data into a spreadsheet and charts to compare...
Lesson Plan
Curated OER

Charting the Heights

For Teachers 6th - 8th
Students enter data regarding the height of classmates into a spreadsheet. Formulas will also be entered to find the median, mean, and mode of the data.
Lesson Plan
Curated OER

Around and Around

For Teachers 6th - 8th
Young scholars create a spreadsheet to record information about circular objects. They measure and record information from a variety of objects. Students calculate the ratio of the circumference to the diameter of each object. They find...
Lesson Plan
Curated OER

Let's Go Camping

For Teachers 5th
Fifth graders plan a budget for a camping trip. They use a spreadsheet to organize the budget and word processing justification for their choices.
Lesson Plan
Curated OER

What About That Jazz?

For Teachers 6th - 8th
Students, with the help of the NBA Utah Jazz website, formulate how to use a database. In addition, they access how to copy and paste, and prepare a spreadsheet for later use. Students apply productivity/multimedia tools and peripherals...
Lesson Plan
Curated OER

Sweet Car Dreams

For Teachers Higher Ed
Students rebuild two different makes of cars. They calculate the cost of rebuilding the car. They create a spreadsheet to track their progress and costs.
Lesson Plan
Curated OER

United States Regions

For Teachers 5th
Fifth graders identify the regions of the United States. They gain general knowledge of Regions of the U.S., create a spreadsheet and use word processing to create a report.
Lesson Plan
Curated OER

Computer Science: Temperature

For Teachers 9th - 10th
Students conduct an experiment on heat transfer and how it works. They record the temperature in whatever environment is surrounding the container and run experiments that use at least two different ambient temperatures. Students...
Lesson Plan
Curated OER

Cloud Databases

For Teachers 7th - 9th
Students complete a unit on clouds and a report about one type of cloud. They collect data through observation about different types of cloud cover and then create a spreadsheet to reflect their observations over a 2 week period.
Lesson Plan
Curated OER

Getting to Know the Thirteen Colonies

For Teachers 5th
Fifth graders analyze information about the thirteen colonies. Using the information, they can manipulate and identify a region in which the colony is located. As a class, they make generalizations about the various regions and time...
Lesson Plan
Curated OER

Memory Game

For Teachers 6th - 9th
Students create cards for a memory game by entering data into a spreadsheet that is then merged into a word processing document. Tutorials are available through links on the lesson plan page.
Lesson Plan
Curated OER

Thanksgiving Feast

For Teachers 7th - 9th
Use the Tool Factory Workshop to have your class create a list of people to invite to their Thanksgiving Feast.They will take pictures related to the fall season and create invitations using Tool Factory Database. Students make a grocery...
Lesson Plan
Curated OER

Environmental Risk Analysis

For Teachers 9th - 12th
Students complete a survey and enter the responses in a spreadsheet. The spread sheet is used to create a bar graph. Students complete spreadsheets listing types of hazards in their community.
Lesson Plan
Curated OER

Interest Calculation and Spreadsheets

For Teachers 5th - 12th
Students, while in the computer lab working on a spreadsheet program, calculate interest and accumulated value of a savings plan. They follow specific directives on how to create their spreadsheets. At the end of the instructional...
Lesson Plan
Alabama Learning Exchange

Wet Heads

For Teachers 6th - 8th
Middle schoolers apply the steps of the scientific method to an experiment. They complete an instructional activity of scientific inquiry and use a spreadsheet software to create a graph illustrating data gathered.
Lesson Plan
Curated OER

All The Bell & Whistles

For Teachers 9th - 12th
Young adults are so eager to get that first cell phone. And, cell phones have so many cool extras! Learners conduct real-life research to determine which cell phone carrier offers the best deals on things like wall paper, ringtones, and...
Lesson Plan
Curated OER

The Ultimate Vacation

For Teachers 9th - 12th
Students use research skills to solve a problem. They research information needed to plan a vacation. Students create a letter, a flyer, an itinerary, an activity list, cost spreadsheet, a reference page, table of contents and a title page.
Lesson Plan
Curated OER

Caching in Pine's Treasures

For Teachers 6th - 12th
Students compile image information about the Junior High School using a digital camera. They survey the area making observations and recording them with the help of portable technology and transferring the data to a spreadsheet and...
Lesson Plan
Curated OER

Using Computers to Produce Spreadsheets and Bar Graphs

For Teachers 4th - 12th
Students review graphing terminology and how to plot data points, how to input data into a spreadsheet, and how to make a chart using a computer.
Lesson Plan
Curated OER

Forces of Flight - Lift

For Teachers 3rd - 8th
Students design and test paper airplanes to understand the concept of lift and how it affects flight. This technology-based Science instructional activity is excellent for use with upper-elementary and middle-level learners and uses...
Lesson Plan
Curated OER

Typhoon Project

For Teachers 9th - 11th
Students graph and outline the path of a typhoon. In this algebra lesson, students measure the path of the typhoon and create a graph with their data. They analyze the data and make predictions.
Lesson Plan
Curated OER

Variable Arrays

For Teachers 12th
Twelfth graders compare and contrast variables and arrays. Using data, they enter the information into a spreadsheet and an array to compare how they appear. To end the lesson, they complete basic programs in which they use arrays.
Lesson Plan
Curated OER

Taxes: Where Does Your Money Go?

For Teachers 9th - 12th
Students explore the concept of taxes. In this tax instructional activity, students investigate types of taxes and deductions taken out of a paycheck before they see it. Students calculate the tax on a given dollar amount. Students...