NOTE: Check your answers carefully using examples from your textbook, as spreadsheet calculators that do not work will not be awarded marks for being ‘close’. Stage 5 Surface Area and Volume Excel Calculator Marking Criteria – Part A NB Test each with known and answers dimensions 5.1 Cube Correct SA & Volume 1 Rectangular prism Correct SA 1 Correct Volume 1 Correct Hypotenuse 1 Triangular prism Correct SA 1 Correct Volume 1 5.2 Triangular prism Correct Hypotenuse 1 Correct SA 1 Correct Volume 1 Correct SA 1 Open cylinder Correct Volume 1 Correct SA, Correct Volume 1 Closed cylinder 5.3 Pyramid given slant height Correct SA 1 Correct Volume 2 Incorrect Vol evidence 1 Pythag ‘-‘ 2 Cone given perp. height Correct SA 1
NOTE: Check your answers carefully using examples from your textbook, as spreadsheet calculators that do not work will not be awarded marks for being ‘close’. Stage 5 – Surface Area and Volume Excel Calculator Marking Criteria Part A NB Test each with known dimensions and answers 5.1 Cube Rectangular prism Triangular prism Correct SA & Volume Correct SA Correct Volume Correct Hypotenuse Correct SA Correct Volume 1 1 1 1 1 1 5.2 Triangular prism Open cylinder Closed cylinder Correct Hypotenuse Correct SA Correct Volume Correct SA Correct Volume Correct SA, Correct Volume 1 1 1 1 1 1 5.3 Pyramid given slant height Cone given perp. height Correct SA Correct Volume Incorrect Vol evidence Pythag ‘-‘ Correct SA 1 2 1 2 1
Excel_Calculator-Surface_Area_and_Volume.docx