6.5 Data Warehouse Working Group

The mission of the Data Warehouse Working Group is to lead the definition of the detailed data that schools and parents need to improve student achievement and organizational effectiveness. It will represent to the other SIFA working groups the interests of the school administrators, guidance counselors, teachers, parents and students who can benefit from the analysis of integrated SIF K-12 data.

Click here for non-normative background/supplementary documentation from this group.

6.5.1 AggregateStatisticInfo

This object defines the data that is being aggregated as well as the type of measurement that is being performed.

SIF_Events are reported for this object.

AggregateStatisticInfo
Figure 6.5.1-1: AggregateStatisticInfo AggregateStatisticInfo RefId StatisticName CalculationRule Type ApprovalDate ExpirationDate ExclusionRules ExclusionRule Type Source EffectiveDate DiscontinueDate Location Type LocationName LocationRefId SIF_RefObject Measure SIF_Metadata SIF_ExtendedElements
 Element/@AttributeCharDescriptionType
 AggregateStatisticInfo 

This object defines the data that is being aggregated as well as the type of measurement that is being performed.

 
 
@
key
RefIdM

Key

 
RefIdType
 StatisticNameM

Name of Aggregate Statistic

Examples
Total Enrollment
Diploma Recipients

xs:token
 CalculationRuleO

Rule for calculating the aggregate statistic

 
xs:string
@TypeM values:
Description
Formula
URL
 ApprovalDateO

Date for which the statistic is initially valid

 
xs:date
 ExpirationDateO

Date after which the statistic is no longer valid

 
xs:date
 ExclusionRulesO

Rules for which statistic may not be reported.

 
List
 ExclusionRules/ExclusionRule
     
OR

Rule for which statistic may not be reported

 
xs:string
@TypeM values:
SampleSize
Description
 SourceO

System providing the data: i.e., SIS, Transportation,

 
xs:token
 EffectiveDateO

Effective date of the statistic

 
xs:date
 DiscontinueDateO

Discontinue date of the statistic

 
xs:date
 LocationO  
@TypeM values:
Classroom
School
District
Campus
IntermediateUnit
StateEducationAgency
 Location/LocationNameO

Name of the location

 
xs:token
 Location/LocationRefIdO

RefId of the location object if the location is a SIF object such as SchoolInfo.

 
IdRefType
@SIF_RefObject

Type of SIF object Location points to.

 
values:
SchoolInfo
LEAInfo
RoomInfo
 MeasureO

Type of the statistic.

 
values:
Count
Minimum
Maximum
Percent
Mean
Median
Mode
Sum
StandardDeviation
UnduplicatedCount
FTE
Other
 SIF_MetadataO SIF_Metadata
 SIF_ExtendedElementsO SIF_ExtendedElements
Table 6.5.1-1: AggregateStatisticInfo
<AggregateStatisticInfo RefId="A5DECBD3161B4F5D9F46EBA64C87B002"> <StatisticName>Read Proficiency L1</StatisticName> <CalculationRule Type="Description">Number of students scoring at Reading Proficiency Level 1</CalculationRule> <ApprovalDate>2002-09-01</ApprovalDate> <ExpirationDate>2006-06-30</ExpirationDate> <ExclusionRules> <ExclusionRule Type="SampleSize">N less than 10</ExclusionRule> </ExclusionRules> <Source>SIS</Source> <Location Type="School"> <LocationName>Green River High School</LocationName> <LocationRefId SIF_RefObject="SchoolInfo">279BCEE5515E4C1AAC3A765D1F069BC3</LocationRefId> </Location> <Measure>Count</Measure> </AggregateStatisticInfo>
Example 6.5.1-1: AggregateStatisticInfo

6.5.2 AggregateCharacteristicInfo

This object defines the attribute of a group of objects that implicitly or explicitly defines a subset of the group.

SIF_Events are reported for this object.

AggregateCharacteristicInfo
Figure 6.5.2-1: AggregateCharacteristicInfo AggregateCharacteristicInfo RefId Description Definition ElementName SIF_Metadata SIF_ExtendedElements
 Element/@AttributeCharDescriptionType
 AggregateCharacteristicInfo 

This object defines the attribute of a group of objects that implicitly or explicitly defines a subset of the group.

 
 
@
key
RefIdM

Key for aggregate characteristic information.

 
RefIdType
 DescriptionO

Describes the supercategory of the characteristic described in the Definition element below.

Examples
Gender
Ethnicity
Grade
Economic Status
LEP Status
IEP Status
Migrant Status

xs:string
 DefinitionM

Defines the aggregate characteristic information.

Examples
White
Male
Dropout

xs:token
 ElementNameO

Reference to SIF elements or external authority (e.g., StudentPersonal/Gender).

Examples
Dropout Status

xs:token
 SIF_MetadataO SIF_Metadata
 SIF_ExtendedElementsO SIF_ExtendedElements
Table 6.5.2-1: AggregateCharacteristicInfo
<AggregateCharacteristicInfo RefId="06AF1D69FB064AB388983505714F18FB"> <Description>Ethnicity</Description> <Definition>Hispanic</Definition> <ElementName>StudentPersonal/Demographics/Ethnicity</ElementName> </AggregateCharacteristicInfo>
Example 6.5.2-1: AggregateCharacteristicInfo

6.5.3 AggregateStatisticFact

This object is the actual value of the measurement. It is always associated with one statistic and one or more characteristics.

SIF_Events are reported for this object.

AggregateStatisticFact
Figure 6.5.3-1: AggregateStatisticFact AggregateStatisticFact RefId AggregateStatisticInfoRefId Characteristics AggregateCharacteristicInfoRefId Excluded Value SIF_Metadata SIF_ExtendedElements
 Element/@AttributeCharDescriptionType
 AggregateStatisticFact 

This object is the actual value of the measurement. It is always associated with one statistic and one or more characteristics.

 
 
@
key
RefIdM RefIdType
 AggregateStatisticInfoRefIdM Reference to statistic defined by AggregateStatisticInfo.  IdRefType
 CharacteristicsM

Reference to one or more AggregateCharacteristicInfo objects.

 
List
 Characteristics/AggregateCharacteristicInfoRefId
     
MR

Reference to an AggregateCharacteristicInfo object.

 
IdRefType
 ExcludedO values:
Yes
No
 ValueM

Value of the fact.

 
xs:decimal
 SIF_MetadataO SIF_Metadata
 SIF_ExtendedElementsO SIF_ExtendedElements
Table 6.5.3-1: AggregateStatisticFact
<AggregateStatisticFact RefId="3A4E2822C696433B812B49DEAE557E41"> <AggregateStatisticInfoRefId>91A4209F7F4F4F4B9DC8D21CEFD1DC2F</AggregateStatisticInfoRefId> <Characteristics> <AggregateCharacteristicInfoRefId>0B972D8644EE4D7994F5FF1C3131772D</AggregateCharacteristicInfoRefId> </Characteristics> <Excluded>No</Excluded> <Value>27</Value> </AggregateStatisticFact>
Example 6.5.3-1: AggregateStatisticFact

Valid XHTML 1.0 Transitional