I used excel to whip up a little half page Observation Record sheet for my daughter to use as part of a little homeschooling project last year. It was meant to be used to record external observations only.
I had her record the date, time, and basic weather info.
Then there were a series of yes/no choices for each hive:
Bees Flying?,
Dead Bees visible on landing board or near entrance?
Pollen comming in?
Orientation Flights?
Bearding?
Bee Dance? (I have occasionally seen the bee communication dance on the landing board or at the edge of top entrance when there is one.)
Washboard Dance? (Which I suspect is actually honey curing activity.)
There was also a place for her to record the number of foragers coming and going in one minute, pollen colors, and any other notes she wanted to make.
She was still a bit too young to fill it all out last year, but soon I will print out some more and have her do them again this year. If we get enough of them filled out I will enter the results in a spread sheet or database, cross reference them with my internal observations, and look for trends... but we will probably not be that diligent for another year or two.