Table of Contents
Tools & Training: Data Organization
Recommended Reading: Data Organization
Tools & Training: Data Analysis
Recommended Reading: Data Analysis
Tools & Training: Data Sharing and Archiving
Recommended Reading:Data Sharing and Archiving
Data Quality and Documentation
Tools & Training: Data Quality and Documentation
Recommended Reading: Data Quality and Documentation
Tools & Training: Data Management Planning
Recommended Reading: Data Management Planning
Related Lynda.com Spreadsheet and Database tutorials
- Excel 2013: Managing & Analyzing DataService Unit: Lynda.com
Location: Online Training
Time: On demand - Office 365: Excel Essential TrainingService Unit: Lynda.com
Location: Online Training
Time: On demand - Excel 2016: Advanced Formulas & FunctionsService Unit: Lynda.com
Location: Online Training
Time: On demand - Excel 2016: Pivot Tables in DepthService Unit: Lynda.com
Location: Online Training
Time: On demand - Cleaning up your Excel 2013 dataService Unit: Lynda.com
Location: Online Training
Time: On demand - Relational Database FundamentalsService Unit: Lynda.com
Location: Online Training
Time: On demand - SQL Essential TrainingService Unit: Lynda.com
Location: Online Training
Time: On demand - Learn [Microsoft] Access 2016: the BasicsService Unit: Lynda.com
Location: Online Training
Time: On demand - Learn [Microsoft] Access for Office 365Service Unit: Lynda.com
Location: Online Training
Time: On demand - [Microsoft] Access 2013 Essential TrainingService Unit: Lynda.com
Location: Online Training
Time: On demand - Relational Database Design with FileMaker ProService Unit: Lynda.com
Location: Online Training
Time: On demand - FileMaker Pro 14 Essential TrainingService Unit: Lynda.com
Location: Online Training
Time: On demand
Spreadsheet and Database Tools
- Data Integration: KarmaKarma is an information integration tool that enables users to quickly and easily integrate data from a variety of data sources including databases, spreadsheets, delimited text files, XML, JSON, KML and Web APIs.
- DataOne Software Tools CatalogSearch for a variety of useful data tools through DataOne's software catalog
- FilemakerBASIC: Licenses for Filemaker for Mac can be renewed (if your department has already licensed it) through Cornell's software licensing. If you need a new license, you can buy a copy through the Cornell Store (https://store.cornell.edu/c-569-other.aspx)
- Microsoft Excel and AccessBASIC: Microsoft Excel and Access are available for Windows computers through Cornell's software licensing program.
- MySQL (free, open source Community version)ADVANCED: MySQL is a popular relational database management system.
- MySQL WorkbenchADVANCED: App for database design & modeling, SQL development and database administration. Works on Windows, Mac & Linux. Requires that you work with MySQL databases.
- National Park Service's Inventory & Management Natural Resource Database TemplateEXAMPLE: Want to see Access in action in the real world? "The National Park Service Inventory and Monitoring (I&M) Program's Natural Resource Database Template (NRDT) is a set of Microsoft Access relational database tables that parks and networks can use to develop applications for capturing natural resource inventory and monitoring data."
- Open OfficeBASIC: Open Office is a free, open source suite of applications (including a spreadsheet app, Calc, and a desktop database app, Base) for Windows, Linux & Mac.
- OpenRefineINTERMEDIATE - ADVANCED: OpenRefine (formerly Google Refine) is a "powerful tool for working with messy data, cleaning it, transforming it from one format into another, extending it with web services, and more."
- SequelProADVANCED: SequelPro is a free, open source app for MySQL database management for Macs. Requires that you work with MySQL databases.
Spreadsheet and Database Training
- Data CarpentryData Carpentry develops and teaches workshops on the fundamental data skills needed to conduct research. Lessons are available for self-guided learning as well.
- Software CarpentrySoftware Carpentry is a site designed to teach graduate researchers basic computing skills. Under the Lessons, section you'll find tutorials on working with spreadsheets, databases using SQL (Structured Query Language) and Access.
- Lynda.comRECOMMENDED: Cornell now has a subscription to this online, self-paced video training site, which has modules on Excel, Access, and many other software tools.
- SkillSoft Online TrainingAll current Cornell students, faculty & staff are eligible for access to SkillSoft online training, which includes modules on Microsoft Office products like Excel and Access and books on Filemaker and MySQL. Request a login at skillsoft@cornell.edu (or call 254-6400; Learning Management) and login at https://cornell.skillport.com/
- CIT TrainingCIT Training offers links to free Microsoft Office tutorials and fee-based workshops, including training on Excel and Access.
