Browse lesson plans

ACC basketball

The students will use ACC basketball statistics to practice the process of converting fractions to decimals then to percents and will learn how to create and edit a spreadsheet. They will then use this spreadsheet to analyze their data. This unit is done during the basketball season.

Format: lesson plan (grade 6–8 Information Skills and Mathematics)

By Susan Dougherty.

Building a paper bridge: An introduction to problem solving

This activity allows the student to explore problem solving strategies while working with a partner. This activity (building a paper bridge), requires students to question word definition and the application of those definitions. Through problem solving strategies, students discover the need for applying math skills.

Format: lesson plan (grade 8 Mathematics)

By Steve Walston.

Collecting and organizing data

In this lesson students will learn to collect data and organize the data into a chart using computer technology.

Format: lesson plan (grade 3 Computer/Technology Skills, Information Skills, and Mathematics)

By Rochelle Mullis.

Dear Tootsie Roll company

The students will measure the surface area and wrapper area of five pieces of candy. Using appropriate formulas and measuring techniques, they will complete information needed for a spreadsheet and database. Students wrap up the lesson by writing a letter to the company with the most wasted paper to explain how the waste affects them as consumers and a suggestion for correcting the problem.

Format: lesson plan (grade 7–8 English Language Arts and Mathematics)

By Tonya Thompson.

Healthy and unhealthy foods: What's the difference? (Part 1)

In I’m on a diet and proud of it: Nutrition through math and science, page 6

In this lesson, students build scientific models to help them conceptualize the energy (calorie) to nutrient ratio provided by various types of carbohydrates, thereby discovering complex carbohydrates and lean protein as being the superior choices.

Format: lesson plan (grade 4 Healthful Living, Information Skills, and Science)

By Karina Colón.

I’m on a diet and proud of it: Nutrition through math and science

In this unit, students will be involved in hands-on, inquiry activities that integrate various subject areas in order to learn and apply concepts of food chemistry and nutrition.

Format: lesson plan (multiple pages)

Integrated unit on South America

This lesson includes information concerning database operations, word processing, desktop publishing, and spreadsheet formatting. Students will solve math problems.

Format: lesson plan (grade 6–7 Computer/Technology Skills, English Language Development, Mathematics, and Social Studies)

By DPI Integration Strategies.

Interdisciplinary Integrated Unit on DNA/Genetics Part B: Math

The second lesson of an interdisciplinary integrated unit on DNA and genetics, focusing on math. The other lessons in the unit focus on science and language arts.

Format: lesson plan (grade 6–7 Computer/Technology Skills and Mathematics)

By Jane Lentz, Jimmy White, Marlene Smith, and Tori Goldrick.

Ohm's Law made easy with a spreadsheet

In this lesson, students will use math word problems to help them input information into a spreadsheet that will use Ohm's law to calculate current and resistance using common household appliance wattages.

Format: lesson plan (grade 6–9 Computer/Technology Skills, Mathematics, and Science)

By Hilda Hamilton.

Using percent of change to measure growth in North Carolina

Students will work in small groups to use the internet to gather data on the population growth for each of the 100 counties in North Carolina from 1992 to 1995. From these data, students will find the percent of increase/decrease for the counties they have been assigned. As a follow-up, the students will enter their data into a computer spreadsheet and from that spreadsheet, produce graphs of the information.

Format: lesson plan (grade 7–8 Information Skills, Mathematics, and Social Studies)

By Wanda Washburn.

Resources on the web

Collecting, representing, and interpreting data using spreadsheets and graphing software: Collecting and examining weather data

Spreadsheets and graphing software are tools for organizing, representing, and comparing data. This activity illustrates how weather data can be collected and examined using these tools. In the first part, Collecting and Examining Weather Data, students... (Learn more)

Format: lesson plan (grade 5 Computer/Technology Skills, Mathematics, and Science)

Provided by: Illuminations