APPL10036
Spreadsheet Essentials |
|
|
|
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: Winter 2015
Prerequisites:
N/A
Corequisites:
N/A
Equivalents:
N/A
Pre/Co/Equiv Notes: N/A |
Course
Name (short): Spreadsheet Essentials
School: Business
Program(s):
Office Admin - Executive, Office Admin. Legal Coop, Office Administration Legal, Office Administration Medical
Program Coordinator(s):
Lisa Mendez
Course Leader or Contact: Leasa Steadman
Originator: Linda Sutherland
Designate: Linda Sutherland
Version: 2.0
Status: Approved (APPR)
Calendar Description
Students create professional spreadsheets of varying complexity by
entering and editing data, building formulas, and enhancing formatting
and functionality. Students identify tasks and problems that require
mathematics, and apply mathematical
techniques to accurately solve routine business problems. Students
then transfer these concepts into spreadsheet applications.
Typical Instructional Format
Lecture
|
42.0 |
Total hours: |
42.0 |
Courses may be offered in other formats.
Section I Notes:
N/A
|
|
|
Section II: Course Details
|
Detailed Description
Students use specialized software to create professional spreadsheets
of varying complexity by entering and editing data, building formulas,
and enhancing formatting and functionality. Students become proficient
in using a spreadsheet application to format, organize, analyze, and
present information. Students reinforce their skills in identifying
tasks and problems that require mathematics, and apply mathematical
techniques to accurately solve routine business problems involving
ratios, proportions, commissions, discounts and interest rates.
Students then transfer these concepts into spreadsheet applications
through hands-on learning and guided practice, in-class discussions,
and interactive lectures.
Program Context
|
Office Admin - Executive |
Program Coordinator: Lisa Mendez |
This is a required course in
the Office Administration
Programs. Students establish
foundation skills and
knowledge required in future
courses. The skills and
knowledge acquired and refined
in the course are essential to
perform effectively in the
workplace.
Office Admin. Legal Coop |
Program Coordinator: Lisa Mendez |
Same as executive.
Office Administration Legal |
Program Coordinator: Lisa Mendez |
Same as executive.
Office Administration Medical |
Program Coordinator: Lisa Mendez |
Same as executive.
|
Course Critical Performance and Learning Outcomes
|
Critical Performance
By the end of this course, students will have demonstrated the ability
to create accurate spreadsheets for business applications.
Learning Outcomes
To achieve the critical performance, students will have demonstrated
the ability to:
1. Produce spreadsheets with simple formulas.
2. Prepare charts and graphs.
3. Manipulate workbooks with multiple spreadsheets.
4. Differentiate between absolute, relative and mixed cell
references.
5. Format spreadsheets for presentation in a business setting.
6. Apply a variety of mathematical techniques to analyze information.
7. Compose simple to advanced formulas using mathematical operators
or functions.
|
Evaluation Plan
Students demonstrate their learning in the following ways:
|
Projects (4 at 5% each) 20%
Assignment 1 15%
Assignment 2 15%
Assignment 3 20%
Final Exam 30%
Total 100%
|
Provincial Context
The course meets the following Ministry of Training, Colleges and Universities requirements:
|
Essential Employability
Skills
Essential Employability Skills emphasized in the course:
X
|
Communication
|
X
|
Critical Thinking & Problem Solving
|
|
Interpersonal
|
X
|
Numeracy |
X
|
Information
Management |
|
Personal
|
Notes: N/A
Prior Learning Assessment and Recognition
PLAR Contact: Lisa Mendez
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: Winter 2015
Professor: Multiple Professors
Textbook(s): Spreadsheet Essentials(APPL10036): Business Math Using Excel,
Burton/Shelton
New Perspectives on Microsoft Excel 2013, Custom e-book access.
(purchased already in Term 1); available in SAM
RESOURCES:
SAM 2013 - http://sam.cengage.com//
SAM PIN is required to complete Tutorials, Exams and Projects.
Students purchased a SAM licence in term 1, and this remains active.
Applicable student group(s): Office Administration Medical, Executive, Legal - Year 1 students
Course Details:Module 1:
Reviewing Basic Math Functions
Introducing Excel and Spreadsheets
Introduction to Formulas and Functions
Project 1 - 5%
Assignment 1 - 15%
Module 2:
Working with Percentages
Formatting Workbook Text and Data
Formatting a Worksheet for Printing
Project 2 - 5%
Assignment 2 - 15%
Module 3:
Determining Discounts, Markups and Markdowns
Working with Functions and Cell References (Relative, Absolute and Mixed)
Using Logical and Lookup Functions
Project 3 - 5%
Assignment 3 - 20%
Module 4:
Calculating Simple Interest
Analyzing and Charting Financial Data
Creating Charts, Sparklines, and Data Bars
Project 4 - 5%
Final Exam 30%
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 ]
|
Copyright © Sheridan College. All rights reserved. |