Spreadsheets and Databases Teacher Resources

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...

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 lesson combines elements of computer...

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.

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.

Learners 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. 

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...

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...

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...

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.

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.

Fifth graders collect information about an assigned topic. They organize data by using a database.

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.

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...

Middle schoolers create a database with information about famous people. They develop a custom word-processing template. They practice merging fields into their template.

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.

Students create databases. In this spreadsheet lesson plan, students take stock of their toys and create databases. Students consider good business practices as they listen to guest speaker discuss how to control inventory.

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.

Ninth graders access a database and open a spreadsheet.  In this oxygen and water temperature lesson students save the database, sort it and generate scatter plot graphs. 

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 discover the links between population and Congressional representation. In this government lesson, students research population statistics and create spreadsheets that compare population to the number of Congress members per state.

High schoolers 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...

High schoolers, 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...

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,...

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...