ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
General Instruction to fill this observation solution template
2
Recommended: We suggest you use a unique resource name to avoid duplication in reports.
3
Don't change any labels of the tab and Don't change any column name's in each sheet
4
Take the help of 'comments' to understand what needs to be filled in a particular column
5
Detailed instructions for Rubric Scoring Formula is available at the end of the instructions sheet.
6
7
Note: Please avoid the special characters like double quotes(") and new-line(\n or an enter key) characters which are not allowed in our system as they may create issues in the reports.
8
Colour Codes to followHeader ColorQuestions Tab
9
Mandatory FieldKeywordsDescription
10
Optional Fieldcriteria_idselect criteria_id from drop-down provided for each questions
11
Conditionally Optional Fieldquestion_sequencewrite the order of the question, how you want to see them on App(e.g. 1,2,3...)
12
question_idUnique ID for each question (Alphanumeric)
13
instance_parent_question_idIf it is a instance type Solution, write the instance_parent_question_id
otherwise leave this column as empty
14
Details Tabparent_question_idWrite the parent_question_id, if it a child question (i.e. dependent question on other)
15
KeywordsDescriptionshow_when_parent_question_value_isUse the appropriate mathematical operator(Equal or > or < etc.) as per your questionnaire need
16
environmentThere are two environments available to upload the observation solution:
1. pre-prod: If you want to test your solution internally within products team before rolling out to production. 2. production : for uploading the solution to diksha production 		parent_question_valueWrite the 'response' of the parent question if this is a child question and particular response of parent question dependent on it. i.e write R1 or R2 or R3....... as per its dependency.
17
observation_idFor updating the existing observation template on the platform, write the unique observation_id sent via email. In case a new observation solution creation, leave this column as empty. (right now update feature is not available on platform, coming soon)page Select the Page no. against each question (P1, P2, P3.....), Based on your Page selection that question will appear on mobile screen. Example: If 3 questions have selected as P1 only, all three question will come on single screen.
18
observation_solution_nameWrite a meaningful name of your observation solutionquestion_numberYou may use 1,2,3.... or a, b, c.... or i, ii, iii.....etc. as numbering your questionnaire
19
observation_solution_descriptionWrite a brief description about the observation solutionquestion_language1Write the Primary language name in which you are creating your solution (e.g. English)
20
Diksha_loginIdWrite your platform login ID (UserID of the observation solution Designer )question_language2If you want to show your questionnaire in other language as well, you may write here(e.g. Kannada)
21
languageLanguage of the observation solutionquestion_tipIf you want add tip to your question, you may write the tip text in this column
22
section_nameName of the section which is going to be created (write some meaningful section label)question_hintTo add hint to the question, write the hint text here.
23
keywordsWrite some appropriate keywords instance_identifierIf it is a instance type Solution, write the instance_identifier here. This will be label as ADD instance identifier text
24
geo_tag_all_questionsGeo-tagging will help in authenticating the coordinates(location) of observation form submissionquestion_response_typeSelect the question-response-type from the drop-down list as per question's need
25
point_based_scoring_systemIf Observation is point-based scoring set to TRUE else leave it blankdate_formatUse the date format (DD-MM-YYYY) user will be able to edit the date once enter (Note: This is recommended date format)
26
entity_typePlease select any 1 of the entiy type of observation from the drop down provideddate_auto_captureUse auto_capture only if you don't want let your user edit the date of observation once entered.
27
program_nameName of the program , if you wish to map this solution to any. Leave it blank if you want to upload solution as a template.response_requiredIf the question is mandatory to anwser, Select TRUE option
28
scope_entity_typeEntity type of the scope. By default it will be state.min_number_valueWrite the minimum number allowed to enter in case of data entry(number) & Slider type question
29
scope_entityEnter the entity names you are targetting. Ideally a state namemax_number_valueWrite the maximum number allowed to enter in case of data entry(number) & Slider type question
30
rolesDefine the roles, who should access the formfile_uploadIf evidences is required to attach for a particular question, Select as TRUE else FALSE
31
allow_audio_recordingIf you want to record the evidences in the form of audio, you any select as TRUE
32
Criteria Tabshow_remarksIf you want to show add remark option after that question so that assessor can add the remark, you may select it as TRUE
33
KeywordsDescriptionresponse(R1)Write your first response here
34
criteria_idUse any unique alphanumeric text as criteria_id response(R2)Write your second response here
35
criteria_namewrite the name of the criteriaresponse(R1)_hintWrite the hint for your response 1(if needed) else leave this column
36
response(R2)_hintWrite the hint for your response 2(if needed) else leave this column
37
framework Tabresponse(R1)_scoreScore to be given if option 1 is selected, leave blank if not required.

Note: fill column response(R1)_score to response(R15)_score only if observation is point-based-scoring else leave it blank
38
KeywordsDescriptionslider_value_with_scorescore for slider question.
The format to fill this column :
based on min_number_value and max_number_value column
min_number_value : score for this slider value , min_number_value + 1 : score for this slider value , ...... , max_number-value : score for this slider value.

Ex : if min_number_value = 1 , max_number_value = 5 .
Format :- 1:0.5,2:1.5,3:2.5,4:3.5,5:4.5

Note : Fill this column only if observation is point-based-scoring else leave it blank
39
Domain IDUse any unique alphanumeric text as domain idquestion_weightageweightage for each question

Note : Fill this column only if observation is point-based-scoring else leave it blank
40
Domain Namewrite the name of the Domainsection_headerWrite the section header title here
41
Criteria IDSelect any criteria id from the dropdownquestion_prefill_from_entity_profileBoolean :- Should the value of the question be pre-filled with some value from the entity meta information
42
L1 descriptionDescription for criteriaquestion_is_editableBoolean :- Can the user edit a pre filled value
43
L2 descriptionDescription for criteriaquestion_entity_meta_namesSelect from the dropdowns :- User can select from a range of fields, the value of which will be pre-filled in the question form in the app

Note : Right now meta data contains only entityType of school.
44
L3 descriptionDescription for criteria
45
46
ECMs or Domains TabImp mapping
47
KeywordsDescriptionKeywordsDescription
48
ECM Id/Domian IDUse any unique alphanumeric text as ECM id/domain idcriteriaIdSelect the criteria Id
49
ECM Name/Domain Namewrite the name of the ECM Name/DomainL1-improvement-projectsImprovement project at Level 1
50
section_idUse any unique alphanumeric text as section id (can be same as ECM Id)L2-improvement-projectsImprovement project at Level 2
51
section_namewrite the name of the section name (ECM Name)L3-improvement-projectsImprovement project at Level 3
52
Is ECM Mandatory?Select True/False from dropdownLn-improvement-projectsImprovement project at Level n
53
54
Criteria_Rubric-Scoring Tab
55
KeywordsDescription
56
criteriaIdSelect criteria id from the dropdown
57
weightageweightage in integer
58
L1 SCOREDefine the range of score for the each criteria at respective levels.For a said criteria, find the sum of minimum and maximum score. Divide it in range to create the required no. of levels.
For eg. if the criteria has 3 questions,
Q1- R1:25,R2:50,R3:75,R4:100(radio type parent question)
Q2- R1:25,R2:50,R3:75,R4:100(multi-select type parent question)
Q3- R1:25,R2:50,R3:75,R4:100(radio type child question for Q2)

The formula for finding the minimum score for criteria is
min score = {(A1*B1)+(A2*B2)+...+(An*Bn)}/n
ex: min score = [(25*1)+(25*1)]/2 = 25
where,
A = Minimum score of each mandatory parent question in criteria
B = Weightage of each mandatory parent question in the criteria
n = Total no. of mandatory parent questions in the criteria

The formula for finding the maximum score for criteria is
max score = {(X1*Y1)+(X2*Y2)+...+(Xm*Ym)}/m
ex: max score = [(100*1)+(250*1)+(100*1)]/3 = 150
where,
X = Maximun score of each question in a criteria
Y = Weightage of question in criteria
m = Total no. of questions in the criteria

So the three levels can be defined as
L1:25<=SCORE<=50;
L2:50<SCORE<=100;
L3:100<SCORE<=150

Note:
Max score for Multiselect questions: The formula for finding the maximum score for criteria is {[the sum of (all scores of each questions in a criteria * weightage of question in criteria)]/total no. of questions in the criteria}
59
L2 SCORE
60
L3 SCORE
61
62
Domain(theme)_rubric_scoring Tab
63
KeywordsDescription
64
domain_IdSelect domain id from the dropdown
65
domain_nameFill domain name as per domain id
66
weightageweightage in integer
67
L1 SCOREDefine the range of score for the each domain at respective levels. For a said domain, find the sum of minimum and maximum score of each criterion in the domain. Divide it in range to create the required no. of levels.
For eg. if the domain has 2 criterion,
C1- L1:25<=SCORE<=50;L2:50<SCORE<=75;L3:75<SCORE<=100
C2- L1:25<=SCORE<=50;L2:50<SCORE<=75;L3:75<SCORE<=100

The formula for finding the minimum score for domain is
min score = {(A1*B1)+(A2*B2)+...+(An*Bn)}/n
ex : min score - [(25*1)+(25*1)]/2 = 25
where,
A = Minimum score of each criterion in a domain
B = Weightage of criteria in the domain
n = Total no. of criterion in the domain

The formula for finding the maximum score for domain is
max score = {(X1*Y1)+(X2*Y2)+...+(Xm*Ym)}/m
ex: max score - [(100*1)+(100*1)]/2 = 100
where,
X = Maximun score of each criterion in a domain
Y = Weightage of criterion in domain
m = Total no. of criterion in the domain

So the three levels can be defined as
L1:25<=SCORE<=50;
L2:50<SCORE<=75;
L3:75<SCORE<=100
68
L2 SCORE
69
L3 SCORE
70
71
72
Rubric Scoring formula
73
Criteria Rubric Scoring FormulaDefine the range of score for the each criteria at respective levels. For a said criteria, find the sum of minimum and maximum score. Divide it in range to create the required no. of levels.
For eg. if the criteria has 3 questions,
Q1- R1:25,R2:50,R3:75,R4:100(radio type parent question)
Q2- R1:25,R2:50,R3:75,R4:100(multi-select type parent question)
Q3- R1:25,R2:50,R3:75,R4:100(radio type child question for Q2)

The formula for finding the minimum score for criteria is
min score = {(A1*B1)+(A2*B2)+...+(An*Bn)}/n
ex: min score = [(25*1)+(25*1)]/2 = 25
where,
A = Minimum score of each mandatory parent question in criteria
B = Weightage of each mandatory parent question in the criteria
n = Total no. of mandatory parent questions in the criteria

The formula for finding the maximum score for criteria is
max score = {(X1*Y1)+(X2*Y2)+...+(Xm*Ym)}/m
ex: max score = [(100*1)+(250*1)+(100*1)]/3 = 150
where,
X = Maximun score of each question in a criteria
Y = Weightage of question in criteria
m = Total no. of questions in the criteria

So the three levels can be defined as
L1:25<=SCORE<=50;
L2:50<SCORE<=100;
L3:100<SCORE<=150

Note:
Max score for Multiselect questions: The formula for finding the maximum score for criteria is {[the sum of (all scores of each questions in a criteria * weightage of question in criteria)]/total no. of questions in the criteria}
74
NOTE : If the Child question is not answered , it will not be part of scoring calculations.
75
Theme Rubric Scoring FormulaDefine the range of score for the each domain at respective levels. For a said domain, find the sum of minimum and maximum score of each criterion in the domain. Divide it in range to create the required no. of levels.
For eg. if the domain has 2 criterion,
C1- L1:25<=SCORE<=50;L2:50<SCORE<=75;L3:75<SCORE<=100
C2- L1:25<=SCORE<=50;L2:50<SCORE<=75;L3:75<SCORE<=100

The formula for finding the minimum score for domain is
min score = {(A1*B1)+(A2*B2)+...+(An*Bn)}/n
ex : min score - [(25*1)+(25*1)]/2 = 25
where,
A = Minimum score of each criterion in a domain
B = Weightage of criteria in the domain
n = Total no. of criterion in the domain

The formula for finding the maximum score for domain is
max score = {(X1*Y1)+(X2*Y2)+...+(Xm*Ym)}/m
ex: max score - [(100*1)+(100*1)]/2 = 100
where,
X = Maximun score of each criterion in a domain
Y = Weightage of criterion in domain
m = Total no. of criterion in the domain

So the three levels can be defined as
L1:25<=SCORE<=50;
L2:50<SCORE<=75;
L3:75<SCORE<=100
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100