Free Trial

Weekly Challenges

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

Challenge #472: School Supplies Cost How Much?! Part 1

AYXAcademy
Alteryx
Alteryx

Full Width - WC banner.svg

 

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 incredible challenge!

 

Every year, parents and guardians need to purchase school supplies for their children at the beginning of the school year. This is a major cost that many families struggle to budget for.

 

In Part 1 of this challenge, your objective is to calculate the cost of school supplies for one child in each grade of elementary school (from kindergarten to sixth grade).

 

There are two datasets provided:

  • School Supply List Text Input: A list of school supplies separated by grade.
  • Cost of School Supplies Text Input: The cost of each unit from a list of school supplies.

 

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

Changing Data Layouts

Sorting Data

 

Ready? Good luck!

The Academy Team

 

Download Start File

 

Download Solution File

 

Data Source:

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

Pilsner
11 - Bolide

My solution:

Spoiler
472.png

martinson
11 - Bolide

Great Challenge

Cheers,
martinson

LinkedIN

Bulien
Tofel
9 - Comet

Cannot they re-use that 'quality' headphones ?

 

Spoiler
Challenge 472.jpg

Kilbyflow_Designer
8 - Asteroid

Done!!

 

Spoiler
Challenge 472.jpg

Bennu
8 - Asteroid

Just wait until college tuition and college books...

Spoiler
WC_472.jpg
alexnajm
18 - Pollux
18 - Pollux

Done!

Spoiler
Challenge 472.png
Bobbyt23
12 - Quasar

Nice straightforward challenge but with a couple of sneaky banana skins to trip you up. Good fun!

 

EDIT- Not sure why my spoiler pic isn't loading. 🤔

Erin
10 - Fireball

One of my least favorite things to do is school supply shopping. Where's my brown paper bag to breathe into? 😶

 

Spoiler
472.jpg


Great challenge though! Easy peasy with just a couple banana peels like @Bobbyt23 said! 

JBevan89
8 - Asteroid
Spoiler
C472_JB.png

Great Challenge.  I'm gutted that I was not the first to solve, but i'm delighted with the formula's I worked out 😁