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

 | Directing |  |  |  |  | Producing |  |  |  |  | Production Design |  |  |  |  | Post Production |  |  |  |  | Cinematography |  |  |  |  | Production Techniques |  |  |  |  | Story Development |  |  |  |  | Assistant Directing
TERM 1 | 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 | 6 | 1 |  |  |  | 7 |  |  |  |  | 6 |  | 1 |  |  | 7 |  |  |  |  | 7 |  |  |  |  |  |  |  |  |  | 4 | 3 |  |  |  | 5 |  |  | 1
Qiran ([NAME]) Chen | 7 |  |  |  |  | 6 | 1 |  |  |  | 7 |  |  |  |  | 7 |  |  |  |  | 6 |  |  | 1 |  |  |  |  |  |  | 6 |  |  | 1 |  | 4 |  | 2
[NAME] ([NAME]) [NAME] | 7 |  |  |  |  | 7 |  |  |  |  | 7 |  |  |  |  | 7 |  |  |  |  | 7 |  |  |  |  |  |  |  |  |  | 7 |  |  |  |  | 6
Yuetong (Isabel) [NAME] | 7 |  |  |  |  | 7 |  |  |  |  | 6 |  |  | 1 |  | 6 | 1 |  |  |  | 7 |  |  |  |  |  |  |  |  |  | 6 |  | 1 |  |  | 6
[NAME] (Vlad) [NAME] | 7 |  |  |  |  | 7 |  |  |  |  | 7 |  |  |  |  | 6 |  |  | 1 |  | 7 |  |  |  |  |  |  |  |  |  | 7 |  |  |  |  | 6
Chenbo ([NAME]) Xiao | 4 | 2 |  | 1 |  | 7 |  |  |  |  | 7 |  |  |  |  | 6 |  |  | 1 |  | 7 |  |  |  |  |  |  |  |  |  | 6 | 1 |  |  |  | 6
[NAME]) Lu | 5 |  |  | 2 |  | 4 | 1 |  | 2 |  | 5 |  |  | 2 |  | 5 | 2 |  |  |  | 5 |  |  | 2 |  |  |  |  |  |  | 2 | 3 |  | 2 |  | 6
Chenyi (Freddie) Zhang | 4 |  |  |  |  | 5 |  | 2 |  |  | 7 |  |  |  |  | 5 | 2 |  |  |  | 7 |  |  |  |  |  |  |  |  |  | 7 |  |  |  |  | 2 | 3 |  | 1
[NAME] ([NAME]) Fang | 7 |  |  |  |  | 7 |  |  |  |  | 7 |  |  |  |  | 7 |  |  |  |  | 7 |  |  |  |  |  |  |  |  |  | 6 |  |  | 1 |  | 3 |  | 1
Jiaqing (Agnes) Kang | 6 |  | 1 |  |  | 7 |  |  |  |  | 7 |  |  |  |  | 6 | 1 |  |  |  | 7 |  |  |  |  |  |  |  |  |  | 6 | 1 |  |  |  | 6
[NAME] | 2 | 1 | 1 | 1 |  | 4 |  | 3 |  |  | 7 |  |  |  |  | 5 | 2 |  |  |  | 7 |  |  |  |  |  |  |  |  |  | 3 | 1 | 1 | 2 |  | 5 |  | 1
Junjie (Riol) He | 7 |  |  |  |  | 7 |  |  |  |  | 7 |  |  |  |  | 7 |  |  |  |  | 7 |  |  |  |  |  |  |  |  |  | 7 |  |  |  |  | 6
Junqi (Eden) [NAME] | 7 |  |  |  |  | 7 |  |  |  |  | 6 | 1 |  |  |  | 7 |  |  |  |  | 7 |  |  |  |  |  |  |  |  |  | 7 |  |  |  |  | 6
Linfeng (Wayne) Zhang | 7 |  |  |  |  | 7 |  |  |  |  | 7 |  |  |  |  | 7 |  |  |  |  | 7 |  |  |  |  |  |  |  |  |  | 7 |  |  |  |  | 6
Muxin ([NAME]) [NAME] | 5 | 1 |  |  |  | 5 |  | 2 |  |  | 7 |  |  |  |  | 5 | 2 |  |  |  | 7 |  |  |  |  |  |  |  |  |  | 6 |  | 1 |  |  | 4 | 1
Qianyun (Fay) Fang | 7 |  |  |  |  | 7 |  |  |  |  | 7 |  |  |  |  | 7 |  |  |  |  | 7 |  |  |  |  |  |  |  |  |  | 6 |  |  | 1 |  | 6
Ruimin (Vic) [NAME] | 5 |  | 2 |  |  | 6 |  | 1 |  |  | 7 |  |  |  |  | 6 | 1 |  |  |  | 7 |  |  |  |  |  |  |  |  |  | 7 |  |  |  |  | 5 |  | 1
[NAME] ([NAME]) [NAME] | 7 |  |  |  |  | 7 |  |  |  |  | 7 |  |  |  |  | 7 |  |  |  |  | 7 |  |  |  |  |  |  |  |  |  | 7 |  |  |  |  | 6
Xiaochen (Seven) Qi | 5 | 1 | 1 |  |  | 6 |  | 1 |  |  | 5 | 1 | 1 |  |  | 6 | 1 |  |  |  | 6 |  |  | 1 |  |  |  |  |  |  | 5 | 2 |  |  |  | 5 |  |  | 1
[NAME] (Leo) Yu | 7 |  |  |  |  | 7 |  |  |  |  | 6 |  | 1 |  |  | 6 | 1 |  |  |  | 7 |  |  |  |  |  |  |  |  |  | 5 | 1 |  | 1 |  | 5 | 1
[NAME] ([NAME]) [NAME] | 7 |  |  |  |  | 7 |  |  |  |  | 7 |  |  |  |  | 7 |  |  |  |  | 7 |  |  |  |  |  |  |  |  |  | 7 |  |  |  |  | 5 |  | 1
Xinwei (Will) [NAME] | 7 |  |  |  |  | 7 |  |  |  |  | 7 |  |  |  |  | 7 |  |  |  |  | 7 |  |  |  |  |  |  |  |  |  | 7 |  |  |  |  | 6
[NAME] ([NAME]) Fu | 1 |  | 5 |  |  |  |  | 7 |  |  | 1 |  | 6 | 0 |  |  |  | 7 |  |  |  |  | 7 |  |  |  |  |  |  |  |  |  | 7 |  |  |  |  | 6
Yiming ([NAME]) Deng | 4 | 1 | 1 | 1 |  | 6 |  | 1 |  |  | 6 |  | 1 |  |  | 7 |  |  |  |  | 7 |  |  |  |  |  |  |  |  |  | 7 |  |  |  |  | 5 |  |  | 1
[NAME] ([NAME]) [NAME] | 5 | 2 |  |  |  | 5 | 1 | 1 |  |  | 6 | 1 |  |  |  | 2 | 5 |  |  |  | 4 | 3 |  |  |  |  |  |  |  |  | 6 | 1 |  |  |  | 4 | 2