What is Fruit?

A task to help define fruit based recipes, however first we must ask... What is Fruit?

Prerequisites:
1. Microsoft Excel installed. (Note: This can be completed without Excel by utilizing notepad and a CSV file instead)
2. Sign-up for an API key at: https://ndb.nal.usda.gov/ndb/doc/index# (Click ‘Sign up now’ text)

Excel:
Create an excel file with 3 columns; Fruit, Recipe, Ingredients
In the fruit column, add 3 rows; Apple, Orange, Banana (Leave Recipe and Ingredients Blank)

The Problem:
Prompt the user to input the name of a fruit
Check to see if the inputted fruit name exists in column A of our Excel file
Fruit does not exist in excel file:
(Advanced) Search for the user’s input using this API, requesting a JSON formatted response, test to see if the word “fruit” exists within the response
(Intermediate) Confirm the user’s input by repeating the fruit back to them, "Are you sure you want me to check for fig Recipes?"
“Fruit” does not exist in response:
Display a message that says, “I don’t believe this is a fruit” and ask the user if
they’d like to try again or exit.
Try again: Return to the start and prompt the user for the name of a fruit
Exit: End process
“Fruit” does exist in response:
Add the fruit to the next available row in the excel file
Continue from “Fruit does exist”

Fruit does exist in Excel File
Navigate to Taste.com.au and search the fruit name
Look at the top 3 (Non-Featured) recipes and identify which has the most ingredients
Store the Recipe name in Column B next to the relevant fruit
Store the Ingredients in column C, separated by a new line with no excess white space
Prompt the user to ‘Start Again’ or ‘Exit’

Use your project to populate Apple, Orange, Banana, and one fruit of your choosing.
Submit your project folder and completed excel file in a .zip to the email Daniel.Farrugia@withyouwithme.com

Advanced

Intermediate

Data Challenge #4 - Air Crashes

This challenge will test your ability to clean data. Minimal preparation has been done to this data set, so as to give you a chance to deal with a more realistic set of formatting issues.

The following are data sets of total flights each year and a data set of air crashes.

Flight data

and

air crash data from 1908-2009

You will need to do a lot of cleaning with this data. 

Some hints:

The date is in american format, so you will need to separate out day month and year.

This will allow you to use year as a common variable between the two datasets.

You will need to add an index column, if you wish to count the number of air crashes.

To compare the total flights data with the crash data you will need to know how to unpivot columns in Power BI.

This video will tell you how.

(if you are using excel, do not worry about this part. Skip Q1, but answer all the others)

Make a line graph showing both the number of flights, and the number of crashes.

Q1 Does the trend in total number of flights explain the trend in the number of crashes?

Add two more columns to your crash data set that calculate the number of survivors and the survival rate.

Q2 Suppose a genie tells you that you will be in an air crash. You are allowed to choose what year you will be in the crash. What year should you choose to maximize your chance of survival?

Q3 Which month has the most crashes?

Q4 Where was the worst air disaster in aviation History?

Q5 How many people died?

Q6 How many people died in the air disaster with the most Survivors?

Q7 Which air operator has had the most fatalities, which has had second most?

Q8 What year was the most deadly for air travel?

Q9 What year produced the most survivors of air crashes?

Send your answers to lachlan.vaughantaylor@withyouwithme.com by May 14th.

Intro to Web Development challenge #2

Welcome to the second Intro to Web Development challenge! Now's your chance to show off some of your new HTML, CSS and JavaScript skills.

Task and motivation

Once again, you will be creating a static webpage that is based on a reference image. The styling for this task is more complex than the previous one, and the final product will look more like a modern website as a result. You will practice styling buttons, using flex display and HTML entities/symbols.

Scenario: A friend has been blogging their interior design articles, but isn’t happy with how bland they appear. They have asked you to help them create a more polished looking blog in the hopes of gaining more viewers. They have provided you with this image for reference:

The aim of this activity is to create a page with HTML and CSS that looks like the below image. You will need to use tools such as a colour picker to obtain the HEX codes/RGB value of the colours used. If you are finding it hard to match the font sizes/spacing between elements you can use an image editor to measure sections of the reference.

Hints:

You will need

Reference image: To base your implementation off of.

Starter files: 

A colour picker - use whichever one you prefer,but here is an example.

A HTML validator - To ensure you’re using best practices while you’re doing any kind of web development work. This will ensure your code not only works, but is readable for people other than yourself. You can find one here. You’re creating habits that will stick with you for your career in tech, make sure they’re good ones! 

Starter files: 


Submit your files directly to Kristin via Discord or through the below form.
Good luck!

If you’re having any difficulty, jump into our Software Development Discord Server and join the discussion!

Data Challenge #3 - Spotify Tracks

How it works:

Each fortnight we will present a data challenge to be solved. These challenges will be a mix of Excel, Power BI, Tableau and SQL and are designed to increase your proficiency in skills across the data pathway. We encourage everyone on the Data Pathway to take a crack and challenge yourself!

Challenge #3 - Spotify Tracks

You are assigned to a team of Data Analysts reviewing musical data over the last 100 years.

Your task is to provide insights about musical trends by Popularity, Energy and Tempo.

Questions 1-4 

(Tip - Use 'Popularity' metric)

Questions 5-9 

Question 10 

Suggestions 

Use the Dataset below

https://www.kaggle.com/yamaerenay/spotify-dataset-19212020-160k-tracks

CHALLENGE TITLE HIDDEN

this is a test challenge

Intro to Web Development challenge #1

Welcome to the first Intro to Web Development challenge! Now's your chance to show off some of your new HTML, CSS and JavaScript skills.

Task and motivation

Now that you have grasped the basics of CSS and HTML, you will be creating a static page base that complies with a visual specification. When working as a web developer, it is very common to be presented with a visual specification (usually created by a designer) that you need to translate to code. You will practice using images, text and background styling in this activity.

Scenario

A family member is starting their own travel blog. They love travelling and writing, but don’t know how to code. They have asked you to help them by creating a web page that nicely displays photos and headings, so they can showcase the places they are visiting. They have provided you with this image for reference:

The aim of this activity is to create a page with HTML and CSS that looks like the below image. You will need to use tools such as a colour picker to obtain the HEX codes/RGB value of the colours used. If you are finding it hard to match the font sizes/spacing between elements you can use an image editor to measure sections of the reference.

Hints

You will need

Reference image: To base your implementation off 

Starter files: 

A colour picker - use whichever one you choose but here is an example.

A HTML validator - To ensure you’re using best practices/style while you’re doing any kind of web development work. This will ensure your code not only works, but is readable for people other than yourself. You can find one here. You’re creating habits that will stick with you for your career in tech, make sure they’re good ones! 

Submit your answers

Submissions close 28/01/2021 at 12:00pm AEST.
Submit your files directly to Kristin via Discord or through the below form.
Good luck!

If you’re having any difficulty, jump into our Software Development Discord Server and join the discussion!