Lesson Plan
Curated OER

Spreadsheets and Database in Social Studies

For Teachers 5th
Fifth graders create/use spreadsheets to solve real-world problems, explore patterns and make predictions, select/explain most appropriate types of graph to display data, and enter data into a prepared spreadsheet to perform calculations.
Lesson Plan
Curated OER

Basic Excel

For Teachers 1st - 4th
Learners explore basic Excel spreadsheets.  In this spreadsheet lesson plan, students enter Alaska weather information and  perform calculations. Learners title the columns on the spreadsheet and format the cells. ...
Lesson Plan
Curated OER

Escape Velocity

For Teachers 6th
Sixth graders create/use spreadsheets to solve real-world problems, explore patterns, make predictions, select/explain most appropriate types of graph to display data, use information to create product, and have basic understanding of...
Lesson Plan
Curated OER

Graphically Speaking

For Teachers 4th - 6th
Students discover the links between population and Congressional representation. For this government lesson, students research population statistics and create spreadsheets that compare population to the number of Congress members per...
Lesson Plan
Curated OER

Spreadsheets in Science

For Teachers 4th
Fourth graders create spreadsheets, explore patterns and make predictions based on the information. They select the appropriate graph to display the spreadsheet data. They search and sort prepared data bases to gain knowledge for...
Lesson Plan
Curated OER

American Colonies

For Teachers 6th - 8th
Students record information in a database about the three American colonies. They are comparing and contrasting them. They are to log into a given database and fill in the corresponding sections. Once it is filled in the similiarities...
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

Cloud Databases

For Teachers 7th - 9th
Students complete a unit on clouds and a report about one type of cloud. They collect data through observation about different types of cloud cover and then create a spreadsheet to reflect their observations over a 2 week period.
Lesson Plan
Curated OER

It's 'ELEMENT' ary

For Teachers 6th - 8th
Students, using a Web site about the periodic table of elements, create spreadsheets representing elements and their properties. They also create graphs that compare the physical properties of the elements.
Lesson Plan
Curated OER

Electronic Spreadsheets & Iditarod 2000

For Teachers 6th - 8th
Students use the Internet for gathering information for Iditarod race journals. They use a spreadsheet program for entering data and making charts for showing changes in speeds achieved over a period of four weeks in timed writings in...
Lesson Plan
Curated OER

First Class First? Using Data to Explore the Tragedy of the Titanic

For Teachers 9th - 12th
Students analyze and interpret data related to the crew and passengers of the Titanic. They research information on a Titanic database to illustrate specific statistical conclusions, and whether or not social status affected the outcome.
Lesson Plan
Curated OER

Family Search We All Came To America

For Teachers 8th
Eighth graders participate in a computer based Family Search Unit. They use multimedia resources to research their country of origin, conduct interviews, and use software to produce narratives, databases, spreadsheets and graphs in this...
Lesson Plan
Curated OER

Are You Here Today?

For Teachers K
Students recognize their own name in print and the names of their classmates. They use one to one correspondence to determine who has not checked in, completed their field, and if absent indicate that on the form. Students tally the...
Lesson Plan
Curated OER

Embracing Diversity

For Teachers 9th
Ninth graders discover that the amount surveyed affects the results and conclusions drawn from a survey. In this sampling lesson students explore the concept that a valid conclusion require a large number of entries.  Students...
Lesson Plan
Curated OER

Environmental Risk Analysis

For Teachers 9th - 12th
Students complete a survey and enter the responses in a spreadsheet. The spread sheet is used to create a bar graph. Students complete spreadsheets listing types of hazards in their community.
Lesson Plan
Curated OER

Finding Mean, Mode and Median in the Computer Lab

For Teachers 5th - 12th
Students create spreadsheets which will display and figure mean, median, and mode of a set of numbers.
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

Comparing Weather Conditions

For Teachers 4th - 5th
Pupils conduct research on temperature, wind speed and weather conditions from a variety of areas. They organize their findings on worksheets and spreadsheets and discuss various examples of databases.
Lesson Plan
Curated OER

Space Presents Problems

For Teachers 6th - 8th
Students use the internet to research problems related to space. They complete a questionaire to direct their research before beginning. They create a database of moon and planet characteristics.
Lesson Plan
Curated OER

Western Hemisphere

For Teachers 4th
Fourth graders use a database to compare countries in the western hemisphere. They describe a variety of regions in Texas and the Western Hemisphere such as political, population, and economic regions that result from patterns of human...
Lesson Plan
Curated OER

The Birds of a Feather Flock Together

For Teachers 5th
Fifth graders identify all parts of an egg, and explore their importance to the life cycle of a chicken. Learners compare all sorts of birds and place them in categories based on what they look like. This five-day activity effectively...
Lesson Plan
Curated OER

Pumped Up Gas Prices

For Teachers 3rd - 6th
Students calculate gas prices. In this transportation lesson, 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. For 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

Career Exploration

For Teachers 7th - 8th
Students complete a unit about career choices. They conduct research on a selected career that interests them, conduct an interview, explore various websites, create a five-page HyperStudio stack, and write ten checks that relate to...