SPSNL Federal Setting Calculation Chart- MAKE A COPY.xlsx

	A	B	C	D	E	F	J
1	Federal Setting Calculation Chart
2	Federal Setting Calculation Chart
3	St. Paul School of Northern Lights
4	St. Paul School of Northern Lights
5	Directions: Insert the total Instructional minutes per day and total instructional minutes per week into gray boxes below. Ranges of minutes will autocalculate. After calculating the time away from peers for your specific student (either per day or per week), plug that number into the ranges to determine Federal Setting.
6							SHORTENED SCHOOL DAY:
7	If Counting minutes PER DAY						To determine a student's federal setting in Minnesota when they are on a shortened school day, you calculate the percentage of special education pull-out time against the student's actual active instructional day(the modified shortened schedule length), rather than the district's standard full-time operational day.
8	Total Minutes per day	0				In the grey box, enter the total minutes per school day.
9	Federal Setting 1 = Between	0	and	0	per day
10	Federal Setting 2 = Between	1	and	0	per day
11	Federal Setting 3 = Between	1	and	0	per day		How to Calculate the Percentage:
12							Find the denominator: Use the total number of educational minutes in the student's actual shortened daily schedule (from their first class to their last class on site, minus lunch).
13							Find the numerator: Total the number of minutes per day the student is pulled out of the general education environment to receive special education services.
14							Divide: Divide the special education minutes by the shortened total daily minutes to get the percentage. Match that percentage to the standard Minnesota Department of Education tiers:
15	If Counting minutes PER WEEK						Setting 1: 0% to 21% of the shortened day in special education.
16	Total Minutes per week	1855				This grey box will auto calcualte, assuming that each day of the week is the same number of minutes. If your school week is not the same minutes for 5 days, you will need to hand enter the minutes for the whole week.	Setting 2: 21% to 60% of the shortened day in special education.
17	Federal Setting 1 = Between	0	and	371	per week		Setting 3: 60% or more of the shortened day in special education.
18	Federal Setting 2 = Between	372	and	1113	per week
19	Federal Setting 3 = Between	1114	and	1855	per week		Rules and Compliance Reminders:
20							The calculation must strictly reflect what is documented in the student's Individualized Education Program (IEP) and the formal shortened-day agreement approved by the IEP team.
21							Do not count push-in/support services delivered inside the general education classroom as "outside" time.
22							Shortened schedules are meant to be temporary and tied directly to disability-related needs, requiring ongoing review by the IEP team
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