UPMSP Vocational General Foundation study materials
UPMSP Vocational General Foundation study resources

UPMSP Vocational General Foundation: Computer and Digital Literacy - Hardware, Office Tools and Safe Internet Use

UPMSP Vocational General Foundation · Work through your exam, one topic at a time.

All guide sections

Computer and Digital Literacy - Hardware, Office Tools and Safe Internet Use

This domain tests practical digital literacy: computer parts, memory and storage units, operating-system basics, word processing and spreadsheets, internet and email, digital payment methods, and cyber safety.

Core knowledge

  • Input devices send data in (keyboard, mouse, scanner, microphone); output devices send results out (monitor, printer, speaker).
  • Memory: RAM is volatile and loses content on power-off; ROM is non-volatile. Storage units: 8 bits = 1 byte, 1024 bytes = 1 KB, 1024 KB = 1 MB, 1024 MB = 1 GB.
  • Spreadsheet formulas start with =. Common ones: =SUM(B2:B5), =AVERAGE(B2:B5), =MAX(...), =MIN(...).
  • Email fields: To, Cc (visible copy), Bcc (hidden copy), Subject, Body, Attachment.
  • Digital payments: UPI links a bank account to a virtual payment address; never share the OTP or PIN, because no genuine bank or helpline asks for them.
  • Safe browsing: look for https and the padlock, avoid unknown links, and treat urgent “verify your account” messages as phishing until proven otherwise.

Worked example

A trainee needs the total and average of marks in cells B2 to B5, with the average placed in B6.

  • In B6 type =SUM(B2:B5) to total; in B7 type =AVERAGE(B2:B5) to average. Reasoning shown: the equals sign starts a formula; the colon means “from B2 through B5”; typing the numbers directly would break the result when a mark is later edited, whereas a formula updates automatically.

Traps that cost marks

  • Confusing Kb (kilobit) with KB (kilobyte).
  • Saying RAM stores data permanently.
  • Calling a printer an input device because paper comes out.
  • Replying to a phishing mail to “confirm” details.
  • Writing =SUM(B2+B5) when the full range is required.