Survey forms Scanning and Data Entry into Excel Sheets
Client Profile:
The Company: Security Agency
Location: London, United Kingdom
Industry: Security
The Objective:
Setting up accurate survey data (hard copies) processing of global employee survey from around 35 hour firms who selected for an offline survey.
The Challenges:
- To segregate and update the hard copies, as well as categorize them based on demography, date of survey and batch number.
- Storing and maintaining the data from the scanned copies.
- Continuous observation to eliminate any chances of errors in scanning or data entry.
- The client, a prominent international security solutions group, with an determined for effective and accurate data entry approached Computyne.
- They wanted to scan and enter data of ‘Global Employee Survey’ conducted by them. These data was in hard copies which consisted data of around 30 HR contact who opted for offline survey.
General Benefits:
- Quick and Effective conversion of complex and huge voluminous data into digital format.
- Error-free and streamlined data which can be easily accessed.
- Data stored in a centralized system, for convenient access in future.
- The activity helped the client flow in deliverance of successful premium fundraising and membership projects and programs to our various clients.
The Solutions:
Streamlining and proper categorization of the data was our prime focus. The hard copies were divided and cataloged according to the countries, date of survey and batch numbers.
- With Batch of surveys arriving at Computyne office, the spread sheets were updated with following information:
- Date batch received
- Batch number
- Country survey received from
- Upon arrival and opening of a particular bunch of survey, again the following information were updated in the spreadsheet to avoid any further confusion:
- Location names
- Observing the surveys using labels, post-it notes, separate sheets of paper etc.
- Reference code
- Country co-coordinator survey count
- Data entry processors reviewed the spread sheet to see where a batch of surveys require processing and update spread sheet with following information:
- Name(s) of data entry processors
- Date of data entry
- Data entry status
Technology / Software Used:
- MS Excel, FTP Server
Ask Us A Question
Fill out the form below to learn more about how Computyne can assist your organization.