Course Title: Create and use databases

Part B: Course Detail

Teaching Period: Term1 2009

Course Code: COSC5943C

Course Title: Create and use databases

School: 650T TAFE Business

Campus: City Campus

Program: C3216 - Certificate III in Business Administration

Course Contact : Janet McDonald

Course Contact Phone: +61 3 99255134

Course Contact Email:janet.mcdonald@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

There are no pre-requisites or co-requisites for this course.

Course Description

This course covers the use of database software to create simple two table relational databases with reports and queries, for the storage and retrieval of infomation in a business environment.


National Codes, Titles, Elements and Performance Criteria

National Element Code & Title:

BSBITU301A Create and use databases

Element:

Create a simple database.

Performance Criteria:

Design a simple relational database, with at least two tables, using a database application, basic design principles, software functions and simple formulae.

Develop a table with fields and attributes according to database usage, as well as data considerations and user requirements.

Create a primary key for each table.

Modify table layout and field attributes as required.

Create a relationship between the two tables.

Check and amend data entered, in accordance with organisational and task requirements.

Element:

Create reports and queries.

Performance Criteria:

Determine information output, database tables to be used and report layout to meet task requirements.

Determine data groupings, search and sort criteria to meet task requirements.

Run reports and queries to check that results and formulae provide the required data.

Modify reports to include or exclude additional requirements.

Element:

Use database

Performance Criteria:

Ensure data input meets designated time lines and organisational requirements for speed and accuracy.

Use manuals, user documentation and online help to overcome problems with database design and production.

Preview, adjust and print database reports or forms in accordance with organisational and task requirements.

Name and store databases, in accordance with organisational requirements, and exit application without data loss or damage.

Prepare and distribute reports to appropriate person in a suitable format.


Learning Outcomes



Details of Learning Activities

Learning activities will include class-based exercises, demonstrations and observations in order to develop competency, including the underpinning skills and knowledge.


Teaching Schedule

Week beginning Content Requirements
Week 1 - 9 Feb

Course Guide & Assessments; Office Procedures & Occupational Health and Safety

 
Week 2 - 16 Feb Office Procedures; Occupational Health and Safety & What is a database? Text
Week 10 - 20 Apr Section 1- Database Theory, Entering Simple Data, Field Types Text
Week 11 - 27 Apr Section 2 - Using a Database Form, Creating a Query, Creating a Report Text
Week 12 - 4 May Section 2 - Using a Database Form, Creating a Query, Creating a Report; Assessment Text & Printing credits
Week 13 - 11 May Section 3 - Creating a Database, Tables and Fields, Creating and Modifying a Form Text
Week 14 - 18 May Section 3 - Creating a Database, Tables and Fields, Creating and Modifying a Form & Section 4 - Queries and Reports Text
Week 15 - 25 May Section 4 - Queries and Reports & Assessment Text & Printing credits
Week 16 - 1 Jun Review Text
Week 17 - 8 Jun Final assessment  
Week 18 - 15 June Special Consideration Text & Printing credits


Learning Resources

Prescribed Texts

Cheryl Price & Julia Wix, Create and use databases Access 2003, BSBITU301A, Software Publications

1741238587


References


Other Resources


Overview of Assessment

Students must demonstrate an understanding of all elements of competency to be deemed competent.

Assessment methods have been designed to measure achievements of each element of competency in a flexible manner. Assessments will incorporate a variety of methods such as class exercises, practical projects and tests. Students are advised that they are likely to be asked to personally demonstrate their assessment work to their teacher to ensure that the relevant competency standards are being met.

In addition to the assessments, formative feedback is provided to the students throughout the duration of the course.

Learning activities will include class-based discussions, exercises, reading and reflection in order to develop competency including underpinning skills and knowledge.


Assessment Tasks

Students will complete a number of documents which focus on both the practical and theory component of developing and using a database, including employability skills. The assessments will be held in class as indicated on the Teaching Schedule, are open book and are to be completed individually.


Assessment Matrix

Element of Competency Week 12 Week 15 Week 17
Create a simple database Yes Yes Yes
Create reports and queries   Yes Yes
Use database Yes Yes Yes

Other Information

Employability Skills

This course/competency includes the employability skills listed below which are assessable under the Business Services Training Package.

In order to be able to effectively demonstrate the required employability skills during the course, students should participate and aim to attend punctually. Students are required to contribute to 80% plus of required classes. Please note that employability skills are assessed across the entire program.

Employability skills are a core component of the competency and if a student is unable to effectively demonstrate these skills within the competency, a mark of  NYC (Not Yet Competent) will be given for the course.

Employability skills identifed for this course are:

Communication

Problem solving

Planning and organising

Self-management

Learning

Technology

From July 2008 students issued with Training Package qualifications have been informed by their Registered Training Organisation that Employability Skills Summaries for Training Package qualifications can be downloaded from http://employabilityskills.training.com.au. Registered Training Organisations are required to add the mandatory sentence providing the URL for the Employability Skills Summaries to Training package and qualification testamurs from 1 January 2009. The Australian Qualification Framework Implementation Handbook has been amended to show this requirement.

Course Overview: Access Course Overview