10 CT Analysing Data wk8-11 PreQuiz

When you design a digital dashboard that converts raw environmental sensor readings into an interactive heat-map for emergency responders, which stage of the information process are you primarily addressing?

• Data acquisition

• Data interpretation and representation

• Data storage

• Data disposal

A community health app records heart-rate data from users’ smartwatches. According to best practice, who should be considered the owner of the data?

• The software developer

• The smartwatch manufacturer

• The individual user who generated the data

• The national health authority

Encrypting every record in a cloud database before it is written to disk mainly protects data while it is—

• in use (memory)

• at rest (storage)

• in transit (network)

• being deleted

Which section of a project notebook would normally contain screenshots of evolving interface mock-ups annotated with dates and design rationales?

• Problem definition

• Iterative design log

• Test plan

• Final evaluation

To ensure only plausible temperatures (-50°C to 60°C) are accepted in a climate-monitoring spreadsheet, you should apply—

• a VLOOKUP function

• conditional formatting

• data-validation rules with a range check

• a COUNTIF function

Which formula best returns the total revenue for all orders placed by customer ID held in cell B2, using a table of orders in range Orders!A2:D500?

• =SUM(D:D)

• =VLOOKUP(B2,Orders!A2:D500,4,0)

• =SUMIF(Orders!B2:B500,B2,Orders!D2:D500)

• =SUM(Orders!A2:A500)

In a large spreadsheet, you apply a color scale so that the highest five values in a column appear green and the lowest five appear red. This is an example of—

• grouping

• filtering

• conditional formatting

• data validation

Which tool in most spreadsheet software lets you create “What-if” scenarios to maximize profit by altering variables such as price and units sold subject to constraints?

• Goal Seek

• Solver/Optimiser

• Subtotals

• Flash Fill

When you generate a pivot chart that shows monthly sales trends and highlights months whose values lie more than two standard deviations from the mean, you are primarily—

• aggregating data

• identifying PII

• performing ETL

• enforcing referential integrity

In a relational database, which SQL command updates a customer’s email address while preserving the rest of the record?

• INSERT

• DELETE

• UPDATE

• SELECT