Learning Center
Plans & pricing Sign in
Sign Out
Get this document free



									CBA Lesson Plan    Unit: 4: Databases   Topic: Create database objects     Framework: 4.4    (Author: Erin Rappold)
    What concept within the framework is to be developed? What is the specific objective of the lesson? Creating
     database objects. Students will generate and run a query, enter and display data in a form, and produce a report.
    What do students probably already know about the content? What prior knowledge needs to be activated?
     Students will probably have no knowledge about creating database objects but probably have seen them in
     printed form unknowing. To activate prior knowledge, students need visually see these objects to be reminded of
     what they look like and how they are used.
    What don’t they know? Students will not that you fill in the form to add to the table, then run a query and make
     it into a report.
    Is there potential for misconception? Understanding that entering in data into the form is just like entering in
     data into a table. Some students might rush by just entering in data to the table and skip the step for the form.
    What should students be able to do at the end of the lesson? Students should be able to create all database
     objects (form, query and report).
    What resources are available to develop the concept? Modified Frayer Model (attached) and Closure Frame
     (attached) literacy strategies will be used to help develop the understanding and concept of creating database
     objects and review each object; students will use database software to demonstrate creating database objects.
    What questions will focus students’ thinking on the concept and help guide learning? What is the original
     definition? Define the object in your own words? What are some ways to use the object in the business world?
     What does it look like? Why is this object important? What is one key idea?
    How will I assess students’ understanding of the essential concepts and major details? I will prepare a Frayer
     Model Chart (see attached) for each object in a database to activate students’ prior knowledge about the term
     and generate understanding in their own words. The before strategy will ask them to write down the original
     definition, define the object in their own words, name examples of ways the object is used in the business world,
     and draw a picture of what they think the object will look like. I will as for volunteers to share what they wrote
     down, which will initiate a class discussion about databases objects. During the lesson, students will create a
     form, query and report using the Access Project worksheet they started in the last lesson. I will guide them
     through the steps of each object before they start their individual projects. A rubric is attached for the students
     to see how they will be graded at the end this lesson. The after strategy when students turn in their project they
     will receive a Closure Frame (see attached) to identify the most important information they learned in the lesson.
     The students will turn in the both the Modified Frayer Model and Closure Frame for a grade. I will review the
     models and paragraphs and start the next day’s class with a few of them, emphasizing what the students need to
     know about database objects. A final assessment will be based on the rubric after the lesson is complete for a
     unit grade.
Description of Lesson: CBA Unit 4: Databases, Create database objects 4.4
Part of     Strategy        What Students Will Do                           What Teachers Will Do
            Modified             Write the original definition.                List out the 3 different objects on
            Frayer Model         Write what the object means in their           the board and define them.
                                  own words.                                    Ask the students to fill out the
                                 What are some ways use the object in           Frayer Model.
Before                            the business world. (examples)                Ask for volunteers to share what
                                 Draw a picture of what the object will         they wrote down for each block.
                                  look like.                                    Lead class discussion over ideas
                                                                                 they have about databases
                                 Create a Form using the Access Project        Demonstrate how create a form,
                                  worksheet from the previous lesson.            query, and report using a
During                           Create a Query.                                database.
                                 Create a Report.
            Closure              Complete a Closure Frame about what           Have the students fill out a Closure
            Frame                 the students learned about databases           Frame about what they learned
After                             objects.                                       about database objects.
                                                                                Ask students what they learned
                                                                                 about databases objects.
Student Name: ________________________________   Period: ________________Date: ___________

                      Modified Frayer Model
Original definition                                                    Define in your own words

Ways used in the
business world
                                         Form                          Draw a picture of what
                                                                       the object will look like
Student Name: ________________________________   Period: ________________Date: ___________

                      Modified Frayer Model
Original definition                                                   Define in your own words

Ways used in the
business world
                                       Query                          Draw a picture of what
                                                                      the object will look like
Student Name: ________________________________   Period: ________________Date: ___________

                      Modified Frayer Model
Original definition                                                    Define in your own words

Ways used in the
business world
                                      Report                           Draw a picture of what
                                                                       the object will look like
Student Name: ________________________________             Period: ________________Date: ___________

                          CLOSURE FRAME
Today’s lesson on ___________________________________________________________________________________

_______________________________________________. One Key idea was ___________________________________

________________________________________________. This is important because ____________________________



Another key idea ____________________________________________________________________________________


This matters because ________________________________________________________________________________


___________________________________________. In sum, today’s lesson ____________________________________


Student Name: ______________________                      Period: ________________Date: ___________

                                     ACCESS PROJECT WORKSHEET

Objective: Create and use a database—create tables, forms, queries and reports, use sort and filter; print.

   Family and friends (name, address, date of birth)
   CD or DVD collection (name, price, genre)
   Other collection (trading cards, car parts)
   Class/church/other group information (name, grade, phone number)

Database Name ______________________________

Field Names—minimum of 10 (include type—must use at least 3 different types)

___________________________________                   ___________________________________

___________________________________                   ___________________________________

___________________________________                   ___________________________________

___________________________________                   ___________________________________

___________________________________                   ___________________________________

___________________________________                   ___________________________________

Other requirements:

        Minimum of 10 records
        At least one table—table name ________________________________________
        Print table
        Create an appropriate form—form name _________________________________
        Print ONE form
        Create a minimum of 2 queries (print)
        Create at least one report—report name _________________________________
        (must group) Print report

Attach all printouts to this worksheet and turn in.
Student Name: ________________________________                         Period: ________________Date: ___________

                                                  Access Project
                                                 Grading Criteria
Grading Sheet for: ________________________________________________________________________________

                                                                                 Points Earned Comments
                                                                    Points Possible

Create Database
Name the database                                                         5

Create table
Minimum 10 fields                                                        20

Enter data
Minimum 10 records                                                       20

Print the table                                                          10

Create form – use at least 5 fields
YOUR info is the form to be printed                                      15

Sort the table by a field in ascending order – print the table           10

Query 1
Use 3 to 5 fields – Print                                                15
Query 2
Use 3 to 5 fields
(different from Query 1) – Print                                         15

Create report – use all the fields, group the information – Print        15

Grading Sheet and planning sheet attached to printouts
Printouts in order of rubric                                             15

TOTAL                                                                    140

To top