Advanced Certificate in Computer Applications

  • Home
  • Advanced Certificate in Computer Applications
( 1 Rating )
Shape Image One

Advanced Certificate in Computer Applications

Categories: Computer Science
Wishlist Share
Share Course
Page Link
Share On Social Media

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.

Show More

What Will You Learn?

  • 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

About the instructor

Lumen
Lumen Learning courseware is based on open educational resources (OER). When we can find well designed, effective OER that are appropriately licensed, we use them in our courseware. When we can’t find pre-existing OER, we create original content and license it as OER (under a Creative Commons Attribution license).

Course Curriculum

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
Free
Free access this course

Requirements

  • Little or no prior computer experience is required.

Audience

  • Business Managers
  • Anyone who wants to learn to use computer applications

Want to receive push notifications for all major on-site activities?