Epic: data model documentation

[hellafitz]

Draft visual documentation of our current data model.

Resources/references from Gunner: "the first and third are likely most germane, second one is a bit arcane:

Data Flow diagram tutorial (detailed with examples) https://www.visual-paradigm.com/tutorials/data-flow-diagram-dfd.jsp There's a lot of content on youtube as well.

Tidy data Wickham, Hadley (20 February 2013). "Tidy Data" (PDF). Journal of Statistical Software. http://vita.had.co.nz/papers/tidy-data.html and a bit more accessibly: https://cfss.uchicago.edu/notes/tidy-data/

Worth scanning the wikipedia article for some nomenclature https://en.wikipedia.org/wiki/Data_model

[hellafitz]

data collection points (rough draft): login | account creation /registration | pre-survey | curriculum activity [Google Analytics activity tracking] | submission | post-survey

Judging: scoring --> score data Educators: voluntary impact survey

TF specific: DCs Lessons UGC (user generated content): Uploads, comments, photos, videos

[hellafitz]

Team questions:

• who is the audience? what level of abstraction? how does this get used?
• what is the question that this document will help us answer? (e.g. how is data collected in surveymonkey connected to the platform?)
• what are the biggest unknown Qs that Assessment would like to answer?

[stenington]

Having slept on it, here's a first stab at something: https://projects.invisionapp.com/freehand/document/cAOchKI28

It takes the sites/platforms map as a starting point and tries to decorate it with info on who logs in where, and what kind of data gets stored in what database or 3rd party service.

[stenington]

@hellafitz The invision board above is my straw man proposal for data model documentation. I don't expect it does what you want it to do, but maybe it provides something concrete to start pulling apart.