Tin học cơ bản: Kiến thức và ứng dụng

Introduction to Basic Computer Science

Welcome to this comprehensive course on fundamental computer concepts. Whether you are a beginner or need a refresher, this guide covers essential topics such as viruses, hardware upgrades, memory types, operating systems, keyboard shortcuts, and common office‑suite tools. By the end of the lesson you will understand the underlying principles that power everyday computing tasks.

Understanding Macro Viruses

Macro viruses are a specific class of malware that exploit the macro feature found in many office applications. Unlike traditional viruses that spread through executable files, macro viruses embed malicious code inside documents that support programmable macros.

How Macro Viruses Propagate

The primary infection vector is the Word and Excel file. When a user opens a document containing a macro, the embedded script runs automatically (if macro execution is enabled), allowing the virus to replicate itself into other documents on the same system or network.

• They do not spread through boot sectors or system memory directly.
• USB drives can carry infected documents, but the virus itself still relies on the file type, not the storage medium.
• Disabling macros or using protected view in Office applications dramatically reduces the risk.

For more details, see the explanation below:

Explanation: Macro virus typically spreads via Word and Excel files. The malicious macro is executed when the document is opened, not through the memory or USB itself.

Impact of Upgrading the Processor

The central processing unit (CPU) is the brain of the computer. Replacing a slower CPU with a faster one directly influences the system’s performance.

What Changes When You Install a Faster CPU?

A higher‑speed processor executes instructions more quickly, resulting in a noticeable increase in overall system responsiveness. Tasks such as launching applications, rendering graphics, and running calculations become smoother.

• Speed improvement: The computer runs faster.
• Memory capacity (RAM, hard‑drive, ROM) remains unchanged unless you upgrade those components separately.
• Performance gains are most evident in CPU‑intensive workloads like video editing, gaming, and data analysis.

Explanation: Replacing the processor with a higher‑speed model can make the computer run faster, but it does not automatically increase RAM size, hard‑drive capacity, or ROM size.

Primary vs. Secondary Memory

Memory in a computer is categorized based on its role and accessibility. Two core types are RAM (Random Access Memory) and ROM (Read‑Only Memory).

Why RAM and ROM Are Considered Primary Memory

Both RAM and ROM reside on the motherboard and are directly accessed by the CPU during operation. They differ in function—RAM is volatile and stores temporary data, while ROM holds permanent firmware—but they share the characteristic of being primary memory.

• Primary memory is fast, directly addressable, and essential for running the operating system.
• Secondary memory (hard drives, SSDs, optical discs) provides long‑term storage but is slower to access.

Explanation: RAM and ROM are both part of the primary memory hierarchy, accessed directly by the processor while the computer is running.

Operating System: The Bridge Between Users and Hardware

The operating system (OS) is the foundational software layer that manages hardware resources and provides services to application programs.

Key Functions of an OS

• Process scheduling and multitasking.
• Memory management, including allocation of RAM to running programs.
• File system organization and security.
• Device driver coordination, enabling peripherals to communicate with the CPU.

Unlike application software, which performs specific tasks (e.g., word processing, spreadsheet calculations), the OS creates a user-friendly environment that abstracts hardware complexity.

Explanation: The operating system acts as an intermediary, allowing users to interact with the computer and manage its resources.

Keyboard Shortcuts for Efficient File Management

Windows provides several shortcuts to streamline file operations. Understanding these shortcuts can save time and reduce the risk of accidental data loss.

Deleting Files Without Using the Recycle Bin

Pressing Shift + Delete removes a selected file permanently, bypassing the Recycle Bin. This action is irreversible through standard Windows recovery methods, so it should be used with caution.

• Standard Delete moves the file to the Recycle Bin, allowing restoration.
• Other combinations like Ctrl + Delete or Alt + Delete have no default function for file deletion.

Explanation: Using Shift + Delete permanently deletes a file without sending it to the Recycle Bin.

Microsoft Word: Using the Format Painter

The Format Painter is a handy tool that copies formatting attributes from one piece of text or object and applies them to another.

When to Use the Format Painter

• Consistent font style, size, color, and paragraph settings across a document.
• Quickly replicating heading styles without manually adjusting each attribute.
• Transferring table or shape formatting to other elements.

To activate, select the source text, click the Format Painter icon, then click the target area. Double‑clicking the icon locks the tool for multiple applications.

Explanation: The Format Painter copies formatting, not content, allowing you to replicate styles efficiently.

Excel Cell References: Mixed Addresses

Excel formulas use cell references that can be absolute, relative, or mixed. Understanding these references is crucial for accurate calculations when copying formulas.

What Is a Mixed Cell Reference?

A mixed reference locks either the column or the row, but not both. For example:

• $A1 – column A is absolute (fixed), row 1 is relative.
• B$5 – row 5 is absolute, column B is relative.

When you drag the formula across cells, only the unfixed part changes, preserving the intended reference.

Explanation: Addresses like $A1 or B$5 are mixed references, fixing either the column or the row.

PowerPoint Animation: Exit Effects

PowerPoint offers three categories of animation: Entrance, Emphasis, and Exit. Exit effects control what happens to an object when it leaves the slide during a presentation.

How the Exit Effect Works

When an Exit animation is applied, the selected object disappears from view at the designated time. This is useful for:

• Removing outdated information without changing the slide layout.
• Creating a clean transition to the next point.
• Enhancing visual storytelling by fading or flying objects out.

Unlike Entrance effects, which make an object appear, Exit effects make the object vanish from the slide.

Explanation: The Exit effect causes the object to disappear during the slide show.

Conclusion and Further Learning

This course has covered a range of basic computer science topics that are essential for everyday digital tasks. Mastery of these concepts not only improves productivity but also enhances your ability to troubleshoot common issues.

Next Steps

• Practice creating and applying macros safely in Office applications.
• Experiment with CPU upgrades on a test machine to observe performance changes.
• Explore deeper memory management topics such as virtual memory and caching.
• Learn advanced keyboard shortcuts and automation scripts for Windows.
• Design complex Excel models using mixed and absolute references.
• Develop engaging PowerPoint presentations with a combination of Entrance, Emphasis, and Exit animations.

By reinforcing these fundamentals, you build a solid foundation for more advanced studies in computer science, information technology, and digital productivity.