E3 T1 Using & Manipulating Data

Multiple Choice

Which is the best example of data helping an organisation make a decision?

• Choosing staff uniforms based on one manager’s opinion

• Changing opening hours after analysing customer footfall data

• Picking a new logo because it “looks better”

• Buying new laptops because another company did

Multiple Choice

Which of the following is NOT a reason why data analysis is important for organizations?

• It helps in making informed decisions.

• It improves operational efficiency.

• It guarantees financial success.

• It identifies trends and patterns.

Open Ended

Why is the ability to collect, analyse, and present data considered vital for both individuals and organizations?

Multiple Choice

Data vs information: which is correct?

• Data is processed; information is raw

• Data is raw; information is processed and meaningful

• Data and information mean the same

• Information is always numbers

Multiple Choice

Which is primary data?

• Government census statistics

• A market research report

• A survey you create and send to customers

• A Wikipedia page

Multiple Choice

Which is the best sign a source is reliable?

• It has lots of likes

• It is peer-reviewed / from a credible organisation

• It’s the newest post on social media

• It uses complicated words

Multiple Choice

Which is an example of validation?

• Double-entering the same record to check for typos

• Printing the data

• Asking a colleague to proofread

• A range check that age must be 0–120

Multiple Choice

Best chart to show a trend over time?

• Pie chart

• Line graph

• Scatter without labels

• Random colours bar chart

Open Ended

Give one advantage and one disadvantage of primary data.

Multiple Choice

A common downside of secondary data is:

• Always too expensive

• May not match your goals or be up-to-date

• Cannot be analysed

• Must be collected by interviews

Multiple Choice

Which combination is best for judging reliability?

• Check the source, check for bias, verify consistency

• Pick the first result on Google, trust it, share it

• Use only social media, because it’s current

• Ignore other sources so you don’t get confused

Open Ended

Explain how the reliability of data can be judged and ensured, providing examples from both social media analytics and academic research.

Multiple Choice

A council wants quick feedback from thousands of residents about buses. Best method?

• Interview every resident

• Focus groups only

• Online survey with clear unbiased questions

• Guess based on one complaint email

Multiple Select

Which of the following are advantages of using surveys for data collection?

• Efficient for large groups

• Easy to analyze

• Provides deep, detailed insights

• Risk of low response rates

Multiple Choice

Which issue is most linked to focus groups?

• Low response rate

• Groupthink / people copying dominant views

• Format checking email addresses

• Sorting data alphabetically

Fill in the Blank

Interviews are a method of collecting data that involves one-on-one detailed conversations. One benefit of interviews is that they provide ___ responses.

-

Multiple Choice

A gaming company hosts focus groups to test a new game interface. What is one implication of using small group sizes in focus groups?

• Small group sizes might not represent the broader audience.

• Small group sizes always provide unbiased results.

• Small group sizes are less time-intensive.

• Small group sizes guarantee accurate feedback.

Multiple Choice

Which of the following is a consequence of inaccurate data in healthcare?

• Incorrect treatment risking health or life

• Overpaid taxes

• Wasted advertising budget

• Loss of sales trends

Multiple Choice

Double-entry of information to catch typos is:

• Validation

• Verification

• Encryption

• Sorting

Open Ended

Explain the difference between data verification and data validation, providing an example of each.

Multiple Choice

Which of the following methods can be used for extracting and sorting data?

• Using spreadsheets

• SQL queries

• Automation tools

• All of the above

Multiple Choice

What does this query return?
SELECT * FROM Customers WHERE TotalSpent > 500 AND PurchaseDate >= '2024-10-01';

• All customers who have ever spent anything

• Customers who spent under 500

• Only customers from October 2023

• Customers who spent over 500 and purchased on/after 1 Oct 2024

Multiple Select

Select all benefits of data modelling.

• Helps organizations make data-driven decisions

• Identifies patterns and correlations

• Ensures data meets specific rules

• Predicts future revenue growth

Multiple Choice

Best way to show “parts of a whole” (percentages by category)?

• Pie chart

• Random table only

• Line chart

• Unlabelled scatter graph

Fill in the Blank

A marketing manager presents campaign success using a ___ chart comparing click-through rates across different ads.

Multiple Choice

Which tool is a data visualisation platform (not just a spreadsheet)?

• Snipping Tool

• Calculator

• Power BI

• Notepad

Open Ended

List and briefly describe three characteristics of an effective user interface.

Multiple Choice

Which of the following is an example of how accessibility can be improved in user interfaces?

• Using alt text for images and keyboard navigation

• Adding more colors to the interface

• Making the app available only on smartphones

• Removing all text from the interface

Multiple Select

Which of the following are important aspects of user interfaces mentioned across the examples?

• Ease of Use

• Intuitiveness

• Performance

• Error Reduction

Open Ended

Explain how user-friendly interfaces contribute to effective data manipulation and decision-making in organizations.

Open Ended

What questions do you still have about the impact of IT systems on organisations?

Open Ended

Why is it important for both individuals and organizations to understand how to collect, analyse, and present data?

Open Ended

Give one real-life example where inaccurate data could cause harm.