Spreadsheet: 01945efe-339d-4ef5-961a-b8ba49925c9e
Sheet: Instructions

Instructions for Bilingual Minutes Calculator |  |  |  |  |  |  |  |  |  | Instructions for Bilingual Minutes Calculator
ELEMENTARY |  |  |  |  |  |  |  |  |  | MIDDLE SCHOOL / HIGH SCHOOL
There are three separate spreadsheets which are based on the type of schedule for the building in |  |  |  |  |  |  |  |  |  | There are three separate spreadsheets which are based on the type of schedule for the building in
which the ELL student is receiving instruction.  Each day begins at 7:30 AM and runs until 4:00 PM |  |  |  |  |  |  |  |  |  | which the ELL student is receiving instruction.  Each day has a tentative bell schedule to demonstrate
The form can be adjusted to other beginning and ending times by simply changing the beginning and |  |  |  |  |  |  |  |  |  | how the calculator works.  Any beginning and ending time can be used whether class periods or pull out
ending time.  Each schedule is broken into 5 minute increments as that is usually the only increment |  |  |  |  |  |  |  |  |  | sessions.  Only enter periods or segments of time when service is being provided on that particular day.
that will work consistently. |  |  |  |  |  |  |  |  |  | All data input should be in the beginning and ending time columns   If there are no beginning or ending times
 |  |  |  |  |  |  |  |  |  | there will be no minutes of service calculated.
You will notice that in the minutes served column there is a formula which produces the minutes |  |  |  |  |  |  |  |  |  | You will notice that in the minutes served column there is a formula which produces the minutes
between two times and that there are 5 minute increments from 7:30AM until 4:00 PM for a total of |  |  |  |  |  |  |  |  |  | between two times and that there are 5 minute increments from 7:30AM until 4:00 PM for a total of
510 minutes.  Keep in mind that the maximum per day average that can be claimed is 360 min/day. |  |  |  |  |  |  |  |  |  | 510 minutes.  Keep in mind that the maximum per day average that can be claimed is 360 min/day.
Limited to 180 minutes for grade K or pre-school. |  |  |  |  |  |  |  |  |  | The formula in the Average Minutes per Day will only produce a result of 360 or less.
The calculator is designed to be used with one individual per sheet, this will make it easier to figure |  |  |  |  |  |  |  |  |  | The calculator is designed to be used with one individual per sheet, this will make it easier to figure
and it will make the verification by the auditor easier also.  Time is computed by deleting the beginning and |  |  |  |  |  |  |  |  |  | and it will make the verification by the auditor easier also.
ending times for which the student IS NOT receiving ELL Services from a ELL teacher or paraeducator.
 |  |  |  |  |  |  |  |  |  | The answer will appear in cell [NAME] and as long as it does not exceed 360 minutes/day that is the
The answer will appear in cell E3 and as long as it does not exceed 360 minutes/day that is the |  |  |  |  |  |  |  |  |  | answer for that student's ESOL minutes for KIDS.
answer for that child's ESOL minutes for KIDS.
 |  |  |  |  |  |  |  |  |  | Which Calculator to use?
Which Calculator to use?
 |  |  |  |  |  |  |  |  |  |  | If the student  has the same exact schedule every day of the week you can use the Daily
 | If the student  has the same exact schedule every day of the week you can use the Daily |  |  |  |  |  |  |  |  |  | Schedule.
 | Schedule.
 |  |  |  |  |  |  |  |  |  |  | If the student has a different schedule on different days but the same schedule every
 | If the student has a different schedule on different days but the same schedule every |  |  |  |  |  |  |  |  |  | week, then use the Weekly Schedule.
 | week, then use the Weekly Schedule.
 |  |  |  |  |  |  |  |  |  |  | If the student has a different schedule on different weeks use the Two Week Schedule
 | If the student has a different schedule on different weeks use the Two Week Schedule |  |  |  |  |  |  |  |  |  | or the Three Week Schedule depending on the cycle the building is on.
 | or the Three Week Schedule depending on the cycle the building is on.
 |  |  |  |  |  |  |  |  |  | Notes to completion of the Calculator.
Notes to completion of the Calculator.
 |  |  |  |  |  |  |  |  |  |  | Use the students first and last name
 | Use the students first and last name |  |  |  |  |  |  |  |  |  | The KIDS ID number should be the STATE NUMBER
 | The KIDS ID number should be the STATE NUMBER |  |  |  |  |  |  |  |  |  | Use teacher or para educators first and last name.
 | Use teacher or para educators first and last name.