The solution needed to be cost-effective, informative, and would require a specific time frame to deliver the information. The project requirement may vary on the nature of survey.
The Solution We divided this project into two activities i.e. making the survey form database & creating the analysis reports in the tabulation format. Project plan is been made to execute both the activities efficiently.
We have then created a dynamic application to enter the survey form data & to create final reports. Entire application is been tested with sample forms & established connection to view the online reports. We have then deployed seven team members including one team leader for this project. Out of the entire team we have selected two members to check the final reports & data quality of survey forms.
All survey data is entered in the database though this application & checked according to the specifications and quality methodologies. After making sure the quality of entries, tabulations reports are created for in-house quality check.
We have also set the following data checkpoints to make sure the accuracy of final reports:
- Check report template with all rows & columns.
- Make the data hand count to make sure the reports are correct & matching with the survey form figures.
- Check the total number of forms with report figures
- Checking of total number of fields cross referring in reports.
So this data is checked and approved by QC team. The reports are then uploaded onto the site for clients' final review.
The implementation of this process saved clients' cost of manpower & saved TAT to process & upload forms. It also increased the quality & reliability, as client can review these reports online from anywhere. |
