CIS2202 Advanced Office Applications: Excel and PowerPoint

CIS	2202	78107	2, 2008	ONC	Advanced Office Applications: Excel and PowerPoint	1.00	Toowoomba
Subject	Cat-nbr	Class	Term	Mode	Description	Units	Campus

Academic group:	FOBUS
Academic org:	FOB005
Student contribution band:	2
ASCED code:	029999

Staffing
Other requisites
Synopsis
Objectives
Topics
Texts
Student workload
Assessment details
Important assessment information
Assessment notes
Production date
PDF version

STAFFING

Moderator: Kristeen Casey

OTHER REQUISITES

It is highly recommended that students successfully complete CIS1000 before enrolling in this course. Current details of computer requirements can be found at <http://www.usq.edu.au/business/aboutfob.htm>. Students are also required to provide USQ with their current e-mail address, and regularly check this e-mail address during the course. Students are also required to have Internet access to USQConnect, and regularly access the StudyDesk site for the latest course updates.

SYNOPSIS

This course has a major focus on the use of Excel, a popular desktop spreadsheet application commonly found in business and administrative environments for the management, processing and analysis of organisational data in order to generate useful business information. The course also requires students to demonstrate the ability to effectively use Powerpoint software to produce files and templates to support professional quality presentations and documents for a broad range of situations. Students will apply problem-solving techniques to simulated business scenarios. Successful students should be ready to sit for certification as Microsoft Office Specialists in Excel and PowerPoint. Formerly MGT2202.

OBJECTIVES

The course objectives define the student learning outcomes for a course. The assessment item/s that may be used to assess student achievement of an objective is/are shown in parentheses after each objective. On successful completion of this course, students should be able to:

1.: construct and use spreadsheets for use in the decision making process and to demonstrate the ability to use charts in an effective manner to present business related data (Online Activity, Assignment 1, Assignment 2, Examination)
2.: appreciate the role of information processing in the administrative functioning of an organisation (Assignment 1, Assignment 2, Assignment 3, Examination)
3.: use Powerpoint to produce professional quality presentations (Assignment 3, Examination).

TOPICS

	Description	Weighting (%)
1.	Introduction to spreadsheets	10.00
2.	Advanced application of Microsoft Excel to a range of complex administrative tasks	75.00
3.	Advanced application of the integration of the various components of Microsoft Office to a range of complex administrative tasks	5.00
4.	Advanced application of PowerPoint to prepare a presentation	10.00

TEXT and MATERIALS required to be PURCHASED or accessed

ALL textbooks and materials are available for purchase from USQ BOOKSHOP (unless otherwise stated). Orders may be placed via secure internet, free fax 1800642453, phone 07 46312742 (within Australia), or mail. Overseas students should fax +61 7 46311743, or phone +61 7 46312742. For costs, further details, and internet ordering, use the 'Textbook Search' facility at http://bookshop.usq.edu.au click 'Semester', then enter your 'Course Code' (no spaces).

Microsoft Office 2007 software - any version of this suite containing Microsoft Access 2007, Microsoft Word 2007, Microsoft Excel 2007 and Microsoft PowerPoint 2007 is suitable. Note that previous versions of Microsoft Office are not suitable due to significant changes in the 2007 version.

Parsons, JJ, Oja, D, Ageloff, R & Carey, P 2008, New perspectives on Microsoft Office Excel 2007 comprehensive, Thomson Course Technology, Boston, Massachusetts AND Zimmerman, BB & Zimmerman, SS 2008, New perspectives on Microsoft Office PowerPoint 2007 comprehensive, Thomson Course Technology, Boston, Massachusetts. Note: the textbooks can be purchased as a shrink-wrapped set from the USQ Bookshop at a special reduced price from the publisher.

REFERENCE MATERIALS

Reference materials are materials that, if accessed by students, may improve their knowledge and understanding of the material in the course and enrich their learning experience.

STUDENT WORKLOAD REQUIREMENTS

ACTIVITY	HOURS
Laboratory or Practical Classes	24.00
Lectures	13.00
Private Study	128.00

ASSESSMENT DETAILS

Description	Marks out of	Wtg(%)	Due date	Notes
ONLINE ACTIVITY	10.00	5.00	12 Aug 2008
ASSIGNMENT 1	15.00	15.00	02 Sep 2008
ASSIGNMENT 2	25.00	25.00	20 Oct 2008
2 HOUR EXAMINATION	55.00	55.00	END S2	(see note 1)

NOTES

1.: The examination is scheduled to be held in the end-of-semester examination period. Students will be advised of the official examination date after the timetable has been finalised.

IMPORTANT ASSESSMENT INFORMATION

Attendance requirements:
It is the students' responsibility to attend and participate appropriately in all activities (such as lectures, tutorials, laboratories and practical work) scheduled for them, and to study all material provided to them or required to be accessed by them to maximise their chance of meeting the objectives of the course and to be informed of course-related activities and administration.
Requirements for students to complete each assessment item satisfactorily:
To satisfactorily complete an individual assessment item a student must achieve at least 50% of the marks. (Depending upon the requirements in Statement 4 below, students may not have to satisfactorily complete each assessment item to receive a passing grade in this course.)
Penalties for late submission of required work:
If students submit assignments after the due date without prior approval of the examiner, then a penalty of 5% of the total marks gained by the student for the assignment may apply for each working day late up to ten working days at which time a mark of zero may be recorded.
Requirements for student to be awarded a passing grade in the course:
To be assured of receiving a passing grade a student must achieve at least 50% of the total weighted marks available for the course.
Method used to combine assessment results to attain final grade:
The final grades for students will be assigned on the basis of the aggregate of the weighted marks obtained for each of the summative assessment items in the course.
Examination information:
This is a closed examination. Candidates are allowed to bring only writing and drawing instruments into the examination.
Examination period when Deferred/Supplementary examinations will be held:
Any Deferred or Supplementary examinations for this course will be held during the next examination period.
University Regulations:
Students should read USQ Regulations 5.1 Definitions, 5.6 Assessment, and 5.10 Student Academic Misconduct for further information and to avoid actions which might contravene university regulations. These regulations can be found at <http://www.usq.edu.au/corporateservices/calendar/part5.htm>. Students should also read the Faculty of Business Policies and Procedures which can be found at <http://www.usq.edu.au/business/aboutfob.htm>.

ASSESSMENT NOTES

Assignments: (i) The due date for an assignment is the date by which a student must submit the assignment to the USQ. (ii) Students must retain a copy of each assignment submitted for assessment. This must be produced within 24 hours if required by the examiner. (iii) In accordance with university policy, the examiner may grant an extension of the due date of an assignment in extenuating circumstances.

Course weightings: Course weightings of topics should not be interpreted as applying to the number of marks allocated to questions testing those topics in an examination paper.

This version produced 28 Aug 2009.