Course Title: Create and use databases

Part B: Course Detail

Teaching Period: Term1 2010

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 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

  Weekly Schedule  
Week beginning Content Requirements
Week 5 – 8 Mar Section 1 – Database Theory; Entering Simple Data; Field Types Text
Week 6 – 15 Mar Section 2 – Creating a Query; Creating a Report Text
Week 7 – 22 Mar Section 2 – Creating a Query; Creating a Report
Assessment 1 		Text & Printing credits
Week 8 – 29 Mar Section 3 – Tables and Fields; Creating and Modifying a Form Text
  Easter Break 1 April – 6 April Text
Week 8 – 5 Apr Section 3 – Tables and Fields; Creating and Modifying a Form Text
Week 9 – 12 April

Assessment 2

Section 4 – Queries and reports

Text & Printing credits
Week 10 – 19 April

Section 4 – Queries and reports

Assessment 3

 Text & Printing credits
Week 11 – 26 April Final assessment Text & Printing credits


Learning Resources

Prescribed Texts

Price & Wix, Create and use databases (Access 2003), Software Pulbications

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. 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 Assess 1 Assess 2 Assess 3 Assess 4
Create a simple database     √ √
Create reports and queries   √   √
Use database √     √

Other Information

In adherence with RMIT’s commitment to sustainability, course teachers will seek to incorporate environmental concerns in the facilitation of this course. These include, but are not limited to:
• Conserving natural resources
• Using recycled materials wherever possible
• Minimising pollution
• Applying energy savings measures
• Reducing waste
Students are encouraged to identify and follow environmental and resource efficient ways of working whilst studying this course.

Course Overview: Access Course Overview