🧠 Roadmap to Ace the Practical Test of Lok Sewa Aayog (Computer Officer - Gazetted 3rd Class)

If you've cleared the written exam of Lok Sewa Aayog for the post of Computer Officer (Gazetted 3rd Class), congratulations! You're just one step away from success — the practical examination.

Unlike the written part, the practical test focuses on your hands-on technical skills, and often includes real-world tasks from system administration, database management, programming, and networking. This guide provides you with a clear and focused roadmap to prepare for this crucial stage.

🖥️ 1. Operating System (System Administration – Windows)

Note: You will be given Windows OS, but be prepared with Linux as well as it is included in syllabus. 

🔍 Types of Questions

• Troubleshooting system issues (user access, startup issues, permission errors).
  
  

• Creating user accounts with limited access time/days.
  
  

• Setting folder/file permissions (read/write/execute) for specific users.
  
  

• Basic shell commands or GUI-based settings.
  
  

✅ How to Prepare

• Practice using both GUI and command line (especially on Linux or PowerShell).
  
  

• Learn to:
  
  

• Create users with net user (Windows) or useradd (Linux).
  
  

• Set folder permissions using chmod, chown (Linux), or Security tab (Windows).
  
  

• Restrict user login time (via Task Scheduler, Group Policy, or CLI).
  
  

• Take screenshots at each step of the process (use Snipping Tool or PrtScn) and save it in MS Word as a documented report.
  
  

📄 Example Task

Create a user named examuser who can access the system only on weekdays between 10 AM to 5 PM. Grant read-only permission to a folder named SharedDocs.

🛢️ 2. DBMS (Database Management System)

🔍 Types of Questions

• A real-life scenario is given, and you must:
  
  

• Design tables and define primary/foreign keys.
  
  

• Enter sample data using INSERT.
  
  

• Execute queries (SELECT, JOIN, GROUP BY, COUNT, etc.).
  
  

✅ How to Prepare

• Practice on MySQL or PostgreSQL locally or using platforms like db-fiddle.
  
  

• Learn to:
  
  

• Create tables (CREATE TABLE)
  
  

• Define constraints (PRIMARY KEY, FOREIGN KEY)
  
  

• Insert data (INSERT INTO)
  
  

• Write queries using:
  
  

• Aggregate functions: SUM(), AVG(), COUNT()
  
  

• JOINs: INNER, LEFT, RIGHT
  
  

• WHERE, ORDER BY, GROUP BY
  
  

📌 Tips

• Understand ER diagrams and be ready to assume logical structure when it's not given.
  
  

• Practice typing queries without auto-suggestions.
  
  

📄 Example Task

A school has students and classes. Create tables Students and Classes with relevant fields. Insert data and list all students with their class names.

👨‍💻 3. Programming (C/C++/Java – mostly C++ on VS Code or Turbo C++)

🔍 Types of Questions

• Write programs on:
  
  

• Pattern printing
  
  

• Number problems (Armstrong, Fibonacci, Palindrome)
  
  

• Data structures: Stack, Queue
  
  

• File handling
  
  

• Recursion-based tasks
  
  

✅ How to Prepare

• Focus on C++, as it's widely supported and familiar.
  
  

• Practice using VS Code, since it’s more stable than Turbo C++.
  
  

Learn to compile and run:

g++ filename.cpp

./a.exe

• Debug common errors (missing semicolons, unmatched brackets, etc.)
  
  

🧪 Practice Programs

• Print pyramid/star patterns.
  
  

• Check if a number is palindrome or Armstrong.
  
  

• Stack/Queue using arrays or linked list.
  
  

• Read/write from files using fstream.
  
  

• Recursion: factorial, power, reverse string.
  
  

📌 Tip

Save your code, compile, run, and take screenshots of output and source code for each task.

🌐 4. Networking

🔍 Types of Questions

• Use of network commands:
  
  

• ping, ipconfig, tracert, nslookup
  
  

• Network design using Cisco Packet Tracer.
  
  

• Create a small office network with VLANs, DNS setup, routers/switches.
  
  

• Assign IPs manually or via DHCP.
  
  

✅ How to Prepare

• Learn and practice:
  
  

• CLI commands in Windows CMD or Linux terminal [Most important]
  
  

• Basic subnetting and IP allocation.
  
  

• Although Cisco Packet Tracer related questions were not asked in our exam, there can be possibility : Cisco Packet Tracer:
  
  

• Connecting routers, switches, PCs
  
  

• Configuring static IP, DNS server
  
  

• Creating VLANs and assigning ports

• TIP FOR CLI: You can get hint from windows cmd if you get confused for commands.

📌 Tip

Learn to simulate network and verify connectivity using ping. Save configuration screenshots for documentation.

📚 General Preparation Tips

• 📸 Document everything: Take step-by-step screenshots and paste them into MS Word.
  
  

• ⏱️ Time management: Practice completing each task under exam time constraints.
  
  

• 💡 Revise basics: Don’t ignore fundamental concepts — they appear most often.
  
  

• ⚙️ Setup your environment: Have VS Code with C/C++ compiler, MySQL with XAMPP.
  
  

• 📁 Create a folder structure: Save your work under clear folder names (e.g., OS_Task1, DBMS_Query1, etc.)
  
  

🎯 Final Word

The practical test is your chance to show not just knowledge but real-world problem-solving skills. Focus on accuracy, clarity, and completeness. Practice daily on a computer, simulate the test environment, and build confidence.

Remember: You won’t be judged only on whether your solution is perfect — but also on whether you can approach the problem methodically, present your process clearly, and document it well.

✅ Best of luck!
Make sure your preparation is as “practical” as the test itself! 💪