Epi Info™ User Guide

Loading Nutritional Data

Prior to creating a growth chart, nutritional data must be loaded into the dashboard. Follow the steps below to load the data associated with the Nutrition project into the dashboard.

1. From the Epi Info™ main menu, click the Visual Dashboard button or select Tools > Analyze Data > Visual Dashboard. The Dashboard tool appears.
2. Right-click on the dashboard canvas. A context menu appears.
3. Select Set Data Source from the context menu. The Select Data Source dialog box appears.
4. Click the ellipses next to the Data Source text box. A file open dialog box appears.
5. Navigate to the Epi Info™ projects folder.
6. Open the Nutrition folder within the projects folder.
7. Select the Nutrition project. Click Open.
8. In the Select Data Source dialog box, select the PatientVisits form. Click OK. The data is loaded on the dashboard.

After the PatientVisits form is loaded, the dashboard will have cached the data in the computer’s memory. Based on the data, various types of statistical tools or gadgets can be added to the canvas to display useful information to the user. For information regarding the statistical tools and gadgets available, reference the Visual Dashboard section of this user guide.

Creating a Growth Chart

There are many growth charting options available under Add NutStat growth chart in Visual Dashboard. The available growth chart types are dependent on each growth reference and require the necessary project data.

Note: The Nutrition project does not contain example data for every growth chart type.

The following examples demonstrate how to create a growth chart with data contained in the Nutrition project. All growth charts created in Visual Dashboard use similar processes outlined in the examples in the following tabs.

BMI for Age

The following example demonstrates how to create a BMI for Age growth chart using the CDC 2000 Growth Reference. The growth chart will demonstrate how the patient’s BMI compares to the CDC 2000 Growth Reference by age.

1. Right-click on the dashboard canvas. A context menu appears.
2. Select Add NutStat Growth Chart > CDC 2000 Growth Reference > Body Mass Index (BMI) for Age from the list of options in the context menu. A growth chart gadget appears on the canvas.
   

   

   Figure 11.6: Growth Chart Gadget

    

   The gadget must specify what fields to use for the Patient ID, Gender, Age, Body mass index (BMI), and the Patient ID to chart.

3. Select VisitPatientID for Patient ID field to use.
4. Select VisitSex for Gender field (must be coded M/F).
5. Select AgeMonths for Age field (months).
6. Select BMI for Body mass index (BMI) field.
7. Select 1 for Patient ID to chart.
   

   

   Figure 11.7: Completed Growth Chart Gadget

   The checkboxes below the drop-down lists allow for customizing the appearance of the graph.

   • Show legend – adds a legend to the graph (checked by default).
   • Use tall chart – extends the vertical height of the growth chart.
   • Black and white curves only – all curves appear in black and white (color is removed).
     
8. Click the Generate Chart button. The growth chart appears on the canvas.
   

   

   Figure 11.8: BMI for Age Growth Chart

    

9. To collapse the panel and show only the chart, click the up arrow at the top right corner of the properties panel. Click the down arrow to expand the properties panel.

Height for Age

The following example demonstrates how to create a Height for Age growth chart using the CDC/WHO 1978 growth reference. The growth chart will demonstrate how the patient’s height compares to CDC/WHO 1978 standards by age.

1. Right-click on the dashboard canvas. A context menu appears.
2. Select Add NutStat Growth Chart > CDC/WHO 1978> Height for Age from the list of options in the context menu. A growth charting gadget appears on the canvas.
3. Select VisitPatientID for Patient ID field to use.
4. Select  VisitSex for Gender field (must be coded M/F).
5. Select AgeMonths for Age field (months).
6. Select HeightInches for Height field.
7. Select 1 for Patient ID to chart.
8. Click the Generate Chart button. The chart appears as shown below.
   

   

   Figure 11.9: Height for Age Growth Chart

    

9. To collapse the panel and show only the chart, click the up arrow at the top right corner of the properties panel. Click the down arrow to expand the properties panel.

Length for Age

The following example demonstrates how to create a Length for Age growth chart using the WHO Child Growth Standards. The growth chart will demonstrate how the patient’s length compares to WHO Child Growth Standards by age.

Note: The Length for Age chart requires similar inputs as the Height for Age chart but additionally requires the user to check the Recumbent check box in the PatientVisits form during data entry.
 

Figure 11.10: Recumbent checkbox in PatientsVisit form during data entry

1. Right-click on the dashboard canvas. A context menu appears..
2. Select Add NutStat Growth Chart > WHO Child Growth Standards > Length for Age from the list of options in the context menu. A growth charting gadget appears on the canvas.
3. Select VisitPatientID for Patient ID field to use.
4. Select VisitSex for Gender field (must be coded M/F).
5. Select AgeMonths for Age field (months).
6. Select HeightInches for Length field. (If recumbent was checked during data entry, the height field converts to length).
7. Select 1 for Patient ID to chart.
8. Click the Generate Chart button. The chart will appear as shown below.
   

   

   Figure 11.11: Length for Age Growth Chart

    

9. To collapse the panel and show only the chart, click the up arrow at the top right corner of the properties panel. Click the down arrow to expand the properties panel.

It is important to note some aspects of the growth charting capabilities. First, there must be a patient ID field to identify a single person within the database. In the examples above, all of the records from the patient with an ID value of 1 were charted. Second, the field storing gender information must code that information as M and F. The dashboard has data recoding capabilities that can be used to change gender information to other formats. No matter what format represents male and female, it can be converted. In the examples above, no conversion was necessary. Third, the field storing the age values must be in months. Similar to gender, the dashboard can convert ages stored in days and years into months. Fourth, all properties can be changed in order to re-generate the chart. However, changing the chart inputs and growth references is subject to the data available and the available chart types. Finally, the growth charts can be used with non-Epi Info™ 7 projects, including projects that do not have the z-scores and percentiles already calculated.