🛠️ IT Workshop (100113)¶
⬅️ Back to Semester-1 | 🏠 Home
💡 Why this subject? Pure hands-on skills — assembling a PC, using Linux, and mastering MS Office/LaTeX are skills you'll use your entire career, not just for exams.
📌 Unit 1: PC Hardware¶
- Peripherals: keyboard, mouse, monitor, printer (input/output devices).
- CPU components: ALU (does math/logic), Control Unit (directs operations), Registers (tiny fast storage).
- Motherboard: the "circuit highway" connecting CPU, RAM, storage, and peripherals.
- Assembling a PC: CPU → motherboard socket → RAM into slots → PSU → storage → cables → peripherals.
- OS Installation: boot from USB/DVD → partition disk → install files → set up drivers.
- Basic Linux commands:
| Command | Use |
|---|---|
ls |
list files |
cd |
change directory |
pwd |
show current path |
mkdir |
create folder |
rm |
delete file |
cp / mv |
copy / move |
cat |
view file content |
sudo |
run as admin |
📌 Unit 2: Internet¶
- Web Browser: software to access websites (Chrome, Firefox, Edge).
- Search Engines: Google, Bing — index the web so you can search by keyword.
- Browser customization: bookmarks, proxy settings, pop-up blockers, search toolbars.
- Antivirus & Cyber Hygiene: protect against malware, phishing, viruses — never click unknown links! 🛡️
📌 Unit 3 & 4: MS Word + LaTeX¶
- MS Word features: Hyperlinks, Spell Check, Track Changes, Table of Contents, Mail Merge, WordArt.
- LaTeX: a typesetting system (not WYSIWYG like Word) — you write code-like markup and it compiles to a beautifully formatted PDF. Preferred for research papers/theses because of perfect math formatting.
📝 Example — Simple LaTeX document:
\documentclass{article}
\begin{document}
\title{My First Document}
\author{Pratap}
\maketitle
Hello, this is \textbf{bold} and this is $E = mc^2$.
\end{document}
🧠 Quick Recall: Use Word for quick formatted docs (resume, certificate); use LaTeX when you need precise math symbols or a long structured document (thesis, research paper).
📌 Unit 5: MS Excel¶
- Formulas & Functions:
=SUM(),=AVERAGE(),=IF(),=VLOOKUP() - Conditional Formatting: auto-highlight cells based on rules (e.g., red if marks < 40).
- Charts: visualize data (bar, pie, line).
- Cell Referencing:
A1(relative — changes when copied) vs$A$1(absolute — stays fixed).
📝 Example — Calculating GPA:
=AVERAGE(B2:B6) → average of marks in B2 to B6
=IF(C2>=40,"Pass","Fail") → conditional pass/fail check
📌 Unit 6: MS PowerPoint¶
- Slide Layouts, Transitions, Custom Animations: control how content appears and moves between slides.
- Hyperlinks in slides: jump to another slide, file, or website on click.
- Master Slide: a template that controls the look of all slides at once (logo, fonts, colors).
🔬 Lab Highlights¶
- Disassemble & reassemble a PC, install Windows + Linux (dual boot)
- Configure browser, practice safe browsing & cyber hygiene
- Create certificate/abstract/newsletter in Word & LaTeX
- Build a scheduler & GPA calculator in Excel
- Build an interactive presentation in PowerPoint
✅ Quick Revision Table¶
| Topic | One-line memory hook |
|---|---|
| Motherboard | The highway connecting all PC parts |
sudo |
"Run this as admin" in Linux |
| LaTeX | Code → compiled into perfectly formatted PDF |
$A$1 |
Absolute reference — never changes when copied |
| Master Slide | One template controls all slides |