Markbook export question

Hello everyone,
I have a small problem with the markbook output. The first picture shows that I have the scores of term1~term3.
When outputting to excel, only the cumulative average score is displayed.
What adjustments do I need to make to fully display the scores of term1~3, thank you so much.

Hi Kevin, I’ve made this change in v24, you can copy the updated file to your system to make the same changes prior to v24: https://github.com/GibbonEdu/core/commit/41bc69f516a106e094b41b7aee27e4504b8611d0

Hi Sandra and Kevin,
Pls I have a quick question. I need to calculate students’ final scores from the weightings in the attached picture. The assessment and Mid-semester exams are 30% each while the final exam is 40%. I’d like to calculate their total score at the end of the semester and then assign a letter grade.

Please how can I do that in the Markbook?

Hi Kevin, I've made this change in v24, you can copy the updated file to your system to make the same changes prior to v24: https://github.com/GibbonEdu/core/commit/41bc69f516a106e094b41b7aee27e4504b8611d0

Thank you Sandra,this is a great help,i am sorry so late to give feedback, i got COVID, but i am better now, thank you again.

Hi Kevin, sounds rough, glad to hear you are on the mend!

Hi mbash, be sure that your system-wide grade scale is set to percentage in System Admin > System Settings, this should enable the markbook to calculate the scores that you’ve entered.

Hello @ross ,i get new question, when i want export the term markbook to excel, i can see every type’s average on the system,but the excel file only show all term score .
because i need teacher use the average score for each type ,like “writing” or “reading”
Can i export only by single term and include the markbook type’s average?
thank you very much.
have a nice day Kevin

[image removed for privacy reasons, but link shared with Sandra]

excel file

Hello @ross ,sorry to bother you agin,if you have time please help me again about my last question.
now i have another question about markbook Weighting,is it possible setup diffient weighting in diffient term
,because my scholl in the term 1 ,don’t have exam

like image 1,

Hi Kevin, the weighting system is not this fine-grained, however I don’t see that it needs to be, as it doesn’t treat a lack of marks in a category as a 0. You should be able to use your 30/30/30/10 for all your terms. In a term where there isn’t a mark in the exam category, the weighting calculator will handle the missing category properly by effectively adjusting the weights of the other categories, no need to do this manually (it can properly handle weights that add up to less than 100% or even more than 100%). Hope this helps!

Thank you Sandra,you spend a lot of time to answer my question,
now i know it , and i will explain it to my workgroup,thans again.

Hello @sandra ,i get new question, when i want export the term markbook to excel, i can see every type's average on the system,but the excel file only show all term score . because i need teacher use the average score for each type ,like "writing" or "reading" Can i export only by single term and include the markbook type's average? thank you very much. have a nice day Kevin

[image removed for privacy reasons, but link shared with Sandra]

excel file

Sorry @ross ,how about this question, or this funcstion is working at Query Builder module.
thank you , have nice day. kevin