Content Areas: Science, Math
Computer Skills: Spreadsheets, Database

Objectives:

• To create and use spreadsheets to solve real-world problems
• To explore patterns and make predictions
• To select and explain most appropriate types of graphs to display data
• To enter data into a prepared spreadsheet to perform calculations and recognize the changes that occur
• To search and sort prepared databases for information to use in classroom projects
• To gain a general knowledge in the areas of animals, space, and weather

Materials: (Each activity sheet will let you know if an activity requires more materials or time)

Computer
Computer files loaded on the computer or computers that students will use
Download all PC files from the "Teacher Resources" page (see link on left menu)
Spreadsheet and Database program
One of the activity sheets listed below
Student sheets copied for each student

 Teacher Activity Sheet Computer File Student Sheet Science Math Computer Skill Plants and Sunlight Bar Graph Spreadsheet, graphing Rabbit Population Bar Graph Spreadsheet, graphing Length of Year and Distance from Sun Line Graph Database, Spreadsheet Percentage of Snow Days Pie Graph Database, Spreadsheet

Time: 2 classroom periods, 1 computer lab period

Activities:

Classroom Period 1:

1. Teach the topic that relates to the spreadsheet activity.
2. If an experiment or activity is required complete this before going to the computer lab.

Computer Lab Trip 1:

1. Demonstrate for students how to look up the required information in a database and then use this information to create a spreadsheet.
2. Using the information have students make a graph and answer questions.
3. SAVE the file and print to take back to class.

Classroom Period 2:

1. Pair students and have them compare their graphs with each other.
2. Have several students report to the class their observations.
3. Hang these around the room, make a bulletin board, or keep in a portfolio.

NC Competencies:

Science:

Goal 2: The learner will have a general knowledge of animals.
Goal 4: The learner will have a general understanding of the earth's atmosphere, weather, and climate.
Goal 5: The learner will have a general understanding of space.

Computer Skills: