Business Computer Applications

Unit 1: Skills for Productivity

• Introduction

• Digital Citizenship

• External Parts of a Computer

• Internal Parts of a Computer

• File Management

• Keyboarding Skill Building

Unit 2: Word Processing - Creating and Editing Documents

• Introduction

• Getting to Know Word

• Create and Save Documents

• Text Basics and Formatting Text

• Page Layout and Printing

Unit 3: Word Processing - Formatting and Customizing Documents

• Introduction

• Line and Paragraph Spacing

• Lists

• Hyperlinks

• Breaks and Columns

• Headers and Footers

Unit 4: Adding and Formatting Objects

• Introduction

• Pictures and Text Wrapping

• Shapes

• Text Boxes and WordArt

• Tables

• Charts

Unit 5: Spreadsheets - Creating and Editing Workbooks

• Introduction

• Getting to Know Excel

• Create and Save Workbooks

• Cell Basics

• Formatting Columns, Rows, and Cells

• Worksheet Basics

• Page Layout and Printing Workbooks

Unit 6: Spreadsheets - Formulas, Functions and Charts

• Introduction

• Simple and Complex Formulas

• Cell References

• Functions

• View Options

• Sorting Data

• Charts

Unit 7: Creating and Editing Slide Shows

• Introduction

• Getting to Know PowerPoint

• Create and Save a Presentation

• Slide and Text Basics

• Themes and Transitions

• Presenting and Printing a Presentation

Unit 8: Presentations - Preparing for Delivery

• Introduction

• Lists, Indents and Line Spacing

• Insert and Format Images

• Insert and Format Objects

• Animations

• PowerPoint Project - Delivery

Unit 1: Beyond the Basics of Word

• Introduction

• Word Basic Editing

• Advanced Formatting Features

• Using Tables

• Using Custom Styles and Building Blocks

• Using SmartArt

Unit 2: Production Tools in Word

• Introduction

• Formatting a Research Paper

• Research Paper Finishing Touches

• Performing Mail Merge

• Using Macros in Word

• Protecting Word Documents

Unit 3: Modifying the Appearance of a Worksheet

• Introduction

• Working and Saving Data in Excel

• Creating Named Ranges

• Formatting Cells and Ranges

• Adding Sparklines

• Adding Graphics

Unit 4: Working with Data, Macros, and Functions

• Introduction

• Data Validation, Sorting and Filtering Data

• Conditional Formatting, Outlining and Subtotaling Data

• Tables

• Advanced Functions

• Using Macros in Excel

Unit 5: Advanced Features of Power Point

• Introduction

• PowerPoint Essentials

• Illustrating Data with Tables and Information Graphics

• Slide Master

• Inserting Video and Audio

• Advanced Presentation Options

Unit 6: Introduction to Microsoft Access

• Introduction

• Introduction to Databases

• Getting Started with Access

• Working with Tables

• Modifying Tables

• Sorting and Filtering Records

Unit 7: Creating and Using Queries

• Introduction

• Designing Your Own Database

• Designing a Simple Query

• Designing a Multi-Table Query

• More Query Design Options

Unit 8: Creating Forms and Reports

• Introduction

• Working with Forms

• Creating and Formatting Forms

• Creating Reports

• Advanced Report Options