Step 1 & Table of Contents

Google Sheets Expert? Click on the Fast Track links.
G.P.A. Chart Part 1		Fast Track #1	Fast Track no words #1
Using Google Sheets start with #2.
GOOGLE SHEETS Start wih Step 2 Formatting the Chart in Google Sheets	Step # 2 - Borders.
	Step 2a - Title the Chart.
	Step 2a-1 - Merge
	Step 2a-2 - Center
	Step 2a-3 - Float Text in Cells
	Step 2b - Text Wrap
	Step 2c - Type the Week #'s
	Step 2d - Text Wrap Cell A12.
	Step 2e - Type a number
Number Values	Step # 3 Round NUMBERS to the nearest tenths. Program the cells from B3 - J12 to round the NUMBERS to the nearest tenths. Type in a 2 and it will read as a 2.0. The number 1.46 will show up automatically as a 1.5.
Insert Formulas	Step # 4 Put the AVERAGE formula into Cell J3
	Step # 5 Put the AVERAGE formula into Cell B12
Get rid of the Error Message	Step # 6 If Error Formula in Cells B3:I3
	Step # 7 If Error Formula in Cells B3:B11

Go back through the Table of Contents Chart to make sure that all the formats & formulas work.
Color your chart. Click for the Example.
Ask Ms. Church to grade your G.P.A. Chart Part 1.

G.P.A. Part 2
Step # 8 Google Sheets Empty Cell Rule to turn cells white in the middle of the chart.	Excel Instructions
Step # 9 Google Sheets Conditionally Formatting the G.P.A. Ranges Make the numbers turn colors when they're typed into the cells. B3 - I11.
Ask Ms. Church to grade your G.P.A. Chart Part 2.

G.P.A. Part 3
Step # 10 Duplicate your Google Sheet	Excel Instructions
Step # 11 Find and record your Electives from PowerSchool
Step # 12 Insert Week 10 in Q4. Check all formulas.
Ask Ms. Church to grade your G.P.A. Chart Part 3.

G.P.A. Part 4

Step # 13 Cut and Paste sheets onto one 7th grade sheet.
Step # 12 Duplicate the 7th grade sheet to create an 8th grade sheet.

G.P.A. Part 5

Step # 14 Record Current Quarter Grades on the Quarter Sheet.
Use the Grade Sheet in your Drive.

Grade Point Average Values

A's = 4 points

B's = 3 points

C's = 2 points

D's = 1 points

F's = 0 points

Google Sheets Tool Bar

Excel Instructions
Excel Step 8 IsBlank Rule	Excel Step 9 Conditional Formating for the GPA Ranges.	Excel 10 Move or Copy	Excel 12 Insert Row

G.P.A. Part 4

Make a 7th Grade G.P.A. Sheet and an 8th Grade G.P.A. Sheet.

Condence all G.P.A. sheets down to one sheet for each grade level. See the below example.

Title a NEW sheet 7th grade.

Cut and Paste all four charts onto one sheet.

Put all Subjects in alphabetical order with your electives in Columns H & I. All subjects need to line up the whole way down the chart.

Make sure that your formulas work.

Delete the other sheets. Yes, that's right DELETE (of course only after I have graded the previous sheets :)

Title a NEW sheet 8th grade.

Create a Sheet with different colors on each chart. Then change the titles as follows >>>

G.P.A. Part 5

Step # 13 Record Current Quarter Grades on the Quarter Sheet.
Get your Grade Check Paper from Ms. Church

Step 1

In Excel Format Cell Size

Step 1a.   In Excel Select Cells A1 - J12
          Format Cells > Column Width = 15
          Format Cells > Row height = 35-40

Step 1b. In Excel Select the Whole chart

Step 1c. Alignment
In Excel Select the Whole chart > Wrap Text >

Next Step #2

Using Excel start with #1