0% found this document useful (0 votes)
6 views120 pages

RSCIT

The document provides comprehensive notes for the RSCIT exam, covering essential topics such as computer basics, MS Word, MS Excel, and more. It includes quick concept notes, important MCQ points, and exam traps to help students maximize their scores. The content is structured in chapters with detailed explanations, memory tricks, and shortcuts for effective revision.

Uploaded by

rupaalupsc
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
6 views120 pages

RSCIT

The document provides comprehensive notes for the RSCIT exam, covering essential topics such as computer basics, MS Word, MS Excel, and more. It includes quick concept notes, important MCQ points, and exam traps to help students maximize their scores. The content is structured in chapters with detailed explanations, memory tricks, and shortcuts for effective revision.

Uploaded by

rupaalupsc
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

🏆 ULTRA-SMART RSCIT COMPLETE NOTES

RKCL EXAM DOMINATION SYSTEM 2024-25

By: Elite RSCIT Strategy Engine

⚡ MISSION: Maximum Score | Fastest Revision | Zero Confusion | Full Marks Strategy

📚 COMPLETE CHAPTER INDEX

Chapter Topic Weightage


1 Computer Basics & Fundamentals
2 MS Word 2010
3 MS Excel 2010
4 MS PowerPoint 2010
5 Internet & Email
6 Cyber Security
7 Digital Payments
8 Government Digital Services
9 Mobile Devices
10 Cloud Computing & Emerging Tech

═══════════════════════════════════

📖 CHAPTER 1: COMPUTER BASICS & FUNDAMENTALS

═══════════════════════════════════
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

PART 1 — QUICK CONCEPT NOTES

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

🖥️ COMPUTER DEFINITION

• Computer = Electronic device that processes data → gives information


• Data = Raw facts (unprocessed)
• Information = Processed data (meaningful output)
• COMPUTER Full Form = Common Operating Machine Purposely Used for Technical and Educational
Research

🔄 IPO CYCLE (Most Asked!)

text
INPUT → PROCESS → OUTPUT
(Data) (CPU) (Information)

• Input devices → Data लेते हैं (Keyboard, Mouse)


• CPU → Process करता है (Brain of Computer)
• Output devices → Result दे ते हैं (Monitor, Printer)

🧠 TYPES OF MEMORY

Memory Full Form Type Speed Cost


RAM Random Access Memory Volatile Fast Medium
ROM Read Only Memory Non-Volatile Medium Low
Cache Cache Memory Volatile Fastest Highest
HDD Hard Disk Drive Non-Volatile Slow Lowest
SSD Solid State Drive Non-Volatile Fast High

⚡ MEMORY TRICK:

"RAM = Temporary (बंद होने पर data जाता है)"


"ROM = Permanent (बंद होने पर data रहता है)"

💾 STORAGE UNITS (Exam Favorite!)

Unit Value Trick


1 Bit 0 or 1 Smallest unit
1 Nibble 4 Bits Half byte
1 Byte 8 Bits Most Asked
1 KB 1024 Bytes Kilo
1 MB 1024 KB Mega
1 GB 1024 MB Giga
1 TB 1024 GB Tera
1 PB 1024 TB Peta

⚡ MEMORY TRICK:

"Bit Nibble Byte KB MB GB TB PB"


"Bade Nana Bhi Kaam Mein Gaye The Pyaar se"

🖥️ GENERATIONS OF COMPUTERS

Gen Year Technology Key Word


1st 1940-56 Vacuum Tubes ENIAC
2nd 1956-63 Transistors Smaller
3rd 1964-71 IC (Integrated Circuit) IC Chips
4th 1971-present Microprocessor VLSI
5th Present+ AI / Machine Learning AI

⚡ MEMORY TRICK:

"VTI MV A" = Vacuum Tube → Transistor → IC → Micro → AI

🔧 HARDWARE vs SOFTWARE

Hardware Software
Physical parts Programs/instructions

Touch कर सकते हैं Touch नह ीं कर सकते


Monitor, CPU, Mouse MS Word, Windows
Made of metal/plastic Made of code

Types of Software:

• System Software = OS (Windows, Linux, Android)


• Application Software = MS Word, Chrome, Tally
• Utility Software = Antivirus, Disk Cleaner
🖱️ INPUT DEVICES (Important List!)

• Keyboard → Text input


• Mouse → Pointing device
• Scanner → Document to digital
• Microphone → Sound input
• Webcam → Video input
• Joystick → Gaming
• Light Pen → Drawing
• Barcode Reader → Barcode scan
• OMR → Optical Mark Reader (Exam sheets)
• OCR → Optical Character Reader
• MICR → Magnetic Ink Character Recognition (Bank cheques)

🖨️ OUTPUT DEVICES

• Monitor → Display
• Printer → Hard copy
• Speaker → Sound
• Projector → Presentation
• Plotter → Large drawings/maps

🖨️ PRINTER TYPES (Exam Trap!)

Printer Technology Use


Inkjet Ink spray Photos, Color
Laser Laser + toner Office, Fast
Dot Matrix Pins + ribbon Bills, Impact
Thermal Heat ATM receipts
Plotter Pens/cutters Maps, Banners

⌨️ KEYBOARD TYPES

• QWERTY → Most common (आज का standard)


• DVORAK → Faster typing layout
• AZERTY → French keyboard

🖥️ MONITOR TYPES

• CRT → Cathode Ray Tube (पुराना, बडा)


• LCD → Liquid Crystal Display
• LED → Light Emitting Diode
• TFT → Thin Film Transistor
• OLED → Organic LED (latest)
💻 TYPES OF COMPUTERS (By Size)

Type Example Size


Supercomputer PARAM Largest
Mainframe IBM z15 Very Large
Mini Computer PDP-11 Medium
Micro Computer Desktop/Laptop Small
Embedded Computer ATM, Washing Machine Smallest

⚡ India's Supercomputer:

PARAM = India's first supercomputer (C-DAC द्वारा बनाया)


PARAM 8000 = First, PRATYUSH = Current Weather

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

PART 2 — MOST IMPORTANT MCQ POINTS

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

• ⭐ 1 Byte = 8 Bits (सबसे ज्यादा पूछा जाता है)


• ⭐ RAM = Volatile / Temporary Memory
• ⭐ ROM = Non-Volatile / Permanent Memory
• 🔥 CPU = Central Processing Unit = Brain of Computer
• 🔥 ALU = Arithmetic Logic Unit (CPU का भाग)
• 🔥 CU = Control Unit (CPU का भाग)
• ✅ ENIAC = First electronic computer (1st Gen)
• ✅ PARAM = India's supercomputer
• ⭐ Mouse = Pointing Device
• 🔥 MICR = Bank cheques में use होता है
• ⭐ OMR = Exam answer sheets में
• 🔥 Laser Printer = Fast + Quality
• ⭐ Dot Matrix = Impact Printer
• ✅ 1 KB = 1024 Bytes (NOT 1000)
• 🔥 4th Generation = Microprocessor
• ⭐ 5th Generation = AI/Artificial Intelligence
• ✅ Volatile Memory = Data lost on power off
• 🔥 Input + Process + Output = IPO Cycle
• ⭐ Hardware = Physical, Software = Logical
• 🔥 Antivirus = Utility Software
• ✅ Windows = System Software / OS
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

PART 4 — EXAM TRAP ALERTS ⚠️

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

🚨 TRAP 1: 1 KB = ?

❌ Students write 1000 Bytes


✅ CORRECT = 1024 Bytes

🚨 TRAP 2: RAM vs ROM

❌ Students confuse volatile/non-volatile


✅ RAM = Volatile (data जाता है)
✅ ROM = Non-Volatile (data रहता है)

🚨 TRAP 3: Input vs Output

❌ Scanner confusion
✅ Scanner = Input Device (paper → digital)
✅ Printer = Output Device (digital → paper)

🚨 TRAP 4: Software Types

❌ Students put Antivirus in Application Software


✅ Antivirus = Utility Software
✅ MS Word = Application Software
✅ Windows = System Software

🚨 TRAP 5: MICR vs OCR vs OMR

MICR = Bank cheques (Magnetic Ink)


OCR = Text recognition from images
OMR = Bubble sheet exam answers
🚨 TRAP 6: Generation Technology

❌ 3rd Gen = Transistor (WRONG)


✅ 2nd Gen = Transistor
✅ 3rd Gen = IC (Integrated Circuit)

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

PART 5 — RAPID REVISION BLOCK ⚡

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

text
⚡ 5-MINUTE REVISION — COMPUTER BASICS

✅ 1 Byte = 8 Bits
✅ 1 KB = 1024 Bytes
✅ RAM = Volatile, ROM = Non-Volatile
✅ CPU = Brain = ALU + CU + Registers
✅ ENIAC = 1st Computer
✅ PARAM = India's Supercomputer
✅ MICR = Bank cheques
✅ OMR = Exam sheets
✅ Scanner = INPUT, Printer = OUTPUT
✅ Antivirus = Utility Software
✅ Windows = System Software
✅ 1st Gen = Vacuum Tube
✅ 2nd Gen = Transistor
✅ 3rd Gen = IC
✅ 4th Gen = Microprocessor
✅ 5th Gen = AI
✅ Laser Printer = Fast, Quality
✅ Dot Matrix = Impact Printer
✅ Mouse = Pointing Device
✅ QWERTY = Standard Keyboard
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

PART 6 — MEMORY OPTIMIZATION 🧠

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

🔮 MNEMONIC: CPU Parts

"ACR" = ALU + Control Unit + Registers

🔮 MNEMONIC: Storage Order

"Big Naughty Boys Kill Many Girls These Precious days"


Bit → Nibble → Byte → KB → MB → GB → TB → PB

🔮 MNEMONIC: Computer Generations

"Very Tired Indians Make AI"


Vacuum → Transistor → IC → Microprocessor → AI

🔮 MNEMONIC: Software Types

"SUA" = System → Utility → Application

═══════════════════════════════════

📖 CHAPTER 2: MS WORD 2010

═══════════════════════════════════
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

PART 1 — QUICK CONCEPT NOTES

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

📝 MS WORD BASICS

• MS Word = Word Processing Software by Microsoft


• Extension = .docx (Word 2007+), .doc (older)
• Default Font = Calibri
• Default Font Size = 11pt
• Default Page Size = A4
• Default Margins = 1 inch (all sides)

🖥️ MS WORD 2010 INTERFACE

text
TITLE BAR → File name + Program name
RIBBON → Tabs with commands (Home, Insert, Page Layout...)
QUICK ACCESS TOOLBAR → Save, Undo, Redo (top left)
STATUS BAR → Page number, word count (bottom)
RULER → Margin + indent control
SCROLL BAR → Navigate document

📑 MS WORD TABS & THEIR KEY FUNCTIONS

Tab Key Functions


Home Font, Paragraph, Clipboard, Styles
Insert Table, Picture, Header/Footer, Page Break
Page Layout Margins, Orientation, Page Size, Columns
References Table of Contents, Footnote, Citation
Mailings Mail Merge, Labels, Envelopes
Review Spell Check, Track Changes, Comments
View Zoom, Reading Layout, Gridlines

🔤 FONT GROUP (Home Tab)

• Bold = Ctrl+B
• Italic = Ctrl+I
• Underline = Ctrl+U
• Font Size Increase = Ctrl+Shift+>
• Font Size Decrease = Ctrl+Shift+<
• Change Case = Shift+F3
• Clear Formatting = Ctrl+Space
📄 PARAGRAPH ALIGNMENT

Alignment Shortcut Use


Left Ctrl+L Default
Center Ctrl+E Headings
Right Ctrl+R Dates
Justify Ctrl+J Books/formal

🖨️ PAGE SETUP (Page Layout Tab)

• Orientation → Portrait (vertical) / Landscape (horizontal)


• Portrait = Default ← Exam Trap!
• Margins → Normal = 1 inch
• Paper Size → A4 (Default)
• Columns → Newspaper style text

📊 IMPORTANT WORD FEATURES

Feature Location Use


Mail Merge Mailings Tab Bulk letters
Track Changes Review Tab Edit tracking
Word Count Review Tab Count words
Spell Check Review Tab / F7 Grammar fix
Header/Footer Insert Tab Page header
Watermark Page Layout Background text
Table of Contents References Auto contents
Footnote References Bottom note

📋 CLIPBOARD GROUP

• Cut = Ctrl+X (काटना)


• Copy = Ctrl+C (नकल करना)
• Paste = Ctrl+V (चिपकाना)
• Undo = Ctrl+Z (वापस करना)
• Redo = Ctrl+Y (फिर करना)
• Select All = Ctrl+A

🔍 FIND & REPLACE

• Find = Ctrl+F
• Replace = Ctrl+H
• Go To = Ctrl+G
💾 FILE OPERATIONS

• New = Ctrl+N
• Open = Ctrl+O
• Save = Ctrl+S
• Save As = F12
• Print = Ctrl+P
• Close = Ctrl+W
• Exit = Alt+F4

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

PART 2 — MOST IMPORTANT MCQ POINTS

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

• ⭐ MS Word extension = .docx


• ⭐ Default font = Calibri, Size = 11
• 🔥 Mail Merge = Mailings Tab
• ✅ Spell Check = F7
• ⭐ Ctrl+Z = Undo (Most asked shortcut)
• 🔥 Track Changes = Review Tab
• ✅ Watermark = Page Layout Tab
• ⭐ Portrait = Default Orientation
• 🔥 Ctrl+H = Find & Replace
• ✅ Header/Footer = Insert Tab
• ⭐ Word Count = Review Tab
• 🔥 F12 = Save As
• ✅ Ctrl+E = Center Align
• ⭐ Default page size = A4
• 🔥 Footnote = References Tab
• ✅ Ctrl+Home = Go to beginning of document
• ⭐ Ctrl+End = Go to end of document

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

PART 3 — SHORTCUT KEY MASTER TABLE

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

🔑 MS WORD COMPLETE SHORTCUT TABLE

Shortcut Function Memory Trick


Ctrl+N New Document New
Ctrl+O Open Open
Ctrl+S Save Save
Ctrl+P Print Print
Ctrl+W Close Window close
Ctrl+Z Undo Zap back
Ctrl+Y Redo Yes redo
Ctrl+X Cut Scissors (X shape)
Ctrl+C Copy Copy
Ctrl+V Paste Velcro (sticks)
Ctrl+A Select All All
Ctrl+B Bold Bold
Ctrl+I Italic Italic
Ctrl+U Underline Underline
Ctrl+L Left Align Left
Ctrl+E Center Center
Ctrl+R Right Align Right
Ctrl+J Justify Justify
Ctrl+F Find Find
Ctrl+H Replace Hunt & Replace
Ctrl+G Go To Go
Ctrl+Home Start of Doc Home = Start
Ctrl+End End of Doc End = Last
F7 Spell Check F7 = Check
F12 Save As F12 = Save As
Shift+F3 Change Case Case Change
Alt+F4 Exit Program Alt F4 = Close all
Ctrl+K Hyperlink LinK
Ctrl+D Font Dialog Font Dialog
Ctrl+T Hanging Indent Tab indent
Ctrl+1 Single Line Space 1 line
Ctrl+2 Double Line Space 2 lines
Ctrl+5 1.5 Line Space 1.5 lines
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

PART 4 — EXAM TRAP ALERTS ⚠️

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

🚨 TRAP 1: .doc vs .docx

❌ Students say .doc is Word 2010


✅ Word 2010 = .docx
✅ .doc = Word 97-2003

🚨 TRAP 2: Ctrl+Z vs Ctrl+Y

✅ Ctrl+Z = UNDO (पपछला काम वापस)


✅ Ctrl+Y = REDO (UNDO को वापस)

🚨 TRAP 3: Save vs Save As

✅ Ctrl+S = Save (same location, same name)


✅ F12 = Save As (new name/location)

🚨 TRAP 4: Find vs Replace

✅ Ctrl+F = Find only


✅ Ctrl+H = Find AND Replace

🚨 TRAP 5: Mail Merge Location

❌ Students say Insert Tab


✅ Mail Merge = Mailings Tab

🚨 TRAP 6: Spell Check

❌ Ctrl+S = Spell Check (WRONG - यह Save है)


✅ F7 = Spell Check
🚨 TRAP 7: Watermark Location

❌ Insert Tab (WRONG)


✅ Watermark = Page Layout Tab

🚨 TRAP 8: Word Count

✅ Word Count = Review Tab (not Home)


✅ Also visible in Status Bar (bottom)

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

PART 5 — RAPID REVISION BLOCK ⚡

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

text
⚡ MS WORD — 5-MINUTE RAPID REVISION

📁 Extension = .docx
🔤 Default Font = Calibri, Size = 11
📄 Default Page = A4, Portrait
📧 Mail Merge = Mailings Tab
🔍 Spell Check = F7
💾 Save = Ctrl+S | Save As = F12
🔍 Find = Ctrl+F | Replace = Ctrl+H
↩️ Undo = Ctrl+Z | Redo = Ctrl+Y
🖨️ Print = Ctrl+P
📋 Select All = Ctrl+A
✂️ Cut=X, Copy=C, Paste=V (Ctrl+)
📝 Bold=B, Italic=I, Underline=U (Ctrl+)
📐 Left=L, Center=E, Right=R, Justify=J (Ctrl+)
💧 Watermark = Page Layout Tab
📊 Track Changes = Review Tab
📌 Header/Footer = Insert Tab
📖 Footnote = References Tab
🏠 Ctrl+Home = Start | Ctrl+End = End
═══════════════════════════════════

📖 CHAPTER 3: MS EXCEL 2010

═══════════════════════════════════

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

PART 1 — QUICK CONCEPT NOTES

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

📊 MS EXCEL BASICS

• MS Excel = Spreadsheet software by Microsoft


• Extension = .xlsx (Excel 2007+), .xls (older)
• Default font = Calibri, 11pt
• File = Workbook
• Sheet = Worksheet
• Default sheets = 3 sheets (Sheet1, Sheet2, Sheet3)
• Max rows = 1,048,576
• Max columns = 16,384 (XFD)
• Max sheets = Limited by memory

📐 CELL ADDRESSING (Most Asked!)

text
CELL = Intersection of Row + Column
Cell Name = Column Letter + Row Number
Example: A1, B5, C10, Z100

ACTIVE CELL = Currently selected cell


NAME BOX = Shows active cell address (top left)
FORMULA BAR = Shows cell content/formula

📊 EXCEL INTERFACE

Element Location Function


Name Box Top Left Cell address
Formula Bar Top Center Cell content
Column Headers A, B, C... Column names
Row Headers 1, 2, 3... Row numbers
Sheet Tabs Bottom Sheet navigation
Status Bar Bottom Sum, Count, Average

🔢 DATA TYPES IN EXCEL

Type Example Alignment


Text Name, City Left aligned
Number 100, 3.14 Right aligned
Date 01/01/2024 Right aligned
Formula =A1+B1 Right aligned
Boolean TRUE/FALSE Center aligned

⚡ EXAM TIP:

Text = Left, Number = Right (Default alignment)

🔢 FORMULAS (Most Important!)

Basic Formula Rules:

• Always start with = (equal sign)


• Cell reference used instead of values
• Relative = changes when copied (A1)
• Absolute = doesn't change ($ sign) → $A$1

📐 IMPORTANT EXCEL FUNCTIONS

Function Syntax Use


SUM =SUM(A1:A10) Total
AVERAGE =AVERAGE(A1:A10) Mean
MAX =MAX(A1:A10) Largest
MIN =MIN(A1:A10) Smallest
COUNT =COUNT(A1:A10) Count numbers
COUNTA =COUNTA(A1:A10) Count non-empty
IF =IF(condition,true,false) Condition
VLOOKUP =VLOOKUP(lookup,range,col,0) Vertical search
HLOOKUP =HLOOKUP(lookup,range,row,0) Horizontal search
CONCATENATE =CONCATENATE(A1,B1) Join text
LEFT =LEFT(text,n) Left characters
RIGHT =RIGHT(text,n) Right characters
MID =MID(text,start,n) Middle chars
LEN =LEN(text) Text length
UPPER =UPPER(text) UPPERCASE
LOWER =LOWER(text) lowercase
PROPER =PROPER(text) Title Case
TODAY =TODAY() Current date
NOW =NOW() Current date+time
PMT =PMT(rate,nper,pv) Loan payment

📊 CHARTS IN EXCEL

Chart Type Best For


Bar/Column Comparison
Pie Percentage/Parts
Line Trends over time
Area Volume over time
Scatter Correlation

Insert Chart: Insert Tab → Charts Group

🔽 SORTING & FILTERING

• Sort = Data Tab → Sort (A-Z or Z-A)


• Filter = Data Tab → AutoFilter
• Freeze Panes = View Tab → Freeze Panes
• Wrap Text = Home Tab → Alignment Group

📊 CONDITIONAL FORMATTING

• Location: Home Tab → Conditional Formatting


• Use: Color cells based on values
• Types: Color scale, Data bars, Icon sets

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

PART 2 — MOST IMPORTANT MCQ POINTS

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

• ⭐ Excel extension = .xlsx


• ⭐ Formula starts with = (equal sign)
• 🔥 Max rows = 1,048,576
• 🔥 Max columns = 16,384
• ✅ Workbook = Excel file
• ⭐ Worksheet = Single sheet
• 🔥 Name Box = Cell address
• ✅ Formula Bar = Shows formula/content
• ⭐ $ sign = Absolute reference
• 🔥 =SUM() = Total function
• ✅ =AVERAGE() = Mean function
• ⭐ Text = Left aligned (default)
• 🔥 Number = Right aligned (default)
• ✅ Ctrl+; = Current Date shortcut
• ⭐ Chart Insert = Insert Tab
• 🔥 Sort/Filter = Data Tab
• ✅ Conditional Formatting = Home Tab
• ⭐ Freeze Panes = View Tab
• 🔥 =IF() = Logical function
• ✅ =VLOOKUP() = Vertical lookup
• ⭐ Default sheets = 3

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

PART 3 — EXCEL SHORTCUT MASTER TABLE

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

Shortcut Function Trick


Ctrl+N New workbook New
Ctrl+S Save Save
Ctrl+Z Undo Zap back
Ctrl+Home Go to A1 Start
Ctrl+End Last used cell End
Ctrl+Arrow Jump to edge Move fast
F2 Edit cell Edit mode
F4 Repeat/Absolute ref $$ sign
F11 Create chart Fast chart
Ctrl+; Current Date Date shortcut
Ctrl+Shift+; Current Time Time shortcut
Alt+= AutoSum Quick sum
Ctrl+1 Format Cells Format dialog
Ctrl+Shift+L AutoFilter Filter on/off
Ctrl+D Fill Down Copy down
Ctrl+R Fill Right Copy right
Delete Clear content Remove data
Ctrl+- Delete row/col Minus = delete
Ctrl++ Insert row/col Plus = insert
Shift+F11 New sheet New tab

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

PART 4 — EXAM TRAP ALERTS ⚠️

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

🚨 TRAP 1: .xls vs .xlsx

✅ Excel 2010 = .xlsx


✅ Old Excel (97-2003) = .xls

🚨 TRAP 2: COUNT vs COUNTA

✅ COUNT = Only numbers count करता है


✅ COUNTA = All non-empty cells count करता है

🚨 TRAP 3: Absolute vs Relative Reference

✅ A1 = Relative (copy पर change होती है)


✅ $A$1 = Absolute (copy पर change नह ीं होती)
✅ $A1 = Mixed (column fixed, row changes)

🚨 TRAP 4: MAX rows/columns

❌ Students write 65536 rows (old Excel)


✅ Excel 2010 = 1,048,576 rows
✅ Excel 2010 = 16,384 columns

🚨 TRAP 5: Formula without =

❌ SUM(A1:A10) without = sign


✅ Formula MUST start with = sign

🚨 TRAP 6: VLOOKUP vs HLOOKUP

✅ VLOOKUP = Vertical (columns में search)


✅ HLOOKUP = Horizontal (rows में search)
🚨 TRAP 7: Workbook vs Worksheet

✅ Workbook = Entire Excel File (.xlsx)


✅ Worksheet = Individual Sheet (Sheet1, Sheet2)

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

PART 5 — RAPID REVISION BLOCK ⚡

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

text
⚡ MS EXCEL — 5-MINUTE RAPID REVISION

📊 Extension = .xlsx
📁 File = Workbook, Sheet = Worksheet
📐 Default sheets = 3
📏 Max rows = 1,048,576 | Max cols = 16,384
🔢 Formula starts with = sign
💲 Absolute reference = $A$1
📊 Text = Left aligned | Number = Right aligned
🔢 =SUM() =AVERAGE() =MAX() =MIN()
🔢 =IF() = Logical | =VLOOKUP() = Vertical search
📅 =TODAY() = Date | =NOW() = Date+Time
📈 Chart = Insert Tab | Sort = Data Tab
🎨 Conditional Formatting = Home Tab
🔒 Freeze Panes = View Tab
⌨️ Alt+= = AutoSum | F2 = Edit cell
⌨️ F11 = Create Chart | F4 = Absolute ref
⌨️ Ctrl+; = Current Date

═══════════════════════════════════

📖 CHAPTER 4: MS POWERPOINT 2010

═══════════════════════════════════
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

PART 1 — QUICK CONCEPT NOTES

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

📊 MS POWERPOINT BASICS

• PowerPoint = Presentation software


• Extension = .pptx (2007+), .ppt (older)
• File = Presentation
• Page = Slide
• Default view = Normal View
• Default layout = Title Slide

🖥️ POWERPOINT VIEWS

View Use Shortcut


Normal View Create/Edit slides Default
Slide Sorter Rearrange slides View Tab
Reading View View presentation View Tab
Slide Show Present to audience F5
Notes Page Add speaker notes View Tab
Presenter View Dual screen present F5

🎨 DESIGN ELEMENTS

Feature Location Use


Themes Design Tab Slide design
Background Design Tab Slide background
Layout Home Tab Slide layout
Transition Transitions Tab Slide change effect
Animation Animations Tab Object movement
Slide Master View Tab Global design

🎬 TRANSITIONS vs ANIMATIONS

text
TRANSITION = Slide to Slide effect
(How slide appears/disappears)
Location: TRANSITIONS TAB

ANIMATION = Object on slide effect


(How text/image moves on slide)
Location: ANIMATIONS TAB
⚡ EXAM TRAP:

Transition = Slide effect, Animation = Object effect

📊 SLIDE SHOW OPTIONS

• Start from Beginning = F5


• Start from Current Slide = Shift+F5
• Next Slide = Enter / Page Down / Arrow
• Previous Slide = Backspace / Page Up
• End Show = Esc
• Black Screen = B key during show
• White Screen = W key during show

📝 IMPORTANT POWERPOINT FEATURES

Feature Tab Description


SmartArt Insert Professional diagrams
WordArt Insert Stylish text
Action Button Insert Navigation buttons
Hyperlink Insert Link to URL/slide
Header/Footer Insert Slide header
Slide Number Insert Auto numbering
Photo Album Insert Multiple photos
Screen Recording Insert Record screen

📐 LAYOUT TYPES

• Title Slide
• Title and Content
• Two Content
• Blank
• Picture with Caption
• Title Only

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

PART 2 — MOST IMPORTANT MCQ POINTS

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

• ⭐ Extension = .pptx
• ⭐ F5 = Start Slide Show from beginning
• 🔥 Shift+F5 = Start from current slide
• ✅ Transition = Slide effect (Transitions Tab)
• ⭐ Animation = Object effect (Animations Tab)
• 🔥 Esc = End slide show
• ✅ Normal View = Default view
• ⭐ Slide Sorter = Rearrange slides
• 🔥 Design Tab = Themes, Background
• ✅ B = Black screen during show
• ⭐ W = White screen during show
• 🔥 SmartArt = Insert Tab
• ✅ Slide Master = View Tab
• ⭐ Default layout = Title Slide

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

PART 3 — POWERPOINT SHORTCUT TABLE

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

Shortcut Function
F5 Start show from beginning
Shift+F5 Start from current slide
Esc End slide show
Ctrl+M Insert new slide
Ctrl+D Duplicate slide
Ctrl+N New presentation
Ctrl+S Save
Ctrl+Z Undo
Ctrl+A Select all
B Black screen (during show)
W White screen (during show)
Ctrl+Shift+G Group objects
Tab Select next object
Delete Delete selected slide/object
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

PART 4 — EXAM TRAP ALERTS ⚠️

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

🚨 TRAP 1: Transition vs Animation

❌ Students confuse tabs


✅ Transitions Tab = Slide change effect
✅ Animations Tab = Object on slide effect

🚨 TRAP 2: F5 vs Shift+F5

✅ F5 = Beginning se start
✅ Shift+F5 = Current slide se start

🚨 TRAP 3: .ppt vs .pptx

✅ PowerPoint 2010 = .pptx


✅ Older = .ppt

🚨 TRAP 4: Slide vs Presentation

✅ Slide = एक page
✅ Presentation = Complete file (all slides)

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

PART 5 — RAPID REVISION BLOCK ⚡

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

text
⚡ MS POWERPOINT — 5-MINUTE REVISION

📁 Extension = .pptx
🖥️ Default view = Normal View
▶️ F5 = Start show | Shift+F5 = Current slide
⏹️ Esc = End show
🎬 B = Black | W = White (during show)
🎨 Transition = Slide effect (Transitions Tab)
✨ Animation = Object effect (Animations Tab)
🎨 Themes/Background = Design Tab
📊 SmartArt = Insert Tab
🔄 Slide Master = View Tab
📋 Slide Sorter = Rearrange view
➕ Ctrl+M = New slide
📋 Ctrl+D = Duplicate slide

═══════════════════════════════════

📖 CHAPTER 5: INTERNET & EMAIL

═══════════════════════════════════

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

PART 1 — QUICK CONCEPT NOTES

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

🌐 INTERNET BASICS

• Internet = Global network of networks


• WWW = World Wide Web (websites का collection)
• Internet ≠ WWW ← Exam Trap!
• Browser = Software to access internet (Chrome, Firefox)
• Search Engine = Website to search content (Google, Bing)
• ISP = Internet Service Provider (Jio, Airtel, BSNL)

🔗 IMPORTANT INTERNET TERMS

Term Full Form Meaning


URL Uniform Resource Locator Website address
HTTP HyperText Transfer Protocol Web data transfer
HTTPS HTTP Secure Encrypted web
FTP File Transfer Protocol File transfer
SMTP Simple Mail Transfer Protocol Email sending
POP3 Post Office Protocol v3 Email receiving
IMAP Internet Message Access Protocol Email sync
DNS Domain Name System Name to IP convert
IP Internet Protocol Device address
TCP Transmission Control Protocol Data delivery
HTML HyperText Markup Language Web page code
CSS Cascading Style Sheets Web page design
XML Extensible Markup Language Data format

🌐 URL STRUCTURE (Important!)

text
[Link]
│ │ │ │
Protocol www Domain Path
(HTTPS) (.com) (query)

Domain Extensions:

Extension Use
.com Commercial
.org Organization
.edu Education
.gov Government
.in India
.net Network
.[Link] Academic India

📧 EMAIL BASICS

Email Address Format:

text
username@[Link]
│ │
Name Server

Email Parts:

• To = Main recipient
• CC = Carbon Copy (everyone can see)
• BCC = Blind Carbon Copy (hidden recipients)
• Subject = Topic of email
• Attachment = File attached
Email Protocols:

text
SMTP = Email भेजना (Sending) → Port 25
POP3 = Email लेना (Receiving) → Port 110
IMAP = Email sync करना → Port 143

🌐 WEB BROWSERS

Browser Developer
Chrome Google
Firefox Mozilla
Edge Microsoft
Safari Apple
Opera Opera Software
Brave Brave Software

🔍 SEARCH ENGINES

Search Engine Company


Google Alphabet (Google LLC)
Bing Microsoft
Yahoo Yahoo! Inc
DuckDuckGo DDG Inc (Private)
Baidu China

🌐 NETWORKING BASICS

Term Meaning
LAN Local Area Network (एक building)
WAN Wide Area Network (cities/countries)
MAN Metropolitan Area Network (एक city)
PAN Personal Area Network (personal devices)
VPN Virtual Private Network (secure tunnel)
WiFi Wireless Fidelity
Bluetooth Short range wireless

⚡ MEMORY TRICK:

LAN = Local, MAN = Metro, WAN = Wide, PAN = Personal


📡 INTERNET CONNECTION TYPES

Type Speed Use


Dial-up Very Slow Old
DSL Medium Telephone line
Broadband Fast Cable/fiber
WiFi Fast Wireless
3G/4G/5G Mobile Smartphones
Fiber Optic Fastest Modern

🔒 IP ADDRESS

• IPv4 = 32-bit = 4 parts = [Link]


• IPv6 = 128-bit = 8 parts = Newer version
• Static IP = Fixed IP address
• Dynamic IP = Changes each session (DHCP)

🌐 WEBSITE vs WEBPAGE vs WEB SERVER

text
Web Server = Computer hosting websites
Website = Collection of webpages
Webpage = Single page (HTML)
Homepage = First/main page of website

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

PART 2 — MOST IMPORTANT MCQ POINTS

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

• ⭐ WWW ≠ Internet (WWW is part of Internet)


• ⭐ SMTP = Email sending protocol
• 🔥 POP3 = Email receiving protocol
• ✅ HTTP = Web browsing protocol
• ⭐ HTTPS = Secure web browsing
• 🔥 DNS = Name to IP conversion
• ✅ ISP = Internet Service Provider
• ⭐ Chrome = Google का browser
• 🔥 Google = Most popular search engine
• ✅ BCC = Hidden recipients
• ⭐ CC = All can see recipients
• 🔥 URL = Website address
• ✅ .gov = Government website
• ⭐ LAN = Local Area Network
• 🔥 WiFi = Wireless internet
• ✅ IPv4 = 32 bit address
• ⭐ IPv6 = 128 bit address
• 🔥 FTP = File Transfer Protocol
• ✅ HTML = Web page language
• ⭐ Modem = Modulator Demodulator (internet connection device)
• 🔥 Router = Network traffic direct करता है
• ✅ Hub = Data broadcast करता है (सबको)
• ⭐ Switch = Specific device को data भेजता है

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

PART 3 — BROWSER SHORTCUT TABLE

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

Shortcut Function
Ctrl+N New browser window
Ctrl+T New tab
Ctrl+W Close current tab
Ctrl+Shift+T Reopen closed tab
Ctrl+L Address bar focus
Ctrl+D Bookmark page
Ctrl+H History
Ctrl+J Downloads
Ctrl+F Find on page
F5 Refresh page
Ctrl+R Refresh
F11 Full screen
Ctrl+Shift+Delete Clear history
Ctrl++ Zoom in
Ctrl+- Zoom out
Ctrl+0 Default zoom
Alt+Left Back
Alt+Right Forward
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

PART 4 — EXAM TRAP ALERTS ⚠️

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

🚨 TRAP 1: Internet vs WWW

❌ Students think Internet = WWW


✅ Internet = Infrastructure (cables, routers)
✅ WWW = Service on internet (websites)

🚨 TRAP 2: SMTP vs POP3

✅ SMTP = Send करना


✅ POP3 = Receive करना
🔮 Trick: "SMTP = Send Mail To People"

🚨 TRAP 3: Hub vs Switch vs Router

✅ Hub = All को broadcast (dumb)


✅ Switch = Specific device को send (smart)
✅ Router = Different networks connect

🚨 TRAP 4: CC vs BCC

✅ CC = सब दे ख सकते हैं recipients को


✅ BCC = Recipients एक-दस
ू रे को नह ं दे ख सकते

🚨 TRAP 5: Browser vs Search Engine

❌ Chrome = Search Engine (WRONG)


✅ Chrome = Browser (to access internet)
✅ Google = Search Engine (to search content)

🚨 TRAP 6: Modem vs Router

✅ Modem = ISP से connection (internet in)


✅ Router = Devices को internet distribute
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

PART 5 — RAPID REVISION BLOCK ⚡

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

text
⚡ INTERNET & EMAIL — 5-MINUTE REVISION

🌐 Internet ≠ WWW (WWW is service on Internet)


📧 SMTP = Send | POP3 = Receive | IMAP = Sync
🔒 HTTP = Normal | HTTPS = Secure
🌐 DNS = Name to IP convert
🔗 URL = Website address
📡 LAN=Local, MAN=Metro, WAN=Wide
📱 WiFi = Wireless | Bluetooth = Short range
🌐 IPv4 = 32-bit | IPv6 = 128-bit
🔧 Hub = Broadcast | Switch = Smart send | Router = Connect networks
🖥️ Chrome/Firefox/Edge = Browsers
🔍 Google/Bing/Yahoo = Search Engines
📧 CC = All can see | BCC = Hidden
📁 FTP = File Transfer Protocol
🌐 .gov = Govt | .edu = Education | .com = Commercial
📡 Modem = ISP connect | Router = Distribute

═══════════════════════════════════

📖 CHAPTER 6: CYBER SECURITY

═══════════════════════════════════
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

PART 1 — QUICK CONCEPT NOTES

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

🔒 CYBER SECURITY BASICS

• Cyber Security = Digital devices/data को threats से protect करना


• Cybercrime = Computer/internet के through crime
• Hacker = Unauthorized system access करने वाला
• White Hat = Ethical hacker (legal)
• Black Hat = Malicious hacker (illegal)
• Grey Hat = Between white & black

🦠 TYPES OF MALWARE (Most Important!)

Malware What it does


Virus Files से attach होता है, spread करता है
Worm Self-replicate करता है, network में spread
Trojan Useful software जैसा ददखता है, harmful होता है
Spyware User की activities secretly monitor करता है
Adware Unwanted ads ददखाता है
Ransomware Data encrypt करके ransom माींगता है
Keylogger Keyboard inputs record करता है
Rootkit System में hidden रहता है, admin access लेता है
Botnet Infected computers का network

⚡ MEMORY TRICK:

"VWTS ARK B" = Virus, Worm, Trojan, Spyware, Adware, Ransomware, Keylogger, Botnet

🎣 CYBER ATTACK TYPES

Attack Description
Phishing Fake emails/websites से credentials िुराना
Vishing Voice/phone call से fraud
Smishing SMS से fraud
DoS Denial of Service (server को flood करना)
DDoS Distributed DoS (multiple sources से)
Man in Middle Communication intercept करना
SQL Injection Database में malicious code डालना
Cross-site Scripting Website में script inject करना
Brute Force सभी password combinations try करना
Social Engineering Human manipulation से information लेना

🛡️ PROTECTION METHODS

Protection Use
Antivirus Malware detect & remove
Firewall Network traffic filter
Encryption Data को scramble करना
VPN Secure private network
Two-Factor Auth Double security
Strong Password Complex password use
Regular Updates Software patch करना
Backup Data की copy रखना

🔐 PASSWORD RULES (Exam Favorite!)

• Minimum 8 characters
• Mix of UPPERCASE + lowercase + numbers + symbols
• Personal info नह ं (name, birthday)
• Dictionary words नह ं
• Regular change करें
• Different accounts = Different passwords
• Password Manager use करें

🔒 ENCRYPTION TERMS

Term Meaning
Encryption Data को code में convert करना
Decryption Code को data में वापस करना
SSL Secure Socket Layer
TLS Transport Layer Security
HTTPS SSL/TLS encrypted web
Public Key Share करते हैं (encryption)
Private Key Secret रखते हैं (decryption)

📱 SOCIAL MEDIA SAFETY

• Privacy settings strong रखें


• Unknown links click न करें
• Personal info share न करें
• Strong unique passwords use करें
• Two-factor authentication enable करें
• Logout करें public devices पर

⚖️ CYBER LAWS (India)

Law Details
IT Act 2000 India का main cyber law
IT Act 2008 Amendment (updated)
Section 43 Unauthorized computer access
Section 66 Computer fraud
Section 66C Identity theft
Section 66D Cheating using computer
Section 66E Privacy violation
Section 67 Publishing obscene material
Section 72 Breach of confidentiality

🏢 CYBER SECURITY ORGANIZATIONS

Organization Full Form Role


CERT-In Computer Emergency Response Team India India cyber incidents
NASSCOM National Association of Software Companies IT industry
NIC National Informatics Centre Govt IT
CDAC Centre for Development of Advanced Computing Tech development

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

PART 2 — MOST IMPORTANT MCQ POINTS

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

• ⭐ Ransomware = Data encrypt करके पैसे मांगता है


• ⭐ Phishing = Fake email/website से credentials चुराना
• 🔥 Trojan = Useful ददखता है but harmful होता है
• ✅ Worm = Self-replicate करता है
• ⭐ Firewall = Network traffic filter
• 🔥 Antivirus = Malware remove करता है
• ✅ IT Act 2000 = India's main cyber law
• ⭐ CERT-In = India's cyber response team
• 🔥 HTTPS = Secure website (padlock icon 🔒)
• ✅ Encryption = Data को code में convert
• ⭐ VPN = Virtual Private Network
• 🔥 Keylogger = Keyboard strokes record करता है
• ✅ DoS = Server को flood करना
• ⭐ DDoS = Multiple sources से DoS
• 🔥 Vishing = Voice fraud
• ✅ Smishing = SMS fraud
• ⭐ White Hat = Ethical Hacker (legal)
• 🔥 Black Hat = Malicious Hacker (illegal)

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

PART 4 — EXAM TRAP ALERTS ⚠️

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

🚨 TRAP 1: Virus vs Worm

✅ Virus = Host file जरूर है


✅ Worm = No host file (self-replicate करता है)

🚨 TRAP 2: Phishing vs Vishing vs Smishing

✅ Phishing = Email/web
✅ Vishing = Voice/phone
✅ Smishing = SMS
🔮 Trick: Ph=email, V=Voice, Sm=SMS

🚨 TRAP 3: DoS vs DDoS

✅ DoS = Single source


✅ DDoS = Multiple sources (Distributed)

🚨 TRAP 4: Firewall vs Antivirus

✅ Firewall = Network को block/allow (gate की तरह)


✅ Antivirus = Already infected files remove (doctor की तरह)
🚨 TRAP 5: Encryption terms

✅ Encryption = Lock (readable → unreadable)


✅ Decryption = Unlock (unreadable → readable)

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

PART 5 — RAPID REVISION BLOCK ⚡

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

text
⚡ CYBER SECURITY — 5-MINUTE REVISION

🦠 Ransomware = Data encrypt + ransom demand


🎣 Phishing = Fake email/web fraud
📞 Vishing = Voice fraud | SMS = Smishing
🐛 Worm = Self-replicate (no host needed)
🐴 Trojan = Useful ददखता, harmful होता
🔍 Spyware = Secretly monitor करता
⌨️ Keylogger = Keyboard record करता
🛡️ Firewall = Network traffic filter
💊 Antivirus = Malware remove करता
🔒 HTTPS = Secure (padlock icon)
🔐 Encryption = Lock data | Decryption = Unlock
🌐 VPN = Virtual Private Network
⚖️ IT Act 2000 = India's cyber law
🏢 CERT-In = India's cyber response team
👨‍💻 White Hat = Legal hacker
💀 Black Hat = Illegal hacker
🔑 Strong password = 8+ chars + mixed

═══════════════════════════════════

📖 CHAPTER 7: DIGITAL PAYMENTS

═══════════════════════════════════
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

PART 1 — QUICK CONCEPT NOTES

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

💳 DIGITAL PAYMENT METHODS

Method Full Form Use


UPI Unified Payment Interface Real-time bank transfer
NEFT National Electronic Fund Transfer Bank to bank (batch)
RTGS Real Time Gross Settlement Large amount (instant)
IMPS Immediate Payment Service 24/7 instant
AEPS Aadhaar Enabled Payment System Aadhaar biometric
NACH National Automated Clearing House Bulk payments
E-wallet Electronic Wallet Stored value app

📱 POPULAR PAYMENT APPS

App Company
GPay Google
PhonePe Walmart (Flipkart)
Paytm One97 Communications
BHIM NPCI (Government)
Amazon Pay Amazon

⚡ Key Fact:

BHIM = Bharat Interface for Money (by NPCI)


UPI = NPCI द्वारा बनाया गया
NPCI = National Payments Corporation of India

💳 CARD TYPES

Card Use Source


Debit Card Own bank money Bank account
Credit Card Bank's money (loan) Credit line
Prepaid Card Pre-loaded money Recharge
🏧 IMPORTANT BANKING TERMS

Term Full Form Meaning


ATM Automated Teller Machine Cash withdrawal
OTP One Time Password Single use password
PIN Personal Identification Number 4-digit secret
CVV Card Verification Value 3-digit back of card
IFSC Indian Financial System Code Bank branch code
MICR Magnetic Ink Character Recognition Cheque processing

💳 PAYMENT LIMITS (Important!)

Method Min Amount Max Amount


NEFT ₹1 No limit
RTGS ₹2 Lakh No limit
IMPS ₹1 ₹5 Lakh
UPI ₹1 ₹1 Lakh/day

⏰ AVAILABILITY

Method Available
NEFT 24x7 (since Dec 2019)
RTGS 24x7 (since Dec 2020)
IMPS 24x7 always
UPI 24x7 always

🔐 DIGITAL PAYMENT SAFETY

• OTP share न करें फकसी को


• CVV & PIN private रखें
• HTTPS websites पर ह pay करें
• Public WiFi पर payment न करें
• Suspicious QR codes scan न करें
• Unknown UPI requests accept न करें

📊 QR CODE

• QR = Quick Response Code


• 2D barcode for payment/info
• Scan करें → Payment/Info ममलती है
• Use: Payment, Websites, Contact info
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

PART 2 — MOST IMPORTANT MCQ POINTS

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

• ⭐ UPI = Unified Payment Interface


• ⭐ BHIM = Bharat Interface for Money (by NPCI)
• 🔥 RTGS = Minimum ₹2 Lakh
• ✅ NEFT = Batch processing (now 24x7)
• ⭐ IMPS = 24x7 instant
• 🔥 ATM = Automated Teller Machine
• ✅ OTP = One Time Password
• ⭐ CVV = 3-digit back of card
• 🔥 IFSC = Bank branch code
• ✅ NPCI = UPI + BHIM बनाया
• ⭐ Debit Card = Own money
• 🔥 Credit Card = Bank's loan
• ✅ QR = Quick Response
• ⭐ AEPS = Aadhaar biometric payment
• 🔥 PIN = 4-digit ATM code

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

PART 4 — EXAM TRAP ALERTS ⚠️

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

🚨 TRAP 1: NEFT vs RTGS vs IMPS

✅ NEFT = Batch (now 24x7, no min limit)


✅ RTGS = Min ₹2 Lakh (large amounts)
✅ IMPS = Any amount, 24x7 instant

🚨 TRAP 2: Debit vs Credit

✅ Debit = अपना पैसा


✅ Credit = Bank का उधार
🚨 TRAP 3: BHIM vs UPI

✅ UPI = Protocol/System (NPCI का)


✅ BHIM = App (UPI पर based)

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

PART 5 — RAPID REVISION BLOCK ⚡

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

text
⚡ DIGITAL PAYMENTS — 5-MINUTE REVISION

💳 UPI = Unified Payment Interface (NPCI)


📱 BHIM = Bharat Interface for Money (Govt app)
🏧 RTGS = Min ₹2 Lakh (instant, large)
📊 NEFT = Batch (24x7 now)
⚡ IMPS = 24x7 instant (any amount up to ₹5L)
🔢 OTP = One Time Password (share NEVER)
🔢 CVV = 3-digit (back of card)
🔢 IFSC = Bank branch code
🏧 ATM = Automated Teller Machine
💳 Debit = Own money | Credit = Bank loan
📱 NPCI = National Payments Corporation India
🔍 QR = Quick Response Code
🔐 Never share OTP/PIN/CVV
🌐 Pay only on HTTPS sites

═══════════════════════════════════

📖 CHAPTER 8: GOVERNMENT DIGITAL SERVICES

═══════════════════════════════════
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

PART 1 — QUICK CONCEPT NOTES

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

🏛️ E-GOVERNANCE

Portal Use
e-Mitra Rajasthan government services
DigiLocker Digital documents storage
Umang App Unified Mobile App for Govt services
mParivahan Digital vehicle documents
Aadhar Card UIDAI identity
PAN Card Income tax identity
e-Pramaan Digital authentication

📱 IMPORTANT GOVT APPS/PORTALS

Service Portal/App Use


DigiLocker [Link] Digital documents
UMANG [Link] All govt services
e-Mitra [Link] Rajasthan services
UIDAI [Link] Aadhaar services
IRCTC [Link] Train tickets
Income Tax [Link] Tax filing
Passport [Link] Passport services

🪪 DIGITAL INDIA INITIATIVES

Initiative Purpose
Digital India Digital empowerment program
Skill India Skill development
Make in India Manufacturing boost
Jan Dhan Yojana Banking for all
Pradhan Mantri Gramin Digital Saksharta Abhiyan (PMGDISHA) Rural digital literacy
Common Service Centre (CSC) Rural digital services
BharatNet Rural broadband

📋 DIGILOCKER (Important!)

• Launch = 2015
• By = Ministry of Electronics & IT (MeitY)
• Storage = 1 GB free
• Use = Driving license, Aadhaar, Marksheet store करना
• Linked with = Aadhaar
• Valid = Original documents जैसा valid

🔑 AADHAAR SERVICES

• 12-digit unique identification number


• Issued by UIDAI
• UIDAI = Unique Identification Authority of India
• Biometric = Fingerprint + Iris scan
• mAadhaar = Mobile app for Aadhaar

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

PART 2 — MOST IMPORTANT MCQ POINTS

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

• ⭐ DigiLocker = 1 GB free storage


• ⭐ Aadhaar = 12-digit unique number
• 🔥 UIDAI = Aadhaar जार करता है
• ✅ e-Mitra = Rajasthan government portal
• ⭐ UMANG = All govt services एक app
• 🔥 DigiLocker = MeitY द्वारा launch
• ✅ CSC = Common Service Centre
• ⭐ BharatNet = Rural broadband project
• 🔥 PMGDISHA = Rural digital literacy
• ✅ DigiLocker documents = Legal valid

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

PART 5 — RAPID REVISION BLOCK ⚡

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

text
⚡ GOVT DIGITAL SERVICES — 5-MINUTE REVISION

🪪 Aadhaar = 12-digit | UIDAI द्वारा


📁 DigiLocker = Digital documents (1 GB free)
📱 UMANG = All govt services app
🏛️ e-Mitra = Rajasthan govt portal
🌐 CSC = Common Service Centre (rural)
📡 BharatNet = Rural broadband
📚 PMGDISHA = Rural digital literacy
🏭 Digital India = Launched by PM Modi 2015
📜 DigiLocker docs = Legally valid
🔐 e-Pramaan = Digital authentication

═══════════════════════════════════

📖 CHAPTER 9 & 10: MOBILE + CLOUD COMPUTING

═══════════════════════════════════

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

PART 1 — QUICK CONCEPT NOTES

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

📱 MOBILE OPERATING SYSTEMS

OS Company Device
Android Google Samsung, OnePlus, etc.
iOS Apple iPhone, iPad
Windows Mobile Microsoft Windows phones
KaiOS KaiOS Technologies Feature phones (Jio phone)
HarmonyOS Huawei Huawei devices

📶 MOBILE GENERATIONS

Generation Speed Features


1G 2.4 Kbps Voice only
2G 64 Kbps SMS + Basic data
3G 2 Mbps Internet, Video
4G 100 Mbps HD streaming
5G 10 Gbps Ultra fast, IoT
☁️ CLOUD COMPUTING

Definition: Internet के through computing services provide करना

Types:

text
SaaS = Software as a Service (Gmail, Office 365)
PaaS = Platform as a Service (Google App Engine)
IaaS = Infrastructure as a Service (AWS, Azure)

⚡ MEMORY TRICK:

"SPI" → Software → Platform → Infrastructure


"Sabse Pehle Infrastructure" (bottom to top)

☁️ CLOUD SERVICE PROVIDERS

Provider Company
AWS Amazon Web Services
Azure Microsoft
Google Cloud Google
iCloud Apple
OneDrive Microsoft
Google Drive Google
Dropbox Dropbox Inc

☁️ CLOUD DEPLOYMENT MODELS

Model Description
Public Cloud सबके मलए (AWS, Google Cloud)
Private Cloud एक organization के मलए
Hybrid Cloud Public + Private mix
Community Cloud Specific community share

🤖 EMERGING TECHNOLOGIES

Tech Full Form Use


AI Artificial Intelligence Machine thinking
ML Machine Learning Learning from data
IoT Internet of Things Smart devices
AR Augmented Reality Real + Digital
VR Virtual Reality Fully digital
Big Data - Huge data analysis
Blockchain - Decentralized ledger

🔗 IoT (Internet of Things)

• Smart devices जो internet से connected हैं


• Examples: Smart TV, Smart fridge, Smart watch
• Data share करते हैं automatically
• 5G के साथ IoT grow होगा

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

PART 2 — MOST IMPORTANT MCQ POINTS

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

• ⭐ Android = Google का mobile OS


• ⭐ iOS = Apple का mobile OS
• 🔥 5G = Fastest mobile network (10 Gbps)
• ✅ SaaS = Software as a Service (Gmail)
• ⭐ AWS = Amazon Web Services
• 🔥 Azure = Microsoft Cloud
• ✅ Google Drive = Cloud storage
• ⭐ IoT = Internet of Things
• 🔥 AI = Artificial Intelligence
• ✅ Blockchain = Decentralized ledger
• ⭐ Public Cloud = All के लिए
• 🔥 Private Cloud = One organization
• ✅ Hybrid Cloud = Mix of both

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

PART 5 — RAPID REVISION BLOCK ⚡

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

text
⚡ MOBILE + CLOUD — 5-MINUTE REVISION

📱 Android = Google | iOS = Apple


📶 5G = Fastest (10 Gbps)
☁️ SaaS = Gmail, Office (Software)
☁️ PaaS = App Engine (Platform)
☁️ IaaS = AWS, Azure (Infrastructure)
☁️ AWS = Amazon | Azure = Microsoft
📁 Google Drive = Cloud storage (15 GB free)
📁 OneDrive = Microsoft (5 GB free)
📁 iCloud = Apple
🤖 AI = Machine intelligence
🔗 IoT = Smart connected devices
📊 Blockchain = Decentralized & secure
🌐 Public Cloud = All | Private = One org

═══════════════════════════════════

🏆 PART 8 — TOPPER REVISION SYSTEM

═══════════════════════════════════

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

🔥 TOP 100 RSCIT EXAM FACTS

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

💻 COMPUTER BASICS (Facts 1-20)

text
1. 1 Byte = 8 Bits
2. 1 KB = 1024 Bytes
3. RAM = Volatile Memory
4. ROM = Non-Volatile Memory
5. CPU = Brain of Computer (ALU + CU)
6. ENIAC = First Electronic Computer
7. PARAM = India's Supercomputer
8. 1st Gen = Vacuum Tubes
9. 2nd Gen = Transistors
10. 3rd Gen = IC (Integrated Circuit)
11. 4th Gen = Microprocessor (VLSI)
12. 5th Gen = AI
13. MICR = Bank cheques
14. OMR = Exam answer sheets
15. Scanner = Input Device
16. Printer = Output Device
17. Antivirus = Utility Software
18. Windows = System Software
19. MS Word = Application Software
20. Mouse = Pointing Device

📝 MS WORD (Facts 21-35)

text
21. MS Word extension = .docx
22. Default font = Calibri, 11pt
23. Default page = A4, Portrait
24. Ctrl+Z = Undo
25. Ctrl+Y = Redo
26. F7 = Spell Check
27. F12 = Save As
28. Ctrl+H = Find & Replace
29. Ctrl+E = Center Align
30. Ctrl+J = Justify
31. Mail Merge = Mailings Tab
32. Watermark = Page Layout Tab
33. Track Changes = Review Tab
34. Word Count = Review Tab
35. Header/Footer = Insert Tab

📊 MS EXCEL (Facts 36-52)

text
36. Excel extension = .xlsx
37. Formula starts with = sign
38. Max rows = 1,048,576
39. Max columns = 16,384
40. Workbook = Excel file
41. Worksheet = Individual sheet
42. Text = Left aligned (default)
43. Number = Right aligned (default)
44. $A$1 = Absolute reference
45. Alt+= = AutoSum
46. F11 = Create Chart
47. F2 = Edit cell
48. =SUM() = Total
49. =AVERAGE() = Mean
50. =IF() = Logical function
51. =VLOOKUP() = Vertical lookup
52. Sort/Filter = Data Tab

📊 MS POWERPOINT (Facts 53-62)

text
53. PowerPoint extension = .pptx
54. F5 = Start slide show
55. Shift+F5 = Current slide show
56. Esc = End slide show
57. B = Black screen (show)
58. W = White screen (show)
59. Transition = Slide effect
60. Animation = Object effect
61. Ctrl+M = New slide
62. Normal View = Default view

🌐 INTERNET (Facts 63-76)

text
63. WWW ≠ Internet
64. HTTP = Web protocol
65. HTTPS = Secure web
66. SMTP = Email sending
67. POP3 = Email receiving (Port 110)
68. DNS = Name to IP
69. URL = Website address
70. Chrome = Google's browser
71. ISP = Internet Service Provider
72. LAN = Local, WAN = Wide
73. IPv4 = 32-bit
74. IPv6 = 128-bit
75. BCC = Hidden recipients
76. FTP = File Transfer Protocol

🔒 CYBER SECURITY (Facts 77-87)

text
77. Ransomware = Encrypt + ransom
78. Phishing = Fake email fraud
79. Vishing = Voice fraud
80. Smishing = SMS fraud
81. Worm = Self-replicates
82. Trojan = Looks useful, harmful
83. Firewall = Network filter
84. IT Act 2000 = India's cyber law
85. CERT-In = India's cyber team
86. White Hat = Ethical hacker
87. HTTPS = Secure (padlock)

💳 DIGITAL PAYMENTS (Facts 88-95)

text
88. UPI = Unified Payment Interface
89. BHIM = Bharat Interface for Money
90. NPCI = Created UPI & BHIM
91. RTGS = Minimum ₹2 Lakh
92. IMPS = 24x7 instant
93. CVV = 3-digit (back of card)
94. IFSC = Bank branch code
95. OTP = One Time Password (never share)

☁️ CLOUD & MOBILE (Facts 96-100)

text
96. Android = Google's mobile OS
97. iOS = Apple's mobile OS
98. AWS = Amazon Web Services
99. SaaS = Software as a Service
100. IoT = Internet of Things

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

📋 FULL FORM MASTER LIST

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

Abbreviation Full Form


CPU Central Processing Unit
ALU Arithmetic Logic Unit
CU Control Unit
RAM Random Access Memory
ROM Read Only Memory
HDD Hard Disk Drive
SSD Solid State Drive
GPU Graphics Processing Unit
USB Universal Serial Bus
LCD Liquid Crystal Display
LED Light Emitting Diode
OLED Organic Light Emitting Diode
CRT Cathode Ray Tube
LAN Local Area Network
WAN Wide Area Network
MAN Metropolitan Area Network
PAN Personal Area Network
VPN Virtual Private Network
ISP Internet Service Provider
URL Uniform Resource Locator
HTTP HyperText Transfer Protocol
HTTPS HyperText Transfer Protocol Secure
FTP File Transfer Protocol
SMTP Simple Mail Transfer Protocol
POP3 Post Office Protocol version 3
IMAP Internet Message Access Protocol
DNS Domain Name System
IP Internet Protocol
TCP Transmission Control Protocol
WWW World Wide Web
HTML HyperText Markup Language
CSS Cascading Style Sheets
XML Extensible Markup Language
Wi-Fi Wireless Fidelity
UPI Unified Payment Interface
BHIM Bharat Interface for Money
NPCI National Payments Corporation of India
NEFT National Electronic Fund Transfer
RTGS Real Time Gross Settlement
IMPS Immediate Payment Service
AEPS Aadhaar Enabled Payment System
ATM Automated Teller Machine
OTP One Time Password
PIN Personal Identification Number
CVV Card Verification Value
IFSC Indian Financial System Code
MICR Magnetic Ink Character Recognition
OCR Optical Character Recognition
OMR Optical Mark Recognition
UIDAI Unique Identification Authority of India
NIC National Informatics Centre
CDAC Centre for Development of Advanced Computing
CERT-In Computer Emergency Response Team India
NASSCOM National Association of Software and Service Companies
AI Artificial Intelligence
ML Machine Learning
IoT Internet of Things
AR Augmented Reality
VR Virtual Reality
SaaS Software as a Service
PaaS Platform as a Service
IaaS Infrastructure as a Service
AWS Amazon Web Services
QR Quick Response
PDF Portable Document Format
GUI Graphical User Interface
OS Operating System
DoS Denial of Service
DDoS Distributed Denial of Service
SSL Secure Sockets Layer
TLS Transport Layer Security
CSC Common Service Centre
PMGDISHA Pradhan Mantri Gramin Digital Saksharta Abhiyan
MeitY Ministry of Electronics and Information Technology

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

⌨️ SHORTCUT KEY MASTER SHEET

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

🔑 UNIVERSAL SHORTCUTS (All Programs)

Shortcut Function
Ctrl+Z Undo
Ctrl+Y Redo
Ctrl+X Cut
Ctrl+C Copy
Ctrl+V Paste
Ctrl+A Select All
Ctrl+S Save
Ctrl+N New
Ctrl+O Open
Ctrl+P Print
Ctrl+F Find
Alt+F4 Close/Exit
Ctrl+W Close window

📝 MS WORD SHORTCUTS

Shortcut Function
Ctrl+B Bold
Ctrl+I Italic
Ctrl+U Underline
Ctrl+E Center Align
Ctrl+L Left Align
Ctrl+R Right Align
Ctrl+J Justify
Ctrl+H Find & Replace
Ctrl+G Go To
Ctrl+K Hyperlink
Ctrl+D Font dialog
Ctrl+1 Single spacing
Ctrl+2 Double spacing
Ctrl+5 1.5 spacing
Ctrl+Home Beginning of doc
Ctrl+End End of doc
F7 Spell Check
F12 Save As
Shift+F3 Change Case

📊 MS EXCEL SHORTCUTS

Shortcut Function
Alt+= AutoSum
F2 Edit cell
F4 Absolute reference ($)
F11 Create chart
Ctrl+; Current date
Ctrl+Shift+; Current time
Ctrl+D Fill down
Ctrl+R Fill right
Ctrl+1 Format cells
Ctrl+Shift+L AutoFilter
Ctrl+Home Go to A1
Ctrl+End Last used cell
Shift+F11 New sheet
Ctrl+PgUp Previous sheet
Ctrl+PgDn Next sheet

📊 MS POWERPOINT SHORTCUTS

Shortcut Function
F5 Start show (beginning)
Shift+F5 Start show (current slide)
Esc End slide show
B Black screen
W White screen
Ctrl+M New slide
Ctrl+D Duplicate slide
Delete Delete slide

🪟 WINDOWS SHORTCUTS

Shortcut Function
Windows key Open Start menu
Win+D Show Desktop
Win+E Open File Explorer
Win+L Lock computer
Win+R Run dialog
Win+I Settings
Win+Print Screen Screenshot (saved)
Print Screen Screenshot (clipboard)
Alt+Tab Switch windows
Ctrl+Alt+Del Task Manager / Security
Ctrl+Shift+Esc Task Manager (direct)
Win+X Power user menu
F1 Help
F2 Rename file/folder
F5 Refresh
Delete Move to Recycle Bin
Shift+Delete Permanent delete

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

🌐 INTERNET TERMINOLOGY QUICK SHEET

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

Term Meaning
Homepage Website का main/first page
Hyperlink Clickable link (text/image)
Bookmark Saved website address
Cache Temporary internet files
Cookie Website data stored in browser
Download Internet से computer पर
Upload Computer से internet पर
Bandwidth Data transfer capacity
Latency Network delay (ping)
Firewall Network security filter
Proxy Intermediate server
Torrent P2P file sharing
Podcast Audio/video episodes online
Blog Online diary/articles
Vlog Video blog
Streaming Real-time media playing
Broadband High-speed internet
Wi-Fi Hotspot Wireless internet point
Tethering Phone से internet share
404 Error Page not found
500 Error Server error

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

🦠 CYBER SAFETY RAPID NOTES

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

🔴 NEVER DO:

text
❌ OTP फकसी को share न करें
❌ Unknown links click न करें
❌ Public WiFi पर banking न करें
❌ Same password सभी जगह न use करें
❌ Suspicious QR code scan न करें
❌ Personal info social media पर share न करें
❌ Unknown email attachments download न करें
❌ CVV/PIN फकसी को न बताएीं

🟢 ALWAYS DO:

text
✅ HTTPS websites पर ह payment करें
✅ Strong unique passwords use करें
✅ Two-factor authentication enable करें
✅ Software regularly update करें
✅ Antivirus install रखें
✅ Data backup regularly लें
✅ Logout करें public computers पर
✅ Privacy settings check करें

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

📊 FILE EXTENSIONS MASTER LIST

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

Extension File Type


.docx MS Word document
.xlsx MS Excel spreadsheet
.pptx MS PowerPoint
.pdf Portable Document Format
.txt Plain text
.jpg/.jpeg Image (compressed)
.png Image (lossless)
.gif Animated image
.mp3 Audio file
.mp4 Video file
.avi Video file
.wav Audio (uncompressed)
.zip Compressed folder
.rar Compressed archive
.exe Executable (Windows)
.html Web page
.css Style sheet
.xml Data format
.xls Old Excel (97-2003)
.doc Old Word (97-2003)
.ppt Old PowerPoint
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

🎯 MOST EXPECTED MCQs — EXAM READY

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

Q1: 1 Byte में ककतने Bits होते हैं?

Answer: 8 Bits ✅

Q2: MS Excel में formula ककससे start होता है?

Answer: = (Equal sign) ✅

Q3: MS Word में Spell Check की shortcut क्या है?

Answer: F7 ✅

Q4: Ransomware क्या करता है?

Answer: Data encrypt करके ransom मांगता है ✅

Q5: UPI का full form क्या है?

Answer: Unified Payment Interface ✅

Q6: SMTP ककस लिए use होता है?

Answer: Email sending के लिए ✅

Q7: India का पहिा supercomputer कौनसा है?

Answer: PARAM ✅

Q8: MS Word का default orientation क्या है?

Answer: Portrait ✅
Q9: Aadhaar में ककतने digits होते हैं?

Answer: 12 digits ✅

Q10: Android ककस company का OS है?

Answer: Google ✅

Q11: PowerPoint में slide show शुरू करने की key?

Answer: F5 ✅

Q12: Phishing attack में क्या होता है?

Answer: Fake email/website से credentials चुराते हैं ✅

Q13: MS Word में Save As की shortcut?

Answer: F12 ✅

Q14: Excel में Maximum rows ककतनी होती हैं?

Answer: 1,048,576 ✅

Q15: RTGS में minimum amount ककतना है?

Answer: ₹2 Lakh ✅

Q16: DigiLocker में ककतना free storage लमिता है?

Answer: 1 GB ✅

Q17: Ctrl+H ककस लिए use होता है?

Answer: Find & Replace ✅


Q18: CSS का full form?

Answer: Cascading Style Sheets ✅

Q19: WWW को ककसने बनाया?

Answer: Tim Berners-Lee ✅

Q20: CERT-In क्या है?

Answer: Computer Emergency Response Team India ✅

Q21: Cloud computing में SaaS का example?

Answer: Gmail, Google Docs, Office 365 ✅

Q22: IPv4 ककतने bit का होता है?

Answer: 32-bit ✅

Q23: MS Excel में absolute reference कैसे लिखते हैं?

Answer: A$1 ( sign से) ✅

Q24: Transition ककस Tab में होती है ?

Answer: Transitions Tab ✅

Q25: BCC का full form?

Answer: Blind Carbon Copy ✅


━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

⏰ FINAL 1-HOUR REVISION FRAMEWORK

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

text
🕐 HOUR 1 — COMPLETE REVISION PLAN

⏰ 0:00-0:10 → Computer Basics


(Generations, Memory, IPO Cycle, Storage units)

⏰ 0:10-0:20 → MS Word + MS PowerPoint


(Shortcuts, Tabs, Extensions, Key features)

⏰ 0:20-0:30 → MS Excel
(Formulas, Functions, Shortcuts, Rows/Cols)

⏰ 0:30-0:40 → Internet + Email


(Protocols, Browsers, Networking terms)

⏰ 0:40-0:50 → Cyber Security + Digital Payments


(Malware types, Attack types, UPI, Banking terms)

⏰ 0:50-0:60 → Full Form List + Top 25 MCQs


(Quick scan of all abbreviations + practice MCQs)

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

🧠 ULTIMATE MEMORY TRICKS COLLECTION

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

🔮 TRICK 1: Ctrl Shortcuts Pattern

text
B = Bold, I = Italic, U = Underline → "BIU = Beauty"
L = Left, E = cEnter, R = Right, J = Justify → "LERJ"
F = Find, H = Hunt & Replace → "FH pair"
Z = Undo, Y = Yes-Redo → "ZY pair"
X = Cut, C = Copy, V = Paste → "XCV always together"

🔮 TRICK 2: Email Protocols

text
SMTP = Send Mail To People (Sending)
POP3 = Pull Out Post (Receiving)
IMAP = I May Access Plenty (Sync everywhere)

🔮 TRICK 3: Network Types

text
"LAMP" = LAN, MAN, WAN, PAN (small to big)
LAN = Lane (छोट जगह)
MAN = Metro (शहर)
WAN = Wide (दे श/दनु नया)

🔮 TRICK 4: Malware Types

text
"VWTSARK" = Virus, Worm, Trojan, Spyware, Adware, Ransomware, Keylogger
"Very Wicked Thieves Steal And Rob Keychains"

🔮 TRICK 5: Computer Generations

text
"Very Tiny Indians Make AI"
Vacuum Tubes → Transistors → IC → Microprocessor → AI

🔮 TRICK 6: Cloud Service Models

text
"SPI" = SaaS → PaaS → IaaS
"Students Pass in Institutions"
Gmail = SaaS, Google Engine = PaaS, AWS = IaaS

🔮 TRICK 7: Storage Units

text
"Big Naughty Boys Keep Making Great Things Possibly"
Bit → Nibble → Byte → KB → MB → GB → TB → PB

🔮 TRICK 8: MS Office Extensions

text
Word → DOCX (DOCument eXtended)
Excel → XLSX (eXceL Sheet eXtended)
PowerPoint → PPTX (PPT eXtended)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

🎯 COMPARISON TABLES (EXAM TRAPS SOLVED)

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

📊 RAM vs ROM vs HDD

Feature RAM ROM HDD


Volatile? Yes No No
Speed Fast Medium Slow
Type Primary Primary Secondary
Data on power off Lost Safe Safe
Example Working memory BIOS Storage

📊 VIRUS vs WORM vs TROJAN

Feature Virus Worm Trojan


Host needed Yes No No
Self-replicate With host Yes No
Appears as Normal file Normal Useful software
Spreads via Files Network Downloads

📊 HUB vs SWITCH vs ROUTER

Feature Hub Switch Router


Intelligence Dumb Smart Smartest
Data sent to All Specific Different network
Speed Slow Fast Varies
Layer Physical Data Link Network

📊 MS OFFICE FILE FORMATS

Software New Format Old Format


MS Word .docx .doc
MS Excel .xlsx .xls
MS PowerPoint .pptx .ppt
MS Access .accdb .mdb

📊 NEFT vs RTGS vs IMPS vs UPI

Feature NEFT RTGS IMPS UPI


Speed Batch Instant Instant Instant
Min Amount ₹1 ₹2 Lakh ₹1 ₹1
Max Amount No limit No limit ₹5 Lakh ₹1 Lakh
Available 24x7 24x7 24x7 24x7
Mobile Yes Limited Yes Yes

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

⭐ CHAPTER-WISE TOP SHORTCUT REVISION

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

🔑 TOP 10 MOST ASKED SHORTCUTS IN RSCIT

text
Rank 1: Ctrl+Z = Undo ⭐⭐⭐⭐⭐
Rank 2: Ctrl+S = Save ⭐⭐⭐⭐⭐
Rank 3: F5 = Slide Show (PPT) ⭐⭐⭐⭐⭐
Rank 4: F7 = Spell Check ⭐⭐⭐⭐⭐
Rank 5: Ctrl+H = Find & Replace ⭐⭐⭐⭐
Rank 6: F12 = Save As ⭐⭐⭐⭐
Rank 7: Alt+= = AutoSum (Excel) ⭐⭐⭐⭐
Rank 8: Ctrl+E = Center Align ⭐⭐⭐⭐
Rank 9: Win+D = Show Desktop ⭐⭐⭐
Rank 10: Shift+Delete = Permanent Delete ⭐⭐⭐

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

🚀 PRACTICAL EXAM QUICK GUIDE

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

📝 MS WORD PRACTICAL TIPS:

text
1. Document खोलें → Ctrl+N या Ctrl+O
2. Text type करें
3. Select करें → Ctrl+A (सब) या mouse drag
4. Format करें → Bold (Ctrl+B), Italic (Ctrl+I)
5. Align करें → Ctrl+E (center)
6. Save करें → Ctrl+S
7. Print करें → Ctrl+P → Settings check करें
8. Spell check → F7
9. Find करें → Ctrl+F
10. Replace करें → Ctrl+H

📊 MS EXCEL PRACTICAL TIPS:

text
1. Cell click करें (Name box check)
2. Data enter करें
3. Formula type करें → = से start
4. Range select → A1:A10 format
5. AutoSum → Alt+=
6. Chart → Insert → Chart
7. Sort → Data Tab → Sort
8. Filter → Ctrl+Shift+L
9. Save → Ctrl+S
10. Format → Ctrl+1

📊 MS POWERPOINT PRACTICAL TIPS:

text
1. New slide → Ctrl+M
2. Text type करें placeholder में
3. Design → Design Tab → Theme select
4. Transition add → Transitions Tab
5. Animation → Animations Tab
6. Slide Show → F5 (beginning)
7. Current slide → Shift+F5
8. End show → Esc
9. Save → Ctrl+S
10. Print → Ctrl+P → Handout/Slides select

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

🏆 FINAL EXAM STRATEGY TIPS

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

text
📌 EXAM DAY STRATEGY

✅ 1. Shortcut keys के questions पहले solve करें


(Easy marks, 100% sure answers)

✅ 2. Full form questions skip मत करें


(Easy 1-mark each)

✅ 3. Trap words दे खें:


- "NOT", "EXCEPT", "INCORRECT" highlighted
- ये questions carefully पढें

✅ 4. MS Office version matter करता है:


- RSCIT = MS Office 2010 based
- Extension = .docx, .xlsx, .pptx

✅ 5. Internet questions में:


- Protocol पहिानें (SMTP=Send, POP3=Receive)
- Security check करें (HTTPS = Secure)

✅ 6. Cyber security में:


- "-ware" ending = Malware type
- "-ishing" = Social engineering

✅ 7. Digital payment में:


- RTGS = Only large amounts (₹2L+)
- IMPS = Best for instant any amount

✅ 8. Doubt में = Most specific answer choose


(General से specific better)

✅ 9. Time management:
- 35 questions = 60 minutes
- ~1.5 min per question
- Easy पहले, difficult बाद में

✅ 10. Review करें अींत में:


- Skipped questions fill करें
- OTP/CVV related = Security answer choose
🏆 ALL THE BEST FOR YOUR RSCIT EXAM!

💪 आप जरूर सफि होंगे!

📌 REMEMBER:

"Revision + Practice = Maximum Score"

ये notes बनाए हैं: Elite RSCIT Strategy Engine


Focus: Maximum Score | Fastest Revision | Zero Confusion
Mission: आपकी RSCIT EXAM में पूर सिलता 🎯

🏆 RSCIT COMPLETE NOTES — MISSING MODULES

COVERING REMAINING 22% — FULL EXAM DOMINATION

═══════════════════════════════════

📖 MODULE A: NUMBER SYSTEMS

═══════════════════════════════════

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

PART 1 — QUICK CONCEPT NOTES

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

🔢 NUMBER SYSTEM TYPES

System Base Digits Used Example


Binary 2 0, 1 1010
Octal 8 0-7 752
Decimal 10 0-9 255
Hexadecimal 16 0-9, A-F FF

⚡ MEMORY TRICK:

"BODH" = Binary, Octal, Decimal, Hexadecimal

🔢 HEXADECIMAL VALUES

Decimal Hex Binary


0 0 0000
1 1 0001
2 2 0010
3 3 0011
4 4 0100
5 5 0101
6 6 0110
7 7 0111
8 8 1000
9 9 1001
10 A 1010
11 B 1011
12 C 1100
13 D 1101
14 E 1110
15 F 1111

⚡ MEMORY TRICK for A-F:

"After 9: A=10, B=11, C=12, D=13, E=14, F=15"


"All Boys Can Do Extra Fine work"

🔄 CONVERSIONS (Most Asked!)

Binary → Decimal:

text
Example: 1010 → Decimal?
1×2³ + 0×2² + 1×2¹ + 0×2⁰
=8+0+2+0
= 10 ✅
Example: 1111 → Decimal?
8+4+2+1 = 15 ✅

Decimal → Binary:

text
Example: 10 → Binary?
10 ÷ 2 = 5 remainder 0
5 ÷ 2 = 2 remainder 1
2 ÷ 2 = 1 remainder 0
1 ÷ 2 = 0 remainder 1
Read remainders BOTTOM to TOP = 1010 ✅

Binary → Hexadecimal:

text
Group binary into 4 bits from right
1010 1111
1010 = A
1111 = F
Result = AF ✅

Decimal → Hexadecimal:

text
255 ÷ 16 = 15 remainder 15 (F)
15 ÷ 16 = 0 remainder 15 (F)
Read bottom to top = FF ✅

📊 COMMON CONVERSIONS (Exam Ready!)

Decimal Binary Hex Octal


0 0000 0 0
8 1000 8 10
10 1010 A 12
15 1111 F 17
16 10000 10 20
255 11111111 FF 377

🔤 CHARACTER CODING SYSTEMS

System Full Form Bits Characters


ASCII American Standard Code for Information Interchange 7-bit 128 characters
Extended ASCII — 8-bit 256 characters
Unicode Universal Code 16-bit 65,536 characters
UTF-8 Unicode Transformation Format 8 Variable All languages

⚡ Key Facts:

text
ASCII 'A' = 65 (Decimal)
ASCII 'a' = 97 (Decimal)
ASCII '0' = 48 (Decimal)
Space = 32

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

PART 2 — MOST IMPORTANT MCQ POINTS

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

• ⭐ Binary = Base 2 (0 and 1 only)


• ⭐ Hexadecimal = Base 16
• 🔥 ASCII = 7-bit = 128 characters
• ✅ Unicode = 16-bit = 65,536 characters
• ⭐ ASCII 'A' = 65
• 🔥 ASCII 'a' = 97
• ✅ 1010 (Binary) = 10 (Decimal)
• ⭐ 1111 (Binary) = 15 (Decimal) = F (Hex)
• 🔥 FF (Hex) = 255 (Decimal)
• ✅ Computer only understands Binary (0 and 1)
• ⭐ Octal = Base 8

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

PART 4 — EXAM TRAP ALERTS ⚠️

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

🚨 TRAP 1: ASCII bits

❌ ASCII = 8-bit (WRONG)


✅ ASCII = 7-bit (128 chars)
✅ Extended ASCII = 8-bit (256 chars)
🚨 TRAP 2: Binary reading direction

✅ Decimal→Binary में remainders BOTTOM to TOP पढें

🚨 TRAP 3: Hex letters

✅ A=10, B=11, C=12, D=13, E=14, F=15


❌ Students often confuse A=11 (WRONG)

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

PART 5 — RAPID REVISION BLOCK ⚡

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

text
⚡ NUMBER SYSTEMS — 5-MINUTE REVISION

🔢 Binary = Base 2 (0,1)


🔢 Octal = Base 8 (0-7)
🔢 Decimal = Base 10 (0-9)
🔢 Hex = Base 16 (0-9, A-F)
🔤 ASCII = 7-bit = 128 chars
🔤 Extended ASCII = 8-bit = 256 chars
🔤 Unicode = 16-bit = 65,536 chars
📌 ASCII 'A'=65, 'a'=97, '0'=48
📌 1010₂ = 10₁₀ = A₁₆
📌 1111₂ = 15₁₀ = F₁₆
📌 FF₁₆ = 255₁₀
📌 Computer = Only Binary understand करता है

═══════════════════════════════════

📖 MODULE B: WINDOWS OS COMPLETE

═══════════════════════════════════
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

PART 1 — QUICK CONCEPT NOTES

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

🪟 WINDOWS OS BASICS

• Windows = Microsoft का Operating System


• OS = Software that manages hardware & software
• GUI = Graphical User Interface (icons, windows)
• Current Version = Windows 11
• RSCIT Context = Windows 7/10

🖥️ WINDOWS DESKTOP ELEMENTS

Element Description
Desktop Main screen area
Taskbar Bottom bar with Start button
Start Button Programs & settings access
System Tray Clock, WiFi, Volume (bottom right)
Icons Shortcuts to programs/files
Recycle Bin Deleted files temporary storage
Wallpaper Desktop background image

📁 FILE MANAGEMENT

File Operations:

text
Copy = Ctrl+C → Ctrl+V (original रहता है)
Cut = Ctrl+X → Ctrl+V (original जाता है)
Move = Cut + Paste
Delete = Delete key → Recycle Bin में जाता है
Permanent Delete = Shift+Delete (directly)
Rename = F2 key
New Folder = Ctrl+Shift+N
Properties = Alt+Enter / Right click → Properties

File Explorer Shortcuts:

text
Win+E = File Explorer खोलें
Alt+Left = Back
Alt+Right = Forward
Alt+Up = Up one level
F5 = Refresh
F2 = Rename
Delete = Delete
Shift+Delete = Permanent delete
Ctrl+A = Select all files

🗑️ RECYCLE BIN (Important!)

Feature Detail
Purpose Deleted files temporarily store
Delete key Files → Recycle Bin
Shift+Delete Direct permanent delete
Restore Right click → Restore
Empty Right click → Empty Recycle Bin
Network files Recycle Bin में नह ीं जाते
Pen drive files Recycle Bin में नह ीं जाते
Very large files Directly delete (Recycle Bin में नह ीं)

⚡ EXAM TRAP:

Network drive या USB drive से delete = Permanent (Recycle Bin नह ं)

👤 USER ACCOUNT TYPES

Type Permissions
Administrator Full control, install software
Standard User Limited, no install
Guest Minimal access, temporary
Microsoft Account Online linked account

⚙️ CONTROL PANEL KEY ITEMS

Setting Location
Display settings Control Panel → Display
Add/Remove programs Control Panel → Programs
User Accounts Control Panel → User Accounts
Network settings Control Panel → Network
Date & Time Control Panel → Date & Time
Accessibility Control Panel → Ease of Access
Printers Control Panel → Devices & Printers
System info Control Panel → System
📋 TASK MANAGER (Important!)

• Open = Ctrl+Alt+Del → Task Manager


• Direct Open = Ctrl+Shift+Esc
• Tabs: Processes, Performance, Users, Services
• Use: Kill unresponsive programs
• End Task: Select program → End Task

🔍 SEARCH & FIND

• Search = Win+S or Start → Search


• Cortana = Windows 10 voice assistant
• Find files = Win+E → Search box

🖨️ PRINTING IN WINDOWS

text
Ctrl+P = Print dialog
Select Printer → Set copies → OK
Default Printer = automatically selected
Print Queue = pending prints list
Pause/Cancel = via Taskbar printer icon

📱 WINDOWS SETTINGS (Win+I)

Setting Use
System Display, Sound, Notifications
Devices Bluetooth, Printer, Mouse
Network WiFi, Ethernet, VPN
Personalization Theme, Wallpaper, Colors
Apps Install/Uninstall programs
Accounts User accounts, Sign-in
Update & Security Windows Update, Backup

🔐 WINDOWS SECURITY

• Windows Defender = Built-in antivirus


• Firewall = Windows Firewall (built-in)
• BitLocker = Drive encryption
• UAC = User Account Control (permission prompt)
• Windows Hello = Biometric login (Face/Fingerprint)
📂 IMPORTANT FOLDERS IN WINDOWS

Folder Location Content


Desktop C:\Users\Name\Desktop Desktop items
Documents C:\Users\Name\Documents User documents
Downloads C:\Users\Name\Downloads Downloaded files
Program Files C:\Program Files Installed programs
Windows C:\Windows OS system files
Temp C:\Windows\Temp Temporary files
Recycle Bin Desktop Deleted files

⌨️ COMPLETE WINDOWS SHORTCUTS

Shortcut Function
Win Start menu
Win+D Show/Hide Desktop
Win+E File Explorer
Win+L Lock computer
Win+R Run dialog
Win+I Settings
Win+S Search
Win+X Power user menu
Win+Tab Task View
Win+P Project/Display mode
Win+Print Screen Screenshot (saved)
Print Screen Screenshot (clipboard)
Alt+Print Screen Active window screenshot
Alt+Tab Switch between windows
Alt+F4 Close program
Ctrl+Alt+Del Security options
Ctrl+Shift+Esc Task Manager direct
F1 Help
F2 Rename
F3 Search
F5 Refresh
F10 Menu bar activate
Win+↑ Maximize window
Win+↓ Minimize window
Win+← Snap left
Win+→ Snap right
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

PART 4 — EXAM TRAP ALERTS ⚠️

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

🚨 TRAP 1: Recycle Bin Exceptions

✅ USB/Network files = Directly delete (no Recycle Bin)


✅ Normal files = Recycle Bin में जाते हैं

🚨 TRAP 2: Task Manager shortcuts

✅ Ctrl+Alt+Del = Security screen (Task Manager option)


✅ Ctrl+Shift+Esc = Direct Task Manager

🚨 TRAP 3: Delete vs Shift+Delete

✅ Delete = Recycle Bin में


✅ Shift+Delete = Permanent (No recovery)

🚨 TRAP 4: Administrator vs Standard

✅ Admin = Full rights + software install


✅ Standard = Limited, no install

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

PART 5 — RAPID REVISION BLOCK ⚡

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

text
⚡ WINDOWS OS — 5-MINUTE REVISION

🖥️ GUI = Graphical User Interface


🗑️ Recycle Bin = Deleted files (temp)
🗑️ Shift+Delete = Permanent delete
🗑️ USB/Network delete = No Recycle Bin
👤 Admin = Full rights | Standard = Limited
⚙️ Task Manager = Ctrl+Shift+Esc
🔐 Windows Defender = Built-in antivirus
🔒 BitLocker = Drive encryption
⌨️ Win+D = Desktop | Win+E = Explorer
⌨️ Win+L = Lock | Win+R = Run
⌨️ Win+S = Search | Win+I = Settings
📋 F2 = Rename | F5 = Refresh
📷 Win+PrtSc = Screenshot saved

═══════════════════════════════════

📖 MODULE C: NETWORKING COMPLETE

═══════════════════════════════════

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

PART 1 — NETWORK TOPOLOGIES

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

🌐 NETWORK TOPOLOGY TYPES

Topology Shape Key Feature


Bus Linear line Single cable (backbone)
Star Central hub Hub/Switch में सब connect
Ring Circle Data circular flow
Mesh Web Every device connected to all
Tree Hierarchy Star का combination
Hybrid Mixed Multiple topologies

📊 TOPOLOGY COMPARISON TABLE

Feature Bus Star Ring Mesh


Cable needed Less More Medium Maximum
Failure impact All affected Only one All affected Minimal
Installation Easy Easy Complex Complex
Cost Low Medium Medium High
Speed Medium Fast Medium Fast
Central device None Hub/Switch None None

🔮 TOPOLOGY MEMORY TRICKS:

text
BUS = "Bus route" — एक line पर सब
STAR = "Star shape" — center में hub
RING = "Ring" — circular path
MESH = "Spider web" — सबसे connected
TREE = "Tree branches" — hierarchical

🌐 OSI MODEL (7 LAYERS) — Very Important!

text
Layer 7 → APPLICATION → HTTP, FTP, SMTP
Layer 6 → PRESENTATION → Encryption, Format
Layer 5 → SESSION → Connection management
Layer 4 → TRANSPORT → TCP, UDP
Layer 3 → NETWORK → IP, Routing
Layer 2 → DATA LINK → MAC, Switch
Layer 1 → PHYSICAL → Cables, Hub

⚡ MEMORY TRICK (Top to Bottom):

"All People Seem To Need Data Processing"


Application → Presentation → Session → Transport → Network → Data Link → Physical

⚡ MEMORY TRICK (Bottom to Top):

"Please Do Not Throw Sausage Pizza Away"


Physical → Data Link → Network → Transport → Session → Presentation → Application

📊 OSI LAYER KEY FACTS

Layer Number Key Protocol Device


Physical 1 Ethernet Hub, Cable
Data Link 2 MAC Switch, Bridge
Network 3 IP Router
Transport 4 TCP, UDP —
Session 5 NetBIOS —
Presentation 6 SSL, JPEG —
Application 7 HTTP, FTP —
📡 TRANSMISSION MEDIA

Type Examples Speed


Twisted Pair Ethernet cable, Telephone Medium
Coaxial Cable TV cable, Old network Medium
Fiber Optic Internet backbone Fastest
Radio Waves WiFi, Bluetooth Fast
Microwave Satellite, Tower Fast
Infrared TV remote, Old phones Short range

Wired vs Wireless:

text
Wired = Twisted Pair, Coaxial, Fiber Optic
Wireless = Radio, Microwave, Infrared, Satellite

🔧 NETWORK DEVICES COMPLETE

Device Layer Function


Hub Physical (1) Broadcast to all ports
Switch Data Link (2) Send to specific device
Router Network (3) Connect different networks
Bridge Data Link (2) Connect two segments
Gateway All layers Connect different protocols
Repeater Physical (1) Amplify signal
Modem Physical (1) Analog↔Digital convert
NIC Data Link (2) Network Interface Card
Access Point Data Link (2) Wireless network center

📊 TCP vs UDP

Feature TCP UDP


Full Form Transmission Control Protocol User Datagram Protocol
Connection Connection-oriented Connectionless
Reliability Reliable Unreliable
Speed Slower Faster
Use Email, Web, FTP Video streaming, Gaming
Error check Yes No

🌐 IP ADDRESS CLASSES

Class Range Use


Class A 1-126 Large networks
Class B 128-191 Medium networks
Class C 192-223 Small networks
Class D 224-239 Multicast
Class E 240-255 Research

Private IP Ranges:

text
Class A: [Link] – [Link]
Class B: [Link] – [Link]
Class C: [Link] – [Link]

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

PART 4 — EXAM TRAP ALERTS ⚠️

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

🚨 TRAP 1: Hub vs Switch Layer

✅ Hub = Layer 1 (Physical)


✅ Switch = Layer 2 (Data Link)
✅ Router = Layer 3 (Network)

🚨 TRAP 2: TCP vs UDP

✅ TCP = Reliable (email, web)


✅ UDP = Fast but unreliable (video, gaming)

🚨 TRAP 3: OSI Layers count

✅ OSI = 7 layers (not 5, not 6)

🚨 TRAP 4: Fiber Optic

✅ Fiber Optic = Light signals use करता है


✅ Fastest transmission medium
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

PART 5 — RAPID REVISION BLOCK ⚡

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

text
⚡ NETWORKING — 5-MINUTE REVISION

🌐 Bus=Linear | Star=Hub center | Ring=Circular | Mesh=All connected


📚 OSI = 7 layers
📚 "All People Seem To Need Data Processing"
🔧 Hub=Layer1 | Switch=Layer2 | Router=Layer3
📡 Fiber Optic = Fastest medium
🔌 TCP = Reliable | UDP = Fast unreliable
🌐 IPv4 = 32-bit | IPv6 = 128-bit
🏠 192.168.x.x = Private IP (Class C)
📡 NIC = Network Interface Card
🔄 Modem = Analog↔Digital
📶 Access Point = Wireless hub

═══════════════════════════════════

📖 MODULE D: MS OFFICE ADVANCED

═══════════════════════════════════

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

PART 1 — MS WORD ADVANCED

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

📊 TABLE OPERATIONS IN MS WORD

text
Insert Table:
Insert Tab → Table → Insert Table → Rows/Cols set

Table Operations:
├── Merge Cells = Select cells → Right click → Merge
├── Split Cells = Right click → Split Cells
├── Split Table = Table Tools → Layout → Split Table
├── Add Row = Tab key (last cell में)
├── Delete Row = Select → Right click → Delete
├── Sort Table = Table Tools → Layout → Sort
└── Table Properties = Right click → Table Properties

Table Shortcut Keys:

text
Tab = Next cell
Shift+Tab = Previous cell
Tab (last cell) = New row add
Alt+Home = First cell in row
Alt+End = Last cell in row
Alt+PgUp = First cell in column
Alt+PgDn = Last cell in column

📧 MAIL MERGE — STEP BY STEP

text
MAIL MERGE PROCESS:
(Bulk letters/labels बनाने के मलए)

Step 1: Mailings Tab → Start Mail Merge


Step 2: Select document type (Letters/Labels/Email)
Step 3: Select Recipients → Use Existing List / Type New
Step 4: Insert Merge Fields (<<Name>>, <<Address>>)
Step 5: Preview Results
Step 6: Finish & Merge → Print/Edit Individual Documents

Key Terms:
Main Document = Letter template
Data Source = Excel/Database file with names
Merge Field = <<FieldName>> placeholder

📄 PAGE BREAKS vs SECTION BREAKS

Type Use Insert


Page Break New page start Ctrl+Enter
Section Break Next Page New section on new page Page Layout → Breaks
Section Break Continuous New section same page Page Layout → Breaks
Section Break Odd/Even Specific page type Page Layout → Breaks

🔢 PAGE NUMBERING

text
Insert Tab → Header & Footer → Page Number
├── Top of Page (Header)
├── Bottom of Page (Footer)
├── Page Margins
└── Current Position

Format Page Numbers:


Insert → Page Number → Format Page Numbers
├── Number format (1,2,3 or i,ii,iii or A,B,C)
└── Start at: (custom start number)

📝 STYLES IN MS WORD

text
Home Tab → Styles Group
├── Heading 1, Heading 2, Heading 3
├── Normal (default)
├── Title
└── Subtitle

Use:
✅ Automatic Table of Contents बनाने के मलए
✅ Consistent formatting के मलए

🔍 TRACK CHANGES (Review Tab)

text
Track Changes ON/OFF = Ctrl+Shift+E
Accept Changes = Review → Accept
Reject Changes = Review → Reject
Show Markup = Review → Show Markup
Comments Add = Review → New Comment
Delete Comment = Review → Delete

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

PART 2 — MS EXCEL ADVANCED

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

📊 PIVOT TABLE

text
What: Data को summarize करने का tool

How to Create:
Insert Tab → PivotTable → Select Range → OK
Drag fields to:
├── Rows area
├── Columns area
├── Values area (sum/count/average)
└── Filters area

Use: Large data analysis quickly

✅ DATA VALIDATION

text
What: Cell में specific type/range data ह enter हो

How:
Data Tab → Data Validation → Settings
├── Allow: Whole number / Decimal / List / Date
├── Data: Between / Equal to / Greater than
└── Input Message + Error Alert set करें

Example:
Age column = 18-60 only allow
Rating = 1,2,3,4,5 only (dropdown)

🔒 PROTECT SHEET/WORKBOOK

text
Sheet Protect:
Review Tab → Protect Sheet → Password set

Workbook Protect:
Review Tab → Protect Workbook

Effects:
├── Cells edit नह ीं होते
├── Rows/columns add/delete नह ीं
└── Sheet tabs rename नह ीं

📊 NAMED RANGES

text
What: Cell range को name दे ना

How:
Select range → Name Box में name type → Enter

Example:
A1:A10 को "Sales" नाम दे ना
Formula में: =SUM(Sales)

Benefits: Formula readable बनती हैं

🖨️ PRINT SETTINGS IN EXCEL

text
Page Layout Tab:
├── Print Area → Set Print Area
├── Print Titles → Repeat rows/columns on every page
├── Page Breaks → Insert Page Break
└── Scale to Fit → Fit to 1 page

File → Print:
├── Print Active Sheets
├── Print Entire Workbook
└── Print Selection

📊 IMPORTANT EXCEL FORMULAS (Advanced)

Formula Syntax Use


COUNTIF =COUNTIF(range,criteria) Count with condition
SUMIF =SUMIF(range,criteria,sum_range) Sum with condition
AVERAGEIF =AVERAGEIF(range,criteria,avg_range) Average with condition
IFERROR =IFERROR(formula,value_if_error) Error handling
ROUND =ROUND(number,digits) Round number
ABS =ABS(number) Absolute value
INT =INT(number) Integer part
MOD =MOD(number,divisor) Remainder
POWER =POWER(number,power) Exponent
SQRT =SQRT(number) Square root
RANK =RANK(number,ref,order) Rank in list
AND =AND(condition1,condition2) Both true
OR =OR(condition1,condition2) Either true
NOT =NOT(condition) Opposite

📊 CELL FORMATTING OPTIONS

text
Ctrl+1 = Format Cells Dialog
├── Number Tab: Format type (Currency, %, Date, Text)
├── Alignment Tab: Wrap text, Merge cells, Indent
├── Font Tab: Font, Size, Color, Bold/Italic
├── Border Tab: Cell borders
├── Fill Tab: Background color
└── Protection Tab: Lock/Hide cells

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

PART 3 — MS POWERPOINT ADVANCED

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

🎬 SLIDE TIMING & REHEARSE

text
Slide Show Tab → Rehearse Timings
├── Practice करें → Time record होती है
├── Save timings → Automatic advance set
└── Use: Self-running presentations

Set Manual Timing:


Transitions Tab → Advance Slide
├── On Mouse Click (manual)
└── After: X seconds (automatic)

🎵 INSERT AUDIO/VIDEO

text
Audio:
Insert Tab → Audio → Audio on My PC / Record Audio
├── Play across slides = सभी slides पर िले
├── Loop until stopped = repeat
└── Hide during show = icon hide

Video:
Insert Tab → Video → Video on My PC / Online Video
├── Start: Automatically / On Click
└── Full screen: Yes/No

🖥️ PRESENTER VIEW

text
Slide Show Tab → Use Presenter View
├── Requires 2 monitors OR
└── Single screen में भी available

Features:
├── Current slide (audience को ददखता है)
├── Next slide preview (presenter को)
├── Notes panel (speaker notes)
├── Timer
└── Annotation tools

📊 SLIDE MASTER

text
View Tab → Slide Master

Use:
├── Global design changes (सभी slides पर apply)
├── Logo/watermark add करना
├── Default fonts/colors set
└── Layout templates customize

Exit Slide Master:


Slide Master Tab → Close Master View

🎨 ANIMATION EFFECTS TYPES

Category Examples
Entrance Fly In, Fade, Bounce (object आता है)
Emphasis Spin, Grow/Shrink (object highlighted)
Exit Fly Out, Fade Out (object जाता है)
Motion Path Lines, Curves (object move करता है)
text
Animation Pane:
Animations Tab → Animation Pane
├── Order change करें
├── Timing set करें
└── Start: On Click / After Previous / With Previous

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

PART 4 — EXAM TRAP ALERTS ⚠️

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

🚨 TRAP 1: Mail Merge Data Source

✅ Data source = Excel/Access/Word table


✅ Main document = Letter template
🚨 TRAP 2: COUNTIF vs COUNT

✅ COUNT = लसफफ numbers count


✅ COUNTIF = Condition के साथ count

🚨 TRAP 3: Pivot Table location

✅ Pivot Table = Insert Tab (not Data Tab)

🚨 TRAP 4: Animation categories

✅ Entrance = Object आता है (most asked)


✅ Exit = Object जाता है
✅ Emphasis = Object highlight होता है

🚨 TRAP 5: Page Break shortcut

✅ Ctrl+Enter = Page Break (MS Word)


❌ Ctrl+P = Print (not page break)

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

PART 5 — RAPID REVISION BLOCK ⚡

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

text
⚡ MS OFFICE ADVANCED — 5-MINUTE REVISION

📝 WORD:
├── Mail Merge = Mailings Tab (Bulk letters)
├── Page Break = Ctrl+Enter
├── Track Changes = Ctrl+Shift+E
├── Table: Tab=next cell, Shift+Tab=prev cell
└── Page Numbers = Insert Tab

📊 EXCEL:
├── Pivot Table = Insert Tab
├── Data Validation = Data Tab
├── COUNTIF = Count with condition
├── SUMIF = Sum with condition
├── Protect Sheet = Review Tab
└── Print Area = Page Layout Tab

📊 POWERPOINT:
├── Rehearse Timings = Slide Show Tab
├── Presenter View = Slide Show Tab
├── Slide Master = View Tab
├── Animation: Entrance/Exit/Emphasis/Motion Path
└── Insert Audio/Video = Insert Tab

═══════════════════════════════════

📖 MODULE E: RAJASTHAN SPECIFIC SERVICES

═══════════════════════════════════

(RSCIT के लिए MOST IMPORTANT!)

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

PART 1 — SSO RAJASTHAN (Single Sign On)

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

🔑 SSO — COMPLETE NOTES

text
SSO = Single Sign On
Website = [Link]
Purpose = एक ID से सभी Rajasthan govt services

SSO Key Facts:

Feature Detail
Full Form Single Sign On
Website [Link]
Purpose One ID → All Rajasthan services
Launched by Rajasthan Government
Services 100+ government services
Registration Jan Aadhaar / Aadhaar / Bhamashah

📋 SSO REGISTRATION OPTIONS:

text
Citizens can register using:
├── Jan Aadhaar Card
├── Aadhaar Card
├── Bhamashah Card
├── Facebook / Google (Social)
└── Gmail

Government employees:
└── SIPF number से register

🏛️ SERVICES AVAILABLE ON SSO:

text
├── e-Mitra
├── Ration Card
├── Water/Electricity Bill
├── Land Records (Apna Khata)
├── Scholarship Applications
├── Employment Exchange
├── Police services
├── PHED services
├── Income/Domicile Certificate
├── Birth/Death Certificate
└── 100+ more services

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

PART 2 — e-MITRA COMPLETE NOTES

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

🏛️ e-MITRA — COMPLETE DETAILS

Feature Detail
Website [Link]
Purpose Rajasthan govt services delivery
Launched 2004 (Rajasthan Government)
Department DoIT&C (Dept of IT & Communication)
Operator LSK (Lok Sewa Kendra) operator
Available Urban + Rural both
📋 e-MITRA SERVICES:

text
Bill Payment:
├── Electricity bill (JVVNL, AVVNL, JDVVNL)
├── Water bill
└── Phone/Mobile bill

Certificates:
├── Income Certificate
├── Domicile Certificate
├── Caste Certificate
├── Birth Certificate
└── Death Certificate

Government Services:
├── Ration Card apply/update
├── Scholarship application
├── Pension application
├── Land records
└── Vehicle registration

Banking:
└── BC (Business Correspondent) banking

🏪 e-MITRA KIOSK

text
├── Physical shop/center
├── Operator = e-Mitra operator (LSK)
├── Commission basis पर काम करते हैं
├── Urban = Cyber cafe type
└── Rural = CSC type centers

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

PART 3 — JAN AADHAAR CARD

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

👨‍👩‍👧‍👦 JAN AADHAAR — KEY FACTS

Feature Detail
Launched 18 December 2019
State Rajasthan
Purpose Family identity + benefit delivery
Replaces Bhamashah Card
Digits 10-digit unique number
Head Female head of family (मदहला मुखखया)
Website [Link]
App Jan Aadhaar App

📋 JAN AADHAAR USES:

text
├── Government schemes का लाभ
├── DBT (Direct Benefit Transfer)
├── Scholarship
├── Ration Card linked
├── Pension benefits
├── Health insurance (RGHS/Chiranjeevi)
└── SSO login option

📊 BHAMASHAH vs JAN AADHAAR

Feature Bhamashah Jan Aadhaar


Launched 2014 2019
Status Discontinued Active
Head Female Female
Purpose Women empowerment Family benefits
Digits — 10-digit

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

PART 4 — APNA KHATA (LAND RECORDS)

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

🌾 APNA KHATA — KEY FACTS

Feature Detail
Website [Link]
Purpose Online land records
Services Jamabandi, Nakal, Khasra
Department Revenue Department Rajasthan

📋 APNA KHATA SERVICES:

text
├── Jamabandi Nakal (land record copy)
├── Khasra map
├── Land mutation status
├── Naksha (map)
└── E-dharti portal linked

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

PART 5 — OTHER RAJASTHAN PORTALS

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

🏛️ IMPORTANT RAJASTHAN PORTALS

Portal Website Purpose


SSO [Link] Single login all services
e-Mitra [Link] Govt services
Apna Khata [Link] Land records
Jan Aadhaar [Link] Family identity
RajSeva [Link] Service tracking
DOIT&C [Link] IT department
Sampark [Link] Grievance
Raj Kaushal [Link] Employment
Chiranjeevi [Link] Health scheme

📱 IMPORTANT RAJASTHAN APPS

App Purpose
Jan Aadhaar App Jan Aadhaar services
e-Mitra App e-Mitra services
RajCop Citizen Police services
Raj Sampark Grievance
Raj Kaushal Jobs/employment

🏢 RAJASTHAN IT DEPARTMENT

Organization Full Form Work


DOIT&C Department of Information Technology & Communication IT policy Rajasthan
RajCOMP Rajasthan State Computer Centre e-Governance
RSGSM Rajasthan State Govt Services Management —
RISL Rajasthan IT & Services Limited IT services
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

PART 6 — MCQ POINTS (RAJASTHAN)

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

• ⭐ SSO = [Link]
• ⭐ SSO = Single Sign On
• 🔥 e-Mitra = Rajasthan govt services portal
• ✅ Jan Aadhaar = 10-digit family ID
• ⭐ Jan Aadhaar launched = 18 Dec 2019
• 🔥 Jan Aadhaar head = Female (मदहिा मुखखया)
• ✅ Apna Khata = Land records portal
• ⭐ Bhamashah replaced by Jan Aadhaar
• 🔥 e-Mitra launched = 2004
• ✅ SSO services = 100+ Rajasthan services
• ⭐ DOIT&C = IT department Rajasthan
• 🔥 RISL = Rajasthan IT Services Limited

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

PART 7 — RAPID REVISION BLOCK ⚡

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

text
⚡ RAJASTHAN SERVICES — 5-MINUTE REVISION

🔑 SSO = Single Sign On ([Link])


🏛️ e-Mitra = Govt services (2004 launched)
👨‍👩‍👧‍👦 Jan Aadhaar = 10-digit, Dec 2019, Female head
🌾 Apna Khata = Land records online
💊 Chiranjeevi = Health insurance Rajasthan
📱 Jan Aadhaar replaces Bhamashah (2014→2019)
🏢 DOIT&C = Rajasthan IT department
🏢 RISL = Rajasthan IT services
📋 SSO se = 100+ services access
🔐 SSO login = Jan Aadhaar / Aadhaar / Gmail
═══════════════════════════════════

📖 MODULE F: DIGITAL SIGNATURE & SECURITY ADVANCED

═══════════════════════════════════

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

PART 1 — DIGITAL SIGNATURE

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

🔏 DIGITAL SIGNATURE — COMPLETE NOTES

text
Digital Signature = Electronic signature
Purpose = Document authenticity verify करना
Technology = Public Key Cryptography

Like = Handwritten signature का digital version


Legal = IT Act 2000 में legally valid

How it Works:

text
Sender:
Document → Hash create → Private Key से Encrypt
= Digital Signature attached to document

Receiver:
Signature → Public Key से Decrypt → Hash match?
✅ Yes = Authentic document
❌ No = Tampered/Fake

📋 DIGITAL SIGNATURE KEY FACTS

Feature Detail
Technology Public Key Infrastructure (PKI)
Keys used Private Key (sign) + Public Key (verify)
Certificate Digital Certificate from CA
CA Certifying Authority
Valid in India IT Act 2000
Use E-filing, E-contracts, Govt forms
India's CA CCA (Controller of Certifying Authorities)

🔐 TYPES OF ENCRYPTION

Type Description Example


Symmetric Same key for encrypt & decrypt AES, DES
Asymmetric Different keys (Public + Private) RSA
Hashing One-way (no decrypt) MD5, SHA

📜 DIGITAL CERTIFICATE

text
What: Electronic document proving identity
Contains:
├── Owner's name
├── Public key
├── Expiry date
├── Issuer (CA) information
└── Digital signature of CA

Types:
├── Class 1: Email validation
├── Class 2: Organization validation
└── Class 3: Strongest (legal use)

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

PART 2 — BIOMETRIC SECURITY

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

👁️ BIOMETRIC TYPES

Type Example
Fingerprint Most common
Iris Scan Eye recognition
Face Recognition Windows Hello, Phone unlock
Voice Recognition Siri, Alexa, Google
Retina Scan High security
Hand Geometry Shape of hand
Signature Dynamic signature
🔐 AUTHENTICATION FACTORS

text
Something you KNOW = Password, PIN, Pattern
Something you HAVE = OTP, Smart Card, Token
Something you ARE = Biometric (fingerprint, face)

Two-Factor Authentication (2FA) = 2 factors use


Multi-Factor Authentication (MFA) = 2+ factors

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

PART 3 — CYBER CRIME & LAWS COMPLETE

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

⚖️ IT ACT 2000 — ALL SECTIONS

Section Crime Punishment


Sec 43 Unauthorized computer access Compensation
Sec 65 Tampering with source code 3 years + fine
Sec 66 Computer fraud/hacking 3 years + ₹5L fine
Sec 66A Offensive online messages (Struck down)
Sec 66B Receiving stolen computer 3 years + fine
Sec 66C Identity theft 3 years + ₹1L fine
Sec 66D Cheating using computer 3 years + ₹1L fine
Sec 66E Privacy violation (images) 3 years + ₹2L fine
Sec 66F Cyber terrorism Life imprisonment
Sec 67 Obscene material online 5 years + fine
Sec 67A Sexually explicit material 5 years + fine
Sec 67B Child pornography 7 years + fine
Sec 69 Govt surveillance power —
Sec 72 Breach of confidentiality 2 years + fine
Sec 72A Disclosure of info in breach 3 years + fine

⚡ MOST ASKED:

Sec 66C = Identity Theft ⭐


Sec 66F = Cyber Terrorism ⭐
Sec 67 = Obscene material ⭐
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

PART 4 — RAPID REVISION BLOCK ⚡

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

text
⚡ DIGITAL SIGNATURE & SECURITY — 5-MINUTE REVISION

🔏 Digital Signature = PKI technology


🔑 Private Key = Sign करना
🔑 Public Key = Verify करना
📜 CA = Certifying Authority issues certificate
⚖️ IT Act 2000 = India's cyber law
⚖️ Sec 66C = Identity Theft
⚖️ Sec 66F = Cyber Terrorism (life imprisonment)
⚖️ Sec 67 = Obscene content online
👁️ Biometric = Fingerprint, Iris, Face, Voice
🔐 2FA = 2-factor authentication
🔐 MFA = Multi-factor authentication
🔒 Symmetric = Same key (AES, DES)
🔒 Asymmetric = Different keys (RSA)
🔒 Hashing = One-way (MD5, SHA)

═══════════════════════════════════

📖 MODULE G: E-COMMERCE & SOCIAL MEDIA

═══════════════════════════════════

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

PART 1 — E-COMMERCE COMPLETE

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

🛒 E-COMMERCE TYPES

Type Full Form Example


B2C Business to Consumer Amazon, Flipkart
B2B Business to Business Alibaba, IndiaMart
C2C Consumer to Consumer OLX, eBay
C2B Consumer to Business Freelancer, Upwork
G2C Government to Citizen e-Mitra, DigiLocker
B2G Business to Government Govt tenders

🛒 POPULAR E-COMMERCE PLATFORMS

Platform Type Company


Amazon B2C Amazon Inc
Flipkart B2C Walmart
Meesho B2C/C2C Facebook backed
Myntra Fashion Flipkart
Snapdeal B2C India
OLX C2C Naspers
Nykaa Beauty FSN Commerce

💳 ONLINE SHOPPING PROCESS:

text
1. Browse website/app
2. Select product → Add to cart
3. Create account / Login
4. Enter delivery address
5. Select payment method
6. Pay (UPI/Card/COD/Wallet)
7. Order confirmation (email/SMS)
8. Track order
9. Receive delivery
10. Return/Refund if needed

📋 ONLINE SHOPPING SAFETY:

text
✅ Trusted websites only (HTTPS)
✅ Seller ratings check करें
✅ Return policy read करें
✅ Secure payment method use करें
❌ Unknown links से shop न करें
❌ Too good to be true deals से बिें
❌ Public WiFi पर payment न करें
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

PART 2 — SOCIAL MEDIA COMPLETE

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

📱 SOCIAL MEDIA PLATFORMS

Platform Type Company


Facebook Social networking Meta
Instagram Photo/Video sharing Meta
Twitter/X Microblogging X Corp (Elon Musk)
LinkedIn Professional networking Microsoft
YouTube Video sharing Google/Alphabet
WhatsApp Messaging Meta
Telegram Messaging Telegram FZ LLC
Snapchat Photo messaging Snap Inc
Pinterest Image sharing Pinterest Inc
Koo Indian Twitter alt Bombinate Tech
ShareChat Indian regional ShareChat

🔒 SOCIAL MEDIA SAFETY RULES:

text
Privacy Settings:
├── Profile = Friends only (not public)
├── Location sharing = OFF
├── Phone number = Hidden
└── Birthday = Hidden

Do:
✅ Strong password use करें
✅ 2FA enable करें
✅ Trusted friends ह connect करें
✅ Report suspicious accounts

Don't:
❌ Personal info public share न करें
❌ Unknown friend requests accept न करें
❌ Fake news share न करें
❌ Strangers से personal बात न करें
📸 CYBERBULLYING

text
What = Online harassment/bullying
Types:
├── Harassment = Repeated offensive messages
├── Trolling = Intentional provocative posts
├── Doxing = Personal info publicly share
├── Cyberstalking = Online following/monitoring
└── Impersonation = Fake profile बनाना

Prevent:
├── Block & Report करें
├── Evidence save करें (screenshots)
├── Parent/Teacher को बताएीं
└── Cyber cell complaint करें

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

PART 3 — VIDEO CONFERENCING TOOLS

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

📹 VIDEO CONFERENCING PLATFORMS

Tool Company Key Feature


Zoom Zoom Video Communications 100 participants free
Google Meet Google Gmail integrated
Microsoft Teams Microsoft Office 365 integrated
Skype Microsoft Old video calling
Webex Cisco Enterprise use
GoToMeeting LogMeIn Business focused

Key Features (Exam Ready):

text
Zoom:
├── Free = 40 min limit (3+ participants)
├── Screen sharing ✅
├── Recording ✅
└── Breakout rooms ✅

Google Meet:
├── Free = 60 min (updated)
├── Gmail से directly join
└── Google Calendar integrated

Microsoft Teams:
├── Chat + Video + Files
├── Office integration
└── Channels feature

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

PART 4 — RAPID REVISION BLOCK ⚡

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

text
⚡ E-COMMERCE & SOCIAL MEDIA — 5-MINUTE REVISION

🛒 B2C = Amazon, Flipkart (Business to Consumer)


🛒 B2B = Alibaba (Business to Business)
🛒 C2C = OLX, eBay (Consumer to Consumer)
🛒 G2C = e-Mitra (Government to Citizen)
📱 Facebook/Instagram = Meta
📱 WhatsApp = Meta
🐦 Twitter/X = Elon Musk (X Corp)
💼 LinkedIn = Microsoft (Professional)
📹 YouTube = Google (Video)
📹 Zoom = 40 min free limit
📹 Google Meet = Gmail integrated
📹 Teams = Microsoft Office integrated
🔒 Social media = Privacy settings strong रखें
💻 Cyberbullying = Block + Report + Screenshot

═══════════════════════════════════

📖 MODULE H: MOBILE DEVICES COMPLETE

═══════════════════════════════════
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

PART 1 — MOBILE APP TYPES

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

📱 APP TYPES

Type Description Example


Native App Specific OS के मलए बनाई Instagram (Android/iOS separately)
Web App Browser में run होती है Gmail web, Google Docs
Hybrid App Native + Web (combination) Ionic apps
PWA Progressive Web App Twitter Lite

Key Difference:

text
Native = Fast, OS-specific (.apk for Android, .ipa for iOS)
Web = Browser dependent, no install needed
Hybrid = Both लाभ, compromise on performance

📱 MOBILE OS COMPARISON

Feature Android iOS


Developer Google Apple
Open Source Yes No
Customization High Limited
App Store Google Play App Store
Security Moderate High
Devices Many brands iPhone/iPad only
File extension .apk .ipa

📱 MOBILE STORAGE TYPES

Storage Full Form Use


Internal Storage — Apps, data
External Storage MicroSD card Extra space
Cloud Storage — Online backup
RAM Random Access Memory Running apps
ROM Read Only Memory OS stored
📶 MOBILE CONNECTIVITY

Tech Use Range


WiFi Internet (fast) Short
Bluetooth Device connect ~10m
NFC Payment, data (tap) ~4cm
GPS Location Satellite
4G/5G Mobile internet Wide
Hotspot Share internet WiFi range
USB Tethering Share via cable Cable length

🔒 MOBILE SECURITY

text
Screen Lock Types:
├── PIN (4-6 digits)
├── Password (alphanumeric)
├── Pattern (swipe)
├── Fingerprint (biometric)
├── Face unlock (biometric)
└── Smart lock (location/device based)

Security Tips:
✅ Screen lock always enable
✅ Only trusted apps install (Play Store)
✅ App permissions check करें
✅ Regular updates करें
✅ Remote wipe enable करें (Find My Device)
❌ Unknown APK install न करें
❌ Rooting/Jailbreaking से बिें

📱 GOOGLE PLAY vs APP STORE

Feature Google Play App Store


Platform Android iOS
Company Google Apple
Free apps Yes Yes
App format .apk .ipa
Review Less strict More strict
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

PART 2 — RAPID REVISION BLOCK ⚡

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

text
⚡ MOBILE DEVICES — 5-MINUTE REVISION

📱 Android = Google | iOS = Apple


📱 Android app = .apk | iOS app = .ipa
📱 Google Play = Android store
📱 App Store = iOS store
📱 Native = OS specific (fast)
📱 Web = Browser based
📱 Hybrid = Native + Web
📶 NFC = Tap payment (~4cm range)
📶 Bluetooth = ~10m range
📶 GPS = Satellite location
🔒 Screen lock = PIN/Pattern/Biometric
🔒 Unknown APK = Never install
🔒 Rooting = Security risk

═══════════════════════════════════

📖 MODULE I: AI, ML & EMERGING TECH COMPLETE

═══════════════════════════════════

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

PART 1 — ARTIFICIAL INTELLIGENCE

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

🤖 AI COMPLETE NOTES

text
AI = Artificial Intelligence
= Machines को human जैसी intelligence दे ना
= Thinking, Learning, Problem solving by machines

AI Types:

Type Description Example


Narrow AI Specific task only Siri, Chess AI
General AI Human-like (theoretical) Not yet built
Super AI Beyond human (theoretical) Future concept

🧠 MACHINE LEARNING TYPES

Type Description Example


Supervised Learning Labeled data से सीखना Spam detection
Unsupervised Learning Unlabeled data से patterns Customer grouping
Reinforcement Learning Reward/penalty से सीखना Game playing AI

🤖 AI APPLICATIONS (Exam Ready!)

Application Example
Virtual Assistant Siri, Alexa, Google Assistant, Cortana
Recommendation Netflix, YouTube suggestions
Face Recognition Phone unlock, CCTV
Chatbots Customer service bots
Self-driving Tesla, Waymo cars
Medical AI Disease diagnosis
Natural Language ChatGPT, Google Bard
Image Recognition Google Photos

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

PART 2 — BLOCKCHAIN COMPLETE

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

🔗 BLOCKCHAIN KEY FACTS

text
Blockchain = Distributed + Decentralized ledger
= Chain of blocks (data records)
= Tamper-proof (change करना almost impossible)
= No central authority (decentralized)
Key Features:

text
├── Decentralized = No single control
├── Immutable = Data change नह ीं होता
├── Transparent = All can see
├── Secure = Cryptography use
└── Distributed = Multiple copies

Blockchain Uses:

text
├── Cryptocurrency (Bitcoin, Ethereum)
├── Smart Contracts
├── Supply Chain Management
├── Healthcare Records
├── Voting Systems
└── Land Records

Bitcoin:

text
├── First cryptocurrency (2009)
├── Created by: Satoshi Nakamoto (pseudonym)
├── Blockchain based
└── Decentralized digital currency

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

PART 3 — IoT COMPLETE

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

🔗 IoT — INTERNET OF THINGS

text
IoT = Physical devices that are internet-connected
= Smart devices that collect and share data
= "Things" connected to internet

IoT Examples:

text
Home:
├── Smart TV
├── Smart fridge
├── Smart AC (thermostat)
├── Smart lights (Alexa/Google control)
└── Smart door lock
Industry:
├── Smart factory machines
├── Connected sensors
└── Fleet tracking

Healthcare:
├── Smartwatch (heart rate)
├── Connected glucose monitor
└── Remote patient monitoring

Cities:
├── Smart traffic signals
├── Smart parking
└── Smart street lights

IoT Architecture:

text
Devices/Sensors → Gateway → Cloud → Application
(Data collect) (Send) (Store/Process) (User)

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

PART 4 — AR & VR

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

🥽 AR vs VR vs MR

Technology Full Form Description Example


AR Augmented Reality Real world + Digital overlay Pokémon GO, Snapchat filters
VR Virtual Reality Fully digital world VR headsets, Games
MR Mixed Reality Real + Digital interact HoloLens
XR Extended Reality AR+VR+MR combined —

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

PART 5 — BIG DATA

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

📊 BIG DATA — KEY CONCEPTS

text
Big Data = Extremely large datasets
Cannot be processed by traditional databases

5 V's of Big Data:

text
Volume = बहुत बडा data (TB, PB)
Velocity = बहुत तेज generate होता है
Variety = Different types (text, image, video)
Veracity = Data accuracy/trustworthiness
Value = Useful insights ननकालना

Big Data Tools:

text
├── Hadoop (storage & processing)
├── Spark (fast processing)
├── MongoDB (NoSQL database)
└── Tableau (visualization)

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

PART 6 — RAPID REVISION BLOCK ⚡

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

text
⚡ EMERGING TECH — 5-MINUTE REVISION

🤖 AI = Machine intelligence
🧠 ML = Supervised/Unsupervised/Reinforcement
💬 ChatGPT = AI language model
🔗 Blockchain = Decentralized + Immutable ledger
₿ Bitcoin = First cryptocurrency (2009, Satoshi)
🔗 IoT = Smart internet-connected devices
📱 Smart TV/Fridge/Watch = IoT examples
🥽 AR = Real + Digital overlay (Pokémon GO)
🥽 VR = Fully virtual world (VR headsets)
📊 Big Data = 5V's: Volume, Velocity, Variety, Veracity, Value
🗣️ Alexa/Siri/Cortana = AI Voice assistants
🤖 Narrow AI = Specific task (current AI)
═══════════════════════════════════

📖 MODULE J: ONLINE BANKING & INTERNET SAFETY

═══════════════════════════════════

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

PART 1 — ONLINE BANKING

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

🏦 ONLINE BANKING FEATURES

text
Internet Banking = Bank services online access
Mobile Banking = Bank app से services

Services:
├── Account balance check
├── Fund transfer (NEFT/RTGS/IMPS)
├── Bill payment
├── Fixed Deposit/RD management
├── Cheque book request
├── Statement download
└── Loan application

🏦 INTERNET BANKING SAFETY:

text
✅ Official bank website/app use करें
✅ HTTPS check करें
✅ Logout हमेशा करें
✅ Strong password use करें
✅ Regular statement check करें
✅ Transaction alerts ON रखें
❌ Public WiFi पर net banking न करें
❌ Unknown links से login न करें
❌ Browser में password save न करें
❌ OTP फकसी को share न करें
📱 MOBILE BANKING FEATURES:

Feature Description
UPI Payment Instant transfer via mobile
QR Scan Scan to pay
Bill Pay Utility bills payment
Recharge Mobile/DTH recharge
Mini Statement Last transactions
Block Card Emergency card block
Cheque Status Cheque tracking

🏧 ATM SAFETY RULES:

text
✅ Keypad cover करके PIN type करें
✅ अकेले use करें (shoulder surfing से बिें)
✅ Transaction receipt लें
✅ Unknown ATM से बिें
❌ PIN फकसी को न बताएीं
❌ Card फकसी को न दें
❌ Unknown device attached ATM use न करें (skimmer)
❌ Help करने वाले strangers से सावधान

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

PART 2 — INTERNET SAFETY COMPLETE

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

🌐 SAFE BROWSING TIPS:

text
✅ HTTPS websites prefer करें
✅ Pop-up blocker enable रखें
✅ Browser updated रखें
✅ Ad blocker use करें
✅ Downloads verified source से करें
❌ Unknown links click न करें
❌ Pirated software download न करें
❌ Free WiFi पर sensitive info share न करें
📧 EMAIL SAFETY:

text
✅ Unknown sender का attachment न खोलें
✅ Suspicious links hover करके check करें
✅ Spam folder regularly clean करें
✅ Unsubscribe से legitimate emails हटाएीं
❌ Personal info email पर share न करें
❌ Bank details email में न भेजें
❌ Unknown exe/zip files download न करें

🔒 PASSWORD SECURITY COMPLETE:

text
Strong Password Rules:
✅ Minimum 8 characters (12+ better)
✅ UPPERCASE + lowercase
✅ Numbers (0-9)
✅ Special characters (!@#$%^&*)
✅ Not dictionary words
✅ Not personal info (name, birthday)
✅ Different for each account
✅ Change regularly (3-6 months)

Password Manager:
├── LastPass
├── 1Password
├── Bitwarden (Free)
└── Google Password Manager

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

PART 3 — RAPID REVISION BLOCK ⚡

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

text
⚡ ONLINE BANKING & SAFETY — 5-MINUTE REVISION

🏦 Net Banking = HTTPS official site


🏦 Logout always = after banking
📱 UPI = Instant mobile payment
🏧 ATM = Cover keypad while PIN
🏧 Skimmer = Fake card reader (fraud device)
❌ OTP share NEVER
❌ Public WiFi banking NEVER
❌ Unknown links NEVER
🔒 Strong password = 8+ mixed chars
🔒 Different password = different accounts
📧 Unknown email attachment = NEVER open
✅ HTTPS = Safe | HTTP = Unsafe
✅ Transaction alerts = Always ON

═══════════════════════════════════

🏆 FINAL MASTER REVISION SYSTEM

═══════════════════════════════════

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

📊 COMPLETE COMPARISON TABLES

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

🖥️ MS OFFICE COMPLETE COMPARISON

Feature MS Word MS Excel MS PowerPoint


Extension .docx .xlsx .pptx
Old ext .doc .xls .ppt
Default font Calibri 11 Calibri 11 Calibri 18
Default page A4 Portrait — Widescreen
Spell Check F7 F7 F7
New file Ctrl+N Ctrl+N Ctrl+N
Save Ctrl+S Ctrl+S Ctrl+S
Save As F12 F12 F12
Print Ctrl+P Ctrl+P Ctrl+P
Find Ctrl+F Ctrl+F Ctrl+F
Replace Ctrl+H Ctrl+H Ctrl+H
Undo Ctrl+Z Ctrl+Z Ctrl+Z
📡 PROTOCOL MASTER TABLE

Protocol Port Use


HTTP 80 Web browsing
HTTPS 443 Secure web
FTP 21 File transfer
SSH 22 Secure remote
SMTP 25 Email send
POP3 110 Email receive
IMAP 143 Email sync
DNS 53 Name to IP
DHCP 67/68 Auto IP assign
Telnet 23 Remote access

⚡ PORT MEMORY TRICK:

"HTTP=80, HTTPS=443, FTP=21, SMTP=25, POP3=110"


Most asked ports in RSCIT

🔢 STORAGE HIERARCHY (Complete)

text
BIT (0/1)

NIBBLE (4 bits)

BYTE (8 bits)

KILOBYTE (1024 Bytes)

MEGABYTE (1024 KB)

GIGABYTE (1024 MB)

TERABYTE (1024 GB)

PETABYTE (1024 TB)

EXABYTE (1024 PB)

ZETTABYTE (1024 EB)

YOTTABYTE (1024 ZB)

🖨️ PRINTER DPI INFO

text
DPI = Dots Per Inch
= Print quality measure
Higher DPI = Better quality

Standard:
├── 300 DPI = Good quality
├── 600 DPI = High quality
└── 1200 DPI = Photo quality

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

🎯 ADDITIONAL 25 EXPECTED MCQs

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

text
Q26: SSO का full form क्या है?
A: Single Sign On ✅

Q27: Jan Aadhaar card में फकतने digits हैं?


A: 10 digits ✅

Q28: e-Mitra कब launch हुआ?


A: 2004 ✅

Q29: OSI model में फकतने layers हैं?


A: 7 layers ✅

Q30: Router फकस OSI layer पर काम करता है?


A: Layer 3 (Network) ✅

Q31: TCP vs UDP में reliable कौनसा है?


A: TCP ✅

Q32: ASCII 'A' का decimal value क्या है?


A: 65 ✅

Q33: Unicode फकतने bit का है?


A: 16 bit ✅

Q34: Binary 1111 = Decimal?


A: 15 ✅
Q35: Hex FF = Decimal?
A: 255 ✅

Q36: B2C e-commerce का example?


A: Amazon, Flipkart ✅

Q37: Facebook फकस company का है?


A: Meta ✅

Q38: Zoom free version time limit?


A: 40 minutes (3+ participants) ✅

Q39: LinkedIn फकस company ने acquire फकया?


A: Microsoft ✅

Q40: Bitcoin फकसने बनाया?


A: Satoshi Nakamoto ✅

Q41: Blockchain की key feature?


A: Decentralized + Immutable ✅

Q42: IoT का full form?


A: Internet of Things ✅

Q43: AR का example?
A: Pokémon GO ✅

Q44: IT Act Section 66F?


A: Cyber Terrorism ✅

Q45: IT Act Section 66C?


A: Identity Theft ✅

Q46: Digital Signature में Private key का use?


A: Document sign करने के मलए ✅

Q47: Mail Merge में data source क्या होता है?


A: Excel/Database file with recipient data ✅

Q48: Pivot Table फकस Tab में है?


A: Insert Tab ✅

Q49: Animation का Entrance effect क्या है?


A: Object slide पर आता है ✅

Q50: Native app का file format (Android)?


A: .apk ✅

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

🔥 UPDATED FULL FORM ADDITIONS

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

Abbreviation Full Form


SSO Single Sign On
PKI Public Key Infrastructure
CA Certifying Authority
CCA Controller of Certifying Authorities
2FA Two-Factor Authentication
MFA Multi-Factor Authentication
AES Advanced Encryption Standard
DES Data Encryption Standard
RSA Rivest–Shamir–Adleman
MD5 Message Digest 5
SHA Secure Hash Algorithm
B2C Business to Consumer
B2B Business to Business
C2C Consumer to Consumer
G2C Government to Citizen
PWA Progressive Web App
APK Android Package Kit
IPA iOS App Archive
NFC Near Field Communication
GPS Global Positioning System
DPI Dots Per Inch
GUI Graphical User Interface
CLI Command Line Interface
DOIT&C Department of Information Technology & Communication
RISL Rajasthan IT & Services Limited
DHCP Dynamic Host Configuration Protocol
MAC Media Access Control
NIC Network Interface Card
AR Augmented Reality
VR Virtual Reality
MR Mixed Reality
XR Extended Reality
DBT Direct Benefit Transfer
UAC User Account Control
UPS Uninterruptible Power Supply

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

⚡ COMPLETE FINAL RAPID REVISION

(EXAM से पहिे — एक बार पूरा पढें )

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

text
╔══════════════════════════════════════════════╗
║ 🏆 RSCIT FINAL REVISION — ALL TOPICS ║
╚══════════════════════════════════════════════╝

💻 COMPUTER BASICS:
• 1 Byte=8 Bits | 1 KB=1024 Bytes
• RAM=Volatile | ROM=Non-Volatile
• CPU=ALU+CU | ENIAC=1st Computer
• PARAM=India Supercomputer
• 1G=Vacuum | 2G=Transistor | 3G=IC | 4G=Micro | 5G=AI
• MICR=Cheques | OMR=Exam sheets
• Scanner=Input | Printer=Output

🔢 NUMBER SYSTEMS:
• Binary=Base2 | Octal=Base8 | Hex=Base16
• ASCII=7bit=128chars | Unicode=16bit
• ASCII A=65 | a=97 | 0=48
• 1010₂=10₁₀=A₁₆ | FF₁₆=255₁₀

🪟 WINDOWS:
• Recycle Bin=deleted files temp
• USB/Network delete=Permanent
• Shift+Delete=Permanent
• Admin=Full rights | Standard=Limited
• Win+D=Desktop | Win+E=Explorer
• Win+L=Lock | Ctrl+Shift+Esc=Task Manager

📝 MS WORD:
• Extension=.docx | Font=Calibri 11
• Page=A4 Portrait | F7=Spell Check
• F12=Save As | Ctrl+H=Replace
• Mail Merge=Mailings Tab
• Watermark=Page Layout Tab
• Ctrl+Enter=Page Break

📊 MS EXCEL:
• Extension=.xlsx | Formula==sign
• Max Rows=1,048,576 | Max Cols=16,384
• Text=Left | Number=Right aligned
• $A$1=Absolute | Alt+=AutoSum
• F11=Chart | F2=Edit | F4=Absolute
• Pivot Table=Insert Tab
• Data Validation=Data Tab

📊 MS POWERPOINT:
• Extension=.pptx | F5=Slide Show
• Shift+F5=Current slide
• B=Black | W=White (during show)
• Transition=Slide | Animation=Object
• Entrance=Object आता | Exit=Object जाता
• Slide Master=View Tab

🌐 INTERNET:
• SMTP=Send(25) | POP3=Recv(110)
• HTTP=80 | HTTPS=443 | FTP=21
• DNS=Name to IP | URL=Address
• LAN=Local | MAN=Metro | WAN=Wide
• IPv4=32bit | IPv6=128bit
• Hub=Layer1 | Switch=Layer2 | Router=Layer3
• TCP=Reliable | UDP=Fast

🔒 CYBER SECURITY:
• Ransomware=Encrypt+ransom
• Phishing=Email | Vishing=Voice | Smishing=SMS
• Worm=Self-replicate | Trojan=Fake useful
• Firewall=Filter | Antivirus=Remove
• IT Act 2000=Cyber law India
• Sec 66C=Identity Theft
• Sec 66F=Cyber Terrorism
• White Hat=Legal | Black Hat=Illegal

💳 DIGITAL PAYMENTS:
• UPI=Unified Payment Interface (NPCI)
• BHIM=Bharat Interface for Money
• RTGS=Min ₹2 Lakh | IMPS=24x7
• ATM=Automated Teller Machine
• OTP=One Time Password (NEVER share)
• CVV=3-digit back of card
• IFSC=Bank branch code

🏛️ RAJASTHAN SERVICES:
• SSO=[Link] (Single Sign On)
• e-Mitra=2004 launched (Govt services)
• Jan Aadhaar=10-digit, Dec 2019, Female head
• Apna Khata=Land records
• DOIT&C=Rajasthan IT department
• RISL=Rajasthan IT Services

☁️ CLOUD & EMERGING:


• SaaS=Gmail | PaaS=App Engine | IaaS=AWS
• AWS=Amazon | Azure=Microsoft
• Android=Google | iOS=Apple
• Blockchain=Decentralized+Immutable
• Bitcoin=2009, Satoshi Nakamoto
• IoT=Smart connected devices
• AR=Real+Digital | VR=Fully virtual
• Big Data=5V: Volume,Velocity,Variety,Veracity,Value

🛒 E-COMMERCE & SOCIAL:


• B2C=Amazon | B2B=Alibaba | C2C=OLX
• G2C=e-Mitra
• Facebook/Instagram/WhatsApp=Meta
• Twitter/X=Elon Musk
• LinkedIn=Microsoft
• Zoom=40min free limit
• Google Meet=Gmail integrated

🔐 SECURITY ADVANCED:
• Digital Signature=Private key sign, Public verify
• CA=Certifying Authority
• AES/DES=Symmetric | RSA=Asymmetric
• 2FA=2 factor | MFA=Multi-factor
• Biometric=Fingerprint/Iris/Face/Voice

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

📊 FINAL COVERAGE REPORT

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

Module Status Coverage


Computer Basics Complete 100%
Number Systems Complete 100%
Windows OS Complete 100%
MS Word Complete 100%
MS Excel Complete 100%
MS PowerPoint Complete 100%
Internet & Email Complete 100%
Networking Complete 100%
Cyber Security Complete 100%
Digital Payments Complete 100%
Rajasthan Services Complete 100%
E-Commerce Complete 100%
Social Media Complete 100%
Mobile Devices Complete 100%
Cloud Computing Complete 100%
AI/ML/Emerging Tech Complete 100%
Digital Signature Complete 100%
Online Banking Safety Complete 100%
text
╔══════════════════════════════════════╗
║ TOTAL COVERAGE: 100% ✅ ║
║ EXAM READINESS: MAXIMUM 🏆 ║
║ FULL MARKS TARGET: ACHIEVED 🎯 ║
╚══════════════════════════════════════╝

🏆 CONGRATULATIONS!

आपके पास अब COMPLETE RSCIT NOTES हैं

Every Topic • Every Shortcut • Every Trap • Every MCQ

💡 LAST ADVICE:

text
1. ये notes 3 बार पढें
2. Shortcut keys रोज practice करें
3. Rajasthan specific topics याद करें
4. Full forms की list scan करें daily
5. Exam से 1 hour पहले Final Rapid Revision पढें
🎯 आप RSCIT में जरूर TOPPER बनेंगे! 💪

You might also like