Courses

Database

2112838 - Microsoft Access 2016: (A) Fundamentals - EOD

Course Description:

HUMAN RESOURCES & ORGANIZATIONAL EFFECTIVENESS: Discover the fundamentals of creating and working with Access databases. Learn what a relational database is and what it can do for you. Find out how to create and edit tables, set field properties, create table relationships and use simple queries, as well as how to create basic forms and basic reports.

Prerequisites

+ Course Outline

  • Opening Databases
  • Creating Simple Access Databases
  • Using Database Templates and Web App Templates
  • Modifying Table Data
  • Using Quick Search and Find and Replace
  • Adding Datasheet Totals and New Records
  • Updating Records with a Query
  • Appending Queries
  • Navigating Through and Printing Records
  • Sorting and Filtering Records
  • Creating Lookups
  • Exploring Relational Databases and the Design Process
  • Creating Guidelines for Determining Fields
  • Using Guidelines for Grouping Fields into Tables
  • Working with Primary Keys, Foreign Keys, and Composite Keys
  • Working with Table Relationships
  • Creating Tables
  • Importing Tables from Other Databases
  • Inserting and Deleting Fields
  • Configuring Fields to Auto-Increment
  • Setting the Default Value for a Fields
  • Creating Table Relationships
  • Understanding Referential Integrity
  • Editing Relationships
  • Joining Data from Different Tables in a Query
  • Understanding Types of Queries
  • Using the Run Command
  • Designing, Saving, Deleting, and Renaming Queries
  • Sorting and Filtering Data in a Query
  • Using Comparison and Logical Operators
  • Sorting, Grouping, and Formatting Query Fields
  • Performing Calculations in a Query
  • Creating New and Modifying Existing Forms
  • Saving and Deleting Forms
  • Creating New and Modifying an Existing Report
  • Saving and Deleting Reports
  • Adding Controls to Reports
  • Modifying Control Properties
  • Managing Labels and Inserting Images
  • Enhancing the Appearance of Reports with Galleries and Themes
  • Adding Headers or Footers to Reports
  • Inserting Page Numbers to Reports
  • Printing Reports
Back to Top


Desktop Publishing

2112620 - Adobe Acrobat DC - Essentials - EOD

Course Description:

HUMAN RESOURCES & ORGANIZATIONAL EFFECTIVENESS: Learn the basics of creating and manipulating Portable Document Format (PDF) files using Adobe Acrobat DC Professional. PDFs can be viewed and printed on any computer platform in exactly the format that you created it. Create PDF files using several different methods and combine multiple documents into a single PDF. Package multiple PDF and non-PDF files into a PDF portfolio. Make minor changes to PDFs that you have already created. And when you are ready to finalize your PDF, know what Save and Security options will suit your needs and those of your user.

Prerequisites

  • Windows or Mac experience

+ Course Outline

  • Creating PDFs and combined PDFs
  • Optimizing scanned PDFs
  • PDF Portfolios
  • Working with OCR
  • Creating bookmarks
  • Editing text and objects
  • Rearranging pages
  • Using save as options
  • Applying basic security features
Back to Top


2113018 - Adobe InDesign CC 17 - (A) Fundamentals - EOD

Course Description:

HUMAN RESOURCES & ORGANIZATIONAL EFFECTIVENESS: Learn the basics of desktop publishing using Adobe InDesign CC. Find out how to create and modify facing and non-facing pages documents. Discover how to enter and edit text and add graphics. Become skilled at importing and threading text. Find out how to prepare your document for printing and how to create an Acrobat PDF file from your InDesign document. Please note: While this course is taught using Adobe InDesign version CC 2017, the content will still be relevant to users of other InDesign versions.

Prerequisites

  • Windows or Mac experience
  • Strong knowledge of word processing

+ Course Outline

  • Creating facing and non-facing pages documents
  • Working with page margins and columns
  • Creating pages and spreads
  • Adding text
  • Importing content from Microsoft Word
  • Threading text – manually and automatically
  • Basic character and paragraph formatting
  • Adding automatic page numbering
  • Adding and working with graphics
  • Basic text wrap
  • Applying basic color to text and frames
  • Export files as PDF
  • Packaging documents for print
Back to Top


Email

2112854 - Microsoft Outlook 2016: (A) Fundamentals - EOD

Course Description:

HUMAN RESOURCES & ORGANIZATIONAL EFFECTIVENESS: Learn the fundamentals of using Microsoft Outlook to send receive, reply to, and forward email messages. Practice attaching files to messages, opening and saving attached files, and how to insert hyperlinks and signatures. Discover how to use the global address book and create contacts. Use the calendar feature to open and share calendars, create and send appointments, and schedule meetings. Create and modify tasks and notes.

Prerequisites

+ Course Outline

  • Navigating the Outlook Interface
  • Performing Basic E-mail Functions
  • Creating E-mail Messages
  • Checking Spelling and Grammar
  • Using AutoCorrect
  • Formatting Message Content
  • Attaching Files and Items
  • Using the Screenshot Tool
  • Using Quick Parts
  • Inserting Hyperlinks
  • Adding Signatures
  • Setting-up Desktop Alerts
  • Using Message Preview and Conversations
  • Working with Attachments
  • Using Voting Options, Tracking Options, and the Resend and Recall Options
  • Managing Messages Using Tags, Flags, and Other Commands
  • Organizing Messages Using Folders
  • Viewing the Calendar
  • Creating and Managing Appointments
  • Creating and Managing Meetings
  • Printing Calendars
  • Creating and Updating Contacts
  • Viewing and Organizing Contacts
  • Creating and Managing Tasks
  • Creating and Managing Notes
Back to Top


2112903 - Microsoft Outlook 2016: (B) Managing Email, Calendars, and Tasks - EOD

Course Description:

HUMAN RESOURCES & ORGANIZATIONAL EFFECTIVENESS: Learn to customize the Microsoft Outlook interface and use the calendar in more advanced ways. Adapt Outlook to your workflow with shortcuts and shortcut groups. See how to grant the permissions that you need to allow others to manage a calendar that you own. Manage how you assign and delegate duties using advanced Task features. Discover how to enhance your email messages with illustrations, WordArt, SmartArt, equations, charts, and tables. Find out how to use automatic replies, create rules, archive messages, as well as search and filter emails.

Prerequisites

+ Course Outline

  • Creating Rules
  • Sorting, Filtering, Organizing, and Searching Messages
  • Managing Junk Mail
  • Archiving Messages
  • Managing Additional Calendars
  • Tracking Meeting Responses
  • Assigning and Managing Tasks
  • Setting Delegates and Permissions
  • Sharing Calendars and Contacts
  • Changing Data File Settings
  • Customizing the Outlook Interface
  • Resetting Customizations
  • Creating and Managing Quick Steps
  • Adding SmartArt and WordArt
  • Using the Background Removal Tool
  • Using Galleries, Styles, and Themes
  • Inserting Equations and Symbols
  • Creating Tables and Charts
  • Setting Importance and Sensitivity Levels
  • Using Multiple E-mail Accounts
  • Using the From Option
  • Using the Bcc and From Fields
  • Setting Automatic Replies
  • Automatic Replies
  • The Automatic Replies Dialog Box
Back to Top


Graphics and Illustration

2113027 - Adobe Illustrator CC 17 - (A) Fundamentals - EOD

Course Description:

HUMAN RESOURCES & ORGANIZATIONAL EFFECTIVENESS: Learn how Adobe Illustrator CC can help you create beautifully drawn vector graphics that can be used to create logos or graphics for the Web or print. After learning navigational tools, you will start to create ellipses, stars, rectangles, and much more. Find out how to use the pen tool to create paths and how to create basic text. Create and apply colors and find out how to copy and scale shapes. Learn how to export illustrations. Please note: While this course is taught using Adobe Illustrator version CC 2017, the content will still be relevant to users of other Illustrator versions.

Prerequisites

  • Windows or Mac experience
  • Experience with Adobe Photoshop or Adobe Fireworks helpful

+ Course Outline

  • Creating basic shapes
  • Drawing with the Pen and Pencil tools
  • Selecting, editing and transforming objects
  • Working with paths
  • Working with colors and swatches
  • Creating and formatting basic text
  • Importing, exporting and saving files
Back to Top


2113021 - Adobe Photoshop CC 17 - (A) Fundamentals - EOD

Course Description:

HUMAN RESOURCES & ORGANIZATIONAL EFFECTIVENESS: Learn the basics of Photoshop CC including how to utilize layers and master selection tools. Discover how to work with text, apply special effects and how to use the History panel. Learn how to re-size and prepare images for web and print use. Please note: While this course is taught using Adobe Photoshop version CC 2017, the content will still be relevant to users of other Photoshop versions.

Prerequisites

  • Windows or Mac experience

+ Course Outline

  • Understanding image size and resolution
  • Cropping and adding canvas size
  • Saving files for print vs. web applications
  • Creating type
  • Formatting characters
  • Scaling and rotating type
  • Creating basic selections
  • Transforming selection content
  • Understanding layer basics
  • Managing layers
  • Opacity and blending mode basics
  • Applying layer effects
  • Flattening an image
Back to Top


2113034 - Adobe Photoshop CC 17 - (B) Image Corrections - EOD

Course Description:

HUMAN RESOURCES & ORGANIZATIONAL EFFECTIVENESS: Learn retouching strategies for your images using tools in Adobe Photoshop CC. Discover how to use the Red Eye, Clone Stamp, Healing Brush, Spot Healing Brush, Patch and Brush tools. Find out how to utilize photo filters, match colors in two different photos, counteract lens distortions, simulate lens effects, replace colors, apply adjustment layers, and more! Please note: While this course is taught using Adobe Photoshop version CC 2017, the content will still be relevant to users of other Photoshop versions.

Prerequisites

+ Course Outline

  • Adjusting Color and tone
  • Creating and working with adjustment layers
  • Working with shadows, midtones and highlights
  • Using Content-Aware fill and tools
  • Repairing images
  • Simulating photo filters
  • Correcting Image Distortions
  • Simulating Lens Effects
  • Sharpening and blurring images
  • Removing artifacts
  • Using advanced selection features
Back to Top


Information Management

2113427 - Document Accessibility - EOD

Course Description:

Learn how to make your electronic documents more accessible for people with disabilities. This course will cover key concepts for creating accessible documents in Microsoft Word, Excel, and PowerPoint, as well as an introduction to accessible PDFs.  This course is taught by a Division of Information Technology instructor.

Prerequisites:

  • Windows or Mac experience
  • Experience with Microsoft Office strongly recommended

Course Outline:

  • Defining content and structure with headings, lists, and tables
  • Using layout and design to improve readability
  • Enhancing the accessibility of images, charts and graphs, and links
  • Correcting common issues using the Accessibility Checker
  • Following a basic workflow for accessible PDFs

 

+ Course Outline

Learn how to make your electronic documents more accessible for people with disabilities. This course will cover key concepts for creating accessible documents in Microsoft Word, Excel, and PowerPoint, as well as an introduction to accessible PDFs.  This course is taught by a Division of Information Technology instructor.

Prerequisites:

  • Windows or Mac experience
  • Experience with Microsoft Office strongly recommended

Course Outline:

  • Defining content and structure with headings, lists, and tables
  • Using layout and design to improve readability
  • Enhancing the accessibility of images, charts and graphs, and links
  • Correcting common issues using the Accessibility Checker
  • Following a basic workflow for accessible PDFs

 

Back to Top


2111731 - Laserfiche Fundamentals - EOD

Course Description:

HUMAN RESOURCES & ORGANIZATIONAL EFFECTIVENESS: Learn to capture and manage paper and electronic documents with Laserfiche! Find out how to select servers and repositories, retrieve documents and manage folders. Create field, text and date searches. Discover how to add annotations, import and export files, as well as preview documents. For more information on Laserfiche visit: http://laserfiche.tamu.edu/index.php.

Prerequisites

  • Windows or Mac experience

+ Course Outline

  • Setting Up
    • Server and Repository Selection
    • Records Retention File structure
    • Password Security
  • Selecting the Default Folder
    • Default Folder Navigation
    • Folder Creation/Permission
    • Importing/Exporting Files
  • Searching Documents
    • Field Search
    • Text Search
    • Date Search
  • Adding Annotations
    • Stamp
    • Strike-through
    • Redact
  • Viewing Documents
    • Previews
Back to Top


Multimedia/Presentation

2112839 - Microsoft PowerPoint 2016: (A) Fundamentals - EOD

Course Description:

HUMAN RESOURCES & ORGANIZATIONAL EFFECTIVENESS: Discover how to create and edit presentations in Microsoft PowerPoint. Find out how to insert and modify shapes and pictures, as well as how to format and edit presentation text. Learn how to add slide transitions and sequence the appearance of objects on your slide by applying basic animation. Learn how to use slide sorter view to make organizing your slides easier. Learn tools that make showing your presentation a snap and the different options available when printing your presentations.

Prerequisites

+ Course Outline

  • Navigating PowerPoint
  • Creating and Saving PowerPoint Presentations
  • Selecting Presentation Types
  • Inserting Slides from Slide Layouts and Outlines
  • Reusing, Duplicating, Hiding and Showing Slides
  • Using Slide Layouts
  • Changing Slide Size
  • Applying and Working with Themes
  • Editing and Formatting Text
  • Viewing and Navigating a Presentations
  • Using the Slide Navigator
  • Working with Multiple Presentation Windows
  • Creating WordArt
  • Converting Text to SmartArt
  • Setting Text Box Margins and Spacing Options
  • Formatting Text as Columns
  • Formatting Text Boxes with Fills, Outlines and Effects
  • Inserting and Formatting Images
  • Inserting and Formatting Shapes
  • Arranging Objects
  • Animating Objects
  • Using AutoCorrect, the Spell Checker, the Insights Pane, and the Thesaurus
  • Checking Compatibility and Accessibility
  • Applying Transitions and Effects
  • Customizing Transition Timing
  • Adding Sounds
  • Printing Selected Slides, Presentations, Handouts, Outlines, and Notes Pages
  • Working with PowerPoint Presentation File Formats
  • Applying Animations and Timings
  • Setting Up Slide Shows
  • Rehearsing Timings
Back to Top


Software Demonstrations

2112923 - Creating Macros in Microsoft Excel and Word 2016 - EOD

Course Description:

HUMAN RESOURCES & ORGANIZATIONAL EFFECTIVENESS: In this demo, learn how to create macros, which are sets of instructions that can be used to simplify redundant or difficult tasks. Learn how to edit macros and create macro buttons and shortcuts in both Excel and Word.

Prerequisites

  • Microsoft Excel experience recommended

+ Course Outline

  • Create and Save Macros in Excel
  • Edit Excel Macros
  • Create and Save Macros in Word
  • Edit Word Macros
  • Create Macro Buttons and Shortcuts
Back to Top


2112922 - Microsoft Excel 2016 Tips & Tricks - EOD

Course Description:

HUMAN RESOURCES & ORGANIZATIONAL EFFECTIVENESS: In this demo, learn features and functions in Excel to increase your efficiency.

Prerequisites

  • None

Outline

  • Create Shortcut Ribbon
  • Import from Text
  • Create Formatting Style
  • Highlight Conditional Format Duplicates
  • Convert Cells to a Table
  • Sort Data by Column or Dataset
  • Hide Columns and Freeze Panes
  • Show and Edit Formulas
  • Use the DateDif Equation
  • And More!

+ Course Outline

HUMAN RESOURCES & ORGANIZATIONAL EFFECTIVENESS: In this demo, learn features and functions in Excel to increase your efficiency.

Prerequisites

  • None

Outline

  • Create Shortcut Ribbon
  • Import from Text
  • Create Formatting Style
  • Highlight Conditional Format Duplicates
  • Convert Cells to a Table
  • Sort Data by Column or Dataset
  • Hide Columns and Freeze Panes
  • Show and Edit Formulas
  • Use the DateDif Equation
  • And More!
Back to Top


2112757 - Microsoft Windows 10 & Office 2016 Demo - EOD

Course Description:

HUMAN RESOURCES & ORGANIZATIONAL EFFECTIVENESS: Explore how you navigate the new interface of Windows 10. Discover some of the new features of Microsoft Office 2016. Find out “what’s in,” “what’s out,” and what looks different. Learn what the most obvious changes to common tools will be, and see the exciting new options that will enhance productivity. Stay for an optional Q&A session after the demo.

Prerequisites

  • None

+ Course Outline

  • Windows 10
  • Office 2016 Suite
  • Outlook 2016
  • Word 2016
  • Excel 2016
  • PowerPoint 2016
Back to Top


2112925 - Tips for Creating a Paperless Office - EOD

Course Description:

HUMAN RESOURCES & ORGANIZATIONAL EFFECTIVENESS: When eliminating paper from your office workflow, you need to be more resilient than ever in your digital skills for handling and managing documents. In this demo, learn how to share and export documents directly from the individual programs. Develop and collaborate using Track Changes. Analyze your folder structure and apply naming conventions. Experience OneNote as it captures data from the web, and accesses the documents from a variety of devices.

Prerequisites

  • None

+ Course Outline

Edit and Collaborate with Microsoft Office:
  • File Sharing
  • Tracking Changes
  • Adding and Replying to Comments
  • Using Outlook Voting Buttons

Analyze Folder and File Organization and Naming Conventions:
  • Analyzing Folder Structure
  • Applying Naming Conventions
  • Using Special Characters, Dates, or Numbers

Manage All Your Information with OneNote:
  • Capturing Information from Web
  • Accessing Documents from All of Your Computers or Devices
Back to Top


Spreadsheets

2112851 - Microsoft Excel 2016: (A) Fundamentals - EOD

Course Description:

HUMAN RESOURCES & ORGANIZATIONAL EFFECTIVENESS: Learn the fundamentals of Microsoft Excel and the basic functions of spreadsheets. Create and save workbooks; apply text and number formatting; select, move, copy, and delete data. Apply borders, cell styles and other formatting to rows, columns, cells, and tables. Learn how to write formulas and use common functions. Explore page layout and printing options for worksheets. Check spelling, search for and replace data, and save worksheets in alternate file formats.

Prerequisites

+ Course Outline

  • Identifying the Elements of the Excel Interface
  • Creating a Basic Worksheet
  • Creating Formulas in Worksheets
  • Inserting Functions in Worksheets
  • Reusing Formulas
  • Creating Relative, Absolute, and References
  • Manipulating Data, Cells, Columns and Rows
  • Searching For and Replace Data
  • Checking Spelling
  • Modifying Fonts
  • Adding Borders, Colors, and Sheet Backgrounds
  • Applying Number Formats
  • Aligning Cell Contents
  • Using Indent, Wrap Text, Orientation, and Merge & Center Options
  • Applying Cell Styles
  • Defining the Basic Page Layout and Print Options for a Workbook
  • Creating Headers and Footers
  • Adjusting Page Margins and Page Orientation
  • Refining the Page Layout
  • Applying Print Options
Back to Top


2112887 - Microsoft Excel 2016: (B) Managing and Enhancing Workbooks - EOD

Course Description:

HUMAN RESOURCES & ORGANIZATIONAL EFFECTIVENESS: Learn more useful features of Microsoft Excel and spreadsheets to create and manage large workbooks, freeze and hide rows and columns, work with ranges, and protect files. Find out how to use functions to format text, work with styles and themes, add and delete watermarks, outline and consolidate data, create subtotals, as well as sort and filter data. Discover how to insert graphic objects. Table and chart creation and template use will also be covered.

Prerequisites

+ Course Outline

  • Formatting Worksheet Tabs
  • Manage Worksheet References in Formulas
  • Grouping, Repositioning, Inserting, and Deleting Worksheets
  • Hiding and Un-hiding Worksheets
  • Splitting, Freezing Panes, and Arranging
  • Applying and Editing Range Names
  • Using Range Names in Formulas
  • Using Specialized Functions
  • Using Nested Functions
  • Using Automatic Workbook Calculations
  • Enabling Iterative Calculations
  • Creating and Modifying Tables
  • Sorting and Filtering Data
  • Removing Duplicate Values
  • Using Subtotal and Database Functions to Calculate Data
  • Customizing Workbooks with Comments, Hyperlinks, Watermarks, and Background Pictures
  • Managing and Customizing Themes
  • Creating and Using Templates
  • Protecting Files
  • Preparing Workbooks for Multiple Audiences
  • Inserting Charts
  • Inserting and Modify Graphic Objects (Shapes, WordArt, Text Boxes, Images, and SmartArt)
  • Layering and Grouping Graphic Objects
Back to Top


2112889 - Microsoft Excel 2016: (C) Advanced Calculations - EOD

Course Description:

HUMAN RESOURCES & ORGANIZATIONAL EFFECTIVENESS: Learn more advanced features of Microsoft Excel and spreadsheets. Find out how to use logical, statistical, financial, and date functions. You will also build lookup functions, validate data, and troubleshoot errors. Discover how to create sparklines and scenarios, consolidate data, link cells in workbooks, and create outlines.

Prerequisites

+ Course Outline

  • Using Text Functions (LEFT, RIGHT, MID, LEN, TRIM, UPPER, LOWER, PROPER, CONCATENATE and TRANSPOSE)
  • Using Logical Functions and Operators (AND, OR, and IF)
  • Using Lookup Functions (LOOKUP, VLOOKUP, and HLOOKUP)
  • Using Date Functions (TODAY and NOW)
  • Serializing Dates and Times with Functions
  • Using Financial Functions (IPMT, PPMT, NPV, and FV)
  • Applying Conditional Formatting
  • Adding Data Validation Criteria
  • Tracing Cells
  • Troubleshooting Invalid Data and Formula Errors
  • Watching and Evaluating Formulas
  • Creating a Data List Outline
  • Creating Sparklines
  • Creating Scenarios
  • Performing a What-If Analysis
  • Consolidating Data
  • Linking Cells in Different Workbooks
  • Merging Workbooks
Back to Top


2112890 - Microsoft Excel 2016: (C) Charts and PivotTables - EOD

Course Description:

HUMAN RESOURCES & ORGANIZATIONAL EFFECTIVENESS: Learn more advanced features of Microsoft Excel and spreadsheets, including advanced charting features, how to modify each chart element to meet your design standards, and how to create a chart template for consistent visual presentations. Discover how to apply trendlines from historical data to project future estimates. Learn to use pivot tables to reorganize, filter, and sort data to manage the information you need.

Prerequisites

+ Course Outline

  • Creating Charts
  • Resizing and Moving Charts
  • Modifying and Formatting Charts
  • Formatting Charts with a Style
  • Adding a Legend to the Chart
  • Creating a Trendline
  • Formatting Trendlines
  • Creating Advanced Charts
  • Creating Custom Chart Templates
  • Viewing Chart Animations
  • Creating a PivotTable
  • Summarizing Data in a PivotTable
  • Exploring PowerPivot Functions
  • Filtering Data by Using Slicers
  • Analyzing Data with PivotCharts
  • Applying Styles to a PivotChart
Back to Top


Web Page Creation

2111936 - Web Accessibility - Essentials - EOD

Course Description:

HUMAN RESOURCES & ORGANIZATIONAL EFFECTIVENESS: This course is designed for employees who have any role related to Texas A&M University websites and/or web content (e.g., administrators, managers, web designers, web developers, content contributors).  Learn the key concepts of web accessibility, get an overview of the required web accessibility standards at Texas A&M, and discover practical “next steps” to make your websites more accessible. You’ll also get hands-on experience with some common assistive technologies, to better understand how people with disabilities use the web. This course is taught by a Division of Information Technology instructor.

Prerequisites

  • Windows or Mac experience
 

+ Course Outline

  • What is web accessibility, and why is it important?
  • Using assistive technology to access web content (hands-on demonstration)
  • Understanding web accessibility standards and the most common accessibility issues at Texas A&M
  • Creating accessible web content and next steps
Back to Top


2111937 - Web Accessibility - Advanced - EOD

Course Description:

HUMAN RESOURCES & ORGANIZATIONAL EFFECTIVENESS: This course is designed for employees who have a role in creating and/or maintaining Texas A&M University websites and/or web content (e.g., web designers, web developers, and content contributors).  Learn what steps you can take to make your website more accessible to users with disabilities. This includes common design considerations, as well as specific markup that will benefit assistive technology users. Lessons will focus on discussing common barriers, hands-on demonstrations with assistive technologies, and strategies to maximize accessibility.  Throughout the course, the Web Content Accessibility Guidelines (WCAG) 2.0 will be discussed at length. This course is taught by a Division of Information Technology instructor.

Prerequisites

  • Windows or Mac experience
  • Web Accessibility – Essentials (strongly recommended)
  • Strong working knowledge of HTML and CSS

+ Course Outline

  • Layout and design
  • Structure and semantic markup
  • Images
  • Time-based media (e.g., video)
  • Links and navigation
  • Tables
  • Forms
  • Custom components and repurposed HTML

 

Back to Top


Word Processing

2112858 - Microsoft Word 2016: (A) Fundamentals - EOD

Course Description:

HUMAN RESOURCES & ORGANIZATIONAL EFFECTIVENESS: Learn the essentials of Microsoft Word and word processing. Create, navigate, edit and save documents, apply character formatting, and insert images. Find out how to apply paragraph formatting, create bulleted and numbered lists, and customize tab stops. Learn to adjust margins and indents. Work with document views and learn how to print documents.

Prerequisites

+ Course Outline

  • Identify the Components of the Word Interface
  • Viewing Documents
  • Creating and Saving Documents
  • Previewing and Printing Options
  • Navigating and Selecting Text
  • Modifying Text
  • Finding and Replacing Text
  • Applying Character Formatting
  • Aligning Text Using Tabs
  • Displaying Text as List Items
  • Controlling Paragraph Layout
  • Using Margins, Indentation, Spacing, and Hyphenation
  • Adding, Resizing, and Cropping Images
  • Applying Text Wrap
  • Rotating and Positioning Images
  • Adding Captions
  • Sorting Lists, Fields, and Text
  • Renumbering and Customizing Lists
  • Working with Multilevel Lists
  • Adjusting List Appearance and Formatting
  • Checking Spelling and Grammar
  • Determining Readability and Word Count
  • Using the Thesaurus and Research Options
  • Checking Accessibility
  • Customizing the Word Interface
  • Using AutoCorrect
  • Using Additional Save Options
  • Opening Non-Native Files in Microsoft Word
  • Importing Files
  • Opening and Editing PDF Documents
  • Appending Text to a Document
  • Linking to Other Documents
Back to Top


2112893 - Microsoft Word 2016: (B) Mail Merge - Letters and Emails - EOD

Course Description:

HUMAN RESOURCES & ORGANIZATIONAL EFFECTIVENESS: Learn how to use Word to create form letters, labels and envelopes to send to multiple recipients. Find out how to specify the main document to be sent and how to create a recipient list. Learn how to create merge fields, preview your merged data, print or email your merged documents and set options for mailing labels and envelopes. Learn to use mail merge to generate a directory or catalog from your list data.

Prerequisites

+ Course Outline

  • Inserting Mail Merge Fields
  • Setting Mail Merge Rules
  • Using Data Sources
  • Understanding the Mail Merge Process
  • Using the Mail Merge Wizard
  • Opening a Mail Merge Document with a Data Source Attached
  • Unlinking a Data Source
  • Merging Envelopes and Labels
  • Creating a Single Envelope or Label
  • Setting Up a Return Address
  • Creating a Data Source Using Word
  • Creating an Email Merge
Back to Top


Employee Orientations

211495 - New Employee Welcome (NEW) Session - EOD

Course Description:

HUMAN RESOURCES & ORGANIZATIONAL EFFECTIVENESS: Aggieland 101. During this fast-paced, high-energy session, participants will become more knowledgeable about Texas A&M University—its rich history and traditions, tri-fold mission, core values, organizational structure, and commitment to diversity and inclusion. Through learning what makes Texas A&M unique, participants will walk away with a sense of pride and enthusiasm for being part of the Aggie family. Additional information and resources for new employees can be found at http://new.tamu.edu/.

Registration is required. Lunch will be provided.

Prerequisites

  • None

+ Course Outline

  • None
Back to Top


2113509 - New Hire Benefits Orientation - EOD

Course Description:

HUMAN RESOURCES & ORGANIZATIONAL EFFECTIVENESS: All newly benefits-eligible employees are encouraged to attend this basic overview of the comprehensive insurance and retirement benefits package offered by the Texas A&M University System. Topics covered include health insurance, life and disability insurance, flexible spending accounts, paid time off, longevity, and retirement plans. This session is open to any newly benefits-eligible employee; however, it is recommended to be taken within the first month of employment. Registration is required. This session is taught by an HR Benefits Services instructor.

Prerequisites

  • None

+ Course Outline

  • Basic overview of the comprehensive insurance and retirement benefits package offered by the Texas A&M University System
Back to Top


Employment Law

211176 - Alcohol and Drugs in the Workplace - EOD

Course Description:

HUMAN RESOURCES & ORGANIZATIONAL EFFECTIVENESS: This workshop provides participants with information on the signs and symptoms of substance use and abuse. The course also addresses the University's policy and rules regarding substance use and abuse and how to respond to troubled employees. This workshop is taught by an HR Employee Assistance Program instructor.

Prerequisites

  • None

+ Course Outline

  • Learning about alcohol and drugs and the workplace
    • Reviewing statistics related to use and abuse in the workplace
    • Reviewing signs and symptoms of use and abuse
    • Discussing the disease model of drug abuse
  • Reviewing Texas A&M Policies and Procedures
    • Reviewing the Reasonable Suspicion Testing Policy
    • Reviewing testing requirements and implications
  • Reviewing and discussing testing guidelines and procedures
    • How to initiate a test and what to say
    • What are the legalities?
    • Reviewing written guidelines approved by the system
Back to Top


211181 - DOT - Supervisor Training Alcohol and Drugs in the Workplace - EOD

Course Description:

HUMAN RESOURCES & ORGANIZATIONAL EFFECTIVENESS: This workshop, which is offered by special request, focuses on the Department of Transportation (DOT) requirements for workplace alcohol and drug testing. Topics covered include signs and symptoms of substance use and abuse, workplace testing, documentation and how to respond to troubled employees. This course is taught by an HR Employee Assistance Program instructor.

Prerequisites

  • None

+ Course Outline

  • Offered by special request
Back to Top


Professional Enhancement

2111702 - Bridging the Gap: The Multigenerational Workforce - EOD

Course Description:

HUMAN RESOURCES & ORGANIZATIONAL EFFECTIVENESS: We have as many as four distinct generations working side by side, represented by individuals who have different values, different ideas, and different ways of getting things done. An understanding of the generational distinctions allows individuals and teams to work more effectively. The purpose of this course is to provide a framework that helps to recognize the events and influences that shaped the four generations and the impact they have on the workplace. Participants will gain insights into the value of a multigenerational workplace and learn strategies to bridge the differences for better relationships and increased productivity.

Required Prerequisite

  • Online Course 2111862  Generations at Work - EOD (Required)

By the end of this workshop, participants will be able to:

  • Define each of the Generations in the workforce
  • Identify the unique generational values and the impact on behavior in the workplace
  • Identify the generational clash points
  • List strategies to bridge the generational gaps

 

+ Course Outline

HUMAN RESOURCES & ORGANIZATIONAL EFFECTIVENESS: We have as many as four distinct generations working side by side, represented by individuals who have different values, different ideas, and different ways of getting things done. An understanding of the generational distinctions allows individuals and teams to work more effectively. The purpose of this course is to provide a framework that helps to recognize the events and influences that shaped the four generations and the impact they have on the workplace. Participants will gain insights into the value of a multigenerational workplace and learn strategies to bridge the differences for better relationships and increased productivity.

Required Prerequisite

  • Online Course 2111862  Generations at Work - EOD (Required)

By the end of this workshop, participants will be able to:

  • Define each of the Generations in the workforce
  • Identify the unique generational values and the impact on behavior in the workplace
  • Identify the generational clash points
  • List strategies to bridge the generational gaps

 

Back to Top


211368 - Developing Cultural Competence in the Workplace - EOD

Course Description:

HUMAN RESOURCES & ORGANIZATIONAL EFFECTIVENESS: This workshop focuses on exploring the role that culture plays in our daily interactions with others. This interactive session provides participants with the opportunity to examine both the challenges and opportunities that result from an increasingly diverse workforce and examines ways to develop cultural competence. This course is open to all Texas A&M employees.

Required Prerequisite

  • TrainTraq Online Course #2111243 Introduction to Diversity and Inclusion

By the end of this workshop, participants will be able to:

  • Identify the dimensions of diversity and inclusion
  • Examine our own and other's cultural identity and cultural filters
  • Develop a basic understanding of power and privilege
  • Explain how we are socialized to experience, value, and engage in the world
  • Identify skills to respond to insensitive and/or inappropriate remarks and behaviors
  • Identifying actions toward inclusion and cultural competence

 

+ Course Outline

HUMAN RESOURCES & ORGANIZATIONAL EFFECTIVENESS: This workshop focuses on exploring the role that culture plays in our daily interactions with others. This interactive session provides participants with the opportunity to examine both the challenges and opportunities that result from an increasingly diverse workforce and examines ways to develop cultural competence. This course is open to all Texas A&M employees.

Required Prerequisite

  • TrainTraq Online Course #2111243 Introduction to Diversity and Inclusion

By the end of this workshop, participants will be able to:

  • Identify the dimensions of diversity and inclusion
  • Examine our own and other's cultural identity and cultural filters
  • Develop a basic understanding of power and privilege
  • Explain how we are socialized to experience, value, and engage in the world
  • Identify skills to respond to insensitive and/or inappropriate remarks and behaviors
  • Identifying actions toward inclusion and cultural competence

 

Back to Top


2111242 - Fostering Respect in a Diverse Workplace - EOD

Course Description:

HUMAN RESOURCES & ORGANIZATIONAL EFFECTIVENESS: This workshop provides information about the employee’s and supervisor’s role in maintaining a work environment that is free from discrimination and harassment. Participants will have the opportunity to review federal EEO laws, identify and discuss behaviors that might unknowingly contribute to a disrespectful or hostile environment, and identify ways to be proactive in creating a respectful work environment.

Prerequisites

  • None

+ Course Outline

  • Understanding Employer's Duty
  • Understanding EEO laws
  • Discussion of:
    • Related TAMU vision and values
    • Equal Pay Act of 1963
    • Title VII of the Civil rights Act of 1964
    • Age Discrimination in Employment Act of 1964
    • Americans with Disabilities Act of 1990
    • Sexual Harassment
  • Increasing awareness of respectful behavior in the workplace
  • Identifying respectful behavior
  • Identifying positive and proactive actions
  • Identifying resources
Back to Top


211156 - Interpersonal Communication Skills - EOD

Course Description:

HUMAN RESOURCES & ORGANIZATIONAL EFFECTIVENESS: This workshop introduces foundational knowledge and skills of interpersonal communication. Participants receive an overview of the communication process, explore common communication pitfalls, assess their preferred communication style(s), and learn and practice a variety of strategies for improving interpersonal communication in the workplace. This course is open to all Texas A&M employees.

Prerequisites

  • None

+ Course Outline

By the end of this program, participants will be able to:

  • Identify communication barriers
  • Explain and adapt to different communication styles
  • Utilize a feedback tool
  • Apply listening techniques
Back to Top


2111526 - Lasting Impressions: Providing Excellent Customer Service - EOD

Course Description:

HUMAN RESOURCES & ORGANIZATIONAL EFFECTIVENESS: Understanding your customers and effectively communicating with them are key elements for providing excellent customer service. The purpose of this workshop is to provide information for a better understanding of customers and their needs. Participants will learn valuable ways to communicate with diverse customers and practice responding to various challenging scenarios for the delivery of excellent customer service.

Required Prerequisite

  • Online Course 2111241: The Texas A&M University System: A Culture of Service (required)

By the end of this workshop, participants will be able to:

  • Identify customer needs, wants and expectations
  • Interpret triggering moments
  • Apply positive communication skills
  • Identify and utilize service recovery techniques

 

+ Course Outline

HUMAN RESOURCES & ORGANIZATIONAL EFFECTIVENESS: Understanding your customers and effectively communicating with them are key elements for providing excellent customer service. The purpose of this workshop is to provide information for a better understanding of customers and their needs. Participants will learn valuable ways to communicate with diverse customers and practice responding to various challenging scenarios for the delivery of excellent customer service.

Required Prerequisite

  • Online Course 2111241: The Texas A&M University System: A Culture of Service (required)

By the end of this workshop, participants will be able to:

  • Identify customer needs, wants and expectations
  • Interpret triggering moments
  • Apply positive communication skills
  • Identify and utilize service recovery techniques

 

Back to Top


2111871 - Lost in Translation: Navigating Intercultural Communication in the Workplace - EOD

Course Description:

HUMAN RESOURCES & ORGANIZATIONAL EFFECTIVENESS: The global reach of Texas A&M provides opportunities for frequent contact with people from multiple cultures.  While having a diverse workforce offers numerous advantages, cultural differences can contribute to misunderstandings, conflict and discord. An understanding of one’s own culture and that of others allows people to work together more effectively.  This course provides a fundamental framework that helps to recognize the factors and influences of culture on communication and identify skills to improve intercultural communication.  Participants gain insights into the value of effectively communicating with people from diverse cultures and learn strategies for resolving differences for better relationships and increased productivity at work.

Prerequisites:

  • None

By the end of this workshop, participants will be able to:

  • Define intercultural communication
  • Identify the elements that impact intercultural communication
  • Recognize the stumbling blocks
  • Utilize tools and strategies to effectively communicate with other cultures

+ Course Outline

HUMAN RESOURCES & ORGANIZATIONAL EFFECTIVENESS: The global reach of Texas A&M provides opportunities for frequent contact with people from multiple cultures.  While having a diverse workforce offers numerous advantages, cultural differences can contribute to misunderstandings, conflict and discord. An understanding of one’s own culture and that of others allows people to work together more effectively.  This course provides a fundamental framework that helps to recognize the factors and influences of culture on communication and identify skills to improve intercultural communication.  Participants gain insights into the value of effectively communicating with people from diverse cultures and learn strategies for resolving differences for better relationships and increased productivity at work.

Prerequisites:

  • None

By the end of this workshop, participants will be able to:

  • Define intercultural communication
  • Identify the elements that impact intercultural communication
  • Recognize the stumbling blocks
  • Utilize tools and strategies to effectively communicate with other cultures
Back to Top


2112959 - Project Management Fundamentals - EOD

Course Description:

HUMAN RESOURCES & ORGANIZATIONAL EFFECTIVENESS: In this course, you will get an introduction to the essentials of project management in the context of TAC 216. This will include discussions on available tools and resources, as well as a survey of the nine project management knowledge areas (Time, Scope, Communications, Risk, Financial, Resource, Human Resource, Stakeholder and Quality Management). Key concepts in each area will be highlighted, but this is a survey class designed to give a high level overview. This course is taught by a subject matter expert from the Mays Business School.

Outline:

  • Identification of available PM Resources
  • "TAC 216" basic information
  • Project Management Terminology
  • Project Management Benefits
  • Project Management Methodologies
  • Survey of Project Management Knowledge Areas

+ Course Outline

HUMAN RESOURCES & ORGANIZATIONAL EFFECTIVENESS: In this course, you will get an introduction to the essentials of project management in the context of TAC 216. This will include discussions on available tools and resources, as well as a survey of the nine project management knowledge areas (Time, Scope, Communications, Risk, Financial, Resource, Human Resource, Stakeholder and Quality Management). Key concepts in each area will be highlighted, but this is a survey class designed to give a high level overview. This course is taught by a subject matter expert from the Mays Business School.

Outline:

  • Identification of available PM Resources
  • "TAC 216" basic information
  • Project Management Terminology
  • Project Management Benefits
  • Project Management Methodologies
  • Survey of Project Management Knowledge Areas
Back to Top


2113217 - Project Management Scope, Schedule & Budget - EOD

Course Description:

HUMAN RESOURCES & ORGANIZATIONAL EFFECTIVENESS: In this course, you will get an in-depth review of the traditional triple constraints. This course is taught by a subject matter expert from the Mays Business School.

Outline:
• Navigation of scope ideation, documentation and tracking
• Using scope to generate schedule & budget
• Project schedule creation and management
• Project budget creation & management

 

+ Course Outline

HUMAN RESOURCES & ORGANIZATIONAL EFFECTIVENESS: In this course, you will get an in-depth review of the traditional triple constraints. This course is taught by a subject matter expert from the Mays Business School.

Outline:
• Navigation of scope ideation, documentation and tracking
• Using scope to generate schedule & budget
• Project schedule creation and management
• Project budget creation & management

 

Back to Top


2113216 - Project Risk Management - EOD

Course Description:

HUMAN RESOURCES & ORGANIZATIONAL EFFECTIVENESS: In this course, you will get an in-depth review of Project Risk Management. This course is taught by a subject matter expert from the Mays Business School.

Outline:
• Risk Identification
• Qualitative Risk Management
• Quantitative Risk Management
• Risk Responses

 

+ Course Outline

HUMAN RESOURCES & ORGANIZATIONAL EFFECTIVENESS: In this course, you will get an in-depth review of Project Risk Management. This course is taught by a subject matter expert from the Mays Business School.

Outline:
• Risk Identification
• Qualitative Risk Management
• Quantitative Risk Management
• Risk Responses

 

Back to Top


TAMU Workday Training

2113347 - Workday Clinic: HR Liaison – Change Job (TAMU) - EOD

Course Description:

This session is designed for HR Liaisons at TAMU.  A short tutorial on the Workday business process Change Job will be presented and followed by open lab time where participants can start this process for their organization.

+ Course Outline

This session is designed for HR Liaisons at TAMU.  A short tutorial on the Workday business process Change Job will be presented and followed by open lab time where participants can start this process for their organization.

Back to Top


2113342 - Workday Clinic: HR Liaison – Create Job Requisition (TAMU) - EOD

Course Description:

HUMAN RESOURCES & ORGANIZATIONAL EFFECTIVENESS:  This session is designed for HR Liaisons at TAMU.  A short tutorial on the Workday business process Create Job Requisition will be presented and followed by open lab time where participants can begin creating a new job requisition for their organization.

+ Course Outline

HUMAN RESOURCES & ORGANIZATIONAL EFFECTIVENESS:  This session is designed for HR Liaisons at TAMU.  A short tutorial on the Workday business process Create Job Requisition will be presented and followed by open lab time where participants can begin creating a new job requisition for their organization.

Back to Top


2113341 - Workday Clinic: HR Liaison – Create Position (TAMU) - EOD

Course Description:

HUMAN RESOURCES & ORGANIZATIONAL EFFECTIVENESS: This session is designed for HR Liaisons at TAMU.  A short tutorial on the Workday business process Create Position will be presented and followed by open lab time where participants can begin creating a new position for their organization.

 

+ Course Outline

HUMAN RESOURCES & ORGANIZATIONAL EFFECTIVENESS: This session is designed for HR Liaisons at TAMU.  A short tutorial on the Workday business process Create Position will be presented and followed by open lab time where participants can begin creating a new position for their organization.

 

Back to Top


2113343 - Workday Clinic: HR Liaison – Edit Position Restrictions (TAMU) - EOD

Course Description:

HUMAN RESOURCES & ORGANIZATIONAL EFFECTIVENESS:  This session is designed for HR Liaisons at TAMU.  A short tutorial on the Workday business process Edit Position Restrictions will be presented and followed by open lab time where participants can begin editing position restrictions for a position in their organization.

 

+ Course Outline

HUMAN RESOURCES & ORGANIZATIONAL EFFECTIVENESS:  This session is designed for HR Liaisons at TAMU.  A short tutorial on the Workday business process Edit Position Restrictions will be presented and followed by open lab time where participants can begin editing position restrictions for a position in their organization.

 

Back to Top


2113344 - Workday Clinic: Employee Information Overview (TAMU) - EOD

Course Description:

HUMAN RESOURCES & ORGANIZATIONAL EFFECTIVENESS: This session is designed for all employees at TAMU.  A short tutorial on navigating through the first login checklist will be presented and followed by open lab time where participants can review their own information.

+ Course Outline

HUMAN RESOURCES & ORGANIZATIONAL EFFECTIVENESS: This session is designed for all employees at TAMU.  A short tutorial on navigating through the first login checklist will be presented and followed by open lab time where participants can review their own information.

Back to Top


2113407 - Workday Demo: Performance Management - Employees - EOD

Course Description:

HUMAN RESOURCES & ORGANIZATIONAL EFFECTIVENESS: This session is designed for all employees at TAMU.  A tutorial on navigating through the performance management process will be presented.  Sessions held in the GSC computer lab will be followed by open lab time where participants can work on their performance management tasks, while sessions held via WebEx will be followed by time for participants to ask questions.

Prerequisites: None

+ Course Outline

HUMAN RESOURCES & ORGANIZATIONAL EFFECTIVENESS: This session is designed for all employees at TAMU.  A tutorial on navigating through the performance management process will be presented.  Sessions held in the GSC computer lab will be followed by open lab time where participants can work on their performance management tasks, while sessions held via WebEx will be followed by time for participants to ask questions.

Prerequisites: None

Back to Top


2113408 - Workday Demo: Performance Management - Managers- EOD

Course Description:

HUMAN RESOURCES & ORGANIZATIONAL EFFECTIVENESS: This session is designed for all managers at TAMU.  A tutorial on navigating through the performance management process as a manager will be presented.  Sessions held in the GSC computer lab will be followed by open lab time where participants can work on their performance management tasks, while sessions held via WebEx will be followed by time for participants to ask questions.

Prerequisites: None

+ Course Outline

HUMAN RESOURCES & ORGANIZATIONAL EFFECTIVENESS: This session is designed for all managers at TAMU.  A tutorial on navigating through the performance management process as a manager will be presented.  Sessions held in the GSC computer lab will be followed by open lab time where participants can work on their performance management tasks, while sessions held via WebEx will be followed by time for participants to ask questions.

Prerequisites: None

Back to Top