Cicero Posted August 6, 2007 Report Share Posted August 6, 2007 Look what I found: http://www.reg.ulaval.ca/webdav/site...Cote_Laval.xls It's an excel sheet that calculates your CRU!!! Edit: Did anyone make it work? lol... Link to comment Share on other sites More sharing options...
AMmd Posted August 6, 2007 Report Share Posted August 6, 2007 Look what I found: http://www.reg.ulaval.ca/webdav/site/reg/shared/Documents_PDF/Guides%20et%20formulaires/Calcul_Cote_Laval.xls It's an excel sheet that calculates your CRU!!! Edit: Did anyone make it work? lol... it looks really nice, if only it would work lol Link to comment Share on other sites More sharing options...
Cicero Posted August 6, 2007 Author Report Share Posted August 6, 2007 Yeah... Well it ask's for a username and password when you open the file, must be for admission people only Link to comment Share on other sites More sharing options...
Cicero Posted August 6, 2007 Author Report Share Posted August 6, 2007 Can anyone crak the code? Link to comment Share on other sites More sharing options...
AMmd Posted August 6, 2007 Report Share Posted August 6, 2007 Can anyone crak the code? it doesnt ask for a code if you save it on the comp.. but there is a problem with selecting the programs i guess... it keeps saying that you have to select only one program Link to comment Share on other sites More sharing options...
Cicero Posted August 6, 2007 Author Report Share Posted August 6, 2007 it doesnt ask for a code if you save it on the comp.. but there is a problem with selecting the programs i guess... it keeps saying that you have to select only one program Ya it pisses me off, I was so happy with this find.... Link to comment Share on other sites More sharing options...
p0795195 Posted August 8, 2007 Report Share Posted August 8, 2007 its weird, i just clicked on the link and it works for me... and doesnt ask for any passwords. Link to comment Share on other sites More sharing options...
Karim Posted August 8, 2007 Report Share Posted August 8, 2007 Hey everyone! I pressed cancel a couple of times when it asked for the password and it ended up opening up. Once you have it opened, highlight the rows before and after the ones that are missing (for example: Row 11 is followed by 17 so we are missing 12 through 16). So you highlight 11 and 17. Right click and select "unhide". This is the info for the program you selected above. By clicking on the yellow box where the CRU is supposed to appear you can see the formula that should be applied. The formula for the first program is the following: (MAX(MIN((B19-B14)/B15,3),-3)+B13+3)*5)). This will give you your CRU Laval. Then adjust if you have to account for CRC or you have more than 1 program. Happy calculating! Karim Link to comment Share on other sites More sharing options...
zizany Posted August 8, 2007 Report Share Posted August 8, 2007 Wow it works!!! Thank you Link to comment Share on other sites More sharing options...
AMmd Posted August 8, 2007 Report Share Posted August 8, 2007 man i wish i was excel savvy... Link to comment Share on other sites More sharing options...
zizany Posted August 8, 2007 Report Share Posted August 8, 2007 But I don't think that they actually calculate it this way, because in the program it says 'Calcul de la cote laval avant A1995' So they might have changed their method since then... Link to comment Share on other sites More sharing options...
Karim Posted August 8, 2007 Report Share Posted August 8, 2007 There are 3 sheets to the document. The first sheet is current, the second is a numerical list (that can be found elsewhere also), and the third sheet is the pre-1995 method. So just use the first sheet. However, I also have my doubts that this is actually accurate. I just wonder if they use other averages and standard deviation data depending on which university you come from. In any case this probably provides a decent estimate! Link to comment Share on other sites More sharing options...
zizany Posted August 8, 2007 Report Share Posted August 8, 2007 If someone who applied to laval this year could tell us if his CRU is the same with this program than what laval calculated we would know if it is the real CRU... Link to comment Share on other sites More sharing options...
Cicero Posted August 8, 2007 Author Report Share Posted August 8, 2007 I made it work aswell, the problem is in the script of the yellow box that say's: "Erreur choisir un seul programme". Edit the script and instead of =IF(OR((B9=B10),OR(B9="(Tous)",B10="(Tous)")),(IF(OR(AND(B9="(Tous)",B10="(Tous)"),(OR(B19>4.334,B18=0,ISBLANK(B19),B19<0))),"Identifier le programme, inscrire les crédits diviseurs et la moyenne cumulative ( /4,33) pour afficher la cote Laval du programme",+(MAX(MIN((B19-B14)/B15,3),-3)+B13+3)*5)),"Erreur: choisir un seul programme") Replace "(Tous)" by "(All)" :D If this is really the way they calculate it, I'm in homies! Oh and btw, the CRU they calculate is even higher in UdeM so Link to comment Share on other sites More sharing options...
AMmd Posted August 8, 2007 Report Share Posted August 8, 2007 wow you are a genious! thanks now it works Link to comment Share on other sites More sharing options...
Cicero Posted August 8, 2007 Author Report Share Posted August 8, 2007 wow you are a genious! thanks now it works What you guy's think? Is this thing precise?Can people from Laval post their program, credits, GPA and CRU so we can compare and see if this program is legit or not? Link to comment Share on other sites More sharing options...
Karim Posted August 9, 2007 Report Share Posted August 9, 2007 What you guy's think? Is this thing precise?Can people from Laval post their program, credits, GPA and CRU so we can compare and see if this program is legit or not? I'll try to verify if its accurate soon. I know someone who got into Laval last year (entry September 2006) so it shouldn't change alot in just 1 year. I'll calculate her GPA and CRU and all that and let you know what I find! Link to comment Share on other sites More sharing options...
Cicero Posted August 9, 2007 Author Report Share Posted August 9, 2007 I'll try to verify if its accurate soon. I know someone who got into Laval last year (entry September 2006) so it shouldn't change alot in just 1 year. I'll calculate her GPA and CRU and all that and let you know what I find!Sweet, thanks Karim. Link to comment Share on other sites More sharing options...
zuluman007 Posted August 9, 2007 Report Share Posted August 9, 2007 I'll try to verify if its accurate soon. I know someone who got into Laval last year (entry September 2006) so it shouldn't change alot in just 1 year. I'll calculate her GPA and CRU and all that and let you know what I find! Yes same person... new name. So I checked with my friend. She did her degree at another university than Laval in Health Sciences. Since there is no Health Sciences program at Laval we both agreed that "Kinésiologie" was the closest match. Using that data from the document (remember it's 2007 data) her CRU came out to be 33.750. In reality in 2006 she had gotten 33.699. Pretty close!!! That's a 0.15% error! So in her case we can say that the document in question is extremely accurate. I don't have a clue if this is true for all cases but I'm starting to believe that this is the real method they use to calculate CRU. If any one else has access to similar examples it would be interesting to compare! Link to comment Share on other sites More sharing options...
Cicero Posted August 9, 2007 Author Report Share Posted August 9, 2007 Ok les tout le monde, j'ai fait quelques calculs en prennant les notes des personnes qui ont "posté" sur ce forum. Mineur en chimie + Majeur en sciences biologiques à 4.3 = 38,2 à l'udem et 35,136 à laval. (Différence de 3,064 CRU) Bac en littérature française avec 3.9 = 33,9 à l'udem et 31,541 à laval. (Différence de 2,359 CRU) Cert. en administration (3.4) + Cert. en pédagogie (4.23) + Cert. en science infirmière (4.2) = 33,149 à l'udem et 31,496. (Différence de 1,653) Bac en information - gestion avec 3.9 = plus que 33,063 à l'udem et 32,731 à laval. (Différence de 0,332) On peut remarquer qu'il y a une différence significative dans certain programmes entre l'udem et laval. Par contre, pour la CRU à laval, le logiciel à l'air de bien fonctionner. Je commence à croire moi aussi que c'est comme ça qu'ils calculent la CRU à laval. Link to comment Share on other sites More sharing options...
El Matador de la Muerte Posted August 15, 2007 Report Share Posted August 15, 2007 Bacc en Biochimie à l'UQAM... Moyenne 3.88/4.3 ça donne 3.910/4.33... CRU calculé sur le programme excel : 32.192 (Calculé avec indice de force B Sc. en Biochimie à Laval) CRU envoyée par l'Université Laval : 32.438 Différence : 0.76 % PS: Je termine ma maîtrise en chimie organique à l'UQAM ce mois-ci Est-ce que cela a une influence sur ma côte même si je n'ai pas encore officiellement mon diplôme ? Link to comment Share on other sites More sharing options...
Cicero Posted August 15, 2007 Author Report Share Posted August 15, 2007 Nice, merci pour ta réponse Matador, je pense que c'est vraiment comme ça qu'ils calculent la CRU à Laval finallement. La variance dans les CRU est sûrement liée au fait que l'indice de force de groupe et de discipline varie d'année en année et la version de ce fichier date de 2006. Link to comment Share on other sites More sharing options...
El Matador de la Muerte Posted August 16, 2007 Report Share Posted August 16, 2007 D'après la date inscrite dans le fichier excel, les Indices de Force date du 6 février 2007 ! voir la cellule L1 de la feuille Imprimé. C'est dingue ces données !!! Ça veut dire que même si une personne se défonce pour avoir 100 % dans tous ces examens et qu'elle à une moyenne parfaite de 4.33/4.33 en ayant fait un Bac à Laval en Ethnologie du Québec, en Enseignement professionnel, en Sociologie, en Théologie ou en Théologie Juive, cette personne n'a absolument aucune chance d'être acceptée en médecine (je crois qu'il faut une CRU minimale de 31.5 pour avoir ne serait-ce qu'une mince chance d'être convoqué à l'APS, malheureusement la CRU maximale des ces programmes tourne autour de 30 à 30.5 avec une GPA parfaite ; i.e. : A+). Pour ce qui est des diplômes et des certificats, on n'en parle même pas... C'est encore pire!!! Je trouve ça un peu dommage pour les personnes qui s'intéresseraient à la médecine et à l'enseignement de n'avoir aucune chance et de ne pas être informé des indices de force de ces programmes... Après tout, le fichier que Cicero a trouvé était bien caché sur le web... Link to comment Share on other sites More sharing options...
Cicero Posted August 16, 2007 Author Report Share Posted August 16, 2007 Matador tu as absolument raison. Quoi que quelqu'un qui est intéressé à la médecine ne devrais pas d'après moi étudier dans des disciplines qui demande aucun effort supplémentaire pour atteindre le A+, comme en communiquation publique par exemple. Il y a quelqu'un sur ce forum qui a été admis/se avec 3 certificats. Donc, encore là il n'y a rien d'impossible... Entk, pour ma part je veux rentrer en medecine dentaire et je me demandais comment Laval calculerais ma CRU pour une mineur en arts et sciences (Ils n'ont pas de mineur en arts et sciences). Je serais considérer comme un étudiant en biologie? Link to comment Share on other sites More sharing options...
doc31 Posted August 16, 2007 Report Share Posted August 16, 2007 Ha oui, parlons-en des bacc à éviter!! Si j'avais su, je n'aurais jamais fait 3 certificats (c'est moi qui a finalement été admise avec un trio... ) car ça donne l'impression que mes A+ ne valent pas grand chose... pourtant quand on regarde les moyennes de groupe... Bref, j'ai trouvé ces calculs de cote très frustrant et je me suis alors dis que j'aurais fait mieux avec le bacc en nursing! Laval m'ont calculé une cote de presque 28 et ce n'est pas pour vous contredire! J'en revenais pas d'une telle différence! Quant à Sherbrooke, j'ai un beau 30,829! Vive Mtl, une chance qu'ils ont réussi à me remonter le moral! Bref, faites pas des certificats si vs voulez devenir médecin! Moi je voulais juste élargir mes horizons (pcq je voyais pas ce qu'un bacc en nursing m'apporterait de plus ds ma vie personnelle et prof.) en touchants différents domaines mais c'était pas un bon choix pour la cote... Bonne chance Cicero! Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.