Help: Grading for students

AppSheet AppSheet Q&A
1

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
Answer Form715×725 35.6 KB

Table Answer

Table Answer
Table Answer1249×657 44.1 KB

Teacher1

Teacher1
Teacher1869×653 27 KB

Teacher2

Teacher1
Teacher1869×653 27.6 KB

User Manage

User Manage
User Manage426×215 3.45 KB

2

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)

3

Yes. Tks for your help