Modules

IT Security For Users

This module provides an overview of computer hardware and software, as well as the use of computers in a number of everyday situations.

Objectives:

After completing this module students will have an understanding of:

• System Performance – Unwanted messages, malicious programs, infiltration, hoaxes
• Information Security – Identity / authentication, confidentiality, identify theft
• Technology Security – Networks, connectivity, portable devices
• Guidelines and Procedures – Guidelines and procedures, privacy
• Data Security – Security, backups, storage

Improving Productivity Using IT

This module will help learners understand some of the main concepts of word processing, spreadsheets, and presentations, as well as how to use these essential tools on a computer. Upon completion the learner will be able to create and modify tables, queries, forms, reports and prepare outputs ready for distribution by using a query and sort tools.

Objectives:

After completing this module, students will know how to:

• Plan and select software
• Create solutions to everyday computing tasks
• Review and adapt to new technologies
• Guidelines and Procedures – Guidelines and procedures, privacy
• Data Security – Security, backups, storage

Word Processing Software

This module shows learners how to use Microsoft Word on a Windows machine. With Microsoft Word being one of the most used applications in the workplace this is an essential module in the ITQ syllabus.

Objectives:

After completing this module, students will have an understanding of:

• Using the application – Working with Documents, Enhancing Productivity
• Document Creation – Enter Text, Select, Edit
• Formatting – Text, Paragraphs, Styles
• Objects – Table Creation, Table Formatting, Graphical Object
• Mail Merge – Preparation, Outputs
• Prepare Outputs – Setup, Check and Print

Spreadsheet Software

This module shows users how to work with a spreadsheet application to insert and manipulate data. Learners will be taught how to create formulas and functions, format and print a spreadsheet, import objects, and create and adjust charts. Although this course demonstrates Microsoft Excel specifically, the lessons taught in this module can be applied to other spreadsheet applications.

Objectives:

After completing this module, students will have an understanding of:

• Using the Application – Working with Spreadsheets, Enhancing Productivity
• Cells – Insert, Select, Edit, Sort, Copy, Move, Delete
• Managing Worksheets – Rows and Columns, Worksheets
• Formulas and Functions – Arithmetic Formulas, Functions
• Formatting – Numbers/Dates, Contents, Alignment, Border effects
• Charts – Create, Edit
• Prepare Outputs – Setup, Check and Print

Presentation Software

This module shows users how to work with presentation software to insert and manipulate content. Users are shown how to create import objects, create charts, design slideshows, insert pictures, and animate objects within a slide.

Objectives:

After completing this module, students will have an understanding of:

• Using the Application – Working with Spreadsheets, Enhancing Productivity
• Developing a Presentation – Presentation Views, Slides, Master Slide
• Text – Handling Text, formatting, Lists, Tables
• Charts – Using charts, Organization Charts
• Graphical Objects – Insert, Manipulate, Drawing
• Prepare Outputs – Setup, Check and Print

Database Software

This module shows users how to work with a Database application to insert and manipulate data. This is a brand new bonus module added to cover Microsoft Access 2010 at no extra charge!

Objectives:

After completing this module, students will know how to:

• Create tables
• Create objects
• Retrieve information
• Prepare outputs