Course Title: Use laboratory application software

Part B: Course Detail

Teaching Period: Term1 2022

Course Code: OFFC5338C

Course Title: Use laboratory application software

School: 535T Social Care and Health

Campus: City Campus

Program: C4411 - Certificate IV in Tertiary Preparation

Course Contact: Rauha Quazi

Course Contact Phone: +61 3 9925 4277

Course Contact Email: rauha.quazi@rmit.edu.au


Name and Contact Details of All Other Relevant Staff

Namrita Kaul

 namrita.kaul@rmit.edu.au

Nominal Hours: 60

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

None

Course Description

This unit of competency describes the skills and knowledge to use and apply computer software for analysing and reporting in the laboratory, field and/or production plants.


National Codes, Titles, Elements and Performance Criteria

National Element Code & Title:

MSL924004 Use laboratory application software

Element:

1 Access application software

Performance Criteria:

1.1

Identify software required for the task

1.2

Open software from a personal computer or network terminal

1.3

Use information sources to locate details of software features and instructions for its use

Element:

2 Use software for specified purposes

Performance Criteria:

2.1

Input a range of scientific data into a computing system

2.2

Conduct searches for the retrieval of required data

2.3

Use application features for efficient computation

2.4

Construct data sets and databases for numerical and graphical analyses

Element:

3 Produce reports of retrieved data and/or processed data

Performance Criteria:

3.1

Analyse data using features of the software package

3.2

Select options for constructing data reports

3.3

Print the results of data analyses using features of the software package

3.4

Integrate data from diverse application software units in a report

3.5

Report the outcomes and rationale for database searches

3.6

Reference data sources according to the style requirements of the workplace

Element:

4 Perform simple record housekeeping

Performance Criteria:

4.1

Maintain archived data according to workplace standard procedures

4.2

Maintain hard copy data according to workplace standard procedures


Learning Outcomes



Details of Learning Activities

This course is conducted with a combination of;

  • Lectures
  • In class/online worksheet exercises
  • Online learning activities
  • Individual and Group discussions 


     


Teaching Schedule

2022 s1 Teaching Schedule


Week No

Week starting

Topic

Comments

1

7 feb

  • Introduction to  myRMIT,
  • Canvas, RMIT student email
  • Create documents, Basic formatting of documents, Manage files
  • Workplace procedures to save and retrieve data (hard copy and soft copy)

 

2

14 feb

  • Identify and use a software
  • Create spreadsheets in Excel
  • Use Word and Excel to create documents     
  • Maintain hard copies and archived data

 

3

21 feb

  • Calculations and Graphs in Excel
  • Create reports using Word and Excel
  • Reference data sources according to workplace requirements 

 

4

28 feb

  • Continue with previous week
  • More examples to integrate word and excel

 

5

7 mar

  • More on performing calculations and graphs in Excel
  • Create reports using software

 

6

14 mar

  • Mail Merge and applications of Mail Merge
  • Use information sources to locate details of software features and instructions for its use

Assessment Task #1

7

21 mar

  • Terminology used/Workplace standard procedures
  • Legal, ethical and WHS requirements
  • Importance of antivirus software and standard quarantine procedures

 

8

28 mar

  • Understand a Database
  • Create a Database

 

9

4 apr

  • Continue with Databases

Assessment Task 2 released

10

11 apr

  • Analysing data using software (using software packages, word, excel, database)

Mid semester break

(14 – 20 apr)

10

18 apr

11

25 apr

  • Maintain a database
  • Create reports in a database

 

12

2 may

  • Linking Packages(software)

Assessment Task 2 due

13

9 may

  • Terminology associated with software packages
  • Application of specific software package features to laboratory tasks relevant to job role

 

14

16 may

  • Data Protocol and file storage of data
  • General file and record maintenance
  • Maintain archived data according to workplace standard procedures
  • Maintain hard copy data according to workplace standard procedures

 

15

23 may

Revision

Assessment Task 3

Assessment Period

16

30 may

Finalise Results


Learning Resources

Prescribed Texts


References


Other Resources

Resources:

Course handouts will be provided during the classes and also available on Canvas Course shell.

There are no prescribed texts for this course. Materials will be provided via the online learning management system, CANVAS.

You will need access to a computer, some basic software, e.g.: Microsoft Word  and an internet connection. You may receive some of your learning materials in hard copy, CANVAS still remains the resource for most of your course.


The University Library has extensive resources and provides subject specialist expertise, research advice, help with referencing and support through: 

The Learning Lab 
https://www.rmit.edu.au/students/study-support/learning-lab 

The Study Support Hub  
https://www.rmit.edu.au/students/study-support/study-support-hub 

English for uni workshops 
https://www.rmit.edu.au/students/study-support/workshops/english-uni-workshops


Overview of Assessment

Assessment may include

knowledge tests

observation of skills

reports

folio of completed work


Assessment Tasks

Students enrolled in Vocational Education and Training qualifications are assessed for Competency. To be assessed as Competent means you have consistently demonstrated the required knowledge and skills at a standard expected in the workplace.  

To be assessed as Competent in this course, you will need to complete each assessment task to a satisfactory standard. You will receive feedback from the teacher at the conclusion of each assessment task. 


You should refer to the assessment brief which is available through Canvas for full assessment criteria and due dates.


No

Name of Assessment Task

Method of Assessment

Task 1

Using Software Packages

An activity will be conducted during the class time in the class room.(online)

Task 2

Managing Databases

An ongoing activity to be completed during weeks 8 and 13

Task 3

Knowledge Test

Written Test to be conducted during class time


Results that apply to courses that are delivered and assessed in accordance with competency-based assessment are:

CA Competency Achieved  
NYC Not Yet Competent
DNS Did Not Submit for assessment


To successfully complete the course, you need to achieve a satisfactory result for every assessment.
You will be given two attempts for each assessment to demonstrate the required skills.

A third attempt can only be offered after discussions between teacher and the Program Coordinator and is not automatic.


Assessment Matrix

The assessment matrix demonstrates alignment of assessment tasks with the relevant unit of competency. These mapping documents are available through Program Administration if required.

Other Information

Attendance: 

Your learning experience will involve class-based teaching, discussion, demonstration and practical exercises  

It is strongly advised that you attend all timetabled sessions. This will allow you to engage in the required learning activities, ensuring you the maximum opportunity to complete this course successfully. 

 

Extensions of time for submission of assessable work:

If you are prevented from submitting an assessment on time by circumstances outside your control you may apply for an extension of up to seven (7) calendar days in writing (email) to your Program Coordinator one working day BEFORE the due date. Eligibility criteria for application and the form is available from the link:

https://www.rmit.edu.au/students/student-essentials/assessment-and-exams/assessment/extensions-of-time-for-submission-of-assessable-work

Where an extension of greater than seven days is needed, you must apply for special consideration.

 

Special consideration:

If due to illness or other unforeseen circumstance, you are unable to attend on the due date of an assessment (e.g. test, examination, oral, etc.) OR you do attend, but your performance has been affected, you may submit an APPLICATION FOR SPECIAL CONSIDERATION within 2 working days of the due date. If Special Consideration is granted, you will be given the opportunity to complete/repeat the assessment task at a later date. For advice on this application please visit www.rmit.edu.au/students/specialconsideration  or speak to your Program Coordinator.

 


Academic Integrity and Plagiarism:  

RMIT University has a strict policy on plagiarism and academic integrity. Please refer to the website for more information on this policy. 

https://www.rmit.edu.au/students/student-essentials/assessment-and-exams/academic-integrity 

 

Credit Transfer and Recognition of Prior Learning:  

Credit transfer is the recognition of previously completed formal learning (an officially accredited qualification). 

Recognition of Prior Learning (RPL) is an assessment process that allows you to demonstrate competence using the skills you have gained through experience in the workplace, voluntary work, informal or formal training or other life experiences.   

Please speak to your teacher if you wish to discuss applying for Credit Transfer or RPL for the unit(s) of competency addressed in this course. 

https://www.rmit.edu.au/students/student-essentials/enrolment/apply-for-credit 

Course Overview: Access Course Overview