Module 1

1.   Module 1 (60 Hours)

Foundations FO-001   15 hours (5 Sessions)

        This is a perfect starter course for the complete beginner. We patiently explain how the parts of a computer, how to use the keyboard, mouse, and learn basic typing skills using a computer, and advance students to improve their speed and accuracy. A computer program is used in conjunction with the self paced textbook for adults, no tests or pressure-just fun!

Foundations FO-002 15 hours (5 Sessions)

This course provides new users how access to the Internet; using web browsers, mail, file transfer protocol (FTP), configuring Netscape and Internet Explorer for multimedia access using Real Player, Shockwave, Flash and Quick Time. You will also use a variety of web-based search engines for advanced searches and learn the basics of electronic commerce and security issues.

Windows XP Professional CB-001 30 hours (10 Sessions)

This course provides a wonderful introduction to the PC. Basic computer skills are essential to everyone who uses a computer with MS Windows the world's standard operating environment in personal computing! The students will learn to use all of the features of windows XP professional. During this course, the students will be provided with the information necessary to complete the following topics:

a.        Computer Basics

                                              I.      Software basics

                                             ii.      Hardware Basics

                                            iii.      Keyboard and mouse (Typing and mouse training)                           

b.        Windows XP Professional     

                                              I.      Customizing the environment

1.        Start Menu

2.        Desktop

3.        Windows Explorer       

4.        Other customizations

5.        Accessibility features

                                             ii.      Managing Documents

1.        Using Windows Explorer

2.        Using and sharing files on the network

3.        Working Offline

4.        Searching for Files and folders

5.        Printing

                                            iii.      Managing Programs

1.        Running Programs

2.        Installing and removing programs and system components

                                           iv.      Sharing Information and communicating

1.        Making connections

2.        Using Internet Explorer

3.        Sending and receiving faxes

4.        Using NetMeeting

                                            v.      Managing Hardware

1.        Installing and configuring hardware

2.        Managing devices and drivers

3.        Power management

                            vi.      Security and administration

1.        Implementing Windows XP security

2.        Using NTFS Security

                             vii.      Maintenance and optimization

1.        Protecting your data with Backup

2.        Working with the Registry

3.        Optimizing, Maintaining and troubleshooting

4.        Monitoring your system


 viii.      Other Properties

1.        Games

2.        Playing Audio CD

3.        Using Scandisk

4.        Using Disk Clean up

5.        Using Disk defragmenter

6.        Setting up passwords

7.        Using Windows Media Player

8.        Compression tools WinZip and Winrar.

                             Ix.      Music and CD’s

1.        Midi, Wave and MP3 Files

2.        Digital and analog sound

3.        CD-Recordable

4.        CD Re-Writable

5.        MP3 Players

6.        Downloading and converting music.

                             x.      Video Conference

1.        Using NetMeeting

2.        Using Microsoft Instant Messenger (MSN)

 2.     Module 2 (84 hours)
The world's leading suite of productivity software, Microsoft Office helps complete common business tasks, such as word processing, e-mail, presentations, data management and much more. The newest version - Office XP - has features like smart tags, task planes, integrated e-mail, and document recovery to help you work smarter. During this course, the students will be provided with the information necessary to complete the following topics:

A.        Intro. To office XP (2002) M0-001 3 hours (1 Session)

1.        Changes between Office 2000 and 2002

2.        Translation

3.        Speech recognition

4.        Smart Tags

5.        Task Pane

6.       Synonymous

                                               7.       Interoperability between Office Programs

B.        Microsoft Word 2002 MW-00118 hours (6 Sessions)

Students create and edit professional quality documents with standard word processing features. This course is designed for beginners intermediate and advance users.

   i.     The Word window

1.        Enter Text

2.        Select text

3.        Move Through a document

4.        Change the view of a document

                   ii.      Save, Open and print a document

1.        Save a document

2.        Open a document

3.        Preview a document before printing

4.        Print a document

5.        Create a new document

6.        Switch between documents

7.        E-mail a document

                   iii.      Edit a document

1.        Insert and delete text

2.        Move or copy text

3.        Undo change

4.        Find and replace text

5.        Check spelling and grammar

6.        Using the Thesaurus

7.        Using Smart Tags

8.        Add a clip art image

                    iv.      Format Text

1.            Change Font, size and text color

2.            Highlight text

3.            Bold, italic and underline text

4.            Copy formatting

5.            Create a bulleted or numbered list

6.            Change alignment

   v.      Format Pages

1.        Insert Break

2.        Center text on page

3.        Change margins

4.        Add page numbers

5.        Add a watermark

6.        Create columns

  vi.  Working with tables

1.        Create a table

2.        Change row height or column width

3.        Combine cells

4.        Format a table     

   vii. Creating and Modifying Graphics

1.        Create, modify, and position graphics

2.        Create and modify charts using data from other applications

3.         Align text and graphics

    Viii.  Workgroup Collaboration

1.        Track, accept, and reject changes to documents

2.        Merge input from several reviewers

3.        Insert and modify hyperlinks to other documents and Web pages

4.        Create and edit Web documents in Word

5.        Create document versions

6.        Protect documents

7.        Define and modify default file locations for workgroup templates

      ix.  Using Mail Merge

1.        Merge letters with a Word, Excel, or Outlook data source

2.        Merge labels with a Word, Excel, or Outlook data source

C.                 Microsoft Excel 2002 MX-00121 hours (7 Sessions)

Learn this popular spreadsheet program for Windows, including labels, values, formulas/functions, covers spreadsheet design, with a business model emphasizing command usage and charting.

                     I.    the Excel Window

1.        Change the active cell

2.        Enter data

3.        Select cells

4.        Complete a series

5.        Switch between worksheets

6.        Rename Worksheets

                      ii.      Insert, delete or move a worksheet

1.        Save and open a workbook

2.        Create a new workbook

3.        E-mail a worksheet

                      iii.      Edit a worksheet

1.        Edit or delete data

2.        Move or copy data

3.        Insert or delete a row or column

4.        Zoom in or out

5.        Undo changes

                      iv.      Using formulas and functions

1.        Introduction to formulas and functions

2.        Enter a formula

3.        Enter a function

4.        Perform common calculations

5.        Copy a formula

6.        Check errors in formulas

7.        Format a worksheet

8.        Change column and row width and height

9.        Change font and size of data

10.     Change number format

11.     Change data and cell color

12.     Change alignment of data

13.     Center data across columns

14.     Bold, italicize or underline data

15.     Copy formatting

16.     Apply an auto format

                      v.      Print a worksheet

1.        Preview a worksheet

2.        Change page orientation

3.        Change margins

4.        Change print options

5.        Working with charts

6.        Create a chart

7.        Move or resize a chart

8.        Change the chart type

9.        Print a chart       

   vi.     Summarizing Data

1.        Use subtotals with lists and ranges

2.        Define and apply filters

3.        Add group and outline criteria to ranges

4.        Use data validation

5.        Retrieve external data and create queries

6.        Create Extensible Markup Language (XML) Web queries

  vii.     Analyzing Data

1.        Create a Microsoft PivotTable®, Microsoft PivotChart®, and PivotTable/PivotChart  
Reports

2.        Forecast values with what-if analysis

3.        Create and display scenarios

  Ix.     Workgroup Collaboration

1.        Modify passwords, protections, and properties

2.        Create a shared workbook

3.        Track, accept and reject changes to workbooks

4.        Merge workbooks

D.        Ms. Power Point 2002 MP-00112 hours (3 Sessions)

This popular presentation manager from Microsoft has everything you need to quickly turn your ideas into powerfully convincing presentations. We'll show you how to make on-screen presentations, overheads and slides. Learn techniques and tips to automate a slide show and design persuasive and impressive presentations using outlines, slides, clip art and animation.

                         I.   The Power Point Window

1.        Create a presentation using the

2.        Auto content wizard

3.        Create a blank presentation

4.        Change the view of a presentation

5.        Browse through a presentation

6.        Save a presentation

7.        Open a presentation

8.        E-mail a presentation

                        ii.      Edit   slides

1.        Select text

2.        Insert text

3.        Delete text

4.        Undo changes

5.        Move text

6.        Check spelling

7.        Add a new slide

                        iii.      Add objects to slides

1.        Change the slide layout

2.        Add an auto shape slides   

3.        Add word art

4.        Add a picture

5.        Add a clip art image

6.        Add a chart

7.        Add a diagram

8.        Move or resize an object

                         iv.      Enhance a presentation

1.        Change font of text

2.        Change size of text

3.        Change style of text

4.        Change alignment of text

5.        Change text color

6.        Change object color

7.        Change the design template

8.        Change the color scheme

9.        Animate slides

V.      fine-tune a presentation

1.        Reorder slides

2.        Delete a slide

3.        Add slide transitions

4.        View a slide show

5.        Create notes

6.        Preview presentation before printing

7.        Print a presentation                  

vi. Printing Presentations

1.        Preview and print slides, outlines, handouts, and speaker notes

   vii.     Working with Data from Other Sources

1.        Import Excel charts into slides

2.        Add sound and video to slides

3.        Insert Word tables on slides

4.        Export a presentation as an outline

   Viii.     Managing and Delivering Presentations

1.        Set up slide shows

2.        Deliver presentations

3.        Manage files and folders for presentations

4.        Work with embedded fonts

5.        Publish presentations to the Web

6.        Use Pack and Go

   Ix.     Workgroup Collaboration

1.        Set up a review cycle

2.        Review presentation comments

3.        Schedule and deliver presentation broadcasts

            
E.       Ms. Outlook 2002 MU-00112 hours (4 Sessions)

Students will learn how to send and receive mail, schedule appointments, insert events, schedule meetings, create and manage tasks, and organize contacts.
During this course, including computer lab time, students will be provided with the information necessary to complete the following objectives:

·         Identify the elements of the Outlook application window and explore Outlook components.

·         Send, receive, and act on mail messages.

·         Use additional message-handling options, insert text into a message, and create multiple Signatures.

·         Create personal folders and organize Outlook 2000 folders.

·         Create, edit, and categorize single appointments and recurring appointments and create events.

·         Create, send, and manage meeting requests.

·         Create, edit, and assign tasks, and create and edit contacts.

                        I.      Exchange E-mail

1.        The Outlook Window

2.        Read Messages

3.        Send a Message

4.        Attach a File to a Message

5.        Reply to a Message

6.        Forward a Message

7.        Delete a Message

                         ii.      Manage Information

1.        Using the Calendar

2.        Using Contacts

3.        Using Tasks

4.        Using Notes

5.        Using Deleted Items

iii.     Scheduling

1.        Add appointments, meetings, and events to the Outlook calendar

2.        Apply conditional formats to the Outlook calendar

3.        Respond to meeting requests

4.        Use categories to manage appointments

5.        Print calendars

Iv.     Creating and Managing Tasks and Notes

1.        Create and update tasks

2.        Modify task organization and Task view

3.        Accept, decline, or delegate tasks

4.        Create and modify notes

5.        Use categories to manage tasks and notes

F.     Microsoft Access 2002 MA-001 18 hours (6 Sessions)

This popular database manager from Microsoft has everything you need to store, sort, and keep track of your files and records. We'll show you how to use this powerful tool to create custom-made database programs. Learn the concepts of relational database, data normalization techniques, table relationships, and referential integrity by creating tables, queries, screens, reports and macros, and develop a small system.

   I.     Getting Started

 

1.        Introduction to Access

2.        Definition of Database

3.        Create a database using a wizard

4.        Create a Blank Database

5.        Open a database Object

        ii.     Create a Table

 

1.        What are the parts of a table

2.        How to create a table

3.        How to delete a table from the Database

4.        Rename a Field

5.        Rearrange fields

6.        Add a Field

7.        Delete a Field

   iii.     Move through data in a table

1.        Select Data

2.        Edit Data

3.        Add – Delete a record

4.        Display a sub datasheet

5.        Change the view of a table

6.        Set the primary key

7.        Data Types

8.        Change a field data type

9.        Using the pivot table view

10.     Using the Pivot chart view

11.     Create a relationships between tables

     iv.    Create Forms

1.        What is a form

2.        How to create a form

3.        Move through records

4.        Edit Data

5.        Add a record

6.        Delete a record

7.        Find Data

8.        Filter Data by selection

9.        Filter Data using criteria

 

           v.     Create a Query

 

1.        What is a Query

2.        How to create a query

3.        Change the view of a query

4.        Sort query results

5.        Using Criteria

 

         vi. Create Reports

 

1.        Creating Reports

2.        Print a report

3.     Module 3 (69 Hours)
The Web Graphics Designer/developer program provides students a solid grounding in the tools and skills of computer-generated design, to be utilized in both print and web based projects. In addition to emphasizing technical proficiency, essential concepts such design theory and design methodology are integrated. During this course, the students will be provided with the information necessary to complete the following objectives:

A.      Microsoft Front Page 2002 MF-001 27 hours (9 Sessions)

This course teaches you how to build a Web page with Hypertext Markup Language created by the program itself, develop custom web sites, intranets and Share Point pages.

I.      Getting Started

1.        Introduction to FrontPage

2.        Introduction to the Web

3.        Plan a Home Page

4.        Start Front Page

5.        The FrontPage Window

6.        Exit FrontPage

7.        Getting Help

Ii.     FrontPage Basics

1.        Create a New Web Site

2.        Display or hide the Folder list

3.        Display or hide the Navigation Pane

4.        Open a Web Page

5.        Switch between Web Pages

6.        Display or hide a toolbar

7.        Create a blank Web Page

8.        Create a Web Page using a Template

9.        Save a Web Page

10.     Using the Task Pane

11.     Change the view of a Web Site

12.     Open a Web Site

iii.     Work with Web Pages

1.        Enter Text

2.        Delete Text

3.        Print a Web Page

4.        Display Web Page download time

5.        Change the view of a Web Page

6.        Display a Web Page in a Browser

7.        Using the folders View

8.        Change a Web Page Title

9.        Rename a Web Page

10.     Delete a Web Page

11.     Search for a Web Page

iv.     Edit Text

1.        Select Text

2.        Undo Changes

3.        Move or Copy Text

4.        Add Symbols

5.        Check Spelling

6.        Using The Thesaurus

v.     Format Web Pages

1.        Bold, Italicize and Underline text

2.        Change Alignment  of Text

3.        Change Font of Text

4.        Change Size of text

5.        Change Color of text

6.        Highlighted Text

7.        Indent Text

8.        Add a heading

9.        Copy formatting

10.     Created a Bullet of numbering List

11.     Change Background color

12.     Apply a Theme

13.     Add a Hit counter

vi.     Add Images

1.        Introduction to images

2.        Add an Image

3.        Add a Clip Art Image

4.        Move or resize on image

5.        Add a border to an Image

6.        Align an image with text

7.        Add a Background Image

8.        Create a Thumbnail Image

9.        Make a Image Background Transparent

10.     Provide Alternative Text

11.     Add a Horizontal Line

12.     Customize a horizontal Line

13.     Create a Photo Gallery

vii.     Create Links

1.        Create a link to another Web Page

2.        Create a link to a Web Page area

3.        Create a E-mail Link

4.        Create a link to a sound or video

5.        Remove a link

6.        Change link Colors

7.        Using the Hyperlink view

8.        Check Links

9.        Add a Link Bar

viii.     Create Tables

1.        Add a Table

2.        Add or Delete a Row or Column

3.        Change Row Height or Column Width

4.        Combine Cells

5.        Add a Caption to a Table

6.        Change Table Border

7.        Format a Table

ix.     Work with Navigational Structure

1.        Using a Navigational View

2.        Add a Web Page to the Navigational Structure

3.        Remove a Web Page from the Navigational Structure

4.        Move a WEB Page in the Navigational Structure

5.        Change a Web Page Title in the Navigational Structure

6.        Add shared Borders

7.        Change Navigation Buttons in shared Borders

x.     Create Frames

1.        Create Frames

2.        Add an existing Web Page to a Frame

3.        Add a New Web Page to a Frame

4.        Resize a Frame

5.        Save Frames

6.        Create a link to a frame

7.        Set a Frames Page as your Home Page

8.        Create an Inline Frame

xi.     Create Forms

1.        Set Up a Form

2.        Add a Text Box

3.        Add a Test Area

4.        Add Check Boxes

5.        Add Option Buttons

6.        Add a Drop-Down Box

7.        Access From Results

xii.     Manage Web Pages

1.        Create a New Folder

2.        Move  a File to a Folder

3.        View Reports

4.        Add a Task

5.        View Task

6.        Delete a Task

xiii.      Publish Web Page

1.        Introduction to a Web Hosting Service

2.        Choose a Web Hosting Service

3.        Specify Keyboards for a Web Page

4.        Specify a Summary for a Web Page

5.        Transfer Web Page to a Web Server

6.        Publicize Web Pages

B. Adobe Photoshop 7.0   AP-001 21 hours (7 Sessions)

The industry standard program for desktop image design and production; create your own image files by combining graphic elements and photos. Learn to edit and enhance your images with this powerful program. Students will learn to use several tools for selecting parts of images, and will move, duplicate, and resize images. Students will learn to use layers, and to apply layer effects and filters to create special effects, including lighting and texture effects. Additionally, students will use painting tools and blending modes to create shading effects, and will perform adjustments to contrast and color balance. Students will save images in formats for print and Web use.

1.        Select appropriate resolutions for different image and output types.

2.        Resize and crop image areas.

3.        Select image areas using the Lasso, Marquee, and Magic Wand tools.

4.        Use alpha channels to save and load selections.

5.        Create and manipulate multiple layers to composite images easily.

6.        Apply blending and shading effects to create realistic composites.

7.        Select colors using the Color palette, Color Picker, and Eyedropper tool.

8.        Use Photoshop's painting tools to create artwork or to retouch photographs.

9.        Add and format text within an image.

10.     Apply layer effects and filters to create special effects including lighting effects and textures.

11.     Modify the brightness, contrast, color balance, hue, and saturation of images.

12.     Save images in file formats for use with other applications and the Web.

C. Adobe Illustrator 10.0 AI-001 21 hours (7 Sessions)

The finest illustration tools and typographic control give you the ultimate power to create graphics to artists, technical illustrators, desktop publishers, & on-line designers. Create artwork and layouts for brochures, ads, packaging, Web pages, and more. This hands-on course will introduce you to the basics of Illustrator. Adobe Illustrator is a sophisticated graphics program capable of creating complex and attractive illustrations and type effects. In this course, you will learn many of the basic skills that will allow you to take advantage of Illustrator's powerful tools.

 

1.        Navigate in the Adobe Illustrator environment.

2.        Master the use of the Pencil and Pen tools to create paths.

3.        Use several tools to manipulate and modify paths.

4.        Create and edit geometric objects.

5.        Apply fill and stroke attributes to objects and paths.

6.        Define process colors and gradients and work with spot colors.

7.        Use layers to manage complex illustrations.

8.        Use the Transparency palette to change the opacity of selected objects.

9.        Enter and format type in an illustration, and create eye-catching type effects

4.     Module 4 (147 hours)

Repair Program 
A+ Certification is a Comptia-sponsored testing program that certifies the competency of entry-level (6 month’s experience) computer service technicians. The A+® exams contain situational, and identification types of questions. All of the questions are multiple choices. There is either one answer for each question or the question identifies how many answers you should select. The test covers a broad range of hardware and software technologies, but is not bound to any vendor-specific products.

The program is backed by major computer hardware and software vendors, distributors, resellers and publications. A+ certification signifies that the certified individual possesses the knowledge and skills essential for a successful entry-level (6 months experience) computer service technician, as defined by experts from companies across the industry. To date, over 500,000 people have obtained the A+ Certification

1.     Core module RC-001 45 Hours (15 sessions)

a.        Domain 1.0 Installation, Configuration, and Upgrading
This domain requires the knowledge and skills to identify, install, configure, and upgrade microcomputer modules and peripherals, following established basic procedures for system assembly and disassembly of field replaceable modules. Elements included are listed below with each test objective

                   I.      Content Limits
Identify basic terms, concepts, and functions of system modules, including how each module should work during normal operation and during the boot process.

• System board
• Power supply
• Processor /CPU
• Memory
• Storage devices
• Monitor
• Modem
• Firmware
• BIOS
• CMOS
• LCD (portable systems)
• Ports
• PDA (Personal Digital Assistant)

Identify basic procedures for adding and removing field replaceable modules for both desktop and portable systems.

• System board
• Storage device
• Power supply
• Processor /CPU
• Memory
• Input devices
• Hard drive
• Keyboard
• Video board
• Mouse
• Network Interface Card (NIC)

Portable system components

• AC adapter
• Digital Camera
• LCD panel
• PC Card
• Pointing Devices.

                Ii.      Identify available IRQs, DMAs, and I/O addresses and procedures for device installation and configuration.

• Standard IRQ settings
• Modems
• Floppy drive controllers
• Hard drive controllers
• USB ports
• Infrared ports
• Hexadecimal/Addresses 

               Iii.      Identify common peripheral ports associated cabling, and their connectors.

• Cable types
• Cable orientation
• Serial versus parallel
• Pin connections
  Examples of types of connectors:
  • DB-9
  • DB-25
  • RJ-11
  • RJ-45
  • BNC
  • PS2/MINI-DIN
  • USB
  • IEEE 1394

               iv.      Identify proper procedures for installing and configuring IDE/EIDE devices.

• Master/Slave
• Devices per channel
• Primary/Secondary 

                 v.  Identify proper procedures for installing and configuring SCSI devices.

• Address/Termination conflicts
• Cabling
• Types (example: regular, wide, ultra-wide)
• Internal versus external
• Expansion slots, EISA, ISA, PCI
• Jumpers block settings (binary equivalents).

                  vi.   Identify proper procedures for installing and configuring peripheral devices.

• Monitor/Video Card
• Modem
• USB peripherals and hubs
• IEEE 1284
• IEEE 1394
• External storage

Portables

• Docking stations
• PC cards
• Port replicators
• Infrared devices

                   Vii. Identify hardware methods of upgrading system performance, procedures for replacing basic subsystem components, unique components and when to use them. 

• Memory
• Hard Drives
• CPU
• Upgrading BIOS
• When to upgrade BIOS

Portable Systems

•    Battery
•    Hard Drive
•    Types I, II, III cards
•    Memory 

b.        Domain 2.0 Diagnosing and Troubleshooting
This domain requires the ability to apply knowledge relating to diagnosing and troubleshooting common module problems and system malfunctions. This includes knowledge of the symptoms relating to common problems.

                   I.   Identify common symptoms and problems associated with each module and how to troubleshoot and isolate the problems.

• Processor/Memory symptoms
• Mouse
• Floppy drive
• Parallel ports
• Hard Drives
• CD-ROM
• DVD
• Sound Card/Audio
• Monitor/Video
• Motherboards
• Modems
• BIOS
• USB
• NIC
• CMOS
• Power supply
• Slot covers
• POST audible/visual error codes
• Troubleshooting tools, e.g., multimeter
• Large LBA, LBA
• Cables
• Keyboard
• Peripherals 

                   ii.   Identify basic troubleshooting procedures and how to elicit problem symptoms from customers.

• Troubleshooting/isolation/problem determination procedures
• Determine whether hardware or software problem
• Gather information from user regarding, e.g.,
• Customer Environment
• Symptoms/Error Codes
• Situation when the problem occurred.

c.         Domain 3.0 Preventive Maintenance
This domain requires the knowledge of safety and preventive maintenance. With regard to safety, it includes the potential hazards to personnel and equipment when working with lasers, high voltage equipment, ESD, and items that require special disposal procedures that comply with environmental guidelines. With regard to preventive maintenance, this includes knowledge of preventive maintenance products, procedures, environmental hazards, and precautions when working on microcomputer systems.

                    I.   Identify the purpose of various types of preventive maintenance products and procedures and when to use them.

• Liquid cleaning compounds
• Types of materials to clean contacts and connections
• Non-static vacuums (chassis, power supplies, fans)

                     Ii.  Identify issues, procedures and devices for protection within the computing environment, including people, hardware and the surrounding workspace.

• UPS (Uninterruptible Power Supply) and suppressors
• Determining the signs of power issues
• Proper methods of storage of components for future use

 Potential hazards and proper safety procedures relating Lasers

• High-voltage equipment
• Power supply
• CRT

 Special disposal procedures that comply with environmental guidelines.

• Batteries
• CRTs
• Toner kits/cartridges
• Chemical solvents and cans
• MSDS (Material Safety Data Sheet)

 ESD (Electrostatic Discharge) precautions and procedures

• What ESD can do, how it may be apparent, or hidden
• Common ESD protection devices
• Situations that could present a danger or hazard

d.        Domain 4.0 Motherboard/Processors/Memory
This domain requires knowledge of specific terminology, facts, and ways and means of dealing with classifications, categories and principles of motherboards, processors, and memory in microcomputer systems.

                     I. Distinguish between the popular CPU chips in terms of their basic characteristics.

• Popular CPU chips (Intel, AMD, Cyrix)
• Characteristics
• Physical size
• Voltage
• Speeds
• On board cache or not
• Sockets

                   ii.   Identify the categories of RAM (Random Access Memory) terminology, their locations, and physical characteristics.

• EDO RAM (Extended Data Output RAM)
• DRAM (Dynamic Random Access Memory)
• SRAM (Static RAM)
• RIMM (Rambus Inline Memory Module 184 Pin)
• VRAM (Video RAM)
• SDRAM (Synchronous Dynamic RAM)
• DDR (Double Data Rate)
• WRAM (Windows Accelerator Card RAM)
• Locations and physical characteristics:
• Memory bank
• Memory chips (8-bit, 16-bit, and 32-bit)
• SIMMS (Single In-line Memory Module)
• DIMMS (Dual In-line Memory Module)
• ECC Memory

                   Iii.  Identify the most popular type of motherboards, their components, and their architecture (bus structures and power supplies).

• AT (Full and Baby)
• ATX
• Components
• Communication ports
• SIMM and DIMM
• Processor sockets
• External cache memory (Level 2)
• Bus Architecture
• ISA
• PCI
• AGP
• USB (Universal Serial Bus)
• VESA local bus (VL-Bus)
• Basic compatibility guidelines
• IDE (ATA, ATAPI, ULTRA-DMA, EIDE)
• SCSI (Wide, Fast, Ultra, LVD(Low Voltage Differential))

                   iv.      Identify the purpose of CMOS (Complementary Metal-Oxide Semiconductor), what it contains and how to change its basic parameters.

• Printer parallel port Uni, bi-directional, disable/enable, ECP, EPP
• COM/serial port memory address, interrupt request, disable
• Floppy drive enable/disable drive or boot, speed, density
• Hard drive size and drive type
• Memory parity, non-parity
• Boot sequence
• Passwords
• Plug & Play BIOS

e.         Domain 5.0 Printers
 This domain requires knowledge of basic types of printers, basic concepts, and printer components, how they work, how they print onto a page, paper path, care and service techniques, and common problems.

        I.      Identify basic concepts, printer operations and printer components.

• Paper feeder mechanisms
• Types of Printers
• Laser
• Inkjet
• Dot Matrix

 Types of printer connections and configurations

• Parallel
• Network
• USB
• Infrared

                   ii.      Identify care and service techniques and common problems with primary printer types.

• Feed and output
• Errors (printed or displayed)
• Paper jam
• Print quality
• Safety precautions
• Preventive maintenance

f.           Domain 6.0 Basic Networking
This domain requires knowledge of basic network concepts and terminology, ability to determine whether a computer is networked, knowledge of procedures for swapping and configuring network interface cards, and knowledge of the ramifications of repairs when a computer is networked. The scope of this topic is specific to hardware issues on the desktop and connecting it to a network.

                  I.      Identify basic networking concepts, including how a network works and the ramifications of repairs on the network.

• Installing and configuring network cards
• Network access
• Full-duplex, half-duplex
• Cabling Twisted Pair, Coaxial, Fiber Optic
• Ways to network a PC
• Physical Network topographies
• Increasing bandwidth
• Loss of data
• Network slowdown
• Infrared
• Hardware protocols

2. Operating System Module RO-001 51 hours (17 sessions)

a.        Domain 1.0 Operating System Fundamentals
this domain requires knowledge of underlying DOS (Command prompt functions) in Windows 9x, Windows 2000 operating systems in terms of its functions and structure, for managing files and directories, and running programs. It also includes navigating through the operating system from command line prompts and Windows procedures for accessing and retrieving information.

  I.      Identify the operating systems functions, structure, and major system files to navigate the operating system and how to get to needed technical information.

•    Major Operating System functions
•    Create folders
•    Checking OS Version
•    Major Operating System components
•    Explorer
•    My Computer
•    Control Panel
•    Contrasts between Windows 9X and Windows 2000
•    Major system files: what they are, where they are located, how they are used
•    and what they contain

System, Configuration, and User Interface files

•    IO.SYS
•    BOOT.INI
•    WIN.COM
•    MSDOS.SYS
•    AUTOEXEC.BAT
•    CONFIG.SYS
•    COMMAND LINE PROMPT

Memory management

•    Conventional
•    Extended/upper memory
•    High memory
•    FILE memory
•    HIMEM.SYS
•    EMM386.exe

Windows 9x Computer Management

•    IO.SYS
•    WIN.INI
•    USER.DAT
•    SYSEDIT
•    SYSTEM.INI
•    SETVER.EXE
•    SMARTDRV.EXE
•    MSCONFIG (98)
•    COMMAND.COM
•    DOSSTART.BAT
•    REGEDIT.EXE
•    SYSTEM.DAT
•    RUN COMMAND
•    DriveSpace

Windows 2000 Computer Management

• BOOT.INI
• REGEDT32
• REGEDIT
• RUN CMD
• NTLDR
• NTDETECT.COM
• NTBOOTDD.SYS

 Command Prompt Procedures (Command syntax)

• DIR
• ATTRIB
• VER
• MEM
• SCANDISK
• DEFRAG
• EDIT
• XCOPY
• COPY
• FORMAT
• FDISK
• MSCDEX
• SETVER
• SCANREG

Operating System Technologies Examination Objectives

                                             ii.      Identify basic concepts and procedures for creating, viewing and managing files, directories and disks. This includes procedures for changing file attributes and the ramifications of those changes (for example, security issues).

• File attributes - Read Only, Hidden, System, and Archive attributes
• File naming conventions (Most common extensions)
• Windows 2000 COMPRESS, ENCRYPT
• IDE/SCSI
• Internal/External
• Backup/Restore
• Partitioning/Formatting/File System
• FAT
• FAT16
• FAT32
• NTFS4
• NTFS5
• HPFS
• Windows-based utilities
• Scandisk
• Device manager
• System Manager
• Computer Manager
• MSCONFIG.EXE
• REGEDIT.EXE (View information/Backup registry)
• REGEDT32.EXE
• ATTRIB.EXE
• EXTRACT.EXE
• DEFRAG.EXE
• EDIT.COM
• FDISK.EXE
• SYSEDIT.EXE
• SCANREG
• WSCRIPT.EXE
• HWINFO.EXE
• ASD.EXE (Automatic Skip Driver)
• Cvt1.EXE (Drive Converter FAT16 to FAT32)

b.        Domain 2.0 Installation, Configuration and Upgrading
This domain requires knowledge of installing, configuring and upgrading Windows 9x, and Windows 2000. This includes knowledge of system boot sequences and minimum hardware requirements.
 

                                              I.      Identify the procedures for installing Windows 9x, and Windows 2000 for bringing the software to a basic operational level.

• Start Up
• Partition
• Format drive
• Loading drivers
• Run appropriate set up utility 

                                             ii.      Identify steps to perform an operating system upgrade.

• Upgrading from Windows 98 to Windows 2000
• Replacing Windows 9x with Windows 2000
• Dual boot Windows 9x/Windows 2000 

                                            iii.      Identify the basic system boot sequences and boot methods, including the steps to create an emergency boot disk with utilities installed for Windows 9x, Windows NT, and Windows 2000.

• Startup disk
• Safe Mode
• MS-DOS mode
• NTLDR (NT Loader), BOOT.INI
• Files required to boot
• Creating emergency repair disk (ERD). 

                                           iv.      Identify procedures for loading/adding and configuring application device drivers and the necessary software for certain devices.

• Windows 9x Plug and Play and Windows 2000
• Identify the procedures for installing and launching typical Windows and non-Windows
• applications. (Note: there is no content related to Windows 3.1)
• Procedures for set up and configuring Windows printing subsystem.
• Setting Default printer
• Installing/Spool setting
• Network printing (on a peer to peer environment)

c.         Domain 3.0 Diagnosing and Troubleshooting
This domain requires the ability to apply knowledge to diagnose and troubleshoot common problems relating to Windows 9x and Windows 2000. This includes understanding normal operation and symptoms relating to common problems.

 I.      Recognize and interpret the meaning of common error codes and startup messages from the boot sequence, and identify steps to correct the problems.

• Safe Mode
• No operating system found
• Error in CONFIG.SYS line XX
• Bad or missing COMMAND.COM
• HIMEM.SYS not loaded
• Missing or corrupt HIMEM.SYS
• SCSI
• Swap file
• NT boot issues
• Dr. Watson
• Failure to start GUI
• Windows Protection Error
• Event Viewer  Event log is full
• A device referenced in SYSTEM.INI, WIN.INI, Registry is not found

                                             ii.      Recognize common problems and determine how to resolve them.

• Eliciting problem symptoms from customers
• Having customer reproduce error as part of the diagnostic process
• Identifying recent changes to the computer environment from the user
• Troubleshooting Windows-specific printing problems
• Print spool is stalled
• Incorrect/incompatible driver for print
• Incorrect parameter
• Other Common problems
• General Protection Faults
• Illegal operation
• Invalid working directory
• System lock up
• Option (Sound card, modem, input device) or will not function
• Application will not start or load
• Cannot log on to network (option  NIC not functioning)
• TSR (Terminate Stay Resident) programs and virus
• Applications don’t install
• Network connection.
• Viruses and virus types
• What they are
• Sources (floppy, emails, etc.)
• How to determine presence

d.         Domain 4.0 Networks
This domain requires knowledge of network capabilities of Windows and how to connect to networks on the client side, including what the Internet is about, its capabilities, basic concepts relating to Internet access and generic procedures for system setup. The scope of this topic is only what is needed on the desktop side to connect to a network.

                                              I.      Identify the networking capabilities of Windows including procedures for connecting to the network.

• Protocols
• IPCONFIG.EXE
• WINIPCFG.EXE
• Sharing disk drives
• Sharing print and file services
• Network type and network card
• Installing and Configuring browsers
• Configure OS for network connection

                                             ii.      Identify concepts and capabilities relating to the Internet and basic procedures for setting up a system for Internet access. 

Concepts and terminology

• ISP
• TCP/IP
• IPX/SPX
• NetBEUI
• E-mail
• PING.EXE
• HTML
• HTTP://
• FTP
• Domain Names (Web sites)
• Dial-up networking
• TRACERT.EXE
• NSLOOKUP.EXE
  
   

3. Repair program Real life RR-001 51 hours (17 sessions)

1.      Understanding the network protocols and physical devices to create an ICS (Internet connection sharing) using the analog modem.

§         IP Addressing

§         Subnet Mask

§         Gateway

§         DNS

§         Hubs, switches and routers.

§         Cabling specifications (Straight thru and Crossover)

2.      Partition Magic 7.0 / 8.0

• Installation
• Creating the Rescue disks
• Delete, create, format, merge, and resize partitions
• Troubleshooting

3.      Ghost 2002

• Installing
• Creating a bootable floppy
• Working from IDE connectors
• Working from TCP/IP
• Create an Image
• Copying a hard disk
• Coping a partition
• Troubleshooting

4.      Norton Utilities 2003

• Running from CD
• Using Win Doctor
• Using Disk Doctor
• Booting from CD

5.      Norton Antivirus 2003

• Installing Norton
• Live update
• Scanning devices
• Schedule a scan
• Exclusions
• The activity log and script blocking
• Repair, delete and quarantine

6.      Norton Firewall 2002

• Configuring the firewall
• Add, change and delete permissions
• Block ports, URL addresses, Configure options.
• Understanding the ping, tracert, Route and netstat commands

7.      Windows XP

• Differences between XP Home, Professional and 64 Bits edition
• Minimum requirements for Windows XP Professional
• Partitions review
• FAT 32 Vs NTFS
• Installing XP Pro.
• Updating XP Professional
• Adding XP Professional To a Server
• Setting up permissions on the server
• Roaming and local profiles

8.         New Stuff

• MSN Messenger
• Net meeting (CONF)
• Remote desktop connection (using Outlook and Messenger)
• Files and settings transfer wizard
• System restore
• Windows movie maker
• Transfer files wizard
• Program compatibility wizard
• Roll back driver
• Firewall
• Password restore
• Service Pack 1
• Set Program Access and defaults
• Windows XP Plus!
• Power toys for Windows XP

9.      Drive Image 2002

• Considerations
• Create Images on the network
• Create images on the CD-RW or DVD-RW
• Create images on a different partition
• Create a start up image disk
• Restoring Images

5.      Module 5 (196 hours)

Networking Program
Students learn to organize and administer a network of Windows 2000 workstations including account administration, security, the registry, control panel, maintenance, logons, resources, the browser, print devices, and troubleshooting. This course is designed to build, install, update and configure a Windows 2000 server. Besides of  utilize network tools and work with RIS (Remote Installation Service), DHCP (Dynamic Host Configuration Protocol), profiles (Local, Roaming and Mandatory) and more of W2K server.

TCP/IP TC-001 24 hours (8 sessions)

TCP/IP is the language that computers speak. Is a set of rules that defines how two computers address each other and send data to each other. This set of rules is called protocol. Multiple protocols that are grouped together form a protocol suite and work together as a protocol stack.

TCP/IP is a strong, fast, scalable, and efficient suite of protocols. This protocol stack is the facto protocol of the Internet. As information exchange via the Internet becomes more widespread, more individuals and companies will need to understand TCP/IP.

Intensive knowledge of TCP/IP is taught in the first classes as consequence of the demand in the futures certifications includes CISCO, MSCE and NORTEL evaluation tests.

·         What’s the TCP/IP

·         What are the protocols

·         What’s IP addressing

·         Numbering System

·         Reviewing Binary and Decimal numbering systems

·         Converting binary numbers to Decimal

·         Converting Decimal numbers to Binary

·         The IP Addresses Classes

·         Classless Inter-Domain Routing (CIDR)

·         What is a Subnet Mask?

·         Network and Host

·         Finding a local o remote address

·         Custom Subnet Mask ( SUBNETTING)

·         Subnetting rules

·         Creating a custom subnet mask

o        Determining how many subnets are needed

o        Determining the maximum number of host on each network

o        Determining the Subnet Mask

o        Determining the valid Network Addresses

o        Determining the range of valid host IP addresses

o        Confirm that you met the requirements for the number of networks and maximum numbers of hosts.

·         IP address Allocation

·         Supernetting

·         Host name resolution

·         NetBIOS name Resolution

·         The need for a new version of IP

·         IPv6’s form of addressing

·         Plans for the proposed transition from IPv4 to IPv6

   NETWORK PROGRAM N+ NP-001 48 Hours (16 Sessions)

Network Cables and Devices

·        The OSI Model

·        Network Adapters

·        Network Cabling

·        Topology and Physical Layout

·        Bridges, Brouters, and Routers

·        Remote Connectivity

·        Troubleshooting Hardware

Network Protocols

·        Protocols and the OSI Model

·        Transport Protocols

·        TCP/IP Fundamentals

·        Subnetting and Routing

·        Name Resolution

·        Proxies and Firewalls

·        Troubleshooting Tools

·        Remote Access Protocols

Network Operating Systems

·        Introduction

·        Network Clients

·        Directory Services

·        Administrative Utilities

·        Windows 2000 User Management

·        Accessing  Windows 2000 Server Resources

·        Optimizing & Maintaining Windows 2000

Network Design & Maintenance

·        Planning

·        Hardware Resources

·        Fault Tolerance

·        Routine Maintenance

·        Upgrades and Modifications

·        Troubleshooting

·        Identify the seven layers of the OSI Model and describe the role of each.

·        Identify the basic attributes, purpose, and function of Network Interface Cards (NICs).

·        Select an appropriate course of action when a client workstation does not connect to the network after installing or replacing a network interface card.

·        Discuss how a network card is usually configured, including the purpose of EPROM, jumpers, and configuration software.

·        Illustrate methods of diagnosing network card problems, including performing loop back tests, utilizing vendor-supplied diagnostics, and resolving device conflicts.

·        Illustrate by example the characteristics and appropriate implementation of various types of network media including:

·        UTP

·        STP

·        Category 5 -5e -  6

·        Category 3

·        Coaxial

·        Fiber Optic

·        Discuss the maximum length and speed of various types of network media, including:

·        10Base2

·        10BaseT

·        10Base5

·        100BaseT

·        100VG-AnyLAN

·        100BaseTX

·        Identify RJ-45 and BNC connectors.

·        Given either the T568A or T568B pin-out configuration, properly crimp and RJ-45 connector onto Category 5 UTP cable.

·        Discuss the procedure to properly crimp a BNC connector onto coaxial cable.

·        Describe the characteristics, advantages, and disadvantages of bus, ring, star, and mesh topologies.

·        Describe the characteristics of an Ethernet network.

·        Describe the characteristics of a Token Ring network.

·        Contrast the functions of bridges, brouters, and routers.

·        Describe the properties, benefits, and potential issues involved with POTS circuits.

·        Describe the properties, benefits, and potential issues involved with ISDN circuits.

·        Configure Windows 98 with a modem.

·        Establish a dial-up network connection using Windows 98.

·        Discuss how environmental factors can affect computer networks.

·        Define physical and logical indicators of network trouble.

·        Recognize and apply appropriate diagnostic procedures.

·        Identify the purpose and function of common network tools.

·        Identify the components of the troubleshooting cycle.

·        Gather information relevant to a network support problem.

·        Compare and contrast popular protocols, including:

·        TCP/IP

·        IPX/SPX

·        NetBEUI

·        Describe the importance of network name resolution.

·        Identify the main protocols that are included within the TCP/IP suite.

·        Given an IP address, identify it as a Class A, B, or C address.

·        Given a Well Known Port number, identify the TCP/IP components associated with that port.

·        Describe the purpose of Dynamic Host Configuration Protocol (DHCP).

·        Compare and contrast the functions of a firewall with those of a proxy server.

·        Identify the following IP troubleshooting Network tools:

§         ARP

§         NBTSTAT

§         NETSTAT

§         PING

§         HOSTNAME

§         NSLOOKUP

§         TRACERT

§         IPCONFIG

§         WINIPCFG

§         IFCONFIG

§         ROUTE

§         TELNET

·        Describe the role of SLIP, PPP, and PPTP.

·        Compare and contrast Windows 2000 and NetWare in terms of:

§         Directory services

§         User Management

§         Security

§         Administrative tools

§         Discuss various fault tolerance methods, including:

§         Disk Mirroring

§         Disk Striping with Parity

§         Disk Duplexing

·        Discuss the role of replication in a fault tolerance strategy

·        Develop an adequate tape backup procedure

·        Identify the benefits of removable media devices

·        Explain the purpose of Uninterruptible Power Supplies

·        Discuss the necessity of applying software patches and fixes to network operating systems, desktop operating systems, and applications

·        Provide an example of a method by which a virus could infect a network

·        Discuss the need to document system configuration prior to making modifications

·        Describe the steps required to restore a system to its original state after performing an upgrade

·        Illustrate potential issues with outdated or unused driver files when upgrading an operating system

·        Identify potential problems after computer equipment is physically relocated

·        Provide general guidelines for upgrading Windows 9x and Windows 2000 pro

·        Provide general guidelines for installing Windows 2000 Server

·        Describe methods to help prioritize network problems.

Windows 2000 Professional wP-001 24 hours (8 sessions)
Students will learn how to install and manage the Windows 2000 Professional operating system. Upon successful completion of this course, students will be able to:  

·         Install Windows 2000 Professional, understand the upgrade process from Windows 9x and Windows NT, and prepare for an unattended installation.

·         Explain the Windows 2000 boot process.

·         Install Plug and Play and legacy hardware, use Device Manager to configure hardware devices, customize a Windows 2000 installation, and add and remove software and operating system updates.

·         Create partitions on basic disks, upgrade basic disks to dynamic disks, defragment a hard disk, and use NTFS file compression.

·         Create and manage users and groups in a Windows 2000 workgroup.

·         Secure files with NTFS security, and analyze the interaction between share permissions and NTFS security.

·         Use the Distributed File System, set and manage disk quotas, configure Offline Files, and encrypt files and folders.

·         Create a local printer, connect to a network printer, manage network printing, and connect to a network printer through the Web.

·         Use Event Viewer to analyze network information, use Performance to analyze network activity, and optimize network and server performance.

·         Use all of the major Windows 2000 administrative tools.

·         List and describe the basic physical components of a computer network.

·         List and describe the primary network architecture schemes and the devices used to connect networks together.

·         Identify and describe the major networking protocols and relate them to the Microsoft network architecture.

·         Configure TCP/IP manually on a Windows 2000 computer.

·         Use default and custom subnet masks to subdivide a TCP/IP network.

·         Identify the Windows 2000 components used to connect to the World Wide Web.

·         Identify the Windows 2000 components used to configure remote access to a Windows 2000 network.

  Windows 2000 server wS-001 45 hours (15 sessions)

Installing, configuring and administering Microsoft Windows 2000 Server operating system. During this classes the students will learn such things as how to create and manage users and groups, how to configure and customize the operating system, how to create and manage the different disk configurations such as simple volumes, spanned volumes, stripe volumes, mirrored volumes and Raid5 volumes, how to optimize and troubleshoot the system, how to install, configure and manage printers, how to active directory works, etc.
 

·         Implementing, managing and troubleshooting Hardware devices and drivers for servers

·         Minimum requirements, considerations and installation

·         Install Windows service packs

·         Configure Internet connection utilizing Static IP addresses

·         Create a Domain Controller (Active Directory)

·         Remove a Domain Controller (DCPROMO)

·         Understand and create dynamic volumes

·         create a simple volume

·         create a spanned volume

·         create a mirrored volume

·         create a striped volume

·         Install TCP/IP, NWLINK  and NetBEUI protocols

·         Installing, configuring and troubleshooting Shared access, remote access

·         Installing, configuring and troubleshooting VPNs and terminal services

·         Create a DHCP (Scope and exclusions)

·         Setup the Internet connection Sharing (Using ICS or NAT)

·         Setup a remote Installation Service (RIS)

·         Create User accounts

• Local Profile
• Roaming Profile
• Mandatory Profile

·         Create permissions

·         Encrypting File systems (EFS)

·         Use the Microsoft Management Console (MMC)

·         Installing, configuring and troubleshooting Norton Antivirus enterprise edition (4 consoles)

·         Learn how to create the rules for the antivirus (updating, scanning and the quarantine)

·         Learn how to install, configure and troubleshoot Diskepeer

·          Installing, configuring and troubleshooting a FTP server

CCNA PROGRAM CC-001 54 Hours (18 Lessons)

The CCNA certification (Cisco Certified Network Associate) indicates a foundation in and apprentice knowledge of networking for the small office/home office (SOHO) market. CCNA certified professionals can install, configure, and operate LAN, WAN, and dial access services for small networks (100 nodes or fewer), including but not limited to use of these protocols: IP, IGRP, IPX, Serial, AppleTalk, Frame Relay, IP RIP, VLANs, RIP, Ethernet, Access Lists. Cisco Certified Network Associate (CCNA) Basics presents important networking fundamentals using the Open Systems Interconnect (OSI) seven layer model concepts; terminology and technologies are explained and illustrated using text and graphics animation. The course includes online assessments that allow learners to measure their progress throughout the learning experience.

After completing this course the student should be able to:

• Commonly used networking terms and topologies
• The basic functions of a network protocol
• Fundamental network device roles (for example, hub, bridge, router, and switch)
• Binary and hexadecimal numbering
• Internetworking concepts overview
• The Open System Interconnection (OSI) reference model
• Assembling and cabling Cisco devices
• Operating and configuring a Cisco IOS device
• Interconnecting Catalyst Switches
• Interconnecting Cisco Routers
  • With TCP/IP
  • Determining IP routes
  • Basic IP traffic management with access list
• Establishing serial point to point connections
• Identify the major components of the network system
• Examine the primary types and use of network cabling
• Compare the functions or usage of a local area network (LAN) versus wide area network (WAN)
• Describe the standard topologies and the advantages and disadvantages of each
• Discuss the functions of each of the seven layers of the OSI reference model
• Describe the basic process of communication between the layers of the OSI reference model
• Define the major network access methods and outline the key features of each
• Describe the functions and features of devises used at Layers One, Two and Three of the OSI model
• Explain the significance of each of the following to the following to a network system: IP addresses and classes and reserved address space
• Identify and described common routed and routing protocols

6.     Module 6 (35 hours)

Quick books 2002 QB-001 35 hours (12 sessions)
Students will learn how to set up a QuickBooks company; enter account opening balances; create and customize company lists; set up inventory; sell products; invoice for services; process customer payments; work with bank accounts, enter and pay bills; set up an internet connection; and use online services. Students will also learn how to customize forms; work with credit card transactions, work with Asset, Liability and Equity accounts; create and customize reports and graphs; track and pay sales tax; manage payroll, complete job estimates, time tracking and costing; and create customized letters and forms.
During this course, including computer lab time, students will be provided with the information necessary to complete the following objectives:

• Set up a QuickBooks company
• Work with company lists
• Set up and work with inventory lists
• Set up QuickBooks to help you sell your products
• Create customer invoices and billing statements
• Receive payments from customers
• Perform bank transactions
• Enter bills into accounts payable
• Pay bills
• Conduct online banking services
• Customize forms
• Work with credit card transactions
• Work with Asset, Liability and Equity accounts
• Create and customize reports and graphs
• Track and pay sales tax
• Manage payroll
• Complete job estimates, time tracking and costing
• Create customized letters and forms
• Synchronize QuickBooks with Microsoft Outlook.

Excel advanced MX-002 15 hours (5 sessions)
Building on your knowledge of Microsoft Excel, our expert level class teaches you the new features and functions of the latest version.

• Creating Charts
• Embedded Charts
• Chart Types
• Add/Del Chart Item
• Move/Size Chart Item
• Formatting Numbers
• Formatting Charts
• Printing Chart Sheet
• Add Graphic Objects
• Format Objects
• Single-Level Sorting
• Multiple-Level Sorting
• Sorting Options
• Design Considerations
• Filtering Data
• Multiple-Condition Criteria
• Filtered Lists
• DB Functions
• External Databases

Classes Expectation 

• Attendance and active participation is required. Each student is expected to attend every class session on a regular and punctual basis in order to obtain the educational benefits of each class.
• In the event of a student’s absence from a test, the instructor shall be sole judge of the validity of the student’s excuse and may grant or deny an opportunity to make up the work, which was missed.
• Lack of preparation shall no be accepted as an excuse for missing a final examination. The privilege of taking a make up final examination is not extended beyond two weeks from the original date of examination.
• The user of cellular phones, beepers or other related technology is forbidden in the classrooms.
• Do not enter the classroom while the class is in session and do not leave the classroom while a class is in session unless it is an emergency. Walking in and out of the classes is rude and disruptive.
• Use of foul language or profanity is absolutely prohibited in the classroom. Failure to observe this rule is ground for suspension or dismissal.
• Ask questions
• Stay current
• Actively participate in class discussions
• Complete the home assignments
• Attend all the classes
• Obtain class notes and homework if a class is missed
• Use the library to obtain supplementary material that explain an unclear topic
• Prepare for exams
• Seek tutorial assistance, if required