Educational Performance Evaluation and Prediction

Problem Description

📖 Predicting Relative Performance Score of Schools

You have been hired by the City of Austin, Texas to calculate the Relative Performance Score of educational institutions in the city. You have two files available that contain the following columns:

📋 Column Description

Note: The Relative Performance Rating column is available only in the training data (train.csv).

🧩 Subtasks

Subtask 1 (5 points)

Calculate how many elementary schools exist in Anderson County in the test data (test.csv).
The result must be an integer.

Subtask 2 (5 points)

What is the most frequent rating in the Academic Growth Rating column in the test data (test.csv)?
The result must be a string: "A", "B", "C", "D" or "F".

Subtask 3 (90 points)

Build a prediction model capable of estimating Relative Performance Rating for all educational institutions in the test data.

📊 Evaluation

Evaluation is done using accuracy:

accuracy = number_of_correct_predictions / total_number_of_predictions

Scoring for Subtask 3:

• accuracy ≥ 0.9 → 90 points
• accuracy < 0.75 → 0 points
• Intermediate values are scored proportionally between 0 and 90

📄 Submission File Format

The submission file must be in CSV format, with the following columns:

• subtaskID – subtask index
• datapointID – unique identifier from the dataset
• answer – your answer or prediction

Example:

1subtaskID,datapointID,answer  21,1,0  32,2,F  43,100,C  53,101,A  63,102,B  7...

Note:
For Subtask 1 and Subtask 2, the datapointID value must be 1 and 2, respectively.

📊 Data Source

City of Austin – data.austintexas.gov
Emergency Medical Services Department