Searching Databases

Lesson Overview

In this 45-minute lesson, students will learn how to effectively search for information in a database using computers. The focus will be on developing their research skills, understanding different types of databases, and learning how to refine their searches for optimal results. This lesson aligns with the UK National Curriculum for Computing, particularly in Key Stage 2.

Objective

• Students will understand how to use a database to find information.
• Students will learn to employ search techniques to refine their queries.
• Students will develop the skills to evaluate the relevance of the searched information.

Curriculum Links

• Computing National Curriculum (Key Stage 2): Design, use, and evaluate computational artefacts that include programs, data handling, and digital content.
• Information and Communication Technology (ICT) Programme of Study: Develop research skills using ICT tools and resources effectively.

Materials Needed

• 5 Computers with internet access
• Projector and screen for demonstration
• Handouts with database search tips
• Whiteboard and markers
• Example databases (e.g., online encyclopaedias or educational database platforms)

Lesson Structure

1. Introduction (10 minutes)

• Engagement Activity: Start with a question: “What do you think a database is?”
• Discussion: Briefly go over responses and correct any misconceptions. Introduce databases as organized collections of data that can be easily accessed, managed, and updated.
• Objective Sharing: Explain the aim of today’s lesson which is to learn effective searching techniques within a database.

2. Instructional Input (15 minutes)

• Demonstration: Use the projector to demonstrate a simplified database interface.
  • Show how to access a database, input search terms, and adjust search parameters.
• Key Terms: Introduce vocabulary such as “keywords,” “filters,” “results”, and “relevance.”
• Searching Techniques: Discuss the following techniques with examples:
  • Using specific keywords
  • Employing Boolean operators (AND, OR, NOT)
  • Using filters (date ranges, categories)

3. Guided Practice (15 minutes)

• Group Activity: Divide students into small pairs and give them a set of 3 tasks to complete using the computers:
  1. Find information about a specific animal using the database.
  2. Search for recent articles on renewable energy.
  3. Locate statistics about the population of the UK.

Each pair will be assigned a computer and will utilise their new searching skills to complete the tasks.

4. Independent Practice (5 minutes)

• Reflection Task: Ask each student to find one interesting fact from their search and write it down. Follow up with the question, “Why did you choose this fact?”

5. Closing (5 minutes)

• Class Discussion: Bring the class back together and have each pair share what they found. Discuss the different approaches used in their searches and what made their pieces of information relevant or interesting.
• Wrap-Up: Highlight the importance of effective searching and evaluating online information.

Assessment

• Formative Assessment: Throughout the lesson, observe pairs during group activities to assess their collaborative skills and ability to navigate databases.
• Exit Ticket: Collect students' reflections at the end, focusing on their search experience and what they learned about information retrieval.

Differentiation

• For Advanced Learners: Encourage them to explore more complex databases or to find multiple articles on the same topic to compare perspectives.
• For Struggling Learners: Provide a glossary of terms and a step-by-step video tutorial for them to revisit as needed.

Additional Notes

Ensure that devices are set up and functioning prior to the lesson to maximize time spent on learning. This lesson fosters critical thinking, collaboration, and digital literacy—key skills that will serve students throughout their education and beyond.