Requirements
- National Identity Document, Passport, Work Permit or Asylum
- Have physical Address where you will receive a certificate
- Have a functioning cell phone number and the email address
Features
- Demonstrate an understanding of the principles of spreadsheets.
- Create, open and save spreadsheets
- Produce a spreadsheet from a given specification.
- Edit a spreadsheet.
- Format a spreadsheet
- Check spelling in a spreadsheet.
- Print a spreadsheet using features specific to spreadsheets.
Target audiences
- All Ages Qualify
- Everyone Qualifies for our Courses
- All countries qualifies for our Courses
116937 Use a Graphical User Interface (GUI)-based spreadsheet application to create and edit spreadsheets NQF Level 02
People who complete this course are able to:
- Demonstrate an understanding of the principles of spreadsheets.
- Create, open and save spreadsheets.
- Produce a spreadsheet from a given specification.
- Edit a spreadsheet.
- Format a spreadsheet.
- Check spelling in a spreadsheet.
- Print a spreadsheet using features specific to spreadsheets.
-
Student Guide
-
Text Book +Notes +Lesson
- 116937-3-1 SayPro Lesson Introduction to Excel 2010
- 116937-3-2 SayPro Lesson Setting Up Your Excel Environment
- 116937-3-3 SayPro Lesson Exploring the Excel Environment
- 116937-3-4 SayPro Lesson To Add Commands to the Quick Access Toolbar:
- 116937-3-5 SayPro Lesson To Scroll Horizontally in a Worksheet:
- 116937-3-6 SayPro Lesson Spreadsheet programs:
- 116937-3-7 SayPro Lesson Examples of spreadsheets that can be produced using a spreadsheet application:
- 116937-3-8 SayPro Lesson Starting a Workbook
- 116937-3-9 SayPro Lesson To Create a New, Blank Workbook:
- 116937-3- 10 SayPro Lesson To Select Multiple Cells:
- 116937-3- 11 SayPro Lesson To Move Through a Worksheet Using the Keyboard:
- 116937-3- 12 SayPro Lesson Close the active workbook window:
- 116937-3-13 SayPro Lesson To Open an Existing Workbook:
- 116937-3-14 SayPro Lesson Producing a spreadsheet
- 116937-3-15 SayPro Lesson To Edit or Delete Text:
- 116937-3-16 SayPro Lesson To Create a Simple Formula that Adds Two Numbers:
- 116937-3-17 SayPro Lesson To Create a Simple Formula that Adds the Contents of Two Cells:
- 116937-3-18 SayPro Lesson To Create a Simple Formula using the Point and Click Method:
- 116937-3-19 SayPro Lesson To Create a Simple Formula that Multiplies the Contents of Two Cells:
- 116937-3-20 SayPro Lesson The benefits of saving a file in different formats:
- 116937-3-21 SayPro Lesson Saving a spreadsheet with a different file format:
- 116937-3-22 SayPro Lesson To Save As an Excel 97-2003 Workbook:
- 116937-3-23 SayPro Lesson To Save As a PDF:
- 116937-3-24 SayPro Lesson Editing a spreadsheet
- 116937-3-25 SayPro Lesson To Open an Existing Workbook:
- 116937-3-26 SayPro Lesson To Cut and Paste Cell Content:
- 116937-3-27 SayPro Lesson To Drag and Drop Information:
- 116937-3-28 SayPro Lesson To Use the Fill Handle to Fill Cells:
- 116937-3-29 SayPro Lesson Using automatic fill feature:
- 116937-3-30 SayPro Lesson .Formatting dates and times:
- 116937-3-31 SayPro Lesson Find or replace text and numbers in a worksheet:
- 116937-3-32 SayPro Lesson Formatting a spreadsheet
- 116937-3-33 SayPro Lesson To Change the Font Size:
- 116937-3-34 SayPro Lesson To Use the Bold, Italic, and Underline Commands:
- 116937-3-35 SayPro Lesson To Change the Font Colour:
- 116937-3-36 SayPro Lesson To Change Vertical Text Alignment:
- 116937-3-37 SayPro Lesson Formatting Numbers and Dates
- 116937-3-38 SayPro Lesson To Modify Column Width:
- 116937-3-39 SayPro Lesson To Set Column Width with a Specific Measurement:
- 116937-3-40 SayPro Lesson To Modify the Row Height:
- 116937-3-41 SayPro Lesson To Set Row Height with a Specific Measurement:
- 116937-3-42 SayPro Lesson Checking spelling and grammar in a spreadsheet
- 116937-3-43 SayPro Lesson AutoCorrect spelling, and insert text and symbols:
- 116937-3-44 SayPro Lesson Printing Workbooks
- 116937-3-45 SayPro Lesson To View the Spreadsheet in Print Preview:
- 116937-3-46 SayPro Lesson Print gridlines in a worksheet:
- 116937-3-47 SayPro Lesson To Print Active Sheets:
- 116937-3-48 SayPro Lesson To Print the Entire Workbook:
- 116937-3-49 SayPro Lesson To Print a Selection, or Set the Print Area:
- 116937-3-50 SayPro Lesson To Change Page Orientation:
- 116937-3-51 SayPro Lesson To Modify Margins While in Print Preview:
- 116937-3-52 SayPro Lesson Checking the integrity of data:
-
Home Activity and Tasks
-
Portfolio of Evidence Guide
- 116937-5-1 CONTACT DETAILS
- 116937-5-2 COMPETENCE
- 116937-5-3 ASSESSMENT STRATEGY
- 116937-5-4 ASSESSMENT PREPARATION
- 116937-5-5 AGREED ASSESSMENT PLAN
- 116937-5-6 Interview (RPL Purposes)
- 116937-5-7 LETTER OF COMMITMENT FROM THE LEARNER
- 116937-5-8 Declaration of Authenticity
- 116937-5-9 PORTFOLIO BUILDING
- 116937-5-10 RECORD OF LEARNING
- 116937-5-11 ASSESSMENT DECISION & EVIDENCE EVALUATION RECORD
- 116937-5-12 Assessor’s feedback report to the candidate
- 116937-5-13 Moderator’s Report
- 116937-5-14 ASSESSMENT REVIEW
- 116937-5-15 Candidate Appeal Form
- 116937-5-16 Assessor’s Contingency Plan
-
Formative Assessment-Pre -Assignment
-
Summative Assessment
- 116937-7-1 Summative Assessment (SO 2, AC 1, AC 2, AC 3, AC 4, AC 5, AC 6, AC 7, AC8)
- 116937-7-2 Summative Assessment (SO 3, AC 1, AC 2, AC 3, AC 4, AC 5, AC 6, AC 7)
- 116937-7-3 Summative Assessment (SO 4, AC 1, AC 2, AC 3, AC 4, AC 5, SO 5, AC 1, AC 2, AC 3,SO 7, AC 1, AC 2, AC 3)
- 116937-7-4 Summative Assessment (SO 6, AC 1, AC 2, AC 3, AC 4)
-
suggestions and improvements
- 116937-8-1 what did you like about this course . Accept and comment below
- 116937-8-2 what other courses do you think we can add . Accept and comment below
- 116937-8-3 what can you you suggest more to Sourthen Africa Yourth Academy . Accept and comment below
- 116937-8-4 what do you suggest we can do in future to improve our services . Accept and comment below
