APPL70072
Presentation and Spreadsheet Applications
Sheridan
 
  I: Administrative Information   II: Course Details   III: Topical Outline(s)  Printable Version
 
Section I: Administrative Information
  Total hours: 42.0
Credit Value: 3.0
Credit Value Notes: N/A
Effective: Fall 2020
Prerequisites: N/A
Corequisites: N/A
Equivalents: N/A
Pre/Co/Equiv Notes: Basic Windows Skills are required; knowledge of keyboarding is a definite asset.

Program(s): Office Administration
Program Coordinator(s): N/A
Course Leader or Contact: N/A
Version: 20200914_00
Status: Approved (APPR)

Section I Notes: This course is offered in class and online. The online version is a web-based course offered entirely online through Sheridan and hosted by Sheridan College. Students taking this course will need reliable access to the internet, and should have a basic level of comfort using computers as well as the self-discipline to study online. Students can expect to spend an additional three hours per week for online activities such as tutorials and projects. In addition, students need to have access to minimum hardware and operating system requirements in order to utilize online training, exams, projects and to complete tests.

 
 
Section II: Course Details

Detailed Description
Students create professional spreadsheets and presentations using specialized software. Students produce and edit spreadsheets of varying complexity by entering and editing data, building formulas,and enhancing spreadsheets. Students become proficient in using a spreadsheet application to format, organize, analyze, and present information. Students plan, create, and revise electronic presentations. Presentations are enhanced by formatting slides using design templates, styles, bullets and numbering, headers and footers,and speaker's notes. Visual appeal is created with images, animation effects, and sound and video effects. Through hands-on learning and guided practice, students learn the skills required to produce professional business presentations. In the online course, students will engage in online discussions, participate in online activities and assessments, and submit assignments online.

Program Context

 
Office Administration Program Coordinator(s): N/A
This course is a required course in the Office Administration Sheridan Certificate program, offered through the Faculty of Continuing and Professional Studies.


Course Critical Performance and Learning Outcomes

  Critical Performance:
By the end of this course, students will have demonstrated the ability to produce business materials by a specified deadline using spreadsheet and presentation software
 
Learning Outcomes:

To achieve the critical performance, students will have demonstrated the ability to:

  1. Produce basic spreadsheets with simple formulas.
  2. Prepare charts, web pages, and workbooks with multiple spreadsheets.
  3. Apply advanced formatting features such as alignment, fonts, styles, templates, graphic images, WordArt, maps, and borders.
  4. Compose simple to advanced formulas using mathematical operators or functions.
  5. Differentiate between absolute, relative, and mixed call references.
  6. Define the features and functionality of the specialized presentation software.
  7. Create professional presentations and slide show presentations with transitions and effects, enhanced formatting, images, and multimedia objects.
  8. Apply advanced formatting features such as colour schemes, design templates, images, animation, and visual elements.
  9. Review presentations for spelling and grammatical errors.
  10. Apply effective file management skills when creating documents and copying, moving, deleting and renaming files.

Evaluation Plan
Students demonstrate their learning in the following ways:

 Evaluation Plan: ONLINE
 Training (12 Total)24.0%
 Exams (12 Total)24.0%
 Projects (13 Total)52.0%
Total100.0%

Evaluation Notes and Academic Missed Work Procedure:
Online students are encouraged to complete all online work for assessment and preparation for the tests. No attendance in class is required. Training, Exams, Assignments and Case Studies are completed online through a publisher's software (SAM2016). Please note: Online students MUST have access to a computer that meets the computer requirements. All training/exams/projects must be completed as individual efforts unless the instructor states otherwise in writing. NOTES: This course requires Office 2016 Your workstation MUST meet the following minimum system requirements to use SAM/OFFICE 2016: Personal Computer or laptop: Processor: Intel Pentium 4 or higher processor required; Intel Centrino or an equivalent multi-core processor recommended Memory: 1 GB RAM (32-bit); 2 GB RAM (64-bit) Operating Systems: Windows 7 32- or 64-bit, or Windows 8 or 8.1 32- or 64-bit; Macintosh OX X 10.6 Snow Leopard or higher Audio & Video: Graphics: SVGA Resolution: Minimum recommended 1024x768 Colour: 32-bit Video Memory: 64 MB minimum; 128 MB recommended Video Card: Modern DirectX compatible Network: Internet connection: 56K modem minimum; broadband connection (cable, DSL, T1, or ISDN) recommended. Persistent connection required. Software and Disk Storage: Web Browsers: 4 MB Most recent version of Adobe Flash Player recommended; versions 9.0.115.0 or higher have been tested and are supported; versions prior to 9.0.115.0 are not supported: 2MB Adobe Reader: Version 8 or higher; Most recent recommended: 22.4 MB Microsoft Office 2016 Professional for Windows for SAM Projects. Please refer to your Microsoft documentation for current disk storage requirements. Supported Browsers: You can access SAM using the following browsers: Internet Explorer version 8 or higher Mozilla Firefox version 3.6 or higher Google Chrome version 33.0 or higher Safari version 4.0 or higher for Macintosh OSX No matter the browser you choose to use, the following have to be true to fully use SAM: JavaScript is enabled. Pop-up Blocking is disabled, either entirely or just for the SAM URL: sam.cengage.com Ad blocking software is disabled for the URL: sam.cengage.com



Evaluation Plan: IN-CLASS
 Training (12 Total)24.0%
 Exams (12 Total)24.0%
 Projects (13 Total)52.0%
Total100.0%

Evaluation Notes and Academic Missed Work Procedure:
In-class tests are to be written in class on the scheduled date. Exceptions may be considered at the discretion of the instructor. In such cases, the instructor may allow the student to write the test after the scheduled test date, provided the student contacts the instructor to advise him/her of the situation. - Medical documentation is required for medical situations - Requests based on compassionate or other grounds must be submitted in writing. - In situations where a student knows, in advance, that s/he will not be available on the scheduled test date, the student must contact the instructor, in writing, prior to the scheduled test date providing an explanation, and a request to write the test on an alternate date. In these situations, the test must be written in advance of the scheduled test date. All tests not written on the scheduled test date must be written in the Test Centre. Exceptions are tests that require the use of a computer. In these cases, arrangements should be made with the instructor to write in class on an alternate date. Students are encouraged to attend all classes. For submission of assignments and projects, the instructor will specify, in writing: - Due dates and special instructions for submissions - Deductions for overdue submissions All assignments must be completed as individual efforts unless the instructor states otherwise in writing. NOTES: This course requires Office 2016 Your workstation MUST meet the following minimum system requirements to use SAM/OFFICE 2016: Personal Computer or laptop: Processor: Intel Pentium 4 or higher processor required; Intel Centrino or an equivalent multi-core processor recommended Memory: 1 GB RAM (32-bit); 2 GB RAM (64-bit) Operating Systems: Windows 7 32- or 64-bit, or Windows 8 or 8.1 32- or 64-bit; Macintosh OX X 10.6 Snow Leopard or higher Audio & Video: Graphics: SVGA Resolution: Minimum recommended 1024x768 Colour: 32-bit Video Memory: 64 MB minimum; 128 MB recommended Video Card: Modern DirectX compatible Network: Internet connection: 56K modem minimum; broadband connection (cable, DSL, T1, or ISDN) recommended. Persistent connection required. Software and Disk Storage: Web Browsers: 4 MB Most recent version of Adobe Flash Player recommended; versions 9.0.115.0 or higher have been tested and are supported; versions prior to 9.0.115.0 are not supported: 2MB Adobe Reader: Version 8 or higher; Most recent recommended: 22.4 MB Microsoft Office 2016 Professional for Windows for SAM Projects. Please refer to your Microsoft documentation for current disk storage requirements. Supported Browsers: You can access SAM using the following browsers: Internet Explorer version 8 or higher Mozilla Firefox version 3.6 or higher Google Chrome version 33.0 or higher Safari version 4.0 or higher for Macintosh OSX No matter the browser you choose to use, the following have to be true to fully use SAM: JavaScript is enabled. Pop-up Blocking is disabled, either entirely or just for the SAM URL: sam.cengage.com Ad blocking software is disabled for the URL: sam.cengage.com

Provincial Context
The course meets the following Ministry of Colleges and Universities requirements:


 

Essential Employability Skills
Essential Employability Skills emphasized in the course:

  • Information Management - Locate, select, organize and document information using appropriate technology and information systems.

Prior Learning Assessment and Recognition
PLAR Contact (if course is PLAR-eligible) - Office of the Registrar

  • Not Eligible for PLAR

 
 
Section III: Topical Outline
Some details of this outline may change as a result of circumstances such as weather cancellations, College and student activities, and class timetabling.
Print Instruction Mode Professor Applicable Student Group(s)
In-Class Multiple Professors Continuing & Professional Studies students in the Office Administration program
Online Multiple Professors Continuing & Professional Studies students in the Office Administration program

Sheridan Policies

All Sheridan policies can be viewed on the Sheridan policy website.

Academic Integrity: The principle of academic integrity requires that all work submitted for evaluation and course credit be the original, unassisted work of the student. Cheating or plagiarism including borrowing, copying, purchasing or collaborating on work, except for group projects arranged and approved by the professor, or otherwise submitting work that is not the student's own, violates this principle and will not be tolerated. Students who have any questions regarding whether or not specific circumstances involve a breach of academic integrity are advised to review the Academic Integrity Policy and procedure and/or discuss them with the professor.

Copyright: A majority of the course lectures and materials provided in class and posted in SLATE are protected by copyright. Use of these materials must comply with the Acceptable Use Policy, Use of Copyright Protected Work Policy and Student Code of Conduct. Students may use, copy and share these materials for learning and/or research purposes provided that the use complies with fair dealing or an exception in the Copyright Act. Permission from the rights holder would be necessary otherwise. Please note that it is prohibited to reproduce and/or post a work that is not your own on third-party commercial websites including but not limited to Course Hero or OneNote. It is also prohibited to reproduce and/or post a work that is not your own or your own work with the intent to assist others in cheating on third-party commercial websites including but not limited to Course Hero or OneNote.

Intellectual Property: Sheridan's Intellectual Property Policy generally applies such that students own their own work. Please be advised that students working with external research and/or industry collaborators may be asked to sign agreements that waive or modify their IP rights. Please refer to Sheridan's IP Policy and Procedure.

Respectful Behaviour: Sheridan is committed to provide a learning environment that supports academic achievement by respecting the dignity, self-esteem and fair treatment of every person engaged in the learning process. Behaviour which is inconsistent with this principle will not be tolerated. Details of Sheridan's policy on Harassment and Discrimination, Academic Integrity and other academic policies are available on the Sheridan policy website.

Accessible Learning: Accessible Learning coordinates academic accommodations for students with disabilities. For more information or to register, please see the Accessible Learning website (Statement added September 2016)

Course Outline Changes: The information contained in this Course Outline including but not limited to faculty and program information and course description is subject to change without notice. Any changes to course curriculum and/or assessment shall adhere to approved Sheridan protocol. Nothing in this Course Outline should be viewed as a representation, offer and/or warranty. Students are responsible for reading the Important Notice and Disclaimer which applies to Programs and Courses.


[ Printable Version ]

Copyright © Sheridan College. All rights reserved.