LESSON PLANS

Course BCS II-7 th Grade

GPS MSBCS-BCSII-6

GPS:

MSBCS-BCSII-6: The student will utilize database software.

a) Identify uses of database software and careers related to database.

b) Identify and explain database terminology.

c) Create and save basic database related to business and computer science careers.

d) Retrieve, edit, manipulate, and print various databases

Amount of Time Needed: Lesson plans should cover 3-4 55-minute class periods

Warm-Up:

Day 1—Watch Discovery Education videos together—2 segments—“Gathering Information for a Database” (02:54) and “Using a Computer to Organize a Database” (04:20)

(Log into Discovery Education and then access this link: http://player.discoveryeducation.com/index.cfm?guidAssetId=ABD4FD3F-44EC-4D64-BF65-507D4F579BC4&blnFromSearch=1&productcode=US )

Day 2—Visit http://online.onetcenter.org/find/ . Type “database” in the Keyword Search box. Look through the list of database-related career fields. Click on and read at least 3 different job descriptions.

Day 3—Read this description of Database Administrators. http://www.nycareerzone.org/cz/profile.jsp?onetsoc=15-1061.00

Day 4—Database Vocabulary Crossword Puzzle

Lesson Activities/Procedures:

Word Wall—

Microsoft Access

Database

Table

Records

Primary Key

Form

Report

Day 1—

1. Complete the Warm Up Activity
2. Students should research 10 business and computer science careers using the Internet, and complete the Job Data Table worksheet. Don’t know where to start? Try these sites:
1. http://www.khake.com/page17.html
2. http://stats.bls.gov/OCO/OCOS042.HTM

Day 2—

1. Complete the Warm Up Activity
2. Teacher should introduce Microsoft Access to students using the overhead projector. Open program and review similarities and differences between Access and other Office programs. Review toolbars and introduce database vocabulary words.
3. Teacher should use PowerPoint with screenshots to guide students step by step to create a new database using their completed Job Data Table worksheet.
4. Create Job Snapshots table in Access.

Day 3—

1. Complete the Warm Up Activity
2. Teacher should continue using PowerPoint to guide students to modify table, create a form, and create a report.
3. Students should print Job Snapshots Table and Jobs Report.

Day 4—(if needed)

1. Complete the Warm Up Activity
2. Students should complete any remaining activities from the PowerPoint.

Handouts: Job Data Table

Database Vocabulary Crossword Puzzle

Evaluation:

Check for completed Job Data Table

Check the following database printouts:

Job Snapshots Table

Jobs Report

Closing: Answer Essential Question of the Day.

Day 1—How is a database like a filing cabinet?

Day 2—Why would a database be useful to a business?

Day 3—Explain how a table can “relate” to another table.

Day 4—Discuss examples of “reports” you might have gotten or seen before that have come from a database.