Training

 

 

Popular Courses

Browse Our Free Resources

  • whitepapers
  • whitepapers
  • webinars
  • blogs

Our Locations

Training Centres

Vancouver, BC
Calgary, AB
Edmonton, AB
Toronto, ON
Ottawa, ON
Montreal, QC
Hunt Valley
Columbia

locations map

Calgary

550 6th Av SW
Suite 475
Calgary, AB
T2P 0S2

Toronto

821A Bloor Street West
Toronto, ON
M6G 1M1

Vancouver

409 Granville St
Suite 902
Vancouver, BC
V6C 1T2

U.S. Office

436 York Road
Suite 1
Jenkintown, PA
19046

Other Locations

Dallas, TX
Miami, FL

Home > Training > Windows 7 > IT Basics for Advanced Users I Training

IT Basics for Advanced Users I Training

Course#: 50529

This three-day instructor-ledcourse provides students with the knowledge and skills to work with a computer system. This course focuses on the key aspects of a computer system and provides IT motivation to the users. This course offers the students the skills to work with Web browsers, email, and the Internet. The students also acquire advanced knowledge and skills to work with MicrosoftWord 2010 and Microsoft Excel 2010. In addition, this courses introduces the students to Data management concepts including backup and Restore.

What you will learn

After completing this course, students will be able to:

  • Develop practical IT motivation.
  • Develop working knowledge of using Web browser, email, and the Internet.
  • Develop advanced working skills of using Word 2010.
  • Develop advanced working skills of using Excel 2010.
  • Develop skills for data management.
  • Develop troubleshooting techniques for data management.

Audience

This course is intended for users who have prior experience of handling a computer for day to day work such as word processing, Internet usage and email, or information management. The expectation for this audience is to learn MS office applications and leverage the knowledge to the organization’s custom applications. The users will also be introduced to the Data Management concepts including Backup and Restore. In essence, the audience may be leveraged as the organizational Admin resources.

Prerequisites

Before attending this course, students must have:

  • Prior experience of handling a computer for day-to-day work such as word processing, Internet usage and email, or information management.

Duration

3 Days

Outline of 50529 IT Basics for Advanced Users I Training

Module 1: An Overview of Computer Systems

This module explains course introduces you to the fundamentals of computing systems. It focuses on the different types of the computers available to the users and the guidelines to protect them from malicious and virus attacks. This module also focuses on how data is stored on various computer systems and the physical media on which data can be stored.

Lessons

  • Introduction to Computer Systems
  • Connecting a Computer to a Network
  • Introduction to Data Storage

After completing this module, students will be able to:

  • Describe the features of various computer systems.
  • Identify guidelines for connecting a computer to a network.
  • Identify key features of various data storage system.

Module 2: Using Web Browsers, Email, and the Internet

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.

Lessons

  • Introduction to the Internet
  • Searching for Information on the Internet
  • Communicating on the Internet

Lab : Using Web Browsers, Email, and 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.

Module 3: Working with Microsoft Word 2010

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.

Lessons

  • Using the Mail Merge Feature
  • Working with Manuscripts and Journals

Lab : Working with Microsoft Word 2010

  • 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.

Module 4: Working with Microsoft Excel 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.

Lessons

  • Excel 2010 Overview
  • Working with Data
  • Formatting Data
  • Working with Charts

Lab : Working with Microsoft Excel 2010

  • 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.

Module 5: Database Management

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.

Lessons

  • Database Management Overview
  • Working with an Access Database
  • Working with Tables

Lab : Database Management

  • 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.

Module 6: Data Storage, Archival, and Retrieval

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.

Lessons

  • 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.
We regularly offer classes in these and other cities. Atlanta, Austin, Baltimore, Calgary, Chicago, Cleveland, Dallas, Denver, Detroit, Houston, Jacksonville, Miami, Montreal, New York City, Orlando, Ottawa, Philadelphia, Phoenix, Pittsburgh, Seattle, Toronto, Vancouver, Washington DC.
*Your name:

*Your e-mail:

*Phone:

*Company name:

Additional notes:

We have received your message. A sales representative will contact you soon.

Thank you!.

more details
buy this course

Register for a courseware sample

It's simple, and free.

 

Thank You!

You will receive an email shortly containing a link to download the requested sample of the labs for this course.