Welcome to the new TAN website! Please visit often as we add training resources and let us know if you have a resource to contribute.

Working With Data

Data Management

Basics Of Data Collection

The process of planning the research involves the data selection, collection, analysis, and ensuring that any data collected is reliable and credible.

Ten Guiding Principles for Data Collection, Storage, Sharing, and Use. (2014, March 5). https://www.cdc.gov/nchhstp/programintegration/tenguidingprinciples.htm
Simister, N., & Garbutt, A. (2017). Principles of Data Collection. https://www.intrac.org/wpcms/wp-content/uploads/2017/01/Principles-of-data-collection.pdf

Best Practices Of Dataset Management

Involves the process of organizing data in a manner that anyone would be able to understand the data.

The Department of Health Sciences Research. Data Collection Basics: A Mayo Resource. https://www.mayoclinic.org/~/media/330446EEF8C94D559779E8B1087FF8C8
Smithsonian Library. (2018, February 28). Research Data Management Best Practices . https://library.si.edu/sites/default/files/pdf/rdm_best_practices.pdf

Analyzing Data

Analysis of statistical data

Statistics in SPSS
- - https://youtu.be/TZPyOJ8tFcI
Statistics in SAS
- - https://video.sas.com/category/videos/how-to-tutorials

Cleaning A Dataset

Is making the data more condensed and clear, ensuring that the data is corrected before analyzing it, and continuously double-checking to ensure the correct information is presented.

Xiong, A., & Vaz, R. (2019, August 21). How to Clean Your Data: Best Practices for Data Hygiene. RSS. https://www.grantbook.org/blog/how-to-clean-your-data-hygiene-best-practices
Broeck, J. V. den, Cunningham, S. A., Eeckels, R., & Herbst, K. (2005, September 6). Data Cleaning: Detecting, Diagnosing, and Editing Data Abnormalities. PLoS Medicine. https://www.ncbi.nlm.nih.gov/pmc/articles/PMC1198040/

Basic Statistical Analyses

Ensuring that the data is correct and making the data presentable.

Lang, T. A., & Altman, D. G. Basic Statistical Reporting for Articles Published in Biomedical Journals: The “Statistical Analyses and Methods in the Published Literature” or The SAMPL Guidelines.” http://hvt-journal.com/docs/author_corner/SAMPL-Guidelines.pdf
Ali, Z., & Bhaskar, S. B. (2016, September). Basic statistical tools in research and data analysis. Indian journal of anaesthesia. https://www.ncbi.nlm.nih.gov/pmc/articles/PMC5037948/

Working With Spreadsheets

Programs often used to create spreadsheets

Google Sheets

Creates data that pop with colorful charts and graphs. Has built-in formulas, pivot tables and conditional formatting.

https://youtu.be/Rus4buFP_a4 - tutorial on how to start off in google sheet
https://youtu.be/vTMuQOMDPgQ - how to use different math functions in google sheets
- - Common google sheets functions: https://youtu.be/mRHlvRRERgs

Excel

Often used for more complicated formulas or spreadsheets.

https://youtu.be/Jl0Qk63z2ZY - common formulas (addition, subtraction, etc.)

Working With Surveys

Platforms are often used to create surveys or questionnaires.

Google Forms

Used to manage event registrations, whip up a quick poll, create a pop quiz, and surveys.

https://youtu.be/wQ7jNpwdWDs - tutorial on how to create a form

Redcap

Used for building and managing online surveys and databases.

https://redcapinfo.ucdenver.edu/redcap-videos.html - videos on how to create surveys

Page updated

Report abuse