Data Analysis Template.xlsx

	A	B	C	D
1	Cornerstone Communities Data Analysis Template This template is for use in conjunction with the Cornerstone Communities Data Analysis written Playbook. With thanks and credit to Kaitlyn Ashmore from Wilfrid Laurier University who led the research for this process as part of the Canadian Government's Mitacs scheme.
2
3
4	KEY TO SECTIONS AND TABS:
5	Section	Tab	Steps	Description
6	Raw data	WS1 EX1	1	Space to input data from Exercise 1 of Workshop 1
7	Raw data	WS1 EX2	2	Space to input data from Exercise 2 of Workshop 1
8	Raw data	WS1 EX3	3	Space to input data from Exercise 3 of Workshop 1
9	Raw data	WS1 FF	4	Space to input data from Faciliator Feedback Form from Workshop 1
10	Raw data	WS2 EX1	5	Space to input data from Exercise 1 of Workshop 2
11	Raw data	WS2 EX2	6	Space to input data from Exercise 2 of Workshop 2
12	Raw data	WS2 FF	7	Space to input data from Faciliator Feedback Form from Workshop 2
13	Raw data	Questionnaire	8	Space in input data from the questionnaire responses
14	Coding	Coding Scheme	9	Setting up a scheme to code your raw data
15	Coding	Coding Workspace	10	Categorising your raw data using the coding scheme
16	Coding	Coding Counts	11	Summing up the repeating codes
17	Identifying	Headline Themes	12	Identifying the headline themes from the data
18	Identifying	Factors & Dimensions	13	Identifying the factors that contribute to the themes and measurable dimensions of those factors
19	Identifying	Metrics	14	Identifying existing metrics that represent your dimensions
20	Outputs	Outputs	15	Creating a summary sheet of the outputs that will be needed for Module 3 (Indicator Design)
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100