Sheridan Course Outlines

Land Acknowledgement

Sheridan College resides on land that has been, and still is, the traditional territory of several Indigenous nations, including the Anishinaabe, the Haudenosaunee Confederacy, the Wendat, and the Mississaugas of the Credit First Nation. We recognize this territory is covered by the Dish with One Spoon treaty and the Two Row Wampum treaty, which emphasize the importance of joint stewardship, peace, and respectful relationships.

As an institution of higher learning Sheridan embraces the critical role that education must play in facilitating real transformational change. We continue our collective efforts to recognize Canada's colonial history and to take steps to meaningful Truth and Reconciliation.

Section I: Administrative Information

Total hours: 42.0
Credit Value: 3.0
Credit Value Notes: N/A
Effective: Winter 2021
Prerequisites: APPL70055
Corequisites: N/A
Equivalents: N/A
Pre/Co/Equiv Notes: N/A

Program(s): Microsoft Office Applications
Program Coordinator(s): Greg Golding
Course Leader or Contact: N/A
Version: 20210118_00
Status: Approved (APPR)

Section I Notes: Access to course materials and assignments will be available on Sheridan's Learning and Teaching Environment (SLATE). Students will need reliable access to a computer and the internet.

Section II: Course Details

Detailed Description
Students build on the skills learned in Microsoft Excel, Introduction to create professional worksheets and workbooks using advanced features. Studies include: macros, templates, formulas, and database features. Additionally, students learn to format worksheets, work with multiple workbooks, sort, filter, link, embed, consolidate, import, export data, use data analysis and auditing tools, protect, and share workbooks. Students participate in online activities and assessments, and submit assignments online.

Program Context

Microsoft Office Applications	Program Coordinator(s): Greg Golding
This course is a required course in the Microsoft Office Applications Sheridan Certificate Program, offered through the Faculty of Continuing and Professional Studies.

Course Critical Performance and Learning Outcomes

	Critical Performance:
	By the end of this course, students will have demonstrated the ability to produce advanced workbooks using spreadsheet software.

Learning Outcomes:

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

Apply Microsoft Excel as an advanced tool in the production of worksheets and workbooks.
Define the intermediate to advanced features and functionality of Microsoft Excel.
Apply the skills required to create, format, modify, maintain, link, save and print intermediate to advanced worksheets and workbooks.
Demonstrate the skills required to move, copy, sort, filter, link, and calculate data.
Create Excel Tables, PivotTables, PivotCharts, Insert Slicers and work with macros.
Control data input using data validation, protect worksheets and workbooks, and add, edit and delete comments.
Compose advanced formulas using functions such as Financial, Date & Time, Math & Trig, Statistical, Lookup & Reference, and Logical functions.
Apply advanced formatting techniques using styles, format painter, borders and shading, templates, headers and footers, adjusting column width and height, modifying font settings, and conditional formatting to enhance the appearance of worksheets.
Implement effective file management skills when creating folders, copying, moving, deleting and renaming files.

Evaluation Plan
Students demonstrate their learning in the following ways:

Evaluation Plan: ONLINE

	Training (12 Total)	24.0%
	Exams (12 Total)	24.0%
	Projects (10 Total)	52.0%
	Total	100.0%

Evaluation Notes and Academic Missed Work Procedure:

Students are encouraged to complete all online work for assessment and preparation for the tests. Online Training Tutorials: Online training tutorials are marked. There are an unlimited number of attempts permitted for each training tutorial.  

Online Exams: Online Exams are based on skills learned and practised in the Online Training Tutorials. If a student is does not complete an online exam, they will receive a mark of zero. The 
actual score for each online exam is recorded.

Projects: Projects are completed either in SAM2016 or through the textbook. Projects summarize each section's skills learned. A student's actual score on the assignment will be recorded.   

All training/exams/projects must be completed as individual efforts unless the instructor states otherwise in writing.

Evaluation Plan: IN-CLASS

	Training (12 Total)	24.0%
	Exams (12Total)	24.0%
	Projects (10 Total)	52.0%
	Total	100.0%

Evaluation Notes and Academic Missed Work Procedure:

Students are encouraged to complete all online work for assessment and preparation for the tests. 

Online Training Tutorials: Online training tutorials are marked. There are an unlimited number of attempts permitted for each training tutorial.  

Online Exams: Online Exams are based on skills learned and practised in the Online Training Tutorials. If a student is does not complete an online exam, they will receive a mark of zero.  The 
actual score for each online exam is recorded.

Projects: Projects are completed either in SAM2016 or through the textbook. Projects summarize each section's skills learned. A student's actual score on the assignment will be recorded.   

All training/exams/projects must be completed as individual efforts unless the instructor states otherwise in writing.

Provincial Context
The course meets the following Ministry of Colleges and Universities requirements:

Essential Employability Skills
Essential Employability Skills emphasized in the course:

Information Management Skills - Analyze, evaluate, and apply relevant information from a variety of sources.

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
Notes:

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	Instruction Mode	Professor	Applicable Student Group(s)
	In-Class	Multiple Professors	Continuing & Professional Studies students in the Microsoft Office Application program.
	Online	Multiple Professors	Continuing & Professional Studies students in the Microsoft Office Application program.

Sheridan Policies

It is recommended that students read the following policies in relation to course outlines:

Academic Integrity
Copyright
Intellectual Property
Respectful Behaviour
Accessible Learning

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

Appropriate use of generative Artificial Intelligence tools: In alignment with Sheridan's Academic Integrity Policy, students should consult with their professors and/or refer to evaluation instructions regarding the appropriate use, or prohibition, of generative Artificial Intelligence (AI) tools for coursework. Turnitin AI detection software may be used by faculty members to screen assignment submissions or exams for unauthorized use of artificial intelligence.

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