# I want to create an app that tracks students' development based on the different competence goals **URL:** \ **Category:** Ask for Help\ **Created:** [June 3, 2025, 9:34pm UTC](https://community.glideapps.com/t/i-want-to-create-an-app-that-tracks-students-development-based-on-the-different-competence-goals/82228 "2025-06-03T21:34:48Z")\ **Posts on this page:** 3\ **Page:** 1
**Author:** ![Inge\_Holvik\_Kjorrefj](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/inge_holvik_kjorrefj/32/88867_2.png) [@Inge\_Holvik\_Kjorrefj](https://community.glideapps.com/u/Inge_Holvik_Kjorrefj)\ **Post date:** [June 3, 2025, 9:34pm UTC](https://community.glideapps.com/t/i-want-to-create-an-app-that-tracks-students-development-based-on-the-different-competence-goals/82228/1 "2025-06-03T21:34:48Z")
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. ---
**Author:** ![Mazen](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mazen/32/84042_2.png) [@Mazen](https://community.glideapps.com/u/Mazen)\ **Post date:** [June 3, 2025, 10:38pm UTC](https://community.glideapps.com/t/i-want-to-create-an-app-that-tracks-students-development-based-on-the-different-competence-goals/82228/2 "2025-06-03T22:38:41Z")
Glide is perfect for your use case. ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [June 4, 2025, 1:01am UTC](https://community.glideapps.com/t/i-want-to-create-an-app-that-tracks-students-development-based-on-the-different-competence-goals/82228/3 "2025-06-04T01:01:15Z")
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](mailto:ola.nordmann@email.com) | | `S002` | Kari Svendsen | 10A | [kari.s@email.com](mailto:kari.s@email.com) | | `S003` | Ahmed Ali | 10B | [ahmed.a@email.com](mailto: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.