You need a supervisor. Not just for the analysis, but also for your basic data preparation. This is not how you need to record data for analysis. The rule is that one variable gets one column. So one column should contain the success evaluation, and I'd number it from one to five for degree of success. You can associate labels with these numbers in your stats package – jamovi, for example, has a nice interface for doing this. And is free.

Second, it looks like you had a pre-post design. So you can organise your data with a column for pre and another for post ratings (wide data) or a colum with a code for whether the rating is pre or post.

But most of all, you need help from the people who should be helping you. Researchgate is fine for the occasional question, but it's no substiute for a supervisor who knows your subject area, understands your research and is paid to help you!

Good luck

Ronán Michael Conroy thank you those are some helpful notes, and I do have a supervisor but unfortunately its my university's half term break so my supervisor won't respond to any of my questions.

Jade Moody – I fully support your supervisor's aspiration to have a half-term holiday. But I am still concerned that nobody seems to have helped you draw up an analysis plan. But I would encourage you to be patient. Your supervisor will be back, and you can bring your problem to them. Bring aspirins as well, by the way.