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 re-typing the data? 6.3 Assume that you have one spreadsheet that uses data from another spreadsheet. 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. 6.4 Study the graph below and answer the questions that follow. 6.4.1 How many categories (series of data) are shown in this graph/chart? 6.4.2 Explain the problem that exists in the Marketing department according to the graph/chart. 6.4.3 Which department underspent by the largest percentage on their allocated budget? 6.4.4 Suggest THREE improvements that could be made to this graph/chart to make it easier to interpret.

NSC Computer Application Technology Data, information, knowledge, and wisdom: 6.1 Give TWO tips for setting hi

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

Answer

Questions should provide options, particularly using closed questions to limit responses, ensuring clarity in answers.
Questions should be concise and unambiguous, directly addressing the subject matter without leading to confusion.

Step 2

How would one transfer data collected electronically to another application without re-typing the data?

99%

104 rated

Answer

Data can be exported from the original application to a CSV or text file, and then imported into the new application. This allows for smooth data transfer without the need for manual re-typing.

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

Answer

Inserting a cell reference ensures that any changes made to the original data will automatically be updated in the referencing spreadsheet, maintaining accuracy and consistency.

Step 4

How many categories (series of data) are shown in this graph/chart?

98%

120 rated

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

Answer

The Marketing department has overspent, utilizing more than their allocated budget. This implies poor financial planning.

Step 6

Which department underspent by the largest percentage on their allocated budget?

97%

121 rated

Answer

The Research department underspent by the largest percentage compared to 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

Answer

Add currency symbols to the numbers/amounts for clearer financial representation.
Include axis titles to provide context for the data presented on each axis.
Use a meaningful chart title to immediately convey what the graph depicts.

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

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

Give TWO tips for setting high quality questions to be used in a survey.

How would one transfer data collected electronically to another application without re-typing the data?

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.

How many categories (series of data) are shown in this graph/chart?

Explain the problem that exists in the Marketing department according to the graph/chart.

Which department underspent by the largest percentage on their allocated budget?

Suggest THREE improvements that could be made to this graph/chart to make it easier to interpret.

Join the NSC students using SimpleStudy...