Spreadsheet: 600094d1543461222-enter-data-based-on-2-different-cells-2-columns-different-sheets-grading-excel-form
Sheet: Sheet5

 |  |  | Term 1 |  |  |  |  |  |  | T1 AVERAGE | Term 2 |  |  |  |  |  |  | [NAME] | Term 3 |  |  |  |  |  | T3 AVERAGE | Term 4 (80% specializations 20% [NAME]) |  |  |  |  |  | T4 AVERAGE | Term 6 |  |  |  |  | T6 Average | PROGRAM AVERAGE
First name | Surname | Email address | [NAME]. | Directing | PD | Post Production | Producing | [NAME] | AD |  | [NAME]. | Directing | PD | Post Production | Producing | [NAME] | AD |  | Directing | PD | Post Production | Producing | [NAME] | AD |  | Directing | PD | Post Production | Producing | [NAME] | [NAME] |  | Directing | PD | Post Production | Producing | [NAME]
[NAME] ([NAME]) | [NAME] | [EMAIL] |  |  |  |  |  |  |  |  |  |  |  | 90 |  |  |  |  |  |  | 85 |  |  |  |  |  | - | 76 |  | 0
Qiran ([NAME]) | [NAME] | [EMAIL] |  |  |  |  |  |  |  |  |  |  |  | 87 |  |  |  |  |  |  | 65 |  |  |  |  |  | - | 45 |  | 0
Muxin | [NAME] | [EMAIL] |  |  |  |  |  |  |  |  |  |  |  | 61 |  |  |  |  |  |  | 65 |  |  |  |  |  | 77 | - |  | 0
[NAME] ([NAME]) | [NAME] | [EMAIL] |  |  |  |  |  |  |  |  |  |  |  | 75 |  |  |  |  |  |  | 65 |  |  |  |  |  | - | - | 76.43 | 0
Yiming ([NAME]) | [NAME] | [EMAIL] |  |  |  |  |  |  |  |  |  |  |  | 74 |  |  |  |  |  |  | 84 |  |  |  |  |  | 69 | - | 82.14 | 0
[NAME] ([NAME]) | Fang | [EMAIL] |  |  |  |  |  |  |  |  |  |  |  | 83 |  |  |  |  |  |  | 65 |  |  |  |  |  | - | - | 82.14 | 0
Qianyun (Fay) | Fang | [EMAIL] |  |  |  |  |  |  |  |  |  |  |  | 84 |  |  |  |  |  |  | 86 |  |  |  |  |  | 0 | 89 |  | 0
Yichao | Fu | [EMAIL] |  |  |  |  |  |  |  | N/A |  |  |  | 75 |  |  |  |  |  |  | 86 |  |  |  |  |  | - | 76 |  | 0
Junjie (Riol) | He | [EMAIL] |  |  |  |  |  |  |  |  |  |  |  | 84 |  |  |  |  |  |  | 89 |  |  |  |  |  | 0 | - |  | 95.5
Jiaqing (Agnes) | Kang | [EMAIL] |  |  |  |  |  |  |  |  |  |  |  | 76 |  |  |  |  |  |  | 78 |  |  |  |  |  | - | 83 |  | 0
Yuetong (Isabel) | [NAME] | [EMAIL] |  |  |  |  |  |  |  |  |  |  |  | 90 |  |  |  |  |  |  | 87 |  |  |  |  |  | 0 | 73 | 100 | 0
[NAME]) | [NAME] | [NAME] |  |  |  |  |  |  |  |  |  |  |  | na |  |  |  |  |  |  | 65 |  |  |  |  |  | 0 | - |  | 67.86
[NAME] (Klader) | [NAME] | [EMAIL] |  |  |  |  |  |  |  |  |  |  |  | 94 |  |  |  |  |  |  | 95 |  |  |  |  |  | 88 | - |  | 0
Ruimin (Vic) | [NAME] | [EMAIL] |  |  |  |  |  |  |  |  |  |  |  | 32 |  |  |  |  |  |  | 40 |  |  |  |  |  | - | - |  | 70
[NAME]) | [NAME] | [EMAIL] |  |  |  |  |  |  |  |  |  |  |  | 72 |  |  |  |  |  |  | 65 |  |  |  |  |  | - | - |  | 85
[NAME]Seven ） | Qi | [EMAIL] |  |  |  |  |  |  |  |  |  |  |  | 34 |  |  |  |  |  |  | 40 |  |  |  |  |  | 80 | - |  | 95.5
Junqi (Voang) | [NAME] | [EMAIL] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 65 |  |  |  |  |  | 0 | - |  | 0
[NAME]） | Xiao | [EMAIL] |  |  |  |  |  |  |  |  |  |  |  | 90 |  |  |  |  |  |  | 85 |  |  |  |  |  | - | - |  | 79.79
[NAME] (Leo) | [NAME] | [EMAIL] |  |  |  |  |  |  |  |  |  |  |  | 49 |  |  |  |  |  |  | 54 |  |  |  |  |  | - | - |  | 70
Chenyi (Freddie) | Zhang | [EMAIL] |  |  |  |  |  |  |  |  |  |  |  | 79 |  |  |  |  |  |  | 83 |  |  |  |  |  | - | 78 |  | 0
Linfeng (Wayne) | Zhang | [EMAIL] |  |  |  |  |  |  |  |  |  |  |  | 73 |  |  |  |  |  |  | 82 |  |  |  |  |  | 0 | - |  | 100
[NAME] (Vlad) | [NAME] | [EMAIL] |  |  |  |  |  |  |  |  |  |  |  | 95 |  |  |  |  |  |  | 88 |  |  |  |  |  | - | - |  | 89.5
Xinwei (Will) | [NAME] | [EMAIL] |  |  |  |  |  |  |  |  |  |  |  | 87 |  |  |  |  |  |  | 87 |  |  |  |  |  | - | - |  | 98.57
Hui ([NAME]) | Zhu | [EMAIL] |  |  |  |  |  |  |  |  |  |  |  | 61 |  |  |  |  |  |  | 65 |  |  |  |  |  | - | - | 79.29 | 0