Free Course: Computing Fundamentals -uCertify

2.1

Understanding CPUs

2.2

Understanding Memory

2.3

Understanding Motherboards

2.4

Understanding Power Supplies

2.5

Troubleshooting Common System Unit Problems

2.6

Summary

2.7

Test Yourself

Input, Output, and Storage

3.1

Selecting and Using Input Devices

3.2

Selecting and Using Output Devices

3.3

Choosing Appropriate Storage Devices

3.4

Summary

3.5

Test Yourself

Operating System Basics

4.1

Understanding System Software

4.2

Comparing the Major Operating Systems

4.3

Understanding Device Drivers

4.4

Understanding Digital Storage

4.5

Summary

4.6

Test Yourself

Introduction to Windows 8.1

5.1

A Tour of Windows 8.1

5.2

Starting Up and Shutting Down

5.3

Running Applications

5.4

Managing Files

5.5

Summary

5.6

Test Yourself

Windows 8.1 Administration and Maintenance

6.1

Managing User Accounts

6.2

Using System Utilities

6.3

Troubleshooting Common Windows Problems

6.4

Summary

6.5

Test Yourself

Understanding Application Software

7.1

Business Productivity Software

7.2

Graphics Software

7.3

Other Types of Software

7.4

Managing Your Applications

7.5

Summary

7.6

Test Yourself

Understanding Microsoft Office 2013

8.1

Understanding the Office 2013 Interface

8.2

Using Basic Features of Office Applications

8.3

Saving, Opening, and Creating Files

8.4

Printing and Sharing Files

8.5

Setting Application Options

8.6

Summary

8.7

Test Yourself

Word Processing with Microsoft Word

9.1

Editing and Formatting Text

9.2

Formatting Paragraphs

9.3

Formatting Documents and Sections

9.4

Working with Pictures

9.5

Working with Tables

9.6

Correcting and Collaborating

9.7

Summary

9.8

Test Yourself

Creating Spreadsheets with Microsoft Excel

10.1

Understanding the Excel Interface

10.2

Moving Around in a Worksheet

10.3

Changing the Structure of a Worksheet

10.4

Entering Formulas and Functions

10.5

Creating Charts

10.6

Working with Data Tables

10.7

Summary

10.8

Test Yourself

Managing Databases with Access

11.1

Understanding Access Databases

11.2

Creating Databases and Tables

11.3

Understanding the Access Interface

11.4

Creating Queries

11.5

Creating Forms and Reports

11.6

Summary

11.7

Test Yourself

Creating Presentation Graphics with PowerPoint

12.1

Building a Basic Presentation

12.2

Formatting a Presentation

12.3

Creating and Inserting Content

12.4

Applying Transitions and Animations

12.5

Presenting a Slide Show

12.6

Summary

12.7

Test Yourself

Networking and Internet Basics

13.1

Our Connected World: Communication Systems

13.2

The Internet

13.3

Ways of Classifying Networks

13.4

Wireless Networking Technologies

13.5

Network Hardware

13.6

Understanding and Connecting to the Internet

13.7

Troubleshooting Network and Internet Connections

13.8

Summary

13.9

Test Yourself

Online Communication

14.1

Internet Communication Types

14.2

Communicating Appropriately

14.3

Using and Managing Email

14.4

Summary

14.5

Test Yourself

Web Basics

15.1

How the Web Works

15.2

Accessing the Web with a Browser

15.3

Using Web Search Tools

15.4

Summary

15.5

Test Yourself

Network and Internet Privacy and Security

16.1

Network and Internet Security Concerns

16.2

Network and Internet Privacy Concerns

16.3

Strategies for Improving Security

16.4

Summary

16.5

Test Yourself

Legal, Ethical, Health, and Environmental Issues in Computing

17.1

Legal Issues in Computing

17.2

Ethical Issues in Computing

17.3

Health Issues in Computing

17.4

Environmental Issues in Computer Disposal

17.5

Summary

17.6

Test Yourself

Appendix A: Customizing Windows 8.1