Business Applications

Not a Learning.com customer? Learn More

Type:Lesson

Estimated Time:10 minutes

Score Type:Auto Score

This lesson automatically provides a score to your gradebook

Available Languages: English, Spanish


Vocabulary: Boolean operator, data, data analysis, data table, database, datasheet, dialog box, field, filter, query, report, table, toolbar


Primary Objectives:

  • Student begins to understand the role of queries in databases.
  • Student gains experience navigating through a database.
  • Students learns how to query data to find answers.
  • Student learns how to save queries and reports for future use.
  • Student learns how to share data by creating and printing reports.

Secondary Objectives:

  • Student learns about sol, axis rotation, orbital rotation

Subjects:

Boolean operators

Digital Literacy > Reference and Research > Search Strategies > Boolean operators

Boolean operators

Information Literacy > Reference and Research > Search Strategies > Boolean operators

Critical Thinking and Decision Making Process 

Information Technology > Student Use > Critical Thinking and Decision Making Process 

Data Formats 

Information Technology > Basic Operations and Concepts > Data Formats 

Internet

Science > Concepts and Processes > Tools / Instruments > Software Tools > Internet

Problem Solving 

Information Technology > Student Use > Problem Solving 

SQL Statements 

Information Technology > Programming > SQL Statements 

Structured Query Language 

Information Technology > Programming > Structured Query Language 

Student Communication with Others 

Information Technology > Digital Communications > Student Communication with Others 

Use of Mathematical Expressions such as Boolean operators 

Information Technology > Programming > Use of Mathematical Expressions such as Boolean operators 
Show More

Teacher Notes:

  • The database lessons incorporate information about our solar system by following two robots from the fictional company S-SPACE (Solar System Planets Are Cool Enterprises) on their mission to find the perfect location to build a S-SPACE City. This lesson’s setting is Mars (which turns out to be the best planet for a new S-SPACE City). You might want to show and discuss facts about Mars with students before they take the EasyTech lesson.

  • The lesson introduction shows an animated Mars Rover. You might want to discuss the real Mars Rover and its research significance with students before they take the lesson.

  • Student should know that the word query is another word for question.

  • You might want to explain that in databases, queries are similar to filters except that students can name and save queries for future use. Queries can use data from tables or other queries.

Extension Ideas:

  • As students become proficient using databases, they can use more advanced searches, filters, and queries to help them answer complex questions and create reports. To help students retrieve targeted information from large databases, discuss the Boolean operators OR, AND, and NOT with students. Describe how each operator is used in data retrieval. Then, using a current curriculum topic as subject matter, have students write down Boolean searches they would use to find information on the Web that would be relevant to a current research paper or project. After you approve the students’ Boolean search ideas, allow them to conduct their searches online and create a bibliography showing the relevant and reliable resources they found for each Boolean search they conducted. The bibliographies can then be incorporated into more comprehensive bibliographies developed for the overall research project.

Standards:

ISTE seal of compliance for proficiency student standards ISTE seal of compliance for readiness student standards
Feedback