Slott-Student Learning Outcomes Tracing Tool

Αρετή (Arete) Journal of Excellence in Global Leadership | Vol. 1 No. 1 | 2022

Development of SLOTT and Analysis Using SLOTT To address the possible cause of a low number of mapped/aligned CSLOs to the cultural ISLO for Kishwaukee College, a mapping trace of all course outcomes will need to be evaluated, through the design and use of a modifiable tracing tool in an Excel™ Pivot Table/Chart and Dashboard. A Dashboard is used to display large amounts of data visually that can be filtered using slicers. This tracing tool will pull the CSLOs and mapping details from the syllabi for all campus courses. The data was gathered by William Michels (Assessment Teaching Chair) from 588 course syllabi individually. The data was then used to develop the Excel™ table, converted into a Pivot table/chart, and the subsequent dashboard. The tracing tool will have the ability to trace the outcomes at all four levels, within the college: the institutional, program, department l, and course. Using filters (slicers), the mapped/aligned tracing data will be easily generated for this cultural outcome, as well as many others. The slicer tool allows for the filtering of data in the Excel™ visual tables. Thus, the slicer will allow for filtering of the data that most pertains to the query. It will filter the courses, departments, repeated course sections offered, and the number of enrolled students for the cultural competency outcome. The slicers will also allow for the same questions to be answered for the other three ISLOs for comparison and gap analysis. SLOTT will show the number of courses and outcomes mapped up through the four levels of the Kishwaukee College Assessment program leveraging visualization to help answer the Assessment Committee’s questions. Not only will SLOTT trace the cultural outcomes, but all outcomes that are mapped by Kishwaukee College. SLOTT is also easily modifiable for course additions and deletions. The development of the tracing tool is beneficial for this assessment problem but also is flexible enough to map other gaps and issues. The four-step process for the development of SLOTT is seen in

Figure 3. Figure 3 4 Steps in SLOTT Development

Source: Authors’ Illustration

9