Questionnaire related database elements
Purpose
The data-schema elements in this part of the KKSys allow management of data relating to Questionnares used to gather data about farmers. This part of the database is slightly different from other sections as it is intended to enable complex data-gathering exercises such as visits to farmers in which questions are asked in any possible questionnaire or survey.
enable the recording of many aspects of data that are required for the day-to-day operation of Kuapa Kokoo.
Examples of the types of questionnaires which can be created:
- Questionnaires relating to Organic cultivation or Fairtrade Practices.
- Questionnaires gathering household data related to the income levels, educational levels or other socio-economic data of farmers.
- Questionnaires related to gender issues.
- Questionnaires related to child-labour.
These are only example questionniares, and many other types of questionniare can be created, including questionnaires relating to other groups KKFU is involved with such as Staff Questionnaires, or Societies.
Basic inter-relationships within this part of the database
The Questionnaires system consists of a number of Questionnaires, each with a set of Questions. As an example, a Questonnaire might relate to Child Labour, and one of the questions might be Give the Ages of Children Working on this Farm.
Once a Questionnaire has been created, with its related Questions, KKFU staff can use the ICO Orixa App to visit farmers and add a series of Answers. When these answers are added together for all the farmers the full data from the questionnaire can be extracted.
The Questionnaires System has two additional data-entities. Question Sections a small entity, which simply allows Questionnaires to be divided into parts, and Non-conformities, an entity which is used to add special notes and additional data when the answer a farmer has given to a question has raised an issue which needs to be resolved.
Not all Questionnaires need to have Non-conformities. For example when a Questionnaire is created for household data such as the types of housing of farmers, there would not be any possibility for non-conformity. On the other hand if pesticides were found on a farm when the Questionnaire related to Organic farming, then a non-conformity record could be added.
The use and purpose of each of these entities and the child-entities are detailed in individual sections of this help document below, please go to the linked articles for detailed, step by step description of each data-entity
Elements of the questionnaires-related sections of the database
TThe KKSys is a single, whole database. The questionnaire related sections of the database are not separate from the sections managing Society, Farmer or Audit data. The sections have been separated in this help document to make it easier to understand them and get a sense of their inter-relationships and purpose, but the data exists as a whole and all parts of it can be accessed at any time.
Questionnaires, Question Sections and Questions
The image below shows each of these data-entities and lists all the data-fields present in each one, with it's data-type. These images give an overview of the data-entities which is fully detailed in the individual linked sections listed above.
Questionnaires, QuestionSections, Questions
Inspections, Answers and Nonconformities
The image below shows each of these data-entities and lists all the data-fields present in each one, with it's data-type. These images give an overview of the data-entities which is fully detailed in the individual linked sections listed above.
Inspections, Answers & NoConformities
A detailed "how to" document on using the Questionnaires system is here:
The main implementation of the Questionnaire system is in the ICO-System. This is detailed here: