Outline: SMS213

BUSINESS DECISION MAKING SOFTWARE

Prerequisites

ICA001 and ACC120 or ICA001 and ACC106

Co-requisite

EAC150
ESL934 or EAC149 or EAC150

Topic Outline

See chart below

Modes of Instruction

This subject will be taught in a classroom instructional mode utilizing lecture and lab assignments. Students are expected to have reviewed the text material prior to class.

Prescribed Texts and Tutorials

The text for SMS213 is a package that includes the following:
1. Microsoft Office Excel 2007 In Business-Comprehensive Editon by Joseph M. Manzo, published by Pearson
2. Myitlab by Pearson
3. Purbhoo Simply Accounting

The ISBN for this package is: 0138003998 from Pearson. Please note this package has been updated for January 01, 2009 therein any previous packages will not be applicate.

Required Supplies

1 GB USB Flash Menory for saving your lab based assignments

Modes of Evaluation

I have placed the new text times here just for clarification

Simply Accounting Test	10%
Excel test 1	25%
Excel test 2	30%
Excel test 3	30%
Assignments	5%
TOTAL	100%

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

Term Test and Lab Tests

Test dates are disclosed in the “Detailed Course Outline”. There are no makeup tests unless you have a medical reason. If you have a medical reason you will need to present a medical document, in a prescribed format when required, to the Professor. Please remember this information will be validated and if found to be false this will be deemed as Academic dishonesty.

SeneLab Tools, a software application developed by Seneca College, is used to download files, where applicable, and to upload files (your answers) at the end of a test. There are exercises in class to practice downloading and uploading files.

The student will take full responsibilities to ensure that
1.1. he/she can properly download and upload files using SeneLab Tools,
1.2. he/she has uploaded (submitted) his/her answer(s), as required, using SeneLab Tools,
1.3. the files (answers) uploaded are not corrupted.
No assistance will be available in this respect during a test.

If the files (answers) that a student uploads are corrupted, the test will not be marked resulting a zero and there is no make-up test.

It is required that test files are uploaded on time at the end of a test. Late submissions will not be accepted.

Supplementary Information

Upon the successful completion of the course, the student may be interested in applying for the Microsoft Certified Application Specialist: Microsoft Office Excel 2007 certificate (MCAS certificate) by taking the exam offered by Microsoft. Please see the following site; http://www.microsoft.com/learning/exams/77-602.mspx for further information. In the event this link is broken please search the Microsoft site. .

Professor(s):

Terry Pegler	Room C4018	Extension 2280
Leroy DaCosta	Room C4049	Extension 2276
Romana Girdauskas	Room C4023	Extension 6051
John Kucharczuk	Room C4022	Extension 6641
Shelly York	Room C4022	Extension 6049
Tom Honey	Room C4048	Extension 2627
Cary Ng	Room C4035	Extension 2830
Dubravko Zgrablic	Room C2025	Extenstion 2490

APPROVED BY: _________________________________________

KAREN MURKAR, Chair
School of Accounting and Financial Services

SMS213
DETAILED TOPIC OUTLINE
WINTER 2009 (091)

Week	Lab
1	Review of computer fundamentals and an Introduction to Simply Accounting Review of computer fundmentals How to save files and build directories Introduction to Seneca Lab test system Simply Accounting Part 1 Getting Started Chapter 1: Introduction to Simply Accounting Data Files, Backing up data files, Accessing data files and help features, Date formats and settings, saving and finishing a Chapter 2 GST and PST General Tax Information
2	Simply Accounting Part 2: Applications Chapter 3; Missoni Marbleworks General Journal Entering Journal Transaction Adding New Accounts Adjusting Posted Entries Reporting
3	Simply Accounting Test Excel Chapter 1: Introduction, What is Excel Excel Chapter 2: Excel Basics Data Management, Formatting, Editing, Printing
4	Excel Chapter 3: Calculating, Data Fromulas and Functions Basic/Pasting Formulas, Complex Formulas, Auditing Formulas Basic Functions Basic Statistics, Auto Sum, Absolute/Relative referencing Financial Functions Future Value, Payment, Function library
5	EXCEL TEST ONE Excel Chapter 4; Evaluation Data Logical Functions If function, Nested If function, and or functions and combinations Lookup functions V-Lookup, H-Lookup
6	Excel Chapter 5; Presenting Information with Charts Creating Charts, Formatting Charts, Advanced Charts Options
7	Excel Chapter 6; Applying Core Competency Skills: Financial Planning and Accounting Linking and Consolidating Data, Linking and Consolidating worksheets and workbooks Updating links, SUMIF function Financial Planning Finacial assumptions, Freeze panes, Financial data, Cash analysis - NPV function Financial Accounting T-Accounts, Journals, Ledgers, Trail Balance Statements
Mar 02	STUDY WEEK
8	EXCEL TEST TWO Excel Chapter 7; Date textand IS functions Date Functions Today, Year and Month functions, Date and Day function Concatenate function, Search, Left, Len and Mid functions
9	Chapter 7 (continued) IS Functions ISNUMBER, ISTEXT, ISERROR functions Excel Chapter 8; Managing Large Volumes of Data Pivot Tables Building new pivot tables, Adding fields and changing field settings, Applying filters to fields, Adding and removing report totals, Adding formulas (calculated fields).
10	Chapter 8 (continued) Pivot charts Tools for Selectingand Summarizing Data Filters. Subtotals, Adding the developer Tab, List boxes
11	Excel Chapter 9; Scenario Tools Scenario Tools, Scroll bar, Conditonal formatting, Data tables, Goal seek, Scenario Manager, Solver
12	Excel Chapter 10; Working with External Data opening text files, Delimited text files, Fixed width data files. Connecting to external data, Improting data from Access Database, importing data from the WEB, Importing text files
13	EXCEL TEST THREE
14	EXAM WEEK

Last Updated: Winter 2009