Lesson Plan
Curated OER

ICT Activity 17

For Teachers 8th
Eighth graders use a spreadsheet for the first time. They work on a selected environmental issues as their theme. Students prepare costs or income for an event that raises money for an environmental issue. They use the costs and income...
Lesson Plan
Curated OER

And the Winner Is...

For Teachers 3rd
Third graders participate in an election project. They collect data to create a spreadsheet from which a graph is generated.
Lesson Plan
Curated OER

Number and Algebra: Again and Again

For Teachers 5th - 9th
Students use a given spreadsheet to investigate an iterative process by changing the variables. They design their own spreadsheet to investigate the iterative process.
Lesson Plan
Curated OER

Sorting

For Teachers 4th - 6th
Students examine how sorting is the process of putting things into an orderly sequence based on some key value. In this lesson students create a spreadsheet with 26 rows of data, then sort those rows by different values.
Lesson Plan
Curated OER

Put Your Heart Into It

For Teachers 1st
First graders sort Valentine candies according to kind. Data is inserted into a spreadsheet and displayed in various graphic formats.
Lesson Plan
Curated OER

"Favorite Fairy Tale Characters"

For Teachers 3rd
Third graders enter the results of their survey on a spreadsheet. They construct a bar graph showing the results.
Lesson Plan
Curated OER

Creating a Nutrition Table in MicroSoftExcel

For Teachers 6th - 8th
Students access the internet to find Nutritional information from a restaurant of their choice and compile their information into an excel spreadsheet.
Lesson Plan
Curated OER

Spreadsheet Activity

For Teachers 7th - 8th
Young scholars create a spreadsheet to match a given sample. This includes adjusting column width and row height, changing alignment, changing size and style of print, changing number format.
Lesson Plan
Curated OER

How is Your Driver Doing?

For Teachers 6th
Sixth graders explore the concept of averaging of numbers and the function of a spreadsheet. Data is collected, analyzed, and displayed in this lesson. The NASCAR race results provides the basis for the collection of data.
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

Cannot Buy Me Love

For Teachers 6th - 9th
Students investigate the concepts that are related to finance and how it is used in the world. They take part in activities that are focused around the use of a spreadsheet while using a T-chart to simulate a ledger of credits and debits.
Lesson Plan
Curated OER

Your Just Desserts

For Teachers 6th - 8th
Middle schoolers write letters to town officials and local businesses asking for favorite dessert recipes. They tabulate their responses in a spreadsheet. Students turn their survey results into colorful graphs.
Lesson Plan
Curated OER

Society, Cyberspace and the Future

For Teachers 6th - 7th
Students locate information on the rapid growth of world population and consumption needs through the use of Internet, Cd-ROMs, laser dics and other media. They use spreadsheet to present data gathered on world population growth between...
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

Let's Keep Track of Grades

For Teachers 7th - 8th
Students participate in a technology project. This lesson is a hands-on spreadsheet project where students are responsible for keeping track of their grades for class. The students learn to enter data into a spreadsheet, create...
Lesson Plan
Curated OER

ACC Basketball Statistics

For Teachers 6th - 8th
Students use math skills and create a spreadsheet. In this statistics and computer skills lesson, students gather ACC basketball statistics, convert fractions to decimals and then percents. Students use the gathered information to create...
Lesson Plan
Curated OER

Party Math

For Teachers 10th - 12th
Students create a spreadsheet that they will use to plan a small party or outing. They calculate expenses and stay within a budget amount for their party.
Lesson Plan
Curated OER

Management of Wildlife Resources

For Teachers 10th - 12th
Students investigate how wildlife management policies affect the size of large animal populations. They develop a spreadsheet that incorporates a mathematical model to predict big game herd sizes, and using worksheet data manage a bison...
Lesson Plan
Curated OER

A "Capital" Idea

For Teachers 8th
Eighth graders prepare for a field trip to Washington, DC by researching landmark, monument, or building in Washington. They use the information in small groups to design a multimedia presentation. They include a spreadsheet that shows...
Lesson Plan
Curated OER

Straw Breathing Exercise

For Teachers 9th - 12th
Students fill out an anonymous questionaire to explore whether they might have asthma. They then set up a spreadsheet to enter the data, decide on a definition of asthma, and figure out the prevalence of asthma. Pupils simulate what it...
Lesson Plan
Curated OER

Building My Dream House

For Teachers 7th - 8th
Young scholars create their dream house using a spreadsheet for measurements. In this measurements and drawings lesson plan, students apply concepts of units and conversions as they build and create different shapes. They use Google...
Lesson Plan
Curated OER

EXCEL It!

For Teachers 5th - 8th
Students surf the Web gathering information about graphs. The data collected is incorporated into an Excel spreadsheet and graphs of varying nature generated to further enhance student understanding.

Other popular searches