+ Reply to Thread
Results 1 to 2 of 2

monitoring students

  1. #1
    Registered User
    Join Date
    10-02-2004
    Posts
    3

    Question monitoring students

    I am involved in education and have an interesting problem

    Students are creating spreadsheets in the work that we do, simple example would be

    place a value in column A and B, in C create the product of A and B, but hwat we are interested in is the formula the students use, ie =A1*B1. When they ahve put formula in we would like the sheet to indicate to us that the formula is correct. Problem nukmber of variations of acceptable formulae. Thought about data validation but this of course produces a drop down list for student to choose from. Tried Conditional formatting but to no avail.

    any chance of any help from anyone. Please

  2. #2
    Forum Expert swatsp0p's Avatar
    Join Date
    10-07-2004
    Location
    Kentucky, USA
    MS-Off Ver
    Excel 2010
    Posts
    1,545
    If we can assume that any formula that returns the "correct" answer is a "correct formula", you could put the following in D1:

    =IF(C1=A1*B1,"CORRECT","ERROR") where A1*B1 represents a formula to generate a "correct answer"

    Then I would unlock all the cells that the students are to use and Lock the cells with my validation formula. Then Protect the sheet and not allow "select locked cells" to prevent them from seeing my "correct formula". They would only see either Error or Correct.

    Good Luck
    Bruce
    The older I get, the better I used to be.
    USA

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1