top of page

Business Computer Applications

Programs Covered

  • Microsoft Word

  • Microsoft Excel

  • Microsoft Access

  • Microsoft PowerPoint

​

Course Description

As a student in this course, you will learn the most important topics of Microsoft Office 2016. No prior computer experience is assumed. You will first be presented with an overview of essential computer concepts and Windows 10. From there you’ll move into the applications. First up is Word, followed by Excel, then Access and PowerPoint. On the way you’ll have Modules integrating all four applications together. You’ll wrap up the course with Outlook 2016.

​

Assignment Descriptions

  • Concepts Review – Includes screen identification, multiple choice, and matching questions.

  • Skills Review – Provides additional hands-on exercises that mirror the progressive style of the lesson material.

  • Independent Challenges 1, 2 and 3 – Case projects that require critical thinking and application of the Module skills.  The Independent Challenges increase in difficulty, with the first being the easiest (with the most step-by-step detailed instructions).  Independent Challenges 2 and 3 become increasingly more open-ended.

  • Real Life Independent Challenge – Using a real world focus to apply the Module skills, students create documents that will benefit their every day lives.

  • Advanced Challenge Exercises – Optional steps that are set within 2 of the 4 Independent Challenges for each Module.  They are designed to challenge more advanced students.  2 solution files are provided for easy grading.

  • Visual Workshop – a practical, self-graded capstone project that requires independent problem solving.

Power Standards

4.1.50-Integrate functions of word processing, spreadsheets, databases, and presentation applications to various workplace scenarios.

7.5.2-Manage local and cloud-based files and folders.

7.7.9-Apply advanced features of applications for productivity.

7.2.6-Analyze and use mathematical and/or statistical methods to manipulate data into useful information. 

7.2.7-Present analyzed information in a meaningful format.

Module Objectives
Concepts 1

  • Describe data communications and understand system software and hardware.

Windows 10 1 & 2

  • Manage multiple windows and navigate the desktop and start menu.

  • Open, edit, save, move, and rename files.

Office 1

  • Start an Office app and identify Office 2016 screen elements.

Word 1-4

  • Format text and navigate a document.

  • Cut, copy, and paste text. Add hyperlinks and check spelling and grammar.

  • Change line and paragraph spacing. Insert tabs and indents. 

  • Manage sources and create a bibliography. Create sections, columns, headers, and footers.

Excel 1-4

  • Enter and edit a simple formula.

  • Understand relative and absolute cell references.

  • Format cells and apply conditional formatting.

  • Create and design charts.

Access 1-4

  • Create a database, table, and primary keys.

  • Create a query. Filter and apply AND and OR criteria.

  • Create forms and modify tab order.

  • Create reports and add subtotals and counts.

PowerPoint 1-4

  • Plan an effective presentation. Enter slide text and compare presentation views.

  • Rearrange and align objects, add slide footers.

  • Insert a chart, table, picture, and slides from other presentations.

  • Modify masters and customize presentations. 

Integration 1-3

Integrate data among Word, Excel, Access, and PowerPoint.

Outlook 1 & 2

  • Communicate with email. 

  • Manage tasks and contacts.

bottom of page