office applications ii academic library

​Office 2013 Applications 2 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 APPLICATIONS II ONLINE
UNIT 1 - MICROSOFT EXCEL SPREADSHEETS BASICS
UNIT 2 - CREATING MICROSOFT EXCEL SPREADSHEETS
  1. Course Overview
  2. What is a Spreadsheet and What Are Its Uses?
  3. Spreadsheet Design and the Microsoft Excel Screen
  4. Quiz 1: Overview of Spreadsheet Basics
  5. Alternate Quiz 1—Form A: Overview of Spreadsheet Basics
  6. Alternate Quiz 1—Form B: Overview of Spreadsheet Basics
  7. Navigating in a Worksheet
  8. Microsoft Excel Workbook Views
  9. Microsoft Excel Window Views
  10. Project: Managing the Worksheet Environment 
  11. Quiz 2: Spreadsheet Basics
  12. Alternate Quiz 2—Form A: Spreadsheet Basics
  13. Alternate Quiz 2—Form B: Spreadsheet Basics
  14. Workbook Properties
  15. Saving and File Formats
  16. Sharing Worksheet Data with Other Users
  17. Managing Comments
  18. Printing Worksheets and Workbooks
  19. Project: Saving and Printing Microsoft Excel Files
  20. Quiz 3: Managing File Settings
  21. Alternate Quiz 3—Form A: Managing File Settings
  22. Alternate Quiz 3—Form B: Managing File Settings
  23. Review
  24. Test
  25. Alternate Test—Form A
  26. Alternate Test—Form B
  27. Glossary and Credits
  1. Microsoft Excel Data Types
  2. Entering and Editing Cell Data
  3. Selecting, Filling, Moving, and Copying Cell Data
  4. AutoFill
  5. Project: Stock Market Project Part 1 – Researching and Recording Stock Prices – Complete this assignment Stock Market Project Part 1 – Researching and Recording Stock Prices.
  6. Quiz 1: Data Entry
  7. Alternate Quiz 1—Form A: Data Entry
  8. Alternate Quiz 1—Form B: Data Entry
  9. Cell Formats
  10. Editing Cells, Rows, and Columns
  11. Managing Worksheets
  12. Project: Stock Market Project 2 – Formatting a Spreadsheet 
  13. Quiz 2: Formatting Cells and Worksheets
  14. Alternate Quiz 2—Form A: Formatting Cells and Worksheets
  15. Alternate Quiz 2—Form B: Formatting Cells and Worksheets
  16. Order of Operations
  17. Microsoft Excel Formulas
  18. Types of Cell References in Formulas
  19. Project: Stock Market Project 3 – Entering Formulas 
  20. Quiz 3: Creating Formulas
  21. Alternate Quiz 3—Form A: Creating Formulas
  22. Alternate Quiz 3—Form B: Creating Formulas
  23. Functions in Microsoft Excel
  24. Function Wizard and Linking Formulas
  25. Analyzing Data by Sorting and Filtering
  26. Project: Stock Market Project 4 – Entering Functions 
  27. Quiz 4: Utilizing Functions and Data Commands
  28. Alternate Quiz 4—Form A: Utilizing Functions and Data Commands
  29. Alternate Quiz 4—Form B: Utilizing Functions and Data Commands
  30. Review
  31. Test
  32. Alternate Test—Form A
  33. Alternate Test—Form B
  34. Glossary and Credits
UNIT 3 - MICROSOFT EXCEL GRAPHICAL REPRESENTATIONS
UNIT 4 - MICROSOFT ACCESS DATABASE BASICS
  1. Why Use Graphical Representations of Data?
  2. Creating Charts
  3. Quiz 1: Creating Charts in Microsoft Excel
  4. Alternate Quiz 1—Form A: Data Entry
  5. Alternate Quiz 1—Form B: Data Entry
  6. Formatting Charts
  7. Enhancing Charts with Illustrations
  8. Formatting Illustrations
  9. Project: Stock Market Project Part 5 – Creating and Enhancing Charts
  10. Quiz 2: Enhancing Microsoft Excel Charts
  11. Alternate Quiz 2—Form A: Enhancing Microsoft Excel Charts
  12. Alternate Quiz 2—Form B: Enhancing Microsoft Excel Charts
  13. Creating Picture Charts
  14. Sparklines
  15. Project: Stock Market Project Part 6 – Creating Advanced Charts 
  16. Quiz 3: Advanced Charting Options
  17. Alternate Quiz 3—Form A: Advanced Charting Options
  18. Alternate Quiz 3—Form B: Advanced Charting Options
  19. Review
  20. Test
  21. Alternate Test—Form A
  22. Alternate Test—Form B
  23. Glossary and Credits
  1. What is a Database and Its Uses?
  2. Database Design
  3. Field Names, Data Types, and Properties
  4. Project: Designing a Customer Information Database 
  5. Quiz 1: Database Design
  6. Alternate Quiz 1—Form A: Database Design
  7. Alternate Quiz 1—Form B: Database Design
  8. The Access Screen
  9. Navigating in Table Datasheets, Forms, and Reports
  10. Working in the Navigation Pane
  11. Save Options and Compact and Repair
  12. Quiz 2: Managing the Access Environment
  13. Alternate Quiz 2—Form A: Managing the Access Environment
  14. Alternate Quiz 2—Form B: Managing the Access Environment
  15. Creating an Access Database and Table
  16. Entering Data
  17. Modifying a Table
  18. Importing Data from an Excel File
  19. Sorting and Filtering
  20. Creating Relationships
  21. Quiz 3: Creating an Access Database
  22. Alternate Quiz 3—Form A: Creating an Access Database
  23. Alternate Quiz 3—Form B: Creating an Access Database
  24. Project: Designing an Address List Database
  25. Project: Creating an Address List Database 
  26. Review
  27. Test
  28. Alternate Test—Form A
  29. Alternate Test—Form B
  30. Glossary and Credits
UNIT 5 - MICROSOFT ACCESS FORMS, QUERIES, AND REPORTS
UNIT 6 - COURSE REVIEW AND EXAM
  1. Creating Forms
  2. Editing the Design of a Form
  3. Creating Multi-table Forms
  4. Editing Multi-table Forms
  5. Project: Address List Forms 
  6. Quiz 1: Microsoft Access Forms
  7. Alternate Quiz 1—Form A: Microsoft Access Forms
  8. Alternate Quiz 1—Form B: Microsoft Access Forms
  9. Creating Simple Queries
  10. Creating Advanced Queries
  11. Creating Multi-table Queries
  12. Calculating Totals in a Query
  13. Creating Calculated Fields in a Query
  14. Project: Address List Queries 
  15. Quiz 2: Microsoft Access Queries
  16. Alternate Quiz 2—Form A: Microsoft Access Queries
  17. Alternate Quiz 2—Form B: Microsoft Access Queries
  18. Creating Reports
  19. Editing the Design of a Report
  20. Sorting and Filtering Records in a Report
  21. Creating Multi-table Reports
  22. Editing the Design of a Multi-Table Report
  23. Project: Address List Reports
  24. Quiz 3: Microsoft Access Reports
  25. Alternate Quiz 3—Form A: Microsoft Access Reports
  26. Alternate Quiz 3—Form B: Microsoft Access Reports
  27. Review
  28. Test
  29. Alternate Test—Form A
  30. Alternate Test—Form B
  31. Glossary and Credits
  1. Review
  2. Test
  3. Alternate Test—Form A
  4. Alternate Test—Form B