Designing and Developing a Database Part 1 The logical database design

Teacher Instructions

This webquest is to be used in conjunction with this lesson set over a 12 week period. It is envisioned the teacher will run each lesson as planned in each lesson plan, using the webquest in each lesson for students to conduct activites to reflect the learning outcomes of each lesson.

Teacher Resources attached :

Overview document: describing a three month lesson set and learning outcomes.

Forward Planning Document for the 12 week lesson set.

A lesson plan for each lesson in the 12 week set.

Business resource kit - containing business and project documentation.

Database resource kit - containing internet and book references on Database Design.

 Learning Area Outcome Focus for this 12 week lesson set.

Technology process:

Students apply a technology process to create or modify products, processes, systems, services or environments to meet human needs and realise opportunities.

Information:

Students design, adapt, use and present information that is appropriate to achieving solutions to technology challenges.

Enterprise:

Students pursue and realise opportunities through the development of innovative strategies designed to meet human needs.

This 12 week course is the first part in a six part set which covers the design and development of a database and the use of the Microsoft suite of software packages.

It is designed to be taught to a year 9 class at level three and/or four. The following comprises the six sections each section being a 12 week course.

Lessons          1 � 12              Designing and Developing a Database.

Lessons          12 � 24            Accessing a Database with Microsoft Excel.

Lessons          24 � 36            Accessing a Database with Microsoft Word.

Lessons          36 � 48            Accessing a Database with Microsoft Publisher.

Lessons          48 � 60            Accessing a Database with integrated packages of

Microsoft Excel, Word, Publisher.

Lessons          61 � 73            Creating a database driven website.

By the end of the first set of 12 lessons, students will have acquired the skills to meet the three Learning Area Outcomes of Technology Process, Information and Enterprise through the design and development of a database using Microsoft Access.

It is envisioned that in the following five parts of the course, students will have the skills to be able to design and develop an application database with confidence in the first few weeks of each set of 12 week lessons in preparation for the use/access of the Microsoft software application. The main part of the learning will be in the use/access of the database using the microsoft software application in each lesson set.

Assessment for the 12 week lesson set.

Assessment consists of a final portfolio which contains material produced during each of the 12 lessons, and in-class assessment each week.

Weekly In-class assessment             50%

Final Portfolio                          50%

Overarching Outcomes covered in the 12 weeks of lessons

Values in the Curriculum Framework that are to be respected during these 12 weeks of lessons.

1.1  The pursuit of personal excellence:

 Each person should be encouraged to achieve his or her personal best in all undertakings and to respect the achievements of others.

1.2  Empowerment:

Each person should be encouraged to develop critical thinking, the

 creative imagination, interpersonal and vocational skills, and basic competencies in the various forms of disciplined inquiry.

2.1 Individual uniqueness:

 Each person should acknowledge his or her own uniqueness and be encouraged to develop self-respect and dignity.

2.2 Personal meaning:

Each person should develop a sense of personal meaning and identity, and be encouraged to reflect critically on the ways in which that occurs.

3.1 Compassion and care:

Each person has a right to receive care and compassion and have a life of dignity, free from harassment and discrimination.

3.3 Respect:

Each person should respect those of different opinion, temperament or background.

3.4 Open learning environment:

 Each person has the right to a friendly learning environment free of coercive or indoctrinative elements, whether in the explicit or implicit curriculum

3.5 Individual differences:

Each person differs in his or her readiness and ability to learn and has the right to be given access to available knowledge at a level appropriate to his or her developmental needs and interests.

3.6 Cooperation/Conflict resolution:

Each person should strive to work cooperatively and to resolve conflict peacefully while respecting differences and valuing the other person.

4.6 Reconciliation:

Strategies of cooperation and reconciliation are preferred to coercion and confrontation, especially where groups or individuals are in conflict.