Course Name (short): Integrated Office Applications
School: Business
Program(s): Office Admin - Executive, Office Administration, Office Administration Legal, Office Administration Medical
Program Coordinator(s): Lisa Mendez
Course Leader or Contact: Kellie Hayward
Originator: Sarah Bell
Designate: Sarah Bell
Version: 8.0
Status: Approved (APPR)

Calendar Description
Students learn to produce complex business documents and electronic presentations by integrating specific business applications (word processing, spreadsheets, presentation, and database software).

Typical Instructional Format

Courses may be offered in other formats.

Section I Notes: This course was formerly coded as OADM17028.This course is offered in a hybrid version. The hybrid delivery is a combination of in-class instruction (2 hours) and online work (1 hour) per week. 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 postings, discussions, and homework. This is a web-based course offered online, using Sheridan's current LMS (Learning Management System). To take this course, students will need reliable access to the Internet and manage the virtual component to the course.

Detailed Description
Students create professional business documents by integrating specific business applications (word processing, spreadsheet, presentation, and database software). Students customize and enhance business presentations through introduction of tables, charts, graphics and animation in presentation software. Students produce and edit tables, table relationships and queries in a database application. Presentations are shared for collaboration and review with others. Through hands-on learning and guided practice, in-class discussions, and interactive lectures, students learn the skills required to produce professional and electronic documents, spreadsheets, and presentations.

Program Context

 
Critical Performance
By the end of this course, students will have demonstrated the 
ability to produce complex integrated business documents and 
electronic presentations.   

Learning Outcomes
To achieve the critical performance, students will have demonstrated 
the ability to: 
1.  Create professional presentations and slide show presentations
    with tables, charts, graphics, transitions and effects, enhanced
    formatting, images, and multimedia objects.
2.  Apply advanced formatting features such as colour schemes, design
    templates, images, animation, and visual elements.
3.  Prepare electronic presentations for review and distribution.
4.  Develop basic database tables, queries, forms and reports in a
    database application.
5.  Use integrated software for advanced document preparation.
6.  Publish presentations and business documents as web pages.

25% Practical Skills Test 1:  Creating an Advanced Presentation
25% Practical Skills Test 2:  Creating a Database and Integrating
    Applications 
50% Assignments to include:
	10% Online Tutorials
	10% In Class Assessments
        20% Individual Project assignments
	10% Collaborative Team Project Assignment (Integrated Apps)
___
100%

New Perspectives on Microsoft® Office 2010, First Course, 1st  
Edition, Volume 2 (Custom Edition) Ann Shaffer, Patrick Carey, June 
Jamrich Parsons, Dan Oja,Kathleen T. Finnegan bundled with SAM 
Personal Identification Number and SAM e/book

Resource(s):
	
Cengage Learning Student Textbook Companion Site Cengage Learning 
Skills Assessment Manager (SAM 2010) - http://sam2010.course.com/

MODULE 1:  ADVANCED PRESENTATION APPLICATIONS		WEEKS 1-4

WEEK 1:  INTRODUCTION TO COURSE AND FILE MANAGEMENT
Overview of course content and evaluation
Review of SAM 2010
Review of Cengage Learning Resource Site
Introduction of SLATE course content

Inserting Slides from Another Presentation (Tutorial 3.1)
Adding Video
Inserting a Sound Clip
Understanding Video and Audio Animation Effects
Creating a Table on a Slide
Creating a Chart
Adding a Second Animation to an Object
Changing the Speed of Animations
SAM TRAINING SESSION #1

WEEK 2:  ADDING AND CUSTOMIZING MEDIA AND CHARTS 

THEME COLORS AND BACKGROUNDS (Tutorial 3.2)
Changing Theme Fonts and Colors
Resetting Slides
Modifying the Slide Background
Modifying/Customizing Bullet Styles
Creating a Custom Theme
Applying a Different Theme to Individual Slides

SAM TRAINING SESSION #2

WEEK 3: INTEGRATING POWERPOINT AND COLLABORATING WITH OTHERS 
(Tutorial 4.1)
Import, Modify, and export a Word Outline
Import Graphics
Copy an object from another presentation
Remove the background from photographs
Embed and modify a table from Word
Link and modify an Excel chart
Create and edit hyperlinks
Add action buttons
Inserting Slides from Another Presentation
Adding Video
Inserting a Sound Clip
Understanding Video and Audio Animation Effects
Creating a Table on a Slide
Creating a Chart
Adding a Second Animation to an Object
Changing the Speed of Animations
SAM TRAINING SESSION #3

(Tutorial 4.2)
Apply a dynamic content transition
Customize handout masters
Mark slides during a slide show
Work with comments and compare presentations
Inspect documents for private or hidden data
Identify features not supported by previous versions of PowerPoint
Mark a presentation as final
Save a presentation in other formats
SAM TRAINING SESSION #4

SAM PPT Tutorials (Training) Weeks 1 - 3 (5%)
SAM PPT In Class Assignments (Exams) Weeks 1 - 3 (5%)
SAM PPT Projects (5%)

WEEK 4:
PRACTICAL SKILLS TEST #1:  ADVANCED PRESENTATION APPLICATION (25%)


MODULE 2:  DATABASE APPLICATIONS			WEEKS 5-10

WEEK 5:  INTRODUCTION TO ACCESS DATABASE (Tutorial 1.1)
Basic database concepts and terms
Create a blank database
Create and save a table in Datasheet view
Enter field names and records in a table datasheet
Open a table using the navigation Pane
SAM TRAINING SESSION #5

WEEK 6:  BUILDING A DATABASE AND DEFINING TABLE RELATIONSHIPS 
(Tutorial 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
Compact, backup and restore a database
SAM TRAINING SESSION #6

WEEK 7:  BUILDING A DATABASE (Tutorial 2.1)
Guidelines for designing databases and setting field properties
Modify the format of a field in Datasheet view
Create a table in Design view
Define fields and specify a table's primary key
Modify the structure of a table
SAM TRAINING SESSION #7

DEFINING TABLE RELATIONSHIPS (Tutorial 2.2)
Import data from an Excel worksheet 
Create a table by importing an existing table structure
Add fields to a table with the Data type gallery
Delete, rename, and move fields
Add data to a table by importing a text file
Define a relationship between two tables
SAM TRAINING SESSION #8

WEEK 8:  MAINTAINING AND QUERYING A DATABASE (Tutorial 3.1)
Find, modify, and delete records in a table
Use 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
SAM TRAINING SESSION #9

WEEK 9:  MAINTAINING AND QUERYING A DATABASE (Tutorial 3.2)
Specify an exact match condition in a query
Change the font size and alternate row color in a datasheet
Use a comparison operator in a query to match a range of values
Use the And and Or logical operators in queries
Create and format a calculated field in a query
Perform calculations in a query using aggregate functions/group 
calculations
Change the display of database objects in the Navigation Pane
SAM TRAINING SESSION #10

WEEK 10: FORMS (Tutorial 4.1)
Create a form using the Form Wizard
Apply a theme to a form
Add a picture to a form
Change the color and line type of items on a form
Find and maintain data using a form
Preview and print selected form records
SAM TRAINING SESSION #11

WEEK 11: REPORTS (Tutorial 4.2)
Create a form with a main form and a subform
Create a report using the Report Wizard
Apply a theme to a report
Resize fields in a report
Insert a picture in a report
Use conditional formatting in a report
Preview and print a report
SAM TRAINING SESSION #12

SAM ACCESS TUTORIALS (Training) Weeks 5 - 11 (5%)
SAM ACCESS IN CLASS ASSIGNMENTS (Exams) Weeks 5 - 11 (5%)
SAM ACCESS Projects (15%)

MODULE 3:  INTEGRATING APPLICATIONS			WEEKS 12-13

WEEK 12:  INTEGRATING WORD AND EXCEL
Object Linking and Embedding (OLE)
Embed an Excel chart in a Word document
Edit an embedded Excel chart in Word
Link an Excel worksheet to a Word document
Update a linked Excel worksheet
Test links

INTEGRATING WORD, EXCEL, AND ACCESS
Importing/Exporting Data
Import an Excel list into an Access database
Query an Access database
Export an Access query to a Word document

WEEK 13:  INTEGRATING WORD, EXCEL, ACCESS AND POWERPOINT
Create a Word outline
Create PowerPoint slides from a Word outline
Copy and paste Access query results into a PowerPoint presentation
Link an Excel chart to a PowerPoint presentation

WEEK 14:  FINAL TEST & COLLABORATIVE ASSIGNMENT DUE

ASSIGNMENT #3 DUE:
COLLABORATIVE PROJECT (INTEGRATED SOFTWARE APPLICATIONS) (10%)

PRACTICAL SKILLS TEST #2:  
CREATING A DATABASE AND INTEGRATING APPLICATIONS (25%)