Excellent Learning
Self-Checking Excel Spreadsheet
Self-Checking Excel Spreadsheet Template
This template contains the simple formula of =IF(Cell="answer","Great!","")
in the "Check" column. You would replace Cell with the actual cell
number. (i.e. C8) This is the template modeled during Technology Integration
Training with Jenniefer Jones.
Self-Checking / Self-Grading Excel Spreadsheet
Self-Checking / Self-Grading Excel Spreadsheet 20
questions
Self-Checking / Self-Grading Excel Spreadsheet 15
questions
Self-Checking / Self-Grading Excel Spreadsheet 10
questions
Self-Checking / Self-Grading Excel Spreadsheet 5
questions
These templates not only give students immediate feedback, but also grade the work for the
teacher. It is important to NOT change the positive reinforcement message within these
templates as it will make it so that grading cannot occur.
Advanced Tips
Enter Multiple Lines In An Excel Cell
When you have multiple-choice type questions, you may find that using more than one line
in a cell improves your worksheet's appearance. For example, if you would like to enter a
question, followed by choices A, B, C, and D, you could enter the question on one line of
the cell, then enter choice A on the next line, and so on. To try this, click cell A1 and
type your question. Now press Alt + Enter and type your first answer choice. You now have
two lines in the same cell. Excel will adjust the cell height to accommodate the text.
Protecting Self-Checking / Self-Grading Excel Spreadsheets
The various cells in the Self-Checking / Self-Grading Excel Spreadsheets have already been
locked/unlocked and hidden according to need. All you have to do to protect your
sheet is simply make your desired information changes and then follow these steps:
- Tools (top menu)
- Protection (a choice from the "Tools" drop down menu)
- Protect Sheet (a choice from the "Protection" pop out menu)
- Save you file
Other Ways to Integrate Excel
http://www.mindspring.com/~kadkins/strategy.htm
|