COIT40206 - Computing Skills for University
Term 1 - 2017


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.

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 3A
Fraction of Full-Time Student Load 0.125

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).

Offerings

Term 1 - 2017
  • Brisbane
  • Bundaberg
  • Cairns
  • Conservatorium of Music
  • Distance
  • Gladstone
  • Gold Coast
  • Hartford (Singapore)
  • Mackay
  • Melior
  • New Zealand Int Campus
  • Noosa
  • Perth
  • Rockhampton
  • Sydney
  • Townsville

Website

This unit has a website, within the Moodle system, which is available two weeks before the start of term. It is important that you visit your Moodle site throughout the term. Go to Moodle

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

Assessment Overview

Assessment Task Weighting
1. Practical Assessment 20%
2. Practical Assessment 20%
3. Practical Assessment 30%
4. Practical Assessment 30%

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 Procedures for more details of interim results and final grades.

All University policies are available on the IMPortal.

You may wish to view these policies:

  • Grades and Results Procedure
  • Assessment Policy and Procedure (Higher Education Coursework)
  • Review of Grade Procedure
  • Academic Misconduct Procedure
  • Monitoring Academic Progress (MAP) Policy and Procedure – Domestic Students
  • Monitoring Academic Progress (MAP) Policy and Procedure – International Students
  • Refund and Excess Payments (Credit Balances) Policy and Procedure
  • Student Feedback – Compliments and Complaints Policy and Procedure
  • Acceptable Use of Information and Communications Technology Facilities and Devices Policy and Procedure

This list is not an exhaustive list of all University policies. The full list of University policies are available on the IMPortal.

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 Source Recommendation
Windows 10 and MS Office 2016 will be rolled out across CQU campus facilities in 2017. ITD Write Windows 10 supplemental materials to be available on Moodle in Term 1 2017. Revise study materials to suit Office version 2016, to be implemented in Term 2 2017.
Very positive feedback about the ability to complete the course in Fast Track mode. Student feedback Continue to offer the course in Fast Track mode to eligible students. Maintain the fast turn around of assessments and continue to seek ways to improve the offering.
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 Assessment Tasks to Learning Outcomes

Assessment Tasks Learning Outcomes
1 2 3 4 5
1 - Practical Assessment      
2 - Practical Assessment      
3 - Practical Assessment        
4 - Practical Assessment        

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          

Alignment of Assessment Tasks to Graduate Attributes

Assessment Tasks Graduate Attributes
1 2 3 4 5 6 7 8
1 - Practical Assessment          
2 - Practical Assessment          
3 - Practical Assessment              
4 - Practical Assessment              

Prescribed Textbooks

Computing Skills for University Study Guide
Author/s: CQUniversity STEPS staff Year: 2015
Edition: 2nd edn Publisher: CQUniversity
City: Rockhampton State: Queensland
Country: Australia
View textbooks at the CQUniversity Bookshop
Note:

All Study Material for this unit is freely available on Moodle in electronic form; however, purchase of hard copy study material is highly recommended. Hard copies can be purchased online at minimal cost from the CQUniversity bookshop.

Mac computer users - A version of the study guide written specifically to suit Apple Mac computers is available in electronic form on the COIT40206 Moodle site. The hard copy material listed above is written to suit PC computers running Microsoft Windows.

IT Resources

You will need access to the following IT resources:
  • CQUniversity Student Email
  • Internet
  • Unit Website (Moodle)
  • Full licenced version of Microsoft Office 2013 or Office 2016 (including Word, Excel and Powerpoint) or Microsoft Office 2011 for MAC or Office 2016 for MAC.
  • Suitable storage media, such as a removeable USB stick
All submissions for this unit must use the Harvard (author-date) referencing style (details can be obtained here). For further information, see the Assessment Tasks below.
Unit CoordinatorMichelle Gray (m.l.gray@cqu.edu.au)
Note: Check the Term-Specific section for any additional contact information provided by the teaching team
Week Begin Date Module/Topic Chapter Events and Submissions
Week 1 06-03-2017

Module 1

Week 1 - Computing foundations

Skills Activity Week 1 - Save and Send

Week 2 13-03-2017

Module 1

Week 2 - Microsoft Word Basic Skills

Skills Activity Week 2 - Format a Document

Week 3 20-03-2017

Module 1

Week 3 - Format an Essay

Skills Activity Week 3 - Format an Essay

Week 4 27-03-2017

Module 1

Week 4 - Revision and Assessment 1

Module 1 Revision - Essay Activity

Assessment 1 - Format an Essay Due Friday (31 Mar 17) 11:45 PM AEST
Week 5 03-04-2017

Module 2

Week 5 - Create a PowerPoint Presentation

Skills Activity Week 5 - Simple Presentation

Vacation Week 10-04-2017

Module 2

Suggest continuing work on Module 3 and reviewing & planning assessment two item.

Week 6 17-04-2017

Module 2

Week 6 - Advanced PowerPoint

Personal revision and Assessment 2

aWeekW

Skills Activity Week 6 - Create Design

Assessment 2 - Powerpoint Presentation Due Friday (21 Apr 17) 11:45 PM AEST
Week 7 24-04-2017

Module 3

Week 7 - Document Display

Skills Activity Week 7 - Display and Styles

Week 8 01-05-2017

Module 3

Week 8 - Format a Report

Skills Activity Week 8 - Format a Report

Week 9 08-05-2017

Module 3

Week 9 - Revision and Assessment 3

Module 3 Revision - Report Activity

Assessment 3 - Format an Academic Report Due Friday (12 May 17) 11:45 PM AEST
Week 10 15-05-2017

Module 4

Week 10 - Spreadsheet Foundations

Skills Activity Week 10 - Formatting

Week 11 22-05-2017

Module 4

Week 11 - Numbers and Formulas

Skills Activity Week 11 - Video Shop.

Week 12 29-05-2017

Module 4

Week 12 - Sorting and Charts

Skills Activity Week 12 - Wages.

Review/Exam Week 05-06-2017

Module 4

Week 13 - Revision and Assessment Four

Module 4 Revision - Spreadsheet Activity

Assessment 4 - Spreadsheet Due Friday (09 Jun 17) 11:45 PM AEST
Exam Week 12-06-2017

In Week 1 you should either meet your Lecturer in class (Internal students) or receive an email from your

Support Lecturer (Distance Students). This Lecturer will be your main contact for help and information about the

course content. Contact details for your Support Lecturer can be found in Moodle from the first week of the term.

Any queries about the running of the course may be directed to the Course Co-ordinator, Michelle Gray

(m.l.gray@cqu.edu.au - note the "l" is a small "L", not a capital "i" or a number "1").

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 (Learning outcome 1). It requires that you correctly format an academic essay given 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 Study Guide.
  3. Create a title page for the essay formatted in accordance with the information on the Instruction sheet and using the techniques taught in Module 1 of the unit.
  4. 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
  5. 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 Study Guide and a copy of the Essay Preparation Checklist with you when you undertake this assessment.

Assessment Due Date Week 4 Friday (31-Mar-2017) 11:45 PM AEST
Late penalties will not be incurred for submission over the ensuing weekend up to midnight Sunday.
Return Date to Students Individual marks/feedback will be provided within two weeks of submission date through the Moodle website prior to the next assessment due date.
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 Study Guide.

The approximate breakdown of marks for this assessment is:
22% General essay and file settings
23% Quotations
12% Footer
22% Reference list
22% Title page

Referencing Style Harvard (author-date)
Submission Online

Refer to the "Getting Started With CQUniversity Systems" booklet for details regarding online submission.

Learning Outcomes Assessed
This section can be expanded to view the assessed learning outcomes

1. Produce an appropriately formatted academic essay.

5. Perform basic operations using email and the Learning Management System provided.

Graduate Attributes
This section can be expanded to view the assessed graduate attributes

2. Communication

3. Information Literacy

4. Information Technology Competence



2 Practical Assessment

Assessment Title Assessment 2 - 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 2 of the unit (Learning outcome 4).

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 week 5 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 2 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 this Module. It is recommended that you refer to the Study Guide as you work on this assessment.

Assessment Due Date Week 6 Friday (21-Apr-2017) 11:45 PM AEST
Late penalties will not be incurred for submission over the ensuing weekend up to midnight Sunday.
Return Date to Students Individual marks/feedback will be provided within two weeks of submission date through the Moodle website prior to the next assessment due date.
Weighting 20%
Assessment Criteria

Grades will be allocated on the basis of the completion of the tasks listed in the instruction sheet using techniques taught in this Module of the Study Guide.

The approximate breakdown of grades is:

21% Meeting specific criteria for the presentation

21% Documentation

26% Design principles

32% Use of advanced techniques

Individual marks/feedback will be provided through the Moodle website.

Referencing Style Harvard (author-date)
Submission Online

Refer to the "Getting Started With CQUniversity Systems" booklet for details regarding online submission.

Learning Outcomes Assessed
This section can be expanded to view the assessed learning outcomes

4. Create an electronic presentation using appropriate software.

5. Perform basic operations using email and the Learning Management System provided.

Graduate Attributes
This section can be expanded to view the assessed graduate attributes

2. Communication

3. Information Literacy

4. Information Technology Competence



3 Practical Assessment

Assessment Title Assessment 3 - 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 3. It requires that you correctly format a file given 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 study guide, using the skills learnt in Module 3.
  3. Ensure that the completed report 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
    * 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 Study Guide with you when you attempt this assessment.

Assessment Due Date Week 9 Friday (12-May-2017) 11:45 PM AEST
Late penalties will not be incurred for submission over the ensuing weekend up to midnight Sunday.
Return Date to Students Individual marks/feedback will be provided within two weeks of submission date through the Moodle website prior to the next assessment due date.
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 this Module of the Study Guide.

The approximate breakdown of grades is:

30% General formatting including styles and sections

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

15% Differential Footers

10% Tables of Contents, Tables and Figures

18% Title page

Individual marks/feedback will be provided through the Moodle website.

Referencing Style Harvard (author-date)
Submission Online

Refer to the "Getting Started With CQUniversity Systems" booklet for details regarding online submission.

Learning Outcomes Assessed
This section can be expanded to view the assessed learning outcomes

2. Produce an appropriately formatted basic academic report.

Graduate Attributes
This section can be expanded to view the assessed graduate attributes

4. 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 (Learning outcome 3)

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 study guide, 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 Study Guide with you when you attempt this assessment.

Assessment Due Date Review/Exam Week Friday (09-Jun-2017) 11:45 PM AEST
Late penalties will not be incurred for submission over the ensuing weekend up to midnight Sunday.
Return Date to Students Individual marks/feedback will be provided within two weeks of submission 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 and formatting guidelines taught in this Module of the Study Guide.

The approximate breakdown of grades is:

31% Formatting a worksheet

26% Use of formulas and functions

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

23% Charts

Individual marks/feedback will be provided through the Moodle website.

Referencing Style Harvard (author-date)
Submission Online

Refer to the "Getting Started With CQUniversity Systems" booklet for details regarding online submission.

Learning Outcomes Assessed
This section can be expanded to view the assessed learning outcomes

3. Perform basic spreadsheet operations and create charts.

Graduate Attributes
This section can be expanded to view the assessed graduate attributes

4. Information Technology Competence




© 2017 CQUniversity
Page generated by apps-prod-01.cqu.edu.au at Fri Mar 24 20:02:07 AEST 2017