Exam Regrade
Oct 12, 2007
I have a faculty member who needs to regrade an exam. (a CMS problem). The answer key is on one page and each of the individual student submissions are on subsequent pages.
The students all received exams that had the questions and the answers scrambled.
I need to find a way to match the question from the submission to the same question in the answer key and return the correct answer to a new column on the student submission.
A few issues:
* Some of the questions have multiple answers and the submission log lists each as a separate question. (ie. Answer Key #69)
* Not all of the "Correct Answers" are in the same column on the Answer Key (ie. Answer Key #70)
There are about 140 submissions all together -- I need some help trying to figure this one out.
View 9 Replies
Mar 29, 2007
I want to maintain a history of exam results held on different dates
For this purpose I created a file with three sheets named Inputs, Working & result history. Description of all sheet is as follows :
“Inputs” Used as main Input file to feed marks for each subject on certain exam date.
“Working” Linked with sheet inputs and perform calculations ( total marks, % etc)
“Result History” Date wise history of exam results based on sheet (working).
Required Solution Steps:
1.Score entered for different subjects in Sheet “Inputs” for a particular exam date.
2.Obtained marks are totaled and score % calculated based on scores entered in sheet inputs.
3.Date wise history of exam results recorded based on working sheet.
To transfer/copy/paste results from “Working” sheet to “Result history” sheet I recorded a macro which is linked with a button. This macro copy record from working sheet and paste it as value to result history sheet....
View 6 Replies
View Related
Mar 10, 2014
I have a list of students that have sat a number of exams on different dates. Can I pick out from the list the last exam for each person. I can sort by id number and then by date but how do I then show the record showing the latest date for each person?
Example
Mary 1/2/2012
john 2/3/2012
john 1/3/2012
mary 1/1/2012
mary 4/4/ 2012
I want to select the record showing the latest date for each person. the result would be
mary 4/4/2012
John 2/3/2012
View 7 Replies
View Related
Mar 12, 2009
Im trying to make a "IF" function such as: =IF(A1<=B5+360,"Good To Go","Needs Exam")
where A1 is todays date and b5 would be the current date of an exam. So i want it to say Good to Go if its in the paramaters like i have and Needs Exam if its ouside. So i have it working but id like to know how to make it where if it displays "Needs Exam" it Turns the lettering Red. is there a way to do that or no?
View 4 Replies
View Related
