Task cards are great, aren’t they? Students like them, teachers like them, administrators like them, there’s really no reason to not like them! Figuring out how best to create digital task cards has been a journey for me; but I persevered and was rather content with the digital task cards I had come up with, except one thing–I had no way of know what my students had answered, or I had to click through multiple slides for each student and check everything by hand. I missed the recording sheets and the relatively easy grading methods I had for paper-based task cards. Until last week that is! It took some thinking and experimenting, but I knew that if I could use conditional formatting to create games and mystery pictures, I should be able to use conditional formatting to create self-grading task cards. I was correct, it is possible, and I’m going to tell you exactly how I did it. But first, here’s a look at these cards in action so you can see why I’m so excited about them!
Cool, right? And they were extremely easy to make. This is possible in both Excel and Sheets, but I find it a little easier to complete in Sheets because there are fewer options. The good news is that Sheets can be downloaded as Excel (click File, Download, Microsoft Excel) and all of the formatting stays in place. These directions will be for Sheets.
The first thing I did was rename the first tab as “Directions.” To rename a tab:
- go to the bottom of the screen
- right click where it says Sheet1
- click Rename
- type the new name for the sheet
I then clicked in the first cell and started typing my directions. I chose to type one sentence per line in hopes the students will read the directions more carefully if they weren’t in paragraph format. To insert the arrow directing them to the tabs for the questions I did the following:
- Click Insert
- Click Drawing
- I chose the arrow I wanted from the shapes menu and drew it on the screen.
- Click “Save and Close” in the upper right corner.
- Reposition and resize the arrow to fit your needs.
After the directions are finished it’s time to add the question, answer, and grade tabs. I recommend that you add the answer tab first and you update it as you go. To add a tab click the + sign in the bottom left corner. Change the name to “Answers” using the above steps. I chose to label column A as “Question,” so I could easily see which question the answer corresponded to, and I went ahead and numbered down column A (type 1 into cell A2, grab the bottom right corner of the blue outline around the cell and pull down, the numbering will be done automatically). Column B I labeled “Answer.” Going back to my directions tab, I again clicked the + button and renamed this newest tab “1” for question one.
On the question tabs you are going to include whatever you would normally place on a task card. I chose to include a picture (click Insert, Image, Over Cells) and the sentence that I wanted them to complete. One thing you do need to be sure and include though is an easily identifiable place for them to type their answer. You need to know exactly where the answer will be typed in order for the conditional formatting to work. I took care of this problem by choosing a cell, resizing it (not necessary but I wanted it to be large and not easily missed), and coloring it tan. Now that your first task card is set up, it’s time to make the magic happen on the answer sheet.
- Click on the answer tab.
- Click in the cell for the answer to question/task 1 (cell B2 on my sheet).
- type =
- Click on the answer cell from task card 1 (click on tab 1, click on the answer cell).
- Click on the Answers tab.
- Hit enter.
Now anything typed into the answer cell on task card 1 (tab 1) will automatically appear in the corresponding answer cell on the Answers tab. Next I need to do the conditional formatting for the self-checking part of the task cards. (This step is not necessary if you are not planning to allow students access to the answer tab but it only takes a moment and I think it’s worth it.)
- On the Answers tab click on the cell for the answer to question 1 (cell B2 on my sheet).
- Click Format
- Click Conditional Formatting
- Under Format rules, Format cells if… choose “text is exactly”
- Type the correct answer in the box labeled “Value or formula”
- Choose the color you want the cell to turn (I leave mine green).
- Click Done.
To test this out, click on tab 1, type the correct answer in the answer box, hit enter. Now click on the answer tab and next to number 1 should be your answer and the cell should be green. This in itself is cool, but now to make it self-grading!
- On the Answers tab click the cell next to the answer for question 1 (cell C2 on my sheet).
- type =IF (that’s equals sign IF)
- click the cell with the answer (Answers tab cell B2 on my sheet)
- type the correct answer in quotation marks (i.e.: “much”)
- type ,1,0 (that’s comma one comma zero)
- hit enter
The cell next to your answer for question one should now have a number 1 in it. You have now completed the set up for task card 1.
To create the next task card you could start from scratch, but I recommend copying and pasting to save yourself a little setup work.
- Right click on tab 1 at the bottom of your screen.
- Click Duplicate
- Rename the new tab 2 (or whatever number you are on).
Now you just need to change elements such as the picture (if you choose) and the question. The answer box is already formatted for you, as well as any static elements you may have included (i.e. a border). Once the card is designed to your satisfaction, follow the steps above to update the Answers tab. Continue repeating these steps for each of your task cards.
Only a few things remain to be done. The first step is to finish the auto-grading feature.
- On the Answers tab click the cell below the points for the last question (the cell immediately bellow the last 1/0 cell, on mine it was cell C27).
- type =SUM( (that’s equals sign SUM and open parenthesis)
- click on the 1/0 cell for question 1 (cell C2 on my sheet) and drag down to highlight all of the 1/0 cells
- release your mouse button
- hit enter
You now have a total number of questions correct. To convert this to a percentage, be sure you are in the cell below your total score (cell C28 on my sheet).
- type =
- click the cell with your total score (cell C27 on my sheet)
- type / (that’s a forward slash or divide sign)
- type the total number of questions
- hit enter
- click again on the cell with your percent (cell C28 on my sheet)
- click Format
- click Number
- click Percent
- hit enter
You now have a percentage grade for the activity.
This next part is totally optional but I wanted it because I sometimes use task cards as an assessment. The Answers tab will now clearly show which questions are correct and which are incorrect. This is great if I want students to be able to go back and correct their work, but what if I don’t want to make it obvious which questions are right or wrong, and I still want them to know their final score? My solution was a grade tab.
From the Answers tab create a new tab by clicking the + sign in the bottom left corner. Rename the new tab “Grade.” I then inserted a picture (just for fun) and an encouraging message. I then chose a cell and typed “Number Correct” (cell H4 in my example). In the next cell over (cell I4 on my sheet) I told it to automatically populate from the Answers sheet.
- On the Grade tab click where you want the number correct to appear (cell I4 on mine).
- Type =
- Click on the Answers tab.
- Click on the box with the total correct (cell C27 on my sheet)
- Click on the Grade tab.
- Hit enter.
I then repeated this process a row or two lower for the total percentage, this time pulling in the percentage from the Answers tab (cell C28 on my sheet). I now have a sheet that will show my students their grade, but not which questions are correct or incorrect. On this tab they are still able to see that they answered N questions incorrectly, but they don’t know which ones.
The final step is to hide the Answers tab so they don’t have access to which specific questions are correct or incorrect (this step is optional but good if you want to use the cards as an assessment). To hide a tab:
- Right click on the tab you wish to hide.
- Click Hide sheet.
To make the tab visible again (if you want to look at specific answers without having to click on every tab):
- Click View.
- Click Hidden Sheets
- Click Answers
Can students do this too? Yes. Are they likely to think about it and do it? Probably not. Unless they know the tab is there they have no reason to go looking for it. Add to that the fact that they’d have to be able to read the conditional formatting formulas we inputted to get the correct answers, and cheating is highly unlikely.
That’s it, you now have a complete set of self-grading digital task cards. To use them you will need to make a copy of the document for each student and give them editing rights (be sure you’ve deleted any answers you typed on the question tabs as you tested things out). The best way of doing this will depend on your learning management system. To do this on Blackboard I create a Force a Copy link and post the link in my assignment. In Google Classroom you can just put the link into classroom and choose “make a copy for each student.” The important thing is that each student have his or her own copy of the cards.
This truly is my new favorite way to do task cards. I like it so much that I’m planning to go back and recreate some of my other task cards (the ones where students move circles to indicate their choice and I have to check each slide individually) using this method. I hope you find it helpful as well, happy teaching!