Course: Grade 11 CAT Guest Preview

  • General

    • Welcome to the Grade 11 CAT Guest preview!

    • Starting off:

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

      Click on one of the sections below to start your preview. In Grade 11 we will cover Microsoft Access, Excel and Word. 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 containing a video, a downloadable file (where required) and a self-assessment to test your skills.

      Please contact us if you struggle with any features or want to know more about what is on offer.

    • Microsoft Word

      Lesson 4 – Insert different breaks

      Download the Word document below before proceeding to the Self-assessment.

      Lesson 4 – Insert different breaks

      Self-assessment

      Lesson 4Insert different breaks

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

      1. Remove the page break on page 1.
      Hint: switch on “Show/Hide” to see the page break.

      1. Insert a section break before the heading “Common Social Media Features” on page 1.
      2. Now change the orientation of page 1 to landscape.
      3. Verify that only page 1 is landscape and that the rest of the document is still portrait.
      4. On page 3 you will see columns. Insert a column break before the paragraph about “cyberbullying” at the bottom of the first column.
      5. Verify that this paragraph appears at the top of the second column after you added the column break.
      6. Insert a page break before the heading “What Does the Future Hold …” below the columns.
      7. Save the file in your folder for this lesson.


    • Microsoft Excel

      Lesson 5 – Use functions: count, counta, countblank

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

      Lesson 5 – Use functions: count, counta, countblank

      Self-assessment


      Lesson 5 – 

    • Microsoft Access

      Lesson 6 – Tables: Create a validation rule

      Tables: Create a validation rule

      Download the following Access and pdf documents:

      Lesson 6 – Tables: Create a validation rule


       Input Mask Character Sheet


      Validation Rule Examples


      Lesson 6 – Tables: Create a validation rule

      Open the file that you downloaded for this lesson and complete the following in the Athletics Event table:

      1. Create a validation rule for the Email field to make sure that all the addresses contain the @ symbol. Add appropriate validation text.
      2. Create a validation rule for the Age field to limit the ages that can be entered to learners who are 13 to 19 years old. Add appropriate validation text.
      3. Create a validation rule for the DOB field to make sure that all the learners who are competing, were born on or after 01/01/2001. Add appropriate validation text.
      4. Open the table with the name Learners to check whether you completed the exercise correctly.
      5. Save the file in your folder for this lesson.
    • forum icon
      Forum
      Announcements Forum