Student Data Collection (SDC) Process EQAO Grade 9 Assessment of Mathematics

Data Definitions

 

Reference

Number

Field Name

Field Name Definition

(Blue text describes location of the data in Maplewood)

Null
Value

Allowed

Values

Value
Definition

Variable

Format

1

ProjectCode

Grade 9 Assessment of Mathematics, Winter and Spring 2016

Not allowed

G9W_17

2017 Winter Assessment

Text (6)

G9S_17

2016 Spring Assessment

2

SchMident

Ministry-assigned identifier for the school; File, School Setup, School Information; School Info tab.

Not allowed

 

 

Text (6)

3

 FirstName

Student’s first name; Student Records, Biographics tab, Name.

Not allowed

 

 

Text (50)

4

 LastName

Student’s last name; Student Records, Biographics tab, Name. Note: legal surname is used if it exists.

Not allowed

 

 

Text (50)

5

DateofBirth

Student's date of birth;  Student Records, Biographics tab, Birth Date

 

Not allowed

#

 

Missing/Unknown

 

YYYYMMDD

 

6

StudentOEN

Ministry-assigned Ontario Education Number; Student Records, Enrolment tab, Edit, OEN Number.

In Maplewood, this means - If school has a funding type of "private" and an OEN has not been assigned to a student, -then a '#' will be sent in the OEN field.

Not allowed

#

For use only by

schools not

required by the

ministry to assign

OENs.

Text (9)

7

SASN

Board- or school-assigned student identification number; Student Records, Biographics tab, Name, Student Number.

Allowed

 

 

Text (9)

8

StudentType

This student is home-schooled, enrolled in a Section 23 program, an adult student, a mature student, enrolled in an E-learning course, participating in an independent or private study course or to be issued an OSSD by the Independent Learning Centre.

Please see "Accounting and Reporting EQAO Results for Student with Unique or Special Circumstances" for information on who to include in these categories.

 3 (Adult) will be sent  if student age = 18 or older, and Mature flag is NOT checked
4 (Mature) will be sent if student age = 18 or older, and Mature flag IS checked
5 (E-learning) will be sent if Math Class that the student is enrolled in has a course type of 'E-Learning'
6 (Independent or private study) will be sent if Math Class that the student is enrolled in has a course type OR a DELIVERY TYPE of 'Independent Study' Note: a course type of E-learning over-rides Independent Study

All other cases, student type will be defaulted to '#' - N/A

Note: Use value "5" only for students enrolled in an e-learning course who do not reside within the jurisdiction of the school board offering the course.

Note: Only the values "#," "3" and "4" may be submitted by independent schools.

Not allowed

#

Not applicable

Text (1)

1

Home-schooled (for school boards only)

2

Section 23 (for school boards only)

3

Adult

4

Mature

5

E-Learning (for school boards only)

6

Independent (for school boards only)

7

Independent Learning Centre (for school boards only)

9

Permanent Residence

The student’s permanent residence is outside Ontario; In order to populate this field, Maplewood will look at permanent address tab and if province is not ON or Ontario, then "1" will be sent. Note: If Permanent Address tab is empty, then Maplewood will look at the student address tab..

Not allowed

#

No

Text (1)

1

Yes

10

StatusInCanada

Legal status of the student in Canada

Student, Enrolment, Citizenship field.
Allowable entries are:
# Missing/Unknown (only sent if Citizenship field is left blank/null)
1 Canadian Citizen (maps to OnSIS code 1)
2 Permanent Resident (maps to OnSIS code 3)
3 Refugee Status (maps to OnSIS code 7)
4 Student Visa (maps to OnSIS code 4)
5 Other Visa (maps to OnSIS code 5)
6 None of the above (maps to all other entries. i.e. OnSIS code is NOT 1,3,4,5, or 7)

Not allowed

#

Missing/Unknown

Text (1)

1

Canadian Citizen

2

Permanent Resident

3

Refugee Status

4

Student Visa

5

Other Visa

6

None of the above

11

Aboriginal Type


In accordance with the board’s policy for voluntary, confidential Aboriginal student self identification, this Aboriginal student has voluntarily self-identified as

• a First Nation student who lives in the jurisdiction of and attends a provincially funded elementary or secondary school or who lives in a First Nation community and attends a provincially funded elementary or secondary school under a tuition agreement;

• a Métis student who attends a provincially funded elementary or secondary school or

• an Inuit student who attends a provincially funded elementary or secondary school.

 

Note: Only the value "#" may be submitted by independent schools.

For the field 'AboriginalType', independent schools must submit a value of #. Maplewood will look at the school type (under school Information, Configuration tab. If school type = private, then # will be sent).

 

For publicly funded schools, Aboriginal Type information will be populated based on what is currently entered in the 'Aboriginal Self ID' field in Maplewood. This field can be found under Enrolment, Edit, Aboriginal Tab, and is a user defined table. To modify this table, select, Students, Custom Fields, Tables, Aboriginal, Aboriginal Self ID.

Not Allowed

#

Not applicable or not

self-identified

Text (1)

2

First Nation

3

Métis

4

Inuit

12

Program

Is this student enrolled in an applied or an academic mathematic program?; The fifth character in the course code determines if enrolled in applied or academic: if 5th character is P, then it’s applied (1) or if it is D, then it’s academic (2).

Not allowed

1

Applied

Text (1)

2

Academic

13

MathTeacher
FirstName

Student's mathematics class teacher's first name; File, School Setup, Classes, Teacher (Teacher Name is editable using Staff, Staff Records,Personal, Name.

Not allowed

 

 

Text (35)

14

MathTeacher
LastName

Student's mathematics class teacher's last name; File, School Setup, Classes, Teacher (Teacher Name is editable using Staff, Staff Records, Personal menu, Name).

Not allowed
  

 

 

Text (35)

15

ClassCode

Student's mathematics class code ID; Course code and section letter (e.g. MPM1Da) of the class in the student’s timetable.

Not allowed

 

 

Text (20)

16

MathClass
When

When is this student's mathematics class held: during the first semester or second semester or over the full year? ; Based on the semesters assigned to the class in File, School Setup, Classes.

Not allowed

1

 

First semester

(winter administration)  

Text (1)

2

Second semester
(spring administration)

3

 

Full year
 (spring administration)

17

French
ImmersionOrExtended

This student is studying mathematics in a French Immersion class; File, School Setup, Classes. If the language of instruction for the math class is French, then code 1 (yes) is in the file.

Not allowed

#

No

 

Text (1)

1

 

Yes

18

 Gender

Student's gender; Student Records, Biographics tab, Edit, Gender.

Not allowed

1

Male

Text (1)

2

Female

19

DateEnteredSchool

Date student entered current school (Record the most recent date of entry). Student Records, Enrolment, Edit, Entry to this School

Not allowed

#

Missing/Unknown

YYYYMMDD

20

DateEnteredBoard

Date student entered current board (Record the most recent date of entry).

Student Records, Enrolment tab, Edit, Entry to this Board

If a student has an entry date to this board then it will be populated in the file. If a student has an Origin Type of Beginner (OnSIS= 37), and entry to this board is blank, then the entry to this school date will be used to populate this field.

If entry date to this board is blank, and student origin type is not 'Beginner' than '#' is sent.

 

Not allowed

#

Missing/Unknown

YYYYMMDD

21

ESLorELD

This student is currently an ESL/ELD learner; Student Records, View Menu, Report Card Details & EQAO Tests, Program tab; for the mathclass, if ESL or ELD is checked, then code 1 (yes) is in the file.

Not allowed

#

No

Text (1)

191

Yes

22

IEP

This student has an Individual Education Plan (IEP); Student Records, View Menu, Report Card Details & EQAO Tests, Program tab; for the math class, if IEP is checked, then code 1 (yes) is in the file. If the box "IEP for all special ed. students" was checked, 1 (Yes) appears if a special education student has an active status and an exceptionality other than Gifted.

 Not allowed

#

No

Text (1)

 

1

Yes

23

IPRCBehaviour

This student has special needs and has been identified as having the following exceptionality: behaviour; Student Records, Special Ed. tab, Edit, exceptionality contains Behaviour (Ministry code 01 in exceptionality table). *

 Not allowed

#

No

Text (1)

 

1

Yes

24

IPRCAutism

This student has special education needs and has been identified as having the exceptionality:

autism spectrum disorders; Student Records, Special Ed. tab, Edit;exceptionality

contains Autism (Ministry code 02). *

 Not allowed

#

No

Text (1)

 

1

Yes

25

IPRCDeaf

This student has special needs and has been identified as having the following exceptionality: deaf or hard of hearing; Student Records, Special Ed. tab, Edit; exceptionality contains Deaf and hard of hearing or Deaf (Alternate Program) (Ministry code 03 or 21). *

 Not allowed

#

No

Text (1)

 

1

Yes

26

IPRCBlind

This student has special needs and has been identified as having the following exceptionality: blind or low vision; Student Records, Special Ed. tab, Edit; exceptionality contains Blind and low vision (Ministry code 08). *

 Not allowed

#

No

Text (1)

 

1

Yes

27

IPRCGifted

This student has special needs and has been identified as having the following exceptionality: giftedness; Student Records, Special Ed. tab,Edit; exceptionality contains Giftedness (Ministry code 06). *

 Not allowed

#

No

Text (1)

 

1

Yes

28

IPRCIntellectual

This student has special needs and has been identified as having the following exceptionality: mild intellectual disability; Student Records, Special Ed. tab, Edit; exceptionality contains Mild intellectual disability (Ministry code 07). *

 Not allowed

#

No

Text (1)

 

1

Yes

29

IPRCDevelopmental

This student has special needs and has been identified as having the following exceptionality: developmental disability; Student Records, Special Ed. tab, Edit;exceptionality contains
Developmental disability

(Ministry code 24). *

 Not allowed

#

No

Text (1)

 

1

Yes

30

IPRCMultiple

This student has special needs and has been identified as having the following exceptionality: multiple exceptionalities Student Records, Special Ed. tab, Edit; exceptionality contains Multiple exceptionalities (Ministry code 10 or 23 Deaf/Blind Alternate Program). *If the student has more than one exceptionality, the individual IPRCCategory tags are set to # (no) and IPRCCategoryMultiple is set to 1 (yes). Note: Exceptionalities are ignored if the special ed status is Inactive.

 Not allowed

#

No

Text (1)

 

1

Yes

31

IPRCPhysical

This student has special needs and has been identified as having the following exceptionality: physical disability; Student Records, Special Ed. tab, Edit; exceptionality contains Physical disability (Ministry code 09). *

 Not allowed

#

No

Text (1)

 

1

Yes

32

IPRCSpeech

This student has special needs and has been identified as having the following exceptionality: speech impairment; Student Records, Special Ed. tab, Edit; exceptionality contains Speech impairment (Ministry code 20). *

 Not allowed

#

No

Text (1)

 

1

Yes

33

IPRCLanguage

This student has special needs and has been identified as having the following exceptionality: language impairment; Student Records, Special Ed. tab, Edit; exceptionality contains Language impairment (Ministry code 05). *

 Not allowed

#

No

Text (1)

 

1

Yes

34

IPRCLearning

This student has special needs and has been identified as having the following exceptionality: learning disability; Student Records, Special Ed. tab, Edit; exceptionality contains Learning disability (Ministry code 04). *

 Not allowed

#

No

Text (1)

 

1

Yes

35

SpecialProvisions
Setting

This English language learner will receive the following special provision: an individual or small-group setting or an individual study carrel; Student Records, View Menu, Report Card Details & EQAO Tests, Grade 9 Assessment tab (editable for gr. 9 students only)

Not allowed

#

No

Text (1)

 

1

Yes

36

SpecialProvisions
Time

This English language learner will receive the following special provision: additional time for the assessment, to a maximum of double the allotted time; Student Records, View Menu, Report Card Details & EQAO Tests, Grade 9 Assessment tab (editable for gr. 9 students only)

Not allowed

#

No

Text (1)

 

1

Yes

37

SpecialProvisions
Breaks

This English language learner  will receive the following special provision: periodic
 supervised breaks; Student Records, View Menu, Report Card Details & EQAO Tests, Grade 9 Assessment tab (editable for gr. 9 students only)

Not allowed

#

No

Text (1)

 

1

Yes

38

Accommodation
Setting

This student with special education needs will receive the following accommodation: an individual or small-group setting or an individual study carrel; Student Records, View Menu, Report Card Details & EQAO Tests, Grade 9 Assessment tab (editable for gr. 9 students only)

Not allowed

#

No

Text (1)

 

1

Yes

39

Accommodation
Seating

This student with special education needs will receive the following accommodation:preferential seating in the assessment room

Student Records, View Menu, Report Card Details & EQAO Tests, Grade 9 Assessment tab (editable for gr. 9 students only)

Not allowed

#

No

Text (1)

 

1

Yes

40

Accommodation

DevicesSetting

This student with special education needs will receive the following accommodation: adaptive equipment (special lighting, special pens or pencil grips or devices for

supporting the student's arm for printing, writing or keyboarding).

Student Records, View Menu, Report Card Details & EQAO Tests, Grade 9 Assessment

tab (editable for gr. 9 students only)

Not allowed

#

No

Text (1)

 

1

Yes

41

Accommodation
Prompts

This student with special needs will receive the following accommodation: prompts for students with severe attention problems.

Student Records, View Menu, Report Card Details & EQAO Tests, Grade 9 Assessment tab (editable for gr. 9 students only)

Not allowed

#

No

Text (1)

 

1

Yes

42

Accommodation
Time

This student with special education needs will receive the following accommodation: additional time, to a maximum of double the allotted time; Student Records, View Menu, Report Card Details & EQAO Tests, Grade 9 Assessment tab (editable for gr. 9 students only)

Not allowed

#

No

Text (1)

 

1

Yes

43

Accommodation
Breaks

This student with special education needs will receive the following accommodation: periodic supervised breaks; Student Records, View Menu, Report Card Details & EQAO Tests, Grade 9 Assessment tab (editable for gr. 9 students only)

Not allowed

#

No

Text (1)

 

1

Yes

44

Accommodation
Signed

This student with special education needs will receive the following accommodation: sign language or an oral interpreter; Student Records, View Menu, Report Card Details & EQAO Tests, Grade 9 Assessment tab (editable for gr. 9 students only)

Not allowed

#

No

Text (1)

 

1

Yes

45

Accommodation
Braille

This student with special education needs will receive the following accommodation: Braille version (contracted or uncontracted); Student Records, View Menu, Report Card Details & EQAO Tests, Grade 9 Assessment tab (editable for gr. 9 students only)

Not allowed

#

No

Text (1)

 

1

Yes (contracted)

2

Yes (uncontracted)

46

Accommodation
LargePrint

This student with special education needs will receive the following accommodation: large-print version; Student Records, View Menu, Report Card Details & EQAO Tests, Grade 9 Assessment tab (editable for gr. 9 students only)

Not allowed

#

No

Text (1)

 

1

Yes

47

Accommodation
Coloured

This student with special education needs will receive the following accommodation: coloured-paper version; Student Records, View Menu, Report Card Details & EQAO Tests, Grade 9 Assessment tab (editable for gr. 9 students only)

Not allowed

#

No

Text (1)

 

1

Blue

2

Green

3

Yellow

48

Accommodation
LPColoured

This student with special education needs will receive the following accommodation: large-print, coloured-paper version; Student Records, View Menu, Report Card Details & EQAO Tests, Grade 9 Assessment tab (editable for gr. 9 students only)

Not allowed

#

No

Text (1)

 

1

Blue

2

Green

3

Yellow

49

Accommodation
Audio

This student with special education needs will receive the following accommodation: audio version (CD) ; Student Records, View Menu, Report Card Details & EQAO Tests, Grade 9 Assessment tab (editable for gr. 9 students only)

Not allowed

#

No

Text (1)

 

1

CD

50

 Accommodation

DevicesPresentation
 

This student with special education needs will receive the following accommodation

(presentation): an assistive technology version (an electronic version [Word, accessible

Word, PDF or accessible PDF] used with technology such as text-to-speech software)

will be available for download from the secure section of EQAO’s Web site.

Student Records, View Menu, Report Card Details & EQAO Tests, Grade 9 Assessment

tab (editable for gr. 9 students only)

Not allowed

#

No

Text (1)

 

1

Yes

51

Accommodation
Recording

This student with special education needs will receive the following accommodation: audio recording of student responses

Student Records, View Menu, Report Card Details & EQAO Tests, Grade 9 Assessment tab (editable for gr. 9 students only)

Not allowed

#

No

Text (1)

 

1

Yes

52

Accommodation
Scribing

This student with special education needs will receive the following accommodation: verbatim scribing of responses;

 

 Student Records, View Menu, Report Card Details & EQAO Tests, Grade 9 Assessment tab (editable for gr. 9 students only)

Not allowed

#

No

Text (1)

 

1

Yes

53

Accommodation
Computer

 This student with special education needs will receive the following accommodation

(response): use of a computer or word processor or assistive devices and technology

(e.g., speech synthesizer, brailler, speech-to-text software or augmentative or alternative

communications systems) for recording responses only.

Student Records, View Menu, Report Card Details & EQAO Tests, Grade 9 Assessment

tab (editable for gr. 9 students only)

Not allowed

#

No

Text (1)

 

1

Yes

54

SpPermTemp
Injury

This student has no IEP but has received the principal's permission for one or more appropriate accommodations because of a temporary injury or condition. The accommodations have been indicated; Student Records, View Menu, Report Card Details & EQAO Tests, Grade 9 Assessment tab (editable for gr. 9 students only)

Not allowed

#

No

Text (1)

 

1

Yes

55

SpPermNew
Student

This student has recently arrived from another school and has no IEP but has received the principal's permission for one or more appropriate accommodations. The accommodations have been indicated; Student Records, View Menu, Report Card Details & EQAO Tests, Grade 9 Assessment tab (editable for gr. 9 students only)

Not allowed

#

No

Text (1)

 

1

Yes