Curriculum
- 10 Sections
- 41 Lessons
- 10 Weeks
Expand all sectionsCollapse all sections
- Read InstructionsPlease read instructions below1
- Session OnePREPARE AND PRODUCE A SPREADSHEET TO PROVIDE A SOLUTION TO A GIVEN PROBLEM.4
- Session TwoADJUST SETTINGS TO CUSTOMISE THE VIEW AND PREFERENCES OF THE SPREADSHEET APPLICATION TO SUITE THE SOLUTION CREATED FOR THE GIVEN PROBLEM.8
- 3.1Toolbar menus are switched off and on. – Copy30 Minutes
- 3.2The view of the spreadsheet is enlarged and made smaller. – Copy30 Minutes
- 3.3The way that the spreadsheet is viewed is changed. – Copy30 Minutes
- 3.4Cells are frozen to prevent scrolling. – Copy30 Minutes
- 3.5The default file location is changed. – Copy30 Minutes
- 3.6A user name is added to the file. – Copy1 Hour
- 3.7Excel Int Session 2 – 201330 Minutes
- 3.8Excel 2 Quiz 2 – Copy30 Minutes0 Questions
- Session ThreeWORK WITH MULTIPLE WORKSHEETS TO SUITE THE SOLUTION TO THE GIVEN PROBLEM.7
- 4.1The purpose of using multiple worksheets within one spreadsheet file are explained with examples. – Copy30 Minutes
- 4.2New worksheets are opened. (Minimum 3 worksheets) – Copy30 Minutes
- 4.3Worksheets are renamed in terms of their purpose within the solution to the given problem. – Copy30 Minutes
- 4.4Cells are manipulated between worksheets. – Copy30 Minutes
- 4.5A worksheet within a workbook (or spreadsheet) is deleted. – Copy30 Minutes
- 4.6Excel Int Session 3 – 201330 Minutes
- 4.7Excel 2 Quiz 3 – Copy30 Minutes0 Questions
- Session FourAPPLY FORMULAE TO WORKSHEETS TO PROVIDE ALTERNATIVE SOLUTIONS TO THE GIVEN PROBLEM.8
- 5.1Formulae are entered taking into consideration the natural order of operation. – Copy30 Minutes
- 5.2Formulae are entered to deliberately change the natural order of operation. – Copy30 Minutes
- 5.3Formula error messages are correctly interpreted and the formula corrected accordingly. – Copy30 Minutes
- 5.4The difference between relative and absolute cell addressing is demonstrated by using it in a formula. – Copy30 Minutes
- 5.5Data are changed to test possible solutions to the given problem without having to change formulae. – Copy30 Minutes
- 5.6Scenarios are created that demonstrate different possible outcomes. – Copy30 Minutes
- 5.7Excel Int Session 4 – 201330 Minutes
- 5.8Excel 2 Quiz 4 – Copy30 Minutes0 Questions
- Session FiveAPPLY SIMPLE BUILT-IN FUNCTIONS OF THE SPREADSHEET APPLICATION TO THE GIVEN PROBLEM.5
- 6.1Functions are explained in terms of their purpose, use and construct. – Copy30 Minutes
- 6.2Simple Mathematical functions are applied to the given problem. – Copy30 Minutes
- 6.3Statistical functions are applied that achieve the anticipated result. – Copy30 Minutes
- 6.4Excel Int Session 5 – 201330 Minutes
- 6.5Excel 2 Quiz 5 – Copy30 Minutes0 Questions
- Session SixAPPLY FORMATTING TO A SPREADSHEET APPLICABLE TO THE GIVEN PROBLEM.6
- 7.1Methods of automatically formatting a spreadsheet are explained. – Copy30 Minutes
- 7.2A spreadsheet is created using a template. – Copy1 Hour
- 7.3Cells are formatted using styles. – Copy30 Minutes
- 7.4Formats are copied between cells. – Copy30 Minutes
- 7.5Excel Int Session 6 – 201330 Minutes
- 7.6Excel 2 Quiz 6 – Copy30 Minutes0 Questions
- Session SevenUSE SPECIAL EFFECTS TO IMPROVE THE PRESENTATION OF THE SPREADSHEET.6
- 8.1Text is centered across a cell range. – Copy30 Minutes
- 8.2Orientation of text within a cell is changed. – Copy30 Minutes
- 8.3A border is applied to cells and removed from cells. – Copy1 Hour
- 8.4Fill (shading) is applied to cells and removed from cells. – Copy30 Minutes
- 8.5Excel Int Session 7 – 201330 Minutes
- 8.6Excel 2 Quiz 7 – Copy30 Minutes0 Questions
- Session EightEVALUATE A SPREADSHEET TO COMPLY WITH THE GIVEN PROBLEM.4
- 9.1The spreadsheet is evaluated for compliance with a given problem, appropriate formatting, readability, legibility, presentation, accuracy, and data integrity. – Copy30 Minutes
- 9.2The spreadsheet is modified if required and compliance with the brief is confirmed. – Copy30 Minutes
- 9.3Excel Int Session 8 – 201330 Minutes
- 9.4Excel 2 Quiz 8 – Copy30 Minutes0 Questions
- Excel Intermediate Portfolio of Evidence (POE)1
