Basic Information Technology Skills

Understanding Basic Information Technology Skills

In today’s digital world, mastering fundamental IT skills is essential for both personal productivity and professional success. This course breaks down the core concepts behind common computer operations, software functions, and security awareness. By the end of the module, you’ll be able to explain how hardware upgrades affect performance, where operating systems reside, and how to use key shortcuts in Windows, Word, Excel, and PowerPoint. Let’s explore each topic in depth.

1. Macro Viruses and File Types

Macro viruses are a specific class of malware that target document files capable of storing executable scripts. The most common carriers are Microsoft Word and Excel files. These programs support macros—small programs written in VBA (Visual Basic for Applications) that automate repetitive tasks. While macros can be useful, they also provide a hidden pathway for malicious code.

• Why Word and Excel? Both applications allow users to embed macros directly within the document, enabling the virus to execute whenever the file is opened.
• Prevention tips: Disable macros by default, use reputable antivirus software, and avoid opening attachments from unknown sources.

Understanding the relationship between macro viruses and document files helps you protect your system from one of the most common infection vectors.

2. Impact of Upgrading the Processor

The processor, or CPU, is the brain of the computer. Replacing a slower CPU with a faster one directly influences the system’s ability to execute instructions.

• Performance boost: A faster processor can handle more calculations per second, meaning tasks such as rendering videos, running simulations, or loading web pages complete more quickly.
• What doesn’t change: Upgrading the CPU does not automatically increase ROM (Read‑Only Memory) or RAM (Random‑Access Memory) capacity, nor does it expand hard‑drive storage. Those components must be upgraded separately if needed.

When evaluating a hardware upgrade, consider the balance between CPU speed, memory size, and storage capacity to avoid bottlenecks.

3. Where Operating Systems Reside

Operating systems (OS) need to be available whenever the computer powers on. This is achieved by storing the OS on secondary storage, typically a hard disk drive (HDD) or solid‑state drive (SSD).

• Secondary storage vs. primary storage: Primary storage (RAM) is volatile—it loses data when power is cut. Secondary storage retains data without power, ensuring the OS boots every time.
• Boot process: During startup, the BIOS/UEFI firmware reads the boot loader from secondary storage and loads the OS into RAM for execution.

Understanding this distinction clarifies why you can install software, save files, and retain settings even after shutting down your computer.

4. Deleting Files with Shift+Delete

Windows provides multiple ways to remove unwanted files. Using Shift+Delete bypasses the Recycle Bin, permanently erasing the selected file from the file system.

• Immediate removal: The file does not appear in the Recycle Bin, reducing the chance of accidental recovery.
• Data recovery: Although the file’s directory entry is removed, the actual data may still reside on the disk until overwritten. Specialized recovery tools can sometimes retrieve such files.
• Best practice: Use Shift+Delete for confidential or large files you intend to discard permanently, but ensure you truly no longer need the data.

5. Keyboard Shortcut: Ctrl+Z

Keyboard shortcuts streamline workflow by reducing reliance on mouse clicks. In most document editors, Ctrl+Z performs the Undo action, reversing the most recent change.

• Undo chain: Pressing Ctrl+Z repeatedly steps back through a series of edits, allowing you to revert to an earlier state.
• Redo: The counterpart shortcut, Ctrl+Y (or Ctrl+Shift+Z), re‑applies the undone action.
• Why it matters: Quick undo capabilities boost productivity and reduce anxiety about making mistakes.

6. Excel’s MOD Function

Excel offers a wide range of mathematical functions. The MOD function returns the remainder after division of one number by another. For example, MOD(20,3) calculates the remainder of 20 divided by 3.

• 20 ÷ 3 = 6 with a remainder of 2.
• Therefore, MOD(20,3) returns 2.

Understanding MOD is useful for tasks such as scheduling (e.g., determining days of the week), creating cyclic patterns, or validating data entry.

7. PowerPoint Entrance Effects

Presentation software like PowerPoint includes animation features to enhance visual storytelling. An Entrance effect makes an object appear on a slide at a chosen moment.

• Purpose: To draw the audience’s attention to a specific element, such as a chart or bullet point, as you discuss it.
• Common entrance styles: Fade In, Fly In, Zoom, and Appear.
• Best practice: Use entrance effects sparingly to maintain professionalism and avoid distracting viewers.

8. Email as an Electronic Messaging Service

Among the listed options, email is the dedicated service for sending and receiving electronic messages. Email operates over the Internet using protocols such as SMTP (Simple Mail Transfer Protocol) for sending and IMAP/POP3 for receiving.

• Key components: Mail server, client application (e.g., Outlook, Gmail), and address format ([email protected]).
• Security considerations: Use strong passwords, enable two‑factor authentication, and be cautious of phishing attempts.

Mastering email etiquette—clear subject lines, concise content, and proper signatures—enhances professional communication.

Putting It All Together: Practical Exercises

To reinforce the concepts covered, try the following hands‑on activities:

• Macro safety test: Open a Word document with macros disabled. Locate the macro settings and enable them only for trusted files.
• CPU upgrade simulation: Use a benchmarking tool (e.g., CPU-Z) to compare scores before and after adjusting the processor speed in the BIOS (if your hardware permits).
• OS location check: Open your system’s “Disk Management” utility to identify the partition where the OS resides.
• Shift+Delete practice: Create a dummy file, then permanently delete it using Shift+Delete. Attempt recovery with a free tool like Recuva to see the limits of data retrieval.
• Undo/Redo drill: In a text editor, type a paragraph, then use Ctrl+Z repeatedly to undo each line, followed by Ctrl+Y to redo them.
• Excel MOD worksheet: Build a small table that lists numbers 1‑30 and uses MOD to highlight every 5th entry.
• PowerPoint animation: Create a slide with three bullet points. Apply an entrance effect to each point, timed to appear one after another.
• Email etiquette review: Draft a professional email, focusing on a clear subject, greeting, concise body, and proper closing.

Key Takeaways

By mastering these basic IT skills, you lay a solid foundation for more advanced topics such as network security, data analysis, and software development. Remember:

• Macro viruses target Word and Excel files—keep macros disabled unless needed.
• A faster processor speeds up computation but does not increase memory or storage.
• Operating systems live on secondary storage, ensuring persistence across power cycles.
• Shift+Delete permanently removes files, bypassing the Recycle Bin.
• Ctrl+Z is the universal undo shortcut, essential for efficient editing.
• MOD(20,3) returns 2, illustrating how remainder calculations work in Excel.
• Entrance effects in PowerPoint make objects appear, enhancing presentations.
• Email remains the primary service for electronic messaging.

Continue practicing these concepts, and you’ll become more confident navigating the digital landscape.