Forum Discussion

Copper Contributor

Sep 03, 2022

Solved

Tracking student progress

I'm looking to create my own grade book to track student progress over time. My school district refuses to provide an adequate grade book solution for the competency-based assessment model which we n...

Formulas and Functions

Riny_van_Eekelen
Sep 25, 2022
JeffreyB593 Not sure I follow, but when I select/enter some new Competencies and refresh the pivot table, all seem to be included properly. With respect to adding new assignments, select the last block from the table (i.e. T1:W37). Copy and Paste to X1. The table is expanded with all the formats and data validation in place. Do NOT select entire columns T to W. Then it will not work.

JeffreyB593

Copper Contributor

Sep 25, 2022

Thanks so much. The old system, a six-point scale, was much easier to work with and I think the students understood it better, but these new competencies and the scale are now Provincially mandated by the Ministry of Education. Some folks who are not teachers sat around a boardroom table and thought this up. Now I'm required to use it. As you said, daily conversations with students allow them to know where they stand but I have to report out on all of these. If I was closer to retirement I wouldn't bother but I still have eight years to go so I can't really buck the system. All of this wouldn't have been a problem if they had provided some sort of reporting software when they changed the Assessment model. I could rant for days on this topic so I'll stop.

mathetes

Gold Contributor

Sep 25, 2022

JeffreyB593

The old system, a six-point scale, was much easier to work with and I think the students understood it better, but these new competencies and the scale are now Provincially mandated by the Ministry of Education. Some folks who are not teachers sat around a boardroom table and thought this up. Now I'm required to use it.

Yet another example of "best intentions having unintended side effects" downstream, decisions made by folks who don't actually have to live with the consequences!!

If I was closer to retirement I wouldn't bother but I still have eight years to go so I can't really buck the system. ... I could rant for days on this topic so I'll stop.

If I were a taxpaying voter there, I'd be ranting on it myself.

I hope your last eight years go well despite this kind of interference!