Request More Info

Shown a database listing planets, the student is asked to delete the record that doesn't belong

Preview this lesson

Databases: Planning and Building a Database

In this engaging and interactive digital lesson, the learners will receive direct instruction and practice in planning and building a database. They will create a form, start a new file, create, edit, and define fields, and review, edit, and delete data.

Teacher-Facing Resources

Type:Lesson

Estimated Time:18 minutes

Grades:4-5

Score Type:Automatically Graded

Available Languages: English, Spanish

Vocabulary: data, database, field, form, record

Primary Objectives:

Student learns how to plan for a database.
Student learns to start a new database file.
Student learns to create and define fields.
Student learns how to enter data into a database record.
Student learns how to review and edit data.
Student learns how to delete records and fields.

Secondary Objectives:

Student learns about Mercury, solar system planets

Subjects:

Content Specific

Language Arts > Writing > Vocabulary > Content Specific

Critical Thinking and Decision Making Process

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

Data Collection for Decision Making

Technology Education > Digital Literacy > Student Use > Data Collection for Decision Making

Data Formats

Technology Education > Information Technology > Basic Operations and Concepts > Data Formats

Database Applications

Technology Education > Information Technology > Software Applications > Database Applications

Listening / Pay Attention

Language Arts > Communication > Media Literacy / Viewing > Comprehension > Listening / Pay Attention

Listening to Nonfiction

Language Arts > Communication > Listening Strategies / Context > Listening to Nonfiction

Look for and make use of structure

Mathematics > Process Standards > Common Core > Look for and make use of structure

One-Dimensional Structured Data Types

Technology Education > Information Technology > Programming > One-Dimensional Structured Data Types

Problem Solving Tools

Technology Education > Information Technology > Software Applications > Problem Solving Tools

Problem Solving

Technology Education > Information Technology > Student Use > Problem Solving

Use appropriate tools strategically

Mathematics > Process Standards > Common Core > Use appropriate tools strategically

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 Mercury. You might want to show and discuss facts about Mercury with students before they take the EasyTech lesson.
Students should know that the first step in creating a database is planning.
Students work with data types in this lesson as they learn how to build a database. You might want to remind students that a field formatted as a Boolean data type requires Yes or No criteria in the field. For example, a field named Rings could be formatted as a Boolean data type because the criteria would be Yes or No. Similarly, remind students that the OLE (object linking and embedding) data type can be used to include images in a datasheet.
Students should know how to use the Save As dialog box.
The lesson shows students how to assign the AutoNumber data type to the ID field by selecting AutoNumber in the Data Type list box. In Open Office, students would use the Integer data type and then click Yes in the AutoValue list box. You should make sure students know how to assign the AutoNumber or AutoValue data type on your school’s database software.
The lesson shows students using the Primary Key button. In some database programs, students may have to right-click a gray box next to the field row and choose Primary Key. You should make sure students know how to assign a primary key to a field on your school’s database software.
The lesson shows students how to apply a style set to database forms in a wizard. Some database applications only allow students to choose a form color and border style. You might want to make sure students know how to format database forms on your school’s database software.
Students should know the basic steps for inserting a picture.
Database images must be bitmaps.
In some database programs, students will have to right-click a picture field to insert an image instead of using the Insert menu.
In the Spanish version of this lesson, the audio presents the data types in Spanish while the onscreen data types are shown in English. You might want to review the English terms for the data types with students before they view the Spanish lesson.

Databases can seem complex, but students can create effective databases if they clearly understand all the parts of a database. To aid in student understanding, hold a class discussion in which the class looks at an existing database and deconstructs it into datasheet parts (such as records, fields, data types, criteria, and so forth). Next, have students find and deconstruct another database on their own. They can show their work by drawing a datasheet and writing field names at the tops of the columns (you might want to remind students to include an ID field formatted as the primary key in their datasheets). Below the field names, students can write the data type for each field. In the third row, students should add a sample record. After students have deconstructed their databases, have them exchange their datasheets with a partner so they can “test” each other’s datasheets by adding a new record. Allow students time to provide feedback to each other, and then hold a class discussion to reflect on successes and discoveries.

ISTE

S.5.b

Students collect data or identify relevant data sets, use digital tools to analyze them, and represent data in various ways to facilitate problem-solving and decision-making.

CSTA

1B-DA-06	Organize and present collected data visually to highlight relationships and support a claim. (P7.1)
1B-DA-07	Use data to highlight or propose cause-and-effect relationships, predict outcomes, or communicate an idea. (P7.1)

CCSS

ELA-Literacy.L.4.6	Acquire and use accurately grade-appropriate general academic and domain-specific words and phrases, including those that signal precise actions, emotions, or states of being (e.g., quizzed, whined, stammered) and that are basic to a particular topic (e.g., wildlife, conservation, and endangered when discussing animal preservation).
ELA-Literacy.L.5.6	Acquire and use accurately grade-appropriate general academic and domain-specific words and phrases, including those that signal contrast, addition, and other logical relationships (e.g., however, although, nevertheless, similarly, moreover, in addition).
ELA-Literacy.SL.4.2	Paraphrase portions of a text read aloud or information presented in diverse media and formats, including visually, quantitatively, and orally.
ELA-Literacy.SL.5.2	Summarize a written text read aloud or information presented in diverse media and formats, including visually, quantitatively, and orally.
ELA-Literacy.W.4.2d	Use precise language and domain-specific vocabulary to inform about or explain the topic.
ELA-Literacy.W.5.2d	Use precise language and domain-specific vocabulary to inform about or explain the topic.
Math.Practice.MP5	Use appropriate tools strategically.
Math.Practice.MP7	Look for and make use of structure.

Aligned to National and State Standards

See how our curriculum can help you meet your instructional goals

Check it out