2023: Week 22 - Student Attendance vs Test Scores

Challenge by: Tanbir Jalil

This is our next challenge from one of the members of the 38th cohort of the Data School UK.

You have been hired to create a dataset for the Prep School that will allow them to analyse the correlation between attendance and test scores.

Inputs

  1. Student Test Scores Graphical user interface, application, table, Excel

Description automatically generated
  2. Attendance Figures 
Table

Description automatically generated

Requirements

  • Input the data
  • First we must join the test score data set and the additional class attendance data set 
  • Clean Data: there’s a few spelling mistakes in the data set, use the data tool of your choice to correct these mistakes before we proceed. These mistakes are in the “Subject”  Column
  • Use a calculated field to clean up the test score column, so each number is a rounded to the nearest whole number
  • Split the student name column so we can see the first name and surname in two separate columns, named appropriately
  • If any student has an attendance percentage less than 70%, flag it as "Low Attendance" in a new column "attendance flag". Conversely, if above 90%, flag as “high attendance”. And anything else as “Medium”.  
  • Output the data

Output

Table

Description automatically generated with medium confidence
  • 8 fields
    • Attendance Flag
    • First Name
    • Surname
    • Attendance_Percentage
    • Student_ID
    • Subject
    • Test_score
    • TestScoreInteger
  • 20 rows (21 including headers)
You can download all the output from here.

After you finish the challenge make sure to fill in the participation tracker, then share your solution on Twitter using #PreppinData and tagging @tanbir_jalil@Datajedininja@JennyMartinDS14 & @TomProwse1

You can also post your solution on the Tableau Forum where we have a Preppin' Data community page. Post your solutions and ask questions if you need any help! 

Popular posts from this blog

2024: Week 1 - Prep Air's Flow Card

2023: Week 1 The Data Source Bank

How to...Handle Free Text