Excel 2013 Intermediate
Feb
21
8:00 AM08:00

Excel 2013 Intermediate

Excel 2013 Intermediate

February 21, 2018
8:00 - 5:00
CHL Computer Lab, 1103 Balch Blvd.
Stennis Space Center

Cost: $25

To register, contact Troy Teadt at 228-688-3113 or 985-788-3257 or by email at tteadt@prcc.edu, at least one week before the class date.

Overview
Upon successful completion of this course, students will be able to:

  • use Excel templates and user-defined templates to create templates and workbooks.
  • use a variety of techniques to sort and filter data.
  • use various functions and auditing features to create advanced formulas and audit worksheets.
  • use PivotTables, PivotCharts, and other analysis tools to analyze data.

Course Content

Lesson 1: Working with Templates

  • Create a Workbook from an Excel Template
  • Create a Custom Template from an Excel Template
  • Create a Graphic
  • Create a Workbook from a User-defined Template

Lesson 2: Sorting and Filtering Data

  • Sort Data Using Normal and Custom Sorts
  • Add Subtotals to a Worksheet
  • Filter Lists Using Auto Filter
  • Create and Apply Custom Filters
  • Create and Apply Advanced Filters

Lesson 3: Importing and Exporting Data

  • Import Data from the Web
  • Import Data from an External Source
  • Export Data
  • Save a Worksheet as a Web Page
  • Publish a Worksheet to the Web

Lesson 4: Working with Advanced Formulas

  • Share Data Among Worksheets
  • Create a Name for a Range of Cells
  • Use Functions to Create Advanced Formulas
  • Trace Cell Precedents
  • Trace Cell Dependents
  • Locate Errors in Formulas

Lesson 5: Analyzing Data

  • Create a PivotTable Report
  • Create a PivotChart Report
  • Create Scenarios
  • Use Solver
  • Use Goal Seek

Lesson 6: Collaborating

  • Insert and Edit a Hyperlink
  • Add and Edit Comments in a Worksheet
View Event →
ArcGIS Desktop II
Feb
21
to Feb 22

ArcGIS Desktop II

ArcGIS for Desktop II

February 21 - 22 (two days)
8:30 - 4:30 p.m.
MSU Building, 1021 Balch Blvd.
Stennis Space Center

Cost: $25

To register, contact Troy Teadt at least one week prior to class date at 228-688-3113 (o), 985-788-3257 (c), or tteadt@prcc.edu.

Overview
ArcGIS for Desktop II covers advanced software functionality, including:
Georeferencing
Subtypes and Domains
Advanced Labeling and Annotation
Network Analysis
Geodatabase Topology
Data Analysis and Workflows
Advanced Map Layouts
Model Builder

Who Should Attend
Anyone who wants to learn more about advanced functionality in ESRI ArcGIS for Desktop Software.

Goals
Those completing this course will be able to build upon basic ArcGIS for Desktop Skills.

Prerequisites
Introduction to ArcGIS for Desktop or good working knowledge of ArcGIS for Desktop Software

View Event →
Word 2013 Intermediate
Feb
28
8:00 AM08:00

Word 2013 Intermediate

Word 2013 Intermediate

February 28, 2018
8:00 - 5:00
CHL Computer Lab, 1103 Balch Blvd.
Stennis Space Center

Cost: $25

To register, contact Troy Teadt at 228-688-3113 or 985-788-3257 or by email at tteadt@prcc.edu, at least one week before the class date.

Overview
Upon successful completion of this course, students will be able to:

  • create and modify custom templates, apply existing styles, and create a custom style.
  • enhance a table by merging table cells, sorting and calculating table data, and creating charts based on various table data.
  • learn how to insert, manipulate, and format graphic images, including clip art, AutoShapes, WordArt, and organization charts.
  • create a newsletter using columns, sections, and graphics.
  • use the Mail Merge Wizard to mail merge form letters, complete with mailing labels.
  • include comments in a document and compare and merge documents.

Course Content

Lesson 1: Creating and Modifying Templates

  • Apply Styles
  • Modify Styles
  • Create User-Defined Styles
  • Create a Template from an Existing Document

Lesson 2: Managing Tables and Table Data in Documents

  • Convert Tabbed Text into a Table
  • Merge Cells in a Table
  • Open an Excel Table in Word
  • Sort Table Data
  • Perform Calculations in Tables
  • Create and Modify a Chart Based on Word Table Data
  • Link Excel Data in a Word Table

Lesson 3: Adding Graphics

  • Insert a Clip Art Image
  • Add an AutoShape
  • Insert WordArt
  • Insert an Organizational Chart

Lesson 4: Creating a Newsletter

  • Create a Document Section
  • Format Text into Newsletter Columns
  • Control Column Text Flow
  • Wrap Text Around a Graphic
  • Create Envelopes and Labels

Lesson 5: Sending Form Letters

  • Select the Main Document Type
  • Select the Data Source
  • Insert Merge Fields
  • Merge and Preview Form Letters
  • Create Mailing Labels

Lesson 6: Creating a Web Page

  • Create a Web Page Using a Template
  • Preview a Web Page in a Browser
  • Create a Hyperlink in a Web Page
  • Edit a Hyperlink in a Web Page
  • Apply a Theme to a Web Page

Lesson 7: Managing Document Changes

  • Use Comments in Word Documents
  • Compare and Merge Documents

View Event →
PowerPoint 2013 Advanced
Mar
7
8:00 AM08:00

PowerPoint 2013 Advanced

PowerPoint 2013 Advanced

March 7, 2018
8:00 - 5:00
CHL Computer Lab, 1103 Balch Blvd.
Stennis Space Center

Cost: $25

To register, contact Troy Teadt at 228-688-3113 or 985-788-3257 or by email at tteadt@prcc.edu, at least one week before the class date.

Overview
Upon successful completion of this course, students will be able to:

  • create a design template.
  • create organization charts and diagrams.
  • add special effects to a Microsoft® Office PowerPoint®  slide.
  • use advanced animation techniques
  • create a Microsoft® Office PowerPoint®  presentation containing hyperlinks and action controls.

Course Content

Lesson 1: Creating a Custom Design Template

  • Define Design Template Characteristics
  • Create a Custom Color Scheme
  • Set Up a Slide Master
  • Format Custom Bullets
  • Add a Footer
  • Modify the Notes Master
  • Save a Custom Design Template

Lesson 2: Adding Organization Charts and Diagrams

  • Working with Organization Charts
  • Update an Organization Chart
  • Applying a Chart Layout
  • Create a Diagram
  • Draw a Flowchart

Lesson 3: Adding Special Effects

  • Add Sound and Movies
  • Add Animation and Work with Advanced Timeline
  • Emphasize Objects
  • Set a Motion Path
  • Set the Order of Effects

Lesson 4: Creating Presentations Containing Hyperlinks

  • Create a Group Home Page with the AutoContent Wizard
  • Hyperlink to a Web Page
  • Hyperlink to another slide
  • Hyperlink to another MS file

Lesson 5: Collaborating in PowerPoint

  • Set Password Protection
  • Work with Comments
  • Send a Presentation for Review
  • Merge Revision Copies
  • Apply Reviewer Changes

Lesson 6: Delivering a Presentation

  • Hyperlink Within PowerPoint
  • Add an Action Button
  • Set Up a Custom Show
  • Annotate a Presentation
  • Working with Narrations and Slide Timings
  • Set Up a Slide Show to Repeat Automatically

View Event →
Intermediate QGIS
Mar
7
to Mar 8

Intermediate QGIS

Intermediate QGIS

March 7 - 8, 2018
8:30 - 4:30 each day
MSU Building, 1021 Balch Blvd.
Stennis Space Center

Cost: $25

To register, contact Troy Teadt at least one week prior to class date at 228-688-3113 (o), 985-788-3257 (c), or tteadt@prcc.edu.

Overview
Intermediate QGIS presents advanced concepts and techniques not covered in the Introduction to QGIS course.

Who Should Attend
Individuals interested in additional capabilities of QGIS

Goals
Participants completing this course will be able to:

  • Customize the QGIS interface
  • Utilize advanced table management procedures
  • Implement topology concepts in the editing environment
  • Convert vector and raster data formats
  • Process raster data
  • Georeference vector and raster data
  • Create geospatial PDF files
  • Develop a mobile GIS
  • Extend QGIS beyond the desktop
  •  Utilize advanced geoprocessing techniques

Prerequisites
Introduction to QGIS

View Event →
Introduction to ArcGIS Online
Mar
14
to Mar 15

Introduction to ArcGIS Online

Introduction to ArcGIS Online

March 14 - 15, 2018
8:30 - 4:30 each day
MSU Building, 1021 Balch Blvd.
Stennis Space Center

Cost: $25

To register, contact Troy Teadt at least one week prior to class date at 228-688-3113 (o), 985-788-3257 (c), or tteadt@prcc.edu.

Course Description
This two day introductory course begins with an exploration of the ESRI ArcGIS Online  web interface. The functionality of both free and organizational (subscriber) accounts is explored. Participants will learn how to create a web map, work with and manage desktop content, create and configure an ArcGIS Online organizational account (free 30‐day trial subscription), explore member roles for an organizational account, publish feature services, create a webmapping application, use Explorer for ArcGIS to view web maps on a mobile device, and collect/update data using Collector for ArcGIS on a mobile device.

Prerequisites
Working knowledge of ArcGIS for Desktop (ArcMap)

Table of Contents

  • Exercise 1:  Creating a Web Map Using Desktop and Web Content
  • Exercise 2:  Working with Desktop Content on ArcGIS Online
  • Exercise 3:  Creating and Configuring an ArcGIS Online Organizational Account
  • Exercise 4:  Exploring a New ArcGIS Online Organizational Account
  • Exercise 5:  Publishing a Feature Service
  • Exercise 6:  Creating a Parcel Web Map
  • Exercise 7:  Creating a Parcel Viewer Web Mapping Application
  • Exercise 8:  Working with Explorer for ArcGIS
  • Exercise 9:  Publishing a Feature Service for Use with Collector for ArcGIS
  • Exercise 10:  Working with Collector for ArcGIS

 

View Event →
Advanced QGIS
Mar
20
to Mar 21

Advanced QGIS

Advanced QGIS

March 20 - 21, 2018
8:30 - 4:30 each day
MSU Building, 1021 Balch Blvd.
Stennis Space Center

Cost: $25

To register, contact Troy Teadt at least one week prior to class date at 228-688-3113 (o), 985-788-3257 (c), or tteadt@prcc.edu.

Overview
Advanced QGIS focuses on building and managing multi-user database management systems, delivery of map services over the Internet and web-based mapping applications. This 2-day course utilizes the open source software PostGIS/PostgreSQL, GeoServer and GeoExplorer.

Who Should Attend
QGIS users interested in working in a GIS server environment.

Goals
Participants completing this course will be able to:

  • Create an interface between QGIS and geospatial data servers
  • Install and import data into PostGIS
  • Assign PostGIS user privileges to databases and layers
  • Assign PostGIS user privileges to columns and rows in attribute tables
  • Deliver GIS data over the Intranet and Internet with GeoServer
  • Create interactive web mapping applications with GeoExplorer

Prerequisites
Introduction to QGIS

View Event →
Microsoft Access: Part 2
Mar
21
to Mar 22

Microsoft Access: Part 2

Microsoft Access: Level 2

March 21 - 22, 2018 (two day course)
CHL Computer Lab
1103 Balch Blvd., Stennis Space Center, Room 1005

Cost: $40

To register, contact Troy Teadt at 228-688-3113 or 985-788-3257 or by email at tteadt@prcc.edu, at least one week before the class date.

Course Outline:

1.   Advanced Queries
Create Unmatched & Duplicate Queries
Crosstab Queries
Create Subqueries

2.   Implementing Advanced Form Design
Add Controls to Forms
Create Subforms
Organize Information with Tab Pages
Enhance Navigation of Forms
Apply Conditional Formatting

3.  Using Data Validation
Field and Record Validation
Form Validation

4.  Using Macros to Improve User Interface Design
Create a Macro
Restrict Records Using a Condition
Validate Data Using a Macro
Automate Data Entry Using a Macro
Convert a Macro to VBA

5.  Sharing Data Across Applications
Export Access Data to Excel
Export Access Data Create a PivotTable
Export Access Data Create a Mail Merge

6.  Advanced Database Management
Link Tables to External Data Sources
Manage a Database
Determine Object Dependency
Document a Database
Analyze the Performance of a Database

7. Distributing and Securing a Database
Splitting Database for Multiple Users
Implement Security
Set Passwords
Convert Access Database to ACCDE File
Database with Digital Signature

8.   Managing Switchboards
Create a Database Switchboard
Modify a Database Switchboard
Set Startup Options

 

View Event →
Excel 2013 Advanced
Mar
28
to Mar 29

Excel 2013 Advanced

Excel 2013 Advanced

March 28 - 29, 2018
8:00 - 5:00 each day
CHL Computer Lab, 1103 Balch Blvd.
Stennis Space Center

Cost: $40

To register, contact Troy Teadt at 228-688-3113 or 985-788-3257 or by email at tteadt@prcc.edu, at least one week before the class date.

Overview
Upon successful completion of this course, students will be able to

  • customize your workbook by applying conditional formatting, adding data validation criteria, customizing menus and toolbars, creating and editing a macro, and grouping and outlining structured data.
  • work with multiple workbooks to create a workspace, consolidate data, link cells, edit links,
  • collaborate with other Excel users by protecting your workbook
  • chart non-adjacent data, modify chart items, and create a custom chart template.
  • use multiple graphic objects and diagrams to enhance your worksheet.

Course Content

Lesson 1: Customizing your Workbook

  • Apply Conditional Formatting
  • Add Data Validation Criteria
  • Customize Menus
  • Customize Toolbars
  • Create a Macro
  • Edit a Macro
  • Group and Outline Structured Data

Lesson 2: Working with Multiple Data Sources

  • Create a Workspace
  • Consolidate Data
  • Link Cells in Different Workbooks
  • Edit Links

Lesson 3: Collaborating with Others Using Workbooks

  • Protect your Worksheets
  • Protect Your Workbook

Lesson 4: Creating Charts

  • Creating a Chart Sheet
  • Creating an Embedded Chart
  • Comparing Chart Sheets with Embedded Charts

Lesson 5: Modifying Charts

  • Chart Types
  • Modifying Embedded Charts
  • Adding and Deleting Chart Items
  • Moving and Sizing Chart Items

Lesson 6: Formatting a Chart

  • Formatting Chart Text
  • Formatting Labels
  • Printing a Chart Sheet

Lesson 7: Using Graphic Objects to Enhance your Worksheets

  • Create Graphic Objects
  • Resize, Move, and Copy Graphic Objects
  • Change the Order of Graphic Objects
  • Group Graphic Objects
  • Format Graphic Objects
  • Insert Clip Art
  • Modify Clip Art

 

View Event →
Word 2013 Advanced
Apr
4
8:00 AM08:00

Word 2013 Advanced

Word 2013 Advanced

April 4, 2018
8:00 - 5:00
CHL Computer Lab, 1103 Balch. Blvd.
Stennis Space Center

Cost: $25

To register, contact Troy Teadt at 228-688-3113 or 985-788-3257 or by email at tteadt@prcc.edu, at least one week before the class date.

Overview
Upon successful completion of this course, students will be able to:

  • create and distribute a form.
  • automate tasks by writing and revising macros.
  • create references to information in a document.
  • prepare a document for publication.
  • revise documents based on feedback provided by other users.

Course Content

Lesson 1: Creating and Distributing Forms

  • Create a Form Template
  • Insert Fields in a Form Template
  • Protect the Form
  • Test a Form

Lesson 2: Automating Tasks

  • Run Macros
  • Record a Macro
  • Edit a Macro
  • Create Toolbar Buttons
  • Create Custom Menus

Lesson 3: Referencing Document Information

  • Insert Bookmarks
  • Insert Footnotes and Endnotes
  • Add Captions
  • Create Cross-References

Lesson 4: Preparing a Document for Publication

  • Set Book Margins
  • Create Custom Headers and Footers
  • Compile a Table of Contents
  • Index the Document
  • Create a Master Document

Lesson 5: Revising Documents

  • Create Document Versions
  • Distribute a Document
  • Track Changes to a Document
  • Review Document Changes

Lesson 6: Modifying an HTML Page

  • Save Word Documents as Web Pages
  • Edit Web Pages in Word
  • Insert Scrolling Text
  • Place a Movie Clip in a Web Page
  • Insert a Background Sound

 

 

View Event →
Project 2013
Apr
11
to Apr 12

Project 2013

Project 2013

April 11 - 12, 2018
8:00 - 5:00 each day
CHL Computer Lab, 1103 Balch Blvd.
Stennis Space Center

Cost: $40

To register, contact Troy Teadt at 228-688-3113 or 985-788-3257 or by email at tteadt@prcc.edu, at least one week before the class date.

Prerequisites: Windows 8, Windows 7, Windows XP Basic, or equivalent experience

Course Content

Day 1

Unit 1: Getting started
Topic A: Project management concepts
Topic B: Exploring the Project window
Topic C: Working with project files

Unit 2: Working with tasks
Topic A: Creating a task list
Topic B: Modifying a task list
Topic C: Creating a Work Breakdown Structure

Unit 3: Scheduling tasks
Topic A: Setting up task links
Topic B: Working in Network Diagram view
Topic C: Working with advanced task options

Unit 4: Managing resources
Topic A: Creating base calendars
Topic B: Working with resources and calendars
Topic C: Working with resource costs

Unit 5: Working with views and tables
Topic A: Working with views
Topic B: Working with tables

Unit 6: Filtering, grouping, and sorting
Topic A: Working with filters
Topic B: Working with groups
Topic C: Sorting tasks and resources

Unit 7: Finalizing the task plan
Topic A: Finalizing schedules
Topic B: Resolving resource conflicts

Day 2

Unit 8: Tracking project work
Topic A: Managing a project
Topic B: Updating the progress of tasks
Topic C: Observing project progress

Unit 9: Analyzing and adjusting the plan
Topic A: Analyzing the plan
Topic B: Rescheduling tasks

Unit 10: Formatting and reporting
Topic A: Formatting a project file
Topic B: Using drawing tools
Topic C: Printing views and reports
Topic D: Customizing reports
Topic E: Visual reports

Unit 11: Customizing the project environment
Topic A: Creating custom views
Topic B: Creating a custom table

Unit 12: Managing multiple projects
Topic A: Consolidating and sharing projects
Topic B: Sharing resources across projects

Unit 13: Project communications
Topic A: Communicating among a project team
Topic B: Working with hyperlinks

Unit 14: Exchanging project data
Topic A: Importing data
Topic B: Exporting data
Topic C: Copying data

View Event →
Excel 2013 Programming with VBA
Apr
17
to Apr 19

Excel 2013 Programming with VBA

Excel 2013 Programming with VBA

April 17 - 19, 2018
8:00 - 5:00 daily
CHL Computer Lab, 1103 Balch Blvd.
Stennis Space Center

Cost: $100 (includes textbook)

REGISTRATION DEADLINE: April 6, 2018

To register, contact Troy Teadt at 228-688-3113 or 985-788-3257 or by email at tteadt@prcc.edu, NO LATER THAN APRIL 6.

Prerequisite: Proficient knowledge of Microsoft Excel. Knowledge of PivotTables helpful but not required.

Course Content

Getting Started
Introducing Visual Basic for Applications
Displaying the Developer Tab in the Ribbon
Recording a Macro
Saving a Macro-Enabled Workbook
Running a Macro
Editing a Macro in the Visual Basic Editor
Understanding the Development Environment
Using Visual Basic Help
Closing the Visual Basic Editor
Understanding Macro Security

Working with Procedures and Functions
Understanding Modules
Creating a Standard Module
Understanding Procedures
Creating a Sub Procedure
Calling Procedures
Using the Immediate Window to Call Procedures
Creating a Function Procedure
Naming Procedures
Working with the Code Editor

Understanding Objects
Understanding Objects
Navigating the Excel Object Hierarchy
Understanding Collections
Using the Object Browser
Working with Properties
Using the With Statement
Working with Methods
Creating an Event Procedure

Using Expressions, Variables, and Intrinsic Functions
Understanding Expressions and Statements
Declaring Variables
Understanding Data Types
Working with Variable Scope
Using Intrinsic Functions
Understanding Constants
Using Intrinsic Constants
Using Message Boxes
Using Input Boxes
Declaring and Using Object Variables

Controlling Program Execution
Understanding Control-of-Flow Structures
Working with Boolean Expressions
Using the If...End If Decision Structures
Using the Select Case...End Select Structure
Using the Do...Loop Structure
Using the For...To...Next Structure
Using the For Each...Next Structure
Guidelines for use of Control-of-Flow Structures

Working with Forms and Controls
Understanding UserForms
Using the Toolbox
Working with UserForm Properties, Events, and Methods
Understanding Controls
Setting Control Properties in the Properties Window
Working with the Label Control
Working with the Text Box Control
Working with the Command Button Control
Working with the Combo Box Control
Working with the Frame Control
Working with Option Button Controls
Working with Control Appearance
Setting the Tab Order
Populating a Control
Adding Code to Controls
Launching a Form in Code

Debugging Code
Understanding Errors
Using Debugging Tools
Setting Breakpoints
Stepping through Code
Using Break Mode during Run mode
Determining the Value of Expressions

Handling Errors
Understanding Error Handling
Understanding VBA's Error Trapping Options
Trapping Errors with the On Error Statement
Understanding the Err Object
Writing an Error-Handling Routine
Working with Inline Error Handling
 

 

View Event →
Geospatial Python
Apr
18
to Apr 19

Geospatial Python

Geospatial Python

April 18 - 19, 2018
8:30 - 4:30 each day
MSU Building, 1021 Balch Blvd.
Stennis Space Center

Cost: $25

To register, contact Troy Teadt at least one week prior to class date at 228-688-3113 (o), 985-788-3257 (c), or tteadt@prcc.edu.

Overview:
Geospatial Python introduces the basics of the computer programming language, Python, as it applies to spatial data. Python is rapidly becoming the primary language for application development because of the relatively short learning curve when compared to otherprogramming languages, such as C/C++. Along with the fundamentals of Python, workshop participants learn how to develop programs using the GDAL/OGR libraries, the foundation libraries used in most commercial and open source GIS software. Workshop participants learn how to write simple Python programs, read and create spatial and non-spatial datasets, data queries, geoprocessing and spatial analysis. Software and sample programs are included with course materials.

Prerequisite: none.

View Event →
Excel 2013 Pivot Tables
Apr
25
8:00 AM08:00

Excel 2013 Pivot Tables

Excel 2013 Pivot Tables

April 25, 2018
Morning Session: 8:00 a.m. - 12:00 p.m.
Afternoon Session: 1:00 p.m. - 5:00 p.m.
CHL Computer Lab, 1103 Balch Blvd.
Stennis Space Center

Cost: $15

To register, contact Troy Teadt at 228-688-3113 or 985-788-3257 or by email at tteadt@prcc.edu, at least one week before the class date.

Prerequisites: Before starting this course, students are recommended to take or have equivalent knowledge of Excel 2013 Beginner and Excel 2013 Intermediate courses.

Overview
Upon successful completion of this class, students will be able to build a PivotTable, analyze data using PivotTables, and present PivotTable data visually.

Course Content

Lesson 1: Building a PivotTable
Topic 1A: Insert a PivotTable
Topic 1B: Create a PivotTable Based on External Data
Topic 1C: Categorize PivotTable Data
Topic 1D: Customize a PivotTable

Lesson 2: Analyzing Data Using PivotTables
Topic 2A: Create Custom Calculations in a PivotTable
Topic 2B: Restructure a PivotTable

Lesson 3: Presenting PivotTable Data Visually
Topic 3A: Format a PivotTable
Topic 3B: Present a PivotTable in a PivotChart
Topic 3C: Print PivotTables and PivotCharts

View Event →
Excel 2013 for Beginners
May
2
8:00 AM08:00

Excel 2013 for Beginners

Excel 2013 for Beginners

May 2, 2018
8:00 - 5:00
CHL Computer Lab, 1103 Balch Blvd.
Stennis Space Center

Cost: $25

To register, contact Troy Teadt at 228-688-3113 or 985-788-3257 or by email at tteadt@prcc.edu, at least one week before the class date.

Overview
Upon successful completion of this course, students will be able to:

  • create a basic worksheet by entering text and values
  • work with cells and cell data by using a variety of moving and copying techniques
  • perform calculations on data by using formulas, including functions
  • change the appearance of worksheet data by using a variety of formatting techniques
  • work with multiple worksheets by formatting, repositioning, copying and moving, and adding and deleting worksheets within a workbook
  • set the page display and printing options

Course Content

Lesson 1: Getting Started

  • Introduction to the Excel Application Window
  • Navigation techniques and shortcuts
  • Enter Data in a Worksheet
  • Creating Basic Formulas
  • Save a Workbook

Lesson 2: Editing Your Worksheet

  • Moving Data to Other Cells
  • Copy Data to Other Cells
  • Fill Cells with a Series of Data
  • Insert and Delete Rows and Columns
  • Find and Replace Numbers

Lesson 3: Performing Calculations

  • Sum a Range of Data
  • Use a Built-in Function
  • Copy a Formula
  • Create an Absolute Reference

Lesson 4: Formatting

  • Specify Number Formats
  • Create a Custom Number Format
  • Change Font Size and Type
  • Add Borders and Color to Cells
  • Change Column Width and Row Height
  • Align Cell Contents 
  • Merge and Center Cells
  • Apply an AutoFormat

Lesson 5: Working with Multiple Worksheets

  • Format Worksheet Tabs
  • Reposition Worksheets in a Workbook
  • Copy Worksheets
  • Change the Number of Worksheets

Lesson 6: Setting Page Display and Printing Options

  • Freeze Rows and Columns
  • Set Print Title
  • Set Page Margins
  • Create a Header and Footer
  • Change Page Orientation
  • Insert and Remove Page Breaks
  • Print a Range
View Event →
Microsoft Access: Part 1
May
9
to May 10

Microsoft Access: Part 1

Microsoft Access: Part 1

May 9 - 10, 2018 (two days)
CHL Computer Lab No. 2
1103 Balch Blvd., Stennis Space Center, Room 1004

Cost: $40

To register, contact Troy Teadt at 228-688-3113 or 985-788-3257 or by email at tteadt@prcc.edu, at least one week before the class date.

Course Outline:

1.  Getting Started with Access
Orientation to Microsoft Access
Create a Simple Access Database

2.   Working with Table Data
Modify Table Data Sort & Filter Records
Work with Subdatasheets
Create Lookups

3.  Querying a Database
Join Data from Different Tables in Query
Sort and Filter Data in a Query
Perform Calculations in a Query

4. Creating Flexible Queries
Create Parameter Queries
Create Action Queries

5.  Generating Reports
Create a Report
Add Controls to a Report
Enhance the Appearance of a Report
Prepare a Report for Print

6.  Customizing the Access Environment
The Access Options Dialog Box

7. Designing a Relational Database
Relational Database Design
Create and Import Tables
Create Table Relationships

8.  Joining Tables in Queries
Create Query Joins
Join Tables With No Common Fields
Relate Data within a Table

9.  Importing and Exporting Data
Import Data into Access
Export Data to Text File Formats

10. Advanced Reporting
Organize Report Information
Include Control Formatting in a Report
Add a Calculated Field to a Report
Add a Subreport to an Existing Report

View Event →
Excel 2013 Intermediate
May
16
8:00 AM08:00

Excel 2013 Intermediate

Excel 2013 Intermediate

May 16, 2018
8:00 - 5:00
CHL Computer Lab, 1103 Balch Blvd.
Stennis Space Center

Cost: $25

To register, contact Troy Teadt at 228-688-3113 or 985-788-3257 or by email at tteadt@prcc.edu, at least one week before the class date.

Overview
Upon successful completion of this course, students will be able to:

  • use Excel templates and user-defined templates to create templates and workbooks.
  • use a variety of techniques to sort and filter data.
  • use various functions and auditing features to create advanced formulas and audit worksheets.
  • use PivotTables, PivotCharts, and other analysis tools to analyze data.

Course Content

Lesson 1: Working with Templates

  • Create a Workbook from an Excel Template
  • Create a Custom Template from an Excel Template
  • Create a Graphic
  • Create a Workbook from a User-defined Template

Lesson 2: Sorting and Filtering Data

  • Sort Data Using Normal and Custom Sorts
  • Add Subtotals to a Worksheet
  • Filter Lists Using Auto Filter
  • Create and Apply Custom Filters
  • Create and Apply Advanced Filters

Lesson 3: Importing and Exporting Data

  • Import Data from the Web
  • Import Data from an External Source
  • Export Data
  • Save a Worksheet as a Web Page
  • Publish a Worksheet to the Web

Lesson 4: Working with Advanced Formulas

  • Share Data Among Worksheets
  • Create a Name for a Range of Cells
  • Use Functions to Create Advanced Formulas
  • Trace Cell Precedents
  • Trace Cell Dependents
  • Locate Errors in Formulas

Lesson 5: Analyzing Data

  • Create a PivotTable Report
  • Create a PivotChart Report
  • Create Scenarios
  • Use Solver
  • Use Goal Seek

Lesson 6: Collaborating

  • Insert and Edit a Hyperlink
  • Add and Edit Comments in a Worksheet
View Event →
Microsoft Access: Part 2
May
23
to May 24

Microsoft Access: Part 2

Microsoft Access: Part 2

May 23 - 24, 2018 (two day course)
CHL Computer Lab
1103 Balch Blvd., Stennis Space Center, Room 1005

Cost: $40

To register, contact Troy Teadt at 228-688-3113 or 985-788-3257 or by email at tteadt@prcc.edu, at least one week before the class date.

Course Outline:

1.   Advanced Queries
Create Unmatched & Duplicate Queries
Crosstab Queries
Create Subqueries

2.   Implementing Advanced Form Design
Add Controls to Forms
Create Subforms
Organize Information with Tab Pages
Enhance Navigation of Forms
Apply Conditional Formatting

3.  Using Data Validation
Field and Record Validation
Form Validation

4.  Using Macros to Improve User Interface Design
Create a Macro
Restrict Records Using a Condition
Validate Data Using a Macro
Automate Data Entry Using a Macro
Convert a Macro to VBA

5.  Sharing Data Across Applications
Export Access Data to Excel
Export Access Data Create a PivotTable
Export Access Data Create a Mail Merge

6.  Advanced Database Management
Link Tables to External Data Sources
Manage a Database
Determine Object Dependency
Document a Database
Analyze the Performance of a Database

7. Distributing and Securing a Database
Splitting Database for Multiple Users
Implement Security
Set Passwords
Convert Access Database to ACCDE File
Database with Digital Signature

8.   Managing Switchboards
Create a Database Switchboard
Modify a Database Switchboard
Set Startup Options

View Event →
Excel 2013 Advanced
Jun
6
to Jun 7

Excel 2013 Advanced

Excel 2013 Advanced

June 6 - 7, 2018
8:00 - 5:00 each day
CHL Computer Lab, 1103 Balch Blvd.
Stennis Space Center

Cost: $40

To register, contact Troy Teadt at 228-688-3113 or 985-788-3257 or by email at tteadt@prcc.edu, at least one week before the class date.

Overview
Upon successful completion of this course, students will be able to

  • customize your workbook by applying conditional formatting, adding data validation criteria, customizing menus and toolbars, creating and editing a macro, and grouping and outlining structured data.
  • work with multiple workbooks to create a workspace, consolidate data, link cells, edit links,
  • collaborate with other Excel users by protecting your workbook
  • chart non-adjacent data, modify chart items, and create a custom chart template.
  • use multiple graphic objects and diagrams to enhance your worksheet.

Course Content

Lesson 1: Customizing your Workbook

  • Apply Conditional Formatting
  • Add Data Validation Criteria
  • Customize Menus
  • Customize Toolbars
  • Create a Macro
  • Edit a Macro
  • Group and Outline Structured Data

Lesson 2: Working with Multiple Data Sources

  • Create a Workspace
  • Consolidate Data
  • Link Cells in Different Workbooks
  • Edit Links

Lesson 3: Collaborating with Others Using Workbooks

  • Protect your Worksheets
  • Protect Your Workbook

Lesson 4: Creating Charts

  • Creating a Chart Sheet
  • Creating an Embedded Chart
  • Comparing Chart Sheets with Embedded Charts

Lesson 5: Modifying Charts

  • Chart Types
  • Modifying Embedded Charts
  • Adding and Deleting Chart Items
  • Moving and Sizing Chart Items

Lesson 6: Formatting a Chart

  • Formatting Chart Text
  • Formatting Labels
  • Printing a Chart Sheet

Lesson 7: Using Graphic Objects to Enhance your Worksheets

  • Create Graphic Objects
  • Resize, Move, and Copy Graphic Objects
  • Change the Order of Graphic Objects
  • Group Graphic Objects
  • Format Graphic Objects
  • Insert Clip Art
  • Modify Clip Art
View Event →

Microsoft Access: Part 1
Feb
7
to Feb 8

Microsoft Access: Part 1

Microsoft Access: Part 1

February 7 - 8, 2018 (two days)
CHL Computer Lab No. 2
1103 Balch Blvd., Stennis Space Center, Room 1004

Cost: $40

To register, contact Troy Teadt at 228-688-3113 or 985-788-3257 or by email at tteadt@prcc.edu, at least one week before the class date.

Course Outline:

1.  Getting Started with Access
Orientation to Microsoft Access
Create a Simple Access Database

2.   Working with Table Data
Modify Table Data Sort & Filter Records
Work with Subdatasheets
Create Lookups

3.  Querying a Database
Join Data from Different Tables in Query
Sort and Filter Data in a Query
Perform Calculations in a Query

4. Creating Flexible Queries
Create Parameter Queries
Create Action Queries

5.  Generating Reports
Create a Report
Add Controls to a Report
Enhance the Appearance of a Report
Prepare a Report for Print

6.  Customizing the Access Environment
The Access Options Dialog Box

7. Designing a Relational Database
Relational Database Design
Create and Import Tables
Create Table Relationships

8.  Joining Tables in Queries
Create Query Joins
Join Tables With No Common Fields
Relate Data within a Table

9.  Importing and Exporting Data
Import Data into Access
Export Data to Text File Formats

10. Advanced Reporting
Organize Report Information
Include Control Formatting in a Report
Add a Calculated Field to a Report
Add a Subreport to an Existing Report

 

View Event →
Introduction to QGIS
Feb
6
to Feb 7

Introduction to QGIS

Introduction to QGIS

February 6 - 7, 2018
Two day course meets 8:30 - 4:30 each day
MSU Building, Bldg 1021, Stennis Space Center

Cost: $25

For reservations, registration and payment, contact:
Troy Teadt, PRCC Workforce Liaison, tteadt@prcc.edu
228-688-3113 (O), 985-788-3257 (C), 228-688-7454 (Fax)

Course Description:

QGIS is an “open source” geographic information systems (GIS) software package and available to users at no-cost.  No prior experience with GIS is required to attend.  Topics covered in this course include:

·         What is GIS and how is it used

·         Map projections and coordinate systems

·         An overview of GIS data types and how to create GIS   datasets

·         Using GIS data to manage map symbology and labels

·         Attribute and spatial data analysis techniques

·         Geoprocessing of spatial data

·         Designing maps for presentations

The course combines instructor-led presentations and hands-on, practical exercises for participants.  Each attendee will receive a course workbook, data used in the exercises and a copy of the latest version of QGIS.

View Event →
Intro to GIS using ArcGIS Desktop
Jan
31
to Feb 1

Intro to GIS using ArcGIS Desktop

Introduction to GIS using ArcGIS Desktop

January 31 - February 1
8:30 - 4:30 each day
MSU Building, Bldg 1021, Stennis Space Center

Cost: $25

To register, contact Troy Teadt at 228-688-3113 or 985-788-3257 or by email at tteadt@prcc.edu, at least one week before the class date.

Course Length: 2 days (16 hours)

Overview
This course is intended for individuals who have no experience with Geographic Information Systems (GIS), and offers a basic introduction to GIS using ESRI’s ArcGIS for Desktop software.  

Who Should Attend
Individuals who are interested in learning about Geographic Information Systems (GIS) and ESRI’s ArcGIS for Desktop software.

Goals
Course participants will learn and explore the following:

  • What GIS is and how is it used.
  • Exploring GIS data in ArcGIS for Desktop (ArcMap/ArcCatalog)
  • GIS data formats
  • Map projections and coordinate systems.
  • Symbolizing and Labeling Features in a map.
  • Working with attribute tables
  • Editing and creating data
  • Using geoprocessing tools to process data
  • Analyzing GIS data
  • Designing a map layout.

Prerequisites
Basic computer skills

 

 

View Event →
Microsoft Office PowerPoint: Introduction
Jan
31
8:00 AM08:00

Microsoft Office PowerPoint: Introduction

Microsoft Office PowerPoint 2013: Level I

Wednesday, January 31, 2018
8:00 a.m. - 5:00 p.m.
Center of Higher Learning Computer Lab No. 1
Bldg. 1103, Room 1005

Cost: $25
To register, contact Troy Teadt at 228-688-3113 or 985-788-3257 or by email at tteadt@prcc.edu, at least one week before the class date.

Performance-Based Objectives:

  • manipulate an existing PowerPoint presentation.
  • begin creating a presentation.
  • format text slides.
  • add tables to a presentation.
  • chart data in a presentation.
  • modify objects on slides.
  • add images to a presentation.
  • prepare to deliver a presentation.

Course Content

Lesson 1: An Orientation to PowerPoint

Topic 1A: The PowerPoint Environment

Topic 1B: Orientation to Views

Topic 1C: Navigate Through a Presentation

Topic 1D: Edit Slide Text

Topic 1E: Save the Presentation

Topic 1F: Run a Slide Show

Lesson 2: Beginning a Presentation

Topic 2A: Create a New Presentation

Topic 2B: Change Background Color

Topic 2C: Add Slides to a Presentation

Topic 2D: Enter Text

Topic 2E: Create a Presentation from a Microsoft Word Outline

Lesson 3: Formatting Text Slides

Topic 3A: Apply Character Formats

Topic 3B: Align Text

Topic 3C: Change Line Spacing

Topic 3D: Change Indents

Lesson 4: Adding Tables to a Presentation

Topic 4A: Create a Table

Topic 4B: Format Tables

Topic 4C: Insert a Table from Microsoft Word

Lesson 5: Charting Data

Topic 5A: Create a Column Chart

Topic 5B: Edit Chart Data

Topic 5C: Change Chart Type

Topic 5D: Insert a Chart from Microsoft Excel

Lesson 6: Modifying Objects

Topic 6A: Resize Objects

Topic 6B: Copy and Duplicate Objects

Topic 6C: Move Objects

Topic 6D: Changing Object Orientation

Topic 6E: Format Objects

Topic 6F: Group and Ungroup Objects

Topic 6G: Change the Order of Objects

 

Lesson 7: Adding Images to a Presentation

Topic 7A: Add Clip Art

Topic 7B: Add a Picture from a File

Topic 7C: Draw Lines and Shapes

Topic 7D: Insert WordArt

Lesson 8: Preparing to Deliver a Presentation

Topic 8A: Spell Check

Topic 8B: Arrange Slides

Topic 8C: Add Transitions

Topic 8D: Create Speaker Notes

Topic 8E: Send a Presentation to Microsoft Word

Topic 8F: Print the Presentation

Topic 8G: Package a Presentation for CD

 

View Event →
Excel 2013 for Beginners
Jan
17
8:00 AM08:00

Excel 2013 for Beginners

Excel 2013 for Beginners

January 17, 2018
8:00 - 5:00
CHL Computer Lab, 1103 Balch Blvd.
Stennis Space Center

Cost: $25

To register, contact Troy Teadt at 228-688-3113 or 985-788-3257 or by email at tteadt@prcc.edu, at least one week before the class date.

Overview
Upon successful completion of this course, students will be able to:

  • create a basic worksheet by entering text and values
  • work with cells and cell data by using a variety of moving and copying techniques
  • perform calculations on data by using formulas, including functions
  • change the appearance of worksheet data by using a variety of formatting techniques
  • work with multiple worksheets by formatting, repositioning, copying and moving, and adding and deleting worksheets within a workbook
  • set the page display and printing options

Course Content

Lesson 1: Getting Started

  • Introduction to the Excel Application Window
  • Navigation techniques and shortcuts
  • Enter Data in a Worksheet
  • Creating Basic Formulas
  • Save a Workbook

Lesson 2: Editing Your Worksheet

  • Moving Data to Other Cells
  • Copy Data to Other Cells
  • Fill Cells with a Series of Data
  • Insert and Delete Rows and Columns
  • Find and Replace Numbers

Lesson 3: Performing Calculations

  • Sum a Range of Data
  • Use a Built-in Function
  • Copy a Formula
  • Create an Absolute Reference

Lesson 4: Formatting

  • Specify Number Formats
  • Create a Custom Number Format
  • Change Font Size and Type
  • Add Borders and Color to Cells
  • Change Column Width and Row Height
  • Align Cell Contents 
  • Merge and Center Cells
  • Apply an AutoFormat

Lesson 5: Working with Multiple Worksheets

  • Format Worksheet Tabs
  • Reposition Worksheets in a Workbook
  • Copy Worksheets
  • Change the Number of Worksheets

Lesson 6: Setting Page Display and Printing Options

  • Freeze Rows and Columns
  • Set Print Title
  • Set Page Margins
  • Create a Header and Footer
  • Change Page Orientation
  • Insert and Remove Page Breaks
  • Print a Range

View Event →
Microsoft Access: Part 2
Nov
1
to Nov 2

Microsoft Access: Part 2

Microsoft Access: Level 2
November 1 - 2, 2017 (two days)
CHL Computer Lab
1103 Balch Blvd., Stennis Space Center, Room 1005

Cost: $40

To register, contact:
Troy Teadt, PRCC Workforce Liaison
tteadt@prcc.edu
228.688-3113 (office)
985.788.3257 (cell)
228.688.7454 (fax)

Course Outline:

1.   Advanced Queries
Create Unmatched & Duplicate Queries
Crosstab Queries
Create Subqueries

2.   Implementing Advanced Form Design
Add Controls to Forms
Create Subforms
Organize Information with Tab Pages
Enhance Navigation of Forms
Apply Conditional Formatting

3.  Using Data Validation
Field and Record Validation
Form Validation

4.  Using Macros to Improve User Interface Design
Create a Macro
Restrict Records Using a Condition
Validate Data Using a Macro
Automate Data Entry Using a Macro
Convert a Macro to VBA

5.  Sharing Data Across Applications
Export Access Data to Excel
Export Access Data Create a PivotTable
Export Access Data Create a Mail Merge

6.  Advanced Database Management
Link Tables to External Data Sources
Manage a Database
Determine Object Dependency
Document a Database
Analyze the Performance of a Database

7. Distributing and Securing a Database
Splitting Database for Multiple Users
Implement Security
Set Passwords
Convert Access Database to ACCDE File
Database with Digital Signature

8.   Managing Switchboards
Create a Database Switchboard
Modify a Database Switchboard
Set Startup Options

 

View Event →
Microsoft Access: Part 1
Oct
25
to Oct 26

Microsoft Access: Part 1

Microsoft Access: Part 1
October 25 - 26 (two days)
CHL Computer Lab
1103 Balch Blvd., Stennis Space Center, Room 1005

Cost: $40

To register, contact:
Troy Teadt, PRCC Workforce Liaison
tteadt@prcc.edu
228.688-3113 (office)
985.788.3257 (cell)
228.688.7454 (fax)

Course Outline:

1.  Getting Started with Access
Orientation to Microsoft Access
Create a Simple Access Database

2.   Working with Table Data
Modify Table Data Sort & Filter Records
Work with Subdatasheets
Create Lookups

3.  Querying a Database
Join Data from Different Tables in Query
Sort and Filter Data in a Query
Perform Calculations in a Query

4. Creating Flexible Queries
Create Parameter Queries
Create Action Queries

5.  Generating Reports
Create a Report
Add Controls to a Report
Enhance the Appearance of a Report
Prepare a Report for Print

6.  Customizing the Access Environment
The Access Options Dialog Box

7. Designing a Relational Database
Relational Database Design
Create and Import Tables
Create Table Relationships

8.  Joining Tables in Queries
Create Query Joins
Join Tables With No Common Fields
Relate Data within a Table

9.  Importing and Exporting Data
Import Data into Access
Export Data to Text File Formats

10. Advanced Reporting
Organize Report Information
Include Control Formatting in a Report
Add a Calculated Field to a Report
Add a Subreport to an Existing Report

VIEW Access Level 2 course details by clicking here.

VIEW a printable flyer for the entire two-part Access series by clickinghere.

 

View Event →
Microsoft Word: Intermediate
Oct
11
8:00 AM08:00

Microsoft Word: Intermediate

Word Level 2

Wednesday, October 11, 2017
8:00 a.m. - 5:00 p.m.
CHL Computer Lab, Bldg. 1103, Room 1005

Cost: $25
Registration contact:
Troy Teadt, PRCC Workforce Liaison
tteadt@prcc.edu
228-688-3113

Performance Based Objectives

Upon successful completion of this course, students will be able to:

  • create and modify custom templates, apply existing styles, and create a custom style.
  • enhance a table by merging table cells, sorting and calculating table data, and creating charts based on various table data.
  • learn how to insert, manipulate, and format graphic images, including clip art, AutoShapes, WordArt, and organization charts.
  • create a newsletter using columns, sections, and graphics.
  • use the Mail Merge Wizard to mail merge form letters, complete with mailing labels.
  • include comments in a document and compare and merge documents.

Course Content

Lesson 1: Creating and Modifying Templates
Topic 1A: Apply Styles
Topic 1B: Modify Styles
Topic 1C: Create User-Defined Styles
Topic 1D: Create a Template from an Existing Document

Lesson 2: Managing Tables and Table Data in Documents
Topic 2A: Convert Tabbed Text into a Table
Topic 2B: Merge Cells in a Table
Topic 2C: Open an Excel Table in Word
Topic 2D: Sort Table Data
Topic 2E: Perform Calculations in Tables
Topic 2F: Create and Modify a Chart Based on Word Table Data
Topic 2G: Link Excel Data in a Word Table

Lesson 3: Adding Graphics
Topic 3A: Insert a Clip Art Image
Topic 3B: Add an AutoShape
Topic 3C: Insert WordArt
Topic 3D: Insert an Organizational Chart

Lesson 4: Creating a Newsletter
Topic 4A: Create a Document Section
Topic 4B: Format Text into Newsletter Columns
Topic 4C: Control Column Text Flow
Topic 4D: Wrap Text Around a Graphic
Topic 4E: Create Envelopes and Labels

Lesson 5: Sending Form Letters
Topic 5A: Select the Main Document Type
Topic 5B: Select the Data Source
Topic 5C: Insert Merge Fields
Topic 5D: Merge and Preview Form Letters
Topic 5E: Create Mailing Labels

Lesson 6: Creating a Web Page
Topic 6A: Create a Web Page Using a Template
Topic 6B: Preview a Web Page in a Browser
Topic 6C: Create a Hyperlink in a Web Page
Topic 6D: Edit a Hyperlink in a Web Page
Topic 6E: Apply a Theme to a Web Page

Lesson 7: Managing Document Changes
Topic 7A: Use Comments in Word Documents
Topic 7B: Compare and Merge Documents

VIEW Word Level 3/Advanced course details by clicking here.

Click here for a brochure of the entire three-part Word series.

View Event →
Microsoft Word: Introduction
Oct
4
8:00 AM08:00

Microsoft Word: Introduction

Word: Level 1

Wednesday, October 4, 2017
8:00 a.m. - 5:00 p.m.
CHL Computer Lab, Bldg. 1103, Room 1005

Cost: $25
Registration contact:
Troy Teadt, PRCC Workforce Liaison
tteadt@prcc.edu
228-688-3113

Performance-Based Objectives

Upon successful completion of this course, students will be able to:

  • create a simple document, save a document, use Microsoft Word's automatic text features for entering text, and access online help.
  • make changes to an existing document using a variety of editing techniques.
  • apply text formatting to a document.
  • change the appearance of a document by applying various paragraph formats and effects.
  • create a table, navigate and enter text in a table, and enhance its appearance through formatting.
  • use Word's Find and Replace, and proofing tools to efficiently do your work.
  • preview a document, apply and remove formatting that affects entire pages, and print a document.

Course Content

Lesson 1: Creating a Document
Lesson 2: Editing Text
Lesson 3: Formatting Text
Lesson 4: Formatting Paragraphs
Lesson 5: Adding Tables          
Lesson 6: Using Word Timesavers
Lesson 7: Setting Page Display and Printing Options

VIEW Word Level 2/Intermediate course details by clicking here.

VIEW Word Level 3/Advanced course details by clicking here.

Click here for a brochure of the entire Word three-part series.

View Event →
Microsoft Excel Programming with VBA
Sep
26
to Sep 28

Microsoft Excel Programming with VBA

Microsoft Excel Programming with VBA

September 26 - 28, 2017
8:00 a.m. - 5:00 p.m.
Center for Higher Learning Computer Lab No. 1
Bldg. 1103,  Room 1005

Cost: $100 (includes textbook)
REGISTRATION DEADLINE: Tuesday, Sept. 12, 2017
To register, contact Troy Teadt at 228-688-3113 or 985-788-3257 or by email at tteadt@prcc.edu, at least one week before the class date.
 

Prerequisite
Proficient knowledge of Microsoft Excel

Course Outline (3-day class)

Getting Started
Introducing Visual Basic for Applications
Displaying the Developer Tab in the Ribbon
Recording a Macro
Saving a Macro-Enabled Workbook
Running a Macro
Editing a Macro in the Visual Basic Editor
Understanding the Development Environment
Using Visual Basic Help
Closing the Visual Basic Editor
Understanding Macro Security

Working with Procedures and Functions
Understanding Modules
Creating a Standard Module
Understanding Procedures
Creating a Sub Procedure
Calling Procedures
Using the Immediate Window to Call Procedures Creating a Function Procedure
Naming Procedures
Working with the Code Editor

Understanding Objects
Understanding Objects
Navigating the Excel Object Hierarchy
Understanding Collections
Using the Object Browser
Working with Properties
Using the With Statement
Working with Methods
Creating an Event Procedure

Using Expressions, Variables, and Intrinsic Functions
Understanding Expressions and Statements
Declaring Variables
Understanding Data Types
Working with Variable Scope
Using Intrinsic Functions
Understanding Constants
Using Intrinsic Constants
Using Message Boxes
Using Input Boxes
Declaring and Using Object Variables

Controlling Program Execution
Understanding Control-of-Flow Structures
Working with Boolean Expressions
Using the If...End If Decision Structures
Using the Select Case...End Select Structure
Using the Do...Loop Structure
Using the For...To...Next Structure
Using the For Each...Next Structure
Guidelines for use of Control-of-Flow Structures

Working with Forms and Controls Understanding UserForms
Using the Toolbox
Working with UserForm Properties, Events, and Methods Understanding Controls
Setting Control Properties in the Properties Window
Working with the Label Control
Working with the Text Box Control
Working with the Command Button Control
Working with the Combo Box Control
Working with the Frame Control
Working with Option Button Controls
Working with Control Appearance
Setting the Tab Order
Populating a Control
Adding Code to Controls
Launching a Form in Code

Working with the PivotTable Object
Understanding PivotTables
Creating a PivotTable Using Worksheet Data
Working with the PivotTable Objects
Working with the PivotFields Collection
Assigning a Macro to the Quick Access Toolbar

Debugging Code
Understanding Errors
Using Debugging Tools
Setting Breakpoints
Stepping through Code
Using Break Mode during Run mode
Determining the Value of Expressions

Handling Errors
Understanding Error Handling
Understanding VBA's Error Trapping Options
Trapping Errors with the On Error Statement
Understanding the Err Object
Writing an Error-Handling Routine
Working with Inline Error Handling

 

View Event →
Microsoft Office PowerPoint: Advanced
Sep
20
8:00 AM08:00

Microsoft Office PowerPoint: Advanced

Microsoft Office PowerPoint 2013: Level 2

Wednesday, September 20
8:00 a.m. - 5:00 p.m.
Center of Higher Learning Computer Lab No. 2
Bldg. 1103, Room 1004

Cost: $25
To register, contact Troy Teadt at 228-688-3113 or 985-788-3257 or by email at tteadt@prcc.edu, at least one week before the class date.

Performance-Based Objectives

  • create a design template.
  • create organization charts and diagrams.
  • add special effects to a Microsoft® Office PowerPoint®  slide.
  • use advanced animation techniques
  • create a Microsoft® Office PowerPoint®  presentation containing hyperlinks and action controls.

Course Content:

Lesson 1: Creating a Custom Design Template

Topic 1A: Define Design Template Characteristics

Topic 1B: Create a Custom Color Scheme

Topic 1C: Set Up a Slide Master

Topic 1D: Format Custom Bullets

Topic 1E: Add a Footer

Topic 1F: Modify the Notes Master

Topic 1G: Save a Custom Design Template

Lesson 2: Adding Organization Charts and Diagrams

Topic 2A: Working with Organization Charts

Topic 2B: Update an Organization Chart

Topic 2C: Applying a Chart Layout

Topic 2D: Create a Diagram

Topic 2E: Draw a Flowchart

Lesson 3: Adding Special Effects

Topic 3A: Add Sound and Movies

Topic 3B: Add Animation and Work with Advanced Timeline

Topic 3C: Emphasize Objects

Topic 3D: Set a Motion Path

Topic 3E: Set the Order of Effects

Lesson 4: Creating Presentations Containing Hyperlinks

Topic 4A: Create a Group Home Page with the AutoContent Wizard

Topic 4B: Hyperlink to a Web Page

Topic 4C: Hyperlink to another slide

Topic 4DHyperlink to another MS file

Lesson 5: Collaborating in PowerPoint

Topic 5A: Set Password Protection

Topic 5B: Work with Comments

Topic 5C: Send a Presentation for Review

Topic 5D: Merge Revision Copies

Topic 5E: Apply Reviewer Changes

Lesson 6: Delivering a Presentation

Topic 6A: Hyperlink Within PowerPoint

Topic 6B: Add an Action Button

Topic 6C: Set Up a Custom Show

Topic 6D: Annotate a Presentation

Topic 6E: Working with Narrations and Slide Timings

Topic 6F: Set Up a Slide Show to Repeat Automatically

View Event →
Microsoft Office PowerPoint: Introduction
Sep
13
8:00 AM08:00

Microsoft Office PowerPoint: Introduction

Microsoft Office PowerPoint 2013: Level I

Wednesday, January 31, 2018
8:00 a.m. - 5:00 p.m.
Center of Higher Learning Computer Lab No. 1
Bldg. 1103, Room 1005

Cost: $25
To register, contact Troy Teadt at 228-688-3113 or 985-788-3257 or by email at tteadt@prcc.edu, at least one week before the class date.

Performance-Based Objectives:

  • manipulate an existing PowerPoint presentation.
  • begin creating a presentation.
  • format text slides.
  • add tables to a presentation.
  • chart data in a presentation.
  • modify objects on slides.
  • add images to a presentation.
  • prepare to deliver a presentation.

Course Content

Lesson 1: An Orientation to PowerPoint

Topic 1A: The PowerPoint Environment

Topic 1B: Orientation to Views

Topic 1C: Navigate Through a Presentation

Topic 1D: Edit Slide Text

Topic 1E: Save the Presentation

Topic 1F: Run a Slide Show

Lesson 2: Beginning a Presentation

Topic 2A: Create a New Presentation

Topic 2B: Change Background Color

Topic 2C: Add Slides to a Presentation

Topic 2D: Enter Text

Topic 2E: Create a Presentation from a Microsoft Word Outline

Lesson 3: Formatting Text Slides

Topic 3A: Apply Character Formats

Topic 3B: Align Text

Topic 3C: Change Line Spacing

Topic 3D: Change Indents

Lesson 4: Adding Tables to a Presentation

Topic 4A: Create a Table

Topic 4B: Format Tables

Topic 4C: Insert a Table from Microsoft Word

Lesson 5: Charting Data

Topic 5A: Create a Column Chart

Topic 5B: Edit Chart Data

Topic 5C: Change Chart Type

Topic 5D: Insert a Chart from Microsoft Excel

Lesson 6: Modifying Objects

Topic 6A: Resize Objects

Topic 6B: Copy and Duplicate Objects

Topic 6C: Move Objects

Topic 6D: Changing Object Orientation

Topic 6E: Format Objects

Topic 6F: Group and Ungroup Objects

Topic 6G: Change the Order of Objects

 

Lesson 7: Adding Images to a Presentation

Topic 7A: Add Clip Art

Topic 7B: Add a Picture from a File

Topic 7C: Draw Lines and Shapes

Topic 7D: Insert WordArt

Lesson 8: Preparing to Deliver a Presentation

Topic 8A: Spell Check

Topic 8B: Arrange Slides

Topic 8C: Add Transitions

Topic 8D: Create Speaker Notes

Topic 8E: Send a Presentation to Microsoft Word

Topic 8F: Print the Presentation

Topic 8G: Package a Presentation for CD

 

View Event →
Aug
7
to Aug 10

Introduction to MATLAB

 Introduction to MATLAB®

offered by

The University of Southern Mississippi

School of Ocean Science and Technology Division of Marine Science

August 7—10, 2017     8:00 am—4:30 pm

Building 1022, Room 101

 

Participation Requirements:

$500 registration fee

Text (to be purchased by student in advance of class): A Guide to MATLAB® for Beginners and Experienced Users, (2nd or 3rd) Ed, by Brian R. Hunt, Ronald L. Lipsman, and Jonathan M. Rosenberg, and published by Cambridge University Press in 2007. (Available from Amazon.com.)\

Pre-requisite course training (no cost): https://matlabacademy.mathworks.com

Computers and software will be provided at no cost.

For course requirements and questions, contact Max van Norden at maxim.vannorden@usm.edu or 228-688-7123.

To register, contact Kim Miller at kim.miller@usm.edu or 228-688-3170.


Contact Hours

Class Hours:  Monday to Thursday, August 7 - 10, 2017        0800-1630

Location:        Building 1022 classroom (Room 101)

This class will be taught in 4 full day sessions from 0800 until 1200, with the afternoons devoted to completion of the MATLAB® programming exercises. Problems and issues encountered by students attempting the problem sets will be discussed as they occur.  The results for each day will be summarized during an interactive discussion at 1600 each day.  There will be a 1-hour break for lunch from 1200 until 1300 and 10-minute breaks will be taken every hour.

Course Description

This 4 day long introduction to MATLAB® course is intended specifically to prepare students in the marine sciences for the programming and computational challenges they will encounter. No previous programming experience is necessary or expected.

Texts    

A Guide to MATLAB® for Beginners and Experienced Users, (2nd or 3rd) Ed, by Brian R. Hunt, Ronald L. Lipsman, and Jonathan M. Rosenberg, and published by Cambridge University Press in 2007. (Available from Amazon.com)

Computer  

Students will be provided with a laptop computer with MATLAB® installed.

Instructional Strategy

This course will be taught in a very “hands-on” manner. Sample problems will be worked out collaboratively on the whiteboard and in MATLAB®, and programming exercises will be assigned and discussed each day.

Student Learning Outcomes

At the end of this course you will be able to use MATLAB® to:

·         Input and manipulate data of various formats

·         Perform mathematical operations on scalar and vector data

·         Save data and computations in various formats

·         Write scripts and functions (programs) for repetitive and/or complex tasks

·         Create graphics, such as plots and histograms, for visually analyzing data and computational output

¨ Learn how to utilize MATLAB® in new ways

 

View Event →
Geospatial Python Training
Jul
17
to Jul 18

Geospatial Python Training

Geospatial Python Training

July 17 - 18, 2017
8:30 a.m. - 4:30 p.m. daily
MSU Building, 1021 Balch Blvd., Stennis Space Center

Cost: $25

Registration: Contact Troy Teadt, PRCC Workforce Liaison. at tteadt@prcc.edu or 228-688-3113 (o), 985-788-3257 (c), 228-688-7454 (fax).

Geospatial Python introduces the basics of the computer programming language, Python, as it applies to spatial data.  Python is rapidly becoming the primary language for application development because of the relatively short learning curve when compared to other programming languages, such as C/C++.   Along with the fundamentals of Python, workshop participants learn how to develop programs using the GDAL/OGR libraries, the foundation libraries used in most commercial and open source GIS software.  Workshop participants learn how to write simple Python programs, read and create spatial and non-spatial datasets, data queries, geoprocessing and spatial analysis.  Software and sample programs are included with course materials.

For a printable flyer, please click here.

View Event →
Community Leadership Development Programs Forum and Expo
May
3
9:30 AM09:30

Community Leadership Development Programs Forum and Expo

Community Leadership Development Programs
Forum and Expo

Wednesday, May 3, 2017

Featuring:
Leadership Gulf Coast
Leadership Hancock County
New Orleans Regional Leadership Institute
Leadership Northshore
Pearl River County Partners in Leadership
Leadership St. Tammany
 

Small Group Forum
9:30 - 10:30 a.m.
Santa Rosa Room, Building 1100

Light refreshments provided
Please RSVP by April 26 to kim.miller@usm.edu

Representatives from area Community Leadership Development Programs
will discuss how Stennis agencies can support professional growth
and service opportunities for employees.

Expo
10:45 a.m. - 1:00 p.m.
Atrium, Bldg. 1100

Leadership Groups will present information about
membership opportunities to the Stennis community.

For questions and more details, please contact Kim Miller
at kim.miller@usm.edu or 228.688.3170.

For a printable flyer, please click here.

View Event →
MSU Lunch & Learn
Apr
27
12:00 PM12:00

MSU Lunch & Learn

Please join the

Mississippi State University
Bagley College of Engineering

for a Lunch and Learn Session
on Graduate Distance Learning Opportunities

Thursday, April 27, 2017
12:00 p.m.

Bldg. 1100, Room 134, Gainesville Room
John C. Stennis Space Center

Lunch Provided

RSVP by April 20, 2017

MSU staff will be available to discuss admission, registration, and program information. For program details, please contact Tamra Swann at 662.325.3786 or tswann@bagley.msstate.edu.

To RSVP, contact The Center of Higher Learning
kim.miller@usm.edu or 228.688.3170

For a flyer on MSU Bagley Distance Learning, please click here.

View Event →
Microsoft Project: 2 day course
Apr
26
to Apr 27

Microsoft Project: 2 day course

Microsoft Project
Offered by PRCC Workforce Development
April 26 - 27, 2017
8:00 am—5:00 pm
Building 1103, Room 1005

Course fee is $40. Seating is limited. For all registration and payment questions, contact:

Troy Teadt
tteadt@prcc.edu
228-688-3113 (o)
985-788-3257 (c)

Prerequisite
Windows 8, Windows 7, Windows XP Basic
or equivalent experience

Course Outline

Day One

Unit 1: Getting started
Topic A: Project management concepts
Topic B: Exploring the Project window
Topic C: Working with project files

Unit 2: Working with tasks
Topic A: Creating a task list
Topic B: Modifying a task list
Topic C: Creating a Work Breakdown Structure

Unit 3: Scheduling tasks
Topic A: Setting up task links
Topic B: Working in Network Diagram view
Topic C: Working with advanced task options

Unit 4: Managing resources
Topic A: Creating base calendars
Topic B: Working with resources and calendars
Topic C: Working with resource costs

Unit 5: Working with views and tables
Topic A: Working with views
Topic B: Working with tables

Unit 6: Filtering, grouping, and sorting
Topic A: Working with filters
Topic B: Working with groups
Topic C: Sorting tasks and resources

Unit 7: Finalizing the task plan
Topic A: Finalizing schedules
Topic B: Resolving resource conflicts

 

Day Two

Unit 8: Tracking project work
Topic A: Managing a project
Topic B: Updating the progress of tasks
Topic C: Observing project progress

Unit 9: Analyzing and adjusting the plan
Topic A:
Analyzing the plan
Topic B: Rescheduling tasks

Unit 10: Formatting and reporting
Topic A: Formatting a project file
Topic B: Using drawing tools
Topic C: Printing views and reports
Topic D: Customizing reports
Topic E: Visual reports

Unit 11: Customizing the project environment
Topic A: Creating custom views
Topic B: Creating a custom table

Unit 12: Managing multiple projects
Topic A: Consolidating and sharing projects
Topic B: Sharing resources across projects

Unit 13: Project communications
Topic A: Communicating among a project team
Topic B: Working with hyperlinks

Unit 14: Exchanging project data
Topic A: Importing data
Topic B: Exporting data
Topic C: Copying data

For a printable flyer for this course, please click here.

View Event →
Intro to GIS - ArcGIS for Desktop
Apr
20
to Apr 21

Intro to GIS - ArcGIS for Desktop

Introduction to Geographic Information Systems (GIS) using ArcGIS for Desktop

Class will be held on Stennis Space Center, Bldg 1021 (MSU Bldg), 8:30-4:30 each day.  Cost is $25 per student. To register, please contact Troy Teadt at tteadt@prcc.edu or 228-688-3113 (office) or 985-788-3257 (cell).

Course Length: 2 days (16 hours)

Overview

This course is intended for individuals who have no experience with Geographic Information Systems (GIS), and offers a basic introduction to GIS using ESRI’s ArcGIS for Desktop software.  

Who Should Attend

Individuals who are interested in learning about Geographic Information Systems (GIS) and ESRI’s ArcGIS for Desktop software.


Goals

Course participants will learn and explore the following:

  • What GIS is and how is it used.
  • Exploring GIS data in ArcGIS for Desktop (ArcMap/ArcCatalog)
  • GIS data formats
  • Map projections and coordinate systems.
  • Symbolizing and Labeling Features in a map.
  • Working with attribute tables
  • Editing and creating data
  • Using geoprocessing tools to process data
  • Analyzing GIS data
  • Designing a map layout.

Prerequisites: Basic computer skills

View Event →
Microsoft Access: Advanced
Apr
19
8:00 AM08:00

Microsoft Access: Advanced

The Center of Higher Learning and Pearl River Community College are pleased to announce Microsoft software training at the NASA John C. Stennis Space Center. These classes are scheduled for the CHL Computer Training Lab in Bldg. 1103, Room 1005. 

To reserve a seat, at least one week prior, please contact Troy Teadt at 228-688-3113 (office), 985-788-3257 (cell) or tteadt@prcc.edu (email).

For a printable flyer, please click here.

Microsoft Access: Advanced (Level 3 of 3)

Performance-Based Objectives

Upon successful completion of this course, students will be able to:

  • put existing data into correctly designed tables and compact your database.
  • use a variety of techniques to summarize data.
  • create and revise basic Access macros.
  • create macros that require data entry in certain fields and automatic data entry in others.
  • use advanced features to enhance forms.
  • use advanced features to enhance reports and distribute a report to non-Access users.
  • use Office Links to use Access data in other Office programs.

Course Content

Lesson 1: Structuring Existing Data

Topic 1A: Use the Table Analyzer Wizard for Help

Topic 1B: Decide on Your Own Design

Topic 1C: Create a Junction Table

Topic 1D: Modify the Original Tables and Complete the Design

Topic 1E: Compact and Repair a Database

Lesson 2: Summarizing Data

Topic 2A: Group and Summarize Records in Different Ways

Topic 2B: Summarize with a Crosstab Query

Topic 2C: Pivot Query Results

Topic 2D: Display a Graphical Summary on a Form

Lesson 3: Simplifying Tasks with Macros

Topic 3A: Create a Macro

Topic 3B: Attach a Macro to a Command Button

Topic 3C: Restrict Records

Lesson 4: Adding Interaction and Automation with Macros

Topic 4A: Require Data Entry with a Macro

Topic 4B: Display a Message Box with a Macro

Topic 4C: Automate Data Entry

Lesson 5: Making Forms More Usable

Topic 5A: Change the Display of Data Under Certain Conditions

Topic 5B: Display a Calendar on a Form

Topic 5C: Organize Information with Tab Pages

Lesson 6: Making Reports More Powerful

Topic 6A: Cancel Printing of a Blank Report

Topic 6B: Include a Chart

Topic 6C: Arrange Data in Columns

Topic 6D: Distribute Reports as a Snapshot

Lesson 7: Expanding the Reach of Your Data

Topic 7A: Merge Access Data with a Word Document

Topic 7B: Publish Access Data as a Word Document

Topic 7C: Analyze Access Data in Excel

View Event →
Microsoft Access: Intermediate
Apr
12
8:00 AM08:00

Microsoft Access: Intermediate

The Center of Higher Learning and Pearl River Community College are pleased to announce Microsoft software training at the NASA John C. Stennis Space Center. These classes are scheduled for the CHL Computer Training Lab in Bldg. 1103, Room 1005. 

To reserve a seat, at least one week prior, please contact Troy Teadt at 228-688-3113 (office), 985-788-3257 (cell) or tteadt@prcc.edu (email).

For a printable flyer, please click here.

Access: Intermediate (Level 2 of 3)

Performance-Based Objectives

Upon successful completion of this course, students will be able to:

  • share data with other applications and enforce referential integrity.
  • modify the design of a table to streamline data entry and maintain data integrity.
  • use a filter to show you records in a datasheet or a form that match whatever conditions you specify, and you will generate different query results by creating different types of joins between tables.
  • create select queries that display special records and you will design other types of queries, including parameter and action queries.
  • create forms and change their designs to enhance the appearance and usability of a form and to make your form more professional.
  • create reports and change their designs to better organize and summarize information and to improve the appearance by enhancing data layout and working with report pagination.
  • create and work with data access pages.

Course Content

Lesson 1: Managing a Database and Data

Topic 1A: Import Data

Topic 1B: Maintain Record Integrity

Topic 1C: Exporting Data

Topic 1D: Documenting Table Relationships

Lesson 2: Controlling Data Entry

Topic 2A: Make Data Entry More Accurate

Topic 2B: Make Data Entry More Efficient

Topic 2C: Facilitate Data Entry

Lesson 3: Finding and Joining Data

Topic 3A: Find Data with Filters

Topic 3B: Get the Correct Data with Query Joins

Topic 3C: Building Bridges Between the Data

Topic 3D: Relating Data within a Table

Lesson 4: Creating Flexible Queries

Topic 4A: Summarizing Data with Queries

Topic 4B: Enter Criteria on the Fly

Topic 4C: Maintain Data with Queries

Lesson 5: Improving Your Forms

Topic 5A: Enhance the Appearance of a Form

Topic 5B: Enhance the Usability of a Form

Topic 5C: Make Your Forms More Professional

Topic 5D: Display Form Data from Multiple Tables

Lesson 6: Customizing Your Reports

Topic 6A: Organize Report Information

Topic 6B: Enhancing Data Layout

Topic 6C: Working with Report Pagination

Topic 6D: Summarizing Information

Topic 6E: Add a Subreport to an Existing Report

Topic 6F: Creating Mailing Labels

View Event →
Microsoft Access: Introduction
Apr
5
8:00 AM08:00

Microsoft Access: Introduction

The Center of Higher Learning and Pearl River Community College are pleased to announce Microsoft software training at the NASA John C. Stennis Space Center. These classes are scheduled for the CHL Computer Training Lab in Bldg. 1103.

To reserve a seat, at least one week prior, please contact Troy Teadt at 228-688-3113 (office), 985-788-3257 (cell) or tteadt@prcc.edu (email).

For a printable flyer, click here.

Access Level 1: Introduction

Performance-Based Objectives

Upon successful completion of this course, students will be able to:

  • define the purpose of and terminology associated with a relational database and Access objects.
  • follow the steps required to properly design a database.
  • create tables to hold data and then establish table relationships.
  • modify the design of and work with data in tables.
  • create, modify the design of, and work with select queries.
  • create and modify forms to work with your data.
  • create and modify reports to select, organize, and print data.

Course Content

Lesson 1: Working with a Relational Database

Topic 1A: Identify Uses of a Relational Database

Topic 1B: Define Database Terminology

Topic 1C: Create a New Database Based on a Template

Topic 1D: Examine the New Database

Lesson 2: Planning a Database

Topic 2A: Identify Database Purpose

Topic 2B: Review Existing Data

Topic 2C: Determine Fields

Topic 2D: Group Fields into Tables

Topic 2E: Normalize the Data

Topic 2F: Designate Primary and Foreign Keys

Topic 2G: Identify Table Relationships

Lesson 3: Building the Basic Structure

Topic 3A: Create a Blank Database

Topic 3B: Create a Table using a Wizard

Topic 3C: Compare Datasheet and Design Views

Topic 3D: Create Tables in Design View

Topic 3E: Create Relationships between Tables

Lesson 4: Working with Tables

Topic 4A: Modify a Table Design

Topic 4B: Work in Datasheet View

Topic 4C: Work with Subdatasheets

Lesson 5: Creating and Working with Select Queries

Topic 5A: Examine a Query

Topic 5B: Create a Query Using a Wizard

Topic 5C: Work in Query Design View

Topic 5D: Select Records

Topic 5E: Edit Values in a Query Datasheet

Topic 5F: Add a Calculated Field to a Query

Topic 5G: Perform a Calculation for a Group of Records

Lesson 6: Creating and Using Forms

Topic 6A: Create AutoForms

Topic 6B: Create a Form Using a Wizard

Topic 6C: Modify the Design of the Form

Topic 6D: Use Forms to Work with Data

Lesson 7: Creating and Using Reports

Topic 7A: Create an AutoReport

Topic 7B: Create a Report Using a Wizard

Topic 7C: Examine a Report in Design View

Topic 7D: Create a Calculated Field

Topic 7E: Change the Format of a Control

Topic 7F: Change the Style of a Report

Topic 7G: Adjust Report Width

View Event →
Microsoft Word Training: Advanced
Mar
29
8:00 AM08:00

Microsoft Word Training: Advanced

The Center of Higher Learning and Pearl River Community College are pleased to announce Microsoft software training at the NASA John C. Stennis Space Center. These classes are scheduled for the CHL Computer Training Lab in Bldg. 1103, Room 1005. 

To reserve a seat, at least one week prior, please contact Troy Teadt at 228-688-3113 (office), 985-788-3257 (cell) or tteadt@prcc.edu (email). 

To see details for the entire Word series, click here. 

 

Microsoft Word: Advanced (Level 3 of 3)

Performance-Based Objectives

Upon successful completion of this course, students will be able to:

  • create and distribute a form.
  • automate tasks by writing and revising macros.
  • create references to information in a document.
  • prepare a document for publication.
  • revise documents based on feedback provided by other users.

Course Content

Lesson 1: Creating and Distributing Forms

Topic 1A: Create a Form Template

Topic 1B: Insert Fields in a Form Template

Topic 1C: Protect the Form

Topic 1D: Test a Form

Lesson 2: Automating Tasks

Topic 2A: Run Macros

Topic 2B: Record a Macro

Topic 2C: Edit a Macro

Topic 2D: Create Toolbar Buttons

Topic 2E: Create Custom Menus

Lesson 3: Referencing Document Information

Topic 3A: Insert Bookmarks

Topic 3B: Insert Footnotes and Endnotes

Topic 3C: Add Captions

Topic 3D: Create Cross-References

Lesson 4: Preparing a Document for Publication

Topic 4A: Set Book Margins

Topic 4B: Create Custom Headers and Footers

Topic 4C: Compile a Table of Contents

Topic 4D: Index the Document

Topic 4E: Create a Master Document

Lesson 5: Revising Documents

Topic 5A: Create Document Versions

Topic 5B: Distribute a Document

Topic 5C: Track Changes to a Document

Topic 5D: Review Document Changes

Lesson 6: Modifying an HTML Page

Topic 6A: Save Word Documents as Web Pages

Topic 6B: Edit Web Pages in Word

Topic 6C: Insert Scrolling Text

Topic 6D: Place a Movie Clip in a Web Page

Topic 6E: Insert a Background Sound

View Event →
Microsoft Word Training: Intermediate
Mar
22
8:00 AM08:00

Microsoft Word Training: Intermediate

The Center of Higher Learning and Pearl River Community College are pleased to announce Microsoft software training at the NASA John C. Stennis Space Center. These classes are scheduled for the CHL Computer Training Lab in Bldg. 1103, Room 1005. 

To reserve a seat, at least one week prior, please contact Troy Teadt at 228-688-3113 (office), 985-788-3257 (cell) or tteadt@prcc.edu (email). 

To see details for the entire Word series, click here. 

 

Word: Intermediate (Level 2 of 3)

Performance-Based Objectives

Upon successful completion of this course, students will be able to:

  • create and modify custom templates, apply existing styles, and create a custom style.
  • enhance a table by merging table cells, sorting and calculating table data, and creating charts based on various table data.
  • learn how to insert, manipulate, and format graphic images, including clip art, AutoShapes, WordArt, and organization charts.
  • create a newsletter using columns, sections, and graphics.
  • use the Mail Merge Wizard to mail merge form letters, complete with mailing labels.
  • include comments in a document and compare and merge documents.

Course Content

Lesson 1: Creating and Modifying Templates

Topic 1A: Apply Styles

Topic 1B: Modify Styles

Topic 1C: Create User-Defined Styles

Topic 1D: Create a Template from an Existing Document

Lesson 2: Managing Tables and Table Data in Documents

Topic 2A: Convert Tabbed Text into a Table

Topic 2B: Merge Cells in a Table

Topic 2C: Open an Excel Table in Word

Topic 2D: Sort Table Data

Topic 2E: Perform Calculations in Tables

Topic 2F: Create and Modify a Chart Based on Word Table Data

Topic 2G: Link Excel Data in a Word Table

Lesson 3: Adding Graphics

Topic 3A: Insert a Clip Art Image

Topic 3B: Add an AutoShape

Topic 3C: Insert WordArt

Topic 3D: Insert an Organizational Chart

Lesson 4: Creating a Newsletter

Topic 4A: Create a Document Section

Topic 4B: Format Text into Newsletter Columns

Topic 4C: Control Column Text Flow

Topic 4D: Wrap Text Around a Graphic

Topic 4E: Create Envelopes and Labels

Lesson 5: Sending Form Letters

Topic 5A: Select the Main Document Type

Topic 5B: Select the Data Source

Topic 5C: Insert Merge Fields

Topic 5D: Merge and Preview Form Letters

Topic 5E: Create Mailing Labels

Lesson 6: Creating a Web Page

Topic 6A: Create a Web Page Using a Template

Topic 6B: Preview a Web Page in a Browser

Topic 6C: Create a Hyperlink in a Web Page

Topic 6D: Edit a Hyperlink in a Web Page

Topic 6E: Apply a Theme to a Web Page

Lesson 7: Managing Document Changes

Topic 7A: Use Comments in Word Documents

Topic 7B: Compare and Merge Documents

View Event →
Mar
15
to Mar 17

CARIS Training

CARIS Bathy DataBASE Training:

BASE Manager/Editor Course

March 15 - 17, 2017
2.5 days of training, course begins at 1:00 p.m. on March 15

CHL Computer Lab, 1103 Balch Blvd., Stennis Space Center

This course explores the use of the CARIS BASE Manager in the processing and preparation of bathymetric datasets. The course uses presentations, discussions and demonstrations, and hands-on practical exercises.

Audience: Anyone wanting a more in-depth knowledge of CARIS BASE Manager and to learn more about importing, validating, compiling, analyzing and extracting bathymetric data.

Topics Include

· Survey Data Management Overview

· Concepts in bathymetry data storage and associated workflows

· Import of 3rd party data formats

· Gridded surface and 3D point cloud creation for the storage of large volume bathymetric datasets

· Data cleaning and validation using area-based cleaning tools and 3D fly-though techniques

· TIN model creation and manipulation with generation of gridded surfaces

· Surface analysis and computations (e.g. differences, extracts, vertical shift, slope and aspect mapping, etc.)

· 3D visualization for large data volumes with raster image and vector draping

· Creation of Product Surfaces (e.g. Combined surfaces)

· Creation of Bathymetry Products as properly attributed S-57 Depth Contours, Depth Areas and Sounding objects

· Prepare objects for use in chart production

· Export bathymetric data and bathymetry products to 3rd part formats

Prerequisites

· Familiarity with operating computers and software

· Familiarity with basic hydrographic concepts and terminology

· Experience with bathymetric data

 

Very limited seating. Register today!
Cost: $500

For registration and payment,
contact CHL at:
kim.miller@usm.edu
228-688-3170

CHL accepts checks, credit cards, training forms and
purchase orders.

 

 

 

 

 

View Event →
Mar
13
to Mar 17

CompTIA A+ Training

CompTIA A+ Certification Course

CHL Computer Lab, Bldg. 1103, Room 1005
March 13 - 17, 2017
8:00 a.m. to 4:00 p.m. daily (40 hours)

DoD 8570 BASELINE CERTIFICATION:
This course is DoD Approved Baseline Certification for IAT Level I

Overview: In this course, you will acquire the essential skills and information you will need to install, configure, optimize, troubleshoot, repair, upgrade, and perform preventive maintenance on PCs, digital devices, and operating systems. This course is designed for students who are seeking the CompTIA A+ certification and who want to prepare for the CompTIA A+ 220-901 Certification Exam and the CompTIA 220-902 Certification Exam. Instruction is via New Horizons On Line Live (Instructor Led Training Online).

COURSE OBJECTIVES

In this course, you will install, configure, optimize, troubleshoot, repair, upgrade, and perform preventive maintenance on personal computers, digital devices, and operating systems. You will:

  • Identify the hardware components of personal computers and mobile digital devices.
  • Identify the basic components and functions of operating systems.
  • Identify networking and security fundamentals.
  • Identify the operational procedures that should be followed by professional PC technicians.
  • Install, configure, and troubleshoot display devices.
  • Install and configure peripheral components.
  • Manage system components.
  • Manage data storage.
  • Install and configure Microsoft Windows.
  • Optimize and maintain Microsoft Windows.
  • Work with other operating systems.
  • Identify the hardware and software requirements for client environment configurations.
  • Identify network technologies.
  • Install and configure networking capabilities.
  • Support mobile digital devices.
  • Support printers and multifunction devices.
  • Identify security threats, vulnerabilities, and controls.
  • Implement security controls.
  • Troubleshoot system-wide issues.

Course Fee: $1732.50 (reflects 30% discount for Stennis personnel)
Exam Voucher $398

For registration and payment, contact CHL at:
kim.miller@usm.edu
228-688-3170

For a printable flyer, click here.

View Event →
Microsoft Word Training: Introduction
Mar
8
8:00 AM08:00

Microsoft Word Training: Introduction

The Center of Higher Learning and Pearl River Community College are pleased to announce Microsoft software training at the NASA John C. Stennis Space Center. These classes are scheduled for the CHL Computer Training Lab in Bldg. 1103.

To reserve a seat, at least one week prior, please contact Troy Teadt at 228-688-3113 (office), 985-788-3257 (cell) or tteadt@prcc.edu (email). 

To see details for the entire Word series, click here.

Word: Introduction (Level 1 of 3)

Performance-Based Objectives

Upon successful completion of this course, students will be able to:

  • create a simple document, save a document, use Microsoft Word's automatic text features for entering text, and access online help.
  • make changes to an existing document using a variety of editing techniques.
  • apply text formatting to a document.
  • change the appearance of a document by applying various paragraph formats and effects.
  • create a table, navigate and enter text in a table, and enhance its appearance through formatting.
  • use Word's Find and Replace, and proofing tools to efficiently do your work.
  • preview a document, apply and remove formatting that affects entire pages, and print a document.

Course Content

Lesson 1: Creating a Document

Topic 1A: Enter Text

Topic 1B: Save a Document

Topic 1C: Use Automatic Text Features

Lesson 2: Editing Text

Topic 2A: Open an Existing Document

Topic 2B: Delete Blocks of Text

Topic 2C: Move and Copy Text

Topic 2D: Copy Multiple Items

Lesson 3: Formatting Text

Topic 3A: Apply Character Formats

Topic 3B: Change the Font and Font Size

Topic 3C: Add Highlighting and Color to Text

Topic 3D: Copy Text Formatting

Topic 3E: Paste Options

Lesson 4: Formatting Paragraphs

Topic 4A: Change Paragraph Alignment

Topic 4B: Change Line Spacing Within a Paragraph

Topic 4C: Add a Border and Shading to a Paragraph

Topic 4D: Set a Custom Tab

Topic 4E: Add Indents

Topic 4F: Create Numbered and Bulleted Lists

Topic 4G: Create an Outline Numbered List

Lesson 5: Adding Tables

Topic 5A: Create a Table

Topic 5B: Change Table Structure

Topic 5C: Add Table Borders and Shading

Topic 5D: AutoFormat a Table

Lesson 6: Using Word Timesavers

Topic 6A: Create a New Document Using a Template

Topic 6B: Create a New Document Using a Wizard

Topic 6C: Insert a Symbol

Topic 6D: Insert the Date or Time

Topic 6E: Find and Replace Text

Topic 6F: Check Spelling and Grammar

Topic 6G: Replace a Word Using the Thesaurus

Lesson 7: Setting Page Display and Printing Options

Topic 7A: Preview a Document

Topic 7B: Set the Page Orientation

Topic 7C: Create Headers and Footers

Topic 7D: Change Margins

Topic 7E: Insert a Page Break

Topic 7F: Align Text on a Page

Topic 7G: Print a Document

View Event →
Advanced QGIS
Dec
5
to Dec 6

Advanced QGIS

Advanced QGIS

December 5 - 6, 2016
8:30 - 4:30 each day
MSU Building, Bldg 1021, Stennis Space Center

Cost: $25

For reservations, registration and payment, contact:
Troy Teadt
PRCC Workforce Liaison
228-688-3113 (O)
985-788-3257 (C)
228-688-7454 (Fax)

View Event →
Intro to GIS using ArcGIS for Desktop
Nov
16
to Nov 17

Intro to GIS using ArcGIS for Desktop

Intro to GIS using ArcGIS for Desktop

November 16 - 17, 2016
8:30 - 4:30 each day
MSU Building, Bldg 1021, Stennis Space Center

Cost: $25

For reservations, registration and payment, contact:
Troy Teadt
PRCC Workforce Liaison
228-688-3113 (O)
985-788-3257 (C)
228-688-7454 (Fax)

Course Length: 2 days (16 hours)

Overview
This course is intended for individuals who have no experience with Geographic Information Systems (GIS), and offers a basic introduction to GIS using ESRI’s ArcGIS for Desktop software.  

Who Should Attend
Individuals who are interested in learning about Geographic Information Systems (GIS) and ESRI’s ArcGIS for Desktop software.

Goals
Course participants will learn and explore the following:

  • What GIS is and how is it used.
  • Exploring GIS data in ArcGIS for Desktop (ArcMap/ArcCatalog)
  • GIS data formats
  • Map projections and coordinate systems.
  • Symbolizing and Labeling Features in a map.
  • Working with attribute tables
  • Editing and creating data
  • Using geoprocessing tools to process data
  • Analyzing GIS data
  • Designing a map layout.

Prerequisites: Basic computer skills

View Event →
Excel 2013 Programming with VBA: 3 day course
Nov
1
to Nov 3

Excel 2013 Programming with VBA: 3 day course

Excel 2013 Programming with VBA
Offered by PRCC Workforce Development
November 1 - 3, 2016
8:00 am—5:00 pm
Building 1103, Room 1005

Course fee is $100, includes textbook. Seating is limited. For all registration and payment questions, contact:

Troy Teadt
tteadt@prcc.edu
228-688-3113 (o)
985-788-3257 (c)

Prerequisite
Proficient knowledge of Microsoft Excel

Course Outline

Getting Started
Introducing Visual Basic for Applications
Displaying the Developer Tab in the Ribbon
Recording a Macro
Saving a Macro-Enabled Workbook
Running a Macro
Editing a Macro in the Visual Basic Editor
Understanding the Development Environment
Using Visual Basic Help
Closing the Visual Basic Editor
Understanding Macro Security

Working with Procedures and Functions
Understanding Modules
Creating a Standard Module
Understanding Procedures
Creating a Sub Procedure
Calling Procedures
Using the Immediate Window to Call Procedures Creating a Function Procedure
Naming Procedures
Working with the Code Editor

Understanding Objects
Understanding Objects
Navigating the Excel Object Hierarchy
Understanding Collections
Using the Object Browser
Working with Properties
Using the With Statement
Working with Methods
Creating an Event Procedure

Using Expressions, Variables, and Intrinsic Functions
Understanding Expressions and Statements
Declaring Variables
Understanding Data Types
Working with Variable Scope
Using Intrinsic Functions
Understanding Constants
Using Intrinsic Constants
Using Message Boxes
Using Input Boxes
Declaring and Using Object Variables

Controlling Program Execution
Understanding Control-of-Flow Structures
Working with Boolean Expressions
Using the If...End If Decision Structures
Using the Select Case...End Select Structure
Using the Do...Loop Structure
Using the For...To...Next Structure
Using the For Each...Next Structure
Guidelines for use of Control-of-Flow Structures

Working with Forms and Controls Understanding UserForms
Using the Toolbox
Working with UserForm Properties, Events, and Methods Understanding Controls
Setting Control Properties in the Properties Window
Working with the Label Control
Working with the Text Box Control
Working with the Command Button Control
Working with the Combo Box Control
Working with the Frame Control
Working with Option Button Controls
Working with Control Appearance
Setting the Tab Order
Populating a Control
Adding Code to Controls
Launching a Form in Code

Working with the PivotTable Object
Understanding PivotTables
Creating a PivotTable Using Worksheet Data
Working with the PivotTable Objects
Working with the PivotFields Collection
Assigning a Macro to the Quick Access Toolbar

Debugging Code
Understanding Errors
Using Debugging Tools
Setting Breakpoints
Stepping through Code
Using Break Mode during Run mode
Determining the Value of Expressions

Handling Errors
Understanding Error Handling
Understanding VBA's Error Trapping Options
Trapping Errors with the On Error Statement
Understanding the Err Object
Writing an Error-Handling Routine
Working with Inline Error Handling

 

View Event →