Weekly Challenges

AYXAcademy

Hello Community members,

A solution to last week’s challenge can be found here.

This week’s challenge was submitted by Talia Sanders (@tsand22) . Thank you, Talia, for this great challenge!

In Part 1 of this challenge, you calculated the cost of school supplies for one child in each grade of elementary school (from kindergarten [K] to sixth grade).

In this week’s challenge, you will analyze data related to school enrollment by grade level in the state of Indiana, and use the cost of school supplies results from Part 1 to answer two questions:

What is the total cost of school supplies for all students for each grade (kindergarten to grade 6)? To achieve this, calculate the total number of students in each grade, and then the total cost of school supplies by grade.
What is the total cost of school supplies for all students in kindergarten to grade 6?

Hints:

Some schools serve multiple grade levels (for example, K to 8 or 5 to 12). Be sure to include any schools that have students in grades K to 6.
Include all types of schools (traditional, private, charter, etc.).

There are two datasets provided for this challenge:

Enrollment Data Text Input: Data for school enrollment in the state of Indiana, such as school name, number of students in each grade, and total number of students in each school.
Full Cost of School Supplies Text Input: Cost of school supplies for each grade (K to 6).

Need a refresher? Review the following lessons in Academy to gear up:

Filtering Data

Joining Data

Ready to take this challenge? Good luck!

The Academy Team

Download Start File

Download Solution File

Data Source:

https://www.in.gov/doe/it/data-center-and-reports/

File: School Enrollment by Grade Level - (Updated - SY 2023-2024)

Update with challenge 472 link