Computer Science Study Guide
This guide covers computer fundamentals, programming, and IT concepts essential for Rajasthan competitive exams including RSCIT, Patwari, and Police Constable.
Computer Fundamentals
- Generations of Computers: First (Vacuum Tubes) to Fifth (AI) generation characteristics
- Computer Organisation: Input/Output devices, CPU (ALU + CU), Memory (RAM/ROM/Cache)
- Types of Software: System software (OS, drivers), Application software, Utility programs
- Number Systems: Binary, Octal, Decimal, Hexadecimal conversions
- Computer Languages: Machine level, Assembly, High-level (C, Java, Python)
Operating System & Networking
- OS Functions: Process management, Memory management, File management
- Types of OS: Batch, Real-time, Time-sharing, Distributed, Multi-user (Windows, Linux, macOS)
- Network Types: LAN, MAN, WAN; Topologies (Star, Bus, Ring, Mesh)
- Internet Protocols: TCP/IP, HTTP/HTTPS, FTP, SMTP, DNS, DHCP
- IP Addressing: IPv4 vs IPv6, Classes A-E, Subnet mask
MS Office & Database
- MS Word: Mail merge, Table of contents, Track changes, Shortcuts
- MS Excel: Formulas (SUM, VLOOKUP, IF), Pivot tables, Charts, Cell references
- MS PowerPoint: Slide transitions, Animations, Master slide
- DBMS Concepts: Tables, Keys (Primary/Foreign), Normalisation, SQL basics
Cybersecurity & IT Acts
- Common Threats: Virus, Worm, Trojan, Phishing, Ransomware, Spyware
- Protection: Firewall, Antivirus, Encryption (SSL/TLS), Digital Signature
- IT Act 2000: Legal framework for e-commerce, cyber crimes, penalties
- Important Terms: Cookies, Cache, VPN, HTTPS, Two-factor authentication