Educational function (Academy) of your organization provides you with training services, which include:
- 🎓 Foundation program for the fresh graduates
- 🎓 Continuous education support for employees
- 🎓 Certification program for the employees
- 🎓 Books and procurement - Library function is not included though
- 🎓 Field trips and industrial visits
- 🎓 E-learning and publications.
- 🎓 Workshops, roadshows, awareness campaigns
This, a 7-fold education function in your organization, is a team catering to 10K+ people. It is evident that this function generates a lot of data quarter on quarter. Though the data has shape it is not currently collected and maintained in a central location. Data is collected from various representatives over email and other vehicles and then reported in presentations.
This has though put the data in one place, when it comes to comparison / observing trends / getting insights from far historical data it is not viable. Analysis of data is then becoming increasingly tough and business decisions are driven by the available budget.
We would want to base our decisions on historical data to:
- 💡 Better predict our budgets
- 💡 Discover insights in trends to improve the performance
Can you help us with a web application that helps us gather data in a central cloud location from where it can be further analyzed and insighted.
We are looking at a Web application hosted on cloud that could gather data from the various academy stake-holders and store it away onto a database with recommended data-shape. (Attributes and values in common agreed format)
** What we are NOT looking for now**
- 🏀 Any analysis of the data or data massaging
- 🏀 No report generation as well.
Academy currently using quarterly emails and info-path to gather such data from various stakeholders, We agree it is outdated and involves manual work / maintenance. Academy is keen on getting rid of such a process and would like to replace that with a web application.
Here we show some sample data that needs to be collected
The anchor of such foundation program batches should be able to add in a tabular format any new batches that he /she has handled in a given financial year
| Batch name | Start date | End Date | Intake | Placement DU |
|---|---|---|---|---|
| ENGGElec_WinterFY17 | 13-OCT-2016 | 01-DEC-2016 | 23 | Engineering Network Embedded |
| ENGGelec_AutmnFY17 | 01-JAN-2017 | 03-MAR-2017 | 54 | Engineering Software Products |
| ENGGMech_AutmnFY17 | 02-JAN-2017 | 05-MAR-2017 | 100 | Engineering Core |
Each batch then would have details which too has to be entered by the anchor to complete the data population for foundation. Ideally we want the anchor to fill up the above table , and then click on to fill in the below details
- 🏀 A stakeholder who has logged in sees all the batches populated by other stake holders. This is to avoid duplication incase of joint ownership
- 🏀 But the owner only can edit the batch details that he /she has entered. Others batches would be un-editable.
| ENGGElec_WinterFY17 | |
|---|---|
| High performers | 2 |
| Average performers | 10 |
| Poor performers | 11 |
| Other batch initiatives | Industrial visit to BHEL , guest lectures from IIT professor, makers Workshop |
Lectures for continuous education should be able to enter the details of the lectures conducted in the quarter / month.
- 🏀 Topic names are to be standardised. The user cannot enter free text in that field. As he starts typing in we want him to have flyout suggestions from which he / she can select standar names.
| Topic | Start date | End Date | Effort/day | Attendees | Assessment (yes/no) | Avg course feedback (/5.0) | Mode |
|---|---|---|---|---|---|---|---|
| AngularJS | 01-DEC-2016 | 04-DEC-2016 | 2.0 | 112 | Yes | 4.2 | Virtual classroom |
| MongoDB | 01-DEC-2016 | 04-DEC-2016 | 1.0 | 34 | No | 4.8 | Virtual classroom |
| CAD using CATIAv5 | 12-DEC-2016 | 16-DEC-2016 | 2.0 | 200 | Yes | 4.1 | Classroom |
Anchors need to repor new certifications rolled out, and the target DU for the same.
- 🏀 Title of the certification is free text
- 🏀 DU for the certification is from a select list
- 🏀 Appropriate provision for pick up the date
| Certification | DU | Rolled out on |
|---|---|---|
| IoT practicioners course for S/w engineers | ENGNE | 10-DEC-2016 |
| IoT practicioners course for H/w engineers | ENGNE | 02-DEC-2016 |
Academy needs insight in the books order and their orider placement status.
- 🏀 title of the book is free text
- 🏀 ISBN is optional
- 🏀 Order status is select list
- 🏀 Price is numerical only allowed float value
| Title | ISBN | Order status | Price($) |
|---|---|---|---|
| Two scoops of DJANGO | 12334-453545-556B | Placed | 25.00 |
| Flex in action | 12334-453545-556B | Complete | 10.00 |
Keeping a track of e-learnings is necesary for each quarter
| Title | Platform | Release date | Anchor |
|---|---|---|---|
| Design automation | ILP | 20-JAN-2017 | XXX |
| CATIA automation | Digital tutor | 20-JAN-2017 | XXX |
| Venue | Workshop | coverage |
|---|---|---|
| Pune | IoT workshops | 120 |
| Mysore | Engineering core showcase | 300 |
Anchor uses his organization email and empnumber as the authentication creds. The application maintains such credentials at the backend and verifies against the same. Once authenticated the user would be stored in local browser cache to be used for the entire session.