Slide 1

Slide 1 text

TRJFP Data Plans Robin Lovelace, University of Leeds. Created with open source software Slides: speakerdeck.com/robinlovelace

Slide 2

Slide 2 text

1: Context

Slide 3

Slide 3 text

Academic paper on TRJFP

Slide 4

Slide 4 text

No content

Slide 5

Slide 5 text

No content

Slide 6

Slide 6 text

2: The data See the updated 'master' schema here: http://tinyurl.com/trjfp-data 3 main tables: Cafe, Donation and Intercept

Slide 7

Slide 7 text

tblCafe ● Basic info on cafes: – Name – Location – Created – Closed – Contact?

Slide 8

Slide 8 text

tblDonation ● Daily totals: – Donations – Belies – Date – N. people? – Other stuff?

Slide 9

Slide 9 text

tblIntercept ● Biggest table – Type of food – Grams – Barcode? – Comments?

Slide 10

Slide 10 text

Take a look and modify this table: http://tinyurl.com/trjfp-data

Slide 11

Slide 11 text

3: 'Front end'

Slide 12

Slide 12 text

What platform?

Slide 13

Slide 13 text

4: 'Back end'

Slide 14

Slide 14 text

5: How will it work Front end Cafe manager Cafe manager Back end database (in CDRC) Data flow All data back to TRJFP Online infographics TRJFP analysis Some data 'open access' for research Data manager Data manager Data manager

Slide 15

Slide 15 text

Data manager job ● See https://github.com/Robinlovelace/trjfp-paper/blob/mast er/data-manager-jd.Rmd ● ● Essential: Database management skills ● System administration experience, including maintaining an up-to-date list of usernames and passwords for outlets ● Ability to work with people from a range of backgrounds (technical and non-technical) to ensure understanding and correct use of the database