Course 50529A: IT Basics for Advanced Users I
15 July 2011
About this course
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.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.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.
- Course details
Course OutlineModule 1: An Overview of Computer SystemsThis 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
Module 2: Using Web Browsers, Email, and the InternetAfter completing this module, students will be able to:
- Introduction to Computer Systems
- Connecting a Computer to a Network
- Introduction to Data Storage
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
- 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 3: Working with Microsoft Word 2010After completing this module, students will be able to:
- Introduction to the Internet
- Searching for Information on the Internet
- Communicating 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.Lessons
- Identify key features of the Internet.
- Search for information on the Internet.
- Communicate on the Internet.
Module 4: Working with Microsoft Excel 2010After completing this module, students will be able to:
- Using the Mail Merge Feature
- Working with Manuscripts and Journals
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
- Use the Mail merge feature of Word 2010.
- Identify the guidelines for creating books and journals using Word 2010.
Module 5: Database ManagementAfter completing this module, students will be able to:
- Excel 2010 Overview
- Working with Data
- Formatting Data
- Working 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.Lessons
- Explain the components of a worksheet.
- Work with data in a worksheet.
- Format data in a worksheet.
- Work with charts.
Module 6: Data Storage, Archival, and RetrievalAfter completing this module, students will be able to:
- Database Management Overview
- Working with an Access Database
- Working with Tables
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
- Identify the components of the Access 2010 database.
- Create a database in Access 2010.
- Work with tables in an Access 2010 database.
After completing this module, students will be able to:
- Removable Data Storage
- Remote Data Storage
- Backing Up and Restoring Data
- Work with removable data storage.
- Work with remote data storage.
- Use the Backup and Restore techniques for data archival and retrieval.
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.
Looking for training resources, events and advice from peers? Join the Microsoft Training and Certification Community.
Preparing for an exam now? Find your Microsoft Certification Study Group.
Talk to us on these social networks: