art 1 | art 2 | drawing&ptg | comp. graphicss | adv. comp. graphics | visual literacy | ceramics I | ceramics II | sculpture&jewelry | art history
 

Google Forms

tests and quizzes

Here is a simple way to create an online quiz using only Google Forms app. There are no additional apps or platforms. Grading is done automatically within a minute. I use it for some of my formative assessment.

See this quiz at the bottom of the page.

Step 1: create a form

Go to your Google Drive

Create a New Form

Rename the form by clicking on the "Untitled form" sign.

Give it a descriptive name (ex. "Art-1 Color Theory")

Click OK.

You can also add a descriptive text right below the quiz name

(ex. "Art vocabulary" or "pre-test", etc.)

Step 2: create required field(s)

Start with a required field: student's name.
Choose question type: Text
Check the Required question box. Then click Done.

If you want to, you can add more text fields for other student information: class period, homeroom teacher, etc.

Step 3: Questions

Start adding questions to your quiz by clicking on an arrow next to Add Item button.
You can click directly on the button if you want to keep settings from the previous question.

For my first question I used Multiple choice question type.

 

 

Question title: type in your question. You can number your questions here if you want to.

Help text: add more detailed instructions or hints (it's optional)

Question type: You can change the question type at any time here

Answer choices: type in as many or few as you want

This is what the question looks like when it's done.

Next question: True/False

Again, I used the Multiple choice question type.

The two answer options are: True and False.

This is what it looks like.

Adding an image to a question will require 2 steps:

  • 1. Adding Image
  • 2. Creating a new question

Start with clicking on Image option in the Add Item menu.

Drag and drop your image here or choose other options to upload it.

Pay attention to image sizes. I use images between 200 pixels and 400 pixels wide.

The image you see in this screen-shot is 200x200 pixels.

You can type in your question here.

Click Done when it is uploaded.

Image itself does not support any answer options.

You need to create another item to offer the answer type.

In this example I chose Choose from a list.

Do not type your question here (you have already done it in the image window.

Choose the type of question, then type in the answer options.

This is what it looks like.

Next type of question is Checkboxes.

This option allows students to select multiple answers.

Here is what it looks like.

Step 4: the looks

After you are done with all quiz questions - time to apply some design to your quiz, just to make it more friendly. :)

Click on Change theme

Scroll down the right pane to choose one of the existing designs.

You will get an immediate preview, and you can change the design later.

Step 5: answer keys

To make the quiz work - you need to create the answer keys to your questions.

Click on View live form.

It will bring you to the quiz page.

For the name field you can type: teacher, answer keys, your name, etc.

The important part is that you need to be very careful and answer everything correctly.

Do not leave any questions unanswered.

Click Submit

Congratulations!

This part is done!

Step 6: answer records

Once you created a form, Google Drive will automatically create a spreadsheet with the same name. This is where you will find all responses to your questions. Also, you are going to set up all calculations here.

In the Responses spreadsheet you will see that every question is placed in a separate column. There is also an additional column with date and time when the quiz answers have been submitted.

Select the entire row 2 (your answer keys). I usually freeze it, so I don't accidentally change something in the answers.
Go to View > Freeze rows > Freeze 2 rows (You want to keep the first row with questions frozen too).

Then I insert another column next to the student's name column.
Click anywhere in column B. Then go to Insert > Column Right

This is where I will record the correct answers - so I give it this title.

Then I answered the quiz one more time (you see "test" for student's name). This time I intentionally answered some questions wrong, just to check if the formula will work.

Click on the cell C3 (as shown) or, if you have a different structure, the corresponding cell (column: Correct answers, row: test)

FORMULAS

Now, this is where it can get a little more difficult if you are not fluent with spteadsheets and the formulas. But no worries!

This is what we are trying to achieve in our formula:

    1. compare each answer with the answer keys;
    2. if the answer matches the key, it will receive 1 point (or more, if you wish to grant more points for certain questions);
    3. if the answer does not match the key, it will receive 0 points.

This is what it will look like in the shpreadsheet language:

=(IF(D3=$D$2,1,0)+IF(E3=$E2,1,0)+IF(F3=$F$2,1,0)+IF(G3=$G2,1,0))

 

If this looks confusing, here is what it actually means:

=(IF(D3=$D$2,1,0)+IF(E3=$E2,1,0)+IF(F3=$F$2,1,0)+IF(G3=$G2,1,0))

Simply means that we are starting a formula, where the content of the cell will be equal to what is in the parentheses.
=(IF(D3=$D$2,1,0)+IF(E3=$E2,1,0)+IF(F3=$F$2,1,0)+IF(G3=$G2,1,0))

This is an "IF" formula.
It says this:
IF cell D3 equals cell D2, then it is given the value 1, if not, then 0

IF(D3=$D$2,1,0)

The $ sign makes it an absolute cell reference (to prevent automatic formula adjustments while copying and pasting the formula).

=(IF(D3=$D$2,1,0)+IF(E3=$E2,1,0)+IF(F3=$F$2,1,0)+IF(G3=$G2,1,0)) All values, given to each cell, are added for the final grade.
Add as many cell references as you have questions.

Once you've added the calculation formula, hit Enter (Return) to apply the calculations.

The result will show immediately.

You can copy and paste the formula here:

=(IF(E3=$E$2,1,0)+IF(F3=$F$2,1,0)+IF(G3=$G$2,1,0)+IF(H3=$H$2,1,0)+IF(I3=$I$2,1,0)+IF(J3=$J$2,1,0)
+IF(K3=$K$2,1,0)+IF(L3=$L$2,1,0)+IF(M3=$M$2,1,0)+IF(N3=$N$2,1,0)+IF(O3=$O$2,1,0)+IF(P3=$P$2,1,0)
+IF(Q3=$Q$2,1,0)+IF(R3=$R$2,1,0)+IF(S3=$S$2,1,0)+IF(T3=$T$2,1,0)+IF(U3=$U$2,1,0)+IF(V3=$V$2,1,0)
+IF(W3=$W$2,1,0)+IF(X3=$X$2,1,0)+IF(Y3=$Y$2,1,0)+IF(Z3=$Z$2,1,0)+IF(AA3=$AA$2,1,0)+IF(AB3=$AB$2,1,0)
+IF(AC3=$AC$2,1,0)+IF(AD3=$AD$2,1,0)+IF(AE3=$AE$2,1,0)+IF(AF3=$AF$2,1,0)+IF(AG3=$AG$2,1,0)+IF(AH3=$AH$2,1,0))

This formula is good for a quiz with 30 questions. First question starts in column E. You can modify it to fit your needs.

Step 7: distributing the test

 
 

Step 8: grading

After you have your students complete the quiz:

Copy the cell with formula: Edit > Copy (or Ctrl/Command C)

Click on the cell below (your 1st student).

Edit > Paste (or Ctrl/Command V)

After that, click and drag down the bottom right corner of the pasted cell.

It will calculate all grades at once.

Isn't that nice?!!

You can also adjust the cell formatting for a better view:

I made the row 1 a little taller, and changed the text wrapping to "wrap" - so I can read the entire question.

You can also add another column and have the percentage calculated as well.

Add a formula to your test row 3:


=C3/4%

Where:
= starts a calculation formula
C3 is the cell with the correct answers
/4 out of 4 questions
% shows the percentage

Copy the cell formula
Paste and drag down to apply to the rest of the rows.
You can change the background color if you want to...

 

 

 

top

home | my art | my ceramics | my graphics and cards | my paintings | art lessons online | resources | school art classes | art 1 | art 2 | computer graphics | adv.comp.graphics | visual lit | drawing & painting | ceramics 1 | art history | contact | privacy policy