/ Softdisk G-S 58 / SDGS 58.2mg / SDGS.58 / AWGS / SGSDocs

< prev

view JSON data

view as text

open on a Mac

open on a PC

+--------+-------------------------+-------------------------+--------+--------+
|00000000| 11 10 1a 01 30 00 00 00 | 00 00 ff 0f e8 07 ff 01 |....0...|........|
|00000010| 3f 02 01 00 01 00 01 00 | 01 00 00 00 00 00 00 00 |?.......|........|
|00000020| 00 00 00 00 00 00 51 fb | 08 00 00 00 ff ff 4c 96 |......Q.|......L.|
|00000030| e0 00 78 28 08 00 40 00 | 00 00 00 0f f0 00 ff 0f |..x(..@.|........|
|00000040| 00 00 0f 00 f0 0f ff 0f | 00 00 00 0f f0 00 ff 0f |........|........|
|00000050| 00 00 0f 00 f0 0f ff 0f | ff ff ff ff ff ff ff ff |........|........|
|00000060| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff f0 |........|........|
|00000070| 00 0f ff ff ff ff ff ff | a0 00 00 01 65 00 48 00 |........|....e.H.|
|00000080| 50 00 00 00 00 00 f4 02 | 80 02 ee ff ec ff 06 03 |P.......|........|
|00000090| 94 02 4b 00 80 00 12 00 | 00 00 01 00 00 00 c0 03 |..K.....|........|
|000000a0| 27 3a 01 00 65 00 48 00 | 50 00 00 00 00 00 f4 02 |':..e.H.|P.......|
|000000b0| 80 02 05 00 00 00 00 00 | 0d 19 09 00 0b 00 12 00 |........|........|
|000000c0| 00 00 00 00 c0 6d e0 00 | 27 3a 01 00 ff 7f 01 00 |.....m..|':......|
|000000d0| 00 01 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000000e0| a8 19 09 00 01 00 0a 00 | ac 17 05 00 98 6d 01 00 |........|.....m..|
|000000f0| 27 3a 05 00 4f 00 32 00 | 5c 00 7d 00 00 00 00 00 |':..O.2.|\.}.....|
|00000100| 00 00 00 00 00 00 00 00 | c4 19 09 00 02 00 0a 00 |........|........|
|00000110| 0a 00 0f 00 02 00 c6 00 | 7e 02 02 00 00 00 00 00 |........|~.......|
|00000120| 0e 41 70 72 69 6c 20 31 | 38 2c 20 31 39 39 33 ff |.April 1|8, 1993.|
|00000130| ff ff ff ff ff ff ff ff | ff ff 08 20 34 3a 35 35 |........|... 4:55|
|00000140| 20 50 4d ff 01 31 39 39 | 39 f0 00 0f 03 00 00 00 | PM..199|9.......|
|00000150| 00 00 01 00 74 96 e0 00 | 10 00 10 00 88 96 e0 00 |....t...|........|
|00000160| 0a 9c 39 00 43 00 3b 00 | f4 02 12 00 12 00 18 03 |..9.C.;.|........|
|00000170| 50 00 12 00 02 00 7d 02 | 1e 00 00 00 00 00 2e 00 |P.....}.|........|
|00000180| 02 00 a3 00 ec 96 e0 00 | 00 00 3d 00 3c 00 4a 00 |........|..=.<.J.|
|00000190| 3c 00 1c 00 04 00 53 01 | 00 00 04 00 00 0a 00 00 |<.....S.|........|
|000001a0| 2d 00 00 00 00 00 34 00 | 00 00 ff ff 88 96 e0 00 |-.....4.|........|
|000001b0| 0a 9c 39 00 43 00 3b 00 | f4 02 12 00 12 00 18 03 |..9.C.;.|........|
|000001c0| 50 00 12 00 02 00 7d 02 | 1e 00 00 00 00 00 2e 00 |P.....}.|........|
|000001d0| 02 00 a3 00 ec 96 e0 00 | 00 00 3d 00 3c 00 4a 00 |........|..=.<.J.|
|000001e0| 3c 00 1c 00 04 00 53 01 | 00 00 04 00 00 0a 00 00 |<.....S.|........|
|000001f0| 2d 00 00 00 00 00 34 00 | 00 00 ff ff 9c 96 e0 00 |-.....4.|........|
|00000200| c7 86 3e 00 01 00 01 00 | f4 02 12 00 12 00 6e 00 |..>.....|......n.|
|00000210| 50 00 12 00 01 00 00 00 | 01 00 00 00 00 00 01 00 |P.......|........|
|00000220| 00 00 07 00 00 00 10 00 | 00 00 00 00 ff ff 00 00 |........|........|
|00000230| ff ff ff ff ff ff ff ff | 00 00 ff ff ff ff ff ff |........|........|
|00000240| 01 00 00 00 ff ff ff ff | ff ff 01 00 28 97 e0 00 |........|....(...|
|00000250| 5d 86 3e 00 01 00 01 00 | f4 02 12 00 12 00 6e 00 |].>.....|......n.|
|00000260| 50 00 12 00 01 00 00 00 | 01 00 00 00 00 00 01 00 |P.......|........|
|00000270| 00 00 07 00 00 00 10 00 | 00 00 00 00 ff ff 00 00 |........|........|
|00000280| ff ff ff ff ff ff ff ff | 00 00 ff ff ff ff ff ff |........|........|
|00000290| 01 00 00 00 ff ff ff ff | ff ff 01 00 3b 00 00 00 |........|....;...|
|000002a0| 04 00 00 00 00 00 0d 00 | 01 00 00 00 0c 00 00 00 |........|........|
|000002b0| 00 00 0d 00 01 00 00 00 | 14 00 00 00 01 00 0f 00 |........|........|
|000002c0| 01 00 00 00 3f 00 00 00 | 01 00 0d 00 01 00 00 00 |....?...|........|
|000002d0| 49 00 00 00 01 00 0d 00 | 01 00 00 00 5d 00 00 00 |I.......|....]...|
|000002e0| 01 00 0d 00 01 00 00 00 | 65 00 00 00 00 00 0d 00 |........|e.......|
|000002f0| 01 00 00 00 6d 00 00 00 | 00 00 0d 00 01 00 00 00 |....m...|........|
|00000300| 75 00 00 00 02 00 0d 00 | 01 00 00 00 a2 00 00 00 |u.......|........|
|00000310| 02 00 0d 00 01 00 00 00 | aa 00 00 00 03 00 34 00 |........|......4.|
|00000320| 04 00 00 00 c3 01 00 00 | 03 00 27 00 03 00 00 00 |........|..'.....|
|00000330| 96 02 00 00 03 00 34 00 | 04 00 00 00 b9 03 00 00 |......4.|........|
|00000340| 02 00 0d 00 01 00 00 00 | c1 03 00 00 02 00 0d 00 |........|........|
|00000350| 01 00 00 00 c9 03 00 00 | 02 00 0d 00 01 00 00 00 |........|........|
|00000360| e2 03 00 00 02 00 0d 00 | 01 00 00 00 ea 03 00 00 |........|........|
|00000370| 03 00 0d 00 01 00 00 00 | 3c 04 00 00 04 00 1a 00 |........|<.......|
|00000380| 02 00 00 00 a3 04 00 00 | 03 00 0d 00 01 00 00 00 |........|........|
|00000390| ab 04 00 00 03 00 4e 00 | 06 00 00 00 5f 06 00 00 |......N.|...._...|
|000003a0| 02 00 0d 00 01 00 00 00 | 67 06 00 00 02 00 0d 00 |........|g.......|
|000003b0| 01 00 00 00 6f 06 00 00 | 02 00 0d 00 01 00 00 00 |....o...|........|
|000003c0| 86 06 00 00 03 00 0d 00 | 01 00 00 00 8e 06 00 00 |........|........|
|000003d0| 03 00 27 00 03 00 00 00 | 52 07 00 00 03 00 75 00 |..'.....|R.....u.|
|000003e0| 09 00 00 00 f7 09 00 00 | 03 00 41 00 05 00 00 00 |........|..A.....|
|000003f0| 4b 0b 00 00 03 00 0d 00 | 01 00 00 00 53 0b 00 00 |K.......|....S...|
|00000400| 03 00 5b 00 07 00 01 00 | 04 00 00 00 03 00 0d 00 |..[.....|........|
|00000410| 01 00 01 00 0c 00 00 00 | 03 00 0d 00 01 00 01 00 |........|........|
|00000420| 14 00 00 00 02 00 0d 00 | 01 00 01 00 29 00 00 00 |........|....)...|
|00000430| 02 00 0d 00 01 00 01 00 | 31 00 00 00 03 00 34 00 |........|1.....4.|
|00000440| 04 00 01 00 4f 01 00 00 | 03 00 4e 00 06 00 02 00 |....O...|..N.....|
|00000450| 04 00 00 00 03 00 a9 00 | 0d 00 02 00 eb 03 00 00 |........|........|
|00000460| 03 00 0d 00 01 00 02 00 | f3 03 00 00 03 00 27 00 |........|......'.|
|00000470| 03 00 02 00 c2 04 00 00 | 03 00 0d 00 01 00 02 00 |........|........|
|00000480| ca 04 00 00 03 00 0d 00 | 01 00 02 00 d2 04 00 00 |........|........|
|00000490| 02 00 0d 00 01 00 02 00 | f6 04 00 00 03 00 0d 00 |........|........|
|000004a0| 01 00 02 00 fe 04 00 00 | 03 00 41 00 05 00 02 00 |........|..A.....|
|000004b0| 84 06 00 00 03 00 0d 00 | 01 00 02 00 8c 06 00 00 |........|........|
|000004c0| 03 00 27 00 03 00 02 00 | 4c 07 00 00 03 00 0d 00 |..'.....|L.......|
|000004d0| 01 00 02 00 54 07 00 00 | 03 00 0d 00 01 00 02 00 |....T...|........|
|000004e0| 5c 07 00 00 02 00 0d 00 | 01 00 02 00 74 07 00 00 |\.......|....t...|
|000004f0| 02 00 0d 00 01 00 02 00 | 7c 07 00 00 03 00 27 00 |........||.....'.|
|00000500| 03 00 02 00 66 08 00 00 | 04 00 0d 00 01 00 02 00 |....f...|........|
|00000510| 6e 08 00 00 04 00 0d 00 | 01 00 02 00 a8 08 00 00 |n.......|........|
|00000520| 04 00 0d 00 01 00 02 00 | de 08 00 00 04 00 0d 00 |........|........|
|00000530| 01 00 02 00 0e 09 00 00 | 04 00 0d 00 01 00 02 00 |........|........|
|00000540| 3b 09 00 00 04 00 0d 00 | 01 00 02 00 73 09 00 00 |;.......|....s...|
|00000550| 04 00 0d 00 01 00 02 00 | 81 09 00 00 05 00 0d 00 |........|........|
|00000560| 01 00 04 00 11 00 28 00 | 28 00 30 02 01 00 5e 01 |......(.|(.0...^.|
|00000570| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000580| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000590| 00 00 00 00 00 00 04 00 | 21 00 28 00 28 00 30 02 |........|!.(.(.0.|
|000005a0| 01 00 5e 01 00 00 00 00 | 00 00 00 00 00 00 00 00 |..^.....|........|
|000005b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000005c0| 00 00 00 00 00 00 00 00 | 00 00 0e 00 11 00 28 00 |........|......(.|
|000005d0| 28 00 30 02 02 00 50 00 | 00 00 5e 01 00 00 00 00 |(.0...P.|..^.....|
|000005e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000005f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 1c 00 |........|........|
|00000600| 11 00 3c 00 3c 00 30 02 | 02 00 64 00 00 00 5e 01 |..<.<.0.|..d...^.|
|00000610| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000620| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000630| 00 00 08 00 11 00 5a 00 | 5a 00 30 02 02 00 64 00 |......Z.|Z.0...d.|
|00000640| 00 00 5e 01 00 00 00 00 | 00 00 00 00 00 00 00 00 |..^.....|........|
|00000650| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000660| 00 00 00 00 00 00 01 00 | 11 00 5a 00 5a 00 30 02 |........|..Z.Z.0.|
|00000670| 02 00 78 00 00 00 5e 01 | 00 00 00 00 00 00 00 00 |..x...^.|........|
|00000680| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000690| 00 00 00 00 00 00 00 00 | 00 00 41 0d 00 00 41 0d |........|..A...A.|
|000006a0| 41 0d 04 00 00 0a 00 00 | 00 0d 04 00 00 0a 00 00 |A.......|........|
|000006b0| 00 0d 04 00 08 0a 00 00 | 00 53 75 70 65 72 20 47 |........|.Super G|
|000006c0| 72 61 64 65 20 53 68 65 | 65 74 02 00 aa 02 08 20 |rade She|et..... |
|000006d0| 49 6e 73 74 72 75 63 74 | 69 6f 6e 73 0d 04 00 00 |Instruct|ions....|
|000006e0| 0a 00 00 00 62 79 0d 04 | 00 00 0a 00 00 00 41 61 |....by..|......Aa|
|000006f0| 72 6f 6e 20 4d 69 6c 6c | 65 72 0d 04 00 00 0a 00 |ron Mill|er......|
|00000700| 00 00 0d 04 00 05 0a 00 | 00 00 0d 04 00 05 0a 00 |........|........|
|00000710| 00 00 0d 04 00 05 0a 00 | 00 00 47 65 6e 65 72 61 |........|..Genera|
|00000720| 6c 20 49 6e 66 6f 72 6d | 61 74 69 6f 6e 20 26 20 |l Inform|ation & |
|00000730| 51 75 69 63 6b 20 4f 76 | 65 72 20 56 69 65 77 0d |Quick Ov|er View.|
|00000740| 04 00 05 0a 00 00 70 0d | 04 00 00 0a 00 00 70 09 |......p.|......p.|
|00000750| 54 68 65 20 53 75 70 65 | 72 20 47 72 61 64 65 20 |The Supe|r Grade |
|00000760| 53 68 65 65 74 aa 20 28 | 53 47 53 29 20 74 65 6d |Sheet. (|SGS) tem|
|00000770| 70 6c 61 74 65 20 69 73 | 20 64 65 73 69 67 6e 65 |plate is| designe|
|00000780| 64 20 74 6f 20 61 6c 6c | 6f 77 20 74 65 61 63 68 |d to all|ow teach|
|00000790| 65 72 73 20 74 6f 20 71 | 75 69 63 6b 6c 79 20 61 |ers to q|uickly a|
|000007a0| 6e 64 20 65 61 73 69 6c | 79 20 61 63 63 65 73 73 |nd easil|y access|
|000007b0| 20 73 74 75 64 65 6e 74 | 73 d5 20 67 72 61 64 65 | student|s. grade|
|000007c0| 73 20 61 6e 64 20 61 76 | 65 72 61 67 65 73 2e 20 |s and av|erages. |
|000007d0| 20 50 72 65 73 65 6e 74 | 6c 79 2c 20 53 47 53 20 | Present|ly, SGS |
|000007e0| 63 61 6e 20 61 63 63 6f | 6d 6d 6f 64 61 74 65 20 |can acco|mmodate |
|000007f0| 74 77 65 6e 74 79 2d 66 | 69 76 65 20 28 32 35 29 |twenty-f|ive (25)|
|00000800| 20 73 74 75 64 65 6e 74 | 73 20 77 69 74 68 20 61 | student|s with a|
|00000810| 20 6d 61 78 69 6d 75 6d | 20 6f 66 20 66 69 66 74 | maximum| of fift|
|00000820| 65 65 6e 20 28 31 35 29 | 20 67 72 61 64 65 73 20 |een (15)| grades |
|00000830| 65 61 63 68 20 77 69 74 | 68 6f 75 74 20 6d 6f 64 |each wit|hout mod|
|00000840| 69 66 69 63 61 74 69 6f | 6e 20 74 6f 20 74 68 65 |ificatio|n to the|
|00000850| 20 62 61 73 69 63 20 74 | 65 6d 70 6c 61 74 65 2e | basic t|emplate.|
|00000860| 0d 04 00 00 0a 00 00 76 | 09 55 73 69 6e 67 20 53 |.......v|.Using S|
|00000870| 47 53 20 69 73 20 76 65 | 72 79 20 73 69 6d 70 6c |GS is ve|ry simpl|
|00000880| 65 2e 20 20 41 6c 6c 20 | 79 6f 75 20 02 05 68 61 |e.  All |you ..ha|
|00000890| 76 65 02 00 20 74 6f 20 | 64 6f 20 69 73 20 65 6e |ve.. to |do is en|
|000008a0| 74 65 72 20 73 74 75 64 | 65 6e 74 20 6e 61 6d 65 |ter stud|ent name|
|000008b0| 73 20 69 6e 20 63 65 6c | 6c 73 20 42 31 39 20 74 |s in cel|ls B19 t|
|000008c0| 6f 20 42 34 34 20 61 6e | 64 20 67 72 61 64 65 73 |o B44 an|d grades|
|000008d0| 20 42 31 39 20 74 6f 20 | 52 31 39 20 74 6f 20 42 | B19 to |R19 to B|
|000008e0| 34 34 20 74 6f 20 52 34 | 34 2e 20 20 54 68 65 20 |44 to R4|4.  The |
|000008f0| 74 65 6d 70 6c 61 74 65 | 20 77 69 6c 6c 20 74 68 |template| will th|
|00000900| 65 6e 20 64 69 73 70 6c | 61 79 20 73 74 75 64 65 |en displ|ay stude|
|00000910| 6e 74 20 61 76 65 72 61 | 67 65 73 20 62 65 67 69 |nt avera|ges begi|
|00000920| 6e 6e 69 6e 67 20 61 74 | 20 63 65 6c 6c 20 54 31 |nning at| cell T1|
|00000930| 39 2e 09 0d 04 00 00 0a | 00 00 74 09 54 68 65 20 |9.......|..t.The |
|00000940| 69 6e 66 6f 72 6d 61 74 | 69 6f 6e 20 62 65 6c 6f |informat|ion belo|
|00000950| 77 20 69 73 20 64 65 76 | 6f 74 65 64 20 74 6f 20 |w is dev|oted to |
|00000960| 64 65 73 63 72 69 62 69 | 6e 67 20 74 68 65 20 73 |describi|ng the s|
|00000970| 69 78 20 63 65 6c 6c 73 | 20 77 68 69 63 68 20 63 |ix cells| which c|
|00000980| 6f 6e 74 61 69 6e 20 74 | 68 65 20 d2 43 6c 61 73 |ontain t|he .Clas|
|00000990| 73 20 49 6e 66 6f 72 6d | 61 74 69 6f 6e d3 d1 44 |s Inform|ation..D|
|000009a0| 38 20 74 6f 20 44 31 33 | d1 77 69 74 68 20 61 6e |8 to D13|.with an|
|000009b0| 20 65 6d 70 68 61 73 69 | 73 20 6f 6e 20 d2 57 65 | emphasi|s on .We|
|000009c0| 69 67 68 74 65 64 20 47 | 72 61 64 65 73 d3 20 61 |ighted G|rades. a|
|000009d0| 6e 64 20 d2 41 6c 65 72 | 74 20 41 76 65 72 61 67 |nd .Aler|t Averag|
|000009e0| 65 2e d3 20 20 41 74 20 | 74 68 65 20 65 6e 64 20 |e..  At |the end |
|000009f0| 6f 66 20 74 68 65 20 6c | 69 73 74 20 69 73 20 61 |of the l|ist is a|
|00000a00| 20 73 65 63 74 69 6f 6e | 20 77 68 69 63 68 20 6c | section| which l|
|00000a10| 69 73 74 73 20 61 6c 6c | 20 74 68 65 20 63 65 6c |ists all| the cel|
|00000a20| 6c 73 20 77 68 69 63 68 | 20 61 72 65 20 61 75 74 |ls which| are aut|
|00000a30| 6f 6d 61 74 69 63 61 6c | 6c 79 20 63 61 6c 63 75 |omatical|ly calcu|
|00000a40| 6c 61 74 65 64 20 62 79 | 20 74 68 65 20 74 65 6d |lated by| the tem|
|00000a50| 70 6c 61 74 65 2e 0d 04 | 00 00 0a 00 00 74 0d 04 |plate...|.....t..|
|00000a60| 00 05 0a 00 00 74 0d 04 | 00 05 0a 00 00 6e 43 6c |.....t..|.....nCl|
|00000a70| 61 73 73 20 49 6e 66 6f | 72 6d 61 74 69 6f 6e 0d |ass Info|rmation.|
|00000a80| 04 00 05 0a 00 00 65 0d | 04 00 00 0a 00 00 72 55 |......e.|......rU|
|00000a90| 6e 64 65 72 20 74 68 65 | 20 d2 43 6c 61 73 73 20 |nder the| .Class |
|00000aa0| 49 6e 66 6f 72 6d 61 74 | 69 6f 6e d3 20 68 65 61 |Informat|ion. hea|
|00000ab0| 64 69 6e 67 2c 20 74 68 | 65 20 75 73 65 72 20 77 |ding, th|e user w|
|00000ac0| 69 6c 6c 20 66 69 6e 64 | 20 73 69 78 20 28 36 29 |ill find| six (6)|
|00000ad0| 20 6f 70 74 69 6f 6e 73 | 3a 0d 04 00 00 0a 00 00 | options|:.......|
|00000ae0| 54 d2 43 6c 61 73 73 20 | 54 69 74 6c 65 d3 2c 20 |T.Class |Title., |
|00000af0| d2 50 65 72 69 6f 64 d3 | 2c 20 d2 45 6e 72 6f 6c |.Period.|, .Enrol|
|00000b00| 6c 6d 65 6e 74 d3 2c 20 | d2 52 65 70 6f 72 74 20 |lment., |.Report |
|00000b10| 50 65 72 69 6f 64 d3 2c | 20 d2 57 65 69 67 68 74 |Period.,| .Weight|
|00000b20| 65 64 20 47 72 61 64 65 | 73 d3 2c 20 61 6e 64 20 |ed Grade|s., and |
|00000b30| d2 41 6c 65 72 74 20 41 | 76 65 72 61 67 65 2e d3 |.Alert A|verage..|
|00000b40| 0d 04 00 00 0a 00 00 20 | 0d 04 00 00 0a 00 00 d2 |....... |........|
|00000b50| 54 68 65 20 66 69 72 73 | 74 20 66 6f 75 72 20 28 |The firs|t four (|
|00000b60| 34 29 d1 d2 43 6c 61 73 | 73 20 54 69 74 6c 65 d3 |4)..Clas|s Title.|
|00000b70| 2c 20 d2 50 65 72 69 6f | 64 d3 2c 20 d2 45 6e 72 |, .Perio|d., .Enr|
|00000b80| 6f 6c 6c 6d 65 6e 74 d3 | 2c 20 61 6e 64 20 d2 52 |ollment.|, and .R|
|00000b90| 65 70 6f 72 74 20 50 65 | 72 69 6f 64 d3 d1 61 72 |eport Pe|riod..ar|
|00000ba0| 65 20 70 72 65 74 74 79 | 20 6d 75 63 68 20 73 65 |e pretty| much se|
|00000bb0| 6c 66 2d 65 78 70 6c 61 | 6e 61 74 6f 72 79 20 61 |lf-expla|natory a|
|00000bc0| 6e 64 20 61 72 65 20 6f | 70 74 69 6f 6e 61 6c 20 |nd are o|ptional |
|00000bd0| 69 6e 66 6f 72 6d 61 74 | 69 6f 6e 2e 20 20 4a 75 |informat|ion.  Ju|
|00000be0| 73 74 20 6f 6e 65 20 69 | 74 65 6d 20 6f 66 20 69 |st one i|tem of i|
|00000bf0| 6d 70 6f 72 74 61 6e 63 | 65 2c 20 d2 45 6e 72 6f |mportanc|e, .Enro|
|00000c00| 6c 6c 6d 65 6e 74 d3 20 | 69 73 20 61 75 74 6f 6d |llment. |is autom|
|00000c10| 61 74 69 63 61 6c 6c 79 | 20 63 61 6c 63 75 6c 61 |atically| calcula|
|00000c20| 74 65 64 20 62 79 20 74 | 68 65 20 74 65 6d 70 6c |ted by t|he templ|
|00000c30| 61 74 65 20 62 65 63 61 | 75 73 65 20 69 74 20 6d |ate beca|use it m|
|00000c40| 6f 6e 69 74 6f 72 73 20 | 66 6f 72 20 74 68 65 20 |onitors |for the |
|00000c50| 61 64 64 69 74 69 6f 6e | 20 6f 66 20 73 74 75 64 |addition| of stud|
|00000c60| 65 6e 74 73 20 74 6f 20 | 74 68 65 20 63 6c 61 73 |ents to |the clas|
|00000c70| 73 20 72 6f 6c 65 2e 20 | 20 54 68 65 20 6c 61 73 |s role. | The las|
|00000c80| 74 20 74 77 6f 20 69 74 | 65 6d 73 20 61 72 65 20 |t two it|ems are |
|00000c90| 73 69 6d 70 6c 65 3b 20 | 68 6f 77 65 76 65 72 2c |simple; |however,|
|00000ca0| 20 74 68 65 69 72 20 75 | 73 65 20 77 69 74 68 69 | their u|se withi|
|00000cb0| 6e 20 74 68 65 20 74 65 | 6d 70 6c 61 74 65 20 69 |n the te|mplate i|
|00000cc0| 73 20 02 05 76 65 72 79 | 02 00 20 63 6f 6d 70 6c |s ..very|.. compl|
|00000cd0| 65 78 20 61 6e 64 20 74 | 68 65 20 65 78 70 6c 61 |ex and t|he expla|
|00000ce0| 6e 61 74 69 6f 6e 73 20 | 61 72 65 20 71 75 69 74 |nations |are quit|
|00000cf0| 65 20 74 65 63 68 6e 69 | 63 61 6c 2e 0d 04 00 05 |e techni|cal.....|
|00000d00| 0a 00 00 00 0d 04 00 05 | 0a 00 00 64 0d 04 00 05 |........|...d....|
|00000d10| 0a 00 00 64 57 65 69 67 | 68 74 65 64 20 47 72 61 |...dWeig|hted Gra|
|00000d20| 64 65 73 0d 04 00 00 0a | 00 00 20 0d 04 00 00 0a |des.....|.. .....|
|00000d30| 00 00 20 09 46 69 72 73 | 74 2c 20 6c 65 74 d5 73 |.. .Firs|t, let.s|
|00000d40| 20 64 65 61 6c 20 77 69 | 74 68 20 d2 57 65 69 67 | deal wi|th .Weig|
|00000d50| 68 74 65 64 20 47 72 61 | 64 65 73 2e d3 20 20 49 |hted Gra|des..  I|
|00000d60| 66 20 63 65 6c 6c 20 44 | 31 32 20 69 73 20 d2 59 |f cell D|12 is .Y|
|00000d70| 65 73 d3 2c 20 6f 72 20 | 61 6e 79 74 68 69 6e 67 |es., or |anything|
|00000d80| 20 62 65 67 69 6e 6e 69 | 6e 67 20 77 69 74 68 20 | beginni|ng with |
|00000d90| 74 68 65 20 6c 65 74 74 | 65 72 73 20 d2 59 d3 20 |the lett|ers .Y. |
|00000da0| 6f 72 20 d2 79 d3 2c 20 | 74 68 65 6e 20 74 68 65 |or .y., |then the|
|00000db0| 20 74 65 6d 70 6c 61 74 | 65 20 61 73 73 75 6d 65 | templat|e assume|
|00000dc0| 73 20 74 68 61 74 20 74 | 68 65 20 75 73 65 72 20 |s that t|he user |
|00000dd0| 77 61 6e 74 73 20 74 6f | 20 75 73 65 20 77 65 69 |wants to| use wei|
|00000de0| 67 68 74 65 64 20 67 72 | 61 64 65 73 2e 20 20 0d |ghted gr|ades.  .|
|00000df0| 04 00 00 0a 00 00 61 09 | 49 66 20 74 68 65 20 61 |......a.|If the a|
|00000e00| 62 6f 76 65 20 69 73 20 | 74 72 75 65 2c 20 74 68 |bove is |true, th|
|00000e10| 65 6e 20 74 68 65 20 74 | 65 6d 70 6c 61 74 65 20 |en the t|emplate |
|00000e20| 6d 61 6b 65 73 20 73 6f | 6d 65 20 63 68 61 6e 67 |makes so|me chang|
|00000e30| 65 73 20 6f 66 20 77 68 | 69 63 68 20 74 68 65 20 |es of wh|ich the |
|00000e40| 75 73 65 72 20 73 68 6f | 75 6c 64 20 74 61 6b 65 |user sho|uld take|
|00000e50| 20 6e 6f 74 65 2e 20 20 | 43 65 6c 6c 20 45 31 33 | note.  |Cell E13|
|00000e60| 20 63 68 61 6e 67 65 73 | 20 74 6f 20 61 20 d2 25 | changes| to a .%|
|00000e70| d3 2c 20 69 6e 64 69 63 | 61 74 69 6e 67 20 74 68 |., indic|ating th|
|00000e80| 61 74 20 74 68 65 20 d2 | 41 6c 65 72 74 20 41 76 |at the .|Alert Av|
|00000e90| 65 72 61 67 65 d3 20 77 | 69 6c 6c 20 62 65 20 63 |erage. w|ill be c|
|00000ea0| 6f 6d 70 75 74 65 64 20 | 6f 6e 20 61 20 70 65 72 |omputed |on a per|
|00000eb0| 63 65 6e 74 61 67 65 20 | 73 63 61 6c 65 20 28 73 |centage |scale (s|
|00000ec0| 65 65 20 d2 41 6c 65 72 | 74 20 41 76 65 72 61 67 |ee .Aler|t Averag|
|00000ed0| 65 d3 20 62 65 6c 6f 77 | 20 66 6f 72 20 6d 6f 72 |e. below| for mor|
|00000ee0| 65 20 69 6e 66 6f 72 6d | 61 74 69 6f 6e 20 6f 6e |e inform|ation on|
|00000ef0| 20 74 68 69 73 29 2e 20 | 20 43 65 6c 6c 73 20 42 | this). | Cells B|
|00000f00| 31 35 2c 20 42 31 36 20 | 61 6e 64 20 54 31 36 20 |15, B16 |and T16 |
|00000f10| 70 72 6f 6d 70 74 20 74 | 68 65 20 75 73 65 72 20 |prompt t|he user |
|00000f20| 74 6f 20 65 6e 74 65 72 | 20 74 68 65 20 d2 77 65 |to enter| the .we|
|00000f30| 69 67 68 74 20 73 63 61 | 6c 65 73 d3 20 66 6f 72 |ight sca|les. for|
|00000f40| 20 65 61 63 68 20 67 72 | 61 64 65 2e 20 20 41 20 | each gr|ade.  A |
|00000f50| 77 65 69 67 68 74 20 73 | 63 61 6c 65 20 69 73 20 |weight s|cale is |
|00000f60| 61 20 72 65 61 6c 20 6e | 75 6d 62 65 72 20 72 65 |a real n|umber re|
|00000f70| 70 72 65 73 65 6e 74 69 | 6e 67 20 74 68 65 20 77 |presenti|ng the w|
|00000f80| 65 69 67 68 74 20 74 68 | 61 74 20 61 20 63 65 72 |eight th|at a cer|
|00000f90| 74 61 69 6e 20 67 72 61 | 64 65 20 63 61 72 72 69 |tain gra|de carri|
|00000fa0| 65 73 2e 20 20 46 6f 72 | 20 65 78 61 6d 70 6c 65 |es.  For| example|
|00000fb0| 2c 20 61 20 77 65 69 67 | 68 74 20 73 63 61 6c 65 |, a weig|ht scale|
|00000fc0| 20 6f 66 20 31 35 20 69 | 6e 64 69 63 61 74 65 73 | of 15 i|ndicates|
|00000fd0| 20 74 6f 20 74 68 65 20 | 74 65 6d 70 6c 61 74 65 | to the |template|
|00000fe0| 20 74 68 61 74 20 61 20 | 67 72 61 64 65 20 6d 61 | that a |grade ma|
|00000ff0| 6b 65 73 20 75 70 20 66 | 69 66 74 65 65 6e 20 70 |kes up f|ifteen p|
|00001000| 65 72 63 65 6e 74 20 28 | 31 35 25 29 20 6f 66 20 |ercent (|15%) of |
|00001010| 74 68 65 20 66 69 6e 61 | 6c 20 61 76 65 72 61 67 |the fina|l averag|
|00001020| 65 2e 20 20 50 6c 65 61 | 73 65 20 6e 6f 74 65 20 |e.  Plea|se note |
|00001030| 74 68 61 74 20 74 68 65 | 20 74 6f 74 61 6c 20 66 |that the| total f|
|00001040| 6f 72 20 6f 66 20 61 6c | 6c 20 77 65 69 67 68 74 |or of al|l weight|
|00001050| 20 73 63 61 6c 65 73 20 | 6d 75 73 74 20 65 71 75 | scales |must equ|
|00001060| 61 6c 20 31 30 30 20 6f | 72 20 74 68 65 20 61 76 |al 100 o|r the av|
|00001070| 65 72 61 67 65 73 20 77 | 69 6c 6c 20 62 65 20 63 |erages w|ill be c|
|00001080| 6f 6d 70 75 74 65 64 20 | 69 6e 63 6f 72 72 65 63 |omputed |incorrec|
|00001090| 74 6c 79 2e 0d 04 00 00 | 0a 00 00 6e 09 54 68 65 |tly.....|...n.The|
|000010a0| 20 74 65 6d 70 6c 61 74 | 65 20 64 6f 65 73 20 6e | templat|e does n|
|000010b0| 6f 74 20 72 65 71 75 69 | 72 65 20 79 6f 75 20 74 |ot requi|re you t|
|000010c0| 6f 20 75 73 65 20 61 6c | 6c 20 66 69 66 74 65 65 |o use al|l fiftee|
|000010d0| 6e 20 28 31 35 29 20 67 | 72 61 64 65 20 63 6f 6c |n (15) g|rade col|
|000010e0| 75 6d 6e 73 20 28 44 31 | 39 20 74 6f 20 52 31 39 |umns (D1|9 to R19|
|000010f0| 29 2e 20 20 59 6f 75 20 | 6d 61 79 20 65 6e 74 65 |).  You |may ente|
|00001100| 72 20 61 6e 79 20 6e 75 | 6d 62 65 72 20 6f 66 20 |r any nu|mber of |
|00001110| 67 72 61 64 65 73 20 66 | 72 6f 6d 20 6f 6e 65 20 |grades f|rom one |
|00001120| 28 31 29 20 74 6f 20 66 | 69 66 74 65 65 6e 20 28 |(1) to f|ifteen (|
|00001130| 31 35 29 3b 20 68 6f 77 | 65 76 65 72 2c 20 62 65 |15); how|ever, be|
|00001140| 77 61 72 65 20 74 68 61 | 74 20 79 6f 75 20 6d 75 |ware tha|t you mu|
|00001150| 73 74 20 61 64 6a 75 73 | 74 20 74 68 65 20 77 65 |st adjus|t the we|
|00001160| 69 67 68 74 20 73 63 61 | 6c 65 73 20 28 63 65 6c |ight sca|les (cel|
|00001170| 6c 73 20 44 31 36 20 74 | 6f 20 52 31 36 29 20 61 |ls D16 t|o R16) a|
|00001180| 63 63 6f 72 64 69 6e 67 | 6c 79 20 69 66 20 79 6f |ccording|ly if yo|
|00001190| 75 20 68 61 76 65 20 73 | 65 6c 65 63 74 65 64 20 |u have s|elected |
|000011a0| 77 65 69 67 68 74 65 64 | 20 67 72 61 64 65 73 2e |weighted| grades.|
|000011b0| 20 20 50 6c 65 61 73 65 | 20 72 65 6d 65 6d 62 65 |  Please| remembe|
|000011c0| 72 20 74 68 61 74 20 74 | 68 65 20 77 65 69 67 68 |r that t|he weigh|
|000011d0| 74 20 73 63 61 6c 65 73 | 20 6d 75 73 74 20 74 6f |t scales| must to|
|000011e0| 74 61 6c 20 31 30 30 2e | 0d 04 00 00 0a 00 00 65 |tal 100.|.......e|
|000011f0| 0d 04 00 00 0a 00 00 68 | 09 49 66 20 63 65 6c 6c |.......h|.If cell|
|00001200| 20 44 31 32 20 69 73 20 | d2 4e 6f d3 2c 20 6f 72 | D12 is |.No., or|
|00001210| 20 61 6e 79 74 68 69 6e | 67 20 62 65 67 69 6e 6e | anythin|g beginn|
|00001220| 69 6e 67 20 77 69 74 68 | 20 74 68 65 20 6c 65 74 |ing with| the let|
|00001230| 74 65 72 73 20 d2 4e d3 | 20 6f 72 20 d2 6e d3 2c |ters .N.| or .n.,|
|00001240| 20 74 68 65 6e 20 74 68 | 65 20 74 65 6d 70 6c 61 | then th|e templa|
|00001250| 74 65 20 61 73 73 75 6d | 65 73 20 74 68 61 74 20 |te assum|es that |
|00001260| 74 68 65 20 75 73 65 72 | 20 77 61 6e 74 73 20 74 |the user| wants t|
|00001270| 6f 20 75 73 65 20 61 20 | 73 74 61 6e 64 61 72 64 |o use a |standard|
|00001280| 20 61 76 65 72 61 67 69 | 6e 67 20 70 72 6f 63 65 | averagi|ng proce|
|00001290| 64 75 72 65 20 77 68 65 | 72 65 20 61 6c 6c 20 67 |dure whe|re all g|
|000012a0| 72 61 64 65 73 20 63 61 | 72 72 79 20 65 71 75 61 |rades ca|rry equa|
|000012b0| 6c 20 77 65 69 67 68 74 | 2e 20 20 49 66 20 74 68 |l weight|.  If th|
|000012c0| 69 73 20 69 73 20 73 6f | 2c 20 74 68 65 6e 20 63 |is is so|, then c|
|000012d0| 65 6c 6c 20 42 31 35 2c | 20 42 31 36 20 61 6e 64 |ell B15,| B16 and|
|000012e0| 20 54 31 36 20 72 65 6d | 61 69 6e 20 62 6c 61 6e | T16 rem|ain blan|
|000012f0| 6b 20 61 6e 64 20 63 65 | 6c 6c 20 45 31 33 20 72 |k and ce|ll E13 r|
|00001300| 65 76 65 72 74 73 20 74 | 6f 20 61 20 d2 23 d3 2c |everts t|o a .#.,|
|00001310| 20 69 6e 64 69 63 61 74 | 69 6e 67 20 74 68 61 74 | indicat|ing that|
|00001320| 20 74 68 65 20 d2 41 6c | 65 72 74 20 41 76 65 72 | the .Al|ert Aver|
|00001330| 61 67 65 d3 20 77 69 6c | 6c 20 62 65 20 63 6f 6d |age. wil|l be com|
|00001340| 70 75 74 65 64 20 6f 6e | 20 61 20 73 74 72 61 69 |puted on| a strai|
|00001350| 67 68 74 20 73 63 61 6c | 65 2e 20 20 41 6c 73 6f |ght scal|e.  Also|
|00001360| 2c 20 6e 6f 74 65 20 74 | 68 61 74 20 61 6e 79 20 |, note t|hat any |
|00001370| 6e 75 6d 62 65 72 73 20 | 72 65 6d 61 69 6e 69 6e |numbers |remainin|
|00001380| 67 20 69 6e 20 63 65 6c | 6c 73 20 44 31 36 20 74 |g in cel|ls D16 t|
|00001390| 6f 20 52 31 36 20 28 77 | 65 69 67 68 74 20 73 63 |o R16 (w|eight sc|
|000013a0| 61 6c 65 73 29 20 77 69 | 6c 6c 20 62 65 20 69 67 |ales) wi|ll be ig|
|000013b0| 6e 6f 72 65 64 20 62 79 | 20 74 68 65 20 74 65 6d |nored by| the tem|
|000013c0| 70 6c 61 74 65 20 77 68 | 65 6e 20 63 6f 6d 70 75 |plate wh|en compu|
|000013d0| 74 69 6e 67 20 61 76 65 | 72 61 67 65 73 2e 0d f5 |ting ave|rages...|
|000013e0| 02 00 00 f5 02 f5 02 04 | 00 00 0a 00 00 6c 0d 04 |........|.....l..|
|000013f0| 00 00 0a 00 00 6c 0d 04 | 00 05 0a 00 00 76 41 6c |.....l..|.....vAl|
|00001400| 65 72 74 20 41 76 65 72 | 61 67 65 0d 04 00 05 0a |ert Aver|age.....|
|00001410| 00 00 61 0d 04 00 00 0a | 00 00 61 09 54 68 65 20 |..a.....|..a.The |
|00001420| d2 41 6c 65 72 74 20 41 | 76 65 72 61 67 65 d3 20 |.Alert A|verage. |
|00001430| 69 73 20 61 20 66 65 61 | 74 75 72 65 20 6f 66 20 |is a fea|ture of |
|00001440| 63 6f 6e 76 65 6e 69 65 | 6e 63 65 20 66 6f 72 20 |convenie|nce for |
|00001450| 74 65 61 63 68 65 72 73 | 2e 20 20 49 74 20 77 69 |teachers|.  It wi|
|00001460| 6c 6c 20 61 75 74 6f 6d | 61 74 69 63 61 6c 6c 79 |ll autom|atically|
|00001470| 20 6e 6f 74 69 66 79 20 | 74 68 65 6d 20 69 66 20 | notify |them if |
|00001480| 61 20 73 74 75 64 65 6e | 74 73 d5 20 61 76 65 72 |a studen|ts. aver|
|00001490| 61 67 65 73 20 66 61 6c | 6c 73 20 62 65 6c 6f 77 |ages fal|ls below|
|000014a0| 20 74 68 65 20 64 65 73 | 69 67 6e 61 74 65 64 20 | the des|ignated |
|000014b0| 70 6f 69 6e 74 20 28 63 | 65 6c 6c 20 44 31 33 29 |point (c|ell D13)|
|000014c0| 2e 20 20 48 6f 77 65 76 | 65 72 2c 20 74 68 65 72 |.  Howev|er, ther|
|000014d0| 65 20 61 72 65 20 61 20 | 66 65 77 20 74 68 69 6e |e are a |few thin|
|000014e0| 67 73 20 74 68 61 74 20 | 6e 65 65 64 20 74 6f 20 |gs that |need to |
|000014f0| 62 65 20 64 69 73 63 75 | 73 73 65 64 20 74 6f 20 |be discu|ssed to |
|00001500| 70 72 6f 70 65 72 6c 79 | 20 75 6e 64 65 72 73 74 |properly| underst|
|00001510| 61 6e 64 20 74 68 65 20 | 75 73 61 67 65 20 6f 66 |and the |usage of|
|00001520| 20 d2 41 6c 65 72 74 20 | 41 76 65 72 61 67 65 2e | .Alert |Average.|
|00001530| d3 0d 04 00 00 0a 00 00 | fc 09 54 68 65 72 65 20 |........|..There |
|00001540| 69 73 20 6f 6e 6c 79 20 | 6f 6e 65 20 6f 70 74 69 |is only |one opti|
|00001550| 6f 6e 20 74 68 61 74 20 | 65 66 66 65 63 74 73 20 |on that |effects |
|00001560| 74 68 65 20 70 65 72 66 | 6f 72 6d 61 6e 63 65 20 |the perf|ormance |
|00001570| 6f 66 20 d2 41 6c 65 72 | 74 20 41 76 65 72 61 67 |of .Aler|t Averag|
|00001580| 65 d3 20 61 6e 64 20 74 | 68 61 74 20 69 73 20 d2 |e. and t|hat is .|
|00001590| 57 65 69 67 68 74 65 64 | 20 47 72 61 64 65 73 2e |Weighted| Grades.|
|000015a0| d3 20 20 49 66 20 d2 57 | 65 69 67 68 74 65 64 20 |.  If .W|eighted |
|000015b0| 47 72 61 64 65 73 d3 20 | 69 73 20 73 65 74 20 74 |Grades. |is set t|
|000015c0| 6f 20 d2 4e 6f d3 2c 20 | 74 68 65 6e 20 74 68 65 |o .No., |then the|
|000015d0| 20 d2 41 6c 65 72 74 20 | 41 76 65 72 61 67 65 d3 | .Alert |Average.|
|000015e0| 20 69 73 20 74 61 6b 65 | 6e 20 6c 69 74 65 72 61 | is take|n litera|
|000015f0| 6c 6c 79 2e 20 20 46 6f | 72 20 65 78 61 6d 70 6c |lly.  Fo|r exampl|
|00001600| 65 2c 20 d2 41 6c 65 72 | 74 20 41 76 65 72 61 67 |e, .Aler|t Averag|
|00001610| 65 d3 20 69 73 20 d2 37 | 35 d3 2c 20 79 6f 75 20 |e. is .7|5., you |
|00001620| 68 61 76 65 20 65 6e 74 | 65 72 65 64 20 74 77 6f |have ent|ered two|
|00001630| 20 67 72 61 64 65 73 2c | 20 36 30 20 61 6e 64 20 | grades,| 60 and |
|00001640| 37 35 2e 20 20 41 66 74 | 65 72 20 72 65 63 61 6c |75.  Aft|er recal|
|00001650| 63 75 6c 61 74 69 6e 67 | 2c 20 74 68 65 20 73 70 |culating|, the sp|
|00001660| 72 65 61 64 73 68 65 65 | 74 20 77 6f 75 6c 64 20 |readshee|t would |
|00001670| 64 69 73 70 6c 61 79 20 | 61 20 6d 6f 64 61 6c 20 |display |a modal |
|00001680| 64 69 61 6c 6f 67 20 77 | 69 74 68 20 74 68 65 20 |dialog w|ith the |
|00001690| 73 74 75 64 65 6e 74 d5 | 73 20 6e 61 6d 65 20 61 |student.|s name a|
|000016a0| 6e 64 20 63 75 72 72 65 | 6e 74 20 61 76 65 72 61 |nd curre|nt avera|
|000016b0| 67 65 20 62 65 63 61 75 | 73 65 20 68 69 73 2f 68 |ge becau|se his/h|
|000016c0| 65 72 20 61 76 65 72 61 | 67 65 20 69 73 20 62 65 |er avera|ge is be|
|000016d0| 6c 6f 77 20 37 35 2e 0d | d1 09 00 00 d1 09 d1 09 |low 75..|........|
|000016e0| 04 00 00 0a 00 00 65 09 | 49 66 20 79 6f 75 20 68 |......e.|If you h|
|000016f0| 61 76 65 20 73 65 74 20 | d2 57 65 69 67 68 74 65 |ave set |.Weighte|
|00001700| 64 20 47 72 61 64 65 73 | d3 20 74 6f 20 d2 59 65 |d Grades|. to .Ye|
|00001710| 73 d3 2c 20 74 68 65 6e | 20 74 68 65 20 70 72 6f |s., then| the pro|
|00001720| 63 65 64 75 72 65 20 66 | 6f 72 20 64 65 74 65 72 |cedure f|or deter|
|00001730| 6d 69 6e 69 6e 67 20 69 | 66 20 61 20 73 74 75 64 |mining i|f a stud|
|00001740| 65 6e 74 73 20 61 76 65 | 72 61 67 65 20 66 61 6c |ents ave|rage fal|
|00001750| 6c 73 20 62 65 6c 6f 77 | 20 d2 41 6c 65 72 74 20 |ls below| .Alert |
|00001760| 41 76 65 72 61 67 65 d3 | 20 69 73 20 71 75 69 74 |Average.| is quit|
|00001770| 65 20 64 69 66 66 65 72 | 65 6e 74 2e 20 20 41 73 |e differ|ent.  As|
|00001780| 20 79 6f 75 20 6b 6e 6f | 77 2c 20 65 61 63 68 20 | you kno|w, each |
|00001790| 67 72 61 64 65 20 68 61 | 73 20 61 20 77 65 69 67 |grade ha|s a weig|
|000017a0| 68 74 20 73 63 61 6c 65 | 2c 20 73 6f 20 75 73 69 |ht scale|, so usi|
|000017b0| 6e 67 20 d2 41 6c 65 72 | 74 20 41 76 65 72 61 67 |ng .Aler|t Averag|
|000017c0| 65 d3 20 61 73 20 64 65 | 73 63 72 69 62 65 64 20 |e. as de|scribed |
|000017d0| 61 62 6f 76 65 20 77 6f | 75 6c 64 20 72 65 73 75 |above wo|uld resu|
|000017e0| 6c 74 20 69 73 20 65 72 | 72 6f 6e 65 6f 75 73 20 |lt is er|roneous |
|000017f0| 61 6c 65 72 74 73 2e 20 | 20 54 68 75 73 2c 20 74 |alerts. | Thus, t|
|00001800| 68 65 20 66 6f 6c 6c 6f | 77 69 6e 67 20 6d 65 74 |he follo|wing met|
|00001810| 68 6f 64 20 69 73 20 75 | 73 65 64 2e 20 20 46 69 |hod is u|sed.  Fi|
|00001820| 72 73 74 2c 20 65 61 63 | 68 20 67 72 61 64 65 20 |rst, eac|h grade |
|00001830| 69 73 20 6d 75 6c 74 69 | 70 6c 69 65 64 20 62 79 |is multi|plied by|
|00001840| 20 69 74 73 20 77 65 69 | 67 68 74 20 73 63 61 6c | its wei|ght scal|
|00001850| 65 20 61 6e 64 20 74 68 | 65 20 72 65 73 75 6c 74 |e and th|e result|
|00001860| 73 20 61 72 65 20 74 68 | 65 6e 20 61 64 64 65 64 |s are th|en added|
|00001870| 20 74 6f 20 70 72 6f 64 | 75 63 65 20 74 68 65 20 | to prod|uce the |
|00001880| 73 74 75 64 65 6e 74 73 | d5 20 63 75 72 72 65 6e |students|. curren|
|00001890| 74 20 61 76 65 72 61 67 | 65 2e 20 20 4e 65 78 74 |t averag|e.  Next|
|000018a0| 2c 20 d2 41 6c 65 72 74 | 20 41 76 65 72 61 67 65 |, .Alert| Average|
|000018b0| d3 20 69 73 20 6d 75 6c | 74 69 70 6c 69 65 64 20 |. is mul|tiplied |
|000018c0| 62 79 20 65 61 63 68 20 | 77 65 69 67 68 74 20 73 |by each |weight s|
|000018d0| 63 61 6c 65 20 61 6e 64 | 20 74 68 65 20 72 65 73 |cale and| the res|
|000018e0| 75 6c 74 73 20 61 72 65 | 20 61 67 61 69 6e 20 61 |ults are| again a|
|000018f0| 64 64 65 64 2e 20 20 49 | 66 20 74 68 65 20 73 74 |dded.  I|f the st|
|00001900| 75 64 65 6e 74 73 d5 20 | 61 76 65 72 61 67 65 20 |udents. |average |
|00001910| 66 61 6c 6c 73 20 62 65 | 6c 6f 77 20 74 68 69 73 |falls be|low this|
|00001920| 20 74 6f 74 61 6c 2c 20 | 74 68 65 6e 20 74 68 65 | total, |then the|
|00001930| 20 61 6c 65 72 74 20 69 | 73 20 70 72 6f 64 75 63 | alert i|s produc|
|00001940| 65 64 2e 20 20 46 6f 72 | 20 65 78 61 6d 70 6c 65 |ed.  For| example|
|00001950| 2c 20 79 6f 75 20 68 61 | 76 65 20 61 6e 20 d2 41 |, you ha|ve an .A|
|00001960| 6c 65 72 74 20 41 76 65 | 72 61 67 65 d3 20 6f 66 |lert Ave|rage. of|
|00001970| 20 37 35 20 61 6e 64 20 | 32 20 67 72 61 64 65 2c | 75 and |2 grade,|
|00001980| 20 39 30 20 61 6e 64 20 | 38 35 2c 20 65 61 63 68 | 90 and |85, each|
|00001990| 20 68 61 76 69 6e 67 20 | 61 20 77 65 69 67 68 74 | having |a weight|
|000019a0| 20 73 63 61 6c 65 20 6f | 66 20 31 30 2e 20 20 54 | scale o|f 10.  T|
|000019b0| 68 65 20 73 74 75 64 65 | 6e 74 d5 73 20 63 75 72 |he stude|nt.s cur|
|000019c0| 72 65 6e 74 20 61 76 65 | 72 61 67 65 20 77 6f 75 |rent ave|rage wou|
|000019d0| 6c 64 20 62 65 20 31 37 | 2e 35 2c 20 66 61 72 20 |ld be 17|.5, far |
|000019e0| 62 65 6c 6f 77 20 74 68 | 65 20 37 35 20 6c 69 6d |below th|e 75 lim|
|000019f0| 69 74 3b 20 68 6f 77 65 | 76 65 72 2c 20 74 68 65 |it; howe|ver, the|
|00001a00| 20 61 6c 65 72 74 20 77 | 6f 75 6c 64 20 6e 6f 74 | alert w|ould not|
|00001a10| 20 62 65 20 67 69 76 65 | 6e 20 62 65 63 61 75 73 | be give|n becaus|
|00001a20| 65 20 61 76 65 72 61 67 | 65 20 69 73 20 61 62 6f |e averag|e is abo|
|00001a30| 76 65 20 31 35 2e 30 30 | 20 28 d2 41 6c 65 72 74 |ve 15.00| (.Alert|
|00001a40| 20 41 76 65 72 61 67 65 | d3 20 74 69 6d 65 73 20 | Average|. times |
|00001a50| 77 65 69 67 68 74 20 73 | 63 61 6c 65 29 2e 20 20 |weight s|cale).  |
|00001a60| 4c 69 6b 65 20 69 74 20 | 73 61 69 64 2c 20 69 74 |Like it |said, it|
|00001a70| 20 69 73 20 76 65 72 79 | 20 63 6f 6d 70 6c 65 78 | is very| complex|
|00001a80| 3b 20 68 6f 77 65 76 65 | 72 2c 20 74 68 69 73 20 |; howeve|r, this |
|00001a90| 68 61 73 20 6e 6f 74 68 | 69 6e 67 20 74 6f 20 64 |has noth|ing to d|
|00001aa0| 6f 20 77 69 74 68 20 74 | 68 65 20 61 63 74 75 61 |o with t|he actua|
|00001ab0| 6c 20 75 73 65 20 6f 66 | 20 74 68 65 20 74 65 6d |l use of| the tem|
|00001ac0| 70 6c 61 74 65 2e 0d 04 | 00 00 0a 00 00 00 0d 04 |plate...|........|
|00001ad0| 00 00 0a 00 00 00 09 4a | 75 73 74 20 61 20 6e 6f |.......J|ust a no|
|00001ae0| 74 65 21 20 20 59 6f 75 | 20 63 61 6e 20 64 65 74 |te!  You| can det|
|00001af0| 65 72 6d 69 6e 65 20 77 | 68 69 63 68 20 77 61 79 |ermine w|hich way|
|00001b00| 20 d2 41 6c 65 72 74 20 | 41 76 65 72 61 67 65 d3 | .Alert |Average.|
|00001b10| 20 77 69 6c 6c 20 62 65 | 20 75 73 65 64 20 62 79 | will be| used by|
|00001b20| 20 65 78 61 6d 69 6e 69 | 6e 67 20 63 65 6c 6c 20 | examini|ng cell |
|00001b30| 45 31 33 2e 20 20 49 66 | 20 69 74 20 69 73 20 61 |E13.  If| it is a|
|00001b40| 20 d2 23 d3 2c 20 74 68 | 65 6e 20 61 20 6c 69 74 | .#., th|en a lit|
|00001b50| 65 72 61 6c 20 63 6f 6d | 70 61 72 69 73 6f 6e 20 |eral com|parison |
|00001b60| 69 73 20 64 6f 6e 65 2e | 20 20 49 66 20 69 74 20 |is done.|  If it |
|00001b70| 69 73 20 61 20 d2 25 d3 | 2c 20 74 68 65 6e 20 74 |is a .%.|, then t|
|00001b80| 68 65 20 70 65 72 63 65 | 6e 74 61 67 65 20 6d 65 |he perce|ntage me|
|00001b90| 74 68 6f 64 20 69 73 20 | 75 73 65 64 2e 0d 04 00 |thod is |used....|
|00001ba0| 00 0a 00 00 00 0d 04 00 | 00 0a 00 00 00 0d 04 00 |........|........|
|00001bb0| 05 0a 00 00 00 45 6e 74 | 65 72 69 6e 67 20 53 74 |.....Ent|ering St|
|00001bc0| 75 64 65 6e 74 20 49 6e | 66 6f 72 6d 61 74 69 6f |udent In|formatio|
|00001bd0| 6e 0d 04 00 00 0a 00 00 | 00 0d 04 00 00 0a 00 00 |n.......|........|
|00001be0| 00 09 54 68 65 20 6f 6e | 6c 79 20 69 6e 66 6f 72 |..The on|ly infor|
|00001bf0| 6d 61 74 69 6f 6e 20 74 | 68 61 74 20 74 68 65 20 |mation t|hat the |
|00001c00| 75 73 65 72 20 6d 75 73 | 74 20 65 6e 74 65 72 20 |user mus|t enter |
|00001c10| 69 73 20 74 68 65 20 73 | 74 75 64 65 6e 74 20 69 |is the s|tudent i|
|00001c20| 6e 66 6f 72 6d 61 74 69 | 6f 6e 2c 20 73 74 75 64 |nformati|on, stud|
|00001c30| 65 6e 74 20 6e 61 6d 65 | 73 20 61 6e 64 20 67 72 |ent name|s and gr|
|00001c40| 61 64 65 73 2e 20 20 54 | 68 65 20 72 65 73 74 2c |ades.  T|he rest,|
|00001c50| 20 74 68 65 20 74 65 6d | 70 6c 61 74 65 20 63 61 | the tem|plate ca|
|00001c60| 6c 63 75 6c 61 74 65 73 | 20 69 74 73 65 6c 66 73 |lculates| itselfs|
|00001c70| 20 6f 72 20 69 73 20 6f | 70 74 69 6f 6e 61 6c 20 | or is o|ptional |
|00001c80| 69 6e 66 6f 72 6d 61 74 | 69 6f 6e 2e 20 20 53 74 |informat|ion.  St|
|00001c90| 75 64 65 6e 74 20 6e 61 | 6d 65 73 20 28 70 72 65 |udent na|mes (pre|
|00001ca0| 73 65 6e 74 6c 79 20 6c | 69 6d 69 74 65 64 20 74 |sently l|imited t|
|00001cb0| 6f 20 32 35 29 20 6d 75 | 73 74 20 62 65 20 70 6c |o 25) mu|st be pl|
|00001cc0| 61 63 65 64 20 69 6e 20 | 63 65 6c 6c 73 20 42 31 |aced in |cells B1|
|00001cd0| 39 20 74 6f 20 42 34 34 | 2e 20 20 54 68 69 73 20 |9 to B44|.  This |
|00001ce0| 69 6e 66 6f 72 6d 61 74 | 69 6f 6e 20 69 73 20 74 |informat|ion is t|
|00001cf0| 72 61 6e 73 70 6f 73 65 | 64 20 74 6f 20 63 65 6c |ranspose|d to cel|
|00001d00| 6c 73 20 55 31 39 20 74 | 6f 20 55 34 34 20 73 6f |ls U19 t|o U44 so|
|00001d10| 20 74 68 61 74 20 79 6f | 75 20 64 6f 20 6e 6f 74 | that yo|u do not|
|00001d20| 20 68 61 76 65 20 74 6f | 20 73 63 72 6f 6c 6c 20 | have to| scroll |
|00001d30| 62 61 63 6b 20 61 6e 64 | 20 66 6f 72 74 68 20 74 |back and| forth t|
|00001d40| 6f 20 6d 61 74 63 68 20 | 61 20 6e 61 6d 65 20 77 |o match |a name w|
|00001d50| 69 74 68 20 61 6e 20 61 | 76 65 72 61 67 65 2e 0d |ith an a|verage..|
|00001d60| 04 00 00 0a 00 00 00 0d | 04 00 00 0a 00 00 00 09 |........|........|
|00001d70| 47 72 61 64 65 73 20 66 | 6f 72 20 65 61 63 68 20 |Grades f|or each |
|00001d80| 73 74 75 64 65 6e 74 20 | 28 70 72 65 73 65 6e 74 |student |(present|
|00001d90| 6c 79 20 6c 69 6d 69 74 | 65 64 20 74 6f 20 31 35 |ly limit|ed to 15|
|00001da0| 29 20 6d 75 73 74 20 62 | 65 20 65 6e 74 65 72 65 |) must b|e entere|
|00001db0| 64 20 69 6e 20 63 65 6c | 6c 73 20 44 31 39 20 74 |d in cel|ls D19 t|
|00001dc0| 6f 20 52 31 39 20 74 6f | 20 44 34 34 20 74 6f 20 |o R19 to| D44 to |
|00001dd0| 52 34 34 2e 20 20 59 6f | 75 20 6d 61 79 20 75 73 |R44.  Yo|u may us|
|00001de0| 65 20 6f 6e 6c 79 20 61 | 20 73 75 62 73 65 74 20 |e only a| subset |
|00001df0| 6f 66 20 74 68 65 73 65 | 2c 20 64 65 70 65 6e 64 |of these|, depend|
|00001e00| 69 6e 67 20 6f 6e 20 74 | 68 65 20 6e 75 6d 62 65 |ing on t|he numbe|
|00001e10| 72 20 6f 66 20 73 74 75 | 64 65 6e 74 73 20 79 6f |r of stu|dents yo|
|00001e20| 75 20 68 61 76 65 2e 0d | 04 00 00 0a 00 00 00 0d |u have..|........|
|00001e30| 04 00 00 0a 00 00 00 0d | 04 00 05 0a 00 00 00 43 |........|.......C|
|00001e40| 61 6c 63 75 6c 61 74 65 | 64 20 43 65 6c 6c 73 0d |alculate|d Cells.|
|00001e50| 04 00 05 0a 00 00 00 0d | 04 00 00 0a 00 00 00 09 |........|........|
|00001e60| 54 68 65 20 66 6f 6c 6c | 6f 77 69 6e 67 20 69 73 |The foll|owing is|
|00001e70| 20 61 20 6c 69 73 74 20 | 6f 66 20 63 65 6c 6c 73 | a list |of cells|
|00001e80| 20 77 68 6f 73 65 20 63 | 6f 6e 74 65 6e 74 73 20 | whose c|ontents |
|00001e90| 61 72 65 20 63 61 6c 63 | 75 6c 61 74 65 64 20 62 |are calc|ulated b|
|00001ea0| 79 20 74 68 65 20 74 65 | 6d 70 6c 61 74 65 20 61 |y the te|mplate a|
|00001eb0| 6e 64 20 02 05 6d 75 73 | 74 20 6e 6f 74 20 6d 6f |nd ..mus|t not mo|
|00001ec0| 64 69 66 69 65 64 02 00 | 20 6f 72 20 74 6f 20 74 |dified..| or to t|
|00001ed0| 65 6d 70 6c 61 74 65 20 | 77 69 6c 6c 20 6e 6f 74 |emplate |will not|
|00001ee0| 20 77 6f 72 6b 20 70 72 | 6f 70 65 72 6c 79 2e 20 | work pr|operly. |
|00001ef0| 20 54 6f 20 70 72 65 76 | 65 6e 74 20 61 63 63 69 | To prev|ent acci|
|00001f00| 64 65 6e 74 61 6c 20 6d | 6f 64 69 66 69 63 61 74 |dental m|odificat|
|00001f10| 69 6f 6e 2c 20 61 6c 6c | 20 6f 66 20 74 68 65 73 |ion, all| of thes|
|00001f20| 65 20 63 65 6c 6c 73 20 | 68 61 76 65 20 62 65 65 |e cells |have bee|
|00001f30| 6e 20 70 72 6f 74 65 63 | 74 65 64 2c 20 f0 2d 2a |n protec|ted, .-*|
|00001f40| 2e 0d 04 00 00 0a 00 00 | 00 0d 04 00 00 0a 00 00 |........|........|
|00001f50| 41 41 31 39 20 74 6f 20 | 41 34 34 20 2d 20 45 6e |AA19 to |A44 - En|
|00001f60| 72 6f 6c 6c 6d 65 6e 74 | 20 6e 75 6d 62 65 72 20 |rollment| number |
|00001f70| 28 74 65 6d 70 6c 61 74 | 65 20 75 73 65 20 6f 6e |(templat|e use on|
|00001f80| 6c 79 29 0d 04 00 00 0a | 00 00 00 44 34 35 20 74 |ly).....|...D45 t|
|00001f90| 6f 20 54 34 35 20 2d 20 | 43 6f 6e 74 61 69 6e 73 |o T45 - |Contains|
|00001fa0| 20 67 72 61 64 65 20 61 | 6e 64 20 63 6c 61 73 73 | grade a|nd class|
|00001fb0| 20 61 76 65 72 61 67 65 | 73 0d 04 00 00 0a 00 00 | average|s.......|
|00001fc0| ff 54 31 39 20 74 6f 20 | 54 34 34 20 2d 20 43 6f |.T19 to |T44 - Co|
|00001fd0| 6e 74 61 69 6e 73 20 73 | 74 75 64 65 6e 74 73 d5 |ntains s|tudents.|
|00001fe0| 20 61 76 65 72 61 67 65 | 73 0d 04 00 00 0a 00 00 | average|s.......|
|00001ff0| 00 55 31 39 20 74 6f 20 | 55 34 34 20 2d 20 54 72 |.U19 to |U44 - Tr|
|00002000| 61 6e 73 70 6f 73 65 64 | 20 73 74 75 64 65 6e 74 |ansposed| student|
|00002010| 20 6e 61 6d 65 73 0d 04 | 00 00 0a 00 00 00 56 31 | names..|......V1|
|00002020| 39 20 74 6f 20 56 34 34 | 20 2d 20 50 72 6f 64 75 |9 to V44| - Produ|
|00002030| 63 65 73 20 61 6c 65 72 | 74 73 20 62 61 73 65 64 |ces aler|ts based|
|00002040| 20 6f 6e 20 64 61 74 61 | 20 74 61 62 6c 65 0d 04 | on data| table..|
|00002050| 00 00 0a 00 00 04 52 61 | 6e 67 65 3a 0d 04 00 00 |......Ra|nge:....|
|00002060| 0a 00 00 00 09 41 52 20 | 31 39 20 74 6f 20 42 52 |.....AR |19 to BR|
|00002070| 20 31 39 20 74 6f 20 41 | 52 20 34 34 20 54 6f 20 | 19 to A|R 44 To |
|00002080| 42 52 20 34 34 20 2d 20 | 44 61 74 61 20 74 61 62 |BR 44 - |Data tab|
|00002090| 6c 65 20 66 6f 72 20 63 | 6f 6d 70 75 74 61 74 69 |le for c|omputati|
|000020a0| 6f 6e 20 6f 66 20 61 6c | 65 72 74 73 0d 01 00 00 |on of al|erts....|
|000020b0| 00 04 00 00 00 00 00 10 | 00 01 00 01 00 11 00 28 |........|.......(|
|000020c0| 00 28 00 30 02 01 00 5e | 01 00 00 00 00 00 00 00 |.(.0...^|........|
|000020d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000020e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 0c |........|........|
|000020f0| 00 00 00 0c 00 0c 00 03 | 00 00 0c 00 00 00 0d 01 |........|........|
|00002100| 00 00 00 04 00 00 00 00 | 00 10 00 01 00 01 00 11 |........|........|
|00002110| 00 28 00 28 00 30 02 01 | 00 5e 01 00 00 00 00 00 |.(.(.0..|.^......|
|00002120| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002130| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002140| 00 0c 00 00 00 0c 00 0c | 00 03 00 00 0c 00 00 00 |........|........|
|00002150| 0d                      |                         |.       |        |
+--------+-------------------------+-------------------------+--------+--------+