+
Lesson Plan
Curated OER

Doughnuts to $ Database

For Teachers 5th
Fifth graders are selling Krispy Kreme doughnuts to raise money for their overnight camping trip. They use a database to set to keep track of and record additions to their daily sales. Students then follow the step by step directions to...
+
Lesson Plan
Curated OER

European Elevation Sort

For Teachers 6th
Given a prepared database of European countries, sixth graders sort the countries in ascending order by elevation and identify the five countries with the highest elevations. This cross-curricular instructional activity combines elements...
+
Lesson Plan
Curated OER

Metrically Me!

For Teachers 4th - 6th
Students define the parts of a database, search strategies to locate information electronically, create/modify databases, etc. and enter data into a prepared spreadsheet to perform calculations.
+
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

Using a Statistical Procedure To Search A Database For Out of the Ordinary Values

For Teachers 7th - 10th
Young scholars develop a spreadsheet containing formulas and find summaries for them.  In this investigative lesson students choose a topic, investigate it and use MS Excel to sort data. 
+
Lesson Plan
Curated OER

What Does George W. Bush Have in Common With Past U.S. Presidents?

For Teachers 6th
Sixth graders discover what it takes to become President of the United States. Using a database, they complete a scavenger hunt to determine what George W. Bush has in common with past Presidents. They also create a spreadsheet which...
+
Lesson Plan
Curated OER

How Much Do You Burn?

For Teachers 6th
Sixth graders discover their weight relative to the other children in their class. They determine how many calories they burn through exercise and compare it with their classmates. Using the internet, they calculate their body mass index...
+
Lesson Plan
Curated OER

Student Census

For Teachers 7th - 9th
Young scholars collect data from their peers and store the information in a database. As students manage the information they realize the usefulness of a database as a tool to manage large amounts of information in an efficient and...
+
Organizer
Curated OER

Database

For Students 6th - 8th
In this technology worksheet, students examine the graphics in order to see how the information is organized for a database. They use the sheet as a reference for making database entries.
+
Lesson Plan
Curated OER

M&M Graphing

For Teachers 4th
Fourth graders name colors of M&Ms and record answers. They estimate number of M&Ms of each color found in a typical package of M&Ms on piece of paper.They record information on sheet of paper and create a spreadsheet. paper.
+
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

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

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

Famous People

For Teachers 6th - 8th
Young scholars create a database with information about famous people. They develop a custom word-processing template. They practice merging fields into their template.
+
Lesson Plan
Curated OER

Student Reading Log

For Teachers 4th
Fourth graders read on a daily basis to enhance their reading experiences, and record their reading activities in reading log database at least every two weeks to practice their keyboarding skills.
+
Lesson Plan
Curated OER

Stock and Inventory

For Teachers 5th - 8th
Learners create databases. In this spreadsheet lesson, students take stock of their toys and create databases. Learners consider good business practices as they listen to guest speaker discuss how to control inventory.
+
Lesson Plan
Curated OER

Using A Volunteer Acquired Database Constructed On The Internet, Examine the Relationship between Dissolved Oxygen and Water Temperature

For Teachers 9th
Ninth graders access a database and open a spreadsheet.  In this oxygen and water temperature lesson plan students save the database, sort it and generate scatter plot graphs. 
+
Lesson Plan
Curated OER

Microsoft Access Lesson Plan

For Teachers 3rd
Third graders read children's literature during the school year and compile a list of books and genres in an Access database. They print out a report of all the different books and genres of they read over the whole school year.
+
Lesson Plan
Curated OER

Basic Excel

For Teachers 1st - 4th
Students explore basic Excel spreadsheets.  In this spreadsheet lesson plan, students enter Alaska weather information and  perform calculations. Students title the columns on the spreadsheet and format the cells.  Students complete...
+
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

Historical Population Changes in the US

For Teachers 9th - 12th
Young scholars conduct research on historical population changes in the U.S. They conduct Internet research on the Historical Census Data Browser, create a bar graph and data table using a spreadsheet program, and display and interpret...
+
Lesson Plan
Curated OER

"Living in the Limelight The Universal Dream"

For Teachers 9th - 12th
Students, using Leo's Lyrics, investigate common themes in popular music. They create a Microsoft Excel spreadsheet that analyzes their findings along with a 200 word paragraph stating their observations, conclusions and hypotheses about...
+
Lesson Plan
Curated OER

Does Humidity Affect Cloud Formation?

For Teachers 6th - 8th
Students use S'COOL data to identify factors that affect cloud formation. They find a data set using the S'COOL database , and use Excel to manipulate the data. Student isolate relevant data, create meaningful graphs from a spreadsheet,...
+
Lesson Plan
Curated OER

Birds, Fractions and Percentages

For Teachers 6th - 12th
Students study fractions, percentages, spreadsheets, and computers by watching and recording the number of species of birdsseen. They create a spreadsheet to record the results of their one month study.