Kiến thức cơ bản Tin học và Hệ điều hành

Fundamental Computer Science and Operating System Concepts

Welcome to this comprehensive course that covers essential topics in computer science and operating systems, with a focus on Windows navigation, binary arithmetic, data measurement units, and Microsoft Excel basics. Whether you are a beginner preparing for an exam or a professional refreshing core knowledge, this guide provides clear explanations, practical examples, and SEO‑friendly keywords to help you master the material.

Creating a New Folder in Windows

One of the most common tasks in a Windows environment is creating a new folder to organize files. The standard method uses the context menu:

• Step 1: Right‑click on the desktop or inside any directory.
• Step 2: Choose New → Folder from the popup menu.
• Step 3: Type the desired folder name and press Enter.

This approach is preferred over keyboard shortcuts like Ctrl+N (which opens a new window) or F2 (which renames an existing item). Mastering the right‑click method improves workflow efficiency and aligns with Windows best practices.

Selecting Consecutive Items in Windows Explorer

When you need to select a series of files or folders, the Shift key is essential. Holding Shift while clicking the first and last items creates a continuous selection range. This technique is faster than using Ctrl, which selects non‑adjacent items one by one. Remember:

• Shift + Click: Selects all items between the first and last click.
• Ctrl + Click: Adds or removes individual items from the selection.

File System Management in Windows

The Windows operating system relies on a dedicated component called the File System Manager. This subsystem handles:

• Reading and writing data to storage devices.
• Organizing files into directories and sub‑directories.
• Enforcing security permissions and access control lists (ACLs).
• Maintaining metadata such as timestamps and file attributes.

Understanding the role of the file system manager is crucial for troubleshooting storage issues, optimizing performance, and ensuring data integrity.

Binary Numbers and Decimal Conversion

Binary (base‑2) notation is the foundation of digital computing. Each digit (bit) represents a power of two, starting from the rightmost position (2⁰). To convert the binary number 101₂ to decimal:

• Identify the positions: 1·2² + 0·2¹ + 1·2⁰.
• Calculate: 1·4 + 0·2 + 1·1 = 4 + 0 + 1 = 5.
• Since the original question mistakenly added an extra value, the correct decimal result is 5. (If the intended binary string were 111₂, the decimal would be 7.)

Practice converting binary numbers regularly to strengthen your number‑system fluency.

Data Measurement Units: From Kilobytes to Megabytes

In computing, data size is measured using a hierarchy of units. The most common progression is:

• 1 KB = 1,024 bytes
• 1 MB = 1,024 KB
• 1 GB = 1,024 MB
• 1 TB = 1,024 GB

Therefore, the unit larger than 1 KB is 1 MB. Remember the mnemonic “Megabyte > Kilobyte, each MB has 1024 KB” to avoid confusion with decimal (SI) prefixes.

Excel Basics: Calculating Averages

Microsoft Excel provides the =AVERAGE() function to compute the arithmetic mean of a range of cells. The correct syntax uses a colon (:) to define a continuous range:

• =AVERAGE(H5:H7) – calculates the average of cells H5, H6, and H7.
• Incorrect variations such as =AVERAGE(H5;H7) or =AVERAGE(H5):(H7) will produce errors or unintended results.

Tip: Use the AutoSum dropdown to quickly insert the AVERAGE function for any selected range.

Excel Shortcut: Using F4 for Absolute References

When copying formulas, you often need to lock a cell reference so it does not change. Pressing F4 toggles the reference between relative (A1), absolute ($A$1), and mixed forms ($A1 or A$1). This shortcut is essential for:

• Creating stable lookup tables.
• Ensuring constants remain unchanged during drag‑fill operations.

Remember the phrase “F4 adds the dollar signs” to recall its purpose.

Printing Specific Pages in Excel Charts

When preparing a printed report, you may need to print only a subset of pages. In the Excel print dialog, locate the Pages … To … option. Enter the starting page number and the ending page number (e.g., 3 to 7) to limit the output. This setting is more precise than adjusting the number of copies or selecting the collated option.

Key Takeaways

• Use Right‑click → New → Folder to create directories in Windows.
• Hold Shift for consecutive selections in Explorer.
• The File System Manager is the Windows component responsible for handling files.
• Binary conversion relies on powers of two; practice with various bit lengths.
• 1 MB is the next unit after 1 KB in the binary data hierarchy.
• Excel’s =AVERAGE(H5:H7) correctly computes averages over a range.
• Press F4 to toggle absolute references in Excel formulas.
• Use the Pages … To … field to print selected pages of a chart.

By mastering these fundamental concepts, you will improve your efficiency in both Windows operating environments and Microsoft Excel, laying a solid foundation for more advanced computer science studies.