CEDStandards / CEDS-Data-Warehouse

Modeled for longitudinal storage and reporting of P-20W data, the Common Education Data Standards (CEDS) Data Warehouse implements star schema data warehouse normalization techniques for improved query performance.
https://github.com/CEDStandards/CEDS-Data-Warehouse
Apache License 2.0
22 stars 3 forks source link

Add score metrics to FactK12StudentAssessments #43

Open kimcarlsonSD opened 1 year ago

kimcarlsonSD commented 1 year ago

This is for capturing needs not currently supported by the CEDS model. Please do not send or share actual data as examples in this issue or in attachments.

Author(s) Kim Carlson

Authoring Organization(s) South Dakota Department of Education

Email Address kim.carlson@state.sd.us

Use Case Title Add score metrics to FactK12StudentAssessments

Use Case Overview There are two requests for this issue...

(1) South Dakota is requesting a new metric column is added to FactK12StudentAssessments. It would be called AssessmentResultScoreValueACTSuperScore and be a (nvarchar(35), null).

(2) South Dakota is also requesting these metrics be added into FactK12StudentAssessments with the CEDS release if possible. These metrics were provided to South Dakota as possible additional metrics that could be added. One thing, for AssessmentResultScoreStandardErrorRawScore can the word value be added to be consistent with the other metric naming conventions?

• AssessmentResultScoreValueStandardErrorRawScore (nvarchar(35), null) • AssessmentResultScoreValueStandardErrorScaleScore (nvarchar(35), null) • AssessmentResultScoreValueStandardErrorPercentile (nvarchar(35), null) • AssessmentResultScoreValueStandardErrorTScore (nvarchar(35), null) • AssessmentResultScoreValueStandardErrorZScore (nvarchar(35), null) • AssessmentResultScoreValueStandardErrorACTScore (nvarchar(35), null) • AssessmentResultScoreValueStandardErrorSATScore (nvarchar(35), null)

Pull Request Number(s) (If applicable)

Use Case Background Provide information related to why these changes/additions are needed. These changes are needed so we can include standard error in the assessment table. We also need a new metric for ACT super score. South Dakota had a meeting with Nathan and Duane requesting this an additional metric since super score can be different than ACT scores.

Components Affected Delete everything from the list below except the components affected:

FactK12StudentAssessments is what is affected. I'm not sure if it impacts both CEDS IDS and CEDS Data Warehouse?

CEDS Integrated Data Store (complete IDS Design Overview Table)

CEDS Data Warehouse (complete DW Design Overview Table)

CEDS Element Gap Analysis Provide link to CEDS Align Map or Connection.


INTEGRATED DATA STORE DESIGN OVERVIEW

Description of Proposed Changes Provide a concise description of the proposed changes.

As-Is Diagram Add as an attachment in this issue.

Proposed To-Be Diagram Add as an attachment in this issue.


DATA WAREHOUSE DESIGN OVERVIEW (Includes Dim, Fact, and Report tables)

Description of Proposed Changes Provide a concise description of the proposed changes.

As-Is Diagram Add as an attachment in this issue.

Proposed To-Be Diagram Add as an attachment in this issue.


DATA MIGRATION IMPACT ANALYSIS

Description of Proposed Changes Provide a concise description of the proposed changes.

New Business Rule Provide a concise and comprehensive description of the new business rule.

Existing Business Rule Provide a concise and comprehensive description of the existing business rule.

Changed Business Rule Provide a concise and comprehensive description of the changes to be made to the business rule.