+ Post New Thread
Results 1 to 4 of 4
How do you do....it? Thread, Detecting correct answer - MS Word / Excel in Technical; I'm trying to find a way to automate the marking of a piece of classwork, using either MS Word or ...
  1. #1

    Join Date
    Mar 2007
    Posts
    379
    Thank Post
    21
    Thanked 3 Times in 3 Posts
    Rep Power
    16

    Detecting correct answer - MS Word / Excel

    I'm trying to find a way to automate the marking of a piece of classwork, using either MS Word or Excel.

    Basically the plan is to describe a question for the user, and then accept their answer (its done multiple choice, so a single number will be given as an answer). The file then gets sent to the teacher.

    When the teacher opens the file, they want to be presented with an answer, either "correct" or "incorrect" preferrably with a total.

    I'm thinking along the lines of Macros here if I go down the Word road, but if I go with Excel I could do a number of "if" statements (which check each field against a set of answers) which are triggered by a macro.

    Any suggestions?

    Thanks in advance!

  2. #2
    Scotmk's Avatar
    Join Date
    May 2007
    Location
    Milton Keynes
    Posts
    277
    Thank Post
    1
    Thanked 4 Times in 3 Posts
    Rep Power
    16

    Re: Detecting correct answer - MS Word / Excel

    search for creating excel quizes, this is the same as these, I cannot remember the statement, but it can be done.


    go here and select first line

  3. #3

    Join Date
    Mar 2007
    Posts
    379
    Thank Post
    21
    Thanked 3 Times in 3 Posts
    Rep Power
    16

    Re: Detecting correct answer - MS Word / Excel

    Thanks very much!

  4. #4

    Join Date
    Oct 2005
    Location
    Lancashire
    Posts
    110
    Thank Post
    0
    Thanked 1 Time in 1 Post
    Rep Power
    0

    Re: Detecting correct answer - MS Word / Excel

    Might be impossible for you but this seems a perfect situation for a VLE (eg Moodle). Create the quiz in there (or import it), get the students to answer it in there and then let the system mark it! Ultimately less work for you. Even better if you start to share quizzes with other teachers.

SHARE:
+ Post New Thread

Similar Threads

  1. Corrupt Word/Excel files
    By ind13 in forum Office Software
    Replies: 5
    Last Post: 6th June 2008, 02:03 PM
  2. Detecting Mobile Phones for Exams
    By Disease in forum How do you do....it?
    Replies: 23
    Last Post: 13th December 2007, 05:19 AM
  3. Cut and paste issues between excel and word
    By 17thcpikeman in forum Windows
    Replies: 1
    Last Post: 30th November 2007, 01:42 PM
  4. HP 2800dtn Not detecting new ink carts
    By Dos_Box in forum Hardware
    Replies: 11
    Last Post: 31st August 2007, 11:10 PM

Thread Information

Users Browsing this Thread

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

Posting Permissions

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