Ad Destinatum Persequor

MICROSOFT OFFICE PROFESSIONAL

Our students demanded it and we have responded. All the training you need to be proficient in all Microsoft Office 2013 Applications is here under this one package. Office Applications I explores the use of application skills in Microsoft® Word®, Publisher®, and PowerPoint®. Students will use these applications for designing, developing, creating, editing and sharing business publications, presentations and documents. This course offers key skills and knowledge in the following Microsoft Office® applications:

  • Microsoft Word: Students are provided an introduction to advanced skills in Microsoft Word ranging from the simple development of an understanding of the variety of uses of Word, to more complex explorations of tab stops, mail merge, reference resources and additional features available in the backstage view.
  • Microsoft Publisher: Students learn how to create publications, edit and insert publication items, and view, review and share such publications.
  • Microsoft PowerPoint: Students learn to create presentations, modify and enter content, deliver and modify presentations, as well as share and collaborate on PowerPoint presentations.

Office Applications II explores the use of application skills in Microsoft® Excel® and Microsoft® Access®. Students will utilize these applications to design, create, develop, share and edit business spreadsheet and database documents. This course offers key skills and knowledge in the following areas:

  • Introduction to advanced skills in Microsoft® Excel® which ranges from basic spreadsheet terminology to the exploration of data entry, formulas, formatting, functions, graphics, charts and additional features that are available in backstage view.
  • Skills in Microsoft® Access®, that range from basic relational database terminology, to the creation and modification of forms, tables, queries and reports.

Objectives:
  • Create, save, format and modify styles, font, text, folders and pages in Microsoft Word.
  • Demonstrate how to use Cut, Copy and Paste commands along with the Show/Hide button during the editing of documents.
  • Demonstrate how to use AutoCorrect, Spell Check and Find and Replace in your Word application.
  • Learn to track changes and add comments in your document.
  • Show how to insert, modify, edit and format elements of a Word document.
  • Demonstrate your knowledge of advanced skills in Microsoft Word.
  • Grasp the basics of Word references.
  • Modify document properties such as templates.
  • Learn how to edit, modify, review and navigate elements of the Microsoft Publisher application.
  • Remember how to electronically share and print a publication.
  • Show how to create, modify, insert, open, save and present elements of a PowerPoint Presentation.
  • Recognize the elements of an Excel spreadsheet.
  • Demonstrate use of Excel navigation and protection tools.
  • Know how to modify, edit, save, create, and format Excel spreadsheets.
  • Use tools to manage Excel worksheets.
  • Define the rules for creating formulas and functions in Excel worksheets.
  • Demonstrate how to create, modify, and edit charts and shapes in Microsoft Excel.
  • Demonstrate knowledge of database design.
  • Manage the Access Environment.
  • Create an Access database.
  • Create, modify, and edit Access forms, queries, and reports.

Students need to be computer literate and enjoy internet access. Students require basic research skills and the ability to conduct searches online and access websites that are recommended. Students require Word processing and presentation software to produce projects.

Course Syllabus

(click on the module heading to reveal a lesson by lesson breakdown)

BUSINESS TECHNOLOGY

  • Course Overview
  • Microsoft Word and the Documents it can Create
  • Navigating the Word Screen Formatting
  • Open, Enter Text, Save and Print
  • Quiz 1: Word Introduction
  • Alternate Quiz 1: Form A: Word Introduction
  • Alternate Quiz 1: Form B: Word Introduction
  • Font: Basic Editing Features and Pages
  • Font Styles and the Clipboard
  • Project: Microsoft Word Document Formatting
  • Quiz 2: Formatting Font
  • Alternate Quiz 2: Form A: Formatting Font
  • Alternate Quiz 2: Form B: Formatting Font
  • Paragraph Formatting Features
  • Page Setup Features
  • Backgrounds and Themes
  • Project: Microsoft Word Page and Paragraph
  • Quiz 3: Formatting Paragraphs and Pages
  • Alternate Quiz 3: Form A: Formatting Paragraphs and Pages
  • Alternate Quiz 3: Form B: Formatting Paragraphs and Pages
  • Supplemental Lesson
  • Special Project
  • Review
  • Test
  • Alternate Test: Form A
  • Alternate Test: Form B
  • Glossary and Credits

MICROSOFT WORD INTERMEDIATE SKILLS

  • Inserting Images into Documents
  • Inserting Shapes, SmartArt and Text Boxes
  • Special Parts in the Word Application
  • Project: Inserting and Modifying Content
  • Quiz 1: Word Intermediate Skills
  • Alternate Quiz 1: Form A: Word Intermediate Skills
  • Alternate Quiz 1: Form B: Word Intermediate Skills
  • Inserting Tables
  • Organizing Content in Tables
  • Project: Tables
  • Quiz 2: Working with Tables
  • Alternate Quiz 2: Form A: Working with Tables
  • Alternate Quiz 2: Form B: Working with Tables
  • Spell Check and Find and Replace
  • Insert Comments and Track Changes
  • Autocorrect Options
  • Project: Review Tab Skills
  • Quiz 3: Autocorrect Options
  • Alternate Quiz 3: Form A: Autocorrect Options
  • Alternate Quiz 3: Form B: Autocorrect Options
  • Project: Collaborating on a Word Document
  • Project: Supplemental Projects
  • Special Project
  • Review
  • Test
  • Alternate Test: Form A
  • Alternate Test: Form B
  • Glossary and Credits

MICROSOFT WORD ADVANCED SKILLS

  • Merging to Create Labels
  • Merging to Create Letters
  • Project: Creating a Merge
  • Quiz 1: Word Advanced Skills
  • Alternate Quiz 1: Form A: Word Advanced Skills
  • Alternate Quiz 1: Form B: Word Advanced Skills
  • Endnotes and Footnotes
  • Hyperlinks
  • Table of Contents
  • Project: Inserting Special Report Features
  • Quiz 2: References
  • Alternate Quiz 2: Form A: References
  • Alternate Quiz 2: Form B: References
  • Share, Protect, and Modify Document Properties
  • Using and Creating a Template
  • Project: Creating a document template
  • Quiz 3: Backstage View
  • Alternate Quiz 3: Form A: Backstage View
  • Alternate Quiz 3: Form B: Backstage View
  • Project: Unit Simulation
  • Project: Supplemental Materials
  • Special Project
  • Review
  • Test
  • Alternate Test—Form A
  • Alternate Test—Form B
  • Glossary and Credits

MICROSOFT PUBLISHER APPLICATION

  • Opening and Navigating Publisher
  • Designing Pages
  • Inserting Text
  • Project: Open Publisher, Browse, and Select a Template
  • Quiz 1: Publisher
  • Alternate Quiz 1: Form A: Publisher
  • Alternate Quiz 1: Form B: Publisher
  • Graphics
  • Tables and Building Blocks
  • Project: Inserting Enhancements
  • Viewing a Publications
  • Reviewing a Publication
  • Sharing and Printing Publications
  • Project: Modify and Share a Publication
  • Quiz 2: Publications
  • Alternate Quiz 2: Form A: Publications
  • Alternate Quiz 2: Form B: Publications
  • Project: Design, Edit and Share a Publication
  • Project: Supplemental Activities
  • Special Project
  • Review
  • Test
  • Alternate Test—Form A
  • Alternate Test—Form B
  • Glossary and Credits

MICROSOFT POWERPOINT APPLICATION

  • PowerPoint Layout and Modifying Views
  • Entering Text and Formatting Slides
  • Quiz 1: PowerPoint Layout and Views
  • Alternate Quiz 1: Form A: PowerPoint Layout and Views
  • Alternate Quiz 1: Form B: PowerPoint Layout and Views
  • Images, WordArt, and SmartArt
  • Charts and Tables
  • Project: Simulation: Creating a Presentation
  • Quiz 2: Charts and Tables
  • Alternate Quiz 2: Form A: Charts and Tables
  • Alternate Quiz 2: Form B: Charts and Tables
  • Transitions and Animations
  • Set up Show and Timings
  • Presentation Tools
  • Saving, Printing, Sharing, and Protecting a Presentation
  • Project: Simulation: Modify, Share, and Deliver a Show
  • Quiz 3: Modify, Share, Deliver a Show
  • Alternate Quiz 3: Form A: Modify, Share, Deliver a Show
  • Alternate Quiz 3: Form B: Modify, Share, Deliver a Show
  • Project: Simulation: Design and Create a Presentation
  • Project: Supplemental Activities
  • Special Project
  • Review
  • Test
  • Alternate Test—Form A
  • Alternate Test—Form B
  • Glossary and Credits

COURSE REVIEW, AND EXAM

  • Course Review
  • Final Exam
  • Alternate Exam—Form A
  • Alternate Exam—Form B

MICROSOFT EXCEL SPREADSHEETS BASICS

  • Course Overview
  • What is a Spreadsheet and What Are Its Uses?
  • Spreadsheet Design and the Microsoft Excel Screen
  • Quiz 1: Overview of Spreadsheet Basics
  • Alternate Quiz 1: Form A: Overview of Spreadsheet Basics
  • Alternate Quiz 1: Form B: Overview of Spreadsheet Basics
  • Navigating in a Worksheet
  • Microsoft Excel Workbook Views
  • Microsoft Excel Window Views
  • Project: Managing the Worksheet Environment
  • Quiz 2: Spreadsheet Basics
  • Alternate Quiz 2: Form A: Spreadsheet Basics
  • Alternate Quiz 2: Form B: Spreadsheet Basics
  • Workbook Properties
  • Saving and File Formats
  • Sharing Worksheet Data with Other Users
  • Managing Comments
  • Printing Worksheets and Workbooks
  • Project: Saving and Printing Microsoft Excel Files
  • Quiz 3: Managing File Settings
  • Alternate Quiz 3: Form A: Managing File Settings
  • Alternate Quiz 3: Form B: Managing File Settings
  • Supplemental Lesson 1: Financial Terms
  • Supplemental Lesson 2: Financial Statements
  • Special Project
  • Review
  • Test
  • Alternate Test—Form A
  • Alternate Test—Form B
  • Glossary and Credits

CREATING MICROSOFT EXCEL SPREADSHEETS

  • Microsoft Excel Data Types
  • Entering and Editing Cell Data
  • Selecting, Filling, Moving, and Copying Cell Data
  • AutoFill
  • Project: Stock Market Project Part 1 - Researching and Recording Stock Prices
  • Quiz 1: Data Entry
  • Alternate Quiz 1: Form A: Data Entry
  • Alternate Quiz 1: Form B: Data Entry
  • Cell Formats
  • Editing Cells, Rows, and Columns
  • Managing Worksheets
  • Project: Stock Market Project 2 - Formatting a Spreadsheet
  • Quiz 2: Formatting Cells and Worksheets< /li>
  • Alternate Quiz 2: Form A: Formatting Cells and Worksheets
  • Alternate Quiz 2: Form B: Formatting Cells and Worksheets
  • Order of Operations
  • Microsoft Excel Formulas
  • Types of Cell References in Formulas
  • Project: Stock Market Project 3 - Entering Formulas
  • Quiz 3: Creating Formulas
  • Alternate Quiz 3: Form A: Creating Formulas
  • Alternate Quiz 3: Form B: Creating Formulas
  • Functions in Microsoft Excel
  • Function Wizard and Linking Formulas
  • Analyzing Data by Sorting and Filtering
  • Project: Stock Market Project 4 - Entering Functions
  • Quiz 4: Utilizing Functions and Data Commands
  • Alternate Quiz 4: Form A: Utilizing Functions and Data Commands
  • Alternate Quiz 4: Form B: Utilizing Functions and Data Commands
  • Project: Budget Project - Career Search
  • Project: Budget Project - Housing Research
  • Project: Budget Project - Vehicle Research
  • Project: Budget Project - Utilities, Vacation, and Miscellaneous Expense Research
  • Project: Budget Project - Final
  • Special Project
  • Review
  • Test
  • Alternate Test—Form A
  • Alternate Test—Form B
  • Glossary and Credits

MICROSOFT EXCEL GRAPHICAL REPRESENTATIONS

  • Why Use Graphical Representations of Data?
    • \
  • Creating Charts
  • Quiz 1: Creating Charts in Microsoft Excel
  • Alternate Quiz 1: Form A: Data Entry
  • Alternate Quiz 1: Form B: Data Entry
  • Formatting Charts
  • Enhancing Charts with Illustrations
  • Formatting Illustrations
  • Project: Stock Market Project Part 5 - Creating and Enhancing Charts
  • Quiz 2: Enhancing Microsoft Excel Charts
  • Alternate Quiz 2: Form A: Enhancing Microsoft Excel Charts
  • Alternate Quiz 2: Form B: Enhancing Microsoft Excel Charts
  • Creating Picture Charts
  • Sparklines
  • Project: Stock Market Project Part 6 – Creating Advanced Charts
  • Quiz 3: Advanced Charting Options
  • Alternate Quiz 3: Form A: Advanced Charting Options
  • Alternate Quiz 3: Form B: Advanced Charting Options
  • Project: Research and Chart Product Price Comparisons
  • Project: Chart Budget Expenses
  • Special Project
  • Review
  • Test
  • Alternate Test—Form A
  • Alternate Test—Form B
  • Glossary and Credits

MICROSOFT PUBLISHER APPLICATION

  • What is a Database and Its Uses?
  • Database Design
  • Field Names, Data Types, and Properties
  • Project: Designing a Customer Information Database
  • Quiz 1: Database Design
  • Alternate Quiz 1: Form A: Database Design
  • Alternate Quiz 1: Form B: Database Design
  • The Access Screen
  • Navigating in Table Datasheets, Forms, and Reports
  • Working in the Navigation Pane
  • Save Options and Compact and Repair
  • Project: Managing the Access Environment
  • Quiz 2: Managing the Access Environment
  • Alternate Quiz 2: Form A: Managing the Access Environment
  • Alternate Quiz 2: Form B: Managing the Access Environment
  • Creating an Access Database and Table
  • Sorting and Filtering
  • Creating Relationships
  • Project: Creating Customer Information Database
  • Quiz 3: Creating an Access Database
  • Alternate Quiz 3: Form A: Creating an Access Database
  • Alternate Quiz 3: Form B: Creating an Access Database
  • Project: Designing an Address List Database
  • Project: Designing and Creating an Inventory Database
  • Special Project
  • Review
  • Test
  • Alternate Test—Form A
  • Alternate Test—Form B
  • Glossary and Credits

MICROSOFT ACCESS FORMS, QUERIES, AND REPORTS

  • Creating Forms
  • Editing the Design of a Form
  • Creating Multi-table Forms
  • Editing Multi-table Forms
  • Project: Address List Forms
  • Quiz 1: Microsoft Access Forms
  • Alternate Quiz 1: Form A: Microsoft Access Forms
  • Alternate Quiz 1: Form B: Microsoft Access Forms
  • Creating Simple Queries
  • Creating Advanced Queries
  • Creating Multi-table Queries
  • Calculating Totals in a Query
  • Creating Calculated Fields in a Query
  • Project: Address List Queries
  • Quiz 2: Microsoft Access Queries
  • Alternate Quiz 2: Form A: Microsoft Access Queries
  • Alternate Quiz 2: Form B: Microsoft Access Queries
  • Creating Reports
  • Editing the Design of a Repor
  • Sorting and Filtering Records in a Report
  • Creating Multi-table Reports
  • Editing the Design of a Multi-Table Report
  • Project: Address List Reports
  • Quiz 3: Microsoft Access Reports
  • Alternate Quiz 3: Form A: Microsoft Access Reports
  • Alternate Quiz 3: Form B: Microsoft Access Reports
  • Project: Creating Forms for the Address List Database
  • Project: Creating Queries for the Address List Database
  • Project: Creating Reports for the Address List Database
  • Special Project
  • Review
  • Test
  • Alternate Test—Form A
  • Alternate Test—Form B
  • Glossary and Credits

SEMESTER REVIEW AND EXAM

  • Review
  • Test
  • Alternate Final Exam: Form A
  • Alternate Final Exam: Form B
bundle