NFC Academy
  • Home
  • About Us
    • Who We Are
    • Why Us >
      • Biblical Worldview
      • Full Accreditation
      • Anytime & Anywhere Learning
      • Convenience & Flexibility
      • Superior Academics
      • Try Online Lessons Now
      • Full Time Students
      • Transfer Students
      • International Students
    • NFC Academy Administration & Staff
    • NFC ACADEMY FACULTY
    • Parent Resources
    • Blog
  • Admissions
    • Enrollment Process
    • Apply Now
    • Tuition Information
    • Tuition Discounts
    • FAQ
    • NFCA Auto-Pay
    • Academy Tuition Rewards
    • Tuition Policies
  • K - 5th Book
    • Pre-K4 Homeschool
    • Homeschool Kindergarten
    • Book Program Grades 1-5
    • K-5 Book Program Courses
    • Accelerated Math Program
    • Kindergarten Teacher Resources
    • 1st-5th Book Program Teacher Resources
    • Gradebook Book Program 1-5
  • 3rd-5th Online
    • Homeschool 3rd-5th Online Program
    • Elementary 3-5 Online Courses
    • Accelerated Math Program
    • Elementary Writing Center
    • Student Resources 3-5 Online
    • Home Teacher Training
  • 6th-8th Online
    • Homeschool 6th-8th Online Program
    • Middle School 6-8 Online Courses
    • Accelerated Math Program
    • Middle School Writing Center
    • Student Resources 6-8 Online
    • Home Teacher Training
  • High School Online
    • High School Homeschool Online Program
    • High School Online Courses
    • NFC Academy Graduation Services
    • College Ready
    • Transcript Request
    • National Honor Society
    • Library and Writing Center
    • Student Resources
  • Contact Us
  • Home
  • About Us
    • Who We Are
    • Why Us >
      • Biblical Worldview
      • Full Accreditation
      • Anytime & Anywhere Learning
      • Convenience & Flexibility
      • Superior Academics
      • Try Online Lessons Now
      • Full Time Students
      • Transfer Students
      • International Students
    • NFC Academy Administration & Staff
    • NFC ACADEMY FACULTY
    • Parent Resources
    • Blog
  • Admissions
    • Enrollment Process
    • Apply Now
    • Tuition Information
    • Tuition Discounts
    • FAQ
    • NFCA Auto-Pay
    • Academy Tuition Rewards
    • Tuition Policies
  • K - 5th Book
    • Pre-K4 Homeschool
    • Homeschool Kindergarten
    • Book Program Grades 1-5
    • K-5 Book Program Courses
    • Accelerated Math Program
    • Kindergarten Teacher Resources
    • 1st-5th Book Program Teacher Resources
    • Gradebook Book Program 1-5
  • 3rd-5th Online
    • Homeschool 3rd-5th Online Program
    • Elementary 3-5 Online Courses
    • Accelerated Math Program
    • Elementary Writing Center
    • Student Resources 3-5 Online
    • Home Teacher Training
  • 6th-8th Online
    • Homeschool 6th-8th Online Program
    • Middle School 6-8 Online Courses
    • Accelerated Math Program
    • Middle School Writing Center
    • Student Resources 6-8 Online
    • Home Teacher Training
  • High School Online
    • High School Homeschool Online Program
    • High School Online Courses
    • NFC Academy Graduation Services
    • College Ready
    • Transcript Request
    • National Honor Society
    • Library and Writing Center
    • Student Resources
  • Contact Us

office applications ii

one semester high school elective course - .5 credit

office applications ii academic library

Picture
​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
                                         NFC ACADEMY
OUR MISSION 
Using innovative technology together with successful educational practices and a biblical worldview curriculum in a distance educational environment to equip students for their future while serving and glorifying God. 
ADMISSIONS
Admissions
Tuition
Auto-Pay
FAQ
Apply Now
Academy Tuition Rewards
​Tuition Policies
PROGRAMS
Kindergarten
Book Program 1-5
Online Grades 3-5
Online Grades 6-8
High School Grades 9-12
NFC Academy Global
SUPPORT
About Us
Contact

Biblical Worldview
Meet  Our Faculty & Staff
Parent Resources
© Copyright 2022.  NFC Academy.     3000 N  Meridian Road .   Tallahassee, FL 32312.    Phone: 888.407.6327.   FAX: 850.386.7163 
Online Christian Homeschool – NFC Academy