Aug
20
to Aug 24

Introduction to MATLAB

 Introduction to MATLAB®

offered by

The University of Southern Mississippi

School of Ocean Science and Engineering

Division of Marine Science

August 20 - 24, 2018     8:30 am—12:30 pm

Building 1022, Room 101

 

Participation Requirements:

$500 registration fee

Text (to be purchased by student in advance of class):

“MATLAB: A Practical Introduction to Programming & Problem Solving” (4th Ed.)  ISBN-13: 978-0128045251 (Available from Amazon.com)

Pre-requisite course training (no cost): 

https://www.mathworks.com/training-schedule/matlab-onramp.html

Computers and software will be provided

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

To register, contact Keith Long at Keith.Long@usm.edu or 228-688-7662.


Contact Hours

Class Hours:  Monday to Friday, August 20 - 24, 2018 / 8:30a - 12:30p each day

Location:       Building 1022 classroom (Room 101)

Course Description

This 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

“MATLAB: A Practical Introduction to Programming & Problem Solving” (4th Ed.)  ISBN-13: 978-0128045251 (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 →

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 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 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 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 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 →
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 →
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 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 →
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 →
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 →
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 →
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 →
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 →
HYPACK Multibeam Training
Mar
19
to Mar 22

HYPACK Multibeam Training

HYPACK Multibeam Training

March 19 - 22, 2018
8:30 a.m. - 5:00 p.m. daily
CHL Computer Lab, 1103 Balch Blvd., Stennis Space Center

Cost: $800 per person, includes materials and boat time

Seating is limited! Register by Wednesday, March 14, 2018. To register, contact Kim Miller at kim.miller@usm.edu or 228-688-3170.

Overview
This four day course will concentrate on HYPACK® and HYSWEEP® multibeam applications and includes three days of classroom software training and one day of practical training on vessel. All activities will be conducted on site at the John C. Stennis Space Center. Training days 1, 3, and 4 will meet in the CHL Computer Lab. Training Day 2 will launch from the Stennis wharf.

Topics

  • Multibeam System Integration
  • Multibeam System Calibration
  • Multibeam Performance Testing
  • Multibeam Data Collection and Processing
  • Water Column Data Collection and Processing
  • Backscatter Data Collection and Processing
  • Magnetometer Data Collection and Processing
  • LIDAR
  • MBMAX
  • CUBE

 

 

 

View Event →
MSU Lunch & Learn
Mar
15
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, March 15, 2018
12:00 p.m.

Conference Room C107, Building 1100
John C. Stennis Space Center

Lunch Provided

RSVP by March 8, 2018

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

 

View Event →
CARIS Base Editor
Mar
14
to Mar 16

CARIS Base Editor

CARIS BASE Editor: Bathymetric Analysis Course

March 14 - 16, 2018
Wednesday: 1:00 p.m. - 5:00 p.m. / Thursday and Friday: 8:00 a.m. to 5:00 p.m.
CHL Computer Lab
1103 Balch Blvd., Stennis Space Center

Cost: $600 per person

Seating is limited! Register by Friday, March 9, 2018.
To register, contact Kim Miller at kim.miller@usm.edu or 228-688-3170. CHL accepts checks, credit cards, purchase orders and SF182s.

Overview
This course explores the use of the CARIS BASE Editor 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 Editor 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

 

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 →
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 →
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 →
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 →
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 →
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 →
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 →