Questions at the end of lessons: aggregated results after course

Hi I'm trying to create a structure where a course is made up of multiple topics, each with a question at the end, plus a longer test, with multiple questions, at the end of the course. I want the end-of-course test to draw x questions at random from a bank of y questions. I want to aggregate the results of all the end-of-topic questions plus the end-of-course test Is there anyone who has done this and can point me in the direction of how to achieve it, please?