How they work: Each template has space for 12 questions. As the creator, choose how many questions you want the students to complete, and whether the remaining questions stay or disappear! With the disappearing template, after a student has answered the designated number of questions correctly, the remaining questions will disappear. With the non-disappearing template, the questions will stay for students who wish to continue working (and maybe earn some extra credit or bonus points!)
What goes on Sheet 1?
Title
Directions
What goes in Sheet 2?
image/phrase to appear once enough answers are entered correctly
The number of questions you want students to answer
The questions you want students to answer
The correct answers to each question
What can you customize on Sheet 1? You can customize the font style, size and color. You can customize the fill color of all of the cells, the borders, and the size of the cells. Adjust the width of the columns by dragging the columns you want to be wider or more narrow. You can also adjust the height of the rows by dragging to make them taller or shorter.
What goes on Sheet 1?
Title
Directions
Questions
What goes in Sheet 2?
The number of questions you want students to answer
The correct answers to each question
What can you customize on Sheet 1? You can customize the font style, size and color. You can customize the fill color of all of the cells, the borders, and the size of the cells. Adjust the width of the columns by dragging the columns you want to be wider or more narrow. You can also adjust the height of the rows by dragging to make them taller or shorter.
Want to add drop down boxes? Here’s how:
click into the cell where you want a drop down menu
go to “Data” and choose “Data Validation”
in the dialogue box that pops up, change the “criteria” to “list of items” and add your list of answers in the box to the right
click SAVE
Need help with this lesson? Email Lisa at lisa@helloalgebra.com and include the workshop and lesson name so we can help you as quickly as possible.