Graduation Rate Data File (CSV/Excel Format)
School/Institution Name | Year | Total Students | Graduates | Graduation Rate (%) |
---|---|---|---|---|
Example High School | 2024 | 1000 | 800 | 80% |
Example University | 2024 | 2000 | 1500 | 75% |
Example College | 2024 | 500 | 450 | 90% |
2. Test Scores and Academic Performance Data File (CSV/Excel Format)
Student ID | School/Institution Name | Test Type | Test Score | Year | Grade Level | Demographic Group |
---|---|---|---|---|---|---|
12345 | Example High School | SAT | 1200 | 2024 | 12th Grade | Hispanic |
23456 | Example High School | ACT | 28 | 2024 | 12th Grade | African American |
34567 | Example University | SAT | 1300 | 2024 | 1st Year | White |
3. Retention Rate Data File (CSV/Excel Format)
School/Institution Name | Year 1 Enrollment | Year 2 Enrollment | Retention Rate (%) |
---|---|---|---|
Example High School | 1000 | 850 | 85% |
Example College | 800 | 700 | 87.5% |
Example University | 1500 | 1400 | 93.33% |
4. Student Engagement and Satisfaction Data File (CSV/Excel Format)
Student ID | School/Institution Name | Engagement Level (1-5) | Satisfaction Rating (1-5) | Program Type | Year | Demographic Group |
---|---|---|---|---|---|---|
12345 | Example High School | 4 | 5 | Personalized Learning | 2024 | Hispanic |
23456 | Example College | 3 | 4 | Hybrid Learning | 2024 | African American |
34567 | Example University | 5 | 5 | Blended Learning | 2024 | White |
5. SEL Program Data File (CSV/Excel Format)
Student ID | School/Institution Name | SEL Program Participation | Pre-Program GPA | Post-Program GPA | Behavioral Improvements (1-5) | Year |
---|---|---|---|---|---|---|
12345 | Example High School | Yes | 2.8 | 3.2 | 4 | 2024 |
23456 | Example College | Yes | 3.0 | 3.4 | 3 | 2024 |
34567 | Example University | No | 3.5 | 3.6 | N/A | 2024 |
How to Create the Raw Data Files
- Excel: Open Excel, create a new workbook, and enter the above data into sheets for each category (e.g., “Graduation Rates,” “Test Scores,” etc.).
- CSV: Open a text editor (like Notepad), input the data in comma-separated format, and save the file with a
.csv
extension. - Database: If you’re using a database like MySQL, SQL Server, or SQLite, create tables with the above columns, and insert data accordingly.
Leave a Reply
You must be logged in to post a comment.