I want to create an app that tracks students' development based on the different competence goals

Ask for Help
1

Hello, my name is Inge and im a teacher. i want to track my studenet development without the need for tests all the time.
So in norway we have competence goals, so f.eks if my studenst program a CNC robot i want to asess them on how good they are at it and how they evolve over the year. . såp if i could have an app, whith the students names, when i press a name, a new page comes up, here i kan choose one or more competence goals, hit next and grade their performance, klick next again and many add comments. an finaly finish. everything gets logged and i kan then get a list og which student has done the differnet goals, and ti what level of success.

2 Likes
2

Glide is perfect for your use case.

3

You can start with a structure like this in Glide Tables.

1. Students Table

Student ID Student Name Class Email
S001 Ola Nordmann 10A ola.nordmann@email.com
S002 Kari Svendsen 10A kari.s@email.com
S003 Ahmed Ali 10B ahmed.a@email.com

2. CompetenceGoals Table

Goal ID Goal Name Subject Description
G001 Programmere CNC robot - Sikkerhetsprosedyrer Teknologi Forstå og anvende sikkerhetsregler ved CNC
G002 Programmere CNC robot - Grunnleggende G-kode Teknologi Kunne skrive enkel G-kode for basisoperasjoner
G003 Kretsdesign - Seriekobling Elektronikk Designe og koble en enkel seriekrets
G004 Kildekritikk på Internett Samfunnsfag Vurdere troverdigheten til digitale kilder

3. Assessments Table

Assessment ID Date Student ID Goal ID Performance Level Comments Teacher
A001 2023-09-15 S001 G001 Developing Forsto viktigheten, men glemte noen sjekkpunkter. inge.teacher@skole.no
A002 2023-09-15 S002 G001 Proficient Utmerket forståelse og praksis. inge.teacher@skole.no
A003 2023-10-20 S001 G001 Proficient Mye bedre! Alle sjekkpunkter fulgt. inge.teacher@skole.no
A004 2023-11-05 S001 G002 Emerging Trenger mer øvelse på G-kode struktur. inge.teacher@skole.no
A005 2023-09-22 S003 G003 Proficient Godt designet seriekobling. inge.teacher@skole.no
A006 2023-11-10 S002 G004 Developing Identifiserte noen usikre kilder, trenger mer dybde. inge.teacher@skole.no
A007 2023-11-15 S001 G002 Developing Forbedring i G-kode, men fortsatt noen feil. inge.teacher@skole.no

Key things to note in this structure:

  • Student ID in the Assessments table: Each value here (e.g., S001, S002) directly corresponds to a Student ID in the Students table. This is how you know which student the assessment is for.

  • Goal ID in the Assessments table: Each value here (e.g., G001, G002) directly corresponds to a Goal ID in the CompetenceGoals table. This tells you which competence goal was assessed.

  • Primary Keys: Student ID, Goal ID, and Assessment ID are unique identifiers for each row in their respective tables. Glide can generate these as “Row IDs” for you.

1 Like