Microsoft Access Lesson Plan- Teachers

AS: How do you currently keep track of information for a class trip?

Objectives: Teachers will use Microsoft Access to create a database to track payments, permission slips and chaperones for a grade level class trip

Subject: Technology, Databases

Activities:

Your Grade Level/Subject Area Team is planning a field trip to culminate a unit of study. The planning will involve collecting multiple payments, permission slips, and securing chaperones for the trip. Typically you would keep handwritten records of the progress, but this time you will make the leap and use the technology available on your district-issued laptop.

Creating the database:
Teachers will launch Microsoft Access from the Start Menu
Teachers will name their database so it can be easily identified
Teachers will protect their database by assigning it a password
Teachers will start by creating a table for the students that will be going on the field trip
Teachers will define fields, then create and save a table from the Design View
First Name, Last Name, Address, HomePhone, StudentCell, Parent1, ParentCell1, Parent2, Parent Cell2, Emergency Contact, EmergencyPhone
Teachers will enter student data into the table

Adding a new table:
Teachers will also create the following tables:
Class/Section (for individual classes)
Payment
Permission Slip
Chaperone
Group
Teachers will enter the appropriate data into each table

Updating the database:
Teachers will open the field trip database to update data as necessary

Querying the database:
Teachers will create a query to view the payments made by students in each class or section
Teachers will create a query to view the students that have not yet returned a permission slip
Teachers will run a parameter query on the database to view information for a specific student
Teachers will use calculations to determine the total paid by each student
Teachers will use the Totals row to determine the total paid by all students

Creating a report:
Teachers will create a report of the students that still need to return a permission slip or payment for the trip

Closure:

Vocabulary: Database, record, field, table, query, report, calculation, totals, aggregate function

Materials: Microsoft Access, collected permission slips and payments

Evaluation: Teacher Observation

NETS Standards:
3. Model Digital-Age Work and Learning
Teachers exhibit knowledge, skills, and work processes representative of an innovative professional in a global and digital society. Teachers:
a. demonstrate fluency in technology systems and the transfer of current knowledge to new technologies and situations.
b. collaborate with students, peers, parents, and community members using digital tools and resources to support student success and innovation.
d. model and facilitate effective use of current and emerging digital tools to locate, analyze, evaluate, and use information resources to support research and learning.
5. Engage in Professional Growth and Leadership
Teachers continuously improve their professional practice, model lifelong learning, and exhibit leadership in their school and professional community by promoting and demonstrating the effective use of digital tools and resources. Teachers:
a. participate in local and global learning communities to explore creative applications of technology to improve student learning.
b. exhibit leadership by demonstrating a vision of technology infusion, participating in shared decision making and community building, and developing the leadership and technology skills of others.
d. contribute to the effectiveness, vitality, and self-renewal of the teaching profession and of their school and community.