From Know Your Audience: chapter 5
Not many surveys are analysed manually these days, even in developing countries, but manual analysis can be quicker than using a computer, when:
Manual counting works better if questionnaires are printed on fairly thick paper (i.e. not very floppy), and answer codes are shown on the questionnaires.
There are two possible ways to hand-count questionnaires:
1. to go through each questionnaire once, noting on a separate piece of paper the answers to every question.
2. to go through each question one at a time, counting questionnaires.
In theory, method 1 should be faster - but in practice, its not, because its too easy to make a mistake. If you are interrupted while doing this. you are almost certain to lose count, and youll have to start again. In practice, method 2 is best: one heap for each possible answer to the question you are currently tabulating. Though this means that you have to re-sort the questionnaires for every question, it also means that any errors are easily discovered - and, with hand-counting, there will always be a few errors.
For example, to hand-count the results of the question "Which sex are you?" you need to make space for 2 heaps (or possibly 3, if the sex of some respondents wasnt noted). Sort the questionnaires into male and female heaps (and maybe a not-stated heap), then count the number in each heap. As you count each questionnaire, double-check that its in the right heap. The total of all the heaps should be the known total number of questionnaires. If it isnt, count again.
After tabulating the responses to each question (e.g. 81 male, 119 female, 2 not stated), take the next question, and create a new set of heaps.
To make a manual count for a multiple-answer question (such as "Which languages do you understand?") is not so easy, because people who gave two answers should be in two heaps - but they only have one questionnaire. The solution is to make a separate count for each possible answer, with two heaps for each answer: those who gave that answer (e.g. understand English) and those who did not (e.g. do not understand English).
If you want to do manual counting of a questionnaire that takes up more than one piece of paper, this is possible, but each questionnaire will have to be folded so that you can always see the answer to the question youre counting at the time.
Cross-tabulation by hand
For this, you need not just a row of heaps of questionnaires, but a matrix of heaps. If one of the two questions being cross-tabulated has 3 possible answers, and the other has 5, youll need to make space for 15 heaps: 5 across, and 3 down, or vice versa. If your table isnt large enough, you can do this on the floor - as long as theres no wind!