SMS333 - Computer Applications

Outline information
Semester
Schools offering this subject
Last revision date Feb 1, 2016 12:17:55 AM
Last review date Apr 11, 2016 12:15:11 AM

Subject Title
Computer Applications

Subject Description
This subject enables students to apply business and marketing related concepts using spreadsheet, database, presentation and web development software.  Students will learn how to create, format and chart spreadsheet, how to enter and query data from a database, how to create professional forms and reports, how to effectively integrate data/files across multiple Office applications.

Targeted provisions were made to the subject content to provide students with the specific knowledge and skills required for passing Microsoft Office Specialist Exams, 77-420 Excel 2013 and 77-424 Access 2013.

Credit Status
One credit.

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

  1. Submit assignments that reflect verbal and/or written instructions.
  2. Develop self-directed strategies to independently learn new features of the software applications and incorporate these skills in assignments.
  3. Demonstrate the ability to use MySeneca and its features and tools effectively:
    • regularly refer to course materials posted in Blackboard
    • submit electronic assignment files in the appropriate folders in Blackboard
    • use the Content System to store and backup assignment files
    • use SeneLAB to download seed and upload completed test files
  4. Demonstrate ability to create effective business presentations while incorporating a variety of PowerPoint features including, but not limited to, graphics, multimedia, different layouts and designs, slide transitions, bullet animation, charts and Smart Art Objects.
  5. Apply business knowledge and appropriate design principles to an electronic presentation and be able to present in front of an audience as an individual or as a team member.
  6. Evaluate how Internet Technology facilitates marketing of goods and services for consumers and businesses.
  7. Create and use databases and database objects:
    • explain the basic purposes, principles and vocabulary of relational databases\
    • define/change fields and field properties
    • demonstrate the ability to add, delete or edit records
    • create queries, sort records as required, apply appropriate criteria to achieve a stated quer
    • requirement, and be able to join multiple tables
    • create standard forms and reports, using wizards, with emphasis on groups, totals and summaries
  8. Create and modify spreadsheets:
    • enter values and labels in cells
    • use copy, paste, formatting, editing and printing
    • use format painter
    • build formulas using arithmetic operators
    • use functions (including, but not limited to, SUM, AVERAGE, COUNT, MIN, MAX, NOW, TODAY, DATE, TIME, IF, ROUND, PMT, FV, PV, RATE)
    • use and understand the difference between relative and absolute cell references
    • apply conditional formatting
    • manage multiple worksheets by inserting, renaming and deleting
    • create and edit embedded charts
    • create and use pivot tables and charts
    • use what-if analysis, goal seek, scenario manager and solver
  9. Understand the process of integration of different applications in Microsoft Office and how they function together.

Essential Employability Skills
Communicate clearly, concisely and correctly in the written, spoken and visual form that fulfils the purpose and meets the needs of the audience.

Respond to written, spoken, or visual messages in a manner that ensures effective communication.

Execute mathematical operations accurately.

Apply a systematic approach to solve problems.

Use a variety of thinking skills to anticipate and solve problems.

Locate, select, organize, and document information using appropriate technology and information systems.

Analyze, evaluate, and apply relevant information from a variety of sources.

Show respect for diverse opinions, values, belief systems, and contributions of others.

Interact with others in groups or teams in ways that contribute to effective working relationships and the achievement of goals.

Manage the use of time and other resources to complete projects.

Take responsibility for one's own actions, decisions, and consequences.

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 http://library.senecacollege.ca for further information regarding cheating and plagiarism policies and procedures.

Discrimination/Harassment
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 student.conduct@senecacollege.ca.

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.