APPL10111
Computer Applications 2
Sheridan College Logo
 
  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 2006
Prerequisites: N/A
Corequisites: N/A
Equivalents:
N/A
Pre/Co/Equiv Notes: A knowledge of Windows and the College Network

Program(s): Business, Business Admin Accounting, Business Admin Finance, Business Admin Marketing, Business Human Resources, E-commerce Management
Program Coordinator(s): Multiple Coordinators
Course Leader or Contact: Sue Newman
Version:
4.0
Status: Approved (APPR)

Section I Notes: N/A

 
 
Section II: Course Details

Detailed Description
The emphasis in this course is on using a computer as a professional tool in a business environment. The objective of this course is to reinforce the student's basic Windows skills,and introduce the student to spreadsheet terms, concepts and applications. Hands-on experience with microcomputers will be provided through WindowsXP and Excel 2003.

Program Context

 
Business Program Coordinator: Multiple
This course is a required component in the second semester of the Business Foundation Year and is a requirement in the Accounting, Finance, Human Resources and Marketing options. Program Coordinators: Mark Rust(Trafalgar); Carole Bowman (Davis)

Business Admin Accounting Program Coordinator: Multiple
Same as above. Program Coordinators: Sally Mitzel

Business Admin Finance Program Coordinator: Multiple
Same as above. Program Coordinator: Mark Weaver

Business Admin Marketing Program Coordinator: Multiple
Same as above. Program Coordinators: Doug Greenwood

Business Human Resources Program Coordinator: Multiple
Same as above. Program Coordinator: John Hardisty

E-commerce Management Program Coordinator: Multiple
Same as above. Program Coordinator: Jane Abramowitz


Course Learning Outcomes
Learning outcomes identify the critical performances, and the knowledge, skills and attitudes that successful students will have reliably demonstrated through the learning experiences and evaluation in the course. Successful students will have demonstrated the following:

 
 
            Knowledge
			
Successful students will have demonstrated knowledge of:
- the components of a WindowsXP desktop
- the use of WindowsXP menus, dialog boxes and toolbars
- effective file management
- the application of spreadsheets as business problem solving tools
- the basic elements of spreadsheet design

 
            Skills
			
Successful students will have demonstrated further development in 
their abilities to:
- open, close, save and print worksheets
- enter and edit labels, values and formulas
- create and print graphs
- copy formulas, values and labels
- use @ functions
- format values
- design presentation quality worksheets
- use versions and scenarios in the evaluation of alternatives
- work with multiple worksheets
- work with Excel lists
- integrate Excel with other windows programs and the world wide web

 
            Attitudes
			
Successful students will have demonstrated attitudes of:
- confidence to analyze and comprehend issues
- responsibility in meeting test and assignment deadlines



Evaluation Plan
Students demonstrate their learning in the following ways:

 
Evaluation:

Excel    Weekly Assignments  20%
         MidTerm             35%
         Final Exam          45%
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 2006
Professor: Multiple Professors
Textbook(s):
Microsoft Excel 2003 New Perspectives Series - Introductory

Applicable student group(s): Business Administration - Foundation Year Business Administration - Accounting Business Administration - Finance Business Administration - Human Resources Business Administration - Marketing E-commerce Management
Course Details:
Week 1:
Activity:   Course Introduction
            Create Shortcuts
            Copy Files
______________________________________________________________________

Prep/       Buy books - Microsoft Excel 2002 New Perspectives
Assignment: Introductory

Week 2:
Activity:   Tutorial 1

Prep/       See Web CT
Assignment: 
______________________________________________________________________

Week 3:
Activity:   Tutorial 2

Prep/       See Web CT
Assignment: 
______________________________________________________________________

Week 4:
Activity:   Tutorial 2

Prep/       See Web CT
Assignment:
______________________________________________________________________

Week 5:
Activity:   Tutorial 3

Prep/       See Web CT
Assignment:
______________________________________________________________________

Week 6:
Activity:   Review for Text on Tutorials 1-3
______________________________________________________________________

Week 7:
Activity:   Test on Tutorials 1-2

Prep/       See Web CT
Assignment:
______________________________________________________________________

Week 8:
Activity:   Tutorial 4

Prep/       See Web CT
Assignment:
______________________________________________________________________
Week 9:
Activity:   Tutorial 4

Prep/       See Web Ct
Assignment:
______________________________________________________________________
Week 10:
Activity:   Tutorial 5

Prep/       See Web CT
Assignment:  
______________________________________________________________________
Week 11:
Activity:   Appendix 2

Prep/       See Web CT
Assignment:  
______________________________________________________________________
Week 12:
Activity:   Review for Final Exam

______________________________________________________________________
Week 13:    
Activity:   Final EXCEL Exam
 
______________________________________________________________________
Week 14:
Activity:   Make-up Exams

______________________________________________________________________


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.