VED Data Downloads¶
This wiki reviews accessing data extracts and reports on Vermont Education Dashboard
- VED Data Downloads
- How-To:
- Other Data Reports
- Column Headers
- VED Organization Dataset Headers
- VED Staff Information Dataset Headers
- VED Enrollment Dataset Headers
- VED Student Information Dataset Headers
- VED Student Characteristics Dataset Headers
- VED Chronic Absentee Dataset Headers
- VED Assessment Dataset Headers
- VED Course Enrollment Dataset Headers
- VED Exclusionary Discipline Dataset Headers
- Internet Resources for Working with Data
How-To:¶
Instructions for accessing data extracts in the Vermont AOE Vermont Education Dashboard tool: A guide for finding data and downloading specific data
-
Go to the Vermont Education Dashboard website. You can find it by clicking on this link: Vermont Education Dashboard | Agency of Education
-
Once you are on the Vermont Education Dashboard webpage, scroll down the page below the dashboard options and above the version information, click on full dataset.
-
The Data download will be accessible in the Downloads folder in windows system.
The file will need to be unzipped. Right click and select open on the zip file. This will allow you to see the files in the zip file, there will be files in each for each of the six dashboards and several for assessment data because of it size and complexity. Each of these files is in comma delimited format and can be read by excel or other local analysis tools. If you need more information about working with zip files in Windows or Mac OS, try this site for tips Tech Savvy Tips and Tricks: Working with Zip Files (gcfglobal.org)
-
Work with the data files in a spreadsheet tool. Most users will have excel, but for Mac users that use numbers there is a link to a conversion tool for csv to numbers file format at the end of this document.
Other Data Reports¶
The Data and Reports landing page contains a hyperlinked list of other reports that are available. [Data and Reporting | Agency of Education (vermont.gov)](https://education.vermont.gov/data-and-reporting}
Column Headers¶
NOTE: This section is still under construction and is not complete. Please check back soon as we are actively working on it.
VED Organization Dataset Headers¶
| Column Heading | Description |
|---|---|
| SupervisoryName | Name of the Supervisory Union |
| SupervisoryIdentifier | Identifier of Supervisory Union |
| SchoolName | Name of the School |
| OrganizationIdentifier | Identifier for School |
| ADDRESS | Address of School |
| CITY | City of School |
| LATITUDE | Latitude of School |
| LONGITUDE | Longitude of School |
| STATE | State of School |
| ZIP_CODE | Zip Code of School |
| COMPLETE_ADDRESS | Full Address of School |
VED Staff Information Dataset Headers¶
| Column Heading | Description |
|---|---|
| SY | School Year |
| ORG_ID | Organization Identifer |
| Staff_Group | Grouping of Staff Labels |
| Staff_Label | Descriptions of Information |
| Staff_SU_SD | Supervisory Information |
| Staff_School | School Information |
| Staff_State | State Information |
VED Enrollment Dataset Headers¶
| Column Heading | Description |
|---|---|
| SY | School Year |
| ORG_ID | Organization Identifier |
| PK/EEE | Prekindergarten Enrollment |
| K_Full | Greater than or equal to 22.5 hours a week Kindergarten Enrollment |
| K_Part | Less than 22.5 hours a week Kindergarten Enrollment |
| 1st | First Grade Enrollment |
| 2nd | Second Grade Enrollment |
| 3rd | Third Grade Enrollment |
| 4th | Fourth Grade Enrollment |
| 5th | Fifth Grade Enrollment |
| 6th | Sixth Grade Enrollment |
| 7th | Seventh Grade Enrollment |
| 8th | Eight Grade Enrollment |
| 9th | Ninth Grade Enrollment |
| 10th | Tenth Grade Enrollment |
| 11th | Eleventh Grade Enrollment |
| 12th | Twelveth Grade Enrollment |
| AW | Adult Without Diploma |
| ADP | Post Graduate / Adult with Diploma |
| Total | Sum of all Grades |
VED Student Information Dataset Headers¶
| Column Heading | Description |
|---|---|
| Info_Group | Grouping of Student Information Labels |
| Info_Label | Descriptions of Information |
| Info_SU_SD | Supervisory Union Information |
| Info_School | School Information |
| Info_State | State Information |
| ORG_ID | Organization Identifier |
| SY | School Year |
VED Student Characteristics Dataset Headers¶
| Column Heading | Description |
|---|---|
| Char_Group | Grouping of Student Characteristics Labels |
| Char_Label | Descriptions of Information |
| ORG_ID | Organization Identifier |
| SY | School Year |
| Suppressed_Char_SU_SD | Suppressed Supervisory Union level information |
| Suppressed_Char_School | Suppressed school level information |
| Suppressed_Char_State | Suppressed state-level information |
| SUPPRESSED_SU_SD | Supervisory Union Suppressed binary |
| SUPPRESSED_School | School Suppressed binary |
| SUPPRESSED_State | State Suppressed binary |
VED Chronic Absentee Dataset Headers¶
| Column Heading | Description |
|---|---|
| CollectionTypeName | Collection Type |
| SchoolYear | School Year |
| StateOrganizationID | Organization Identifier |
| OrganizationName | Organization Name |
| OrganizationTypeName | Organization Type |
| Description | Descriptions of Information |
| StudentCount | Count of Students |
| StudentBodyPercentage | Percentage of Students |
| Attendance_Description | Descriptions of Information for Attendance |
| EnglishLanguageLearner_Description | Descriptions of Information for English Language Learner |
| FreeReducedLunch_Description | Descriptions of Information for Free Reduced Lunch Description |
| Sex_Description | Descriptions of Information for Gender Binary |
| StudentSupportServices_Description | Description of Information for Student Support Services |
VED Assessment Dataset Headers¶
| Column Heading | Description |
|---|---|
| SY | School Year |
| ORG_ID | Organization Identifier |
| Test_Name | Types of Tests |
| Indicator_Label | Information on Proficiency |
| Assess_Group | Grouping of Assessment Labels |
| Assess_Label | Description of Information |
| VALUE_W | School level information |
| VALUE_W_ST | State-level information |
| VALUE_W_SUSD | Supervisory Union level information |
VED Course Enrollment Dataset Headers¶
| Column Heading | Description |
|---|---|
| CollectionTypeName | Collection Type |
| SchoolYear | School Year |
| OrganizationName | Organization Name |
| OrganizationTypeName | Type of Organization |
| Description | Description of Course Enrollment |
| StudentCount | Count of Students |
| StudentBodyPercentage | Percentage of Students |
| Course_Description | Description of Course Enrollment |
| EnglishLanguageLearner_Description | Description of English Language Learner |
| FreeReducedLunch_Description | Description of Free Reduced Lunch |
| Gender_Description | Description of Binary Gender |
| RacialGrouping_Description | Description of Racial Groupings |
| StudentSupportServices_Description | Description of Student Support Services |
VED Exclusionary Discipline Dataset Headers¶
| Column Heading | Description |
|---|---|
| CollectionTypeName | Collection Type |
| SchoolYear | School Year |
| StateOrganizationID | Organization Identifer |
| OrganizationName | Name of Organization |
| Description | Description of Exclusionary Discipline |
| OrganizationTypeName | Type of Organization |
| StudentCount | Count of Students |
| StudentBodyPercentage | Percentage of Student Body |
| ExclusionIncidentType_Description | Description of Incident Type |
| EnglishLanguageLearner_Description | Description of English Language Learner |
| FreeReducedLunch_Description | Description of Free Reduced Lunch |
| RacialGroupingState_Description | Description of Racial Grouping |
| Sex_Description | Description of Binary Gender |
Internet Resources for Working with Data¶
- Free spreadsheet software - Calc | LibreOffice - Free Office Suite - Based on OpenOffice - Compatible with Microsoft
- Online tool that will convert csv to excel file - https://document.online-convert.com/convert/csv-to-excel
- Convert csv file to Numbers format - Convert csv to numbers - 101convert.com (this site has many other conversion tool and may be more generally useful)