Lesson Plan
Curated OER

Reading + Keyboarding= Success

For Teachers 3rd - 8th
Students practice their keyboarding skills. In this typing lesson, students use interesting stories to practice their skills. They practice throughout the semester and then monitor their improvement.
Lesson Plan
Curated OER

World Education Statistics

For Teachers 9th - 12th
Students use a spreadsheet from The Digest of Education Statistics and convert the statistics to percentages, and create a chart of their new data. Students discuss their findings about the disparities in educational spending among...
Lesson Plan
Curated OER

Level III: Technology Integration

For Teachers 4th
Fourth graders prepare two spreadsheets each with an embedded line graph that displays data about the growth of the bitter rot fungus on apples and on petri dishes that were stored in the refrigerator and the classroom. They prepare a...
Lesson Plan
Curated OER

Dental Detectives

For Teachers 1st
First graders explore the theme of dental health and hygeine. They make tooth loss predictions, count lost teeth, and graph tooth loss. In addition, they listen to dental health stories, read online stories, create spreadsheets, and play...
Lesson Plan
Curated OER

Buying Cars/Financing Cars Compound Interest

For Teachers 11th - 12th
Provide a real world context in which exponential functions are used to determine a eal world phenomena such as compound interest and exponential growth. This activity should be taught after students have mastered the laws of exponents...
Lesson Plan
Curated OER

Birds, Fractions and Percentages

For Teachers 6th - 12th
Students study fractions, percentages, spreadsheets, and computers by watching and recording the number of species of birdsseen. They create a spreadsheet to record the results of their one month study.
Lesson Plan
Statistics Education Web

Walk the Line

For Students 9th - 12th Standards
How confident are you? Explore the meaning of a confidence interval using class collected data. Learners analyze data and follow the steps to determine a 95 percent confidence interval. They then interpret the meaning of the confidence...
Lesson Plan
Curated OER

E-mailing the Chamber of Commerce

For Teachers 9th - 12th
Encourage effective internet research and e-mail correspondence as scholars investigate a US capital city they've never visited to find pertinent and relevant information. They begin by picking a city, then visit that city's chamber of...
Lesson Plan
Curated OER

Function Graphing--ID: 8252

For Teachers 9th
Those graphing calculators can be tricky; good thing Texas Instruments has devised a lesson on how to use their TI-Nspire calculator to graph functions. Kids investigate functional notation as they graph ordered pairs in the form (a,...
Lesson Plan
1
1
Curated OER

Irish Eyes: Taking a Look at Local Landscape

For Teachers 9th - 12th Standards
Direct your class’s attention to the elements that make their community unique. After examining sample travel brochures, groups select something from their community to use as the subject, and then research, create, and publish a...
Lesson Plan
Curated OER

Conversation Heart Graphing

For Teachers 6th
Sixth graders review the different types of graphs (bar, line, pictograph) They predict the data set they can garner several boxes of conversation hearts. Students record their data using an Excel spreadsheet. They create a graph based...
Lesson Plan
Curated OER

Iditarod

For Teachers 6th - 8th
For this Iditarod worksheet, young scholars complete word problems about fractions, money, and more, based on the Iditarod race. Students complete 10 problems.
Lesson Plan
1
1
Earth Watch Institute

Entering Local Groundhog Data in an Excel Spreadsheet

For Teachers 4th
Here is a cross-curricular ecology and technology lesson; your learners create spreadsheets depicting the location and number of groundhog dens in a local park. They research groundhogs and analyze data about where the groundhog...
Lesson Plan
Curated OER

Creating a Bar Graph Using a Spreadsheet: Dice Rolling Probabilities

For Teachers 10th
Tenth graders explore the concept of spreadsheets. They create a simple spreadsheet and chart from given data. Students perform basic formatting procedures on their chart. They use spreadsheet functions to perform calculations.
Lesson Plan
Curated OER

Embracing Diversity

For Teachers 9th - 12th
Young scholars explore and use different computer programs for collecting data. In this technology based lesson, students set up a survey and use the Excel and Lotus software to collect data.
Lesson Plan
Curated OER

Hot, Wet, and Cold

For Teachers 7th - 9th
Students research climate data for a city in each of the 5 major geographic sections of Texas. They use data to describe the climate and what influence the geography of that section has on the weather.
Lesson Plan
Curated OER

Graphs! Graphs! Graphs!

For Teachers 6th - 8th
Students practice making charts and graphs from data on spreadsheets. Individually, they create a graph representing the latest information on voter registration. They answer questions and analyze the data to end the lesson.
Lesson Plan
Curated OER

4 Month Budget Spreadsheet

For Teachers 8th
Eighth graders create and maintain a spreadsheet budget based on a predetermined salary. They have an opportunity to make "investments and purchases." Budget records be kept for an imaginary 4 month period.
Lesson Plan
Curated OER

Did Somebody Say...? Where to Work?

For Teachers 6th - 8th
Middle schoolers conduct research on four fast food restaurants to determine where they might apply for a job. They conduct research on hourly rate, working conditions, and benefits, construct a spreadsheet with a graph, and present...
Lesson Plan
Curated OER

Creating a Spreadsheet

For Teachers 8th - 10th
Students create a spreadsheet using ICT. In this algebra lesson, students collect and graph their data using a spreadsheet. They find solution to a given problem using trial and error.
Lesson Plan
Curated OER

Million Dollar Project

For Teachers 5th
Each student is given the task of spending $1 million. The way students spend their money is dependent on a theme such as "creating a dream world," "taking a trip," or "doing something to better society." Each student researches,...
Lesson Plan
Curated OER

Spreadsheet Project: Planning a Party

For Teachers 9th - 12th
Students create a spreadsheet and stay within a budget as they plan a class party for the next holiday.
Lesson Plan
Curated OER

And the Survey Says...

For Teachers 7th - 8th
Students use technology to input, retrieve, organize, manipulate, evaluate, and communicate information; apply appropriate technologies to critical thinking, creative expression, and decision-making skills. They collect and explore data...
Lesson Plan
Curated OER

The Hot Dog Stand

For Teachers 6th - 8th
Students run a computer simulation. They collect data as they work and use the data to create an annual report for their business. Several different simulations could be used for this project. It is desirable for students to do this...