Notes library · Non-Technical

💻 Computer Knowledge Notes

Computer organisation, hardware and software, operating systems, MS Office, internet, networking, security and databases.

13 of 13 chapters written

Chapters

  1. 01Computer Fundamentals & OrganisationWhat a computer is and its characteristics; limitations; history — abacus, Pascaline, Babbage's Difference and Analytical Engines, Ada Lovelace, Hollerith, ENIAC, stored-program concept and von Neumann architecture; generations of computers; classification by working principle (analog, digital, hybrid), purpose and size (supercomputers, mainframes, minicomputers, microcomputers, embedded); Indian supercomputers; block diagram and functional units — input, CPU (ALU, CU, registers), memory, output, buses; data, information and processing cycle; bits, bytes and storage units; number systems and conversions — with worked examples.Read →
  2. 02Hardware, Software & Input-Output DevicesHardware components — motherboard, processor, RAM, storage, graphics card, power supply, expansion slots and ports (USB, HDMI, VGA, Ethernet, audio); input devices — keyboard (types of keys), pointing devices, scanners, OCR, OMR, MICR, barcode and QR readers, biometric devices, digitisers, microphones and cameras; output devices — monitors (CRT, LCD, LED, OLED), resolution and refresh rate, printers (impact and non-impact), plotters, speakers, projectors; software — system software (operating systems, utilities, device drivers, language translators), application software, firmware, licensing types (proprietary, freeware, shareware, open source); programming language generations — with worked examples.Read →
  3. 03Memory & Operating SystemsMemory hierarchy — registers, cache, primary and secondary memory; primary memory — RAM (SRAM, DRAM) and ROM (PROM, EPROM, EEPROM, flash); secondary storage — magnetic (hard disks, tapes), optical (CD, DVD, Blu-ray), solid-state (SSD, pen drives, memory cards) and cloud storage with typical capacities; virtual memory; operating systems — definition, functions (process, memory, file, device management, security, user interface), types (batch, multiprogramming, time-sharing, multitasking, multiprocessing, real-time, distributed, network, mobile), popular operating systems, booting process (BIOS/UEFI, POST, bootloader), kernel and shell, CLI vs GUI, file systems, process scheduling and deadlock basics — with worked examples.Read →
  4. 04DOS Commands & Windows BasicsMS-DOS — features, prompt and paths, drives, file naming, wildcards, internal and external commands (DIR, CD, MD, RD, COPY, DEL, REN, TYPE, CLS, DATE, TIME, VER, VOL, FORMAT, CHKDSK, XCOPY, TREE, ATTRIB, EDIT), system/boot files (IO.SYS, MSDOS.SYS, COMMAND.COM, CONFIG.SYS, AUTOEXEC.BAT), batch files; Windows command prompt equivalents; Microsoft Windows — desktop, taskbar, Start menu, icons and shortcuts, windows elements, File Explorer, files and folders, Recycle Bin, Control Panel/Settings, Task Manager, accessories (Notepad, Paint, WordPad, Calculator, Snipping Tool), common file extensions, keyboard shortcuts, system maintenance tools — with worked examples.Read →
  5. 05MS WordWord processing concepts and Microsoft Word interface — Quick Access Toolbar, ribbon tabs and groups, status bar, views; creating, saving (file formats, templates) and printing documents; text editing — selection, cut/copy/paste, find and replace, undo/redo, spelling and grammar, thesaurus, AutoCorrect; formatting — character (font, size, styles, case, subscript/superscript), paragraph (alignment, indentation, line spacing, bullets and numbering, borders and shading), styles and Format Painter; page layout — margins, orientation, size, columns, breaks, headers and footers, page numbers, watermarks; tables; inserting pictures, shapes, SmartArt, charts, equations, symbols, hyperlinks, text boxes, WordArt, drop cap; references — table of contents, footnotes, captions, citations; mail merge; track changes and comments; protection and macros; keyboard shortcuts — with worked examples.Read →
  6. 06MS ExcelSpreadsheet concepts — workbook, worksheet, rows, columns, cells, ranges and the Excel interface (name box, formula bar); data entry, data types, AutoFill and Flash Fill; formulas and operator precedence; cell references — relative, absolute and mixed; functions — mathematical, statistical, logical, lookup (VLOOKUP, HLOOKUP, XLOOKUP, INDEX–MATCH), text, date and time, financial; common error values; formatting — number formats, alignment, merge and wrap, conditional formatting; data tools — sort, filter, data validation, remove duplicates, text to columns; charts; pivot tables; what-if analysis (Goal Seek, Data Tables, Scenario Manager) and Solver; freeze panes, protection, printing; file formats; engineering uses (estimates, BBS, levelling, test results); keyboard shortcuts — with worked examples.Read →
  7. 07MS PowerPointPresentation software concepts and PowerPoint interface; creating presentations — templates, themes and Designer; slides — layouts, placeholders, adding, duplicating, hiding, reordering and sections; views — Normal, Outline, Slide Sorter, Notes Page, Reading View, Slide Show and Presenter View; slide masters, handout and notes masters; inserting text, pictures, shapes, icons, SmartArt, tables, charts, audio, video, screen recordings, hyperlinks and action buttons; transitions vs animations (entrance, emphasis, exit, motion paths, Animation Pane, timing); slide show setup — rehearse timings, recording, custom shows, kiosk mode; speaker notes and handouts; saving, exporting (PDF, video, .ppsx) and file formats; good presentation practices for engineering reports; keyboard shortcuts — with worked examples.Read →
  8. 08Internet, Email, Networking & Data CommunicationData communication — components, transmission modes (simplex, half-duplex, full-duplex), serial and parallel, synchronous and asynchronous transmission, bandwidth and data rate; transmission media — guided (twisted pair, coaxial, optical fibre) and unguided (radio, microwave, satellite, infrared, Bluetooth, Wi-Fi); computer networks — types (PAN, LAN, CAN, MAN, WAN), topologies (bus, star, ring, mesh, tree, hybrid), network devices (NIC, hub, switch, router, bridge, repeater, gateway, modem, access point); network models — OSI seven layers and TCP/IP; protocols and port numbers; IP addressing (IPv4, IPv6), MAC addresses, DNS; the Internet — history (ARPANET, WWW), ISPs, broadband technologies, intranet and extranet, web browsers, URLs, search engines, web technologies; email — structure, protocols, CC and BCC, etiquette; Indian digital infrastructure — with worked examples.Read →
  9. 09Cyber SecurityInformation security goals — confidentiality, integrity, availability (CIA triad), authentication, authorisation, non-repudiation; cyber threats — malware (virus, worm, Trojan, ransomware, spyware, adware, rootkit, keylogger, botnet), social engineering (phishing, spear phishing, vishing, smishing, pretexting), password attacks, denial of service, man-in-the-middle, SQL injection and cross-site scripting, identity theft, cyberstalking, digital payment frauds; security measures — antivirus, firewalls, encryption (symmetric and asymmetric), hashing, digital signatures and certificates, HTTPS/TLS, multi-factor authentication, strong passwords, updates and patches, backups (3-2-1 rule), VPN, access control; safe practices for mobiles, Wi-Fi, email and UPI; Indian cyber laws and institutions — IT Act 2000 and key sections, CERT-In, Digital Personal Data Protection Act 2023, cyber crime reporting — with worked examples.Read →
  10. 10Programming Fundamentals — Flowcharts, Algorithms & C BasicsProblem solving with computers; algorithms — definition, characteristics and representation; pseudocode; flowcharts — standard symbols, rules and examples; decision tables; programming paradigms (procedural, object-oriented, functional); program development life cycle; errors (syntax, runtime, logical) and debugging; C programming basics — history, structure of a C program, compilation process, tokens, keywords, identifiers, data types and sizes, constants and variables, operators and precedence, input/output (printf, scanf), control structures (if, if–else, switch, for, while, do–while, break, continue), arrays, strings, functions, pointers (introduction), sample programs for engineering calculations — with worked examples.Read →
  11. 11Databases, Cloud Computing & AI BasicsData and databases — file systems vs DBMS, advantages of DBMS, data models (hierarchical, network, relational, object-oriented), relational concepts (tables, tuples, attributes, domains, keys — primary, candidate, foreign, composite), integrity constraints, normalisation (1NF, 2NF, 3NF), SQL (DDL, DML, DCL, TCL commands and queries), popular DBMS; data warehousing, data mining and big data (Vs); cloud computing — characteristics, service models (IaaS, PaaS, SaaS), deployment models, virtualisation, benefits and risks, Indian government cloud initiatives; emerging technologies — artificial intelligence, machine learning (supervised, unsupervised, reinforcement), deep learning and neural networks, natural language processing, computer vision, generative AI; Internet of Things, blockchain, AR/VR, digital twins and BIM; applications in civil engineering — with worked examples.Read →
  12. 12Computer Abbreviations & TerminologyComprehensive list of frequently asked computer abbreviations grouped by category — hardware and processors, memory and storage, input/output and display, software and programming, file formats, networking and internet, communication and mobile technologies, security, data and emerging technologies, organisations and Indian digital initiatives; common computer terminology (bug, patch, cache, cookie, bookmark, plug-in, firmware, spam, bandwidth, latency, etc.); notes on commonly misunderstood expansions — with practice examples.Read →
  13. 13E-mail, Social Media, e-Governance & Digital PaymentsE-mail (addresses, fields To/Cc/Bcc, protocols, etiquette, spam and phishing), social networking platforms and safe use, e-governance (models G2C, G2B, G2G, G2E; NeGP, Digital India, DigiLocker, UMANG, e-Sign, GeM, CSC, e-NAM and farmer portals), and digital financial tools (net/mobile banking, UPI, BHIM, IMPS, NEFT, RTGS, cards, wallets, AePS, USSD, e-RUPI) with safety practices and exam-focused facts.Read →

Exams that include Computer Knowledge

Open your exam to see only the chapters its syllabus asks for.