Course Title: Computer Applications (1999)
Part B: Course Detail
Teaching Period: Term2 2011
Course Code: ISYS5415
Course Title: Computer Applications (1999)
School: 130T Engineering (TAFE)
Campus: City Campus
Program: C6016 - Advanced Diploma of Engineering Technology (Principal Technical Officer)
Course Contact : Program Manager
Course Contact Phone: +61 3 9925 4668
Course Contact Email:engineering-tafe@rmit.edu.au
Name and Contact Details of All Other Relevant Staff
Co-ordinator: Leon Mattatia
Telephone 9925 4668
Email: leon.mattatia@rmit.edu.au
Teacher: Mark Burns
Telephone: 9925 4604;
Fax: 9925 4377
Email: mark.burns@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
Delvered in conjunction with this module:
EA 050 Engineering Computing
Course Description
The purpose of this module is to provide participants with the skills, knowledge and attitudes required to design and implement spreadsheets and data bases to meet business application needs, using appropriate computer software packages.
National Codes, Titles, Elements and Performance Criteria
National Element Code & Title: |
VBH626 Computer Applications (1999) |
Learning Outcomes
On completion of this module the learner should be able to:
1. Use appropriate computer software packages to produce customised spreadsheets and graphical representations, including slideshow presentations to meet business application needs.
2. Use appropriate computer software packages to produce customised databases to meet business application needs.
Details of Learning Activities
You will be working in a computer laboratory developing/reinforcing your Excel, Access, PowerPoint and macro skills, so that you have all the Office computer skills needed to successfully complete your program and prepare for your professional career.
The total number of scheduled hours of teaching, learning and assessment involved in this course includes all planned activities (face to face classes, lectures, workshops and seminars; workplace visits, online learning and other forms of structured teaching and learning). It also covers the amount of effort necessary to undertake, evaluate and complete all assessment requirements, observation of work performance, discussions with supervisors and others providing third party evidence and one on one and group assessment sessions with students.
Teaching Schedule
NB: Parts of excel and access will be co-delivered (sessions 6-14) and co-assessed with Operate Computing Packages.
Session No. 16 Topic: Set-up macro commands for execution within spreadsheets. LO1.1 Refer Assess. matrix
Session No.6-9 Topic: Design and implement a customised spreadsheet to meet a business application need. 1.2 Refer Assess. matrix
Session No.6-9 Topic: Use all of the spreadsheet graph commands to convert spreadsheet data into graphic screen and hard copy displays. 1.3 Refer Assess. matrix
Session No.16 Topic: Combine macro and graphical commands to execute slideshow displays of data in graphical format. 1.4 Refer Assess. matrix
Session No.16 Topic: List and discuss the features and uses of commercially available database packages. 2.1 Refer Assess. matrix
Session No.11-14 Topic; Carry out interactive commands on multifile databases. 2.3 Refer Assess. matrix
Session No.11-14, & 16 Topic: Design a database for a business application. 2.4 Refer Assess. matrix
Session No.11-14 Topic: Develop simple database application programs using appropriate computer software. 2.5 Refer Assess. matrix
Learning Resources
Prescribed Texts
None. |
References
Other Resources
Notes and exercises are provided.
Overview of Assessment
Assessment for this module will consist of the following:
Written assignment
Practical demonstration of computer skills
Assessment Tasks
Assessment Task No. (ATN) CO = Classroom observation.
ATN 1 –EXCEL: class test (22%) (Operate Computing Packages): design and create spreadsheet question + CO.
ATN 2 – ACCESS: workplace simulated test (open book) (28%) (Operate Computing Packages) + CO.
ATN 3 – Computer Applications (1999) test (50%)
Assessment Matrix
ATN = Assessment Task Number. CO = Classroom observation. LO = Learning Outcome.
LO 1.1 Set-up macro commands for execution within spreadsheets. ATN3.
LO 1.2 Design and implement a customised spreadsheet to meet a business application need. ATN1.
LO 1.3 Use all of the spreadsheet graph commands to convert spreadsheet data into graphic screen and hardcopy displays. ATN1.
LO 1.4 Combine macro and graphical commands to execute slideshow displays of data in graphical format. ATN3.
LO 1.5 Install and configure a spreadsheet package onto a microcomputer. CO.
LO 2.1 List and discuss the features and uses of commercially available database packages. ATN3.
LO 2.2 Install and configure a database package onto a microcomputer. CO.
LO 2.3 Carry out interactive commands on multifile databases. ATN2.
LO 2.4 Design a database for a business application. ATN3.
LO 2.5 Develop simple database application programs using appropriate computer software.ATN2.
Other Information
Grading Criteria
NN 0-49% Fail
PA 50 – 59% Pass
CR 60 – 69% Credit
DI 70 – 79% Distinction
HD 80-100% High Distinction
Course Overview: Access Course Overview