This activty is an example of how we can use one data set to find out lots of different information.

We are going to analyse the top songs from Spotify in 2019 and see what patterns we can find.

Materials
  • Spotify data set appropriate to the learners
  • Paper, pencil
  • Coloured paper & coloured pencils (optional)
  •  Access to spreadsheet software (optional)
Blended vs Home Learning

This task can be easily split between classroom and home learning if required. The recommended approach is to start the activity at home and and complete it in school.

Datasets

Dataset for first level learners: This data set is a simplified set of information about the most popular songs, containing 20 records and 3 characteristics about each song (artist, genre, popularity) –

Dataset for second level learners: This is the complete dataset for all 50 songs with 11 different characteristics about each song –

Top 50 Spotify Songs (excel)

Top 50 Spotify Songs – Printable

Additional Information

Knowing how to sort data in excel can help learners complete this task. Watch this video to learn how to sort your data.

Being able to create a chart in excel is an optional part of this activity. Read more about how to create a chart

Activity

Lesson Plan – Analyse Spotify Data

Learner Worksheet Top 20

Learner Workshop Top 50

Follow on work and subject extensions
  • Expressive Arts – Music Choreograph short dances to music with different beats per minute
  • Numeracy & Technologies- Create a top 50 songs for your class or school
  • Expressive Arts – Create a piece of art that represents one of the songs in the dataset using only the characteristics available in the dataset