User Guide

profilefury12
userguidefiles.zip

FraserRiverCollegeLogo.jpg

FRCGradingSheet-PointsTemplate.xlsx

Sheet1

Fraser River College
Instructor
Course GRADE & GPA TABLE
Section Score 0% 60% 63% 67% 70% 73% 77% 80% 83% 87% 90% 93% 97%
Year Ltr Grade F D- D D+ C- C C+ B- B B+ A- A A+
Term GPA 0.00 0.67 1.00 1.33 1.67 2.00 2.33 2.67 3.00 3.33 3.67 4.00 4.00
Assignment or Test Name
Possible Points
The grade for each assignment or test may be expressed to one decimal point.
Total number of assignments and tests: 0
Total possible points: 0
LAST NAME First Name Hon Stret Address City Prv P/C A/C Phone STUDENT ID Average
Microsoft: Average equals Total Points divided by Total Possible Points
Ltr Grade
An-Chian Kao: Note that the GradeTable referred to in the formula in this column is the table of grades found at the top of this sheet.
GPA
Microsoft: INSERT NEW COLUMNS TO THE LEFT TO ADD MORE ASSIGNMENTS OR TESTS.

Microsoft: INSERT NEW ROWS ABOVE THIS ROW TO ADD STUDENTS.

Microsoft: Average equals Total Points divided by Total Possible Points

An-Chian Kao: Note that the GradeTable referred to in the formula in this column is the table of grades found at the top of this sheet.
CLASS SUMMARY Average Ltr Grade GPA
Average
Highest Score
Lowest Score

Enter each assignment or test and the points it is worth into the table below.

image1.jpeg

FRCGradingSheet-COMM 04.xlsx

Sheet1

Fraser River College
Instructor D. Ingre
Course COMM 04 GRADE & GPA TABLE
Section S20 Average 0% 60% 63% 67% 70% 73% 77% 80% 83% 87% 90% 93% 97%
Year 2014 Ltr Grade F D- D D+ C- C C+ B- B B+ A- A A+
Term Fall GPA 0.00 0.67 1.00 1.33 1.67 2.00 2.33 2.67 3.00 3.33 3.67 4.00 4.00
Assignment or Test Name Quiz 1 Quiz 2 Report Memo Proposal Letter Midterm Quiz 3 Presentation Final
Possible Points 5 5 15 15 20 5 10 25
The grade for each assignment or test may be expressed to one decimal point.
Total number of assignments and tests: 8
Total possible points: 100
LAST NAME First Name Hon Stret Address City Prv P/C A/C Phone STUDENT ID Average
Microsoft: Average equals Total Points divided by Total Possible Points
Ltr Grade
An-Chian Kao: Note that the GradeTable referred to in the formula in this column is the table of grades found at the top of this sheet.
GPA Quiz 1 Quiz 2 Report Memo Proposal Letter Midterm Quiz 3 Presentation Final
Microsoft: INSERT NEW COLUMNS TO THE LEFT TO ADD MORE ASSIGNMENTS OR TESTS.
1 Atwal Kulwinder Ms. 342 Dundas Street West Toronto ON L3B 5T5 416 222-9989 032556395 80% B- 2.67 4.2 4.0 12.5 11.6 14.7 4.1 8.4 20.6
2 Avigdor Noam Mr. 101 Signal Hill Road St. John's NF A1B 9A7 709 843-1147 031456985 71% C- 1.67 3.5 3.8 9.9 9.8 11.9 2.8 7.3 22.4
3 Berakett Leila Ms. #1503-852 Georgia Street Vancouver BC V6H 8Y7 604 662-0909 022365287 70% C- 1.67 4.9 2.8 10.2 10.2 16.0 2.5 7.0 16.0
4 Bouthillier Aimée Ms. 352 St. Mary Avenue Winnipeg MB R2R 1M8 204 543-0399 035478942 75% C 2.00 4.5 4.2 11.4 13.0 14.2 2.4 6.3 18.6
5 Bryce Shari Ms. 10045-100th Street Edmonton AB T5N 3J9 403 263-3117 031902531 80% B- 2.67 2.6 3.5 10.9 13.2 18.5 2.1 6.5 22.5
6 Chung Mitchell Mr. 352 St. Mary Avenue Winnipeg MB R2R 1M8 204 543-0397 011026503 70% C- 1.67 3.8 4.0 8.9 11.0 10.9 2.3 7.4 21.8
7 Cohen Sarah Ms. 10045-100th Street Edmonton AB T5N 3J9 403 263-3117 011005698 75% C 2.00 4.1 3.0 9.4 14.0 13.7 2.6 9.8 18.7
8 Concorde Roger Mr. 352 St. Mary Avenue Winnipeg MB R2R 1M8 204 543-0393 022800664 83% B 3.00 3.0 4.9 12.6 14.2 18.9 3.0 8.8 17.2
9 Gomes Franco Mr. 12641-73rd Avenue Surrey BC V4R 2S7 604 838-5877 024415026 71% C- 1.67 3.6 3.8 13.8 9.8 15.6 3.0 7.6 13.9
10 Greathall Deborah Ms. 23321-Captsone Drive Langley BC V5X 1R3 604 306-0998 017578410 74% C 2.00 4.1 3.0 10.5 10.9 13.0 2.8 5.6 24.0
11 Greene Rosalind Ms. 9999-2011th Street Langley BC V1V 0M0 604 444-4444 024025587 83% B 3.00 4.0 3.7 14.0 14.3 14.9 3.5 6.8 21.9
12 Hayakawa Pat Ms. 9999-2011th Street Langley BC V1V 0M0 604 444-4444 039669930 73% C 2.00 4.9 3.2 12.0 13.8 10.6 3.6 6.9 18.4
13 Hong Heather Ms. 9999-2011th Street Langley BC V1V 0M0 604 444-4412 022660127 75% C 2.00 3.5 4.3 11.9 12.7 18.7 3.4 8.4 12.3
14 Lembo Mariana Ms. 8888-2011th Street Langley BC V1V 0M0 604 444-4444 017845102 68% D+ 1.33 2.8 4.8 8.9 11.6 14.6 2.4 7.2 15.4
15 Methoulios Angelos Mr. 9999-2011th Street Langley BC V1V 0M0 604 444-8718 023205639 70% C- 1.67 4.8 4.2 8.4 8.4 17.0 2.7 7.3 17.1
16 Nabata Frank Mr. 9999-2011th Street Langley BC V1V 0M0 604 444-8718 033200521 68% D+ 1.33 3.6 3.8 11.6 10.8 16.9 3.7 6.4 11.6
17 Pleske Nicolas Mr. 5827 Dixie Road Mississauga ON L2J 2J2 519 998-2222 012647484 70% C- 1.67 4.1 2.2 13.0 7.5 18.2 3.8 5.8 15.6
18 Radescu Vlad Mr. 5827 Dixie Road Mississauga ON L2J 2J2 519 858-9990 035598689 69% D+ 1.33 3.7 3.8 10.7 12.8 11.5 3.8 6.0 16.2
19 Sacho Cal Mr. 5827 Dixie Road Mississauga ON L2J 2J2 519 998-9989 022630021 70% C- 1.67 4.0 2.5 11.8 11.1 16.3 3.9 5.9 14.9
20 Santini Flavio Mr. #1802-2889 Don Mills Road Toronto ON M4J 2L5 416 244-2534 033054007 75% C 2.00 3.0 4.5 9.8 10.0 17.5 4.0 7.4 18.9
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
Microsoft: INSERT NEW ROWS ABOVE THIS ROW TO ADD STUDENTS.

Microsoft: Average equals Total Points divided by Total Possible Points

An-Chian Kao: Note that the GradeTable referred to in the formula in this column is the table of grades found at the top of this sheet.
CLASS SUMMARY Average Ltr Grade GPA Quiz 1 Quiz 2 Report Memo Proposal Letter Midterm Quiz 3 Presentation Final
Average 73.50% C 1.95 4 4 11 12 15 3 7 18
Highest Score 83.00% B 3.00 5 5 14 14 19 4 10 24
Lowest Score 68.00% D+ 1.33 3 2 8 8 11 2 6 12

Enter each assignment or test and the points it is worth into the table below.

image1.jpeg

FraserRiverCollegeFinalMarksLetter.docx

D:\Docs\01-KUC-Current\3110\UserGuideAssignments\FraserRiverCollegeLogo.jpg Fraser River College

15389 Barnes Road Vancouver BC V4R 8N9

Tel: 604-588-9877 Fax: 604-488-7901 Email: [email protected]

web: http://www.fraserrivercollege.ca

Page 2 of 2

March 28, 2014

«Hon» «First_Name» «LAST_NAME»

«Stret_Address»

«City» «Prv» «PC»

Dear «Hon» «LAST_NAME»:

On behalf of Fraser River College, I am pleased to present your marks in completion of Communications 04 for the Fall term of 2003.

Quiz #1

«Quiz_1»

/05

Quiz #2

«Quiz_2»

/05

Report Memo

«Report_Memo»

/15

Proposal Letter

«Proposal_Letter»

/15

Midterm

«Midterm»

/20

Quiz #3

«Quiz_3»

/05

Presentation

«Presentation»

/10

Final

«Final»

/25

Total

«Average»

/100

«Ltr_Grade»

Letter Grade

«GPA»

GPA Score

It was a pleasure having you in class. I hope you found the course useful, and I’d like to extend my best wishes for your future endeavours.

Yours truly,

D:\Graphics\MDIsignBlue.jpg

David Ingre

image1.jpeg

image2.jpeg

MicrosoftAcademicGradebookTemplate.xltx

Gradebook

Use this gradebook to calculate grades where each assignment is worth a % of the final grade.
GRADE & GPA TABLE
Score 0% 60% 63% 67% 70% 73% 77% 80% 83% 87% 90% 93% 97%
Ltr Grade F D- D D+ C- C C+ B- B B+ A- A A+
GPA 0.00 0.67 1.00 1.33 1.67 2.00 2.33 2.67 3.00 3.33 3.67 4.00 4.00
Your School Name
Teacher Name
Class/Project Assignment or Test Name
Year/Semester/Quarter Percentage (must add up to 100%)
STUDENT NAME STUDENT ID Score
: Cumulative score equals the sum of each individual score times its percentage weight. The cumulative score and grade aren't valid until 100% of scores are in.
Ltr Grade
: Note that the GradeTable referred to in the formula in this column is the table of grades found at the top of this sheet.
GPA
: INSERT NEW COLUMNS TO THE LEFT TO ADD MORE ASSIGNMENTS OR TESTS.

: INSERT NEW ROWS ABOVE THIS ROW TO ADD STUDENTS.

: INSERT NEW COLUMNS TO THE LEFT TO ADD MORE ASSIGNMENTS OR TESTS.
CLASS SUMMARY Score Ltr Grade GPA
Average
Highest Score
Lowest Score

Enter each assignment or test and its percentage of the total grade into the table below.

Score, Ltr Grade and GPA are not valid until 100% of tests & assignments are complete.

image1.jpeg