Layout recommendations for weekly scores

[Earthlark]

I'm trying to figure out the best layout for this table (using Win 10 Excel 2016), but I'm not sure after having tried a bunch of different things, so if anyone has any recommendations, I'd be much obliged. See a couple quick examples I created below. Example two seems my best bet as I can filter by activity (but I can't sort by student name or number).

Each student performs a 5-minute writing test and two 1-minutes speaking tests. The number of words are counted and recorded. I want to measure the progress as it changes over 10 weeks. I also want to display mins, maxes, averages, sums, cellular conditional formatting. It would also be nice to be able to sort students by number, first, or last name. I'd also like to be able to filter the Ws, the Ss, the SA1s, and the SB2s to analyze.

I'm also doing this for multiple classes, so it'd be nice to have something I can replicate and plug different names into.

Is my best bet a pivot table? Or do I need to just use one like example 2 and then filter and copy and paste individual tables w/links to other sheets? Or? If I know what form to go for, I can probably figure it out, but I'm not really sure where to begin. I tried a few pivot tables, but for some reason, this doesn't seem to lend itself very well to a pivot table...


Example 1

Example 2

 

[Special-K99]

No attachments.

You cant attach files on this forum. There are tools on this forum for adding small spreadsheet images

https://www.mrexcel.com/forum/about-board/508133-attachments.html

Or upload the file to an online storage site and post a link to it, though some people may not download the file for fear of viruses.

 

[Earthlark]

Strange. I just used "Insert Image" and put in the URL. The images in the preview showed up fine. So I take it "Insert Image" isn't meant to be used? I originally tried for a few hours installing some of the add-ins mentioned (HTML Maker and Excel Jeanie), but Excel Jeanie produces an error and HTML Maker doesn't show up after enabling it in the add-ins and after making sure the add-ins folder is trusted (as well as the file). That's why I eventually gave up and tried to insert an image.

So far I haven't been able to find any way to post examples from Excel 2016 after a few hours of reading through threads. Isn't there any way to post a screenshot? I can't believe something so simple has been so hard. Maybe I'm just being stupid. Any recommendations?