Lesson Title: European Database - Filter or Sort
Curriculum Area: Social Studies
Technology Strand: Database
Grade Level: 6
 
Essential Question: What strategies can I use to find information in a database?
 
A Activity Summary Students will use a prepared database file to answer the questions on the worksheet. Students will need to make a decision if they need to sort or filter the information to locate the correct answer.
C Curriculum Social Studies
1.02 Generate, interpret, and manipulate information from tools such as maps, globes,charts, graphs, databases, and models to pose and answer questions about space and place, environment and society, and spatial dynamics and connections.
T Technology Database
3.03 Develop and use search strategies with two or more criteria to solve problems and make decisions in content areas.  
 
Activating Strategies
Review Vocabulary - Teacher Led Make copies of the "Sort_Filter_Review" activity for students. Practice a few questions with students. Have students explain how they got their answers and what keywords helped them decide whether to sort or filter. This activity can be accomplished in the classroom before entering the lab.
 
Technology Vocabulary: Database Vocabulary
Detailed Technology Instructions: Microsoft Works for Windows Database Instructions
 
Cognitive Teaching Strategies
After the Activating Strategies (students should be in the computer lab):
1. Open the "European_Countries" database file.
2. Make sure the database is in List View.
3. Have students decide whether to use sort (rearrange the records), or filter (search multiple criteria) option to answer the questions. Students should then answer the question.
(Teacher can refer to Microsoft Works for Windows Database Instructions for specific directions on sorting and filtering.)
4. If students complete the questions, have them come up with their own questions using database information. These questions can be used for additional practice.
5. After students complete the assignment, exit the database without saving.
6. Turn in the activity sheet to the teacher.
 
Summary Strategies
Discuss answers to European Database Activity Worksheet. Review when to apply the filter, sort, and find options to answer questions.
 
Resources
Click for directions on how to download files on a Windows computer. 
Microsoft Word Files
Euro_Sort_Filter_Act.doc
Sort_Filter_Review.doc

Microsoft Excel File
European_Countries.xls

Microsoft Works 4.0 or 4.5 for Windows File
European_Countries.wdb  
 
Re-teaching and Enrichment Activities
This is the last database lesson that discusses European Countries. The next two lessons in the European studies series are desktop publishing lessons. Both are included in: Britain1

The concept for this lesson plan was submitted by
Jennifer Stone  Janice Bradburn
Prescott Technology Center, Data last modified: 8/12/2006