APPL70055
Excel, Introduction		 Sheridan
 
  I: Administrative Information   II: Course Details   III: Topical Outline(s)  Printable Version
 

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: Fall 2020
Prerequisites: N/A
Corequisites: N/A
Equivalents: N/A
Pre/Co/Equiv Notes: Basic Windows Skills are required; knowledge of keyboarding is a definite asset.

Program(s): Business, Microsoft Office Applications, Small Business Bookkeeping
Program Coordinator(s): Ruxandra Dunn, Greg Golding
Course Leader or Contact: N/A
Version: 20200914_00
Status: Approved (APPR)

Section I Notes: This course is offered in a classroom version and an online version. The online version is a web-based course offered entirely online through Sheridan and hosted by Sheridan College. 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 tutorials and projects. In addition, students need to have access to minimum hardware and operating system requirements in order to utilize online training, exams, projects and to complete tests.
 
 
Section II: Course Details

Detailed Description
Learn how to use Microsoft Excel to create, format, edit, print, and save worksheets/workbooks, master formatting techniques, insert formulas, insert headers and footers, sort data, insert images and objects, use SmartArt and WordArt, move and copy selected cells, create a workbook with multiple worksheets, and link data between worksheets, maintain workbooks, create and format charts and create hyperlinks. Students will participate in online activities and assessments, and submit assignments online, and online course students will also engage in online discussions.

Program Context

 
Business Program Coordinator(s): N/A
This course is a required course in the Business Sheridan Certificate Program, offered through the Faculty of Continuing and Professional Studies.

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.

Small Business Bookkeeping Program Coordinator(s): Ruxandra Dunn
This course is a required course in the Small Business Bookkeeping 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 prepare professional Excel worksheets and workbooks using introductory Microsoft Excel features.
 
Learning Outcomes:

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

  1. Develop an appreciation for and an understanding of Microsoft Excel Introduction as a vital tool in the production of worksheets and workbooks.
  2. Define the basic to intermediate features and functionality of Microsoft Excel.
  3. Demonstrate the skills required to create, format, modify, maintain, link, save and print basic worksheets and workbooks.
  4. Demonstrate the skills required to move, copy, sort, calculate and link data.
  5. Prepare charts and multiple worksheets.
  6. Apply formatting features such as SmartArt, modifying numbers, adjusting column width and height, alignment, fonts, styles, templates, graphic images, WordArt, borders, shading, headers and footers to enhance the appearance of worksheets.
  7. Compose simple to advanced formulas using mathematical operators and functions.
  8. Differentiate between absolute, relative and mixed cell references.
  9. Apply effective file management skills when creating folders, and copying, moving, deleting and renaming files.

Evaluation Plan
Students demonstrate their learning in the following ways:

 Evaluation Plan: ONLINE
 Online Training Tutorials (8 Total)24.0%
 Exams (8 Total)24.0%
 Projects (9 Total)52.0%
Total100.0%

Evaluation Notes and Academic Missed Work Procedure:
Students are encouraged to complete all online work for assessment. 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 practiced in the Online Training Tutorials. If a student 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
 Online Training Tutorials (8 Total)24.0%
 Exams (8 Total)24.0%
 Projects (9 Total)52.0%
Total100.0%

Evaluation Notes and Academic Missed Work Procedure:
Students are encouraged to complete all online work for assessment. 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 practiced in the Online Training Tutorials. If a student 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:

  • Communication Skills - Communicate clearly, concisely and correctly in the written, spoken, visual form that fulfills the purpose and meets the needs of the audience.

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:  N/A
 
 
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
Online Multiple Professors Continuing & Professional Studies students

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 ]

Copyright © Sheridan College. All rights reserved.