Logo
Help
SEPCo
  Home > Catalog > Computer Training course details 
What We Offer !
About Us !
Catalog
Course Registration
Course Schedule
Map
 

 
Header Image

Computer Training Course Details 

PS1101 PC 101 SOFTWARE    NEW

1 Day
Location: SRTCC
Contact: SRTCC Staff, Kendall Lee 504-728-1211

Overview:

This course is to help understand how to setup install and configure your MOP, MOB, VPN and Outlook mail. It will also cover mapping network drives network printers and setting this all through a high speed internet connection, like DSL, wireless, and hard wired , also using the old phone lines. It will also have some tricks and tips on how to do this all very simple and easy!

Designed For:

Anyone that wants to know about computer software, to be able to identify ports, drives, all trouble shooting tricks it takes to get connected with Shell !

Prerequisites:

None

Objectives:

Upon completion of this course, the student should be able to:

  • Identify all external ports.

  • Identify the difference between MOP, MOB, VPN
  • Learn how high speed wireless works.
  • Learn how to setup a network drive.
  • Learn how to setup a network printer
  • Learn how to install new software on the GI system.
  • Learn how to setup a number of things in Outlook Email
  • Learn how to do basic maintenances/troubleshooting
  • Learn how to do it all safely.

Outline:

First ½ of Day
  1. Intro to Basic Computer Hardware/Software
  2. Identify external ports
  3. Cover safety for you and your PC
  4. Identify the proper ports/slots for MOP, MOB, VPN use
  5. Identify all network components that allow you to get connected to Shell

Second ½ of Day
  1. Hands-on session
  2. Basic Maintenance
  3. Bring your computer or laptop and we can get you setup !

PS8271 MS PROJECT 2000 INTRODUCTION

1 Day
Location: SRTCC
Contact: SRTCC Staff,  504-728-1200

Overview

This course covers project scheduling and data management.

Designed For

Personnel needing to manage project or schedule data.

Prerequisites

Windows

Objectives

Upon completion of this course, the student should be able to:

  • Understand the basics of working with MS Project
  • Create and enter data for a project
  • Set up task relationships
  • Add and assign resources
  • Analyze the project
  • Display, Sort, and Filter project data

Outline

  1. FUNDAMENTALS OF PROJECT MANAGEMENT
    1. Examining Microsoft Project 4.0
  2. STARTING A PROJECT
    1. An Overview of the Planning Process
    2. Defining Project Information
  3. TASK RELATIONSHIPS
    1. Linking Tasks and observing the Critical Path
    2. Modifying task relationships
    3. Constraints
  4. OUTLINING
    1. Organizing the task list into an Outline
    2. Viewing Levels of Detail
  5. ADDING & ASSIGNING RESOURCES
    1. Creating and assigning a Base Calendar
    2. Entering and assigning Resources
    3. Working with Project Costs
  6. ANALYZING THE PROJECT
    1. Resolving time restrictions
    2. Resolving resource conflicts
  7. DISPLAYING PROJECT DATA
    1. Exploring Views
    2. Generating Project Reports
  8. SORTING & FILTERING DATA
    1. Sorting Project Data
    2. Filtering Project Data
    3. Creating Custom filters
  9. SETTING & TRACKING THE PLAN
    1. Creating a Baseline Plan
    2. Previewing the Baseline Report
    3. Tracking Progress 

PS8282 MS WORD 2000 INTERMEDIATE

1 Day
Location: SRTCC
Contact: SRTCC Staff,  504-728-1200

Overview

This course covers advanced tables, text styles, text columns, word and clip art, autotext, labels and envelopes, and inserting Excel or  PowerPoint data using Microsoft Word.

Designed For

Personnel needing more advanced skills in MS Word

Prerequisites

Microsoft Word Introduction

Objectives

Upon Completion of this course students will be able to:

  • Understand advanced table formatting
  • Use Text Styles
  • Create Text Columns
  • Insert and format Word and Clip Art
  • Work with AutoText
  • Create Labels and Envelopes
  • Insert Excel or  PowerPoint data into a Word document

Outline

  1. ADVANCED TABLE CONCEPTS
    1. Creating Tables from text
    2. Adding columns and rows to the table
    3. Merging Rows
    4. Entering Table Titles
    5. Adding Calculations to the Table
    6. Formatting Table Text
    7. Adding Shading or Patterns to tables
    8. Table and cell justification
  2. WORKING WITH TEXT STYLES
    1. Using existing text styles
    2. Creating a Text Style
    3. Converting an existing Text style
    4. Using Text Styles to set Table of Contents Headings
  3. WORKING WITH COLUMNS
    1. Creating Text Columns
    2. Adding Text Columns to a portion of the document
    3. Inserting Column Breaks
    4. Format Columns
    5. Changing the Column Layout
  4. ADDING PICTURES TO THE DOCUMENT
    1. Inserting a Word Picture
    2. Inserting Pictures from files
    3. Format and Justify a Picture in the document
  5. WORD ART
    1. Inserting Word Art
    2. Formatting Word Art
    3. Changing the Text Color and WordArt Style
    4. Sizing and Moving WordArt
  6. CLIP ART
    1. Adding Word Clip Art
    2. Using the Shell ELS Clip Art
    3. Adding the Shell Pectin to Documents
  7. ADDING TEXT ANIMATION TO DOCUMENTS
    1. Adding Animation
    2. View Animation
  8. AUTOTEXT
    1. Creating AutoText Templates
    2. Inserting AutoText
  9. CREATING ENVELOPES AND LABELS
    1. Creating Envelopes
    2. Creating a full page of labels
    3. Creating a single label
    4. Printing Envelopes and labels

PS8290 MS WORD 2000 ADVANCED

1 Day
Location: SRTCC
Contact: SRTCC Staff,  504-728-1200

Overview

This course covers macros, databases, form letters, and mail merge, document sections, document templates, forms, revision codes, table of contents, indexes, and data fields using Microsoft Word.

Designed For

Personnel needing advanced desktop publishing techniques in MS Word

Prerequisites

Microsoft Word Introduction and Intermediate

Objectives

Upon Completion of this course students will be able to:

  • Create Macros
  • Create Databases
  • Create Form Letters
  • Create Forms
  • Create Document Templates
  • Insert Revision Codes
  • Add Tables of Content and Indexes
  • Work with Data fields into the Word Document

Outline

  1. MACROS
    1. Help On Macros
    2. Recording A Macro
    3. Special Macro Keystrokes
    4. Save A Macro
    5. Play Back A Macro
    6. Edit A Macro
    7. Add A Macro To The Word Toolbar
  2. WORKING WITH DATABASES IN WORD
    1. Creating Data Files
    2. Creating Form Letters
    3. Setting The Data Relationship
    4. Using Microsoft Access As A Data Source
    5. Adding Fields To The Form Letter
    6. Performing Mail Merges
    7. Mail Merge To Labels / Envelopes
  3. USING SECTIONS IN DOCUMENTS
    1. Introduction To Sections
    2. Inserting A New Section
    3. Adding Different Headers And Footers To Multiple Sections
    4. Page Numbering In Sections
    5. Mixing Landscape And Portrait In A Single Document
  4. WORD TEMPLATES
    1. Creating A New Template File
    2. Inserting Template Text
    3. Saving A Template File
    4. Edit An Existing Template
    5. Creating A File From A Template
  5. FORMS
    1. Creating A Form Template
    2. Adding Text Fields
    3. Adding Option Boxes
    4. Protecting The Form
    5. Saving The Form
    6. Using The Form Template

PS8320 ACCESS 2000 INTERMEDIATE

1 Day
Location: SRTCC
Contact: SRTCC Staff,  504-728-1200

Overview

This course covers database normalization, table relationships, enhanced table design, indexing, referential integrity, intermediate form design, subforms, customized reporting, charts, and mailing labels in Microsoft Access.

Designed For

This training is recommended for individuals who need to customize data entry forms and reports, create charts or mailing labels, and maintain database information.

Prerequisites

Basic NT Skills and Introduction To Access

Objectives

Upon completion of this course, the student should be able to:  

  • Create tables with normalized data
  • Set table relationships for multiple tables
  • Set field properties in tables
  • Perform multiple table queries
  • Design enhanced data entry forms
  • Create subforms
  • Perform enhanced reporting using Microsoft Access
  • Customize Access reports
  • Use Access to create charts
  • Create mail label reports

Outline

  1. DATA NORMALIZATION
    1. Normalize Data Rules in Table Creation
  2. TABLE RELATIONSHIPS
    1. One-To-One Relationships
    2. One-To-Many Relationships
    3. Correcting a Many-To-Many Relationship
    4. Setting and Using Referential Integrity
  3. FIELD PROPERTIES IN TABLES
    1. Setting Field Defaults
    2. Working with Lookups
    3. Data Validation
    4. Indexing
  4. SELECT QUERIES
    1. Calculations in Queries
    2. Multiple-Table Queries
  5. ENHANCED FORM DESIGN
    1. Customizing the Form Design
    2. Adding Calculations to the Form
    3. Using Drawing Options on the Form
    4. Adding Text Boxes to the Form
    5. Adding Label Boxes to the Form
    6. Adding Combo Boxes to the Form
  6. FORMS AND SUBFORMS
    1. Creating a Subform within a Form
    2. Using Form Wizard to Create a Form and Subform
  7. ENHANCED REPORTING
    1. Adding Fields to a Report
    2. Formatting the Report
    3. Grouped Report Options
    4. Adding Calculations Other than SUM
    5. Subreports
  8. CREATING CHARTS
    1. Charting Access Data
  9. MAILING LABELS
    1. Creating a Mail Label Report

PS8321 ACCESS 2000 ADVANCED

1 Day
Location: SRTCC
Contact:  SRTCC Staff,  504-728-1200

Overview

Students will learn how to create action queries, more efficient forms and reports, and macros. This course meets the Microsoft Proficiency Guidelines for Access at the Expert level.

Designed For

Students enrolling in this course should be able to work with Access at an intermediate level, and understand Access terminology.

Prerequisites

Access 97: Level 1 and Access 97: Level 2 or equivalent knowledge.

Objectives

Upon completion of this course, the student should be able to:

  • Make select queries more versatile by using parameters; and use action queries to update data values and add or delete records.
  • Refine the information derived from queries by creating outer joins and using crosstab queries.
  • Enhance form design by manipulating control object properties.
  • Automate simple tasks by creating macros to open forms and control form properties.
  • Make forms more functional and automate tasks by creating macros.
  • Enhance the design of reports by hiding repetitive data, grouping data on prefix values, and using functions in controls.
  • Use Access to create links to Internet sites, and to save data as HTML documents.

Outline

  1. DESIGNING PARAMETER AND ACTION QUERIES
    1. Creating parameter queries
    2. Creating action queries
  2. OUTER JOIN AND CROSSTAB QUERY TECHNIQUES
    1. Joining tables and working with join properties
    2. Crosstab queries
    3. Editing limitations in query datasheets
  3. FORM DESIGN ENHANCEMENTS
    1. Building a form based on joined tables; using functions in forms
    2. Using option groups and additional form design enhancements
  4. USING COMMAND BUTTONS AND MACROS WITH FORMS
    1. Creating macros and command buttons
    2. Using macros to control form properties
  5. USING MACROS TO PROVIDE USER INTERACTION AND AUTOMATE TASKS
    1. Using macros to provide user interaction
    2. Using macros to automate tasks
  6. ADVANCED REPORT TECHNIQUES
    1. Hiding duplicate data, grouping data, and using functions in reports
  7. INTRODUCTION TO THE INTERNET
    1. Using hyperlinks

PS8324 EXCEL 2000 INTERMEDIATE

1 Day
Location: SRTCC
Contact: SRTCC Staff,  504-728-1200

Overview

This course covers intermediate worksheet options in Microsoft Excel including graphics, range commands, functions, database options, OLE (Linking worksheets), and drawing tools.

Designed For

Personnel needing to manipulate data in excel or create graphics and manage graphics data.

Prerequisites

Windows 98, NT, or 2000 Introduction equivalent knowledge and Introduction to Excel

Objectives

Upon Completion of this course students will be able to:

  • Work with advanced Charting options
  • Create Range Names
  • Add intermediate functions
  • Adds pictures, lines, boxes, and text boxes to the worksheet
  • Link worksheet to information on other worksheets
  • Perform sorts, extracts and other database functions
  • Format drawn objects on the worksheet.

Outline

  1. CHARTS
    1. Create A Chart On Its Own Chart Sheet
    2. Create An Embedded Chart On The Worksheet
    3. Modify The Chart Type
    4. Custom Chart Types
    5. Creating 3D Charts
    6. Adding And Deleting Chart Items
    7. Including But Not Displaying Chart Information
    8. Moving And Sizing A Chart
  2. FORMAT CHART ITEMS
    1. Add And Format Chart Titles And Headings
    2. Format Chart Numbers
    3. Formatting 3D Options
    4. Change The Chart Background
    5. Set The Axis Options
    6. Legend Options
    7. Printing A Chart Sheet Or Embedded Chart With Data
  3. ADDING PICTURES TO WORKSHEETS
    1. Adding A Picture From Excel
    2. Adding Pictures From Files
  4. DRAWING TOOLS
    1. Adding Lines In The Worksheet
    2. Adding Autoshapes To The Worksheet
    3. Formatting Drawn Objects
  5. SORTING DATA IN THE WORKSHEET
    1. Using Quick Sort Options
    2. Sorting Information
    3. Multiple Level Sorting
    4. Sort Options In Excel
  6. FILTERS IN EXCEL
    1. Using Filters to Narrow a list of data
    2. Using AutoFilter
    3. And VS Or Criteria
    4. Entering Filter Criteria
    5. Using Multiple Criteria
    6. Working With A Filtered List
  7. RANGE NAMING
    1. Creating a Range Name
    2. Edit the Locations for a Range Name
    3. Using Range Names As References
    4. Using Range Names As Formulas
    5. GOTO Using Range Names
  8. THE @IF FUNCTION
  9. WORKING WITH MULTIPLE WORKBOOKS
    1. Linking Data In Multiple Workbooks
    2. Linking Data Between Worksheets

PS8325 ACCESS 2000 BASIC APPLICATIONS

1 Day
Location: SRTCC
Contact: SRTCC Staff,  504-728-1200

Overview

Students will learn how to design and create basic applications using forms, macros, customized buttons, macro groups and customization tools.

Designed For

Students enrolling in this course should understand the basic concepts involved in working with a personal computer.  For example, students should be familiar with such terms as computer memory, data files, and program files.

Prerequisites

Students should understand the basics of Microsoft Windows 95 and Access Introduction, Intermediate, and Advanced.

Objectives

Upon completion of this course, the student should be able to:

  • Plan the application
  • Create application objects
  • Work with external data
  • Work with imported data
  • Create lookup forms and subforms
  • Create graphics
  • Work with main forms and the autoexec macro
  • Add command button macros
  • Create macro groups
  • Use macro names, actions and arguments to run application menu forms
  • Format the application
  • Create custom menus and toolbars
  • Hide the database window
  • Learn about modules

Outline

DAY 1

  1. Planning the Application
  2. Creating Application Objects
  3. Working with external data
  4. Working with imported data
  5. Creating lookup form and subforms
  6. Creating Graphics
  7. Main Forms and the AutoExec Macro
  8. Add Command Button Macros

DAY 2

  1. Creating Macro Groups
  2. Using Macro Names, Actions and Arguments to run Application Menu Forms
  3. Formatting the Application
  4. Creating Custom Menus and Toolbars
  5. Hiding the Database Window
  6. Introduction to Modules
  7. Introduction to Access Basic Code

PS8329 Excel 2000 Advanced

1 Day
Location: SRTCC
Contact: SRTCC Staff,  504-728-1200

Overview

Students will learn various advanced techniques for analyzing and manipulating data.

Designed For

Students enrolling in this course should understand the basic concepts involved in using Excel 2000.  For example, they should be familiar with  data types (text and values), copying data, basic formulas and functions, and opening and saving files

Prerequisites

Windows 2000: Introduction and Excel 2000: Worksheets, or equivalent knowledge.

Objectives

Upon Completion of this course students will be able to:

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

Outline

  1. Customizing the work area

    1. Working with Built-in Toolbars

    2. Using Custom Toolbars

    3. Creating and Using Styles

    4. Using Templates

  2.  Advanced Formula Construction

    1. Using Names

    2. Using the IF Function

    3. Using the VLOOKUP Function

    4. Using the IS Functions and the Auditing Features

  3.  Using Pivot Tables

    1. Creating Pivot Tables

    2. Modifying Pivot Tables

    3. Grouping and Summarizing Data in a Pivot Table

    4. Creating Interactive Pivot Tables for the Web

  4.  Working with Multiple Worksheets

    1. Working with Workbooks

    2. Linking Cells in Different Workbooks

    3. Workbook Versus Links and Workspaces

    4. Sharing and Merging Workbooks

  5.  Consolidating and Analyzing Data

    1. Consolidating Data from More than one Worksheet

    2. Using the Goal Seek and Solver Utilities

    3. Using Scenario Manager to View a Worksheet with Different Input Values

  6.  Using Protection and Display Options

    1. Using Comments

    2. Protecting Workbooks

    3. Using Custom Views

  7.  Introduction to Macros

    1. Running a Macro

    2. Recording a Macro

    3. Viewing and Editing VBA Code

  8.  Working with Interactive Excel Web Documents

    1. Saving Excel Worksheets as Web Documents

    2. Spreadsheet Web Components

PS8346 ACROBAT 5.0 INTRODUCTION

1 Day
Location: SRTCC
Contact:  SRTCC Staff,  504-728-1200

Overview:

In Acrobat 5.0: Introduction (Windows) , you will explore the Acrobat 5.0 work environment, and practice creating and manipulating Portable Document Format (PDF) files. Some of the topics you will cover include: how to create a PDF file, how to modify a PDF file by adding navigation to it, how to add sound and movie clips to a PDF file, how to annotate (add additional comments to) a PDF file, how to create PDF forms, how to create an index of PDF documents, how to add security to PDF documents, and how to distribute PDFs.

Designed For:

  • Delivery Method:   Acrobat 5.0: Introduction (Windows) is a hands-on instruction book that teaches you to use Adobe Acrobat and to create and manipulate Portable Document Format (PDF) files.
  • Benefits:  The student will be able to set up Acrobat print drivers and identify various ways to create and manage PDF files. They will gain a complete understanding of the Acrobat suite of products including Acrobat Distiller and Acrobat Catalog.
  • Target student:  Those who are responsible for converting documents into Acrobat PDF formats or anyone interested in creating electronically distributed PDF documents.
  • Hardware/Software Requirements: You will need:
    • At least 64 megabytes (MB) of Random Access Memory (RAM).
    • At least 50 MB of free hard disk space.
    • A 200 MHz or faster Intel Pentium processor.
    • Windows 95, 98, NT (version 4.0), or 2000.
    • A 256-color (or higher) monitor capable of at least 800 x 600 resolution.
    • A CD-ROM drive.
    • An Internet connection.
    • Microsoft Internet Explorer 4.0 or later.
    • Microsoft Outlook Express or an equivalent e-mail application.
    • Adobe Acrobat 5.0.
    • Microsoft Word 97 or 2000.
    • Apple QuickTime Player (newest version available from http://www.apple.com—this is a free download).
    • A sound card and speakers.

Prerequisites:

Students should have basic knowledge of computers and experience in navigating around the Microsoft Windows work environment. No previous knowledge of Acrobat is required.

Objectives:

Performance-Based Objectives

Lesson objectives help students become comfortable with the course, and also provide a means to evaluate learning. Upon successful completion of this course, students will be able to:

  • Create a PDF file from various media, including electronic files, Web pages, and scanned images.
  • Modify PDF files by adding hyperlinks, bookmarks, and movie and sound clips to them.
  • Add graphic and text annotations to a PDF file.
  • Create a Web Ready PDF form and validate data in the form.
  • Index a collection of PDF files.
  • Limit accessibility to PDF files by adding password security and digital signatures to them.
  • Optimize and distribute PDF files.

Outline:

  1. Introduction to Acrobat 5.0

    1. Getting to Know Acrobat 5.0

    2. Creating PDF Files

  2. Modifying PDF Files

    1. Adding Navigation Tools

    2. Creating Non-PDF Files

    3. Movie Clips and Sounds: Adding Multimedia Elementsto a PDF File

  3. Annotating PDF Files

    1. Annotations

    2. Sharing Comments Online

  4. Designing and Using Electronic Forms

    1. PDF Forms and the Web

    2. Form Data Validation

  5. Indexing PDF Files

    1. PDF Prep: Getting PDF Files Ready for Indexing

    2. The Altered Index: What to Do When You Haveto Update an Index

  6. Securing PDF Files

    1. Passwords and Restricted Access

    2. Certificates and Digital Signatures

  7. Optimizing and Distributing PDF Files

    1. PDF Files: Easy Access for People with Disabilities

    2. Optimization

    3. The Four Basic Methods for Distributing PDFFiles

  8. Appendix A: Batch Processing PDF Files

    1. Implementing Batch Processing Techniques

  9. Appendix B: PDF Consultant

    1. Using PDF Consultant to Analyze and Repair Files

PS8363 ACCESS 2000 INTRODUCTION

1 Day
Location: SRTCC
Contact: SRTCC Staff, 504-728-1200

Overview

Students will learn the basic skills necessary to begin using Access 97. They will design and create databases, tables, queries, forms, and reports. This book was written using the Windows 95 platform; however, the manufacturer states that it can also be used with Windows NT. This course meets the Microsoft Proficiency Guidelines for Access at the Expert level.

Designed For

Students enrolling in this course should understand the basic concepts involved in working with a personal computer (PC). For example, students should be familiar with terms such as computer memory, data files, and program files. Students should also be familiar with the components that make up the PC, including input, output, and storage devices. Students should also be familiar with Windows 95, and be fairly comfortable working in a Windows environment. No prior knowledge of databases or Access is assumed.

Prerequisites

Windows 2000: Introduction or Windows 2000: Transition or equivalent knowledge.

Objectives

Upon completion of this course, the student should be able to:

  • Understand database concepts and terminology in Access 97.
  • 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.

Outline

  1. INTRODUCTION TO ACCESS
    1. The Access Window and Toolbars
    2. The Database Window
    3. Opening a Database File
    4. Access Objects
  2. TABLES
    1. Create Tables Manually
    2. Fields, Field Types, and Field Properties
    3. Primary Keys
    4. Saving Tables
    5. Create Tables Using the Wizard
  3. ENTERING DATA
    1. Entering Data in a New Table
    2. Adding Data to an Existing Table
    3. Special Data Entry Keys
    4. Editing Records
  4. MODIFYING TABLES
    1. Renaming Fields
    2. Adding Fields
    3. Rearranging Fields
    4. Changing Field Properties
  5. USING QUICK FIND AND SORT OPTIONS
    1. Quick Sort Records
    2. Find Using Single Criteria
  6. CREATING SELECT QUERIES
    1. Creating a New Query
    2. Selecting Fields
    3. Setting Sort Options
    4. Calculations in Queries
    5. Using Multiple Tables in Queries
  7. BASIC FORMS
    1. Creating a Form
    2. Adding Text Fields
    3. Adding Label Fields
    4. Moving Fields
    5. Adding Lines and Boxes
  8. BASIC REPORTING
    1. Creating a Tabular Report
    2. Creating a Grouped Report
    3. Basic Report Formatting
  9. DATABASE MAINTENANCE
    1. Creating a New Database File
    2. Compacting the Database

PS8364 EXCEL 2000 INTRODUCTION

1 Day
Location: SRTCC
Contact: SRTCC  Staff,  504-728-1200

Overview

This course covers basic worksheet creation using Microsoft Excel. Students will be able to enter and calculate data, format the worksheet, and create basic graphics.

Designed For

This course is recommended for those who desire a basic understanding of Excel.

Prerequisites

none

Objectives

Upon completion of this course, the student should be able to:  

  • Create basic worksheets
  • Add formulas and functions
  • Move and copy data
  • Set column widths and row heights
  • Work with ranges
  • Use autosum
  • Format text and numbers on the worksheet
  • Add lines and colors
  • Spell check the workbook
  • Print a worksheet
  • Graph a worksheet
  • Sort information
  • Work with multiple worksheets

PS8365 MS WORD 2000 INTRODUCTION

1 Day
Location: SRTCC
Contact:  SRTCC Staff,  504-728-1200

Overview

 This Course covers basic document creation using Microsoft Word.

Designed For

For Personnel needing to create basic documentation using Microsoft Word.

Prerequisites None

Objectives

Upon completion of this course students will be able to:

  • Create documents
  • Save documents
  • Print documents
  • Add tabs
  • Create tables
  • Create headers and footers
  • Format paragraphs
  • Format text
  • Change text size
  • Set Margins
  • Add Page Breaks
  • Spell Check A Document
  • Using Thesaurus
  • Work with Document Templates

Outline

  1. INTRODUCTION THE WORD
    1. The Word Window and Toolbars
    2. Using Help
    3. Creating A Document
    4. Typing Basics
  2. MANAGING WORD DOCUMENTS
    1. Opening an Existing File
    2. Moving Through the Word Document
    3. Working With Multiple Documents
    4. Saving A File
    5. Saving A File with A New Name
    6. Closing Files
  3. FORMAT DOCUMENTS
    1. Formatting Text
    2. Setting Document Margins and Page Breaks
    3. Aligning Text
    4. Text Selection Techniques
    5. Changing the Text Font, Size, Or Color
  4. PARAGRAPH FORMATS
    1. Indenting Text
    2. Working With Tabs
    3. Adding Numbers and Bullets to Lists
    4. Customizing Numbers or Bullets
  5. TABLES
    1. Creating Tables
    2. Entering Data in A Table
    3. Basic Table Formatting
  6. PAGE FORMATS
    1. Setting Margins
    2. Adding Page Breaks
    3. Adding Headers and Footers
  7. DOCUMENT TOOLS
    1. Spell Check A Document
    2. Using Autocorrect
    3. Using Thesaurus
    4. Printing Documents
    5. Printing Options
    6. Document Templates 

PS8366 POWERPOINT 2000 INTRODUCTION

1 Day
Location: SRTCC
Contact:  SRTCC Staff,  504-728-1210

Overview

Students will learn the basic skills necessary to begin effectively creating presentations in Microsoft PowerPoint 97. This book was written using the Windows 95 platform, but it can also be used with Windows NT. This course meets the Microsoft Proficiency Guidelines for PowerPoint at the Expert level.

Designed For

Students enrolling in this course should understand the basic concepts involved in working with a personal computer (PC). No prior knowledge of PowerPoint is assumed.

Prerequisites

Windows 95: Introduction, Windows 95: Making the Transition, or equivalent knowledge.

Objectives

Upon completion of this course, the student should be able to:  

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

Outline

  1. INTRODUCTION TO POWERPOINT
    1. The PowerPoint Main Window and Toolbars
    2. Opening a PowerPoint Presentation
    3. Presentation Views
    4. Moving Through the Presentation
    5. Spell Check a Presentation.
    6. Close a Presentation
  2. CREATING A PRESENTATION
    1. Create a Title Chart
    2. Create a Text Chart
    3. Create a Bullet Chart
    4. Format Bullets
  3. OUTLINE VIEW
    1. Creating slides in outline view
  4. DRAWING TOOLS
    1. Adding lines, autoshapes, and Text Boxes
    2. Formatting Drawn Objects
  5. CLIPART AND WORD ART
    1. Adding ClipArt to the Presentation
    2. Adding WordArt to the Presentation
    3. Formatting WordArt
  6. ORGANIZATION CHARTS
    1. Creating an Organization Chart
    2. Organization Chart Options
    3. Format the Organization Chart
  7. GRAPH CHARTS
    1. Creating a Column Chart
    2. Data Options for Charts
    3. Edit a Chart
    4. Change the Chart Type
    5. Creating Combination Charts
  8. CHART TEMPLATES
    1. Apply a template to the presentation
    2. Changing the Background for individual slides
  9. SLIDE MASTER
    1. Setting Slide defaults
    2. Adding objects to all slides
    3. Changing Bullet defaults
    4. Slide Footers
  10. SLIDE SHOW OPTIONS
    1. Adding Slide Transitions
    2. Adding Slide Timings
    3. Running a Manual or Automatic Show
    4. Speakers Notes
    5. Printing a Presentation

PS8377 EXCEL 2000  INTRODUCTION TO VISUAL BASIC APPLICATIONS

1 Day
Location:  SRTCC
Contact:   SRTCC Staff,  504-728-1200

Course Overview

Students will learn to create and edit macros, and gain an understanding of VBA code.

Designed For

Students enrolling in this course should understand the basic concepts involved in working with a personal computer (PC).  For example, they should be familiar with the components that make up the personal computer, including input, output, and storage devices.

Prerequisites

Windows Orientation, Excel 7.0: Worksheets, and Excel 7.0: Advanced or equivalent knowledge.

Objectives

  • Understand the basics of a Visual Basic Module.
  • Understand how to execute one or more lines of code repetitively.
  • Understand relative and absolute recorded macros, and assign these macros to various objects.
  • Create macros that interact with the user.
  • Create custom functions.
  • Analyze how your code operates and locate the source of errors.
  • Write procedures that test conditions and then run only certain statements based on the results.
  • Organize your macros for easy access.

PS8379  MICROSOFT OFFICE 2000: MACRO PROGRAMMING USING VISUAL BASIC FOR APPLICATIONS

1 Day
Location:  SRTCC
Contact: SRTCC  Staff,  504-728-1210

Overview:

Students will learn to create and edit macros, and gain an understanding of VBA code.

Designed For:

Students enrolling in this course should understand the basic concepts involved in working with a personal computer (PC). For example, they should be familiar with the components that make up the personal computer, including input, output, and storage devices.

Prerequisites:

Windows Orientation, Excel 2000: Worksheets, Excel 2000: Advanced, Word 2000: Level 1, Word 2000: Level 2, and Word 2000: Advanced or equivalent knowledge.

Objectives:

Performance-based objectives

Lesson objectives help students become comfortable with the course, and also provide a means to evaluate learning. Upon successful completion of this course, students will be able to:

  • Run macros and explain the basics of a Visual Basic Module.

  • Create relative and absolute recorded macros and assign macros to various objects in a workbook.

  • Write procedures that test conditions and then run only certain statements based on the results.

  • Write procedures that execute one or more lines of code repetitively.

  • Store Excel macros so they are available in any workbook.

  • Create macros in Word 2000.

  • Create macros that interact with the user.

Outline: 

  1. Introduction to Visual Basic for Applications

    1. Running a Macro

    2. Recording a Macro

    3. Examining Module Design

  2. Assigning Macros

    1. Specifying the Location of Recorded Macros

    2. Assigning Macros to Menus, Buttons, and Toolbars

  3. Creating Decision-Making Code

    1. The If…Then Decision Structure

    2. The If…Then…Else Decision Structure

    3. The Select Case Decision Structure

  4. Using Loop Structures

    1. Using a For…Next Statement

    2. Using a Do…Loop Statement

    3. Using a For Each…Next Statement

  5. Macro Management

    1. Personal Macro Workbook

    2. Assigning Sub procedures to run automatically

  6. Recording a Macro in Word 2000

    1. Running a Macro

    2. Recording a Macro

  7. Interactive Macros

    1. Creating a Custom Message Box

    2. Creating a Custom Input Box

    3. Extracting Data from Excel

  8. Using Macros in PowerPoint and Access

    1. Using Macros in PowerPoint

    2. Using Macros in Access

  9. Debugging and Testing Code

    1. Overview of Debugging

PS8627 POWERPOINT 2000 ADVANCED

1 Day
Location: SRTCC
Contact: SRTCC Staff,  504-728-1200

Overview

This Course covers enhancing PowerPoint presentations using animation, sound, video, and backgrounds as well as basic presentation rules.

Designed For

Personnel needing to create exciting presentations using MS PowerPoint

Prerequisites

Microsoft PowerPoint Introduction

Objectives

Upon completion of this course, the student should be able to:

  • Understand basic presentation rules.
  • Create custom templates
  • Add Powerpoint Clip Art
  • Add Shell Clip Art
  • Add the Shell Pectin To Presentations
  • Use the PowerPoint Drawing Tools
  • Adding animation
  • Create Flow Charts
  • Add sounds to Presentations
  • Add Movies to Presentations
  • Branching To Other Presentations
  • Creating A Play List For Multiple Presentations
  • Understand advanced Presentation options
  • Understand Presentation slide tools

Outline

  1. PRESENTATION BASICS
    1. Rules For Slide Creation
    2. When An Where To Add Pictures And Animation
    3. Slide Colorings
    4. Text Chart Rules
    5. Slide Background Rules
    6. Adding Blank Slides
  2. CREATING CUSTOM TEMPLATES
    1. Adding Slide Backgrounds
    2. Setting Color Schemes
    3. Inserting Custom Objects and Text for All Slides
    4. Saving the Template
  3. USING CLIPART AND WORDART
    1. Adding Powerpoint Clip Art
    2. Adding Shell Clip Art
    3. Adding the Shell Pectin to Presentations
  4. DRAWING TOOLS
    1. Adding Lines, Autoshapes, And Text Boxes
    2. Formatting Drawn Objects
  5. ADDING ANIMATION TO CLIPART OBJECTS
    1. Setting Animation Options
    2. Setting Animation Timing and Order
  6. ADDING ANIMATION TO TEXT
    1. Setting Animation Options
    2. Setting Animation Timing and Order
  7. CREATING FLOW CHARTS
    1. Create A Flow Chart
    2. Format the Flow Chart
  8. ADDING SOUND TO PRESENTATIONS
    1. Insert Sound Files
    2. Hide Sound File Icons
    3. Set Play Options and Animation
  9. ADDING MOVIES TO PRESENTATIONS
    1. Insert Movie Files
    2. Set Play Options
  10. USING BRANCHING AND PLAY LISTS
    1. Branching To Other Presentations
    2. Returning To the Main Presentation
    3. Create A Play List for Multiple Presentations
    4. Using the Powerpoint Viewer
  11. SLIDE SHOW OPTIONS
    1. Add Slide Transitions
    2. Add Slide Timings
    3. Run A Manual or Automatic Show
    4. Speakers Notes
    5. Printing A Presentation
  12. PRESENTATION OPTIONS
    1. Moving Through Slides
    2. Moving Back A Slide
    3. Using Slide Navigator
    4. Using the Pointer as A Show Tool
    5. Pausing A Slide Show

02/19/2010