Extracting course evaluations and sending to teachers on course
Use Case Description
The danish educational system mandates that students perform course evaluation at the end of a course.
These data are stored in a central system called Amukvalitet where they are used for statistics and quality assurance.
The system is “locked” behind a login which automations cannot interact. Therefore the extraction of datasets (spanning several dates) is performed manually and stored in a folder for the RPA process.
The automation solution reads new datasets and works its way through the available dates within it.
For each course ending on date X, scores and comments are extracted and put into a evaluation sheet in Excel.
This evaluation sheet is exported to PDF.
API query to the educational institution registration system finds and extracts emails for teachers on the given courses.
The evaluation sheet is sent to these teachers so they can evaluate on feedback from students.
For each date processed an overview of processed courses is sent to SME - perhaps a course administration department.
Improvement suggestions would be to use Integration Services for the file change trigger.
AS-IS WORKFLOW, TO-BE WORKFLOW
Other information about the use case
Industry categories for this use case: Compliance, Marketing Sales, Universities Academy, Public Sector
Skill level required: Advanced
UiPath Products that were used: UiPath Studio, UiPath Orchestrator
Other applications that were used: -
Other resources: -
What is the top ROI driver for this use case?: Improve customer experience