Global Journal of Management and Business Research, A: Administration and Management, Volume 22 Issue 5

17. The marks sheets of PrTET, PsTET and LUT 1 to 4 and Hands-on Tests can be liked to Score card. Same can be done for other marks sheet created based on the need and number of tests conducted by making a copy of marks sheet provided using Excel Spreadsheet. Score card 18. The marks sheets can be linked to a Score card the marks scored by each trainee will automatically filled in Score card and total score will reflected. 19. As criteria is functioned-in, the trainees who score <700/1000 will be highlighted in red. 20. Score card displays the assessment results of each trainee for each test conducted and also a cumulative score. It is an at glance score board for entire training. 21. Criteria can be also fixed for each LU test to high light the weak areas where the Trainer can focus. 22. K&S gained by trainees on particular theme/subtask can be ascertained from the numerical value of Total Score for Question (last column M; cell M6) of marks sheet of each test. Low score for a particular Question/subtask indicates Trainee is unable to understand/learn the K&S. Each Trainee Feedback form 23. Enter the trainee ID in merged Cells 3C:L 24. Individual trainee can enter his/her response (any one numerical value between 10 and 1) asked for each point for assessment listed in Column B & Rows 7 to 31 in respective Rows of Columns C to L. 25. Overall score will be recorded in Colum M and Cell M32 will reflect the trainee’s assessment of entire training course. 26. Each trainee assessment sheet is linked to Feedback analysis sheet. The consolidated responses of each trainee will be recorded in it and general statistics of trainees evaluation will generated. It provides the overall score (mean of all numerical responses of all trainees) for the training course. 27. The summarised digital information of Assessments and Feedback will provide ample opportunity for improving or standardizing the training functions. 28. An unbiased statement on objectives achieved and capability of showing improvement in on on-job performance can be assessed and proved.  A model Marks sheet (Supplemental Material 3). An Integrated Approach for Effective Evaluation of Training Courses 13 Global Journal of Management and Business Research Volume XXII Issue V Version I Year 2022 ( ) A © 2022 Global Journals Supplemental Material 3a A model marks sheet Trainee ID SE1 SE2 ER1 ER2 Type of Questions Question No. Key T C Marks T C Marks T C Marks T C Marks Total Score for Question Mutiple Choice Questions 1 B b 1 a 0 b 1 1 0 3 2 A 0 3 C 0 4 A 0 5 D 0 True/Flase 6 T 0 7 F 0 8 F 0 9 T 0 10 F 0 One word answer 11 C 0 12 C 0 13 W 0 14 C 0 15 W 0 One line answer 16 C 0 17 C 0 18 W 0 19 C 0 20 W 0 Total score of each trainee 1 0 1 1 3 TC: Trainee choice