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 on30 Minutes
- 3.2The view of the spreadsheet is enlarged and made smaller30 Minutes
- 3.3The way that the spreadsheet is viewed is changed30 Minutes
- 3.4Cells are frozen to prevent scrolling30 Minutes
- 3.5The default file location is changed30 Minutes
- 3.6A user name is added to the file1 Hour
- 3.7Excel 2 Int 2016 Video30 Minutes
- 3.8Excel 2 Quiz 230 Minutes6 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 examples30 Minutes
- 4.2New worksheets are opened30 Minutes
- 4.3Worksheets are renamed in terms of their purpose within the solution to the given problem30 Minutes
- 4.4Cells are manipulated between worksheets30 Minutes
- 4.5A worksheet within a workbook (or spreadsheet) is deleted1 Hour
- 4.6Excel 3 Int 2016 Video30 Minutes
- 4.7Excel 2 Quiz 330 Minutes5 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 operation30 Minutes
- 5.2Formulae are entered to deliberately change the natural order of operation30 Minutes
- 5.3Formula error messages are correctly interpreted and the formula corrected accordingly30 Minutes
- 5.4The difference between relative and absolute cell addressing is demonstrated by using it in a formula30 Minutes
- 5.5Data are changed to test possible solutions to the given problem without having to change formulae30 Minutes
- 5.6Scenarios are created that demonstrate different possible outcomes30 Minutes
- 5.7Excel 4 Int 2016 Video30 Minutes
- 5.8Excel 2 Quiz 430 Minutes7 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 construct30 Minutes
- 6.2Simple Mathematical functions are applied to the given problem30 Minutes
- 6.3Statistical functions are applied that achieve the anticipated result30 Minutes
- 6.4Excel 5 Int 2016 Video30 Minutes
- 6.5Excel 2 Quiz 530 Minutes4 Questions
- Session SixAPPLY FORMATTING TO A SPREADSHEET APPLICABLE TO THE GIVEN PROBLEM.6
- Session SevenUSE SPECIAL EFFECTS TO IMPROVE THE PRESENTATION OF THE SPREADSHEET.6
- 8.1Text is centered across a cell range30 Minutes
- 8.2Orientation of text within a cell is changed30 Minutes
- 8.3A border is applied to cells and removed from cells1 Hour
- 8.4Fill (shading) is applied to cells and removed from cells.30 Minutes
- 8.5Excel 7 Int 2016 Video30 Minutes
- 8.6Excel 2 Quiz 730 Minutes4 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 integrity30 Minutes
- 9.2The spreadsheet is modified if required and compliance with the brief is confirmed30 Minutes
- 9.3Excel 8 Int 2016 Video30 Minutes
- 9.4Excel 2 Quiz 830 Minutes4 Questions
- Excel Intermediate Portfolio of Evidence (POE)1
Prev
Excel 2 Quiz 2
