Ed-Fi Dashboards Generalized Assessments Hands-On Exercise


Outline

  1. Restore the Grand Bend ISD sample databases
  2. Add mock assessment data to the Grand Bend ODS
  3. Add and configure new metrics in the Metric Metadata Utility
  4. Run the Ed-Fi Dashboards ETL
  5. Open the Ed-Fi Dashboards to view the results

Step 1 - Restore the Grand Bend ISD Databases (modified from the UI Developers' Guide - Installation Step 2 - Restore Sample Databases)

  1. Open a PowerShell window and navigate to C:\Ed-Fi\Database\ (presuming the installation path used in the Getting Started documentation was the recommended C:\Ed-Fi\).


  2. If the SQL Server is not set up as the default instance (MSSQLSERVER), then run the command $env:db_server = ".\MYNAMEDINSTANCE" to setup the named SQL Server instance.


  3. By default the script will restore the Glendale data set, so to restore the Grand Bend data set, execute $env:db_agency = "GrandBend" from the PowerShell command window.


  4. Run the command .\build samples to restore the Grand Bend ISD Databases


Step 2 - Add mock assessment data to the Grand Bend ODS

  1. Open Sql Server management Studio
  2. Connect to the default local Sql Server instance (or the specific non-default instance specified in the previous step)
  3. Download the Grand_Bend_ISD_Mock_Assesment_Data.sql sql script.
  4. Open and execute the  script in Sql Server Management Studio
    1. The script assumes the Grand Bend ISD ODS is named EdFi

Step 3 - Add and configure new metrics in the Metric Metadata Utility

More information about installing the Metric Metadata Utility is available on the How to: Install the metric Configuration Tool page

  1. Adjust Academic Subject Area data in the MetricsMetadata database
    1. Open Sql Server Management Studio and connect to your Sql Server Instance which has the MetricsMetadata database.

    2. Run this sql to update the Academic Subject Area information in the MetricsMetadata database

      use MetricsMetadata
GO
Set identity_insert dbo.AssessmentAcademicSubjectType ON
GO
Delete dbo.AssessmentAcademicSubjectType where AssessmentAcademicSubjectTypeId=1
INSERT INTO [dbo].[AssessmentAcademicSubjectType] ([AssessmentAcademicSubjectTypeId], [Description]) VALUES (28, N'Reading')
GO
Set identity_insert dbo.AssessmentAcademicSubjectType OFF
GO
  2. Run the Metric Metadata Utility (http://localhost/mmu the default installation was followed)
  3. Click "Choose Files"


  4. Select all the metric metadata files located at C:\Ed-Fi\Etl\src\EdFi.Runtime\Reading\Queries\2.0\DashboardTypes\(presuming the installation path used in the Getting Started documentation was the recommended C:\Ed-Fi\), and click "Open"


  5. Next, click "Upload"

    You should then see this message


  6. Click the "Edit" button under "EDIT METRICS"


  7. Click "Student"


  8. Click "Local Assessmnets"


  9. Click "Add Metric"


  10. Select "As a child" then click "Next"


  11. Select "Elementary School" then click "Next"


  12. Type in a "Name" for the metric of "2017 Summit Assessments", then select the "Type" as "AggregateMetric", enter "{0:P1}" for the format and click "Create"


  13. Select the newly created aggregate metric "2017 Summit Assessments"


  14. click "Add Metric"


  15. Select "As a child" and click "Next"


  16. Select "Elementary School" and click "Next"


  17. Type in a "Name" for the metric of "2017 Summit Assessment", then select the "Type" as "ContainerMetric", and click "Create"


  18. Select the newly created container metric "2017 Summit Assessment"


  19. Click "Add Metric"


  20. Select "As a child" and click "Next"


  21. Select "Elementary School" and click "Next"


  22. Type in a "Name" for the metric of "2017 Summit Early Learning Assessment", then select the "Type" as "GranularMetric", enter "{0:P1}" for the format and click "Create"


  23. Configure the Assesment Translator at the Aggregate Metric "2017 Summit Assessments"
    Step 1 - Click "2017 Summit Assessments"
    Step 2 - Click the "Assessment" tab
    Step 3 - Click "Performance" to select the performance level assessment translator
    Step 4 - Select "Raw score" from the drop down box
    Step 5 - Click "Save"


  24. Configure Details for the Granular Metric "2017 Summit Early Learning Assessment"
    Step 1 - Click "" to select it
    Step 2 - Click on the "Edit Details" tab
    Step 3 - Select "Standard form the "Trend Interpretation" drop down
    Step 4 - Enter "{0}" for the "List Format"
    Step 5 - Click "Save Changes"


  25. Click on the "States" tab, then "Add State"


  26. Configure the "Low" state. 
    1. Select "Low" from the "MetricStateType" drop down
    2. Type "Low" in the "StateText" field
    3. Enter 0 for the "MinValue"
    4. Select "Min Value Inclusive"
    5. Enter 40 for the "MaxValue"
    6. Click "Save"
  27. Configure "Good" state
    1. Select "Good" from the "MetricStateType" drop down
    2. Type "Good" in the "StateText" field
    3. Enter 40 for the "MinValue"
    4. Select "Min Value Inclusive"
    5. Enter 60 for the "MaxValue"
    6. Select "Max Value Inclusive"
    7. Click "Save"


  28. Configure the assessment translator information for the Granular Metric "2017 Summit Early Learning Assessment"
    Step 1 - Click the "Assessment" tab
    Step 2 - Select "Early Learning - Language and literacy development" from the "Add Category" drop down
    Step 3 - Select "Reading" from the "Add Subject" drop down


  29. Download the new csv files
    1. Click "Home" in the top Menu
    2. Click the "Export" button
    3. Unzip the downloaded files and copy them to C:\Ed-Fi\Etl\src\EdFi.Runtime\Reading\Queries\2.0\DashboardTypes\, replacing the existing files in that location
  30. Build and execute the Ed-Fi Dashboards ETL solution
    1. Open a PowerShell window and navigate to C:\Ed-Fi\Etl\.
    2. Run the command .\build compile to compile the solution.
    3. Navigate to C:\Ed-Fi\Etl\src\EdFi.Runtime\bin\Release\ and execute EdFi.Runtime.exe. 








  • No labels