Section 5.3: Basic Computer Appreciation and Digital Literacy

Computer Hardware and Software Fundamentals

In the modern public service, digital literacy is essential for administrative efficiency. Civil servants must understand the basic components of computer systems and how they process information:

Hardware Components

Computer hardware consists of the physical parts of a computer system:

• Central Processing Unit (CPU): Known as the brain of the computer, the CPU executes program instructions. It contains the Control Unit (CU), which directs the flow of data, and the Arithmetic Logic Unit (ALU), which performs calculations and logical comparisons.
• Memory Hierarchy: Primary storage includes Random Access Memory (RAM), which is volatile memory used for active programs and files, and Read-Only Memory (ROM), which is non-volatile memory containing permanent boot instructions (BIOS).
• Secondary Storage: Non-volatile storage devices for files and software, including Solid-State Drives (SSDs), Hard Disk Drives (HDDs), and external flash memory. SSDs are faster than HDDs as they use flash-based memory instead of moving platters.
• Input and Output Devices: Input devices transfer data to the computer (e.g., keyboards, mice, flatbed scanners for document digitization). Output devices display or produce processed data (e.g., LCD monitors, laser printers).

Software Systems

Software is the set of instructions that controls the hardware:

• System Software: Includes the Operating System (OS) such as Microsoft Windows or macOS, which manages resources and provides the user interface, alongside utility programs and device drivers.
• Application Software: Directs the computer to perform specific user tasks. The most common examples are word processors, spreadsheet applications, database management systems, and web browsers.

E-Governance and Federal IT Infrastructure

Nigeria's public service utilizes centralized digital platforms to streamline finance, payroll, and infrastructure management:

• Integrated Personnel and Payroll Information System (IPPIS): Managed by the OHCSF and the Office of the Accountant-General, IPPIS is a centralized database containing biometric and employment records of all federal employees. It automatically calculates salaries, deductions, and tax, eliminating manual payroll errors and 'ghost workers.'
• Government Integrated Financial Management Information System (GIFMIS): An IT system implemented to automate budget execution, revenue collection, and accounting. It improves financial transparency by tracking commitments and expenditures in real-time.
• Treasury Single Account (TSA) and Remita: The TSA consolidates all federal revenues into a single account at the Central Bank of Nigeria (CBN). MDAs use the Remita payment gateway to collect fees and process payments. Every transaction generates a unique Remita Retrieval Reference (RRR) code for tracking.
• Galaxy Backbone: A federal agency providing fiber-optic network infrastructure, secure web hosting (ending in .gov.ng), and unified email servers to all MDAs, ensuring secure inter-ministerial communication.
• National Information Technology Development Agency (NITDA): The regulatory body that sets IT standards, guidelines, and frameworks for digital adoption and data protection in Nigeria.

Basic Productivity Tools

Civil servants utilize standard office suites for daily administrative tasks:

• Word Processing (e.g., Microsoft Word): Used for drafting memos, circulars, and official letters. Crucial functions include Mail Merge (generating personalized documents for multiple recipients), Track Changes (enabling collaborative editing and review), and paragraph styling for structured formatting.
• Spreadsheets (e.g., Microsoft Excel): Used for data analysis, budgeting, and statistical reports. Key concepts include:
  • Formulas: Functions like =SUM(), =AVERAGE(), =VLOOKUP(), and =IF() are standard.
  • Cell Referencing: Relative referencing (e.g., A1 shifts when copied) versus Absolute referencing (e.g., $A$1 remains constant).
  • Data Organization: Sorting, filtering, and Pivot Tables are used to summarize large datasets.
• Document Formats: The Portable Document Format (PDF) is the standard for final, non-editable official documents, preserving formatting across different devices.

Cybersecurity in the Public Service

As the civil service digitizes, safeguarding sensitive government data is paramount:

• Common Cybersecurity Threats:
  • Phishing: Fraudulent emails designed to trick civil servants into revealing passwords or clicking malicious links.
  • Malware and Ransomware: Software that infects networks to steal information or lock files until a ransom is paid.
  • Social Engineering: Manipulation of personnel to bypass security protocols.
• Best Practices:
  • Access Controls: Implementing strong, unique passwords combined with Multi-Factor Authentication (MFA).
  • Data Encryption: Encrypting sensitive communications and using secure, official government email accounts rather than personal ones.
  • Physical and Device Security: Locking computer screens (Windows Key + L), avoiding unauthorized external storage media (USBs), and regularly backing up files.
  • Information Classification: Adhering to the Official Secrets Act, ensuring restricted or classified files are never sent over unencrypted channels.
• Legal Framework: The Cybercrimes (Prohibition, Prevention, etc.) Act of 2015 provides the legal basis for prosecuting unauthorized access, hacking, and data breaches affecting critical national infrastructure.