Docstoc

Training Participant Feedback Form - Download as Excel

Document Sample
Training Participant Feedback Form - Download as Excel Powered By Docstoc
					Master Data Sheet - Training Administration

Sl. No. Template No           TYPE              NAME OF MASTER
5. Basic Data for Training Administration
    5.1 HRM-5.1          Master Data    Course Category
    5.2 HRM-5.1          Master Data    Course Material Category
    5.3 HRM-5.1          Basic Data     Training Equipment
    5.4 HRM-5.1          Basic Data     Training Room Type
    5.5 HRM-5.1          Master Data    Training Room
    5.6 HRM-5.1          Basic Data     Training Room Equipment
    5.7 HRM-5.1          Basic Data     Evaluation Rating Scale
    5.8 HRM-5.1          Basic Data     Evaluation Category
    5.9 HRM-5.1          Master Data    Evaluation Question
   5.10 HRM-5.1          Master Data    Evaluation Question Template
   5.11 HRM-5.1          Basic Data     Training Cost
   5.12 HRM-5.1          Master Data    Course
   5.13 HRM-5.1          Master Data    Training Institution
   5.14 HRM-5.1          Master Data    Trainer
RESPONSIBILITY REMARKS

Process   Owner   Released
Process   Owner   Released
Process   Owner   Released
Process   Owner   Released
Process   Owner   Released
Process   Owner   Released
Process   Owner   Released
Process   Owner   Released
Process   Owner   Released
Process   Owner   Released
Process   Owner   Released
Process   Owner   Released
Process   Owner   Released
Process   Owner   Released
MASTER DATA TEMPLATE - HRMS

Menu Path:         Training Administration/General training Administration
Master Name:       Course Category/Course Material Category/Training Equipment /Training Room
                   Question Template
Description:       To Group Courses and Course materials under various Categories. Defining Training Equip
                   Equipments training room has, Evaluation Rating of Training and Question Template as p


Data Source :

Master 1           Course Category
Field Name         Field Length                                    Description




Course Category ID Varchar2(10)                                    Course Category ID

Course Category    Varchar2(100)                                   Course Category
Name                                                               Name
Course Category    Varchar2(2000)                                  Course Category
Description                                                        Description

Example :
                                    Course Category
Course Category                                                    Course Category
ID                 Course Category Name                            Description
ACCT               ACCOUNTS
TECH               TECHNICAL




Master 2           Course Material Category
Field Name         Field Length                                    Description




Course Material                                                    Course Material
                   Varchar2(200)
Category                                                           Category
Course Material
                   Varchar2(2000)                                  Course Material desc
desc

Example :
                   Course Material Category
Course Material
                   Course Material desc
Category
CMSD               Course Material Handbook
CMLD               Course Material Handbook
Master 3              Training Equipment
Field Name            Field Length                        Description




Training Equipment    Varchar2(10)                        Training Equipment
ID                                                        ID
Training Equipment    Varchar2(100)                       Training Equipment
Name                                                      Name
Training Equipment    Varchar2(2000)                      Training Equipment
Description                                               Description
Reservable Quantity   NUMBER                              Reservable Quantity


Example :
                                                  Training Equipment
Training              Training Equipment Name              Training
Equipment ID                                               Equipment
                                                           Description
LCD                   LCD PROJECTOR                        LCD PROJECTOR
OHP                   OVERHEAD PROJECTOR                   OVERHEAD
                                                           PROJECTOR
CMP                   COMPUTER                             COMPUTER



Master 4              Training Room Type
Field Name            Field Length                        Description




Training Room Type Varchar2(100)                          Training Room Type

Training Room         Varchar2(2000)                      Training Room
Description                                               Description

Example :
                        Training Room Type
Training Room         Training Room Description
Type
CONFHALL              CONFERENCE HALL
EXAMROOM              EXAMINATION ROOM
LECTHALL              LECTURE HALL
PRACROOM              PRACTICAL ROOM


Master 5              Training Room
Field Name           Field Length              Description




Training Room      Varchar2(100)               Training Room Name
Name
Training Room Type Varchar2(100)               Training Room Type

Training Room        Varchar2(20)              Training Room
Location                                       Location
Room Capacity        NUMBER                    Room Capacity
Address              Varchar2(250)             Address
Country              Varchar2(20)              Country
Remark               Varchar2(2000)            Remark

Example :
                                                               Training Room
Training Room        Training Room Type        Training Room
Name                                           Location
A                    EXAMROOM                  Internal

B                    PRACROOM                  Internal




Master 6             Training Room Equipment
Field Name           Field Length              Description




Training Room        Varchar2(200)             Training Room Name
Name
Room Type            Varchar2(100)             Room Type
Room Location        Varchar2(200)             Room Location
Training Equipment   Varchar2(10)              Training Equipment
ID                                             ID
Training Equipment   Varchar2(100)             Training Equipment
Name                                           Name
Quantity             Number                    Reserveable Quantity


Example :
                                                 Training Room Equipment
Training Room        Room Type                 Room Location
Name

A                    EXAMROOM                  CTI,ERAGGADA
B                     PRACROOM                            CTI,ERAGGADA




Master 7              Evaluation Rating Scale
Field Name            Field Length                        Description




Training Evaluation   Varchar2(200)                       Training Evaluation
Criteria                                                  Criteria
Evaluation Rating     Varchar2(40)                        Evaluation Rating
Description           Varchar2(2000)
Score                 Number                              Score

Example :
                                                Evaluation Rating Scale
Training
Evaluation            Evaluation Rating                   Description
Criteria
FEEDBACK              E                                   EXCELLENT
FEEDBACK              VG                                  VERY GOOD
FEEDBACK              G                                   GOOD
FEEDBACK              S                                   SATISFACTORY


Master 8              Evaluation Category
Field Name            Field Length                        Description




Evaluation Category Varchar2(100)                         Evaluation Category

Evaluation Group      Varchar2(20)                        Evaluation Group

Example :
                      Evaluation Category
Evaluation Category Evaluation Group

Trainer               Training Event
Participant           Participant


Master 9              Evaluation Question
Field Name            Field Length                                   Description




Training Evaluation   Varchar2(100)                                  Training Evaluation
Category                                                             Category
Evaluation Group      Varchar2(20)                                   Evaluation Group
Training Evaluation   Varchar2(200)                                  Training Evaluation
Criteria                                                             Criteria
Evaluation Question   Varchar2(250)                                  Evaluation Question
Text                                                                 Text

Example :
                                                          Evaluation Question
Training              Evaluation Group                             Training Evaluation
Evaluation                                                         Criteria
Category
Participant           Participant                                    FEEDBACK
Trainer               Training Event                                 FEEDBACK


Master 10             Evaluation Question Template
Field Name            Field Length                                   Description




Evaluation Template   Varchar2(200)                                  Evaluation Template
Name                                                                 Name
Evaluation Question   Varchar2(250)                                  Evaluation Question
Text                                                                 Text
Training Evaluation   Varchar2(100)                                  Training Evaluation
Category                                                             Category
Evaluation Group      Varchar2(20)                                   Evaluation Group
Training Evaluation   Varchar2(200)                                  Training Evaluation
Criteria                                                             Criteria

Example :
                                                            Evaluation Question Template
Evaluation            Evaluation Question Text                     Training Evaluation
Template Name                                                      Category

FEED BACK FORM        How was your learning experience?              Participant
FEED BACK FORM        How were the programme objectives explained?   Trainer


Master 11             Training Cost
Field Name           Field Length                Description




Cost Category Name Varchar2(100)                 Cost Category Name

Cost Category        Varchar2(2000)              Cost Category
Description                                      Description
Course Cost Name     Varchar2(100)               Course Cost Name
Course Cost          Varchar2(2000)              Course Cost
Description                                      Description
Course Cost Unit     Varchar2(20)                Course Cost Unit

Example :
                                                  Training Cost
Cost Category        Cost Category Description   Course Cost Name
Name




Master 12            Course
Field Name           Field Length                Description




Course Id            Varchar2(10)                Course Id
Course Title         Varchar2(100)               Course Title
Course Category Id   Varchar2(10)                Course Category Id
Course Category                                  Course Category
Name                                             Name
Valid From                                       Valid From
Valid To                                         Valid To
Course Description   Varchar2(2000)              Course Description
Course Objective     Varchar2(2000)              Course Objective
Target Audience      Varchar2(2000)              Target Audience
Course Duration      NUMBER                      Course Duration
Course Duration      Varchar2(20)                Course Duration Unit
Unit
Course Fee           NUMBER                      Course Fee
Currency             Varchar2(3)                 Currency
Course Fee Unit      Varchar2(20)                Course Fee Unit
Max Participant      NUMBER                      Max Participant
Minimal Score to     NUMBER                      Minimal Score to
Pass                                             Pass
Course Owner         Varchar2(11)                Course Owner
Course Owner Name                                Course Owner Name
Evaluation Template NUMBER                      Evaluation Template
Name                                            Name

Example :
                                                                          Course
Course Id           Course Title                Course Category Id

        1                                  2             3
XX/XX/XX            ERP                         IT



                                                                          Course
Course Objective    Target Audience             Course Duration


           8                               9            10
afdfddaf            E1-E4                                             5



                                                   Course
Max Participant     Minimal Score to Pass       Course Owner


           15                              16           17
                  20 X




Master 13           Training Institution
Field Name          Field Length                Description




Institute Name      Varchar2(100)               Institute Name
Contact Person      Varchar2(100)               Contact Person
Designation         Varchar2(100)               Contact Person
                                                Designation
Address ID          Varchar2(50)                Address ID
Address 1           Varchar2(35)                Address 1
Address 2           Varchar2(35)                Address 2
Zip Code            Varchar2(35)                Zip Code
City                Varchar2(35)                City
State               Varchar2(35)                State

Example :
                                                                             Training In
Institute Name      Contact Person              Designation
                                               MANAGING
HMDA                   MR.KALU
                                               DIRECTOR


Master 14              Trainer
Field Name             Field Length     Description




Person ID              Varchar2(20)     Person ID
First Name             Varchar2(100)    First Name
Last Name              Varchar2(100)    Last Name
Internal               Varchar2(1)      Internal
Date of Birth          NUMBER           Date of Birth
Gender                                  Gender
Training Institution                    Training Institution
Name                                    Name
Remark                 Varchar2(2000)   Remark

Example :
                                                               Trainer
Person ID              First Name       Last Name


101595N                Sandeep          Puri
E100001                Naveen           Rout
quipment /Training Room Type /Training Room/Training Room Equipment/Evaluation Category/Evaluation

ories. Defining Training Equipment (Inventory) in an organization, Various Types of training rooms their capacity and
 and Question Template as per Organization standards.




            Mandatory Field                                     Type (C/N)       Codification
                                                                               required or not
                                                                                   (Y/N)


            Y                                                   C/N            Y

            Y                                                   C/N            Y

            N                                                   C/N            Y




            Mandatory Field                                     Type (C/N)       Codification
                                                                               required or not
                                                                                   (Y/N)



            Y                                                   C              Y

            N                                                   C              Y
    Mandatory Field            Type (C/N)     Codification
                                            required or not
                                                (Y/N)


    Y                          C/N          Y

    Y                          C            N

    N                          C            N

    Y                          C            N



t
    Reservable Quantity


                          20
                          10

                          40




    Mandatory Field            Type (C/N)     Codification
                                            required or not
                                                (Y/N)


    Y                          C/N          Y

    N                          C            N
        Mandatory Field         Type (C/N)     Codification
                                             required or not
                                                 (Y/N)


        Y                       C/N          N

        N                       C            N

        Y                       C            N

        N                       N            N
        N                       C/N          N
        N                       C            N
        N                       C            N


    Training Room
        Room Capacity           Address      Country

        40                      CTI,ERAGADD INDIA
                                A
        41                      CTI,ERAGADD INDIA
                                A




        Mandatory Field         Type (C/N)     Codification
                                             required or not
                                                 (Y/N)


        Y                       C            N

        Y                       C            N
        Y                       C            N
        Y                       C            Y

        N                       C            N

        N                       N            N



g Room Equipment
                                Training      Quantity
                                Equipment
        Training Equipment ID   Name
        LCD                     LCD Projector              5
      LCD                    LCD Projector                 5




      Mandatory Field        Type (C/N)        Codification
                                             required or not
                                                 (Y/N)


      Y                      C               N

      Y                      C               N
      N
      Y                      N               N


ale

      Score

                        10
                         8
                         5
                         3



      Mandatory Field        Type (C/N)        Codification
                                             required or not
                                                 (Y/N)


      Y                      C               N

      N                      C               N
         Mandatory Field                                Type (C/N)     Codification
                                                                     required or not
                                                                         (Y/N)


         Y                                              C            N

         N                                              C            N
         N                                              C/N          N

         Y                                              C            Y



n
         Evaluation Question Text


         How was your learning experience?
         How were the programme objectives explained?



         Mandatory Field                                Type (C/N)     Codification
                                                                     required or not
                                                                         (Y/N)


         Y                                              C/N          Y

         Y                                              C            N

         N                                              C            N

         N                                              C            N
         N                                              C/N          N



on Template
         Evaluation Group                               Training
                                                        Evaluation
                                                        Criteria
         Participant                                    Feedback
         Training Event                                 Feedback
       Mandatory Field           Type (C/N)      Codification
                                               required or not
                                                   (Y/N)


       Y                         C             Y

       Y                         C             Y

       Y                         C             Y
       N                         C             Y

       Y                         C             N


Cost
       Course Cost Description   Course Cost
                                 Unit




       Mandatory Field           Type (C/N)      Codification
                                               required or not
                                                   (Y/N)


       Y                         C/N           Y
       Y                         C             N
       Y                         C/N           Y
       Y                         C             N

       Y                         N             N
       Y                         N             N
       Y                         C             N
       Y                         C             N
       Y                         C/N           N
       Y                         N             N
       Y                         C             N

       Y                         N             N
       Y                         C             N
       Y                         C             N
       Y                         N             N
       Y                         N             N

       Y                         C/N           N
       Y                         C             N
    Y                            C/N          N



    Course
     Course Category Name        Valid From   Valid To

                       4               5             6
    INFORMATION TECHNOLOGY



    Course
     Course Duration Unit        Course Fee   Currency


                            11         12            13
    Day/Hr./Week                         25000 INR



e
    Course Owner Name            Evaluation
                                 Template
                                 Name
                            18        19
                                 Annex-1




    Mandatory Field              Type (C/N)      Codification
                                               required or not
                                                   (Y/N)


    Y                            C            Y
    N                            C            N
    N                            C            Y

    Y                            C/N          N
    N                            C/N          N
    N                            C/N          N
    N                            N            N
    N                            C            N
    N                            C            N


       Training Institution
    Address ID                   Address 1    Address 2
                  1 No. 35,      KHAIRATABAD




Mandatory Field     Type (C/N)     Codification
                                 required or not
                                     (Y/N)


Y                  C/N           Y
N                  C             N
N                  C             N
Y                  TRUE/FALSE    N
N                  N             N
Y                  C             N
Y                  C/N           N

N                                N


    Trainer
Internal            Date of Birth Gender


YES                     1/1/1970 Male
NO                     2/12/1945 Male
                           HRM-5.1



valuation Category/Evaluation

aining rooms their capacity and




             Guidelines    Existing
                for        Field /
            codification   New Field
                           (E/N)




             Guidelines    Existing
                for        Field /
            codification   New Field
                           (E/N)
 Guidelines    Existing
    for        Field /
codification   New Field
               (E/N)




 Guidelines    Existing
    for        Field /
codification   New Field
               (E/N)
 Guidelines    Existing
    for        Field /
codification   New Field
               (E/N)




Remark




 Guidelines    Existing
    for        Field /
codification   New Field
               (E/N)
 Guidelines    Existing
    for        Field /
codification   New Field
               (E/N)




 Guidelines    Existing
    for        Field /
codification   New Field
               (E/N)
 Guidelines    Existing
    for        Field /
codification   New Field
               (E/N)




 Guidelines    Existing
    for        Field /
codification   New Field
               (E/N)
 Guidelines    Existing
    for        Field /
codification   New Field
               (E/N)




 Guidelines    Existing
    for        Field /
codification   New Field
               (E/N)
Course
Description
        7
eafdfaf




Course Fee
Unit

     14
PERSON




  Guidelines    Existing
     for        Field /
 codification   New Field
                (E/N)




Zip Code        City        State
                HYDERABA ANDHRAR
       500001
                D        PRADESH



  Guidelines    Existing
     for        Field /
 codification   New Field
                (E/N)




Training        Remark
Institution
Name
NHPC
IIM-A

				
DOCUMENT INFO
Description: Training Participant Feedback Form document sample