+
Lesson Plan
Curated OER

Comuter Technology-Applying Spreadsheet Information

For Teachers 9th - 12th
Students create spreadsheets and practice sorting within the spreadsheet with three different activities. Students manipulate different materials such as addresses, real estate sales, and athletic participation numbers.
+
Lesson Plan
Curated OER

Twelve Days of Christmas

For Teachers 6th - 8th
Learners create charts and graphs using a spreadsheet. They chart the number of each gift given day by day from the song, "The Twelve Days of Christmas." They create a bar graph and a circle graph from their data on the spreadsheet.
+
Lesson Plan
Curated OER

What Colors Are Your Skittles?

For Teachers 9th - 12th
Students record the numbers of each color in their own Skittles. They compare their results with their partner. Students create a spreadsheet to chart the different colors found in a package of Skittles. They create a PowerPoint...
+
Lesson Plan
Curated OER

Keypals and You

For Teachers 6th - 12th
Students collect and compare data received from keypals. They use electronic mail to exchange information with keypals and rrite a paper comparing similarities and differences between themselves and their keypals. In addition, use a...
+
Lesson Plan
Curated OER

What Color Are Your Skittles?

For Teachers 7th - 10th
Students create spreadsheets and manipulate data. They collect data, create appropriate graphs and use percentages to describe quantities. Students compare and contrast data. They use spreadsheets to generate a pie chart.
+
Lesson Plan
Curated OER

Geoboard Area

For Teachers 3rd - 6th
Students explore the basic geometric shapes and geometric shape vocabulary through the use of geoboards and virtual geoboards. They create a variety of shapes with a partner, build ten different rectangles on their geoboards, and...
+
Lesson Plan
Curated OER

Great Graphing

For Teachers 7th - 8th
Young scholars collect data, use a computer spreadsheet program to create various graphs, and compare the graphs. They state the findings of each graph in writing and decide which graph type best represents the data.
+
Lesson Plan
Curated OER

State Economy Chart

For Teachers 5th
Fifth graders research and record statistics on the economy of an assigned state. They create a spreadsheet in Excel to report the data and a 3D Pie graph using the Chart Wizard in Excel to represent their states' data.
+
Lesson Plan
Curated OER

Time Management

For Teachers 6th - 9th
Students plot activities for a 24 hour day. They record their information on a spread sheet program. Students list categories they use and write equations for cells that add cells of each category together. Students create a pie chart of...
+
Lesson Plan
Curated OER

Battery Power

For Teachers 6th
Sixth graders examine how much energy they use in the form of battery power. They examine the cost of using regular vs. rechargeable batteries and examine the effect on the environment of the two types of batteries. They discover that...
+
Lesson Plan
Curated OER

Pumped Up Gas Prices

For Teachers 3rd - 6th
Students calculate gas prices. In this transportation lesson plan, students tally the mileage and gas costs of their car for one months. They figure out how much was spent on gas and create a graph showing average gas prices over time. 
+
Lesson Plan
Curated OER

Shop 'Til You Drop

For Teachers 3rd - 5th
Students evaluate food prices. In this real world math lesson plan, students compare the cost of various grocery items to determine which is the best deal. They work in groups using grocery ads to decide how to get the most product for...
+
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

Exploring our Community

For Teachers 4th - 8th
Students research Los Angeles and its surrounding communities. They create digital presentations of the information they have gathered by answering the question included in the lesson.
+
Lesson Plan
Curated OER

Our Favorites

For Teachers 6th - 7th
Learners participate in and conduct a survey to determine various class favorites. They collect, organize and display their data, interpret the results, and complete a packet of worksheets to display the information.
+
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

Macbeth Madness

For Teachers 10th - Higher Ed
Students research Macbeth online and complete computer and graphing activities for the play. In this Macbeth activities lesson, students research Macbeth and bookmark the URL's. Students complete activities for the topic on spreadsheets...
+
Lesson Plan
Curated OER

Who is Coming to Our House?

For Teachers 9th - 12th
Students examine waves of immigration that affected the development of the United States, appreciate variety of countries of origin of immigrants, analyze immigration data, discern patterns in data and communicate finding to classmates,...
+
Lesson Plan
Curated OER

The Seasonal Round and The Cycle of Life

For Teachers 4th
Fourth graders are introduced to the concept of the seasonal round and how folklife traditions vary from season to season. They begin charting dates of personal interest on seasonal round calendars by starting with birthdays. Students...
+
Lesson Plan
Curated OER

Fast Food Fun

For Teachers 4th - 6th
Students use technology to input, retrieve, organize, manipulate, evaluate, and communicate information to find calories and fat in a typical fast food meal. They decide which fast food restaurant you would like to visit and click on...
+
Lesson Plan
Curated OER

Fabulous Fossils

For Teachers 7th
Seventh graders investigate how fossils are formed and discuss how scientists determine the appearance of ancient plants and animals. They make fossils of everyday objects for others to identify. They make spreadsheets to display fossil...
+
Lesson Plan
Curated OER

The Media and You

For Teachers 7th
Seventh graders discuss the main purposes of media. Using various advertisements, they identify the method used by the advertisers in each example. They use these methods to create and sell their own product to the class. They use the...
+
Lesson Plan
Curated OER

The Snack Bar

For Teachers 6th
Sixth graders complete a purchase order. In this ratios and patterns instructional activity, 6th graders work in groups to complete a purchase order for a grand opening of the school snack bar. Students use rations to figure out the need...
+
Lesson Plan
Curated OER

GeoHunt

For Teachers 7th - 8th
Students describe the difference between geological resources and othe natural resources. They list the rocks, minerals, and fossil fuels that are found in Illinois and their uses. They identify ways to conserve natural resources.