ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Instructions for using the GPA Worksheet: the Worksheet follows as the Green tabbed Excel sheet.
2
General Organization:
3
The layout of the spreadsheet allows the user to use a single file to fill in a team with all nine members who are seniors, juniors, sophomores, or freshmen without having to copy or erase anything.
4
5
The spreadsheet is set up in View Page Break Preview. (If the spreadsheet opens and it is not in this view, then open View, then select Page Break Preview.) This view allows you to see the layout as shown in the diagram below. The numbers represent page numbers.
6
7
1101928The first column, colored yellow above, is for seniors, and is displayed and prints as pages 1-9.The second column, colored light blue, is for juniors, and is displayed and prints as pages 10-18.The third column, colored green, is for sophomores, and is displayed and prints as pages 19-27.The fourth column, colored red, is for freshmen, and is displayed and prints as pages 28-36.
8
2112029
9
3122130
10
4132231
11
5142332
12
6152433
13
7162534
14
8172635
15
9182736
16
17
 (There are no colors on the spreadsheet; refer to the page numbers seen in Page Break Preview.
18
Knowing page numbers is very useful when printing because it can save lots of blank pages.
19
20
While you may work in this Page Break Preview view, the size is rather small. You can switch back to the larger size by opening View and selecting “Normal”; however, go back to Page Break Preview before printing so that you may print only the pages needed.
21
22
Getting Started:
23
1Secure copies of your team members’ transcripts and the “Official courses to be used in calculating grade-point-averages (GPA)” pages from your AcaDec Coaches Manual, or from the TAD Website (www.txacadec.org). In the website, select the "Online Forms", then "Texas Academic Decathlon Manual"
24
25
2Highlight on the transcripts the eligible courses…those to be used in calculating GPA as outlined in the Coaches’ Manual. Only these classes will be typed into the spreadsheet. DO NOT type in other classes! If your school has renamed a state course, then find out from the Counseling Center the name of the course for which credit is being given. Indicate on the transcript the correct state name
26
27
3Open the Microsoft Excel file titled “AcaDec GPA Worksheet”, then the 2nd tabbed Excel worksheet colored green and labeled "GPA Worksheet"
28
29
5Page 1 should be displayed. To preserve the blank template, select File, Save As, and give a new file name of your choice. Then save. This allows the blank template file to remain clean for future use
30
31
6Back to the "Worksheet". Write only in the blocks requesting information; all others are locked.
32
33
7The worksheet is designed to greatly reduce the number of times you write the school name, coaches names, and phone numbers. Therefore, FIRST complete (on page one) your school name, the names of both coaches, and the school phone numbers…whether or not you have a senior student! Use hyphens as separators on the phone number(s). This information will be immediately imprinted on all 36 pages…no further typing is needed for this information.
34
35
8If you have a 12th grade student, complete his/her name on page one, then check his AcaDec category by moving the cursor over the small white block to the left of the appropriate category (Honors, Scholastic, or Varsity). A white hand will appear; left mouse click and a check will appear in the box. To correct, move the cursor over the box, left click and the check will disappear.
36
37
9Move down the page to “10th Grade Classes and Grade Points (include any summer school)”
38
39
10Type in the course name only ONE time in the "Eligible Course Name” column. In the “1st Sem Grade” column, record the grade. In the “1st Sem. Grade Points” column, type in the correct number (4, 3, 2, 1, or 0). Repeat this procedure for the 2nd semester grade. If a class is only 1 semester in length, DO NOT TYPE ANYTHING in the “2nd Sem Grade” and “2nd Sem. Grade Points” columns blanks. If your school is on the Accelerated Block Plan, treat each 9-weeks as a semester. DO NOT TYPE ANYTHING IN the "Grade" column for an ineligible (not used in grade calculation) class. If you do, the GPA calculation will be inaccurate!
40
41
11Repeat this procedure until you have all grades for the 10th grade
42
43
12Now scroll down and repeat the procedure for grades and grade points (as outlined in #s10-11) for the “11th Grade Classes and Grade Points (include any summer school)"
44
45
13As you scroll further down page 1, you will see that all calculation have been completed for you.
46
47
14To continue the worksheet for your other team members, go the appropriate grade levels for each person. Use the same procedure as outlined above, except that you will not have to type in the school name, etc.,
48
49
15Remember to save before printing
50
51
Printing:
52
1When you are ready to print, remember that you probably DO NOT want to print all 36 pages. Therefore, you must remember which pages you have used and give appropriate print commands.
53
54
2To print, select File, Print. When the print screen appears, find the “Print Range” area and select “Page(s) From”. Then place the first page number in the “From” box and the last page in the range you wish printed in the “To” box.
55
56
3Example: If you have 3 seniors, 3 juniors, and 3 sophomores, you would probably have completed pages 1-3, 10-12, and 19-21. Give three print commands. The first will be to print “From” 1 “To” 3; the second “From” 10 “To” 12, etc. If you wish to print a single page, place the same page number in both “From” and “To”.
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100