Course Name (short): Computer Applications
School: Business
Program(s): Banking and Wealth Management, Business, Business Admin Accounting, Business Admin Finance, Business Admin Marketing, Business Human Resources, Tourism and Travel
Program Coordinator(s): Carole Bowman, Roger Halfacre, Carol Bureau, Judith Hunter, Sally Mitzel, Mark Weaver
Course Leader or Contact: Laura Gill
Originator: Jessica MacDougall
Designate: Jessica MacDougall
Version: 20.0
Status: Approved - Under Rev (AREV)

Calendar Description
Students examine and apply essential computing concepts to develop file management and desktop management skills appropriate for the business environment. Students use a variety of computer application software (word processing, spreadsheet, and presentation applications) to create documents that can be used to communicate and support decision making within an organization.

Typical Instructional Format

Courses may be offered in other formats.

Section I Notes: This course is offered in a mobile hybrid environment. The hybrid environment is 2 hours in a classroom and 1 hour virtual per week. Students taking this course will need reliable access to the internet and manage the virtual component to the course. Students should have a basic level of comfort using computers as well as the self discipline to study online. This is a web-based course offered online, using Sheridan's current LMS (Learning Management System). Students in mobile computing program at Sheridan are required to bring a laptop computer that complies with their program's hardware and software standards.

Detailed Description
Students examine and apply essential computing concepts to develop file management and desktop management skills appropriate for the business environment. Students use a variety of computer application software (word processing, spreadsheet, and presentation applications) to create documents that can be used to communicate and support decision making within an organization. Through interactive lecture, demonstrations, active learning, in-class discussions, online tutorials, independent activities, students learn the skills to create professional presentations, well formatted business documents, as well as accurate professional spreadsheets.

Program Context

 Critical Performance Statement:

By the end of this course, students will have demonstrated the 
ability to use standard business computer application software (word 
processing, spreadsheet, and presentation applications) to create 
documents that can be used to communicate and support decision making 
within an organization.

Learning Outcomes:

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

1.  Demonstrate best filing practices using operating system software 
    to organize file directories, search for files and handle 
    different tasks related to storing electronic files.

2.  Apply operating system software and Sheridan network resources to 
    download software, map drives as well as print drivers.

3.  Utilize learning management software to electronically submit 
    assignments and tests.

4.  Use collaborative teaching tool for virtual learning, delivery 
    and communication.

5.  Publish professional business slide show presentations using 
    enhanced formatting, images, objects and slide masters.

6.  Produce word processing documents that include business letters, 
    memos, tables and reports that meet specific requirements    
    including formatting.

7.  Create tables, diagrams and objects that effectively communicate 
    information in a variety of business documents using word  
    processing software.

8.  Develop electronic spreadsheets that include mathematical 
    formulas, statistical functions and financial functions to 
    calculate information needed to support business decisions.

9.  Analyze data of a given business case to select the appropriate 
    charts to be inserted in spreadsheets in order to display the 
    data graphically.

10. Demonstrate professional behaviours including commitment to 
    meeting due dates and completing assignments to professional 
    standards.

Students demonstrate their learning in the following ways:

10% 	Online Training
14%     Quizzes
6%      Discussions
10%     PowerPoint Test
25% 	Word Test
35%	Excel Test

None required

Module 1:
Introduction to Course
- Overview of course, weekly outline, and evaluation plan
- Introduction of course resources - required Office 2013  
- Login, installation of software, learning management system, 
  communication tools and network information


Module 2:  PowerPoint 2013
Introduction to PowerPoint
- Add and modify text
- Create effective presentations 
- Presentation content
- Format, layouts, themes, edit, and slide arrangement

PowerPoint Presentations
- Graphics, objects and formatting
- Slide master, slide numbering, headers/footers and other objects

PowerPoint Test


Module 3:  Word 2013
Preparation of Business Documents
- Write a business letter and memo
- Paragraph formatting, line spacing, margins and other formatting    
  features
- Insert, delete, resize graphics

Create, Edit and Format a Report
- Create bulleted lists, move text, find & replace, spell check and 
  grammar
- Report formatting including page numbers, and references
- Report navigation pane
- Create and modify tables
- Create tabs, footnotes/endnotes, section breaks, headers/footers,  
  cover page

Discussion 1
Word Test


Module 4:  Excel 2013
Create Worksheets to Make Business Decisions
- Understand the use of worksheets and parts of window
- Create and modify worksheets with basic formatting
- Work with editing tools as well printing and spell check
- Create formulas using mathematical operators and other basic  
  functions

Working with Formulas and Functions
- Create formulas using relative, absolute, and mixed referencing 
- Copy formulas using Auto Fill Handle as well as review function 
  syntax
- Create formulas using Insert Function 
- Create formulas using financial functions

Develop Professional Workbooks
- Create and modify worksheets using various formatting such as 
  fonts, fill colours, backgrounds, alignment, merge cells as well 
  as styles and other formatting
- Create formulas using mathematical operators and percentages
- Create footers, fit to one page, and other page setup options
- Create conditional format

Enhance a Workbook with Charts and Graphics
- Create charts by analyzing data and selecting appropriate 
  information to convey a message
- Apply chart format such as type, titles, legends, moving/resizing, 
  and other customized layout 
- Distinguish between a chart versus a chart within the
  current sheet along with trendlines

Discussion 2
Excel Test