The exam consists of 200 single-choice questions, and is implemented in two versions.
In the exams file, the first 4 characters are the student identifier - 0001, the 5th character is the answer sheet identifier.
Each card contains the answers to 100 questions. The 6th character is a space, the 7th is the exam version identifier and from the 8th character onwards are the answers to the questions.
The purpose of the exercise is to see how many students have passed. The threshold for passing is 60%.
The best students passed exam with ID:
More details in Results.xlsx
In egzamin.txt file we have answers and student ID in string format. I needed to read that file, then process that according to the key in Klucz.xlsx.
In other words I checked which answer is correct in egzamin.txt thanks for Klucz.xlsx. Means I read both file, then process data inside of them, then I checked whether the answers were correct and assigned points to the specified student ID.