RSCIT Quick Revision
Key concepts, shortcuts, and important topics for RSCIT computer literacy exam
Select Revision Category
Topic-wise Revision Points
Computer Fundamentals
- Computer generations: 1st (Vacuum Tubes), 2nd (Transistors), 3rd (IC), 4th (Microprocessor), 5th (AI)
- Types: Analog (continuous data), Digital (discrete data), Hybrid (both)
- Input devices: Keyboard, Mouse, Scanner, Microphone, Touchscreen, Light Pen, Barcode Reader
- Output devices: Monitor, Printer (Laser/Inkjet/Dot Matrix), Speaker, Projector, Plotter
- Memory: RAM (Volatile), ROM (Non-volatile), Cache, Register, Secondary (HDD, SSD, Pen drive)
- CPU components: ALU (Arithmetic Logic Unit), CU (Control Unit), Registers
MS Word
- File extensions: .doc (Word 97-2003), .docx (Word 2007+), .dot (Template)
- Mail Merge: Used to send same letter to multiple recipients - Data Source + Main Document
- Page Layout: Margins, Orientation (Portrait/Landscape), Size, Columns, Breaks
- Headers & Footers: Text appearing on every page (top/bottom margin area)
- Table of Contents: Auto-generated from heading styles (H1, H2, H3)
- Track Changes: Feature to show edits made by different reviewers
MS Excel
- Workbook (.xlsx) contains Worksheets, Worksheet contains Cells
- Cell reference: A1 (Column A Row 1), $A$1 (Absolute), A$1 (Mixed)
- Common functions: SUM(), AVERAGE(), COUNT(), MAX(), MIN(), IF(), VLOOKUP()
- Charts: Column, Bar, Line, Pie, Scatter - Pie shows percentage/proportion
- Sorting: Arrange data alphabetically/numerically (A-Z or Z-A)
- Filtering: Show only rows meeting specific criteria using AutoFilter
- Conditional Formatting: Auto-format cells based on their values
MS PowerPoint
- File extension: .pptx (PowerPoint 2007+), .ppt (PowerPoint 97-2003)
- Slide Layouts: Title Slide, Title and Content, Comparison, Blank
- Animations: Motion effects applied to elements ON a slide
- Transitions: Effects applied when moving FROM one slide TO the next
- Slide Master: Controls overall appearance (fonts, colors, backgrounds) of all slides
- Slide Sorter View: Shows thumbnail versions of all slides for easy reordering
- F5: Start slideshow from beginning, Shift+F5: Start from current slide
Internet & Email
- HTTP (port 80): HyperText Transfer Protocol - unsecured web communication
- HTTPS (port 443): Secure version using SSL/TLS encryption - shows lock icon in browser
- FTP (port 21): File Transfer Protocol for uploading/downloading files
- SMTP (port 25): Simple Mail Transfer Protocol - SENDING emails
- POP3 (port 110): Post Office Protocol - DOWNLOADING emails to device
- IMAP (port 143): Internet Message Access Protocol - emails stay on server
- CC: Carbon Copy (all recipients visible), BCC: Blind Carbon Copy (recipients hidden)
- Browser: Chrome, Firefox, Edge, Safari - Search Engine: Google, Bing, Yahoo
Computer Networks
- LAN (Local Area Network): Small area (office, building) - High speed
- MAN (Metropolitan Area Network): City-wide area
- WAN (Wide Area Network): Large geographical area (country, world) - Internet is largest WAN
- Network Topologies: Star (hub/switch center), Bus (single cable), Ring (circular), Mesh (all connected)
- IP Address: IPv4 (32-bit, e.g., 192.168.1.1), IPv6 (128-bit, e.g., 2001:db8::1)
- DNS (Domain Name System): Converts domain names to IP addresses
Cyber Security & IT Act
- Virus: Malicious program that replicates and spreads to other files
- Malware: Malicious software (includes viruses, worms, trojans, ransomware, spyware)
- Firewall: Security system that monitors incoming/outgoing network traffic
- Phishing: Fake emails/messages tricking users to reveal sensitive information
- IT Act 2000 (India): Primary law dealing with cyber crimes, e-commerce, digital signatures
- Section 66: Deals with computer-related offenses (hacking)
- Safe browsing: Use HTTPS, strong passwords, avoid unknown links, update software regularly
Database Concepts
- DBMS (Database Management System): Software to manage databases (MySQL, Oracle, MS Access)
- Table: Collection of related data organized in rows (records) and columns (fields)
- Primary Key: Uniquely identifies each record in a table (e.g., Student ID)
- Foreign Key: Links tables by referencing primary key of another table
- SQL: Structured Query Language - used to interact with databases
- Basic SQL: SELECT, INSERT, UPDATE, DELETE, CREATE TABLE, DROP TABLE
- Query: A request for data or information from a database table
Memory Aids & Mnemonics
Computer Generations: Very Tiny IC Made AI (Vacuum Tubes, Transistors, IC, Microprocessor, AI)
OSI Model: Please Do Not Throw Sausage Pizza Away (Physical, Data Link, Network, Transport, Session, Presentation, Application)
Memory Units: Big Kangaroos Make Good Teachers (Byte < KB < MB < GB < TB) - ascending order
Email Protocols: S Send (SMTP), P Pick (POP3), I Inbox (IMAP)
HTML: Head-Body (Head contains metadata, Body contains visible content)
Important Formulas & Rules
Excel: Every formula starts with = sign
Excel: $A$1 makes cell reference absolute (doesn't change when copied)
1 Byte = 8 Bits, 1 KB = 1024 Bytes, 1 MB = 1024 KB, 1 GB = 1024 MB, 1 TB = 1024 GB
Network: Speed (LAN > MAN > WAN), Coverage (WAN > MAN > LAN)
Browser refreshes: F5 (refresh), Ctrl+F5 (hard refresh - clears cache)
Revision Strategy
First Pass (30 minutes)
Quickly scan all topics. Identify areas where you feel less confident. Mark them for focused revision.
Deep Revision (60 minutes)
Study marked topics thoroughly. Write down key points. Create your own mnemonics for difficult concepts.
Practice (45 minutes)
Solve 10-15 questions from this category. Apply the formulas and techniques you just revised.
Final Review (15 minutes)
Go through mnemonics and formulas one more time. Note down any remaining doubts for later clarification.