Tin học cơ bản: Windows, Internet và Office

Fundamentals of Windows, Internet, and Microsoft Office

Welcome to this comprehensive course designed for beginners in computer science and information technology. In this module we explore essential concepts of the Windows operating system, email fundamentals, and core features of Microsoft Office applications (Word, Excel, PowerPoint). Mastering these basics will improve your productivity and lay a solid foundation for more advanced studies.

1. Managing Files in Windows

Effective file management is a cornerstone of everyday computer use. Windows provides several tools and shortcuts that help you organize, locate, and delete files safely.

• File Explorer – the primary interface for browsing drives, folders, and files. It allows you to create, rename, move, copy, and delete items with a graphical view.
• Recycle Bin – a safety net that temporarily stores deleted items, giving you a chance to restore them if needed.
• Permanent deletion – when you are certain a file should be removed forever, you can bypass the Recycle Bin.

To delete a file permanently without sending it to the Recycle Bin, press Shift + Delete. This shortcut prompts a confirmation dialog and then removes the file directly from the storage medium. Use it cautiously, as recovery becomes difficult without specialized software.

2. Understanding Email Structure

Email remains a primary communication channel in both personal and professional contexts. Every email address follows a standard format:

[email protected]

The @ symbol separates the user name from the domain name. While periods (.) appear within the domain (e.g., example.com), they do not serve as the separator. Recognizing this structure helps you create valid addresses and troubleshoot delivery issues.

3. Word Essentials: Inserting a Page Break

Microsoft Word is the go‑to word processor for creating documents, reports, and essays. One frequent formatting need is to start a new page at a specific point in the text. The shortcut Ctrl + Enter inserts a page break exactly where the cursor is positioned, moving subsequent content to the next page. This is more precise than pressing Enter repeatedly, which only adds line breaks.

4. Excel Functions for Data Analysis

Excel is a powerful spreadsheet tool used for calculations, data analysis, and visualization. Two functions frequently appear in beginner‑level tasks:

• SUMIF() – adds values that meet a specified condition. For example, =SUMIF(A2:A10, ">10", B2:B10) sums the values in column B where the corresponding cell in column A is greater than 10.
• UPPER() – converts any text string to uppercase letters. Using =UPPER("hello") returns HELLO. This is useful for standardizing data before analysis.

Other related functions include COUNTIF() (counts cells meeting a condition) and PROPER() (capitalizes the first letter of each word). Understanding the difference between counting and summing functions helps you choose the right tool for your dataset.

5. PowerPoint: Creating Dynamic Presentations

PowerPoint enables you to design engaging slide decks. Two key concepts enhance the flow of a presentation:

• Transitions – these are slide‑to‑slide effects such as Fade, Push, or Morph. Applying a transition creates a visual bridge between slides, keeping the audience’s attention.
• Animation timing – within a slide, objects can appear with effects. The option With previous makes an animation start simultaneously with the preceding animation, allowing multiple elements to move together. In contrast, After previous starts the animation only after the previous one finishes.

Choosing the right combination of transitions and animation timing can dramatically improve the professionalism of your presentation.

6. Consolidated Review and Best Practices

Below is a quick checklist to reinforce the concepts covered:

• Use Shift + Delete for permanent file removal in Windows.
• Navigate files with File Explorer, not unrelated tools like Paint.
• Remember that the @ symbol separates the user name from the domain in an email address.
• Insert a page break in Word with Ctrl + Enter for precise pagination.
• Apply SUMIF() to total values that meet criteria, and UPPER() to standardize text case in Excel.
• Enhance slide flow in PowerPoint using the Transitions tab and the With previous animation option.

By consistently applying these shortcuts and functions, you will increase efficiency, reduce errors, and produce polished documents, spreadsheets, and presentations.

7. Frequently Asked Questions (FAQ)

• Can I recover a file deleted with Shift + Delete? Recovery is possible only with specialized data‑recovery software and is not guaranteed. Always double‑check before using the shortcut.
• What happens if I omit the @ symbol in an email address? The address becomes invalid, and most mail servers will reject the message.
• Is there a way to insert a page break without a keyboard shortcut? Yes, you can go to the Insert tab in Word and choose Page Break from the dropdown menu.
• How does SUMIF differ from SUMIFS? SUMIF handles a single condition, while SUMIFS can evaluate multiple criteria simultaneously.
• Can I apply the same transition to all slides at once? Absolutely—select all slides in the slide sorter view, then choose a transition from the Transitions ribbon.

8. Further Learning Resources

To deepen your knowledge, explore the following free resources:

• Microsoft Windows Support – tutorials on file management, shortcuts, and system settings.
• Microsoft Office Help Center – detailed guides for Word, Excel, and PowerPoint.
• GCFGlobal – beginner-friendly courses on computer basics and Office applications.

Regular practice combined with these resources will solidify your understanding and prepare you for more advanced topics such as macro programming, data visualization, and collaborative cloud workflows.