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: Advanced
Oct
18
8:00 AM08:00

Microsoft Word: Advanced

Word Level 3

Wednesday, October 18, 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 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

Click here for a printable flyer for the entire three-part Word series.

View Event →
Introduction to QGIS
Oct
17
to Oct 18

Introduction to QGIS

Introduction to QGIS

October 17 - 18, 2017
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 →
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, September 13
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:

  • 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 →
Intermediate QGIS
Oct
17
to Oct 18

Intermediate QGIS

Intermediate QGIS

October 17 - 18, 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)

Intermediate QGIS

Course Length: 2 days (16 hours)

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
Sep
28
to Sep 29

Introduction to ArcGIS Online

Introduction to ArcGIS Online

September 28 - 29, 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 →
Introduction to QGIS
Sep
26
to Sep 27

Introduction to QGIS

Introduction to QGIS

September 26 - 27, 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, 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 →