Course Title: Identify physical database requirements

Part B: Course Detail

Teaching Period: Term1 2012

Course Code: COSC5347C

Course Title: Identify physical database requirements

School: 345T Media and Communication

Campus: City Campus

Program: C4197 - Certificate IV in Creative Industries

Course Contact : Program Administration - Adam Lovell

Course Contact Phone: 03 9925 4976

Course Contact Email:adam.lovell@rmit.edu.au


Name and Contact Details of All Other Relevant Staff

Teacher: Viv Weir
Phone: 03 9925 8012
Email: viv.weir@rmit.edu.au

Nominal Hours: 40

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

This course is taught and assessed with the competencies Operate a Word Processing Application (ICAU1129A) and Use Advanced Features of Computer Applications (ICAU3126A) None

Course Description

This course requires students to create a physical database using a data dictionary and design specifications. This course is co-delivered with ICAU3126A and ICAU1129A.


National Codes, Titles, Elements and Performance Criteria

National Element Code & Title:

ICAB4060A Identify physical database requirements

Element:

1.  Identify database scope

Performance Criteria:

1.1 Review requirements of the user and current system architecture.
1.2 Determine database size from requirements and technical specifications
1.3 Document database and scope of project.
1.4 Evaluate several database management systems against requirements and make appropriate selection

Element:

2.  Identify database requirements

Performance Criteria:

2.1 Review technical specifications for the database.
2.2 Identify database tables and relationships
2.3 Identify database data dictionary, table attributes and keys
2.4 Develop database reports based on acceptance criteria and requirements

Element:

3.  Identify security requirements

Performance Criteria:

3.1 Review system security plan
3.2 Clarify and confirm chosen database management system and user security required for the database to ensure database security is aligned to security system plan
3.3 Identify, evaluate and record database performance, recovery and audience needs

Element:

4.  See client feedback and approval

Performance Criteria:

4.1 Present database scope, technical requirements and security documentations to user for feedback
4.2 Review user feedback and adjust database as required
4.3 Present database and documentation to user for final approval


Learning Outcomes


On successful completion of this unit, you will be able to design and modify database information for specific purposes.


Details of Learning Activities

Learning activities will consist of:-
• demonstrations
• practical exercises
• independent project based work.


Teaching Schedule

Week BeginningClass Content Elements
Week 1 WORD
Email – logging onto RMIT system
Accessing Blackboard
Setting up passwords
Ergonomic principles and practices
General O.H. & S. principles and responsibilities
Establish assessment requirements
Word applications
 ICAU1129A – 1.1-4
Week 2 WORD
Formats, spacing
Purpose of business documents
Layout of business documents
Letters/letterheads
 ICAU1129A 1.1-4,
2.1-6
Week 3 WORD
Business documents – mail merge
using templates
Tabulation
 ICAU1129A
1,1-4
2.1-6
3.1-5
6.1-3
7.1-3
Week 4 WORD
Proofreading symbols
Using tabulation
 ICAU1129A
1,1-4
2.1-6
3.1-5
Week 5WORD
Creating tables, forms and
columns
Portfolio Exercise 3 -Business documents/Merged documents (25%)ICAU1129A
2.1-6
3.1-5
4.1-4
5.1-2
Week 6USING POWERPOINT
- page layout
- text enhancements
- using templates
 ICAU3126A
1,1-4
2.1-4
Week 7POWERPOINT
Using Graphics – Word Art and Clip Art
Leaflets – Combining graphics and text

Developing a slide show
 ICAU3126A
1,1-4
2.1-4
Week 8 POWERPOINT
Developing a slide show
Newsletter (10%) dueICAU3126A
1,1-4
2.1-4
Week 9 EXCEL
Designing a spreadsheet
Basic formula
Slideshow Presentation (15%) dueICAU3126A
1,1-4
2.1-4
Week 10EXCEL
Customising a formula
Creating graphs
 ICAU3126A
1,1-4
2.1-4
Week 11 EXCEL
Class exercises
 ICAU3126A
1,1-4
2.1-4
Week 12EXCEL
Class exercises
General Store Superannuation (15%)

ICAU3126A
1,1-4
2.1-4

ICAU1129A
1,1-4 ,2.1-6
3.1-5,4.1-4
5.1-2 ,6.1-3
7.1-3

Week 13ACCESS
Designing a database
Purpose
Structure
Relative/absolute formula
Data filters
Creating queries
Portfolio Ex. 9 – Tennis Club (5%)

ICAB4060A

1,1-4,2.1-4

ICAU1129A
1,1-4 , 2.1-6
3.1-5

Week 14 CCESS
Customising queries
Designing reports Designing and creating your own database
Class exercises
Tennis Club /Your own database (15%)ICAB4060A – 1, 1-4, 2. 1-4
Week 15ACCESS
Class exercises
 ICAB4060A – 1, 1-4
2. 1-4
Week 16 Finalise Portfolio documents
TEST
Integrated Assignment (20 %)ICAB4060A 3,1-3
4.1-3
    


Learning Resources

Prescribed Texts

Class handouts


References

You are advised to look at the course Blackboard site for ongoing updated information.


Other Resources

USB storage - memory stick


Overview of Assessment

Students are to develop a Portfolio of documents which will include ten (10) examples of  work.


Assessment Tasks

To demonstrate competency in this course, you will need to complete the following pieces of assessment to a satisfactory standard. You will receive feedback on all assessment.

PORTFOLIO

Assessment Task No 1
Portfolio Exercises 1 and 2 – Business Documentation 15%
Students are to incorporate student learning of business documentation and ergonomic principles and practices. Due Week 4

Assessment Task No 2
Portfolio Exercise 3 – Merged Documents 10%
Students are to incorporate student learning of mail merge and manipulating data. Due Week 5

Assessment Task No 3
Portfolio Exercise 4 and 5 – Newsletter 10%
Students are to incorporate student learning of text enhancements and page layout. Due Week 8

Assessment Task No 4
Portfolio Exercises 6 - PowerPoint
Slideshow Presentation 15%
Students are to incorporate student learning of PowerPoint and graphical presentation. Due Week 9

Assessment Task No 5
Portfolio Exercises 7 and 8 - Excel
General Store 5%
Superannuation 10%
Students are to incorporate student learning of Excel using basic and customised formula and graphical information. Due Week 11 & 12

Assessment Task No 6
Portfolio Exercises 9 and 10 – Access
Tennis Club Database 5%
Personal Database 10%
Students are to incorporate student learning of Access using basic to advanced data base skills. Due Week 13 & 14

Assessment Task No 6
Integrated Assignment 20%
Students are to incorporate all student learning by submitting a portfolio of the semester’s work and undertaking a final test.
Due week 16


For further information on the assessment and grading system and criteria used, please refer to the course blackboard site.

Grades used in this unit are as follows:

Grades which apply to curriculum-based courses:
80 – 100% HD High Distinction
70 – 79% DI Distinction
60 – 69% CR Credit
50 – 59% PA Pass
Under 50% NN Fail


Assessment Matrix

The assessment matrix demonstrated alignment of assessment tasks with the relevant Unit of Competency. These are available through the course contact in Program administration

Other Information




Special consideration Policy (Late Submission)
All assessment tasks are required to be completed to a satisfactory level. If you are unable to complete any piece of assessment by the due date, you will need to apply for an extension.
Please refer to the following URL for extensions and special consideration:
http://www.rmit.edu.au/browse;ID=qkssnx1c5r0y;STATUS=A;PAGE_AUTHOR=Andrea%20Syers;SECTION=1;

Course Overview: Access Course Overview