Produce and use spreadsheets for business

1. Produce and use spreadsheets for business

2. P&P3EL Printing P&P3EL Organising workbooks P&P3EL Using formulas P&P3EL Entering data P&P3EL Creating graphs P&P3EL Formatting data Produce and use spreadsheets for business Modules Topics Notional Hours 4 12 12 12 6 4 50 TE315 Entering data on a spreadsheet TE315 Using formulas in a spreadsheet TE315 Formatting data in a spreadsheet TE315 Creating graphs in a spreadsheet TE315 Organising workbooks TE315 Printing spreadsheets and graphs Total Notional Hours

3. Critical Cross-field Outcomes Identify and solve problems Work effectively with others Communicate effectively Organise and manage myself and my activities Collect, analyse, organise and critically evaluate information Use science and technology effectively and critically Demonstrate an understanding of the world as a set of related systems Use mathematics Learner and societal development US: EUC9 Produce and use spreadsheets for business TE315 Entering data on a spreadsheet Be able to undo changes Be able to enter, edit and remove data in a cell Be able to select multiple cells Be able to move around in a file Be able to open and save a file

4. Notional Hours 4 Topic Specification: TE315 Entering data on a spreadsheet Learning Activities Assignment Description Topic assessment criteria Use Multi media WHAT • The assessor will observe and confirm that learners: • Are able to open and save a file • Are able to move around in a file • Are able to select multiple cells • Are able to enter, edit and remove data in a cell • Are able to edit data in a cell • Are able to undo changes Attend a lecture and demonstration on how to enter data on a spreadsheet Self Study Plant investigation Collect Information Media search HOW Expert demonstration Attend lectures • Learners use examples to practice entering of data onto a spreadsheet • Given a prepared spreadsheet, learners have to demonstrate their ability to: • open and save a file • move around in a file • select multiple cells • enter, edit and remove data in a cell • undo changes Group Discussions Summarise Case studies Analyse, plan and make decisions Use checklists Develop recommendations Job assignment Make presentation Complete documents Execute, test and evaluate Draft a report Practical test

5. Critical Cross-field Outcomes Identify and solve problems Work effectively with others Communicate effectively Organise and manage myself and my activities Collect, analyse, organise and critically evaluate information Use science and technology effectively and critically Demonstrate an understanding of the world as a set of related systems Use mathematics Learner and societal development US: EUC9 Produce and use spreadsheets for business TE315 Using formulas in a spreadsheet Be able to create formulas with absolute and relative references Be able to edit cell contents and formulas Be able to name ranges Be able to create formulas using the function wizard Be able to create simple formulas Be able to total rows and columns automatically Understand the use of some typical formulas available in spreadsheets Understand the purpose of using formulas in spreadsheets

6. Notional Hours 12 Topic Specification: TE315 Using formulas in a spreadsheet Learning Activities Assignment Description Topic assessment criteria Use Multi media WHAT • The assessor will observe and confirm that learners: • Understand the purpose of using formulas in spreadsheets • Understand the use of some typical formulas available in spreadsheets • Are able to total rows and columns automatically • Are able to create simple formulas • Are able to create formulas using the function wizard • Are able to name ranges • Are able to edit cell contents and formulas • Are able to create formulas with absolute and relative references Attend a lecture and demonstration on how to use formulas in a spreadsheet. Self Study Plant investigation Collect Information Media search HOW Expert demonstration Attend lectures • Learners use examples to practice entering formulas on a spreadsheet • Given a prepared spreadsheet, learners have to demonstrate their ability to: • total rows and columns automatically • create simple formulas • name ranges • edit cell contents and formulas • create formulas with absolute and relative references Group Discussions Summarise Case studies Analyse, plan and make decisions Use checklists Develop recommendations Job assignment Make presentation Complete documents Execute, test and evaluate Draft a report Practical test

7. Critical Cross-field Outcomes Identify and solve problems Work effectively with others Communicate effectively Organise and manage myself and my activities Collect, analyse, organise and critically evaluate information Use science and technology effectively and critically Demonstrate an understanding of the world as a set of related systems Use mathematics Learner and societal development US: EUC9 Produce and use spreadsheets for business TE315 Formatting data in a spreadsheet Be able to add borders and colour Be able to change cell alignments Be able to change row heights and widths Be able to change fonts Be able to change number formats Be able to copy formats to other cells Be able to format data automatically Understand the purpose of formatting data and know the format options available in spreadsheets

8. Notional Hours 12 Topic Specification: TE315 Formatting data in a spreadsheet Learning Activities Assignment Description Topic assessment criteria Use Multi media WHAT • The assessor will observe and confirm that learners: • Understand the purpose of formatting data and know the format options available in spreadsheets • Are able to format data automatically • Are able to copy formats to other cells • Are able to change number formats • Are able to change fonts • Are able to change row heights and widths • Are able to change cell alignments • Are able to add borders and colour Attend a lecture and demonstration on how to format data in a spreadsheet. Self Study Plant investigation Collect Information Media search HOW Expert demonstration Attend lectures • Learners use examples to practice formatting data on a spreadsheet • Given unformatted data, learners have to demonstrate their ability to: • format data automatically • copy formats to other cells • change number formats • change fonts • change row heights and widths • change cell alignments • add borders and colour Group Discussions Summarise Case studies Analyse, plan and make decisions Use checklists Develop recommendations Job assignment Make presentation Complete documents Execute, test and evaluate Draft a report Practical test

9. Critical Cross-field Outcomes Identify and solve problems Work effectively with others Communicate effectively Organise and manage myself and my activities Collect, analyse, organise and critically evaluate information Use science and technology effectively and critically Demonstrate an understanding of the world as a set of related systems Use mathematics Learner and societal development US: EUC9 Produce and use spreadsheets for business TE315 Creating graphs in a spreadsheet Be able to add text boxes Be able to format charts Be able to add trend values Be able to add or delete gridlines and legends Be able to modify chart data Be able to create different types of simple charts Understand the purpose of creating graphs and know the different graph options available in spreadsheets

10. Notional Hours 12 Topic Specification: TE315 Creating graphs in a spreadsheet Learning Activities Assignment Description Topic assessment criteria Use Multi media WHAT • The assessor will observe and confirm that learners: • Understand the purpose of creating graphs and know the different graph options available in spreadsheets • Are able to create different types of simple charts • Are able to modify chart data • Are able to add or delete gridlines and legends • Are able to add trend values • Are able to format charts • Are able to add text boxes Attend a lecture and demonstration on how to create graphs in a spreadsheet. Self Study Plant investigation Collect Information Media search HOW Expert demonstration Attend lectures • Learners use examples to practice creating graphs on a spreadsheet • Given tabulated data, learners have to demonstrate their ability to: • create different types of simple charts • modify chart data • add or delete gridlines and legends • add trend values • format charts • add text boxes Group Discussions Summarise Case studies Analyse, plan and make decisions Use checklists Develop recommendations Job assignment Make presentation Complete documents Execute, test and evaluate Draft a report Practical test

11. Critical Cross-field Outcomes Identify and solve problems Work effectively with others Communicate effectively Organise and manage myself and my activities Collect, analyse, organise and critically evaluate information Use science and technology effectively and critically Demonstrate an understanding of the world as a set of related systems Use mathematics Learner and societal development US: EUC9 Produce and use spreadsheets for business TE315 Organising workbooks Be able to find files Be able to update summary information Be able to add, edit and delete cell notes Be able to copy and move sheets Understand basic principles along which workbooks should be organised

12. Notional Hours 6 Topic Specification: TE315 Organising workbooks Learning Activities Assignment Description Topic assessment criteria Use Multi media WHAT • The assessor will observe and confirm that learners: • Understand basic principles along which workbooks should be organised • Are able to copy and move sheets • Are able to add, edit and delete cell notes • Are able to update summary information • Are able to find files Attend a lecture and demonstration on how to organise workbooks. Self Study Plant investigation Collect Information Media search HOW Expert demonstration Attend lectures • Learners use examples to practice organising workbooks • Given unorganised data and workbooks, learners have to demonstrate their ability to: • move and copy data between different spreadsheets and workbooks • copy and move sheets • add, edit and delete cell notes • update summary information • find files Group Discussions Summarise Case studies Analyse, plan and make decisions Use checklists Develop recommendations Job assignment Make presentation Complete documents Execute, test and evaluate Draft a report Practical test

13. Critical Cross-field Outcomes Identify and solve problems Work effectively with others Communicate effectively Organise and manage myself and my activities Collect, analyse, organise and critically evaluate information Use science and technology effectively and critically Demonstrate an understanding of the world as a set of related systems Use mathematics Learner and societal development US: EUC9 Produce and use spreadsheets for business TE315 Printing spreadsheets and graphs Be able to print a graph Be able to print a worksheet Be able to add headers and footers Be able to set up pages Be able to preview a spreadsheet

14. Notional Hours 4 Topic Specification: TE315 Printing spreadsheets and graphs Learning Activities Assignment Description Topic assessment criteria Use Multi media WHAT • The assessor will observe and confirm that learners: • Are able to preview a spreadsheet • Are able to set up pages • Are able to add headers and footers • Are able to print a worksheet • Are able to print a graph Attend a lecture and demonstration on how to print spreadsheets and graphs Self Study Plant investigation Collect Information Media search HOW Expert demonstration Attend lectures • Learners use examples to practice printing spreadsheets and graphs • Using previously prepared data, learners have to demonstrate their ability to: • preview a spreadsheet • set up pages • add headers and footers • print a worksheet • print a graph Group Discussions Summarise Case studies Analyse, plan and make decisions Use checklists Develop recommendations Job assignment Make presentation Complete documents Execute, test and evaluate Draft a report Practical test