idea for a resource (mainly useful for math, science) (2 Viewers)

killer queen

Well-Known Member
Joined
Oct 21, 2024
Messages
435
Gender
Female
HSC
2025
wow im seeing the google form update in real time this is so cool
LOL then you're seeing me struggle to figure out how to do it haha

if anybody has more google form expertise please hmu this is hard

preferably I would like to do the multiple sections but I don't know if it's possible to make it occur recursively so this is what I've settled on, maybe it'll work better in long rung

I was also thinking in future e.g. next year I might not be as around to tabulate everything so I might need to give access to someone else...
 

cheesynooby

Well-Known Member
Joined
Feb 7, 2025
Messages
445
Location
punklorde
Gender
Male
HSC
2025
LOL then you're seeing me struggle to figure out how to do it haha

if anybody has more google form expertise please hmu this is hard

preferably I would like to do the multiple sections but I don't know if it's possible to make it occur recursively so this is what I've settled on, maybe it'll work better in long rung

I was also thinking in future e.g. next year I might not be as around to tabulate everything so I might need to give access to someone else...
i think ur system rn works!
i was thinking maybe just having multiple of the same questions (doesnt necessarily have to be a new section since they can be non required questions so u dont have to fill them all)
 

killer queen

Well-Known Member
Joined
Oct 21, 2024
Messages
435
Gender
Female
HSC
2025
i think ur system rn works!
i was thinking maybe just having multiple of the same questions (doesnt necessarily have to be a new section since they can be non required questions so u dont have to fill them all)
thanks!! we'll see if it holds up in future - I can give u editing rights if u want, if u wanna pm email? only if u want tho

I'm also betting the smart person rn is u :00

Yea dw we both know that ainโ€™t me
I know bc I know which marks u submitted ๐Ÿ˜
 

C2H6O

Well-Known Member
Joined
Oct 18, 2024
Messages
969
Gender
Male
HSC
2025
Just an idea for the spreadsheetโ€™s formatting, with the colour gradient you could find a score measuring a papers difficulty by , which outputs a number between -1 and 1, 0 being the person got their hsc mark on the test paper, and use conditional formatting to fill the cells with a colour, more negative being green (easy), blank being normal, and positive being red (hard). Thereโ€™s still a couple issues like how a 90 hsc mark doesnโ€™t mean raw 90s is expected, so might have to do a bit more maths-ing there to change it
 

cheesynooby

Well-Known Member
Joined
Feb 7, 2025
Messages
445
Location
punklorde
Gender
Male
HSC
2025
Just an idea for the spreadsheetโ€™s formatting, with the colour gradient you could find a score measuring a papers difficulty by , which outputs a number between -1 and 1, 0 being the person got their hsc mark on the test paper, and use conditional formatting to fill the cells with a colour, more negative being green (easy), blank being normal, and positive being red (hard). Thereโ€™s still a couple issues like how a 90 hsc mark doesnโ€™t mean raw 90s is expected, so might have to do a bit more maths-ing there to change it
perhaps using an average of the raws on the hsc past papers would be more effective since most people using it probably haven't done their hsc yet
 

killer queen

Well-Known Member
Joined
Oct 21, 2024
Messages
435
Gender
Female
HSC
2025
Just an idea for the spreadsheetโ€™s formatting, with the colour gradient you could find a score measuring a papers difficulty by , which outputs a number between -1 and 1, 0 being the person got their hsc mark on the test paper, and use conditional formatting to fill the cells with a colour, more negative being green (easy), blank being normal, and positive being red (hard). Thereโ€™s still a couple issues like how a 90 hsc mark doesnโ€™t mean raw 90s is expected, so might have to do a bit more maths-ing there to change it
I will google how to do this once I get more submissions - would it potentially be possible to average different people's scores though? As different people would find the difficulty variable
Or we can make an "average person" and then use that

perhaps using an average of the raws on the hsc past papers would be more effective since most people using it probably haven't done their hsc yet
This could be used later I suppose when we all graduate
 

Users Who Are Viewing This Thread (Users: 0, Guests: 2)

Top