Basic Computer Knowledge: Practical Literacy
Hardware and Software
Know input and output devices, memory hierarchy (registers, cache, RAM, ROM, secondary storage), and units of storage (bit, byte, KB, MB, GB). Distinguish system software from application software and understand the role of the operating system.
Office Tools
For word processing, understand formatting, headers, and mail merge. For spreadsheets, learn cell referencing (relative and absolute), common functions such as SUM, AVERAGE, COUNT, and IF, and chart types. For presentations, know slide layout and transitions.
Networking and Security
Understand LAN versus WAN, the role of IP addresses and browsers, and the meaning of HTTP, URL, and email fields (To, Cc, Bcc). Learn basic security habits: strong passwords, antivirus updates, phishing awareness, and backups.
Traps
- Memory confusion: RAM is volatile; ROM is non-volatile.
- Unit order: KB before MB before GB; a byte is eight bits.
- Absolute references: in a spreadsheet, $A$1 is absolute while A1 is relative.
- Cc versus Bcc: recipients in Bcc are hidden from other recipients.
Rule of Thumb
For each shortcut or function, associate one concrete use: Ctrl+S saves, Ctrl+Z undoes, SUM adds a range.
Worked Example
In a spreadsheet, if the formula =A1*$B$1 is copied from row 1 to row 2, it becomes =A2*$B$1 because A1 is relative and $B$1 is absolute.