Resources for public health researchers and epidemiologists
VBA table generator macro
Click on the 'Download' to find a VBA macro-enabled Word document that helps create APA like tables automatically. It also helps in editing these tables with great ease!! Use and distribution is free for both commercial and non-commercial purposes. Instructional videos in Media content page.
Calendar memory jogger
This is a calendar that has a collection of important festivals, holidays, events (astronomical, observences etc)
It also contains specific political and sport events from 2014-2019. It has been developed with Uttar Pradesh in mind,
Varanasi in particular, for 2014-2020.
​
The use-
It is a tool for reducing memory bias when collecting data which concerns events that occured in the distant past. It is used to jog the memory when asking for details of events that occured in the past. People often can associate a certain event like occurence of a symptom, or the date of going to a traditional healer etc to some festival that occured approximately around that day. Eg- They may say, 'I distinctly remember my fever started two days after Ganesh chathurthi of 2014' or 'My surgery was on the weekend after the Cricket World Cup final of 2016'.
Of course, you should also ask for people's birthdays, anniversary's etc as these are even better trigger points. Note that the pdf has a menu of bookmarks so that you can navigate quickly. So don't print it. Just use an electronic version on your mobile when adminstering your survey question.