Photo AI
Part of a form that was designed to capture data for a poll on the matric farewell is shown below - NSC Computer Application Technology - Question 6 - 2017 - Paper 2
Question 6
Part of a form that was designed to capture data for a poll on the matric farewell is shown below. Matric Farewell Theme Name* Theme 2 Theme 3 Theme 4 Class*... show full transcript
Worked Solution & Example Answer:Part of a form that was designed to capture data for a poll on the matric farewell is shown below - NSC Computer Application Technology - Question 6 - 2017 - Paper 2
Step 1
Explain why the control(s) used to get the user's response for the theme was a poor choice.
Answer
The use of checkboxes allows users to select multiple themes at once, which may lead to inaccurate data collection. If a user selects more than one theme, it could lead to confusion about which theme they actually prefer, thus making the collected data unreliable.
Step 2
Give ONE reason why the button control ('Final') on this form may be confusing to a user.
Answer
The caption on the button does not clearly indicate its function. Users may not understand that clicking 'Final' submits their choices, which could lead to hesitation or inadvertent double submissions.
Step 3
Explain why a list box would have been a better choice to select the class rather than the combo box in the example above.
Answer
A list box allows users to view all available classes at once, making it easier to select one. In contrast, the combo box may require users to scroll through options or type an entry, which may result in errors or incorrect selections. Since classes are fixed, a list box eliminates the need for users to enter alternatives.
Step 4
Explain how this might affect the quality of information on the web page.
Answer
Cached web pages may show outdated or incorrect information if the user does not refresh the browser. This can lead to confusion or reliance on stale data, impairing decision-making processes. To mitigate this, users should refresh the page or clear their browser's cache.
Step 5
Give the name of the function cell B2 that could have been used to determine the number of learners who performed on level 1.
Answer
The function that could be used is COUNTIF which counts the number of cells that meet a specific condition. In this case, it would count the number of learners performing at level 1.
Step 6
Explain what the likely problem is AND how to correct the problem.
Answer
The likely problem is that the chart is being generated with incorrect data ranges. To correct this, ensure the data range includes B2:B7 from the first column to draw the chart accurately, and that the levels from column A are included in the data set.