Mid-State Technical College Case Study

We are a small, rural technical (community) college consisting of three campuses and a community learning center. At each location there is an Academic Success Center (ASC). The ASC provides services for students learning the English language, seeking a GED/HSED, working on pre-college skills prior to being accepted into a program of study, and who are enrolled in the college but need remedial help with classwork.

Most of the ASC’s work is funded by state and federal grants. It is critical, for reporting purposes, to gather data on student attendance and progress. This is where AccuSQL comes into the picture.

The ASC uses a AccuSQL Version 12 Single Center, Multiple Location License.  The ASC is identified as the single center and each campus is one of the multiple locations. Because our reporting requirements are complicated and varied, we do not want the students to pick a class to work on or to pick a tutor/instructor.  Our AccuSQL is set up so staff controls which class and grant each student is enrolled. As the student progresses through classes or changes granting category, staff members make these changes in AccuSQL. Students simply log-in with their student ID number and their attendance is tracked.

The built-in reports are used to gather data on traffic patterns, and frequency and duration of student visits. To maximize our resources and best serve students, this data is analyzed and interpreted to determine location hours of operation and staffing needs.

In analyzing the frequency data, it was recognized that an overly large percentage of students visit the ASC only once.  To determine why, we developed a customer service survey.  The survey is currently being administered electronically to all students via the survey feature in AccuSQL. A follow-up satisfaction survey was also created and is being administered via AccuSQL  on each student’s tenth visit.

Since the AccuSQL data can be exported, customized reports can be generated.  A staff member was interested in knowing the enrollment percentage in each service category, at each location. Through manipulation of exported AccuSQL data, she was able to generate the following report:

This information has assisted with targeting recruitment efforts at each location.

We are finishing our first year with AccuSQL and feel we have just scratched the surface of its capability. As data and reporting requirements become more demanding, we believe that AccuSQL  will be able to meet those needs. A staff member commented, “Eventually, as we get more into it, AccuSQL will vacuum the floor for us too.”

Dr. Jo-Ellen Fairbanks- Schutz Ph.D
Mid-State Technical College
Associate Dean - General Education
Wisconsin Rapids, WI 54494

- Back to AccuSQL Customer Stories -