Course Outline - Centennial College

Course Outline School:

Business

Department:

Business Management

Course Title:

Applied Business Software 2

Course Code:

COMP 126

Course Hours/Credits:

56

Prerequisites:

BFPE 111, COMP 106

Co-requisites:

N/A

Eligible for Prior Learning, Assessment and Recognition:

Yes

Originated by:

Kerri Shields

Creation Date:

Fall 2014

Revised by:

Kerri Shields

Revision Date:

Fall 2014

Current Semester:

Summer 2015

Approved by:

Chairperson/Dean

Students are expected to review and understand all areas of the course outline. Retain this course outline for future transfer credit applications. A fee may be charged for additional copies. This course outline is available in alternative formats upon request.

COMP 126

CENTENNIAL COLLEGE


Course Description Skills in managing information are essential as businesses continue to utilize technologies to gain a competitive edge. College graduates who can locate, gather, and organize information using appropriate technology and information systems will be able to compete for employment and be more successful in their job roles. In this course students learn how spreadsheets and databases are used by business professionals. Students use Microsoft Excel 2013 tools such as formulas and functions, pivot tables, charts, and scenarios to solve problems, analyze data, and make decisions. Students also learn how to create and query a Microsoft Access 2013 database. This course includes an integrative project whereby students use multiple Microsoft Office programs to complete a business project. This course teaches many of the skills measured by the Core Microsoft Office Specialist (MOS) exam. Exam criteria and details can be referenced at the Microsoft website should students wish to pursue Microsoft MOS certification.

Program Outcomes Successful completion of this and other courses in the program culminates in the achievement of the Vocational Learning Outcomes (program outcomes) set by the Ministry of Training, Colleges and Universities in the Program Standard. The VLOs express the learning a student must reliably demonstrate before graduation. To ensure a meaningful learning experience and to better understand how this course and program prepare graduates for success, students are encouraged to review the Program Standard by visiting http://www.tcu.gov.on.ca/pepg/audiences/colleges/progstan/. For apprenticeship-based programs, visit http://www.collegeoftrades.ca/training-standards.

Course Learning Outcomes The student will reliably demonstrate the ability to: 1. Use Microsoft Excel to produce spreadsheets for a variety of business needs (e.g., cash flow analysis, budgeting, cost estimating, inventory management, and financial reporting). 2. Use Microsoft Access to enter, maintain, and retrieve data in a relational database format. 3. Analyze and interpret data for problem-solving and decision-making processes. 4. Analyze a business case/situation and use appropriate technology to record, organize and present information in a form that will clearly be understood by end users and management (e.g., charts, tables, functions/formulas, queries, lists, images; using suitable language and terminology). 5. Use appropriate mathematical tools, statistical tools and software to process data, identify trends, address business enquiries and product reports. 6. Solve a business need by integrating Microsoft Office software programs to produce a complete business solution for information storage, manipulation, and presentation.

Essential Employability Skills (EES) The student will reliably demonstrate the ability to*: 1. Communicate clearly, concisely and correctly in the written, spoken, and visual form that fulfills the purpose and meets the needs of the audience.

THIS COURSE ADHERES TO ALL COLLEGE POLICIES (See College Calendar)

2

COMP 126

CENTENNIAL COLLEGE


2.

Respond to written, spoken, or visual messages in a manner that ensures effective communication. 3. Execute mathematical operations accurately. 4. Apply a systematic approach to solve problems. 6. Locate, select, organize, and document information using appropriate technology and information systems. 10. Manage the use of time and other resources to complete projects. *There are 11 Essential Employability Skills outcomes as per the Ministry Program Standard. Of these 11 outcomes, the following will be assessed in this course.

Global Citizenship and Equity (GC&E) Outcomes N/A

Methods of Instruction Instructor-led lessons, skills assessment software, hands-on exercises

Text and other Instructional/Learning Materials Text Book(s): Microsoft Excel and Access 2013. New Perspectives on Microsoft Office 2013, Custom Publication with SAM, Cengage Learning. ISBN: 017665707X NOTE: Due to needing an access code, students must purchase a NEW textbook package in order to complete the course. Supplies: USB Memory Stick (at least 1 GB recommended), Ear Phones/Headset (optional) Custom Courseware: SAM Skills Assessment Manager

Classroom and Equipment Requirements Computer, Microsoft Office, Internet

Evaluation Scheme ➮ Excel 2013 SAM Projects (6 x 5%): Excel 2013 SAM Projects (6 x 5% each): Students complete an Excel, hands-on project from the SAM system as assigned by professor. ➮ Excel 2013 SAM Assessment 1: Students complete a skills assessment/test in SAM. Questions are based on Excel Tutorials 1-4. ➮ Excel 2013 SAM Assessment 2: Students complete a skills assessment/test within SAM. Questions are based on Excel tutorials 5, 6, and 8. ➮ Excel 2013 SAM Capstone Project: Students complete a SAM project based on Excel tutorials 1-4. ➮ Access 2013 SAM Projects (3 x 5%): Access 2013 SAM Projects (3 x 5% each): Students complete an Excel, hands-on project from the SAM system as assigned by professor. ➮ Access 2013 SAM Assessment: Students complete a skills assessment/test within SAM. Questions are based on Access tutorials 1-3.


3

COMP 126

CENTENNIAL COLLEGE


➮ Integrating Microsoft Office Assignment: Students integrate Microsoft Office programs to complete a business project. Evaluation Name Excel 2013 SAM Projects (6 x 5%) Excel 2013 SAM Assessment 1 Excel 2013 SAM Assessment 2 Excel 2013 SAM Capstone Project Access 2013 SAM Projects (3 x 5%) Access 2013 SAM Assessment Integrating Microsoft Office Assignment Total

CLO(s)

EES GCE Weight/100 Outcome(s) Outcome(s) 1, 3, 4, 5 1, 2, 3, 4, 30 6, 10 1, 3, 4 2, 3, 4 10 1, 3, 4 2, 3, 4 15 1, 3, 4, 5 1, 2, 3, 4, 10 6, 10 2, 3, 4 1, 2, 4, 10 15 2, 3, 4 2, 4 10 1, 2, 3, 4, 5, 6 1, 2, 3, 4, 10 6, 10 100%

If students are unable to write a test they should immediately contact their professor or program Chair for advice. In exceptional and well documented circumstances (e.g. unforeseen family problems, serious illness, or death of a close family member), students may be able to write a make-up test. All submitted work may be reviewed for authenticity and originality utilizing Turnitin®. Students who do not wish to have their work submitted to Turnitin® must, by the end of the second week of class, communicate this in writing to the instructor and make mutually agreeable alternate arrangements. When writing tests, students must be able to produce official College photo identification or they may be refused the right to take the test or test results will be void.

Student Accommodation It is College Policy to provide accommodation based on grounds defined in the Ontario Human Rights Code. Accommodation may include modifications to standard practices. Students with disabilities who require academic accommodations must register with the Centre for Students with Disabilities. Students requiring accommodation based on other human rights grounds should talk with their professors as early as possible. Please see the Student Accommodation Policy.

Use of Dictionaries •

Any dictionary (hard copy or electronic) may be used in regular class work.

Program or School Policies N/A

Course Policies Passing Grade: Students must achieve an overall course grade of at least 50% in order to pass the course. In addition, students must obtain at least 50% on the Excel portion of the course as well as 50% on the Access portion of the course. Missed Tests: Students who are absent from a test with a valid reason should request a make-up test. THIS COURSE ADHERES TO ALL COLLEGE POLICIES (See College Calendar)

4

COMP 126

CENTENNIAL COLLEGE


Students should email their professor immediately upon absence (within 48 hours of absence) and arrange to submit professional documentation (as determined by College) to their professor stating reason of absence. Late Assignments: Students should submit assignments on or before the given due date. Assignments submitted after the due date will incur a late assignment penalty of 20% loss of marks per day late (including weekends and holidays). There will be no penalty for work missed for a justifiable reason with supporting, professional documentation (as determined by College) as evidence of reason. Students need to inform their professor of any situation that arises during the semester that may have an adverse effect on their academic performance, and request, well in advance, any necessary considerations according to the policies. Failure to do so will jeopardize any academic appeals.

College Policies Students should familiarize themselves with all College Policies that cover academic matters and student conduct. All students and employees have the right to study and work in an environment that is free from discrimination and harassment and promotes respect and equity. Centennial policies ensure all incidents of harassment, discrimination, bullying and violence will be addressed and responded to accordingly. Academic honesty is integral to the learning process and a necessary ingredient of academic integrity. Academic dishonesty includes cheating, plagiarism, and impersonation. All of these occur when the work of others is presented by a student as their own and/or without citing sources of information. Breaches of academic honesty may result in a failing grade on the assignment/course, suspension or expulsion from the college. For more information on these and other policies, please visit www.centennialcollege.ca/aboutcentennial/college-overview/college-policies. Students enrolled in a joint or collaborative program are subject to the partner institution's academic policies.

PLAR Process This course is eligible for Prior Learning Assessment and Recognition (PLAR). PLAR is a process by which course credit may be granted for past learning acquired through work or other life experiences. The PLAR process involves completing an assessment (portfolio, test, assignment, etc.) that reliably demonstrates achievement of the course learning outcomes. Contact the academic school to obtain information on the PLAR process and the required assessment. This course outline and its associated weekly topical(s) may not be reproduced, in whole or in part, without the prior permission of Centennial College.


5

COMP 126

CENTENNIAL COLLEGE


Topical Outline (subject to change): Week 1

Topics Course Overview; SAM/ebook registration; Reiew eCentennial; Review Getting Started with Excel

2

3

Readings/Materials Course Outline

Excel Tutorial 1 Creating a Customer Order Report

•Review Course Outline, learning objectives, policy, and grading scheme •Review Learning Management System (LMS) - eCentennial •Review SAM and Registration in COMP126 course

Instructional Strategies

Evaluation Name

Evaluation Date

Discussion, Instructorled Lesson, Demonstration, Video, Hands-on exercises

Session 1.1 •Open and close a workbook •Navigate through a workbook and worksheet •Select cells and ranges •Plan and create a workbook •Insert, rename, and move worksheets •Enter text, dates, and numbers •Undo and redo actions •Resize columns and rows

Getting Started with Excel

Excel Tutorial 1 (continued)

Formatting a Workbook Text and Data

Excel Tutorial 2 Designing a Sales Report

Formatting a Workbook Text and

Weekly Learning Outcome(s)

Excel Tutorial 2 Designing a Sales

Session 1.2 •Enter formulas and SUM and COUNT functions •Copy and paste formulas •Move or copy cells and ranges •Insert and delete rows, columns, and ranges •Create patterned text with Flash Fill •Add cell borders and change font size •Change worksheet views •Prepare a workbook for printing •Save a workbook with a new filename


Session 2.1 •Change fonts, font style, and font color •Add fill colors and a background image •Create formulas to calculate sales data •Apply Currency and Accounting formats and the Percent style •Format dates and times •Align, indent, and rotate cell contents •Merge a group of cells Session 2.2. Discussion, Instructor•Use the AVERAGE function led Lesson,


Excel Tutorial 2 Project (5%) 6

COMP 126

Week

CENTENNIAL COLLEGE

Topics Data (continued)

Readings/Materials Report (continued)

Calculating Data with Formulas and Excel Tutorial 3 Functions Creating a Fitness Tracker

4

Calculating Data with Formulas and Functions (continued)

Excel Tutorial 3 Creating a Fitness Tracker (continued)

Analyzing and Charting Financial Data

Excel Tutorial 4 Presenting Data for a Business Plan

Weekly Learning Outcome(s) •Apply cell styles •Copy and paste formats with the Format Painter •Find and replace text and formatting •Change workbook themes •Highlight cells with conditional formats •Format a worksheet for printing •Set the print area, insert page breaks, and print titles, create headers and footers, and set margins Session 3.1 •Make a workbook user-friendly •Translate an equation into an Excel formula •Understand function syntax •Enter formulas and functions with the Quick Analysis tool •Enter functions with the Insert Function dialog box •Interpret error values •Change cell references between relative and absolute Session 3.2 •Use the AutoFill tool to enter formulas and data and complete a series •Display the current date with the TODAY function •Find the next weekday with the WORKDAY function •Use the COUNT and COUNTA functions to tally cells •Use an IF function to return a value based on a condition •Perform an exact match lookup with a VLOOKUP function •Perform what-if analysis using trial and error and Goal Seek



Evaluation Name

Evaluation Date

Demonstration, Video, Hands-on exercises


Excel Tutorial 3 Project (5%)

Discuss and assign Excel 2013 Capstone Project

Session 4.1 •Use the PMT function to calculate a loan payment •Create an embedded pie chart •Apply styles to a chart THIS COURSE ADHERES TO ALL COLLEGE POLICIES (See College Calendar)

7

COMP 126

Week

CENTENNIAL COLLEGE

Topics

Readings/Materials




Evaluation Name

Evaluation Date

•Add data labels to a pie chart •Format a chart legend •Create a clustered column chart •Create a stacked column chart

5

Working with Excel Tables, PivotTables, and PivotCharts

Session 4.2 •Create a line chart •Create a combination chart •Format chart elements •Modify the chart’s data source •Add sparklines to a worksheet •Format cells with data bars •Insert a watermark Excel Tutorial 5 Session 5.1 Tracking Cash Receipts •Explore a structured range of data •Freeze rows and columns •Plan and create an Excel table •Rename and format an Excel table •Add, edit, and delete records in an Excel table •Sort data





Excel Assessment 1 – Tutorials 1-4 (10%)

Session 5.2 •Filter data using filter buttons •Filter an Excel table with a slicer •Insert a Total row to summarize an Excel table •Split a worksheet into two panes •Insert subtotals into a range of data •Use the Outline buttons to show or hide details 6

Working with Excel Tables, PivotTables, and PivotCharts (continued) Managing Multiple Worksheets and Workbooks

Excel Tutorial 5 Session 5.3 Tracking Cash Receipts •Create and modify a PivotTable (continued) •Apply PivotTable styles and formatting •Filter a PivotTable Excel Tutorial 6 •Insert a slicer to filter a PivotTable Summarizing Recycling •Insert a recommended PivtoTable Data •Create a PivotChart

Excel 2013 Capstone Project (Tutorials 1-4) (10%)

Session 6.1 •Create a worksheet group •Format and edit multiple worksheets at once THIS COURSE ADHERES TO ALL COLLEGE POLICIES (See College Calendar)

8

COMP 126

Week

CENTENNIAL COLLEGE

Topics

Readings/Materials




Evaluation Name

Evaluation Date

•Create cell references to other worksheets •Consolidate information from multiple worksheets using 3-D references •Create and print a worksheet group 7

8

9

10

Managing Multiple Worksheets and Workbooks (continued)

Working with Advanced Functions

Working with Advanced Functions (continued)

Creating a Database

Excel Tutorial 6 Summarizing Recycling Data (continued)

Excel Tutorial 8 Calculating Employee Compensation and Benefits

Excel Tutorial 8 Calculating Employee Compensation and Benefits (continued)

Access Tutorial 1 Tracking Patient, Visit, and Billing Data

Session 6.2 •Create a link to data in another workbook •Create a workbook reference •Learn how to edit links Session 6.3 •Insert a hyperlink in a cell •Create a workbook based on an existing template •Create a custom workbook template Session 8.1 •Use the IF function •Use the AND function •Use the OR function •Use the structured references in formulas Session 8.2 •Nest the IF function •Use the VLOOKUP function •USE the HLOOKUP function •Use the IFERROR function Session 8.3 •Use conditional formatting to highlight duplicate values •Summarize data using the COUNTIF, SUMIF, and AVERAGEIF functions

Session 1.1 •Learn basic database concepts and terms •Start and exit Access •Explore the Microsoft Access window and Backstage view •Create a blank database •Create and save a table in Datasheet view •Enter field names and records in a table








Access Tutorial 1 Project (5%)

Excel Assessment 2 – Tutorials 5, 6, 8 (15%)

9

COMP 126

Week

CENTENNIAL COLLEGE

Topics

Readings/Materials




Evaluation Name

Evaluation Date

datasheet •Open a table using the Navigation Pane

11

12

Building a Database and Defining Table Relationships

Session 1.2 •Open an Access database •Copy and paste records from another Access database •Navigate a table datasheet •Create and navigate a simple query •Create and navigate a simple form •Create, preview, navigate, and print a simple report •Use Help in Access •Learn how to compact, back up, and restore a database Access Tutorial 2 Session 2.1 Creating the Billing and •Learn the guidelines for designing databases Patient Tables and setting field properties •Create a table in Design view •Define fields, set field properties, and specify a table’s primary key •Modify the structure of a table •Change the order of fields in Design view •Add new fields in Design view •Change the Format property for a field in Datasheet view •Modify field properties in Design view

Maintaining and Access Tutorial 3 Querying a Database Updating and Retrieving Information


Session 2.2 •Import data from an Excel spreadsheet •Create a table by importing an existing table structure •Add fields to a table with the Data Type gallery •Delete and rename fields •Change the data type for a field in Design view •Set the Default Value property for a field •Add data to a table by importing a text file •Define a relationship between two tables Session 3.1 Discussion, Instructor•Find, modify, and delete records in a table led Lesson, •Hide and unhide fields in a datasheet Demonstration, Video,


Access Tutorial 2 Project (5%)

Access Tutorial 3 Project (5%) 10

COMP 126

Week

CENTENNIAL COLLEGE

Topics

Readings/Materials


About Patients, Visits, and Invoices

13

•Work in the Query window in Design view •Create, run, and save queries •Update data using a query datasheet •Create a query based on multiple tables •Sort data in a query •Filter data in a query Maintaining and Access Tutorial 3 Session 3.2 Querying a Database continued •Specify an exact match condition in a query •Use a comparison operator in a query to Integrating Microsoft Updating and match a range of values Office Retrieving Information •Use the AND and OR logical operators in About Patients, Visits, queries and Invoices •Change the font size and alternate row color in a datasheet Integrating Word, Excel, •Create and format a calculated field in a Access, and query PowerPoint •Perform calculations in a query using aggregate functions and record group Integration calculations Creating Documents for •Change the display of database objects in a Green Initiative Plan the Navigation Pane



Evaluation Name

Evaluation Date

Hands-on exercises Discuss and assign Integrating Microsoft Office 2013 Assignment Discussion, Instructorled Lesson, Demonstration, Video, Hands-on exercises

Integration: Session 3 •Create PowerPoint slides from a Word outline •Create an Access query •Copy Access query results to a PowerPoint slide •Embed an Excel table in PowerPoint slide 14

Integrating Microsoft Office

Integrating Word, Excel, Integration: Session 3 (continued) Access, and •Create PowerPoint slides from a Word PowerPoint outline •Create an Access query Creating Documents for •Copy Access query results to a PowerPoint a Green Initiative Plan slide •Embed an Excel table in PowerPoint slide



Access SAM Assessment (10%) Integrating Microsoft Office 2013 Assignment (10%)

11

Course Outline - Centennial College

Recommend Documents