Spreadsheet: 600097d1543463487-enter-data-based-on-2-different-cells-2-columns-different-sheets-grading-excel-form
Sheet: T2

 | Directing |  |  |  |  | Producing |  |  |  |  | Production Design |  |  |  |  | Post Production |  |  |  |  | Cinematography |  |  |  |  | Production Techniques |  |  |  |  | Story Development |  |  |  |  | Assistant Directing
Term 2 | Present | Late | Excused | Absent | % Absent | Present | Late | Excused | Absent | % Absent | Present | Late | Excused | Absent | % Absent | Present | Late | Excused | Absent | % Absent | Present | Late | Excused | Absent | % Absent | Present | Late | Excused | Absent |  | Present | Late | Excused | Absent | % Absent | Present | Late | Excused | Absent | % Absent | Total P | Total L | Total E | Total A
Hui ([NAME]) Zhu | 9 |  |  |  |  | 5 | 2 |  |  |  | 7 |  |  |  |  | 4 | 2 |  | 1 |  | 7 |  |  |  |  |  |  |  |  |  | 7 |  |  |  |  | 5 |  | 1
Qiran ([NAME]) Chen | 7 | 1 | 1 |  |  | 4 | 2 |  | 1 |  | 2 | 2 | 1 | 2 |  | 6 |  |  | 1 |  | 3 | 1 |  | 3 |  |  |  |  |  |  | 6 |  |  | 1 |  | 5 |  | 1
[NAME] ([NAME]) [NAME] | 9 |  |  |  |  | 7 |  |  |  |  | 7 |  |  |  |  | 7 |  |  |  |  | 7 |  |  |  |  |  |  |  |  |  | 7 |  |  |  |  | 6
Yuetong (Isabel) [NAME] | 9 |  |  |  |  | 6 | 1 |  |  |  | 7 |  |  |  |  | 6 |  | 1 |  |  | 6 |  |  | 1 |  |  |  |  |  |  | 6 |  |  | 1 |  | 4 |  | 2
[NAME] (Vlad) [NAME] | 9 |  |  |  |  | 7 |  |  |  |  | 7 |  |  |  |  | 7 |  |  |  |  | 7 |  |  |  |  |  |  |  |  |  | 6 |  |  | 1 |  | 6
Chenbo ([NAME]) Xiao | 6 | 3 |  |  |  | 5 | 1 |  | 1 |  | 6 | 1 |  |  |  | 6 | 1 |  |  |  | 6 |  |  | 1 |  |  |  |  |  |  | 6 |  |  | 1 |  | 5 | 1
[NAME]) Lu | 7 |  |  | 2 |  | 3 | 4 |  |  |  | 6 | 1 |  |  |  | 7 |  |  |  |  | 5 |  |  | 2 |  |  |  |  |  |  | 6 |  |  | 1 |  | 3 | 2 |  | 1
Chenyi (Freddie) Zhang | 8 |  | 1 |  |  | 5 | 1 |  | 1 |  | 5 | 1 | 1 |  |  | 7 |  |  |  |  | 7 |  |  |  |  |  |  |  |  |  | 5 |  | 1 | 1 |  | 4 |  | 2
[NAME] ([NAME]) Fang | 8 |  |  | 1 |  | 5 | 2 |  |  |  | 7 |  |  |  |  | 6 | 1 |  |  |  | 7 |  |  |  |  |  |  |  |  |  | 7 |  |  |  |  | 6
Jiaqing (Agnes) Kang | 5 |  | 1 | 3 |  | 5 | 0 | 2 |  |  | 5 | 1 | 1 |  |  | 6 |  | 1 |  |  | 5 |  |  | 2 |  |  |  |  |  |  | 4 |  | 2 | 1 |  | 4 |  | 1 | 1
[NAME] | 4 | 1 | 2 | 2 |  | 3 | 0 | 1 | 3 |  | 5 | 1 |  | 1 |  | 2 | 3 |  | 2 |  | 5 |  |  | 2 |  |  |  |  |  |  | 3 | 1 | 1 | 2 |  | 1 | 1 | 1 | 3
Junjie (Riol) He | 9 |  |  |  |  | 7 |  | 0 |  |  | 7 |  |  |  |  | 7 |  |  |  |  | 7 |  |  |  |  |  |  |  |  |  | 6 |  |  | 1 |  | 6
Junqi (Eden) [NAME] | 9 |  |  |  |  | 7 |  |  |  |  | 7 |  |  |  |  | 7 |  |  |  |  | 7 |  |  |  |  |  |  |  |  |  | 6 |  |  | 1 |  | 6
Linfeng (Wayne) Zhang | 8 | 1 |  |  |  | 7 |  |  |  |  | 7 |  |  |  |  | 6 | 1 |  |  |  | 7 |  |  |  |  |  |  |  |  |  | 7 |  |  |  |  | 6
Muxin ([NAME]) [NAME] | 4 | 1 |  | 4 |  | 5 | 1 | 1 |  |  | 5 | 1 |  | 1 |  | 5 | 1 |  | 1 |  | 4 | 1 |  | 2 |  |  |  |  |  |  | 7 |  |  |  |  | 0 | 3 | 0 | 3
Qianyun (Fay) Fang | 9 |  |  |  |  | 7 |  |  |  |  | 6 | 1 |  |  |  | 6 |  | 1 |  |  | 7 |  |  |  |  |  |  |  |  |  | 7 |  |  |  |  | 6
Ruimin (Vic) [NAME] | 6 |  | 3 |  |  | 5 | 1 | 1 |  |  | 4 |  | 3 |  |  | 7 |  |  |  |  | 7 |  |  |  |  |  |  |  |  |  | 6 |  |  | 1 |  | 6
[NAME] ([NAME]) [NAME] | 9 |  |  |  |  | 7 |  |  |  |  | 6 |  |  | 1 |  | 7 |  |  |  |  | 7 |  |  |  |  |  |  |  |  |  | 6 |  |  | 1 |  | 5 |  | 1
Xiaochen (Seven) Qi | 8 |  | 1 |  |  | 4 | 3 |  |  |  | 6 |  |  | 1 |  | 4 | 2 |  | 1 |  | 7 |  |  |  |  |  |  |  |  |  | 7 |  |  |  |  | 6
[NAME] (Leo) Yu | 8 |  |  | 1 |  | 6 |  | 1 |  |  | 5 | 2 |  |  |  | 5 |  | 1 | 1 |  | 6 |  |  | 1 |  |  |  |  |  |  | 5 |  |  | 2 |  | 6
[NAME] ([NAME]) [NAME] | 8 |  | 1 |  |  | 6 | 1 |  |  |  | 6 | 1 |  |  |  | 7 |  |  |  |  | 7 |  |  |  |  |  |  |  |  |  | 7 |  |  |  |  | 6
Xinwei (Will) [NAME] | 9 |  |  |  |  | 7 |  |  |  |  | 7 |  |  |  |  | 7 |  |  |  |  | 7 |  |  |  |  |  |  |  |  |  | 7 |  |  |  |  | 6
[NAME] ([NAME]) Fu | 9 | 1 |  |  |  | 6 |  | 1 |  |  | 7 |  |  |  |  | 6 |  |  | 1 |  | 5 |  | 1 | 1 |  |  |  |  |  |  | 5 |  | 1 | 1 |  | 6
Yiming ([NAME]) Deng | 8 | 1 |  |  |  | 5 | 1 |  | 1 |  | 6 |  |  | 1 |  | 5 | 1 |  | 1 |  | 6 |  |  | 1 |  |  |  |  |  |  | 6 |  |  | 1 |  | 3 |  | 1 | 2
[NAME] ([NAME]) [NAME] | 3 | 1 | 5 |  |  | 2 | 4 | 1 |  |  | 5 | 1 | 1 |  |  | 1 | 3 | 3 |  |  | 6 |  |  | 1 |  |  |  |  |  |  | 3 | 2 | 1 | 1 |  | 4 |  | 2