def data_to_merit(dic):
    """
    Returns a dictionary of merit cca choices of each student
    {student:merit cca}
    """

    final_dic = {}

    dic_choices = dic["choices"][0] #relevant sheet

    for NRIC, choices in dic_choices.items():
        final_dic[NRIC] = choices["MERIT1"] #just take first choice; no limit for merit CCAs

    del final_dic["NRIC"]

    return final_dic