Course Title: Build a database
Part B: Course Detail
Teaching Period: Term2 2011
Course Code: COSC5317C
Course Title: Build a database
School: 650T TAFE Business
Campus: City Campus
Program: C5194 - Diploma of Information Technology (General)
Course Contact : Chandra Nannegari
Course Contact Phone: +61 3 99251657
Course Contact Email:Chandra.Nannegari@rmit.edu.au
Name and Contact Details of All Other Relevant Staff
Nominal Hours: 30
Regardless of the mode of delivery, represent a guide to the relative teaching time and student effort required to successfully achieve a particular competency/module. This may include not only scheduled classes or workplace visits but also the amount of effort required to undertake, evaluate and complete all assessment requirements, including any non-classroom activities.
Pre-requisites and Co-requisites
None
Course Description
This unit defines the competency required to build and implement a database using an established design.
National Codes, Titles, Elements and Performance Criteria
National Element Code & Title: |
ICAB4170A Build a database |
Element: |
1. Confirm database design |
Performance Criteria: |
1.1 Review database design documentation, including data structures, queries, reports and user interface |
Element: |
2. Create prototype |
Performance Criteria: |
2.1 Develop prototype according to database design |
Element: |
3. Test database |
Performance Criteria: |
3.1 Develop implementation plan for the database |
Element: |
4. Evaluate database |
Performance Criteria: |
4.1 Review database with client for final approval |
Learning Outcomes
Details of Learning Activities
Theory sessions, practical lab sessions, tutorial sessions, assignments and homework.
Teaching Schedule
Week beginning | Topic/Learning Activities | Practical Laboratory Session Topics and Assessments |
Week 1 – 4th July 2011 | Introduction to Course. Data Structures | Teacher handouts in-class exercises. Worksheet for Assessment 1 |
Week 2 – 11th July 2011 | VBA basics. Variables, Types, Assignments, Subs, Functions. | Teacher handouts in-class exercises Submit Worksheet for Feedback. |
Week 3 – 18th July 2011 | VBA basics : Loops | Teacher handouts in-class exercises Worksheet for Assessment 1 |
Week 4 – 25th July 2011 | VBA continued. | Worksheet for Feedback. |
Week 5 – 01st Aug 2011 | Logical database design | Teacher handouts in-class exercises Submit Worksheet for Feedback. |
Week 6 – 08th Aug 2011 | GUI Components: Forms | GUI components. Project Posting for Assessment 2. |
Week 7 – 15th Aug 2011 | GUI components Continued. | GUI components – continued. Submit Worksheet for Feedback. |
Week 8 – 22nd Aug 2011 | Form & Subform | Worksheet for Assessment 1. |
Vacation: Mid - Semester break - Mon 29th Aug - Fri 2nd Sept, 2011 | ||
Week 9 – 05th Sept 2011 | Confirm DB Design. | Worksheet for Assessment 1. |
Week 10 – 12th Sept 2011 | Prototype Created and populated. | Prototype populated. Worksheet for Assessment 1 |
Week 11 – 19th Sept 2011 | Test Data Developed. | Submit “Logical data model” part of Project. Worksheet for Assessment 1 |
Week 12 – 26nd Sept 2011 | Implementation plan. Post implementation review. | Worksheet for Assessment 1. Project Feedback. |
Week 13 – 3rd Oct 2011 | Evaluate Database | Worksheet for Assessment 1 |
Week 14 – 10th Oct 2011 | Project Work | Project Work |
Week 15 – 17th Oct 2011 | Assessment 2: Project submission and demonstrations. Revision Feedback on Competency (CA / NYC) | |
Week 16 – 24th Oct 2011 | Assessment – 3 : TEST |
Learning Resources
Prescribed Texts
1. Jeffrey A. Hoffer, Prescott & Topi, Modern Database Management 9/E , Prentice Hall, ISBN 978-0-13-600391-5 |
|
2. Microsoft Office Access Help (Accompanying MS Access) |
References
1. David M. Kroenke, Database Processing: Fundamentals, Design & Implementation, 9th Edition. Prentice Hall, ISBN 0-13-120971-X |
|
2. Smith & Sussman, Beginning Access 2000 VBA Wrox, ISBN 1-861001-76-2. |
Other Resources
Overview of Assessment
Assessment tasks will consist of a portfolio of in-class exercises, a project with associated documentation, and a combined theory and practical test.
You will be provided with feedback throughout the course to check your progress.
You are advised that you are likely to be asked to personally demonstrate your assessment work to your teacher to ensure that the relevant competency standards are being met.
Assessment Tasks
Assessment 1 (Worksheets): 30%
The purpose of these worksheets is to provide feedback to students from class exercises. Printouts are to be submitted during class. In addition, Elements of the competency will be assessed through the class exercise worksheets.
Assessment 2 (Project ): 45%
The purpose of this project is to ensure that students are able to implement all the skills they have developed to date.
Firstly, students will be required to build a database prototype using client specifications in MS Access / MS SQL Server / MySQL.
Test data will be loaded, and queries will be created in SQL. Forms, reports and VBA modules will also be required. Basic security features will be implemented.
Implementation plan will be developed, post implementation review is conducted, system documentation is written and user training requirements are identified.
Assessment 3 (TEST): 25%
A final Test will be offered to students who have achieved CA.
Assessment Matrix
ICAITB170A - Build a Database |
Assessment – 1 Worksheets CA / NYC & 30% |
Assessment – 2 Project CA / NYC & 45% |
Assessment – 3 TEST 25% |
Confirm database design | Yes | Yes | |
Create prototype | Yes | Yes | Yes |
Test database | Yes | Yes | Yes |
Evaluate database | Yes | Yes |
Other Information
Competency Requirements:
To be deemed competent students must demonstrate an understanding of all elements of this competency. Assessment methods have been designed to measure achievement of each competency in a flexible manner over multiple tasks.
Students are advised that they are likely to be asked to personally demonstrate their work to their teacher to ensure that the relevant competency standards are being met.
All competency-based assessments for this course must be completed in order to achieve a CA (Competency Achieved) award.
Each assessment task will also carry a numerical weighting to be used for grading purposes. The grade applied will only be awarded if a CA has been achieved in all compulsory assessment tasks.
If a student has been assessed as NYC (Not Yet Competent) in any of the assessment tasks, the weighting will carry no value until the student has obtained a CA.
If a CA is achieved on re-assessment, a maximum mark of 50% of the original weighting will be granted for that assessment.
Re-assessments will only be granted to students who were either unsuccessful in the first attempt, or have an approved application for special consideration.
A final TESTworth 25% will be offered to students who have achieved CA.
Course Overview: Access Course Overview