Practice Test Using Excel
I want to design a practice test for my students, who need to memorize --
verbatim -- a list of 37 characteristics. I would like to use an Excel 2007 spreadsheet to allow them to practice. Ideally, the practice spreadsheet would possess the following characteristics, based upon text-based input: - keyboarding the phrase verbatim changes the block to green; or, - keyboarding a phrase which does not match, but which does contain keywords (which I designate), changes the block to yellow; or, - entering a complete miss changes the block to red; or - leaving it blank turns it to red. I can conditionally format one cell to correspond to a "paired" cell and achieve the results I want; however, students don't always memorize the characteristics in the same order -- some use the alphabet, some use geography, others seem to "free-flow" their answers. How do I compare their entry to 37 possible answers, and provide the correct result? Also, I don't want them to enter one correct response 37 times, and achieve 37 "greens." Can anyone assist? thanks in advance! -- downinfl On the Sun Coast |
Practice Test Using Excel
My, my, my! This is such a helpful resource ... NOT!!
-- downinfl On the Sun Coast "downinfl" wrote: I want to design a practice test for my students, who need to memorize -- verbatim -- a list of 37 characteristics. I would like to use an Excel 2007 spreadsheet to allow them to practice. Ideally, the practice spreadsheet would possess the following characteristics, based upon text-based input: - keyboarding the phrase verbatim changes the block to green; or, - keyboarding a phrase which does not match, but which does contain keywords (which I designate), changes the block to yellow; or, - entering a complete miss changes the block to red; or - leaving it blank turns it to red. I can conditionally format one cell to correspond to a "paired" cell and achieve the results I want; however, students don't always memorize the characteristics in the same order -- some use the alphabet, some use geography, others seem to "free-flow" their answers. How do I compare their entry to 37 possible answers, and provide the correct result? Also, I don't want them to enter one correct response 37 times, and achieve 37 "greens." Can anyone assist? thanks in advance! -- downinfl On the Sun Coast |
All times are GMT +1. The time now is 06:33 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com