- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jul 02, 2021 05:02 AM
I am looking at to build a system which will allow me to keep track of the walkthrough I do with my teachers as a school principal.
I have one tab with all the teachers, one tab with all the standards we are looking at.
My goal is when I start a walkthrough would be to:
- Select the teacher
- Upload medias
- Add notes in 3 boxes: description fo the observation, area of strengths, suggestions
- Rate the selected standards (probably 5 maximum for one walkthrough), and add a note next to the rating
What would be the best way to design this ? My issue is on the standard as for ONE ENTRY (one walkthrough for one teacher), I can see how to deal with the medias and the three notes, however I don’t see how I can select the standards I want to rate and rate them.
If you have done think kind of design or you know a template that could inspire me, I would love to see it.
Solved! Go to Solution.
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jul 06, 2021 07:09 AM
It sounds like you need a junction table.
I’ll call this [Teacher Ratings]
. Each record in this table would link to one record from [Teachers]
and one record from [Standards]
, and allow you to assign a rating for that teacher related to that standard. With five standards, that would be five records per teacher.
On the [Teachers]
table, you would see incoming links from these records for each teacher. To tell at a glance what these ratings are, set the primary field in the [Teacher Ratings]
table as a formula that concatenates the teacher name (or maybe initials for brevity), the standard, and the rating. That way you could see all ratings for a given teacher at a glance on the teacher’s record by looking at these links.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jul 06, 2021 07:09 AM
It sounds like you need a junction table.
I’ll call this [Teacher Ratings]
. Each record in this table would link to one record from [Teachers]
and one record from [Standards]
, and allow you to assign a rating for that teacher related to that standard. With five standards, that would be five records per teacher.
On the [Teachers]
table, you would see incoming links from these records for each teacher. To tell at a glance what these ratings are, set the primary field in the [Teacher Ratings]
table as a formula that concatenates the teacher name (or maybe initials for brevity), the standard, and the rating. That way you could see all ratings for a given teacher at a glance on the teacher’s record by looking at these links.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jul 06, 2021 05:46 PM
Thanks for your help, you give me the right direction, and it works beautifully.