Class 4: Condensed Notes
कक्षा 4: संक्षिप्त नोट् स
Operating System, VLOOKUP & Mail Merge | Operating System, VLOOKUP और Mail Merge
1. Mail Merge | मेल मर्ज
• Mail Merge auto-personalizes one Word letter for many people using an Excel data source (e.g. 100 certificates,
each with a different name/roll no).
Mail Merge Excel data source का उपयोग करके एक Word letter को कई लोगों के लिए automatic personalize करता है (जैसे
100 certificates, हर एक में अलग नाम/roll no)।
• Steps: make Excel data sheet → Word: Mailings → Start Mail Merge → Select Recipients → Insert Merge
Field → Preview Results → Finish & Merge.
Steps: Excel data sheet बनाएं → Word: Mailings → Start Mail Merge → Select Recipients → Insert Merge Field →
Preview Results → Finish & Merge।
2. VLOOKUP | वीलुकअप
• VLOOKUP finds a value and returns matching data from the same row. Syntax: =VLOOKUP(lookup_value,
table_array, col_index_num, [range_lookup]); FALSE = exact match.
VLOOKUP एक value ढूंढकर उसी row का data return करता है। Syntax: =VLOOKUP(lookup_value, table_array,
col_index_num, [range_lookup]); FALSE = exact match।
• VLOOKUP + Mail Merge together: VLOOKUP calculates grades in Excel, Mail Merge prints them into
hundreds of certificates automatically.
VLOOKUP + Mail Merge साथ में: VLOOKUP Excel में grades calculate करता है, Mail Merge उन्हें automatically
सैकड़ों certificates में print करता है।
3. Operating System | ऑपरेटिंग सिस्टम
• OS = software managing hardware and providing services to programs (process, memory, file, device
management). Kernel = core that talks directly to hardware.
OS = hardware manage करने वाला software जो programs को services देता है (process, memory, file, device
management)। Kernel = hardware से सीधे बात करने वाला core।
• Single-user OS (Windows, macOS — home PCs) vs. Multi-user/Network OS (Linux/Unix, Windows Server —
offices, banks, servers).
Single-user OS (Windows, macOS — home PCs) बनाम Multi-user/Network OS (Linux/Unix, Windows Server —
offices, banks, servers)।
4. Windows Desktop & Files | विंडोज डेस्कटॉप और फाइलें
• Desktop, Taskbar (Start button, system tray), Start Menu, File Explorer (Win+E) are the core Windows
components.
Desktop, Taskbar (Start button, system tray), Start Menu, File Explorer (Win+E) विंडोज के मुख्य components हैं।
• NTFS = default Windows file system (large files, permissions); FAT32/exFAT = used for USB drives, cross-
platform.
NTFS = default विंडोज file system (large files, permissions); FAT32/exFAT = USB drives, cross-platform के लिए
उपयोग होता है।
• File operations: Copy/Cut/Paste (Ctrl+C/X/V), Rename (F2), Delete → Recycle Bin, Compress → ZIP,
Properties → size/date.
File operations: Copy/Cut/Paste (Ctrl+C/X/V), Rename (F2), Delete → Recycle Bin, Compress → ZIP, Properties
→ size/date।
5. Control Panel & Task Manager | कं ट्रोल पैनल और टास्क मैनेजर
• Control Panel/Settings (Win+I) configure display, sound, user accounts, devices, and Windows Update.
Control Panel/Settings (Win+I) display, sound, user accounts, devices, और Windows Update configure करते हैं।
• Task Manager (Ctrl+Shift+Esc): view/end running processes, monitor CPU/RAM/Disk usage, manage startup
programs.
Task Manager (Ctrl+Shift+Esc): running processes देखें/बंद करें, CPU/RAM/Disk usage monitor करें, startup
programs manage करें।
6. Keyboard Shortcuts | कीबोर्ड शॉर्ट कट
• General: Ctrl+C/V (copy/paste), Ctrl+Z/Y (undo/redo), Ctrl+S (save), F2 (rename), F5 (refresh).
General: Ctrl+C/V (copy/paste), Ctrl+Z/Y (undo/redo), Ctrl+S (save), F2 (rename), F5 (refresh)।
• Windows: Win+D (desktop), Win+E (Explorer), Win+L (lock), Win+R (run), Alt+Tab (switch), Alt+F4 (close).
Windows: Win+D (desktop), Win+E (Explorer), Win+L (lock), Win+R (run), Alt+Tab (switch), Alt+F4 (close)।
7. Security, Networking & Backup | सुरक्षा, नेटवर्किं ग और बैकअप
• Windows Defender (antivirus), Firewall, Windows Update, UAC, BitLocker (encryption), and strong passwords
are core security basics.
Windows Defender (antivirus), Firewall, Windows Update, UAC, BitLocker (encryption), और strong passwords
मुख्य security basics हैं।
• Networking: connect via Wi-Fi/Ethernet; check IP with ipconfig; use VPN on public Wi-Fi. Backup:
OneDrive/external HDD; follow the 3-2-1 backup rule (3 copies, 2 media, 1 offsite).
Networking: Wi-Fi/Ethernet से connect करें; ipconfig से IP check करें; public Wi-Fi पर VPN उपयोग करें। Backup:
OneDrive/external HDD; 3-2-1 backup rule अपनाएं (3 copies, 2 media, 1 offsite)।
8. Command Prompt & Peripherals | कमांड प्रॉम्प्ट और पेरिफे रल
• CMD basics: dir (list files), cd (change directory), mkdir (create folder), del (delete), ipconfig, ping.
CMD basics: dir (files list), cd (directory बदलें), mkdir (folder बनाएं), del (delete करें), ipconfig, ping।
• Peripherals connect via USB/Bluetooth; printing via Ctrl+P (or 'Microsoft Print to PDF' to save as PDF).
Peripherals USB/Bluetooth से जुड़ ते हैं; printing के लिए Ctrl+P (या PDF में save करने के लिए 'Microsoft Print to
PDF')।
9. Key Takeaways | मुख्य बातें
• OS manages hardware (Windows, Linux, macOS); NTFS is Windows' default file system, FAT32 for USB
drives.
OS hardware manage करता है (Windows, Linux, macOS); NTFS विंडोज का default file system है, FAT32 USB drives
के लिए।
• Key shortcuts: Ctrl+C/V, Win+E, Ctrl+Shift+Esc. Security essentials: Defender + Firewall + Updates.
मुख्य shortcuts: Ctrl+C/V, Win+E, Ctrl+Shift+Esc। Security essentials: Defender + Firewall + Updates।
Class 4 Diary Entry
कक्षा 4 डायरी प्रविष्टि
आज की कक्षा का विषय
Today's Class Topic
Operating System, VLOOKUP & Mail Merge (Class 4, UGC Internship Programme).
Operating System, VLOOKUP और Mail Merge (कक्षा 4, UGC Internship Programme)।
आज कक्षा में क्या पढ़ा (मुख्य बिंदु)
Key Topics Covered Today
Mail Merge and VLOOKUP (with their step-by-step processes); what an Operating System is and its types; Windows
desktop, file system (NTFS/FAT32), and file operations; Control Panel, Task Manager, and keyboard shortcuts; and
Windows security, networking, backup, and Command Prompt basics.
Mail Merge और VLOOKUP (उनकी step-by-step process के साथ); Operating System क्या है और इसके प्रकार; Windows desktop,
file system (NTFS/FAT32), और file operations; Control Panel, Task Manager, और keyboard shortcuts; और Windows
security, networking, backup, और Command Prompt की बुनियादी बातें।
मुझे सबसे उपयोगी क्या लगा
What I Found Most Useful
Learning how VLOOKUP and Mail Merge work together to auto-generate hundreds of certificates — a practical skill
for real exam/office work, along with essential keyboard shortcuts that save time daily.
यह सीखना कि VLOOKUP और Mail Merge मिलकर सैकड़ों certificates automatically कै से बनाते हैं — असली exam/office काम के
लिए एक practical skill, साथ ही रोज़ काम आने वाले keyboard shortcuts।