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.
Estimated Time:18 minutes
Score Type:Automatically Graded
Available Languages: English, Spanish
Vocabulary: data, database, field, form, record
Content SpecificLanguage Arts > Writing > Vocabulary > Content Specific
Critical Thinking and Decision Making ProcessTechnology Education > Information Technology > Student Use > Critical Thinking and Decision Making Process
Data Collection for Decision MakingTechnology Education > Digital Literacy > Student Use > Data Collection for Decision Making
Data FormatsTechnology Education > Information Technology > Basic Operations and Concepts > Data Formats
Database ApplicationsTechnology Education > Information Technology > Software Applications > Database Applications
Listening / Pay AttentionLanguage Arts > Communication > Media Literacy / Viewing > Comprehension > Listening / Pay Attention
Listening to NonfictionLanguage Arts > Communication > Listening Strategies / Context > Listening to Nonfiction
Look for and make use of structureMathematics > Process Standards > Common Core > Look for and make use of structure
One-Dimensional Structured Data TypesTechnology Education > Information Technology > Programming > One-Dimensional Structured Data Types
Problem Solving ToolsTechnology Education > Information Technology > Software Applications > Problem Solving Tools
Problem SolvingTechnology Education > Information Technology > Student Use > Problem Solving
Use appropriate tools strategicallyMathematics > 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.
|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.|
|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)|
|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.|