Background: Monitoring food costs informs governments of the affordability of healthy diets. Many countries have adopted a standardized healthy food basket. The Victorian Healthy Food Basket contains 44 food items necessary to meet the nutritional requirements of four different Australian family types for a fortnight.
Objective: The aim of this study was to describe the development of a new iPad app as core to the implementation of the Victorian Healthy Food Basket. The app significantly automates the data collection. We evaluate if the new technology enhanced the quality and efficacy of the research.
Methods: Time taken for data collection and entry was recorded. Semi-structured evaluative interviews were conducted with five field workers during the pilot of the iPad app. Field workers were familiar with previous manual data collection methods. Qualitative process evaluation data was summarized against key evaluation questions.
Results: Field workers reported that using the iPad for data collection resulted in increased data accuracy, time savings, and efficient data management, and was preferred over manual collection.
Conclusions: Portable digital devices may be considered to improve and extend data collection in the field of food cost monitoring.
The cost of nutritious food is a key factor influencing food access, choice, and therefore impacts on health . Socially and economically disadvantaged populations have greater rates of nutrition related diseases. Monitoring the cost and availability of a nutritious basket of food can provide useful information to assess both economic and physical access to nutritious food in a region, as well as changes in affordability over time, and is vital information to assist in informing policy. Healthy food baskets are a tool implemented regionally to reliably achieve this. A range of healthy food baskets have been developed internationally to assess and monitor the cost of an ideal nutritious diet [ - ]. Healthy food baskets have been deemed to be an effective instrument to assess economic food access [ ]. The Victorian Healthy Food Basket (VHFB) is a shopping list of the specific quantities of 44 commonly consumed foods that, as a whole, meet the nutrient requirements of four reference families for a fortnight [ ]. Checking the price of these items at supermarkets makes it possible to calculate the cost of a nutritious diet, monitor changes over time, and compare the cost of healthy diet to income data to assess affordability. In Australia the distance between a store and the nearest capital city can be over 2000 km [ ], creating a need for efficient mechanisms for the collection of data. We focus on a study in the state of Victoria, Australia, covering 115 stores over 27 geographically and demographically distinct areas with a total population of 2,525,534.
Practical implementations of healthy food baskets rely significantly on data collection. Traditional approaches to collecting data on the cost of items in a healthy food basket involve simple, manual data collection techniques, including pen and paper at the source of observation. This data is then entered into computerized spread sheets for the purpose of data analysis. This form of data collection and management can be inaccurate, labor-intensive, and therefore inefficient [- ]. Newer technology developments such as portable digital devices (Personal Digital Assistant [PDA] and smart touch devices) and wireless technologies have opened many opportunities for the way we collect, store, manage, and share survey data. These advances are making data collection and sharing faster, easier, and more accurate [ - ].
An iPad app aimed to enhance the quality and efficacy of the research and was complemented by a Java Server app that provides a data management and analysis platform (). The Java Server app is built using Model View Controller (MVC) and Inversion of Control (IoC) design patterns that employ Struts2 technology to generate interactive webpage content, with persistence to a database achieved using Hibernate JPA. The app is currently deployed on an Apache Tomcat server using a PostgreSQL database. The iPad app was developed to incorporate instructions for data collection as well as data entry fields with quality controls ( ). Upon completion of the data entry, the field workers upload the shopping lists to the central data store, eliminating the need for manual data entry. The app was implemented with the ability to seamlessly manage data capture and data upload even when connectivity to the mobile network is not available. The iPad app had basic error validation and prevention mechanisms such as a format for price, quantity, and address fields. Error messages were displayed if users entered data that did not match the agreed formats, drop-down boxes so that users were limited to a set of valid data options, and if users were not able to upload prices/data from stores that did not have a completed data set. The app was freely available from the Apple App Store with conditions for use for research purpose highlighted as a condition of the download. While anyone is able to download the app, only those trained in rule for data collection and use of the iPad are given user accounts by the research team to upload their data to the central Web-based store. This paper describes the development and process evaluation of the iPad app for the collection of healthy food basket data.
The iPad app was piloted to test for user-friendliness. All field workers (n=6) who were selected to pilot the technology were invited to be part of the evaluation. They all had previous experience with the paper-based, manual data collection processes and consented to be interviewed to evaluate the new technology.
A process evaluation was conducted using semi-structured interviews with five field workers (83% response rate) at the completion of the pilot. The focus of the process evaluation was on the quality and efficiency of, and satisfaction with, the technology and perceptions of improvements from previous paper-based methods () [ ]. The short interview explored the experience of using the iPad app for data collection and entry. Interviews were audio-recorded and notes taken. Interviews were analyzed by one author (DPS) using an approach whereby audio-recording and notes were reviewed, text coded, and grouped into categories against the process evaluation questions [ ]. The analysis was verified by another author (CP) through independent review of notes from interviews.
|Questions of inquiry
|Approach to data collection using the iPad app
|Quality of app, visual appeal and functionality
|Strengths of data collection using the iPad app compared to paper-based
|Efficiency – ease of use, perceived ease compared to paper-based collection
|Challenges with data collection and entry using the iPad app
|Satisfaction – overall with app and compared to manual collection
|Recommendations for future improvement of iPad app
Field workers commented that the iPad app resulted in more accurate data collection with fewer discrepancies. Collecting data in a paper format at the store and entering the data later into an excel file was tedious, error prone, and time-consuming.
When I used to enter data …. I would have about 15-20 stores piled up and start entering them one after the other and you could easily miss a decimal point or an item. But with the iPad … I actually made less mistakes when entering prices… [Field worker number 4].
The field workers reported that another significant benefit of portable digital device was the time savings made. Compared to the previous paper-based model, field workers found the ability to upload the data directly from the app saved time. Compared to paper-based data collection, using the iPad app was reported to be a fast, easy, and convenient way to collect data whilst in the supermarkets.
I would have to go home and then enter data… Sometimes I had to wait until the file is shared with me. With the iPad, once I have collected the data in the store the work is done. It saves a lot of time.
[Field worker number 1]
The field workers commented that the iPad app was easy to use and they were able to be familiar with the available functionality quickly and with minimal training. Participants commented that having access to the data collection rules in the iPad reduced the need to manage multiple sheets of paper. Field workers recorded that the time taken to collect and upload data was between 45-60 minutes. This varied from previous paper-based collection which took 70-90 minutes in total and was a two-step rather than one-step process. Field workers described entering data using the iPad for the first time took longer than when using pen and paper. However, after the first store the time taken was the same as that of the paper and pen. They explained that this was due to the need to become familiar with the new technology.
I looked at the user guide for about 5 mins and was ready to go. It’s very easy to use.
[Field worker 1]
We didn’t even look at the guide, the orientation we had was good enough.
[Field worker 2]
The development of this novel iPad app for the collection of food cost data was perceived to provide a more efficient and accurate form of data collection compared to previous manual-based systems.
Improved data accuracy is a major advantage for using portable digital devices. Previous studies have shown that error validation, prevention, and workflow improvements (such as taking away the need to double handle data entry) in the surveys designed for digital devices significantly reduce the errors seen when data is collected using manual techniques [, ]. Adding further error prevention and validation mechanisms such as range checks, real-time visibility of missing data, and automatic capture of store addresses using GPS capabilities of the devices are planned for the immediate future. Price scanning using the portable device may also be investigated.
While views of the five field workers in this study are likely to be transferable to others using portable devices for data collection, the small sample size and focus on process evaluation are acknowledged as limitations in the breadth and depth of evaluation data.
There remains a need for a national food and nutrition monitoring system in Australia . The electronic support systems of the healthy food basket could form part of this system. This research provides some evidence to support the idea that using portable digital devices for data collection in the nutrition research area can result in increased data accuracy, time savings, and efficient data management and sharing. The iPad app is available free to use for research purposes (contact corresponding author for more information).
Funding for this work was provided by the Centre for Excellence in Intervention and Prevention Science (CEIPS), an initiative of the Department of Health, Victoria.
SQ together with AS identified the idea of the iPad app for the collection of the data. AK, SE and DPS supported researchers CP and HT to complete the development. CP and DPS tested the app and conducted and analyzed interviews from field workers. CP oversaw project and drafted manuscript. All authors were involved in drafting and approved the final version of the manuscript.
Conflicts of Interest
- Wilkinson R, Marmot M. World Health Organization.: World Health Organization; 1998. The Social Determinants of Health: The Solid Facts, Second Edition URL: http://www.euro.who.int/__data/assets/pdf_file/0005/98438/e81384.pdf [accessed 2014-10-10] [WebCite Cache]
- Williams PG, Reid M, Shaw K. The Illawarra Healthy Food Price Index. 1. Development of the food basket. Nutrition and Dietetics 2004;61(4):200-207.
- The 2000 Healthy Food Access basket (HFAB) survey: full report.: Queensland Government; 2001. The 2000 Healthy Food Access basket (HFAB) survey: full report URL: http://www.health.qld.gov.au/ph/documents/hpu/9137.pdf [accessed 2014-10-10] [WebCite Cache]
- Health Canada. National Nutritious Food Basket. 2008. URL: http://www.hc-sc.gc.ca/fn-an/surveill/basket-panier/hist-eng.php [accessed 2014-10-10] [WebCite Cache]
- Andrews M, Kantor LS, Lino M, Ripplinger D. Using USDA's Thrifty Food Plan to assess food availability and affordability. Food Access 2001;24(2):45.
- Nathoo T, Shoveller J. Do healthy food baskets assess food security? Chronic Dis Can 2003;24(2-3):65-69. [Medline]
- Palermo C, Wilson A. Development of a healthy food basket for Victoria. Aust N Z J Public Health 2007 Aug;31(4):360-363. [Medline]
- Couper M. Technology trends in survey data collection. Social Science Computer Review 2005 Nov 01;23(4):486-501 [FREE Full text] [CrossRef]
- Yu P, de Courten M, Pan E, Galea G, Pryor J. The development and evaluation of a PDA-based method for public health surveillance data collection in developing countries. Int J Med Inform 2009 Aug;78(8):532-542. [CrossRef] [Medline]
- Fletcher LA, Erickson DJ, Toomey TL, Wagenaar AC. Handheld computers. A feasible alternative to paper forms for field data collection. Eval Rev 2003 Apr;27(2):165-178. [Medline]
- Guadagno L, VandeWeerd C, Stevens D, Abraham I, Paveza GJ, Fulmer T. Using PDAs for data collection. Appl Nurs Res 2004 Nov;17(4):283-291. [Medline]
- Hawe P, Degeling D, Hall J. Evaluating health promotion: a health worker's guide. Sydney: Maclennan & Petty; 1990.
- Liamputtong P. Qualitative research methods. South Melbourne, Vic: Oxford University Press Australia and New Zealand; 2009.
- Masters G, Coles-Rutishauser I, Webb K, Marks G, Pearse J. The National Public Health Partnership (NPHP). Summer Hill, NSW; Melbourne Victoria: Nexus Management Consulting; National Public Health Partnership; 2006 Apr 20. A national food and nutrition monitoring and surveillance system: a framework and a business case URL: http://www.health.vic.gov.au/archive/archive2014/nphp/publications/documents/att3_fnms_final_report0406.pdf [accessed 2014-10-10] [WebCite Cache]
|IoC: Inversion of Control (IoC)
|MVC: Model View Controller
|PDA: Portable Digital Assistant
|VHFB: Victorian Healthy Food Basket
Edited by G Eysenbach; submitted 09.02.14; peer-reviewed by P Williams, A Lee; comments to author 17.08.14; revised version received 04.09.14; accepted 09.09.14; published 04.12.14Copyright
©Claire Palermo, Dharani Perera-Schulz, Anitha Kannan, Helen Truby, Alan Shiell, Sindhu Emilda, Steve Quenette. Originally published in JMIR Mhealth and Uhealth (http://mhealth.jmir.org), 04.12.2014.
This is an open-access article distributed under the terms of the Creative Commons Attribution License (http://creativecommons.org/licenses/by/2.0/), which permits unrestricted use, distribution, and reproduction in any medium, provided the original work, first published in JMIR mhealth and uhealth, is properly cited. The complete bibliographic information, a link to the original publication on http://mhealth.jmir.org/, as well as this copyright and license information must be included.