I designed and created a Dance o' meter, which is a spreadsheet which presents questions for the students to answer. The questions allow them to give responses about themselves. The idea of this quiz is to encourage and persuade students to take part in the Dance o'Clock event.

I used formulas in the answer boxes to give the student choice in answer. I changed the format of my spreadsheet to suit the user so I used formatting techniques to do so. I used conditional formatting in the results boxes so they change colours when certain results occur.

To complete the Dance o' meter effectively I did some market research and evaluated spreadsheet quizzes that are already available.

Quiz Questions.

First draft quiz.

Quiz feedback.

This next link shows my quiz, formula view, my results and my test buddy's results.

Dance o'clock.

Annotating my quiz and password protection.