1 / 14

Colectica for Excel: Using DDI Lifecycle with Spreadsheets

Colectica for Excel: Using DDI Lifecycle with Spreadsheets. NADDI 2013. 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. DDI Lifecycle.

chul
Download Presentation

Colectica for Excel: Using DDI Lifecycle with Spreadsheets

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