Okay so would this be another way to say it?
Display the value of the “Bad” column for the logged in student at the current time (hour)
And then for each other column (“Good”, “Okay”, etc.)?
The way I would do that is to Find the First Occurrence of app variable Student ID in column “Student ID” of the data source (that will return the row # with Class Hour “1st”) and then add [current hour minus one] to that value. Use that number as the row id to get the row object from the data source. Then get each property (column name) from the row object.
·····················································································································
Need help? How to Ask Great Questions 
Debugging A Project API JSON Tutorial
Want to hire a Certified Thunkable Expert? Elevate your app with Tatiang on Fiverr