Programming Test
Time allowed: Once on the coding platform, please allow yourself no more than 20 minutes in one go for all questions. The system will continue to be available after the 20 minutes, so please time yourself carefully.
Task: As part of a payment method analysis, we would like to probe the popularity of Direct Debit payments across our supporters¡¯ age groups.
Please go to Interview Zen coding platform here, register your name and email address at the bottom of the page and answer the questions using the data description provided below. You might find it useful to familiarise yourself with it before going on the timed platform.
Once on the coding platform, you can choose any programming language from the drop- down menu for each question in part. Please note, the platform will not run your code, but provide a language-specific text editor.
The platform will be recording your answers as you go, so please use the offered textboxes for code writing.
Good luck!
Data Dictionary
1. Relationship information
1
2. Tablesinformation
2.1. IncomeTable
Supporter_URN
Banking_Date
Payment_Method
2.2. SupporterTable
Supporter_URN
Name
Unique supporter ID
Date of donation
int
date
string
Field
Description Type
Amount
Donation amount (¡ê) float
Budgetary_Department
Fundraising department the string donation is assigned to
One of: –
–
– – –
¡®Gift Aid¡¯ ¡®COG¡¯ (Direct Debit)
¡®Cash¡¯ ¡®Payroll Giving¡¯ ¡®Other¡¯
Field
Description Type
Unique supporter ID
Name of supporter
int
Age_Band
Age Band of
supporter:
– ¡®18 to 25¡¯
– ¡®26 to 35¡¯
– ¡®36 to 45¡¯
– ¡®46 to 55¡¯
– ¡®56 to 65¡¯
– ¡®66+¡¯
string
string
Gender
Gender of supporter:
– ¡®F¡¯
– ¡®M¡¯
– ¡®Transgender
¡¯
– ¡®Other¡¯
string
2