Instructional/Learning Plan
Monte Thompson
Microsoft Access 2007Student Learning Outcomes for Lesson 1 - 3
Upon successful completion of the first 3 lessons, the student will:
Lesson 1
- Describe the Access 2000, “Getting Started Window” (Office Button, New)
- Label and define the elements of the Access 2007 user-interface
- Choose a template database from Microsoft Office (you must be using Microsoft's Web browser to use this service).
- Make design changes to templates in Access 2007
- Demonstrate mastery of database terminology.
Lesson 2
- Define the term “Relational Database”
- Demonstrate knowledge of “Database Normalization Theory”
- Plan, design and create a new relational database, based on user needs, based on user needs. (Assignment 4)
- Plan, design and create tables and forms for new database.
Lesson 3
- Import data into tables from Excel spreadsheets.
- Query a database using different methods. (Video)
- Generate user specified reports. (Video)
Prerequisites: Microsoft Windows, Microsoft Word, Microsoft Excel
Course: Introduction to Microsoft Access
Student Assessments:
Lesson 1: An Introduction to Microsoft Access 2007 User Interface
Content type: Concepts
Teaching strategy:
- Provide reading assignment which lists and examines 10 major Microsoft Access 2007 user-interface elements.
- Assign students to groups not exceeding 10 students per group.
- Demonstrate the user-interface elements, via an online video, which examines the new user interface of Microsoft Access 2007.
- Assign students to collaborative to create a class glossary, with definitions of the technology concepts introduced in this lesson.
- Assign reading assignment, discussing the educational advantages to them in participating in group collaborations.
- Students will be provided the opportunity to participate in daily scheduled video conferencing which will allow the students to participate in a real time learning experience, giving them access to a teacher and will allow for the ability to interact with other students in a Moodle environment.
- Students will be assigned to demonstrate their understanding of the Access user-interface elements (one element per student) by defining each of the major 10 Microsoft Access 2007 user-interface elements introduced in this lesson, using their group's wiki as their medium for exchanging ideas.
- Instructor will participate in all of the discussion, offering ideas and feedback.
- Students will be assigned a pre-test to determine any difficulties the students may be having grasping the concepts presented in this lessons .
- Students will be asked to complete a test, to determine any areas where further practice may be necessary.
Lesson 2: Download/Open/Edit/Save a Microsoft Access 2007, 'Database Template'.
Content type: Procedure
Teaching strategy:
- Provide reading assignment which explains the the elements that make up a database.
- Assign students to add to our collaborative glossary, with definitions of the technology concepts introduced in this lesson
- Assign students to download the Northwind 2007 template database from Microsoft Office.
- Provide reading assignment which describes the procedural steps to make design changes to templates in Access 2007.
- Provide students with instructions of modifications, they are to make to the tables and forms of their Northwind template database.
- Students will be provided the opportunity to participate in daily scheduled video conferencing which will allow the students to participate in a real time learning experience, giving them access to a teacher and will allow for the ability to interact with other students in a Moodle environment.
- Students will be assigned to upload their new database to the lessons assignment module.
- Students will provided an opportunity to correct any errors in their database discovered by the instructor, with feedback providing instructions to satisfy lesson requirements.
- Students will be assigned a pre-test to determine any difficulties the students may be having grasping the concepts presented in this lessons, post pre-test Instructor will provide student with feedback and direction to help insure the student has grasped the lessons materials. Grading will be based on the criteria of the course quiz/test grading rubric. 100% of learners will satisfactorily demonstrate their mastery of the concepts introduced in this lesson using this lesson's grading rubric
- Students will be asked to complete a test, to determine any areas where further practice may be necessary. Post test, the Instructor will provide student with feedback and direction to help insure the student has grasped the lessons materials, and provided an opportunity to retake lessons test.
Grading will be based on the criteria of the course quiz/test grading rubric. 100% of learners will satisfactorily demonstrate their mastery of the concepts introduced in this lesson using this lesson's grading rubric
- Instructor will participate in all of the discussion, offering ideas and feedback.
Lesson 3:
Content type: Procedure
Teaching strategy:
- Assign students a reading exercise introducing them to the concepts of 'Relationship Databases' vs. 'Flat database' concepts.
-
Assign reading exercise which defines the group database requirements.
-
Groups will use their group wiki to collaborate their plans for designing and debugging their group's relational database.
-
Assign students to create a group paper, using their wiki, listing and expanding on the procedural steps of designing and evaluating of their group database.
-
Instructor will participate in all of the discussion, offering ideas and feedback.
-
Students will be provided the opportunity to participate in daily scheduled video conferencing which will allow the students to participate in a real time learning experience, giving them access to a teacher and will allow for the ability to interact with other students in a Moodle environment.
Microsoft Access 2007
Lesson 1: Introduction to the Microsoft Access 2007 User-Interface
- Apply the skills necessary to access an assigned web site, download assigned project, with 100% accuracy. This will be documented by successfully uploading the assigned database to the instructor.Construct diagrams that accurately explain and demonstrate an instructor specified, database schema. This will be evaluated through database schema scored with a rubric, with 80% accuracy and thoroughness.
- Construct diagrams that accurately explain and demonstrate instructor specified modifications to the database schema. This will be evaluated through database schema scored with a rubric, with 80% accuracy and thoroughness
- Demonstrate the knowledge to explain database design terminology. This will be measured by a multiple choice exam, with the criteria of success being that 100% of students, scoring a minimum score of 70%.
- Analyze database schema and identify the best possible solution to a problem. This will be measured by a successfully implementing normalization of assigned database exercise, including the design and creation of tables, forms, and reports, with the criteria of success being that 100% of students successfully design and a database, based on instructors requirements.
- Demonstrate the knowledge and skills required to design an normalized Access database schema This will be measured by a multiple choice exam, with the criteria of success being that 100% of students scoring a minimum score of 70%.
Lesson 3: Database Schema and Normalization.
- Analyze database schema and identify the best possible solution to a problem. This will be measured by a successfully implementing normalization of assigned database exercise, including the building of tables, forms, and reports, with the criteria of success being that 100% of students successfully design and a database, based on instructors requirements.
- Demonstrate the knowledge and skills required to design an normalized Access database schema This will be measured by a multiple choice exam, with the criteria of success being that 100% of students scoring a minimum score of 70%.
No comments:
Post a Comment