DIY

APPLIED EDUCATIONAL SYSTEMS – COMPUTER APPLICATION MODULES

SIGN UP:

Period 3 – INTRO TO COMPUTER APPLICATIONS:

1. Students go to https://learn.aeseducation.com.
2. Enter the enrollment code (E8WZ8) and follow the instructions on the screen.

Period 7 – COMPUTER APPLICATIONS:

1. Students go to https://learn.aeseducation.com.
2. Enter the enrollment code (SMT9P) and follow the instructions on the screen.

THE BELOW HAS BEEN Provided by GCF Learn Free

Computer Basics

Introduction

• 1: Getting to Know Computers
• 2: Understanding Operating Systems
• 3: Understanding Applications
• 4: Web Apps and the Cloud

All About the Desktop Computer

• 5: Basic Parts of a Desktop Computer
• 6: Buttons, Sockets and Slots on a Desktop Computer
• 7: Inside a Desktop Computer

Laptop Computers and Mobile Devices

• 8: Laptop Computers and Netbooks
• 9: Getting to Know Mobile Devices

Getting Started

• 10: Setting Up a Computer
• 11: Beginning to Use Your Computer
• 12: Getting to Know the OS
• 13: Connecting to the Internet

Doing More with Computers

• 14: Computer Safety and Maintenance
• 15: Basic Troubleshooting Techniques

TAKE THE QUIZ

Google

Google Drive and Docs

• 1: All About Google Drive and Docs
• 2: Getting Started with Google Drive
• 3: Uploading and Syncing Files
• 4: Creating Google Docs
• 5: Managing your Files
• 6: Sharing and Collaborating
• 7: Converting and Printing Docs

Common Tasks in Documents

• 8: Getting Started with Your Document
• 9: Formatting Text and Adding Hyperlinks
• 10: Using Indents, Tabs, and Lists
• 11: Headers, Footers, and Page Breaks

Doing More with Documents

• 12: Working with Tables
• 13: Inserting Images
• 14: Inserting Text Boxes and Shapes

TAKE THE QUIZ

Word 2010

Word Basics

• 1: Getting Started with Word
• 2: Text Basics
• 3: Formatting Text
• 4: Saving
• 5: Modifying Page Layout
• 6: Checking Spelling and Grammar
• 7: Printing

Common Tasks in Word

• 8: Using Indents and Tabs
• 9: Line and Paragraph Spacing
• 10: Working with Lists
• 11: Adding Breaks
• 12: Working with Columns
• 13: Working with Hyperlinks
• 14: Working with Shapes
• 15: Text Boxes and WordArt
• 16: Inserting Clip Art and Pictures
• 17: Formatting Pictures

Doing More With Word

• 18: Styles and Themes
• 19: Working with Headers and Footers
• 20: Reviewing Documents
• 21: Working with Tables
• 22: SmartArt Graphics
• 23: Using a Template
• 24: Using Mail Merge

TAKE THE QUIZ

PowerPoint 2010

PowerPoint Basics

• 1: Getting Started with PowerPoint
• 2: Slide Basics
• 3: Text Basics
• 4: Applying a Theme
• 5: Inserting Images
• 6: Applying Transitions
• 7: Checking Spelling
• 8: Presenting Slide Show
• 9: Saving and Printing

Common Tasks in PowerPoint

• 10: Modifying Lists
• 11: Indents and Line Spacing
• 12: WordArt and Shapes
• 13: Modifying Themes
• 14: Formatting Pictures
• 15: Arranging Objects
• 16: Animating Text and Objects
• 17: Inserting Videos
• 18: Inserting Audio

Doing More With PowerPoint

• 19: SmartArt Illustrations
• 20: Hyperlinks and Action Buttons
• 21: Working with Tables
• 22: Working with Charts
• 23: Reviewing Presentations
• 24: Advanced Presentation Options
• 25: Slide Master View

TAKE THE QUIZ

Excel 2010

Excel Basics

• 1: Getting Started with Excel
• 2: Cell Basics
• 3: Modifying Columns, Rows, and Cells
• 4: Formatting Cells
• 5: Saving
• 6: Creating Simple Formulas
• 7: Worksheet Basics
• 8: Printing

Common Tasks in Excel

• 9: Creating Complex Formulas
• 10: Working with Basic Functions
• 11: Sorting Data
• 12: Outlining Data
• 13: Filtering Data
• 14: Formatting Tables

Doing More with Excel

• 15: Reviewing and Sharing Workbooks
• 16: Using Templates
• 17: Working with Charts
• 18: Working with Sparklines
• 19: Using Conditional Formatting
• 20: Creating PivotTables
• 21: Using What-If Analysis

TAKE THE QUIZ

ACCESS 2010

Access Basics

• 1: Introduction to Databases
• 2: Introduction to Objects
• 3: Getting Started in Access
• 4: Managing Databases and Objects

Working With Data

• 5: Working with Tables
• 6: Working with Forms
• 7: Sorting and Filtering Records

Running Queries and Reports

• 8: Designing a Query
• 9: More Query Design Options
• 10: Creating Reports
• 11: Advanced Report Options

Database Design Tips

• 12: Modifying Tables
• 13: Creating Forms
• 14: Formatting Forms
• 15: Designing Your Own Database

TAKE THE QUIZ