Step by Step Instruction
Google Sheets starts on Step 2
Part 1 1a 1b 1c 2 2a 2b 2c 2d 2e 3
4 5 6 7 8 Part 2 9 10 Part 3 11 12 13

 

ABC                                                                                                          GPA Part 2
If you are using Excel start with #1 If you are using Google Sheets start with #2.

Arrow up to the Excel Table


 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 



 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

ABC

Step by Step Instruction

               Google Sheets start with Step # 2
Part 1 Formatting the Google Sheet starts with # 2
1a 1b 1c 2 2a 2b 2c 2d 2e 3
Formulas
4 5 6 7 8

Step 2.

Study the Tool Bars>>>>

Google Sheets Tool Bar
 
                 
                 
                 
                 
                 
                                                                                      
Google Sheets Tool Bar

Google Sheets Tool Bar

                             Arrow up to the Excel Table

Step 2. But the Borders in.
Click to see an example.
Image of the Grade Check Chart from class.

Select cells A1- J12 and choose all borders


Arrow up to the Excel Table

Step 2a) In cell A1 type the title "Quarter Grade Chart."    
Step 2a-1)      Merge cells > A1 - J1.

Step 2a-2)      Center cells > A1 - J12.

Step 2a-3)     Float titles in cells > A1 - J12.


Arrow up to the Excel Table

Step 2b) In cells B2 - J2 TYPE your Class Schedule.

Click the Text Wrap Tool so that Language Arts fits in the cell.


Arrow up to the Excel Table

Step 2c) In cells A3-A11 Type the week number.

Type 3 Week titles and then "skinny plus" them down to cell A11.

Step 2d) In cells A12 type the title "G.P.A. by Subject."                   

Click the Text Wrap Tool so that "G.P.A. by Subject" fits in the cell.


Arrow up to the Excel Table

Step 2e)

Type the number four in Cell G6.

Type the number three in Cell E4.

Type the number two in Cell B7.

Type the number one in Cell H9.

Type the number zero in Cell E5.

Arrow up to the Excel Table

Step 3

 

Number Format

Step 3a)   Complete Step 2e) by typing a few G.P.A. numbers into the chart.  4's, 3's, 2's, 1's or 0's.

Step 3b) Now select cells B3 - J12.  
     
Step 3c) Set the Number Value.  
                                              

Step 3d) Set
the decimal value
                                   to round to the nearest tenths position.
                             From a 3 to a 3.00 to a 3.0
                             From a 2 to a 2.00 to a 2.0
                             From a 1 to a 1.0 to a 1.0
etc.

Google Sheets ChooseNumber Tool Bar

Arrow up to the Excel Table

Change to Number

Arrow up to the Excel Table
Arrow up to the Excel Table
Step 4

Imput Formulas
Back to Video 4

Google Sheets Formula Tool Bar

Step 4.   In Cell J3 type in the = Average Formula:

                                        =AVERAGE(B3:I3)     Press Enter

Use the "skinny plus +" to extend the Average Formula all the way down the column J.

Select Cell J3 > Move your mouse around until it changes to a "skinny plus." >
Click
> Hold > Drag down the column > until you reach J11 > Release.

When you have an AVERAGE Formula in a cell but there are
no numbers in the cells you'll get the Error Message .

We'll get rid of the Error Message in Step 8.

Arrow up to the Excel Table
Step 5

Step 5.   In Cell B12 type in the = Average Formula:

                                        =AVERAGE(B3:B11)     Press Enter

Use the "skinny plus +" to extend the Average Formula to the right for the entire row.

Select Cell B12 > Move your mouse around until it changes to a "skinny plus." >
Click
> Hold >Drag to the left >until you reach J12 > Release.

Arrow up to the Excel Table

Step 6

Error Messages


Watch the video
If Error Video
or
follow the
Step by Step
Instructions.

 

 

 

When you have an AVERAGE Formula in a cell but there are
no numbers in the cells you'll get the Error Message

Step 6.   Let's Hide the Error Message If Error Video

How to get rid of the Error Messages If Error Video
3:05 min


Step 6 -
Let's Hide the Error Message

      Step by Step Instructions

Step 6a     Select Cell J3 that has the Error Message.

Step 6b     Edit the Average Formula =AVERAGE(B3:I3)             

Step 6c Put your cursor between the = sign and the A in average.
Step 6d Type iferror(
Step 6e Put your cursor behind the last )
Step 6f Type a comma , 2 quotes "" and a )
Arrow up to the Excel Table


Step 6g)     Your "If Error Formula" should look like this: 

 

Step 6h)   Use the "skinny plus +" to extend the NEW Formula all the way down the column.

Select Cell J3 > Move your mouse around until it changes to a "skinny plus." >
Click
> Hold > Drag down the column > until you reach J11 > Release.

 
Arrow up to the Excel Table
Step 7

Step 7  Repeat the Steps from 6 in Row 12 but use (B3:B11)

Step 7a     Select Cell B12 that has the Error Message.

Step 7b     Edit the Average Formula so that it looks like the "If Error Formula" below.     


       


Step 7c   Use the "skinny plus +" to extend the NEW Formula all the way to the left of the row.

Select Cell B12 > Move your mouse around until it changes to a "skinny plus." >
Click
> Hold >Drag to the left >until you reach J12 > Release.

 
Arrow up to the Excel Table

.

Step 8 Get your Grade Report from Ms. Church and input your Quarter Grades.

Tell Ms. Church that you are ready for Part 1 to be graded.

Arrow up to the Excel Table

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 Back to Video  1

Frequently Asked Questions

Back to Video 6

Where is the Chart Button?
Back to Video 1
 

Tippy Top

 

Back to Video  4

Frequently Asked Questions
Where is the FX button? Back to Video 4

Tippy Top

 

 
Back to Video  5

Frequently Asked Questions
Where is the Chart Button?
Back to Video 5
 

Tippy Top

Back to Video 6

Frequently Asked Questions
Where is the Merge and CenterButton?
Back to Video 6

Tippy Top


Back to Video 7
Frequently Asked Questions

Where is the Settings and Print Preview?

Special Note - This version there is no Print Preview Settings.

Where is the Conditional Formatting Button?

Back to Video 7
Ms. Church show me how to Conditional Format cells. Ms Church show me how....

Tippy Top

 


Back to Video 9
Frequently Asked Questions
Back to Video 9

 

Tippy Top

G.P.A.

Back to GPA
Frequently Asked Questions

 

 

Tippy Top

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Arrow up to the Excel Table

 

 

 

 

 

 

 

 

 

Email
first name dot last name at g dot kpbsd dot org
shell.church@g.kpbsd.org

Arrow up to the Excel Table

 

Excel 8     G.P.A. Video Conditional Formating     Conditional Formating Videos

 

Arrow up to the Excel Table
Fri. G.P.A. Video
Create a new GPA Excel Document with drop down windows, Value Look up formulas and conditional formatting. for each G.P.A. range.

Save it as LastName_FirstName_gpa

Excel 8     G.P.A. Video Conditional Formating     Conditional Formating Videos

 

1- Excel Video Doc
Drop
Drop
02-05
Drop
06-08

 

Arrow up to the Excel Table

 

 

Part 1

Formatting the Chart
in
an Excel Document

Step # 1a
   Column Width & Row Height
Step # 1b
   Format All Cells
Step # 1c
   Center Alignment &Text Wrap
Formatting the Chart
in
Google Sheets
Step # 2
   Type in your Class Schedule
Google Sheets
     
Center Alignment &Text Wrap

Number Values

Step # 3
      Round to the nearest tenths.
    
             2 should read as 2.0.
         
    
    1.3333 should read as 1.0.
         
    
    0.5147 should read as 0.6.  
   

Insert Formulas

Arrow up to the Excel Table

Step # 4
   Average Formula in column J

Put the AVERAGE formula into Cell J3
        =AVERAGE(B3:I3)
Then get the "skinny +" and spread the formula down Column J.

Step # 5
   Average Formula in row 12

Put the AVERAGE formula into Cell B12
        =AVERAGE(B3:B11)
Then get the "skinny +" and spread the formula to the right of row 12.

Get rid of the Error Message

Step # 6
   If Error Formula in Cells B3:I3
Step # 7
   If Error Formula in Cells B3:B11
Gett your Grade Check Sheet.
Step # 8
   Input QUARTER grades
Tell Ms. Church that you're ready
for Part 1 to be graded
.
Do not go on to Part 2 until you have a grade in PowerSchool.

 

 

 

 

 

 

 

 

 

 

Step by Step Instruction

               Google Sheets start with Step # 2
Part 1 Formatting the Google Sheet starts with # 2
1a 1b 1c 2 2a 2b 2c 2d 2e 3
Formulas
4 5 6 7 8

 

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


Arrow up to the Excel Table



Step 1b
.   In Excel Select the Whole chart

Format > All Borders
Format > Bold Font
Format > Font Calibri
Format > Font Size 16
Arrow up to the Excel Table



Step 1c
.   Alignment

          In Excel Select the Whole chart > Wrap Text >

Arrow up to the Excel Table
Next Step #2