...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
- User runs the Ed-Fi ODS/API application and authorizes
2. StudentSchoolAssociation Posts (the names are fictitious)-
John Smith, Kelly Logan, Jennifer Hart getting enrolled in a school within a district. Choose different schools and its districts. John is going to be enrolled in one school only. Kelly will be enrolled in two schools with different FTEs. Jennifer will be enrolled in one school but entry date will be beyond Oct 1st.
a. Do a GET on schools to show that the school exists
b. Do a POST for John Smith. Make sure the Entry Date is within Oct 1st of the current year. Make sure his FTE is 1.0
c. Do a POST for Kelly Logan. Make sure the Entry Date is within OCT 1st of the current year. Make sure her FTE is 0.51
...
d. Do a POST for Jennifer Hart. Make sure the entry date is beyond Oct 1st of the current year. Make sure her FTE is 1.0
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
Below are the reports generated for this use case
- Special Education Report By Age (SpecialEducationByAgeReport.xlsx)
- Special Education Report By Disability (SpecialEducationPrimaryDisabilityReport.xlsx)
- Special Education Report By Special Education Setting (SpecialEducationSettingReport.xlsx)
Report Generation Step-by-Step Guide
Populate Database Tables
The reports are generated using the student data available in the EdFi_Ods_2022 database. The stored procedures shown below are used to insert data into report tables in the database.
- reporting.LoadStudentFallMembership - inserts data into reporting.StudentFallMembership table.
- reporting.LoadSpedChildCount - inserts data into reporting.SpecialEducationChildCount table.
You can find the database tables and stored procedures by following the below steps:
Step 1. Open Microsoft SQL Server Management Studio as Administrator using Windows search box with "ssms" keyword.
Step 2. Using Windows Authentication, click Connect.
Step 3. After connection, you will see EdFi_Admin, EdFi_Security and EdFi_Ods_2022 database for the 2022 school year in the Object explorer.
Step 4. Expand the EdFi_Ods_2022 database and then Tables to find the reporting tables under reporting schema.
Step 5. Run the stored procedures, also found under reporting schema, to populate the reporting tables.
Generate Reports
Now that the reporting tables have been populated using the above stored procedures you can use the provided SQL scripts to generate each report.
...
These SQL scripts can be found under C:\Ed-Fi-Starter-Kit\ReportGenerationScripts folder. Look for your reports in the Reports folder on the desktop.
Now that you've generated some reports, you will need to know how to refresh them when there is an update in the student data. Updated reports can be generated by running the PowerShell script report.ps1 located in the same folder. The script performs all the tasks required to generate these reports, from executing the stored procedures to inserting data into the reporting tables as well as executing all the SQL scripts found in C:\Ed-Fi-Starter-Kit\ReportGenerationScripts folder. Additionally, it updates the XLSX files inside Reports folder on the desktop. Follow the steps below to run the PowerShell script.
Step 1. Open Windows PowerShell as Administrator using Windows search box with "powershell" keyword.
Step 2. Run the command below in PowerShell to navigate to the ReportGenerationScripts folder
| Code Block | ||
|---|---|---|
| ||
cd C:\Ed-Fi-Starter-Kit\ReportGenerationScripts |
Step 3. Run the following command in PowerShell to generate the updated reports
| Code Block | ||
|---|---|---|
| ||
.\report.ps1 |
Step 4. The updated excel report files will be present under Reports folder on the desktop.
