AB
1
4
2
OPTION ONE
3
1.aMake sure that you are logged into your Google Account. (If you don't have a Google Account see OPTION TWO)
4
1.bClick 'File' and select 'Make a copy' (DO NOT 'request access' to this master copy).
If "Make a copy" option is disabled go to OPTION TWO
5
1.cRename and press 'OK' (refer to the video below).
6
7
OPTION TWO
8
2Click 'File' and select 'Download -> Microsoft Excel xlsx.'
You can then upload this Excel file to your schools cloud system, giving your whole school access to the spreadsheet.
9
3Next you need to set up the classes. Each class requires their own tab. If you have 3 Early Years classes, then you need to duplicate each Early Years tab and label them with class names accordingly.
10
4Make sure that split year level classes (e.g Year 1/2 or a Year 5/6) have only 1 tab, as once the test results have been entered the teacher will be required to look at the class as a whole and cluster students into three targeted teaching groups based upon literacy levels, regardless of their year level.) The exception to this is if there are combined Early Years & Foundation classes as the skill sequence it totally different and 2 tabs will be required.
11
5Add in student names from current classlists. (Ideally this can be assigned to admin/reception staff).
12
6Store the tracking sheet in a 'cloud-based' or networked format, that allows multiple users to access and work on the document simultaneously.
13
7Watch video here: https://youtu.be/ocEc9jplkMc
14
8In the 'Notes' column it is possible to add abbreviated notes pertaining to the class e.g. ASD (Autism), ESL, LA (low attendance), SP (receiving speech therapy), GD (Global delay) and low IQ etc.
15
9Remember the tracking sheets are in a format that you can adapt. e.g. Foundation may wish to enter an onset and rime blending column, Early Years may wish to enter a blending three phonemes column and some schools enter another test cycle.