Advanced Certificate in Computer Applications

Categories: Computer Science

About Course

Course Description

This course is aimed at beginning to intermediate computer users. It teaches a range of computer skills from the basics of using Windows, to basic internet literacy, to creating projects using Microsoft Office. Assignments show step-by-step visuals to help students complete projects, and include integration across Microsoft Word, Excel, PowerPoint, and Access.

Certification

A verifiable certificate in PDF format is available to download after fulfilling all the course requirements.

Who This Course is for

This course is aimed at students and anyone who wants to achieve a mastery of the use computer applications such as cloud computing, Microsoft Word, Microsoft Excel, Microsoft PowerPoint, etc.

This course equips you with the skills to do the following: Use basic functions of a computer
Use the internet to conduct research
Use cloud computing applications
Perform basic tasks in Microsoft Word
Perform intermediate tasks in Microsoft Word
Perform advanced tasks in Microsoft Word
Perform intermediate tasks in Microsoft Excel
Perform advanced tasks in Microsoft Excel
Perform basic tasks in Microsoft PowerPoint
Perform intermediate tasks in Microsoft PowerPoint
Perform advanced tasks in Microsoft PowerPoint
Perform basic tasks in Microsoft Access
Perform intermediate tasks in Microsoft Access
Perform advanced tasks in Microsoft Access

Course Content

Module 1: Introduction to Computers
Why learn how to use computers?

Why It Matters: Introduction to Computers
Introduction to Computer Concepts
Hardware
Software
Security
Privacy
Introduction to Operating Systems
Identifying Your Operating System (OS)
Introduction to Navigate Programs
Managing Windows
Keyboard Shortcuts
Introduction to Finding Programs and Files
Start Menu
Creating Files and Folders
Organizing Files and Folders
Deleting Files and Folders
Introduction to File Management
Local Files
Network Files
Online Files
Introduction to Snips and Screenshots
Snips and Screenshots
Putting It Together: Intro to Computers
Assignment: Download Files
Assignment: Identify Your OS
Assignment: Empty the Recycle Bin
Discussion: Computers vs. Smartphones

Module 2: Internet Research
Why learn how to run an internet search?

Why It Matters: Internet Research
Introduction to Using and Searching the Internet
Internet Browsers
Basic Browser Tools
Introduction to Ethical Business Research
Ethical Research
Data and Customer Rights
Introduction to Basic Searches
Web Searching
Identifying Search Results
Opening Search Results
Introduction to Advanced Searches
Adjusting Search Parameters
Image Searches
Putting It Together: Internet Research
Assignment: Search the Internet
Discussion: Search Results
Discussion: Personal Data and Ethical Business Use

Module 3: Cloud Computing
Cloud computing allows users to use computer applications, store files, and communicate and collaborate with others using the internet instead of a local server.

Why It Matters: Cloud Computing
Introduction to Email Tools
Sending and Receiving Emails and Attachments
Signatures and Automatic Replies
Organizing and Searching Email
Email Rules
Email Etiquette
Security Threats in Email
Introduction to Calendar Tools
Creating Appointments and Meetings
Scheduling Assistant and Room Finder
Shared Calendars
Introduction to Instant Messaging and Video Conferencing
Instant Messaging and Video Conference Applications
Choosing a Communication Tool
Introduction to Cloud Storage Tools
Using OneDrive
Using OneNote
Putting It Together: Cloud Computing
Assignment: Personalize Your Outlook.com Inbox
Discussion: Notifications

Module 4: Microsoft Word Basic Skills
Why learn to complete basic skills in Microsoft Word?

Why It Matters: Microsoft Word Basic Skills
Introduction to Using Word
Creating a New Blank Document and Finding Your Way Around
Saving Files
File Extensions
Introduction to Basic Text Formatting
Selecting and Moving Text
Bold, Italics, Underline
Fonts
Alignment, Justification, and Indentation
Line and Paragraph Spacing
Introduction to Workspace Tools
Spell Check and Dictionaries
Find and Replace
Introduction to Lists
Lists
Putting It Together: Microsoft Word Basic Skills
Assignment: Create Basic Document
Discussion: Paragraph Styles

Module 5: Microsoft Word Intermediate Skills
Why learn to complete intermediate skills in Microsoft Word?

Why It Matters: Microsoft Word Intermediate Skills
Introduction to Page Layout
Tab Stops
Columns
Headers and Footers
Introduction to Text Boxes
Text Boxes
Introduction to Tables
Creating Tables
Converting Text to a Table
Formatting Tables
Introduction to Images
Adding Images
Text Wrap
Introduction to Hyperlinks
Hyperlinks
Putting It Together: Microsoft Word Intermediate Skills
Assignment: Create Document with Tables and Images
Discussion: Cover Pages

Module 6: Microsoft Word Advanced Skills
Why learn to complete advanced skills in Microsoft Word?

Why It Matters: Microsoft Word Advanced Skills
Introduction to Advanced File Creation and Text Formatting
Creating a New Document from a Template
Text Effects
Introduction to Watermarks and Icons
Watermarks
Icons in Word
Introduction to Citations
Citations
Introduction to Mail Merge
Mail Merge
Introduction to Internet and Word
Internet and Word
Putting It Together: Microsoft Word Advanced Skills
Assignment: Edit a Newsletter
Discussion: Advanced Shortcuts

Module 7: Microsoft Excel Basic Skills
Why learn to complete basic skills in Microsoft Excel?

Why It Matters: Microsoft Excel Basic Skills
Introduction to Using Excel
Creating a New Workbook
Entering Data
Introduction to Basic Formatting and Layout
Table Styles
Cell Styles
Cell Format
Comma Styles
Rearranging Tables
Changing Width of Columns and Rows
Introduction to Using Multiple Worksheets
Creating a Workbook with Multiple Worksheets
Putting It Together: Microsoft Excel Basic Skills
Assignment: Organize Sales Data
Discussion: Merging and Centering Cells

Module 8: Microsoft Excel Intermediate Skills
Why learn to complete intermediate skills in Microsoft Excel?

Why It Matters: Microsoft Excel Intermediate Skills
Introduction to Using Excel for Data Analysis
Sorting Data
Filtering Data
Functions
Introduction to Automating Data Entry
Flash Fill
SUM Data
Simple Math
Introduction to Graphics
Graphics
Modify Graphics
Format Graphics
Introduction to Charts
Charts
Clustered Column Charts
Chart Types
Putting It Together: Microsoft Excel Intermediate Skills
Assignment: Analyze Yearly Trends
Discussion: Hard Return within a Cell

Module 9: Microsoft Excel Advanced Skills
Why learn to complete advanced skills in Microsoft Excel?

Why It Matters: Microsoft Excel Advanced Skills
Introduction to Sparklines
Sparklines
Introduction to More Formatting and Layout
Conditional Formatting
Viewing a Worksheet
Introduction to Pivot Tables
Pivot Tables
Introduction to Macros
Macros
Recording a Macro
Introduction to Statistical Functions and Formulas
What is a Function?
Lookup Functions and Formulas
Logical Functions and Formulas
Financial Functions and Formulas
Introduction to Add-Ins
Add-Ins
Introduction to Internet and Excel
Internet and Excel
Putting It Together: Microsoft Excel Advanced Skills
Assignment: Create Macro for Car Loan Spreadsheet
Discussion: Excel Worksheet as a Webpage

Module 10: Microsoft PowerPoint Basic Skills
Why learn to complete basic skills in Microsoft PowerPoint?

Why It Matters: Microsoft PowerPoint Basic Skills
Introduction to Creating Presentations
New Presentations
Themes
Introduction to Using PowerPoint
Editing a Presentation
Organizing Slides
Views
Introduction to Objects in PowerPoint
Text Boxes
Images and Clip Art
Images and Clip Art
SmartArt
Arranging Objects
Grouping Objects
Putting It Together: Microsoft PowerPoint Basic Skills
Assignment: Present Sales Information
Discussion: Infographics and Custom Shapes

Module 11: Microsoft PowerPoint Intermediate Skills
Why learn to complete intermediate skills in Microsoft PowerPoint?

Why It Matters: Microsoft PowerPoint Intermediate Skills
Introduction to Transition Effects
Transition Effects
Introduction to Headers and Footers
Headers and Footers
Introduction to Audio in PowerPoint
Adding Audio in PowerPoint
Introduction to Videos in PowerPoint
Inserting Videos in PowerPoint
Embedding Videos in PowerPoint
Uploading Videos in PowerPoint
Introduction to Lists
Creating Lists
Modifying Lists
Putting It Together: Microsoft PowerPoint Intermediate Skills
Assignment: Create a New Presentation
Discussion: Making a PowerPoint Presentation into a Video

Module 12: Microsoft PowerPoint Advanced Skills
Why learn to complete advanced skills in Microsoft PowerPoint?

Why It Matters: Microsoft PowerPoint Advanced Skills
Introduction to Colors
Color Themes
Custom Color Themes
Introduction to Tables in PowerPoint
Create Tables
Format Tables
Modify Tables
Introduction to Animations in PowerPoint
Animations in PowerPoint
Introduction to Charts in PowerPoint
Create Charts
Format Charts
Modify Charts
Introduction to Customized PowerPoint Template
Customized PowerPoint Templates
Introduction to Internet and PowerPoint
Internet and PowerPoint
Putting It Together: Microsoft PowerPoint Advanced Skills
Assignment: Modify Existing PowerPoint Presentations
Discussion: Ten Extra Tips for PowerPoint

Module 13: Microsoft Access Basic Skills
Why learn to perform basic tasks in Microsoft Access?

Why It Matters: Microsoft Access Basic Skills
Introduction to Creating Database Tables
Creating a Database
Naming Databases
Creating an Access Table
Introduction to Fields in Access
Field Properties
Field Names and Data Types
Introduction to Table Primary Key
Primary Key
Set a Primary Key
Introduction to Indexes
What is an Index?
To Index or Not to Index?
Putting It Together: Microsoft Access Basic Skills
Assignment: Create New Access Database
Discussion: Selecting Primary Key Tips

Module 14: Microsoft Access Intermediate Skills
Why learn intermediate Microsoft Access skills?

Why It Matters: Microsoft Access Intermediate Skills
Introduction to Table Relationships
Database Principles
Flat File vs Normalized Data
Types of Table Relationships
Introduction to Working with Tables
Datasheets
Entering Data
Changing Values
Introduction to Working with Datasheets
Adding Values and Records in Datasheets
Deleting Records in Datasheets
Introduction to Sorting and Filtering Data
Displaying Records in Datasheets
Sorting Data
Aggregating Data
Printing Records
Putting It Together: Microsoft Access Intermediate Skills
Assignment: Modify Access Database
Discussion: Moving Columns and Fields

Module 15: Microsoft Access Advanced Skills
Why learn advanced Microsoft Access skills?

Why It Matters: Microsoft Access Advanced Skills
Introduction to Importing and Exporting Data
External Data
Import and Export Options
Introduction to Queries
What Are Queries?
Adding Criteria to a Query
Saving Queries
Introduction to Forms and Reports
Understanding Forms
Creating Basic Forms
Form Controls and Views
Presenting Data on Reports
Introduction to Analyzing Data
Transforming Data
Understanding Calculations
Using Conditional Analysis
Using Subqueries
Understanding Domain Aggregation
Putting It Together: Microsoft Access Advanced Skills
Assignment: Create Queries for Access Database
Discussion: Ways to Manage Access Tables

Module 16: Integration
Business needs drive collaboration, information sharing and business analysis.

Why It Matters: Integration
Introduction to Using Word with Excel and PowerPoint
Customized Word Templates
Excel Table in Word Document
Excel Chart in Word Document
PowerPoint in Word Document
Introduction to Using PowerPoint with Excel
Excel Table in PowerPoint
Excel Chart in PowerPoint
Introduction to Integrating Access
Access and Mail Merge
Excel Table from Access Data
Access Data from Excel Table
Putting It Together: Integration
Assignment: Create Mail Merge Letters
Discussion: Audio Integration
Assignment: Create Capstone Presentation