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: Winter 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: 17.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 2010 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 2010 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: Winter 2014
Professor: Tba
Textbook(s): New Perspectives on Microsoft® Office Excel® 2010, Comprehensive, by
June Parsons, Dan Oja, Roy Ageloff,and Patrick Carey, 1st Edition,
Published by Course Technology ISBN: 978-0-538-74291-7
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 2010
- 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 ]
|
Copyright © Sheridan College. All rights reserved. |