Tin học đại cương: Internet, Windows và ứng dụng văn phòng

Fundamentals of General Computing: Internet, Windows, and Office Applications

Welcome to this comprehensive course designed for beginners in information technology. In this module we explore the core concepts that underpin everyday computing: internet protocols, email structure, file transfer, basic security, Windows shortcuts, and essential Microsoft Office functions. Each section is written with clear explanations, practical examples, and SEO‑friendly keywords to help you master the material and rank well in search results.

1. Internet Protocols – The Backbone of Online Communication

The internet relies on a layered set of protocols that enable devices to exchange data reliably. The most important suite is TCP/IP (Transmission Control Protocol/Internet Protocol). TCP/IP provides the fundamental addressing and routing mechanisms that allow any computer, smartphone, or IoT device to communicate across the global network.

• TCP ensures reliable, ordered delivery of data packets.
• IP handles addressing, directing each packet to its destination.

Higher‑level protocols such as HTTP (Hypertext Transfer Protocol) and FTP (File Transfer Protocol) operate on top of TCP/IP. They cannot function without the underlying TCP/IP suite, which is why the correct answer to the quiz question "Which protocol is primarily used for communication on the Internet?" is TCP/IP.

Key SEO terms: TCP/IP protocol suite, Internet communication basics, how the internet works.

2. Understanding Email Addresses – The Role of the @ Symbol

An email address follows the format [email protected]. The @ character separates the local part (the mailbox name) from the domain part (the mail server). For example, in [email protected], student is the mailbox name and university.edu is the domain.

Other characters such as &, #, or $ are not used for this purpose and would render the address invalid. Recognizing the @ symbol is essential for correctly entering email contacts, configuring mail clients, and troubleshooting delivery issues.

SEO‑focused keywords: email address format, what does @ mean in email, email syntax rules.

3. File Transfer Basics – Upload vs. Download

When you move a file from your computer to another device over a network, the operation is called a upload. Conversely, receiving a file from another device is a download. Uploading is commonly performed via web interfaces, cloud storage services (e.g., Google Drive, OneDrive), or FTP clients.

Understanding the distinction is crucial for tasks such as sharing documents, publishing website content, or backing up data to a remote server. The quiz question "What is the action called when you transfer a file from your computer to another computer over the network?" correctly identifies Upload as the answer.

SEO terms: how to upload files, difference between upload and download, file transfer methods.

4. Basic Virus Containment – Isolating an Infected Machine

When a computer shows signs of malware infection, the most effective immediate step to prevent spread is to disconnect it from the local network. By cutting the network connection, you stop the virus from communicating with other devices, sharing files, or propagating through shared resources.

Additional best practices include:

• Running a reputable anti‑virus scan as soon as possible.
• Avoiding the opening of suspicious links or attachments.
• Keeping the operating system and applications up to date.

These measures reduce the risk of lateral movement within a corporate LAN or home network. The quiz correctly highlights Disconnecting from the local network as the proper response.

SEO‑friendly phrases: how to isolate a virus‑infected PC, prevent malware spread, network isolation for infected computers.

5. Essential Windows Keyboard Shortcuts

Keyboard shortcuts boost productivity by allowing you to perform common actions without navigating menus. In Windows, the shortcut for copying the selected item to the Clipboard is Ctrl + C. This command stores the data temporarily, enabling you to paste it elsewhere with Ctrl + V.

Other useful shortcuts include:

• Ctrl + X – Cut (removes the item and places it on the Clipboard).
• Ctrl + Z – Undo the last action.
• Alt + Tab – Switch between open applications.

Mastering these shortcuts is a foundational skill for any Windows user and is directly tested in the quiz question about copying to the Clipboard.

SEO keywords: Windows copy shortcut, Ctrl + C function, keyboard shortcuts for Windows.

6. Microsoft Word – Inserting a Page Break

In Word, a page break forces the following content to start on a new page, regardless of the current layout. The shortcut Ctrl + Enter inserts a mandatory page break instantly. This is different from Shift + Enter, which creates a line break without starting a new paragraph.

Using page breaks is essential for formatting reports, dissertations, and any document that requires precise pagination. The quiz correctly identifies Ctrl + Enter as the shortcut for inserting a page break.

SEO‑oriented terms: Word page break shortcut, how to insert a page break in Microsoft Word, Ctrl + Enter function.

7. Excel Functions – Counting Non‑Empty Cells with COUNTA

The COUNTA function counts the number of cells in a range that are not empty, including both numbers and text. For example, =COUNTA(A1:A10) returns the total of cells that contain any data.

It differs from COUNT, which only counts cells containing numeric values. Understanding this distinction helps you create accurate summaries and dashboards.

SEO phrases: Excel COUNTA function, how to count non‑blank cells in Excel, difference between COUNTA and COUNT.

8. Excel Functions – Getting the Current Date with TODAY()

The TODAY() function returns the current system date without the time component. It updates automatically each day, making it ideal for timestamps, due‑date calculations, and dynamic reports. In contrast, NOW() returns both date and time.

Example usage: =TODAY() might display 2026‑11‑03 on the day you view the worksheet. Pairing TODAY() with other date functions (e.g., EDATE, NETWORKDAYS) enables powerful scheduling tools.

SEO‑focused keywords: Excel TODAY function, how to display current date in Excel, date functions in Microsoft Excel.

9. Recap and Practical Application

By mastering the concepts covered in this course, you will be able to:

• Explain why TCP/IP is the core protocol suite for internet communication.
• Identify the @ symbol as the separator in email addresses.
• Differentiate between uploading and downloading files.
• Implement immediate network isolation to contain a virus outbreak.
• Use essential Windows shortcuts such as Ctrl + C for copying.
• Insert page breaks in Word with Ctrl + Enter.
• Apply COUNTA to count non‑empty cells and TODAY() to retrieve the current date in Excel.

These skills form the foundation of everyday computing tasks in both personal and professional environments. Practice each technique, experiment with the shortcuts, and incorporate the functions into real‑world spreadsheets to reinforce learning.

10. Further Learning Resources

To deepen your knowledge, explore the following resources:

• Understanding TCP/IP – Cloudflare Learning
• Microsoft Windows Keyboard Shortcuts
• Insert Page Breaks in Word
• COUNTA Function Overview
• TODAY Function in Excel

These links provide deeper technical details, step‑by‑step tutorials, and additional practice exercises.