data entry Excel is a dynamic spreadsheet desgined for efficient data collection while adhering to predefined attributes outlined in an OCA schema.
A schema provides a structured framework that informs users on effectively utilizing data. It includes essential details such as data types, units of measurement, and concise descriptions for each data element (label). To delve deeper into the concept of a schema, refer to the official OCA Schema bundle documentation.
Creating a schema is just the beginning; its actual value lies in its practical application. Rather than languishing in a repository, a schema is meant to be utilized by others, serving as a reliable reference point during their data collection endeavors. Generating a data entry spreadsheet that adheres to the schema description opens avenues for seamless replication of data collection processes.
Utilizing a data entry xls facilitates data collection based on established schemas others employ. This ensures compliance and streamlines the referencing of existing work, simplifying the overall data-collection process.
Learn more about how to create a schema and generate a data entry Excel, or use our user guided interface to create your own schema and data entry Excel
The data entry Excel comprises three separate sheets, each serving a vital role:
schema description: This sheet offers a comprehensive overview of the overlays within an OCA schema bundle. Certain overlays have been renamed to enhance ease of understanding within the data entry Excel. For instance, Sensitive attributes in the data entry Excel correspond to flagged attributes in the OCA schema bundle, while Required aligns with conformance.
Moreover, for attributes requiring data input from specified options, a look up table is provided. These options, known as entry codes in OCA, are presented in a user-friendly format for quick reference. Watch a video about look up tables in data entry or read our blog post about entry codes
data entry: This is the primary workspace for inputting collected data. Attributes with entry codes are conveniently presented as a dropdown list, facilitating accurate and efficient data entry.
schema conformant: Designed to ensure data integrity, this sheet verifies that data entered in the data entry sheet adheres to the attributes definitions outlined in the schema bundle.
N.B Although some validation occurs in data entry Excel, the complete data validation is done with another tool. Currently, a data validation tool is implemented in python.
Collectively, these three sheets provide a comprehensive framework for structured data entry, simplifying the process while maintaining adherence to schema specifications.
The code provided in dataentryExcel has been seamlessly integrated into the codebase of the Semantic Engine, accessible at semanticengine.org. This integration enables users to effortlessly generate data entry Excel sheets by either uploading a preexisting OCA bundle, such as the example provided in chicken_example.json, or by crafting one from scratch.
Create an OCA bundle schema using a schema writer at the Semantic Engine and then create your own data entry Excel based on the OCA schema bundle you have generated.