ࡱ> bxda  !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwyz{|}~Root Entry F c@]Workbook%_VBA_PROJECT_CUR"#" VBAP  `\pJohn Kongsvold Ba=  ThisWorkbook=X#7!8X@"1Arial1Arial1Arial1Arial1$Arial1 Arial1Helv1Arial1hArial1Arial1Arial19Arial1Arial1Arial1 Arial18Arial19Arial15Arial1Arial1 Arial19Arial19Arial1 Arial19Arial14Arial1Arial19Arial10Arial1Arial1Arial1Arial1QTahoma1QTahoma1QTahoma1QTahoma1Arial1Arial1Arial1Arial1Arial"$"#,##0_);\("$"#,##0\)!"$"#,##0_);[Red]\("$"#,##0\)""$"#,##0.00_);\("$"#,##0.00\)'""$"#,##0.00_);[Red]\("$"#,##0.00\)7*2_("$"* #,##0_);_("$"* \(#,##0\);_("$"* "-"_);_(@_).))_(* #,##0_);_(* \(#,##0\);_(* "-"_);_(@_)?,:_("$"* #,##0.00_);_("$"* \(#,##0.00\);_("$"* "-"??_);_(@_)6+1_(* #,##0.00_);_(* \(#,##0.00\);_(* "-"??_);_(@_);;; dd\-mmm\-yy_) mm/dd/yy_) 0.0_)0_) hh:mm_) dddd\ m/d/yy dddd000.0 dd\-mmm_)m/dmmmm\ d\,\ yyyy mm/dd/yy;;;General" ";;;" "General;;;" "General$[$-409]dddd\,\ mmmm\ dd\,\ yyyy"Yes";"Yes";"No""True";"True";"False""On";"On";"Off" 0.0%,'[<=9999999]###\-####;\(###\)\ ###\-#### mm/dd/yy;@ 0.0;[Red]0.0 m/d/yy;@ 0.00_) 0.000_) m/d;@ ###\-#### mmm\-yyyy                + ) , *      q  q q X  q"  s"  q ( q!  q" q"  q ( q!  q" p  q#  y"  s   p p q q! p" p") p ) p p p! p ) s"@  s @  q @ q ( q" s"  s  q  q!X q H  s  q#  q 1q L p  p  p  P q#X s# q# p q"  s&@@  s&@  s&  @   s"!@@ s"!@ s" ! @ s!@ s" s" s! @ s" s" s!"@@ s""@ s" " @ s" @ s s s s# " q      (       #)  "   )  "    "   "  "   # "  "     "@  "@   @   @   @  "  "       !  a    ` q" q p! p" p   ` $ $ %" &` '" p" p"  " " & 1p! p!   p" $  `  a (  s!@H  s!H  s H  s"@H  s"H  s" H s"@H s H s! H s  @ H s H s H (p"@H '"  q   !  p"@H s! s  s"  " "  c! " " (p"@  q (  q ( (p"@ (1p"@ (p" @  q (  q ( q"8"@@ q"8"@ q"8 " @  s" q" q  q"  s""@@  s""@  s" " @ q)X  " "  Normal_Attend Fa2000Normal_Consol Test`= GradeBook Avg1 Y}Avg2 Avg3 Avg4 o2Avg5! Attendance%Mid-Term8 " Averages;&" Averages;&" Averages;&" Averages;&" Averages;&Course:R% Course_Info;OWCourseID:CourseID:CourseID:CourseID:CourseID:CRN:QDays:V" FirstFormula:" FirstFormula:& FiveFormulas;& FiveFormulas;& FiveFormulas;& FiveFormulas;& FiveFormulas; Grade;&  Grade;& &HideCalcNoteCell:&HideCalcNoteCell: Instructor:U! LastStudent:%! LastStudent:%! LastStudent:%! LastStudent:%! LastStudent:%! LastStudent:%! LastStudent:%)LetterGradeNoteCell: )LetterGradeNoteCell: Name:T NameCount:( NameCount:'  ;;  ;&  ;&  ;&  ;&  ;&  ;&   ;' * );;* );;* );;* );;* );;* );;  ;  ;& QuizAverages;& QuizAverages;& QuizAverages;& QuizAverages;& QuizAverages;(QuizLookupNoteCell:(QuizLookupNoteCell:% RosterNames;%% RosterNames;%%ScoringNoteCell:%ScoringNoteCell:Section:S& StudentMarks;%& StudentMarks;%Term:PTime:WTopName:TopName:TopName:TopName:TopName:TopName:TopName:TopName:" TopRowScore1:" TopRowScore1:" TopRowScore1:" TopRowScore1:" TopRowScore1:"ffpP @P$ 73 A@@   Quiz Pre-WritingExamHmWkProjectFinalWeighted LetterGradeExtraExtra Credit ItemsAvg1Avg2Avg3Avg4Avg5AverageOverrideCreditScoring Weights--->> = ColumnTotal Class Average StudentCounthYou should modify the column titles and weighting percentages above the six student score columns above.OBlank cells count the same as zero toward the weighted average and final grade. Class High Class LowStandard DeviationClass Bonus Points or Curve  2007 - John Kongsvold Note: Point HereGrade Dist. TableLetter Grade Table GradeCountTotalsAdjustedABottomLetterA-Adj.B+~~~FBD-B-DC+D+CC-I N*W*Roundingo Grade Description 1Grade Description 2Grade Description 3Grade Description 4Grade Description 5Grade Description 6Grade Description 7Grade Description 8Grade Description 9Grade Description 10Grade Description 11Grade Description 12Grade Description 13Grade Description 14Grade Description 15Grade Description 16These columns will not print.Important Note: Point Here.Final Average is computed with  lowest grade(s) dropped. Quiz GradesDroppingName% <Student names and formulas cannot be modified on this sheet.FThe number of lowest grades to be dropped can be modified at any time.POnly cells that appear with green characters can be changed on this sheet. [Do not move or drag any values or text. Just select a student score cell and enter a value.oScores can be entered for computation with or without decimals but will display rounded to the nearest integer.kThe green percent sign characters in the grade cells indicate which columns can be used for student scores.SThe percent sign characters in the grade cells can be replaced with student scores.LThe percent sign characters in the grade cells will not affect the averages.NOnly 16 grades per student can be entered on this sheet to allow for printing.kIf you have any problems or suggestions please send email to: jkongsvold@hcc.commnet.edu or call HCC x5128.pOnly Grade Scoring Weights, Letter Grade Overrides, and Extra Credit Totals can differ from the GradeBook sheet._Grade Column Headings, Student Names, Student Grades, etc. are copied from the GradeBook sheet.2007 John Kongsvold2This grade book was constructed from 6/6/2007 data NoteWStudent1Student2Student3Student4Student5Student6Student7Student8Student9 Student10 Student11 Student12 Student13 Student14 Student15 Student16 Student17 Student18 Student19 Student20 Student21 Student22 Student23 Student24 Student25Optional Descriptions Row Student26 Student27 Student28 Student29 Student30 Student31___________________2005-2007 John Kongsvold 2005-2007 - John Kongsvold |The first five student grade columns above contain formulas that automatically retrieve the average from the the Avg sheets.`Only cells that appear with green text or colored background can be changed on this sheet. mAny of the Avg1-5, Attendance, or Mid-Term sheets can be renamed or removed by Right-clicking the tabs below.The formulas in the first five student grade columns can be replaced with student scores, zeros, or just deleted, if you don't want to use the computed averages from the the Avg sheets.NColumn averages and standard deviations below ignore text in the student rows.\Do not drag or move any text or value cells. Just select a cell and enter the text or value.Kongsvold, John Course InfoTermCRNCourseSectionTimeFa07CSA106MW11:00-12:45 pm03 Course NameInstructor Name Course DaysChange Course Info in cell A80+ 4,Z~,,./0640Z01j2V3|K6q 7 7 H8n 8 29X "<Hg<ccN  XB?G  dMbP?_*+%&R&D30&L&F&CPage &P of &N&R 2005-2007 John Kongsvold&?'?(?)?M6HP DeskJet 855CseXC od,,LetterDINU"4$u $$$$"d ,,??cU} I } I  } m  } I  }  }  }  } $ } I } I }  } m } $ } %m  Scoring Weight X%%% @% @%h%w %J %w@%w@%w@ %w@ %w@ %w@ %w@ %w@%w@%w@%w@%w@%w@%w@%w@%w@%w@%w@%w@%w@%w@%w@%w@%w@%w@%w@ c;2b %CE GradeBook for CRN - C !Fa07 GradeBook for CRN - 3124 5X2b C-CB ~ C$/,CSA106-03 ~ Change Course Info in cell A80 2b CKongsvold, John         !   !  ,$&2b C CFMW 11:00-12:45 pm      " # $  !   !.%%%%%%%%%%%%%%%%%%%%$ &-!lV?-!lV?-!lV?-!lV?-!lV?-!lV? '#(X? %  $  !   !.%%%%%%%%%%%%%%%%%%%%$ f+*!D9Bf+*!D9Bf+*!D9Bf+*!D9Bf+*!D9Bf +d,:b! %B%B {D@DD6@D@DD6@D@DD6@D@DD6@D@DD6@D@DD6@D Bq -:b [D A   $ ADA  DDK%>IBf "BW    e  . .#/& %$>~00000000000000000000$ g+*!D9Bf+*!D9Bf+*!D9Bf+*!D9Bf+*!D9Bf~ +,) $-B-B {L@LL6@L@LL6@L@LL6@L@LL6@L@LL6@L@LL6@L B -;b) e$ [LA   ,ALA  LDK%>IBf "BF    . ./$ ->~00000000000000000000$ h+*!D9Bf+*!D9Bf+*!D9Bf+*!D9Bf+*!D9Bf~ +,)  -;b)  F    . ./ ~00000000000000000000$ i+ *! D 9Bf+ *! D 9Bf+ *! D 9Bf+ *! D 9Bf+ *! D 9Bf~ + ,)  -;b)  F  . . / ~ 00000000000000000000$ j+ *! D 9Bf+ *! D 9Bf+ *! D 9Bf+ *! D 9Bf+ *! D 9Bf~ + ,)  - ;b)  F  . . / ~ 00000000000000000000$ k+ *! D 9Bf+ *! D 9Bf+ *! D 9Bf+ *! D 9Bf+ *! D 9Bf~ + ,)  -;b)  F  . . / ~ 00000000000000000000$ l+ *! D 9Bf+ *! D 9Bf+ *! D 9Bf+ *! D 9Bf+ *! D 9Bf~ + ,)  -;b)  F  . . / ~ 00000000000000000000$ m+ *! D 9Bf+ *! D 9Bf+ *! D 9Bf+ *! D 9Bf+ *! D 9Bf~ + ,)  -;b) F  . . /~ 00000000000000000000$ n+*!D9Bf+*!D9Bf+*!D9Bf+*!D9Bf+*!D9Bf~ +,! %B%B {D@DD6@D@DD6@D@DD6@D@DD6@D@DD6@D@DD6@D Bq -;b![D A   $ ADA  DDK%>IBf "BF    . .#/ %$>~00000000000000000000$ o+*!D9Bf+*!D9Bf+*!D9Bf+*!D9Bf+*!D9Bf~ +,! %B%B {D@DD6@D@DD6@D@DD6@D@DD6@D@DD6@D@DD6@D Bq - ;b![D A   $ ADA  DDK%>IBf "BF    . .#/ %$>~00000000000000000000$ p+*!D9Bf+*!D9Bf+*!D9Bf+*!D9Bf+*!D9Bf~ +,)  -$;b) F    . ./~00000000000000000000$ q+*!D9Bf+*!D9Bf+*!D9Bf+*!D9Bf+*!D9Bf~ +,)  -(;b) F    . ./~00000000000000000000$ r+*!D9Bf+*!D9Bf+*!D9Bf+*!D9Bf+*!D9Bf~ +,)  -,;b) F    . ./~00000000000000000000$ s+*!D9Bf+*!D9Bf+*!D9Bf+*!D9Bf+*!D9Bf~ +,)  -0;b) F    . ./~00000000000000000000$ t+*!D9Bf+*!D9Bf+*!D9Bf+*!D9Bf+*!D9Bf~ +,)  -4;b) F    . ./~00000000000000000000$ u+*!D9Bf+*!D9Bf+*!D9Bf+*!D9Bf+*!D9Bf~ +,)  -8;b) F    . ./~00000000000000000000$ v+*!D9Bf+*!D9Bf+*!D9Bf+*!D9Bf+*!D9Bf~ +,)  -<;b) F    . ./~00000000000000000000$ w+*!D9Bf+*!D9Bf+*!D9Bf+*!D9Bf+*!D9Bf~ +,)  -@;b) F    . ./~00000000000000000000$ x+*!D9Bf+*!D9Bf+*!D9Bf+*!D9Bf+*!D9Bf~ +,)  -D;b) F    . ./~00000000000000000000$ y+*!D9Bf+*!D9Bf+*!D9Bf+*!D9Bf+*!D9Bf~ +,)  -H;b) F    . ./~00000000000000000000$ z+*!D9Bf+*!D9Bf+*!D9Bf+*!D9Bf+*!D9Bf~ +,)  -L;b) F    . ./~00000000000000000000$ {+*!D9Bf+*!D9Bf+*!D9Bf+*!D9Bf+*!D9Bf~ +,)  -P;b) F    . ./~00000000000000000000$ |+*!D9Bf+*!D9Bf+*!D9Bf+*!D9Bf+*!D9Bf~ +,)  -T;b) F    . ./~00000000000000000000$ }+*!D9Bf+*!D9Bf+*!D9Bf+*!D9Bf+*!D9Bf~ +,)  -X;b)$ F    . ./$~00000000000000000000$ ~+*!D9Bf+*!D9Bf+*!D9Bf+*!D9Bf+*!D9Bf~ +,)?#-B-B {L@LL6@L@LL6@L@LL6@L@LL6@L@LL6@L@LL6@L B -\;b) e# [LA   ,ALA  LDK%>IBf "BF  ../# ->~00000000000000000000$ +*!D9Bf+*!D9Bf+*!D9Bf+*!D9Bf+*!D9Bf~ +,)  -`;b)  F  ../ ~00000000000000000000$DCl$Y""""""  """"""""""""""5 %w@!%w@"%w@#%w@$%w@%%-@ &%Y@'%Y@(%Y@)%,@*%Y@+%Y@,%@-%Y@.%Y@/%Y@0Y@1Y@2Y@3,4,5,6;78,9J :; ;; <,=; >?, + *! D 9Bf+ *! D 9Bf+ *! D 9Bf+ *! D 9Bf+ *! D 9Bf~ + ,)  -d;b)! F .. /!~ 00000000000000000000$ !+!*!!D!9Bf+!*!!D!9Bf+!*!!D!9Bf+!*!!D!9Bf+!*!!D!9Bf~ !+!,)! ! -h;b)" F ! ..!/"~!00000000000000000000$ "+"*!"D"9Bf+"*!"D"9Bf+"*!"D"9Bf+"*!"D"9Bf+"*!"D"9Bf~ "+",)" " -l;b)# F " .."/#~"00000000000000000000$ #+#*!#D#9Bf+#*!#D#9Bf+#*!#D#9Bf+#*!#D#9Bf+#*!#D#9Bf~ #+#,)# # -p;b) F # ..#/~#00000000000000000000$ $+$*!$D$9Bf+$*!$D$9Bf+$*!$D$9Bf+$*!$D$9Bf+$*!$D$9Bf~ $+$,)$ $ -t;b) F $ $ $ . $.$/~$00000000000000000000$%) %* %* %+ %+ %+ %+ %1 % 2 %  % ++4.%44444444444444444444$ &5&6!&y)%$@"N$&@"NB 9)%$@"N$&@"NBD6@B&6!&y)%$@"N$&@"NB 9)%$@"N$&@"NBD6@B&6!&y)%$@"N$&@"NB 9)%$@"N$&@"NBD6@B&6!&y)%$@"N$&@"NB 9)%$@"N$&@"NBD6@B&6!&y)%$@"N$&@"NB 9)%$@"N$&@"NBD6@B&6!&y)%$@"N$&@"NB 9)%$@"N$&@"NBD6@B&6&6!(y)%$@"N$&@"NB 9)%$@"N$&@"NBD6@B& 7 & 888 '';;;;;;;< ' 888 (9(:?@ 3 #>B(;;;;;;;< ( 888);;;;;;=; ) 888 *>*??????@@ * 888 +>+??????@@ + 888 ,, , 888 ->-??????@@ - 888 .>.??????@@ . 888 />/??????@@ / 888 0>0??????@@ 0 888 1>1??????@@ 1 8882>??????@@ 2 888 3A3@!3y)%$@"N$&@"NB 9)%$@"N$&@"NBD6@B3@!3y)%$@"N$&@"NB 9)%$@"N$&@"NBD6@B3@!3y)%$@"N$&@"NB 9)%$@"N$&@"NBD6@B3@!3y)%$@"N$&@"NB 9)%$@"N$&@"NBD6@B3@!3y)%$@"N$&@"NB 9)%$@"N$&@"NBD6@B3@!3y)%$@"N$&@"NB 9)%$@"N$&@"NBD6@B3@3@!4y)%$@"N$&@"NB 9)%$@"N$&@"NBD6@B3 B 4A4@!4y)%$@"N$&@"NB 9)%$@"N$&@"NBD6@B4@!4y)%$@"N$&@"NB 9)%$@"N$&@"NBD6@B4@!4y)%$@"N$&@"NB 9)%$@"N$&@"NBD6@B4@!4y)%$@"N$&@"NB 9)%$@"N$&@"NBD6@B4@!4y)%$@"N$&@"NB 9)%$@"N$&@"NBD6@B4@!4y)%$@"N$&@"NB 9)%$@"N$&@"NBD6@B4@4@!5y)%$@"N$&@"NB 9)%$@"N$&@"NBD6@B4 B 5A5@!5s)%$@"N$&@"NB 3)%$@"N$&@"NBB5@!5s)%$@"N$&@"NB 3)%$@"N$&@"NBB5@!5s)%$@"N$&@"NB 3)%$@"N$&@"NBB5@!5s)%$@"N$&@"NB 3)%$@"N$&@"NBB5@!5s)%$@"N$&@"NB 3)%$@"N$&@"NBB5@!5s)%$@"N$&@"NB 3)%$@"N$&@"NBB5@5@!<s)%$@"N$&@"NB 3)%$@"N$&@"NBB5 C 6A*6DDDDDD 6EFC 7GGGGGGG 7 H 88 I 9JK2 :L! :M" :NO :#:PPJ ;J$ ;Q% ;R& ;S' ;% ;( ; ;PPJ <J$ <T)<U)=<<J #LAZ<V <* < <+ <PPJ =J$ =W,=X)=<#=Y!> %<=% =- =* =% =PPJ >J$ >T.>U)?<>V >/~ > >0 >PPJ ?J$ ?T1?U)@<#?V!A %>@%~ ?$@?33333M@ C <D? ?2 ?PPJ DO$l"78[*88:88888,''L&Lr@ ; A ,B ,C ; D @E ,F ; G ; H ,I ,J , K , L M N , O J P,Q,R,S,T,U,V,W; @J$ @W3@X)?<@Y~ @@O@ ?D@ @4 @PPJ AJ$ AT5AU)A<AV~ AAP@B CDA A6 APPJ BJ$ BT7BU)C<#BV!B %AC%~ BBQ@D FDB B8 BPPJ CJ$ CW8CX)B<CY~ CC@R@@ IDC C7 CPPJ DJ$ DT6DU)D<DV~ DD@S@E MDD D5 DPPJ EJ$ ET4EU)F<#EV!E %DF3~ EET@F PDE E3 EPPJ FJ$ FW2FX)E<FY~ FFT@G SDF F1 FPPJ GJ$ GZ0G[>@)G<G\>@!GDG~ GGU@H WDG G. GPPJ HJ$ HT9HU)H<HV~ HHV@I ZDH H, HPPJ IJ$ IT:IU)J<#IV?!I %HJ%~ II@W@K ]DI I) IPPJ JJ$ JW;JX?)I< JY J JPPJ KJ$ K]K^#K_?@!c %;J%K` Ka<~ K? KPPJ L M Nccccccccc N J= O O O8 P PP~ Qh@ QQ R RR S SS T TT U UU V VV W WW4 i**&&&&&&&  c    B   N$  B B @       U"  u                                                                               ave fin   h  w  De Cl  Po urv                                           hn    int rad abl r G e                         ota ste ott er j. ~ D- C C N Rou                     esc  cri Gr ipt rad tio de  on   De  6 esc  cri Gr ipt rad tio ade ion  de  on  e D  n 1   De   14!! Des!! 15!! esc!! 6!! lum!! ot "" Imp"" te:"" re."" Ave"" omp""  ## gra## ppe##  Gr## opp## e#  ude## and$$  ca$$ odi$$ his$$ Th$$ of $$ adeK rop  (    BD XPP?> :L6]4@D`]  KKzC <John Kongsvold: This value is added to each students total score for the purpose of determining the letter grade. Adjust this value as you see fit.< e!t(  B XPP?;zU@]4@] 3ZEr(0 w<xJohn Kongsvold: Use values in this column to adjust the lowest score for each letter grade to fit your grading system.< e!w   B  XPP?339]4@  ^ ss,.$C\P w<xJohn Kongsvold: Use values in this column to adjust the lowest score for each letter grade to fit your grading system.< e!w   Bp XPP?349]4@p` ]:eKQ䝌 w<xJohn Kongsvold: Use values in this column to adjust the lowest score for each letter grade to fit your grading system.< e!w   Bԏ XPP?35 9]]4@ԏh` ^Ha w<xJohn Kongsvold: Use values in this column to adjust the lowest score for each letter grade to fit your grading system.< e!w   Bs XPP?36:]4@sPb cXmMukzy w<xJohn Kongsvold: Use values in this column to adjust the lowest score for each letter grade to fit your grading system.< e!w   BTt XPP?36<]4@Ttb MJ1{ w<xJohn Kongsvold: Use values in this column to adjust the lowest score for each letter grade to fit your grading system.< e!w   Bt XPP?38<]4@td qL2 I w<xJohn Kongsvold: Use values in this column to adjust the lowest score for each letter grade to fit your grading system.< e!w    Bu XPP?39#=]4 @ud O %ǜF}@' w<xJohn Kongsvold: Use values in this column to adjust the lowest score for each letter grade to fit your grading system.< e!w    Bu XPP?3:z@]4 @uf R'F"k w<xJohn Kongsvold: Use values in this column to adjust the lowest score for each letter grade to fit your grading system.< e!w    Bu XPP?3;z@]4 @u@g ^$_«NU w<xJohn Kongsvold: Use values in this column to adjust the lowest score for each letter grade to fit your grading system.< e!w    BHv XPP?3<fAs]4 @Hv(i  G\Q w<xJohn Kongsvold: Use values in this column to adjust the lowest score for each letter grade to fit your grading system.< e!w    Bv XPP?v )]4 @vi r\ +BIN\  \ <]John Kongsvold: This cell, the other cells in this column, and the cells in the next four columns contain a formula to automatically insert the unweighted student averages from the appropriate worksheet (Avg1, Avg2, etc.) into this GradeBook worksheet. The Avg sheets already contains all the student names and all the necessary formulas. The Avg worksheets also allows you to very simply choose the option of dropping zero, one, two, three, or four grade(s) from the computed average. If you do not need to use one or more of the Avg sheets and want to remove it, first replace all the formulas from the appropriate column with zeros(0) or other score; then right-click on the sheet tab below and choose Delete from the pop-up menu. Repeat for other average sheets that you want to remove. You can easily change the name of the Avg sheets that you want to use by right-clicking on the appropriate tab below and choosing Rename from the pop-up menu; then type in a more meaningful name and press Enter. If you have any problems please send email to: jkongsvold@hcc.commnet.edu or call HCC x5128.< a!G" \  Bw XPP?05]4@wpk ?V_F-9 2d <John Kongsvold: If you have any suggestions or problems please send email to: jkongsvold@hcc.commnet.edu or call HCC x5128. Thank You < [!v  Btw XPP?)]4@twk Vh$AMi9  H<!John Kongsvold: If you need to override the calculated letter grade for a student enter an I, N, W, or F etc. in this column for that student. To redisplay the calculated letter grade, click on the cell in this column and press the Delete key to clear the contents of that cell .<H [!A"!"%!"!   Bw XPP?  ^ =]4@wm wplG$  #<$Point to cell M7 to see note there.<!#  B@A BBOO  $MM LL ::,, 7? $MM LL ::,,  $$;$$ $MM LL ::,,  wsGBggD  5YVw  dMbP?_*+%?&C&F2/&L&D&CPage &P of &N&R 2005-2007 John Kongsvold&?'?M6HP DeskJet 855CseXC odXXLetterDINU"4$u $$$$"dXX??cU} d}  d} md} d} d} d} md}  d} d} d5?`@J@w@h?@ ?@?@?@ ?@ ?@ ?@ ?@ ?@?@?@?@?@?@?@?@?@?@?@?@?@?@?@?@?@?@?@ e f> f? f@ fA fB fC  fD  fE  fF  fG  fH fI fJ fK fL fMg hN ii O2gjjjggggggggggggggggg6(3b  Z ZB|BsAv CSA106-03<3b CEFa07gkkkkkkk  kP~   mQ mmmmmmg n n n n n R *oo nS nS nS nS nS T qr?)',BNr@)r@)r@)r@)r@)  r@)  r @)  r"@)  r$@)  r&@)r(@)r*@)r,@)r.@)r0@)q$pp?p@p@p@)H3b Z Student1+s!$D BNt~ u vU vU vU vU vU  vU  vU  vU  vU  vU vU vU vU vU vUtNw8%B %B<1GradeBqw\3b[%B 3%0x%B%B<2GradesB <2Gradeswp3bk%B C%%B%AF%B<3GradesB <3Gradesw3b{%B S%%B%AF%AF%B<4GradesB <4Gradesw3b&%B c%%B%AF%AF%AF%B<5GradesB <5Grades)3b Z Student2s),D BNt~ u vU vU vU vU vU  vU  vU  vU  vU  vU vU vU vU vU vUtwB8-B -B<1GradeBw3be$[-B 3-0x-B-B<2GradesB <2Gradesw3bk%B C%%B%AF%B<3GradesB <3Gradesw3b{%B S%%B%AF%AF%B<4GradesB <4Gradesw3b%B c%%B%AF%AF%AF%B<5GradesB <5Grades)4b Z Student3s)t~ u vU vU vU vU vU  vU  vU  vU  vU  vU vU vU vU vU vUtww$4b <2Gradesw84bk%B C%%B%AF%B<3GradesB <3GradeswL4b{%B S%%B%AF%AF%B<4GradesB <4Gradesw`4b %B c%%B%AF%AF%AF%B<5GradesB <5Grades )t4b Z  Student4 s)  t~ u vU vU vU vU vU vU vU vU vU vU vU vU vU vU vU t w  w4b  <2Grades w4b k% B C% % B% AF% B<3GradesB <3Grades w4b {% B S% % B% AF% AF% B<4GradesB <4Grades w4b % B c% % B% AF% AF% AF% B<5GradesB <5Grades )4b Z  Student5 s)  t~ u vU vU vU vU vU vU vU vU vU vU vU vU vU vU vU t w  w4b  <2Grades w5b k% B C% % B% AF% B<3GradesB <3Grades w5b {% B S% % B% AF% AF% B<4GradesB <4Grades w(5b % B c% % B% AF% AF% AF% B<5GradesB <5Grades )<5b Z  Student6 s)  t~ u vU vU vU vU vU vU vU vU vU vU vU vU vU vU vU t w  wP5b  <2Grades wd5b k% B C% % B% AF% B<3GradesB <3Grades wx5b {% B S% % B% AF% AF% B<4GradesB <4Grades w5b % B c% % B% AF% AF% AF% B<5GradesB <5Grades )5b Z  Student7 s)  t~ u vU vU vU vU vU vU vU vU vU vU vU vU vU vU vU t w  w5b  <2Grades w5b k% B C% % B% AF% B<3GradesB <3Grades w5b {% B S% % B% AF% AF% B<4GradesB <4Grades w5b % B c% % B% AF% AF% AF% B<5GradesB <5Grades )6b Z  Student8 s) t~ u vU vU vU vU vU vU vU vU vU vU vU vU vU vU vU t w  w6b  <2Grades w,6b k% B C% % B% AF% B<3GradesB <3Grades w@6b {% B S% % B% AF% AF% B<4GradesB <4Grades wT6b% B c% % B% AF% AF% AF% B<5GradesB <5Grades)h6b Z Student9s)t~ u vU vU vU vU vU  vU  vU  vU  vU  vU vU vU vU vU vUtww|6b <2Gradesw6bk%B C%%B%AF%B<3GradesB <3Gradesw6b{%B S%%B%AF%AF%B<4GradesB <4Gradesw6b%B c%%B%AF%AF%AF%B<5GradesB <5Grades)6b Z Student10s)t~ u vU vU vU vU vU  vU  vU  vU  vU  vU vU vU vU vU vUtww6b <2Gradesw6bk%B C%%B%AF%B<3GradesB <3Gradesw7b{%B S%%B%AF%AF%B<4GradesB <4Gradesw7b%B c%%B%AF%AF%AF%B<5GradesB <5Grades)07b Z Student11s)t~ u vU vU vU vU vU  vU  vU  vU  vU  vU vU vU vU vU vUtwwD7b <2GradeswX7bk%B C%%B%AF%B<3GradesB <3Gradeswl7b{%B S%%B%AF%AF%B<4GradesB <4Gradesw7b%B c%%B%AF%AF%AF%B<5GradesB <5Grades)7b Z Student12s)t~ u vU vU vU vU vU  vU  vU  vU  vU  vU vU vU vU vU vUtww7b <2Gradesw7bk%B C%%B%AF%B<3GradesB <3Gradesw7b{%B S%%B%AF%AF%B<4GradesB <4Gradesw7b%B c%%B%AF%AF%AF%B<5GradesB <5Grades)7b Z Student13s)t~ u vU vU vU vU vU  vU  vU  vU  vU  vU vU vU vU vU vUtww 8b <2Gradesw 8bk%B C%%B%AF%B<3GradesB <3Gradesw48b{%B S%%B%AF%AF%B<4GradesB <4GradeswH8b%B c%%B%AF%AF%AF%B<5GradesB <5Grades)\8b Z Student14s)t~ u vU vU vU vU vU  vU  vU  vU  vU  vU vU vU vU vU vUtwwp8b <2Gradesw8bk%B C%%B%AF%B<3GradesB <3Gradesw8b{%B S%%B%AF%AF%B<4GradesB <4Gradesw8b%B c%%B%AF%AF%AF%B<5GradesB <5Grades)8b Z Student15s)t~ u vU vU vU vU vU  vU  vU  vU  vU  vU vU vU vU vU vUtww8b <2Gradesw8bk%B C%%B%AF%B<3GradesB <3Gradesw8b{%B S%%B%AF%AF%B<4GradesB <4Gradesw9b%B c%%B%AF%AF%AF%B<5GradesB <5Grades)$9b Z Student16+s!$D BNt~ u vU vU vU vU vU  vU  vU  vU  vU  vU vU vU vU vU vUtNw8%B %B<1GradeBw89b <2GradeswL9bk%B C%%B%AF%B<3GradesB <3Gradesw`9b{%B S%%B%AF%AF%B<4GradesB <4Gradeswt9b%B c%%B%AF%AF%AF%B<5GradesB <5Grades)9b Z Student17+s!$D BNt~ u vU vU vU vU vU  vU  vU  vU  vU  vU vU vU vU vU vUtNw8%B %B<1GradeBw9b <2Gradesw9bk%B C%%B%AF%B<3GradesB <3Gradesw9b{%B S%%B%AF%AF%B<4GradesB <4Gradesw9b %B c%%B%AF%AF%AF%B<5GradesB <5Grades)9b Z Student18+s!$D BNt~ u vU vU vU vU vU  vU  vU  vU  vU  vU vU vU vU vU vUtNw8%B %B<1GradeBw:b <2Gradesw:bk%B C%%B%AF%B<3GradesB <3Gradesw(:b{%B S%%B%AF%AF%B<4GradesB <4Gradesw<:b%B c%%B%AF%AF%AF%B<5GradesB <5Grades)P:b Z Student19s)$,D BNt~ u vU vU vU vU vU  vU  vU  vU  vU  vU vU vU vU vU vUtwB$8-B -B<1GradeBwd:b <2Gradeswx:bk%B C%%B%AF%B<3GradesB <3Gradesw:b{%B S%%B%AF%AF%B<4GradesB <4Gradesw:b%B c%%B%AF%AF%AF%B<5GradesB <5Grades):b Z Student20s)t~ u vU vU vU vU vU  vU  vU  vU  vU  vU vU vU vU vU vUtww:b <2Gradesw:bk%B C%%B%AF%B<3GradesB <3Gradeswx;b{%B S%%B%AF%AF%B<4GradesB <4Gradesw;b%B c%%B%AF%AF%AF%B<5GradesB <5Grades);b Z Student21s)t~ u vU vU vU vU vU  vU  vU  vU  vU  vU vU vU vU vU vUtww;b <2Gradesw;bk%B C%%B%AF%B<3GradesB <3Gradesw;b{%B S%%B%AF%AF%B<4GradesB <4Gradesw;b%B c%%B%AF%AF%AF%B<5GradesB <5Grades)b  <2Grades w >b k% B C% % B% AF% B<3GradesB <3Grades w4>b {% B S% % B% AF% AF% B<4GradesB <4Grades wH>b!% B c% % B% AF% AF% AF% B<5GradesB <5Grades!)\>b "Z! Student28!s)!!t~ !u !vU !vU !vU !vU !vU ! vU ! vU ! vU ! vU ! vU !vU !vU !vU !vU !vU!t!w!!wp>b! <2Grades!w>b!k%!!B C%!!%!!B%!!AF%!!B<3GradesB <3Grades!w>b!{%!!B S%!!%!!B%!!AF%!!AF%!!B<4GradesB <4Grades!w>b"%!!B c%!!%!!B%!!AF%!!AF%!!AF%!!B<5GradesB <5Grades")>b #Z" Student29"s)""t~ "u "vU "vU "vU "vU "vU " vU " vU " vU " vU " vU "vU "vU "vU "vU "vU"t"w""w>b" <2Grades"w>b"k%""B C%""%""B%""AF%""B<3GradesB <3Grades"w>b"{%""B S%""%""B%""AF%""AF%""B<4GradesB <4Grades"w?b#%""B c%""%""B%""AF%""AF%""AF%""B<5GradesB <5Grades#)$?b Z# Student30#s)##t~ #u #vU #vU #vU #vU #vU # vU # vU # vU # vU # vU #vU #vU #vU #vU #vU#t#w##w8?b# <2Grades#wL?b#k%##B C%##%##B%##AF%##B<3GradesB <3Grades#w`?b#{%##B S%##%##B%##AF%##AF%##B<4GradesB <4Grades#wt?b%##B c%##%##B%##AF%##AF%##AF%##B<5GradesB <5Grades$)?b Z$ Student31$s)$$t~ $u $vU $vU $vU $vU $vU $ vU $ vU $ vU $ vU $ vU $vU $vU $vU $vU $vU$t$w$$w?b$ <2Grades$w?b$k%$$B C%$$%$$B%$$AF%$$B<3GradesB <3Grades$w?b${%$$B S%$$%$$B%$$AF%$$AF%$$B<4GradesB <4Grades$w?b%$$B c%$$%$$B%$$AF%$$AF%$$AF%$$B<5GradesB <5Grades %)2%xgyyyyyyyyyyyyyyyygggg &z&{!&s)%$"N$&"NB 3)%$"N$&"NBB&|&}!&s)%$"N$&"NB 3)%$"N$&"NBB&}!&s)%$"N$&"NB 3)%$"N$&"NBB&}!&s)%$"N$&"NB 3)%$"N$&"NBB&}!&s)%$"N$&"NB 3)%$"N$&"NBB&}!&s)%$"N$&"NB 3)%$"N$&"NBB&}!& s)%$"N$&"NB 3)%$"N$&"NBB& }!& s)%$ "N$& "NB 3)%$ "N$& "NBB& }!& s)%$ "N$& "NB 3)%$ "N$& "NBB& }!& s)%$ "N$& "NB 3)%$ "N$& "NBB& }!& s)%$ "N$& "NB 3)%$ "N$& "NBB& }!&s)%$ "N$& "NB 3)%$ "N$& "NBB&}!&s)%$"N$&"NB 3)%$"N$&"NBB&}!&s)%$"N$&"NB 3)%$"N$&"NBB&}!&s)%$"N$&"NB 3)%$"N$&"NBB&}!&s)%$"N$&"NB 3)%$"N$&"NBB&}!&s)%$"N$&"NB 3)%$"N$&"NBB&~&{!&s)%$"N$&"NB 3)%$"N$&"NBB&{!&s)%$"N$&"NB 3)%$"N$&"NBB&{!&s)%$"N$&"NB 3)%$"N$&"NBB&{!&s)%$"N$&"NB 3)%$"N$&"NBB&{!cs)%$"N$&"NB 3)%$"N$&"NBB '6'4(ggggggggggggggggggggggg )>V2)gggggggggggggggggggggg *W2*gggggggggggggggggggggg +>X ,>Y -Z /[ 0\ 1] 2^ 4_* h}}}}}D@ H8DD _ g g  g d B   N$   B!! "" ade## # $$ $ &  (    Bx XPP?H]4@xly 1Ut%B <John Kongsvold: In Excel, blank cells and/or cells with text data are NOT normally included in the computation of averages. You must insert zeros in the cells for each missing score if you want the computation of the averages to be accurate. If you don't want your students to be penalized for the missing grades, specify the dropping of one, two, three, or four lowest grades for all of your students or leave the percent sign in place of a nemeric score.< [!p John KongsvoldE>@<dA   7 SorryJYou can only enter a value of zero, one, two, three, or four in this cell.IYou must only enter a zero, one, two, three, or four digit in this cell. or 012343  wsAvg1ggD  50   dMbP?_*+%?&C&F2/&L&D&CPage &P of &N&R 2005-2007 John Kongsvold&?'?M6HP DeskJet 855CseXC odXXLetterDINU"4$u $$$$"dXX??cU} d}  d} md} d} d} d} md}  d} d5?`@J@w@h?@ ?@?@?@ ?@ ?@ ?@ ?@ ?@?@?@?@?@?@?@?@?@?@?@?@?@?@?@?@?@?@?@ e f> f? f@ fA fB fC  fD  fE  fF  fG  fH fI fJ fK fL fMg hN ii O2gjjjggggggggggggggggg'?b Z BsAv CSA106-03(b CEFa07gkkkkkkk  kP~  l  mQ mmmmmmg n n n n n R *oo nS nS nS nS nS T qr?)',BNr@)r@)r@)r@)r@)  r@)  r @)  r"@)  r$@)  r&@)r(@)r*@)r,@)r.@)r0@)q$pp?p@p@p@)(b Z Student1+s!$D BNt~ u vU vU vU vU vU  vU  vU  vU  vU  vU vU vU vU vU vUtNw8%B %B<1GradeBqw(b[%B 3%0x%B%B<2GradesB <2Gradesw(bk%B C%%B%AF%B<3GradesB <3Gradesw(b{%B S%%B%AF%AF%B<4GradesB <4Gradesw)b&%B c%%B%AF%AF%AF%B<5GradesB <5Grades))b Z Student2s),D BNt~ u vU vU vU vU vU  vU  vU  vU  vU  vU vU vU vU vU vUtwB8-B -B<1GradeBw0)be$[-B 3-0x-B-B<2GradesB <2GradeswD)bk%B C%%B%AF%B<3GradesB <3GradeswX)b{%B S%%B%AF%AF%B<4GradesB <4Gradeswl)b%B c%%B%AF%AF%AF%B<5GradesB <5Grades))b Z Student3s)t~ u vU vU vU vU vU  vU  vU  vU  vU  vU vU vU vU vU vUtww)b <2Gradesw)bk%B C%%B%AF%B<3GradesB <3Gradesw)b{%B S%%B%AF%AF%B<4GradesB <4Gradesw)b %B c%%B%AF%AF%AF%B<5GradesB <5Grades ))b Z  Student4 s)  t~ u vU vU vU vU vU vU vU vU vU vU vU vU vU vU vU t w  w)b  <2Grades w *b k% B C% % B% AF% B<3GradesB <3Grades w *b {% B S% % B% AF% AF% B<4GradesB <4Grades w4*b % B c% % B% AF% AF% AF% B<5GradesB <5Grades )H*b Z  Student5 s)  t~ u vU vU vU vU vU vU vU vU vU vU vU vU vU vU vU t w  w\*b  <2Grades wp*b k% B C% % B% AF% B<3GradesB <3Grades w*b {% B S% % B% AF% AF% B<4GradesB <4Grades w*b % B c% % B% AF% AF% AF% B<5GradesB <5Grades )*b Z  Student6 s)  t~ u vU vU vU vU vU vU vU vU vU vU vU vU vU vU vU t w  w*b  <2Grades w*b k% B C% % B% AF% B<3GradesB <3Grades w*b {% B S% % B% AF% AF% B<4GradesB <4Grades w*b % B c% % B% AF% AF% AF% B<5GradesB <5Grades )+b Z  Student7 s)  t~ u vU vU vU vU vU vU vU vU vU vU vU vU vU vU vU t w  w$+b  <2Grades w8+b k% B C% % B% AF% B<3GradesB <3Grades wL+b {% B S% % B% AF% AF% B<4GradesB <4Grades w`+b % B c% % B% AF% AF% AF% B<5GradesB <5Grades )t+b Z  Student8 s) t~ u vU vU vU vU vU vU vU vU vU vU vU vU vU vU vU t w  w+b  <2Grades w+b k% B C% % B% AF% B<3GradesB <3Grades w+b {% B S% % B% AF% AF% B<4GradesB <4Grades w+b% B c% % B% AF% AF% AF% B<5GradesB <5Grades)+b Z Student9s)t~ u vU vU vU vU vU  vU  vU  vU  vU  vU vU vU vU vU vUtww+b <2Gradesw,bk%B C%%B%AF%B<3GradesB <3Gradesw,b{%B S%%B%AF%AF%B<4GradesB <4Gradesw(,b%B c%%B%AF%AF%AF%B<5GradesB <5Grades)<,b Z Student10s)t~ u vU vU vU vU vU  vU  vU  vU  vU  vU vU vU vU vU vUtwwP,b <2Gradeswd,bk%B C%%B%AF%B<3GradesB <3Gradeswx,b{%B S%%B%AF%AF%B<4GradesB <4Gradesw,b%B c%%B%AF%AF%AF%B<5GradesB <5Grades),b Z Student11s)t~ u vU vU vU vU vU  vU  vU  vU  vU  vU vU vU vU vU vUtww,b <2Gradesw,bk%B C%%B%AF%B<3GradesB <3Gradesw,b{%B S%%B%AF%AF%B<4GradesB <4Gradesw,b%B c%%B%AF%AF%AF%B<5GradesB <5Grades)-b Z Student12s)t~ u vU vU vU vU vU  vU  vU  vU  vU  vU vU vU vU vU vUtww-b <2Gradesw,-bk%B C%%B%AF%B<3GradesB <3Gradesw@-b{%B S%%B%AF%AF%B<4GradesB <4GradeswT-b%B c%%B%AF%AF%AF%B<5GradesB <5Grades)h-b Z Student13s)t~ u vU vU vU vU vU  vU  vU  vU  vU  vU vU vU vU vU vUtww|-b <2Gradesw-bk%B C%%B%AF%B<3GradesB <3Gradesw-b{%B S%%B%AF%AF%B<4GradesB <4Gradesw-b%B c%%B%AF%AF%AF%B<5GradesB <5Grades)-b Z Student14s)t~ u vU vU vU vU vU  vU  vU  vU  vU  vU vU vU vU vU vUtww-b <2Gradesw bk%B C%%B%AF%B<3GradesB <3Gradesw, b{%B S%%B%AF%AF%B<4GradesB <4Gradesw@ b%B c%%B%AF%AF%AF%B<5GradesB <5Grades)T b Z Student15s)t~ u vU vU vU vU vU  vU  vU  vU  vU  vU vU vU vU vU vUtwwh b <2Gradesw| bk%B C%%B%AF%B<3GradesB <3Gradesw b{%B S%%B%AF%AF%B<4GradesB <4Gradesw b%B c%%B%AF%AF%AF%B<5GradesB <5G      !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcefghijklmnopqrstuvwxyz{|}~rades)@b Z Student16+s!$D BNt~ u vU vU vU vU vU  vU  vU  vU  vU  vU vU vU vU vU vUtNw8%B %B<1GradeBw@b <2Gradesw(@bk%B C%%B%AF%B<3GradesB <3Gradesw<@b{%B S%%B%AF%AF%B<4GradesB <4GradeswP@b%B c%%B%AF%AF%AF%B<5GradesB <5Grades)d@b Z Student17+s!$D BNt~ u vU vU vU vU vU  vU  vU  vU  vU  vU vU vU vU vU vUtNw8%B %B<1GradeBwx@b <2Gradesw@bk%B C%%B%AF%B<3GradesB <3Gradesw@b{%B S%%B%AF%AF%B<4GradesB <4Gradesw@b %B c%%B%AF%AF%AF%B<5GradesB <5Grades)@b Z Student18+s!$D BNt~ u vU vU vU vU vU  vU  vU  vU  vU  vU vU vU vU vU vUtNw8%B %B<1GradeBw@b <2Gradesw@bk%B C%%B%AF%B<3GradesB <3GradeswAb{%B S%%B%AF%AF%B<4GradesB <4GradeswAb%B c%%B%AF%AF%AF%B<5GradesB <5Grades),Ab Z Student19s)$,D BNt~ u vU vU vU vU vU  vU  vU  vU  vU  vU vU vU vU vU vUtwB$8-B -B<1GradeBw@Ab <2GradeswTAbk%B C%%B%AF%B<3GradesB <3GradeswhAb{%B S%%B%AF%AF%B<4GradesB <4Gradesw|Ab%B c%%B%AF%AF%AF%B<5GradesB <5Grades)Ab Z Student20s)t~ u vU vU vU vU vU  vU  vU  vU  vU  vU vU vU vU vU vUtwwAb <2GradeswAbk%B C%%B%AF%B<3GradesB <3GradeswAb{%B S%%B%AF%AF%B<4GradesB <4GradeswAb%B c%%B%AF%AF%AF%B<5GradesB <5Grades)Ab Z Student21s)t~ u vU vU vU vU vU  vU  vU  vU  vU  vU vU vU vU vU vUtwwBb <2GradeswBbk%B C%%B%AF%B<3GradesB <3Gradesw0Bb{%B S%%B%AF%AF%B<4GradesB <4GradeswDBb%B c%%B%AF%AF%AF%B<5GradesB <5Grades)XBb Z Student22s)t~ u vU vU vU vU vU  vU  vU  vU  vU  vU vU vU vU vU vUtwwlBb <2GradeswBbk%B C%%B%AF%B<3GradesB <3GradeswBb{%B S%%B%AF%AF%B<4GradesB <4GradeswBb%B c%%B%AF%AF%AF%B<5GradesB <5Grades)Bb Z Student23s)t~ u vU vU vU vU vU  vU  vU  vU  vU  vU vU vU vU vU vUtwwBb <2GradeswBbk%B C%%B%AF%B<3GradesB <3GradeswBb{%B S%%B%AF%AF%B<4GradesB <4Gradesw Cb$%B c%%B%AF%AF%AF%B<5GradesB <5Grades) Cb Z Student24s)$#,D BNt~ u vU vU vU vU vU  vU  vU  vU  vU  vU vU vU vU vU vUtwB#8-B -B<1GradeBw4Cb <2GradeswHCbk%B C%%B%AF%B<3GradesB <3Gradesw\Cb{%B S%%B%AF%AF%B<4GradesB <4GradeswpCb%B c%%B%AF%AF%AF%B<5GradesB <5Grades)Cb Z Student25s)t~ u vU vU vU vU vU  vU  vU  vU  vU  vU vU vU vU vU vUtwwCb <2GradeswCbk%B C%%B%AF%B<3GradesB <3GradeswCb{%B S%%B%AF%AF%B<4GradesB <4GradeswCb%B c%%B%AF%AF%AF%B<5GradesB <5Grades)Cb Z Student26s)t~ u vU vU vU vU vU  vU  vU  vU  vU  vU vU vU vU vU vUtwwCb <2GradeswDbk%B C%%B%AF%B<3GradesB <3Gradesw$Db{%B S%%B%AF%AF%B<4GradesB <4Gradesw8Db %B c%%B%AF%AF%AF%B<5GradesB <5GradesDelDsN|||||||}}}}}}}}}}} ?@!?@"?@#?@$?@%-@ &?@'?@(?@)?@*?@+?@,?@-?@/?@0?@1?@2?@4?@ )LDb !Z  Student27 s)  t~ u vU vU vU vU vU vU vU vU vU vU vU vU vU vU vU t w  w`Db  <2Grades wtDb k% B C% % B% AF% B<3GradesB <3Grades wDb {% B S% % B% AF% AF% B<4GradesB <4Grades wDb!% B c% % B% AF% AF% AF% B<5GradesB <5Grades!)Db "Z! Student28!s)!!t~ !u !vU !vU !vU !vU !vU ! vU ! vU ! vU ! vU ! vU !vU !vU !vU !vU !vU!t!w!!wDb! <2Grades!wDb!k%!!B C%!!%!!B%!!AF%!!B<3GradesB <3Grades!wDb!{%!!B S%!!%!!B%!!AF%!!AF%!!B<4GradesB <4Grades!wEb"%!!B c%!!%!!B%!!AF%!!AF%!!AF%!!B<5GradesB <5Grades")Eb #Z" Student29"s)""t~ "u "vU "vU "vU "vU "vU " vU " vU " vU " vU " vU "vU "vU "vU "vU "vU"t"w""w(Eb" <2Grades"wV2)gggggggggggggggggggggg *W2*gggggggggggggggggggggg +>X ,>Y -Z /[ 0\ 1] 2^ 4_* h}}}}}D@ H8DD _ g g  g d B   N$  B  !! ade"" ## # $$ $ & U"0 (     B > XPP?H]4@ >`z 󗞫XVK jz <John Kongsvold: In Excel, blank cells and/or cells with text data are NOT normally included in the computation of averages. You must insert zeros in the cells for each missing score if you want the computation of the averages to be accurate. If you don't want your students to be penalized for the missing grades, specify the dropping of one, two, three, or four lowest grades for all of your students or leave the percent sign in place of a nemeric score.< [!p John KongsvoldE>@<dA 7 SorryJYou can only enter a value of zero, one, two, three, or four in this cell.IYou must only enter a zero, one, two, three, or four digit in this cell. or 012343  wsAvg2ggD  5ny  dMbP?_*+%?&C&F2/&L&D&CPage &P of &N&R 2005-2007 John Kongsvold&?'?M6HP DeskJet 855CseXC odXXLetterDINU"4$u $$$$"dXX??cU} d}  d} md} d} d} d} md}  d} d5?`@J@w@h?@ ?@?@?@ ?@ ?@ ?@ ?@ ?@?@?@?@?@?@?@?@?@?@?@?@?@?@?@?@?@?@?@ e f> f? f@ fA fB fC  fD  fE  fF  fG  fH fI fJ fK fL fMg hN ii O2gjjjggggggggggggggggg'@Fb Z BsAv CSA106-03TFb CEFa07gkkkkkkk  kP~  l  mQ mmmmmmg n n n n n R *oo nS nS nS nS nS T qr?)',BNr@)r@)r@)r@)r@)  r@)  r @)  r"@)  r$@)  r&@)r(@)r*@)r,@)r.@)r0@)q$pp?p@p@p@)`Fb Z Student1+s!$D BNt~ u vU vU vU vU vU  vU  vU  vU  vU  vU vU vU vU vU vUtNw8%B %B<1GradeBqwtFb[%B 3%0x%B%B<2GradesB <2GradeswFbk%B C%%B%AF%B<3GradesB <3GradeswFb{%B S%%B%AF%AF%B<4GradesB <4GradeswFb&%B c%%B%AF%AF%AF%B<5GradesB <5Grades)Fb Z Student2s),D BNt~ u vU vU vU vU vU  vU  vU  vU  vU  vU vU vU vU vU vUtwB8-B -B<1GradeBwFbe$[-B 3-0x-B-B<2GradesB <2GradeswFbk%B C%%B%AF%B<3GradesB <3GradeswGb{%B S%%B%AF%AF%B<4GradesB <4GradeswGb%B c%%B%AF%AF%AF%B<5GradesB <5Grades)(Gb Z Student3s)t~ u vU vU vU vU vU  vU  vU  vU  vU  vU vU vU vU vU vUtwwV2)gggggggggggggggggggggg *W2*gggggggggggggggggggggg +>X ,>Y -Z /[ 0\ 1] 2^ 4_* h}}}}}D@ H8DD _ g g  g d B   N$  B  !! ade"" ## # $$ $ & U"@(    Bܕ XPP?H]4@ܕ} x ,JjJdG8 <John Kongsvold: In Excel, blank cells and/or cells with text data are NOT normally included in the computation of averages. You must insert zeros in the cells for each missing score if you want the computation of the averages to be accurate. If you don't want your students to be penalized for the missing grades, specify the dropping of one, two, three, or four lowest grades for all of your students or leave the percent sign in place of a nemeric score.< [!p John KongsvoldE>@<dA 7 SorryJYou can only enter a value of zero, one, two, three, or four in this cell.IYou must only enter a zero, one, two, three, or four digit in this cell. or 012343  wsAvg3ggD  5 c ,  dMbP?_*+%?&C&F2/&L&D&CPage &P of &N&R 2005-2007 John Kongsvold&?'?M6HP DeskJet 855CseXC odXXLetterDINU"4$u $$$$"dXX??cU} d}  d} md} d} d} d} md}  d} d5?`@J@w@h?@ ?@?@?@ ?@ ?@ ?@ ?@ ?@?@?@?@?@?@?@?@?@?@?@?@?@?@?@?@?@?@?@ e f> f? f@ fA fB fC  fD  fE  fF  fG  fH fI fJ fK fL fMg hN ii O2gjjjggggggggggggggggg'|Rb Z BsAv CSA106-03Rb CEFa07gkkkkkkk  kP~  l  mQ mmmmmmg n n n n n R *oo nS nS nS nS nS T qr?)',BNr@)r@)r@)r@)r@)  r@)  r @)  r"@)  r$@)  r&@)r(@)r*@)r,@)r.@)r0@)q$pp?p@p@p@)Rb Z Student1+s!$D BNt~ u vU vU vU vU vU  vU  vU  vU  vU  vU vU vU vU vU vUtNw8%B %B<1GradeBqwRb[%B 3%0x%B%B<2GradesB <2GradeswRbk%B C%%B%AF%B<3GradesB <3GradeswRb{%B S%%B%AF%AF%B<4GradesB <4GradeswRb&%B c%%B%AF%AF%AF%B<5GradesB <5Grades)Sb Z Student2s),D BNt~ u vU vU vU vU vU  vU  vU  vU  vU  vU vU vU vU vU vUtwB8-B -B<1GradeBwSbe$[-B 3-0x-B-B<2GradesB <2Gradesw(Sbk%B C%%B%AF%B<3GradesB <3GradeswV2)gggggggggggggggggggggg *W2*gggggggggggggggggggggg +>X ,>Y -Z /[ 0\ 1] 2^ 4_* h}}}}}D@ H8DD _ g g  g d B   N$  B  !! ade"" ## # $$ $ & U"P(    Bd XPP?H]4@d )eN[BW <John Kongsvold: In Excel, blank cells and/or cells with text data are NOT normally included in the computation of averages. You must insert zeros in the cells for each missing score if you want the computation of the averages to be accurate. If you don't want your students to be penalized for the missing grades, specify the dropping of one, two, three, or four lowest grades for all of your students or leave the percent sign in place of a nemeric score.< [!p John KongsvoldE>@<dA 7 SorryJYou can only enter a value of zero, one, two, three, or four in this cell.IYou must only enter a zero, one, two, three, or four digit in this cell. or 012343  wsAvg4ggD  56F  dMbP?_*+%?&C&F2/&L&D&CPage &P of &N&R 2005-2007 John Kongsvold&?'?M6HP DeskJet 855CseXC odXXLetterDINU"4$u $$$$"dXX??cU} d}  d} md} d} d} d} md}  d} d5?`@J@w@h?@ ?@?@?@ ?@ ?@ ?@ ?@ ?@?@?@?@?@?@?@?@?@?@?@?@?@?@?@?@?@?@?@ e f> f? f@ fA fB fC  fD  fE  fF  fG  fH fI fJ fK fL fMg hN ii O2gjjjggggggggggggggggg'^b Z BsAv CSA106-03^b CEFa07gkkkkkkk  kP~  l  mQ mmmmmmg n n n n n R *oo nS nS nS nS nS T qr?)',BNr@)r@)r@)r@)r@)  r@)  r @)  r"@)  r$@)  r&@)r(@)r*@)r,@)r.@)r0@)q$pp?p@p@p@)^b Z Student1+s!$D BNt~ u vU vU vU vU vU  vU  vU  vU  vU  vU vU vU vU vU vUtNw8%B %B<1GradeBqw^b[%B 3%0x%B%B<2GradesB <2Gradesw_bk%B C%%B%AF%B<3GradesB <3Gradesw_b{%B S%%B%AF%AF%B<4GradesB <4Gradesw(_b&%B c%%B%AF%AF%AF%B<5GradesB <5Grades)<_b Z Student2s),D BNt~ u vU vU vU vU vU  vU  vU  vU  vU  vU vU vU vU vU vUtwB8-B -B<1GradeBwP_be$[-B 3-0x-B-B<2GradesB <2Gradeswd_bk%B C%%B%AF%B<3GradesB <3Gradeswx_b{%B S%%B%AF%AF%B<4GradesB <4Gradesw_b%B c%%B%AF%AF%AF%B<5GradesB <5Grades)_b Z Student3s)t~ u vU vU vU vU vU  vU  vU  vU  vU  vU vU vU vU vU vUtww_b <2Gradesw_bk%B C%%B%AF%B<3GradesB <3Gradesw_b{%B S%%B%AF%AF%B<4GradesB <4Gradesw_b %B c%%B%AF%AF%AF%B<5GradesB <5Grades )`b Z  Student4 s)  t~ u vU vU vU vU vU vU vU vU vU vU vU vU vU vU vU t w  w`b  <2Grades w,`b k% B C% % B% AF% B<3GradesB <3Grades w@`b {% B S% % B% AF% AF% B<4GradesB <4Grades wT`b % B c% % B% AF% AF% AF% B<5GradesB <5Grades )h`b Z  Student5 s)  t~ u vU vU vU vU vU vU vU vU vU vU vU vU vU vU vU t w  w|`b  <2Grades w`b k% B C% % B% AF% B<3GradesB <3Grades w`b {% B S% % B% AF% AF% B<4GradesB <4Grades w`b % B c% % B% AF% AF% AF% B<5GradesB <5Grades )`b Z  Student6 s)  t~ u vU vU vU vU vU vU vU vU vU vU vU vU vU vU vU t w  w`b  <2Grades w`b k% B C% % B% AF% B<3GradesB <3Grades wab {% B S% % B% AF% AF% B<4GradesB <4Grades wab % B c% % B% AF% AF% AF% B<5GradesB <5Grades )0ab Z  Student7 s)  t~ u vU vU vU vU vU vU vU vU vU vU vU vU vU vU vU t w  wDab  <2Grades wXab k% B C% % B% AF% B<3GradesB <3Grades wlab {% B S% % B% AF% AF% B<4GradesB <4Grades wab % B c% % B% AF% AF% AF% B<5GradesB <5Grades )ab Z  Student8 s) t~ u vU vU vU vU vU vU vU vU vU vU vU vU vU vU vU t w  wab  <2Grades wab k% B C% % B% AF% B<3GradesB <3Grades wab {% B S% % B% AF% AF% B<4GradesB <4Grades wab% B c% % B% AF% AF% AF% B<5GradesB <5Grades)ab Z Student9s)t~ u vU vU vU vU vU  vU  vU  vU  vU  vU vU vU vU vU vUtww bb <2Gradesw bbk%B C%%B%AF%B<3GradesB <3Gradesw4bb{%B S%%B%AF%AF%B<4GradesB <4GradeswHbb%B c%%B%AF%AF%AF%B<5GradesB <5Grades)\bb Z Student10s)t~ u vU vU vU vU vU  vU  vU  vU  vU  vU vU vU vU vU vUtwwpbb <2Gradeswbbk%B C%%B%AF%B<3GradesB <3Gradeswbb{%B S%%B%AF%AF%B<4GradesB <4Gradeswbb%B c%%B%AF%AF%AF%B<5GradesB <5Grades)bb Z Student11s)t~ u vU vU vU vU vU  vU  vU  vU  vU  vU vU vU vU vU vUtwwbb <2Gradeswbbk%B C%%B%AF%B<3GradesB <3Gradeswbb{%B S%%B%AF%AF%B<4GradesB <4Gradeswcb%B c%%B%AF%AF%AF%B<5GradesB <5Grades)$cb Z Student12s)t~ u vU vU vU vU vU  vU  vU  vU  vU  vU vU vU vU vU vUtww8cb <2GradeswLcbk%B C%%B%AF%B<3GradesB <3Gradesw`cb{%B S%%B%AF%AF%B<4GradesB <4Gradeswtcb%B c%%B%AF%AF%AF%B<5GradesB <5Grades)cb Z Student13s)t~ u vU vU vU vU vU  vU  vU  vU  vU  vU vU vU vU vU vUtwwcb <2Gradeswcbk%B C%%B%AF%B<3GradesB <3Gradeswcb{%B S%%B%AF%AF%B<4GradesB <4Gradeswcb%B c%%B%AF%AF%AF%B<5GradesB <5Grades)cb Z Student14s)t~ u vU vU vU vU vU  vU  vU  vU  vU  vU vU vU vU vU vUtwwdb <2Gradeswdbk%B C%%B%AF%B<3GradesB <3Gradesw(db{%B S%%B%AF%AF%B<4GradesB <4GradeswV2)gggggggggggggggggggggg *W2*gggggggggggggggggggggg +>X ,>Y -Z /[ 0\ 1] 2^ 4_* h}}}}}D@ H8DD _ g g  g d B   N$  B  !! ade"" ## # $ $ & U"`(    B8 XPP?H]4@8P >=Ojch <John Kongsvold: In Excel, blank cells and/or cells with text data are NOT normally included in the computation of averages. You must insert zeros in the cells for each missing score if you want the computation of the averages to be accurate. If you don't want your students to be penalized for the missing grades, specify the dropping of one, two, three, or four lowest grades for all of your students or leave the percent sign in place of a nemeric score.< [!p John KongsvoldE>@<dA 7 SorryJYou can only enter a value of zero, one, two, three, or four in this cell.IYou must only enter a zero, one, two, three, or four digit in this cell. or 012343  wsAvg5ggD  ,L_go;   dMbP?_*+%, &C&14&A &F30&L&D&CPage &P of &N&R 2005-2007 John Kongsvold&?'?(?)?M6HP DeskJet 855CseXC od,,Letter      !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`iudefghjoklmnptqrsvywxz{|}~DINU"4$u $$$$"d,,??cU} } M & W 1:00-2:45?44, 4, 4, 4, 4w4w 4w@4w@4w@ 4w@ 4w@  4w@ 4w@ 4w@4w@4w@ 4w@4w@4w@4w@4w@ 4w@4w@4w@4w@4w@ 4w@4w@4w@4w@4w@ 4w@2jb CRN C  ~ CECRN 3124 ~ Fa07.kb Z ~ ZC@CSA106-03 ~ Change Course Info in cell A80 ~ Kongsvold, Johnj3kb ZMW 11:00-12:45 pm 3@`3@3@4@$ D@4@! L4@4@ 5@  `5@  5@  6@  @6@  6@6@ 7@7@7@8@`8@8@8@@9@9@9@ :@`:@:@;@@;@;@;@  <@!!`<@*"3kb 0 Z Student1l3kb Z Student2l3kb Z Student3l3 kb Z  Student4l 3 lb Z  Student5l 3 $lb Z  Student6l 3 8lb Z  Student7l 3 Llb Z  Student8l 3`lb Z Student9l3tlb Z Student10l3lb Z Student11l3lb Z Student12l3lb Z Student13l3lb Z Student14l3lb Z Student15l3lb Z Student16l3mb Z Student17l3mb Z Student18l3(mb Z Student19l34w@?4w@ mb !Z  Student27l 3!mb "Z! Student28l!3"mb #Z" Student29l"3#nb Z# Student30l#3$nb Z$ Student31l$3 %l%3 &l&3 'l'3 (l(3 )l)3 *l*3 +l+3 ,l,3 -l-3 .l.3 /l/3 0l03 1l13 2l23 3l33 4l43 5l53 6l63 7l73 8l83 9l93 :l:3 ;l;3n<3 =l=3n>3n?3Dl~~~~~~~~~~~~~~~~~~~~~~~r~r@4w@A4w@B4w@C4w@D4w@E4w@F4w@G4w@H4w@I4w@J4w@K4w@L4w@M4w@N4w@O4w@P4w@Q4w@R4w@S4w@T4w@U4w@V4w@W4w@X4w@Y4w@Z4w@[4w@\4w@]4w@^4w@_4w@n@3nA3nB3nC3nD3nE3nF3nG3nH3nI3nJ3nK3nL3nM3nN3nO3nP3nQ3nR3nS3nT3nU3nV3nW3nX3nY3nZ3n[3n\3n]3n^3n_3Dlrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrr`4w@a4w@b4w@c4w@d4w@e4w@f4w@g4w@h4w@i4w@j4w@k4w@l4w@m4w@n4w@o4w@p4w@q4w@r4w@s4w@t4w@u4w@v4w@w4w@x4w@y4w@z4w@{4w@|4w@}4w@~4w@4w@n`3na3nb3nc3nd3ne3nf3ng3nh3ni3nj3nk3nl3nm3nn3no3np3nq3nr3ns3nt3nu3nv3nw3nx3ny3nz3n{3n|3n}3n~3n3Dlrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrr4w@4w@4w@4w@4w@4w@4w@4w@4w@4w@4w@4w@4w@4w@4w@4w@w@w@w@w@w@w@w@w@w@w@w@w@w@w@w@w@n3n3n3Dlrrr w@w@w@w@w@w@w@w@w@w@w@w@w@w@w@w@w@w@w@w@w@w@w@w@w@w@w@w@w@w@w@w@Dl ,,< 0   # lpT(    B: XPP? )]4@: p~1zDT%t{  <John Kongsvold: If you have any problems or suggestions please send email to: jkongsvold@hcc.commnet.edu or call HCC x5128. Course Info can be modified on the GradeBook sheet tab, cell A80.< [!  N: XPP??<f@]4@:\ F+I 4j2 }<~John Kongsvold: If you have any problems or suggestions please send email to: jkongsvold@hcc.commnet.edu or call HCC x5128. < [!>}John Kongsvolda=John KongsvoldaP>@<dA 7 wsAttendggD  L)b  dMbP?_*+%&R&D2/&L&F&CPage &P of &N&R 2005=2007John Kongsvold&?'?(?)?M6HP DeskJet 855CseXC od,,LetterDINU"4$u $$$$"d ,,??cU} I } I  }  }  }  } $ } I }  }  } m }  } m  Scoring Weight L @ @hw J w@w@w@ w@ w@ w@ w@ w@w@w@w@w@w@w@w@w@w@w@w@w@w@w@w@w@w@w@*,nb  Mid-Term Z*'Mid-Term Fa07 GradeBook for CRN - 3124 |nb Z/,CSA106-03 ~ Change Course Info in cell A80! nb ZKongsvold, Johnnb ZQuizob Z Pre-Writingob ZExam(ob ZHmWk4ob Z ProjectDob ZFinal   !   !Pob ZMW 11:00-12:45 pmtob ZAvg1ob ZAvg2ob ZAvg3ob ZAvg4ob ZAvg5ob ZExam" # $  !   ! &*???? '#(? %  $  !   !)ob Z Student1!Z!Z!Z!Z!Zob Z  Note,ob) -B-B {L@LL1@L@LL1@L@LL1@L@LL1@L@LL1@L@LL1@L B -ob(& e [LA   ,ALA  LDF%9DBf "BW  > ob  (Z A   :  BW  . . Z)ob Z Student2!Z!Z!Z!Z!Z Z,)  -:b) F  > :b  (Z A   :  B  . . Z)pb Z Student3!Z!Z!Z!Z!Z Z,)  -pb)  F  > pb  (Z A   :  B  . . Z )pb Z  Student4 ! Z  ! Z  ! Z  ! Z  ! Z   Z  ,)  -0pb)  F > 4pb (Z A   :  B . .  Z  )8pb Z  Student5 ! Z  ! Z  ! Z  ! Z  ! Z   Z  ,)  -Lpb)  F > Ppb (Z A   :  B . .  Z  )Tpb Z  Student6 ! Z  ! Z  ! Z  ! Z  ! Z   Z  ,)  -hpb)  F > lpb (Z A   :  B . .  Z  )ppb Z  Student7 ! Z  ! Z  ! Z  ! Z  ! Z   Z  ,)  -pb)  F > pb (Z A   :  B . .  Z  )pb Z  Student8 ! Z  ! Z  ! Z  ! Z  ! Z   Z  ,)  -pb) F > pb (Z A   :  B . .  Z )pb Z Student9!Z!Z!Z!Z!Z Z,)  -pb) F  > pb >(Z A   :  B  . . Z)pb Z Student10!Z!Z!Z!Z!Z Z,)  -pb) F  > pb  (Z A   :  B  . . Z)pb Z Student11!Z!Z!Z!Z!Z Z,)  -pb) F  > pb  (Z A   :  B  . . Z)pb Z Student12!Z!Z!Z!Z!Z Z,)  -qb) F  > qb  (Z A   :  B  . . Z)qb Z Student13!Z!Z!Z!Z!Z Z,)  -,qb) F  > 0qb  (Z A   :  B  . . Z)4qb Z Student14!Z!Z!Z!Z!Z Z,)  -Hqb) F  > Lqb  (Z A   :  B  . . Z)Pqb Z Student15!Z!Z!Z!Z!Z Z,)  -dqb) F  > hqb  (Z A   :  B  . . Z)lqb Z Student16!Z!Z!Z!Z!Z Z,)  -qb) F  > qb  (Z A   :  B  . . Z)qb Z Student17!Z!Z!Z!Z!Z Z,)  -qb) F  > qb  (Z A   :  B  . . Z)qb Z Student18!Z!Z!Z!Z!Z Z,)  -qb) F  > qb  (Z A   :  B  . . Z)qb Z Student19!Z!Z!Z!Z!Z Z,)  -qb) F  > qb  (Z A   :  B  . . Z)qb Z Student20!Z!Z!Z!Z!Z Z,)  -qb) F  > qb  (Z A   :  B  . . Z)qb Z Student21!Z!Z!Z!Z!Z Z,)  - rb) F  > rb  (Z A   :  B  . . Z)rb Z Student22!Z!Z!Z!Z!Z Z,)  -(rb) F  > ,rb  (Z A   :  B  . . Z)0rb Z Student23!Z!Z!Z!Z!Z Z,)  -Drb) F  > Hrb  (Z A   :  B  . . Z)Lrb Z Student24!Z!Z!Z!Z!Z Z,)  -`rb)$ F  > drb  (Z A   :  B  . . Z)hrb Z Student25!Z!Z!Z!Z!Z Z,) #-B-B {L@LL1@L@LL1@L@LL1@L@LL1@L@LL1@L@LL1@L B -|rb) e# [LA   ,ALA  LDF%9DBf "BF  > rb :(Z A   :  B  . . Z)rb Z Student26!Z!Z!Z!Z!Z Z,)  -rb)  F  > rb  (Z A   :  B  . . ZD8l |v w@!w@"w@#w@$w@%-@ &Y@'Y@(Y@)Y@*Y@+Y@,Y@-Y@.,/,0 ,1 ;2 3 4 J 5 ; 6 ; 7 ,8 ; 9 : ; , < = > , ? @ )rb !Z  Student27 ! Z  ! Z  ! Z  ! Z  ! Z   Z  ,)  -rb)! F > rb (Z A   :  B . .  Z !)rb "Z! Student28!!!Z!!!!Z!!!!Z!!!!Z!!!!Z!! !Z!!,)! ! -rb)" F ! >! rb ! (Z! A   :!  B ! . !.! !Z!")rb #Z" Student29"!"Z""!"Z""!"Z""!"Z""!"Z"" "Z"",)" " -rb)# F " >" rb " (Z" A   :"  B " . "." "Z"#)rb Z# Student30#!#Z##!#Z##!#Z##!#Z##!#Z## #Z##,)# # -sb) F # >#  sb # (Z# A   :#  B # . #.# #Z#$)sb $Z$ Student31$!$Z$$!$Z$$!$Z$$!$Z$$!$Z$$ $Z$$,!$ %$$B%$$B {D@D$D1@D@D$D1@D@D$D1@D@D$D1@D@D$D1@D@D$D1@D$ Bq$ -$sb![D$ A   $$ AD$A  D$DF%9DBf "BF $ >$ (sb $ (Z$ A   :$  B $ . $.$ $Z$%) %* %* %+ %+ %+ %+ %1 % 2 % 3 % ++ &5&6!&y)%$@"N$&@"NB 9)%$@"N$&@"NBD1@B&6!&y)%$@"N$&@"NB 9)%$@"N$&@"NBD1@B&6!&y)%$@"N$&@"NB 9)%$@"N$&@"NBD1@B&6!&y)%$@"N$&@"NB 9)%$@"N$&@"NBD1@B&6!&y)%$@"N$&@"NB 9)%$@"N$&@"NBD1@B&6!&y)%$@"N$&@"NB 9)%$@"N$&@"NBD1@B&6&6!.y)%$@"N$&@"NB 9)%$@"N$&@"NBD1@B& 7 & 888'9:;;;;;;;< ' 888 ((;;;;;;=; ( 888 )>`)??????@@ ) 888 *>a*??????@@ * 888 +>+??????@@ + 888 ,>,??????@@ , 888 ->-??????@@ - 888 .A.@!.y)%$@"N$&@"NB 9)%$@"N$&@"NBD1@B.@!.y)%$@"N$&@"NB 9)%$@"N$&@"NBD1@B.@!.y)%$@"N$&@"NB 9)%$@"N$&@"NBD1@B.@!.y)%$@"N$&@"NB 9)%$@"N$&@"NBD1@B.@!.y)%$@"N$&@"NB 9)%$@"N$&@"NBD1@B.@!.y)%$@"N$&@"NB 9)%$@"N$&@"NBD1@B.@.@!/y)%$@"N$&@"NB 9)%$@"N$&@"NBD1@B. B /A/@!/y)%$@"N$&@"NB 9)%$@"N$&@"NBD1@B/@!/y)%$@"N$&@"NB 9)%$@"N$&@"NBD1@B/@!/y)%$@"N$&@"NB 9)%$@"N$&@"NBD1@B/@!/y)%$@"N$&@"NB 9)%$@"N$&@"NBD1@B/@!/y)%$@"N$&@"NB 9)%$@"N$&@"NBD1@B/@!/y)%$@"N$&@"NB 9)%$@"N$&@"NBD1@B/@/@!0y)%$@"N$&@"NB 9)%$@"N$&@"NBD1@B/ B 0A0@!0s)%$@"N$&@"NB 3)%$@"N$&@"NBB0@!0s)%$@"N$&@"NB 3)%$@"N$&@"NBB0@!0s)%$@"N$&@"NB 3)%$@"N$&@"NBB0@!0s)%$@"N$&@"NB 3)%$@"N$&@"NBB0@!0s)%$@"N$&@"NB 3)%$@"N$&@"NBB0@!0s)%$@"N$&@"NB 3)%$@"N$&@"NBB0@0@!7s)%$@"N$&@"NB 3)%$@"N$&@"NBB0 C 1A*1DDDDDD 1EFC 2GGGGGGG 2 H 3 3 I 4JK2 5L! 5M" 5NO 5#5PPJ 6J$ 6Q% 6R& 6S' 6% 6( 6 6PPJ 7J$ 7T)7U)877E #LAZ7V 7* 7 7+ 7PPJ 8J$ 8W,8X)87#8Y!9 %78% 8- 8* 8% 8PPJ 9J$ 9T.9U):79V 9/~ 9 90 9PPJ :J$ :T1:U);7#:V!< %9;%~ :$@:33333M@  <D: :2 :PPJ ;J$ ;W3;X):7;Y~ ;;O@ ?D; ;4 ;PPJ <J$ <T5<U)<7<V~ <<P@= CD< <6 <PPJ =J$ =T7=U)>7#=V!= %<>%~ ==Q@? FD= =8 =PPJ >J$ >W8>X)=7>Y~ >>@R@; ID> >7 >PPJ ?J$ ?T6?U)?7?V~ ??@S@@ MD? ?5 ?PPJ D%l7.888888''L&Lr@ A , B , C D E , F , G H I J K  @J$ @T4@U)A7#@V!@ %?A3~ @@T@A PD@ @3 @PPJ AJ$ AW2AX)@7AY~ AAT@B SDA A1 APPJ BJ$ BZ0B[>@)B7B\>@!BDB~ BBU@C WDB B. BPPJ CJ$ CT9CU)C7CV~ CCV@D ZDC C, CPPJ DJ$ DT:DU)E7#DV?!D %CE%~ DD@W@F ]DD D) DPPJ EJ$ EW;EX?)D7 EY E EPPJ FJ$ F]F^#F_?@! %6E%F` Fa<~ Fb? FPPJ G H Iccccccc I J=Jccccccccc J J=KJ K8i&*  c    B   N$  B B @  @          U"  u                                                                          ch nam Avg hat  to igh g o rop  be hoo me  pop  th n a nin  an nte ou  pro ase il  svo mmn  ca 128           hn    int rad abl r G e                         ota ste ott er j. ~ D- C C N Rou                     esc  cri Gr ipt rad  tio de  on   De  6 esc     cri  Gr  ipt  rad  tio!   ade!! ion!! de !! on !! e D!! n 1"!  De""  14"" Des"" 15"" esc"" 6#"  lum# ot ## Imp## te:## re.## Ave## omp$$  $$ gra$$ ppe$$  Gr$$ opp$$ e$  ude  | (     B  XPP?; LI]4@ d 9DO0G>% <John Kongsvold: This value is added to each students total score for the purpose of determining the letter grade. Adjust this value as you see fit.< e!t(  B$  XPP?8%=y]4@$ Ď %cFQD|J w<xJohn Kongsvold: Use values in this column to adjust the lowest score for each letter grade to fit your grading system.< e!w   B  XPP?C0f 6U]4@ $ =ߧ@z w<xJohn Kongsvold: Use values in this column to adjust the lowest score for each letter grade to fit your grading system.< e!w   B  XPP?C0 6]4@   ؍A^ɝ w<xJohn Kongsvold: Use values in this column to adjust the lowest score for each letter grade to fit your grading system.< e!w   BP  XPP?C1 61]4@P l  &qNnMj{  w<xJohn Kongsvold: Use values in this column to adjust the lowest score for each letter grade to fit your grading system.< e!w   B  XPP?C36 73]4@ T RvN w<xJohn Kongsvold: Use values in this column to adjust the lowest score for each letter grade to fit your grading system.< e!w   B  XPP?C3 9l]4@  nEHMBz6 w<xJohn Kongsvold: Use values in this column to adjust the lowest score for each letter grade to fit your grading system.< e!w   B|  XPP?C4t 9y]4@|  XtB aM w<xJohn Kongsvold: Use values in this column to adjust the lowest score for each letter grade to fit your grading system.< e!w   B  XPP?C5 :]4 @  3sH@'l< w<xJohn Kongsvold: Use values in this column to adjust the lowest score for each letter grade to fit your grading system.< e!w   BD  XPP?C7 =6]4 @D  L'@X w<xJohn Kongsvold: Use values in this column to adjust the lowest score for each letter grade to fit your grading system.< e!w   B  XPP?C8% =]4 @ D ӇZBI~JF w<xJohn Kongsvold: Use values in this column to adjust the lowest score for each letter grade to fit your grading system.< e!w   B  XPP?C9( >Z]4 @ , "MyEkg w<xJohn Kongsvold: Use values in this column to adjust the lowest score for each letter grade to fit your grading system.< e!w   Bp  XPP?,#1]4 @p  ]nAj&| <John Kongsvold: If you have any suggestions or problems please send email to: jkongsvold@hcc.commnet.edu or call HCC x5128. Thank You < [!v  BԤ  XPP?O)]4@Ԥ t PM. G  H<!John Kongsvold: If you need to override the calculated letter grade for a student enter an I, N, W, or F etc. in this column for that student. To redisplay the calculated letter grade, click on the cell in this column and press the Delete key to clear the contents of that cell .<H [!A"!"%!"!   B8  XPP?  p =]4@8 Ԝ G)8Gw@X #<$Point to cell M7 to see note there.<!#  B  XPP? `  =]4@  Uw%BzC8خ $<%Point to cell A6 to view note there.< $  B  XPP?G ]4@  d)$`B 4U <John Kongsvold: Scoring weights should be entered as percentages, 0 to 100 percent, which will be displayed rounded to one decimal place, i.e. 16.67% will display as 16.7% but be computed as the original 16.67%. Remember, the total for all scoring weights should equal 100%.< [!John KongsvoldwJohn Kongsvoldw John Kongsvoldw John Kongsvoldw5 John Kongsvoldw:John Kongsvoldw;John Kongsvoldw<John Kongsvoldw=John Kongsvoldw>John Kongsvoldw?John Kongsvoldw@ John KongsvoldwAJohn KongsvoldwB John KongsvoldwC John KongsvoldwD John KongsvoldwFJohn Kongsvoldw>@A #****  HH GG 557? GG 55 entered as percentages, 0 to 100  $$;$$ GG 55 entered as percentages, 0 to 100  wsMidggD ThisWorkbook wsGB __SRP_2$__SRP_3(B  !"#%&')+,-./0123456789:;<>?@BDEFGHIJKLMNOPQRSTUWXY[]^_`abcdefghijklmnpqrtvwxyz{|}~?hK#xME (SLSS<N0{00020819-0000-0000-C000-000000000046}8(%H xpİAttribute VB_Name = "ThisWorkbook" Bas0{00020P819-0C$0046} |GlobalSpacFalse dCreatablPredeclaIdTru BExposeTemplateDerivBustomizD2Option /licit Drh #<׽b"Gt3 Fq\HO (>xq\HO (>׽b"Gt3ME(SLSS6"N0{00020820-0000-0000-C000-000000000046}(%H0h % %8p@@HH86H<$*\Rffff*28482f04814 xAttribute VB_Name = "wsGB" Basl0{00020820- C$0046} |@GlobalSpacFalse CreatablPredeHclaIdTru BExposeTemplateDeriv$ustomizD2 rU p 1Y4a`rU @nDrhs#<;&-KQ|nF F ,6g@kkYx ,6g@kkY;&-KQ|nFMEwsAvg1 *__SRP_4 =__SRP_5ABwsAvg2C(SLSS6"N0{00020820-0000-0000-C000-000000000046}(%H0h % %8p@@HH86H<$*\Rffff*29482f04814 xAttribute VB_Name = "wsA@vg1" Bast0{00020820- C$0046} |Global!SpacFalse dCreatablPre declaIdTru BExposeTemplateDeriv$Bustom izD2 rU 14a`rU @nDrhn#<mtG F\.M\NQx\.M\NQmtGME(SLSS6"N0{00020820-0000-0000-C000-000000000046}(%H0h % %8p@@HH86H<$*\Rffff*2:482f04814 xAttribute VB_Name = "wsA@vg2" Bast0{00020820- C$0046} |Global!SpacFalse dCreatablPre declaIdTru BExposeTemplateDeriv$Bustom izD2 rU 91a4a__SRP_6 V__SRP_7ZBwsAvg3\__SRP_8 o`rU @nDrh#<@ 9A_6Y F`!zMK4sx`!zMK4s@ 9A_6YME(SLSS6"N0{00020820-0000-0000-C000-000000000046}(%H0h % %8p@@HH86H<$*\Rffff*2;482f04814 xAttribute VB_Name = "wsA@vg3" Bast0{00020820- C$0046} |Global!SpacFalse dCreatablPre declaIdTru BExposeTemplateDeriv$Bustom izD2 rU 14a`rU @nDrh#<[/C[wµ F\F߲nx\__SRP_9sBwsAvg4u__SRP_a__SRP_bBF߲n[/C[wµME(SLSS6"N0{00020820-0000-0000-C000-000000000046}(%H0h %  %8p@@HH86H<$*\Rffff*2<482f04814 xAttribute VB_Name = "wsA@vg4" Bast0{00020820- C$0046} |Global!SpacFalse dCreatablPre declaIdTru BExposeTemplateDeriv$Bustom izD2 rU 01 4a`rU @nDrh#<$EDRϘ FwsAvg5__SRP_c__SRP_dBwsAttendPeA,exPeA,e$EDRϘME(SLSS6"N0{00020820-0000-0000-C000-000000000046}(%H0h %" %8p@@HH86H<$*\Rffff*2=482f04814 xAttribute VB_Name = "wsA@vg5" Bast0{00020820- C$0046} |Global!SpacFalse dCreatablPre declaIdTru BExposeTemplateDeriv$Bustom izD2 rU `11Y4a`rU @nDrh%0#<O|tFJWi` FfŠJ^@1!oxfŠJ^@1!oO|tFJWi`ME(SLSS6"N0{00020820-0000-0000-C000-000000000046}(%H0h %$ %8p@@HH86H<$*\Rffff*2>482f04814 xAttribute VB_Name = "ws@end" Bas|0{00020820- C$0046} |Global!SpacFalse dCreatablPre declaIdTru BExposeTemplateDeriv$Bustom izD2 rU 14a`rU @n__SRP_e__SRP_fBwsMid __SRP_10DrhuU#<sNX+ FGiR=xGiR=sNX+ME(SLSS6"N0{00020820-0000-0000-C000-000000000046}(%H0h %( %8p@@HH86H<$*\Rffff*2?482f04814 xAttribute VB_Name = "wsM id" Basp0{0002`0820- C$0046} |GlobalSpacFalse CreatablPredeclaIdTru BExposeTemplateDeriv$BustomizD2 rU 14a`rU @n__SRP_11B_VBA_PROJECTF dir__SRP_0 ay  *\G{000204EF-0000-0000-C000-000000000046}#4.0#9#C:\PROGRA~1\COMMON~1\MICROS~1\VBA\VBA6\VBE6.DLL#Visual Basic For Applications*\G{00020813-0000-0000-C000-000000000046}#1.5#0#C:\Program Files\Microsoft Office\OFFICE11\EXCEL.EXE#Microsoft Excel 11.0 Object Library*\G{00020430-0000-0000-C000-000000000046}#2.0#0#C:\WINNT\System32\stdole2.tlb#OLE Automation(*\G{2DF8D04C-5BFA-101B-BDE5-00AA0044DE52}#2.3#0#C:\Program Files\Common Files\Microsoft Shared\OFFICE11\MSO.DLL#Microsoft Office 11.0 Object Library  6H<h ThisWorkbook3J480f3617ThisWorkbookKEwsGB28482f0481wsGB  wsAvg129482f0481 wsAvg1s0 wsAvg22:482f0481 wsAvg2nH wsAvg32;482f0481 wsAvg3` wsAvg42<482f0481! wsAvg4x wsAvg52=482f0481# wsAvg5wsAttend2>482f0481%wsAttend%0 wsMid2?482f0481) wsMiduU`xH0HJFXISa MIpIZ       !"#$%&'()*+,-./012345678:;=>?ABCDEFGHIJKLNOPRSTUVWXYZ[\]^_`abcdefghijklmnopqrt_stdole f%\*\G{00020430-C 0046}#2.0#0#C:\WINNT\System32\c2.tlb#OLE Automation^DOfficDO>fic5DD2DF8D04C-5BFA-101B -BDE5DAA5B42Dgram Files\CommonMicrosoft Shared\OFFICE11\MSO.DL L#M 11.0 Ob Li`braryK hThisWorkbookGThjsWArkboU 2 HB1wE,B,!K*"B+BBws GBG@wsGB2 wsAvg1G4AAvg61@G2NsU2222Rn3333 4 4 4 4 bD 5 5 5 5 "QsAttendGRA t`nRd2r9%0kwsMiAUMsd=F2"G? ! uU) K*y rU~~~~~~~~~~~~~B $[xcO<3O    e e e e )e Ae Ye qe iyi ThisWorkbookwsGBwsAvg1wsAvg2wsAvg3wsAvg4wsAvg5wsAttendwsMid VBAProjectF /C:\PROGRA~1\COMMON~1\MICROS~1\VBA\VBA6\VBE6.DLLVBA  Y0F4C:\Program Files\Microsoft Office\OFFICE11\EXCEL.EXEExcel a@0FC:\WINNT\System32\stdole2.tlbstdole  QPL-[DR?C:\Program Files\Common Files\Microsoft Shared\OFFICE11\MSO.DLLOffice q`F׽b"Gt3 Fq\HO (>DF Worksheet @;&-KQ|nF ,6g@kkYmtG\.M\NQ@ 9A_6Y`!zMK4s[/C[wµ\F߲n$EDRϘPeA,eO|tFJWi`fŠJ^@1!osNX+GiR=\rU~}      ypThisWorkbookThisWorkbookwsGBwsGBwsAvg1wsAvg1wsAvg2wsAvg2wsAvg3wsAvg3wsAvg4wsAvg4wsAvg5wsAvg5wsAttendwsAttendwsMidwsMid__SRP_19PROJECTwm<PROJECT!@SummaryInformation($MID="{A803654F-507C-45DE-B0EC-1008CA3B33AF}" Document=ThisWorkbook/&H00000000 Document=wsGB/&H00000000 Document=wsAvg1/&H00000000 Document=wsAvg2/&H00000000 Document=wsAvg3/&H00000000 Document=wsAvg4/&H00000000 Document=wsAvg5/&H00000000 Document=wsAttend/&H00000000 Document=wsMid/&H00000000 Name="VBAProject" HelpContextID="0" VersionCompatible32="393222000" CMG="1614F1E40F1C2A202A202A202A20" DPB="3537D201EE21EF21EF21" GC="5456B322CD40CE40CEBF" [Host Extender Info] &H00000001={3832D640-CF90-11CF-8E43-00A0C911005A};VBE;&H00000000 [Workspace] ThisWorkbook=0, 0, 0, 0, C wsGB=0, 0, 0, 0, C wsAvg1=0, 0, 0, 0, C wsAvg2=0, 0, 0, 0, C wsAvg3=0, 0, 0, 0, C wsAvg4=0, 0, 0, 0, C wsAvg5=0, 0, 0, 0, C wsAttend=0, 0, 0, 0, C wsMid=0, 0, 0, 0, C Oh+'0HPh John KongsvoldJohn KongsvoldMicrosoft Excel@*U@e@՜.+,08 PXd lt|  [ GradeBookAvg1Avg2Avg3Avg4Avg5 Attendance Mid-TermAvg1!AveragesAvg2!AveragesAvg3!AveragesAvg4!AveragesAvg5!AveragesCourse Course_InfoAvg1!CourseIDAvg2!CourseIDAvg3!CouDocumentSummaryInformation8QhCompObjsmrseIDAvg4!CourseIDAvg5!CourseIDCRNDaysGradeBook!FirstFormula'Mid-Term'!FirstFormulaAvg1!FiveFormulasAvg2!FiveFormulasAvg3!FiveFormulasAvg4!FiveFormulasAvg5!FiveFormulasGradeBook!Grade'Mid-Term'!GradeGradeBook!HideCalcNoteCell'Mid-Term'!HideCalcNoteCell InstructorAvg1!LastStudentAvg2!LastStudentAvg3!LastStudentAvg4!LastStudentAvg5!LastStudentGradeBook!LastStudent'Mid-Term'!LastStudentGradeBook!LetterGradeNoteCell'Mid-Term'!LetterGradeNoteCellNameGradeBook!NameCount'Mid-Term'!NameCountAttendance!Print_AreaAvg1!Print_AreaAvg2!Print_AreaAvg3!Print_AreaAvg4!Print_AreaAvg5!Print_AreaGradeBook!Print_Area'Mid-Term'!Print_AreaAttendance!Print_TitlesAvg1!Print_TitlesAvg2!Print_TitlesAvg3!Print_TitlesAvg4!Print_TitlesAvg5!Print_TitlesGradeBook!Print_Titles'Mid-Term'!Print_TitlesAvg1!QuizAveragesAvg2!QuizAveragesAvg3!QuizAveragesAvg4!QuizAveragesAvg5!QuizAveragesGradeBook!QuizLookupNoteCell'Mid-Term'!QuizLookupNoteCellGradeBook!RosterNames'Mid-Term'!RosterNamesGradeBook!ScoringNoteCell'Mid-Term'!ScoringNoteCellSectionGradeBook!StudentMarks'Mid-Term'!StudentMarksTermTimeAttendance!TopName Avg1!TopName Avg2!TopName Avg3!TopName Avg4!TopName Avg5!TopNameGradeBook!TopName'Mid-Term'!TopNameAvg1!TopRowScore1Avg2!TopRowScore1Avg3!TopRowScore1Avg4!TopRowScore1Avg5!TopRowScore1  Worksheets Named RangesS F!Microsoft Office Excel WorksheetBiff8Excel.Sheet.89q