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 Public

Section I: Administrative Information

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

Course Name (short): The Spreadsheet Power User
School: All Sheridan Schools
Program(s): IT Support Services
Program Coordinator(s): Mark Orlando
Course Leader or Contact: Mark Orlando
Originator: Christina Spadafora
Designate: Christina Spadafora
Version: 21.0
Status: Approved - Under Rev (AREV)

Calendar Description
This course uses a case-based, problem-solving approach to cover the features of Microsoft Excel 2013. This includes the creation of professional-looking workbooks, the use of templates, and the development of customized applications with macros and Visual Basic for Applications (VBA). This course is designed to assist the student in preparing for the Microsoft Excel Expert certification exam.

Typical Instructional Format

Mobile	42.0
Total hours:	42.0

Courses may be offered in other formats.

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: Ann Cadger
Students may apply to receive credit by demonstrating achievement of the course learning outcomes through previous life and work experiences. 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)

Academic Honesty
The principle of academic honesty 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 faculty member, or otherwise submitting work that is not the student's own violates this principle and will not be tolerated. Instances of academic dishonesty, including assisting another student to cheat, will be penalized as detailed in the Student Handbook.

Students who have any questions regarding whether or not specific circumstances involve a breach of academic honesty are advised to discuss them with the faculty member prior to submitting the assignment in question.

Discrimination and Harassment
Sheridan is committed to provide a learning environment that respects 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 are available in the Student Handbook.

[ Printable Version ]