USSMC Information Solutions Schedule 70

 

USSMC GSA Help Desk: 1-301-322-2247

For questions, E-Mail: ussmc1@ussmc.com

USSMC Corporation, 9701 Apollo Dr, Suite 200,

Largo, MD 20774

www.ussmc.com

 

 

 

 

 

 

 

 

 

 

Customer Success Is Our Mission

 

As America builds new models of government, Federal agencies depend increasingly on leading-edge IT solutions to fulfill evolving mission objectives. USSMC Information Solutions understands government s most difficult challenges. We deliver innovative IT solutions that empower agencies to exceed mission requirements. We embrace each agency s vision and provide the IT foundation that enables mission success.

 

 

Table of Contents

 

 

I. Information for Procurement offices. 2

II. USSMC Schedule 70 Products and Services. 4

A. Special Item Number 132-33 Perpetual Software Licenses. 4

B. SIN 132-34 Maintenance of Software. 5

C. SIN 132-50 - Training Courses for Information Technology Equipment and Software (FPDS Code U012) 6

DESKTOP APPLICATIONS. 6

TECHNICAL APPLICATIONS. 32

D. SIN 132-51 - Information TECHNOLOGY (IT) PROFESSIONAL SERVICES. 82

E. SIN 132-52- Electronic Commerce Services. 86

III. USSMC Products and Services Price List 88

A. 132-33: Perpetual Software License. 88

B. 132-34: Maintenance of General Purpose Commercial Information Technology Software. 88

C. 132-50: Training. 89

USSMC Government-site Training Hourly Labor Cost 89

USSMC Site Training Hourly Labor Cost 89

USSMC Government-site Training Course Price List 89

USSMC site and Online Training Course Price List 91

D. 132-51: Professional Information Technology Services. 92

USSMC Government Site Hourly Labor Rate, SIN 132-51. 93

IT Professional Services. 93

USSMC Site Hourly Labor Rate, SIN 132-51. 93

IT Professional Services. 93

E. 132-52: Electronic Commerce Services. 94

USSMC Government-site Hourly Labor Rate, SIN 132-52 Ecommerce Services. 94

USSMC Site Hourly Labor Rate, SIN 132-52 Ecommerce Services. 95

 

I. Information for Procurement offices

 

1. Special Item Numbers and Category Code:

132-33: Perpetual Software License

FSC Class 7030-Information Technology Software

132-34: Maintenance of General Purpose Commercial Information Technology Software

132-50: Training

FSC CLASS D399

132-51: Professional Information Technology Services

FSC CLASS D301 - Resources and Facilities Management

FSC CLASS D302 - Database Planning and Design

FSC CLASS D306 - Systems Analysis and Design

FSC CLASS D308-1 - Programming

FSC CLASS D311 - Conversion and Implementation Support

FSC CLASS D316 - Network Services Project Management

FSC CLASS D317 - Data/Records Management

132-52: Electronic Commerce Services

FPDS CLASS D399- Other Information Technology Services, Not Elsewhere Classified

 

2. Maximum Order: The maximum task order limit is $500,000.However, agencies may place, and USSMC may honor, orders exceeding this limit in accordance with FAR 8- 404. Ordering agencies are encouraged to seek price reductions for orders in excess of $500,000.

 

3. Minimum order: The minimum order value is $100.

 

4. Geographic Coverage (Delivery Area): Domestic and Overseas.

 

5. Point(s) of Production: To be specified in the individual delivery/task order.

 

6. Discount from List Prices or Statement of Net Price: As negotiated and mutually agreed to for each individual delivery /task order.

 

7. Quantity Discounts: As negotiated and mutually agreed to for each individual delivery/task order.

 

8. Prompt Payment Terms: 1% Net 15 days.

 

9. Credit Cards: Government purchase cards are accepted at or below the micro-purchase threshold of $2,500.

 

10. Foreign Items: None.

 

11. Time of Delivery: As negotiated and mutually agreed upon for each individual delivery/task order.

Urgent Requirements: For bona fide urgent requirements, agencies are encouraged to contact USSMC to obtain accelerated delivery. USSMC shall reply to the inquiry within 3 workdays after receipt. (USSMC shall confirm telephone replies in writing.) If USSMC offers an accelerated delivery time acceptable to the ordering agency, any order(s) placed pursuant to the agreed upon accelerated delivery timeframe shall be delivered within this shorter delivery time, and in accordance with all the other terms and conditions of the contract.

 

12. F.O.B. Point: Destination.

 

13. Ordering Address:

USSMC Corporation

9701 Apollo Drive, Suite 200

Largo, MD 20774

Attn: GSA Contract Administrator

Phone: 1-301-322-2247

Fax: 301-322-8761

E-mail: ussmc1@USSMC.com

Or, as specified on individual task proposal.

 

14. Warranty provision: USSMC s services will be performed by competent personnel with pertinent experience in the field of Information Technology. No warranty for data that is licensed, or has been provided at no charge, shall be provided other than that it is the data as used by USSMC and corrections will be provided to the extent they are available. The warranties expressed herein are in lieu of all other warranties, expressed or implied, including, but not limited to, warranties of merchantability or fitness for a particular purpose. This warranty excludes consequential and indirect damages.

 

15. Section 508. Compliance information is available on Electronic and Information Technology (EIT) supplies and services. The EIT standards can be found at:

www.Section508.gov.

 

16. Data Universal Numbering System (DUNS)

Number: Specific DUNS Numbers will be provided for each individual delivery/task order.

Contract Number GS-35F-0897P

 

17. Central Contractor Registration (CCR): USSMC is registered with CCR.

 

 

II. USSMC Schedule 70 Products and Services

 

A. Special Item Number 132-33 Perpetual Software Licenses

 

FSC CLASS 7030 - INFORMATION TECHNOLOGY SOFTWARE

Large Scale Computers

Operating System Software
Application Software
Electronic Commerce (EC) Software
Utility Software
Communications Software
Core Financial Management Software
Ancillary Financial Systems Software
Special Physical, Visual, Speech, and Hearing Aid Software

Microcomputers

Operating System Software
Application Software
Electronic Commerce (EC) Software
Utility Software
Communications Software
Core Financial Management Software
Ancillary Financial Systems Software
Special Physical, Visual, Speech, and Hearing Aid Software

USSMC EEO Tracking System is an enterprise level web-based thin client application. This is designed to be the simplest, most powerful system on the market that effectively monitors workflow and EEO complaint-related issues and bases.

 

USSMC licenses its EEO Tracking System (or any other USSMC custom-designed web based tracking system) as a perpetual license (132-33) for the life of that version number, with additional charges for maintenance and customization (132-34), plus training and on-site database administration (132-51). When a new version of the software becomes available with a different interface, new information, and/or more features, then a new set of perpetual licenses will be applied and the customer must purchase this new license.

 

USSMC s EEO and Workflow Software is usually used in conjunction with a consulting assignment. Because USSMC provides a multi-faceted EEO solution, the software includes an ongoing query and trigger alert system, database and report tool and processes plus extensive features and interoperability.

 

 

USSMC EEO Tracking System features include:

 

  • EEOC MD 110 and MD 715 compliant;
  • Section 508-Compliant;
  • Complete Online Form Solution;
  • Platform Independent Solution (Windows or UNIX)
  • Broad Database Compatibility, including SQL, ORACLE, or any ODBC database system;
  • Browser based interface very thin client
  • Low system maintenance requirements;
  • An easy to use system administration module;
  • Developed using internet standards for PHP
  • Built in Help Assistance Component
  • An online training module for use training.
  • Knowledge Management Component

 

Application Features:

        Complete Level Browser Based Application

        EEO Form 462

        Section 508 Compliant

        Platform Independent

        Developed for Secure Environment

        SSL Encrypted

 

Project Workflow Capability Feature includes:

 

        Tracks workflow processes and document control

        Tracks staff assignment, project responsibility and timelines

        Tracks travel logistics

        Tracks budget allocation and expenses

 

B. SIN 132-34 Maintenance of Software

Support Services are billed and made available through support contracts in blocks of 60 hours or more at a cost of $100.00 per hour. Support Services are also available on time available basis without an active support contract at a rate of $125.00 per hour.

 

All products, maintenance, and support services are subject to the terms and conditions of USSMC standard license agreements and the provisions of GSA Federal Supply Schedule. USSMC travel and expenses are billed at actual cost or at then current federal travel guidelines whichever are the lesser. Labor rates for professional services such as custom development, conversion, project management and consulting are also available. (Any costs for customizations are not included in the calculation of the yearly maintenance fee.)

 

C. SIN 132-50 - Training Courses for Information Technology Equipment and Software (FPDS Code U012)

 

Training Manager

 

Minimum/General Experience: 10 yrs., Bachelors Degree or equivalent. Functional Responsibilities: Serves as a senior level training representative responsible for all aspects of program management including work standards, schedules, personnel supervision, cost, technical and contract performance. Designs classroom training infrastructure for IT related courses and incorporates the latest IT technology via wireless and remote access training.

 

Training Specialist

 

Minimum/General Experience: Bachelor s Degree or equivalent and 2 years of general experience. Six (6) years of general experience is considered equivalent to a Bachelor s Degree. With a Masters degree no experience is required. Functional Responsibilities: Develops and revises these IT related courses and prepares appropriate training catalogs. Prepares instructor materials (course outline, background material, and training aids). Prepares student materials (course manuals, workbooks, handouts, completion certificates, and course critique forms). Trains personnel by conducting formal classroom courses, workshops and seminars.

 

 

DESKTOP APPLICATIONS

 

Database Administration Applications

 

Access 2000: Level 1

 

Prerequisites: Windows 95 or equivalent knowledge.

 

Overview: Participants will learn the basic skills necessary to begin using Access 2000. They will design and create databases, tables, queries, forms, and reports.

Objectives:

  • Understand database concepts and terminology in Access 2000.
  • Design and create tables.
  • Enter and manipulate data in tables.
  • Use Access queries to select and analyze information in a table.
  • Create data forms for viewing and inputting data.
  • Create reports that summarize and group data.
  • Perform database maintenance procedures.

 

Approximate Duration: 8 Hours

 

 

 

Access 2000: Level 2

 

Prerequisites: Access 2000 Level 1 or equivalent knowledge

 

Overview: Participants will learn how to enhance their database designs by using the principles of normalization and table relationships. Participants also learn how to query multiple tables for data that is used in customized forms and reports.

Objectives:

  • Normalize sample tables by identifying design problems.
  • Establish relationships between tables by analyzing table relationships and enforcing referential integrity.
  • Customize table designs by setting field properties to maintain data integrity and creating indexes.
  • Design select queries by using multiple tables to calculate, group, average, and to show top values.
  • Customize form designs by creating calculated fields, combo boxes, and unbound controls.
  • Interact with data through a browser by creating and using data access pages.
  • Customize report designs by grouping, sorting, and summarizing data, and by adding sub-reports.

 

Approximate Duration: 8 Hours

 

 

Access 2000: Advanced

 

Prerequisites: Access 2000 Level 1 and Access 2000 Level 2 or equivalent knowledge.

 

Overview: Participants will learn how to use a variety of complex query techniques, create more efficient forms and reports, and create and use macros to automate their forms. In addition, participants will gain experience with Internet-related features, including hyperlinks and the Web toolbar.

 

Objectives:

  • Make select queries more versatile and useful by using parameters; use action queries to update data values and add or delete records.
  • Generate different query types by creating various types of joins between tables; use cross tab queries to summarize data.
  • Use advanced form feat including properties, functions, and design tools to facilitate data entry and improve accuracy in forms; display table information that has a one-to-many relationship by creating forms that contain sub forms.
  • Automate tasks by creating macros to open forms and control form properties.
  • Make forms more functional by using macros to provide user interaction and automate data entry.
  • Make reports more concise and easier to understand by using properties and functions in report controls; create mailing labels.
  • Use Internet-related ACCE tools by inserting hyperlinks and using the Web toolbar.

 

Approximate Duration: 8 Hours

 

 

SPSS 10.5: Introduction

 

Prerequisites: Windows 95 or equivalent knowledge and basic statistics

 

Overview: Participants will learn the SPSS 10.5 basics, working with data in datasheet

through statistical analysis

 

Objectives:

Understand the advantage of the code-free statistical analysis tool

Create basic datasheets and data files, define variables

Enter the string and value of each variable

Copy, cut and paste data, transform variables

Read files from external, including SPSS files and Excel files

Perform data analysis, conduct hypothesis test on data

Read, edit and print output

 

Approximate Duration: 8 Hours

 

 

SPSS 10.5: Advanced

 

Prerequisites: SPSS introduction or equivalent knowledge, intermediate level statistics courses

 

Overview: Participants will learn how to perform linear regression, analysis of variance, parametric and nonparametric sample tests

 

Objectives:

Conduct analysis of variance (one way ANOVA)

Perform linear regression analysis

Create logistic regression model

Understand and explain correlation

Decide sample type and conduct appropriate analysis- nonparametric or parametric, independent or related

 

Approximate Duration: 8 Hours

 

 

Paradox 9.0: Advanced

 

Prerequisites: Paradox 9 Introduction or equivalent knowledge.

 

Overview: Participants will learn to structure tables properly, use the principles of data normalization and table relationships, enable data-entry accuracy, use queries effectively, and enhance form and report designs to present data effectively.

 

Objectives:

  • Work with keyed tables by structuring them properly and by creating secondary indexes.
  • Organize tables in a database by following data-normalization rules.
  • Classify tables by determining the types of relationships they have, and create relationships between tables by linking arid establishing referential integrity.
  • Increase the accuracy of data entry by specifying validity checks and creating lookup tables. Manipulate data in tables by using queries to search for special characters, update multiple records, and link tables.
  • Create custom forms that use memo fields, calculated fields, and combo boxes.
  • Create custom tabular reports by changing a style sheet, defining a table frame object, adding enhancements to improve the report appearance, and using page layout and print settings.

 

Approximate Duration: 8 Hours

 

 

 

Graphics and Publishing

 

 

Adobe Illustrator 7.0: Introduction

 

Prerequisites: Windows 95 or equivalent knowledge.

 

Overview: Participants will become comfortable with the interface & tools of Adobe Illustrator 8.0. Demonstrations will cover example projects, printing, layering, and basic type.

Objectives:

  • Use the Work Area: the toolbox, palettes, views, guides, and zooming
  • Use basic shapes
  • Use painting attributes
  • Create and use layers
  • Work with type

 

Approximate Duration: 8 Hours

 

 

 

Adobe Illustrator 7.0: Intermediate

 

Prerequisites: Adobe Illustrator 7.0 Introduction or equivalent knowledge.

 

Overview: Participants will learn editing and drawing features as well as complex airbrushing effects and color control to increase their skill level.

 

Objectives:

  • Drawing with the pen tool
  • Working with brushes
  • Transforming objects
  • Blending shapes and colors
  • Using the gradient mesh tool
  • Using and refining compound paths
  • Masking

 

Approximate Duration: 8 Hours

 

 

 

Adobe Illustrator 7.0: Advanced

 

Prerequisites: Adobe Illustrator 7.0 Intermediate or equivalent knowledge

 

Overview: Participants will learn advanced user skills of Illustrator.

 

Objectives:

  • Defining graphic formats
  • Importing and exporting formats
  • Tracing raster images
  • Creating patterns
  • Applying patterns
  • Using elements in multiple documents
  • Enhancing performance
  • Setting display type
  • Importing text
  • Cleanup Command
  • Banding with gradients and blends
  • Defining and using trapping
  • Printing separations

 

Approximate Duration: 8 hours

 

 

 

Adobe PageMaker 6.5: Basics

 

Prerequisites: Windows 95 or Equivalent knowledge

 

Overview: Participants will learn the basic skills necessary to use the PageMaker for Windows program.

 

Objectives:

  • Identifying PageMaker environment elements
  • Navigating in PageMaker
  • Setting up a document
  • Saving a document
  • Creating multi-page documents
  • Using master pages
  • Creating frames
  • Placing text within frames
  • Formatting characters and paragraphs
  • Importing graphics
  • Wrapping text
  • Printing documents

 

Approximate Duration: 8 Hours

 

 

 

Adobe PageMaker 6.5: Type Design

 

Prerequisites: Adobe PageMaker 6.5: Basics or equivalent knowledge.

Overview: Participants will learn the fundamentals of type design to use the appropriate tools of the PageMaker for Windows program.

Objectives:

  • Using preferences
  • Creating automatic page numbers
  • Applying styles
  • Basing one style on another
  • Typing and importing text into a table
  • Formatting tables
  • Checking spelling
  • Changing text
  • Choosing type faces
  • Using paragraph spacing
  • Using different type effects
  • Marking text
  • Creating a table of contents

 

Approximate Duration: 8 Hours

 

 

 

Adobe PageMaker 6.5: Production 1

 

Prerequisites: Adobe PageMaker 6.5 Type Design or equivalent knowledge.

 

Overview: Participants will learn the basic skills of production techniques to use the PageMaker for Windows program.

 

Objectives:

  • Using the grid manager plug-in
  • Using frames in templates
  • Using text and graphics in a template
  • Drawing and manipulating graphics
  • Understanding colors
  • Applying colors
  • Using vector and raster graphics
  • Using contrast and halftones
  • Linking graphics
  • Printing color separations and proofs
  • Building a booklet

 

Approximate Duration: 8 Hours

 

 

 

Adobe PageMaker 6.5: Production 2

 

Prerequisites: Adobe PageMaker 6.5 Production 1 or equivalent knowledge.

 

Overview: Participants will learn advanced skills of production techniques to use the PageMaker for Windows pro

 

Objectives:

  • Structuring a document
  • Transforming graphics
  • Setting up and using a color management system
  • Performing traps
  • Using printer styles
  • Understanding electronic publishing
  • Creating hyperlinks
  • Exporting PDF files
  • Printing PDF files
  • Modifying publications for HTML
  • Exporting to HTML

 

Approximate Duration: 8 Hours

 

 

 

CorelDRAW 9.0: Introduction

 

Prerequisites: Windows 95 or Equivalent knowledge.

 

Overview: Participants will learn how to get started, use the basic tools, and apply it to various drawings.

 

Objectives:

  • Open, close, switch between, and save CorelDRAW documents.
  • Use various techniques to zoom and move around objects.
  • Customize and insert/delete pages.
  • Move, copy, clone, delete, and size objects.
  • Draw lines, polylines, polygons, rectangles, and circles.
  • Use the Shape tool to reshape curves and lines.
  • Group, ungroup, use guidelines, snaps, and align objects with each other.
  • Work with Artistic and Paragraph text.
  • Assign outlines and special fills to objects.
  • Incorporate symbols and clip into the document.
  • Mirror, rate, skew, and size using the Transformation docker.
  • Fit text to path and draw with the Artistic Media tool.
  • Apply Lens, Perspective, PowerClips Presets, and Drop Shadow special effects.
  • Export objects into other Window applications.
  • Print and choose print option.

 

Approximate Duration: 16 Hours

 

 

 

CorelDRAW 9.0: Advanced

 

Prerequisites: CorelDraw 9.0 Introduction or equivalent knowledge.

 

Overview: This course explores beyond the basics of CorelDRAW and looks at the advanced features of DRAW (60%), Trace (10%), and Photo-Paint (30%).

 

Objectives:

  • Implement customized options such as workspaces, adding buttons, shortcut keys, set document defaults, and use file backups.
  • Work with paragraph text by importing, flowing, formatting, wrapping objects around, and applying drop caps.
  • Create special text by converting to curves, blending, and using drop shadows.
  • Create jumpy text, chrome; text, bevel text, and enveloped text.
  • Create a greeting card and labels.
  • Use group and child objects.
  • Incorporate combining, welding, trimming, and intersection.
  • Learn about using multiple layers.
  • Incorporate text and graphic styles, and save a custom template.
  • Implement interactive fills, distortions, transparency, and mesh fills.
  • Create custom patterns, symbols, and scripts.
  • Work with bitmaps by adjusting color, importing, applying special effects, and creating Web Images using CorelDRAW.
  • Learn how to trace images using Corel Trace.
  • Work with Corel Photo-Paint to learn the basics of color adjustment, special effects, and text effects.
  • Publish to PDF and the Internet.

 

Approximate Duration: 16 Hours

 

 

 

Internet Browser Applications

 

Internet Explorer 5.0: Introduction

 

Prerequisites: Windows 95 or equivalent knowledge.

 

Overview: Participants will learn how to find and use information on the Internet.

 

Objectives:

  • Describe the software and hardware required to connect to the Internet, and identify the main components of the Internet Explorer 5.0 window.
  • Find Web sites that contain useful information, and use Favorites to maintain links to particularly useful sites.
  • Use Internet Explorer s Help system to get information about how to browse more efficiently and effectively.
  • Use Outlook Express to send and receive email, as well as to participate in newsgroup discussions.
  • Download and unzip zipped files from the Internet, and browse and use files from an FTP site.
  • Use the Internet Options dialog box to specify a home, control History, and change settings for temporary Internet files.

        Personalize the MSN home page, and identify other candidates to be used as a home page.

 

Approximate Duration: 8 Hours

 

 

 

Netscape Navigator 3.0: Introduction

 

Prerequisites: Windows 95 or equivalent knowledge.

 

Overview: Participants will obtain an overview of connecting to and navigating within the Internet and World Wide Web in the Windows environment.

 

Objectives:

  • Explore the basics of the Internet: its history, structure, resources, functionality, addressing schemes, and connection requirements.
  • Connect to the Internet via Netscape 3.0.
  • Explore the World Wide Web using Netscape.
  • Find specific information on the Internet using Gopher, Veronica, Jughead, FTP, Archie, and Web search engine
  • Download files from FTP sites.
  • Communicate with others using email, mailing lists, and newsgroups.
  • Access resources for new Internet users including FAQs, RFCs, new-user Web pages, Web page repositories, and security tips.
  • Create a PowerStart Page to help simplify accessing the Internet.
  • Create own Web page using HTML language.

 

Approximate Duration: 8 Hours

 

 

 

Personal Information Management Applications

 

 

 

Outlook 2000: Level 1

 

Prerequisites: Windows 95 or equivalent knowledge.

 

Overview: Participants will learn the fundamentals of using Outlook 2000 to coordinate mail, appointments, events, meetings tasks, and contacts.

 

Objectives:

  • Identify the Outlook 2000 interface.
  • 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.
  • Create, send, and manage meeting requests.
  • Create, edit, assign, and track tasks, and create and edit contacts.

 

Approximate Duration: 8 Hours

 

 

 

Outlook 2000: Level 2

 

Prerequisites: Outlook 2000 Level 1 or equivalent knowledge.

 

Overview: Participants will learn how to sort, filter, and group items; use and create Outlook templates and forms; and share information by using public folders and Net Folders. Participants will also learn how to share and fax contacts, automatically record activities in the Journal, and customize the Outlook environment.

 

Objectives:

  • Manage and arrange Outlook items by sorting, filtering, and using the Find feature; and by displaying custom views and creating custom forms.
  • Share information with other Outlook users by creating, posting to, replying to, and editing posts in public folders; creating and posting to Net Folders; and granting other Outlook users folder permissions.
  • Communicate with contacts by sending faxes, sharing contacts with other users, and organizing contacts and notes.
  • Automatically record items associate with contacts in the Journal by setting options in the Options dialog box.
  • Integrate Outlook98 with Office applications by importing and exporting Office documents and creating an Office document in Outlook.
  • Customize the Outlook environment by creating custom toolbars and menu items to add to the Outlook Bar.
  • Investigate Internet and remote mail features by creating HTML documents, adding hyperlinks, and discussing the Outlook Newsreader and remote mail options.

 

Approximate Duration: 8 Hours

 

 

 

Outlook 2000: Advanced

 

Prerequisites: Windows 95, Outlook 2000 Level 1, Outlook 2000 Level 2, or equivalent knowledge.

 

Overview: Participants will learn how to use some advanced features in Outlook, including managing and customizing their mail environment, customizing Calendar options, communicating over the Internet by using the Calendar, managing contacts and tasks, and working offline and with Newsreader.

 

Objectives:

  • Manage and customize their mail environment by creating stationery and archiving mail messages.
  • Become familiar with some of Outlook s advanced mail features, including importing a vCard file, creating a Personal Address Book, and sending and receiving a fax.
  • Customize Calendar option and share Calendar information with other users.
  • Use the Calendar to communicate with others over the Internet.
  • Manage contacts and tasks by flagging and exporting contacts and organizing tasks by category.
  • Work offline, including creating a quick synchronization group and synchronizing by message size, and familiarize themselves with the steps necessary for setting up Newsreader and sending arid receiving information through Newsreader.

 

Approximate Duration: 8 Hours

 

 

 

Operating Systems

 

 

Linux: Workstation

 

Prerequisites: Windows 95 or equivalent knowledge.

 

Overview: Participants will learn what Linux is, how to perform a workstation install, and some basic commands.

 

Objectives:

  • Trace the history and development of Linux.
  • Gather hardware and network information required for installation.
  • Install Red Hat Linux 6.0 using the workstation class.
  • Log in and use basic commands.
  • Create and configure user accounts.
  • Mount file systems and move around the file system s directory structure.
  • Manage the file system.
  • Set permissions files and directories. Create files using editors and redirections, and then print the files.
  • Use the X Window environment.
  • Shut down, restart, and configure the startup of your Linux system.

 

Approximate Duration: 16 hours

 

 

 

Windows NT Workstation 4.0: Orientation

 

Prerequisites: None. However, a basic working knowledge of PC-compatible systems is recommended.

 

Overview: Participants will learn the benefits of working with personal computers and of using Windows NT Workstation.

 

Objectives:

  • Identify some fundamental personal computing concepts and terminology, such as hardware components and software; examine and identify components of the Windows NT Workstation 4.0 screen; select items with the mouse; and access Windows NT Workstation features by using the Start button
  • Work with windows by using buttons and dragging techniques; work with multiple programs by using the taskbar to switch between and tile windows; observe the contents of a hard disk by using the My Computer icon; and access a disk quickly by creating a desktop shortcut.
  • Become accustomed to common Windows NT Workstation program techniques by experimenting with WordPad.
  • Display the contents of disks by using the Windows NT Explorer; create a folder by using the shortcut menu; copy and move documents and folders by dragging them; and sort and locate documents by using the Windows NT Explorer.
  • Prepare a disk for use by using the Format command; copy and move groups of documents; delete and restore documents by using the Recycle Bin.
  • Share data between programs by using the Edit, Copy and Edit, Paste commands.
  • Identify some fundamental c and terminology of computer networks; observe shared resources by using the Network Neighborhood icon; access shared data; and connect to a remote printer.
  • Customize the appearance of your Windows NT Workstation desktop; exit Windows NT Workstation by using the Shut Down command.

 

Approximate Duration: 8 Hours

 

 

 

Windows XP: Introduction

 

Prerequisites: None. However, a basic working knowledge of PC-compatible systems is recommended.

 

Overview: Participants will learn computer, network, and Internet basics. In addition, they will learn how to use the Windows XP environment to locate and manage information, to work with Windows XP programs, to customize the desktop, and to access and browse the Web.

Objectives:

  • Use fundamental personal computing concepts and terminology
  • Work with Windows XP desktop objects and windows
  • Navigate to information stored on their computer
  • Use Windows Explorer to manage files and folders
  • Use common Windows 93 program techniques by working with WordPad and Paint
  • Customize the Windows 8 desktop to best suit their needs
  • Access the Internet and use the basic functions of the Internet Explorer environment

 

Approximate Duration: 8 Hours

 

 

 

Windows 2000: Introduction

 

Prerequisites: None. However a basic working knowledge of PC-compatible systems is recommended

 

Overview: Participants will learn basic computer concepts and skills related to IBM and compatible computers. Participants will receive a thorough introduction to the domain environment. In addition, they will learn Windows 2000 techniques and become acquainted with applications.

 

Objectives:

  • Log on to Windows 2000, shut down and restart the operating system, and work with desktop objects and window.
  • Navigate to information stored on the computer.
  • Use Windows Explorer to m files and folders.
  • Use common Windows 2000 program techniques by working with WordPad and Paint.
  • Customize the Windows 2000 desktop to best suit your needs.
  • Use My Network Places to browse the network and view connections; use the Active Directory to browse and search shared folders; activate the Offline Files feature, make changes to a file, and then save the copies on the domain and their computers.
  • Manage and administer the workstation by using the Microsoft Management Console, the Control Panel, and the NTFS used in Windows 2000.

 

Approximate Duration: 8 Hours

 

 

 

Windows 2000: Transition from Windows 98

 

Prerequisites: Windows 98 or equivalent knowledge

 

Overview: Participants will learn how to get started in the secure Windows 2000 environment, usability improvements, the use of My Network Places and the Active Directory, and the management and administration of the workstation. In general, they will learn how to apply their knowledge of Windows 98 in order to use Windows 2000 efficiently.

 

Objectives:

  • Describe the differences between Windows 98 and Windows 2000; log on to Windows 2000; and shut down and restart the operating system.
  • Identify changes to the Windows 2000 user interface, including those on the desktop, the taskbar, the Start menu, and within Windows Explorer; and identify new features such as the Search feature, the Help feature, and Windows 2000 programs.
  • Use My Network Places to browse the network and view connections; use the Active Directory to browse and search shared folders; activate the Offline Files feature, make changes to a file, and then synchronize the copies on the domain and your computer.
  • Manage and administer the workstation by using the Microsoft Management Console, new features of the Control Panel, and the NTFS file system used in Windows 2000.

 

Approximate Duration: 40 Hours

 

 

 

Unix: Introduction Level 1

 

Prerequisites: None. However, a basic working knowledge of PC-compatible systems is recommended

 

Overview: Participants will learn how to log in and out of UNIX, use the Mail utility and Talk utility, use the UNIX filing system, manage files, secure files and directories, create new utilities, work with the vi editor, and write shell scripts.

 

Objectives:

  • Understand the basic feature available in UNIX, and briefly understand its history and evolution. Log in and log out change their password, and understand some basic UNIX commands and the UNIX command syntax: command-option argument.
  • Use the mail utility and the t utility.
  • Understand full paths, partial paths, current working directory, and the concept of home directory.
  • Create directories, copy and move files, and remove files and directories.
  • Secure files and directories y the use of permissions.
  • Combine several UNIX utilities to create new utilities that accomplish specific tasks.
  • Create and edit a vi file.
  • Create custom commands that can run from the prompt.

 

Approximate Duration: 16 Hours

 

 

 

Unix: Introduction Level II

 

Prerequisites: Unix: Introduction Level 1 or equivalent knowledge

 

Overview: Participants will learn about the UNIX user environment, the components of the user interface, and how they can he modified to create a custom interface. In addition, participants will learn several advanced file management techniques and how to use the find, grep, and egrep commands. Participants also learn to create custom reports from database files by using the tr, sed, and awk programs.

 

Objectives:

  • Explore the different UNIX shells available, such as the Bourne, C, and Korn Shells.
  • Work with a user-defined interface, and modify existing files and create files that customize their user interface.
  • Use the alias command, assign an alternate name to a command, and create user-defined commands.
  • Understand the components that comprise the C-Shell history feature, and perform a complete installation of the history program by modifying and adding the necessary commands and assignments.
  • Determine their user and terminal status use commands to determine who else is on a system and some of their system attributes, and determine the location of commands that are available to users.
  • Use multi-tasking to manage processes.
  • Use the find command to search for files and directories that meet a criterion defined by them. Use file compression and restoration, the tar command, and the pr and lpr commands.
  • Use the tr, sed, and awk commands to modify and manage file contents, to create files, or to output stream.

 

  • Approximate Duration: 16 hours

 

 

 

Presentation Applications

 

.

Corel Presentation 9.0: Introduction

 

Prerequisites: Windows 95 or equivalent knowledge.

 

Overview: Participants will learn the basic skills necessary to begin creating effective slide shows in Corel Presentation 9.0.

 

Objectives:

  • Identify on-screen features and navigate in a slide show.
  • Create and edit bullet slides, and use the Perfect Expert to create a slide show.
  • Use drawing tools, incorporate Clipart and use TextArt to create slides.
  • Create and edit bar graphs.
  • Change the overall appearance of slide show by adding a new master and themes, and editing the templates.
  • Run a slide show and become familiar with slide show options such as transitions and object animation.
  • Add speaker notes, examine print options, and save a slide show in HTML format.

 

Approximate Duration: 8 Hours

 

 

 

PowerPoint 2000: Introduction

 

Prerequisites: Windows 95 or equivalent knowledge.

 

Overview: Participants will learn the PowerPoint 2000 basics, working with slides, drawing, graphics, and techniques necessary to effectively create presentations.

 

Objectives:

  • Start the PowerPoint program, identify on-screen features, and navigate through a presentation.
  • Create and edit bullet slides.
  • Use PowerPoint s drawing tools to create a slide.
  • Incorporate clip art and WordArt objects in a slide.
  • Create and enhance organization charts, and create and edits charts by using Microsoft Graph.
  • Change the overall appearance of a presentation by using design templates and the Slide Master.
  • Run a slide show, become familiar with slide show options, and add notes to a slide.
  • Preview and save a PowerPoint presentation as a Web page and open a locally stored presentation in Internet Explorer

 

Approximate Duration: 8 Hours

 

 

 

PowerPoint 2000: Advanced

 

Prerequisites: PowerPoint 2001 Introduction or equivalent knowledge

 

Overview: Participants will learn how to enhance a presentation by using custom clip art, and movies and work with embedded and imported objects by using Microsoft applications.

 

Objectives:

  • Create a custom template by selecting a color scheme, background fill, fonts and clip art.
  • Enhance a presentation by using custom clip art, animation, and movies.
  • Work with embedded and imported objects by using Microsoft applications.
  • Customize the PowerPoint environment by modifying toolbars and using the Options dialog box.
  • Build interactive presentation by creating hyperlinks and action buttons and create custom slide shows.
  • Become familiar with collaboration features by creating online meetings and broadcast presentations

 

Approximate Duration: 8 Hours

 

 

Project Management Applications

.

 

Microsoft Project 2000: Level 1

 

Prerequisites: Windows 95 or equivalent knowledge. Participants should have some project management experience and be familiar with terms such as Gantt Chart, PERT Chart, task, critical path, and resource.

 

Overview: Participants will know to use Microsoft Project 2000 to enter and keep track of project details.

 

Objectives:

  • Identify the steps involved in project planning and become familiar with project management software by learning how to use the Microsoft Project 2000 desktop.
  • Build a project Work Breakdown Structure by entering project tasks, creating an outline, and entering task durations.
  • Create and modify task relationships by linking tasks and attaching task constraints.
  • Staff a project by creating a company calendar, entering the resource pool into the Resource Sheet, assigning resources to tasks, and entering resource costs using the cost table.
  • Work with different views and tables by customizing the Calendar View, formatting the Gantt Chart, and modifying standard, default tables.
  • Resolve time and resource conflicts by shortening the length of a project s critical path and using the Level Now command.
  • Sort and filter project date effectively by sorting data in a sheet using the Sort dialog box and by viewing the data that meets specific criteria using filters.

 

Approximate Duration: 8 Hours

 

 

 

Microsoft Project 2000: Level 2

 

Prerequisites: Microsoft Project 2000: Creating a Project, or equivalent knowledge.

 

Overview: Participants will learn how to use Microsoft Project 2000 to manage a project plan after the project has begun.

 

Objectives:

  • Create a baseline plan
  • Track an active project
  • Manage future tasks
  • Work with resource scheduling
  • Consolidate projects
  • Work with data in other applications
  • Create, edit, and add hyperlinks to HTML files
  • Modify the Microsoft Project environment

 

Approximate Duration: 8 Hours

 

 

 

Spreadsheet Applications

 

 

Excel 2000: Worksheets

 

Prerequisites: Windows 95 or equivalent knowledge.

 

Overview: Participants will learn basic worksheets skills and how to work with data in worksheets.

 

Objectives:

  • Understand the disadvantage of paper spreadsheets and the advantages of electronic spreadsheets by exploring both.
  • Create a basic worksheet by entering text, values, and formulas.
  • Create formulas by using Excel s built-in functions.
  • Move a copy data by using shortcut menus, drag-and-drop editing, and toolbar buttons.
  • Change the appearance of worksheet data by using a variety of formatting techniques.
  • Prepare a document for printing by using the spell checking feature and a variety of printing options.
  • Use the three-dimensional aspect of the Excel workbook environment by creating formulas that refer to cells on multiple worksheets.
  • Save an Excel Workbook as a Web Page

 

Approximate Duration: 8 Hours

 

 

 

Excel 2000: Charting and Organizing Data

 

Prerequisites: Excel 2000 Worksheets or equivalent knowledge.

 

Overview: Participants will learn the skills and concepts necessary to create charts and to use the fist-management capabilities of Excel 2000.

 

Objectives:

  • Create charts that graphically represent worksheet data.
  • Modify charts.
  • Customize charts by applying formatting.
  • Enhance worksheets and charts by using the drawing tools to add graphic objects.
  • Sort information in a list by using the Data, Sort command.
  • Locate information quickly in a list that meets specified conditions by using the advanced filter feature.

 

Approximate Duration: 8 Hour

 

 

 

Excel 2000: Advanced

 

Prerequisites: Excel 2000 Worksheets, Excel 2000 Charting and Organizing Data or equivalent knowledge.

 

Overview: Participants will learn various advanced techniques for analyzing and manipulating data in Excel.

 

Objectives:

  • Customize toolbars and create styles and templates.
  • Create decision-making functions.
  • Analyze worksheet data by creating pivot tables.
  • Compare and contrast workbook files and file links.
  • Outline and consolidate worksheets and analyze worksheet data by using the Scenario Manager.
  • Display and protect worksheet data by locking cells.
  • Record and modify macros by using the Visual Basic Editor.
  • Create and work with interactive Web documents.

 

Approximate Duration: 8 Hours

 

 

 

Quattro Pro 9.0: Spreadsheets

 

Prerequisites: Windows 95 or equivalent knowledge.

 

Overview: Participants will learn how to create, format, and print basic spreadsheets. Participants will become familiar with a number of ways to modify a spreadsheet once it has been created Participants will also become acquainted with the three-dimensional aspects of spreadsheets.

 

Objectives:

  • Understand the basics of the Quattro Pro environment; create a basic spreadsheet by entering text, values, and formulas
  • Modify a spreadsheet; use Quattro Pro s built-in functions.
  • Copy and move spreadsheet data by using drag-and-drop editing, toolbar buttons, and menus.
  • Change the appearance of spreadsheet data by using a variety of formatting techniques.
  • Use absolute addresses, correct circular references, and use the Spell Checker.
  • Prepare a spreadsheet for printing by previewing it and specifying page settings.
  • Use notebooks to create three-dimensional formatting and formulas.

 

Approximate Duration: 8 Hours

 

 

 

Quattro Pro 90: Charts and Databases

 

Prerequisites: Quattro Pro 9.0 Spreadsheets or equivalent knowledge.

 

Overview: Participants will learn how to effectively use charts in Quattro Pro to graphically represent their data. They will also become familiar with the database features of Quattro Pro, which enable them to sort, locate, extract, manipulate, and calculate data, and present it in meaningful reports.

 

Objectives:

  • Use the QuickChart tool to display data graphically.
  • Use the Chart Expert, Chart Gallery, and Chart Advisor to create a chart and change its overall appearance.
  • Enhance the chart display by changing chart object properties, adding data details, and drawing objects on the chart.
  • Create and enhance pie charts and combination charts.
  • Create a map chart, and create and run an automated slideshow presentation.
  • Sort data in a notebook based on one or more columns.
  • Work with spreadsheet data as a database to locate records and groups of records that meet specific criteria.
  • Work with spreadsheet data as a database to extract and manipulate records and groups of records that meet specific criteria.
  • Use data functions to perform calculations and summarize data by creating a Cross Tabs report.

 

Approximate Duration: 8 hours

 

 

 

Web Page Design

 

 

FrontPage 2000: Introduction

 

Prerequisites: Proficiency in any word-processing application, Internet Explorer 5.0 Introduction or equivalent knowledge

 

Overview: Participants will learn how to create documents with an HTML format, connected by hypertext for use on the World Wide Web or on a corporate intranet.

 

Objectives:

  • Distinguish between FrontPage Explorer and FrontPage Editor.
  • Create and edit webs and web pages.
  • Create links between and within web pages.
  • Insert, size, align, and link images.
  • Create, modify, and enhance a table.
  • Create frames by using templates.
  • Use a wizard to create a web.

 

Approximate Duration: 8 Hours

 

 

 

FrontPage 2000: Advanced

 

Prerequisites: Front Page 2000 Introduction or equivalent knowledge.

 

Overview: Participants will learn to use tables, forms, and other advanced features to create sophisticated web sites.

 

Objectives:

  • Use advanced features such as Navigation view, Shared Borders, and themes, to create a coherent and attractive web site
  • Structure a web page by using tables.
  • Create a form on a web page.
  • Add dynamic multimedia components to a web page.
  • Enhance web pages by using Dynamic HTML, cascading style sheets, and by creating Channels.

 

Approximate Duration: 8 Hours

 

 

 

Word Processing Applications

 

 

Word 2000: Level I

 

Prerequisites: Windows 95 or equivalent knowledge

 

Overview: Participants will learn the basic skills necessary to begin using Word 2000 by creating and editing documents using different formatting techniques.

 

Objectives:

  • Create and save a document; open an existing document; and use simple editing techniques.
  • Navigate in a large document by using the mouse and keyboard.
  • Edit a document by using more sophisticated techniques, including moving and copying text within a document and between documents.
  • Apply and remove character and paragraph formatting.
  • Use tabs and create and modify a table structure.
  • Adjust margins, add and delete page breaks, and create headers and footers.
  • Use Word s proofing tools, such as the spelling checker and thesaurus, and print a document, envelope, and labels.
  • Save an existing document as a Web page and preview it in a browser.

 

Approximate Duration: 8 Hours

 

 

 

Word 2000: Level 2

 

Prerequisites: Word 2000 Level 1 or equivalent knowledge.

 

Overview: Participants will learn how to create and control section breaks, tables, merges, styles, templates, macros, aid Web pages

 

Objectives:

  • Use section breaks to format a document and format text in columns.
  • Create, modify, and use tables as page-layout elements and sort table data.
  • Merge a document with data to make variations of one document.
  • Create, modify, and use styles to affect the appearance of text.
  • Create and use templates, including the fax template.
  • Create, modify, and use macros.
  • Discuss Internet and Web features, create and edit a Web document, and preview a Web document in a browser.

 

Approximate Duration: 8 Hours

 

 

 

Word 2000: Advanced

 

Prerequisites: Windows 95, Word 2000 Level 1, Word 2000 Level 2 or equivalent knowledge.

 

Overview: Participants will learn how to apply styles, create forms, use form fields, add graphics, work with large documents, share documents, and prepare documents as intranet web pages.

 

Objectives:

  • Use advanced techniques for working with styles.
  • Create and use templates and forms.
  • Enhance documents by drawing in a document and using clip art and WordArt. Manage long documents by adding a table of contents, an index, bookmarks, cross- references, and odd and even headers and footers, and by adjusting margins for document binding.
  • Manage document changes by creating different versions of a document, tracking document changes, adding comments, and accepting or rejecting document changes.
  • Prepare a document for an intranet by inserting hyperlinks, sound, a movie clip, and scrolling text into a web page.

 

Approximate Duration: 8 Hours

 

 

 

WordPerfect 9.0: Level 1

 

Prerequisites: Windows 95 or equivalent knowledge.

 

Overview: Participants will learn the basic elements of word processing, including; navigating, entering text, and basic table and tab structure.

 

Objectives:

  • Identify WordPerfect 9.0, and create, save, and close a document.
  • Open and edit a document by using the mouse, keyboard, and menu choices.
  • Navigate through a multi-page document by using the keyboard, menu, and scroll bars.
  • Change the appearance of a document by adding formatting and changing fonts.
  • Modify text in a document by replacing text, reversing the last change made to a document, and copying or moving text to a new location.
  • Change paragraphs by creating and removing paragraph indents, changing the justification of the text, and setting the line spacing for the document.
  • Set tabs by using the Ruler Bar, and create, modify and format a table.
  • Insert and delete manual page breaks and create headers and footers in a document.
  • Check a document for potential errors by using the Spell Checker, identify alternate words by using the Thesaurus, and correct common typing errors by using QuickCorrect.

 

Approximate Duration: 8 Hours

 

 

 

WordPerfect 9.0: Level 2

 

Prerequisites: WordPerfect 9.0 Level 1 or equivalent knowledge.

 

Overview: Participants will learn some of the intermediate features or word processing, including; using templates, macros, graphics, and formatting tables.

 

Objectives:

  • Modify, format, and work with numeric data in a table.
  • Change the appearance of text by using styles.
  • Create, use, and edit templates.
  • Merge a document with data to create multiple variations of the document.
  • Merge a document by using merge codes, and merge envelopes and mailing labels by using the Corel Address Book.
  • Change the order of text by using the Sort feature.
  • Create, run, and edit a macro.
  • Format text into columns and add graphics.
  • Understand how to access the Internet.

 

Approximate Duration: 8 Hours

 

 

 

WordPerfect 9.0: Advanced

 

Prerequisites: WordPerfect 9.0 Level 1 and WordPerfect 9.0 Level 2 or equivalent

knowledge

 

Overview: Participants will learn how to customize the WordPerfect environment, work with the CorelCENTRAL Address Book, use SpeedLinks and comments, compare documents and work with Corel Versions, create c work with master documents, create a table of contents and an index, and create Web documents.

 

Objectives:

  • Apply WordPerfect settings and create and edit toolbars.
  • Create, modify, and use an address book.
  • Create and work with Speed Links and comments and compare documents.
  • Work with TextArt, water marks, layered drawings, and organization charts.
  • Work with a master document and create cross-references, a table of contents, and an index.
  • Create a table of authorities, footnotes, and endnotes.
  • Create Web documents by using the PerfectExpert, Internet Publisher, and Trellix.

 

Approximate Duration: 8 Hours

 

 

 

TECHNICAL APPLICATIONS

 

 

A+ Certification

 

Required Certification Courses:

1. Upgrading and Repairing PC s

2. DOS/Windows

 

 

Course: Upgrading and Repairing PC s

 

Prerequisites: A basic working knowledge of PC-compatible systems is recommended

 

Overview: Extensive Hands-On labs provide the level of knowledge you need to install, configure, upgrade, maintain, and troubleshoot your PC-compatible system hardware and software. Participants will learn the skills and abilities to become a successful computer technician.

 

Objectives:

  • Explain the basic functions of a microcomputer
  • Discuss basic hardware and software compatibility issues
  • Use appropriate troubleshooting techniques to identify a failing component
  • Describe Electrostatic Discharge (ESD) procedures
  • Describe potential risk of ESD to equipment
  • Describe potential hazards when working with computer equipment
  • Discuss the bus structure implemented in PCs
  • Identify the types of memory used in computers and the types of error messages associated with each
  • Discuss compatibility and maintenance issues associated with input devices, such as scanners, digitizers, and bar code devices
  • Discuss the options available for mass storage
  • Discuss preventive maintenance procedures for a system and its associated peripherals
  • List tips and tricks that optimize the process of computer disassembly, installation, and re assembly
  • Compare and contrast the use of IRQs and DMAs, I/O Addresses, and Memory Addresses
  • List common POST error codes Describe the procedure to measure voltage, current, and resistance
  • List common memory errors
  • Describe the setup options required for a printer attached to a PC
  • Describe printing problems that are specific to dot-matrix printers
  • Describe printing problems that are specific to ink-jet printers
  • Describe printing problems that are specific to laser printers
  • Identify the basic characteristics for local area networks (LANs) and wide area networks (WANs) -
  • List and describe the layers of the OSI networking model
  • List and identify the use of common network devices
  • Describe the physical characteristics of a LAN
  • Define the roles of client servers, and peers on a network
  • Identify potential network bottlenecks
  • List fault tolerance procedures
  • Describe the importance of the Internet to global communications
  • Differentiate between IF addresses and domain names
  • Trace the history of the Internet
  • Identify the most popular means of accessing the Internet
  • Identify service requirements that should be considered when choosing an Internet Service Provider
  • Configure dial-up networking from within Windows 95
  • Install Microsoft Internet Explorer
  • Install Netscape Navigator
  • Use popular search engines to set search parameters
  • Navigate the World Wide Web
  • Troubleshoot connectivity issues
  • Outline e-mail procedures
  • Explain the function of LISTSERV
  • Demonstrate an FTP file transfer procedure
  • Describe the Telnet remote login procedures
  • Describe the purpose of Newsgroups
  • Describe the relationship between good computer support, customer expectations, and customer problems
  • Apply the Directional Model to Troubleshooting, thus ensuring a consistent and comprehensive approach to solving customer problems
  • Communicate effectively and efficiently with customers, whether they are down the hall or across an ocean
  • Successfully test your skills in detailed real-life scenarios

 

Approximate Duration: 40 Hours

 

 

 

Course: DOS/Windows

 

Prerequisites: Basic exposure to DOS and/or PC-based applications is helpful.

 

Overview: Participants will learn the essential operating system competencies required for installing, configuring, upgrading, and troubleshooting PC-compatible systems. This Software Support class, along with our Upgrading and Repairing PCs class, will fully prepare you to take and pass both the CORE and DOS/WINDOWS modules required in attaining A+ Certification.

 

Objectives:

  • Discuss the purpose of an operating system
  • List the three system file required to boot a computer in DOS
  • Use internal DOS commands such as DIR, CD, COPY, RD, DEL, REN, DATE, TIME, VER, MD, and CLS to perform basic operations on your system
  • Manage files and directories using DOS commands
  • Compare and contrast the different areas of memory available under DOS
  • Compare and contrast the DOS utilities available to optimize system performance
  • Optimize hard disks for use with DOS with CHKDSK, SCANDISK, and DEFRAG
  • Discuss the types, purposes, and parameters supported by Windows INI files
  • Differentiate the file type and operating modes used with Windows
  • Discuss memory management in the Windows environment
  • Discuss support for non-Windows applications running under Windows
  • Troubleshoot Windows errors
  • Perform an installation of Windows 95
  • Effectively navigate the Windows 95 end-user interface
  • Customize the Windows 95 interface to meet users needs
  • Use built-in tools and utilities to manage system hardware
  • Monitor performance of the PC using Windows 95 built-in tools and utilities
  • List the features and benefits of the Windows 95 operating system
  • Understand software management techniques used with Windows 95

 

Approximate Duration: 16 Hours

 

 

 

CNA (Certified Novell Administrator) IntraNetWare Track

 

 

IntraNetWare Track Exam #50-613

 

Required Certification Course: 520 IntraNetWare: Netware 4.11 .Administration

 

Overview: Participants will learn the basics of managing a NetWare 4 network. Course 520 teaches how to use NetWare administrative tools to set up, manage and use basic network services, including file systems, network printing, security and E-mail.

 

Objectives:

  • Add users to the network
  • Execute network applications and share software resources
  • Make accessing the network seem invisible to users
  • Set up and manage the net file system
  • Provide transparent access to information and resources anywhere on the network
  • Use a multi-context Novell Directory Services (NDS) environment
  • Set up and manage network printing
  • Create effective network security
  • Back up and restore NetWare server data
  • Set up and manage NetWare messaging services

 

Approximate Duration: 40 Hours

 

 

 

CNA (Certified Novell Administrator) GroupWise 5 Track

 

Group Wise 5 Track Exam #50-618

 

Required Certification Course: 350 Group Wise 5 Administration

 

Prerequisites: Familiarity with domain name systems (DNS), IP and DHCP

 

Overview: Course 350 GroupWise System Administration is designed to teach participants the fundamentals of administering a Group Wise system. It includes system architecture, installation and configuration, messaging within the system, managing documents and client features.

 

Objectives:

  • Using the GroupWise Client
  • Understanding GroupWise System Fundamentals
  • Installing and Configuring a GroupWise System
  • Installing and Configuring the GroupWise Client
  • Configuring Messaging for a Single Post Office
  • Creating a Multiple Post Office System
  • Performing GroupWise Administration Tasks
  • Performing Client and Database Administration

 

Approximate Duration: 24 hours

 

 

 

CNE (Certified Network Engineer) IntraNetWare Track

 

 

IntraNetWare Track Required Certification Courses:

 

  • Course 520 IntraNetWare: NetWare 4.11 Administration (Exam #50-613)
  • Course 565 Networking Technologies (Exam #50-632)
  • Course 525 IntraNetWare: NetWare 4.11 Advanced Administration (Exam #50-6 14)
  • Course 532 NetWare 4.11 Design and Implementation (Exam #50-601)
  • Course 804 IntraNetWare: NetWare 4.11 Installation and Configuration Workshop

(Exam #50-617)

  • Course 801 Service and Support (Exam #50-626)
  • Course 350 GroupWise Administration (Exam #50-618)

 

Course: 520 IntraNetWare: NetWare 4.11 Administration (Exam #50-6 13)

 

Prerequisites: Basic exposure to DOS and/or PC-based applications

 

Overview: Participants will learn the basics of managing a NetWare 4 network. Course 520 teaches how to use NetWare administrative tools to set up, manage and use basic network services, including file systems, network printing, security and E-mail.

 

Objectives:

  • Add users to the network
  • Execute network applications and share software resources
  • Set up and manage the network file system
  • Provide transparent access to information and resources anywhere on the network
  • Use a multi-context Novell Directory Services (NDS) environment
  • Set up and manage network printing
  • Create effective network security
  • Back up and restore NetWare server data
  • Set up and manage NetWare messaging services

 

Approximate Duration: 40 Hours

 

 

 

Course: 565 Networking Technologies (Exam #50-632)

 

Prerequisites: Must have an understanding of personal computers and their operating systems

 

Overview: This course provides participant with an excellent foundation upon which to build their network training. It covers the basics of computer networking, including terms and concepts. Networking technology how it works, and why it works is made clear in this course, where concepts like contemporary network services, transmission media, and protocols are explained. Participants learn how protocols are used in networking implementations from many vendors, especially those most common in today s LANs and WANs.

 

Objectives:

  • Why networking protocols are important
  • The layers of the OSI reference model
  • Characteristics & uses of the layers of the OSl reference model
  • Lower layer protocols
  • Ethernet and token ring repeaters
  • The benefits of bridging
  • The use of switching hubs
  • Bridges, switches and routers
  • Register a domain name
  • Assign addresses to hosts
  • The purpose of subnets
  • The purpose of supernets
  • Routing considerations when supernetting
  • TCP/IP protocol
  • Vector routing with IP
  • Describe lPv6
  • IPX and SPX

 

Approximate Duration: 24 Hours

 

 

 

Course: 525 IntraNetWare: NetWare 4.11 Advanced Administration (Exam #50-614)

 

Prerequisites: 520 IntraNetWare: NetWare 4.11 Administration (Exam #50-613)

 

Overview: Participant will learn advanced administration skills such as tuning the network and server for better performance and managing complex tree structures. Course 525 teaches how to oversee a complex NetWare 4 networking environment, including Novell Directory Services (NDS) partitioning and replication, time synchronization strategies and integrating with NetWare 3.

 

Objectives:

  • Manage a complex NDS tree structure
  • Move NDS containers
  • Secure NDS resources
  • Integrate diverse network clients
  • Add advanced network services
  • Integrate and manage NetWare 3 resources using NetWare 4 utilities
  • Tune the network and NetWare 4 server for better performance

 

Approximate Duration: 24 Hours

 

 

 

Course: 804 IntraNetWare: NetWare 4.11 Installation and Configuration Workshop (Exam #50-617).

 

Prerequisites: Course 520 IntraNetWare: NetWare 4.11 Administration; and Course 525 IntraNetWare: NetWare 4.11 Advanced Administration

 

Overview: Participants will learn how to install and configure a NetWare 4 network, gaining hands-on experience that augments what you learned in courses 525 and 526 about Novell Directory Services (NDS) configuration. Scenarios for upgrading, migrating and installing teach participants how to implement a different design of the NDS tree structure.

 

Objectives:

  • Upgrade from NetWare 3 to NetWare 4
  • Install NetWare 4 servers
  • Configure basic network resources in NDS
  • Perform a complex NDS configuration
  • Merge two NDS trees
  • Troubleshoot NDS
  • Manage the NetWare 4 server
  • Install NetWare for Macintosh
  • Install Novell online documentation

 

Approximate Duration: 16 Hours

 

 

 

Course: 532 NetWare 4.11 Design and Implementation (Exam #50-601)

 

Prerequisites: Course 520 IntraNetWare: NetWare 4.11 Administration;

Course 525 IntraNetWare: NetWare 4.11 Advanced Administration; and

Course 804 IntraNetWare: NetWare 4.11 Installation and Configuration Workshop.

 

Overview: Participants will how to design and create a IntraNetWare implementation plan for a case-study company. Interactive group activities lead you through this process by acting in project roles to assess the needs of the case company. Participants use templates to complete a Novell Directory Services (NOS) design strategy and implementation schedule.

 

Objectives:

  • Design, analyze and integrate an NDS implementation
  • Determine directory tree structure and object placement
  • Form partition boundaries
  • Plan replica placement
  • Create a time synchronization strategy
  • Develop an administration accessibility strategy that includes Novell Directory Services (NDS) object creation and security
  • Develop a migration strategy for clients and servers
  • Create an implementation schedule for integrating your NDS design

 

Approximate Duration: 24 Hours

 

 

 

Course: 801 Service and Support (Exam #50-626)

 

Prerequisites: Course 565 Networking Technologies;

Course 525 IntraNetWare: NetWare 4.11 Advanced Administration; and Course 804 IntraNetWare: NetWare 4.11 Installation and Configuration Workshop.

 

Overview: Learn how to solve real-world problems in this hands-on laboratory course. Spend approximately 60 percent of your class time troubleshooting in six different labs. Course 801 focuses on the installation of network-related hardware and the prevention, diagnosis and resolution of hardware-related networking problems in NetWare 3 and 4 environments.

 

Objectives:

  • Find problem-solving information in Novell research tools
  • Includes network support encyclopedia, MicroHouse Technical Library & CompuServe
  • Install/troubleshoot network cabling, boards & hard disks in workstation & NetWare servers
  • Install a CD-ROM drive in a NetWare server
  • Mount a CD as a NetWare volume
  • Troubleshoot a Netware server & network
  • Troubleshoot DOS workstations
  • Troubleshoot network printing
  • Features of ManageWise
  • Use a protocol analyzer to troubleshoot network problems
  • Network management

 

Approximate Duration: 40 Hours

 

 

 

Course: 350 GroupWise 5 Administration (Exam #50-618)

 

Prerequisites: Familiarity with domain name systems (DNS), IP and DHCP

 

Overview: Course 350 Group Wise System Administration is designed to teach participants the fundamentals of administering Group Wise system. It includes system architecture, installation and configuration, messaging within the system, managing documents and client features.

 

Objectives:

  • Using the GroupWise Client
  • Understanding GroupWise System Fundamentals
  • Installing and Configuring a Group Wise System
  • Installing and Configuring the Group Wise Client
  • Configuring Messaging for L Single Post Office
  • Creating a Multiple Post Office System
  • Performing GroupWise Administration Tasks
  • Performing Client and Database Administration

 

Approximate Duration: 24 Hours

 

 

 

CNE (Certified Network Engineer) GroupWise 5 Track

 

GroupWise 5 Track Required Certification Courses:

 

  • Course 520 IntraNetWare: NetWare 4.11 Administration (Exam #50-6 13)
  • Course 565 Networking Technologies (Exam #50-632)
  • Course 350 GroupWise Administration (Exam #50-618)
  • Course 352 GroupWise 5 Advanced Administration (Exam #50-619)
  • Course 354 GroupWise Net Access and Connectivity (Exam #50-620)
  • Course 801 Service and Support (Exam #50-626)
  • Course 730 Network Management Using ManageWise (Exam #50-628)

 

 

 

Course: 520 IntraNetWare: NetWare 4.11 Administration (Exam #50-613)

 

Prerequisites: Basic exposure to DOS and/or PC-based applications

 

Overview: Participants will learn the basics of managing a NetWare 4 network. Course 520 teaches how to use NetWare administrative tools to set up, manage and use basic network services, including file systems, network printing, security and E-mail.

 

Objectives:

  • Add users to the network
  • Execute network applications and share software resources
  • Make accessing the network seem invisible to users
  • Set up and manage the network file system
  • Provide transparent access to information and resources anywhere on the network
  • Use a multi-context Novell Directory Services (NDS) environment
  • Set up and manage network printing
  • Create effective network security
  • Back up and restore NetWare server data
  • Set up and manage NetWare messaging services

 

Approximate Duration: 40 Hours

 

 

 

Course: 565 Networking Technologies (Exam #50-632)

 

Prerequisites: Must have an understanding of personal computers and their operating systems

 

Overview: This course provides participants with an excellent foundation upon which to build their network training. It covers the basics of computer networking, including terms and concepts. Networking technology how it works, and why it works is made clear in this course, where concepts like contemporary network services, transmission media, and protocols are explained. Participants learn how protocols are used in networking implementations from many vendors, especially those most common in today s LANs and WANs.

 

Objectives:

  • Why networking protocols are important
  • The layers of the 031 reference model
  • Characteristics & uses of the layers of the OSl reference model
  • Lower layer protocols
  • Ethernet and token ring repeaters
  • The benefits of bridging
  • The use of switching hubs
  • Bridges, switches and routers
  • Register a domain name
  • Assign addresses to hosts
  • The purpose of subnets
  • The purpose of supernets
  • Routing considerations when supernetting
  • TCP/IP protocol
  • Vector routing with IF
  • Describe IPv6
  • IPX and SPX

 

Approximate Duration: 24 Hours

 

 

 

Course: 350 GroupWise 5 Administration (Exam #50-618)

 

Prerequisites: Familiarity with domain name systems (DNS), PP and DHCP will help

 

Overview: Course 350 GroupWise System Administration is designed to teach participants the fundamentals of administering a GroupWise system. It includes system architecture, installation and configuration, messaging within the system, managing documents and client features.

 

Objectives:

  • Using the Group Wise Client
  • Understanding GroupWise System Fundamentals
  • Installing and Configuring a GroupWise System
  • Installing and Configuring the GroupWise Client
  • Configuring Messaging for a Single Post Office
  • Creating a Multiple Post Office System
  • Performing GroupWise Administration Tasks
  • Performing Client and Database Administration

 

Approximate Duration: 24 Hours

 

 

 

Course: Course 352 GroupWise 5 Advanced Administration (Exam #50-619)

 

Prerequisites: Course 520 IntraNetWare: NetWare 4.11 Administration

Course 350 Group Wise Administration

Course 532 NetWare 4.11 Design and Implementation

 

Overview: Participants will learn how to design, configure and troubleshoot a GroupWise 5 system with multiple domains. Course 352 also teaches you how to create a document management system and migrate from GroupWise 4.1 to Group Wise 5.

 

Objectives:

  • Create and link secondary domains
  • Configure and load agents
  • Set up a document management system
  • Define external domains
  • Troubleshoot and optimize the system
  • Upgrade a GroupWise 4.1 system to Group Wise 5
  • Design a GroupWise 5 system

 

Approximate Duration: 16 Hours

 

 

 

Course: 354 GroupWise Net Access and Connectivity (Exam #50-620)

 

Prerequisites: Course 520 IntraNetWare: NetWare 4.11 Administration;

Course 350 Group Wise Administration; and

Course 352 GroupWise 5 Advanced Administration

 

Overview: Course 354 GroupWise Net Access and Connectivity is designed to teach participants about the various ways to connect GroupWise Internet/Intranet Access and users to other users both within an organization and via the Internet. This course is critical to the successful installation of GroupWise Internet/Intranet Access and systems that go beyond a company s walls. Specific topics in the course include GroupWise Internet Agent, GroupWise Web Access, GroupWise Async/Remote, and connecting to other mail systems.

 

Objectives:

  • Connect GroupWise Internet/Intranet Access
  • Connect users within organizations and via the Internet
  • Successful installation of GW Internet/Intranet Access
  • Topics: GW Internet Agent, GW Web Access & GW Async/Remote
  • Other topics: MS Exchange, MS Mail, Lotus Notes & cc: Mail gateways
  • Define configurations for gateway setup
  • Enable user access to mail and documents through the Internet
  • Mobile connectivity configuration
  • Facilitate connections to other mail systems such as MS Exchange & Lotus Notes

 

Approximate Duration: 24 Hours

 

 

 

Course: 801 Service and Support (Exam #50-626)

 

Prerequisites: Course 565 Networking Technologies;

Course 525 IntraNetWare: NetWare 4.11 Advanced Administration; and

Course 804 IntraNetWare: NetWare 4.11 Installation and Configuration Workshop.

 

Overview: Participants will learn how to solve real-world problems in this hands-on laboratory course. Spend approximately 60percent of your class time troubleshooting in six different labs. Course 801 focuses on the installation of network-related hardware and the prevention, diagnosis and resolution of hardware-related networking problems in NetWare 3 and 4 environments.

 

Objectives:

  • Find problem-solving information in Novell research tools
  • Includes network support encyclopedia, MicroHouse Technical Library & CompuServe
  • install/troubleshoot network cabling, boards & hard disks in workstation & NW servers
  • Install a CD-ROM drive in a NetWare server
  • Mount a CD as a Netware volume
  • Troubleshoot a Netware server & network
  • Troubleshoot DOS workstations
  • Troubleshoot network printing
  • Features of ManageWise
  • Use a protocol analyzer to troubleshoot network problems
  • Network management

 

Approximate Duration: 40 Hours

 

 

 

Course: Course 730 Network Management Using ManageWise

 

Prerequisites: Course 520 IntraNetWare: NetWare 4.11 Administration

 

Overview: Participants will learn how to use ManageWise, Novell s network management software for effective server management. This course teaches you how to solve network problems using various integrated ManageWise components, including: NetWare Management System (NMS), NetWare Management Agent (NMA), NetWare LANalyzer Agent, and LANdesk and virus protect software.

 

Objectives:

  • Solve common network management problems using ManageWise
  • Use ManageWise tools to manage network performance
  • Troubleshoot user login problems
  • Plan and perform system upgrades
  • Troubleshoot printing problems

 

Approximate Duration: 16 Hours

 

 

 

DBA (Oracle 8 Certification Database Administrator)

 

 

Required Certification Courses:

  • Introduction to Oracle8 SQL and PL/SQL
  • Oracle8 Database Administration
  • Oracle8 Database Backup and Recovery
  • Oracle8 Database Performance Tuning
  • Oracle8 Networking

 

 

Course: Introduction to Oracle8 and PL/SQL

 

Prerequisites: An understanding of computers is essential

 

Overview: This course covers all the essential concepts of relational databases. Develop skills necessary to effectively interact with an Oracle8 database. Participants will develop procedural constructs using PL/SQL. Topics in this course are: SQL, SQL*Plus, control statement processing, loop constructs and advanced query techniques. Exercises and lab sessions reinforce the learning objectives and provide participants the opportunity to gain practical hands- on experience.

 

Objectives:

  • Define and Model an Oracle Relational Database
  • Design and Create Database Structures
  • Store, Retrieve and Manipulate Data
  • Display and Format Data
  • Group and Summarize Query Output
  • Control Transaction Processing
  • Create Query Scripts and Formatted Reports
  • Apply Business Rules and Data Integrity Constraints
  • Secure Objects and User Access
  • Utilize Character and Numeric Functions
  • Display Data from Multiple Tables
  • Develop Complex Queries
  • Develop Procedural Applications
  • Define Variables and Pass Values between Applications
  • Debug PL/SQL Code

 

Approximate Duration: 40 Hours

 

 

 

Course: Oracle8 Database Administration

Prerequisites: Introduction to Oracle8 DQL and PL/SQL

 

Overview: Participants will enhance your understanding of the Oracle8 architectural components, and develop skills necessary to effectively administer an Oracle8 database. They will learn to effectively manage system and database resources, ensure data integrity.

Objectives:

  • Understand the responsibilities of an Oracle Database Administrator (DBA)
  • Define and understand the Oracle architecture, components, functions, and processes
  • Create an Oracle8 database
  • Alter the database mode
  • Create and define the logical and physical structure of an Oracle8 database
  • Start up and shut down a database
  • Organize the contents of an Oracle8 database
  • Size and Resize Database Files
  • Understand transaction processing
  • Define SQL Statement Processing
  • Define and size the System Global Area (SGA) Cache
  • Create Rollback Segments
  • Create User Profiles

 

Approximate Duration: 40 Hours

 

 

 

Course: Oracle8 Backup and Recovery

 

Prerequisites: Oracle8 Database Administration

 

Overview: Participants will plan and implement an effective database backup and recovery strategy, develop a strategy to support 24-hour operations, and develop a recovery plan to minimize down time.

 

Objectives:

  • Identify Differing Business Requirements for Backup and Recovery
  • Define Oracle8 Architectural Issues for Backup and Recovery
  • Understand ARCHIVELOG and NOARCHIVELOG mode
  • Enable Archiving
  • Understand Implications of 24-Hour Operations
  • Perform Hot and Cold Backups
  • Perform Recovery from Hot and Cold Backups
  • Utilize the Export and Import Utilities
  • Develop a Backup and Recovery Plan

 

Approximate Duration: 16 Hours

 

 

 

Course: Oracle8 Database Performance Tuning

 

Prerequisites: Oracle8 Database Administration

 

Overview: Participants will develop skills necessary to effectively troubleshoot and performance tune an Oracle database server. Analyze performance statistics and tune cache areas to reduce physical I/O. They will understand the tuning requirements of online transaction processing systems, decision support systems and batch oriented system.

Objectives:

  • Apply a Tuning Methodology
  • Interpret the Utlbstat/Utlestat Report Output
  • Distribute I/O
  • Utilize Explain Plan, TKPROF and the SQL Trace Diagnostic Tools
  • Tune the Shared Pool
  • Tune the Database Buffer Cache
  • Tune the Redo Mechanisms
  • Size and Utilize Blocks Efficiently
  • Monitor and Detect Lock Contention
  • OLTP vs. Batch Tuning
  • Tune Sorts

 

Duration: 24 Hours

 

 

 

Course: Oracle8 Networking

 

Prerequisites: Oracle8 Database Administration

 

Overview: This course covers essential concepts of the Oracle Net8 Architecture Participants develop skills necessary to configure and troubleshoot an Oracle8 network architecture Participants will explore the LISTENER, TNSNAMES and SQL*NE1 configuration files and NET8 Assistant. Exercises and lab sessions reinforce the learning objectives and provide participants the opportunity to gain practical hands-on experience.

 

Objectives:

  • Define a Network Architecture
  • Understand Client/Server Network Components
  • Configure Oracle Name Services
  • Configure an Oracle Client
  • Configure an Oracle Server
  • Create/Edit LISTENER.ORA
  • Create/Edit TNSNAMES.ORA
  • Create/Edit SQLNET.ORA
  • Utilize NET8 Assistant
  • Configure Multi-Threaded Server
  • Configure OEM Agents

 

Approximate Duration: 16 Hours

 

 

 

MCSE 2000 (Microsoft Certified System Engineer) - Standard Track

 

 

Required Courses:

  1. Installing, Configuring and Administering Microsoft Windows 2000 Professional. (Exam 70-210)
  2. Installing, Configuring and Administering Microsoft Windows 2000 Server (Exam 70-215).
  3. Implementing and Administering a Microsoft Windows 2000 Network Infrastructure (Exam 70-216)
  4. Implementing and Administering a Microsoft Windows 2000 Directory Services Infrastructure (Exam 70-217)
  5. Designing a Microsoft Windows 2000 Directory Services Infrastructure (Exam 0-219)

 

Suggested Elective Courses:

  1. Designing a Secure Network (Exam 70-220)
  2. Upgrading from Microsoft Windows NT 4.0 to Microsoft Windows 2000 (Exam 70-222)

 

 

 

MCSE 2000 (Microsoft Certified System Engineer) - Accelerated Track

 

Candidates must have already passed the following three MCSE-Windows NT 4.0 exams in order to be eligible to take MCSE-Windows 2000 70-240 exam:

 

Exam 70-067 - Implementing and Supporting Microsoft Windows NT Server 4.0

Exam 70-073 - Implementing and Supporting Microsoft Windows NT Workstation 4.0

Exam 70-068 - Implementing and Supporting Microsoft Windows NT Server 4.0 in the

Enterprise

 

Required Courses:

  1. Microsoft Windows 2000 Accelerated Exam for MCPs certified on Microsoft Windows NT 4.0. (Exam 70-240)
  2. Designing a Microsoft Windows 2000 Directory Services Infrastructure. (Exam 70-219)

 

Suggested Elective Courses:

  1. Designing a Secure Network. (Exam 870-220)
  2. Upgrading from Microsoft Windows NT 4.0 to Microsoft Windows 2000. (Exam 70-222)

 

 

Course: Microsoft Windows 2000 Accelerated Exam for MCP s certified on Microsoft Windows NT 4.0.

 

Preparation for Exam: 70-240

 

 

Exam 70-067- Implementing and Supporting Microsoft Windows NT Server 4.0

Exam 70-073- Implementing and Supporting Microsoft Windows NT Workstation 4.0

Exam 70-068- Implementing and Supporting Microsoft Windows NT Server 4.0 in the Enterprise

 

Overview: Windows 2000 is designed to be a multipurpose operating system with integrated support for both client/server and peer-to-peer networks. Many of the features and technologies in Windows 2000 reduce your total cost of ownership (TCO) through automation and new management features. This course provides you with an overview of the new features of Windows 2000 and its system requirements.

 

Objectives:

  • Overview of Windows 2000
  • Upgrading Windows NT to Windows 2000
  • Managing Active Directory Objects
  • Active Directory Security
  • Managing Active Directory Sites
  • Modifying a Windows 2000 Environment
  • Using Group Policies to Manage Client Work Environments
  • Using Group Policies to Deploy Applications
  • Managing Windows 2000 Client Installations
  • New Features of DHCP and WINS
  • New Features in Remote Access
  • Disk and File Management
  • Managing Basic and Dynamic Disks
  • New Disaster Protection Features
  • Using Terminal Services

 

Approximate Duration: 40 hours

 

 

 

Course: Windows 2000: Installation and Administration

 

Preparation for Exams: 70-210 and 70-215

 

Prerequisites: Familiarity with installing and administering a Windows 2000 network and familiarity with networking fundamentals

 

Overview:

Day 1: This course is the first step into learning Microsoft s newest operating system Windows 2000 Professional. The course begins by discussing the key features found in Windows 2000 Professional. Participants then learn how to install Windows 2000 Professional and how to use the Microsoft Management Console for system administration. Next, learn how to customize the system using both the Control Panel and the Registry Editor. Finally, learn how to perform disk management tasks and how to configure your system for network computing.

 

Day 2: It then introduces the Windows 2000 Active Directory service for single point network administration. Participants learn how to create user accounts and groups, then add users to local groups. Next, learn how to set up network printers and how to administer network printing. Learn how to assign NTFS permissions to files and folders and how to share folders over the network. Finally, learn network security by auditing user activity and system events.

 

Day 3: Finally, it will explain how to manage security on your computer using the Windows 2000 Local Security Policy. Next, learn how to manage data through disk quotas, compression, and the Encrypting File System (EFS). Also learn how to back up and restore data. Then, learn how for monitor access to network resources and configure your computer for remote access. Learn the details of the Windows 2000 boot process and how to deploy Windows 2000 using scripted installations and master disk images. Finally, learn how to configure Windows 2000 for mobile computing and how to manage hardware devices.

 

Day 4: This course is designed for a new Windows 2000 systems administrator who needs to learn the basics of installing and configure the Windows 2000 Server operating system. In addition, participants will learn how to install and provide basic support of the Active Directory service to create a Windows 2000 domain.

 

Day 5: This course is also designed for a new Windows 2000 systems administrator who already knows how to install Windows 2000 Server and the Active Directory service, but needs to learn how to provide network support and configure network services in a Windows 2000 Active Directory domain environment. This course will cover various network protocols, name resolution services, remote access, security, and print and application servers. In addition, participants will learn the skills necessary to monitor, optimize, and protect their Windows 2000 Servers from data loss.

 

Objectives:

  • Administer your system using the Microsoft Management Console.
  • Configure clients to use the DNS service.
  • Customize your system using the Windows Control Panel.
  • Customize your system using the Windows Control Panel.
  • Identify the key features of Windows 2000.
  • Install and configure TCP/IP and NWLink.
  • Install Windows 2000 Professional from a CD-ROM and over the network.
  • Perform disk management tasks
  • Use the Registry Editor
  • Assign NTFS file and folder permissions to user accounts and groups.
  • Audit user activity and system events.
  • Create local groups and add users to those groups.
  • Create user accounts and set account properties.
  • Identify the benefits of Active Directory.
  • Manage network printers and documents.
  • Set up and configure network printers.
  • Share folders and their contents so they re accessible over the network.
  • Backup and restore data.
  • Configure remote access.
  • Configure Windows 2000 for mobile computing.
  • Describe the details of the Windows 2000 boot process.
  • Implement Windows 2000 Account Policies and Security options.
  • Implement, manage, and troubleshoot hardware devices and drivers.
  • Manage data using compression, disk quotas, and the Encrypting File System.
  • Monitor access to network resources.
  • Use Setup Manager and the system preparation tools to deploy Windows 2000.
  • Automate the Windows 2000 Server installation process.
  • Centrally manage user environments by implementing Group Policies.
  • Complete common administration tasks in your Active Directory domain.
  • Create a network file and folder structure that is easier for users to navigate.
  • Describe the Window 2000 Server family of products.
  • Determine an appropriate file system for individual business needs.
  • Implement and support an appropriate Active Directory structure for your organization.
  • Install Windows 2000 Server.
  • Enable clients to access a Windows 2000 desktop through terminal emulation.
  • Enable users to communicate with each other over a network.
  • Enable users to communicate with your local area network from a remote location.
  • Enable users to print over the network by setting up and configuring network printers.
  • Extend the functionality of your Windows 2000 server by installing IIS and Telnet.
  • Maintain system and network security by implementing Windows 2000 security technology
  • Optimize disk and network performance by using monitoring and optimization tools.
  • Protect your systems from hardware failure and data loss.

 

Approximate Duration: 40 hours

 

 

 

Course: Windows 2000: Network Infrastructure Implementation

 

Preparation for Exam: 70-216

 

Prerequisites: Familiarity with installing and administering a Windows 2000 network and familiarity with networking fundamentals.

 

Overview:

 

Implementing: In this course, participants will explore the components that make up the Windows 2000 network infrastructure. Identify the features-and reasons why you might implement them. Also, explore the components that make up the Windows 2000 network infrastructure.

 

Administering: In this course, participants will learn how install, and administer the Windows 2000 networking services. Start with an overview of the network services you can use to build your network infrastructure, and then move on to implementing both the TCP/IP and NWLink protocols. Next, learn how to monitor network traffic by using the Network Monitor utility. Finally, explore how to secure your TCP/IP network traffic by using IP Security (IPSec), and how to use Network Address Translation when communicating with the Internet.

 

Also this course will show how to implement name resolution in Windows 2000. Specifically, implement TCP/IP host name resolution through a HOSTS file and the Domain Name System (DNS). Also explore how to implement NetBIOS (computer) name resolution through the Windows Internet Name Service (WINS). From there, move on to implementing remote client connectivity through the Remote Access Service (RAS), and securing your network with Certificate Services.

 

Objectives:

  • Describe the services that make up the Windows 2000 network infrastructure.
  • Design and implement Network Address Translation for Internet access.
  • Dynamically configure TCP/IP with the Dynamic Host Configuration Protocol (DHCP).
  • Install and configure the NWLink protocol.
  • Install and manually configure the TCP/IP protocol.
  • Monitor network traffic.
  • Secure TCP/IP traffic.
  • Configure enterprise-wide network security.
  • Implement Certificate Services.
  • Implement the Domain Name System (DNS) service.
  • Implement the Windows Internet Name Service (WINS).
  • Install and configure a RAS server.
  • Manage the DNS service.
  • Resolve TCP/IP host names with a HOSTS file.

 

Approximate Duration: 40 Hours

 

 

 

Course: Windows 2000: Administering the Active Directory

 

Preparation for Exam: 70-217

 

Prerequisites: Windows 2000: Installation and Administration and familiarity with installing and administering a Windows 2000 network.

 

Overview:

 

Implementing: This course is designed for the Windows 2000 systems administrator who already knows how to install Windows 2000 Server and complete basic administration tasks, but needs to learn how to configure and administer a Windows 2000 Active Directory domain environment. This course will present the fundamentals of Active Directory and cover various Active Directory administration tasks such as integrating DNS and the Active Directory, configuring sites, and user and group administration.

 

This course is also designed for the Windows 2000 systems administrator who already knows how to install and configure Windows 2000 Server and the Active Directory service, but needs to learn how to work with Active Directory resources other than users and groups, control user environments using Group Policy, and secure Active Directory resources. In addition, participants will learn the skills necessary to deploy Windows 2000 Professional using Remote Installation Services.

 

Administering: In this Course, participants will learn how to use the different parts of the Active Directory and create Active Directory domains, manage Active Directory objects and apply security in the Active Directory. Also learn to use Group Policies to manage scripts, manage user interface settings, and to deploy applications. Also, be able to create and manage Group Policies and deploy software. Learn about security, backup, sites, network services, a forest of multiple domain trees, and remote installation. Finally, be able to implement security and backup solutions, manage sites, integrate network services, create and manage a forest of multiple domain trees, and use Remote installation services.

 

Objectives:

 

  • Complete the primary Active Directory administrative.
  • Configure your Active Directory for optimal replication by creating multiple sites.
  • Create a single point of network management.
  • Create and administer group accounts in the Active Directory.
  • Create and administer user accounts in the Active Directory.
  • Describe the administrative differences between using Windows 2000 Server in a workgroup environment and an Active Directory domain environment.
  • Provide name resolutions services for your Active Directory.
  • Successfully implement an Active Directory domain environment.
  • Complete additional i Directory administrative tasks such as delegating authority, organizing Active Directory resources, and protecting against data loss.
  • Control users work environments by creating and apply Windows 2000 Group Policy.
  • Enforce and evaluate security configurations.
  • Manage Active Directory performance.
  • Monitor security events by establishing an audit policy and examining the Security log.
  • Provide users with ac to remote files by creating and securing shared folders.
  • Remotely install Windows 2000 Professional on client computers by using Remote Installation Services.

 

Approximate Duration: 40 Hours

 

 

 

Course: Windows Active Directory Design

 

Preparation for Exam: 70-219

 

Prerequisites: Windows 2000: Installation and Administration and familiarity with installing and administering a Windows 2000 network.

 

Overview: In this course participants will examine factors in the design of the Active Directory, naming conventions, developing domains and designing a Group Policy strategy. Identify factors to consider when designing the Active Directory, appropriately name the DNS and Active Directory domains, design and configure a single Active Directory domain, and design a Group Policy strategy.

 

Participants will also investigate the implications with modifications to the schema, compare centralized and distributed domain models, analyze strategies for delegating administrative responsibility, examine site planning concepts, and plan the Active Directory design. Finally, design a schema strategy, configure an environment with multiple domains, design and implement administrative delegation, develop a multi-site structure, and construct an Active Directory infrastructure

 

Objectives:

  • Directory replication with in a site and between sites.
  • DNS in Active Directory
  • Change and Configuration Management
  • Active Directory Security Solutions
  • To Implement Group Policies
  • Schema modification
  • To Design a Directory Service Architecture

 

Approximate Duration: 24 Hours

 

 

 

Course: Windows 2000: Designing a Secure Network

 

Preparation for Exam: 70-220

 

Prerequisites: Working knowledge of Windows 2000 Directory Services Upgrading Support Skills from Microsoft Windows NT 4.0 to Microsoft Windows 2000 OR Implementing and Administering Windows 200C Directory Services OR Equivalent knowledge

 

Overview: In this hands-on course, participants gain the knowledge and skills you need to assess and implement total Enterprise security. From the file system to the network infrastructure, participants learn to control the privacy, integrity and authenticity of data.

 

Objectives:

  • Design and configure a secure Windows 2000 systems infrastructure
  • Implement NTLM, Kerberos and SSL/TLS for heterogeneous operation
  • Maximize file system security with NTFS encryption and recovery agents
  • Implement delegated administration and distributed security with the Active Directory. Consolidate security and reduce TCO with automated deployment of security policies
  • Build a secure, intolerable network with Windows 2000 security services

 

Approximate Duration: 40 hours

 

 

 

Course: Windows 2000: Migration Strategy

 

Preparation for Exam: 70-222

 

Prerequisites: Implementing and Administering Microsoft Windows 2000 Directory Services, or equivalent knowledge and skills.

 

Overview: Windows 2000: Upgrading from Windows NT 4.0, is for current Windows NT 4.0 system administrators who need to prepare to upgrade a Windows NT network to Windows 2000. To quickly learn the essential skills necessary to install Windows 2000, implement the Active Directory, and perform basic administrative tasks in the new Active Directory management tool.

 

Participants will then develop a migration strategy for transitioning an existing Windows NT network to Windows 2000. Also, to learn the skills necessary to manage file and disk resources, configure Remote Access, support DHCP and WINS, or develop a disaster protection plan for a Windows 2000 network.

 

Objectives:

  • Create, manage, and control access of, objects in the Active Directory.
  • Identify the components of the Active Directory, plan and install an Active Directory structure
  • Identify the new feature benefits in each of the four Windows 2000 products, and determine the system
  • Install and configure a DNS server and set DNS client properties.
  • Use Group Polices to manage client work environments.
  • Use Group Policies to deploy applications.
  • Implement a disaster protection plan.
  • Install and configure DHCP and WINS.
  • Install and configure Routing and Remote Access.
  • Manage Basic and Dynamic disks.
  • Manage file resources in Windows 2000.
  • Plan a migration strategy from Windows NT to Windows 2000.

 

Course Content:

 

Approximate Duration: 16 Hours

 

 

 

Network + Certification

 

Prerequisites: None; however, the certification exam is targeted for computer technicians with 18 to 24 months in the IT field. A+ certification or equivalent knowledge is also recommended.

 

Overview: Participants will learn the skills and knowledge to help prepare them to take the CompTIA Network+ certification exam.

 

Objectives:

  • Describe the purpose of networking protocols and networking in general.

        Identify features of various network operating systems and the clients used to access them.

  • Describe the OSI networking model and its relationship to networking components.
  • Describe the network components relating to the Physical layer of the OSI model.
  • Describe the function of the Data Link layer of the OSI model.
  • Explain how data is transmitted over a network.
  • Describe the function of the Network layer of the OSl model.
  • Describe the function of the Transport layer of the OSl model.
  • Describe the function of the Session layer of the OSl model.
  • Explain the fundamental concepts of the TCP/IP protocol suite.
  • Explain the use of TCP/IP addresses and subnets.
  • Access and use a TCP/IP network.
  • Describe the requirements for remote network access.
  • Explain the need for and ways to implement network security and fault tolerance.
  • Describe the types of information that need to be gathered prior to installing or updating a network operating system.
  • Explain ways to monitor and manage a network.
  • Describe a systematic approach for troubleshooting network problems.

 

Approximate Duration: 40 Hours

 

 

 

RHCE (Red Hat Certified Engineer)

 

Required Certification Courses:

  • Linux: Workstation
  • Linux Fundamentals
  • Linux Networking
  • Linux System Administration
  • Linux Certification Study Guide for RHCE

 

Course: Linux: Workstation

 

Prerequisites: Windows 95, familiarity with the Linux or Unix command line is required or equivalent knowledge.

 

Overview: Participants will learn what Linux is, how to perform a workstation install, and some basic commands.

Objectives:

  • Trace the history and development of Linux.
  • Gather hardware and network information required for installation.
  • Install Red Hat Linux 6.0 using the workstation class.
  • Log in and use basic commands.
  • Create and configure user accounts.
  • Mount file systems and move around the file system s directory structure.
  • Manage the file system.
  • Set permissions on files and directories.
  • Create files using editors and redirections, then print the files.
  • Use the X Window environment.
  • Shut down, restart, and configure the startup of your Linux system.

 

Approximate Duration: 16 hours

 

 

 

Course: Linux Fundamentals

 

Prerequisites: Linux Workstation and 6-12 months experience with Linux. Familiarity with the Linux or Unix command line is required.

 

Overview: Participants will install Linux, configure the X Window System, and learn to navigate the Linux command-line shell. Participants will also learn fundamental concepts common to Linux: the kernel, Linux filesystem, boot process and runlevels, shell scripting, and editing text files.

 

Objectives:

  • Describe the structural components of Linux and what distinguishes a distribution of Linux.
  • Describe Open Source Software and distinguish between GNU and GPL.
  • Create installation boot diskettes.
  • Install Linux distribution(s).
  • Install and configure XFree86.
  • Describe how to get online help.
  • Configure fundamental system hardware.
  • Use fdisk or cfdisk to create, edit, and delete disk partitions.
  • Use LILO to manage boot options.
  • Boot the system, change runlevels, and shut down or reboot the system.
  • Describe the Linux hierarchical file system and the role of key directories in organizing system files.
  • Work effectively on the Linux command line using common shell commands, streams, pipes, filters, and redirection.
  • Use shell scripting to quickly perform repetitive tasks.
  • Open, edit, and save text documents using the vi editor.

 

Approximate Duration: 24 Hours

 

 

 

Course: Linux Networking

 

Prerequisites: Participants should have 6-12 months experience with Linux. Familiarity with the Linux or Unix command line is required. Experience with TCP/IP and networking is required.

 

Overview: Participants will gain a comprehensive overview of the TCP/IP functionality and networking features and daemons available for the Linux platform.

 

Objectives:

  • Install TCP/IP networking and define the common ports.
  • Explain the Client/Server model.
  • Relate some of the history of the Internet.
  • Use TCP/IP to perform basic functions.
  • Troubleshoot TCP/IP problems and understand the concepts behind network troubleshooting and network management.
  • Set up and configure basic DNS services.
  • Perform basic Apache configuration for a simple Web server.
  • Configure file sharing using Samba.
  • Configure file sharing using NFS.
  • Install, configure and manage network services for e-mail, Web services, Samba, NFS, and DNS.
  • Start and stop the appropriate daemons for network services.

 

Approximate Duration: 24 Hours

 

 

 

Course: Linux System Administration

 

Prerequisites: Participants should have 6-12 months experience with Linux. Familiarity with the Linux or Unix command line is required.

 

Overview: Participants will gain hands-on experience with kernel customization, package management, process and disk management, as well as user and group management.

 

Objectives:

  • Describe the role of a Linux system administrator.
  • Explain the function of the kernel and how it interacts with the rest of the system.
  • Use package management to perform system updates and maintain system integrity.
  • Make and install programs from source code.
  • Perform basic process, memory, and performance management.
  • Manage system functionality through daemons.
  • Manage file ownership and permissions.
  • Manage user and group accounts and related system files.
  • Configure and verify system security.
  • Customize and use the shell in user and system environments.
  • Design and maintain an effective data backup strategy.
  • Use and manage local system documentation.
  • Configure logging and monitor log files of local and remote systems.

 

Approximate Duration: 16 Hours

 

 

 

Programming Languages

 

 

HTML 4.0 Programming: Level 1

 

Prerequisites: Windows 95, experience with Netscape or Microsoft browsers or equivalent knowledge.

 

Overview: Participants will learn how to create Web pages by writing HTML code.

 

Objectives:

  • Recognize the components of an HTML file and create such a file.
  • Format paragraphs and characters using HTML.
  • Link to local files and Web pages from their Web pages.
  • Add graphics and sound to their Web pages using HTML.
  • Create different kinds of lists to their Web page using HTML.
  • Create multi-column and multi-row tables using HTML.
  • Set background colors and graphics for Web pages.
  • Evaluate Web page design and consider design issues that affect web pages.
  • Add links to non-Web Internet sites from their Web pages.

 

Approximate Duration: 8 Hours

 

 

 

HTML 4.0 Programming: Level 2

 

Prerequisites: HTML 4.0 Programming Level 1 or equivalent knowledge.

 

Overview: Participants will learn intermediate skills and techniques used in Web page development.

 

Objectives:

  • Create advanced tables, including nested tables.
  • Size and place graphics, including imagemaps, in a Web page.
  • Create Web forms.
  • Create forms with advanced input types and attributes.
  • Create and work with framed Web pages.
  • Create documents that automatically display another page and documents that contain interactive JavaScripts and applets.
  • Design Web pages using style sheets.

 

Approximate Duration: 8 Hours

 

 

 

Java Programming

 

Prerequisites: Programming experience and familiarity with C are required. An understanding of C++ is desirable. Participants should understand object-oriented concepts and have used a WWW Browser, such as Netscape or Explorer.

 

Overview: This intensive course provides a solid introduction to the Java programming language and development environment. In this fast-paced, hands-on course, programmers acquire the skills they need to write standalone, client/server, and intranet applications in Java.

 

Objectives:

  • Describe the context for and uses of Java.
  • Describe the Java environment and steps needed to create a Java program.
  • Use Java to create applets.
  • Use Java to develop applications.

 

Approximate Duration: 40 Hours

 

 

 

Java Programming: Advanced

 

Prerequisites: Java Programming or equivalents knowledge in programming and C/C++.

 

Overview: Participants will focus on the areas of delivering images and animation, thread programming, and event handling.

 

Objectives:

  • Use advanced JAVA programming to build cross-platform client/server applications.
  • Develop flexible database applications using Java Database Connectivity (JDBC)
  • Create Enterprise JavaBeans systems.

 

Approximate Duration: 32 Hours

 

 

 

JavaScript: Enhancing Web Pages

 

Prerequisites: Introduction to JavaScript Scripting or equivalent knowledge.

 

Overview: Participants will be introduced to the JavaScript programming language and concepts by adding enhancements to a fictitious, multi-page Web site.

 

 

Objectives:

  • Recognize the types of enhancements JavaScript can make to Web pages to make them more engaging to the Web user, identify how and where
  • JavaScript can be placed in a Web page, and use the JavaScript error-handling feature of your browser to find and correct scripting errors.
  • Describe the basic concepts of the JavaScript language: objects, event handling, functions, object references, and control structures.
  • Write the JavaScript code to swap images that respond to a mouse click, display images that correspond to the mouse rolling over a link, and automatically cycle through a series of images to create a
  • Web page slide show.
  • Solve the challenge of cross-browser incompatibility by displaying different Web pages for each browser, and change the style and positioning attributes of Web page elements while a page is loaded in either browser:
  • Write JavaScript applications for processing and validating user-entered data on Web page forms.
  • Write the JavaScript code to dynamically load pages into frames, and load new pages into customized windows.

 

Approximate Duration: 8 Hours

 

 

 

JavaScript Programming

 

Prerequisites: JavaScript Enhancing Web Pages or equivalent knowledge.

 

Overview: Participants will l how to write JavaScript programs that use the latest language techniques. Participants will also learn how to write programs that are compatible with previous versions of the language and are cross-browser compatible.

 

Objectives:

  • List the JavaScript syntax rules and implement good coding practices.
  • List the data and variable types that JavaScript supports, use the many control statements available in JavaScript, end create and use functions.
  • Describe object characteristics, use objects, instantiate objects, and create custom objects.
  • Describe the purpose of The Document object and use its properties, methods, and event handlers.
  • Script with frames in mind.
  • Describe the purpose of the Form object and use its properties, methods, and event handlers to read and write to HTML forms.
  • Choose a general process for validating user input into web forms.
  • Validate user input into HTML forms including testing for required fields, numeric data and numeric data within a range of values specified, and string data.
  • Describe the purpose of the Date object, instantiate and use instances of the Date object to create clocks, count-down timers, and perform date math.
  • Describe the purpose of the Math object and use its constants and methods to perform mathematical operations.
  • Characterize the compatibility landscape and choose between the various techniques for dealing with potential incompatibilities. Detect browsers in order to create code that works around platform incompatibilities.

 

Approximate Duration: 24 hours

 

 

 

JavaScript Programming: Advanced

 

Prerequisites: JavaScript Pro or equivalent knowledge.

 

Overview: Participants who are already familiar with the fundamentals of JavaScript programming will learn how to develop scripts that are modular, easily maintainable, and compatible with multiple browsers. Participants will learn debugging techniques and how to use advanced programming features such as custom objects, arrays, and cookies. Participants will also learn how JavaScript communicates with other software such as applets and server-side scripts.

 

Objectives:

  • Debug and maintain JavaScript code libraries.
  • Develop Web pages that display different content or execute different code based on the version of JavaScript that is present on the Web client.
  • Create custom objects with custom methods and properties.
  • Create, read to, write from, and delete single and multi-dimensional arrays.
  • Store, retrieve, and delete cookies.
  • Write JavaScript code to communicate with Java applets, ShockWave movies, ActiveX controls, and server applications.

 

Approximate Duration: 8 Hours

 

 

 

Visual Basic 6.0: Introduction

 

Overview: Participants will l how to use Visual Basic 6.0 to develop Windows applications.

 

Objectives:

  • Identify and describe the purpose of various components of the Visual Basic programming environment.
  • Build and run a small application.
  • Use the code editing tools in the Code Editor window to write conditional statements and other code constructs.
  • Isolate, identify, and correct logic, compile, and run-time errors in a Visual Basic application.
  • Develop multiple-form applications.
  • Declare variables and constants.
  • Examine and discuss Sub and Function procedures, and pass arguments by value and by reference.
  • Create application interface with standard and custom controls.
  • Build common and pop-up menus into an application.
  • Write an error-handling routine.
  • Create an application by using the VB Application Wizard, and create, install, and remove a setup program.
  • Use the data control to access a database table and discuss the features of an MDI environment.

 

Approximate Duration: 24 Hours

 

 

 

Visual Basic 6.0: Database Programming

 

Overview: Participants will learn how to use the Visual Basic 6.0 programming language to access and manipulate a database

 

Objectives:

  • Discuss the components of a Visual Basic database application.
  • Create an ODBC driver and connect to a database.
  • Manage record navigation, data maintenance, and data integrity by using the Data control.
  • Use other data-bound controls to present and maintain data.
  • Maintain data in Recordset objects that include data changes, record additions, and record deletions.
  • Validate data.
  • Debug database applications by trapping run-time errors.
  • Use SQL statements to create recordsets, update records, and summarize data.
  • Produce from within Visual Basic 6.0 and by using Crystal Reports.
  • Deploy their database application by creating the setup application for it.

 

Approximate Duration: 24 Hours

 

 

 

Oracle 9i Database Administration

 

Overview: This course provides the new DBA with the background and tools needed to set up and run Oracle databases, including backup and recovery, and covers database design and performance issues. This course covers Oracle9i, Release 1 and 2.

 

Course Objectives:

Upon completion of the course, students will be able to:

Administer an Oracle database

Perform and test Oracle backups and recoveries

Advise application developers on tuning issues

Plan for growth

  • Start up and shut down an Oracle instance and database
  • Create an operational database
  • Manage physical and logical storage
  • Manage users, privileges and resources
  • Manage undo and redo logs

 

Who Needs to Attend

Database operators

Application designers/developers

 

 

 

USSMC 's ThinkSync to Develop Queries and Reports with SQL and SQL*Plus
XORA305

 

Write queries to format and report data from an Oracle8i relational database

Hands-on 3-day course

 

Course Description

Develop skills necessary to effectively interact with an Oracle8i database. Participants will develop queries and standard reports to produce formatted output. Topics in this course are: SQL, SQL*Plus, query techniques, functions, joins, operators and report formats. Exercises and lab sessions reinforce the learning objectives and provide participants the opportunity to gain practical hands-on experience.

 

You Learn to

        Identify Relational Structures

        Display and Format Data

        Group and Summarize Query Output

        Control Transaction Processing

        Rearrange and Sort displayed output

        Create Query Scripts and Formatted Reports

        Utilize Character and Numeric Functions

        Utilize Date Functions and Display Formats

        Display Data from Multiple Tables

        Utilize Advanced Query Techniques

        Obtain Information from the Data Dictionary Tables

        Store, Retrieve and Manipulate Data

        Create Views to Secure Data

        Create Sequences to Generate Unique Numbers

 

Who Needs to Attend

        End Users

        Support Staff

        Developers

        Analysts

 

Follow-On Courses

SQL Tuning Techniques, PL/SQL Coding Techniques, Relational Database Design

 

 

 

USSMC's ThinkSync to PL/SQL Coding Techniques XORA310

Develop reusable program modules using Oracle's Procedural Language.

Hands-on 2-day course

 

Course Description

This programming course will help participants develop reusable program modules using Oracle's Procedural Language (PL/SQL). Participants learn modular programming techniques and utilize procedural constructs while developing PL/SQL blocks. Topics in this course are: Declare and Manage Variables, PL/SQL Transactions, IF Statements and Loops, Exception Processing and Cursor Management. Exercises and lab sessions reinforce the learning objectives and provide participants the opportunity to gain practical hands-on experience.

You Learn to

        Create PL/SQL Blocks

        Declare PL/SQL Variables

        Declare Scalar and Composite Variables

        Code IF-THEN-ELSE Statements

        Code LOOP Statements

        Code Exception Handlers

        Code User Defined Exceptions

        RAISE Application Errors

        Create Explicit Cursors

        Process and Manage Explicit Cursors

 

Who Needs to Attend

        End Users

        Support Staff

        Developers

        Analysts

        Administrators who are or will be working in an Oracle environment.

 

Follow-On Courses

SQL Tuning Techniques, PL/SQL Develop Database Objects, Oracle8i Database Administration, Oracle Developer: Forms I

 

 

 

USSMC's ThinkSync to Oracle8 for Experienced SQL Users XORA350

Utilize Oracle SQL extensions and PL/SQL to interact with an Oracle8 relational database.

Hands-on 3-day course

 

Course Description

This course is designed for participants who are experienced with the industry standard SQL who wish to become proficient in the Oracle SQL extensions and effectively interact with an Oracle8 database. Participants will also develop reusable procedural constructs using PL/SQL. Topics in this course: SQL, SQL*Plus, functions, control statement processing, loop constructs and query technique. Exercises and lab sessions reinforce the learning objectives and provide participants the opportunity to gain practical hands-on experience.

 

You Learn to

        Define and Model an Oracle Relational Database

        Design and Create Database Structures

        Display and Format Data

        Group and Summarize Query Output

        Control Transaction Processing

        Format Reports

        Secure Objects and User Access

        Utilize Character and Numeric Functions

        Develop Procedural Applications

        Define Variables and Pass Values Between Applications

        Debug PL/SQL Code

 

Who Needs to Attend

An effective Oracle training plan begins with this course.

        End Users

        Support Staff

        Developers

        Analysts

        Administrators who are or will be working in an Oracle environment.

 

Follow-On Courses

SQL Tuning Techniques, PL/SQL Develop Database Objects, Oracle8 Database Administration, Oracle Developer: Forms I

 

 

 

USSMC's ThinkSync to SQL Tuning Techniques XORA400

Troubleshoot and Tune SQL Statement Execution

Hands-on 2-day course

 

Course Description

This course helps participants learn effective application tuning techniques for optimizing performance in the Oracle server environment. Topics in this course are: troubleshooting application performance, utilizing Oracle supplied diagnostic utilities, and creating physical structures to improve application performance. Exercises and lab sessions reinforce the learning objectives and provide participants the opportunity to gain practical hands-on experience.

 

You Learn to

Apply a Tuning Methodology

Utilize Explain Plan, TKPROF and the SQL Trace Diagnostic Tools

Optimize Performance with Clusters and Indexes

Define Cost- or Rule-based Optimization

Pass Optimizer Hints

Tune PL/SQL Code

 

Who Needs to Attend

Data Analysts

Data Administrators

System Administrators

Developers

Support Staff

 

Prerequisites:

You must have knowledge of SQL or attend the Oracle8i SQL and PL/SQL course.

 

Follow-On Courses

Oracle8i Develop Database Objects

 

 

 

USSMC's ThinkSync to PL/SQL Develop Database Objects XORA500

Enhance processing with database stored procedural code.

Hands-on 3-day course

Course Description

Create database level applications. Create PL/SQL object constructs such as stored database procedures, functions, packages, and database triggers. Enforce business rules within the database and perform value based auditing. Participants have the opportunity to gain practical hands-on experience.

 

You Learn to

        Develop Server Level Applications

        Create and Execute Database Procedures

        Create and Execute Database Functions

        Create and Execute Database Packages

        Pass Values Between Applications

        Compile Applications

        Debug Applications

        Manage Application Dependencies

Create and Implicitly Execute Database Triggers

Create Reusable Object Types

         Manipulate Large Object Types

 

Who Needs to Attend

Data Analysts

Data Administrators

System Administrators

Developers

Support Staff

 

Follow-On Courses

SQL Tuning Techniques, Oracle8i Database Administration, Oracle Developer: Forms I

 

 

 

USSMC's ThinkSync PL/SQL Developer Boot Camp XORA550

Develop, compile and execute database server level applications using PL/SQL.

Hands-on 5-day course

 

Course Description

Create database level applications. Participants will code procedural constructs including control statements, loops and cursors, create PL/SQL object constructs such as stored database procedures, functions, packages, and database triggers. Participants will develop techniques to enforce business rules within the database and perform value based auditing. Exercises and lab sessions reinforce the learning objectives and provide participants the opportunity to gain practical hands-on experience.

 

You Learn to

         Develop Procedural Applications

         Define Variables and Pass Values Between Applications

         Debug PL/SQL Code

         Develop Server Level Applications

         Create and Execute Database Procedures

         Create and Execute Database Functions

         Create and Execute Database Packages

         Pass Values Between Applications

         Compile Applications

         Debug Applications

         Manage Application Dependencies

         Create and Implicitly Execute Database Triggers

         Create Reusable Object Types

         Manipulate Large Object Types

 

Who Needs to Attend

         Data Analysts

         Data Administrators

         System Administrators

         Developers

         Support Staff

 

Follow-On Courses

SQL Tuning Techniques, Oracle8i Database Administration, Oracle Developer: Forms I

 

 

 

USSMC's ThinkSync to Oracle8i Database Administration XORA600

 

Develop Skills necessary to effectively manage and Oracle Relational Database

Hands-on 5-day course

 

Course Description

Develop skills to effectively administer an Oracle8i Object Relational Database Management System. Enhance your understanding of the Oracle8i architectural components. Configure and start up the Oracle instance and memory components and create the Oracle database repository. Create physical and logical database objects, Utilize Oracle Enterprise Manger and the integrated Oracle Data Dictionary to monitor and maintain the Oracle8i database. Secure access to the Oracle8i objects with privileges, roles and profiles. Exercises and lab sessions reinforce the learning objectives and provide participants the opportunity to gain practical hands-on experience.

 

You Learn to

        Understand the responsibilities of an Oracle Database Administrator (DBA)

        Define and understand the Oracle architecture, components, functions, and processes

        Define and size the System Global Area (SGA) Cache

        Create an Oracle8i database

        Start up and shut down a database using Oracle Enterprise Manager

        Create and define the logical and physical structure of an Oracle8i database

        Organize the contents of an Oracle8i database

        Size and Resize Database Files

        Manage Partitions

        Create Virtual Databases

        Create Index Organized Tables

        Create Function Based Indexes

        Define SQL Statement Processing

        Create Rollback Segments

        Create User Profiles

        Manage Security

 

Who Needs to Attend

         Data Analysts

         Data Administrators

         System Administrators

         Developers

         Support Staff

 

Follow-On Courses

Oracle8i Database Performance Tuning

Oracle8i Database Backup and Recovery

 

 

 

USSMC's ThinkSync to Oracle8i Architecture and Utilities XORA605

 

A Non-DBAs guide the Oracle8i Architecture and Data Utilities

Hands-on 2-day course

 

Course Description

This course helps participants expand their knowledge of the Oracle8i server environment. Topics in this course are: Oracle8i Architecture, bulk data loading, and data import/export. Exercises and lab sessions reinforce the learning objectives and provide participants the opportunity to gain practical hands-on experience.

 

You Learn to

        Identify the Oracle8i Architecture

        Describe SQL Statement Processing

        Describe the logical and physical structure of an Oracle8i database

        Understand transaction processing

        Load Data Using SQL*Loader

        Export Data from the Database

        Import Data into the Database

 

Who Needs to Attend

         Data Analysts

         System Administrators

         Developers

         Support Staff

 

Prerequisites:

You must have knowledge of SQL or attend the Oracle8i SQL and PL/SQL or SQL/SQL*Plus Develop Queries and Reports courses.

 

Follow-On Courses

Oracle Developer: Forms I

 

 

 

USSMC's ThinkSync to Oracle8i Database Backup and Recovery XORA700

 

Backup and Recover an Oracle Database

Hands-on 2-day course

 

Course Description

Plan and implement an effective database backup and recovery strategy. Develop a strategy to support 24-hour operations. Develop a recovery plan to minimize down time. Gain practical hands-on experience.

 

You Learn to

        Define Oracle8i Architectural Issues for Backup and Recovery

        Understand ARCHIVELOG and NOARCHIVELOG mode

        Enable Archiving

        Understand Implications of 24-Hour Operations

        Perform Hot/Cold Backup and Recovery

        Utilize the Export and Import Utilities

Implement Recovery Manager (RMAN)

 

Who Needs to Attend

         Data Analysts

         Data Administrators

         System Administrators

         Developers

         Support Staff

 

Prerequisites:

You must have knowledge of Oracle Database Administration or attend the Oracle8i Database Administration course.

 

Follow-On Courses

Oracle8i Database Performance Tuning

Oracle8i Networking

 

 

 

USSMC's ThinkSync to Oracle8i Database Performance Tuning XORA800

 

Troubleshoot and Tune and Oracle Database

Hands-on 3-day course

 

Course Description

Develop skills necessary to effectively troubleshoot and performance tune an Oracle database server. Analyze performance statistics and tune cache areas to reduce physical I/O. Understand the tuning requirements of online transaction processing systems, decision support systems and batch oriented system. Gain practical hands-on experience.

You Learn to

        Apply a Tuning Methodology

        Interpret the Utlbstat/Utlestat Report Output

        Distribute I/O

        Utilize Explain Plan, TKPROF and the SQL Trace Diagnostic Tools

        Tune the Shared Pool

        Tune the Database Buffer Cache

        Tune the Redo Mechanisms

        Size and Utilize Blocks Efficiently

        Monitor and Detect Lock Contention

        OLTP vs Batch Tuning Tune Sorts

 

Who Needs to Attend

         Data Analysts

         Data Administrators

         System Administrators

         Developers

         Support Staff

 

Prerequisites:

You must have knowledge of Oracle Database Administration or attend the Oracle8i Database Administration course.

 

Follow-On Courses

Oracle8i Database Backup and Recovery

Oracle8i Networking

 

 

 

USSMC's FastTrack to Oracle8i New Features for Developers XORA8iNF

Utilize the new features of Oracle s 8i object-relational technology.

Hands-on 3-day course

 

Course Description

 

This course will provide participants an introduction to the new features and enhancements of Oracle8i, including object-oriented technology. Topics in this course are: Introduction to Oracle8, New and enhanced features of Oracle8i, Introduction to Object Technology. This seminar is intended to cover major issues a developer will face when working with Oracle8i. Exercises and lab sessions reinforce the learning objectives and provide participants the opportunity to gain practical hands-on experience.

 

You Learn to

         Manage Data Integrity

         Develop Applications in Java

         Utilize Data Management Enhancements

         Utilize Partitioning Enhancements

         Utilize SQL Enhancements

         Utilize PL/SQL Enhancements

         Utilize Security Enhancements

         Utilize Optimizer Enhancements

         Utilize Large Object (LOB) Enhancements

         Utilize Object Type Enhancements

         Utilize Advanced Queuing Techniques

 

Who Needs to Attend

        Developers

        Support Staff

         Database Administrators

 

Prerequisites

Knowledge of Oracle8

 

Follow-On Courses

Java Programming and JDeveloper 3.1, SQL Tuning Techniques, PL/SQL Develop Database Objects

 

 

 

USSMC's FastTrack to Oracle Developer: Reports XRPT100

Design and develop standard reports with Oracle's reporting tool.

Hands-on 3-day course

 

Course Description

This course will help participants develop skills necessary to create standard and customized reports using the Oracle Developer Reports environment. Participants will develop various types of reports including tabular, master/detail, form letters and matrix. Exercises and lab sessions reinforce the learning objectives and provide participants the opportunity to gain practical hands-on experience.

 

You Learn to

        Design Reports

        Customize Data Display

        Execute Reports

        Integrate Text

        Integrate Graphics

        Link Reports

        Create Filters

        Manage Security

Design Reports to Accept Runtime Parameters

 

Who Needs to Attend

        End Users

        Support Staff

        Developers

         Data Analysts

 

Follow-On Courses

SQL Tuning Techniques, PL/SQL Develop Database Objects, Oracle Developer: Forms I

 

 

 

USSMC's FastTrack to Oracle8 Application Developer Certification Boot Camp XORAFRM

 

Develop interactive database applications utilizing the Oracle Developer tool kit.

15 days to certification

 

Certified Oracle Application Developers are in high demand and earn great pay because of their ability to develop Oracle applications. This Boot camp empowers the professional developer with the knowledge and ability to great graphical, interactive database applications utilizing the full capabilities of the Oracle Developer tool kit. This comprehensive course will lead participants through application planning, development and deployment, as they incorporate menus, task bars, objects, triggers, and develop various report formats and business graphics. This course prepares participants for Oracle OCP test certification providing practical hands-on experience and lab exercises.

 

Course Description

Develop skills necessary to build interactive database applications using the Oracle Developer tool kit. Participants will learn how to create multiple-form applications incorporating form objects, event triggers, and record groups. They will practice enhancing their applications to manage files and multiple transactions across modules. Participants will incorporate database level application code by creating PL/SQL object constructs such as stored database procedures, functions, packages, and database triggers. Participants will also learn how to create various types of reports including tabular, master/detail, form letters and matrix using the Oracle Developer Reports environment. Exercises and lab sessions reinforce the learning objectives and provide participants the opportunity to gain practical hands-on experience.

 

You Learn to

        Define and Model an Oracle Relational Database

        Design and Create Database Structures

        Store, Retrieve and Manipulate Data

        Display and Format Data

        Group and Summarize Query Output

        Control Transaction Processing

        Create Query Scripts and Formatted Reports

        Apply Business Rules and Data Integrity Constraints

        Secure Objects and User Access

        Utilize Character and Numeric Functions

        Display Data from Multiple Tables

        Develop Procedural Applications

        Define Variables and Pass Values Between Applications

        Debug PL/SQL Code

        Develop Server Level Applications

        Create and Execute Database Procedures

        Create and Execute Database Functions

        Create and Execute Database Packages

        Pass Values Between Applications

        Compile Applications

        Debug Applications

        Manage Application Dependencies

         Create and Implicitly Execute Database Triggers

         Create Reusable Object Types

        Manipulate Large Object Types

        Develop Form Modules

        Perform Database Operations

        Utilize the Layout Editor

        Navigate Objects

        Perform Advance Query Techniques

        Customize a Form

        Manipulate Items

        Understand Master/Detail Relationships

        Manage Items, Blocks, and Properties

        Create List Of Values (LOV) Box

        Create Application Triggers

        Create Built-Ins

        Canvas Views

        Create Menus

        Organize and access files

        Attach a menu to a form document

        Create and design new menus using different menu item types and menu commands

        Control keys through triggers and command

        Cause the forms application to respond to mouse events

        Manage events in applications based on timers

        Open and close multiple transactions across an application

        Develop modal form applications

        Identify data sources available for queries and DML

        Determine the appropriate data sources for data blocks

        Create data blocks based on stored procedures and nested SELECT statements

        Use record groups to store data for lists and List of Values (LOVs)

        Use record groups to pass data to other Oracle Developer components

         Incorporate charts and reports into applications

         Utilize Project Builder

        Design Reports

        Customize Data Display

        Execute Reports

        Integrate Text

        Integrate Graphics

        Link Reports

        Create Filters

        Manage Security

        Design Reports to Accept Runtime Parameters

 

Who Needs to Attend

        Developers

        Designers

        Support Staff

        Analysts

 

 

 

USSMC's ThinkSync to Oracle8 Database Administrator

 

Certification Boot Camp XORADBA

 

Develop skills necessary to effectively administer an Oracle8 Database.

15 days to certification

 

Certified Oracle Database Administrators are in high demand and earn great pay. This 10 day Boot camp empowers the professional DBA with the tools, knowledge and practical experience needed to perform Oracle Database Administrations task. This comprehensive course will lead participants through Oracle installation planning and deployment as they create, manage, performance tune, backup, recover and network an Oracle8 Database. This course prepares participants for Oracle OCP test certification providing practical hands-on experience and lab exercises.

 

Course Description

Develop skills to effectively administer an Oracle8 Object Relational Database Management System. Enhance your understanding of the Oracle8 architectural components. Troubleshoot and tune an Oracle database server. Analyze performance statistics and tune cache areas to reduce physical I/O. Understand the tuning requirements of online transaction processing systems and decision support oriented systems. Plan and implement an effective database backup and recovery strategy. Develop a strategy to support 24-hour operations. Develop a recovery plan to minimize down time. Participants develop skills necessary to configure and troubleshoot the Oracle8 network architecture. Participants explore the LISTENER, TNSNAMES and SQL*NET configuration files and NET8 Assistant. Exercises and lab sessions reinforce the learning objectives and provide participants the opportunity to gain practical hands-on experience.

You Learn to:

         Define and Model an Oracle Relational Database

         Design and Create Database Structures

         Store, Retrieve and Manipulate Data

         Display and Format Data

         Group and Summarize Query Output

         Control Transaction Processing

         Create Query Scripts and Formatted Reports

         Apply Business Rules and Data Integrity Constraints

         Secure Objects and User Access

         Utilize Character and Numeric Functions

         Display Data from Multiple Tables

         Develop Procedural Applications

         Define Variables and Pass Values Between Applications

         Debug PL/SQL Code

         Understand the responsibilities of an Oracle Database Administrator (DBA)

         Define and understand the Oracle architecture, components, functions, and processes

         Define and size the System Global Area (SGA) Cache

         Create an Oracle8 database

         Start up and shut down a database

         Create and define the logical and physical structure of an Oracle8 database

         Organize the contents of an Oracle8 database

         Size and Resize Database Files

         Manage Partitions

         Create Virtual Databases

         Create Index Organized Tables

         Create Function Based Indexes

         Define SQL Statement Processing

         Create Rollback Segments

         Create User Profiles

         Manage Security

         Define Oracle8 Architectural Issues for Backup and Recovery

         Understand ARCHIVELOG and NOARCHIVELOG mode

         Enable Archiving

         Understand Implications of 24-Hour Operations

         Perform Hot/Cold Backup and Recovery

         Utilize the Export and Import Utilities

         Implement Recovery Manager (RMAN)

         Apply a Tuning Methodology

         Interpret the Utlbstat/Utlestat Report Output

         Distribute I/O

         Utilize Explain Plan, TKPROF and the SQL Trace Diagnostic Tools

         Tune the Shared Pool

         Tune the Database Buffer Cache

         Tune the Redo Mechanisms

         Size and Utilize Blocks Efficiently

         Monitor and Detect Lock Contention

         OLTP vs Batch Tuning

         Tune Sorts

         Define a Network Architecture

         Understand Client/Server Network Components

         Configure Oracle Name Services

         Configure an Oracle Client

         Configure an Oracle Server

         Create/Edit LISTENER..ORA

         Create/Edit TNSNAMES.ORA

         Create/Edit SQLNET.ORA

         Utilize NET8 Assistant

         Configure Multi-Threaded Server

         Configure OEM Agents

 

Who Needs to Attend

        Administrators

        Support Staff

        Developers

        Analysts

 

 

D. SIN 132-51 - Information TECHNOLOGY (IT) PROFESSIONAL SERVICES

FPDS Code D301 IT Facility Operation and Maintenance
FPDS Code D302 IT Systems Development Services
FPDS Code D306 IT Systems Analysis Services
FPDS Code D307 Automated Information Systems Design and Integration Services
FPDS Code D308 Programming Services
FPDS Code D310 IT Backup and Security Services
FPDS Code D311 IT Data Conversion Services
FPDS Code D313 Computer Aided Design/Computer Aided Manufacturing (CAD/CAM) Services
FPDS Code D316 IT Network Management Services
FPDS Code D317 Automated News Services, Data Services, or Other Information Services
FPDS Code D399 Other Information Technology Services, Not Elsewhere Classified

Sr. Database Administrator

Minimum/General Experience: Five (5) years experience in database design and system analysis, current operating systems software internals, and data manipulation languages. General experience in development and maintenance of database systems. Functional Responsibilities: Manages the development of database projects. Plans and budgets staff and resources. When necessary, reallocates resources to maximize benefits. Prepares and delivers presentations on database management systems (DBMS) concepts. Provides daily supervision and direction to support staff.

 

Database Administrator

Minimum/General Experience: This position requires five years experience, which includes analysis, design and programming using state-of-the-art languages and tools. Serves as maintenance programmer to modify existing programs, which correct errors, solves problems and implements enhancements. Functional Responsibility: Analyses user trouble calls and modifies programs to correct problems. Performs operational support, systems administration and help desk support for multiple users in a large network environment. Minimum Education: Bachelor s Degree in Computer Science, Information Systems, Business, Engineering or other related discipline.

 

Web Designer

Minimum/General Experience: This position requires a minimum of five (5) years experience, which includes analysis, design, and implementation of Web Pages using state-of-the-art techniques in Java, HTML FrontPage and database integration tools such as Cold Fusion. Functional Responsibility: Conducts user analysis assesses current customer web designs and those in the industry. Develops sample web designs for user review and input. Works closely with functional users to obtain database requirements for integration with the web. Conceive designs, lays out, and creative artwork for publications, translating facts and features of subject material into graphic terms that best convey intended meaning. Minimum Education: Bachelor s Degree in Computer Science, Information Systems, Business, Engineering or other related technical discipline.

 

Senior Program Analyst

Minimum/General Experience: This position requires a total of eight years experience which includes; use of databases and object oriented languages in the development of administrative system applications, use of C and FORTRAN in development of scientific system applications, and responsibility for software development projects. Team leadership or supervision over other programmers on significant systems and/or software development projects. Functional Responsibility: As an expert programmer, the Senior Programmer Analyst independently develops, modifies, and maintains complex programs which produce several interrelated but different products; Use data from diverse sources supporting multiple users; tests, documents, and writes operating instructions for all work; may perform programming analysis which includes; investigating the feasibility of developing alternate programs, assisting users with defining needs. Minimum Education: Bachelor s Degree in Computer Science, Information Systems, Business, Engineering or other related technical discipline.

 

Software Engineer

Minimum/General Experience: 6yrs., BS/BA in Engineering, Science or Mathematics Functional Responsibilities: Conducts or participates in multidisciplinary research and collaborates with equipment designers and/or hardware engineers in the design, development, and utilization of electronic data processing systems software, Determines computer user needs; advises hardware designers on machine characteristics that affect software systems such as storage capacity, processing speed, and input/output requirements; designs and develops compilers and assemblers, utility programs, and operating systems such as executive programs.

Systems Engineer

 

Minimum/General Experience: 6 yrs., BSEE or Equivalent. Functional Responsibilities: Designs and develops electronic equipment and system- oriented products and prepares related installation, operation and maintenance specification and instruction. Analyzes equipment to establish operation data and conducts tests. Analyzes and prepares Engineering Change Proposals. Performs and analyzes site surveys and recommends optimum equipment placement and software solutions to meet requirements.

 

Systems Administrator

 

Minimum/General Experience: This position requires a minimum of three years experience in administrating UNIX or open systems-compliant systems. Includes operations experience on a large-scale computer system or a multi-server local area network. Functional Responsibility: Supervises and manages the daily activities of configuration and operation of business systems which may be mainframe, mini, or client/server based. Optimizes system operation and resource utilization, and performs system capacity analysis and planning. Provides assistance to users in accessing and using business systems. Minimum Education: Bachelor s Degree in Computer Science, Information Systems, Engineering, Business, or other related discipline

 

Executive Administrative Assistant

 

Minimum/General Experience: This position requires a minimum of one year of experience in performance of administrative functions to support management personnel and technical staff. Excellent skills in spreadsheets and word processing are required. Functional Responsibility: Provides administrative support to management. Prepares financial and project management reports and assist in the development of presentations using graphic tools. Minimum Education: Bachelor s Degree in Business, Accounting or related discipline.

 

Administrative and Clerical

Minimum/General Experience: This position require a minimum on one year of general experience and must possess proficiency to operate standard office machines such as typewriters, copiers and word processors and possess the skill and knowledge to prepare all types of technical material including recommendations, reports viewgraphs, tables, charts and documentation. Functional Responsibility: The administrative/clerical person produces final typed products from the initial input and proofreads material for spelling, grammar, format and consistency. Also, performs general administrative functions in support of contracts and technical staff. Minimum Education: High School Diploma or equivalent, formal secretarial training, vocational or college business courses can serve as a substitute of one years' required experience (one month for one month).

 

Hardware Specialist

Minimum/General Experience: This position requires a minimum of four years experience, which includes: system analysis and evaluation of hardware capabilities and configurations, ADP systems responsibilities, including systems analysis and programming. Must demonstrate the ability to work independently or under only general direction. Functional Responsibility: Reviews computer systems in terms of machine capabilities and man-machine interface. Prepares reports and studies concerning hardware. Prepares functional requirements and specifications for hardware acquisitions. Ensures that problems have been properly identified and solutions will satisfy the user s requirements. Minimum Education: Associate s Degree in Computer Science, Information Systems, Engineering, Business, or other related discipline.

 

IT Technical Writer

Minimum/General Experience: This position requires a minimum of seven years experience of which at least five years must be specialized in IT architectural environments. Specialized experience includes demonstrated experience in writing and editing documents, including technical documentation. Functional Responsibilities: Assists in collecting and organizing information required for preparation of IT user's manuals, IT training materials, installation guides, IT related proposals and other latest trends and technology reports and deliverables. Edits functional descriptions, system specifications and special reports. Demonstrated ability to work independently or under only general direction. Minimum Education: A Bachelor's Degree in English, Literature or related discipline. With six year's general experience of which four years is specialized, a degree is not required.

 

Junior Programmer

Minimum/General Experience: Bachelor s Degree or equivalent and 2 years of general experience. Six (6) years of general experience is considered equivalent to a Bachelor s Degree. With a Masters degree no experience is required. Functional Responsibilities: Develops and revises these IT related courses and prepares appropriate training catalogs. Prepares instructor materials (course outline, background material, and training aids). Prepares student materials (course manuals, workbooks, handouts, completion certificates, and course critique forms). Trains personnel by conducting formal classroom courses, workshops and seminars.

 

Program Manager

Minimum/General Experience: This position requires fifteen years experience of which eight years must be specialized. Specialized experience includes project development from inception to deployment, expertise in the management and control of funds and resources of multiple projects using complex reporting mechanisms, and demonstrated capability in managing multitask contracts and/or subcontracts of various types and complexity. General experience includes increasing responsibilities in information systems and/or communications systems engineering and management. Functional Responsibilities: Performs day-to-day management of overall contract support operation involving multiple projects and groups of personnel. Serves as the primary interface and point-of-contact with government program authorities and representatives on technical and program/project issues. Organizes, directs and coordinates planning and production of all contract support activities. Responsible for formulating and enforcing work standards, assigning contract schedules, reviewing work discrepancies, supervising contractor personnel, and communicating policies, purposes, and goals of the contractor organization to subordinates. Manages and controls financial and administrative requirements of the program/project. Demonstrates excellent writing and communication skills. Establishes and modifies, as necessary, corporate management structure to direct effective contract support activities. Must be capable of negotiating contract terms and conditions with customers. Minimum Education: A Bachelor's degree in Computer Science, Information Systems, Engineering, Business or related discipline. A Masters Degree in one of the disciplines will be considered equivalent to one year of specialized experience and two years general experience.

 

Project Manager

Minimum/General Experience: This position requires a minimum of ten years experience which includes: increasing responsibilities in information systems design and/or management, project development from inception to deployment, expertise in the management and control of funds and resources using complex reporting mechanisms, demonstrated capability in managing multi-task contracts and/or subcontracts of various types and complexity. Functional Responsibility: Serves as the project manager for a large, complex task order (or a group of task orders affecting the same common/standard/migration system) and shall work with the Government Contracting Officer (CO), the contract-level Contracting Officer s Representative (COR), the task order-level COR(s), government management personnel and customer agency representatives. Is responsible for the overall management of the specific task order(s) and insuring that the technical solutions and schedules in the task order are implemented in a timely manner. Performs enterprise wide horizontal integration planning and interfaces to other functional systems. Minimum Education: Bachelor s Degree in Computer Science, Information Systems, Engineering, Business, or other related discipline.

 

Team Leader

Minimum/General Experience: 8yrs. Bachelors Degree or Equivalent Functional Responsibilities: With general guidance from functional management, responsible for providing team leadership to a customer-focused team or group of teams committed to increased quality and productivity. In accordance with organizational goals, provides direction on activities and team members and facilitates team meetings. Identifies and analyzes problems, plans, tasks, and solutions. Monitors team budget and ensures proper use of assets. Represents the team, presenting team suggestions and recommendations. Requires experience in group processes and dynamics. Reports to functional and/or organization management on team accomplishments, achievements, and productivity.

 

 

E. SIN 132-52- Electronic Commerce Services

 

Senior Network Installation Technician

 

Minimum/General Experience: This position requires a minimum of seven years experience which includes: supervision of installation technicians; analysis, design, and installation of local and wide area nets; and analysis and installation of communication systems. Also familiarity with engineering documentation, network configurations and topologies, X.25, TCP/IP, Frame Relay, Bridges, which Routers and includes increasing responsibilities in technical management. Functional Responsibility: Organizes and directs network installation on site surveys. Assesses and documents current site network configuration and user requirements. Designs and optimizes network topologies. Directs and leads preparation of engineering plans and site installation of Technical Design Packages. Develops installation schedules. Mobilizes network installation team. Directs and leads preparation of drawings documenting configuration changes at each site. Prepares site installation and test reports. Coordinates post installation operations and maintenance support. Minimum Education: High School Diploma.

 

Network Installation Technician

 

Minimum/General Experience: This position requires a minimum of three years experience which includes analysis, design, and installation of local area networks; analysis and installation of communications systems; use of engineering documentation, network configurations and topologies, X.25, TCP/IP, Frame Relay, Bridges, and Routers and progressively increasing responsibilities in technical management. Functional Responsibility: Conducts site surveys. Assesses and documents current site network configuration and user requirements. Designs and optimizes network topologies. Follows engineering plans and site installation Technical Design Packages. Develops installation schedules. Works with network installation team. Assists in the preparation of drawing and documenting configuration changes at each site. Prepares site installation and test reports. Minimum Education: High School Diploma.

 

 

USSMC, Inc. Company Contract Administrator: Ms. Brenda Campbell

9701 Apollo Drive, Suite 200 Telephone: 301 322-2247

Largo, Maryland Facsimile: 301 322-8761

www. ussmc.com E-Mail: ussmc1@ussmc.com

 

 

Contract Number: 65-35f-0897p

Period Covered by Contract: 9/27/2004 --- 9/25/2009

General Services Administration
Federal Supply Service

Pricelist current through 09/25/2009

Products and ordering information in this Authorized FSS Information Technology Schedule Pricelist are also available on the GSA Advantage! System. Agencies can browse GSA Advantage! by accessing the Federal Supply Service s Home Page via the Internet at http://www.fss.gsa.gov/

 

III. USSMC Products and Services Price List

A.           132-33: Perpetual Software License

FSC Class 7030-Information Technology Software

 

USSMC EEO Tracking System

 

Number of Concurrent Users

Federal Government Rate

5

$19,200.00

10

$38,400.00

20

$57,600.00

50

$96,000.00

75

$134,400.00

100

$153,600.00

125

$187,200.00

150

$211,200.00

175

$240,000.00

200

$259,200.00

201+

Negotiable

 

 

Please note that prices shown in this table are the base price of product and the actual cost for the Federal Government inclusive of 4% discount. The cost for any customization required by the client is not reflected in these prices.

 

B.           132-34: Maintenance of General Purpose Commercial Information Technology Software

 

The price for our standard maintenance package is 15% of the product base price per year. For example (15%) of the Government s rate of $19,200.This includes:

 

7 am to 7 pm (Eastern Time) technical support (during normal business days)

Toll free support number and support email address (upon contract award)

Regular product upgrades

Extra product upgrades when any changes made to EEOC regulations/ requirements

 

Support Services are billed and made available through support contracts in blocks of 60 hours or more at a cost of $100.00 per hour. Support Services are also available on time available basis without an active support contract at a rate of $125.00 per hour.

 

All products, maintenance, and support services are subject to the terms and conditions of USSMC standard license agreements and the provisions of GSA Federal Supply Schedule. USSMC travel and expenses are billed at actual cost or at then current federal travel guidelines whichever are the lesser. Labor rates for professional services such as custom development, conversion, project management and consulting are also available. (Any costs for customizations are not included in the calculation of the yearly maintenance fee.)

 

C.           132-50: Training

FSC CLASS D399

USSMC Government-site Training Hourly Labor Cost

 

 

 

 

 

 

 

 

 

Job Category

Effective 9/27/2004

9/27/2005

9/27/2006

9/27/2007

9/27/2008

9/27/2009

 

Training Specialist

$72.96

$75.88

$78.91

$82.07

$85.35

$88.77

 

Training Manager

89.28

$92.85

$96.57

$100.43

$104.44

$108.62

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

USSMC Site Training Hourly Labor Cost

 

 

 

 

 

 

 

 

 

Job Category

Effective 9/27/2004

9/27/2005

9/27/2006

9/27/2007

9/27/2008

9/27/2009

 

Training Specialist

$73.72

$76.67

$79.74

$82.92

$86.24

$89.69

 

Training Manager

$90.21

$93.82

$97.57

$101.47

$105.53

$109.75

 

 

USSMC Government-site Training Course Price List

 

 

 

 

 

 

 

Course

Effective 9/27/2004

9/27/2005

9/27/2006

9/27/2007

9/27/2008

9/27/2009

Access 2000 Level 1

$337.92

$351.44

$365.49

$380.11

$395.32

$411.13

Access 2000 Level 2

$429.12

$446.28

$464.14

$482.70

$502.01

$522.09

Access 2000 Advanced

$337.92

$351.44

$365.49

$380.11

$395.32

$411.13

Outlook 2000: Level 1 to Advanced

$206.40

$214.66

$223.24

$232.17

$241.46

$251.12

Linux: Workstation

$1,956.48

$2,034.74

$2,116.13

$2,200.77

$2,288.80

$2,380.36

Windows 2000

$206.40

$214.66

$223.24

$232.17

$241.46

$251.12

PowerPoint 2000 Level 1/ Level 2

$206.40

$214.66

$223.24

$232.17

$241.46

$251.12

Project 2000 Level 1

$337.92

$351.44

$365.49

$380.11

$395.32

$411.13

Project 2000 Level 2

$218.88

$227.64

$236.74

$246.21

$256.06

$266.30

Excel 2000 Level 1/2/3

$206.40

$214.66

$223.24

$232.17

$241.46

$251.12

Word 2000 Level 1/2/3

$206.40

$214.66

$223.24

$232.17

$241.46

$251.12

A+ Certification *

$2,145.60

$2,231.42

$2,320.68

$2,413.51

$2,510.05

$2,610.45

CNA (Certified Novell Admin)-IntraNetware *

$2,208.00

$2,296.32

$2,388.17

$2,483.70

$2,583.05

$2,686.37

CNA (Certified Novell Admin)-Groupwise *

$1,440.00

$1,497.60

$1,557.50

$1,619.80

$1,684.60

$1,751.98

CNE (Cert Network Engineer-IntraNetware *

$7,680.00

$7,987.20

$8,306.69

$8,638.96

$8,984.51

$9,343.89

CNE (Cert Network Engineer-Groupwise *

$7,584.00

$7,887.36

$8,202.85

$8,530.97

$8,872.21

$9,227.10

DBA (Oracle 8 Certified DBA) *

$5,856.00

$6,090.24

$6,333.85

$6,587.20

$6,850.69

$7,124.72

MSCSE Certification *

$4,800.00

$4,992.00

$5,191.68

$5,399.35

$5,615.32

$5,839.93

Network+ Certification *

$2,208.00

$2,296.32

$2,388.17

$2,483.70

$2,583.05

$2,686.37

RHCE (Red Hat Certified Engineer) *

$10,080.00

$10,483.20

$10,902.53

$11,338.63

$11,792.17

$12,263.86

Unix Level 1/ Introduction *

$758.40

$788.74

$820.29

$853.10

$887.22

$922.71

Word Perfect 9.0 Level1 to Advanced

$196.80

$204.67

$212.86

$221.37

$230.23

$239.44

FrontPage 2000 Level 1

$276.48

$287.54

$299.04

$311.00

$323.44

$336.38

FrontPage 2000 Level 2

$395.52

$411.34

$427.79

$444.91

$462.70

$481.21

Paradox 9.0 Advanced

$192.00

$199.68

$207.67

$215.97

$224.61

$233.60

Adobe Illustrator: Introduction to Advanced

$523.20

$544.13

$565.89

$588.53

$612.07

$636.55

Adobe PageMaker 6.5

$648.00

$673.92

$700.88

$728.91

$758.07

$788.39

Corel Draw: Introduction to Advanced

$254.40

$264.58

$275.16

$286.17

$297.61

$309.52

Internet Explorer 5.0 Introduction

$312.00

$324.48

$337.46

$350.96

$365.00

$379.60

Netscape Navigator: Introduction

$312.00

$324.48

$337.46

$350.96

$365.00

$379.60

Corel Presentation

$192.00

$199.68

$207.67

$215.97

$224.61

$233.60

Quattro Pro 9.0 Spreadsheet

$840.00

$873.60

$908.54

$944.89

$982.68

$1,021.99

HTML 4.0 Programming Level 1/Level 2

$240.00

$249.60

$259.58

$269.97

$280.77

$292.00

Java Programming *

$1,896.00

$1,971.84

$2,050.71

$2,132.74

$2,218.05

$2,306.77

Java Programming Advanced *

$1,137.60

$1,183.10

$1,230.43

$1,279.65

$1,330.83

$1,384.06

JavaScript: Enhancing Web Pages *

$383

$398.36

$414.30

$430.87

$448.10

$466.03

JavaScript Programming *

$1,051

$1,093.25

$1,136.98

$1,182.46

$1,229.76

$1,278.95

JavaScript Programming Advanced *

$955

$993.41

$1,033.14

$1,074.47

$1,117.45

$1,162.15

Visual Basic 6.0 Introduction *

$475

$494.21

$513.98

$534.54

$555.92

$578.15

Visual Basic 6.0 Programming Advanced *

$955

$993.41

$1,033.14

$1,074.47

$1,117.45

$1,162.15

ThinkSync TM to Develop Queries and Reports with SQL and SQL*Plus XORA305 *

$6,144

$6,389.76

$6,645.35

$6,911.16

$7,187.61

$7,475.12

ThinkSync TM to PL/SQL Coding Techniques XORA310 *

$4,670

$4,857.22

$5,051.50

$5,253.56

$5,463.71

$5,682.26

ThinkSync TM to Oracle 8 for Experienced SQL Users *

$6,144

$6,389.76

$6,645.35

$6,911.16

$7,187.61

$7,475.12

ThinkSync TM to SQL Tuning Techniques XORA 400 *

$3,710

$3,858.82

$4,013.17

$4,173.70

$4,340.64

$4,514.27

ThinkSync TM to PL/SQL Develop Database Objects XORA 500 *

$6,144

$6,389.76

$6,645.35

$6,911.16

$7,187.61

$7,475.12

ThinkSync TM PL/SQL Developer Boot Camp XORA 550 *

$9,350

$9,724.42

$10,113.39

$10,517.93

$10,938.65

$11,376.19

ThinkSync TM to Oracle 8i Database Administration XORA 600 *

$9,350

$9,724.42

$10,113.39

$10,517.93

$10,938.65

$11,376.19

ThinkSync TM to Oracle 8i Architecture and utilities XORA 605 *

$4,670

$4,857.22

$5,051.50

$5,253.56

$5,463.71

$5,682.26

ThinkSync TM to Oracle 8i Database Backup and Recovery XORA 700 *

$4,670

$4,857.22

$5,051.50

$5,253.56

$5,463.71

$5,682.26

ThinkSync TM to Oracle 8i Database Performance Tuning XORA 800 *

$6,144

$6,389.76

$6,645.35

$6,911.16

$7,187.61

$7,475.12

FastTrack to Oracle 8i New Features for Developer XORA8iNF *

$6,144

$6,389.76

$6,645.35

$6,911.16

$7,187.61

$7,475.12

FastTrack to Oracle Developer: Reports XRPT100 *

$6,144

$6,389.76

$6,645.35

$6,911.16

$7,187.61

$7,475.12

FastTrack to Oracle8 Database Administrator Certification Boot Camp XORADBA *

$22,430

$23,327.62

$24,260.72

$25,231.15

$26,240.40

$27,290.01

FastTrack to Oracle8 Application Developer Certification Boot Camp XORAFRM *

$22,430

$23,327.62

$24,260.72

$25,231.15

$26,240.40

$27,290.01

 

 

 

 

 

 

 

 

 

 

 

 

 

 

USSMC site and Online Training Course Price List

 

 

 

 

 

 

 

Course

Effective 9/27/2004

9/27/2005

9/27/2006

9/27/2007

9/27/2008

9/27/2009

Access 2000 Level 1

$341.44

$355.10

$369.30

$384.07

$399.44

$415.41

Access 2000 Level 2

$433.59

$450.93

$468.97

$487.73

$507.24

$527.53

Access 2000 Advanced

$341.44

$355.10

$369.30

$384.07

$399.44

$415.41

Outlook 2000: Level 1 to Advanced

$208.55

$216.89

$225.57

$234.59

$243.97

$253.73

Linux: Workstation

$1,976.86

$2,055.93

$2,138.17

$2,223.70

$2,312.65

$2,405.15

Windows 2000

$208.55

$216.89

$225.57

$234.59

$243.97

$253.73

PowerPoint 2000 Level 1/ Level 2

$208.55

$216.89

$225.57

$234.59

$243.97

$253.73

Project 2000 Level 1

$341.44

$355.10

$369.30

$384.07

$399.44

$415.41

Project 2000 Level 2

$221.16

$230.01

$239.21

$248.77

$258.73

$269.07

Excel 2000 Level 1/2/3

$208.55

$216.89

$225.57

$234.59

$243.97

$253.73

Word 2000 Level 1/2/3

$208.55

$216.89

$225.57

$234.59

$243.97

$253.73

A+ Certification *

$2,167.95

$2,254.67

$2,344.85

$2,438.65

$2,536.19

$2,637.64

CNA (Certified Novell Admin)-IntraNetware *

$2,231.00

$2,320.24

$2,413.05

$2,509.57

$2,609.95

$2,714.35

CNA (Certified Novell Admin)-Groupwise *

$1,455.00

$1,513.20

$1,573.73

$1,636.68

$1,702.14

$1,770.23

CNE (Cert Network Engineer-IntraNetware *

$7,760.00

$8,070.40

$8,393.22

$8,728.94

$9,078.10

$9,441.23

CNE (Cert Network Engineer-Groupwise *

$7,663.00

$7,969.52

$8,288.30

$8,619.83

$8,964.63

$9,323.21

DBA (Oracle 8 Certified DBA) *

$5,917.00

$6,153.68

$6,399.83

$6,655.82

$6,922.05

$7,198.94

MSCSE Certification *

$4,850.00

$5,044.00

$5,245.76

$5,455.59

$5,673.81

$5,900.77

Network+ Certification *

$2,231.00

$2,320.24

$2,413.05

$2,509.57

$2,609.95

$2,714.35

RHCE (Red Hat Certified Engineer) *

$10,185.00

$10,592.40

$11,016.10

$11,456.74

$11,915.01

$12,391.61

Unix Level 1/ Introduction *

$766.30

$796.95

$828.83

$861.98

$896.46

$932.32

Word Perfect 9.0 Level1 to Advanced

$198.85

$206.80

$215.08

$223.68

$232.63

$241.93

FrontPage 2000 Level 1

$279.36

$290.53

$302.16

$314.24

$326.81

$339.88

FrontPage 2000 Level 2

$399.64

$415.63

$432.25

$449.54

$467.52

$486.22

Paradox 9.0 Advanced

$194.00

$201.76

$209.83

$218.22

$226.95

$236.03

Adobe Illustrator: Introduction to Advanced

$528.65

$549.80

$571.79

$594.66

$618.45

$643.18

Adobe PageMaker 6.5

$654.75

$680.94

$708.18

$736.50

$765.96

$796.60

Corel Draw: Introduction to Advanced

$257.05

$267.33

$278.03

$289.15

$300.71

$312.74

Internet Explorer 5.0 Introduction

$315.25

$327.86

$340.97

$354.61

$368.80

$383.55

Netscape Navigator: Introduction

$315.25

$327.86

$340.97

$354.61

$368.80

$383.55

Corel Presentation

$194.00

$201.76

$209.83

$218.22

$226.95

$236.03

Quattro Pro 9.0 Spreadsheet

$848.75

$882.70

$918.01

$954.73

$992.92

$1,032.63

HTML 4.0 Programming Level 1/Level 2

$242.50

$252.20

$262.29

$272.78

$283.69

$295.04

Java Programming *

$1,915.75

$1,992.38

$2,072.08

$2,154.96

$2,241.16

$2,330.80

Java Programming Advanced *

$1,149.45

$1,195.43

$1,243.25

$1,292.97

$1,344.69

$1,398.48

JavaScript: Enhancing Web Pages *

$387.03

$402.51

$418.61

$435.36

$452.77

$470.88

JavaScript Programming *

$1,062.15

$1,104.64

$1,148.82

$1,194.77

$1,242.57

$1,292.27

JavaScript Programming Advanced *

$965.15

$1,003.76

$1,043.91

$1,085.66

$1,129.09

$1,174.25

Visual Basic 6.0 Introduction *

$480.15

$499.36

$519.33

$540.10

$561.71

$584.18

Visual Basic 6.0 Programming Advanced *

$965.15

$1,003.76

$1,043.91

$1,085.66

$1,129.09

$1,174.25

ThinkSync TM to Develop Queries and Reports with SQL and SQL*Plus XORA305 *

$6,208.00

$6,456.32

$6,714.57

$6,983.16

$7,262.48

$7,552.98

ThinkSync TM to PL/SQL Coding Techniques XORA310 *

$4,719.05

$4,907.81

$5,104.12

$5,308.29

$5,520.62

$5,741.45

ThinkSync TM to Oracle 8 for Experienced SQL Users *

$6,208.00

$6,456.32

$6,714.57

$6,983.16

$7,262.48

$7,552.98

ThinkSync TM to SQL Tuning Techniques XORA 400 *

$3,749.05

$3,899.01

$4,054.97

$4,217.17

$4,385.86

$4,561.29

ThinkSync TM to PL/SQL Develop Database Objects XORA 500 *

$6,208.00

$6,456.32

$6,714.57

$6,983.16

$7,262.48

$7,552.98

ThinkSync TM PL/SQL Developer Boot Camp XORA 550 *

$9,447.80

$9,825.71

$10,218.74

$10,627.49

$11,052.59

$11,494.69

ThinkSync TM to Oracle 8i Database Administration XORA 600 *

$9,447.80

$9,825.71

$10,218.74

$10,627.49

$11,052.59

$11,494.69

ThinkSync TM to Oracle 8i Architecture and utilities XORA 605 *

$4,719.05

$4,907.81

$5,104.12

$5,308.29

$5,520.62

$5,741.45

ThinkSync TM to Oracle 8i Database Backup and Recovery XORA 700 *

$4,719.05

$4,907.81

$5,104.12

$5,308.29

$5,520.62

$5,741.45

ThinkSync TM to Oracle 8i Database Performance Tuning XORA 800 *

$6,208.00

$6,456.32

$6,714.57

$6,983.16

$7,262.48

$7,552.98

FastTrack to Oracle 8i New Features for Developer XORA8iNF *

$6,208.00

$6,456.32

$6,714.57

$6,983.16

$7,262.48

$7,552.98

FastTrack to Oracle Developer: Reports XRPT100 *

$6,208.00

$6,456.32

$6,714.57

$6,983.16

$7,262.48

$7,552.98

FastTrack to Oracle8 Database Administrator Certification Boot Camp XORADBA *

$22,664.05

$23,570.61

$24,513.44

$25,493.97

$26,513.73

$27,574.28

FastTrack to Oracle8 Application Developer Certification Boot Camp XORAFRM *

$22,664.05

$23,570.61

$24,513.44

$25,493.97

$26,513.73

$27,574.28

 

 

 

 

 

 

 

* Not offered online

 

 

 

 

 

 

D.          132-51: Professional Information Technology Services

FSC CLASS D301 - Resources and Facilities Management

FSC CLASS D302 - Database Planning and Design

FSC CLASS D306 - Systems Analysis and Design

FSC CLASS D308-1 - Programming

FSC CLASS D311 - Conversion and Implementation Support

FSC CLASS D316 - Network Services Project Management

FSC CLASS D317 - Data/Records Management

 

 

 

USSMC Government Site Hourly Labor Rate, SIN 132-51

IT Professional Services

 

 

 

 

 

 

 

Job Category

Effective 9/27/2004

9/27/2005

9/27/2006

9/27/2007

9/27/2008

9/27/2009

 

Sr. Database Administrator

$125.00

$130.00

$135.20

$140.61

$146.23

$152.08

 

Database Administrator

$100.00

$104.00

$108.16

$112.49

$116.99

$121.67

 

Web Designer

$108.77

$113.12

$117.65

$122.35

$127.25

$132.34

 

Sr Program Analyst

$120.91

$125.75

$130.78

$136.01

$141.45

$147.11

 

Software Engineer

$79.20

$82.37

$85.66

$89.09

$92.65

$96.36

 

System Engineer

$84.90

$88.30

$91.83

$95.50

$99.32

$103.29

 

Systems Administrator

$71.95

$74.83

$77.82

$80.93

$84.17

$87.54

 

Executive Administrative Assistant

$43.78

$45.53

$47.35

$49.25

$51.22

$53.27

 

Administrative and Clerical

$27.84

$28.95

$30.11

$31.32

$32.57

$33.87

 

Hardware Specialist

$62.11

$64.59

$67.18

$69.87

$72.66

$75.57

 

IT Technical Writer

$124.80

$129.79

$134.98

$140.38

$146.00

$151.84

 

Jr. Programmer

$67.44

$70.14

$72.94

$75.86

$78.90

$82.05

 

Program Manager

$142.27

$147.96

$153.88

$160.03

$166.44

$173.09

 

Project Manager

$124.94

$129.94

$135.14

$140.54

$146.16

$152.01

 

Team Leader

$105.89

$110.13

$114.53

$119.11

$123.88

$128.83

 

 

 

USSMC Site Hourly Labor Rate, SIN 132-51

IT Professional Services

 

 

 

 

 

 

 

Job Category

Effective 9/27/2004

9/27/2005

9/27/2006

9/27/2007

9/27/2008

9/27/2009

Sr. Database Administrator

$126.30

$131.35

$136.61

$142.07

$147.75

$153.66

 

Database Administrator

$101.40

$105.46

$109.67

$114.06

$118.62

$123.37

 

Web Designer

$109.90

$114.30

$118.87

$123.62

$128.57

$133.71

 

Sr. Program Analyst

$122.17

$127.06

$132.14

$137.42

$142.92

$148.64

Software Engineer

$80.03

$83.23

$86.56

$90.02

$93.62

$97.37

 

System Engineer

$85.79

$89.22

$92.79

$96.50

$100.36

$104.38

 

Systems Administrator

$72.70

$75.61

$78.63

$81.78

$85.05

$88.45

 

Executive Administrative Assistant

$44.23

$46.00

$47.84

$49.75

$51.74

$53.81

 

Administrative and Clerical

$28.13

$29.26

$30.43

$31.64

$32.91

$34.22

 

Hardware Specialist

$62.76

$65.27

$67.88

$70.60

$73.42

$76.36

 

IT Technical Writer

$126.10

$131.14

$136.39

$141.85

$147.52

$153.42

 

Jr. Programmer

$68.14

$70.87

$73.70

$76.65

$79.71

$82.90

 

Program Manager

$143.75

$149.50

$155.48

$161.70

$168.17

$174.89

 

Project Manager

$126.25

$131.30

$136.55

$142.01

$147.69

$153.60

 

Team Leader

$106.99

$111.27

$115.72

$120.35

$125.16

$130.17

 

 

 

 

 

 

 

 

 

USSMC will accept Labor Hour or Firm Fixed Price task orders. Any travel required will be in addition to the labor rates. Travel will be reimbursed in accordance with Join Travel Regulations (JTR) and will be burdened with G&A.

 

 

 

E.           132-52: Electronic Commerce Services

 

USSMC Government-site Hourly Labor Rate, SIN 132-52 Ecommerce Services

 

 

 

 

 

 

 

Job Category

Effective 9/27/2004

9/27/2005

9/27/2006

9/27/2007

9/27/2008

9/27/2009

Senior Network Installation Technician

$107.04

$111.32

$115.77

$120.41

$125.22

$130.23

Network Installation Technician

77.66

$80.77

$84.00

$87.36

$90.85

$94.49

 

 

 

 

 

 

 

 

 

 

USSMC Site Hourly Labor Rate, SIN 132-52 Ecommerce Services

 

 

 

 

 

 

 

Job Category

Effective 9/27/2004

9/27/2005

9/27/2006

9/27/2007

9/27/2008

9/27/2009

Senior Network Installation Technician

$108.16

$112.48

$116.98

$121.66

$126.53

$131.59

Network Installation Technician

$78.47

$81.61

$84.87

$88.27

$91.80

$95.47