Browsing by Author "McGrory, John"

Now showing 1 - 2 of 2
  • No Thumbnail Available
    Item
    Analyzed Data Management Plans (DMPs) from Successful University of Minnesota Grants from the National Science Foundation, 2011-2014
    (2015-03-31) Johnston, Lisa R; Bishoff, Carolyn; McGrory, John; Storino, Chris; Swendsrud, Anders; ljohnsto@umn.edu; Johnston, Lisa R
    Federal funding agencies are asking principal investigators (PIs) to specify their plans for describing, storing, securing, sharing, and preserving their research data in Data Management Plans (DMPs) included with their grant proposal. This change in sponsored research is best exemplified by the National Science Foundation (NSF) which in 2010 announced that all grants submitted after January 18th, 2011 must include a one- to two-page DMP with all new proposals. In order to review the plans for how University of Minnesota researchers plan to manage, store, describe, protect, and share and preserve their data, a review instrument was created and implemented by the University Libraries in the summer of 2014. Our local study of DMPs in successful NSF grant applications from January 2011 - June 2014 was opt-in by U of M PIs and the libraries collected 182 data management plans for our study, accounting for 41% of the total number of plans solicited. The deidentified data used in our analysis and our survey instrument are presented here.
  • Thumbnail Image
    Item
    Poster for "Excel Archival Tool: Automating the Spreadsheet Conversion Process"
    (2015) McGrory, John
    This poster presents the Excel Archival Tool, a script that was created to programmatically convert Microsoft Excel files into open source formats suitable for long-term archival. This is accomplished by using Visual Basic Script to convert Excel workbooks (.xls and .xlsx) into comma-separated value files (.csv), while also extracting charts/figures (in .png images), cell formulas (in .txt files), and formatting/styling information (in HTML snapshots). This tool is most useful for large Excel data sets that would otherwise require large amounts of tedious work to convert manually.