ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACAD
1
K-12 STEM VIRTUAL FIELD TRIPS WITH LESSON PLANS

To recommend additional resources or report problems with this spreadsheet please contact CESE@FGCU.EDU
2
3
INSTRUCTIONS FOR USING THIS SPREADSHEET
4
1. To begin, select the sheet for your grade level.
5
2. TO SORT BY COLUMN HEADER (this only changes your view, not the view of others)
-Within the sheet, you want to filter, select Row 5 by clicking on the number '5' in the left column. That selects the row you want to filter by.
-Leaving that row selected, look in the top menu area and to the left of the green button for 'View only', then find the little icon for a filter (looks like a funnel).
-Click the small dropdown arrow to the right of the filter icon, then select 'create new temporary filter view'. This should highlight the entire sheet and within the column headers (i.e. grade, standard) you will see drop-down arrows.
-Click a dropdown arrow within the column you want to use to filter, then choose an option such as 'Sort A -> Z' which will then alphabetize that by that column.
-If you want to reset and start anew, select 'none' and it will remove the filter and revert to the original view.
6
3. You can also search the Sheet my typing 'Contol F' which open a text box where you enter your search terms.
7
8
UPDATES TO SHEETS
9
April 3, 2020: added column ot display date each entry added to spreadsheet. Users can sort by date to see whats new
10
September 28, 2020: Page verified
11
12
13
14
15
16
17
18
19
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