Effectively Managing And Sharing Research Data In Spreadsheets

Key Info
Description - a brief synopsis, abstract or summary of what the learning resource is about: 
Regardless of discipline studied or methods used, it is likely that researchers use some sort of spreadsheet application (e.g. Excel, Google Sheets) to investigate, manipulate, or share research data. Though spreadsheets are easy to exchange with other researchers, difficulties can arise if sharing and preservation are not adequately considered. Join JHU Data Management Services for our online training course, “Effectively Managing and Sharing Research Data in Spreadsheets”. NOTE:   You will be required to login to Blackboard to use the resources, but can do so as a guest.  

We will cover spreadsheet practices that can:
1-Increase the possibility research data contained in spreadsheets can be re-used by others (and you) in the future, and
2-Help to reduce the chance of error when using spreadsheets for data acquisition.

-Introduction (7 mins lecture and 1 min demo)
-Prior to Data Collection (7 mins lecture)
-Track Versions and Provenance (5 mins lecture and 15 mins demos)
-Data Quality Control (10 mins lecture and 9 mins demos)
-Documenting Data, Values, and Variables (9 mins lecture and 14 mins demos)
-Data Sharing for Spreadsheets (9 mins lecture and 6 mins demos)
-Using Other People’s Spreadsheet Data (8 mins lecture and 35 mins demos)
-Resources (4 mins lecture and 53 mins demos)


Authoring Organization(s) Name: 
Johns Hopkins University Data Management Services
License - link to legal statement specifying the copyright status of the learning resource: 
Creative Commons Attribution-NonCommercial 4.0 International - CC BY-NC 4.0
Access Cost: 
No fee
Primary language(s) in which the learning resource was originally published or made available: 
More info about
Keywords - short phrases describing what the learning resource is about: 
Data documentation
Data management
Data quality
Data reuse - Core Trustworthy Data Repositories Requirements
Data sharing
Publisher - organization credited with publishing or broadcasting the learning resource: 
Johns Hopkins University Data Management Services
Media Type - designation of the form in which the content of the learning resource is represented, e.g., moving image: 
Interactive Resource - requires a user to take action or make a request in order for the content to be understood, executed or experienced.
Educational Info
Purpose - primary educational reason for which the learning resource was created: 
Professional Development - increasing knowledge and capabilities related to managing the data produced, used or re-used, curated and/or archived.
Learning Resource Type - category of the learning resource from the point of view of a professional educator: 
Course - series of units and lessons used to teach the skills and knowledge required by its curriculum.
Target Audience - intended audience for which the learning resource was created: 
Citizen scientist
Data professional
Early-career research scientist
Graduate student
Mid-career research scientist
Research faculty
Research scientist
Undergraduate student
Intended time to complete - approximate amount of time the average student will take to complete the learning resource: 
More than 1 hour (but less than 1 day)