Jen Richmond

@jenrichmondphd.bsky.social

ex-academic, co-founder RLadiesSydney, developer #RYouWithMe, sharer of #rstats learning https://jenrichmond.github.io/

thanks for sharing @ctrl-n.bsky.social , super interested in this question too. When asking about age, what do you do to prevent your participants giving you messy data?

Nathan Jeffery@ctrl-n.bsky.social · 4w ago

I was watching @jenrichmondphd.bsky.social great tutorial on data management and wanted to start a discussion here: When you ask for age in a survey, do you (a) Use an open-text field with validation (b) Use a multiple choice question with age ranges (c) Something else youtu.be/7UxBZxiJGKY?...

I was asked to speak with a graduate class today about research data management. I was asked, "How do people become convinced that beginning data management early on in a project is worth it?" Me: "Suffering. They usual have to suffer first." 😅

Students, if you’re thinking about dropping a note to that teacher or professor about what their class/project/mentorship has meant to you, but you worry it will be cringe or cheesy, let me just tell you they will coast on the fuzzy feelings prompted by that note for months, if not years

I think of the recommendations in this paper a bit like the Twelve Commandments of Spreadsheets... follow them and save yourself HOURS at the other end. We assume that students/researchers know this stuff, but no one has explicitly been taught it. Another hidden curriculum beauty...

Bild
Darren Dahly@statsepi.bsky.social · 5mo ago

Every day is a good day for sharing one of the most useful papers about research data ever written. PLEASE get your people to understand and follow this advice. www.tandfonline.com/doi/full/10....

Data Organization in Spreadsheets
Karl W. Broman
& Kara H. Woo
Pages 2-10 | Received 01 Jun 2017, Accepted author version posted online: 29 Sep 2017, Published online: 24 Apr 2018

    1. Introduction
    2. Be Consistent
    3. Choose Good Names for Things
    4. Write Dates as YYYY-MM-DD
    5. No Empty Cells
    6. Put Just One Thing in a Cell
    7. Make it a Rectangle
    8. Create a Data Dictionary
    9. No Calculations in the Raw Data Files
    10. Do Not Use Font Color or Highlighting as Data
    11. Make Backups
    12. Use Data Validation to Avoid Errors
    13. Save the Data in Plain Text Files

ABSTRACT

Spreadsheets are widely used software tools for data entry, storage, analysis, and visualization. Focusing on the data entry and storage aspects, this article offers practical recommendations for organizing spreadsheet data to reduce errors and ease later analyses. The basic principles are: be consistent, write dates like YYYY-MM-DD, do not leave any cells empty, put just one thing in a cell, organize the data as a single rectangle (with subjects as rows and variables as columns, and with a single header row), create a data dictionary, do not include calculations in the raw data files, do not use font color or highlighting as data, choose good names for things, make backups, use data validation to avoid data entry errors, and save the data in plain text files.