IT Basics for Advanced Users I

• Identify guidelines for connecting a computer to a network.

• Identify key features of various data storage system.

This module explains concepts related to the Internet and discusses the components that make up the World Wide Web, which is often referred to as the Web. This module also explains different methods that you can use to communicate over the Internet.

• Introduction to the Internet

• Searching for Information on the Internet

• Communicating on the Internet

• Searching for Information on the Web

• Creating an Email Account

• Writing and Sending an Email Message

After completing this module, students will be able to:

• Identify key features of the Internet.

• Search for information on the Internet.

• Communicate on the Internet.

This module explains some of the advanced features Word 2010. This module provides the skills for using the Mail Merge feature of Word 2010 where the students learn to merge data from two documents and send mails to various contacts. This module also focuses on guidelines for creating books and journals using Word 2010.

• Using the Mail Merge Feature

• Working with Manuscripts and Journals

• Creating a Template for the Merged Document and Adding Text

• Creating a New Recipient Address List

• Inserting Placeholders in the Document

• Previewing the Merged Result

After completing this module, students will be able to:

• Use the Mail merge feature of Word 2010.

• Identify the guidelines for creating books and journals using Word 2010.

This module explains the key features of Excel 2010. It explains how to workbook and add data to it. This module also explains how to format data. In addition, this module explains how to represent data in the form of charts.

• Excel 2010 Overview

• Working with Data

• Formatting Data

• Working with Charts

• Creating a Workbook and Adding Data

• Working with a Worksheet

• Formatting Data

• Creating a Chart

• Formatting a Chart

After completing this module, students will be able to:

• Explain the components of a worksheet.

• Work with data in a worksheet.

• Format data in a worksheet.

• Work with charts.

This module explains the basics of Access 2010. It explains how to create a database by using Access 2010. This module also focuses on creating and working with tables in an Access 2010 database.

• Database Management Overview

• Working with an Access Database

• Working with Tables

• Creating an Access 2010 Database

• Creating Tables in a Database

• Adding Records in a Database

• Modifying Records in a Database

After completing this module, students will be able to:

• Identify the components of the Access 2010 database.

• Create a database in Access 2010.

• Work with tables in an Access 2010 database.

This module explains concepts relating to data storage, archival, and retrieval. It explains the various types of data storage techniques, best practices for using the data storage techniques, and simple ways to troubleshoot the storage media. This module also helps the students to gain knowledge for backing up and restoring data.

• Removable Data Storage

• Remote Data Storage

• Backing Up and Restoring Data

After completing this module, students will be able to:

• Work with removable data storage.

• Work with remote data storage.

• Use the Backup and Restore techniques for data archival and retrieval.