Requirements
- Laptop Or Cell Phone
- Read and Write English
- Course Available Online
Features
- Create and edit a graph/chart.
- Load data from an external data source to produce a given spreadsheet result.
- Insert and edit objects in a spreadsheet.
Target audiences
- All Countries Qualify
- All Ages Qualify
Microsoft Office Excel Level 3 (Advanced)
SAQA ID: 116943
Duration:2 Days
Programme Outcome:
- Create and edit a graph/chart.
- Load data from an external data source to produce a given spreadsheet result.
- Insert and edit objects in a spreadsheet.
Accredited SAQA Unit Standard Title:  116943 Using a Graphical User Interface (GUI)-based spreadsheet application, enhance the functionality and apply graph /charts to a spreadsheet NQF Level 4 Credits 3
Accredited: Â Yes
Training Provider: Southern Africa Youth Project
SETA Accreditation Institution Name: Â MICT SETA
Accreditation Number: Acc/2013-07/3086
Training Delivery Mode: Online, Blended, Distance and Face to Face
-
Learner guide
- 116940 SayPro Lesson 5.1 To Create a Simple Formula that Adds Two Numbers: Copy
- 116940 Introduction to Excel 2010
- 116940 SayPro Lesson 1.2 The Ribbon:
- 116940 SayPro Lesson 1.3 To Customize the Ribbon:
- 116940 SayPro Lesson 1.4 To Minimize and Maximize the Ribbon:
- 116940 SayPro Lesson 1.5 To Add Commands to the Quick Access Toolbar:
- 116940 SayPro Lesson 1.6 To Zoom In and Out:
- 116940 SayPro Lesson 1.7 To Scroll Horizontally in a Worksheet:
- 116940 SayPro Lesson 1.8 To Change Page Views:
- 116940 SayPro Lesson 1.Setting Up Your Excel Environment
- 116940 SayPro Lesson 10.0 Working with Cells
- 116940 SayPro Lesson 10.1 To Copy and Paste Cell Contents:
- 116940 SayPro Lesson 10.2 To Cut and Paste Cell Content:
- 116940 SayPro Lesson 10.4 To Use the Fill Handle to Fill Cells:
- 116940 SayPro Lesson 10.5 Adding and removing borders:
- 116940 SayPro Lesson 11.0 Evaluating the accuracy of a spreadsheet
- 116940 SayPro Lesson 2. Starting a Workbook
- 116940 SayPro Lesson 2.1 To Create a New, Blank Workbook:
- 116940 SayPro Lesson 2.2 The Cell:
- 116940 SayPro Lesson 2.3 To Select a Cell:
- 116940 SayPro Lesson 2.4 To Select Multiple Cells:
- 116940 SayPro Lesson 2.5 Cell Content:
- 116940 SayPro Lesson 2.6 To Insert Text:
- 116940 SayPro Lesson 2.7 To Edit or Delete Text:
- 116940 SayPro Lesson 2.8 To Save the Workbook:
- 116940 SayPro Lesson 3.0 Adjusting settings to preferences
- 116940 SayPro Lesson 3.1 To Freeze Rows:
- 116940 SayPro Lesson 3.2 To Freeze Columns:
- 116940 SayPro Lesson 3.3 To Unfreeze Panes:
- 116940 SayPro Lesson 3.4 Changing the default file location
- 116940 SayPro Lesson 4.0 Working with Worksheets
- 116940 SayPro Lesson 4.1 Reasons for multiple worksheets in one spreadsheet
- 116940 SayPro Lesson 4.2 Naming Worksheets
- 116940 SayPro Lesson 4.3 To Rename a Worksheet:
- 116940 SayPro Lesson 4.4 Inserting Worksheets
- 116940 SayPro Lesson 4.5 Deleting Worksheets
- 116940 SayPro Lesson 4.6 To Copy a Worksheet:
- 116940 SayPro Lesson 4.6 To Copy a Worksheet:
- 116940 SayPro Lesson 4.8 Grouping and Ungrouping Worksheets
- 116940 SayPro Lesson 4.9 To Ungroup All Worksheets:
- 116940 SayPro Lesson 5.0 Creating Simple Formulas
- 116940 SayPro Lesson 5.1 To Create a Simple Formula that Adds Two Numbers:
- 116940 SayPro Lesson 5.10 Using the error alert button:
- 116940 SayPro Lesson 5.3 To Create a Simple Formula using the Point and Click Method:
- 116940 SayPro Lesson 5.2 To Create a Simple Formula that Adds the Contents of Two Cells:
- 116940 SayPro Lesson 5.4 To Create a Simple Formula that Multiplies the Contents of Two Cells:
- 116940 SayPro Lesson 5.5 To Create a Simple Formula that Divides One Cell by Another:
- 116940 SayPro Lesson 5.6 To Create a Formula Using Cell References:
- 116940 SayPro Lesson 5.7 To Edit a Formula:
- 116940 SayPro Lesson 5.8 Formula Error Values
- 116940 SayPro Lesson 5.9 Excel’s error values:
- 116940 SayPro Lesson 6.0 Creating Complex Formulas
- 116940 SayPro Lesson 6.1 Complex Formulas Defined
- 116940 SayPro Lesson 6.10 To Create and Copy a Formula Using an Absolute Reference:
- 116940 SayPro Lesson 6.2 The Order of Operations
- 116940 SayPro Lesson 6.3 To Calculate the Correct Answer:
- 116940 SayPro Lesson 6.4 Creating Complex Formulas
- 116940 SayPro Lesson 6.5 Example of How to Write a Complex Formula:
- 116940 SayPro Lesson 6.6 Working with Cell References
- 116940 SayPro Lesson 6.7 Relative References
- 116940 SayPro Lesson 6.8 To Create and Copy a Formula Using Relative References:
- 116940 SayPro Lesson 6.9 Absolute References
- 116940 SayPro Lesson 7.0 Working with Basic Functions
- 116940 SayPro Lesson 7.1 The Parts of a Function:
- 116940 SayPro Lesson 7.10 To Calculate the Average of a Range of Data:
- 116940 SayPro Lesson 7.11 How to find the maximum and minimum values
- 116940 SayPro Lesson 7.12 To Insert a Function from the Function Library:
- 116940 SayPro Lesson 7.13 Using the Insert Function command:
- 116940 SayPro Lesson 7.2 Excel’s Different Functions
- 116940 SayPro Lesson 7.3 Statistical Functions:
- 116940 SayPro Lesson 7.4 Financial Functions:
- 116940 SayPro Lesson 7.5 Date and Time functions:
- 116940 SayPro Lesson 7.5 Date and Time functions:
- 116940 SayPro Lesson 7.7 Using AutoSum to select Common Functions:
- 116940 SayPro Lesson 7.8 To Edit a Function:
- 116940 SayPro Lesson 7.8 To Edit a Function:
- 116940 SayPro Lesson 8.0 Using Templates
- 116940 SayPro Lesson 8.1 To Create New Workbooks Using Templates:
- 116940 SayPro Lesson 9.0 Aligning Text and cell
- 116940 SayPro Lesson 9.1 Formatting Cells
- 116940 SayPro Lesson 9.10 To Format Numbers and Dates:
- 116940 SayPro Lesson 9.11 To Modify Column Width:
- 116940 SayPro Lesson 9.12 To Set Column Width with a Specific Measurement:
- 116940 SayPro Lesson 9.13 To Modify the Row Height:
- 116940 SayPro Lesson 9.14 To Set Row Height with a Specific Measurement:
- 116940 SayPro Lesson 9.16 To Wrap Text:
- 116940 SayPro Lesson 9.17 To Merge Cells Using the Merge and Center Command:
- 116940 SayPro Lesson 9.18 To Access More Merge Options:
- 116940 SayPro Lesson 9.19 Formatting a cell
- 116940 SayPro Lesson 9.2 To Change the Font Size:
- 116940 SayPro Lesson 9.20 Copying formatted cells
- 116940 SayPro Lesson 9.3 To Use the Bold, Italic, and Underline Commands:
- 116940 SayPro Lesson 9.4 To Add a Border:
- 116940 SayPro Lesson 9.5 To Change the Font Colour:
- 116940 SayPro Lesson 9.6 To Add a Fill Colour:
- 116940 SayPro Lesson 9.7 To Change Horizontal Text Alignment:
- 116940 SayPro Lesson 9.8 To Change Vertical Text Alignment:
- 116940 SayPro Lesson 9.9 Formatting Numbers and Dates
-
Poe guide
- 116940-2-1 CONTACT DETAILS
- 116940-2-2 COMPETENCE
- 116940-2-3 ASSESSMENT STRATEGY
- 116940-2-4 ASSESSMENT PREPARATION
- 116940-2-5 AGREED ASSESSMENT PLAN
- 116940-2-6 Interview (RPL Purposes)
- 116940-2-7 LETTER OF COMMITMENT FROM THE LEARNER
- 116940-2-8 Declaration of Authenticity
- 116940-2-9 PORTFOLIO BUILDING
- 116940-2-10 RECORD OF LEARNING
- 116940-2-11 ASSESSMENT DECISION & EVIDENCE EVALUATION RECORD
- 116940-2-12 Assessor’s feedback report to the candidate
- 116940-2-13 Moderator’s Report
- 116940-2-14 ASSESSMENT REVIEW
- 116940-2-15 Candidate Appeal Form
- 116940-2-16 Assessor’s Contingency Plan
-
Formative Assessment
-
Summative Assessment
-
Suggestions and Improvements
- 116940-116943-5-1 What did you like about this course. Accept and comment below
- 116940-116943-5-2 What other courses do you think we can add. Accept and comment below
- 116940-116943-5-3 What can you suggest more to Southern Africa Youth Academy. Accept and comment below
- 116940-116943-5-4 What do you suggest we can do in future to improve our services. Accept and comment below
- 116940-116943-5-5 How satisfied are you by the course you just completed.
- 116940-116943-5-6 Welcome Note
