ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Instructions - Important - DO NOT EDIT THE VALUES IN THE GREEN CELLS
2
1. Click on "File" in the top left and select "Make a copy"
3
2. Save a copy of the spreadsheet to your drive titled "MIDNLastName NavyGradeTemplate.xlsx"
4
3. Swtich to the Grade Tracker Sheet at the bottom of the screen.
5
4. Enter you name, rank, and the semster in cells C1, C2 and C3, respectively
6
5. Enter your courses that you are taking for the semester in the COURSE 1-COURSE 9 blocks in cells C6-C14 and delete and excess cells. *Note these cells are linked to the Course titles in the Class tables below, for example C6 is linked to C19 and C7 is linked to C43.
7
6. Enter the Course credit hours in cells G6-G14 that are associated with the courses in C6-C14
8
7. Enter the desired grades in your courses in cells J6-J14 *Note Do not change the values of cells H6-14 and I6-I14, these have equations in them for automatic grade calculations.
9
8. Go to the appropriate Class (1-7) and enter any grade information as you receive it. Ensure to include grade weights from the course syllabus to get an accurate measure of you GPA. Some classes may have more material assigned than there are availalbe cells in the table. If this is the case, converse with your advisor about consolidating assignments.
10
9. Click on the "Share" icon in the top right corner. In the new window add you advisors email as an Editor.
11
10. Meet with your advisor every 2 weeks via zoom to allow your advisor to discuss and review your progress.
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
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