Grade 6 Information and Communication Technology Review

Web Conferencing Technology and Applications

At the height of the COVID-19 pandemic, numerous businesses shut down while others shifted to virtual interactions through online meetings and conferences. Educational institutions adapted by changing learning modalities, with teachers and students utilizing personal computers, laptops, tablets, and smartphones to conduct online classes. Web conferencing is defined as the combination of these devices, applications, or platforms that allow individuals to communicate with one another.

Web conferencing refers to the technology that makes online meetings, webinars, and information-sharing possible using different online platforms and tools. These systems enable real-time exchange of multimedia content, including audio, video, and chat messages.

A web conferencing tool is a software or application that enables remote communication and online collaboration using audio and video conferencing, instant messaging, and desktop/screen sharing. It provides participants with the experience of being present in an actual meeting room or virtual classroom while using their own devices from any location.

Widely-Used Web Conferencing Applications

• Zoom: Zoom is one of the most widely used web conferencing applications. By default, all Zoom plans can admit up to $100$ participants in a single online meeting. Key features include a user-friendly interface, large meeting capacity, strong security controls, and customizable virtual backgrounds.

• Google Meet: Developed by Google, Google Meet allows users to communicate remotely via audio and video. It enables setting up or scheduling meetings, sending invitations, and delivering high-quality video conferencing. It is accessible on Android and iOS mobile devices or directly through web browsers, integrating seamlessly with Google Workspace.

• Microsoft Teams: Developed by Microsoft Corporation, Microsoft Teams is a cloud-based web conferencing application and collaboration platform. It allows organizations to communicate online via chat, audio, and video, while enabling participants to work together on tasks or projects through document-sharing features.

• GoTo Meeting: GoTo Meeting is designed for virtual meetings, webinars, and real-time collaboration over the Internet. It features an easy-to-use interface that enables even novice users to create meeting sessions effortlessly, making it popular in corporate and business settings.

Common Features of Web Conferencing Applications

• Audio and Video Calls: Allows users to call and see each other in real time. Audio calls use the device microphone, while video calls utilize both the camera and microphone. Users can toggle camera and microphone controls on or off.

• Screen Sharing: Enables speakers or presenters to display their actual screen to show documents, slideshows, or demonstrate software actions visually to retain participant interest.

• Chat Function: Allows participants to send and receive text messages through direct messaging (private) or public chat visible to everyone in the session.

• Mute and Unmute Button: Allows hosts and attendees to manage audio. Muting prevents background noises from transmitting to other participants, while unmuting permits speaking.

• Virtual Whiteboard: A digital collaboration tool similar to a physical blackboard, allowing real-time writing, drawing, and visual illustration of ideas.

• File Sharing: Permits participants to view, edit, share, and view different types of documents or presentations remotely and simultaneously during an online meeting.

• Recording: Captures the complete audio and video session of a meeting, providing reference material for reviewing transpired discussions.

• Reactions: Interactive tools such as "raise hand" (to request clarification or ask questions) and non-verbal reaction icons (thumbs up, clapping hands, hearts) to express feedback or emotion.

• Breakout Rooms: Divides participants into smaller virtual rooms for focused group work and discussions on specific topics. The host can recall all participants back to the main room once the time limit expires.

• Calendar and Contacts Integration: Syncs web conferencing platforms with calendar and contact management applications for meeting scheduling, notifications, and reminders.

• Security: Protects sessions using passwords, meeting IDs, and virtual waiting rooms managed by hosts to block unauthorized access.

Advantages of Web Conferencing Tools

• Improves Collaboration: Enhances interactive teamwork through shared real-time document editing, screen sharing, and virtual whiteboards.

• Saves Time: Facilitates immediate feedback and direct visual demonstrations, eliminating lengthy text explanations.

• Saves Cost: Reduces travel, lodging, and logistical expenses by enabling remote participation from home.

• Increases Productivity: Eliminates transit time to physical venues and enables real-time collaboration from any location.

• Ensures Security: Shields private data by restricting entry strictly to authorized users with valid meeting IDs and passwords.

Limitations of Web Conferencing Tools

• Technical Difficulties: Internet connectivity drops, software bugs, and hardware incompatibilities cause system errors and meeting interruptions.

• Engagement Problems: Participants may feel self-conscious or shy on camera/microphone, or face non-conducive home surroundings.

• Distractions: Interruptions from family members, household pets, and ambient background noises.

• Learning Curve: Varying technical complexity among platforms may hinder smooth execution for less tech-savvy users.

• Meeting Fatigue: Sustained concentration, prolonged screen time, and extended sitting lead to physical, emotional, and mental exhaustion.

Web Conferencing Netiquette

• Be Punctual: Join meetings a few minutes prior to the scheduled start time to demonstrate respect for presenter and attendee time.

• Mute Microphone When Not Speaking: Prevents distracting ambient sounds and maintains clear audio flow.

• Turn Camera On When Able and Necessary: Fosters engagement and trust, using an appropriate background (unless bandwidth constraints demand video off).

• Speak Clearly: Maintain a steady pace and pronounce words distinctly to ensure complete comprehension.

• Use Chat Function Responsibly: Maintain polite, concise communication with proper grammar and mechanics.

• Dress Appropriately: Project a professional and respectful online image.

• Respect Privacy: Obtain explicit consent before recording sessions to align with legal and ethical standards.

• Be Courteous: Listen attentively and avoid interrupting speakers.

• Familiarize with Technology: Understand platform controls prior to sessions to minimize disruption.

Safety Practices in Web Conferencing

• Join Only Trusted Meetings: Avoid clicking random or unfamiliar meeting links.

• Keep Passwords Private: Never distribute meeting access passwords outside authorized groups.

• Avoid Sharing Personal Information: Protect full names, home addresses, schools, and contact numbers from public display.

• Be Respectful and Responsible: Follow host instructions and maintain digital decorum.

Online Forms Builders

Collecting, managing, and organizing survey or sign-up data using pen and paper is time-consuming and inefficient when handling hundreds or thousands of respondents. Online forms builders are web-based tools or applications that allow users to design, distribute, and collect digital forms (surveys, quizzes, registration forms, feedback forms, polls) instantly without writing code.

An online form is an electronic document that allows users to input and submit information through a website or application, serving as an efficient replacement for paper forms.

Widely-Used Online Forms Builder Applications

• Google Forms: An easy-to-use forms builder developed by Google. It automatically integrates with Google Sheets to save and manage data dynamically.

• Microsoft Forms: A free tool within the Microsoft 365 suite (integrates with Teams and Excel) used for creating surveys, quizzes, and polls shared via direct links.

• HubSpot Forms Builder: An online platform utilized by businesses to manage sales, marketing, and client communications while collecting customer feedback and data.

• SurveyMonkey: A widely used application for building detailed quizzes, polls, surveys, and customer feedback workflows.

• Jotform: Features an intuitive drag-and-drop interface for rapid creation of sign-up forms, registration forms, and surveys.

Types of Online Forms

• Embedded Form: Positioned directly on a webpage or website layout, allowing visitors to respond immediately without navigating away (e.g., registration forms on the BIR Online Registration and Update System / ORUS, order forms, feedback forms).

• Pop-Up Form: A compact window that automatically appears ("pops up") over a visited web page to capture immediate visitor attention for quick sign-ups or feedback.

• Standalone Form: Hosted on its own distinct web link. It can be distributed directly via email, messaging applications, or QR codes.

Common Features of Online Forms Builders

• Drag and Drop: Reordering form elements (textboxes, checkboxes, buttons) by dragging them visually across the form canvas.

• Various Input Fields: Support for multiple response formats including textboxes, multiple-choice option buttons, and drop-down selection menus.

• Customization: Modifying background colors, font styles, header imagery, and theme aesthetics.

• Shareable Link: Generating direct URLs for email distribution, messaging, or web posting.

• Templates: Pre-designed, ready-to-use form layouts that accelerate form creation.

• Privacy Settings: Restricting access, mandating user authentication, or enabling anonymous responses.

• Uploads: Accepting respondent file attachments such as documents, images, and audio files.

• Application Integration: Linking seamlessly with external tools such as spreadsheets and web plug-ins.

• Notifications: Sending automated email alerts to creators upon form submission.

Advantages and Disadvantages of Online Forms Builders

Advantages

• Intuitive Interface: Coding-free design using simple point-and-click interactions.

• Time-Saving Features: Rapid form creation, instant distribution, and immediate response aggregation.

• Easy Accessibility: Accessible from any Internet-connected desktop, tablet, or smartphone.

• Automated Processes: Responses are automatically stored in connected databases or spreadsheets for seamless data analysis.

• Customization Options: Visual elements can be aligned with brand identity or user preference.

• Data Protection: Privacy controls maintain proper data governance.

• Easily Editable: Real-time updates automatically reflect across all distributed links.

• Environmentally Friendly: Digital operation reduces paper and ink consumption.

• Cost-Effectiveness: Eliminates physical printing and travel costs associated with manual data collection.

Disadvantages and Limitations

• Technical Issues: Slow connections or server drops can cause submission failures or unrecorded responses; compatibility issues may occur on legacy devices.

• Internet and Device Dependency: Entirely unusable without active Internet connections and smart hardware.

• Restrictions on Free Accounts: Tiered plans place caps on response numbers, advanced analytics, or customization features.

• Privacy Concerns: Misconfigured security settings risk exposing sensitive data.

• Lack of Personal Interaction: Inability to probe deeper into ambiguous respondent answers compared to face-to-face interviews.

Step-by-Step Guide: Creating a Feedback Form in Google Forms

1. Open Browser: Navigate to forms.google.com.

2. Select Template: Choose a template (e.g., T-Shirt Sign Up) or start a Blank form.

3. Customize Content: Modify headers, field titles, and text parameters.

4. Set Required Fields: Toggle the Required switch on the lower right of key question boxes to prevent skipped inputs.

5. Configure Settings: Select the Settings tab and toggle Limit to 1 response (requires Google sign-in) to manage submission volume.

6. Preview Form: Click Publish or Preview (eye icon) to inspect the public layout.

7. Share Form: Click Share / Send, copy the responder link (optionally checking Shorten URL), or enter email addresses directly.

Safety and Responsibility Guidelines for Forms

• Configure privacy settings before distribution.

• Restrict data collection exclusively to necessary, relevant information.

• Protect administrative accounts with strong, unique passwords.

• Never create fake forms (creating deceptive forms constitutes cyberbullying or spamming cybercrimes).

• Double-check form configuration prior to release.

• Delete unused forms to permanently remove stored respondent data.

• Always request permission and state the explicit purpose before collecting personal data.

Cloud Storage Platforms and File Management

Cloud storage is an online service that enables users to save, manage, and retrieve digital files on remote servers hosted, managed, and secured by cloud service providers. Files saved to cloud storage can be accessed and downloaded from any location using an Internet-connected device.

Major Cloud Storage Platforms

• Google Drive: Integrates with Google Workspace across Windows, macOS, iOS, and Android. The free account provides $15\,\text{GB}$ of shared storage across Google Drive, Gmail, and Google Photos. Paid storage expansion options start at $100\,\text{GB}$ and include advanced editing tools, VPN options, and automatic backups.

• Microsoft OneDrive: Developed by Microsoft Corporation for seamless integration across Windows, macOS, iOS, and Android. Free tier includes $5\,\text{GB}$ of storage for Microsoft account holders.

• iCloud: Created by Apple for Apple devices (iPhone, iPad, Mac). Free tier offers $5\,\text{GB}$ storage. Paid iCloud+ subscriptions offer capacities of $50\,\text{GB}$, $200\,\text{GB}$, $2\,\text{TB}$, $6\,\text{TB}$, or $12\,\text{TB}$ (e.g., $50\,\text{GB}$ at $\text{P}49.00/\text{month}$) with device syncing and backup capabilities.

• Dropbox: Established in 2007. Basic accounts include $2\,\text{GB}$ of free storage. Features Dropbox Paper for real-time document collaboration. Paid plans scale from $3\,\text{TB}$ for individual professionals to $9\,\text{TB}$ shared storage for teams.

Advantages and Disadvantages of Cloud Storage

Advantages

• File Storage: Accommodates all digital file formats (documents, slideshows, spreadsheets, images, audio, video).

• Accessibility: Instant file access from any device connected to the Internet.

• File Sharing: Rapid link-based distribution with custom access permissions.

• Real-Time Collaboration: Simultaneous editing by multiple distributed users.

• File Protection: Password-protected storage with auto-saving to protect work against unexpected system crashes or local hardware failure.

Disadvantages and Limitations

• Internet Dependency: High-speed, stable Internet connections are required for file uploading, downloading, and viewing.

• Limited Free Space: Free storage allocations fill rapidly, requiring paid upgrades for extra capacity.

• Security and Privacy Risks: Vulnerable to unauthorized access or hacking if account credentials or permissions are improperly configured.

• Technical Issues: Incompatibilities between file types, software versions, or browser updates.

Cloud Storage Security Features

• Authentication Requirements: Strong usernames, passwords, and Multi-Factor Authentication (MFA) prevent unauthorized account entry.

• File Encryption: Encrypts data during upload and storage, rendering contents unreadable without specialized decryption keys.

• Account Privacy: Personal credentials create private digital storage locked to individual account owners.

• File Backups: Automated versioning and backup options restore lost or accidentally overwritten documents.

• Privacy Settings: Granular permission settings (e.g., View only, Commenter, Editor).

Step-by-Step Guide: Uploading and Sharing Files in Google Drive

Uploading a File

1. Open browser and go to drive.google.com.

2. Click the + New button in the upper left corner.

3. Select File upload from the drop-down menu.

4. Browse and select the target file from the local hard drive.

5. Click Open and await the completion notification pop-up.

6. Click the folder icon in the pop-up to locate the uploaded file in My Drive.

Sharing an Uploaded File

1. Click the three vertical dots next to the file name in Google Drive.

2. Select Share.

3. Under General access, change Restricted to Anyone with the link.

4. Select the access tier:

   • Viewer: Can view the file but cannot edit or comment.

   • Commenter: Can view and leave comments without editing contents.

   • Editor: Full permission to view, comment on, and modify file contents.

5. Enter recipient email addresses, add an optional message, and click Send.

Management and Safety Guidelines for Cloud Storage

• Maintain clean file organization using strict naming conventions, sub-folders, and regular file cleanup.

• Monitor available storage space, permanently purge trash contents, and compress large files.

• Never save passwords or unencrypted identity documents on cloud storage accessible from public computers.

• Log out completely when using shared or public workstations.

• Maintain duplicate offline backups of critical digital files.

• Use View only sharing links by default unless collaborators explicitly require editing privileges.

Word Processing Software and Productivity Tools

A word processing software is an application equipped with tools to create, edit, format, view, and print physical or digital text documents. It includes built-in spelling and grammar checkers and supports embedding rich media elements.

Key Features of Word Processing Software

• Text Entry: Typing, editing, deleting, and positioning text anywhere on a document canvas.

• Formatting: Adjusting typeface, font size, text color, text alignment (left, center, right, justified), and style emphasis (bold, italic, underline).

• Page Structure: Adjusting page margins, layout size, and page orientation (Portrait or Landscape).

• Insertion of Elements: Embedding tables, pictures, graphical shapes, SmartArt, and data charts.

• Collaboration: Real-time multi-user document creation and editing (e.g., Google Docs).

• Printing: Directing output to connected physical printers.

• Saving and Exporting: Exporting files into standard digital formats (PDF, DOCX, JPEG).

Step-by-Step Applications in Microsoft Word

Adding a Watermark

A watermark is a background text or image displayed behind main document contents to establish copyright ownership, signal document status (e.g., Confidential), or enhance visual presentation.

1. Open the target document in Microsoft Word.

2. Click the Design tab on the Ribbon.

3. Click Watermark in the Page Background group to open the drop-down menu.

4. Select a preset watermark or click Custom Watermark to insert a specific picture or custom text, then click Apply.

Applying Page Color

1. Click the Design tab on the Ribbon.

2. Click Page Color in the Page Background group.

3. Choose a color palette option from Theme Colors or Standard Colors, then save changes.

Adding Page Borders

1. Click the Design tab on the Ribbon.

2. Click Page Borders to open the Borders and Shading dialog box.

3. Under Setting, select Box.

4. Customize the border Style, Color, Width, or Art graphics.

5. Ensure Apply to: is set to Whole document, then click OK.

Displaying Page Numbers

1. Open the target document in Microsoft Word.

2. Click the Insert tab on the Ribbon.

3. Click Page Number in the Header & Footer group.

4. Select placement (Top of Page, Bottom of Page, Page Margins, or Current Position).

5. Choose the desired alignment and visual style template, then click OK.

Adding Headers and Footers

• Header: Top margin area displaying document titles, author names, logos, or dates across every page.

• Footer: Bottom margin area displaying page numbers, footnotes, or disclaimer statements across every page.

1. Click the Insert tab on the Ribbon.

2. Select Header or Footer to reveal the layout style drop-down menu.

3. Choose a design style.

4. Type the intended text within the header/footer workspace.

5. Click Close Header and Footer on the Ribbon to apply across the entire document.

Presentation Software and Slide Recording

Presentation software is a computer application used to organize ideas, lessons, or business reports into visual slide shows. It provides built-in templates, custom color schemes, media integration, and visual transition tools.

Widely-Used Presentation Applications

• Microsoft PowerPoint: Standard presentation software featuring extensive animation engines, slide master designs, and slide recording functions.

• Google Slides: Cloud-based tool enabling multi-user real-time presentation creation within web browsers or mobile applications.

• Prezi: Features a dynamic, zooming canvas and spatial motion effects designed for visual learners and step-by-step process presentations.

• Visme: Web-based visual creation tool tailored for data-driven presentations, infographics, interactive graphs, and visual communications.

• Zoho Show: Cloud-based software offering customizable charts, version history tracking, and real-time offline/online editing capabilities.

• Canva & Apple Keynote: Popular tools providing sleek templates and creative design assets.

Reasons for Recording Slide Presentations

1. Broader Reach: Enables distribution via email or cloud links to unlimited audiences.

2. Skill Building: Helps presenters refine vocal delivery, articulation, and confidence.

3. Self-Paced Learning: Viewers can pause, rewind, and re-watch key sections.

4. Enhanced Explanations: Provides detailed verbal context beyond written slide bullet points.

5. Reusability: Eliminates repetitive live presentations by saving recorded modules for future reuse.

6. Documentation: Serves as permanent archival material for absentees.

7. Performance Evaluation: Provides recorded material for self-review and peer feedback.

8. Information Consistency: Delivers identical, accurate messaging across every viewing.

Presentation Recording Guidelines

Before Recording

• Conceptualize topic outlines, key terms, slide transitions, and narration scripts.

• Test microphone input, video camera framing, device battery, and connectivity.

• Position hardware in a quiet, well-lit room free from background noise.

• Rehearse delivery pace and vocal clarity.

During Recording

• Maintain a natural, steady speaking pace with clear pronunciation.

• Maintain eye contact with the camera lens and use a dynamic tone.

• Keep animations and slide transitions minimal to maintain focus on content.

After Recording

• Review video playback for audio-visual timing synchronization.

• Edit out long pauses, adjust audio volume levels, or trim unnecessary segments.

• Gather feedback from peers or teachers.

• Save primary video files and back them up on cloud storage.

Step-by-Step Guide: Recording Slide Presentations in Microsoft PowerPoint

1. Open the target presentation file in Microsoft PowerPoint.

2. Click the Slide Show tab on the Ribbon and select Record Slide Show.

3. The recording dashboard opens, displaying the slide canvas, timer, audio/video controls, and pen annotation tools.

4. Click the red Record button to begin narration.

5. Use the pen annotation tool to emphasize keywords on slides during recording. Click the red button again to stop recording.

6. Click the Play button icon to inspect slide narration quality.

7. Go to File > Export and export the recorded presentation as a video file in MP4 or MOV format.

Desktop Publishing Software and Layout Design

Desktop publishing (DTP) software enables users to combine formatted text, digital imagery, and geometric graphics to produce professional visual layouts for printed and digital publications (magazines, flyers, brochures, posters, newsletters).

Prominent Desktop Publishing Software

• Adobe InDesign: Professional desktop publishing software favored by commercial graphic designers for publishing complex books, magazines, and multi-page layouts.

• Microsoft Publisher: Entry-level DTP application featuring intuitive master page systems, background formatting, layout guides, and publication tools.

• Canva: Web-based layout tool offering drag-and-drop graphic design templates for web and print.

Core Productivity Tools and Features

• Text Tool: Draws text frames and formats typography (font style, size, color, leading, tracking, alignment).

• Image Tool: Embeds, scales, and positions vector graphics and raster photographs within layout frames.

• Shape Tool: Creates geometric structures (rectangles, ellipses, polygons) to frame content.

• Layers: Stacks visual elements hierarchically, locking or ordering background and foreground assets.

• Guides and Grids: Non-printing alignment lines used to position page elements precisely.

• Rulers: Precise measurement tools operating in points, picas, inches, millimeters, centimeters, ciceros, agates, or pixels.

• Master Page: A parent page template that automatically applies recurring visual elements (headers, footers, page borders, logos, backgrounds) across all linked child pages.

• Templates: Pre-formatted design frameworks that accelerate document output.

• Simultaneous Editing & Cloud Integration: Multi-user real-time online design capabilities.

Step-by-Step Applications in Microsoft Publisher

Setting Up Master Pages and Multi-Page Layouts

1. Open Microsoft Publisher and launch a new blank document.

2. Click Insert > Page drop-down > Insert Page….

3. Input the required number of new pages (e.g., $12$) and click OK.

4. Right-click any single page icon in the left navigation pane and select View Two-Page Spread.

5. Click the Page Design tab, click Master Pages, and select Edit Master Pages.

6. Click Two-Page Master to configure the master spread.

7. Click Page Design > Background and pick a theme color to apply to the master canvas.

8. Click Close Master Page on the Master Page tab to apply changes across all document pages.

Adding Built-In Layout Guides

1. Click the Page Design tab on the Ribbon.

2. Click Guides to open the built-in guide menu.

3. Select a structural grid guide layout (e.g., Uneven Grid 3) to display alignment guides across the publication.

Adding Headers, Footers, and Page Numbers in Master Page Mode

1. While in Edit Master Pages mode, click Show Header/Footer on the Master Page tab.

2. Type the intended text within the header workspace.

3. Double-click Show Header/Footer to navigate down to the footer text box and type the footer information.

4. Click Insert Page Number on the Ribbon and select the preferred placement style.

5. Click Close Master Page to verify that headers, footers, and automatic page numbers appear across all pages.

Spreadsheet Software and Data Management

Spreadsheet software is an application designed to input, compute, organize, analyze, and visualize numeric and textual data structured within rows and columns. It provides built-in formula engines, analytical functions, data validation rules, and chart visualization tools.

Widely-Used Spreadsheet Software

• Microsoft Excel: Comprehensive commercial spreadsheet application featuring advanced data analytics, pivot tables, and charting engines.

• Google Sheets: Cloud-based collaborative spreadsheet tool offering automated data entry, Google ecosystem integration, and real-time co-authoring.

• LibreOffice Calc: Free, open-source spreadsheet application running on Windows, Linux, and macOS, capable of processing advanced mathematical formulas.

• Zoho Sheet: Cloud-based spreadsheet software featuring AI-assisted data analysis tools, conditional formatting, and pivot tables across desktop and mobile devices.

• Jotform Tables: Hybrid spreadsheet and database tool designed to collect, organize, and automate form response entries.

Core Productivity Features

• Rows and Columns: The grid framework organizing data horizontally (rows) and vertically (columns).

• Cells: Individual grid units formed by the intersection of a row and a column.

• Formulas and Functions: Built-in computational engines (e.g., SUM, AVERAGE) that automate mathematical calculations.

• Sorting and Filtering: Reordering records numerically/alphabetically or isolating data subsets based on user-defined logical criteria.

• Data Validation: Restricting input entry types within specified cells to ensure data integrity and prevent input errors.

• Autofill: Automatically copying formulas or extrapolating sequential data patterns across adjacent cells.

• Pivot Tables: Interactive summarization tools that aggregate and analyze large volumes of complex data.

Common Types of Charts and Graphs

• Column Chart: Displays data using vertical bars; ideal for comparing individual metrics or tracking performance (such as monthly sales volume) over discrete time frames.

• Bar Graph: Uses horizontal or vertical bars to compare discrete numerical quantities (e.g., stock levels, inventory metrics).

• Line Graph: Connects data points across a continuous axis line; best suited for displaying trends, growth rates, or metric changes over time.

• Pie Chart: Circular statistical graphic divided into proportional slices representing percentages of a whole $100\%$, commonly used for visual budget allocations or demographic breakdowns.

• Area Chart: Blends line chart connectivity with shaded quantitative areas to accentuate volume changes over time.

Step-by-Step Guide: Creating a Chart in Google Sheets

1. Open browser and navigate to sheets.google.com.

2. Open an existing worksheet dataset.

3. Click and drag to highlight the target data cell range (e.g., A4:D9).

4. Click Insert on the main menu bar and select Chart.

5. The data renders automatically as a default column chart. Use the Chart Editor sidebar on the right to customize titles, axes labels, colors, and legend layouts.

6. Drag and resize the chart canvas to position it on the spreadsheet.

Step-by-Step Guide: Data Validation, Sorting, and Filtering in Microsoft Excel

Creating Data Validation Rules

1. Open the target worksheet in Microsoft Excel.

2. Select the target cell range (e.g., cell C3).

3. Click the Data tab on the Ribbon and click Data Validation.

4. In the Settings tab, under Validation criteria:

   • Set Allow: to Whole number.

   • Set Data: to between.

   • Input Minimum: 23 and Maximum: 60.

5. Click the Input Message tab, check Show input message when cell is selected, and type:

   • Title: AGE

   • Input message: Enter an age between 23 to 60

6. Click the Error Alert tab, choose Style: Warning, type Title: ERROR, and set Error message: Please enter the required age parameter!.

7. Click OK to apply the validation rule.

Sorting Data

1. Select the data range containing records to be reordered.

2. Click the Data tab on the Ribbon and select Sort.

3. Ensure My list has headers is checked.

4. Select the target sort column (e.g., Sales Agent), set Sort On to Cell Values, and choose Order: A to Z.

5. Click OK to reorder the dataset alphabetically.

Filtering Data

1. Highlight the data columns or header row containing data to filter.

2. Click the Data tab on the Ribbon and click the Filter icon (funnel symbol) to display drop-down selection arrows on each header.

3. Click the drop-down arrow next to a column header (e.g., Total Sales).

4. Select Number Filters > Greater Than… and enter the numerical threshold (e.g., 30000).

5. Click OK to display only matching rows with total sales exceeding $\text{P}30,000.00$.