APPL16367
Spreadsheets & Presentations
Sheridan College Logo
 
  I: Administrative Information   II: Course Details   III: Topical Outline(s)  Printable Version
 
Section I: Administrative Information
  Total hours: 42.0
Credit Value: 3.0
Credit Value Notes: N/A
Effective: Winter 2014
Prerequisites: N/A
Corequisites: N/A
Equivalents:
N/A
Pre/Co/Equiv Notes: N/A

Program(s): Office Admin - Executive, Office Administration, Office Administration Legal, Office Administration Medical
Program Coordinator(s): Lisa Mendez
Course Leader or Contact: Leasa Steadman
Version:
14.0
Status: Approved (APPR)

Section I Notes: This course is offered in a hybrid version. The hybrid delivery is a combination of in-class instruction (2 hours) and online work (1 hour) per week. Students taking this course will need reliable access to the internet, and should have a basic level of comfort using computers as well as the self discipline to study online. Students can expect to spend an additional three hours per week for online activities such as postings, discussions, and homework. This is a web- based course offered online, using Sheridan's current LMS (Learning Management System). To take this course, students will need reliable access to the Internet and manage the virtual component to the course.

 
 
Section II: Course Details

Detailed Description
Students create professional spreadsheets and presentations using specialized software. Students produce and edit spreadsheets of varying complexity by entering and editing data, building formulas, and enhancing spreadsheets. Students become proficient in using a spreadsheet application to format, organize, analyze, and present information. Students plan, create, and revise electronic presentations. Presentations are enhanced by formatting slides using design templates, styles, bullets and numbering, headers and footers, and speakers notes. Visual appeal is created with images, animation effects, and sound and video effects. Presentations are shared for collaboration and review with others. Through hands-on learning and guided practice, in-class discussions, and interactive lectures, students learn the skills required to produce professional business spreadsheets and presentations.

Program Context

 
Office Admin - Executive Program Coordinator: Lisa Mendez
Same as above.

Office Administration Program Coordinator: Lisa Mendez
This is a required course of the Office Administration programs. Students establish foundation skills and knowledge required in future core courses. The skills and knowledge acquired and refined in this course are essential to perform effectively in the workplace.

Office Administration Legal Program Coordinator: Lisa Mendez
Same as above.

Office Administration Medical Program Coordinator: Lisa Mendez
Same as above.


Course Critical Performance and Learning Outcomes

 
 
Critical Performance
By the end of this course, students will have demonstrated the 
ability to produce business materials by a specified deadline using 
spreadsheet and presentation software.

Learning Outcomes
To achieve the critical performance, students will have demonstrated 
the ability to:

1. Produce basic spreadsheets with simple formulas.

2. Prepare charts, web pages, and workbooks with multiple
   spreadsheets.

3. Apply advanced formatting features such as alignment, fonts,
   styles, templates, graphic images, WordArt, maps, and borders.

4. Compose simple to advanced formulas using mathematical operators
   or functions.

5. Differentiate between absolute, relative and mixed cell
   references.

6. Define the features and functionality of the specialized
   presentation software.

7. Create professional presentations and slide show presentations
   with transitions and effects, enhanced formatting, images, and
   multimedia objects.

8. Apply advanced formatting features such as colour schemes, design
   templates, images, animation, and visual elements.

 

Evaluation Plan
Students demonstrate their learning in the following ways:

 
25%	Practical Skills Test 1:  Creating a Basic Presentation 
25%	Practical Skills Test 2:  Creating Spreadsheets (formatting,
	formulas, and charts)
10%     Online Tutorials
10%     In Class Assignments
30%     Assignments/Projects
___
100%	Total
Provincial Context
The course meets the following Ministry of Training, Colleges and Universities requirements:

 

Essential Employability Skills
Essential Employability Skills emphasized in the course:

X Communication X Critical Thinking & Problem Solving   Interpersonal
X Numeracy X Information Management   Personal

Notes: N/A

Prior Learning Assessment and Recognition
PLAR Contact (if course is PLAR-eligible) : Office of the Registrar

Students may apply to receive credit by demonstrating achievement of the course learning outcomes through previous relevant work/life experience, service, self-study and training on the job. This course is eligible for challenge through the following method(s):

Challenge Exam Portfolio Interview Other Not Eligible for PLAR
X        

Notes:  This course is offered in a hybrid version. The hybrid delivery is a combination of in-class instruction (2 hours) and online work (1 hour) per week. Students taking this course will need reliable access to the internet, and should have a basic level of comfort using computers as well as the self discipline to study online. Students can expect to spend an additional three hours per week for online activities such as postings, discussions, and homework. This is a web- based course offered online, using Sheridan's current LMS (Learning Management System). To take this course, students will need reliable access to the Internet and manage the virtual component to the course.

 
 
Section III: Topical Outline
Some details of this outline may change as a result of circumstances such as weather cancellations, College and student activities, and class timetabling.
Print Effective Term Professor Applicable Student Group(s)
Winter 2014 Multiple Professors Office Administration - Year 1 students
Winter 2014 Multiple Professors Office Administration - Continuing Education Students

Sheridan Policies

All Sheridan policies can be viewed on the Sheridan policy website.

Academic Integrity: The principle of academic integrity requires that all work submitted for evaluation and course credit be the original, unassisted work of the student. Cheating or plagiarism including borrowing, copying, purchasing or collaborating on work, except for group projects arranged and approved by the professor, or otherwise submitting work that is not the student's own, violates this principle and will not be tolerated. Students who have any questions regarding whether or not specific circumstances involve a breach of academic integrity are advised to review the Academic Integrity Policy and procedure and/or discuss them with the professor.

Copyright: A majority of the course lectures and materials provided in class and posted in SLATE are protected by copyright. Use of these materials must comply with the Acceptable Use Policy, Use of Copyright Protected Work Policy and Student Code of Conduct. Students may use, copy and share these materials for learning and/or research purposes provided that the use complies with fair dealing or an exception in the Copyright Act. Permission from the rights holder would be necessary otherwise. Please note that it is prohibited to reproduce and/or post a work that is not your own on third-party commercial websites including but not limited to Course Hero or OneNote. It is also prohibited to reproduce and/or post a work that is not your own or your own work with the intent to assist others in cheating on third-party commercial websites including but not limited to Course Hero or OneNote.

Intellectual Property: Sheridan's Intellectual Property Policy generally applies such that students own their own work. Please be advised that students working with external research and/or industry collaborators may be asked to sign agreements that waive or modify their IP rights. Please refer to Sheridan's IP Policy and Procedure.

Respectful Behaviour: Sheridan is committed to provide a learning environment that supports academic achievement by respecting the dignity, self-esteem and fair treatment of every person engaged in the learning process. Behaviour which is inconsistent with this principle will not be tolerated. Details of Sheridan's policy on Harassment and Discrimination, Academic Integrity and other academic policies are available on the Sheridan policy website.

Accessible Learning: Accessible Learning coordinates academic accommodations for students with disabilities. For more information or to register, please see the Accessible Learning website (Statement added September 2016)

Course Outline Changes: The information contained in this Course Outline including but not limited to faculty and program information and course description is subject to change without notice. Any changes to course curriculum and/or assessment shall adhere to approved Sheridan protocol. Nothing in this Course Outline should be viewed as a representation, offer and/or warranty. Students are responsible for reading the Important Notice and Disclaimer which applies to Programs and Courses.


[ Printable Version ]

Copyright © Sheridan College. All rights reserved.