Data Management and Sharing Online Training


Online Training Courses

Effectively Managing and Sharing Research Data in Spreadsheets 

(8 modules, with 60 mins lectures and 60 mins demos)

Regardless of discipline studied or methods used, it is likely that researchers use some sort of spreadsheet application (e.g. Excel, GoogleSheets) 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”. 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.

Modules

 

  • 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)

Demos

 

  • Install Office 2016 (1 min)
  • View Version History in GoogleSheets, JHBox, OneDrive and Dropbox (2 mins)
  • Excel Add-in: Spreadsheet Inquire (13 mins)
  • Data Validation in Excel and GoogleSheets (3.5 mins)

 

  • Excel Add-in: Pivot Table (5.5 mins)
  • Excel Add-in: Colectica (9 mins)
  • OntoMaton in GoogleSheets (5 mins)
  • Use Open Refine to Clean Up Data (21.5 mins)

**** Public module (Don’t require BlackBoard login to access) ****

Many research projects depend on the development of scripts or other software to collect data, perform analyses or simulations, and visualize results.  Working in a way that makes it easier for your future self and others to understand and re-use your code means that more time can be dedicated to the research itself, rather than troubleshooting hard-to-understand code, resulting in more effective research. In addition, by following some simple best practices around code sharing, the visibility and impact of your research can be increased.  In this introductory session, you will:

  • learn about best practices for writing, documenting (Documentation), and organizing code (Organization & Automation),
  • understand the benefits of using version control (Version Control & Quality Assurance),
  • learn about how code can be linked to research results and why (Context & Credit),
  • understand why it is important to make your code publishable and citable and how to do so (Context & Credit),
  • learn about intellectual property issues (Licensing),
  • learn about how and why your software can be preserved over time (Archiving).

**** Download the DMP Questionnaire first before you begin this course ****

Grant proposals for a growing number of funders require data management plans, including the National Science Foundation. Developing a competitive data management plan requires understanding and effectively addressing the many aspects of research data management that funders and reviewers emphasize (e.g., plans for research data security, sharing, and documentation). Join Data Management Services online for a training session on preparing data management plans. During this one-hour online training, we will cover the research data questions one should answer in creating an effective, competitive plan. The following topics will be covered in our training modules.

 

  • Introduction to Data Management Planning (11 mins)
  • How to Use the DMP Questionnaire (8 mins)
  • Data Products (3 mins)
  • Documentation and Metadata (6 mins)
  • Storage and Backup (7 mins)

 

  • Security and Access Control (3 mins)
  • Long-term Preservation (4 mins)
  • Why (Not) Share Data? (6 mins)
  • Elements for Sharing (7 mins)
  • Resources for Writing a DMP (4 mins)

How to Access Online Training via BlackBoard?

JHU Data Management Services uses BlackBoard to manage our online training courses. You will need to log into BlackBoard system first in order to access course materials, unless it is marked as a public module.


If you are affiliated with JHU and have a JHED login ID and password, please follow the instruction below to enroll and view these courses:

Step1: Login to Blackboard one time with your JHED ID and password.
Step2: Click this self-enroll link to add yourself to the training organization in Blackboard.

If you are an external user, please use the following steps to log in Blackboard as a guest:

Step1: Link to Blackboard log in page.
Step2: Click on the ‘Open Non JHED login’ link, and then enter these credentials in order to login:

Username: jhudms@gmail.com
Password: GuestUser44


Once you have logged in, select a training course that you want to take from the list below and you will be led to a Course Overview page.

Contact us if you have any trouble logging in/viewing our online courses.


Creative Commons License  All online training materials are licensed under a Creative Commons Attribution-NonCommercial 4.0 International License.