6.1 Give TWO tips for setting high quality questions to be used in a survey - NSC Computer Application Technology - Question 6 - 2018 - Paper 2
Question 6
6.1 Give TWO tips for setting high quality questions to be used in a survey.
6.2 How would one transfer data collected electronically to another application without... show full transcript
Worked Solution & Example Answer:6.1 Give TWO tips for setting high quality questions to be used in a survey - NSC Computer Application Technology - Question 6 - 2018 - Paper 2
Step 1
Give TWO tips for setting high quality questions to be used in a survey.
96%
114 rated
Only available for registered users.
Sign up now to view full answer, or log in if you already have an account!
Answer
Questions should provide options or be closed-ended to simplify responses.
Questions should be concise, unambiguous, and directly related to the survey topic.
Step 2
How would one transfer data collected electronically to another application without re-typing the data?
99%
104 rated
Only available for registered users.
Sign up now to view full answer, or log in if you already have an account!
Answer
Data can be transferred by exporting it to a CSV or text file and then importing it into the new application.
Step 3
Give ONE reason why it would be better to insert a cell reference instead of using the copy and paste method to return the required data.
96%
101 rated
Only available for registered users.
Sign up now to view full answer, or log in if you already have an account!
Answer
Using a cell reference ensures that changes to the original data are automatically updated in the new spreadsheet.
Step 4
How many categories (series of data) are shown in this graph/chart?
98%
120 rated
Only available for registered users.
Sign up now to view full answer, or log in if you already have an account!
Answer
There are four categories shown in the graph: Engineering, Marketing, Research, and Quality Assurance.
Step 5
Explain the problem that exists in the Marketing department according to the graph/chart.
97%
117 rated
Only available for registered users.
Sign up now to view full answer, or log in if you already have an account!
Answer
The Marketing department has spent too much of their budget and is overspending according to the allocated budget.
Step 6
Which department underspent by the largest percentage on their allocated budget?
97%
121 rated
Only available for registered users.
Sign up now to view full answer, or log in if you already have an account!
Answer
The Research department underspent the most on their allocated budget.
Step 7
Suggest THREE improvements that could be made to this graph/chart to make it easier to interpret.
96%
114 rated
Only available for registered users.
Sign up now to view full answer, or log in if you already have an account!
Answer
Add currency symbols to the numbers/amounts for clarity.
Include data labels for each bar to provide specific values.
Add axis titles to clarify what each axis represents.
