Matching

Which method of information is being shown here:

• Numbers

• Graphs and charts

• Sparklines

• Infographics

• Tables

Give one difference between a sparkline and a chart.

Answer explanation

Sparklines don’t have x-axis/y-axis/axis labels.
Sparklines don’t show a grid.
Sparklines are a background of a cell whilst charts are objects.
Sparklines are used for seeing a summary/overall trend / charts may be studied more closely (1)

State two differences in the characteristics of data and information.

Answer explanation

Information had meaning. (1)
Information is structured. (1)
Information has context. (1)
Information has been processed. (1)
Or the opposite points being true for data.

A film company is carrying out a test screening for their new film, an action film aimed at teenagers and young adults in English speaking countries. The audience of the film will be shown a preview of the film and given a questionnaire. The results of the survey will determine key aspects of the film, such as whether a new ending will be filmed.

The questionnaires will be given to the audience on paper.

The information on each paper questionnaire will be entered into a spreadsheet for analysis. Explain how the information could be verified.

Answer explanation

Another person could proofread the data (1) by comparing the questionnaires to the data entered (1).
Double entry (1) could be used, where the data / key parts of the data are entered twice / to reduce the chance that a data entry error occurs (1).

One question asks the audience to rate the film from 0 to 10.

Explain one type of validation that could be used to validate the data in the final data set when the audience rates the film from 0 to 10.

Answer explanation

A range check (1) to make sure the data is in the correct range of 0 to 10 (1).

Also accept:A type / data type check (1) to make sure that a number is entered (1).A presence check (1) if the data must be present for every questionnaire (1).

People who attend the screening must provide a contact telephone number.

State the validation that could be used to make sure that all records in the data set have the contact telephone number information required from people who attend the screening.

Answer explanation

Presence check (1).

State one other validation check that may be used on the data.

Answer explanation

Type check. (1)Length check. (1)

Accept format check (1) or lookup check (1).If incorrect answers have been given in part (b) or (c) then accept presence check or range check for this answer.

Explain whether the data collected by the film company is primary or secondary data.

Answer explanation

It is primary data (1) as the film company has collected the original / raw data / the original data from the people that watched the film (1).

Explain two reasons why the data collected may be unreliable, considering the film company invited 10 people to the test screening based on an advertisement in a local newspaper and the screening was held at 9 am on a weekday.

Answer explanation

10 people is a small sample size (1) as if one person isn’t representative of the target audience, they will significantly alter the results (1).
Only a small proportion of people read newspapers / they are less likely to be in the target audience (1), which will result in the data not being representative (1).
The time/date the data was collected is unlikely to attract the target audience (1) as they may be working / at school / in bed (1).
Accept other valid reasons with an explanation.

Describe how an alternative method of data collection could be used to gain further information from members of the audience.

Answer explanation

A telephone interview (1) could be carried out to ask users to give further information about their views of the film / to clarify answers given (1).

Accept other valid methods with a description of how they could be used in this case.