Help: Grading for students

[nghilttran]

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

Answer Form

Table Answer

Table Answer

Teacher1

Teacher1

Teacher2

Teacher1

User Manage

User Manage

[baba_sawane · Accepted 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)

[nghilttran]

Yes. Tks for your help