Course: Grade 12 CAT Guest Preview

  • General

    • Welcome to the Grade 12 CAT Guest preview!


    • Starting off:

      Below is a preview of the content that is available in the Grade 12 CAT course.

      Click on one of the sections below to start your preview. In Grade 12 we will cover Microsoft Word, Microsoft Excel Microsoft Access and HTML. Please note that these lessons focus on the practical part of CAT.

      Each section heading contains a sample lesson as it is presented in the main course.

      During the lesson, you will be presented with a page, each of which contains a video, a downloadable file (where required) and a self-assessment to test your skills.

      Should you struggle with any features or would like to know more about what is on offer, please contact us.
    • forum icon
      Forum
      Announcements Forum

  • Open all

    Close all

  • Instructions: Clicking on the section name will show / hide the section.

  • 1
    • Lesson 1 – Track changes

    • Download the Word document below before proceeding to the self-assessment.

      Lesson 1 – Track changes

      Self-assessment

      Lesson 1 – Track changes

      Open the file that you downloaded for this lesson and complete the following:

      1. Next to the second paragraph (These practices …) is a red line to indicate that somebody changed something in this paragraph.
      2. Scroll through the rest of the document to see if you can find the other four red lines as well.
      3. Click at the beginning of the second paragraph.
      4. Accept this change (to format the text as italic) and move to the next one.
      5. The second sentence of this paragraph (Laptop computers …) was removed by somebody, but you want to keep this sentence. Reject this change.
      6. Reject the rest of the changes in the document.
      7. Save the file in your folder for this lesson.

    Topic
    1
  • 2
    • Lesson 1 – Use statistical functions

    • Download the Excel document below before proceeding to the self-assessment.

      Lesson 1 – Use statistical functions

      Self-assessment


      Lesson 1 – Use statistical functions

      Open the file that you downloaded for this lesson and complete the following:

      1. Cell F47: Calculate the average of the values in column F.
      2. Display only 2 decimals in your answer above.
      3. Cell F49: Calculate the largest value in column F.
      4. Cell F50: Calculate the smallest value in column F.
      5. Cell F52: Calculate the number of cells with leave days in column F.
      6. Cell B53: Calculate the number of cells with names in column B.
      7. Cell F55: Calculate the third largest value in column F.
      8. Cell F56: Calculate the second smallest value in column F.
      9. Cell F58: Calculate the most frequently occurring value in column F.
      10. Sort the values in column F from small to large.
      11. Cell F59: Calculate the value in the middle of the range of values in column F.
      12. Unhide the worksheet with the name “Solution” to check that your calculations are done correctly.
      13. Save the file in your folder for this lesson.

    Topic
    2
  • 3
    • Lesson 1 – Tables: Extract information quickly

    • Download the Excel document below before proceeding to the self-assessment.

      Lesson 1 – Tables: Extract information quickly

      Self-assessment


      Lesson 1 – Tables: Extract information quickly

      Open the file that you downloaded for this lesson and complete the following:

      1. Ensure that the table Athletics Event is open.
      2. Sort the table in alphabetical order according to the learner’s names. Verify that Abie’s name is at the top of the table.
      3. Sort the table according to the learner’s date of birth (DOB). Verify that the youngest learner’s birth date displays at the top of the table (28/12/2006).
      4. Sort the table according to the Grade field so that the grade 12 learners are at the top of the table.
      5. Use the command “Remove Sort” on the ribbon to display the table in its original order.
      6. Use the filter command to find out how many grade 12 girls from Gauteng province will stay in a school hostel. There should be seven learners.
      7. Click on Toggle Filter to see all the learners in the table.
      8. Use the Find option to find the record for Werner Smit. Remove this record. You should have 999 learners in the table now.
      9. Use the Totals command to display a Total row at the bottom of the table.
      10. Display the average age of the learners and the total amount that were paid so far.
      11. Save the file in your folder for this lesson.

    Topic
    3
  • 4

    • Lessons coming soon.


    Topic
    4