Hello.
I am trying to create a line/scatter graph to show the progress (or lack of) for the students in my school. The students are tested twice a year, in this case May 2021 and May 2022 and the test provides an equivalent reading age in years and months (YY:MM).
For example, in May 2021 Joe Bloggs was assessed to have a reading age of 10:01 (10 years and 1 month). In May 2022, Joe was assessed again and had a reading age of 11:06 (11 years and 6 months). Therefore Joe has improved his reading age by 1:5 (1 year and 5 months).
I would like to create a line graph to represent this improvement from assessment 1 (May 2021) to assessment 2 (May 2022). Ideally I would like the y-axis to show Age Equivalent Score (8,9,10,11,12,13,14,15) and the x-axis to show the two assessments points (May 2021 and May 2022).
I have attached a example spreadsheet.
Any help is greatly appreciated.
Thanks
Bookmarks