Lesson Plan
Curated OER

Using Database to Organize Information

For Teachers 5th
Fifth graders collect information about an assigned topic. They organize data by using a database.
Lesson Plan
Curated OER

Native American Unit: Using One Computer to Record Data

For Teachers Higher Ed
Students explore methods to manage a classroom with one computer. Prospective teachers observe a video of students collecting information on Native American tribes. They discuss the use of white boards and electronically recording...
Lesson Plan
Curated OER

States with Attitude, Latitude and Longitude Dude

For Teachers 6th
Sixth graders identify states whose boundaries are formed by lines of latitude and longitude or natural borders such as rivers. They trace a map of the U.S., and fill in borders, rivers and lines of latitude and longitude.
Lesson Plan
Curated OER

The Golden Door: U.S. Immigration Through Ellis Island

For Teachers 5th - 6th
Students complete a unit covering various aspects of immigration to the United States through Ellis Island. They plan a fictional trip to America, entering at Ellis Island. and actually visit Ellis Island and the Statue of Liberty.
Lesson Plan
Curated OER

Traveling Across America

For Teachers 8th - 12th
Students plan a trip to a state capital of their choice with a budget of $2,000. The budgets include site seeing, lodging, food and all necessary expenses. Students keep a daily journal and maintain their budget.
Lesson Plan
Curated OER

Classifying Organisms within Kingdoms

For Teachers 9th - 12th
Students examine animal kingdom classifications. They discuss how animals are placed into kingdom classifications and compare similarities and differences of animals within a kingdom.
Lesson Plan
Curated OER

Book Report Database and Author E-mail Project

For Teachers 2nd - 3rd
Students read a number of books by a given author and input information into a database. They e-mail information about their favorite author to other students. They focus on story elements and ask questions or make suggestions for future...
Lesson Plan
Curated OER

Saving An Endangered Species

For Teachers 2nd
Second graders work in groups in order to look at specific internet sites for animal adoption and sponsorship. They select an endangered species, determine needed funds, develop, advertise, and carry out a fund-raising plan.
Lesson Plan
Curated OER

Advertising

For Teachers 6th - 8th
Learners listen to a guest speaker about the different types of advertising. Using research materials, they discover the laws about copyrighting material. They visit foreign websites to view their advertising and discuss how it is...
Lesson Plan
Curated OER

Checking County Numbers

For Teachers 4th - 8th
Learners use their county's information page to gather information about their community. Using the information, they create graphs from the tables provided and interpret the data. They write a paragraph showing their interpretation of...
Lesson Plan
Curated OER

You Be The Judge: Olympics, Winter Sports, Figure Skating, Math, Statistics, Technology

For Teachers 6th - 8th
Middle schoolers design a score sheet for use when watching a figure skating performance. They use spreadsheet software and research information obtained on the Internet to create their score sheets.
Lesson Plan
Curated OER

Composting

For Teachers 8th
Eighth graders collect data from Bottle Biology compost columns and record using Excel spreadsheet.
Lesson Plan
Curated OER

Fraction Strips on Excel

For Teachers 6th
Sixth graders create three different sets of fraction strips using Excel by following a packet of instructions that taper off as the students gain confidence in their knowledge of Excel. They copy and paste the strips into Word so that...
Lesson Plan
Curated OER

Code Crackers

For Teachers 6th - 8th
Students work in teams creating and posing math rules and trying to guess them using a formula controlled worksheet they create with Excel. Student pairs take turns to see who can crack the other's code the fastest.
Lesson Plan
Curated OER

Highs and Lows

For Teachers 3rd - 4th
Students use email to chart weather patterns and then graph their findings. In this weather patterns lesson, students chart their weather for a week at the school. Students then use email to find temperatures at a variety of locations....
Lesson Plan
Curated OER

Bullies, Bullies, and No Bullies

For Teachers 4th
Fourth graders engage in a lesson about bullying. The concerns of the lesson includes the identification and behavior of a bully. They use the internet to find information. Also, there is a written assessment.
Lesson Plan
Curated OER

Author Cards

For Teachers 8th
Eighth graders create an informational card for a selected author. They read and analyze a book by their chosen author, conduct research about the author, and create an author card that includes a written critical response to the...
Lesson Plan
Curated OER

Spyglass

For Teachers 9th - 12th
Students distinguish between visualization and scientific visualization. They use the software program Spygalss to create images from two-dimensional arrays of numbers.
Lesson Plan
Curated OER

Scientific Inquiry: Periodic Motion

For Teachers 11th - 12th
Students construct their own pendulum. In this physics lesson, students design an experiment to find the factors affecting its period. They formulate a conclusion based on experimental data.
Lesson Plan
Curated OER

Animals In Your Neighborhood

For Teachers 3rd - 5th
Young scholars make list of all animals they have seen in their backyards, neighborhoods, and around school in past week, graph animals using computer spreadsheet program, and compare graphs through email with students in another class.
Lesson Plan
Curated OER

What Do You Think About Radon?

For Teachers 9th - 12th
Students complete a survey about radon in their homes. They calculate the averages for each question. They graph the averages and discuss the results.
Lesson Plan
Curated OER

Graphing Grazy Crayons

For Teachers 2nd
Children create crazy crayons they made to sort and construct a floor bar graph. Then, using technology resources, they make a simple bar graph to compare the top four colors produced. Students will then interpret the printed graph by...
Lesson Plan
Curated OER

Weather, Weather, Everywhere!

For Teachers 6th
Sixth graders collect weather data to compare temperatures around the world. Using the Internet, learners collect data, put it into spreadsheets, and analyze and graph the results. An interesting way to cover the topic of weather.
Lesson Plan
Curated OER

Shoe Showdown

For Teachers 3rd
Third graders use rulers to measure their shoe size in inches and centimeters. They then enter the class shoe measurements into an excel data base and graph the results of both to make the comparison.