School Specific Outline: SMS202

MICROCOMPUTER BUSINESS APPLICATIONS II 

Prerequisites

ICA001 Introduction to Computers and Applications 

Topic Outline        (see last page)

Modes of Instruction

Mixed Mode Delivery
Three periods per week will be scheduled for the student in a computer lab.  For part of this time, the student will interact directly with the professor who may demonstrate skills, take-up assignments,  lecture on concepts, administer quizzes, and ensure students understand how to access and use the on-line materials.  For the remainder of this time, students will be expected to work independently at their own pace within the parameters of identified deadlines and under the guidance of the professor.  Students will use the Internet to login to SMS 202 at https://my.senecacollege.ca

Prescribed Texts and Tutorials

 E-Learn Real World MS Excel 2007, Ola Cholkan, McGraw-Hill Ryerson, 2008.
 ISBN: 0070135355.  Student must purchase access code from bookstore cashier to access online materials.

Seneca Libraries. Guide to Research and Citation: MLA Style. 3rd.ed. Toronto:  Seneca College, 2009. Print.
 

Required Supplies

Students are expected to have an active Learn e-mail account (User ID and password required).  In order to access online materials from home, students require an Internet connection and a microcomputer with the following specifications:
  • A Microsoft Windows operating system 
  • Microsoft  Excel 2007
  • Microsoft  Word 2007
  • Microsoft Internet Explorer (version 6.0 or higher) OR Mozilla Firefox




Modes of Evaluation

     
    3-Application Tests
    (1 @ 20%, 1 @ 25% and 1@ 35%)   
    		  80%
    Weekly assignments   10%
    Microcomputer terminology project    10%

    Please Note:

    Tests not completed on the scheduled dates will be assigned a mark of zero. In exceptional circumstances, it is the student's responsibility to provide written documentation to the professor who may choose to make special arrangements. 

    Assignments must be submitted before or on the due date. Late assignments are never accepted because the grade is given for timely submission and completion rather than for completion alone.  Assignments must be submitted electronically via the SMS202 course at the :  https://my.senecacollege.ca site.

    Assignments that are obviously copied will be graded zero for both the student that copied and the student that was copied from and subject to further action as outlined in Seneca College's Cheating and Plagarism policy.

    The student agrees to take reasonable precautions with respect to ensuring that assigned work is submitted on time. Hardware and software failures, including the connection to the https://my.senecacollege.ca site, should be anticipated and cannot be used as an excuse for not submitting work. Files should be regularly backed up.
     

Promotion Policy:    Refer to the Seneca Academic Policy

Grading Policy

  • A+    90% -   100%      4.0
  • A      80% -    89%       4.0
  • B+    75% -    79%       3.5
  • B      70% -    74%       3.0
  • C+    65% -    69%       2.5
  • C      60% -    64%       2.0
  • D      55% -    59%       1.0
  • F       0%  -     54%       0.0

 
 
 
 

PROFESSOR(s): 

Ola Cholkan, Room C-1022, Ext. 6118
Sarah Arliss, Room C-1031, Ext. 6116


Stefan Kanitz, Room M500, Ext. 7533 - (Markham)


 
 
 
 
 
 
 

APPROVED BY:     ____________________________________        ____________
                                     Academic Chair:  Chris Dudley                                  Date
                                     School of Business Management
 
 

PLEASE KEEP THIS DOCUMENT FOR FUTURE REFERENCE.  IT WILL BE REQUIRED IF YOU APPLY TO ANOTHER EDUCATIONAL INSTITUTION AND SEEK ADVANCED STANDING!

Revised For:   FALL  2009
 


 
 








DETAILED TOPIC OUTLINE - (093)

SMS 202



WEEK
LEARNING UNIT
1 Course Overview
2 Microcomputer terminology (15%)
3 File Management
4 Spreadsheets - The Basics
5 Test #1 - File Management & Spreadsheet Basics (15%)
6 Spreadsheets: Advanced Formatting & Charting
7 Spreadsheets: Advanced Formulas & Functions
- S T U D Y      W E E K
8 Spreadsheets: Large & Multiple Worksheets
9 Test #2 - Spreadsheets: Advanced Formatting & Charting, Advanced Formulas & Functions, Large & Multiple Worksheets (20%)
10 Spreadsheets: Tables
11 Spreadsheets: Data Analysis
12 Data Exchange
13 Test #3 - Comprehensive Spreadsheets & Data Exchange (35%)



Last Updated For:   FALL  2009