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
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 3 - 2018
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).
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 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.
All University policies are available on the CQUniversity Policy site.
You may wish to view these policies:
- Grades and Results Policy
- Assessment Policy and Procedure (Higher Education Coursework)
- Review of Grade Procedure
- Student Academic Integrity Policy and Procedure
- Monitoring Academic Progress (MAP) Policy and Procedure – Domestic Students
- Monitoring Academic Progress (MAP) Policy and Procedure – International Students
- Student Refund and Credit Balance Policy and Procedure
- Student Feedback – Compliments and Complaints Policy and Procedure
- Information and Communications Technology Acceptable Use Policy and Procedure
This list is not an exhaustive list of all University policies. The full list of University policies are available on the CQUniversity Policy site.
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 Student feedback. External course review.
Positive feedback about the Fast Track mode of study for CSU.
Continue to offer Fast Track mode of study seeking to further improve the offering.
Feedback from Student feedback.
Some assessment instructions are difficult to understand.
Clarify assessment instructions where necessary.
Feedback from Student feedback. CSU Staff.
Very positive feedback on the study materials with only a few typographical errors identified in the text book.
Review textbook, to ensure currency and consistency.
- Produce an appropriately formatted academic essay.
- Produce an appropriately formatted basic academic report.
- Perform basic spreadsheet operations and create charts.
- Create an electronic presentation using appropriate software.
- 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 - 20% | |||||
| 2 - Practical Assessment - 20% | |||||
| 3 - Practical Assessment - 30% | |||||
| 4 - Practical Assessment - 30% | |||||
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 - 20% | |||||||||
| 3 - Practical Assessment - 30% | |||||||||
| 4 - Practical Assessment - 30% | |||||||||
Textbooks
COIT40206 Computing Skills for University 4th Edn (2018)
4th Edition (2018)
Authors: School of Access Education
CQUniversity
Queensland , Australia
Binding: Spiral
Additional Textbook Information
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 textbook written specifically to suit Apple Mac computers is available in electronic form each week on the COIT40206 Moodle site. The hard copy material listed above is written to suit PC computers running Microsoft Windows.
IT Resources
- CQUniversity Student Email
- Internet
- Unit Website (Moodle)
- Suitable storage media, such as a removeable USB stick (4GB or greater)
- Full licensed version of Microsoft Office 2013 or Office 2016 (including Word, Excel and Powerpoint), or Office 2011 or MAC or Office 2016 for MAC (if using a MAC instead of a PC).
All submissions for this unit must use the referencing style: Harvard (author-date)
For further information, see the Assessment Tasks.
m.l.gray@cqu.edu.au
Module/Topic
Module 1
Chapter
Week 1 - Computing foundations
Events and Submissions/Topic
Consolidation Activity Week 1- Save and Send
Module/Topic
Module 1
Chapter
Week 2 - Microsoft Word Basic Skills
Events and Submissions/Topic
Consolidation Activity Week 2 - Format a Document
Module/Topic
Module 1
Chapter
Week 3 - Format an Essay
Events and Submissions/Topic
Consolidation Activity Week 3 - Format an Essay
Module/Topic
Module 1
Chapter
Week 4 - Revision and Assessment 1
Events and Submissions/Topic
Module 1 Revision - Essay Activity
Assessment 1
ASSESSMENT 1 - FORMAT AN ESSAY Due: Week 4 Friday (30 Nov 2018) 11:45 pm AEST
Module/Topic
Module 2
Chapter
Vacation Week - a good time to catch up or get ahead.
Events and Submissions/Topic
Module/Topic
Module 2
Chapter
Week 5 - Document Display
Events and Submissions/Topic
Consolidation Activity Week 5 - Display and Styles
Module/Topic
Module 2
Chapter
Week 6 - Format a Report
Events and Submissions/Topic
Consolidation Activity Week 6 - Format a Report
Module/Topic
Module 2
Chapter
Week 7 - Revision and Assessment 2
Events and Submissions/Topic
Module 2 Revision - Report Activity
Assessment 2
ASSESSMENT 2 - FORMAT AN ACADEMIC REPORT Due: Week 7 Friday (4 Jan 2019) 11:45 pm AEST
Module/Topic
Module 3
Chapter
Week 8 - Create a PowerPoint Presentation
Events and Submissions/Topic
Consolidation Activity Week 8 - Simple Presentation
Module/Topic
Module 3
Chapter
Week 9 - Advanced PowerPoint, Personal revision and Assessment 3
Events and Submissions/Topic
Consolidation Activity Week 9 - Create Design
Module/Topic
Module 4
Chapter
Week 10 - Spreadsheet Foundations
Events and Submissions/Topic
Consolidation Activity Week 10 - Formatting
Assessment 3
ASSESSMENT 3 - POWERPOINT PRESENTATION Due: Week 10 Friday (25 Jan 2019) 11:45 pm AEST
Module/Topic
Module 4
Chapter
Week 11 - Numbers and Formulas
Events and Submissions/Topic
Consolidation Activity Week 11 - Video Shop
Module/Topic
Module 4
Chapter
Week 12 - Sorting and Charts
Events and Submissions/Topic
Consolidation Activity Week 12 - Wages
Module/Topic
Module 4
Chapter
Week 13 - Revision and Assessment 4
Events and Submissions/Topic
Module 4 Revision - Spreadsheet Activity
Assessment 4
ASSESSMENT 4 - SPREADSHEET Due: Exam Week Friday (15 Feb 2019) 11:45 pm AEST
In Week 1 you should receive an email from your Support Lecturer. This Lecturer will be your main contact for help and information about the unit 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 unit may be directed to the Unit Co-ordinator, Michelle Gray (m.l.gray@cqu.edu.au - note the "l" is a small "L", not a capital "i" nor a number "1").
Please note that the normal mid-term break is from 3rd to 7th December, 2018, but there is also a University closure in this term from 24th December, 2018, to 1st January, 2019 (including public holidays).
1 Practical Assessment
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 Text Book.
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 Text Book and a copy of the Essay Preparation Checklist with you when you undertake this assessment.
Week 4 Friday (30 Nov 2018) 11:45 pm AEST
Late penalties will not be incurred for submission over the ensuing weekend.
Week 6 Monday (17 Dec 2018)
Individual marks/feedback will be provided two weeks after the submission due date through the Moodle website, prior to the next assessment due date.
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 Text Book.
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
- Produce an appropriately formatted academic essay.
- Perform basic operations using email and the Learning Management System provided.
- Communication
- Information Literacy
- Information Technology Competence
2 Practical Assessment
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.
Week 7 Friday (4 Jan 2019) 11:45 pm AEST
Late penalties will not be incurred for submission over the ensuing weekend.
Week 10 Monday (21 Jan 2019)
Individual marks/feedback will be provided two weeks after the submission due date through the Moodle website, prior to the next assessment due date.
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 Text Book.
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.
- Produce an appropriately formatted basic academic report.
- Information Technology Competence
3 Practical Assessment
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 Text Book as you work on this assessment.
Week 10 Friday (25 Jan 2019) 11:45 pm AEST
Late penalties will not be incurred for submission over the ensuing weekend (only). Public holidays (and university closure) will be counted as late days and incur a penalty.
Exam Week Monday (11 Feb 2019)
Individual marks/feedback will be provided three weeks after the submission due date through the Moodle website, prior to the next assessment due date (note the university closure during this period).
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 Text Book.
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.
- Create an electronic presentation using appropriate software.
- Perform basic operations using email and the Learning Management System provided.
- Communication
- Information Literacy
- Information Technology Competence
4 Practical Assessment
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 course (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 text book, 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 Text Book with you when you attempt this assessment.
Exam Week Friday (15 Feb 2019) 11:45 pm AEST
Late penalties will not be incurred for submission over the ensuing weekend.
Individual marks/feedback will be provided within two weeks of submission date through the Moodle website, in time for certification of grades.
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 Text Book.
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.
- Perform basic spreadsheet operations and create charts.
- Information Technology Competence
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?
