Computer Awareness and Basic Office Applications
Hardware and fundamentals
- Input and output devices, the CPU (ALU plus control unit), primary memory (RAM is volatile, ROM is not) and secondary storage; 1 KB = 1024 bytes, 1 MB = 1024 KB, 1 GB = 1024 MB.
- Software types: system software (operating systems, utilities) and application software; open-source versus proprietary.
- File extensions: .docx, .xlsx, .pptx, .pdf, .jpg, .exe.
MS Office essentials
- Word: Ctrl+B bold, Ctrl+I italic, Ctrl+U underline, Ctrl+S save, Ctrl+Z undo, Ctrl+Y redo, Ctrl+P print, Ctrl+F find; mail merge for bulk letters.
- Excel: every formula starts with '='; A1-style references; $A$1 is absolute while A1 is relative; the high-yield functions are SUM, AVERAGE, COUNT, MAX, MIN and IF.
- PowerPoint: F5 starts a slideshow, Shift+F5 starts from the current slide; know layouts, transitions and animations.
- Shortcuts: Ctrl+C, Ctrl+X, Ctrl+V, Alt+Tab to switch windows.
Internet and e-governance
Know IP addresses, browsers versus search engines, email fields (To, Cc, Bcc), URL structure, cloud storage, digital signatures, and platforms such as Digital India, DigiLocker, UMANG, e-Office and the J&K e-governance systems used for panchayat accounting.
Worked example
'In a spreadsheet, what will =SUM(B2:B6) return?' Reasoning: SUM adds every numeric cell in the rectangular range B2 to B6, ignoring text and blank cells. If those cells hold 10, 20, 30, 40 and 50, the result is 150.
Traps
- Assuming a copied formula keeps the same references; a relative reference such as B2 shifts, whereas $B$2 does not.
- Confusing RAM (temporary working memory) with ROM (permanent).
- Reading Cc as a hidden recipient; the hidden field is Bcc.
- Forgetting that a spreadsheet formula must begin with '='.