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
Middle schoolers 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
Students 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
Young scholars 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...
Lesson Plan
Curated OER

Your Just Desserts

For Teachers 6th - 8th
Students 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 activity 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
Learners 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
Students create their dream house using a spreadsheet for measurements. In this measurements and drawings lesson, students apply concepts of units and conversions as they build and create different shapes. They use Google Sketch-up...
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.
Lesson Plan
Curated OER

Heat of an Unknown Metal

For Teachers 8th
Eighth graders complete labs to find the specific heat of many different types of substances, and use characteristic property to identify an unknown metal. CBL be used to determine energy lost or gained, and students complete a...
Lesson Plan
Curated OER

Using Excel To Teach Probability And Graphing

For Teachers 3rd - 8th
Students engage in the use of technology to investigate the mathematical concepts of probability and graphing. They use the skills of predicting an outcome to come up with reasonable possibilities. Students also practice using a...
Lesson Plan
Curated OER

Don't Settle for a Byte... Get the Megabyte on Technology

For Teachers 4th - 12th
Students use word processing, presentation, and spreadsheet software. In this multi-day computer software usage lesson, students complete a research project that requires the use of a word processor, Excel, FrontPage, and PowerPoint to...
Lesson Plan
Curated OER

Accounting

For Teachers 10th - 11th
Students create bank reconciliation spreadsheet. In this algebra lesson, students discuss the basics about business, money and bank accounts. They use a bank reconciliation statement correctly.

Other popular searches