Proposed Marking Scheme for 5.1/5.2 Cover my Floors Student Name Marks Report Floorplan with targeted 2 Floorplan OR Floorplan with at most 2 targeted rooms missing 1 (4marks) Missing dimensions included with appropriate approximations 1 coverings indicated 1 Presentation All Pictures included with per square metre Or prices per square 2 metre may be in paragraph. (4 marks) Or if one missing 1 Animations included 1 Organisation, sequencing , Headings, relevance 1 Paragraph Justification for all floor coverings(only colour is not a reason) 2 (2marks) Justification for two floor coverings 1 Sub - total /10 Excel Activities Floorplan 1 Floorplan(sh1) Heading centred, renamed tab 1 activity Measurements and floor coverings put in appropriate cells as per 1 floor plan. (sheet 2) Marking for 4 Columns (a, b, c, d) (7 formulas) Correct first line 1 Correct fill for rest OR 1 All correct with additional room (7 formulas) 2 If 2-6 correct formulas 1 Note: If only values no formulas just one mark for all of a, b, c, d a) Area of rooms in sq m /2 b) Cost of coverings $/sq m /2 c) Cost of Installation of rooms /2 d)Total cost per room /2 Autosum or otherwise used to calculate the totals of a, b, c, d above 2 Or if two correct or only correct values no formula (e, f, g, h) 1 Saving with correct formula 2 Or correct numerical amount without formula 1 Average cost per sq m with correct formula 1 Q1 CFPA read from total cost of installation total 1 Q2 Interpret savings correctly 1 Q3 Explanation of ample saving or appropriate example /2 (vague 1 marks, detailed with examples included 2 marks) Sub - total /20 Total /30 Comment (Include lateness) ………………………………………
Proposed Marking Scheme for 5.1/5.2 Cover my Floors Student Name Marks Report Floorplan (4marks) Floorplan with targeted OR Floorplan with at most 2 targeted rooms missing Missing dimensions included with appropriate approximations coverings indicated 2 1 1 1 Presentation (4 marks) All Pictures included with per square metre Or prices per square metre may be in paragraph. Or if one missing Animations included Organisation, sequencing , Headings, relevance 2 1 1 1 Paragraph (2marks) Justification for all floor coverings(only colour is not a reason) Justification for two floor coverings 2 1 Sub - total /10 Excel Activities Floorplan(sh1) Floorplan Heading centred, renamed tab 1 1 activity (sheet 2) Measurements and floor coverings put in appropriate cells as per floor plan. 1 Marking for 4 Columns (a, b, c, d) (7 formulas) Correct first line Correct fill for rest OR All correct with additional room (7 formulas) If 2-6 correct formulas Note: If only values no formulas just one mark for all of a, b, c, d 1 1 2 1 a) Area of rooms in sq m /2 b) Cost of coverings $/sq m /2 c) Cost of Installation of rooms /2 d)Total cost per room /2 Autosum or otherwise used to calculate the totals of a, b, c, d above Or if two correct or only correct values no formula (e, f, g, h) 2 1 Saving with correct formula Or correct numerical amount without formula 2 1 Average cost per sq m with correct formula 1 Q1 CFPA read from total cost of installation total 1 Q2 Interpret savings correctly 1 Q3 Explanation of ample saving or appropriate example (vague 1 marks, detailed with examples included 2 marks) /2 Sub - total /20 Total /30 Comment (Include lateness) ………………………………………
Cover_my_floors.docx