Once you have downloaded the excel Excel template for a an H2 assessment, the file will contain 4 tabs:
...
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 (See Image 1).
...
Most of the text in this tab are protected except for few fields listed below.
Program Name: is the name of the checklist
Program Short Name: is the short name provided to the checklist
Use Competency Class: will determine if competency class will be included with the program
Program DE Prefix: Is the prefix that is added to every Data Element related to the program in DHIS2.
Health Area: is the health area where checklist will be assigned
All the above listed fields are required.
...
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:
labelLabel: a data element that will be rendered as non-editable text, to give information to the user. The label row is highlighted in Green.
questionQuestion: a data element that it is used to capture information - the questions of a an H2 list
scoreScore: 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 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.
...
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.
...
The composite indicator Field is the order of the questions for example if your you’re listing the First Section ( Section 1) Data Elements this will start at 1.1 and ends in 1.x.
...
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.
...
Feedback Text (column N)
Feedback text and descriptions fields field 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 Feedback field.
Description (column O)
The description also should be filled in by the user, the description is for the configuration side (Description will not be displayed on the app).
Errors/Warning/Info (column S)
The template contain a column to show the errors, warnings or information related to the Data Element in the row, this errors help to check the issues before importing the template in the Program Stage. If there are errors in the template, the same errors will be displayed in the Summary Report After Validate the template in the PCA interface.
...
Section for Scores - special case
Under the "Scores" section, the 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 Excel template will show a cell with the red background, or a an alter dialog dialogue 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
2. If the program Name exceeds 225 character.
...
4. If the Use ‘Competency Class’ value is other than ‘Yes / No’.
5. If the 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 an 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.