Sign in to follow this  
Followers 0
freespace2dotcom

The Academagia Gradebook (Year 1)

166 posts in this topic

I am releasing a grade book I made for Y1 since the Legate was nice enough to let us all know how the classes for Y1 are graded. It's a series of excel (2007) spreadsheets for calculating class grades and honors. all you need to do is input the midterms and final exam data in the tan area as just about everthing else has been inputted. (including classmates)


It Now supports ALL CLASSES! (except music and athletics)


Version 1.73 (For the last releases of Y1, DLC 16+)

 

http://s000.tinyupload.com/?file_id=82413846449222070933

 


2hi7z7r.jpg

Share this post


Link to post
Share on other sites

Actually, I may have to tweak the Negation class sheet a bit more. With 29 students 10% failure rate is 3, not 4. I've been racking my brain to get a working formula in excel but I think that's a sign of lazy copying and pasting. If I make any new sheets I'll adjust that a little. I'd say it's still ~95% accurate.

Share this post


Link to post
Share on other sites

Nice, I think I'll try filling it out when I get that far, it's almost the same classes I have.

 

Out of curiosity what ratings are required to avoid failing when it's Pass/Not Pass or Distribution? As I understand it the effects of each rating is set in stone with those rating methods.

 

It seems the cut-off point is 40 for distribution in your document, was that stated somewhere?

Share this post


Link to post
Share on other sites

The Legate mentioned the Grading System recently and its already over at the wiki

Grading Method

Edit: So Pass no Pass is 50% not 40% but apparently not affected by Study!

While Distribution is below 40% to fail

Share this post


Link to post
Share on other sites

The Legate mentioned the Grading System recently and its already over at the wiki

Grading Method

Ah, right it mentions pass/not pass.

 

It doesn't say anything specific about the exact rating required to not fail with the distribution rating. It just says 75+ means First Class Honors.

 

Edit: Nevermind I missed part of it for some reason.

Share this post


Link to post
Share on other sites

Distributing Rating is pure Council distribution what means you fail below 40%

Also only for Hybrid Distribution and Curve its interesting how much you get past 75% because for all other systems you get First Class Honors or Pass if you get 75% or better.

Share this post


Link to post
Share on other sites

Just a heads up I did some more calculations and it turns out that Flore and Corradin should have passed. (juuust barely) I'm too lazy to upload a new version for just that, but the fix is only required for Negation.

 

As is the hybrid distribution formula for rating honors is:

=IF(AND(G24>=75,H24<=2),M2,IF(AND(G24>=60,H24<=10),M3,IF(AND(G24>=50,H24<=21),M4,IF(AND(G24>=40,H24<=24),M5,M6))))

 

What you want to do to fix that is change it to look like this:

 

=IF(AND(G24>=75,H24<=3),M2,IF(AND(G24>=60,H24<=12),M3,IF(AND(G24>=50,H24<=23),M4,IF(AND(G24>=40,H24<=26),M5,M6))))

Share this post


Link to post
Share on other sites

I might do something like your calculation my self when I hit the final exams with Angelik.

Because its usually easier for me to do this mathematic my self then adjust the calculations of someone else.

Share this post


Link to post
Share on other sites

I hear you. The hardest part of it all is pulling the data out of the game. If I can make some more sheets though, you won't need to do any calculations, just data entry, which you'll have to do anyway since there's no way to automatically pull that from the game.

 

Right now its just mostly geared toward my fellow Aranaz students who are magic heavy but I might possibly if unlikely do this for all the Y1 classes.

 

edit: fixed the Negation grading issue and average issue. uploaded already and replaced the link.

Share this post


Link to post
Share on other sites

Hmm, I wonder how students we'll be losing from Academagia - factor in the losses to the courts from random acts of youthful exuberence and expulsions over Gates/Mastery to the dumped duffers and students may be thin on the ground by year 5 :(

Share this post


Link to post
Share on other sites

Hmm, I wonder how students we'll be losing from Academagia - factor in the losses to the courts from random acts of youthful exuberence and expulsions over Gates/Mastery to the dumped duffers and students may be thin on the ground by year 5 :(

Master them all so that they will not stray into the filthy path of Mastery!

 

Hang on a minute....

Share this post


Link to post
Share on other sites

No no Creme, I think you got it, that is certainly the way to stop people from dropping out of class. And a way to get them to study. And a way to more than tripple your allowance! And keep the dorm rooms clean (yours at least!)... I mean.. *cough* I believe I had an appointment somewhere.

Share this post


Link to post
Share on other sites

The perception gap between "fellow students" and "prey" is insufficiently wide for some of my classmates :blink:

 

An extra dose or two of Professor Storey's ethics detention class mayhap? :rolleyes:

Share this post


Link to post
Share on other sites

Kurt gets First Class Honours? Kurt!? What sort of game are you running here, Free?

 

Man, I should make a spreadsheet like this of my own for the classes. I know that my characters pass, but I'll have to keep an eye on everyone else so that they'll pass too. Welp, Mastery, here I come.

 

Legate, are there ways to redo exams? Like in college where you can take a class again or retake an exam during the summer or just generally catch up? Maybe on your parents' funds, maybe because of an amazing grade in another subject, maybe a teacher likes you? You can't have a "you're out" on the first strike can you? And since the classes are so graded, a few of them are bound to fail.

Share this post


Link to post
Share on other sites

Well, in updating my file I accidentally deleted the data. Otherwise I'd show you...To be fair, kurt did not do so well in his other classes. At least in my game, so cut him some slack. I'm sure it had something to do with briardi looking after her flock.

Share this post


Link to post
Share on other sites

Kurt gets First Class Honours? Kurt!? What sort of game are you running here, Free?

 

Never underestimate the terrible offspring between Chinese-style monstrous parenting and Academagical pressure.

Share this post


Link to post
Share on other sites

Hatt;

 

"Legate, are there ways to redo exams?"

 

There aren't ways to redo the exams, but if your parents have sufficient clout with the Regents, there are ways to excuse a Student from certain results.

Share this post


Link to post
Share on other sites

Tough school, this. Now I'll have to plan on Mastering only rich kids with influential parents. Make them fail...

 

This could be a wonderful "Taking over the world" simulator. One student at the time.

Share this post


Link to post
Share on other sites

I just hope the Marchant family don't have this ;)

 

Given that papa Marchant is on trial and needs a certain heroic young 1st year Hedi students help in one adventure I expect not - but then we seem to have a lot of Marchants at school and clout is something that they all practice heavily. :(

Share this post


Link to post
Share on other sites

I actually bothered to update this to support most classes now. (except music and athletics.) please report any bugs with it.

Share this post


Link to post
Share on other sites

So I've been filling in the results because I'm a bit curious. Just half-way through the midterms so far, but I noticed you had not included Neta Xemutre in the Botany class, and Sheary Warrington did not show up as having attended exam in my log. I thought the teachers would drag them there no matter what?

 

I assume that means he got a 0 on the midterm, or was it just my log not writing his result properly?

 

Also in Geometry you didn't write Courtenay de Surval, but you wrote Aveline who doesn't have that class.

 

Great bit of work though. I think It's nice to see who is on top in each class. :)

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now
Sign in to follow this  
Followers 0