Hey all, had some exceptional responses on this website, im looking for some ideas / templates of the best possible way to perform our Grading Exam (Martial Arts Club) so it makes it as simple as possible for the end user, not caring about difficulty my end creating the total product, any pictures or screenshots you need please let me know ill post them 
I am not looking for people to do all the work for me or anything just the most streamlined way of performing such a task
We would like a form that grades our students based on specific moves, we have 3 different rotations of moves and we also have 3 sets of belt levels, (Beginner, Intermediate, Advanced) so 9 different forms depending on the rotation and level, also each examiner can take up to 3 students. IF possible, we would like to be able to assign students to examiners so when examiners come to the app, they click their name and the students names pop up automatically.
can give a quick example of the sort of system
We give a score of 1 2 or 3 per heading
Straight Punch | Back Fist | Outside Block | Round Kick | Shoulder Grab | 2 Handed Push | Sparring | Impact | Drills
That would be our first rotation for beginners and rotation 2 changing most of the moves and rotation 3 changing again, then intermediate being completely different
My main question : Slices or no slices? is there a better method of having dependant dropdowns
Thanks for looking, any questions or screenshots let me know! Thank you
1 Like
Before you think about the dropdowns or other elements of the user interface, think about your data model. Which tables you require to store the data, what columns/fields they will have and how they will be related. Straight away I can see you will probably need the following tables:
-
Examiners.
-
Levels - perhaps with some colour coding through format.
-
Students - with reference field for current belt level and reference field to examiner.
-
Moves - I think these would also have a reference to level and probably a sequence for ordering.
-
Exams - reference to student, examiner, level and possibly having a date/time?
-
Grading - reference to exam, move and providing for a score
With this structure built in a spreadsheet and ID fields named appropriately, you should find that AppSheet will generate most of the application for you.
1 Like
Got the Database set up and list of examiners and student id and all data set, just wondering how i can make it possible to score 3 different students at the same time while loading from a specific form
1 Like
@graham_howe excellent data structure I couldn’t agree more.
You could have your form as a tab this would let you have three different students in the tab view and you could switch back and forth between the students as they go through their moves. There you can have this fill out the grading in the form.
You also may need to get a few things that are only in an admin view. This would allow you to assign students to examiners but they could then not reassign them to someone else.
I do not know what the structure is like there but if you have one person in charge they can assign the students to the examiners that are coming in that day. The admin view is just a normal view but in the show if section you could have something like this:
ANY(SELECT(Examiner[Role],USEREMAIL()=[Email]))=“Admin”
I would be happy to help in any way I can as you continue and I will check your post often. For anything I can do to help. I have linked a few resources below that I find helpful.
Lastly if I may I was a high school teacher for 2.5 years and it was very rough. Any program that teachers students a skill and gives them something to look forward to and perform their best at is extremely valuable in today’s global society. My very best of luck to you and my utmost respect for this Martial Arts Club.
Craig
QREW Technologies
appsheettraining.com
AppSheet Training Youtube Channel
Expressions Page
I appreciate you Craig! been teaching and training in martial arts for 26 years now (30 year old just now) and absolutely love the job and everything you can instill into children from a young age very rewarding haha!
Your solution is exactly how i had it done before with my normal grading, i was looking at possible slicing so its
Select Examiner, Date and clicking save so it slices into Student 1 - Straight Punch | Student 2 Straight Punch | Student 3 straight punch giving them score and clicking save —> Student 1 - Back Fist etc etc, not sure how doable this is but it would allow our admin to keep tabs on the grading scores as it is happening, thoughts?
Okay, you could try this. You could have a dashboard view in the app. And you can make three from views and call them student 1, 2, 3
Now students have names not numbers so in the display section and display name you can dynamically set those titles of the views. For instance in the display name you could write an expression to have it fill in the students names.
Once you have those three views up you can open them all as forms in that dashboard at once. Then the form can be the complete test that the student is being given. Your idea will work from what it sounds like, using slices like that but this way would have a way of having less save buttons.
Also I can help you here and there on this post but my company does offer consulting hours if you are interested feel free to go to appsheettraining.com and sign up for a tech talk on the bottom right. This would get you help with an expert and can get your app off the ground. I won’t being it up again and am sincere about helping you but that is an option available to you.
Craig
QREW Technologies
Would that dashboard view handle multiple students with multiple instructors? sounds like an awesome way to fix the problem im having, what sort of expression could you use to change the display name? honestly never used that option in data, will look into the website about training! thanks for your help
