Office 2013 Applications II is a semester-length, high school elective course that explores the use of application skills in the 2013 versions of Microsoft® Excel® and Microsoft® Access®. Students will use these applications to design, develop, create, edit, and share business spreadsheet and database documents. This course provides key knowledge and skills in the following areas:

1. Introduction to advanced skills in Microsoft® Excel® ranging from basic spreadsheet terminology to exploring data entry, formatting, formulas, functions, charts, graphics, and additional features available in backstage view
2. Skills in Microsoft® Access®, ranging from basic relational database terminology to creating and modifying tables, forms, queries, and reports

Office 2013 Applications II Course Requirements

Students must be computer literate and have Internet access. Students must also have access to the Microsoft Office 2013 suite, including Microsoft Excel and Microsoft Access. Students should have basic research skills, as well as the ability to conduct online searches and access recommended websites. Word processing and presentation software might be required to produce projects.

Office 2013 Applications II Course Outline

Unit 1: Microsoft® Excel® and Access®, Microsoft Excel Spreadsheets Basics

Chapter 1: Overview of Spreadsheet Basics

• What is a Spreadsheet and What Are Its Uses?
• Spreadsheet Design and the Microsoft Excel Screen

Chapter 2: Spreadsheet Basics

• Navigating in a Worksheet
• Microsoft Excel Workbook Views
• Microsoft Excel Window Views
  • Project: Managing the Worksheet Environment

Chapter 3: Managing File Settings

• 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
  • Project: Supplemental Lesson

Unit 2: Microsoft® Excel® and Access®, Creating Microsoft Excel Spreadsheets

Chapter 1: Date Entry

• 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

Chapter 2: Formatting Cells and Worksheets

• Cell Formats
• Editing Cells, Rows, and Columns
• Managing Worksheets
  • Project: Stock Market Project 2—Formatting a Spreadsheet

Chapter 3: Creating Formulas

• Order of Operations
• Microsoft Excel Formulas
• Types of Cell References in Formulas
  • Project: Stock Market Project 3—Entering Formulas

Chapter 4: Utilizing Functions and Data Commands

• Functions in Microsoft Excel
• Function Wizard and Linking Formulas
• Analyzing Data by Sorting and Filtering
  • Project: Stock Market Project 4—Entering Functions
  • 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

Unit 3: Microsoft® Excel® and Access®, Microsoft Excel Graphical Representations

Chapter 1: Creating Charts in Microsoft Excel

• Why Use Graphical Representations of Data?
• Creating Charts

Chapter 2: Enhancing Microsoft Excel Charts

• Formatting Charts
• Enhancing Charts with Illustrations
• Formatting Illustrations
  • Project: Stock Market Project Part 5—Creating and Enhancing Charts

Chapter 3: Advanced Charting Options

• Creating Picture Charts
• Sparklines
  • Project: Stock Market Project Part 6—Creating Advanced Charts
  • Project: Research and Chart Product Price Comparisons
  • Project: Chart Budget Expenses

Unit 4: Microsoft® Excel® and Access®, Microsoft Access Database Basics

Chapter 1: Database Design

• What is a Database and Its Uses?
• Database Design
• Field Names, Data Types, and Properties
  • Project: Designing a Customer Information Database

Chapter 2: Managing the Access Environment

• 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

Chapter 3: Creating an Access Database

• Creating an Access Database and Table
• Entering Data
• Modifying Data
• Importing Data from an Excel File
• Sorting and Filtering
• Creating Relationships
  • Project: Creating a Customer Information Database
  • Project: Designing an Address List Database
  • Project: Creating an Address List Database
  • Project: Designing and Creating an Inventory Database

Unit 5: Microsoft® Excel® and Access®, Microsoft Access Forms, Queries, and Reports

Chapter 1: Microsoft Access Forms

• Creating Forms
• Editing the Design of a Form
• Creating Multi-table Forms
• Editing Multi-table Forms
  • Project: Address List Forms

Chapter 2: Microsoft Access Queries

• 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

Chapter 3: Microsoft Access Reports

• Creating Reports
• Editing the Design of a Report
• Sorting and Filtering Records in a Report
• Creating Multi-table Reports
• Editing the Design of a Multi-table Report
  • Project: Address List 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