An open-source web-based data collection system for ERCs

1. An open-source web-based data collection system for ERCs Kevin Costa Administrative Director, SynBERC AD summer retreat June 23 2011

2. AD database working group Purpose: Create a set of tables that can be used for data collection and center management • Useful for new ERCs, either as starting point or off-the-shelf solution • Optional/augmentational for existing centers • Important to QRCweb development (2011) • Reduce duplicate entry • Web and Excel friendly • Doesn’t encompass financials • Provides audit trails • Serve as reference point between NSF and centers for clarifying what we’re reporting • Discussion/suggestion of data collection system to meet NSF requirements • Useful for center management purposes • Project review, annual reporting, web content management, financial dashboard • Provision for annual refresh • Forward looking: Developing a one size fits all system

4. Fed Gov State Gov Local Gov Quasi Gov Res Org Industry Industry Assoc. Medical Facility Private Foundation Non-Profit Consulting Firm Other Lead institution Core partner Collaborating inst Non ERC prov REU Pre-college partner Foreign partner Community college Core project Sponsored project Associated project Industrial/practitioner member Contributing organization Affiliated organization Funders of associated projects Innovation partner Small business supported by ERC translational research Has predominantly female students Has predominantly underrepresented minority students n/a Sm (<500) Med (500-1000) Lg (>1000)

5. synberc.org

23. Now what? • Roll-out to new existing centers • Import is a challenge • QA • Documentation • Interface with QRC (.xls output) • Sandbox version for general use? • Feedback and improvements • Need a strong process • Financials • FTE as a means for connecting people:effort:project • Set up a page of resources/users