Topic outline
-
-
Starting off:
Below is a preview of the content that is available in the Grade 10 CAT course.
Click on one of the sections below to start your preview. In Grade 10 we will cover Microsoft 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 12 – Use styles in Word
Download the Word document below before proceeding to the self-assessment.
Lesson 12 – Use styles in Word
Self-assessment
Lesson 12 – Use styles in Word
Open the file that you downloaded for this lesson and complete the following:
- Change the main heading (Recycling Basics) to the style “Title”.
- Use the “Heading 1” style to change the three red headings. Please note that the font color might change to fit the new style.
- Use the “Heading 2” style to change the three green headings. Please note that the font color might change to fit the new style.
- Change the blue paragraph on page 2 (EPA released …) to fit the document’s normal style.
- Save the file in your folder for this lesson.
-
Microsoft Excel
Lesson 6 – Use basic functions
Download the Excel document below before proceeding to the self-assessment.
Lesson 6 – Use basic functions
Self-assessment
Lesson 6 – Use basic functions
Open the file that you downloaded for this lesson and complete the following:
- Cell D7: Use a function to calculate the total number of tickets sold.
- Cell D9: Use a function to calculate the average number of tickets sold.
- Cell D11: Use a function to calculate the highest number of tickets sold by a learner.
- Cell D13: Use a function to calculate the smallest number of tickets sold by a learner.
- Cell D15: Use a function to calculate how many learners sold tickets.
- Unhide the worksheet with the name “Solution” to verify that you have completed the exercise in the correct way.
- Save the file in your folder for this lesson.
-
Microsoft Word
Lesson 12 – Use styles in Word
Download the Word document below before proceeding to the self-assessment.
Lesson 12 – Use styles in Word
Self-assessment
Lesson 12 – Use styles in Word
Open the file that you downloaded for this lesson and complete the following:
- Change the main heading (Recycling Basics) to the style “Title”.
- Use the “Heading 1” style to change the three red headings. Please note that the font colour might change to fit the new style.
- Use the “Heading 2” style to change the three green headings. Please note that the font colour might change to fit the new style.
- Change the blue paragraph on page 2 (EPA released …) to fit the document’s normal style.
- Save the file in your folder for this lesson.