Skip to main content
Skip table of contents

MI Worksheet B

Introduction

This will create the MI Worksheet B report. Use this report to determine Full Time Equivalency (FTE) membership assigned to Basic Classroom Programs as well as a total count of handicapped students by program category and by grade.

Note: If a student transfers between buildings after count day, do not update the teacher on the Special Ed tab of the State/Province-MI page for the student until after the Worksheet B has been printed.

Selection Criteria

Selection criteria determine which database records are used in the report. Refer to selection criteria for analysis when the report does not return the correct records.

Student Selection

The report selects records based on the following criteria:

  • The student is included in state reporting. ([Students]State_ExcludeFromReporting=0)
  • Special Education Student flag is selected. ([S_MI_STU_GC_X]flagSpecEd=1)
  • Student was active on the entered Count Date in the report parameters. ([Students]ExitDate>=Count Date)
  • Student is assigned a Special Education Instructor. ([S_MI_STU_GC_X]seTeacher# )
  • Special Education exit date is blank or greater than the Count Date in the report parameters. ([S_MI_STU_GC_X]seExitDate= ) or ([S_MI_STU_GC_X]seExitDate>Count Date)
  • Section 52 FTE value is greater than zero. ([S_MI_STU_GC_X]FTE52>0)

Report Input

For help with navigation and running the report, see How to Find and Generate a Report.

Field

Description

Count Date

Enter the count date.

District Name

Enter the district name if the proper district name is not displayed.

Report Output

Each of the fields displayed in the output of the report are described below. See Understanding the Report Output Table for a definition of each column in the table.

Item #

Data Element

Description

[Table]FieldName

1

Program Assignment

3-digit Program Assignment code.

This is entered on the Staff > Information page in the SpEd Instructor Program Assignment field.

A Special Education Program Assignment override field is available on the State/Province – MI > Spec Ed tab.

[S_MI_SSF_TSDL_X]specEdPrgmAssign

[S_MI_STU_GC_X]sePrgmAssign

2

Teacher Name

The name of the teacher responsible for instructing the Special Education student.

This value is pulled from the Special Education Instructor field on the State/Province – MI > Spec Ed tab.

[S_MI_STU_GC_X]seTeacher

3

Education District Name

This contains the school district name and is pulled from the District Name parameter on the report input page.

N/A

4

Institution/Building Nursing Home

This contains the building name.

[Schools]Name

5

Section 6 Defined Center Programs: ___Yes ___No

This is available to indicate if this is a Section 6 Defined Center Program.

N/A

6

Educating District Code

This contains the 5-digit state assigned district number. If the number is less than 5 digits, then leading zeros are added.

This field is not on a UI Page and may need to be updated using DDA. The field is a numeric field and does not allow for 5 characters, if the district number should have leading zeroes the field will not accept them, but the report will report with the leading zeroes.

[Schools]District_Number

7

Name of Student

This contains the student's name.

[Students]LastFirst

8

District of Residence

This contains the state-assigned District of Residence code identifying the district in which the student resides.

This value is from the Transfer Info page.

[Students]DistrictOfResidence

[S_MI_STU_GC_X]residentLEA

9

Special Education FTE

This contains the FTE membership value for Section 52. And represents the student's source of State Aid reimbursement.

This field is from the State/Province – MI > Spec Ed tab.

[S_MI_STU_GC_X]FTE52

10

Kindergarten through 12th Grade FTE

This contains the General Education FTE membership value for the student's current grade level. The student's current grade level is from the Transfer Info page.

The General Education FTE membership value is from the State/Province – MI > Spec Ed tab or the State/Province – MI > General Ed 5-19 tab.

[S_MI_STU_GC_X]FTE

11

Alternative Education FTE

A value for this column is not pulled from the system.

N/A

12

Total FTE Column

This is calculated on the report. It is the sum of the Special Education Section 52 FTE and General Education FTE values by student as well as a grand total.

Calculated

[S_MI_STU_GC_X]FTE

[S_MI_STU_GC_X]FTE52

13

Age

This is calculated using the student's date of birth as defined on the Demographics page.

Calculated

[Students]DOB

14

Grand Total Headcount

Total number of students.

Calculated

15

Grand Total of FTE

This row contains the grand total of FTE by grade level as well as an overall grand total.

Calculated

16

Signature: __________

This is the signature line for the teacher to sign.

N/A

17

Date: __________

This is the date line for the teacher to write in a date of verification.

N/A

Back to Top

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.