Numeracy Skills Framework



Mathematics Stage 5 – Surface Area and Volume Excel CalculatorOutcomes AssessedMA5.1-2WM - selects and uses appropriate strategies to solve problemsMA5.1-8MG - calculates the areas of composite shapes, and the surface areas of rectangular and triangular prismsMA5.2-11MG - calculates the surface areas of right prisms, cylinders and related composite solidsMA5.2-12MG - applies formulas to calculate the volumes of composite solids composed of right prisms and cylindersMA5.3-13MG - applies formulas to find the surface areas of right pyramids, right cones, spheres and related composite solidsMA5.3-14MG - applies formulas to find the volumes of right pyramids, right cones, spheres and related composite solidsTask To create an excel spreadsheets to calculate the surface area and volume of the following solids give length, breadth and height etc.ALL calculations must use Excel formulas On separate Excel sheets you must create a calculator that will calculate the surface are and volume of the following solids, a 5.1 cube, rectangular prism,triangular prism with a right angled triangle as its base only (Note: you will need base and height measurements of the triangle, AND you will need to use Pythagoras Theorem to calculate the hypotenuse, as it is needed for the surface area)Label your three Excel sheets: cube, rectangular prism, triangular prism5.2triangular prism (Note: as above)open cylindera closed cylinderLabel your three Excel sheets: triangular prism, open cylinder, closed cylinder5.3 pyramid given a slant heightcone given the perpendicular heightLabel your two Excel sheets: pyramid, cone. See below a very simple layout for area and perimeter of a square81915153035Area and Perimeter of a squareType in your side length here8and the unit herecmIts area is 64squarecmIts perimeter is 32cm00Area and Perimeter of a squareType in your side length here8and the unit herecmIts area is 64squarecmIts perimeter is 32cmNOTE: 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 CriteriaPart ANB Test each with known dimensionsand answers 5.1CubeRectangular prismTriangular prismCorrect SA & VolumeCorrect SACorrect VolumeCorrect HypotenuseCorrect SACorrect Volume1111115.2Triangular prismOpen cylinderClosed cylinderCorrect HypotenuseCorrect SACorrect VolumeCorrect SACorrect VolumeCorrect SA, Correct Volume1111115.3Pyramid given slant heightCone given perp. heightCorrect SACorrect VolumeIncorrect Vol evidence Pythag ‘-‘ Correct SAIncorrect SA evidence Pythag ‘+‘ Correct Volume121211AllFormulas for units used twiceUsed twice1All‘square’ and ‘cubic’ used 1AllClarity of layout and Visual appeal1Sub - total /9 ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download