Rainhill HigH SCHOOL media arts college Year 9 BTEC First Information and creative technology Half-term 1 This half term I will learn: Key Terms I will learn this half term are: the uses of spreadsheets and the features available in Accuracy spreadsheet software packages. Data how to design a spreadsheet. Data Sets Formatting Model Half-termly assessments will be: Modelling Productivity Spreadsheet model will be assessed against course BTEC criteria. Recalculation Usability Learning Outcomes Homework Week 1 & 2 I will be able to: – Revise for is a “What demonstrate an understanding of why spreadsheets are spreadsheet?” used in the real world. assessment at the improve productivity and accuracy end of week two. support decision making (e.g. scenario modelling, goal seek, regression and Research which data mining) professions use present information spreadsheets and analyse data identify common perform calculations uses for manipulate large datasets spreadsheets. Create demonstrate an understanding of where spreadsheets are a simple poster to used in the real world. explain this cost modelling information. analysis of data tracking progress and recording results creating timetables and results stock control Week 3 & 4 I will be able to: –
Rainhill HigH SCHOOL media arts college Year 9 BTEC First Information and creative technology Half-term 1 This half term I will learn: the uses of spreadsheets and the features available in spreadsheet software packages. how to design a spreadsheet. Half-termly assessments will be: Spreadsheet model will be assessed against course BTEC criteria. Key Terms I will learn this half term are: Accuracy Data Data Sets Formatting Model Modelling Productivity Recalculation Usability Learning Outcomes Homework Week 1 & 2 – I will be able to: demonstrate an understanding of why spreadsheets are used in the real world. improve productivity and accuracy support decision making (e.g. scenario modelling, goal seek, regression and data mining) present information analyse data perform calculations manipulate large datasets demonstrate an understanding of where spreadsheets are used in the real world. cost modelling analysis of data tracking progress and recording results creating timetables and results stock control Revise for “What is a spreadsheet?” assessment at the end of week two. Research which professions use spreadsheets and identify common uses for spreadsheets. Create a simple poster to explain this information. Week 3 & 4 – I will be able to:
Y9-HT1-ICT-BTEC.docx