This short workshop will cover techniques for using Excel productively. It will introduce you to functionality such as Advanced Formulas, Data Tables & Conditional Formatting, Charting, Pivot tables and Macros and VBA programming. Use of these excel features will help you to analyze, visualize and gain insights from your data.
Ever wonder how to get more out of your PDF files? This short course will show how to optimize PDFs for both search engines and searchers, techniques for handling common problems when creating PDFs and methods for exporting content.
Do you have texts but need a table? Do you have raw data but need to organize it? This workshop will cover techniques to clean, append, parse and analyze your data using advanced excel features and formulas. Learn simple methods for converting and modifying textual data into a tabular format.
For more data workshops, please see http://researchdata.rice.edu/training/.
Introduction to using spreadsheets for beginners or a refresher for the sometime user. Covers basic features and options of Microsoft Excel, including how to organize and navigate tabular data, creating and using simple formulas, formatting worksheets and other helpful tips.
Tableau is a fast rising and award-winning visualization software tool in Business Intelligence (BI) and Analytics Platforms. It helps people see and understand data. In this short course, we will cover the following topics:
• What is Tableau?
• What can Tableau do?
• Why is Tableau so successful in BI in recent years?
The hands-on part will cover how to use Tableau Public, the free version of the software. Specifically, we will use a small set of DMC equipment circulation data as an example. We will cover:
To reach potential employers, collaborators, students and readers, academics need to establish and maintain a compelling web presence. This hands-on workshop will explore how to develop such a online profile, including:
creating a cohesive online presence
sketching out an academic website
Would you like to better manage software versions and collaborate with other researchers? GitHub is a widely-adopted code repository that supports collaboratively developing software and other text-based projects. This hands-on workshop will introduce participants to the basics of GitHub, such as setting up GitHub, creating a branch, and committing changes. We will also look at a few examples of how researchers are using GitHub. Please bring your laptop!
Please see http://researchdata.rice.edu/training/ for the latest update, 8/23/2017.
Drowning in data? Not sure how to organize and back it up? This hands-on, interactive workshop will share tips for effectively organizing, documenting and storing research data. Participants will walk away with ideas for completing a data inventory and data storage/ backup plan for their own data, as well as tips for writing data management plans (as required by many grant agencies).
Note: This short course is not offered this semester. If you are interested in taking it, email firstname.lastname@example.org.
By using text analysis tools, we can explore patterns and anomalies across thousands of texts--or in a single document. This hands-on workshop will provide a basic grounding in text analysis, focusing on: