Internal assessment creation is a simple step but how do you add a mistakenly left out class so that it doesn’t appear odd on the report card(so that it doesn’t appear like a new internal assessment) .
Either edit the created one as a bulk or combine in a SQL statement (it is the first created so a destructive SQL will not destruct previous assessments)
Hi Kelvin, thanks for sharing. I’m not sure, are you asking this as a question or sharing your findings? If it’s the latter, feel free to share the example SQL if you feel it will be helpful to others as well. Thanks!
Hi Sandra, yes this SQL will help if it happens to be multiple column and tedious changing one by one:
go to DB open table gibbonInternalAssessmentColumn and confirm the gibbonInternalAssessmentColumnID number of the first and last assessment that you need to change/rename/combine and set them as:
then run the following SQL:
DECLARE counter int ;
SET counter = y;
WHILE counter>=x DO
name = ‘TERM 1 OPENER EXAM’ WHERE
gibbonInternalAssessmentColumnID = counter;
SET counter = counter - 1;
This can be a temporary solution before bulk editing feature is added.