CS001 — Final Term Summary (Lectures 23–32)

📘 Lecture 23 — Computer Proficiency License (CS-001) Module 4: Sorting Data

📖 Overview: This lecture introduces the concept of sorting data in worksheets and explains how to arrange information in a specific order (alphabetical, numerical, by date, or custom). It also covers table formatting, chart creation and parts, tracking changes, adding comments, document inspection, conditional formatting, and pivot tables — all essential for managing and presenting data efficiently in MS Excel.

🗂️ Topics Covered

This lecture covers sorting (types and application), table formatting (color), templates (built-in), charts (types, parts, creation), reviewing and sharing worksheets (track changes, comments), document inspector, conditional formatting, and pivot tables.

📝 Lecture Summary

Objectives

The objective is to learn how to apply sorting in a worksheet, understand what sorting is, and arrange data in a specific order.

Different types of sorting

Sorting arranges data in a specific order. Types include: alphabetically, numerically, by date and time, customized sorting, and by cell color, font color, or cell icon. To sort, go to the Data bar, click on Sort from the dropdown list (Data < Sort). A Sort dialogue box opens. Select the column, sort on, and order of your choice from the dropdown lists. You can also filter data as needed.

Tables Formatting

You can change the table color. Click on the Home tab, select Format as Table, and choose a color from the dropdown list.

Template

By default, a template is a collection of different color combinations, effects, fonts, and settings. Use MS Excel's built-in templates by clicking the File tab, then New, and selecting a sample template.

Chart

In MS Excel, a chart is a tool to represent data graphically. Charts display hidden meanings of numbers and figures and enable comparison. Types include: Column Chart, Pie Chart, Line Chart, Bar Chart, Area Chart, Surface Chart.

Different parts of a chart

Parts include: Title of the chart, Vertical Axis, Data Series, and Legend.

How to create a chart in a worksheet

Go to Insert > Chart. To change the chart type, right-click on the chart and select Change Chart Type from the menu.

Reviewing and sharing worksheets

Go to Review > Track Changes from the Changes group. Click Highlight Changes from the dropdown menu. A dialogue box opens. Check the box "Track changes while editing" (this also shares your workbook), apply the track selections, and click OK.

Adding and Deleting Comments

Comments provide information about data for convenience. To insert a comment: select the cell, go to the Review tab, click New Comment. Or press Shift+F2 on the keyboard.

Use of Document Inspector

Click the File tab to open the Backstage view. Click the Check for Issues dropdown, then select Inspect Document. By default, anyone can copy, delete, or edit your worksheet data.

Using Conditional Formatting

First, select your spreadsheet data. Go to the Home tab and click on Conditional Formatting from the Styles group.

Pivot table

A pivot table is a kind of interactive table that automatically abstracts, organizes, and summarizes data. It makes data easier to manage, and you can quickly change it to see data in different ways — making it a powerful tool. Go to the Insert tab, click the PivotTable dropdown, and select PivotTable.

🔑 Definition — Pivot Table: A kind of interactive table which automatically abstracts, organizes, and summarizes data. It makes it easier to manage and view data in different ways.

💡 Why this matters: Pivot tables are one of the most powerful Excel tools for analyzing large datasets quickly without formulas — essential for business reporting and decision-making.

⭐ Key Takeaways

Sorting data is the foundation of data organization, allowing you to arrange entries alphabetically, numerically, by date, or by color. Charts visually represent data and have key parts (title, axes, series, legend) — use the Insert tab to create them. Track changes and comments facilitate collaboration and data review on worksheets. The Document Inspector checks for hidden or sensitive information before sharing. Conditional formatting applies visual rules to data, and pivot tables dynamically summarize and reorganize large datasets for flexible analysis — making them indispensable tools for data management and presentation.

🧠 Quick Revision Questions

1. What are the different types of sorting mentioned in this lecture?
2. How do you access the Sort dialogue box in Excel?
3. List at least four different types of charts covered in this lecture.
4. What is the purpose of a pivot table, and how do you insert one?
5. How do you add a comment to a cell in a worksheet?

📘 Lecture 24 — Computer Proficiency License (CS001) Module 5: Introduction to Microsoft PowerPoint 2010

📖 Overview: This lecture introduces the Microsoft PowerPoint 2010 environment, focusing on its interface elements like the Ribbon, Quick Access Toolbar, and Backstage View. It covers the fundamental skills for creating, managing, and formatting presentations, including adding slides, applying themes, and inserting media. This lesson is essential for building a strong foundation in creating professional and dynamic slide presentations.

🗂️ Topics Covered

The lecture covers the PowerPoint 2010 environment including the Menu Bar, Ribbon, and Quick Access Toolbar. It explains the Backstage View for file management and how to create new presentations. The lesson details slide basics such as adding, deleting, copying, and arranging slides, as well as changing layouts and views. It also includes formatting text with indentation, line spacing, bullets, and numbering, and concludes with applying themes and inserting images.

📝 Lecture Summary

Environment of Microsoft PowerPoint 2010

PowerPoint is a presentation software used to create dynamic slide presentations. It is useful for preparing any type of presentation, allowing you to incorporate text, animations, sound, pictures, and videos. A presentation can contain multiple slides, and you can view a slideshow at any time by clicking the Slide Show option in the Ribbon or by pressing F5 on the keyboard.

Menu Bar and Ribbon

The Menu Bar contains different tabs such as Home, Insert, Design, Transitions, Animations, Slide Show, Review, View, and Acrobat. Under each tab, there are groups of related commands. For example, the Tables and Pictures options are found under the Insert tab.

To Customize the Ribbon, right-click on the Ribbon, select "Customize the Ribbon," and a new PowerPoint Options dialog box will open. You can then add or remove different tabs as needed. To Minimize or Show the Ribbon, click the ^ button on the Ribbon bar or right-click and select "Minimize the Ribbon."

The Quick Access Tool Bar

The Quick Access Toolbar is located above the Ribbon and contains shortcut buttons for common commands like Save and Undo. 🔑 Definition — Quick Access Toolbar: A customizable toolbar that provides quick access to frequently used commands. To add commands to the Quick Access Toolbar, right-click on it, select "Customize Quick Access Toolbar," and a new dialog box will open where you can add or remove buttons.

Backstage View

Backstage View is a new feature in MS PowerPoint 2010. It is the view that appears when you click on the File button on the Ribbon. It provides options for file management, such as creating new presentations and opening existing ones.

Creating and Opening Presentations

To create a Blank Presentation, click the File button to open Backstage View. Then click New, select "Blank Presentation," and click the Create button. To open an existing presentation, click File, then Open, browse for the file, and click the Open button. Compatibility mode is used to convert presentations for use with older versions of PowerPoint.

Slide Basics

A Place Holder is an input area on a slide shown as a dotted area where you can insert tables, charts, and text. Slide Layouts allow you to arrange slide content in different ways. 🔑 Definition — Place Holder: A dotted input area on a slide used for inserting text, tables, charts, or other content.

To customize a slide layout, select the slide, click the Home tab, click the Layout dropdown in the Slides group, and choose a new layout. To remove a place holder, select its boundary and press the Backspace or Delete key. To insert text, click the Home tab and use the Drawing Box in the Drawing group. To use a blank slide, select it from the Layout dropdown menu.

To add a new slide, click the New Slide dropdown button under the Home tab and select a layout. To instantly generate a slide with the same layout, click the New Slide button or press Ctrl + M. To copy and paste a slide, select it, click the New Slide dropdown, and choose Duplicate Selected Slides. To delete a slide, select it and press Backspace or Delete.

Managing Slides and Presentations

There are three main Slide Views:

• Normal View
• Slide Sorter View
• Reading View

To access Slide Sorter View, click the View tab and then Slide Sorter from the Presentation Views group. This view allows you to arrange slides and check that all necessary slides exist and no extra slides are present.

Indentation and Line Spacing

Multilevel List refers to different indenting levels in a slide that show multiple lists. To indent text, place the cursor at the start of the text and press the Tab key. You can also use the Increase Indent and Decrease Indent buttons in the Paragraph group on the Home tab. To show the ruler for fine-tuning indents, go to the View tab and check the Ruler checkbox. To format line spacing, click the Line Spacing dropdown from the Paragraph group on the Home tab and select an option. 📐 Formula (Concept): Further indenting an already indented list creates a multilevel list. 💡 Why this matters: Proper indentation and line spacing makes slide text more readable and organized.

Presentation Notes for the Presenter

To number slides, click the Insert tab, then Slide Number from the Paragraph group. In the Header and Footer dialog box, check the Slide number checkbox under the Slide tab. The Justify alignment option is used when a slide contains a large amount of text. To convert text into smart graphics, click the Convert to Smart dropdown from the Paragraph group on the Home tab.

Applying a Theme

A theme is a collection of color combinations, fonts, effects, and settings that can be applied to a presentation. 🔑 Definition — Theme: A predefined set of design elements including colors, fonts, effects, and shapes that gives a presentation a coordinated look.

To apply a theme, click the Design tab on the Menu Bar and select any theme from the Themes group. Theme elements include the Color of the theme, Theme Fonts, and Shape Styles. You can also access themes via the Home tab by selecting New from the Backstage View and then choosing Themes.

To insert an image from a file into a slide, click the Insert tab, then Picture from the Images group. Select the picture in the dialog box and click the Insert button. The Slide Master allows you to set the default content and layout for all slides. To access it, click the View tab and then Slide Master from the Master Views group. 💡 Why this matters: Themes ensure visual consistency and save time on design, while the Slide Master allows for bulk editing of a presentation's look.

⭐ Key Takeaways

For the exam, remember that the Ribbon and Quick Access Toolbar are the main interfaces for commands, and Backstage View (File tab) is for file management. Master adding, duplicating, and deleting slides, and be able to change layouts and views. You must know how to create a multilevel list using the Tab key or indent buttons and how to adjust line spacing. Finally, understand that a theme is a collection of design elements applied from the Design tab, and that images are inserted via the Insert tab.

🧠 Quick Revision Questions

1. What is the keyboard shortcut (F5) used for in Microsoft PowerPoint 2010?
2. What is the name of the input area on a slide shown as a dotted boundary?
3. How do you instantly create a new slide with the same layout as the current slide?
4. What is the term for different indenting levels in a slide that show multiple lists?
5. Which tab on the Ribbon contains the "Themes" group for applying a coordinated look to a presentation?

📘 Lecture 25 — Move, Copy or Delete the text

📖 Overview: This lecture covers essential PowerPoint text manipulation commands (copy, cut, paste, delete), text formatting options, spell-check, and graphics insertion. It also explains how to change slide orientation, print slides in different views, add animation effects, and create organizational charts — all critical skills for creating professional presentations.

🗂️ Topics Covered

The lecture covers text selection, copying, cutting, pasting, and deleting; text formatting including font size, color, style, character spacing, and case changes; spell-check using F7; drawing shapes and changing shape attributes; creating charts and understanding chart parts; inserting objects; changing slide orientation between landscape and portrait; printing slides in various views with collation options; and adding animation effects and transitions between slides.

📝 Lecture Summary

Use copy and paste commands to duplicate the text

To duplicate text, first select the text, then click Copy command under the Home tab OR press Ctrl+C. Then press Ctrl+V to paste. To move text, use Cut (Ctrl+X) followed by Paste (Ctrl+V). To delete text, double-click to select it and press the Delete key.

🔑 Definition — Copy: Duplicates selected text while leaving the original in place.

📐 Formula: Ctrl+C → copy, Ctrl+V → paste

📌 Example: To duplicate the word "Presentation": select the word, press Ctrl+C, move cursor to new location, press Ctrl+V — the word appears in both locations.

Copy, Move or Duplicate the images

Select the image, then click Copy under the Home tab, then click Paste to duplicate the image.

Text Formatting

Select text and click the Home tab from the Ribbon bar. Use the Font size dropdown menu to increase or decrease text size. Text formatting includes Text color, Font size, Font Style, Text shadow, Bold, Italic, Underline, and text shade.

🔑 Definition — Font group: A set of formatting commands on the Home tab that controls text appearance.

Increasing or Decreasing Font Size

To Increase Font Size: Select text, click the A^ button — it increases by 2 scale units per click, but after 20 scale units, it increases by 4 scales per click. To Decrease Font Size: Select text, click the A^ button — it decreases by 2 scale units per click, but after 20 scale units, it decreases by 4 scales per click.

📌 Example: If font size is 14, clicking A^ once makes it 16; clicking again makes it 18. At size 20, the next click jumps to 24.

🔑 Definition — Font size scaling: The incremental change in font size when using the increase/decrease buttons, which changes from 2-unit increments to 4-unit increments above 20.

Clear the Formatting

Select the text, click Home tab, then click the Aa/ button from the font group to remove all formatting.

Character Spacing

AV is used to insert character spacing on selected text. Options: Very tight, Tight, Normal, Loose, Very loose, and More spacing.

Case

Aav changes the case of selected text. Options: Sentence case, lowercase, UPPERCASE, Capitalize Each Word, tOGGLE cASE.

💡 Why this matters: Proper case and spacing improve readability and professionalism in presentations.

Using spell check for presentation text

Select the text, click Review tab from the Ribbon bar, then click Spelling command OR press F7 from the keyboard.

Graphics and Charts

To draw objects: Click Home tab, select any shape from the drawings group. To change shape attributes (color and line type): Select the shape, go to drawing group under Home tab.

🔑 Definition — Chart: A tool to represent data graphically. Types include Column chart, Pie chart, Line chart, Bar chart, Area chart, and Surface chart.

Parts of a chart: Title, Vertical axis, Data Series, Legend (usually about x-axis data and scale).

To insert a chart: Click Insert tab, click chart button from the illustrations group. Right-click on chart to change chart type.

Import other objects, texts, spreadsheet, table chart or graphics

Go to object command under the Insert tab. The Insert Object dialogue box opens. Select Create from file radio button, click Browse to select the object, then click OK.

Add border objects to an object or picture

Right-click the object, click format object option — a new Format Object dialogue box opens.

Printing and Distribution

First, select a suitable presentation slide view. Click Design tab, then page setup button. The Page Setup dialogue box opens — use different features and click OK.

Change Slide Orientation Landscape or Portrait

Default orientation is Landscape. To change to Portrait: Click Design tab, click Slide Orientation dropdown menu, select Portrait.

🔑 Definition — Slide orientation: The direction of the slide — landscape (wider than tall) or portrait (taller than wide).

Preview the presentation in slide outline as a slide sorter

Click View tab, then slide sorter command from the Presentation View commands group.

Print slides in various views and outputs

Click File tab — Backstage opens. Click Print command. The Print menu list contains options like Print, Printer settings, etc. Note: The Collated option under settings prints slides in groups.

💡 Why this matters: Proper print settings ensure handouts are organized for distribution.

Slide Show Effects

Objectives: How to set animation effects, change animation effects, and add transition between slides.

Preset animations: Select text, click Animation tab. Under this tab, there are Animation, Advance Animation, and Timing groups of commands. Note: View animation preview with the Preview button under the animation tab.

⭐ Key Takeaways

Students must master the fundamental text operations (copy, cut, paste, delete) and formatting commands (font size, color, style, character spacing, case) as these form the basis of all slide content editing. The spell-check feature (F7) and the ability to insert, format, and animate shapes, charts, and objects are essential for creating professional presentations. Understanding slide orientation (landscape/portrait) and print settings (collation, views) ensures proper distribution of materials. Animation and transition effects enhance presentation delivery but must be applied correctly for maximum impact. Remember that font size increases/decreases by 2 units until 20, then by 4 units — a common exam point.

🧠 Quick Revision Questions

1. What are the keyboard shortcuts for Copy, Cut, and Paste commands?
2. How does the A^ font size button behave differently after the scale reaches 20 units?
3. Name at least five options available under the Character Spacing (AV) command.
4. What are the four main parts of a chart, and what does the Legend represent?
5. How do you change a slide from landscape to portrait orientation, and which tab provides this option?

📘 Lecture 26 — Change Preset Animation Effect

📖 Overview: This lecture covers advanced PowerPoint features for creating professional presentations. It teaches how to manage slide shows, use navigation tools, hide slides, insert and modify SmartArt graphics, work with hyperlinks and action buttons, create and format tables, rehearse presentations, and use advanced options like recording and broadcasting.

🗂️ Topics Covered

The lecture covers changing preset animation effects, transitions, delivering presentations with on-screen navigation tools, hiding slides, inserting and modifying SmartArt graphics including organization and appearance changes, document exchange and file formats, hyperlinks and action buttons (inserting to slides and files), working with tables (inserting, resizing, styling), and advanced PowerPoint options including rehearsal, recording, video creation, and broadcasting.

📝 Lecture Summary

Change Preset Animation Effect

To change an existing animation effect, click on Animation Pane from the Advance Animation group in the Animations ribbon tab. A new side bar will open on the right side. From this pane, you can play the animation using the play button, change the settings of the effect, or remove it entirely.

Transitions

A Transition is the effect that occurs when you move from one slide to another. To apply a transition, use the Transitions tab from the Ribbon Bar. Every transition has specific properties, such as direction (e.g., from left to right or right to left). These settings can be accessed from the Effect Options menu. You can also use the Apply to All option to apply the current transition to all slides in the presentation.

Deliver Presentation

To start a slide show, click on the Slide Show tab from the Ribbon Bar. You can start from the beginning using From Beginning or press F5. To move to the next slide, press the Space Bar or Arrow Keys.

On-Screen Navigation Tool

When a slide show is running, Navigation Buttons appear at the bottom left of the slide. These include:

• Left and Right Arrow buttons for navigating to the previous or next slide.
• Pen button to show/hide a pen for drawing or highlighting points on the slide.
• Navigation button to jump to a specific slide.

Hide the Slides

You can hide a slide if you do not want it to appear in the slide show. Select the slide, go to the Slide Show tab, and click the Hide Slide button. The slide will be hidden during the show but will appear in the sidebar with a cross mark on it.

Insert Smart Art Graphics

To insert SmartArt, go to the Insert tab and click on SmartArt. A window opens with categorized graphics. Select the required SmartArt and press OK to insert it into the current slide.

Add Text to Smart Art Graphic

After inserting a SmartArt graphic, click on the Arrows button on the left side. A left pane with text boxes opens. Add the required text into these boxes, and it will be applied to the slide's graphic.

Convert Existing Text to Smart Art Graphic

To convert existing text to SmartArt, right-click on the text, select Convert to SmartArt from the dropdown, choose your required SmartArt, and click OK. To convert SmartArt back to text, select the SmartArt, go to the Design tab, click Convert, and select Convert to Text.

Change the Organization of Smart Art Graphic

To change the organization, select a SmartArt graphic and click on the Design tab. Click Add Shape to open a dropdown. Use options like Add Shape Above to insert a shape above the selected one.

Move Shapes to Higher or Lower Level

To change a shape's position, click on the Design tab and select Promote to move it higher or Demote to move it lower. A shortcut key to demote is Tab and to promote is Backspace.

Rearrange Shapes on the Same Level

To rearrange shapes on the same level, click on the Design tab and use the Move Up or Move Down buttons.

Modifying the Smart Art Graphics Appearance

To change the appearance, select the graphic, click the Design tab, expand the Layouts group, and select a new design by clicking or hovering to preview.

Change the Smart Art Style

To change the style, select the graphic, click the Design tab, expand the SmartArt Styles group, and select a style by clicking or hovering to preview.

Change the Smart Art Color Scheme

Select the graphic, click the Design tab, and click Change Colors. A dropdown opens; select the required color to apply it to the graphic. You can also modify a single shape inside the SmartArt by selecting it and changing its color and format.

Save an Existing Document to Another File Format

To save an already created presentation to another file format, click the File tab, select Save As, choose the required file type from the Save as type dropdown, and click Save.

Insert Hyperlinks

To insert a hyperlink, select the text, picture, or shape, right-click, and select Hyperlink. A window opens with Text to display and Address. Insert the link and the display text. A hyperlink can also be inserted from the Insert tab using the Link button. For an email hyperlink, select the Email Address option in the hyperlink window.

Insert Hyperlinks to Another Slide

Select the text or object, right-click, select Hyperlink, and in the window choose Place in this Document. Select the target slide and click OK.

Insert Hyperlinks to Another File

In the hyperlink window, select the file from the files menu and click OK. Clicking the hyperlink will open the linked file.

Remove Hyperlinks

Right-click on the hyperlink and select Remove Hyperlink from the dropdown. The text or image remains.

Inserting Action Buttons

Action Buttons perform an action when clicked, such as moving to the next slide or playing a sound. Go to the Insert tab, click Shapes, find the Action Buttons at the bottom of the dropdown, select one, and draw it on the slide. A window opens to choose the action (hyperlink, play sound, or run a program). Action buttons can also be applied to the Slide Master to appear on every slide.

Change the Appearance of Action Buttons

To change the appearance, select the action button, click the Design tab, and choose the required color, shape, and style.

Insert a Blank Table

To insert a table, go to the Insert tab and select Table. In the dropdown, you can quickly insert a table by selecting small boxes or select Insert Table to specify the number of rows and columns.

Move and Resize Table

To move a table, move the mouse to the sides until the pointer becomes a four-headed arrow, then click and drag. To resize, move the pointer to the extreme edges until it changes, then click and drag.

Add Columns and Rows

To insert a row or column, right-click where you want it, select Insert, and choose Insert Rows Above/Below or Insert Columns Left/Right. To delete, right-click and select Delete Cells.

Change Table Styles

Select the table, click the Design tab, and find the Table Styles group. Hover to preview or click to apply a style. You can also add or remove borders and adjust shading from the Borders and Shading sections on the right side of the design tab.

Advanced Options in PowerPoint

To rehearse a presentation, open the Slide Show tab and click Rehearse Timings to start and record the show. You can also use the Record Slide Show option. To present as a video, click File, find Export, and select Create a Video. Choose the required resolution and quality. To broadcast a slideshow, click Broadcast Slide Show from the Slide Show tab, choose settings, and start the broadcast.

⭐ Key Takeaways

The most critical skills from this lecture are mastering the animation pane for modifying effects, using transitions to control slide movement, and hiding slides for flexible presentations. SmartArt graphics must be learned for inserting, converting text, and reorganizing their structure, as well as changing their colors and styles. Hyperlinks and action buttons are essential for interactive presentations, allowing connections to other slides, files, or emails. Finally, table creation, styling, and formatting, along with advanced options like rehearsal timing, video creation, and broadcasting, are crucial for delivering professional and polished presentations.

🧠 Quick Revision Questions

1. How do you start a slide show from the beginning using the keyboard?
2. How can you hide a slide so it doesn't appear during the presentation?
3. What are the steps to convert existing text on a slide into a SmartArt graphic?
4. How do you insert a hyperlink that jumps to another slide within the same presentation?
5. How can you record timings for a slide show to rehearse a presentation?

📘 Lecture 27 — Module 06 Introduction

📖 Overview: This lecture introduces the foundational concepts of the World Wide Web and the Internet, explaining how users can access and navigate online information. It covers the roles of ISPs and Web Browsers, focusing on the features of Internet Explorer 11, and details how to manage browser settings, history, and search for information effectively.

🗂️ Topics Covered

This lecture begins by defining key terms like WWW, Internet, Web pages, Web sites, and Web servers. It then explains the role of Internet Service Providers (ISPs) and various connection methods. The core of the lecture is a detailed walkthrough of the Internet Explorer browser interface, including its layout, menu bar, toolbar, and address bar. Later sections cover protocols (HTTP, HTTPS, FTP), URL structure, search engines, and practical browser operations like changing the home page, using history, and accessing help.

📝 Lecture Summary

Introduction & Key Concepts

The World Wide Web (WWW) , introduced in 1991, is an application of the internet. It is a collection of online documents stored on computers connected to the internet, serving as the way to collect information. The Internet is the worldwide network of interconnected computers, including both web servers and user computers that run web browser software, sharing information like instant messaging and email.

A website is a way to get information on the internet and provides information related to any topic. It is a collection of web pages maintained by a single person or organization, with a distinct domain name like www.vu.edu.pk. A web page is a part of a website containing text, sound, images, and videos. A web server is a computer that runs websites and is connected to the internet, storing all web pages. The most common web server software is Apache, followed by Microsoft Internet Information Server.

A web browser is a program that lets you explore information on the WWW. Examples include Internet Explorer, Google Chrome, Mozilla Firefox, Opera, and Safari. All browsers browse web pages, but they provide different features like bookmarks and history.

ISP, How to connect internet

ISP stands for Internet Service Provider. An ISP is a company or organization that provides internet access to users for a fee. To connect to the internet, you need a computer, a modem, and a telephone line. Different connection methods include ISDN (a digital phone line with faster data transfer than a modem), TV Cable, DSL, 3G, 4G, and WiFi.

First step with the web browser

To open Internet Explorer: Click Start < All Programs < Internet Explorer, click the icon from the desktop, or click the Internet Explorer icon in the Taskbar.

Basic layout and closing a web browser

All browsers contain a menu bar, title bar, address bar, toolbar, new tab button, status bar, and scroll bar. The basic components of Internet Explorer are:

• Title Bar: The most upper bar of the window. It contains buttons to minimize, restore, and close the window.
• New Tab: Makes it easier to manage having multiple pages open within the browser simultaneously.
• Menu Bar: Located after the address bar, it contains options like File, Edit, and View.
• Toolbar: The strip next to the menu bar, also called the standard toolbar, with buttons for important tasks. The purpose of icons is shown in a tool tip text when the mouse pointer hovers over them.
• Address Bar: Displays the URL of the open web page.
• Progress Bar: A standard Windows control that displays the percentage of completion of a process as a graphical bar.
• Browser Pan: The area in the middle of the screen showing text, hyperlinks, and graphics.

To close a browser: File < Close or press the cross button (X) on the title bar.

Protocol

Data is transferred from one computer to another through rules called protocols. Different protocols used on the internet include:

• HTTP: Stands for Hypertext Transfer Protocol. It is a protocol to transfer web pages from a web server to a web browser. Its purpose is to transfer pages containing hypertext links. Example: http://vu.edu.pk.
• HTTPS: Stands for Hypertext Transfer Protocol Secure. It provides safe communication between two computers.
• FTP: Stands for File Transfer Protocol. Used to access files from an FTP server, which stores different types of files. Some files require a password; anonymous FTP sites allow access without a password.

Understand makeup & structure of URL

IP addresses (e.g., 203.215.176.42) are hard to remember, so they are converted into character-based URLs using host masking. URL stands for Uniform Resource Locator, which is the "unique address" of a web page, also referred to informally as a "web address."

The structure of a URL (e.g., http://vu.edu.pk/cgi-bin/neomail.pl) has several parts:

1. Protocol: Tells the web browser what sort of server it will be talking to. In this example, the protocol is http.
2. Name: Tells about the organization it is associated with, like vu.edu.pk.
3. Path: The location of the particular web page on the web server. In this example, the path is /cgi-bin/neomail.pl.

8. Search Engines

Search engines are programs that search documents for specified keywords and return a list of documents where the keywords were found (e.g., Google, AltaVista). They use software called a spider to search documents on the internet. Indexing software extracts information from documents and stores it in a database. The database is then searched for documents matching the search word, and a web page with hypertext links is assembled.

How to change home page in web browser

The first page seen when starting Internet Explorer is called the home page or start page. To change it: Tools < Internet Options < General < Address.

Display web page in new window

To open a web page without closing another: File < New < Window.

Stop a web page from downloading

A web page can be stopped from opening by:

1. View < Stop
2. Clicking the Stop button.

Refresh a web page

Refresh means to view a web page with the latest changes. A page can be refreshed by:

1. Pressing the F5 key.
2. Clicking the Refresh button.
3. View < Refresh.

16. Display previously visited sites

The browser saves the addresses of visited sites in history. To view history: Press Ctrl+H or click the history icon on the browser toolbar.

Changing number of days in history list

To set how many days history is kept: Tools < Internet Options. Select the history section to change days.

Deleting single entry, clear list of history

To delete a single item: Right-click on the item and select Delete. To delete the entire history list: Tools < Internet Options and select the History section.

Help

To access help, click Help in the menu bar and choose Internet Explorer Help or press F1.

Modify Toolbar

Right-click on the toolbar and choose the desired option from the open list.

Change webpage view settings

Click View, choose Zoom, and then choose the desired zoom view value. Or press Ctrl + to zoom in and Ctrl – to zoom out.

Change webpage text size

Click View, choose Text size, and then choose the desired text view option.

⭐ Key Takeaways

The internet is a global network, while the World Wide Web is a service for accessing information via web pages stored on servers. Web browsers interpret protocols like HTTP to display content, and their components (address bar, toolbar, etc.) allow for navigation and customization. Understanding URLs, which are structured with a protocol, domain name, and path, is fundamental for locating resources. Practical skills like changing the home page, managing history, refreshing content, and using bookmarks are essential for efficient browsing. Finally, being able to manage browser settings such as zoom, text size, and toolbars enhances the user experience.

🧠 Quick Revision Questions

1. What is the difference between the Internet and the World Wide Web?
2. What does the address bar in a web browser display, and what are the three main parts of a URL?
3. What is the purpose of the HTTP protocol and how is it different from HTTPS?
4. Describe two different ways to stop a web page from downloading and two ways to refresh it.
5. How can you view your browsing history in Internet Explorer, and how can you change the number of days it is kept?

📘 Lecture 28 — Web Navigation

📖 Overview: This lecture covers the fundamentals of web navigation, including how to open websites, use hyperlinks, manage bookmarks, and save web content. It is essential for understanding how to efficiently browse the internet and organize frequently visited sites for easy access.

🗂️ Topics Covered

This lecture explains how to open a website by typing a URL in the address bar, navigate backward and forward using browser buttons or keyboard shortcuts, activate hypertext and hypermedia links, bookmark web pages, create and organize bookmark folders, delete bookmarks, copy text, images, and URLs from web pages, save web pages and graphics to a hard disk, download files, and print web pages.

📝 Lecture Summary

Opening a website

To visit any website, we must know its URL (Uniform Resource Locator). The URL is typed into the address bar of the browser.

Navigating backward and forward in a web page

• To move backward: Click the Backward button
• To move forward: Click the Forward button
• To go to the home page: Click the Home button
• Click View → Go to and select any visited website
• You can also navigate using keyboard shortcuts: ALT+LEFT (backward) and ALT+RIGHT (forward)

Hypertext Links

Hypertext is text that links to other information. When you click on a hypertext link with the mouse, it is activated and moves you to the next page. Some links bring you to download a file, broadcast TV, or radio.

Hypermedia Links

Hypermedia links include:

• Picture
• Graphics
• Audio
• Video

Hyperlink Shape: Clicking on any hyperlink will change the mouse pointer into a hand shape.

Methods to open link

Some links open in the same window, while others open in a different window.

To open a link in a new tab:

1. Right-click on the link
2. Select Open in new tab

To open a link in another window:

1. Right-click on the link
2. Select Open in new window

Book mark a web page

When you visit a site and like it, you can save it. Saving a site means you are making a bookmark — putting a mark on the site so you can open it again. You can create a list of sites you like. Some browsers call it Bookmark, and some call it Favorite.

Methods to add a site to favorites:

1. Click the Favorite button from the toolbar
2. Click Favorite → Add to favorites

Creating a book mark folder and add page in it

When the list of favorites grows long, you can shorten it by creating folders and organizing them.

To organize favorites:

1. Click Favorite → Organize Favorite
2. A dialog box will open. Click on New Folder. This will create a folder.

To add a page to this folder:

1. Click Favorite → Add to Favorite
2. A dialog box will open. Select the folder from the Create in option.
3. Add the page to it.

Delete a book mark

You can delete web pages or folders from the favorites list.

To delete a folder:

1. Click Favorite → Organize favorites
2. Select the folder/page
3. Click the Delete button to delete it.

Display book marked page on toolbar

To display favorites in the toolbar as shortcuts:

1. Click View → Toolbar → Favorites Bar

Viewing favorite list on screen

You can also see favorite items on the left side of the screen.

To view favorites on the left side:

1. Click the Favorites Star Button from the right side of the toolbar.
2. Click the button from the explorer bar.

Copy a text from a web page to a document

Duplicate means to copy the same data to a different location. You can copy or duplicate any text or image data.

To copy data:

1. Select the data
2. Click Edit → Copy or press Ctrl+C

To paste data:

1. Select the target location
2. Click Edit → Paste or press Ctrl+V

Copy image from web page to a document

To copy an image:

1. Select the image
2. Click Edit → Copy or press Ctrl+C

To paste the image:

1. Select the target location
2. Click Edit → Paste or press Ctrl+V

Copy URL from web page to a document

You can also copy a URL from the browser to a document.

To copy URL:

1. Select the URL from the browser
2. Click Edit → Copy or press Ctrl+C

To paste URL:

1. Select the target location
2. Click Edit → Paste or press Ctrl+V

Save a web page on hard disk

You can save a web page on the hard disk. You can then open the web page data without connecting to the internet.

To save a web page on hard disk:

1. Click File → Save As
2. Select the target location on the disk

Save a graphic

You can save a graphic as a file.

To save a graphic:

1. Right-click on the graphic
2. Select Save Picture As option
3. Select the target location and enter the name of the graphic

Download text file, image

Downloading is the process of transferring a file from a remote computer to the user's computer.

To download a file:

1. Select the file
2. Right-click on the file
3. Select Save Target As

You can also save an image in the same way as a file.

Printing web page

To print a web page:

1. Click File → Print

⭐ Key Takeaways

Students must remember that URLs are typed in the address bar and hyperlinks change the mouse cursor to a hand shape. Navigation can be done using browser buttons or keyboard shortcuts like ALT+LEFT/RIGHT. Bookmarks (or Favorites) are used to save frequently visited sites, and they can be organized into folders for better management. All web content, including text, images, and URLs, can be copied using Ctrl+C and pasted using Ctrl+V, and entire web pages can be saved to the hard drive for offline viewing using File > Save As.

🧠 Quick Revision Questions

1. What keyboard shortcut is used to navigate backward in a web page?
2. How does the mouse pointer change when it hovers over a hyperlink?
3. What are the two different names browsers use for bookmarked web pages?
4. What is the process called when transferring a file from a remote computer to your own computer?
5. Which menu option is used to save an entire web page to your hard disk?

I cannot summarize this lecture using the provided format because it does not contain the required “Lecture 29” header or an exact lecture title formatted as “Lecture [N] — [Exact Lecture Title]”. The text you provided is from a module titled “Computer Proficiency License (CS001) – Module 06 – Search Engines,” but there is no indication that this is specifically “Lecture 29.” The instruction explicitly states: “The exact lecture title appears on the first page of the text below — extract it and use it in the heading.” Since the first page of the text you provided does not contain a lecture number (e.g., “Lecture 29”) or a lecture-specific title, I am unable to comply with the strict output format requirement. To proceed, please supply a version of the lecture text that includes a clear lecture number and title (e.g., “Lecture 29 — Search Engines” or similar).

📘 Lecture 30 — Email Application

📖 Overview: This lecture provides a comprehensive guide to using email applications, focusing on Microsoft Outlook. It covers everything from initial account configuration to daily tasks like reading, writing, and managing emails, making it essential for anyone needing to use email professionally.

🗂️ Topics Covered

This lecture introduces the concept of an email application, specifically Microsoft Outlook. It details the steps for initial Outlook setup, explains the layout of the application interface, and provides a step-by-step guide for configuring an email account manually. The lecture then covers core email operations including reading, writing, responding to, and organizing messages, as well as advanced features like email signatures, file attachments, spelling checks, and email search.

📝 Lecture Summary

Email Application

An application used to send or receive email is called an email application. Examples include Microsoft Outlook, IncrediMail, and Windows Live Mail.

Using Microsoft Outlook

To open Microsoft Outlook: Click the Start button, then All Programs, then Microsoft Office, and finally Microsoft Outlook. Upon first launch, a setup wizard appears. Click Next, select No, then select Check Continue with no email support, and click Finish to proceed without configuring an email account immediately.

Microsoft Outlook Layout

The main Outlook window consists of several key areas:

• Navigation Pane: Used to switch between different modules like Mail, Calendar, and Contacts.
• Content Area: Displays the list of items (e.g., email messages) in the selected folder.
• Reading Pane: A preview area to view the content of a selected email message without opening it in a new window.
• Ribbon: The main toolbar at the top, containing tabs (e.g., Home, Send/Receive) with commands for various tasks.

Email Account Setting

To set up an email account in Outlook:

1. Click the File tab.
2. Click Account Settings, then click Account Settings again.
3. In the dialog box, click New.
4. Select Manually configure server settings or additional server types and click Next.
5. Choose Internet Email and click Next.
6. Fill the form with your email server information (e.g., your name, email address, account type, incoming and outgoing mail server names).
7. Click More Settings to configure outgoing server authentication and connection security settings.
8. Fill the form as shown in the figure (typically setting the outgoing server to require authentication and using the same settings as the incoming server).
9. Press Ok, then click Test Account Settings to verify the setup.
10. If the test is successful, click Next, then Finish.

Email Application Inbox

• To view your inbox, click Inbox in the Navigation Pane.
• To receive new messages, click the Send and Receive button in the Home ribbon.

Reading a Message

• Click on Inbox in the Navigation Pane.
• Click on an email message in the Content Area to view it in the Reading Pane.
• To open it in a separate window, simply double-click the message.

Mark Message as Read/Unread

Messages which we have read are called read messages, and messages which we have not read are called unread messages.

• To make a selected message as read: Right-click the message and select Mark as Read.
• If you right-click a folder and select Mark All as Read, all messages within that folder are marked as read.

Writing Email

1. Click the New Email button in the Home tab.
2. Write the recipient's email address in the To field.
3. Write a brief description of the email's subject in the Subject field.
4. Write your message in the text area.
5. Click Send to deliver the email.

Responding to an Email Message

1. Click the email message you want to respond to.
2. Click Reply (to reply only to the sender) or Reply All (to reply to the sender and all other recipients) in the Home tab.
3. Write your reply in the new window.
4. Click Send.

• To check emails you have sent, click Sent Items in the Navigation Pane.

Copy and Paste Email Text

1. Select the text you want to copy from the Reading Pane.
2. Right-click and click Copy (or press Ctrl+C).
3. Click New Email.
4. Right-click in the message area and click Paste (or press Ctrl+V).

Cut and Paste Email Text

1. Select the text you want to cut from the Reading Pane.
2. Right-click and click Cut (or press Ctrl+X).
3. Click New Email.
4. Right-click in the message area and click Paste (or press Ctrl+V).

Email Signature Setting

An email signature is a block of text automatically added to the end of an outgoing email, often containing your contact details. To create a signature:

1. Click New Email.
2. Click the Signature button in the Message tab (within the new email window), and select Signatures....
3. Click New, type a name for the signature (e.g., "CPL"), and click OK.
4. Write the details you want in the Edit Signature box.
5. Click OK to save.

Insert Signature in Email Message

1. Click New Email.
2. Click inside the email message area.
3. Click the Signature button in the Message tab.
4. Select the signature name (e.g., "CPL") you created.

Proof Reading

Proof reading means to check and remove spelling and grammar mistakes from your email messages.

1. Open the message in its own window.
2. Click the Review tab.
3. Click Spelling & Grammar.

Download File Attached in Email

A file can be sent and received through email.

1. Click the received email.
2. Right-click the attached file name (shown in the message header or below the subject).
3. Click Save As.
4. Choose a location on your computer and click Save.

Attach File with Email

A text, image, audio, or video file can be sent through email using the attachment feature.

1. Click New Email.
2. Click Attach File in the Message tab.
3. Locate the file on your computer and click Insert.

Search Email Message

To find any relevant email, write relevant keywords (e.g., the sender's name, subject, or words from the message body) in the search box available in the Content Area.

⭐ Key Takeaways

An email application like Microsoft Outlook is essential for managing digital correspondence. Key skills include configuring an email account manually using server settings, navigating the Outlook interface (Navigation Pane, Content Area, Reading Pane, Ribbon), and performing core tasks like reading, writing, replying to, and forwarding emails. Students must also master organizing emails by marking them as read/unread, creating and using email signatures for professionalism, and handling file attachments for both sending and receiving. Finally, the ability to proofread messages and use the search function are crucial for effective and accurate communication.

🧠 Quick Revision Questions

1. What are the four main areas of the Microsoft Outlook interface?
2. Describe the steps to manually configure an email account in Microsoft Outlook.
3. What is the difference between the "Reply" and "Reply All" buttons?
4. How do you create an email signature and then insert it into a new email?
5. Explain the process for saving an attached file from an email you have received.

📘 Lecture 31 — Electronic Mail

📖 Overview: This lecture introduces electronic mail (email) as a modern communication method. It explains how email works, the structure of email addresses, the protocols involved (SMTP and POP3), and provides practical steps for creating and using an email account.

🗂️ Topics Covered

The lecture covers the definition of email and its advantages over traditional letters, introduces famous email clients like Gmail, Hotmail, and Yahoo, explains email protocols SMTP and POP3, details how email works step-by-step, describes the structure of an email address, and provides a step-by-step guide to creating and using a Yahoo email account including reading, composing, and closing messages.

📝 Lecture Summary

Concepts

Email is an abbreviation of electronic mail. With the help of email we can exchange information around the world. The only difference between email and other letters is that email is written through a keyboard and sent through the internet while a letter is written by hand and sent through the post office. It is the fastest way of communication compared to letters and it can be sent at any time when it is convenient.

Famous Email Client

Famous email clients include Gmail, Hotmail, and Yahoo email.
SMTP stands for Simple Mail Transfer Protocol and is used to send and receive email messages.
POP3 stands for Post Office Protocol and is used to receive email messages. An email client interacts with the POP3 server to discover and download new email messages.

3. How email works

First you compose a mail and send it. The message is sent to your internet service provider's email server. The message is then stored in the recipient's electronic mailbox. To read the message, log on to the email server and retrieve the message. To read the message, first you have to enter your password.

4. Email system using email client SMTP and POP3

Steps to send email messages:

1. Message is prepared using an email client.
2. Email client sends it to the SMTP server. If the receiver is local, the mail goes to POP3.
3. Receiver computer picks it at his/her computer.
4. If mail is sent to SMTP, the SMTP server sends it to the local computer's POP3 and the receiver receives it.

💡 Why this matters: Understanding the flow of SMTP and POP3 protocols is essential for troubleshooting email delivery issues and for configuring email clients correctly.

Understanding the structure of email address

Whenever we send any mail we should know the address of the recipient.
🔑 Definition — Email Address Structure: An email address consists of two parts separated by the "@" symbol. The first part identifies the name of the user account and the second part contains the URL of the person's account on the internet.
📐 Formula: username@domain.com → The "username" identifies the specific user, the "@" symbol separates the user from the domain, and the "domain" (e.g., yahoo.com) identifies the email service provider.
📌 Example: In the email address awais@yahoo.com, "awais" is the user account name and "yahoo.com" is the URL of the person's account on the internet.

Layout of email application

Any email program contains components to write, send, and receive email messages.

Create an email account

To use an email program it is important to have an email account.
To create an account on Yahoo:

1. Type www.mail.yahoo.com in the browser.
2. Click on Create account.
3. Fill in the form by entering a user name and password and more details.

Open a mail box for specific user

You can open the email account which you have created before by entering your user name and password. Enter your user name and password and click Sign In.

Open one and several messages

Whenever we receive any email, it goes to our Inbox. We can read and write mail here.
To read a mail:

• Click on Inbox.
• Click on any message to read it.

To compose a mail:

• Click on Compose.
• Write and send the mail.

Close a mail message

To close a mail message:

• Click on the Close (X) button of the window.

⭐ Key Takeaways

Email (electronic mail) is the fastest modern method for exchanging written information over the internet, replacing traditional postal letters. The core protocols are SMTP for sending messages and POP3 for receiving and storing them locally. Every email address follows the structure username@domain.com, where the "@" symbol is critical. To use email, one must first create an account on a service like Yahoo by filling a registration form, then sign in with user name and password to access the Inbox for reading and composing emails.

🧠 Quick Revision Questions

1. What does the abbreviation "SMTP" stand for, and what is its primary function in email communication?
2. What is the structure of an email address, and what does each part (separated by the "@" symbol) represent?
3. List the four steps involved in sending an email message using an email client with SMTP and POP3 protocols.
4. Describe the step-by-step process to create a new email account on Yahoo.
5. How do you read an email message that has arrived in your Inbox?

📘 Lecture 32 — Mail Management

📖 Overview: This lecture teaches how to manage email effectively by organizing messages, contacts, and folders. It covers creating and managing address books, sorting and flagging messages, and handling deleted items. These skills help users maintain a clean and efficient inbox.

🗂️ Topics Covered

The lecture covers creating an address book in an email program, adding and deleting contacts, and creating contact groups. It also explains how to create folders for organizing messages, move messages between folders, sort messages by date/subject/sender, and set message importance with tagging and flags. Finally, it covers deleting, undeleting, and emptying deleted items.

📝 Lecture Summary

Managing email

When you receive many email messages, your inbox or sent folder becomes overloaded. As a good practice, these should be managed. To manage your email, you can follow these options:

1. Create new folders for messages
2. Save your messages in hard disk
3. Delete unwanted or read messages

Create an address book

In real life, you can use a diary to record the name and address of your friend. It is good to use a diary to remember the details of your friends, but it is difficult to remember many email addresses. Email program makes life easy by providing a facility to record email IDs of all contacts in an address book. You can save name, phone number, email IDs, and some related information in an address book. The address book works like a diary.

🔑 Definition — Address Book: A digital directory in an email program where you can save names, phone numbers, email IDs, and other related information of your contacts, functioning like a diary.

Add a mail address to address list

1. Click on the New Item in the Home tab
2. Click Contact
3. A new window will open. Enter name and email ID of the contact and click on Save and Close button below the menu bar.

Contact Group is like a sub-address book which contains email addresses of a specific group of people. For example, Friend Group, Sales Group, and Purchase Group, etc.

Creating Contact Group

1. Click Contact from the Navigation pane
2. Click New contact group
3. Write Group name
4. Click Add Members
5. Choose the required option

Delete a mail address to address list

The way we have added the contact in the address book, we can delete the contact with a few clicks.

1. Select the email contact(s) from the address book by single click.
2. Click on the Remove member button or right-click on the contact name and select Delete from the drop-down menu.
3. Contact(s) will be deleted.
4. To delete the complete address book, click the Delete group button.

Create a folder

It is good to organize messages in different folders. Email programs usually save messages in separate folders. You can create as many folders as you want. To create a new folder:

1. Go to Folder Tab
2. Click New Folder
3. Enter the name of the new folder
4. Write the name of the folder and specify the location.

Move messages to folder

To save a message in a new folder:

1. Select the message in the inbox
2. Right-click on the message
3. Choose Move
4. Click the other folder where you want to move the message and click on the OK button.

Sort messages

We can sort email messages by date, subject, and sender name. Let us sort these messages by date wise. Steps:

1. Open inbox
2. Click Arrange by in the content area
3. Choose any option to sort by your choice

Message Tagging

Step:

1. Click New Message
2. Click High / Low Importance in the Message tab

📌 Example: After composing a new email, you can click on "High Importance" in the Message tab to tag the message as urgent or important for the recipient.

Flag mail message

After reading the mail, you have two options. Some mails are replied to urgently and some are replied to later. It is possible we forget to reply to some urgent messages, so for this reason, the flag feature is introduced. To apply a flag on the message of the inbox folder:

1. Select a message
2. Click on Follow Up in the Home tab To remove a flag:
3. Right-click on the message
4. Select Clear Flag Option

📌 Example: If you receive an email that requires a response by tomorrow, you can flag it using "Follow Up" so you don't forget to reply on time.

Delete a message

You can easily remove any message. Right-click on the message you want to delete from the inbox and select Delete from the menu. The email message will be deleted from the inbox right away and sent to the folder "Deleted items".

Undelete a message from Deleted Items

You may delete an important message. When you delete a message, it is moved from the inbox to the Deleted items folder. Open the "Deleted items" folder and right-click on the message you want to undelete. Select "Move to folder" option and select Inbox.

💡 Why this matters: The "Deleted Items" folder acts as a safety net. If you accidentally delete an important email, you can recover it by moving it back to the inbox instead of losing it permanently.

⭐ Key Takeaways

The most critical things to remember are: how to create and manage an address book (including adding, deleting contacts, and creating contact groups), how to create folders and move messages between them for organization, and how to sort messages by date/subject/sender. You should also know how to tag messages with high/low importance and use flags to mark urgent emails for follow-up. Finally, remember that deleted messages go to the "Deleted items" folder and can be undeleted by moving them back to the inbox.

🧠 Quick Revision Questions

1. What is the purpose of a Contact Group in an email address book?
2. List the steps to create a new folder in an email program.
3. How can you sort email messages in your inbox?
4. What is the difference between "Message Tagging" (High/Low Importance) and "Flag mail message"?
5. After deleting a message, where does it go, and how can you recover it?