chul
Uploaded by
14 SLIDES
285 VUES
140LIKES

Leveraging DDI Lifecycle with Colectica for Excel: Transforming Metadata Management

DESCRIPTION

This talk provides a comprehensive overview of the DDI Lifecycle using Colectica for Excel, a free tool designed to document datasets, variables, and code lists. Learn how to import data from Stata and SPSS, generate codebook documentation, and publish datasets in DDI 3.1 XML format. The session will demonstrate the unique identification of metadata, enabling the reuse of code lists and maintaining an audit trail through versioning. Discover how to save labels, harmonize code lists, and produce documentation in various formats, including PDF and HTML.

1 / 14

Télécharger la présentation

Leveraging DDI Lifecycle with Colectica for Excel: Transforming Metadata Management

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Colectica for Excel: Using DDI Lifecycle with Spreadsheets NADDI 2013

  2. In This Talk • Brief Overview of DDI-L • Colectica for Excel: a free tool to document • Datasets, Variables, and Code Lists • Import • Stata and SPSS • Generate codebook documentation • Demonstration

  3. DDI Lifecycle • Uses DDI version 3.1 • In this tool, DDI-L documents and identifies datasets, variables, codelists, and categories • Enables reuse of metadata through unique identification • Variables can share the same code list • Records audit trail through versioning

  4. Colectica for Excel • Free

  5. Colectica for Excel Document Datasets

  6. Colectica for Excel Document Variables

  7. Colectica for Excel Record custom fields

  8. Colectica for Excel Document Code Lists

  9. Colectica for Excel Reuse a code list

  10. Import SPSS and Stata • Import SPSS and Stata • Save labels and descriptions in DDI-L • Import Code Lists • Harmonize code lists

  11. Publish Documentation • Generate Code books from Excel • PDF, HTML, XSL-FO • Publish DDI 3.1 XML

  12. Demonstration Demonstration

  13. Colectica for Excel - vNext Available now with Colectica 4.1 Allow importing already existing code lists and variable descriptions Colectica for Excel SDK to allow programmatic generation of documented spreadsheets

  14. Thank you

More Related