+
Lesson Plan
Curated OER

Building Arrays Using Excel Spreadsheets

For Teachers 3rd - 5th
Students create arrays using Microsoft Excel. In this technology-based math lesson, students expand their knowledge of multiplication by creating arrays on the computer using a spreadsheet program such as Microsoft Excel.
+
Lesson Plan
Code.org

Introduction to Data

For Teachers 9th - 12th
Data, data everywhere. Challenge your class to begin thinking about data, the ways people collect information, and what we can learn from this data. Class members discuss sources of data and then individuals answer questions in the class...
+
Lesson Plan
Curated OER

Pets Galore!

For Teachers 4th
Fourth graders conduct a class survey on the number of pets that the 4th grade owns and they record that data in their math notebooks. They make a bar graph displaying the results using a spreadsheet through Microsoft Excel.
+
Lesson Plan
Curated OER

Technology - Data Collection

For Teachers 8th - 10th
Learners collect and analyze data from the United States Census Bureau. Using spreadsheet technology, students explore their results and make preductions about income groups. Learners compute the mean, median and mode. They create...
+
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

Fish and Clips

For Teachers 1st - 2nd
Youngsters test magnetic strength by measuring the mass of paper clips that they "hook" with a magnet. Your first and second graders should love the hands-on activities associated with this plan. The reproducible materials are quite good...
+
Lesson Plan
Curated OER

This Little Light of Mine

For Teachers 3rd - 5th
Elementary schoolers discover how electricity travels and create an electron flow through a closed circuit. They work together to make a closed circuit and observe the electricity being made. This outstanding lesson plan is well worth...
+
Lesson Plan
Curated OER

Get My Point!

For Teachers 3rd - 7th
Here is one of the better lessons I've come across on how to teach fractions and decimals. This lesson plan does a great job of showing how these two mathematical representations of numbers are interrelated. Some excellent websites,...
+
Lesson Plan
Curated OER

ABC, Easy as 123

For Teachers K
Kindergartners practice identifying the sight and sounds of vowels and consonants. They identify beginning consonants in single-syllable words and print the letters of the alphabet. This outstanding resource has many excellent...
+
Lesson Plan
Curated OER

Fill In The GAPP

For Teachers K - 1st
Youngsters discover what recycling is and identify things that can be recycled. They use both video and Internet resources to aid them in their study. This is a well-designed instructional activity with excellent activities and a...
+
Lesson Plan
Curated OER

Introduction Lesson to the Book Where the Red Fern Grows

For Teachers 4th - 6th
An excellent lesson plan on the classic book, Where the Red Fern Grows. Learners view the W. Wilson Rawls website and engage in a series of activities generated by the website. They write in their reflective journals, watch a video, and...
+
Lesson Plan
Curated OER

Current Sources of Energy to Maintain a Sustainable Future

For Teachers 4th
In small groups, fourth graders identify different sources of renewable and non-renewable energy. They research the pros and cons of using each of these resources. They rank household appliances according to energy usage and efficiency....
+
Lesson Plan
Curated OER

Exploring Careers

For Teachers 7th
Seventh graders investigate their career aptitudes and interests through a scavenger hunt. They display their choices in Excel spreadsheets.
+
Lesson Plan
Space Awareness

Navigation in the Ancient Mediterranean and Beyond

For Teachers 9th - 11th Standards
Ancient texts, like Homer's Odyssey, mentions navigating ships by observing constellations. Pupils learn about the link between history and astronomy as they relate to navigation in the Bronze Age. Scholars complete two hands-on...
+
Lesson Plan
Curated OER

Food for Thought

For Teachers 3rd
Third graders conduct a survey of their class' favorite foods voting on 3-4 favorites overall. They then go to the computer lab and examine how to produce a horizontal bar graph by graphing the favorite foods of the class.
+
Lesson Plan
Curated OER

This is the Way We Go To School

For Teachers 2nd
Second graders create and utilize a graph using the Excel computer program. They gather data regarding how the students get to school, tally the numbers for the class, and create a bar graph on paper and using Excel.
+
Lesson Plan
Curated OER

Intro to PowerPoint-with KidPix Pictures

For Teachers 3rd - 6th
Young scholars construct a four sentence creative story by using KidPix software. In this computer technology lesson, students use KidPix software to develop slides about themselves, their family, and their house. Young scholars...
+
Lesson Plan
Curated OER

Making a Spreadsheet

For Teachers 5th - 8th
Learners explore spreadsheet software.  In this personal finance and computer technology instructional activity, students develop a vacation spreadsheet on the computer.  Learners represent hotel, food, transportation, and entertainment...
+
Lesson Plan
Curated OER

Divisibility Rules

For Teachers 8th
Eighth graders explore Excel and discover rules of divisibility for the numbers 2, 3, 4, 5, 6, 9, and 10; students examine multiples of 2 using pencil/ paper, then create a chart in Excel that will allow them to more easily see patterns...
+
Lesson Plan
Curated OER

Counting Coins

For Teachers 2nd
Second graders identify a quarter, dime, penny, nickel, and dime. They match the coin with it's monetary value, collect data on excel spreadsheet, and create a graph in Excel. Students participate in group activities.
+
Lesson Plan
Curated OER

A Comparison Study of Water Vapor Data to Precipitation over North America

For Teachers 10th - 12th
Students use NASA satellite data to compare water vapor over the United States.  In this data analysis lesson students use an Excel spreadsheet to map their data. 
+
Lesson Plan
3
3
Chicago Botanic Garden

Calculating Your Carbon Footprint

For Teachers 10th - 12th Standards
Unplugging from technology for one day per week will decrease your carbon footprint—are you up to the challenge? Part two in a series of three allows individuals to explore their personal carbon footprints. By first taking a quiz at home...
+
Lesson Plan
Curated OER

Exploring Biomes Lesson 2: Biome Research

For Teachers 6th - 10th
Learners view a PowerPoint presentation on biomes and their classifications. Divide them into groups and assign them each an individual biome to research. There are pictures of the PowerPoint slides and notes about what to teach for...
+
Lesson Plan
Curated OER

Visit My Class Wikis

For Teachers 4th - 7th
Students visit the links on the blog site to learn about class wikis. In this technology integration lesson, students visit the links to view class wikis.