Computer Skills Essentials

Cheatsheet Content

1. Operating System Basics (Windows/macOS/Linux) File Management: Create, Copy, Move, Delete files/folders Understand file paths (e.g., C:\Users\User\Documents , /home/user/documents ) File extensions (e.g., .txt , .docx , .pdf , .jpg , .py ) Basic Navigation: Desktop, Start Menu/Finder, Taskbar/Dock Using windows (minimize, maximize, close, resize) Keyboard shortcuts (e.g., Ctrl+C/Cmd+C for copy, Ctrl+V/Cmd+V for paste) System Settings: Network connections (Wi-Fi, Ethernet) Display settings, sound settings Installing/uninstalling applications 2. Internet & Web Browsers Browser Usage: Navigation (URLs, back/forward, refresh) Tabs and windows Bookmarks/Favorites Search engines (Google, Bing, DuckDuckGo) Basic Concepts: URL (Uniform Resource Locator) HTTP/HTTPS (Hypertext Transfer Protocol Secure) Cookies, Cache Downloading and uploading files Email: Sending, receiving, replying, forwarding Attachments Organizing emails (folders, labels) 3. Microsoft Office / LibreOffice / Google Docs Suite Word Processing (Word, Writer, Docs): Basic text formatting (bold, italic, underline, font size/type) Paragraph formatting (alignment, indentation, lists) Inserting images, tables Saving and printing documents Spreadsheets (Excel, Calc, Sheets): Cells, rows, columns, worksheets Basic formulas (SUM, AVERAGE, MAX, MIN) Cell formatting (numbers, currency, dates) Creating simple charts/graphs Presentations (PowerPoint, Impress, Slides): Creating slides, adding text and images Basic transitions and animations Presenting a slideshow 4. Data Management & Storage Local Storage: Hard drives (HDD, SSD) USB drives, external hard drives Cloud Storage: Google Drive, Dropbox, OneDrive Uploading, downloading, sharing files Synchronization Data Backup: Importance of regular backups Manual vs. automatic backups 5. Computer Security & Privacy Password Management: Strong passwords (mix of characters, length) Unique passwords for different services Password managers Malware: Viruses, spyware, ransomware Antivirus software Avoiding suspicious links/downloads Phishing: Recognizing fake emails/websites Never sharing personal information unsolicited Privacy: Understanding privacy settings on social media/websites VPN basics 6. Basic Troubleshooting Restarting: "Have you tried turning it off and on again?" Checking Connections: Cables, Wi-Fi, power Error Messages: Searching online for solutions Resource Monitoring: Task Manager (Windows), Activity Monitor (macOS) Updating Software: OS, applications, drivers 7. Introduction to Programming (Concepts) What is Programming? Giving instructions to a computer Variables: Storing data (e.g., x = 10 , name = "Alice" ) Data Types: Integers, floats, strings, booleans Control Flow: if/else statements (conditional logic) for/while loops (repetition) Functions: Reusable blocks of code 8. Digital Communication & Collaboration Video Conferencing: Zoom, Microsoft Teams, Google Meet Instant Messaging: WhatsApp, Slack, Discord Online Collaboration Tools: Shared documents, project management (Trello, Asana) Netiquette: Online etiquette and professional communication