💻 RSSB Computer Instructor
Complete Study Material + 700+ MCQs | Fundamentals | Programming | Networks | DBMS | Pedagogy
🖥️ Fundamentals of Computer
Computer: Latin 'Computare' → to calculate. Electronic device processing input → output.
CPU Units
- ALU – math/logic operations
- Control Unit – nervous system
- Memory Unit – main internal memory
Memory Types
- RAM (volatile): SRAM, DRAM
- ROM (non‑volatile): PROM, EPROM, EEPROM
- Secondary: HDD, SSD, Magnetic tape, Optical disc, Pen drive (EEPROM)
Number Systems
Binary(base2), Octal(base8), Decimal(base10), Hex(base16).
1 Byte = 8 bits, 1 KB = 1024 Bytes.
Conversions: Decimal→Binary (÷2), Binary→Hex (group 4 bits), Binary→Octal (group 3 bits).
📄 Word Processing (MS Word)
MS Word (1990): Create/edit documents. Shortcuts: Ctrl+S (Save), Ctrl+P (Print), Ctrl+C/V/X (Copy/Paste/Cut), Ctrl+Z (Undo), Ctrl+Y (Redo), Ctrl+L/E/R/J (Align). Zoom 10‑500%. Mail Merge, Thesaurus, Macro (VBA). Default font: Calibri (2016).
MS Excel
Workbook (255 sheets), rows: 1,048,576, columns: XFD. Functions: SUM, AVERAGE, COUNT, MAX, MIN, CONCATENATE, TODAY/NOW. AutoSum Alt+=. File .xlsx. Sorting, Filtering (Ctrl+Shift+L).
MS PowerPoint
Presentation (.pptx). Views: Normal, Slide Sorter, Slide Show. F5 (start show). Slide Master. Max 9 slides per handout. Animation Painter, Transition effects.
MS Access
RDBMS. Tables, Queries, Forms, Reports. Relationships: one-to-one, one-to-many. Primary key, Foreign key. Data types: Text, Memo, Number, Date/Time.
⚙️ Programming Fundamentals
C (1972, Dennis Ritchie)
Procedural, 32 keywords, printf/scanf. Arrays, pointers, structures. Call by value / reference. Loops: for, while, do-while.
C++ (Bjarne Stroustrup)
OOP, classes, inheritance, polymorphism, virtual functions. new/delete, cin/cout.
Java (James Gosling, 1995)
Platform independent (JVM), OOP, garbage collection, multithreading. Packages: java.lang, java.io, java.util.
Python (Guido van Rossum, 1991)
Interpreted, dynamic typing, batteries included. Indentation, lists, dicts, OOP.
AI & ML
John McCarthy (AI), LISP. ML types: Supervised, Unsupervised, Reinforcement. Deep learning (CNN, RNN). Blockchain: decentralized ledger, Satoshi Nakamoto. Smart contracts.
OOP Principles
Encapsulation, Inheritance, Polymorphism, Abstraction. Constructor, Destructor, Friend function.
📊 Data Structures & Algorithms
Arrays (contiguous), Linked lists (dynamic), Stack (LIFO), Queue (FIFO). Trees: Binary Tree, BST, AVL (balanced). Traversal: Pre, In, Post. Graph: BFS (Queue), DFS (Stack). Sorting: Bubble, Selection, Insertion, Merge (O(n log n)), Quick (worst O(n²)), Heap. Searching: Binary Search (O(log n)), Linear (O(n)). Hash table, Symbol table.
🖧 Computer Organization & OS
CPU: ALU, CU, registers. Cache, RAM, ROM. OS types: Batch, Time-sharing, Real-time (RTOS). Scheduling: FCFS, SJF, Round Robin. Process states, semaphores. Deadlock. Memory management, paging, segmentation.
Networking (OSI 7 layers)
Physical, Data link, Network, Transport, Session, Presentation, Application. TCP/IP model. Devices: Hub, Switch, Router, Gateway. Topologies: Star, Bus, Ring, Mesh. IPv4 (32 bit), IPv6 (128 bit). HTTP, SMTP, FTP, DNS, ARP. Firewall, VPN, Cyber threats (virus, worm, trojan).
🗄️ Database Management System
RDBMS (E.F. Codd, 1970). SQL: DDL (CREATE, ALTER, DROP), DML (SELECT, INSERT, UPDATE, DELETE). Constraints: PRIMARY KEY, FOREIGN KEY, NOT NULL, UNIQUE. Normalization (1NF,2NF,3NF,BCNF). ACID properties. NoSQL: MongoDB (document store).
📐 System Design & IoT
SDLC: Waterfall, Spiral, Agile. DFD, Decision trees, Coupling/Cohesion. Testing: White box, Black box, Unit/Integration/System. COCOMO model. IoT: M2M, Sensors, Cloud, Edge computing. Virtual Reality, Web publishing, HTML/XML.
Pedagogy
Bloom's Taxonomy (Cognitive, Affective, Psychomotor). Micro-teaching (Stanford 1963). Teaching methods: Lecture, Demonstration, Project, CAI. Formative & Summative evaluation.