Writing outcomes and then names listed below

Hi,

I'd like to be able to do the following in Excel, and would be super grateful if someone could help me.

I'm a teacher, and would like to have a list of my students go along the y axis. Along the x axis, I'd like to be able to write out the learning outcomes (the specific things they have to learn). When I print this out, it will automatically go to a next page once it's gone past a certain point on the x axis. The stuff I write out on the x axis will appear in vertical boxes so that I can fit more per page. Roughly something like this:

1 2
1 2
1 2
1 2
1 2
1 2

Jane
Tom
Billy
etc...

The 1 and 2 represent the specific learning outcome (since I can't write vertically on this post).

I realise that x and y axis are probably not the terms used within Excel but I don't know what those terms are.

Then, when I'm evaluating them, I just put checks or mark values for each specific outcome.

I can't stress how grateful I'd be if someone could write a simple step by step list of how to make this happen. Please assume that I have zero ability in Excel, as I've never been able to make the program work the way I'd like it to.

If there is a non–Excel way to do this, I'd be open to ideas as well.

Thank you so much!

Please take a look at the jpeg to see what I mean. Again, because there are so many outcomes, it would actually end up being 5 or so real life pages, but within Excel it could just go on to the right. I would be printing them off though to give them marks in class and then manually entering the mark back into the Excel spreadsheet in order to calculate the final mark.

That template is essentially perfect! The only thing left to be able to do would be to be able to type in three or four lines worth in each box at the top and for Excel to make that box big enough to show it all. In the jpg, you can see that the writing goes vertically so that you can read the sentences, but I wouldn't even mind if it was written horizontally, just so long as all of it is visible.

As it stands, if I erase one of the boxes at the top, like Maths, and replace it with "Able to speak confidently in another language", all you see is "Able to spea" and then the rest is cut off (or to that effect).

Do you know what I mean?

Hi Martin,

Thank you so much! It's working perfectly! All thanks to you! I'm so pumped! THANKS!

If in the future I have any questions, I'll post within this thread, but I think it's ready to rock.

YES!