Sheridan Course Outlines

APPL19014
The Spreadsheet Power User using MS Excel (Expert Level)

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: Fall 2014
Prerequisites: N/A
Corequisites: N/A
Equivalents: N/A
Pre/Co/Equiv Notes: N/A

Program(s): IT Support Services
Program Coordinator(s): Mark Orlando
Course Leader or Contact: Mark Orlando
Version: 21.0
Status: Approved - Under Rev (AREV)

Section I Notes: This course is offered as a hybrid course which is combination of in- class instruction and activities (2 hours) and online work (1 hour). To take this course in hybrid mode, students will need reliable access to the Internet and manage the virtual component to the course.

Section II: Course Details

Detailed Description
This course offers beginning to advanced instruction on Microsoft Excel 2013 functions and applications using a case-based approach with an emphasis on problem solving. Hands-on instruction along with textbook documentation is used to provide a comprehensive study of Microsoft Excel to give students the tools and knowledge they need if they decide to pursue their certification in Microsoft Excel 2013 at the Expert level.

Program Context

IT Support Services

Program Coordinator: Mark Orlando

This course is a core component of the Information Technologies Support Services program. It links with other courses in software and hardware to develop an advanced level of skill in using current technology and solving computer related problems.

Course Critical Performance and Learning Outcomes

 Critical Performance

By the end of this course, students will have demonstrated the 
ability to use Microsoft Excel at an Expert Level.

Learning Outcomes

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

1.	Identify the basic structure and features of Microsoft Excel
        by creating and editing a basic workbook.
2.	Apply formatting techniques.
3.	Define and apply formulas and functions and use absolute,
        relative and mixed cell references.
4.	Create pie, column, 3-D, and line charts, and sparkline
        graphs based on Excel data.
5.	Manipulate Excel data using Tables, Pivot tables and Pivot
        charts.
6.	Manage multiple worksheets and workbooks using references 
and
        links.
7.	Apply advanced functions using logical functions, Lookup
        tables and conditional formatting. 
8.	Develop an Excel application and automate tasks with macros.
9.	Analyze data using financial tools and functions.
10.	Perform a What-If analysis using Goal Seek, Data Tables,
        Scenario Manager and Solver.
11.	Connect to external data through importing, and database and
        web queries.
12.	Expand Microsoft Excel capabilities using VBA.

Evaluation Plan
Students demonstrate their learning in the following ways:

Students demonstrate their learning in the following ways: 

Assignments:      4 x 5% (20%)
Assignments:      1 x 9% (9%)
Discussions:      5 x 2% (10%)
Quizzes:          4 x 4% (16%)
Mid-Term Exam:   1 x 20% (20%)
Final Exam:      1 x 25% (25%)
Total:                   100% 

A student must average at least 50% on the exams combined in order 
to receive credit for this course.

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

Essential Employability Skills
Essential Employability Skills emphasized in the course:

	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: 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.
Effective term: Fall 2014
Professor: Tba
Textbook(s):

REQUIRED: Microsoft Excel 2013: Comprehensive, 1st Edition, by 
Parsons, Oja, Ageloff, Carey, Desjardins, Published by 
Cengage/Nelson  ISBN: 9781285169330

Applicable student group(s): Information Technologies Support Services
Course Details:

Orientation Module (Week 1)

-	Welcome and Introduction to the Course
-	Overview of course objectives, content, weekly outline, and
        evaluation plan
-	Review of SLATE and course resources
-	Overview of Office 2013
-	Managing your files
-	Download data files
-	Overview of internet resources

Module 1:  Weeks 1 to 3

Week 1:  Getting Started with Excel

Learning Outcomes:
-	Identify the basic structure and features of Microsoft Excel
        by creating and editing a basic workbook.

Learning Activities:
-	Review lecture slides 
-	Overview of features and functionality
-	In-class discussion
-	Complete Tutorial 1 exercises
-	Quick Check Review 

Assignment:
-	Online Discussion #1 (2%)

Week 2:  Formatting a Workbook

Learning Outcomes:
-	Apply formatting techniques.

Learning Activities:
-	Review lecture slides
-	Overview of features and functionality
-	In-class discussion
-	Complete Tutorial 2 exercises
-	Quick Check Review

Assessment:
-	Online Quiz #1 (4%)

Week 3:  Working with Formulas and Functions

Learning Outcome:
-	Define and apply formulas and functions, and use absolute,
        relative and mixed cell references.

Learning Activities:
-	Review lecture slides
-	Overview of features and functionality
-	In-class discussion
-	Complete Tutorial 3 exercises
-	Quick Check Review

Assignment:
-	Excel Assignment #1 (5%)

Module 2:  Weeks 4 to 6

Week 4:  Enhancing a Workbook with Charts and Graphs

Learning Outcomes:
-	Create pie, column, 3-D, and line charts, and sparkline
        graphs based on Excel data.

Learning Activities:
-	Review lecture slides
-	Overview of features and functionality
-	In-class discussion
-	Complete Tutorial 4 exercises
-	Quick Check Review

Assignments:
-	Online Discussion #2 (2%)
-	Excel Assignment  #2 (5%)

Week 5:  Working with Excel Tables, Pivot Tables and Pivot Charts

Learning Outcome:
-	Manipulate Excel data using Tables, Pivot tables and Pivot
        charts.

Learning Activities:
-	Review lecture slides
-	Overview of features and functionality
-	In-class discussion
-	Complete Tutorial 5 exercises
-	Quick Check Review

Assessment:
-	Online Quiz #2 (4%)

Week 6:  Managing Multiple Worksheets and Workbooks

Learning Outcomes:
-	Manage multiple worksheets and workbooks using references 
and
        links.

Learning Activities:
-	Review lecture slides
-	Overview of features and functionality
-	In-class discussion
-	Complete Tutorial 6 exercises
-	Quick Check Review
-	Review for mid-term exam

Assignments:
-	Online Discussion #3 (2%)
-	Excel Assignment  #3 (5%)

Module 3:  Exam (Week 7)

Mid-Term Exam (20%) (in-person)

Module 4:  Weeks 8 and 9

Week 8:  Using Advanced Functions and Conditional Formatting

Learning Outcome:
-	Apply advanced functions using logical functions, Lookup
        tables and conditional formatting.

Learning Activities:
-	Review lecture slides
-	Overview of features and functionality
-	In-class discussion
-	Complete Tutorial 7 exercises
-	Quick Check Review

Assignment:
-	Online Discussion #4 (2%)

Week 9:  Developing an Excel Application

Learning Outcome:
-	Develop an Excel application and automate tasks with macros.

Learning Activities:
-	Review lecture slides
-	Overview of features and functionality
-	In-class discussion
-	Complete Tutorial 8 exercises
-	Quick Check Review

Assessment:
-	Online Quiz #3 (4%)

Module 5:  Weeks 10 and 11

Week 10:  Working with Financial Tools & Functions

Learning Outcome:
-	Analyze data using financial tools and functions.

Learning Activities:
-	Review lecture slides
-	Overview of features and functionality
-	In-class discussion
-	Complete Tutorial 9 exercises
-	Quick Check Review

Assignment:
-	Excel Assignment #4 (5%)

Week 11:  Performing What-If Analyses

Learning Outcome:
-	Perform a What-If analysis using Goal Seek, Data Tables,
        Scenario Manager and Solver.

Learning Activities:
-	Review lecture slides
-	Overview of features and functionality
-	In-class discussion
-	Complete Tutorial 10 exercises
-	Quick Check Review

Assignment:
-	Online Discussion #5 (2%)

Module 6:  Weeks 12 and 13

Week 12:  Connecting to External Data

Learning Outcome:
-	Connect to external data through importing, and database and
        web queries.

Learning Activities:
-	Review lecture slides
-	Overview of features and functionality
-	In-class discussion
-	Complete Tutorial 11 exercises
	Quick Check Review

Assessment/Assignment:
-	Online Quiz      #4 (4%)
-	Excel Assignment #5 (9%)

Week 13:  Expanding Excel with Visual Basic for Applications

Learning Outcomes:
-	Expand Microsoft Excel capabilities using VBA.

Learning Activities:
-	Review lecture slides
-	Overview of features and functionality
-	In-class discussion
-	Complete Tutorial 12 exercises
-	Quick Check Review
-	Review for final exam

Module 7:  Exam (Week 14)

Final Exam (25%) (in-person)

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 ]