Course Title: Identify physical database requirements
Part B: Course Detail
Teaching Period: Term1 2011
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. |
Element: |
2. Identify database requirements |
Performance Criteria: |
2.1 Review technical specifications for the database. |
Element: |
3. Identify security requirements |
Performance Criteria: |
3.1 Review system security plan |
Element: |
4. See client feedback and approval |
Performance Criteria: |
4.1 Present database scope, technical requirements and security documentations to user for feedback |
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 Beginning | Class Content | Elements | |
| Week 1 - 7th Feb | 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 - 14th Feb | WORD Formats, spacing Purpose of business documents Layout of business documents Letters/letterheads |
ICAU1129A 1.1-4, 2.1-6 |
|
| Week 3 - 21st Feb | 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 - 28th Feb | WORD Proofreading symbols Using tabulation |
ICAU1129A 1,1-4 2.1-6 3.1-5 |
|
| Week 5 - 7th March | WORD 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 6 - 14th March | USING POWERPOINT - page layout - text enhancements - using templates |
ICAU3126A 1,1-4 2.1-4 |
|
| Week 7 - 21st March | POWERPOINT 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 - 28th March | POWERPOINT Developing a slide show |
Newsletter (10%) due | ICAU3126A 1,1-4 2.1-4 |
| Week 9 - 4th April | EXCEL Designing a spreadsheet Basic formula |
Slideshow Presentation (15%) due | ICAU3126A 1,1-4 2.1-4 |
| Week 10 - 11th April | EXCEL Customising a formula Creating graphs |
ICAU3126A 1,1-4 2.1-4 |
|
| Week 11 - 18th April | EXCEL Class exercises |
ICAU3126A 1,1-4 2.1-4 |
|
| Week 12 - 2nd May | EXCEL Class exercises |
General Store Superannuation (15%) |
ICAU3126A ICAU1129A |
| Week 13 - 9th May | ACCESS 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 - 16th May | 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 15 - 23rd May | ACCESS Class exercises |
ICAB4060A – 1, 1-4 2. 1-4 |
|
| Week 16 - 30th May | Finalise Portfolio documents TEST |
Integrated Assignment (20 %) | ICAB4060A 3,1-3 4.1-3 |
| Week 17 - 6th June | Outstanding Assessment |
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