I have an idea to make a multiple-choice test app for students. includes an answer table with columns:
Answer1: Answer 1
Answer2: Answer 2
Answer3:Answer 3
(These 3 columns are for student responses)
-------------------------------------------------- ------------
PTS1_Ans1: Teacher score 1 of Ans1,
PTS1_Ans2: Teacher score 1 of Ans2,
PTS1_Ans3: Teacher score 1 of Ans3
PTS2_Ans1: Teacher score 2 of Ans1,
PTS2_Ans2: Teacher score 2 of Ans2,
PTS2_Ans3: Teacher score 2 of Ans3
Total_Score column: Is the total score of teacher 1 or teacher 2
(These columns are teacher 1's scores, teacher 2's scores)
Request:
How to grade student answer sheets
The columns PTS1_Ans1, PTS1_Ans2, PTS1_Ans3, Total_Score are only visible to teacher 1's user
Columns PTS2_Ans1, PTS2_Ans2, PTS2_Ans3. Total_Score is only visible to teacher user 2
-------------------------------------------------- ---
Answer Form
Table Answer
Teacher1
Teacher2
User Manage
Solved! Go to Solution.
Hi,
First, you need to set your score and total columns as Number type instead of text.
To put a score in one of your column , you can use IF() as formula
Ex, for answer 1 , assuming D is the correct answer : if([Answer 1] <> "D", 1 , 0)
if there are several options : if(or([Answer 1] = "D", [Answer 1] = "A") , 1, 0)
To count the total score :
[PTS1_Ans1]+[PTS1_Ans2]+[PTS1_Ans3] (as formula)
Hi,
First, you need to set your score and total columns as Number type instead of text.
To put a score in one of your column , you can use IF() as formula
Ex, for answer 1 , assuming D is the correct answer : if([Answer 1] <> "D", 1 , 0)
if there are several options : if(or([Answer 1] = "D", [Answer 1] = "A") , 1, 0)
To count the total score :
[PTS1_Ans1]+[PTS1_Ans2]+[PTS1_Ans3] (as formula)
Yes. Tks for your help
User | Count |
---|---|
33 | |
30 | |
29 | |
20 | |
18 |