SMS216 - Systems Studies I

Outline information
Schools offering this subject
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

Academic Integrity
Seneca upholds a learning community that values academic integrity, honesty, fairness, trust, respect, responsibility and courage. These values enhance Seneca's commitment to deliver high-quality education and teaching excellence, while supporting a positive learning environment. Ensure that you are aware of Seneca's Academic Integrity Policy which can be found at: Review section 2 of the policy for details regarding approaches to supporting integrity. Section 2.3 and Appendix B of the policy describe various sanctions that can be applied, if there is suspected academic misconduct (e.g., contract cheating, cheating, falsification, impersonation or plagiarism).

Please visit the Academic Integrity website to understand and learn more about how to prepare and submit work so that it supports academic integrity, and to avoid academic misconduct.

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 Accessibility Services Office at ext. 22900 to initiate the process for documenting, assessing and implementing your individual accommodation needs.