Proposal

• Beyond the Spreadsheet: Information Management for GCRC Investigators
• GCRC homepage

CELO implementation

• DataStore Home
• All Families (Top Nav)

Meeting Summaries

• 2006Aug15.txt - meeting at Children's with Sharon and Alice (DOC)
• 2006May26.txt - meeting at Westlake with everyone

Requirements

• Sally Lee Report

Data Models

• Data Model Explanation (DOC)
• Mapping from spreadsheet to data model

Figure 1: Graph Visualization of Schema v.1.3

Figure 2: Extended Schema (v.1.2)

Toolkits for management of local data

• See separate ToolKits page

---

CELO Data import notes

TRACKING

• perhaps demographic info should be split from what needs to be seen (FS_ID, PLE_ID?)
• Rows 222-226 have weird prefix (NRP,NRM,NRF)--are these NOP? Should they be A?
• marker C is "child" and B is biological parent of C
• "Birth Order" and "Age at Onset" are not always numbers ("1 or 2", "<15?");
• disease state: clean "No" text from a few of these columns, also some numbers (37A in H169 has "38197"??)

INVENTORY

• placeholders should be made for samples w/o inventory locations: hair, fingernails, N/R (verified at Aug15 meeting)

SLEDAI

• 'nd' means the same as blank (verified at Aug15 meeting)

Initial Evaluation

• Evaluation of version 1 of CELO with Stevens lab data, as compared against Spreadsheet, Fall 2007- Winter 2008
• Evaluation plan
• Evaluation form requesting expectations
• Consolidated list of responses
• Responses grouped according to a concept map