CQUniversity Unit Profile
COIT40206 Computing Skills for University
Computing Skills for University
All details in this unit profile for COIT40206 have been officially approved by CQUniversity and represent a learning partnership between the University and you (our student).
The information will not be changed unless absolutely necessary and any change will be clearly indicated by an approved correction included in the profile.
General Information

Overview

On completion of this unit, students should be able to use a word processor to format the layout of an academic essay and a report. The students should be able to use a spreadsheet to complete a workbook, create simple formula, apply simple functions as well as create and format charts. The students should be able to use the Internet, negotiate a Learning Management System and communicate using email at an academic level. Students should also be able to create a basic Power Point presentation appropriate for university units.

Details

Career Level: Non-award
Credit Points: 6
Student Contribution Band: 10
Fraction of Full-Time Student Load: 0.125

Pre-requisites or Co-requisites

There are no requisites for this unit.

Important note: Students enrolled in a subsequent unit who failed their pre-requisite unit, should drop the subsequent unit before the census date or within 10 working days of Fail grade notification. Students who do not drop the unit in this timeframe cannot later drop the unit without academic and financial liability. See details in the Assessment Policy and Procedure (Higher Education Coursework).

Offerings For Term 2 - 2022

Brisbane
Bundaberg
Cairns
Gladstone
Mackay
Online
Rockhampton
Townsville

Attendance Requirements

All on-campus students are expected to attend scheduled classes – in some units, these classes are identified as a mandatory (pass/fail) component and attendance is compulsory. International students, on a student visa, must maintain a full time study load and meet both attendance and academic progress requirements in each study period (satisfactory attendance for International students is defined as maintaining at least an 80% attendance record).

Class and Assessment Overview

Recommended Student Time Commitment

Each 6-credit Non-award unit at CQUniversity requires an overall time commitment of an average of 12.5 hours of study per week, making a total of 150 hours for the unit.

Class Timetable

Bundaberg, Cairns, Emerald, Gladstone, Mackay, Rockhampton, Townsville
Adelaide, Brisbane, Melbourne, Perth, Sydney

Assessment Overview

1. Practical Assessment
Weighting: 20%
2. Practical Assessment
Weighting: 30%
3. Practical Assessment
Weighting: 10%
4. Practical Assessment
Weighting: 40%

Assessment Grading

This is a graded unit: your overall grade will be calculated from the marks or grades for each assessment task, based on the relative weightings shown in the table above. You must obtain an overall mark for the unit of at least 50%, or an overall grade of ‘pass’ in order to pass the unit. If any ‘pass/fail’ tasks are shown in the table above they must also be completed successfully (‘pass’ grade). You must also meet any minimum mark requirements specified for a particular assessment task, as detailed in the ‘assessment task’ section (note that in some instances, the minimum mark for a task may be greater than 50%). Consult the University’s Grades and Results Policy for more details of interim results and final grades.

Previous Student Feedback

Feedback, Recommendations and Responses

Every unit is reviewed for enhancement each year. At the most recent review, the following staff and student feedback items were identified and recommendations were made.

Feedback from Students

Feedback

One hour online Zooms are not long enough.

Recommendation

Increase live Moodle Zoom sessions to two hours.

Feedback from Unit Evaluations

Feedback

Voice over on some video lessons sound a bit monotonous.

Recommendation

Continue to revise and update older videos.

Feedback from Unit Evaluations

Feedback

Consistent positive feedback on the value of weekly consolidation activities.

Recommendation

Continue to promote the value of completing consolidation activities as a learning tool and encourage students to use them as valuable formative learning.

Feedback from Students

Feedback

Consistent positive feedback on the Fast Track delivery mode.

Recommendation

Continue Fast Track mode of study maintaining fast turnaround of marking and feedback.

Unit Learning Outcomes
On successful completion of this unit, you will be able to:
  1. Produce an appropriately formatted academic essay.
  2. Produce an appropriately formatted basic academic report.
  3. Perform basic spreadsheet operations and create charts.
  4. Create an electronic presentation using appropriate software.
  5. Perform basic operations using email and the Learning Management System provided.


Alignment of Learning Outcomes, Assessment and Graduate Attributes
N/A Level
Introductory Level
Intermediate Level
Graduate Level
Professional Level
Advanced Level

Alignment of Assessment Tasks to Learning Outcomes

Assessment Tasks Learning Outcomes
1 2 3 4 5
1 - Practical Assessment - 20%
2 - Practical Assessment - 30%
3 - Practical Assessment - 10%
4 - Practical Assessment - 40%

Alignment of Graduate Attributes to Learning Outcomes

Graduate Attributes Learning Outcomes
1 2 3 4 5
1 - Self Management
2 - Communication
3 - Information Literacy
4 - Information Technology Competence
5 - Problem Solving
6 - Critical Thinking
7 - Cross-Cultural Competence
8 - Ethical Practice
9 - Aboriginal and Torres Strait Islander Cultures

Alignment of Assessment Tasks to Graduate Attributes

Assessment Tasks Graduate Attributes
1 2 3 4 5 6 7 8 9
1 - Practical Assessment - 20%
2 - Practical Assessment - 30%
3 - Practical Assessment - 10%
4 - Practical Assessment - 40%
Textbooks and Resources

Textbooks

Prescribed

Computing Skills for University

Edition: 6 (2020)
Authors: School of Access Education
CQUniversity Australia
Rockhampton Rockhampton , Queensland , Australia
ISBN: N/A
Binding: Spiral

Additional Textbook Information

A PC and a MAC version of the textbook for Computing Skills for University (COIT40206) are available on the unit Moodle site; however, we strongly advise you to print your own copy. The textbook cannot be purchased from the CQUniversity Bookshop. Your Access Coordinator will provide advice on printing options.

IT Resources

You will need access to the following IT resources:
  • CQUniversity Student Email
  • Internet
  • Unit Website (Moodle)
  • Suitable storage media, such as a removable USB stick (4GB or greater)
  • Full licensed version of Microsoft Office 2019 or 365 (but no older than 2016; including Word, Excel and PowerPoint), or Office for MAC (if using a MAC instead of a PC). Refer to the information on the Moodle site for information about obtaining a FREE student version of MS Office if you do not have one.
  • Access to a full PC or MAC based computer. NOTE: This unit CANNOT be sufficiently completed using a phone, ipad or tablet (such as a Google Chromebook device)
Referencing Style

All submissions for this unit must use the referencing style: Harvard (author-date)

For further information, see the Assessment Tasks.

Teaching Contacts
Katrina Johnston Unit Coordinator
k.johnston@cqu.edu.au
Schedule
Prep Week Begin Date: 04 Jul 2022

Module/Topic

Preparatory Material

Chapter

Prep Week - Computing Foundations

Events and Submissions/Topic

Consolidation Activity Prep Week

Week 1 Begin Date: 11 Jul 2022

Module/Topic

Module 1

Chapter

Week 1 - Microsoft Word Basic Skills

Events and Submissions/Topic

Consolidation Activity Week 1 - Format a Document

Week 2 Begin Date: 18 Jul 2022

Module/Topic

Module 1

Chapter

Week 2 - Format an Essay

Events and Submissions/Topic

Consolidation Activity Week 2 - Format an Essay

Week 3 Begin Date: 25 Jul 2022

Module/Topic

Module 1

Chapter

Week 3 - Revision and Assessment 1

Events and Submissions/Topic

Module 1 Revision - Essay Activity

Assessment 1 - Format an Essay (submission accepted up to the following Sunday without penalty)


ASSESSMENT 1 - FORMAT AN ESSAY Due: Week 3 Friday (29 July 2022) 11:59 pm AEST
Week 4 Begin Date: 01 Aug 2022

Module/Topic

Module 2

Chapter

Week 4 - Document Display

Events and Submissions/Topic

Consolidation Activity Week 4 - Display and Styles

Week 5 Begin Date: 08 Aug 2022

Module/Topic

Module 2

Chapter

Week 5 - Format a Report

Events and Submissions/Topic

Consolidation Activity Week 5 - Format a Report

Vacation Week Begin Date: 15 Aug 2022

Module/Topic

Mid-term break

Chapter

Events and Submissions/Topic

Great opportunity to catch up, revise or get ahead.

Week 6 Begin Date: 22 Aug 2022

Module/Topic

Module 2

Chapter

Week 6 - Revision and Assessment 2

Events and Submissions/Topic

Module 2 Revision - Report Activity

Assessment 2 - Format a Report (submission accepted up to the following Sunday without penalty)


ASSESSMENT 2 - FORMAT AN ACADEMIC REPORT Due: Week 6 Friday (26 Aug 2022) 11:59 pm AEST
Week 7 Begin Date: 29 Aug 2022

Module/Topic

Module 3

Chapter

Week 7 - Create a PowerPoint Presentation

Events and Submissions/Topic

Consolidation Activity Week 7 - Simple Presentation

Week 8 Begin Date: 05 Sep 2022

Module/Topic

Module 3

Chapter

Week 8 - Advanced PowerPoint, Personal revision and Assessment 3

Events and Submissions/Topic

Consolidation Activity Week 8 - Create Design

Week 9 Begin Date: 12 Sep 2022

Module/Topic

Module 4

Chapter

Week 9 - Spreadsheet Foundations

Events and Submissions/Topic

Consolidation Activity Week 9 - Spreadsheet Formatting

Assessment 3 - Create a PowerPoint (submission accepted up to the following Sunday without penalty)


ASSESSMENT 3 - POWERPOINT PRESENTATION Due: Week 9 Friday (16 Sept 2022) 11:59 pm AEST
Week 10 Begin Date: 19 Sep 2022

Module/Topic

Module 4

Chapter

Week 10 - Numbers and Formulas

Events and Submissions/Topic

Consolidation Activity Week 10 - Video Shop

Week 11 Begin Date: 26 Sep 2022

Module/Topic

Module 4

Chapter

Week 11 - Sorting and Charts

Events and Submissions/Topic

Consolidation Activity Week 11 - Wages

Week 12 Begin Date: 03 Oct 2022

Module/Topic

Module 4

Chapter

Week 12 - Revision and Assessment 4

Events and Submissions/Topic

Module 4 Revision - Spreadsheet Activity

Assessment 4 - Spreadsheet (submission accepted up to the following Sunday without penalty)


ASSESSMENT 4 - SPREADSHEET Due: Week 12 Friday (7 Oct 2022) 11:59 pm AEST
Term Specific Information

Unit Co-ordinator: Katrina Johnston

Email: k.johnston@cqu.edu.au

Phone: 4150 7706

Support Lecturer: Contact details for your support lecturer can be found in Moodle in the Learning Community tile in week 1 of the term. In Week 1, you will receive an email from your support lecturer. This lecturer will be your main contact to email consolidation activities and for help and information about the unit content.

Before term begins: In the week prior to term, it is expected that you will work on the PREP WEEK study material in Moodle and have your first Consolidation Activity completed ready to send to your Support Lecturer when you hear from them in Week 1.

Important Information about the CSU Textbook: It is strongly recommended that you print the textbook. There are two printable versions available: PC Windows and MAC OS. Print only the version corresponding to your computer system.

Assessment Tasks

1 Practical Assessment

Assessment Title
ASSESSMENT 1 - FORMAT AN ESSAY

Task Description

This assessment is designed to reinforce your understanding of correct formatting of an academic essay using MS Word, as covered in Module 1 of the unit. It requires that you correctly format an academic essay provided to you in an unformatted state.

In order to achieve this you will need to:

1. Download the Instruction file, the essay starter file and the reference list file from the assessment link on Moodle.

2. Use Microsoft Word to complete and correctly format these files according to the Instructions, and the Essay Preparation Checklist, using the techniques taught in Module 1 of the Textbook.

3. Ensure that the completed document includes:

* A title page

* The body of the essay formatted according to the Essay Preparation Checklist

* A correctly formatted reference list

4. Upload the completed work onto the assessment link in Moodle and submit for marking.

This is an open book assessment, and it is recommended that you have the Textbook and a copy of the Essay Preparation Checklist with you when you undertake this assessment.


Assessment Due Date

Week 3 Friday (29 July 2022) 11:59 pm AEST

Late penalties will not be incurred for submission over the ensuing weekend.


Return Date to Students

Vacation Week Monday (15 Aug 2022)

Individual marks/feedback will be provided two weeks after the submission due date through the Moodle website.


Weighting
20%

Assessment Criteria

Grades will be allocated on the basis of the correct completion of the tasks listed in the instruction sheet using techniques taught in Module 1 of the Textbook.

The approximate breakdown of marks for this assessment is:

21% General essay and file settings

23% Quotations

11% Footer

21% Reference list

24% Title page


Referencing Style

Submission
Online

Submission Instructions
Assessment must be submitted correctly through the CSU Moodle site.

Learning Outcomes Assessed
  • Produce an appropriately formatted academic essay.
  • Perform basic operations using email and the Learning Management System provided.


Graduate Attributes
  • Communication
  • Information Literacy
  • Information Technology Competence

2 Practical Assessment

Assessment Title
ASSESSMENT 2 - FORMAT AN ACADEMIC REPORT

Task Description

This assessment is designed to reinforce your understanding of the techniques used to format a Microsoft Word document as a report, as taught in Module 2. It requires that you correctly format a file provided to you in an unformatted state. The instructions will detail the required use of sections, styles, differential footers and content formats.

In order to achieve this you will need to:

1. Download the Instruction file, the report starter file and additional content file from the appropriate assessment link on Moodle.

2. Use Microsoft Word to complete and correctly format the report, according to the Instructions and the Formatting conventions detailed in the Textbook, using the skills learnt in Module 2.

3. Ensure that the completed report document consists of:

* A title page

* Front matter including an Executive Summary and Tables of Contents, Tables and/or Figures as required.

* The body of the report (with reference list)

* End matter, such as Appendices, as specified in the instructions.

4. Upload the completed work onto the assignment link in Moodle and submit for marking.

This is an open book assessment, and it is recommended that you have the Textbook with you when you attempt this assessment.



Assessment Due Date

Week 6 Friday (26 Aug 2022) 11:59 pm AEST

Late penalties will not be incurred for submission over the ensuing weekend.


Return Date to Students

Week 9 Monday (12 Sept 2022)

Individual marks/feedback will be provided two weeks after the submission due date through the Moodle website.


Weighting
30%

Assessment Criteria

Grades will be allocated on the basis of the completion of the tasks listed in the instruction sheet using techniques taught in Module 2 of the Textbook.

The approximate breakdown of grades is:

31% General formatting including styles and sections

36% Specific formatting including tables, tabulated text, lists, and captions

9% Differential Footers

10% Tables of Contents, Tables and Figures

14% Title page


Referencing Style

Submission
Online

Submission Instructions
Assessment must be submitted correctly through the CSU Moodle site.

Learning Outcomes Assessed
  • Produce an appropriately formatted basic academic report.
  • Perform basic operations using email and the Learning Management System provided.


Graduate Attributes
  • Communication
  • Information Literacy
  • Information Technology Competence

3 Practical Assessment

Assessment Title
ASSESSMENT 3 - POWERPOINT PRESENTATION

Task Description

This assessment is designed to reinforce your understanding of appropriate presentation of a slide show, using MS Powerpoint, as covered in Module 3 of the unit.

It requires that you create an original Powerpoint presentation in response to the topic specified in the Instructions. In order to achieve this you will need to:

1. Download the Instruction file from the appropriate assessment link on Moodle. This should be downloaded in the break week to start work on planning the assessment task.

2. Use Microsoft PowerPoint to prepare a short presentation in accordance with the design considerations introduced in Module 3 of the unit and meeting the specifications listed in the Instruction file.

3. Ensure your presentation relates to the topic. Note that your interpretation of this topic may be factual or fictional.

4. Save your work as a PowerPoint Presentation file (*.pptx).

5. Upload the presentation through the assessment link in Moodle and submit for marking.

This assessment should be completed in your own time over the weeks allocated to Module 3. It is recommended that you refer to the Textbook as you work on this assessment.


Assessment Due Date

Week 9 Friday (16 Sept 2022) 11:59 pm AEST

Late penalties will not be incurred for submission over the ensuing weekend.


Return Date to Students

Week 12 Monday (3 Oct 2022)

Individual marks/feedback will be provided two weeks after the submission due date through the Moodle website.


Weighting
10%

Assessment Criteria

Grades will be allocated on the basis of the completion of the tasks listed in the instruction sheet using techniques taught in Module 3 of the Textbook.

The approximate breakdown of grades is:

19% Meeting specific criteria for the presentation

13% Documentation

28% Design principles

40% Use of advanced techniques



Referencing Style

Submission
Online

Submission Instructions
Assessment must be submitted correctly through the CSU Moodle site.

Learning Outcomes Assessed
  • Create an electronic presentation using appropriate software.


Graduate Attributes
  • Information Technology Competence

4 Practical Assessment

Assessment Title
ASSESSMENT 4 - SPREADSHEET

Task Description

This assessment is designed to reinforce your understanding of creating and formatting a basic spreadsheet, using MS Excel, including the correct application of appropriate formulae and creation of simple charts, as covered in Module 4 of the unit.

In order to achieve this you will need to:

1. Download the Instruction file and the spreadsheet starter file from the appropriate assessment link on Moodle.

2. Use Microsoft Excel to complete and correctly format the spreadsheet, including basic formulae, and charts, in accordance with the Instruction sheet and the Formatting Guidelines detailed in the Textbook, using the skills taught in Module 4 of the unit.

3. Upload the completed work onto the assignment link in Moodle and send for marking.

This is an open book assessment, and it is recommended that you have the Textbook with you when you attempt this assessment.


Assessment Due Date

Week 12 Friday (7 Oct 2022) 11:59 pm AEST

Late penalties will not be incurred for submission over the ensuing weekend.


Return Date to Students

Individual marks/feedback will be provided within two weeks of submission date through the Moodle website, in time for certification of grades.


Weighting
40%

Assessment Criteria

Grades will be allocated on the basis of the completion of the tasks listed in the instruction sheet using techniques and formatting guidelines taught in Module 4 of the Textbook.

The approximate breakdown of grades is:

27% Formatting a worksheet

22% Use of formulas and functions

31% Working in multiple sheets, including 3-D referencing

20% Charts


Referencing Style

Submission
Online

Submission Instructions
Assessment must be submitted correctly through the CSU Moodle site.

Learning Outcomes Assessed
  • Perform basic spreadsheet operations and create charts.


Graduate Attributes
  • Information Technology Competence

Academic Integrity Statement

As a CQUniversity student you are expected to act honestly in all aspects of your academic work.

Any assessable work undertaken or submitted for review or assessment must be your own work. Assessable work is any type of work you do to meet the assessment requirements in the unit, including draft work submitted for review and feedback and final work to be assessed.

When you use the ideas, words or data of others in your assessment, you must thoroughly and clearly acknowledge the source of this information by using the correct referencing style for your unit. Using others’ work without proper acknowledgement may be considered a form of intellectual dishonesty.

Participating honestly, respectfully, responsibly, and fairly in your university study ensures the CQUniversity qualification you earn will be valued as a true indication of your individual academic achievement and will continue to receive the respect and recognition it deserves.

As a student, you are responsible for reading and following CQUniversity’s policies, including the Student Academic Integrity Policy and Procedure. This policy sets out CQUniversity’s expectations of you to act with integrity, examples of academic integrity breaches to avoid, the processes used to address alleged breaches of academic integrity, and potential penalties.

What is a breach of academic integrity?

A breach of academic integrity includes but is not limited to plagiarism, self-plagiarism, collusion, cheating, contract cheating, and academic misconduct. The Student Academic Integrity Policy and Procedure defines what these terms mean and gives examples.

Why is academic integrity important?

A breach of academic integrity may result in one or more penalties, including suspension or even expulsion from the University. It can also have negative implications for student visas and future enrolment at CQUniversity or elsewhere. Students who engage in contract cheating also risk being blackmailed by contract cheating services.

Where can I get assistance?

For academic advice and guidance, the Academic Learning Centre (ALC) can support you in becoming confident in completing assessments with integrity and of high standard.

What can you do to act with integrity?