SMS210 - Microcomputer Applications for Business

Outline info
Last revision date 2017-11-20 15:16:55.563
Last review date 2017-11-20 15:18:00.306

Subject Title
Microcomputer Applications for Business

Subject Description
Building on the skills they have previously acquired in Excel and Windows operating systems, students will further develop their proficiency in these areas and add Access to their skill set. Throughout the course, they will apply these software skills to solve business problems.

Credit Status
One credit.

Learning Outcomes
Upon successful completion of this subject the student will be able to:

1. Use information technology terminology and concepts that demonstrate the ability to manage files in a Windows environment.

2. Use a Spreadsheet program to:
a) Assemble business related data into spreadsheets and files to meet normal business operational needs
b) Make effective presentation of business information using spreadsheets layouts, information formatting, and charts
c) Construct formulas using arithmetic operators needed for simple business calculations
d) Recognize when and which built-in functions should be used to address more complex business calculations
e) Apply various built-in statistical, logical and financial functions in meeting the requirements of more complex business calculations.

3. Use a Relational Database Management program to:
a) Assemble business related data into tables and databases
b) Manage the business data and objects within a database from input, quality, integrity, and organizational views
c) Analyze stored data using queries to solve typical business information needs
d) Make effective presentation of business information using forms and reports.

Cheating and Plagiarism
Each student should be aware of the College's policy regarding Cheating and Plagiarism. Seneca's Academic Policy will be strictly enforced.

To support academic honesty at Seneca College, all work submitted by students may be reviewed for authenticity and originality, utilizing software tools and third party services. Please visit the Academic Honesty site on for further information regarding cheating and plagiarism policies and procedures.

All students and employees have the right to study and work in an environment that is free from discrimination and/or harassment. Language or activities that defeat this objective violate the College Policy on Discrimination/Harassment and shall not be tolerated. Information and assistance are available from the Student Conduct Office at

Accommodation for Students with Disabilities
The College will provide reasonable accommodation to students with disabilities in order to promote academic success. If you require accommodation, contact the Counselling and Disabilities Services Office at ext. 22900 to initiate the process for documenting, assessing and implementing your individual accommodation needs.

ICA001 or equivalent knowledge. A knowledge of basic accounting is recommended.

Topic Outline

  •     File Management in a Windows environment
  •     Comparative advantages and disadvantages of spreadsheets vs. databases for effectively and efficiently managing business data.

  •     Creating and modifying worksheets
  •     Effective spreadsheet design
  •     Improving appearance of a worksheet
  •     Efficient creation of formulas
  •     Working with basic and advanced functions
  •     Sorting, filtering and editing lists
  •     Effective presentation of business data
  •     Working with charts
  •     Multiple-sheet workbooks
  •     Analysis tools.

  •     Efficient and effective database design
  •     Create database, tables and queries
  •     Add, modify and delete records
  •     Print the contents of a table, query, report and form
  •     Create relationships among tables
  •     Create queries
  •     Create reports and forms using wizards.

Mode of Instruction

A combination of teaching methods will be utilized which may include lectures, case studies, discussions, group and individual work.


This subject is delivered online. This may involve the use of digital materials and/or a text, group discussions, interaction with your instructor and online activities.

Prescribed Texts

Title 1: New Perspectives  - Microsoft Office 365 & Excel 2016: Intermediate
Author: Parsons/Oja/Carey/Desjardins
Publisher:  Cengage Learning
ISBN: 9781305880412

Title 2: New Perspectives  - Microsoft Office 365 & Access 2016: Introductory
Author: Shellman/vodnik
Publisher:  Cengage Learning
ISBN: 9781305880283


Title 1: New Perspectives  - Microsoft Office 365 Excel 2016 Intermediate
Author: Parsons/Oja/Carey/Desjardins
Publisher:  Cengage Learning
ISBN: 9781305880412

Title 2: New Perspectives  - Microsoft Office 365 & Access 2016: Introductory
Author: Shellman/vodnik
Publisher:  Cengage Learning
ISBN: 9781305880283

Reference Material

Required Supplies
A medium to store files, for example: a memory stick or writable CD ROM

Promotion Policy

Grading Policy
A+ 90%  to  100%
A 80%  to  89%
B+ 75%  to  79%
B 70%  to  74%
C+ 65%  to  69%
C 60%  to  64%
D+ 55%  to  59%
D 50%  to  54%
F 0%    to  49% (Not a Pass)
EXC Excellent
SAT Satisfactory
UNSAT Unsatisfactory

For further information, see a copy of the Academic Policy, available online ( or at Seneca's Registrar's Offices.

Modes of Evaluation
Assignments are due on the dates specified. Should extenuating circumstances arise, please contact your instructor prior to the assignment due date so that an appropriate course of action can be established. Late assignments may be subject to a penalty of up to 10% per week and will not generally be accepted beyond two weeks from the due date.

In cases of cheating or plagiarism, the College Academic Policy will prevail. Please ensure that all assignments and reports are properly documented.

Students are referred to the following website for Seneca College Library style guides, Academic Honesty Policy and Copyright guidelines:


Dates for evaluations are specified in the weekly schedule addendum to this outline. The evaluation process may include, but is not limited to, tests, exams, assignments or presentations. Any absences or missed submissions due to medical or other reasons must be supported by medical or other appropriate documentation within one (1) week of the due date. The faculty and program area must be notified immediately in the event of a missed evaluation. Upon acceptance of the documentation, the weighting of the missed deliverable will normally be applied to the final exam.

English Competency

The ability to communicate effectively is essential for success in business. Therefore, you must demonstrate English competency in this subject in both oral and written work. Ensure your written work includes correct sentence structure, spelling and punctuation. Always spell check, edit and proofread your work.

Grading is based on the following marking scheme:


Term Test 40%
Quiz 10%
Final Exam 50%


Discussion Assignments 20%
Project 1 15%
Project 2 15%
Project 3 15%
Final Exam* 35%

* Final Exams: The final exam for online subjects must be written at the Test Centre of the College at which you registered. If you are unable to do so, please make alternative arrangements through the College at which you registered. All the academic policies of the College at which you registered apply. This includes, but is not limited to policies related to grading, supplemental exams, deferred exams and accommodations.

Accelerated One-Week Classroom

Day 2: Excel Test 1 20%
Day 3: Excel Test 2 20%
Day 5: Access Quiz 10%
Day 10: FInal Exam 50%

Please retain this course outline document for future educational and/or employment use.

Program Coordinator
Cynthia Duncan

Approved by: Chair - Business Studies Danielle Mercier