Course Overview

Ch 1: Online Essentials

Chapter 1 Introduces students to the history of computing and the basics of how computers work. It covers the Internet and social media, giving students the opportunity to work within a secure internet environment. Students will learn different methods of digital communication, including Outlook email, instant messaging, forums, text messaging, video chat, and social networking. This chapter also covers online safety and security, how to configure security settings, how to respond to social engineering tactics, and how to evaluate and use information found on the internet.

Ch 2: Computer Essentials

Chapter 2 presents computer hardware components and how to set up peripheral and internal parts of a computer. It also introduces operating systems, allowing students to interact with the Windows 10 user interface, including: display settings, screen savers, printing features and file management. Students will learn about application software and collaboration tools before being introduced to computer networking and setting up user accounts. This chapter will cover principles of databases with an introduction to SQL and Access. It introduces computer programming logic and language such as HTML, CSS, and JavaScript. The chapter concludes with an introduction to Information systems and potential careers.

Ch 3: Common Office Features

Chapter 3 explores common features across Microsoft Office products, such as the ribbon and the backstage view. It also covers how to customize the user's view and options. Students will learn to print files, as well as navigate and search documents within Microsoft Office. This chapter concludes with practicing how to insert and format objects such as shapes and images.

Ch 4: Microsoft Word

Chapter 4 provides extensive practice with features found in Microsoft Word, so that students can become proficient with word processing. This chapter covers creating documents, inserting and modifying text within a document, using the clipboard, and formatting pages and paragraphs. Students will learn how to edit documents, using editing tools like spell check and the thesaurus. They will learn to insert illustrations, objects, and tables; modify tables; and apply styles, templates and themes. Important skills covered in this course are: managing citations and references, inserting content as headers and footers, and using collaboration tools within Word. This chapter concludes with a short introduction to macros.

Ch 5: Microsoft Excel

Chapter 5 introduces several important features of Microsoft Excel. It covers creating spreadsheets, managing workbooks, entering data, formatting cells, organizing data, and validating data. Students will learn about protecting data and printing worksheets. They will also be introduced to creating formulas and advanced functions to analyze data and input that data into charts and tables. The chapter concludes by introducing tools that help with data analysis such as outlines and PivotTables.

Ch 6: Microsoft PowerPoint

Chapter 6 explores many important features of PowerPoint for creating presentations. It covers how to manage, design, and edit presentations. Students will learn how to format text and content placeholders, use themes and template designs, and use slide masters. As they build diverse presentations, they will learn to format objects like SmartArt, shapes, tables, and charts. This chapter covers how to format pictures and apply animations and transitions to make presentations more visually appealing. It concludes by covering tools and best practices when delivering a presentation.

Ch 7: Microsoft Access

Chapter 7 is an introductory course to databases in Microsoft Access. It starts by covering relational databases and managing an existing Access Database. It covers designing and creating tables, creating relationships, importing data, and creating simple queries. Students will learn how to create forms to control data entry and how to build reports to share. This chapter concludes by introducing advanced features such as managing records, cross tab queries, query parameters, and calculated fields.

Ch 8: Microsoft Outlook

Chapter 8 introduces students to email features within Microsoft Outlook. Beginning with how to send and receive messages, it covers tools that are meant to help manage messages, including file management, flagging, and automation. Students will work with their calendar and schedule meetings. This chapter concludes by introducing how to create and manage contacts and groups.

Ch 1: Online Essentials

The Information Age

  • Introduction to Desktop Computer Systems
  • A Brief History of Computing
  • The Binary Number System
  • Bits & Bytes
  • Digital Sound & Video
  • Digital Images
  • File Compression
  • Technology and Ethics

The Internet and Social Media

  • The Web and Other Internet Technologies
  • Using Web Browsers
  • Web Browser Troubleshooting
  • Website Navigation
  • Google Chrome Facts
  • Mozilla Firefox Facts
  • Microsoft Edge Facts
  • Social Media
  • Cloud Computing
  • Online Streaming

Digital Communication

  • Digital Communication
  • Smartphone Facts
  • Digital Privacy
  • Gmail and Google Calendar
  • Introduction to Outlook
  • Checking Your Email
  • Formatting and Sending Messages
  • Email Etiquette
  • Attachments and Hyperlinks
  • Rules of Netiquette

Online Safety and Security

  • Computer Security Risks
  • Windows Firewall
  • Malware Protection on Windows
  • Windows 10 Security Measures
  • Configuring Web Browsers
  • Internet Safety and Security
  • Ecommerce Safeguards
  • Encryption and Authentication

Evaluating Online Information

  • Online Searches
  • Copyright and Intellectual Property
  • Online Academic Research

Ch 2: Computer Essentials

Computer Hardware

  • Desktop and Mobile Devices
  • PC Hardware Components
  • Ports and Connectors
  • Peripheral Devices
  • Printers
  • Checking System Requirements

System Software

  • System Software
  • Operating System Functions
  • Common Operating Systems
  • The Windows 10 Operating System
  • Windows 10 Components
  • Windows Settings
  • Windows Printing Features
  • Windows Update

File Management

  • Storage Devices
  • File Storage Options
  • Windows File Management
  • Shared Storage
  • Cloud Storage

Application Software

  • Desktop Applications
  • Collaboration Tools
  • Installing Applications

Networking and User Accounts

  • Wired and Wireless Networks
  • Networking Facts
  • The Internet
  • Internet Protocols
  • Internet Service Types
  • Network Servers
  • Windows User Accounts

Databases

  • Introduction to Relational Databases
  • Database Terminology
  • Tour of Access
  • SQL
  • Database Terms
  • Big Data

Computer Programming

  • Basic Programming Concepts
  • Programming Languages
  • Object-Oriented Programming
  • Programming Logic
  • HTML, CSS, and JavaScript
  • Careers in Computer Programming
  • Computer Science Careers
  • Artificial Intelligence

Information Systems

  • Introduction to Information Systems
  • Systems Analysis & Design
  • The ICT Industry
  • Information Technology Careers

Ch 3: Common Office Features

Getting Started with Office

  • Introduction to Office Applications
  • Microsoft Office Versions
  • Learning Office Applications
  • The Ribbon
  • Beyond the Ribbon
  • Backstage View Options
  • Common Office Application Features
  • Desktop vs. Web Applications
  • Managing Comments
  • Restricting Document Access

Customizing Views and Options

  • Document Views
  • Customizing Toolbars and Ribbons

Printing Files

  • Printing Options in Office Applications

Navigating Files

  • Navigating Through a Word Document
  • Navigating Through an Excel Workbook

Working With Objects

  • Formatting Images
  • Formatting Shapes
  • Object Formatting

Ch 4: Microsoft Word

Creating Documents and Using the Clipboard

  • Text Selection
  • The Clipboard
  • Document File Formats
  • Word Printing Tips
  • Text Importing
  • Document Creation Tips

Modifying Fonts

  • Font Changes
  • Font Choices
  • Font Tips

Formatting Paragraphs

  • Paragraph and Line Spacing
  • Indentation and Tabs
  • Bulleted and Numbered Lists
  • Paragraph Borders and Shading
  • Paragraph Formatting Tips

Formatting Pages

  • Page Layout Options
  • Page and Column Breaks
  • Tab Stops
  • Page Formatting Tips

Editing Documents

  • AutoCorrect Options
  • Spell Checking
  • The Thesaurus
  • Document Editing Tips

Inserting Illustrations and Other Elements

  • Text Wrap Options
  • Illustration Formatting
  • Building Blocks and Other Elements
  • 3D Models
  • Word Illustration Tips

Creating and Formatting Tables

  • Word Tables
  • Table Formatting
  • Advanced Table Formatting
  • Word Table Tips

Using Themes, Styles, and Templates

  • Word Styles
  • Themes and Style Sets
  • Word Templates
  • Word Theme & Style Tips

Managing References

  • Citations and References
  • Footnotes, Endnotes, and Advanced Citations
  • Captions
  • Table of Contents
  • Reference Tips

Managing Headers, Footers, and Sections

  • Headers and Footers
  • Header and Footer Options
  • Next Page Section Breaks
  • Continuous Section Breaks
  • Word Header, Footer, & Section Tips

Using Office Collaboration Features

  • Track Changes and Comments
  • Distributing Files
  • Collaboration Tips

Using Macros

  • Macros

Ch 5: Microsoft Excel

Creating and Managing Workbooks

  • Spreadsheet Basics
  • Worksheet Management
  • Templates and Themes
  • External Data
  • Online Data
  • Workbook Management Tips

Organizing and Entering Data

  • Deleting and Clearing Cells
  • Copy and Paste Options
  • Large Data Sets
  • Data Entry Tips

Changing Properties and Printing Worksheets

  • Data Protection
  • Data Validation
  • Excel Printing Tips
  • Worksheet Printing Tips

Formatting Cells

  • Number Formats
  • Cell Formats
  • Cell Styles and Colors
  • Cell Borders
  • Cell Formatting Tips

Entering Simple Formulas

  • Formulas and Functions
  • AutoFill Options
  • Add and Average
  • Text Functions
  • Concatenating in Excel
  • Formula Tips
  • Number Functions

Using Advanced Functions

  • Relative and Absolute References
  • Advanced Cell References
  • Named Cells and Ranges
  • The IF Function
  • Logical Functions
  • Excel Error Messages
  • Spill Functions
  • Advanced Function Tips

Displaying Data Charts

  • Chart Formatting
  • Chart Types
  • Chart Tips

Organizing Data in Tables

  • Conditional Formatting
  • Excel Tables
  • Table Customization
  • Formulas in Tables
  • Excel Table Tips

Summarizing Complex Data

  • Creating Outlines
  • PivotTables
  • Advanced PivotTables
  • VLOOKUP
  • Complex Data Tips

Ch 6: Microsoft PowerPoint

Introduction To PowerPoint

  • Best Practices in Design

Creating and Managing Presentations

  • Slide Management
  • Presentation Sections
  • Presentation Management Tips

Formatting Textual Content

  • Text and Content Placeholders
  • Text Formatting
  • Managing Presentation Content
  • PowerPoint Text Formatting Tips

Designing Slides

  • Themes and Templates
  • Slide Backgrounds
  • Slide Design Tips

Using the Slide Master

  • Slide Masters
  • Slide Footers
  • Handout and Notes Masters
  • Slide Master Tips

Formatting SmartArt and Shapes

  • SmartArt
  • Object Formatting
  • Digital Ink
  • SmartArt and Shape Tips

Formatting Tables and Charts

  • PowerPoint Charts
  • PowerPoint Tables
  • Table and Chart Formatting Tips

Formatting Pictures and Other Media

  • Media Formatting
  • Advanced Media Formatting
  • Media Formatting Tips

Applying Animations and Transitions

  • Animation
  • Transitions
  • Slide Zoom
  • 3D Models
  • Motion Paths
  • Section and Summary Zoom
  • Animation and Transition Tips

Delivering Presentations

  • Presentation Tools
  • PowerPoint Print Options
  • Advanced Slideshow Options
  • Presentation Delivery Tips

Ch 7: Microsoft Access

Introduction to Access

  • Relational Databases
  • Access Tasks

Managing Databases

  • Tour of Access
  • Database Terminology
  • Database Management Tips

Designing and Creating Tables

  • Database Planning
  • Table Design
  • Default Values
  • Relationships and Lookups
  • Data Importing
  • Table Design Tips

Use Simple Queries

  • Introduction to Queries
  • Query Criteria
  • Queries with Totals
  • Query Tips

Creating Forms

  • Access Forms
  • Form Formatting
  • Form Tips

Creating Reports

  • The Report Wizard
  • Reports with Totals
  • Report Formatting
  • Report Tips

Surveying Advanced Access Features

  • Managing Databases
  • Formatting Tables and Managing Records
  • Application Parts
  • Crosstab Queries
  • Query Parameters
  • Action Queries
  • Calculated Fields and Conditional Logic
  • Advanced Form Options
  • Navigation Forms
  • Advanced Report Options
  • Advanced Query Facts

Ch 8: Microsoft Outlook

Introduction to Outlook

  • Checking Your Email
  • Outlook Tasks

Sending and Receiving Messages

  • Formatting and Sending Messages
  • Email Etiquette
  • Signatures
  • Attachments and Hyperlinks
  • Tracking Options
  • Message Tips

Managing Messages

  • Organizing Messages
  • Automating Outlook
  • Junk Mail and Clutter
  • Conversations
  • Searching in Outlook
  • Importing and Exporting
  • Message Management Tips

Working With Calendars

  • Creating and Managing Calendars
  • Calendar Items
  • Meetings
  • Tasks
  • Calendar Tips

Managing Contacts and Groups

  • Creating Contacts
  • Contact Groups
  • Using the Navigation Bar
  • Working With Multiple Accounts
  • Contact and Group Tips