ࡱ>   !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghiRoot Entry\ob$OSL53@@j@NativeContent_MAIN&SummaryInformation(0elow to start entering grades, or turn to the instructions tab for more instructions.The Z-scores are calculated based on only those students that were included by typing (or leaving) "yes" (without the quote marks) in the far left column.Mthat part much weight or do not use the Z-score method of weighting, or both.[students on that part might not be very important. If that is the case, either do not give {IF Grades:A3<=Grades:T16}{quit}}To go to the sheet with the grading scale, click on the "Grading Scale" tab below, or move to it by hitting Control-PageDown.Before you start entering scores and calculating grades, you must edit eZ-Score's grading scale to match your school's grading scale.Welcome to eZ-Score.{The following key combinations will help you add students, sort, and decide what target mean and standard deviation to use:|Examine the blue data, both the letter grades and their numerical equivalents. All Grades are based on this numerical scale.Ctrl+Shift+I sorts by ID numberCtrl+Shift+Y sorts by "yes"Ctrl+Shift+T sorts by Total2Ctrl+Shift+Y sorts by "yes" in the "count?" columneZ-Score5Copyright 2003 Jeffrey E. Stake All rights reservedTargetmeanVersion 4.04 qpwstdev Course.Ctrl+Shift+A adds another student to the classSemesterYearTeacherSchoolfinal or preliminaryKEnter new data over blue data ONLY. Typing in other cells can cause errors.+the Z-score method of weighting subscores SUBSCORE DATA = Averagehighextra = Std. Dev.lowcredit = Class Sizefactormax % of gradeformin Preliminarysumattendtalk Grades can bescore possible (optional)stored in thisWeight =exam column forID#part1part2part3part4part5part6part7part8part9part10name talk sumscoretotal letter grade comparison= {getnumber "How many students are in this class?", Grades:A3} {Page.Protection "No;No"}$ {SelectBlock Grades:A24..Grades:A24}0 {BlockInsert.Rows Grades:A24..Grades:A24;Entire}$ {SelectBlock Grades:A25..Grades:X25} {EditCopy} {EditPaste}$ {SelectBlock Grades:M24..Grades:M24}$ {SelectBlock Grades:W24..Grades:W24} {Page.Protection "Yes;No"}~ \a+Do not tamper with the macros on this page. \i {Sort.Key_1 r23} {Sort.Go} {Sort.HeadingSize 1} {Sort.PreviousSorts -1} {Sort.Data Numbers First} {Sort.BlankCellsFirst 0} {Sort.KeQPW9 5 stakestake Arial      !Normal MacroCode 7PPP!P#P"PPP!PP PPP"PPPPP"PP#PPP P!P#PPPPP0PPPPPPPPPPPPP@PPPPPP#PP#P@!P@P@P~fG@B"qtQrv0}3@grade3@Print3@xsort4@xwhole(@\a(@\i(@\t(@\u(@\y8@ comparison(@\c(@\b6@addblock(@\0 9'Enumerical valuesCount? (minimum) suggestedgradeyes cutoffs cutoffA C A- C- B+ D+ B D B- FC+ G?IYou will next enter the data for the students and calculate their grades.9To get to the sheet for that, click the Grades tab below.|When the scale fits your school, SAVE this template with some name that indicates it is the generic template for future use.wThe blue numbers and letters should match your school's grading scale. Notice that an A- is 3.7, not 3.66, for example.uMake such changes as are necessary by moving the cursor to the cells needing changing and enter new values as needed.To the right of the grades there is a suggested cutoff column. Those cutoffs are points halfway between the grades to the left. The minimum cutoffs used by the program are in light purple, and can be changed, but do not change them unless you know what you are doing.HOne other time that you might not want to use the Z-score method is whenPone group of students has a grade on one part and another group has a grade on aVdifferent part. It is best if each student has a grade in each column used. If not, 1it might be better not to use the Z-score method.POtherwise, the Z-score method is ordinarily recommended for weighting subscores.Be careful using your mouse, it is not hard to move stuff from one cell to another accidentally. That can ruin your grades. Stick to the keyboard.uTurn to the green "grades" tab by_5 ""} {Sort.Key_4 ""} {Sort.Key_3 ""} {Sort.Key_2 ""} {Sort.Key_1 b23} {Sort.Heading 0} {Sort.Type Top to bottom}" {Page.Protection "Yes;No"}{up}{up} {Sort.Key_1 m23} \u \t \y {Sort.Key_1 a23} \c {BlockValues Grades:grade;w23}$ {SelectBlock Grades:B24..Grades:o24} {PutCell2 "o"} {PutCell2 "0"} {SelectBlock grades:a24}# {shift+down grades:a3-grades:t16-1}? {BlockName.Create addblock;@Property("Active_Block.Selection")}h {BlockInsert.Rows grades:addblock;Entire}{BlockName.Create addblock;@Property("Active_Block.Selection")} {SelectBlock grades:A23..X23} {SelectBlock grades:addblock}H {EditPaste}{shift+right 14}{putblock "0"}{shift+left 14}{putblock "yes"} {up}{right} {PutBlock "0"}$ {SelectBlock Grades:a24..Grades:a24} exam2Ctrl+Shift+B adds a bunch of students to the class \b" {SelectBlock Grades:a1..Grades:a1}You can eliminate a student from the calculations by typing anything other than the word "yes" in the far left ("count?") column for that student.hWhen you save this file, the next time you open it it will open to the sheet you were on when you saved.~To determine whether to use the Z-score method of calculating grades, read the Z-score Warning page by clicking the tab below.Type only in the cells with blue data. Typing in other cells can cause errors. Do not turn off the page protection unless you know what you are doing.Ctrl+Shift+U sorts by NameUSave this file now, with a new name for the class of students you are about to grade.Click on the tabs below to turn to different sheets in the workbook, or move from sheet to sheet by hitting Control-PageUp or Control-PageDown.7You will spend most of your time on the "Grades" sheet.~To use the Z-score method of combining scores, type "yes" in the appropriate cell in the left most column of the Grades sheet.To avoid using the Z-score method of combining scores, type anything other than "yes" in the appropriate cell in the left most column of the Grades sheet.]eZ-Score4.03 and EZ-Score 4.03 for QPW Copyright 2003 Jeffrey E. Stake All rights reserved.; The copyright to this software belongs to Jeffrey E. Stake. The purchaser obtains only a license to use the software to calculate grades for students for whom the purchaser bears the official responsibility for assigning grades. Any other use of this software constitutes a violation of this license agreement. The license is not transferable. Upon a violation of the terms of the license, the license is automatically revoked and damages may be assessed against the purchaser. Liability for defects in this software is limited to a refund of the purchase price, unless otherwise affirmatively prohibited by law.: Use of this software constitutes agreement to these terms.m You may try this software to see whether it is useful to you. For use after a few trials, please send $39 to: Jeff Stake3 3707 Rachel's Glen Road, Bloomington Indiana 47408^ Authorized users of previous versions and friends of Jeff Stake may use this version for free.UThis template should make it easier to create final grades from a group of subscores.?You will complete the following steps to get your grading done:8expand the spreadsheet to the correct size for the classXenter scores into the spaces (called "cells") for the student scores, and SAVE your workchoose whether to use the Z-score method of adding subscores to get total scores; some advice is available by clicking the "warning" tab below?enter a target mean and target standard deviation for the classtinker with the target mean and standard deviation until you get a distribution that is consistent with what others do at your school+sort the scores by ID, Name, or Total scoreprint your results save the file {Sort.Order_1 Descending}Ctrl+Shift+U sorts by name IMPORTANT!# "count?" studentsG{selectblock grades:s1}{selectblock grades:w1}{Page.Protection "No;No"}{selectblock grades:c1}Ctrl+Shift+C copies the current grades over to another column so that you can make changes and then see whose grade has changed.@Ctrl+Shift+C copies grades for comparison after changes are made0{selectblock grades:a1}{Page.Protection "No;No"}count?VIf the scores on one of the subparts are essentially the same, the differences between*(This is the actual average and std. dev.)jIn order for scores to be included in the totals, you must enter some "weight" for that column of scores. NIf you do not enter a weight for some scores, they do not count in the totals.You do not have to enter any "possible score"; those cells are just for your own record keeping; they are not used by the program.@ {Application.General "Yes;No;No;Yes;5000;No;No;Yes;No;Yes;Down"}tilde makes the macro active \0StudentsXAfter you have selected a cell, you may type data into it if it is not a protected cell.!{selectblock "xsort"}{Sort.Reset}TMove the selected cell around by using the arrow, page up, page down, and home keys.eSome additional help is provided on the "Instructions" sheet. Click on the tab to turn to that sheet.|( To avoid ruining this template in the future, save the file with a new name as soon as you open it each time you open it.)JRegarding the use of the Z-score method, there are two important warnings:(of the students with "yes" in column A.)To turn off the Z-score method, enter anything other than "yes" in cell A12 of the "Grades" sheet. To turn it on, put "yes" back in that cell.Anything other than "yes" in column A excludes that student from the calculations, although the program will still calculate the grades for the excluded students.iYou can get to the Grades sheet by clicking on the green tab below, or by hitting Control-PageDown twice.]1&   `  ` ` ` ` ` ` ` ` ` `                                               +]`` `R +]`` `+]`` `+]`` `+]`` `+]`` `+] +] +] =3WARNING, you gave some scores no weight ; +] *;; P+]` `7-yesIS being used.is NOT being used.;+]`` `  P7   Jyes ;;    rF                          ?     >     =  ^ @ "BEST ;Y'droppedincreased;;;  9;;;;;;;;;;;@ @ @ @ @ @@ @@@@@@ @@ @@@@@@@@=  \ @Z"yes  \;   @=  a  9;;;;;;;;;;; @@@@@@@@@ @ @ @@@@@@@@@ @ @ @=  a @=  _ @=  ^  @=  _  @  88d      LB d    Bw    (')+y +y n1 x!! !<q!*t. Q!? !ch c!Rnot,(!! j!!  P" q!*Q!? A!1! ////0/ wY@W swW H H H (p lwwwwwwwwgt?ww@ H H H (p lwwwwwwwGpY@W swW X H X p lwwwwwwwwwwwwwwwwwwwwwwww>>Gxxpwwww, lww7 rxpwwww lww' qwwwwW!pQpvwwwwwwwwwwwwwwww lwwwwwww lwwwwwH(%pww lww'ww V).OM ".OM ".OM ".OM ".OM ".OM ".OM "+OM8pwww7|*`*``۞s.YAqwwwG!pQpvwg"x ZZuwxzxZ r'| z|sx|'OjUEhHZ HZ XMLhJ LLH OOh |wwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwww00//*2/'/1O/2O/5O /6O ////// / / /////    !!    &2 !  %" x!!Chart1_Chart 1 %!<q!*Q!? !!R(!! $ !!  $ " q!*Q!? A!1! //@!;0!x] |Uՙ?woIHx!! -PF-:fZPTI #Ru[tji[ncnժ%m֖jib[* ʛ~s X'<9}{ͻaܣ?أlBȬ6"~miMoMoO=G95y\_66越<T#zWoQn ȷdzK(֖ NQj!{iy_LmɗM8=Ebx.U[ mo6f؋;/ '90 x{ޓ~A7 3%(B:hW |&ً>7rC>E"2i /ڻ^^ |g4|9~Y|4|?k __ _+WWixѮ S_*?JËv4A(2^*reg5Հ65^؇k_cGkxѮ+4G/W /Z /9o9|!ї81uN⭄u3^Q?|";c | QËvFߤE{ `{1| |ʒ7]N^?=.=b8E÷ϙVu.÷O=O|cᶕ ? D /ikqӛch'ixўD[-n<'~E{2m9,C ?  /Shks#~ V /ڭuL{Ys3|+[ T /SiOW3TO54hOfA ? Ji|)`yU&E7Q`4Q!}va瑭Y:X1X 6+aaV'ap G>DLZX18 \ og֧/V .>V<a!\}|a@ &l!@B`Xyယ!0C Hu1^b]RCrelCC2rmc/6V ! Y: &lCaCNM/rCE^>Z4>C!0D5T3Ɗ!B*B>% `@*!rlơ**`+eaC Q0JMF(jDmj^zY1 rlFhjy_3%,Cajٌd-0" c cٜ'l+gWuP0C\;za,0gO#%Vϊa, rlFFڷ dhF dh&*dhfaa\G a0˕&|ybN+i0ah}gSŴ&fNC 0l Wӛjz3eΑmb5& a\Oo3ݸ XO+$`$Wԛz\]1_$a2z\Skk0McAǂ9#Ny|h{`9J9l4;*;rIYb[f*y>L|qj h'OETy3ng"*b4r3M 5 /K}GٌxlxK//^׼x9x8iWtHO(SV>nxho) ^lxyRhDD'MyRxh^x xI'!^^xԲZz큗O֧|UWg$UU ]^.@|wgܻ"(OH֧|5הpu5˓5/OF<<ic ^&|ا˧ /wh^@2vxS/O/OA/z7)+fx눗^yy*婈ϠZ6gkx֧| 7DO^{UL'Cg$c[ /Լ|MMˏk^~/J-G9vOΗ[/[ /Ҽ| --4/OC< < rch$9v2n/^Լ܉xixy鈗#^n+}"xy^| o;xm˷//6\yr!xp6xO2cˎݣq$#{^=iʐJKW[/̑|+x#S<_^ R][AR/w<n8D҆_hle׸=^ws'}!ЕѾ/ho]V9co]sOĶ[|}PݫiC2.̅BdOO)Q?;X-ׅ=iT{j1j0~_^Py{ [,|e k?&l=ăּak>ak++[/7lm PVYfoy}YٸXFQ YJ6֎ +,m[-6ƶVV%2lqhhfk[+ [+VEZeZhOm݆w7t[|}hmOYOލ>me/ -_3Bve}9y~m~fVuaG+ Rg¿]i5e\i>uwMWɕU UT,.tE,D,BbaA,,# XXZ,,$Bba'bJbqEFbaC,l#  XZ,l$6Fb$bJB94{ pX8Z,$1bhpX8 KmD W`F~4X,O&\$.5bjpX ׈EbB,\$^". $0b!  OƒXxF,<- b!$:" ?XH,|ob#! _‡XH,D,kҼE0XH,E`"b  @E"XZ,>WT*P|giBn]ҟ|AFu~orc|ŭc=oֳNuΘǢ &ܶ+( `287=*ω߭s<8x[íyp>w$IQ]#"&=һw =./bU:~~_[>D>0c<-F4|*ɑ[OO/UhL/g |V˟liݶ 59 K~9 |^Kw*|G>*=VN;u|:e~ب~P܇f܂=0X1ؒ!dF |bP j dxzlpE< ۜbqZjP k d-sb@c$+l/1(a5::]!DRC 6"fŐBCV~1'(428]+ ŐErC9`! y!/bnCa4()a*}Rx.|P1\R@k'Id_W5CT>o㹧Eqa_uws\7q%>O|nao5EQJj.]3 >e|ӭ}c|7|]:e&([$+_ڰZSZܵ%cY{)gʑxu S9kYr(,C9KSB@9PҔ,PB ,EnIJ?"g*grT_}D7Ma(gK%GQنr(gr)g#٠(gٚr6 وr^)h9lr3 dt@9PєsP1s4D9sC9GSAs@9Q+\M9-]PEsec.M ʉ0qk(jʹr.(ʹr. ʹr)"ʹ(r̖(!y{nh)vߵB SΣZ+?B;~߃m;aEHd`.>r|6}[/#c^ ;@`Ȝď[.# '}9\FBa99BNINL qe$)#'S}i-'C$~r d4dfdF̐9\FBa91r29/3wdvȜď[.#9퓜i92'H(,'sFN '$'ZNI2 ɼyhdd4dN-PXNFFN]k5 j6PC-ZP^.y͹aۭ|;}6Hu$eMɹ)I>)r)r)Y^qWþ5~xa0ƾ3X|}?hʊŎdO|gZroi[NFo&FKX?~OJμx:o{Qv;V /_(fd; p 3K' '|3\[ [u޻knbυfZV%~u#Yz3dK vqwCY.#yw{ޮq\pCU{; l- t)du+Qu'Qwu/Q QTN3z6Q%D=z~Yf Qsmߞ͟˟oc)j ϋ!W^V sdߞ9U8rYҴAQ $qQ'7/sK˧f3^23>Kzڎum0.krK\魏W]ma|q00"XR[qw3Wv9TWzQq P]镎 /"^>^>hxyf-^ޮoG𷃗#^8|^2%VX>bV[+o/o5C߁/@i^ބxyxym!V^fxS SStc t9fqS4y`sGSC?G+wW :{Zz,Ztgw.YmwX:m/\rE__rZi\b%zϞu@Egtkk柑vEt9z=sيtY4sUWn\=楽]{\#*yl0,.?gK劽н.]xե',Zb11ԣXz1g+~ Q$6nFǯkCdocroGcrDwk=El.g~oݳ^֯#ZiVLcd&ZoiQoIs+=˫m $'wU wܝe:3"3Ʉb//0/w@w7 pww lwwrwwwwwwwwwwwwwwwwwwwwwwwgpww8pwwwwwwwwwwwwwwwwwwwwwwww dZw7. ;W"rwwwwemwwwwwwwwwww799twwwwemwwwwwwwwwwwH7z'"wwwwWX!Pvwwwwwwwwwwwpwwz9.$o#O (p lwww wwwwwwg>pwwwwwwwwwwwwwwwwwwwfwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwww700//*2//1Offf/2O/5O/6O////// |/ P|/ 0// / /  / // ////     !! #       3 !   4 !   StartF .rrrs2sRsrssssst2tRtrttu<7~34t7%    Pr r)$$GG(' .r   r   r   s   &s   Fs   fs   s   s   s   s   t   &t   Ft   ft   tq#  Grading Scale /uv(wwxx y)z|}4}T}}}T~~q/L XBރ,zȄ(Hhȅ(Hhu<7~2 }   }u }1 A+AGA` u }   }v f~11 w@1t@11p@1ffffff@Aq v }   }Jw G}   Aq w }   }w @}1 Aq w }   }5x W}11@e@1@`@111Aq x }   }x R~31  Aq x }   }By ~31%@% @%333333 @%@%@%333333@%?%?%ffffff?%?% Ap y }   }Kz |3333333333!3#3%Ap A  A-  B+  B  B-  C+  C   C-   D+   D   F  G? z }   }1| ~33@3 @3333333 @3@3@3333333@3?3?3ffffff? 3?"3$Aq |   }   (} }   }v} ~A} H} }   }} -~?A| } }   }~ -~@A| } }   }v~ -~@A| H~ }   }~ -~@A| ~ }   }4 -~@A|  }   } -~@A| e }   } -~@A|  }   }Q -~ @ A| # }   } -~"@@ A|  }   } -~$@ A|  }   }n -~&@ A| @ }   }́ -~(@? A|  }   }, ~*@A}  }   }z ~,@A} L }   }Ȃ ~.@A}  }   } ~0@A}  }   }d ~1@A} 6 }   } ~2@A}  }   } ~3@A} ҃ }   }N ~4@A}   }   } ~5@A} n !   "  ܄ #   $   %  < &  \ '  | (   )   *  ܅ +   ,   -  < .  \ /  |t%Z_score WarningF <\|܈<\|܉u<7~ 27|8 |8  |7 | }   } c~A%$ GG#"Ah       0   P   p         Ј         0   P   p         Љ" InstructionsF eŋ%EeŌ%u<7~27 }   }Ԋ }G!GGA*8,./GAa    Y   y         ً         9   Y   y         ٌ      Grades w= ՙwH_؝Q%v,Cƨ&FfƩ&Ffƪ&Ffƫ&FfƬ&Ffƭ&FfƮ&FfƯ&Ffư&FfƱ&FfƲ&FfƳ&Ffƴ&FfƵ&Ffƶ&FfƷ&FfƸ&Ffƹ&Ffƺ&Ffƻ&FfƼ&Ffƽ&Ffƾ&Ffƿ&Ff&Ff&Ff&Ff&Ff&Fu<7~235 4+44:6  +4 6 4X6 4446 6  4!ރ6 "# 6 $9с6 :+ ~   ~ SG04)6AAR.Ae  ~   ~4 {}79:7;<=G?@5BE3JHT/WAe  ~   ~ 1A "<ALXz?X?]\?W ?G3Ey@I0XAe   ~   ~ v9"<AX]\W GI0YAe      ~   ~ u"<AX]\W GI0ZAe k ~   ~_ ~) >"<AX]\W GI0[Ae 1 ~   ~7 ~)*8,.-"<AX]\W GI0\Ae   ~   ~+ ~)"<@X]\W GI0]Ae  IS being used.  ~   ~% ~)"<X]\W GI0^Ae  ~   ~ ~)"<AX]\W GI0_Ae ə ~   ~Ț ~)"<AX]\W GI0`Ae  ~   ~ ~)"<AX]\W GI0aAe k ~   ~j g(+)#=AN@=?=1bAe < ~   ~ L~)ACFGHKO2OAe ՜ ~   ~ G~)AGCFHKP2cAe S ~   ~ |A?ZLXz?[3EyPV3dLXz?M3EyM3EyM3EyMAe ̝ ~   ~ƞ {G22AG5IL3U3etX߂@Nvn0>@Nvn0>@Nvn0>@NAe  ~   ~s G35A Q?ZtX߂@[vn0>@P(\ @V4ftX߂@Ovn0>@Ovn0>@Ovn0>@OAe E ~   ~G  t@C@A LXz?Z@[@P @V 5@U@U@U@UAe  ~   ~ G?&)+@-/1357:>A@E @CLXz?D@(A6WQ?Q@Q@QAe  ~   ~ h'*,.02468;?BAGDGqrA@FH JKL3gYYYYAe A  A-  B+  B  B-  C+  C  C-  D+   D   F  G? Teacher Year Course final or preliminary A  B  B  B  j ~   ~ %?TTT?TTTTTTTTTGA3RRRRAe BEST        ~   ~N .nGMQSV3hAe   ~   ~ MA3SSSSAe          e !A&A  7   z         ڨ         :   Z !  z "   #   $  ک %   &   '  : (  Z )  z *   +   ,  ڪ -   .   /  : 0  Z 1  z 2   3   4  ګ 5   6   7  : 8  Z 9  z :   ;   <  ڬ =   >   ?  : @  Z A  z B   C   D  ڭ E   F   G  : H  Z I  z J   K   L  ڮ M   N   O  : P  Z Q  z R   S   T  گ U   V   W  : X  Z Y  z Z   [   \  ڰ ]   ^   _  : `  Z a  z b   c   d  ڱ e   f   g  : h  Z i  z j   k   l  ڲ m   n   o  : p  Z q  z r   s   t  ڳ u   v   w  : x  Z y  z z   {   |  ڴ }   ~     :   Z   z         ڵ         :   Z   z         ڶ         :   Z   z         ڷ         :   Z   z         ڸ         :   Z   z         ڹ         :   Z   z         ں         :   Z   z         ڻ         :   Z   z         ڼ         :   Z   z         ڽ         :   Z   z         ھ         :   Z   z         ڿ         :   Z   z                  :   Z   z                  :   Z   z                  :   Z   z                  :   Z   z                  :E(?BDistribution graphu<7~dh !  h " aQ =&4$@1R Inserted1a!Chart1_Chart 1  f MacrosF @-+3u<7~ "   2  "" r!Asi&jnrAAA "      A         uA  ?   ?b W@GtsklmnkopqrA- 4     2Gvsg A     O >GsgA !     \G sw~}G|{zyxA      M >GsgA      &GsrA           U +sA '     A u         j& dd&& &&&&&, Oh+'0 `lx rsstakettstake230@'u@V@Quattro Pro for Windows 7