My thoughts from early August, to Claire: 

For the software thing, I think your suggestion of showing how to do things in R and Sheets is good. As I think about this event, though, I'm starting to think that the teachers will be a lot less receptive to being taught to type R commands (or work through a similar worksheet for Sheets) than our outreach students were. (Perhaps I am extrapolating too far from Penny Green's email -- she didn't mention any interest in data or data analysis at all.) I think we'll have to do more listening and moderating discussion, and spend more time on "what could students do with data? what kind of questions can be addressed with data analysis? what are the main skills students should consider acquiring?" than I thought.

Here's my suggestion. We can break the process of using data in research (once you have a topic and a general research question) into three parts:
(1) getting the data (data sources, downloading, possibly merging)
(2) making simple plots
(3) regression   

Your memo on where to find data will be really useful for (1). Could we demonstrate with the Brexit data? Where did you get it? Did you have to do any merging?

For (2), we can show some plots and how we would make them in R and/or Sheets, with a collection of resources they could give to their students for each.

For (3), I can give a short lecture about what a regression is and why you would do it, and then we can have our participants talk about regressions that could be interesting in the Brexit data and maybe do some of them and talk about the results. 

So if this is the plan, what would be most helpful to me (in addition to an account of where/how you assembled the Brexit data) is your help in locating some more resources that we can give to our participants, which they would then give to students. In particular, locating good tutorials/videos about
-- what regression is in general 
-- how to do regression in Sheets and R
-- making plots in Sheets and in R
-- merging data in Sheets and in R
Also (if we still have some of your time left over), I'd like you to document the steps to take our Brexit data and turn it into one scatterplot and one multivariate regression in R and Sheets.

If the interactive plots thing makes sense for my lecture then I will use it, but I'm just really wary of taxing our participants with a bunch of typing in R.



So to do now: 
-- a reading or two to send them
-- a plan for the day
	-- 11-11:40 introduction, going around and hearing about people's experiences
	-- 11:50-12:45 uses (and abuses) of data
		A couple examples. Brexit, and school workforce structure
	-- 1:30-2:30: where to get it, how to handle it, making simple plots
	coffee break
	-- 2:45-3:30: regression
	-- 3:30-4:00: wrapping up/feedbaclk
	

	
This is the password for what? 	
L1ttleRu55ell



-- 10-10:40 brief introduction from us, going around and hearing about teachers' experiences with EPQs
-- 10:40-12 How could data be used in an EPQ? 
	Two examples: Brexit (Andy) and academisation (Nick), plus discussion
Lunch: 12-1:15
-- 1:15-2:15 Guiding students on accessing, managing, and displaying data  (Nick)
-- 2:15-3:15 Regression  (Andy)
Coffee
-- 3:30-4:00 Wrap up and feedback


edits on Claire:
data into sheets: open, and then upload
"command" to highlight two columns
maybe clean the data beforehand. 

find and replace -- control F doesn't do it for me. 

able to do the regression without "remove blank rows"




OK so now how about the collecting of data?


merge values is an add-on in Google sheets. 

let's get some of this data 


OK annoyingly hard to reconstruct what she did. 

  

here is marital status: 
https://www.ons.gov.uk/peoplepopulationandcommunity/populationandmigration/populationestimates/datasets/populationestimatesbymaritalstatusandlivingarrangements



https://www.ons.gov.uk/peoplepopulationandcommunity/populationandmigration/populationestimates/bulletins/2011censuskeystatisticsforenglandandwales/2012-12-11/relateddata



whole lot of stuff from the 2011 census 


Import rather than open => insert new sheet 

OK but these excel spreadsheets have lots of stuff in them. 

using Power Tools: 

Data -> Merge sheets -> pick the sheet you want to merge from and to, "main table columns", "lookup columns"

And you can just add a trendline in the chart editor



OK so what I can do: I can download the data from the links I found: 

brexit results 

https://www.electoralcommission.org.uk/find-information-by-subject/elections-and-referendums/past-elections-and-referendums/eu-referendum/electorate-and-count-information

census data by local authority

https://www.ons.gov.uk/peoplepopulationandcommunity/populationandmigration/populationestimates/datasets/2011censuskeystatisticsforlocalauthoritiesinenglandandwales

get country of birth

then show how to merge in sheets