Once you have downloaded the excel template for a H2 assessment, the file will contain 4 tabs:
...
When you open the sheet, ‘Template’ tab will be selected by default.
The Instructions tab
This tab provides brief information related to the Excel sheet. You can go through this tab to have a thorough understanding of all the fields in the sheet.
...
All the above listed fields are required.
The Template tab
This tab will present all the current content of the program stage. In the template a row can represent:
Section: they represent the Program Stage sections and contain data elements. The section row is highlighted in Orange. Those data elements can be of three types:
label: a data element that will be rendered as non editable text, to give information to the user. The label row is highlighted in Green.
question: a data element that it is used to capture information - the questions of a H2 list
score: non-editable data elements that are used to store calculated scores in H2
You will select this options in Column B of the template.
...
Managing Assessment Sections
To add another Section the user only will have to add a new row ( Is very important to remark that an entire row needs to be added ) right below the previous section’s last Data Element.
For a new section, the user has to select "Section" on the Structure ( B ) column.
Then write a form name that will be the name displayed for the new section.
Managing labels, questions, scores (Data Elements)
To add a new Data Element you have to find the right position where you want it and add a new entire row right below.
Parent Name (column A)
Is used as reference in conjunction to ‘Parent Question’ column ( L ). This field is auto generated and follows the structure “_S#Q#” where “S” represent the section number and “Q” signifies the “Question”.
Example: _S1Q15 signifies the 15th Question in the 1st Section of the Program Stage.
Structure (column B)
For a new DE the user will have to select between a label or question
If "label" is selected by the user only will have to fill the form name
If the option selected is "question" the User will have to fill in the form name and other fields
Form name (column C)
Form name is the text that will be displayed in the form during the assessment.
Critical (column D) and Compulsory (column E)
The critical and compulsory columns by default are going to be filled with "No". If the question is compulsory indicates that the user will not be able to complete the assessment until this question has been answered. A critical question means that these questions will count for the calculated score.
Value Type (column F)
The value type field defines the kind of response the system expect to receive from the user.
Option Set (column G)
User will be able to fill the option set with options set previously created on DHIS. For a question, if an Option Set is selected, the “Value Type (column F) must match the value type of the Option Set.
Legend (column H)
The legend field allows the user to choose if he wants to apply some colour for "correct" or "incorrect" answers. Also will be created on DHIS. The legend will be displayed in the form and in the Feedback module in the app.
Score Numerator (column I) & Denominator (column J)
These fields are used in the formulas for score calculation.
Compositive Indicator (column K)
The composite indicator Field is the order of the questions for example if your listing the First Section ( Section 1) Data Elements this will start at 1.1 and ends in 1.x.
Parent Question (column L)
Parent question decide the hide show logic for some question. The user will have to select for the parent question the value of the "Parent question" Column A and put it in the Parent questions Column L of the Child question. Essentially the Data Element defined in the row won't be displayed in the data entry form until a certain condition applies to the selected parent.
Answer Value (column M)
The answer value specifies the value that will trigger the “show” rule of the question defined in the row. The answer value field will be filled by the user with the options that expect to receive in the parent question for showing the child question.
Feedback Text (column N)
Feedback text and descriptions fields should be filled by the user for example when you want to display some text above the DE to do some reminder or something you fill the "Feedback" and the description is for the configuration side ( Description will not be displayed on the app).
Section for Scores - special case
Under the "Scores" section user will be able to add a new score.
To add a new score select the position where you want to insert it and add a new row.
Select column B " Score" and fill in the form name and the composite score.
Global Validation present in the Excel template
The excel template will show a cell with the red background or a alter dialog box will show if any of the following validations is violated;
Instruction Tab
If the Program Name doesn’t exist in the Program List (column R) in the Mapping tab
...
5. If value of Health Area doesn’t exist in the Health Area list (column M) in the Mapping tab.
Template Tab
If the Structure value is other than Section / label / question / score.
If the Critical Step value is other than ‘Yes / No’
If the Compulsory value is other than ‘Yes / No’
If the Value Type doesn’t match one of the Value type listed in column B in the Mapping Type.
If the Option set value doesn’t exist in the Mapping’s Option Sets (column H)
If the legend doesn’t exist in Legend set (column O) in the Mapping tab.
If the ‘Score Numerator’ and ‘Score Denominator’ are not of type Decimal
If any of the ‘Score Numerator’ and ‘Score Denominator’ have negative value.
If ‘Parent Name’ is not defined for element of Structure type ‘label or question’
A form number is not defined though Structure value is selected.
Form name is too long or is out of accepted range
MIN_FORM_NAME_LENGTHIf only ‘Score Numerator' or ‘Score Denominator’ is provided.
if one of ‘Parent Question’ or ‘Parent Answer’ is provided and other one is missing.
if both Parent Name and Parent Question has same value.