Nasiru Garba Guda Garba Guda’s Updates

WEEK TWO ASSIGNMENTS

ID is very important in any of the database, this is the unique identifier that is linked with every record, with the help of this ID any required record can be viewed and information regarding that specific record can be retrieved in second. In database we call it primary key, and one primary key cannot be assigned to two different records,
When we have to link different tables in our database we need this unique ID which helps in correlating different information retrieved from community to study the behaviors , attitude and best practices being applied by the community members .
Unique Id could be, house hold number, form number. Cluster number. Child number etc.

• What happens if different questionnaires (and picture files) cannot be linked?
If we could not link different questionnaires together Its very difficult to assess the impact of our activities that we are doing at the ground level, as sometimes we cannot ask direct questions but some in-direct questions to see how effective our activities are in terms of implementation,
Photos are to support the questions asked by interviewer and if we cannot link them together then the quality of data could be questioned.


• Share experiences using tablets or phones in data collection.
I used mobile phone to collect data for lot quality assurance sampling surveys data in post-polio campaign phases for the assessment of campaigns quality and to see what are the reasons of children being missed using open data kit (ODK) forms.
I believe it’s a very efficient way of data collection and data can be transmitted with no delays, if we use mobile phones for data collection the chances of data fudging is also very less, because once data is collected on papers using questionnaire forms can be fudged or can be cooked before sending to next level.
Very less chances that data got lost as it always keeps a copy of data file in the mobile phone which can be retrieved as and when required.
With that I have also been using mobile phone to collect data on microplans validation before the polio campaigns, for real time data sharing and evidence base planning its best data collection method.
Currently I am using mobile phones to assess the cold chain status at district level inside Syria and receiving information about how efficiently the cold chain equipment is working and if there is a need to change we do recommend that from here as due to security problem we can not go down to Syria to monitor the work progress, I am having very good experience of using mobile phones for data collection

ID is very important in any of the database, this is the unique identifier that is linked with every record, with the help of this ID any required record can be viewed and information regarding that specific record can be retrieved in second. In database we call it primary key, and one primary key cannot be assigned to two different records,
When we have to link different tables in our database we need this unique ID which helps in correlating different information retrieved from community to study the behaviors , attitude and best practices being applied by the community members .
Unique Id could be, house hold number, form number. Cluster number. Child number etc.

• What happens if different questionnaires (and picture files) cannot be linked?
If we could not link different questionnaires together Its very difficult to assess the impact of our activities that we are doing at the ground level, as sometimes we cannot ask direct questions but some in-direct questions to see how effective our activities are in terms of implementation,
Photos are to support the questions asked by interviewer and if we cannot link them together then the quality of data could be questioned.


• Share experiences using tablets or phones in data collection.
I used mobile phone to collect data for lot quality assurance sampling surveys data in post-polio campaign phases for the assessment of campaigns quality and to see what are the reasons of children being missed using open data kit (ODK) forms.
I believe it’s a very efficient way of data collection and data can be transmitted with no delays, if we use mobile phones for data collection the chances of data fudging is also very less, because once data is collected on papers using questionnaire forms can be fudged or can be cooked before sending to next level.
Very less chances that data got lost as it always keeps a copy of data file in the mobile phone which can be retrieved as and when required.
With that I have also been using mobile phone to collect data on microplans validation before the polio campaigns, for real time data sharing and evidence base planning its best data collection method.
Currently I am using mobile phones to assess the cold chain status at district level inside Syria and receiving information about how efficiently the cold chain equipment is working and if there is a need to change we do recommend that from here as due to security problem we can not go down to Syria to monitor the work progress, I am having very good experience of using mobile phones for data collection