Valid Assessment Period Worksheet.xlsx

	A	B	C	E	F	G	H
1	Valid Assessment Period Worksheet
2	Use this worksheet to check whether a student's prior assessment will still be valid for a future class. LACES will subtract 230 days from the start of the new Program Year (7/1), or a student's Class Start Date (if after 7/1) to determine whether an assessment is valid and acceptable for use. That means the oldest test record that can move forward is 11/13. You can mirror that process with the worksheet below. This rule applies to assessment records entered manually, uploaded, and carried forward to a new program year.
3	sample
4	Quarter	Test Date After	Class Start Date		Test Date After	Class Start Date
5	Summer	11/13	7/1		5/14/1899		<-- Enter date here
6	Fall	2/4	9/22	Enter your actual class start date in cell G6. There is a formula already entered in the neighboring cell in columnF that will automatically subtract 230 and replace #### with an actual number.
7	Winter	5/20	1/5
8	Spring	8/14	4/1
9
10	Notes • This rule looks for the highest CASAS test or Alternative Assessment within the date range. If assessments are no longer valid or the level is Completed or Exit ESL 6, you must re-assess. • The HS+ Credit Option assessment method remains active as long as the HS+ special program End Date has not passed or is blank. LACES will recalculate a student's entry level each time they re-enter the program. • Think about conducting winter pre-testing sessions on or after 11/13. Choose a later date if your summer classes will start later than 7/1. • Test carry-over for the next program year will not happen until 7/1. So, you will not see any carry-over activity for students in summer classes that start in June until we cross in to the new program year.
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