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: 6.0
Credit Value: 0.0
Credit Value Notes: N/A
Effective: Fall 2019
Prerequisites: N/A
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: 20190903_00
Status: Approved (APPR)

Section I Notes: This workshop will be scheduled in a PC lab, and therefore, participants will not be required to bring their own laptop. This workshop is designed for Windows Office 2016 and therefore, not applicable for Mac products.

Section II: Course Details

Detailed Description
In this workshop, students learn how to use Microsoft Excel to help with decision making and financial planning by setting up spreadsheets to track the household income, expenses, and debts. Through hands on activities, students run what-if scenarios and introduce debt management techniques.

Program Context

Microsoft Office Applications	Program Coordinator(s): Greg Golding
This workshop is not part of a program. This workshop may be beneficial for students seeking to further develop their Microsoft Office Excel skills to specific professional and personal interest applications.

Course Critical Performance and Learning Outcomes

	Critical Performance:
	By the end of this workshop, students will have demonstrated the ability to manage their family finances and budgeting using Microsoft Excel.

Learning Outcomes:

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

Analyze data using Excel Tables, and Financial and Logical functions.
Apply advanced formatting techniques including styles, format painter, templates, column width and height, font settings, and conditional formatting to enhance the appearance of worksheets.
Calculate income, expenses, and debts as they relate to a household.
Input and compare pricing quotes in Excel.
Set up a monthly budget.

Evaluation Plan
Students demonstrate their learning in the following ways:

Evaluation Plan: IN-CLASS

	Pass/No Pass	100.0%
	Total	100.0%

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

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

Not Eligible for PLAR

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.
Instruction Mode: In-Class
Professor: Multiple Professors
Resource(s):

	Type	Description
Required	Other	No textbook is required for this workshop. All resources will be provided in class.

Applicable student group(s): Continuing and Professional Studies Students
Course Details:

Topics:

1. Calculation of the household’s income, expenses, debts, and savings

2. Comparison of the running costs of an old car and a new car

3. Analysis of different renovation quotes to determine to best value

4. Calculation of the savings amount required for a “rainy day” fund

5. Planning for a large expense

6. Debt management using what-if scenarios

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 ]