Scicomm jobs - list of vacancies pages employing science communicators

	A	C	D	E
1	This is a list of scientific organisations that I've been collecting, and adding to, since 2003	Key
2	It's intended to highlight the range of places that might employ science communicators	Green	Jobs page found
3	If a vacancies page link dies you can often find where it's moved by searching for any of these words / phrases	Orange	Jobs page not found, given homepage
4	jobs, vacancies, working for us, work with us, careers, opportunities, job vacancies, recruitment	Blue	Page is a jobs board for other organisations' jobs
5		Blank	Not checked, or not checked recently
6	If a site has a vacancy page I don't duplicate the homepage, if it doesn't I include the homepage.
7
8	It's easier to add new records at the bottom and then re-order alphabetically by name -	Data validation		How to do Data validation on SECTOR column
9	How to re-order	Government		1. Select Sector column
10	Select (highlight) the column to order by, then Ctrl+A to select whole table.	Learned society		2. Click Data menu, then Data validation
11	Click Data > Sort sheet by column [X], A-Z	Medical research / patient charities		3. Click in Instructions tab
12		Other		4. Click in the box next to 'List from a range
13	See Cell E11 on how to add the drop-down menus to a new sheet, see below on how to filter	Research council		5. Click back into Instruction tab...
14	Ctrl+A to select the whole sheet, click the filter / funnel-shaped icon (looks like a Martini glass), wait.	Resource		... small dialogue box will ask 'What data?'
15	Little blue arrows will appear in every column. Click one or more to select what to display.	Science centre / museum		6. Select C9-C20 (allows for future additions)
16	Click icon again to return to unfiltered state.	University		7. Select the first title cell in Sector column...
17	#N/A	Vacancies pages		... Click Data / Data validation / Remove validation
18
19	Original 2009 blog post from which this resource comes
20
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