EOD November Classes, Seminars, Workshops

Below is a listing of the November classes, seminars, and workshops.

UCP PandA Training Session
November 4, 2013
1:00 pm – 3:00 pm; FL2-1001

Participants will learn UCAR business processes and employee legal responsibilities related to award management, accounting, and budgeting and proposal processes along with use of the Proposal and Award (PandA) system to create and route proposals. Instructors: Kelly Smith, UCP Budget Office; Gina Taberski, UCAR Contracts; Anita Monk-Ryan, UCAR Finance.

EXCEL 2010 CHARTS & PIVOT TABLES: Tips/Techniques/Shortcuts
November 5, 2013
8:30 am – 12:00 pm; CG2-CTTC
Facilitator:  Ameriteach Trainer

Learn to better analyze and visually display your data using Excel Pivot Tables and Charts. This course covers extensive techniques, tips and shortcuts for using these powerful, but underutilized, Excel tools. Outline - PIVOT TABLES: Creating, Sorting and Filtering data, Formatting Styles, Numbers, and Layouts, Grouping Data, Comparison and Total Options, Calculated Fields and Items, Combining Multiple Data Sources, Conditional Formatting PivotCharts. CHARTS: Creating, Modifying Design, Layout and Format, Creating Charts from Non-Consecutive Data, Drop-lines, Axis Formatting, Replacing Chart Series with Pictures or Shapes, Analysis Tools, Trending Tools, Using Secondary Axis, Highlighting Relationships Differences with Charts, and Combining Two Charts into One.

EXCEL 2010 FORMULAS & FUNCTIONS
November 5, 2013
1:00 pm – 4:30 pm; CG2-CTTC
Facilitator: Ameriteach Trainer

FORMULAS and FUNCTIONS are the most powerful and useful features of Excel. There are literally hundreds of different kinds of formulas and functions to use in Excel – this class will focus on some of the more cross-functional ones that can be used across all types of business to improve spreadsheet performance and business productivity. Users of both Office 2003 and Office 2007 will benefit from this class. What are some of the best applications for Excel formulas/functions? Date & time, mathematical, text, database, financial, informational, statistical, logic, lookup, reference functions, and nesting IF statements.

EXPORT CONTROLS TRAINING – GENERAL SESSION
November 5, 2013
9:00 am – 11:30 am; FL2 - Main Auditorium
Facilitator: Don Fischer

This general session is open to all UCAR/NCAR/UCP staff. ITAR (International Traffic in Arms Regulations), EAR (Export Administration Regulations), OFAC (Office of Foreign Assets Control), and general export controls laws and regulations will be reviewed in the context of a scientific research institution. Completion of this session will be recorded and fulfills the requirement for initial and annual refresher export compliance training. In this session you will learn the answers to: 1. Why is awareness so critical to federally-funded research institutions? 2. What are export controls? How do they work? How are they enforced? 3. How do controls impact you as a PI (Principal Investigator), researcher or research administrator? 4. How do you remain compliant and subject to as few controls as possible? 5. What is the purpose and scope of OFAC Regulations?

EXPORT CONTROLS FOR EOs, ECCs, PIs, DIRECTORS
November 5, 2013
1:00 pm – 4:30 pm; FL2 – Main Auditorium
Facilitator: Don Fischer

This focused session is designed specifically for UCAR's EOs (Empowered Officials), ECCs (Export Compliance Coordinators), PIs (Principal Investigators) and Directors, and those tasked with direct responsibilities for providing guidance to others on UCAR's export compliance policies, processes and procedures. ITAR (International Traffic in Arms Regulations), EAR (Export Administration Regulations), OFAC (Office of Foreign Assets Control), and general export controls laws and regulations will be reviewed in the context of a scientific research institution with in depth focus on practical applications of export controls as they affect UCAR/NCAR/UCP. In addition, you will learn the answers to: 1. Why is awareness so critical to federally-funded research institutions? 2. What are export controls? How do they work? How are they enforced? 3. How do controls impact you as a PI, researcher or research administrator? 4. How do you remain compliant and subject to as few controls as possible?

EXPORT CONTROLS LUNCH/LEARN SEMINAR for IT and Sys Adms
November 5, 2013
11:45 am – 12:45 pm; FL2 – Main Auditorium
Facilitator: Don Fischer

Brown Bag Session for IT, Sys Adms, and Technical Data Issues. Bring your lunch to this interactive discussion for IT staff, Sys Adms, and anyone working with ITAR (International Traffic in Arms Regulations) or EAR (Export Administration Regulations) controlled technical data or software. Mr. Fischer will answer specific questions and provide guidance for handling export controlled data and working with networking and access issues. This is a technically-focused Q&A session and does NOT meet the mandatory export controls annual training requirement.

POWERPOINT 2010 LEVEL 1 – postponed will be rescheduled
November 6, 2013
8:30 am – 12:00 pm; CG2-CTTC
Facilitator: Ameriteach Trainer

Learn the basic functions of Powerpoint 2010. Overview and navigation; Creating presentations; Saving, rearranging and deleting slides; Using slides from other presentations; Formatting and modifying; Drawing objects and shapes; Modifying objects; Text in objects; Graphics, WordArt, Pictures, Clip Art; Tables Charts and Diagrams; Templates and themes; Slide masters; Transitions and timings; Speaker notes; Slide shows; Proofing and delivery.

POWERPOINT 2010 LEVEL 1 – postponed will be rescheduled
November 6, 2013
1:00 pm – 4:30 pm; CG2-CTTC
Facilitator: Ameriteach Trainer

Learn the basic functions of Powerpoint 2010. Overview and navigation; Creating presentations; Saving, rearranging and deleting slides; Using slides from other presentations; Formatting and modifying; Drawing objects and shapes; Modifying objects; Text in objects; Graphics, WordArt, Pictures, Clip Art; Tables Charts and Diagrams; Templates and themes; Slide masters; Transitions and timings; Speaker notes; Slide shows; Proofing and delivery.

NCAR PandA Training Session
November 7, 2013
9:00 am – 12:30 pm; FL2-1022

Participants will learn UCAR business processes and employee legal responsibilities related to award management, accounting, and budgeting and proposal processes along with use of the Proposal and Award (PandA) system to create and route proposals. Instructors: Kelly Smith, UCP Budget Office; Gina Taberski, UCAR Contracts; Anita Monk-Ryan, UCAR Finance.

NCAR PandA Training Session
November 11, 2013
9:00 am – 12:30 pm; FL2-1022

Participants will learn UCAR business processes and employee legal responsibilities related to award management, accounting, and budgeting and proposal processes along with use of the Proposal and Award (PandA) system to create and route proposals. Instructors: Kelly Smith, UCP Budget Office; Gina Taberski, UCAR Contracts; Anita Monk-Ryan, UCAR Finance.

HOT OPERATIONS
November 14, 2013
1:30 pm – 2:30 pm; Fl2 - 1002
Facilitator: Milenda Powers

Learn to keep from burning down the shop and avoid having "arsonist" on your permanent record. Hot operations refer to work that involves open flames, torches and welding. The Safety policy and permit requirements for this work will be reviewed during this brief class.

LOCKOUT/TAGOUT
November 14, 2013
2:30 pm – 3:30 pm; FL2 - 1002
Facilitator: Milenda Powers

Avoid electrocution of yourself and others by learning how to deactivate energy systems. Recognize dangers and hazards of stored energies. Control hazards by disconnecting and blocking the energy path and perform a lock out/ tag out operation. An audit of lock-out/tag-out skills is conducted yearly.

NCAR PandA Training Session
November 14, 2013
12:30 pm – 4:00 pm; ML Main Seminar Room

Participants will learn UCAR business processes and employee legal responsibilities related to award management, accounting, and budgeting and proposal processes along with use of the Proposal and Award (PandA) system to create and route proposals. Instructors: Kelly Smith, UCP Budget Office; Gina Taberski, UCAR Contracts; Anita Monk-Ryan, UCAR Finance.

CONFINED SPACE ENTRY FOR SUPERVISORS & AIR MONITORING SPECIALIST
November 14, 2013
9:30 am  – 12:30 pm; FL2 - 1002
Facilitator: Milenda Powers

Some work places are designed for equipment, not people! These hazardous locations are called Confined Spaces. Specialized work procedures and precautions are required when we humans must work in these areas. This class prepares supervisors to correctly identify hazards of the confined space and what control measures are required to work in the space. The class also prepares individuals to properly monitor the air in a confined space using an air monitor.

CONFINED SPACE ENTRY
November 14, 2013
8:30 am – 9:30 am; FL2 - 1002
Facilitator: Milenda Powers

Sometimes people must work in spaces that were designed for equipment, not people. Participants will review safe work methods required for employees who enter confined spaces, understand the hazards, how to control the hazards and how to keep watch over employees working in these spaces.

About you
First name: 
Betty
Last name: 
Singleton
Phone extension: 
2005
Announcement contact
First name: 
Betty
Last name: 
Singleton
Phone extension: 
2005
Announcement duration
Start: 
Monday, November 11, 2013
End: 
Saturday, November 16, 2013