General
-
Starting off: Please contact us if you struggle with any features or want to know more about what is on offer.
-
Microsoft Excel
Lesson 7 – Use functions: if
Download the Excel document below before proceeding to the self-assessment.
Lesson 7 – Use functions: if
Self-assessment
Lesson 7 – Use functions: if
Open the file that you downloaded for this lesson and complete the following:
Marks worksheet:
- Cell E2: Use the if-function to determine who passed and who failed the test. To pass, a learner should obtain 40 for the test. The answer in cell E2 should be “Pass”.
- Use the fill handle to copy the formula to the rest of the column.
- Change the mark in cell D2 to 35. Verify that the answer in cell E2 changed to “Fail”.
- Cell F2: Use a nested if function to show the correct symbol next to each mark:
A: 80 to 100
B: 70 to 79
C: 60 to 69
D: 50 to 59
E: 40 to 49
F: 0 to 39
The symbol in cell F2 should be “F”.
- Use the fill handle to copy the formula to the rest of the column.
- Unhide the worksheet with the name “Solution 1” to verify that you calculations are correct.
Tickets worksheet:
- Cell E2: Use the if-function to determine the percentage commission for each learner. All the learners who sold 100 tickets or more, earn 20%. The rest of the learners earn 10%. The answer in cell E2 should be 10%.
- Use the fill handle to copy the formula to the rest of the column.
- Cell F2: Use a nested if-function to determine the commission for each learner:
0 to 49 tickets: 5%
50 to 99 tickets: 10%
100 to 199 tickets: 15%
200 or more tickets: 20%
The answer in cell F2 should be 10%.
- Use the fill handle to copy the formula to the rest of the column.
- Unhide the worksheet with the name “Solution 2” to verify that you calculations are correct.
- Save the file in your folder for this lesson.
-
Microsoft Access
Lesson 4 – Queries: Use criteria
Watch the following three videos before you do the self-assessment:
- Video 1 – Criteria for values
- Video 2 – Criteria for text
- Video 3 – Criteria for dates
Also download the following Access documents:
Lesson 4 – Queries: Use criteria
Queries: Criteria for values
Queries: Criteria for text
Queries: Criteria for dates
Self-assessment
Lesson 4 – Queries: Use criteria
Open the Access file (Lesson 4 – Queries – Use criteria) that you downloaded for this lesson and complete the following:
(All the queries should be based on the Athletics Event table.)
- Create a query to show the name and surname of all the learners from the Western Cape. There should be 107 learners. Save the query as Western Cape.
- Create a query to show the name, surname and gender of all the grade 12 learners that are competing in the 100 m item. There should be 9 learners. Save the query as Item.
- Create a query to show the name, surname and shirt colour of all the girls who did not order a shirt yet. There should be 358 learners. Save the query as Shirt.
- Create a query to show the name, surname and province of all the South African citizens who were born in 2006. There should be 156 learners. Save the query as 2006.
- Create a query to show the name, surname and grade of all the grade 9 and 10 learners who are using Airbnb accommodation. Sort the grades in Design View so that the grade 9’s appear at the top of the list. There should be 60 learners. Save the query as Airbnb.
- Create a query to show the name, surname, province and gender of all the grade 8 learners who paid less than R500. There should be 91 learners. Save the query as Payment.
- Open the query with the name Gauteng. This query is supposed to show the name, surname and grade of all the learners from Gauteng province who ordered a Large shirt, but there are mistakes in the query. Correct the mistakes to show only the name, surname and grade for 21 learners. Close and save the query.
- Save the file in your folder for this lesson.
- Open the Access file with the name “Lesson 4 – Solutions” that you also downloaded for this lesson to verify that you completed everything correctly.
-
Forum