ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Template Version : 5.1.0
2
General Instruction to fill this observation solution template
3
Recommended: We suggest you use a unique resource name to avoid duplication in reports.
4
Don't change any labels of the tab and Don't change any column name's in each sheet
5
Take the help of the 1st row in each tab with 'Description of each field' as mentioned in below to understand what needs to be filled in a particular column
6
Detailed instructions for Rubric Scoring Formula is available at the end of the instructions sheet.
7
8
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.
9
Colour Codes to followHeader ColorDomain(theme)_rubric_scoring Tab
10
Description of each fieldKeywordsDescription
11
Mandatory Fielddomain_IdSelect domain id from the dropdown
12
Optional Fielddomain_nameFill domain name as per domain id
13
Conditionally Optional Fieldweightageweightage in integer
14
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
15
Details TabL2 SCORE
16
KeywordsDescriptionL3 SCORE
17
observation_solution_nameWrite a meaningful name of your observation solutionLn SCOREScoring formula for Level 'n', n can be 4,5,6 ... any number in series.
18
observation_solution_descriptionWrite a brief description about the observation solution
19
Diksha_loginIdWrite your platform login ID (UserID of the observation solution Designer )
20
Name_of_the_creatorThe name provided here will be marked as creator of the observationQuestions Tab
21
languageLanguage of the observation solutionKeywordsDescription
22
Name_of_the_creatorMention the creator name.section_idSection to which the question belongs to.
23
keywordsWrite some appropriate keywords criteria_idselect criteria_id from drop-down provided for each questions
24
scoring_systemMention the scoring system of the observation Ex : pointBasedScoringsection_headerHeader for each section
25
entity_typePlease select any 1 of the entiy type of observation from the drop down providedquestion_sequencewrite the order of the question, how you want to see them on App(e.g. 1,2,3...)
26
question_idUnique ID for each question (Alphanumeric)
27
framework Tabinstance_parent_question_idIf it is a instance type Solution, write the instance_parent_question_id
otherwise leave this column as empty
28
KeywordsDescriptionparent_question_idWrite the parent_question_id, if it a child question (i.e. dependent question on other)
29
Domain IDUse any unique alphanumeric text as domain idshow_when_parent_question_value_isUse the appropriate mathematical operator(EQUALS, OR, NOT_EQUALS_TO) as per your questionnaire need
30
Domain Namewrite the name of the Domainparent_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.
31
Criteria IDSelect any criteria id from the dropdown.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.
32
Criteria NameProvide criteria namequestion_numberYou may use 1,2,3.... or a, b, c.... or i, ii, iii.....etc. as numbering your questionnaire
33
L1 descriptionDescription for criteriaquestion_primary_languageWrite the Primary language name in which you are creating your solution (e.g. English)
34
L2 descriptionDescription for criteriaquestion_secondory_languageIf you want to show your questionnaire in other language as well, you may write here(e.g. Kannada)
35
L3 descriptionDescription for criteriaquestion_tipIf you want add tip to your question, you may write the tip text in this column
36
Ln descriptionPlease replace ' n ' with consecutive integers if there are more levels.question_hintTo add hint to the question, write the hint text here.
37
instance_identifierIf it is a instance type Solution, write the instance_identifier here. This will be label as ADD instance identifier text
38
ECMs or Domains Tabquestion_response_typeSelect the question-response-type from the drop-down list as per question's need
39
KeywordsDescriptiondate_formatUse the date format (DD-MM-YYYY) user will be able to edit the date once enter (Note: This is recommended date format)
40
ECM Id/Domian IDUse any unique alphanumeric text as ECM id/domain iddate_auto_captureUse auto_capture only if you don't want let your user edit the date of observation once entered.
41
ECM Name/Domain Namewrite the name of the ECM Name/Domainresponse_requiredIf the question is mandatory to anwser, Select TRUE option
42
section_idUse any unique alphanumeric text as section id (can be same as ECM Id)min_number_valueWrite the minimum number allowed to enter in case of data entry(number) & Slider type question
43
section_namewrite the name of the section name (ECM Name)max_number_valueWrite the maximum number allowed to enter in case of data entry(number) & Slider type question
44
Is ECM Mandatory?Select True/False from dropdownfile_uploadIf evidences is required to attach for a particular question, Select as TRUE else FALSE
45
allow_audio_recordingIf you want to record the evidences in the form of audio, you any select as TRUE
46
show_remarksIf you want to show add remark option after that question so that assessor can add the remark, you may select it as TRUE
47
Criteria_Rubric-Scoring Tabresponse(R1)Write your first response here
48
KeywordsDescriptionresponse(R2)Write your second response here
49
criteriaIdSelect criteria id from the dropdownresponse(R1)_hintWrite the hint for your response 1(if needed) else leave this column
50
weightageweightage in integerresponse(R2)_hintWrite the hint for your response 2(if needed) else leave this column
51
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}		response(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
52
L2 SCOREslider_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
53
L3 SCORE
54
Ln SCOREScoring formula for Level 'n', n can be 4,5,6 ... any number in series.
55
56
57
Rubric Scoring formula
58
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}
59
NOTE : If the Child question is not answered , it will not be part of scoring calculations.
60
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
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
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