Scribd Logo
Upload

Welcome to Scribd!

  • 721 views

    Lesson Plan Database

    Uploaded by

    Muthu Muhammad Nachiar
    The lesson plan is for a Form 2 computer studies class on using Microsoft Access to enter data into a database. The objectives are for students to understand databases, how to open and use Access to create tables, add and arrange data fields, and save their database. The teaching methods include demonstrating the database functions on an interactive whiteboard while students follow along creating their own student information database in Access, with activities like choosing field names and types, adding records, and saving their work.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as DOC, PDF, TXT or read online from Scribd

    Lesson Plan Database

    Uploaded by

    Muthu Muhammad Nachiar
    721 views2 pages
    The lesson plan is for a Form 2 computer studies class on using Microsoft Access to enter data into a database. The objectives are for students to understand databases, how to open and use Access to create tables, add and arrange data fields, and save their database. The teaching methods include demonstrating the database functions on an interactive whiteboard while students follow along creating their own student information database in Access, with activities like choosing field names and types, adding records, and saving their work.

    Copyright

    © Attribution Non-Commercial (BY-NC)

    Available Formats

    DOC, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The lesson plan is for a Form 2 computer studies class on using Microsoft Access to enter data into a database. The objectives are for students to understand databases, how to open and use Access to create tables, add and arrange data fields, and save their database. The teaching methods include demonstrating the database functions on an interactive whiteboard while students follow along creating their own student information database in Access, with activities like choosing field names and types, adding records, and saving their work.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as DOC, PDF, TXT or read online from Scribd
    Download as doc, pdf, or txt
    721 views2 pages

    Lesson Plan Database

    Uploaded by

    Muthu Muhammad Nachiar
    The lesson plan is for a Form 2 computer studies class on using Microsoft Access to enter data into a database. The objectives are for students to understand databases, how to open and use Access to create tables, add and arrange data fields, and save their database. The teaching methods include demonstrating the database functions on an interactive whiteboard while students follow along creating their own student information database in Access, with activities like choosing field names and types, adding records, and saving their work.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as DOC, PDF, TXT or read online from Scribd
    Download as doc, pdf, or txt
    of 2

    Lesson plan for Database management system

    (DBMS)
    Date : 01.11.2008

    Class : Form 2

    Time : 10 to 11.30

    Subject : Computer studies

    Topic/Title : Entering Data using with Microsoft access

    Teaching Aids/Materials: Lesson content:


    Computer, IWB. Practice with Microsoft access.

    Objectives:
    By the end of the lesson, students should be able to:

    1. understand what is a database,


    2. find out for themselves where databases can be used,
    3. find out how to open Microsoft access blank database,
    4. understand how to add table title,
    5. create more than one table,
    6. create a simple database of their own, (example: class lists with
    details.)
    7. save database into their own file/folders.

    Learning methods:
    1. Greet students and get them to switch on their respective
    computers.
    2. Elicit from students ways of maintaining records. (example:
    friends’ name, address and telephone numbers)
    3. On the IWB show a database which stores students’ information.
    4. On the IWB open Microsoft Access and open a blank database
    table to create students’ records.
    5. Ask the students’ to open a blank database simultaneously.
    6. Make sure every student has opened and could follow the IWB.
    7. Show them how to choose a table name. Select the data type for a
    field in a table.(25 minutes)
    8. Explain how to add new field ,delete field, change filed name and
    change field sizes.(30 minutes)
    9. Explain how to prevent from making mistakes when entering data.
    10. Add the field properties for a field in a table.(student details)
    11.Explain how to arrange the data using a reference key.
    12. Explain how to rearrange data in a specific order.
    13. Add a primary key to a table.
    14. Create a form to make data entry easy.
    15. Enter data using a table and form.
    16. Save the database into a folder.(25 minutes)

    Lesson closure:

    Recap the lesson and ask the students’ to show their own databases.
    (10mimutes)

    You might also like