Overview

 This hybrid training introduces participants to key Excel features that can be used to analyze WIOA-related data found in SMARTT and Cognos.

    Audience

    This professional development activity/course is designed for:

  • Intermediate and advanced users of SMARTT who have completed both the <i>SMARTT New User</I> course and the <i>Intro to Cognos </i>course
Description

Have you ever wished that all the information in SMARTT and Cognos was in a more usable report or in a format where you could extract just the data you wanted, in the way you needed it? Excel is a great tool for accomplishing these tasks, but many users lack the knowledge and skills to do them easily and effectively. This training will show you some Excel features that will greatly facilitate this process.

This hybrid training consists of two parts:

  • Part 1 is an online asynchronous course done at your own pace. It covers basic skills needed to use Microsoft Excel for manipulating data exported from SMARTT. Inserting columns, sorting, using formulas, and creating tables will all be covered.

  • Part 2 is a live webinar or a face-to-face training that will focus on specific types of SMARTT and Cognos data, including NRS cohorts, assessment data, and education functioning levels (EFLs).

    Learning Objectives

    Upon completion of this professional development activity/course, you will be able to:

  • Locate and export WIOA-relevant data from SMARTT and Cognos into Excel
    Use formulas, functions, and tables to extrapolate the data you need
    Use Excel tools such as fills, sorting, filtering, conditional formatting, text-to-columns, and more
    Chart and print your worksheets
Presenter(s) / Facilitator(s)
Prerequisites

 SMARTT New User

Date
04/14/2017 - 1:00 pm
End Date
Location

Picknelly Adult & Family Education Center, Holyoke-GTC Room 104/105
206 Maple St.
Holyoke, MA 01040
United States

PDP Eligible
No