10. actual date that the test was submitted (single date but some students in class may take the test on a different date e.g if they are absent )

I would like to organize the data so that I can analyze both sets of data; scheduled and actual, together in Tableau. Some of the questions that I would like to be able to quickly answer in Tableau are:

How many teachers' classes(or students) took the test during the scheduled date interval?

for those classes that took the test, how many students took the test?

for those classes that took the test, what was the average score on the test?

How many teachers' classes (or students) did not take the test during the schedule date interval (or ever)?

I don't have Tableau file for this yet as I am trying to work out how to feed the data in to Tableau. My data is also subject to IRB protections and therefore I cannot share my Excel spreadsheet online.