This blended training introduces participants to key Excel features that can be used to analyze WIOA-related data found in SMARTT and Cognos.
This professional development activity/course is designed for:
- Intermediate and advanced users of SMARTT who have completed both the SMARTT New User course and the Intro to Cognos course
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 (January 15–19, 2018): 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 (January 19, 2018 10 a.m.–2 p.m.) in Holyoke: 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).
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