Data Cleaning with Kinaki

Using the Data Management, you can compile and edit your data to ensure the highest quality prior to analysis.

Data cleaning is an essential practice in monitoring and evaluation work and allows the data collection practitioner to make corrections to errors that may alter the presentation and analysis of a given dataset.

Kinaki is a web-based platform, which limits some aspects of data cleaning and review.

For larger datasets that require large amounts of processing, it may be relevant to explore how to use Microsoft Excel for Data Cleaning with Kinaki.

To begin, go the Data Management tab of the Data Collection section in Kinaki. Here, we can review data and submit it for analysis.

Heads up! Make sure you archive, delete or submit any older dataset. If you import the new dataset while the old one is still in Active Data Set, the data will merge.

If you have recently completed data collection for a specific data collection tool, your dataset will appear at the top of the page under “Active Data Set”.

This survey data may be from a recent data import, or the results of data collected from an online form.

If the data collection tool is active, you will see a note above the Active Data Set tab that says “Ongoing data collection for this Data Collection Tool”.

Our team recommends completing your data collection prior to the data cleaning process. You can turn off your survey on the “Data Collection” tab.

If there is no active data, you can open a submitted or archived dataset under “Manage Data Set”.

Only archived or re-opened datasets can be edited. Select the title of the dataset to open the record. Opening this dataset will override the “Active Data Set”, so be sure to save your work by archiving or submitting for analysis (even if only to be deleted later on).

With the Active Data Set, use the scrollbars on the bottom and side of the page to navigate through the responses.

Each column has a survey question or an information marker, and contains the question name, type, and full description in proceeding rows at the top of the column.

Each row represents a participant entry. These are labeled by the number (in the second column) and the result (or participant) ID.

To make changes to a answer cell, find the response in the participant’s row. Select the pencil icon. The response must align with the particular question type. Reload the page to view the change.

For example, a single choice may only select one response from the provided options, and a number response will only accept set numerical formats.

To delete an entire entry, select the “x” button next to the “Result ID”. Refresh the page to view the change.

To restore a deleted response, click on the green checkmark next to the corresponding “Result ID”.

Responses that have been edited will appear with green text. Responses that have been deleted appear with red strikethrough text.

When you have finished with a particular entry, select the check-box in the first column. This will allow you to keep track of which entries have been reviewed by your team.

Return to top

Tags: ,

Was this helpful?