Random Clocks

4/28/20

With the recent Coronavirus Disease 2019 (COVID-19), many children are at home because schools are closed. Education and fun, however, should not stop. Here is a spreadsheet I created that creates random analog clocks for students to practice their time, or estimating the time.

When you open up the spreadsheet, it creates three clocks with randomly generated times. It does this by creating a random angle, and converting this to rectangular coordinates. I keep the magnitude (i.e. length) of the hour hand half as big as the length of the minute hand. I also make the hour hand thicker than the minute hand. Note that the positions of the clock hands are not entirely accurate in relation to the numbers on the clock face because I am just creating random angles to draw the hands while the numbers on the clock are just drawn on, but the student should still be able to estimate the time well from this worksheet.

I set the Print Area, that is, the area that will be printed out when you click Print, to be the area with the words in the outlined box. This way, you can just open up the spreadsheet and print. You can also press F9 to create new random numbers.

Click here to download the spreadsheet.

You are free to edit this spreadsheet as needed. If you find this spreadsheet useful, please credit Statisticool.com.

Thanks for reading.