Amendment to Lesson eRecord 2008 Updated on 13 May 2008
“Term Summary” Worksheet (Cell “B22”) Please replace cell B22 with the following formula: ='Term 2-1'!C37+'Term 2-2'!C37+'Term 2-3'!C37+'Term 2-4'!C37+'Term 2-5'!C37+'Term 2-6'!C37+'Term 27'!C37+'Term 2-8'!C37+'Term 2-9'!C37+'Term 2-10'!C37
You may copy the above formula and paste it in cell B22.
“Term Summary” Worksheet (Cell “B41”) Please replace cell B41with the following formula: ='Term 3-1'!C37+'Term 3-2'!C37+'Term 3-3'!C37+'Term 3-4'!C37+'Term 3-5'!C37+'Term 3-6'!C37+'Term 37'!C37+'Term 3-8'!C37+'Term 3-9'!C37+'Term 3-10'!C37
You may copy the above formula and paste it in cell B41.
“Term Summary” Worksheet (Cell “B60”) Please replace cell B60 with the following formula: ='Term 4-1'!C37+'Term 4-2'!C37+'Term 4-3'!C37+'Term 4-4'!C37+'Term 4-5'!C37+'Term 4-6'!C37+'Term 47'!C37+'Term 4-8'!C37+'Term 4-9'!C37+'Term 4-10'!C37
You may copy the above formula and paste it in cell B60.
“Term Summary” Worksheet (Cell “B61” to “B67”)
}
Please replace cell B61 with the following formula: ='Term 4-1'!G18+'Term 4-2'!G18+'Term 4-3'!G18+'Term 4-4'!G18+'Term 4-5'!G18+'Term 4-6'!G18+'Term 47'!G18+'Term 4-8'!G18+'Term 4-9'!G18+'Term 4-10'!G18
You may copy the above formula and paste it in cell B61. Next, copy cell “B61” and paste onto cells “B62”, “B63”, “B64”, “B65”, “B66” & “B67”.
“Term Summary” Worksheet (Cell “D61” to “D67”)
}
Please replace cell D61 with the following formula: ='Term 4-1'!Q18+'Term 4-2'!Q18+'Term 4-3'!Q18+'Term 4-4'!Q18+'Term 4-5'!Q18+'Term 4-6'!Q18+'Term 47'!Q18+'Term 4-8'!Q18+'Term 4-9'!Q18+'Term 4-10'!Q18
You may copy the above formula and paste it in cell D61. Next, copy cell “D61” and paste onto cells “D62”, “D63”, “D64”, “D65”, “D66” & “D67”.
“Overall Summary” Worksheet (Cell “B15”) Please replace cell B15 with the following formula: ='Term Summary'!B14+'Term Summary'!B52
You may copy the above formula and paste it in cell B15.
That’s all Folks!