Course Title: Use laboratory application software

Part B: Course Detail

Teaching Period: Term2 2021

Course Code: OFFC5338C

Course Title: Use laboratory application software

School: 174T School of VE Engineering, Health & Science

Campus: City Campus

Program: C4397 - Certificate IV in Laboratory Techniques

Course Contact: Kirsten Balding

Course Contact Phone: +61 3 9925 4283

Course Contact Email: kirsten.balding@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.
This unit of competency applies to technical officers and laboratory technicians in all industry sectors. It describes the application and use of software packages, this software would be for the storage, retrieval, analysis and display of information.
There is no expectation that candidates would be able to customise the software to meet specific needs. 


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


2021, Semester 2 Teaching Schedule

Using Lab Application Software 

OFFC5338C (MSL924004)

Week No

Week starting

Topic

1

12 July

  • 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

19 July

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

3

26 July

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

4

2nd August

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

5

9th August

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

6

16th August

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

7

23rd August

  • Understand a Database
  • Create a Database

30th August

Mid Sem break

8

6th sept

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

9

13th Sept

  • Continue with Databases
  • Linking Packages(software)

10

20th Sept

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

11

27th Sept

  • Maintain a database
  • Create reports in a database

12

4th Oct

  • Continue with previous week, discuss Assessment Task 2 submission

13

11th Oct

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

14

18th Oct

  • 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

25th Oct

Revision

16

1st Nov

Final Assessment


Learning Resources

Prescribed Texts


References


Other Resources

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


Overview of Assessment

Assessment may include a folio of work activities, observation of tasks & reports & quizzes


Assessment Tasks


No

Name of Assessment Task

Task 1

Refer to Canvas for date

Using Software Packages

Task 2

Refer to Canvas for date

Managing Databases

Task 3

Refer to Canvas for date

Knowledge Test


Assessment Matrix

Other Information

This is a competency based course and is not graded.

The results schedule is:

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

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

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

Late work that is submitted without an application for an extension (see below) will not be corrected.

APPLICATION FOR EXTENSION OF TIME FOR SUBMISSION OF ASSESSABLE WORK - A student may apply for an extension of up to 7 days from the original due date. They must lodge the application form http://mams.rmit.edu.au/seca86tti4g4z.pdf at least 24 hours before the due date. The application should be emailed to the Program Coordinator, Rauha Quazi rauha.quazi@rmit.edu.au . Students requiring longer extensions must apply for SPECIAL CONSIDERATION.

• For missed assessments you (& your doctor if you are sick) must fill out a special consideration form. This form must be lodged online with supporting evidence prior to, or within, 5 days of the scheduled time of the assessment https://www.rmit.edu.au/students/student-essentials/assessment-and-results/special-consideration

• Plagiarism is the presentation of the work, idea or creation of another person as though it is your own. It is a form of cheating and is a very serious academic offence that may lead to expulsion from the University. Plagiarised material can be drawn from, and presented in, written, graphic and visual form, including electronic data and oral presentation. Plagiarism occurs when the origin of the material used is not appropriately cited. It also occurs through enabling plagiarism, which is the act of assisting or allowing another person to plagiarise or to copy your own work. Please make sure you consider this carefully in completing all your work and assessments in this course and if you are unsure about whether you might have plagiarised, seek help from your teacher.

Course Overview: Access Course Overview