# SMS216 - Systems Studies I

 Semester Fall - 2020 Summer - 2020 Winter - 2020 Fall - 2019 Summer - 2019 Winter - 2019 Fall - 2018 Summer - 2018 Winter - 2018 Fall - 2017 Summer - 2017 Winter - 2017 Fall - 2016 Summer - 2016 Winter - 2016 Fall - 2015 Summer - 2015 Winter - 2015 Fall - 2014 Summer - 2014 Winter - 2014 Fall - 2013 Summer - 2013 Winter - 2013 Fall - 2012 Schools offering this subject Select school School of Accounting and Financial Services Last revision date May 25, 2020 12:06:47 AM Last review date Aug 3, 2020 12:15:02 AM

Subject Title
Systems Studies I

Subject Description
This course has been designed to focus on the use and application of spreadsheet and relational database software as used by accountants today to make decisions, analyze, and present data. This course provides real business scenarios that meet professional standards and provides a solid basis on how to use spreadsheet and relational database software to identify the best alternatives related to critical and key business decisions.

Credit Status
One Credit

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

1. Demonstrate basic use of an operating system, including managing files and folders.

2. Explain terms and concepts used in spreadsheet software

3. Interpret results arrived at using a spreadsheet software

4. Apply database design principles to determine required tables, primary key(s) and other fields for each required table.

5. Explain database concepts and key terms such as primary key, foreign key, relationship and field

6. Use a spreadsheet software to:
6.1. Perform basic functions such as cell referencing, data entry, copy, paste, formatting, editing and printing
6.2. Build formulas using math and statistical functions, and evaluate investment projects
6.3. Build formulas using logical (IF, IF\AND, IF\OR and nested Ifs) functions and lookup functions
64. Organize data to facilitate data management and analysis using Excel tables
6.5. Highlight or emphasize cells that meet specific conditions using conditional formatting
6.6. Summarize large amounts of data to facilitate decision making by using pivot tables, pivot charts, database functions and subtotals

7. Use a database software to perform tasks\functions as follow:
7.1. Create databases
7.2. Create, adjust, and maintain tables
7.3. Create, adjust, and maintain queries
7.4. Create, adjust, and maintain forms, including forms with subforms
7.5. Create, adjust, and maintain reports
7.6. Apply validation rules and other control features to improve data integrity
7.7. Backup, recover, compact and repair databases