wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

A Level IT Half Term 1 Part 1

Total questions: 99

Worksheet time: 50mins

Name
Class
Date
1.

What is the primary difference between data and information?

a)

Data are raw; information is processed

b)

Data is processed; information is raw

c)

There is no difference

d)

Information is always numerical

2.

Which of these is an example of raw data?

a)

“It is 20°C outside in London today”

b)

“Hello is a greeting in English”

c)

5

d)

“Five students passed their exam”

3.

How is data transformed into information?

a)

By adding more data points

b)

By providing context and meaning

c)

By storing it on a computer

d)

By deleting duplicates

4.

What best describes direct data?

a)

Data compiled by third parties

b)

Firsthand data you collect yourself

c)

Data that is always cheaper

d)

Data that never contains bias

5.

Why might indirect data be used instead of direct data?

a)

It is always more current

b)

It is always more accurate

c)

It is cost-effective and provides historical context

d)

It guarantees relevance

6.

Which source best provides broad trend information?

a)

Interviews

b)

Data logging

c)

Census data

d)

Observation

7.

What is a potential disadvantage of interviews as a data source?

a)

Limited data scope only

b)

High computation cost

c)

Bias potential

d)

Infrequent updates

8.

Which pairing correctly matches method to example?

a)

Data logging → “population every 10 years”

b)

Questionnaire → “verbal questions”

c)

Interview → “written questions”

d)

Observation → “watching the impact of new traffic lights”

9.

Which criterion evaluates how current information is?

a)

Authority

b)

Age

c)

Relevance

d)

Level of detail

10.

In evaluating information, what does “relevance” mean?

a)

How trustworthy the source is

b)

How closely it relates to the topic

c)

How detailed the source is

d)

How popular the source is

11.

Which set lists common quality criteria?

a)

Popularity, aesthetics, sponsorship

b)

Accuracy, relevance, age, level of detail, completeness

c)

Virality, layout, brevity

d)

Entertainment value, brevity, recency only

12.

Why use multiple sources when researching?

a)

To save time

b)

For a balanced perspective

c)

To simplify research

d)

To avoid documenting justifications

13.

When recording an evaluation of a source, what should you document?

a)

The author’s personal details

b)

The source’s popularity

c)

Justifications for your evaluation

d)

The number of site ads

14.

Why is high-quality information important for decision-making?

a)

It reduces your options

b)

It leads to informed decisions

c)

It is always free

d)

It prevents mistakes

15.

What can poor information quality lead to?

a)

More options

b)

Quicker decisions

c)

Poor outcomes

d)

Higher authority

16.

Which source likely scores high for authority and accuracy?

a)

Anonymous blog

b)

Government website

c)

Meme account

d)

Untied forum post

17.

What is the main purpose of changing page orientation in a spreadsheet?

a)

To add colours

b)

To calculate data

c)

To change layout for better presentation

d)

To protect cells

18.

How does 'Fit to Page' affect a spreadsheet?

a)

Adds a watermark

b)

Adjusts content to fit on a single page

c)

Changes number formats

d)

Hides blank rows

19.

What does merging cells do?

a)

Deletes the cells

b)

Combines multiple cells into one larger cell

c)

Changes cell colour

d)

Protects the sheet

20.

Why might you hide rows or columns?

a)

To permanently remove data

b)

To manage visibility without deleting data

c)

To change data formats

d)

To reduce file size

21.

Which action best improves professional layout?

a)

Random font changes

b)

Consistent page setup and house style

c)

Excessive borders

d)

Unaligned headers and footers

22.

What is the purpose of protecting a worksheet?

a)

To change the layout

b)

To prevent unauthorised edits

c)

To increase file size

d)

To add colours

23.

How can you protect a workbook from unauthorised access?

a)

Hiding rows

b)

Resizing columns

c)

Password-protecting the file

d)

Clearing formats

24.

Which change affects structure rather than content?

a)

Inserting or deleting rows/columns

b)

SUM formula

c)

Number formatting

d)

Conditional formatting

25.

What is the main purpose of encryption?

a)

To increase data size

b)

To protect data by encoding it

c)

To simplify storage

d)

To compress files

26.

Which type uses the same key for encryption and decryption?

a)

Asymmetric encryption

b)

Symmetric encryption

c)

Steganography

d)

Hashing

27.

Why is secure key management vital in symmetric encryption?

a)

Keys are public by design

b)

Loss of the key reduces performance

c)

If the key is exposed, all data can be decrypted

d)

Keys expire every hour

28.

What does TLS mainly protect?

a)

Data integrity

b)

Data compression

c)

Data formatting

d)

Data deletion

29.

Why encrypt data at rest?

a)

To enhance compression

b)

To improve storage speed

c)

To prevent unauthorized access to stored data

d)

To simplify backups

30.

Which is a real-world use of encryption in messaging apps?

a)

Image enhancement

b)

End-to-end encryption

c)

Spam filtering

d)

Threaded conversations

31.

How does encryption benefit online transactions?

a)

Reduces transaction fees

b)

Ensures secure transactions by protecting customer data

c)

Speeds up payment processing automatically

d)

Eliminates the need for receipts

32.

Which pairing is correct for protection type?

a)

HTTPS → data at rest

b)

Full-disk encryption → data in transit

c)

File-level encryption → data at rest

d)

TLS → long-term backups

33.

What is a key advantage of batch processing?

a)

Immediate data processing

b)

Efficiency in handling large data sets

c)

Lowest latency

d)

Continuous updates

34.

Which industry commonly uses batch processing?

a)

Agriculture

b)

Banking

c)

Retail

d)

Social media

35.

Which is an example of batch processing?

a)

Live chat support

b)

Overnight payroll run at month-end

c)

Air-traffic control radar

d)

Online shopping cart update

36.

What is a main benefit of online processing?

a)

Handling huge data sets offline

b)

Instant feedback and updates

c)

Minimal resource usage

d)

Guaranteed zero errors

37.

Which application commonly uses online processing?

a)

E-commerce platforms

b)

Monthly payroll

c)

Weather reanalysis archives

d)

Yearly audits

38.

What is a key feature of real-time processing?

a)

Scheduled processing

b)

Lowest resource needs

c)

Immediate data output

d)

Manual batching

39.

Which system requires real-time processing?

a)

Batch payroll systems

b)

Air-traffic control

c)

Online receipts archiving

d)

End-of-day bank settlement

40.

Which pairing matches method to scenario?

a)

Batch → restaurant seat confirmation

b)

Online → overnight bank settlement

c)

Real-time → ICU patient monitoring

d)

Real-time → monthly invoicing

41.

Which task are mainframes optimized for?

a)

High-speed scientific simulations

b)

Transaction processing with high I/O throughput

c)

Rendering 3D graphics

d)

Weather forecasting

42.

What distinguishes a supercomputer’s architecture?

a)

Single very fast core

b)

Many processors running in parallel

c)

Built-in battery backup

d)

Minimal memory footprint

43.

A common industry for mainframe use is:

a)

Indie game studios

b)

Banking and insurance

c)

Fitness trackers

d)

Social media startups

44.

A key benefit shared by mainframes and supercomputers is:

a)

Very low cost

b)

High fault tolerance/reliability

c)

Touchscreen interfaces

d)

Battery operation

45.

A typical drawback of supercomputers is:

a)

Low processing speed

b)

High cost and maintenance

c)

Lack of parallelism

d)

No security features

46.

Why might mainframes be seen as “inflexible”?

a)

Limited scalability

b)

Poor security

c)

Unreliable hardware

d)

Lack of I/O capacity

47.

What is the main advantage of a compiler over an interpreter?

a)

Easier real-time editing

b)

Faster program execution

c)

Smaller executable size

d)

Better memory management

48.

What does a linker do?

a)

Translates source to machine code

b)

Joins object files into one runnable program

c)

Schedules CPU time

d)

Encrypts binaries

49.

Device drivers primarily:

a)

Clean temporary files

b)

Allow the OS to communicate with hardware

c)

Compress data

d)

Translate high-level code

50.

The operating system’s core role is to:

a)

Remove malware

b)

Manage hardware and run applications

c)

Compile programs

d)

Back up files to cloud

51.

A benefit of system software is:

a)

Built-in GUIs that improve usability

b)

Zero maintenance required

c)

Guaranteed compatibility with all apps, forever

d)

Never uses significant resources

52.

A drawback of system software is that it can:

a)

Be free of vulnerabilities

b)

Require frequent updates and patches

c)

Eliminate compatibility issues

d)

Use no memory

53.

The primary function of antivirus software is to:

a)

Increase internet speed

b)

Detect and remove malware

c)

Defragment disks

d)

Compress files

54.

Why must antivirus be updated regularly?

a)

To reduce file sizes

b)

To recognize new threats

c)

To back up data

d)

To speed up SSDs

55.

Data compression mainly:

a)

Reduces file sizes

b)

Increases file sizes

c)

Encrypts files

d)

Deletes redundant files

56.

Which of the following is a benefit of file compression?

a)

Deletes duplicate files

b)

Reduces file size for storage/transfer

c)

Formats drives

d)

Encrypts archives by default

57.

Disk defragmentation improves performance primarily on:

a)

SSDs

b)

HDDs

c)

USB sticks

d)

Optical media

58.

What does formatting a drive do?

a)

Copies files to another disk

b)

Erases data and prepares a file system

c)

Removes the OS

d)

Finds duplicate files

59.

What is a disadvantage of formatting a drive?

a)

It always increases capacity

b)

All data is lost unless backed up

c)

It infects the device

d)

It disables antivirus

60.

Which type of cells does COUNT(range) count in a spreadsheet?

a)

Non-empty cells

b)

Numeric cells (dates count as numbers)

c)

Blank cells

d)

Text entries only

61.

Which function counts non-empty cells (numbers, text, dates, logicals)?

a)

COUNT

b)

COUNTA

c)

COUNTBLANK

d)

COUNTIF

62.

COUNTBLANK(range) will treat a cell with a formula returning "" as:

a)

Not blank

b)

Blank

c)

Text

d)

Error

63.

In COUNTIF/COUNTIFS, comparison operators must be:

a)

Outside single quotes

b)

Inside quotes (e.g., ">=100")

c)

Written as symbols only

d)

Avoided for dates

64.

COUNTIFS requires all ranges to be:

a)

Different sizes

b)

The same size/aligned

c)

Text-only

d)

Numeric-only

65.

Which function counts rows meeting multiple conditions?

a)

COUNTIF

b)

COUNTIFS

c)

COUNTA

d)

COUNTBLANK

66.

What does the IF function return in a spreadsheet?

a)

A count of numbers

b)

One value if TRUE, another if FALSE

c)

The position of a value

d)

A random value

67.

In IFS, the result returned is for the:

a)

Last TRUE condition

b)

First TRUE condition

c)

Highest numeric test

d)

Default only

68.

What is a best practice for IFS to include a final condition?

a)

FALSE, "Error"

b)

TRUE, default_value

c)

0, "None"

d)

"", "Blank"

69.

AND returns TRUE when:

a)

Any condition is TRUE

b)

All conditions are TRUE

c)

All are FALSE

d)

None of the above

70.

OR is often combined with IF to:

a)

Produce labels based on any matching condition

b)

Iterate across ranges

c)

Sort data

d)

Convert text to numbers

71.

A common pitfall with logic functions is:

a)

Using parentheses

b)

Confusing "100" (text) with 100 (number)

c)

Using cell references

d)

Nesting functions

72.

VLOOKUP("Webcam", Products!B2:D6, 2, FALSE) returns the:

a)

Stock value

b)

Price from the 2nd column

c)

Row number

d)

First column text

73.

XLOOKUP improves on VLOOKUP because it can:

a)

Only search left-to-right

b)

Search in either direction and doesn’t need column numbers

c)

Return only approximate matches

d)

Work only on sorted data

74.

HLOOKUP searches:

a)

Down the first column

b)

Across the top row, then down by row index

c)

Within a 3-D range

d)

Only text values

75.

LOOKUP assumes data are:

a)

Unsorted

b)

Sorted ascending and can return closest match

c)

Sorted descending

d)

Unique

76.

INDEX + MATCH is often preferred because it:

a)

Requires sorted data

b)

Separates lookup position from return column

c)

Ignores errors automatically

d)

Needs fewer references

77.

Which formula returns the price of "Headset" from Products!C2:C6?

a)

=VLOOKUP("Headset",Products!B2:D6,4,FALSE)

b)

=INDEX(Products!C2:C6,MATCH("Headset",Products!B2:B6,0))

c)

=HLOOKUP("Headset",Products!A1:F4,3,FALSE)

d)

=XLOOKUP(Products!C2:C6,"Headset",Products!B2:B6)

78.

Custom software is best described as:

a)

Mass-produced for many users

b)

Tailored to specific user/business needs

c)

Always cheaper than alternatives

d)

Pre-installed on all devices

79.

Which is an off-the-shelf example?

a)

Bespoke school app

b)

Microsoft Office

c)

Custom inventory system

d)

Specialised CRM for a niche

80.

A key advantage of custom software is:

a)

Immediate availability

b)

Meets unique requirements exactly

c)

Low development cost

d)

Zero maintenance

81.

A disadvantage of custom software is often:

a)

Lack of customisation

b)

Higher cost & longer development time

c)

Poor fit to needs

d)

No support available

82.

Off-the-shelf software is typically chosen for:

a)

Quick deployment and lower cost

b)

Unlimited customisation

c)

Exclusive licensing

d)

Extremely niche workflows

83.

A limitation of off-the-shelf software is that it may:

a)

Be expensive

b)

Lack customisation

c)

Require extensive training

d)

Be difficult to install

84.

Which validation type best enforces “date after 01/01/2024”?

a)

Text length

b)

Date >= greater than 01/01/2024

c)

Whole number >= greater than 1

d)

Custom =ISNUMBER()

85.

What does INT(7.9) return?

a)

8

b)

7

c)

7.9

d)

0

86.

Which formula rounds J2 to the nearest pound?

a)

=ROUND(J2,2)

b)

=ROUND(J2,0)

c)

=INT(J2)

d)

=TRUNC(J2,0)

87.

Which SUBTOTAL code sums visible rows (including filtered rows)?

a)

4

b)

9

c)

109 only

d)

1

88.

Which formula returns the highest Net Revenue in Sales!J2:J50?

a)

=MAX(Sales!J2:J50)

b)

=SUM(Sales!J2:J50)

c)

=ROUND(Sales!J2:J50,0)

d)

=INT(Sales!J2:J50)

89.

Which lookup is preferred for flexibility and clear syntax?

a)

VLOOKUP

b)

XLOOKUP

c)

HLOOKUP

d)

LOOKUP

90.

What best differentiates a Command Line Interface (CLI) from a Graphical User Interface (GUI)?

a)

CLI uses icons; GUI uses text

b)

CLI uses typed commands; GUI uses windows, icons, menus

c)

Both require programming knowledge

d)

GUI only works without graphics

91.

Which interface is generally most beginner-friendly?

a)

CLI

b)

GUI

c)

Dialogue

d)

Gesture

92.

A dialogue interface primarily relies on:

a)

Typed commands

b)

Voice or conversational text

c)

Hand movements

d)

Keyboard shortcuts only

93.

Which is a typical application of gesture interfaces?

a)

Package managers

b)

Smart home device control

c)

Spreadsheets

d)

Command shells

94.

What’s a common disadvantage of CLI for novices?

a)

High resource use

b)

Steep learning curve

c)

Requires cameras

d)

Limited automation

95.

Why might gesture interfaces be unsuitable for some users?

a)

Accessibility issues

b)

Lack of icons

c)

Noisy audio

d)

No search features

96.

Which interface would be least suitable for a visually impaired user?

a)

CLI

b)

GUI

c)

Dialogue

d)

Gesture

97.

Which interface is best described as GUI?

a)

GUI

b)

Dialogue

c)

CLI with screen reader

d)

Haptic interface

98.

Which scenario suits a dialogue interface best?

a)

Hands-free setting a reminder on a phone

b)

Editing code with complex commands

c)

Precise CAD modelling

d)

Long spreadsheet formulas

99.

Which sensor detects light levels?

a)

Pressure sensor

b)

Light sensor

c)

Motion sensor

d)

Temperature sensor

Similar Resources on Wayground

Tests on subject 'Information and communication technologies'

100 questions

Tests on subject 'Information and communication technologies'

quiz

Worksheet

•

12th Grade

Cuestionario sobre el Protocolo FTP

94 questions

Cuestionario sobre el Protocolo FTP

quiz

Worksheet

•

12th Grade

Unit 17 React.js Question Bank - Extraction

100 questions

Unit 17 React.js Question Bank - Extraction

quiz

Worksheet

•

12th Grade