Schwarzbart Posted December 8, 2013 Report Share Posted December 8, 2013 Because I already entered the midterm exam results I will keep with the version I have now for Angelik. (I plan to make the sheet with all results public at the end of the roleplaying thread) Quote Link to comment Share on other sites More sharing options...
freespace2dotcom Posted December 8, 2013 Author Report Share Posted December 8, 2013 You may change your mind when you see this next version... Quote Link to comment Share on other sites More sharing options...
freespace2dotcom Posted December 9, 2013 Author Report Share Posted December 9, 2013 Version 1.5 has been finished. Â What's new: Â Several names' typos have been fixed, A few students have been added and removed from classes as appropriate, Better tab organization, Rhetoric is now alphabetized Grammar is no longer missing. Estimates for music and athletics added. The ability to say which classes and college you are in. (better accuracy) A new "master sheet" for comparing students college and academy-wide (still under construction) Quote Link to comment Share on other sites More sharing options...
Schwarzbart Posted December 9, 2013 Report Share Posted December 9, 2013 Are any of the colleges beside Rhetoric resorted or can I simply copy & past the results from the old sheet Quote Link to comment Share on other sites More sharing options...
freespace2dotcom Posted December 9, 2013 Author Report Share Posted December 9, 2013 I removed Aveline from Astrology, so that will need to be kept in mind but other than that you *should* be good! Â edit: oh yeah, changing "Poriabel" to "Oriabel" changed her order in that class slightly. I think that was astrology too. Â Edit2: if any of the numbers of students don't match between versions, let me know. those may have a slight difference. Â (though most likely shouldn't affect copy/pasting) Quote Link to comment Share on other sites More sharing options...
Schwarzbart Posted December 9, 2013 Report Share Posted December 9, 2013 Sadly the "Do you attend this class" don't work for me in LibreOffice as it select or deselect for all class. Â Yes both where astrology and I had fixed them in my sheet also Quote Link to comment Share on other sites More sharing options...
freespace2dotcom Posted December 9, 2013 Author Report Share Posted December 9, 2013 I am not finished working on the gradebook. As you can see the 'total' sheet' still needs work.  I will redo the "Do you attend this class" checkmarks in 1.6  for now having them all selected will give the same effect as the previous version, at least  do the college ones work? Quote Link to comment Share on other sites More sharing options...
Schwarzbart Posted December 9, 2013 Report Share Posted December 9, 2013 yes this one work even if I manual have to deselect Aranaz. Quote Link to comment Share on other sites More sharing options...
freespace2dotcom Posted December 9, 2013 Author Report Share Posted December 9, 2013 Yeah, sorry about that. I had a few things selected for testing and I forgot to reset all of it when I uploaded it. Â Replace the classes in the tan area in the "total" sheet with your own and then check your college and you should be able to see how all students do. Â 1.6 will also fill in the "for orsi's eyes only" area as the formulas are a little too advanced for me to figure out right now and I didn't want that to delay the other fixes. Quote Link to comment Share on other sites More sharing options...
Schwarzbart Posted December 9, 2013 Report Share Posted December 9, 2013 If not to much work could you put the exam date in E2 and F2 at your next version? Quote Link to comment Share on other sites More sharing options...
freespace2dotcom Posted December 9, 2013 Author Report Share Posted December 9, 2013 I think that should be pretty easy. I'll add it to the list. Â No telling when I'll get next version out, though. Quote Link to comment Share on other sites More sharing options...
Schwarzbart Posted December 9, 2013 Report Share Posted December 9, 2013 I just found a large bug because you always use 80% final exam weight what is wrong for nearly all class. According to the mod tools its: Arithmetic 95% Astrology 90% Botany 87% Calligraphy 97% Dialectic 99% Enchant 95% Geometry 95% Glamour 90% Grammar 80% History 80% Incantation 95% Negation 99% Revision 97% Rhetoric 90% Zoology 90% Quote Link to comment Share on other sites More sharing options...
freespace2dotcom Posted December 9, 2013 Author Report Share Posted December 9, 2013 Umm, I'm pretty sure the legate said it was 20-80. That isn't a bug, the gradebook was programmed that way. Â I'm at a loss for words and will be really, really mad at him if this turns out to be untrue! Where did you find that!? Â Edit: found them in the modtools. Â edit 2: also didn't find the legate reference to the specific 20-80 rule that I remembered so he's off the hook! (for now...) Â I'm concerned about my grades again! Legate, did you know this and not say anything!? I'm mad at you again! Â Edit 3: Athletics and music have different values from each other also. It almost seems as if there will be some effect from taking them. Â Final edit: I will add this new info to 1.6 upon confirmation from the Legate that schwarzbart's info is correct. Quote Link to comment Share on other sites More sharing options...
Schwarzbart Posted December 9, 2013 Report Share Posted December 9, 2013 For Athletics and Music I think the Legate already confirmed that its only the score you have at the skill at the time of the exam. Also Athletics and Music have no effect for the extra class requirements unless you have a No Pass.  Will the score of the Pass / Fail class like Music count for the Year 2 extra class requirements? If so will only the final exam count or also the midterm exam to a part? Schwarzbart  As I understand it, P/NP Classes do not count. Quote Link to comment Share on other sites More sharing options...
freespace2dotcom Posted December 9, 2013 Author Report Share Posted December 9, 2013 I just find it curious, is all. if they didn't matter at all, then they should be identical to each other, but maybe I'm thinking too hard. Â Ugh... I've got a looooooo~t to do for V1.6. Â Â Â I need to convert the honors system to a numerical value, (done, mostly) add up the values each honor gives each student, (also mostly done) rank the students' performance against their college and academy as a whole, (again, mostly done) rank the performance of the colleges against each other (done except the PC) Â It might seem that it's done, but at least half of the work in this is making sure if the player is or is not having his grades applied to 7 different colleges as applicable. Â this is one such formula of many I still haven't written yet: =IF($B$6=TRUE,HLOOKUP(C8,$I$13:$N$14,2,FALSE),IF($B$25=TRUE,HLOOKUP(C27,$I$13:$N$14,2,FALSE),IF($B$40=TRUE,HLOOKUP(C42,$I$13:$N$14,2,FALSE),IF($B$57=TRUE,HLOOKUP(C59,$I$13:$N$14,2,FALSE),IF($B$72=TRUE,HLOOKUP(C74,$I$13:$N$14,2,FALSE),IF($B$90=TRUE,HLOOKUP(C92,$I$13:$N$14,2,FALSE),IF($B$105=TRUE,HLOOKUP(C107,$I$13:$N$14,2,FALSE)))))))) Â I've finished adding the exam dates, but changing the weight formula will be a little trickier. Still easier than this, though. Quote Link to comment Share on other sites More sharing options...
Legate of Mineta Posted December 10, 2013 Report Share Posted December 10, 2013 Free; Â It's true: the final weight does depend on Class. Sorry, I never noticed it myself until Schwarzbart pointed it out! Quote Link to comment Share on other sites More sharing options...
freespace2dotcom Posted December 10, 2013 Author Report Share Posted December 10, 2013 gee, and I thought the midterms were pretty unimportant with 20% weight behind them. Â They're good for little else than gauging how a student might do in the finals with around ~5-10% weight. Quote Link to comment Share on other sites More sharing options...
Schwarzbart Posted December 10, 2013 Report Share Posted December 10, 2013 I wonder why they care at all about midterm in Dialectic and Negation because 1% come one that's only 1 point if one got 100 points in the midterm exam. Quote Link to comment Share on other sites More sharing options...
Legate of Mineta Posted December 10, 2013 Report Share Posted December 10, 2013 Schwarzbart; Â They are mandated to have a mid-term, but some Professors think that only the Final matters and weighs the mid terms accordingly. Quote Link to comment Share on other sites More sharing options...
freespace2dotcom Posted December 10, 2013 Author Report Share Posted December 10, 2013 I'll bet that's Briardi's influence. Â But really, the mid terms seem geared more to see if students are on track in their studies to do good on the real exams than anything else. Â V1.6 is coming along nicely. Though I'm having some problems with ties in ranking mucking up my 'best' and 'worst' of page. Quote Link to comment Share on other sites More sharing options...
Svinik Posted December 10, 2013 Report Share Posted December 10, 2013 I suspect that the academagia is using mid-terms mainly to encourage students to concentrate, confirm which students are worth teaching, which need some assistance/encouragement, etc. The need for "proof of what they learned" is then focused at the end when things have come together (i.e. the student has had time to learn the study skills and can now demonstrate what they've learned). Â I had thought it was 20/80 as well, I feel bad for the poor kids in some of my classes as my chaps may have smacked the grade curve a little hard not realising that they could qualify for extra classes without getting 150 or so in the final - though I may have mis-remembered 130 as the numerical element of the qualifier there as well Quote Link to comment Share on other sites More sharing options...
Schwarzbart Posted December 10, 2013 Report Share Posted December 10, 2013 The two class with Curve distribution look wrong especial Arithmetic where I got 9 failure of 35 Students that's fare more then the 10% it says in the wiki. Quote Link to comment Share on other sites More sharing options...
freespace2dotcom Posted December 11, 2013 Author Report Share Posted December 11, 2013 I *just* finished all I want to ever do with the Y1 gradebook and this happens! Â Did they tie for a lower rank? It's possible to get more than 10% failures in the sheet that if ties are involved. Â Could you PM a screenshot of the classes? Quote Link to comment Share on other sites More sharing options...
Schwarzbart Posted December 11, 2013 Report Share Posted December 11, 2013 The formula you used for Arithmetic is: =WENN(UND(H6<=3);M2;WENN(UND(H6<=12);M3;WENN(UND(H6<=23);M4;WENN(UND(H6<=26);M5;M6)))) Â and I think we can agree that 35 - 10% is either 32 or 31 but never 26 Â you also used the exact same formula with Rhetoric with 31 Students where the result then had to be 28 or 27 but not 26 Â Edit: You also used the same numbers (3,12,23,26) for the Hybrid Curve calculations of the Zoology (31 Students) and Botany class (33 Students). Only for the two Hybrid Distribution you thought about adjusting the numbers depending on the number of Students Quote Link to comment Share on other sites More sharing options...
freespace2dotcom Posted December 11, 2013 Author Report Share Posted December 11, 2013 Yup. What *probably* happened is I got a tad bit carried away with copy/pasting and forgot to tweak the percentages from negation when creating the sheets. Â It *does* grade according to the curve, though. the curve is just skewered. Â Both of those classes will be tweaked in 1.6 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.