Computer Proficiency License (CPL) CS001 book HANDOUTS in pdf

<b><span style="font-size: large;">Computer Proficiency License (CPL) CS001  book HANDOUTS in pdf</span></b><br /><br />Handouts | Lectures | Contents | Books<div> <br /></div> <div> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEicMaP2Bu9LCUiThioUhfh5ZSIOiDP1aeG-XIkWSVrSmdyDdJhT8-vrZG1LldTi_9T0OJ44e12qqMRyJWVqP93tNCe6aTG3wzRf-5HTLKtJLiWNfeRGQahD8DV7LZPhSmrwVTROBEV1exA/s1600/hqdefault.jpg" imageanchor="1"><img border="0" height="480" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEicMaP2Bu9LCUiThioUhfh5ZSIOiDP1aeG-XIkWSVrSmdyDdJhT8-vrZG1LldTi_9T0OJ44e12qqMRyJWVqP93tNCe6aTG3wzRf-5HTLKtJLiWNfeRGQahD8DV7LZPhSmrwVTROBEV1exA/s640/hqdefault.jpg" width="640" /></a></div> <div> <br /></div> <div> <div> Computer Proficiency License (CS001) VU</div> <div> Computer Proficiency License (CS001)</div> <div> Virtual University of Pakistan</div> <div> Virtual University of Pakistan</div> <div> 1</div> <div> Computer Proficiency License (CS001) VU</div> <div> Computer Proficiency License</div> <div> Rector</div> <div> Dr. Naveed Akhtar Malik</div> <div> Project Supervisor</div> <div> Asst. Prof Saba Khalil Toor</div> <div> Handouts Compiled by</div> <div> Afia Mufti</div> <div> Syeda. Mariyam Bukhari</div> <div> Virtual University of Pakistan</div> <div> 2</div> <div> Computer Proficiency License (CS001) VU</div> <div> Virtual University of Pakistan</div> <div> 3</div> <div> Computer Proficiency License (CS-001)</div> <div> Table of contents</div> <div> Lecture # Lecture Title Page #</div> <div> Module 1</div> <div> 1 Introduction to Training Environment & Computing 5</div> <div> 2 Input 10</div> <div> 3 Input Devices 13</div> <div> 4 Output 15</div> <div> 5 Storage 18</div> <div> 6 Hardware 21</div> <div> 7 Software 23</div> <div> 8 Internet 25</div> <div> 9 Security 27</div> <div> Module 2</div> <div> 10 Computer Environment 29</div> <div> 11 System Properties 31</div> <div> 12 Desktop 33</div> <div> 13 Organizing Files 36</div> <div> 14 Introduction to Text Editing 39</div> <div> 15 Working with Text Editor 40</div> <div> 16 Closing an Application 42</div> <div> 17 Saving files on Floppy 43</div> <div> 18 Print Management 44</div> <div> Module 3</div> <div> 19 Basic concepts of word processing 47</div> <div> 20 Introduction of MS word 51</div> <div> 21 Text formatting 55</div> <div> 22 Tables 59</div> <div> 23 Mail Merge 62</div> <div> 24 Preparing Output 65</div> <div> Module 4</div> <div> 25 Basic concepts of MS Excel 68</div> <div> 26 Introduction of Excel Sheets 72</div> <div> 27 Working with Cells 75</div> <div> 28 Worksheets 79</div> <div> 29 Formulas and Functions 83</div> <div> 30 Formatting 87</div> <div> 31 Charts and Graphs 92</div> <div> 32 Prepare Output 97</div> <div> 33 Advance Topics 101</div> <div> Module 5</div> <div> 34 Introduction of Power Point 104</div> <div> 35 Developing a Presentation 108</div> <div> 36 Formatting 112</div> <div> 37 Charts and Objects 116</div> <div> 38 Animations 120</div> <div> 39 Printing a Presentation 123</div> <div> Computer Proficiency License (CS001) VU</div> <div> Virtual University of Pakistan</div> <div> 4</div> <div> Important Note:</div> <div> This handout is a supplementary material for the course of Computer Proficiency License</div> <div> (cs001). It is meant to be used along with the DVDs/CDs provided by Virtual University of</div> <div> Pakistan. To get the full benefit of the knowledge imparted in this course, it is mandatory for you</div> <div> to go through the modules and perform the hands-on as well as other exercises and solve pre and</div> <div> post assessment questions.</div> <div> Module 6</div> <div> 40 Internet 126</div> <div> 41 Web Navigation 132</div> <div> 42 Search Engines 136</div> <div> 43 Email 140</div> <div> 44 Messaging 144</div> <div> 45 Mail Management 148</div> <div> Computer Proficiency License (CS001) VU</div> <div> Computer Proficiency License (CS-001)</div> <div> Lecture 01</div> <div> Introduction to Training Environment & Computer Basics</div> <div> 1. Introduction</div> <div> CPL stands for Computer Proficiency License, also known as VU-CPL. It is a computer based</div> <div> training course offered to all who are interested in learning of the usage of computer applications,</div> <div> after going through this course you will become comfortable and confident about computer usage.</div> <div> You can become proficient in the knowledge of computer utilization by using DVDs/CDs that are</div> <div> designed specifically for this course. It has six modules.</div> <div> Module 1 – Introduction to Computers</div> <div> Module 2 – Using the computer and managing files</div> <div> Module 3 – Word processing</div> <div> Module 4 – Spread sheets</div> <div> Module 5 – Presentation</div> <div> Module 6 – Information and communication</div> <div> 2. Objectives</div> <div> The objective of the above mentioned six modules is to provide sufficient knowledge about the</div> <div> computer and its utilization for you to perform your daily computer related tasks .with ease and</div> <div> confidence.</div> <div> 3. Training Environment of CPL</div> <div> Software being installed for this course has its own training environment. It is divided into different</div> <div> parts for understanding and ease of use. Details of these areas are explained as under.</div> <div> 1- Table of contents/Index area</div> <div> Left side of the screen is called table of contents or index area where you will find lesson names</div> <div> and subsections. You can browse these subsections using spacebar. To go back to previous</div> <div> lesson use “backspace” key where as to repeat the same lesson, “enter” key is used.</div> <div> 2- Instruction area</div> <div> The center-bottom bar is used for instructions during the lesson.</div> <div> 3- Subtitle of lesson and duration</div> <div> The top-center area is used for subtitle of lesson with its running duration in minutes.</div> <div> 4- Module Number</div> <div> Module number is written at the top-right corner. For example, if you are using module 3: Word</div> <div> processing then the module number displayed will be ‘3’</div> <div> 5- About, help and exit buttons</div> <div> At the left-bottom corner you will see three buttons.</div> <div> Virtual University of Pakistan</div> <div> 5</div> <div> Computer Proficiency License (CS001) VU</div> <div> About button shows the some basic information about the VU-CPL. Help button will open a new</div> <div> screen with instructions to run the modules. You can close the module by clicking at the exit</div> <div> button.</div> <div> 6- Lesson presentation area or lesson screen</div> <div> This is center area, where lessons contents, such as, text, animation and graphics is displayed.</div> <div> 4. What is computer?</div> <div> Computer is an electronic device that takes data, instructions and information as input and</div> <div> produce output (information) after processing it.</div> <div> It is a machine that process thousands of instructions in less than a second and produces outputs</div> <div> as instructed or programmed.</div> <div> 5. Advantages of computers</div> <div> 1- Efficiency</div> <div> Machines are more efficient than humans. They can perform millions of calculations with less</div> <div> effort in no time.</div> <div> 2- Reliability</div> <div> Work done by computer is more reliable than one done by humans. Computers perform</div> <div> according to the instructions given to it that makes output or results produced by these more</div> <div> accurate and reliable. For example, a computer can do millions of error free calculation in less</div> <div> than a second.</div> <div> 3- Storage</div> <div> Computers give you an advantage of storing large amount of data in one place. For example you</div> <div> can store the data of whole library in one computer.</div> <div> 4- Fast results</div> <div> Computers are capable of doing many difficult tasks in very short time. Everyday the processing</div> <div> speed of computers is increasing to make them work faster. Latest computers are capable of</div> <div> performing thousands of instructions and calculation in less than a minute which used to take</div> <div> hours with old PCs.</div> <div> 6. Basic terms for computer</div> <div> Input</div> <div> Whatever goes into the computer is called input. For example text, graphic sounds etc. In every</div> <div> day life the example for input is a voting slip in a ballot.</div> <div> Input Devices</div> <div> An input device is any peripheral (piece of computer hardware equipment) used to provide data</div> <div> and instruction to computer, for example keyboard and microphone. Every day life example is a</div> <div> hand that is used to put the voting slip in a ballot box. Thus hand is input device for ballot box.</div> <div> Virtual University of Pakistan</div> <div> 6</div> <div> Computer Proficiency License (CS001) VU</div> <div> Output</div> <div> Anything that comes out of a computer is called output. For example sound of a playing video in</div> <div> computer is the output.</div> <div> Output Devices</div> <div> An output device is a hardware used to get the output from the computer. For example head</div> <div> phones are output device and used for listening sound in computer.</div> <div> Processing</div> <div> Computer is given the data and instruction as input, which is processed to create output in the</div> <div> form of information. Data is a raw form of symbols, numbers, images etc, whereas information is</div> <div> an organized, meaningful and useful form of the data.</div> <div> For example, some data (student roll number, name, total marks, obtained marks etc) from the</div> <div> mid exam is entered. Computer process the data, and creates a report of pass and fail students.</div> <div> This report is more organized and useful for us, and thus information rather than just data.</div> <div> Storage</div> <div> Storage, also referred as memory, is the ability of computer to store data, information or</div> <div> instructions. It can save digital data on RAM, hard disks or removable memory.</div> <div> Storage Devices</div> <div> Storage devices are used to store data when they are not being used in memory. The most</div> <div> common types are floppy disks, hard disks and CD-ROM and DVD.</div> <div> Hardware</div> <div> Hardware refers to the physical elements of a computer. Examples of hardware in a computer are</div> <div> the keyboard, the monitor, the mouse and the processing unit.</div> <div> In contrast to software, hardware is a physical entity, while software is a non-physical entity.</div> <div> Hardware and software are interconnected, without software; the hardware of a computer would</div> <div> have no function.</div> <div> Software</div> <div> How does computer use its hardware?</div> <div> The term software refers to programs or sets of instructions that the computer uses to perform</div> <div> computer operations. Software can also be described as a collection of routines, rules and</div> <div> symbolic languages that direct the functioning of the hardware. Software is capable of performing</div> <div> specific tasks, as opposed to hardware which only perform mechanical tasks what they are</div> <div> mechanically designed for.</div> <div> We can think or write instructions, but can not touch them.</div> <div> Characteristics of software</div> <div> Software is intangible (you can not hold it like hardware).</div> <div> It is weightless.</div> <div> It does not exist as hardware.</div> <div> Virtual University of Pakistan</div> <div> 7</div> <div> Computer Proficiency License (CS001) VU</div> <div> Software is use to operate the computer.</div> <div> 7. Types of Computers</div> <div> There are five basic types of computers.</div> <div> Super Computers</div> <div> Are the fastest computers, and because of their speed and memory, are capable of performing</div> <div> operations that would not be practical for PCs or mainframes.</div> <div> Advantages of super computers</div> <div> High speed</div> <div> Most Accurate</div> <div> Most Expensive</div> <div> Examples</div> <div> Cray, ASCII white, Earth simulator etc</div> <div> Mainframe Computers</div> <div> Mainframes are computers where all the processing is done centrally, and the user terminals are</div> <div> called "dumb terminals" since they only input and output (and do not process).</div> <div> Mainframes are computers used mainly by large organizations for critical applications, typically</div> <div> bulk data processing such as census. Examples: banks, airlines, insurance companies, and</div> <div> colleges.</div> <div> Examples</div> <div> PTC, PIA, Banks and other organizations in Pakistan use main frame computers</div> <div> Mini Computers</div> <div> These are powerful, expensive, comparatively less speed computers than mainframes, that are</div> <div> made for more complex procedures and are intended for one user at a time. Some of the</div> <div> complex procedures consist of science, math and engineering calculations and are useful for</div> <div> computer design and manufacturing.</div> <div> Personal Computers</div> <div> PC is an abbreviation for a Personal Computer, it is also known as a Microcomputer. Its physical</div> <div> characteristics and low cost are appealing and useful for its users. Throughout the 1970s and</div> <div> 1980s, home computers were developed for household use, offering some personal productivity,</div> <div> programming and games, while somewhat larger and more expensive systems (although still lowcost</div> <div> compared with minicomputers and mainframes) were aimed for office and small business</div> <div> use.</div> <div> Portable Computers</div> <div> A portable computer is a small personal computer designed for mobile use. A portable computer</div> <div> integrates all of the typical components of a desktop computer, including a display, a keyboard, a</div> <div> pointing device (a touchpad, also known as a track pad, or a pointing stick) and a battery into a</div> <div> single portable unit.</div> <div> Virtual University of Pakistan</div> <div> 8</div> <div> Computer Proficiency License (CS001) VU</div> <div> 8. Summary</div> <div> In this lecture we learnt:</div> <div> 􀁸 What is computer? How it is used in our daily life?</div> <div> 􀁸 Advantages of computer</div> <div> 􀁸 Basic computer terms e.g storage, output, input etc</div> <div> 􀁸 Types of computer</div> <div> 9. Exercise</div> <div> In our daily life there are many devices that act as either input device or output device. List any</div> <div> five such input and output devices from real life.</div> <div> Search the market and identify two input and output devices that use the input data into the</div> <div> computer and get the output from computer, other than one mentioned in this lesson.</div> <div> Virtual University of Pakistan</div> <div> 9</div> <div> Computer Proficiency License (CS001) VU</div> <div> Computer Proficiency License (CS-001)</div> <div> Lecture 02</div> <div> Input</div> <div> 1. Objectives</div> <div> The objective of this lecture is to provide answers to the following questions:</div> <div> 􀁸 What is a keyboard?</div> <div> 􀁸 What are different keys on keyboard?</div> <div> 􀁸 What is their functionality?</div> <div> 2. Keyboard</div> <div> It is an input device to give computer some input. It is like pen in writing. It is called keyboard</div> <div> because it is comprised of a board with keys installed. Every key send unique information to</div> <div> computer.</div> <div> 3. Keyboard types</div> <div> There are different types of keyboards. Standard keyboard is the most commonly used keyboard.</div> <div> Key arrangement can be different for these keyboards. Some may have special keys for other</div> <div> tasks than just typing. These special keyboards are usually used for multimedia purposes like</div> <div> video editing, sound design etc.</div> <div> 4. Basic Keyboard keys</div> <div> There are usually 104 keys on standard keyboard. Pressing the key once and releasing it is</div> <div> called a key stroke.</div> <div> Character keys</div> <div> These are used to enter alphabetic characters. These characters become uppercase when</div> <div> pressed with shift key or caps lock is on.</div> <div> Numeric keys</div> <div> There are 10 numbers or numeric keys (1, 2, 3 to 9 and 0) on standard keyboards. These are</div> <div> used in the same fashion as typewriters’ keyboard to enter numbers. These become symbols or</div> <div> punctuation marks when pressed with the shift key.</div> <div> For example</div> <div> 1- Shift + 8 will print *</div> <div> 2- Shift + 4 will print $</div> <div> Special keys</div> <div> Shift, Alt and Control(ctrl) keys are special keys and when pressed with other keys, perform</div> <div> special operations. For example ctrl+c will copy the selected file or text, shift+ character key will</div> <div> print that character in capital.</div> <div> Escape keys</div> <div> Virtual University of Pakistan</div> <div> 10</div> <div> Computer Proficiency License (CS001) VU</div> <div> It is used to escape/exit from certain type of applications.</div> <div> Function keys</div> <div> F1, F2, …. F12 are called function keys. These are used for different purposes. For example F5</div> <div> is used to refresh the web page in internet browser. F1 will open help window.</div> <div> Arrow keys</div> <div> There are four keys(arrow Keys) for cursor navigation.</div> <div> Left arrow key, Right arrow key</div> <div> Up arrow key, Down arrow key</div> <div> Numeric key pad</div> <div> On the right side, a separate area is reserved for numeric keys, mathematical operational keys(+</div> <div> , - , * , /) , enter, dot and Num Lock key.</div> <div> Space Bar</div> <div> It is horizontal wide key, in the lower most row. It generates space between two characters.</div> <div> Punctuation keys</div> <div> These are keys to enter punctuation and are located on the right side of alphabet keys.</div> <div> Enter key</div> <div> Enter or return key cause cursor to go to next line, form or window to perform its default function.</div> <div> Application key</div> <div> It launches the menu with the keyboard rather than the usual right mouse button.</div> <div> Toggle keys</div> <div> Caps lock, Num lock and Scroll lock keys are toggle keys. At the top right corner, there are three</div> <div> small lights to show the status of these locks. When pressed one, corresponding light is turned</div> <div> on.</div> <div> The keys on numeric key pad act as numbers and dot. When this key is pressed again and the</div> <div> corresponding num lock key light is switched off, the key act as arrow keys, home key, pg up, pg</div> <div> down and end keys.</div> <div> Characters become capital when the caps lock is on.</div> <div> Scroll key modifies the functionality of arrow keys. When the scroll lock is on, the arrows keys</div> <div> would scroll the window instead of moving the cursor.</div> <div> Print screen key</div> <div> It is the key which is used to save (capture) all the contents of the screen in a temporary area.</div> <div> Insert key</div> <div> Key use to insert or overwrite character(s) within a word is called insert key. The key acts as</div> <div> toggle key. If it is in the insert state than any character pressed while the cursor is placed within a</div> <div> Virtual University of Pakistan</div> <div> 11</div> <div> Computer Proficiency License (CS001) VU</div> <div> word gets inserted. If the key is pressed and it is in the overwrite state than any char pressed</div> <div> while the cursor is placed with get overwritten.</div> <div> Home key / End key</div> <div> It is used to go to start (home key) or end (end key) of the document.</div> <div> Page up key / Page down key</div> <div> It is used to go to previous (page up key) or next (page down key) page.</div> <div> Delete key</div> <div> The key used to delete characters.</div> <div> Backspace key</div> <div> The key used to delete the preceding characters.</div> <div> Special keys</div> <div> Alt, Ctrl and shift keys are non-typing keys. They don’t print anything when pressed. These when</div> <div> pressed with other keys, modify the usual operation of that key.</div> <div> For example Alt + F4 close the active window.</div> <div> Tab key</div> <div> Tab key is a typing key and used to put more than one space within characters or words.</div> <div> 5. Summary</div> <div> In this lecture we have learnt:</div> <div> 􀁸 What is keyboard? What is its use?</div> <div> 􀁸 Keyboard types</div> <div> 􀁸 Standard keyboard keys</div> <div> 􀁸 Character keys, Numeric keys, Bracket keys, Punctuation keys, Backspace key, Delete</div> <div> key, Tab key, Caps lock key, Num lock key, Scroll lock key, Insert key, Page up/down</div> <div> keys, Functional keys, Special keys</div> <div> 6. Exercise</div> <div> Practice the usage of character keys placed on the keyboard by writing</div> <div> A quick brown fox jumps over a lazy dog</div> <div> Write the names and numbers of all the functional keys on your keyboard.</div> <div> State the difference between typing and non-typing keys.</div> <div> Virtual University of Pakistan</div> <div> 12</div> <div> Computer Proficiency License (CS001) VU</div> <div> Computer Proficiency License (CS-001)</div> <div> Lecture 03</div> <div> Input Devices</div> <div> 1. Objectives</div> <div> The objective of this lecture is to provide the answers to the following question:</div> <div> 􀁸 What is a computer mouse?</div> <div> 􀁸 What are its different forms?</div> <div> 􀁸 Some other pointing devices than mouse</div> <div> 􀁸 Input devices for image, sound and video</div> <div> 2. Pointing devices</div> <div> Devices used to point things at the computer screen are called pointing devices. For example</div> <div> mouse, track pad etc</div> <div> Mouse</div> <div> Mouse is a pointing device that works by detecting motion relative to</div> <div> its supporting surface. Furthermore:</div> <div> There are many types of computer mouse available in the market.</div> <div> They usually have different shapes or buttons, but they work almost</div> <div> in the same fashion.</div> <div> Mouse Buttons</div> <div> There are two buttons on standard mouse</div> <div> 1- Right mouse button 2- Left mouse button</div> <div> Mouse Pad is a surface used to sense the mouse motion.</div> <div> Mouse Pointer/Arrow/Cursor shows the position and motion of mouse on screen.</div> <div> Track Pad</div> <div> Track pad (also known as touchpad) is a pointing device consisting of a sensitive surface that</div> <div> translates the motion of a user’s finger to a relative position on screen.</div> <div> Track Ball</div> <div> Trackball is a pointing device with a ball placed in a socket with</div> <div> sensors to detect the rotation of the ball in 2-D.</div> <div> 3. Other input devices</div> <div> Microphone</div> <div> Virtual University of Pakistan</div> <div> 13</div> <div> Computer Proficiency License (CS001) VU</div> <div> Microphone is used to input the sound to computer. It is used in motion pictures, radio and</div> <div> television broadcasting etc.</div> <div> Scanner</div> <div> Scanner is a device that scans images, papers etc to store them in computer for later use.</div> <div> Digital camera/Web cam</div> <div> These are input devices that input still images or video to computer.</div> <div> 4. Summary</div> <div> In this lecture we have learnt:</div> <div> 􀁸 What is computer mouse?</div> <div> 􀁸 How to do clicking, double clicking, right clicking and dragging with mouse?</div> <div> 􀁸 What is mouse pointer?</div> <div> 􀁸 Some other devices e.g track pad and track ball</div> <div> 􀁸 Input devices for image(Scanner), sound(Microphone), Video(Digital camera, webcam)</div> <div> 5. Exercise</div> <div> Survey the market and find four different models of microphone that are used to input the voice</div> <div> into computer. Write their names and numbers.</div> <div> What are the different devices through which we can input video to a computer?</div> <div> Virtual University of Pakistan</div> <div> 14</div> <div> Computer Proficiency License (CS001) VU</div> <div> Computer Proficiency License (CS-001)</div> <div> Lecture 04</div> <div> Output</div> <div> 1. Objectives</div> <div> The objective of this lecture is to provide the answers to the following questions:</div> <div> 􀁸 What is output?</div> <div> 􀁸 What are the types of output?</div> <div> 􀁸 What are the commonly used devices?</div> <div> 2. Computer Output</div> <div> It means taking something out from computer.</div> <div> 3. Types of Output</div> <div> In general computer output is of 2 types</div> <div> 1. Soft copy</div> <div> 2. Hard copy</div> <div> 4. Forms of Output</div> <div> Text, Image, Sound, Multimedia (2 or more forms are combined for example text, image, sound)</div> <div> 5. Output devices</div> <div> Printer – Print text or image being safe in computer on paper</div> <div> Monitor – Output display</div> <div> Speakers – Output sounds being played in computer</div> <div> Multimedia projectors – Output multimedia</div> <div> 6. Printer and its types</div> <div> Printer</div> <div> It is an output device that prints image or text being safe in computer. The output is hard copy.</div> <div> Types of printer</div> <div> 1- Dot matrix</div> <div> Dot is a spot of ink, whereas the matrix is a particular arrangement of dots.</div> <div> It works like a typewriter and consist of pins. A pin makes a dot and combination</div> <div> of dots forms characters and illustrations. Printing speed of a dot matrix printer is</div> <div> around 300 char/sec.</div> <div> Examples are Epson LQ 58 E, Microline 420</div> <div> 2- Line printer</div> <div> Virtual University of Pakistan</div> <div> 15</div> <div> Computer Proficiency License (CS001) VU</div> <div> It works like Dot matrix printer, just it prints a complete line at a time. It contains a</div> <div> chain of pins that helps to print an entire line. It is superior in speed and quality.</div> <div> Usually a line printer prints 200 lines/min.</div> <div> Examples are Tolly T6218, Printrox P5220</div> <div> 3- Laser printer</div> <div> It produces high quality graphics by using the same technology as in photocopy</div> <div> machine. It prints a complete page at a time and works like a photopier. It can</div> <div> print upto 6 pg/min. For printing laser printers use powder ink that is available in</div> <div> cartridge. These printers are quite expensive.</div> <div> Examples are HP laser jet 4300, Samsun ML 1710</div> <div> 4- Inkjet printer</div> <div> It has nosals which make dots to print. Inkjet printers are low in cost.</div> <div> For example Lex mark Z35 Color Inkjet printer, Epson stlys C82 Color inkjet</div> <div> printer</div> <div> 7. Monitors and its types</div> <div> Whatever is on screen is called display. Monitor is like TV and it output the softcopy of software</div> <div> and programs in computer. Like regular TV, it has some buttons as well that includes Power</div> <div> button and display adjustment buttons.</div> <div> Types of monitors</div> <div> 1- CRT monitors</div> <div> These are cathode ray tube monitors and commonly used for personal use.</div> <div> Examples are Philips Professional Brilliance 107P, Samsun syncmaster 551v</div> <div> 2- LCD monitors</div> <div> Liquid crystal is used for the screen which is also used in scientific calculator. It got</div> <div> advantage over CRT monitors due to look, lightweight and compact size. These can</div> <div> be adjusted in less space.</div> <div> Examples are Samsung Synmaster LCD, Sony LCD monitor</div> <div> 8. Speakers</div> <div> Different types of computer speakers are available in the market. These speakers work very</div> <div> much like regular speakers.</div> <div> Examples</div> <div> Yamaha 51</div> <div> Logitec z-640</div> <div> 9. Multimedia projectors</div> <div> Enlarge display and sound to have it on some screen. It works like a magnifying glass.</div> <div> Examples</div> <div> Epson Powerlite 8118</div> <div> Toshiba Digital Multimedia</div> <div> Virtual University of Pakistan</div> <div> 16</div> <div> Computer Proficiency License (CS001) VU</div> <div> 10. Summary</div> <div> In this lecture we have learnt:</div> <div> 􀁸 What are Computer Output and output devices?</div> <div> 􀁸 Types of output</div> <div> 􀁸 Commonly used device e.g Printer, Monitor, Speaker</div> <div> 11. Exercise</div> <div> Find out the different sized that are available for</div> <div> LCD monitor, CRT monitor</div> <div> Economical printer is which has less running expenses as compared to others. Figure out which</div> <div> printer type is more economical and write its name and model.</div> <div> What is meant by built in speaker?</div> <div> Virtual University of Pakistan</div> <div> 17</div> <div> Computer Proficiency License (CS001) VU</div> <div> Computer Proficiency License (CS-001)</div> <div> Lecture 05</div> <div> Storage</div> <div> 1. Objectives</div> <div> The objective of this lecture is to provide information about:</div> <div> 􀁸 Computer storage</div> <div> 􀁸 Types of storage</div> <div> 􀁸 Commonly used storage devices</div> <div> 2. Storage</div> <div> Process of storing information in computer is called storage. The devices used to store data are</div> <div> called storage devices.</div> <div> 3. Advantages of storages</div> <div> Information at different places can be saved in computer and can be re-used when needed.</div> <div> 4. Types of storage devices</div> <div> 1 -Primary storage devices</div> <div> 2- Secondary storage devices</div> <div> 4.1 Primary storage devices</div> <div> Storage devices which are installed at the mother board are called primary storage devise. It is</div> <div> also called memory.</div> <div> Types of primary storage</div> <div> There are two types of primary storage devices</div> <div> 1- ROM 2- RAM</div> <div> ROM</div> <div> ROM stands for read only memory. It is a storage device from which only stored information can</div> <div> be read. It can’t be modified, delete or removed. It is like something written on stone that can not</div> <div> be removed or changed once written. It is permanent storage devise and data remains safe on</div> <div> ROM even when computer is off.</div> <div> It contains information related to computer startup process which is written at the time of memory</div> <div> manufacturing. Computer cannot start without ROM.</div> <div> RAM</div> <div> RAM stands for random access memory. It is like something written on sand which is temporary</div> <div> and would be erased. It is temporary memory, also called volatile memory. RAM stores</div> <div> information which is currently processed by computer. When power off, it loses all the</div> <div> information. Data can be read, stored, modified or delete from the RAM.</div> <div> Size of storage</div> <div> Byte is the unit for measuring memory. 1 byte means 1 character</div> <div> Virtual University of Pakistan</div> <div> 18</div> <div> Computer Proficiency License (CS001) VU</div> <div> For example Pakistan is consisting of 8 bytes.</div> <div> Byte is small unit</div> <div> 1024 bytes = 1 kilo byte (kb)</div> <div> 1024 kilo bytes = 1 mega byte (mb)</div> <div> 1024 mega byte = 1 giga byte (gb)</div> <div> 4.2 Secondary storage devices</div> <div> Why is secondary storage devices needed?</div> <div> RAM stores info temporary, whereas we can’t store information on ROM. So we need some place</div> <div> to store information, even when computer is off. It is also called non-volatile storage devices. For</div> <div> example floppy disks, hard disks, compact disks, magnetic tape etc.</div> <div> Advantages of secondary storage devices</div> <div> 1- More data can be stored as compared to primary storage devices</div> <div> 2- Information remains there even if power is switched off.</div> <div> Types of secondary storage</div> <div> 1- Magnetic disks 2- Optical disks</div> <div> Magnetic disks</div> <div> Floppy disk and hard disks are considered in this category.</div> <div> Floppy disk</div> <div> Floppy means soft and disk means something flat and circular</div> <div> A floppy disk can store up to 144 MB of data.</div> <div> Data is stored in circular tracks.</div> <div> Floppy disk is covered by hard casing (shutter, magnetic, liner, shell, and notch)</div> <div> If notch is opened than floppy disk becomes write protected that means that can’t be written on</div> <div> the floppy disk and can only be read. You can write something about the content of floppy disk at</div> <div> the sticker attached at the casing. But use soft tip pen to avoid damage to the disk inside the</div> <div> casing. Floppy is light weight, low cost, commonly used and biggest advantage of floppy is</div> <div> portability. It must be used with care or information saved can be wasted. It should keep away</div> <div> from magnet to safe from damage. The disk should not place in high temperature areas.</div> <div> Floppy drive is used to read/write data on floppy disk.</div> <div> Hard disk</div> <div> It is made of hard material, sealed in casing. More than one hard disk can be sealed in a casing</div> <div> to increase the storage capacity in computer. Data is stored in circular form. Storage capacity of</div> <div> hard disk is very high and high volume of data can be stored here. Hard disk is more durable than</div> <div> floppy drive but it is not as portable as floppy. Don’t bring near magnets and should not place in</div> <div> high temperature area.</div> <div> Optical disks</div> <div> Virtual University of Pakistan</div> <div> 19</div> <div> Computer Proficiency License (CS001) VU</div> <div> It is called optical disk because laser beam is used to read and write the data. Diameter is 4.25</div> <div> inch whereas width is less than 1/20th of an inch. It is easily portable device.</div> <div> There are four types of optical disks</div> <div> 1- CD ROM</div> <div> CD stands for compact disk and ROM stands for read only memory. It is read only storage</div> <div> device, mostly used for audio, videos etc. 600 MB to 800 MB data can be stored. It is easy</div> <div> portable devices. CDs should not be scratched.</div> <div> 2- Write once read many(WORM)</div> <div> It acts as CDROM after data is written on it once. It is used to store data, information.</div> <div> 3- Re-writeable CDs</div> <div> CDs which can be read and write many times are called re-writeable CDs.</div> <div> 4- DVDs</div> <div> DVD stands for digital versatile disk. It was invented to store video only that is why previously</div> <div> it was called as digital video disk. Its capacity is much greater.</div> <div> DVD ROM – Data can be read from it, but can not be written, changed or deleted.</div> <div> DVD RAM – It works like re-writeable CDs. Data can be read, written, stored or removed</div> <div> from it. Storage capacity is huge from 4.7 GB to 9.4 GB. It is easily portable.</div> <div> 4.3 Other storage devices</div> <div> Magnetic tape</div> <div> It is like an audio cassette. Data is saved in line. Data saved first would be read first. It has huge</div> <div> storage capacity. Keep it away from magnet to save from damage.</div> <div> 5. Summary</div> <div> In this lecture we learnt about:</div> <div> 􀁸 Different storage devices (RAM, ROM)</div> <div> 􀁸 Magnetic devices (HD, FD)</div> <div> 􀁸 Optical devices (CDs. DVDs)</div> <div> Virtual University of Pakistan</div> <div> 20</div> <div> Computer Proficiency License (CS001) VU</div> <div> Computer Proficiency License (CS-001)</div> <div> Lecture 06</div> <div> Hardware</div> <div> 1. Objectives</div> <div> The objective of this lecture is to provide information about:</div> <div> 􀁸 Computer hardware</div> <div> 􀁸 Location where different hardware component are placed in computer</div> <div> 􀁸 Purpose of various hardware components</div> <div> 2. Computer Hardware</div> <div> Hardware refers to the physical elements of a computer. Examples of hardware in a computer are</div> <div> the keyboard, the monitor, the mouse and the processing unit</div> <div> 3. System Unit</div> <div> It refers to the box that encapsulates the processor, motherboard, CD and floppy drives, Hard</div> <div> drives, memory, ports etc.</div> <div> 4. Terms related to system unit</div> <div> Following are the terms for external parts of computer casing</div> <div> .</div> <div> Computer casing is the box that houses the computer</div> <div> Power button is used to switch on the computer.</div> <div> Restart button is used to restart (shutdown first and than automatically starts again) the</div> <div> computer</div> <div> Lights shows the running status of the computer</div> <div> CD ROM is the input device used to read data from CDs.</div> <div> Floppy Drive is the input device used to read data from floppy</div> <div> Ports</div> <div> It is an interface that links computer with other peripherals and monitor.</div> <div> Keyboard port is a socket used to connect keyboard to computer.</div> <div> Mouse port is a socket used to connect mouse to computer.</div> <div> Serial port is a socket on a computer that is used to connect scanner, mouse etc. It got 9</div> <div> pins.</div> <div> Parallel port is a socket at the back of the computer to connect printer. It got 25 holes.</div> <div> Pin sockets are used to connect speakers, microphone.</div> <div> RJ11 jacks used to connect phone wires to computer.</div> <div> Power connector is a socket used to supply power in computer</div> <div> Power cable is used to supply power to monitor.</div> <div> Drive bay is a place where hard drives are installed using screws</div> <div> Power supply provides power to processors, mother board etc</div> <div> Mother board</div> <div> Processor is a brain of computer and does all the processing.</div> <div> Fan is used to cool down the processor to avoid it from being damaged</div> <div> Virtual University of Pakistan</div> <div> 21</div> <div> Computer Proficiency License (CS001) VU</div> <div> RAM chip is random access memory used by computer system to keep the running program</div> <div> here.</div> <div> Interface cards</div> <div> Sound card is the interface used to produce sound via speakers</div> <div> LAN card is use to develop a network (more than one computer connected to each other)</div> <div> Modem is used to connect internet with computer</div> <div> 5. How does computer works?</div> <div> Following diagram explain how a computer works In a very generic form. Data goes into memory</div> <div> as input and from there it goes for processing. After processing it goes back to memory, from</div> <div> memory it is sent as out put or it is stored.</div> <div> Input</div> <div> Memory</div> <div> Process</div> <div> Output</div> <div> Storage</div> <div> Fig.6.1</div> <div> 6. Summary</div> <div> In this lecture we learnt information about:</div> <div> 􀁸 Various hardware components of computer</div> <div> 􀁸 System unit lights, buttons on it, front panel</div> <div> 􀁸 Ports such as serial ports, parallel ports, USB ports, RJ 11 ports, Pin sockets</div> <div> 􀁸 Drive Bay, Power supply, Motherboard, Card slots, RAM slots, Processor, Fan</div> <div> 7. Exercise</div> <div> 1. If you have a computer, first detach all peripherals (keyboard, mouse etc) and then attach</div> <div> again</div> <div> 2. Write down difference between serial and parallel ports of computer</div> <div> 3. What is RJ11 jack and why it is used in computer?</div> <div> 4. Write down the difference between motherboard and processor</div> <div> 5. Visit the market and find out the varieties of system units.</div> <div> Virtual University of Pakistan</div> <div> 22</div> <div> Computer Proficiency License (CS001) VU</div> <div> Computer Proficiency License (CS-001)</div> <div> Lecture 07</div> <div> Software</div> <div> 1. Objectives</div> <div> The objective of this lecture is to provide information about:</div> <div> 􀁸 What software is?</div> <div> 􀁸 Types of software</div> <div> 􀁸 Tasks performed using software.</div> <div> 􀁸 What software version is?</div> <div> 2. Computer Software</div> <div> Software is a set of instructions. It can not be touched. Hardware does not work without software.</div> <div> It gives instructions to hardware to perform some functionality.</div> <div> Software versions</div> <div> Software are developed and are periodically updated. When a software is updated and a new</div> <div> copy of this updated is available in the market it is called a new version of a software, for</div> <div> example Win 95, win 98, win NT, win 2000, win XP</div> <div> 3. Types of computer Software</div> <div> There are three basic types of computer software.</div> <div> 1. System software</div> <div> 2. Utility software</div> <div> 3. Application software</div> <div> 3.1 System Software</div> <div> It maintains and control computer hardware. There are two kinds of system software.</div> <div> 1. Operating system</div> <div> 2. Device drivers</div> <div> 1- Operating System</div> <div> Operating systems manage and coordinate the activities of the computer hardware and other</div> <div> software.</div> <div> 2- Device Drivers</div> <div> It manages hardware. Like a driver of a car. Operating system tells what to do to driver and than</div> <div> driver is responsible for action. For example operating system knows which driver to access when</div> <div> a print is required and than printer driver is responsible to take the print.</div> <div> 3.2 Utility Software</div> <div> It manages hardware, operating system or application software and perform specific task. It</div> <div> performs tasks like maintenance, troubleshooting, virus scanning etc. Disk scanner and antivirus</div> <div> are example of utility software.</div> <div> Virtual University of Pakistan</div> <div> 23</div> <div> Computer Proficiency License (CS001) VU</div> <div> 3.3 Application software</div> <div> Software belongs to this category helps in daily life tasks like calculation, presentation, text</div> <div> editing etc. This is most commonly used type of software.</div> <div> 1- Word processor</div> <div> It is complex form of text editors that use to provide use the basic functionality of saving, editing,</div> <div> updating, formatting text. These got spell and grammar checkers. MS word is most common and</div> <div> widely used word processor.</div> <div> 2- Spread sheet</div> <div> It helps in accounting and finance work. It contains cells (Rows and Columns) that contain a</div> <div> value. Different formulas can be applied on these values using by default functions.</div> <div> MS Excel is most common used software for developing spread sheets.</div> <div> 3- Presentation software</div> <div> MS PowerPoint is presentation software that is used by business people, educators, students and</div> <div> trainers to present some idea or information in form of text, image or sound. It consists of pages</div> <div> or slides that may be arranged in a consistent style to give a feel of presentation.</div> <div> 4. Microsoft</div> <div> It is the one of the biggest software companies in the world. It has developed famous windows</div> <div> and application software like MS word, MS excel, MS power point etc.</div> <div> 5. Summary</div> <div> In this lecture we learnt:</div> <div> 􀁸 What software is?</div> <div> 􀁸 Types of software</div> <div> 􀁸 Users and functionality of software</div> <div> 􀁸 What is meant be version of software?</div> <div> Virtual University of Pakistan</div> <div> 24</div> <div> Computer Proficiency License (CS001) VU</div> <div> Computer Proficiency License (CS-001)</div> <div> Lecture 08</div> <div> Internet</div> <div> 1. Objectives</div> <div> The objective of this lecture is to provide information about:</div> <div> 􀁸 What is meant be Internet?</div> <div> 􀁸 Services available over internet</div> <div> 􀁸 How to access internet?</div> <div> 2. Internet</div> <div> Internet is network of networks. It doesn’t belong to any one and non one runs it. People around</div> <div> the globe access internet via telephone line or satellite.</div> <div> How to access it?</div> <div> Internet Service Provider (ISP) is a company or organization that connects the users with internet.</div> <div> ISP is always connected to internet and people who want to access internet, connect it via their</div> <div> local ISPs.</div> <div> It is used to share information and resources over internet.</div> <div> 3. Services over Internet</div> <div> 1- World Wide Web</div> <div> 2- Email</div> <div> World Wide Web</div> <div> Web meant net. It was originally designed to share information among scientific community. But</div> <div> now it is the most popular way of sharing information.</div> <div> Web page is a resource of information written in html.</div> <div> Web browser is software that is used to view webpage. Internet explore is one of the famous</div> <div> internet browser.</div> <div> Web site is a collection of related web pages. Every website has a unique address to access it. It</div> <div> is called uniform recourse locator (URL). For example www.vu.edu.pk is the url for the virtual</div> <div> university’s website.</div> <div> Links provide us the access to other web pages in website. You may have seen links like home,</div> <div> contact us, about us etc.</div> <div> Advantage of web is availability of huge resource of information. For example temperature of</div> <div> different parts of world is available over the web and</div> <div> How to reach the web?</div> <div> 1- Connect telephone line to computer</div> <div> 2- Connect to ISP</div> <div> a. Enter ISP phone</div> <div> b. Enter user name and password to connect</div> <div> Virtual University of Pakistan</div> <div> 25</div> <div> Computer Proficiency License (CS001) VU</div> <div> 3- Open browser</div> <div> 4- Enter URL and browse internet</div> <div> Email</div> <div> It is like regular mail just with a small different that you need computer to read, write or send</div> <div> email. It is used for communication between people who are at some distance. Its delivery is</div> <div> faster, safer than regular mail. Probability of losing t is very low and it can be viewed from</div> <div> anywhere in the world as it resides on internet.</div> <div> Email address is used to send email from one pc to another. e.g info@vu.edu.pk is email address</div> <div> to send email to Virtual University of Pakistan.</div> <div> Email client is software to compose, sent, receive or read email. You can access your emails</div> <div> from anywhere in the world. All you need is email id and password provided. This ensures</div> <div> authenticated access to your emails. Password is a secret word, used to uniquely identifies the</div> <div> user. Some famous email clients are MS outlook, Neo mail, Lotus notes.</div> <div> 4. Summary</div> <div> In this lecture we learnt about:</div> <div> 􀁸 Internet, web, email</div> <div> 􀁸 Web site, WebPages</div> <div> Virtual University of Pakistan</div> <div> 26</div> <div> Computer Proficiency License (CS001) VU</div> <div> Computer Proficiency License (CS-001)</div> <div> Lecture 09</div> <div> Security</div> <div> 1. Objectives</div> <div> The objective of this lecture is to provide information about:</div> <div> 􀁸 What is meant by security of computer?</div> <div> 􀁸 Risk associate with computer.</div> <div> 􀁸 Methods of protection against these risks</div> <div> 2. Security Risks</div> <div> There are risks associated with hardware, software, data etc that can cause a big loss to the</div> <div> owner. One should do preventative actions to avoid these security risks.</div> <div> Types of risks</div> <div> 1- Hardware theft</div> <div> Save hardware/computer from stealing by placing it somewhere safe.</div> <div> 2- Virus</div> <div> Computer virus is software that damage computer. For example it may cause</div> <div> your computer to restart when you open MS word.</div> <div> Antivirus software is used to eliminate virus from computer. It scans hard disk to</div> <div> find virus and terminate them. It also stops entering new virus into computer.</div> <div> New versions of antivirus, help to prevent viruses to damage computer or data.</div> <div> 3- Unauthorized access</div> <div> If you don’t want someone else to access your data in computer, you can protect</div> <div> your computer/data with password. It will reduce the risk of unauthorized access</div> <div> to your pc. Password is a unique word that identifies the user.</div> <div> 4- Backup</div> <div> Data saved in your computer may lose due to some reason. In case of having its</div> <div> backup (same data at some other place/storage device) you can access and use</div> <div> it. Backup is the process of copying data. For example you have prepared a</div> <div> presentation and due to virus attack it got damaged or deleted. If you have its</div> <div> backup file at some secondary storage media like floppy etc, you can restore the</div> <div> presentation from that device.</div> <div> Backup utilities help to organize backup data (that data being copied).</div> <div> 5- Software piracy</div> <div> If some one copy and sells the software of any developer or company without its</div> <div> permission, than he is doing piracy. It is of the biggest problem, software industry</div> <div> is facing now. Copying and selling software in such manner is against software</div> <div> copyright act.</div> <div> According to the copyright act</div> <div> If someone steals the software</div> <div> Or</div> <div> Virtual University of Pakistan</div> <div> 27</div> <div> Computer Proficiency License (CS001) VU</div> <div> Copies or sells it without the permission of the owner/developer</div> <div> Legal action is taken against him.</div> <div> 3. Summary</div> <div> In this lecture we learnt:</div> <div> 􀁸 What is hardware security?</div> <div> 􀁸 Different types of security risks</div> <div> 􀁸 What is meant by computer virus?</div> <div> 􀁸 What is meant by anti-virus?</div> <div> 􀁸 What does data backup means?</div> <div> 􀁸 What is software piracy?</div> <div> Virtual University of Pakistan</div> <div> 28</div> <div> Computer Proficiency License (CS001) VU</div> <div> Computer Proficiency License (CS-001)</div> <div> Lecture 10</div> <div> Computer Environment</div> <div> 1. Objectives</div> <div> The objective of this lecture is to provide information about:</div> <div> 􀁸 How to start, turn off and restart computer?</div> <div> 􀁸 Basic windows structure and properties</div> <div> 􀁸 View computer’s information</div> <div> 2. Starting the computer</div> <div> Press the power button on system unit to start the computer. The area you will see on the</div> <div> monitor screen, after computer a start is called desktop. It is called desktop because you can</div> <div> use it like the top of the desk to place the icon or shortcut to your favorite programs or soft wares.</div> <div> Window is software developed by Microsoft which is usually called Microsoft windows. Window</div> <div> has different versions like window 95, window NT, window 2000, window XP etc. Although these</div> <div> versions are similar to each other but every new version is better than the previous with and</div> <div> provides new features as well.</div> <div> ICON is a graphical representation of files, folders, disk drives, toolbar buttons etc. Name of the</div> <div> icon, file, folder etc is written just below it. The word icon came from the Greek word “eikon” which</div> <div> means image. Still religious pictures are called Eikon in Greek. In windows, these icons are links</div> <div> to software to open it with double click of the mouse. You can design such icons yourself as well.</div> <div> Taskbar is the bar at the bottom area of desktop (monitor screen). Icons of our tasks and</div> <div> software being used will appear here. It is called taskbar because it shows the tasks being carried</div> <div> out in computer. Start button reside at the left side of the task bar. At the right side of this button,</div> <div> quick launch bar exist. Icons reside here open their respective programs with single click. System</div> <div> tray exist at the right side of the task bar, which may contains some icons like antivirus programs,</div> <div> firewall software etc. Icons in system tray represent programs which work in background. For</div> <div> example an antivirus program works consistently in the background to protect your pc from</div> <div> viruses and only icon display here. In the same system tray, there is a clock indicating the system</div> <div> time. It is called system clock.</div> <div> 3. How to shut down the computer?</div> <div> Click on start (located at the bottom left side of the task bar on monitor screen). A list of program</div> <div> names and commands will appear. Click on the option “Shut down”. A dialogue box of shut down</div> <div> will appear in front of desktop. Desktop will turn into gray color. In a drop down menu there, you</div> <div> can see the options like Log off, Restart, Shutdown, and Standby by clicking at the arrow on the</div> <div> right side. There are three buttons Ok, Cancel, and Help at in the dialogue box. Clicking on OK</div> <div> button will shutdown your PC.</div> <div> Old computers show shutdown message on screen that “It is now safe to turn off your computer”</div> <div> Turning off your computer during work may damage your pc and all data will be lost.</div> <div> 4. How to restart computer?</div> <div> You may need to restart the computer.</div> <div> Why we restart computer?</div> <div> Virtual University of Pakistan</div> <div> 29</div> <div> Computer Proficiency License (CS001) VU</div> <div> There can be several reasons for restarting computer. Like new installation of any software can</div> <div> ask for restart, or computer suddenly stop working (halt).</div> <div> To restart your computer, click on start button at the taskbar. Click on shutdown to open the</div> <div> shutdown dialogue box and select restart from the dropdown menu. It will shutdown the computer</div> <div> and starts it again.</div> <div> 5. Window and its structure</div> <div> Basic windows properties</div> <div> If you are using windows XP for the first time, you will see only one icon “Recycle bin” at the</div> <div> desktop. Right click on the start button and select properties. Choose “classic start menu” option.</div> <div> New icons will appear on the desktop.</div> <div> Click on “My Computer” icon. A new screen will open. It is called window.</div> <div> Title bar</div> <div> A bar at the top of the window is called title bar. It has</div> <div> 1- Current window’s name</div> <div> 2- Buttons to restore down Maximize/Minimize and Close the window.</div> <div> Desktop can’t be seen when any window is maximized. Icon for closed windows does not appear</div> <div> at the task bar.</div> <div> Menu bar</div> <div> This bar resides below the title bar. It has few words like File, Edit etc, when you click at any of</div> <div> these, a list/menu will open.</div> <div> Standard bar</div> <div> It contains buttons to facilitate us during work. Due to their utility, these are called standard tools.</div> <div> Status bar</div> <div> It resides at the bottom of the window. It provides some information related to that window.</div> <div> You will come across so many other windows while working with your computer. Every window</div> <div> will perform a new task for you.</div> <div> 12. Summary</div> <div> In this lecture we learnt about the basic system properties</div> <div> 13. Exercise</div> <div> Task 1:</div> <div> Look at the front panel of your system unit. There is a small button other than the power</div> <div> button. Find out what is the use of this button.</div> <div> Task 2:</div> <div> Click on the Start button and then choose Shut Down. Find out what is the use of the</div> <div> option “Stand by”.</div> <div> Task 3:</div> <div> Using the help feature of Windows XP, find out what is the use of Hibernate option and</div> <div> how to enable it on your system.</div> <div> Task 4:</div> <div> Open My Computer window and press Alt + Spacebar keys. Observe what happens. Can</div> <div> you see some useful change in the window?</div> <div> Virtual University of Pakistan</div> <div> 30</div> <div> Computer Proficiency License (CS001) VU</div> <div> Computer Proficiency License (CS-001)</div> <div> Lecture 11</div> <div> System properties</div> <div> 1. Objectives</div> <div> The objective of this lecture is to provide information about:</div> <div> 􀁸 View the computer’s desktop settings</div> <div> 􀁸 Be able to format the floppy disk</div> <div> 􀁸 Use available help functions</div> <div> 2. Basic System Information</div> <div> Information like what hardware, software, operating system etc is used in system is called basic</div> <div> system information.</div> <div> Right click on “My Computer” and select “Properties”. You will find information like operating</div> <div> system name and version, registration data, processing speed and RAM size. Your computer</div> <div> may have different RAM size like 64 MB, 128 MB, and 256 MB etc.</div> <div> 3. Changing date and time</div> <div> Double click at the system clock in the system tray at the taskbar of the desktop.</div> <div> Date and time properties will open. You can change time and date.</div> <div> 4. Changing the wallpaper</div> <div> Right click on the empty area of the desktop. Select properties from the menu. Display properties</div> <div> will open. Select the tab that display “Desktop”. Select the background and click on OK button.</div> <div> You can also choose wallpapers other than given in list by using the “Browse” button. Drop down</div> <div> menu below Browse button, give you position options that are Center, Tile and Stretch.</div> <div> Computer generated images are created by using several colors. More colors make an image</div> <div> better.</div> <div> To change the display settings, bring the same display properties window.</div> <div> Right click on the empty area of the desktop, select properties, and select “Settings” tab. Now you</div> <div> can change color quality (16 bit, 32 bit etc) and screen resolution (640 by 480 etc).</div> <div> There are two more buttons in this window.</div> <div> Troubleshoot – we click on this button when we need some help from computer</div> <div> Advanced – It is the option to change the internal hardware settings of the computer.</div> <div> 5. Changing the Screen saver</div> <div> At the old time, when monitors had no automatic shutdown system, screen savers were used to</div> <div> save the screens. Picture tube surface has a permanent image embedded in it. This is called</div> <div> screen burn out and results if computer remains on for long time, and show the same</div> <div> window/picture.</div> <div> To change the screen saver, select the screen saver tab in display properties. In drop down</div> <div> menu, you will find a list of names of screen savers. You can select any one from these with the</div> <div> wait option. This option will wait for the selected number of seconds/minutes and after that start</div> <div> screen saver if screen remains unused. You can preview the selected screen saver by clicking on</div> <div> “Preview” button. To remove/stop screen saver, press any key on keyboard or move mouse.</div> <div> Virtual University of Pakistan</div> <div> 31</div> <div> Computer Proficiency License (CS001) VU</div> <div> 6. Help feature</div> <div> Open “My Computer” and press F1 (functional key). A help window will open. You can find help</div> <div> about any topic. For example, if you need to find out about the way to change the desktop color.</div> <div> Enter desktop color in search option and press enter or click on the button in front of text area.</div> <div> You will find the results against your search. Click on any option you find appropriate to get the</div> <div> complete information related.</div> <div> 7. Formatting a floppy disk</div> <div> Insert the floppy into the floppy drive. Open My Computer and right click on the icon of the Floppy</div> <div> Drive. In the menu, select the “Format...” option. Choose quick format and click on start button.</div> <div> Floppy disk will be formatted and all data will be removed.</div> <div> 8. Summary</div> <div> In this lecture we learnt:</div> <div> 􀁸 Basic system properties</div> <div> 􀁸 How to configure computer’s desktop</div> <div> 􀁸 How to take help from computer</div> <div> 􀁸 How to format the disk</div> <div> 9. Exercise</div> <div> Task 1:</div> <div> Open My Computer window. Right click on the icon of My Computer that appears in the</div> <div> task bar. Choose the “Close” option from this menu. Observe what happens.</div> <div> Task 2:</div> <div> Is the floppy of 3¼ inches the only size available in the market? Search around and find</div> <div> out which other sizes are available.</div> <div> Task 3:</div> <div> Use the Help and Support menu of Windows XP and find out how to customize your</div> <div> computer. You will find a link labeled as “Customizing your computer”.</div> <div> Virtual University of Pakistan</div> <div> 32</div> <div> Computer Proficiency License (CS001) VU</div> <div> Computer Proficiency License (CS-001)</div> <div> Lecture 12</div> <div> Desktop</div> <div> 1. Objectives</div> <div> The objective of this lecture is to provide information about:</div> <div> 􀁸 How to arrange desktop icons?</div> <div> 􀁸 Recognize and use of icons</div> <div> 􀁸 How to resize and move the window?</div> <div> 􀁸 Difference between active and inactive window</div> <div> 􀁸 Understanding the terms: File and Folder</div> <div> 2. Working with Icons</div> <div> You can see different icons on desktop. Every icon represents software. It means that associated</div> <div> software starts working if icon is double clicked. Icons on a desktop are placed in a certain order,</div> <div> but you if you want, order can be changed.</div> <div> Moving an icon</div> <div> To move an icon, we have to select it first.</div> <div> Click on icon and without releasing the button to the position you want to place</div> <div> Release the mouse</div> <div> Auto arrange option</div> <div> If auto arrange option is selected for desktop icons, we can not change icon’s location.</div> <div> If icon is moved, it will go back to its place.</div> <div> To turn off this option, right click on empty area of desktop.</div> <div> Select “Arrange Icons” and go to “Auto Arrange” Option.</div> <div> If you see an arrow before this option, click on it.</div> <div> It will turn off “Auto Arrange” option</div> <div> Arrange icons</div> <div> Icons can be arranged in four ways</div> <div> Right click on the empty area of the desktop.</div> <div> Move the mouse over the first option “Arrange Icons By”</div> <div> A sub menu will open with four options</div> <div> Name - It will arrange icons with respect to their names in alphabetic order</div> <div> Size - It will arrange icons with respect to their sizes</div> <div> Type - It will arrange icons with respect to their types</div> <div> Modified - It will arrange icons with respect to their creation date</div> <div> 3- Important desktop Icons</div> <div> My Computer – Access to computer drives, Basic computer information</div> <div> Virtual University of Pakistan</div> <div> 33</div> <div> Computer Proficiency License (CS001) VU</div> <div> Recycle Bin – It resembles to the waste bin, and got a recycle logo on it. It got all the deleted files</div> <div> or folders from the computer. If we want, we can restore deleted files from recycle bin but if once</div> <div> these files are deleted from the bin, we can not have them back.</div> <div> To delete the file or folder, select it first by clicking on it once. Now press “Delete” button on</div> <div> keyboard. Click on Ok in the delete confirmation dialogue box. The file or folder is deleted now.</div> <div> To restore the deleted file, select file and click on “Restore this item” option on the left side of the</div> <div> Recycle bin’s window. File will be restored and go back to its original place.</div> <div> To delete the file permanently, open Recycle bin and click on “Empty Recycle Bin” option on the</div> <div> left upper side of the Recycle bin’s window. File will be deleted and the space occupied by this file</div> <div> is available for use now.</div> <div> 4- Resizing and moving a window</div> <div> To resize a window, select window’s bottom right edge and drag inside or outside without</div> <div> releasing the mouse. We can resize a window by dragging any of its edge with mouse pointer.</div> <div> To move a window click on the title bar of the window, and move it without releasing the mouse.</div> <div> With the help of scroll bars, we can see the content of window, which wasn’t visible before. There</div> <div> are two kinds of scroll bars in window.</div> <div> 1- Vertical scroll bar to scroll the window in up and down direction.</div> <div> 2- Horizontal scroll bar to scroll it left and right direction.</div> <div> No matter how many windows you have opened, you can work only at one of them at a time. Title</div> <div> bar color of the window that is in use is different from other windows. The window that is in use</div> <div> has a dark colored title bar and is called active window. The window that is not in use has a light</div> <div> colored title bar and is called inactive window.</div> <div> 5- Understanding files and folders</div> <div> In computer data is saved in form of files. We put these generated files in folders on hard disk. To</div> <div> access our desired file, we have to open associated drive and than folder(s). This is called the</div> <div> path to the file. For example we have a file “song1.mp3” in folder “Songs” which is placed in drive</div> <div> C. To access song1.mp3, first we will open drive C, and than folder Songs. In this case</div> <div> C:\Songs\song1.mp3 would be complete path.</div> <div> Window Explorer</div> <div> With the help of this window, we can browse the folders and files in our computer.</div> <div> Click on Start > All Programs > Accessories > Windows Explorer</div> <div> It has two parts unlike any other window e.g. my computer’s window</div> <div> 1- List panel on left side</div> <div> 2- Detail section on right side</div> <div> In list panel we can see two kinds of signs</div> <div> 1- Plus (expand) sign – This sign only appears before hard drive and folder, incase they got</div> <div> more drive partitions, folders or files. Once clicked + sign, will change it into – sign.</div> <div> 2- Negative (contract) sign</div> <div> Virtual University of Pakistan</div> <div> 34</div> <div> Computer Proficiency License (CS001) VU</div> <div> File and folder tree- It is a list of folders, their sub folders and files in window explorer.</div> <div> 6- Summary</div> <div> In this lecture we learnt:</div> <div> 􀁸 How to arrange desktop icons?</div> <div> 􀁸 Recognize and use of icons</div> <div> 􀁸 How to resize and move the window?</div> <div> 􀁸 Terms such as active, inactive window, File, Folder</div> <div> 7- Exercise</div> <div> Task 1:</div> <div> On your own computer's desktop, try to arrange icons in different order i.e. by Name,</div> <div> Size, Type and Modified.</div> <div> Task 2:</div> <div> Right click on your desktop, click on the “Arrange Icons by” and then click on “Auto</div> <div> Arrange” option. Try to drag and move the desktop icons now. Observe what happens to</div> <div> these icons.</div> <div> Task 3:</div> <div> Now turn off the “Auto Arrange” option from the same menu you used in the previous</div> <div> step and then try again to move the icon.</div> <div> Task 4:</div> <div> Open WordPad window and click on its restore down button if it is maximized. If you look</div> <div> at the bottom right hand corner of the window, you will find some gray dots. Using your</div> <div> mouse pointer, click and drag this corner. Observe what happens.</div> <div> Task 5:</div> <div> Open at least 3 different software windows. Now carefully right click on the empty portion</div> <div> and choose the option “Title Windows Vertically”. Observe the arrangement of windows.</div> <div> Similarly try the options of “Tile Windows Horizontally” and “Cascade Windows”.</div> <div> Task 6:</div> <div> Open at least 3 different software windows. Now press the Alt and Tab keys from the</div> <div> keyboard simultaneously. Observe that a small panel in the center of the screen will open</div> <div> up. This feature is called Application Switcher. Keep the “Alt” key pressed and press Tab</div> <div> key again to move between the icons shown in the panel. Choose any of the icons in this</div> <div> panel and release both the keys. Observe what happens.</div> <div> Virtual University of Pakistan</div> <div> 35</div> <div> Computer Proficiency License (CS001) VU</div> <div> Computer Proficiency License (CS-001)</div> <div> Lecture 13</div> <div> Organizing Files</div> <div> 1. Objectives</div> <div> The objective of this lecture is to provide information about:</div> <div> 􀁸 Learn about files, folders, properties</div> <div> 􀁸 How to rename, copy, paste files</div> <div> 􀁸 How to save, delete, search files</div> <div> 2. Working with folders</div> <div> To create a new folder, right click on the empty area of the desktop and select New < Folder</div> <div> New folders are always named as “New Folder” by computer. Folders within folders can be</div> <div> created. These are called sub-folders as they reside inside some main folder. The purpose of</div> <div> creating folders within folders is to organize our data in a structured form.</div> <div> To view the properties of a folder</div> <div> 1. Select the folder. Go to File menu and click on Properties. A new window call Properties</div> <div> Panel will open.</div> <div> 2. Right click on a folder. Go to Properties.</div> <div> Window Properties Panel consists of three tabs.</div> <div> 1. General Tab – It will have Folder name, type, location on computer, size and number of</div> <div> files and subfolders, date and time folder was created on, attributes(read only, hidden)</div> <div> 2. Sharing Tab</div> <div> 3. Security Tab</div> <div> To rename a folder, right click on the folder, and select Rename. Enter new name in place of</div> <div> highlighted text.</div> <div> 3. Creating application files</div> <div> Computer based document is called file. You require application software to create files like</div> <div> notepad, word pad or MS word.</div> <div> To create a new file, right click on the empty area of the desktop. Go to New and click on the file</div> <div> type you want to create. For example to create a new word document, right click on the desktop,</div> <div> Go to New and select MS Word Document.</div> <div> To view the properties of software, right click on the file. File Properties window will open.</div> <div> To rename a file, right click on that file, and select Rename. Enter new name in place of</div> <div> highlighted text.</div> <div> To select a file, simply do a single click on it.</div> <div> To select multiple files</div> <div> 1. Click on area near to one file and than drag around all files you need to select.</div> <div> 2. Hold down Ctrl key and select all those files that need so be selected.</div> <div> 3. To select adjacent or icons in a row, press Shift Key and select those icons.</div> <div> We may need another copy for any file/folder for backup or further use.</div> <div> Copy would simply make another copy of the file/folder in memory, however the file will remain at</div> <div> its current location, and can be pasted(as another copy) at any other location by using the paste</div> <div> Virtual University of Pakistan</div> <div> 36</div> <div> Computer Proficiency License (CS001) VU</div> <div> option, whereas cut would delete the file/folder from the current location and can be pasted by</div> <div> using paste option.</div> <div> To copy a file/folder, select that file or folder and press Ctrl + C or right click on it and select</div> <div> “Copy” option</div> <div> To cut a file/folder, select that file or folder and press Ctrl + X or right click on it and select “Cut”</div> <div> option</div> <div> To paste a copied or cut file, press Ctrl + V in folder or drive or right click where you want to paste</div> <div> the file and select Paste option.</div> <div> To make backup files/folders</div> <div> 1. Copy the file/folder to another secondary storage device like floppy disk.</div> <div> 2. Right click on the file folder and move your cursor to “Send To” option. Select “3 1/2</div> <div> Floppy” option.</div> <div> To delete a file or folder</div> <div> 1. Select a file/folder and press “Delete” button on keyboard</div> <div> 2. Right click on the file and select Delete option from menu.</div> <div> To search a file or folder click on the start button in task bar. Select “Search” option in the menu.</div> <div> In the left side, there is a search panel that can help you to find a file with the following options.</div> <div> You can find the file with the complete or partial file name, a word or phrase in the file or just</div> <div> select the location to see all the files and folders in that location.</div> <div> 4. Summary</div> <div> In this lecture we have learnt:</div> <div> 􀁸 About folders and their properties</div> <div> 􀁸 Commonly used files and their properties</div> <div> 􀁸 How to rename files, folders</div> <div> 􀁸 How to save, delete and search files, folders</div> <div> 5. Exercise</div> <div> Task 1:</div> <div> Open My Computer and then open C drive. Right click in the empty white space; choose</div> <div> the “New” option and then the “Folder” option to create a folder. Name this folder as “VUCPL”.</div> <div> Now within this folder you have to create 5 more folders by the following names:</div> <div> Exercise 2.1, Exercise 2.2, Exercise 2.3, Exercise 2.4 and Exercise 2.5. This folder</div> <div> structure will be used in the next exercises.</div> <div> Task 2:</div> <div> Create a file on the desktop and then check its size ( hint: right click on file icon and then</div> <div> choose properties ).</div> <div> Task 3:</div> <div> Put a floppy disk in floppy drive of your computer. Click on Start button and choose the</div> <div> “Run” menu. Type “A:” (without the quotation marks) in the available text box and press</div> <div> OK button. Observe what happens.</div> <div> Task 4:</div> <div> Select a file or folder and then press F2 key (F2 is a function key that is located on the</div> <div> top row of buttons on your keyboard). Observe what happens to the icon. Explore what</div> <div> you can do at this moment.</div> <div> Task 5:</div> <div> Open “My computer” and then open C drive. Click in empty white space with your mouse</div> <div> pointer once. Press Ctrl and A keys from the keyboard. Observe the effect of this shortcut</div> <div> combination.</div> <div> Virtual University of Pakistan</div> <div> 37</div> <div> Computer Proficiency License (CS001) VU</div> <div> Task 6:</div> <div> Create two folders on your desktop (Hint: Right click on the desktop and choose “New”</div> <div> from the menu ...). Give them appropriate names. Now open these folders and create a</div> <div> file in each of these folders (hint: right click & choose “Text Document” from the “New”</div> <div> option). Now select file from one of the folder and press Ctrl and X keys simultaneously</div> <div> from the keyboard. Click in the other folder and press Ctrl + V from the keyboard.</div> <div> Observe what happens.</div> <div> Task 7:</div> <div> Put a floppy in the floppy drive and then open My computer. Right click on the floppy</div> <div> drive icon. Choose the properties option to check the capacity of the floppy. Also note the</div> <div> free space available.</div> <div> Task 8:</div> <div> Select any file from the C drive of your computer. Right click on it and check its size. Can</div> <div> you copy & save it in a floppy?</div> <div> Task 9:</div> <div> Open the search file window (hint: Click on Start button & choose search option ... ). Type</div> <div> “ *.txt ” (without quotation marks) in the first text box and press enter from the keyboard.</div> <div> Observe the results of the search. What do you infer from this example?</div> <div> Task 10:</div> <div> Press F1 key from the keyboard to open Help window. Type “Wildcard” in the text box</div> <div> and press enter from the keyboard. Learn about the use of wildcards in searching files.</div> <div> Virtual University of Pakistan</div> <div> 38</div> <div> Computer Proficiency License (CS001) VU</div> <div> Computer Proficiency License (CS-001)</div> <div> Lecture 14</div> <div> Introduction to Text Editing</div> <div> 1. Objectives</div> <div> The objective of this lecture is to provide information about text editing software.</div> <div> 2. Explaining Text Editor</div> <div> Text editor is software that helps in editing text. There are several Text editing soft wares</div> <div> available on internet like Note pad, Text pad etc.</div> <div> Word processor is the advance form of text editing software. We use text or word processors to</div> <div> create word document. If you are using windows operating system, than Notepad and WordPad</div> <div> are installed by default in your system.</div> <div> For more clear understanding, you should consult vu-cpl’s software available at Virtual University</div> <div> of Pakistan.</div> <div> 3. Summary</div> <div> We learn about text editors and how to use them.</div> <div> 4. Exercise</div> <div> Task 1:</div> <div> Click on Start button & choose the RUN Menu. Type notepad in the space available and</div> <div> press enter from the keyboard. Observe what happens. You can also try opening</div> <div> WordPad in the same way.</div> <div> Virtual University of Pakistan</div> <div> 39</div> <div> Computer Proficiency License (CS001) VU</div> <div> Computer Proficiency License (CS-001)</div> <div> Lecture 15</div> <div> Working with Text Editor</div> <div> 1. Objectives</div> <div> The objective of this lecture is to provide information about Working with text editor</div> <div> 2. Basic functions</div> <div> To open a notepad go to Start < All Programs < Accessories < Notepad</div> <div> To save a new file go to File < Save as...</div> <div> To save the text written (modifications) in already saved file go to File < Save</div> <div> To save the file in a new location go to File < Save as… and save the file with another name.</div> <div> For better understanding, you should consult vu-cpl’s software available at Virtual University of</div> <div> Pakistan.</div> <div> 3. Summary</div> <div> In this lecture you have learnt:</div> <div> 􀁸 How to type text in the text editor and how to save the file</div> <div> 􀁸 How to save file with a new name and new location</div> <div> 4. Exercise</div> <div> Task 1:</div> <div> Open All Programs menu and then click on Accessories. Locate the notepad option.</div> <div> Single click on this icon and carefully drag this icon on to your desktop. This action will</div> <div> create a shortcut of Notepad application on your desktop. You will be able to run Notepad</div> <div> by double clicking this icon in future.</div> <div> Task 2:</div> <div> Virtual University of Pakistan</div> <div> 40</div> <div> Computer Proficiency License (CS001) VU</div> <div> Open WordPad from the accessories menu (Hint: Click on Start button, go to All</div> <div> Programs and then Accessories menu). Type any text you like and then press Ctrl and S</div> <div> keys simultaneously from the keyboard. A window will open up; recall what you can do</div> <div> with this window.</div> <div> Virtual University of Pakistan</div> <div> 41</div> <div> Computer Proficiency License (CS001) VU</div> <div> Computer Proficiency License (CS-001)</div> <div> Lecture 16</div> <div> Closing an Application</div> <div> 1. Objectives</div> <div> The objective of this lecture is to provide information about closing Text files and Editor</div> <div> 2. Closing the File</div> <div> To close the file click on the Close button at the title bar</div> <div> 3. Closing the Editor</div> <div> To close the Editor follows any of these.</div> <div> 1- Click on the Close button at the title bar</div> <div> 2- Go to File < Exit</div> <div> It will exit the Editor and close the opened files. For understanding the procedure, you should</div> <div> consult vu-cpl’s software available at Virtual University of Pakistan.</div> <div> 3. Summary</div> <div> In this lecture you have learnt how to close an application window</div> <div> 4. Exercise</div> <div> Task 1:</div> <div> For this exercise we will need the VU-CPL folder that was created in the exercise of third</div> <div> lesson. If you haven't created the folder then complete the 1st task from the exercise of</div> <div> third lesson. Now open WordPad and type any text you like. Press Ctrl and S keys from</div> <div> the keyboard to save the file. In the “Save in” drop down box, try to locate a folder in C</div> <div> Drive by the name of Exercise 2.4 in the VU-CPL folder. Save the WordPad file in this</div> <div> folder.</div> <div> Task 2:</div> <div> Open Notepad and type some text in the file. Save this file in Exercise 2.4 folder. Now</div> <div> press Alt and F4 key from the keyboard (F4 is a function key that is located on the top</div> <div> row of buttons on your keyboard). Using this key combination will close the window. Try</div> <div> this combination on any open window.</div> <div> Virtual University of Pakistan</div> <div> 42</div> <div> Computer Proficiency License (CS001) VU</div> <div> Computer Proficiency License (CS-001)</div> <div> Lecture 17</div> <div> Saving files on Floppy</div> <div> 1. Objectives</div> <div> The objective of this lecture is to provide information about Saving files and folders on secondary</div> <div> storage devices</div> <div> 2. Closing the File</div> <div> To close the file click on the close button at the title bar</div> <div> To save the file on floppy</div> <div> 1. Right click on the file and select Send To < 3 ½ Floppy Drive</div> <div> 2. Select file and press Ctrl + C, Double click on My computer. You can see Floppy drive’s</div> <div> icon there. Double click on this icon to open the drive. Click on an empty area of the</div> <div> drive and press Ctrl + V to paste the file there.</div> <div> You should consult vu-cpl’s dvd to view these steps in animation.</div> <div> 3. Summary</div> <div> In this lecture you have learnt how to save files and folders on floppy</div> <div> 4. Exercise</div> <div> Task 1:</div> <div> NOTE: Before doing this task, you have to insert a floppy disk in your floppy disk drive.</div> <div> Open WordPad and type a few lines in this file. Press Ctrl and S keys from the keyboard.</div> <div> Give this file a name and then locate the option of floppy disk in the “Save in” drop down</div> <div> box. Choose this option and then press enter from the keyboard. After the saving process</div> <div> is completed, open My Computer and double click on the floppy disk icon. Is your file</div> <div> there?</div> <div> Virtual University of Pakistan</div> <div> 43</div> <div> Computer Proficiency License (CS001) VU</div> <div> Computer Proficiency License (CS-001)</div> <div> Lecture 18</div> <div> Print Management</div> <div> 1. Objectives</div> <div> The objective of this lecture is to provide information about</div> <div> 􀁸 How to install a printer?</div> <div> 􀁸 Be able to take prints</div> <div> 􀁸 Change the default printer</div> <div> 􀁸 View job print status from the print manager</div> <div> 2. Printer</div> <div> Printer is hardware. It outputs hardcopy (print on paper) of some file on your computer.</div> <div> 3. Installation</div> <div> Installation or setup means to connect a printer with computer and copy necessary software on</div> <div> the computer. It can be divided into (1) Hardware Installation and (2) Software Installation</div> <div> Hardware Installation</div> <div> Connect the main power cable to power socket</div> <div> Put the USB cable into USB socket</div> <div> Switch the main power on.</div> <div> LED on the printer panel will be on. It indicates the printer is on and ready for taking prints.</div> <div> Software Installation</div> <div> Click on the start < Control Panel</div> <div> Double click on the icon “Printers and other hardware” in control panel window.</div> <div> A new window will open. Click on “Add a printer” option here to open the “Add hardware</div> <div> wizard”</div> <div> Click on next button once</div> <div> Select the radio button against “Local printer” option and also check following option of “Auto</div> <div> detect”</div> <div> Select the “Automatically install the printer (Recommended option)”</div> <div> Insert the CD containing printer-driver in CD Rom and than click on the next button</div> <div> Computer will copy and install all the required driver files and set it as default printer. Incase you</div> <div> want to use this printer as the default printer click on next button.</div> <div> If your printer is not connected to any network, use “Do not share” option and click on next</div> <div> button.</div> <div> 4. Printing from installed printer</div> <div> You can use any of these to get the print of your document.</div> <div> 1. Open your word pad or MS word file. In the menu bar, you can see an icon with “printer</div> <div> shape” Click on this icon to get the print.</div> <div> 2. Click on File < Print.. and press Ok.</div> <div> 3. Press Ctrl + P to get the print of your document.</div> <div> Virtual University of Pakistan</div> <div> 44</div> <div> Computer Proficiency License (CS001) VU</div> <div> 5. Print job status</div> <div> To view the print job status</div> <div> 1. Click on the start < Printers and Faxes</div> <div> 2. Click on the printer icon representing printer, you sent prints to</div> <div> 3. A new window for this printer will open which will display the information such as</div> <div> Document Name, status, Owner, Pages, Size, Submitted date/time and port etc.</div> <div> 6- Summary</div> <div> In this lesson you have learnt:</div> <div> 􀁸 How to attach and install a printer with computer</div> <div> 􀁸 How to take prints of any file</div> <div> 􀁸 How to use printer</div> <div> 􀁸 How to view job status</div> <div> 7- Exercise</div> <div> Task 1:</div> <div> Visit some office and explore how they use printers in a network environment.</div> <div> Task 2:</div> <div> There are different types of printers available in the market. If you have to buy a printer,</div> <div> which factors will you consider deciding which one is best for your requirement?</div> <div> Task 3:</div> <div> When the printer ink cartridge or laser toner is used up, what will you do with it?</div> <div> Task 4:</div> <div> Open a WordPad file which has some pages of text in it. Press Ctrl and P keys from the</div> <div> keyboard simultaneously. Click on the radio button beside the Pages text box and type</div> <div> Virtual University of Pakistan</div> <div> 45</div> <div> Computer Proficiency License (CS001) VU</div> <div> “1-3” (without quotation marks). This setting will only print the first three pages of the</div> <div> current document.</div> <div> Task 5:</div> <div> Open a Notepad file and choose the print option from the file menu. From the print panel,</div> <div> increase the number of copies to be printed.</div> <div> Virtual University of Pakistan</div> <div> 46</div> <div> Computer Proficiency License (CS001) VU</div> <div> Computer Proficiency License (CS-001)</div> <div> Lecture 19</div> <div> Basic concepts of word processing</div> <div> 1. Objectives</div> <div> The objective of this lecture is to provide information about</div> <div> 􀁸 Open and close a word processor</div> <div> 􀁸 Open one and several documents</div> <div> 􀁸 Create a new document based on a document</div> <div> 􀁸 Save a document</div> <div> 􀁸 Switch between open documents</div> <div> 2. MS word Application</div> <div> To open a MS word document move the mouse cursor to the following path</div> <div> Start < All Programs < Microsoft Office < Microsoft Office Word 2003</div> <div> After clicking on the last option “Microsoft Office Word 2003” in the sub menu you will a dialogue</div> <div> box with “Microsoft Office Word 2003” written on it. This dialogue box is called splash screen.</div> <div> After few seconds splash screen will disappear and MS word will open.</div> <div> 3. Explaining Screen Layout</div> <div> Default screen layout is the layout of MS word when it is opened. We can change the default</div> <div> layout according to our will.</div> <div> In title bar, Name of the document with “Microsoft word” is written. If it’s a new document and not</div> <div> being saved yet, it will have temporary name like Document1, Document2 etc</div> <div> A file created by word processing software is called document.</div> <div> 4. Different Toolbars</div> <div> At the right side of the title bar, you can see three buttons</div> <div> 1- Minimize button – This button is used to minimize (An open window will appear as icon</div> <div> in task bar) the word document. To maximize this window, click on its icon at the taskbar.</div> <div> 2- Restore down button – This button is used to restore down the window to a smaller size</div> <div> on desktop.</div> <div> 3- Close button – This button is used to close down the document.</div> <div> Menu bar is a bar just below the title bar of the document. It contains menus (File, Edit, View etc)</div> <div> to give specific instructions to word processor. For example File menu contains commands like</div> <div> Save, Close, Exit for the open document. Edit menu contains editing related commands like cut,</div> <div> copy, paste for the text of word document.</div> <div> Separator is a dotted vertical line between two adjacent toolbars in MS word.</div> <div> To separate two toolbars, move mouse cursor over separator between these two toolbars. Mouse</div> <div> cursor will change its shape into four headed arrow (cross). Without releasing the mouse button,</div> <div> Virtual University of Pakistan</div> <div> 47</div> <div> Computer Proficiency License (CS001) VU</div> <div> drag this toolbar to desire location (Below the preceding toolbar, or in the document area).</div> <div> Toolbar will automatically adjust it self and hidden icons will appear in both toolbars.</div> <div> Below Menu bar, there is another bar called Standard tool bar. It contains icons/buttons to</div> <div> perform all important (standard) task of word processor like cut, copy, paste, save, print etc.</div> <div> Formatting toolbar resides next to Standard tool bar. It contains menus, buttons etc to format</div> <div> the text in word document.</div> <div> Task Pane is a panel visible on the right side of the document in default layout. It contains</div> <div> options like getting started, Open a document, create a new document etc.</div> <div> In the center of the document, you can see white area with blinking line. This white area is called</div> <div> page and the text we type will appear here. Blinking line is called cursor or typing pointer.</div> <div> Zoom option in standard tool bar helps to increase or decrease the zoom option of a document.</div> <div> To view the complete page, select “Page width” option from the zoom drop down menu.</div> <div> There are two rules places in a document.</div> <div> 1- Horizontal ruler</div> <div> 2- Vertical ruler</div> <div> These will give you a measure of width, length and margin of the page.</div> <div> MS document also contains two scroll bars</div> <div> 1- Vertical scroll bar is used to view page(s) of a document</div> <div> 2- Horizontal scroll bar is used to move page in left or right direction</div> <div> Status bar is a strip below horizontal scroll bar. It contains information like page no, section no,</div> <div> total number etc</div> <div> 5. Working with MS word</div> <div> Saving document</div> <div> To save a document, go to menu bar</div> <div> Click on File< Save</div> <div> A new dialogue box will open with “Save As” title</div> <div> Select the drive/folder from the drop down menu ”Save In”</div> <div> Type the name of file; you want to save as, in File name text area</div> <div> Click Ok.</div> <div> Save as dialogue box will be closed.</div> <div> File is saved and you can see its name on title bar</div> <div> If the document is saved successfully, its name will change from document1 to file name we save</div> <div> with. As new document is named Document with some number in title bar and once it will be</div> <div> replaced with the name of the file.</div> <div> Usually computer saves files in “My Document” but we can save our files in any other drive or</div> <div> folder we like.</div> <div> Sometime we need the same file or text for reuse. We can write the whole text again or just have</div> <div> another copy of the same file. Second option is more convenient so we will use it.</div> <div> To save the same file with different name, go to menu bar</div> <div> Click on File< Save As..</div> <div> Virtual University of Pakistan</div> <div> 48</div> <div> Computer Proficiency License (CS001) VU</div> <div> A new dialogue box will open with “Save As” title</div> <div> Select the drive/folder from the drop down menu”Save In”</div> <div> Type the name of file; you want to save as, in File name text area</div> <div> Click Ok.</div> <div> Save as dialogue box will be closed.</div> <div> File is saved and you can see its name on title bar</div> <div> Closing document</div> <div> To close a document</div> <div> 1- Click on File< Close</div> <div> 2- Click on the close button on right side of title bar</div> <div> If you try to close an unsaved document, a dialogue box will appear.</div> <div> It has three options</div> <div> 1- Yes – Click on this button, if you want to close the document after saving the file</div> <div> 2- No- Click on this button, if you want to close the file without saving the unsaved text</div> <div> 3- Cancel- click on this button, if you don’t want to close the file</div> <div> The documents we create using MS word are saved in form of files. These files are called</div> <div> document files.</div> <div> Opening document</div> <div> To open a document file</div> <div> 1- Double click on the file</div> <div> 2- Open MS word</div> <div> a. Click on File < Open</div> <div> b. Browse to the location and file</div> <div> c. Click on Open tab</div> <div> 6. Open one and several documents</div> <div> Whatever we do on computer, can be saved, in form of files. These files can be opened with</div> <div> double click on their icons. At any time, more than one file can be opened. For example, you can</div> <div> listen to some song and at the same time, you can work on multiple ms word files.</div> <div> 7. Switching among documents</div> <div> We can open and edit more than one document at a time.</div> <div> To switch to any file among the several open files, click on its name on task bar or press</div> <div> combination of Alt+Tab. This is called window switcher or application switcher. It’s a small</div> <div> dialogue box which shows icons for all open files and allows switching among these files.</div> <div> 8- Summary</div> <div> In this lecture you learnt</div> <div> 􀁸 Open and close a word processor</div> <div> 􀁸 Open one and several documents</div> <div> 􀁸 Create a new document based on a document</div> <div> 􀁸 Save a document</div> <div> 􀁸 Switch between open documents</div> <div> Virtual University of Pakistan</div> <div> 49</div> <div> Computer Proficiency License (CS001) VU</div> <div> 9- Exercise</div> <div> Task 1:</div> <div> NOTE: Following steps will only work if Microsoft Word is installed in your computer.</div> <div> Click on the Start button and then choose the Run menu option. A small window with a</div> <div> text box will open up. Type “winword” (without quotation marks) and observe what</div> <div> happens.</div> <div> Task 2:</div> <div> NOTE: This task is for those who have Windows XP installed on their computers.</div> <div> Right click on your Desktop area and then choose the Properties option. Display</div> <div> Properties window will open up. Select the Appearance tab from the top and then look</div> <div> foe a drop down list whose label is Color Scheme. Select the option of Olive Green.</div> <div> Press OK button to apply the setting.</div> <div> Task 3:</div> <div> Creating Microsoft Word shortcut on the Desktop:</div> <div> Click on the Start button and click on the All Programs menu option. Locate Microsoft</div> <div> Word option (if you have MS Office 2000 or older) or Microsoft Office (if you have MS</div> <div> Office 2003). Right click on the Microsoft Word option and drag it on to your Desktop</div> <div> area. Release the right mouse button, a small menu will pop up. Select 'Copy here' option</div> <div> from the menu to create a shortcut.</div> <div> Task 4:</div> <div> Open Microsoft Word. Right click on the empty space that you see after the Help menu. A</div> <div> long list will open up. You will find some option with check mark shown on their left side.</div> <div> Click on any one of the item that has a check mark on its side. Observe what happens.</div> <div> Task 5:</div> <div> Open Microsoft Office and see if the Task pane on the right side is also open. Close the</div> <div> pane if you find it there. Now click on the view menu and click on the Task pane option to</div> <div> open the pane again.</div> <div> Task 6:</div> <div> Open a fresh word document and type some text in it. Press Ctrl + O from the keyboard.</div> <div> A window for saving files will open up. Enter the required information and save the file</div> <div> you have just created. Now type some more text in the same file and press Ctrl + S from</div> <div> the keyboard. This shortcut key will save your current document file.</div> <div> Task 7:</div> <div> Open My Documents folder and locate any file that you have created earlier. Selected the</div> <div> file with a single mouse click. Do not double click on the icon. Now press F2 key from the</div> <div> keyboard. F2 key is located in the top left corner of your keyboard, near Escape and F1</div> <div> keys. After pressing the F2 key, you can type and change the name of the file. Same</div> <div> steps can be followed for changing folder name.</div> <div> Virtual University of Pakistan</div> <div> 50</div> <div> Computer Proficiency License (CS001) VU</div> <div> Computer Proficiency License (CS-001)</div> <div> Lecture 20</div> <div> Introduction of MS Word</div> <div> 1. Objectives</div> <div> The objective of this lecture is to provide information about</div> <div> 􀁸 How to insert new text in existing document</div> <div> 􀁸 How to select different portions of text in a document</div> <div> 􀁸 How to cut, copy, paste text in document</div> <div> 􀁸 How to delete text</div> <div> 􀁸 How to use find, replace options</div> <div> 2. Opening a document</div> <div> To open the existing document, first you need to open the software.</div> <div> Click on start < All Programs < Microsoft Office < Microsoft word 2003</div> <div> A new document will open. Click on File < Open or press Ctrl + O to open a new dialogue box.</div> <div> Select the drive or location from the drop down menu at the top of the dialogue box.</div> <div> Select file you need to open and click on open button</div> <div> There is another method commonly used to open an existing file.</div> <div> Go the folder/drive where your files exist.</div> <div> Double click on its icon to open the file</div> <div> 3. Inserting text in document</div> <div> Suppose you have to add a line or paragraph in an existing document. First of all, you need to</div> <div> open this file. There would be a blinking line at the start of document. This blinking line is called</div> <div> cursor. It is similar to English alphabet “I”. Click at the point where you want to add some text.</div> <div> Cursor will be at that point now. Whatever you type will be written here.</div> <div> 4. Selecting text</div> <div> To edit or format text, it has to be selected first. Editing is the process of changing word or</div> <div> sentences in any document. Formatting helps in making text more visible or attractive. Either its</div> <div> editing or formatting, you need to select the text to do either on it. Text selection may include a</div> <div> single letter, a complete word, a sentence, a line, a paragraph or a complete document. We can</div> <div> use mouse pointer and keyboard for text selection.</div> <div> 5. Selecting single letter</div> <div> Bring your mouse near the letter, you need to select. Press the left mouse click for once and</div> <div> without leaving the button, drag to the end of letter. Letter has been selected.</div> <div> You can select a letter with the help of keyboard as well, if you know how to use arrow keys.</div> <div> 6. Selecting a word</div> <div> To select a word with mouse, bring your mouse cursor over the word and double click. It will</div> <div> select the whole word.</div> <div> Virtual University of Pakistan</div> <div> 51</div> <div> Computer Proficiency License (CS001) VU</div> <div> To select a word using keyboard, you have to bring the cursor, near the start of the word, press</div> <div> ctrl+shift and right arrow key. Word is selected.</div> <div> 7. Selecting a sentence</div> <div> To select a complete sentence, keyboard and mouse are used. Click at the start of the sentence</div> <div> and then press Ctrl. Without releasing Ctrl key click once over the sentence. Whole sentence will</div> <div> be selected.</div> <div> 8. Selecting line</div> <div> To select a line, click at the start of the line and move the cursor little to left side, until it changes</div> <div> its shape to mouse pointer. Now click once. Whole line will be selected.</div> <div> Keyboard can also be used to select a line. Click in the start of the line. Press Shift+ end.</div> <div> 9. Paragraph selection</div> <div> To select a paragraph, click at the start of the line and move the cursor little to left side, until it</div> <div> changes its shape to mouse pointer. Now double click. Whole paragraph will be selected.</div> <div> To select a paragraph, using keyboard, click at the start of the paragraph. Press Ctrl, Shift and</div> <div> down area key. It will select whole paragraph.</div> <div> 10. Body text selection</div> <div> To select whole document via mouse, click at the start of the document and move the cursor little</div> <div> bit to the left side, until it changes its shape to mouse pointer. Now click 3 times at once. Whole</div> <div> document will be selected.</div> <div> To select whole document, using keyboard, click anywhere in the document and press Ctrl+A</div> <div> 11. Inserting text</div> <div> Document editing includes</div> <div> 1. Type new text in a document</div> <div> 2. Replace text with new text</div> <div> 3. How to revert change in typed text</div> <div> Click anywhere you want to add new text or move cursor to that position using arrow keys. Start</div> <div> typing required text. New text will be added.</div> <div> 12. Inserting symbols</div> <div> Bring your cursor to the position where you want to add symbol using keyboard arrow keys or</div> <div> mouse click. Go to Insert < Symbol</div> <div> A new dialogue box will open with lots of symbols and special characters. Select anyone of these</div> <div> and click on Insert button.</div> <div> 13. Overtyping text</div> <div> Virtual University of Pakistan</div> <div> 52</div> <div> Computer Proficiency License (CS001) VU</div> <div> Overtyping mode is the typing mode in which new letters being typed replace the old letters. To</div> <div> enable this mode, press Insert key on your keyboard.</div> <div> 14. Cut and paste text</div> <div> To cut select the text you need to cut, press Ctrl+X or Edit < Cut</div> <div> Click at the place where you want to paste the text, press Ctrl+V or Edit < Paste</div> <div> 15. Copy and paste text</div> <div> To copy select the text you need to cut, press Ctrl+C or Edit < Copy</div> <div> Click at the place where you want to paste the text, press Ctrl+V or Edit < Paste</div> <div> 16. Deleting text</div> <div> Select the text, you want to delete and press Delete button on keyboard.</div> <div> 17. Undo and redo commands</div> <div> In case you make some mistake, you can undo it by pressing Ctrl+Z or Edit < Undo</div> <div> To redo your undo action, press Ctrl+Y or Edit < Redo</div> <div> 18. Find text</div> <div> Press Ctrl+F or Edit < Find to open the Find and Replace dialogue box.</div> <div> Enter word(s) you need to find in the text box and click on Find Next button.</div> <div> 19. Find and replace text</div> <div> Press Ctrl+H or Edit < Replace to open the Find and Replace dialogue box.</div> <div> Enter word(s) you need to find in the “Find what” text box.</div> <div> Enter word(s) you need to replace with in the “Replace with” text box</div> <div> If you click on Replace button, it will replace first found text with the give option whereas if you</div> <div> want to replace the text in the whole document, click on Replace All button</div> <div> 20. Summary</div> <div> In this lecture you learnt that:</div> <div> 􀁸 How to insert new text in existing document</div> <div> 􀁸 How to select different portions of text in a document</div> <div> 􀁸 How to cut, copy, paste text in document</div> <div> 􀁸 How to delete text</div> <div> 􀁸 How to use find, replace options</div> <div> 21. Exercise</div> <div> Task 1:</div> <div> Open Microsoft Word. Press Ctrl + O shortcut keys from the keyboard. A window will</div> <div> open up. From this window you can select and open your word documents.</div> <div> Task 2:</div> <div> Click on the Start button. Take your mouse pointer on the All Programs item. Locate the</div> <div> 'Open Office Document' option and click on it to open a window. This will take you to the</div> <div> My Documents folder from where you can select and open your created documents.</div> <div> Virtual University of Pakistan</div> <div> 53</div> <div> Computer Proficiency License (CS001) VU</div> <div> Task 3:</div> <div> Open a document that has some text in it.</div> <div> Press Ctrl + A to select all the text in it.</div> <div> Press Ctrl + C to copy the selected text.</div> <div> Press Ctrl + N to open a new blank file.</div> <div> Press Ctrl + V to paste the copied text in this new blank file.</div> <div> Press Ctrl + S to save this new file. Enter the relevant information and press the Save</div> <div> button.</div> <div> Press Alt + F and then press C keys to close the newly created file.</div> <div> Task 4:</div> <div> Open a fresh document and type the following signs given below. Observe as you type</div> <div> these signs.</div> <div> ==></div> <div> --></div> <div> <==</div> <div> (c)</div> <div> (r)</div> <div> (tm)</div> <div> <=></div> <div> Task 5:</div> <div> Open a document file and select some text.</div> <div> Press Delete key to delete the selected text.</div> <div> Press Ctrl + Z to bring back the deleted text.</div> <div> Press Ctrl + Y to revert the last step of Undo.</div> <div> Virtual University of Pakistan</div> <div> 54</div> <div> Computer Proficiency License (CS001) VU</div> <div> Computer Proficiency License (CS-001)</div> <div> Lecture 21</div> <div> Text Formatting</div> <div> 1. Objectives</div> <div> The objective of this lecture is to provide information about</div> <div> 􀁸 What does the formatting means?</div> <div> 􀁸 How can we format our documents?</div> <div> 􀁸 Which options are included in document formatting?</div> <div> 􀁸 How to use the format menu?</div> <div> 􀁸 How to use formatting options?</div> <div> 2. What is formatting?</div> <div> Format means appearance of a thing whereas formatting is the process of changing or improving</div> <div> that appearance. Document formatting includes page, font and paragraph settings.</div> <div> Keyboard shortcut is a combination of keys, when pressed simultaneously, perform some task</div> <div> that ordinary requires use of mouse or other input device and may take longer to do.</div> <div> 3. Document formatting</div> <div> Document has some empty space at the top, bottom, left and right side of the page. This empty</div> <div> space is called margins. We can vary the size of margin according to our needs.</div> <div> 4. Header and footer option</div> <div> The text that appears in the top margin of the paper is called header. The text region that</div> <div> appears in the bottom of the paper is called footer. Changes made in header and footer of one</div> <div> page appears in all pages of the document. With the help of this feature, we can automatically</div> <div> have same header and footer in every page without hassle.</div> <div> To set the header and footer text, open View menu and click on the “Header and Footer” option.</div> <div> A “Header and Footer” toolbar and visible rectangle text box will appear in the document. This</div> <div> rectangle text box is document header and footer regions. You can enter any text in the header</div> <div> region. Footer region is not visible at that moment. To go to footer region now, click on “Switch</div> <div> between header and footer” button.</div> <div> We can type text or insert auto text in footer section. Auto text is the text that word processor can</div> <div> add in document. For example to display page number, or document creation date, time etc we</div> <div> can use this feature. As you can see in the figure, there is option of Insert AutoText at the left side</div> <div> of the toolbar. Click on the arrow along with it and ten options for auto text will appear.</div> <div> 5. Text formatting</div> <div> Text formatting includes formatting of a letter, word, sentence, paragraph or whole document. To</div> <div> apply any kind of formatting, the text needs to be selected first. To apply different kind of</div> <div> formatting, we use formatting toolbar or keyboard shortcuts.</div> <div> Virtual University of Pakistan</div> <div> 55</div> <div> Computer Proficiency License (CS001) VU</div> <div> 6. Applying existing style</div> <div> The highlighted drop down menu is style menu. By default it contains only six options: three for</div> <div> heading style, one for clear formatting and one for normal style.</div> <div> 7. Changing font</div> <div> lick on the drop down menu to see the list</div> <div> . Changing font size</div> <div> Every font style comes into different sizes. Click on the font size</div> <div> ,</div> <div> uttons for bold (Ctrl+B), italic (Ctrl+I) and underline</div> <div> ta</div> <div> C</div> <div> of installed fonts in your pc. Click on any font</div> <div> name to apply it on selected text.</div> <div> 8</div> <div> drop down menu’s arrow to see the available sizes. To enter font</div> <div> size, click on the text area, and enter required font size like 8.5, 10</div> <div> 15, or 70 etc.</div> <div> 9. Bold, Italics and Underline</div> <div> You can see three b</div> <div> (Ctrl+U) text in the following figure. First select text and than click on any</div> <div> button to get the required formatting. You can also have a combination</div> <div> formatting like Bold-i lic text, Bold-underline text or italic-underline etc.</div> <div> 10. Text alignment</div> <div> elected text can be left aligned, center aligned, right aligned or justified</div> <div> 1. Line spacing</div> <div> ine spacing is the distance/space between any two lines of the document. It</div> <div> e</div> <div> .</div> <div> 2. Text indentation</div> <div> the highlighted area of the formatting toolbar, first button is to “Decrease</div> <div> eas,</div> <div> 3. Bullets and numbering</div> <div> o stylize your lists, select the text and click on any of these buttons. You can have</div> <div> 4. Border and shading</div> <div> S</div> <div> aligned using these four buttons in the formatting menu.</div> <div> 1</div> <div> L</div> <div> makes reading easy for us. By default line spacing is set to single line space. W</div> <div> might give our document to editor for proof reading or to prepare some project,</div> <div> proposal or thesis etc. In that case, we can change the space between two lines</div> <div> arrow along the button shown in the figure, to see the options available for the line spacing.</div> <div> Click on the</div> <div> 1</div> <div> In</div> <div> indentation” of the text and second button is to “Increase indentation”.</div> <div> By decreasing indent, text will move towards left side of the page, wher</div> <div> increase would move text to right side of the page.</div> <div> 1</div> <div> T</div> <div> more options from Format < “Bullets and Numbering…” option.</div> <div> 1</div> <div> Virtual University of Pakistan</div> <div> 56</div> <div> Computer Proficiency License (CS001) VU</div> <div> You can put the border around text or picture using “Border” feature in formatting toolbar. There</div> <div> 5. Applying page border</div> <div> n also apply border around page. To apply border go to</div> <div> r and shading option.</div> <div> 6. Paragraph formatting</div> <div> every document sentences join together and create a paragraph. We create paragraphs to</div> <div> o view paragraph in our document we turn on the paragraph option. Click on the show/hide</div> <div> the</div> <div> f</div> <div> 7. Indenting paragraph</div> <div> hen a document is created all the text is aligned to left margin. The settings that have already</div> <div> New Roman</div> <div> are different by default styles available.</div> <div> 1</div> <div> Just like text and paragraph, we ca</div> <div> Format < Borders and Shading…</div> <div> A new window will open with borde</div> <div> 1</div> <div> In</div> <div> make our document more presentable and readable. A paragraph is created when we press</div> <div> “Enter” key from the keyboard after typing some lines. Even if you press enter after typing a</div> <div> single line, it will be considered as new paragraph.</div> <div> T</div> <div> button on the standard toolbar.</div> <div> Some extra dots and</div> <div> symbols will appear in</div> <div> document. There are dots</div> <div> between words and the</div> <div> special symbol at the end o</div> <div> know where extra spaces are and paragraph starts. To turn off these dots and paragraph marks</div> <div> we click on the same button again.</div> <div> every paragraph. With the help of the dots and symbols you get to</div> <div> 1</div> <div> W</div> <div> been made in the software are called default settings. Default settings of a document are</div> <div> Text is left aligned</div> <div> Font style is Times</div> <div> he ruler at the top shows width of the page and one on the left show length of the page.</div> <div> there is</div> <div> de with first</div> <div> n the left side, upper triangle is to indent first line of the paragraph. Below first line indent, there</div> <div> T</div> <div> The dark area in this bar is actually the margin of the page. Between the dark portion,</div> <div> white region in the ruler. At the edge of dark and white region, we see some geometrical shapes.</div> <div> On the left there are three and on the right there is only one. These are called paragraph</div> <div> indentation marks. We can change indentation of paragraph through these marks.</div> <div> Documents may have different formatting and paragraph indentation. Paragraphs ma</div> <div> line indent are called semi blocked paragraphs. Paragraphs made without first line indent are</div> <div> called blocked paragraphs. Blocked paragraph requires single line space between them so that</div> <div> paragraphs can be easily identified.</div> <div> O</div> <div> is another geometrical shape. It is hanging line indent and used to push the lines of the paragraph</div> <div> except the first line. Just below it a triangle shape exists. It is called left indent and use to indent</div> <div> the whole paragraph on the left side.</div> <div> Virtual University of Pakistan</div> <div> 57</div> <div> Computer Proficiency License (CS001) VU</div> <div> On the right side of the ruler, there is only one marker, and it is called right indent. It is use to</div> <div> push a paragraph from the right side.</div> <div> 18. Paragraph spacing</div> <div> Space between paragraphs make document more readable. To change the spacing between</div> <div> paragraph goes to Format < Paragraphs…</div> <div> You will see the options for Indentation and spacing, Line and page break.</div> <div> 19. Summary</div> <div> In this lecture you learnt:</div> <div> 􀁸 What does the formatting means?</div> <div> 􀁸 Formatting options for document</div> <div> 􀁸 Format menu for MS word</div> <div> 􀁸 Text, paragraph and document formatting options</div> <div> 20. Exercise</div> <div> Task 1:</div> <div> Open a fresh document.</div> <div> Locate the ruler on left side of Microsoft Word window.</div> <div> Double click on the white area of this ruler.</div> <div> Page Setup panel will open up for document formatting.</div> <div> Task 2:</div> <div> Open the page setup panel of a document and explore the tabs before completing the</div> <div> following steps.</div> <div> Change the paper size to Legal.</div> <div> Change page orientation to Landscape.</div> <div> Set all the four margins to 1 inch.</div> <div> Turn ON the 'Different first page' option.</div> <div> Task 3:</div> <div> Open a fresh document.</div> <div> Click on View menu and choose the Header and Footer option.</div> <div> In the Header section type your name.</div> <div> Scroll down using the vertical scroll bar on the right side of the page.</div> <div> Press Alt + I and then press T from the keyboard.</div> <div> Choose a Date and Time format from the list.</div> <div> Press OK button to insert the selected Date and Time format.</div> <div> Click on the Close button in the Header and Footer toolbar to apply the changes.</div> <div> Scroll up and down the page to view the changes made by you.</div> <div> Task 4:</div> <div> Open a document with some text in it.</div> <div> Select a line and then click on Format 􀀀 Borders and Shading menus.</div> <div> Select 'Shadow' option from the Settings section.</div> <div> Select dotted line style from the 'Style' list.</div> <div> Select appropriate width of the line.</div> <div> Press OK to apply changes.</div> <div> Virtual University of Pakistan</div> <div> 58</div> <div> Computer Proficiency License (CS001) VU</div> <div> Computer Proficiency License (CS-001)</div> <div> Lecture 22</div> <div> Tables</div> <div> 1. Objectives</div> <div> The objective of this lecture is to provide information about</div> <div> 􀁸 How to create tables using MS word?</div> <div> 􀁸 How to change column width and height?</div> <div> 􀁸 How to insert and delete columns and rows from table?</div> <div> 􀁸 How to format borders and change colors?</div> <div> 􀁸 How to use images in documents?</div> <div> 2. Tables – An introduction</div> <div> We usually use text in our documents. We can also use charts, graphs and pictures in our</div> <div> document file. Tabular data makes it easier for the reader to understand the information provided.</div> <div> Example of tabular data can be</div> <div> Time table</div> <div> Employee contact list</div> <div> Product sales report</div> <div> Drawing, charts and pictures can make a document look better and easy to understand.</div> <div> 3. Creating tables and inserting data</div> <div> To create table go to Table < Insert < Table</div> <div> A new window for “Insert table” will appear as</div> <div> shown in the figure</div> <div> Enter the number of columns and rows you need</div> <div> in a table and click on OK button.</div> <div> 4. Modifying column and rows</div> <div> The height of rows and columns are adjusted automatically. We can also adjust column height</div> <div> and width of the row.</div> <div> To change the height of the row, move mouse pointer to the bottom edge of the row. It will</div> <div> change its shape into a cross. Now click and drag the cursor to the height you want.</div> <div> To change the column width, repeat the same process with a difference. Keep cursor position on</div> <div> the vertical edge to drag it.</div> <div> 5. Insert column and rows</div> <div> It is recommended that we plan about number of column and rows before creating table. But in</div> <div> case we need more column and rows, we can add it in existing table.</div> <div> Virtual University of Pakistan</div> <div> 59</div> <div> Computer Proficiency License (CS001) VU</div> <div> To add a column in a table, click on the cell, you want to add column with and go to</div> <div> Table < Insert < Columns to the left or Table < Insert < Columns to the right</div> <div> 6. Deleting column and rows</div> <div> To delete any column or row, select any cell in that column or row and go to</div> <div> Table < Delete < Columns or Table < Delete < Rows</div> <div> 7. Modifying border color and shapes</div> <div> Table formatting includes border style and cell shading. To</div> <div> format a table, first you need to select it using it’s selector at</div> <div> the top left side. It will select whole table with one click. Now</div> <div> go to Format < Borders and Shading…</div> <div> You can change style, color and width of the border line from the options given in the window</div> <div> opened.</div> <div> 8. Working with pictures</div> <div> While preparing our document we usually emphasize on the text and its formatting but we can</div> <div> make our document more presentable using pictures and images. To insert a picture in a</div> <div> document go to Insert < Picture < Clip art</div> <div> A new window will appear in the document. Enter the name of the picture you want to search. For</div> <div> example type ”computer” and click on go button. Few pictures will appear in front of you. Double</div> <div> click on any picture and it will appear in your document. Picture toolbar will also appear.</div> <div> This icon will open the file browser to insert picture from your pc.</div> <div> It will change the color of selected picture.</div> <div> It is used to increase the contrast of the image.</div> <div> It will decrease the contrast of the image.</div> <div> This feature will increase the brightness of the picture.</div> <div> You can decrease the brightness of the image by single click on this icon.</div> <div> Click on this icon to crop the picture.</div> <div> Click on this icon to rotate the picture at 90 degree.</div> <div> This icon will display options for line style.</div> <div> This feature is used to compress the picture.</div> <div> It is very useful feature to prepare the document. It makes pictures to align with text in the</div> <div> document.</div> <div> A new window will open once this icon is clicked. It is used to change the pictures properties</div> <div> manually.</div> <div> This feature is used to set the transparent color.</div> <div> This icon will undo the changes made on pictures using picture tool bar options.</div> <div> Virtual University of Pakistan</div> <div> 60</div> <div> Computer Proficiency License (CS001) VU</div> <div> 9. Summary</div> <div> In this lecture you learnt:</div> <div> 􀁸 Creation of tables in word processor</div> <div> 􀁸 Changing table columns width and height</div> <div> 􀁸 Insertion and deletion of columns and rows of table</div> <div> 􀁸 Formatting of table borders</div> <div> 􀁸 Use of pictures and images in document</div> <div> 10. Exercise</div> <div> Task 1:</div> <div> Open a fresh document. Click on the Table 􀀀 Insert 􀀀 Table menus. Create a table of 6</div> <div> columns and 10 rows.</div> <div> Task 2:</div> <div> Select the first row of the table created in the previous step.</div> <div> Change the background color of this row.</div> <div> Select the first column of the table.</div> <div> Change line style of this column.</div> <div> Task 3:</div> <div> Bring your mouse pointer on the table created in previous step. You will see a small</div> <div> square at the bottom right corner of the table. Click on this box with left mouse button and</div> <div> drag it downwards. Observe what happens.</div> <div> Task 4:</div> <div> Create a table with 5 columns and 7 rows. Enter some text in the first row as columns</div> <div> headings. The text should be of variable length so that the columns may have variable</div> <div> width. Now select the whole table and right click on the selected area. Select the option</div> <div> 'Distribute Columns Evenly' from the menu.</div> <div> Task 5:</div> <div> Select the third column of the table created in the previous task. Pres Shift + Delete keys</div> <div> from the keyboard to delete this selected column.</div> <div> Task 6:</div> <div> Select the fourth row of the table created in Task 4. Click on the Table 􀀀 Insert 􀀀 Rows</div> <div> Below. This will add a row below the selected row.</div> <div> Task 7:</div> <div> Create a fresh document and type some text in it. Click in the center of a sentence to</div> <div> bring the cursor. Click on the Insert 􀀀 Picture 􀀀 Clip Art menus. A pane will open up on</div> <div> the right side. In the upper portion of this pane there is a text box. Type the word</div> <div> 'computer' (without quotation marks) in it and press the 'Go' button next to it. Select a</div> <div> picture and insert it in the document.</div> <div> Task 8:</div> <div> Right click on the picture you have just inserted in the document and select the option</div> <div> 'Show Picture Toolbar'. Click on the 'Text Wrapping' button and choose the 'Through'</div> <div> option. Drag the corners of the picture to adjust the size according to your need.</div> <div> Virtual University of Pakistan</div> <div> 61</div> <div> Computer Proficiency License (CS001) VU</div> <div> Computer Proficiency License (CS-001)</div> <div> Lecture 23</div> <div> Mail Merge</div> <div> 1. Objectives</div> <div> The objective of this lecture is to provide information about</div> <div> 􀁸 What is mail merge and why we use it?</div> <div> 􀁸 What are the important steps of mail merge?</div> <div> 􀁸 How to create a mailing list?</div> <div> 􀁸 How to create a mailing list with a document?</div> <div> 􀁸 How to prepare mailing envelopes?</div> <div> 􀁸 How to take print outs of a merged documents</div> <div> 2. Basic concepts</div> <div> In merged mail we have some information that is merged with other letters to be posted after</div> <div> words. This mail can be our postal mail or electronic mail send by our pc. We use the mail merge</div> <div> feature provided by a word processor to merge out our information with letters and prepare them</div> <div> for delivery.</div> <div> Mail merge comprised of two steps.</div> <div> 1. Prepare your letter or invitation.</div> <div> 2. Prepare the list of people who will receive this letter.</div> <div> 3. Merge the information from the list into main letter.</div> <div> For example we need to send university students a convocation letter. Such invitation or letter is</div> <div> addressed to different person. Text of the invitation will be the same but the name of the students</div> <div> and their addresses will be different.</div> <div> To develop invitations using mail merge feature do the following steps</div> <div> 1. Create a letter/invitation with temporary labels like title, first name, last name, city</div> <div> 2. Go to Tools < Letters and Mailing… < Invitation. A panel for mail merge will open in the</div> <div> document.</div> <div> 3. Select “Letters” radio button in the document type and click on the next: Starting</div> <div> document in the bottom of the panel.</div> <div> 4. Select “Use the current document” and click on the “Next: Select recipients”</div> <div> 5. Select “Type a new list” and click on Create… A new window will open with text fields.</div> <div> Enter information in text fields and click on OK. It will ask you to save the list. Enter</div> <div> “Students” and press enter. Click on “Next: write your letter”</div> <div> 3. Editing a merged list</div> <div> It is very easy to edit a list or add/delete</div> <div> a record in list.</div> <div> Click on the Mail recipient button in mail</div> <div> merge toolbar. A new window will open with list you develop. Select any entry and click on Edit</div> <div> button in the window to do any changes. Once you enter into the edit mode for the particular list</div> <div> entry, you can delete, find, sort and add new entry.</div> <div> 4. Merging to a document</div> <div> Every record after merging with the main letter gives a personalized letter. Every student will get</div> <div> the feeling that letter was especially made for him.</div> <div> Virtual University of Pakistan</div> <div> 62</div> <div> Computer Proficiency License (CS001) VU</div> <div> To merge main letter with list of students, click on the “Merge to New document” button in the</div> <div> Mail merge toolbar. A small window will open with following options for merging records.</div> <div> 1. Selecting “All” will merge and create letters for all records in the data list.</div> <div> 2. “Current Record” will merge and create letters for only the record that is visible on the</div> <div> screen</div> <div> 3. “From _____ To _______” will merge and create letters for only the mentioned range of</div> <div> records</div> <div> Select “All” and click on OK button. It will create letters for all students in no time. Now save this</div> <div> document for future use.</div> <div> 5. Creating mailing envelopes</div> <div> Letters prepared through mail merge are delivered to the destination address.</div> <div> For our example, envelops will be made for same students. We have already</div> <div> prepared and saved an address list.</div> <div> To display the mail merge tool bar, go to View < Toolbars < Mail Merge</div> <div> Most of the buttons are disabled at the moment. Click on the first button “Main document setup”.</div> <div> A small window will open. Select “Envelop” option and click on OK button. A new window will</div> <div> open for envelop development. Let the by default options (size 10) for envelop size and click on</div> <div> Ok button. Size of the document will be changed. This is not a page anymore. It is envelop that</div> <div> we have selected in the previous step.</div> <div> Click at the top left corner of envelop and write the return address. Now click at the center of</div> <div> envelop. A cursor will start blinking there. Click on the 2nd icon in the Mail Merge tool bar and</div> <div> browse to the student’s record file.</div> <div> The buttons in the Mail Merge tool bar are now enabled and</div> <div> can be used. Click on the “Insert Merge Field” button. A list will</div> <div> open with address list. We will use some fields to create</div> <div> delivery address. Select the field you want to enter and click on</div> <div> insert. Like this insert all required fields and click on Ok. We can arrange these fields entered with</div> <div> space and enter.</div> <div> To view the merged data, click on “View Merged Data” button in Mail Merge tool bar. Real record</div> <div> will replace address fields. To view other record, click on the navigation buttons in tool bar.</div> <div> 6. Printing a merged document</div> <div> Click on the “Merge to Printer” button in tool bar. Select “All” from the Merge to Printer window to</div> <div> take prints for all records. Soon after you click on the OK button, a new window will open for</div> <div> printer. Click on Ok button to send print request to printer.</div> <div> Virtual University of Pakistan</div> <div> 63</div> <div> Computer Proficiency License (CS001) VU</div> <div> 7. Summary</div> <div> In th le</div> <div> mail merge</div> <div> cument</div> <div> 􀁸 Taking print outs of a merged documents</div> <div> . Exercise</div> <div> Task 1:</div> <div> rge exercise.doc</div> <div> This file contains detailed instructions for a Mail Merge exercise.</div> <div> is cture you learnt:</div> <div> 􀁸 What is mail merge and its use?</div> <div> 􀁸 Important steps use for</div> <div> 􀁸 Creating a mailing list</div> <div> 􀁸 Creating a mailing list with do</div> <div> 􀁸 Preparing mailing envelopes</div> <div> 8</div> <div> Click on the menus and select the file mentioned below:</div> <div> Start < All Programs / Programs < VU-CPL < Module 3 < Mail Me</div> <div> Virtual University of Pakistan</div> <div> 64</div> <div> Computer Proficiency License (CS001) VU</div> <div> Computer Proficiency License (CS-001)</div> <div> Lecture 24</div> <div> Preparing output</div> <div> 1. Objectives</div> <div> The objective of this lecture is to provide information about</div> <div> 􀁸 How to review and proof read a document</div> <div> 􀁸 How to use word processor to proof read</div> <div> 􀁸 How to remove spelling and grammar mistakes</div> <div> 􀁸 How to take print outs of a document</div> <div> 􀁸 How to make use of different printing options</div> <div> 2. Reviewing a document</div> <div> When a document is prepared, it is thoroughly checked with different perspective. A document is</div> <div> checked for its layout and information provided in it. Documents are also checked for its spelling</div> <div> and grammar mistakes. We should review our document made with the help of word processing</div> <div> application.</div> <div> A complete document review includes</div> <div> 1. Complete page layout</div> <div> 2. Page margins and numbering</div> <div> 3. Header and footer settings</div> <div> 4. Text and paragraph settings</div> <div> A very important part of document review is spelling and grammar check. A word processor gives</div> <div> us a very important feature of spelling and grammar check. It indicates any spelling mistake in the</div> <div> document and points out any grammatical mistake as well. While writing in MS word, spelling</div> <div> mistakes are shown by red lines and grammar mistakes are shown by green lines. Using the</div> <div> spelling and grammar check feature, we can remove mistakes from our document.</div> <div> There are two methods to correct such mistakes in document.</div> <div> 1. We can use the spelling and grammar check</div> <div> feature. Go to the start of the document. Click o</div> <div> button highlighted in the figure. It will open a</div> <div> new dialogue box with correct options. You can</div> <div> do the correction, ignore it or add it to dictionary.</div> <div> n</div> <div> 2. We can use the right click of our mouse. Right click on the word with red line below it to</div> <div> see the available corrected options.</div> <div> Virtual University of Pakistan</div> <div> 65</div> <div> Computer Proficiency License (CS001) VU</div> <div> Words not included in computer dictionary are highlighted as mistakes. For example nouns like</div> <div> Places; Muslim names etc are considered as spelling mistakes. We can add such words in</div> <div> dictionary so that they are not considered as mistake next time.</div> <div> Right click on the highlighted word, and select “Add to Dictionary”</div> <div> The green wavy line under the sentence represents a grammatical mistake. Computer is</div> <div> suggesting you to revise the fragment from the grammar perspective.</div> <div> 3. Printing a document</div> <div> We can take prints of a document prepared in word processor. The files created using software</div> <div> and saved in computer called “soft copy”. It is a good practice to have the print preview of your</div> <div> documents. Click on print preview button to see the preview of the document file before print.</div> <div> After viewing the preview, we can come back to the document by clicking on the close button.</div> <div> To take the print you can do any of the following.</div> <div> 1. Click on the print button to take print.</div> <div> 2. Go to File < Print</div> <div> 3. Press Ctrl + P</div> <div> A dialogue box will open in case, either option is followed.</div> <div> You will see different options available for print.</div> <div> You can select All, only current page, or page range for prints</div> <div> Multiple copies can be sent to printer at a time of a document with a single click.</div> <div> Zoom and scaling options can be set for pages being sent to printer.</div> <div> Virtual University of Pakistan</div> <div> 66</div> <div> Computer Proficiency License (CS001) VU</div> <div> 4. Summary</div> <div> In this lecture you learnt:</div> <div> 􀁸 Review and proof reading of a document</div> <div> 􀁸 Using word processor to proof read</div> <div> 􀁸 Removing spelling and grammar mistakes</div> <div> 􀁸 Taking print outs of a document</div> <div> 􀁸 Different print out options</div> <div> 5. Exercise</div> <div> Task 1:</div> <div> Visit some office and explore how they use printers in a network environment.</div> <div> Task 2:</div> <div> There are different types of printers available in the market. If you have to buy a printer,</div> <div> which factors will you consider deciding which one is best for your requirement?</div> <div> Task 3:</div> <div> When the printer ink cartridge or laser toner is used up, what will you do with it?</div> <div> Task 4:</div> <div> Open a Notepad file and choose the print option from the file menu. From the print panel,</div> <div> increase the number of copies to be print.</div> <div> Task 5:</div> <div> Open a Microsoft Word file which has some pages of text in it (at least 7 pages). Press</div> <div> Ctrl and P keys from the keyboard simultaneously. Click on the radio button beside the</div> <div> Pages text box and type “1-3, 6” (without quotation marks). This setting will only print the</div> <div> first three pages and the sixth page of the current document.</div> <div> Virtual University of Pakistan</div> <div> 67</div> <div> Computer Proficiency License (CS001) VU</div> <div> Computer Proficiency License (CS-001)</div> <div> Lecture 25</div> <div> Basic concepts of MS Excel</div> <div> 1. Objectives</div> <div> The objective of this lecture is to provide information about</div> <div> 􀁸 How to start spreadsheet software?</div> <div> 􀁸 Components of spreadsheet software</div> <div> 􀁸 How to create and Close spreadsheets?</div> <div> 􀁸 How to save spreadsheets?</div> <div> 􀁸 How to open one, several spreadsheets?</div> <div> 􀁸 How to switch among several spreadsheets?</div> <div> 􀁸 How to save a spreadsheet under another name?</div> <div> 􀁸 How to exit from spreadsheet?</div> <div> 2. Starting spread sheet software</div> <div> Microsoft Excel is popular and widely used spread sheet software.</div> <div> To open the excel file</div> <div> Click on start < All Programs < Microsoft Office < Microsoft Excel2003</div> <div> In the start a screen will appear for few seconds. This is called splash screen. A new excel file will</div> <div> open, after this screen would disappear. The by default arrangement of toolbars panels and</div> <div> sheets is called default layout.</div> <div> 3. Screen components</div> <div> 􀃎 Title bar: The most upper bar of window is called title bar. Its top left corner shows the</div> <div> document default name like “Microsoft Excel Book1” which shows document is of type Microsoft</div> <div> Excel and its temporary name is Book1.When we save the document we can give another name</div> <div> to document.</div> <div> A file created by spread sheet software is called work book. On the right side of title bar there are</div> <div> three buttons. Minimize button is used to minimize the workbook. Restore button is use to restore</div> <div> down the workbook and close button is use to close it.</div> <div> 􀃎 Menu bar: There is another bar after the title bar is called menu bar. Menu bar contains</div> <div> different options to use features of excel like file, edit, view etc</div> <div> For using any main menu we just move the mouse cursor over it and it will show submenu.</div> <div> 􀃎 Toolbar: The strip next to menu bar is toolbar. Toolbar is shortcut of menu bar sub options.</div> <div> Virtual University of Pakistan</div> <div> 68</div> <div> Computer Proficiency License (CS001) VU</div> <div> We can use these options by clicking icons. For knowing the purpose of these icons just take the</div> <div> mouse pointer over there and wait for a while you will see name of this icon in form of label. This</div> <div> label is called tool tip text.</div> <div> 􀃎 Task pan: When you start the spreadsheet software you will find a panel on the right side. It is</div> <div> called task pan. On the top of task pan “Getting started” is written and you will find options such</div> <div> as seek online help, open recently opened excel files and create a new work book etc.</div> <div> 􀃎 Worksheet area: An excel workbook appears on</div> <div> the screen showing white cells, is called worksheet</div> <div> area. Worksheet area is divided in rows and</div> <div> columns and the area where the rows and columns</div> <div> intersect is called a cell. Worksheet consists of</div> <div> different cells. Each cell has a name which is referred as its address.</div> <div> In worksheet columns are shown in alphabets while rows are shown in numbers.</div> <div> 􀃎 Name Box and Formula bar: There are two bars at</div> <div> the top of excel sheet for active cell name and</div> <div> formula/content of the cell. These are called name box</div> <div> and formula bar.</div> <div> Name box shows address of the active cell name.</div> <div> Formula bar shows the contents of the cell.</div> <div> 􀃎 Sheet Tab: In the end of worksheet there are few buttons; called sheet tab. Sheet tabs are</div> <div> used to move between worksheets in a spreadsheet. You can work on three work sheets</div> <div> simultaneously.</div> <div> 􀃎 Status bar: The bar at the bottom is called status bar which shows the status of document.</div> <div> 4. Creating a new spread sheet</div> <div> To create a new spreadsheet use “NEW” option from file menu.</div> <div> 1- Go to File < New</div> <div> 2- Click on “Blank work book” in the Task Pan in the right side of the MS Excel.</div> <div> 3- A new work book will be opened.</div> <div> Another way to open new file is use “New” icon from tool bar .</div> <div> 5. Saving a new spreadsheet</div> <div> After creating the spreadsheet the next step is to save them. We will use “SAVE” command of file</div> <div> menu to save worksheet.</div> <div> There are three ways to save existing file.</div> <div> 1- Go to File < Save</div> <div> 2- Press Ctrl+S</div> <div> 3- Click on Save Icon in formatting toolbar.</div> <div> 6. Closing</div> <div> When we are finished with our work in spread sheet we need to close it.</div> <div> Virtual University of Pakistan</div> <div> 69</div> <div> Computer Proficiency License (CS001) VU</div> <div> Two ways to close a file:</div> <div> 1- Got to File < Close.</div> <div> 2- Click on the close button at the title bar.</div> <div> 7. Opening</div> <div> When we want to display a spreadsheet that has already been saved we will use “OPEN” option</div> <div> from file menu.</div> <div> Two ways to open a file:</div> <div> 1- Click on File < Open.</div> <div> 2- Press Ctrl + O.</div> <div> Either of the way will open a dialogue box. You can browse the file, needed to open and click on</div> <div> Open button.</div> <div> 8. Switching</div> <div> When more than one spreadsheet is open we can switch and edit among them. To view an open</div> <div> spreadsheet we have to click on its name visible in the task bar and we can also switch among</div> <div> spread sheet by clicking on “Window” option of file menu.</div> <div> To view open spreadsheets at a time:</div> <div> Go to Window < Arrange.</div> <div> 9. Rename</div> <div> When you want to make changes in existing file and to make another copy of existing file, we will</div> <div> use “SAVE AS” option of file menu.</div> <div> 10. Exiting</div> <div> By using “CLOSE” option we do not exit from spreadsheet software. If we want to exit from</div> <div> spreadsheet software we will use “EXIT” option from file menu.</div> <div> To exit from Microsoft Excel software:</div> <div> Go to File < Exit</div> <div> 11. Summary</div> <div> In this lecture we have learnt:</div> <div> 􀁸 How to start spreadsheet software?</div> <div> 􀁸 Components of spreadsheet software?</div> <div> 􀁸 How to create and Close spreadsheets?</div> <div> 􀁸 How to save spreadsheets?</div> <div> 􀁸 How to open one, several spreadsheets?</div> <div> 􀁸 How to switch among several spreadsheets?</div> <div> 􀁸 How to save a spreadsheet under another name?</div> <div> 􀁸 How to exit from spreadsheet?</div> <div> Virtual University of Pakistan</div> <div> 70</div> <div> Computer Proficiency License (CS001) VU</div> <div> 12. Exercise</div> <div> In the coming exercise review your Excel skills to open, navigate, save and close a spreadsheet.</div> <div> Task 1:</div> <div> Creating Microsoft Excel shortcut on the Desktop:</div> <div> Click on the Start button and click on the All Programs menu option. Locate Microsoft</div> <div> Excel option (if you have MS Office 2000 or older) or Microsoft Office (if you have MS</div> <div> Office 2003). Right click on the Microsoft Excel option and drag it on to your Desktop</div> <div> area. Release the right mouse button, a small menu will pop up. Select 'Copy here' option</div> <div> from the menu to create a shortcut</div> <div> Task 2:</div> <div> Starting Microsoft Excel :</div> <div> Click on start button and then point to All program option. In the resulting menu, point to</div> <div> Microsoft office option. Then click on Microsoft Excel 2000 to start Microsoft excel.</div> <div> Task 3:</div> <div> Creating and saving a spreadsheet :</div> <div> Open a New Excel spreadsheet by pressing Ctrl + N from the keyboard. Type your name</div> <div> in cell A1 and address in A2. Press Ctrl + S from the keyboard. A window for saving files</div> <div> will open up. Enter the required information and save the spreadsheet you have just</div> <div> created. Now type some more text in the same spreadsheet and press Ctrl + S from the</div> <div> keyboard. This shortcut key will save your current spreadsheet.</div> <div> Task 4:</div> <div> Changing Spreadsheet Name :</div> <div> Open My Documents folder and locate any spreadsheet that you have created earlier.</div> <div> Select spreadsheet name with a single mouse click. Do not double click on the icon. Now</div> <div> press F2 key from the keyboard. F2 key is located in the top left corner of your keyboard,</div> <div> near Escape and F1 keys. After pressing the F2 key, you can type and change the name</div> <div> of the spreadsheet. Same steps can be followed for changing folder name.</div> <div> Task 5:</div> <div> Changing Zoom setting :</div> <div> Create a new spreadsheet. Note the number of columns and rows that appear in</div> <div> worksheet area. Open view menu and click on Zoom option. In the dialog box select 75%</div> <div> option and then click on Ok button. Note number of rows and columns that appear in</div> <div> worksheet area.</div> <div> Task 6:</div> <div> Opening spreadsheets :</div> <div> Start Excel and open a spreadsheet that you have created recently. For this open file</div> <div> menu and in the last of menu click on any spreadsheet name. It will be shown on screen.</div> <div> Then click on open icon on the toolbar. It is in the shape of an open book. From dialog</div> <div> box click any spreadsheet and then click on open button. finally press Ctrl + O keys from</div> <div> keyboard and double click on any spreadsheet in the dialog box. To see the list of open</div> <div> spreadsheets click on window menu. In last of this menu check open spreadsheets.</div> <div> Virtual University of Pakistan</div> <div> 71</div> <div> Computer Proficiency License (CS001) VU</div> <div> Computer Proficiency License (CS-001)</div> <div> Lecture 26</div> <div> Introduction of Excel Sheets</div> <div> 1. Objectives</div> <div> The objective of this lecture is to provide information about</div> <div> 􀁸 How to enter and edit different type of data in worksheets?</div> <div> 􀁸 What is range and how to select cells, columns and rows in a worksheet?</div> <div> 􀁸 How to insert blank cells, columns and rows in a worksheet?</div> <div> 􀁸 How to delete cells, columns and rows in a worksheet?</div> <div> 􀁸 How to change single or multiple column width and rows height?</div> <div> 􀁸 How to copy and move worksheet data?</div> <div> 􀁸 What is purpose of find and replace command?</div> <div> 􀁸 Sorting of numbers and letters in ascending and descending order</div> <div> 2. Inserting data</div> <div> You can enter different types of data in spreadsheet like text and letters. In numeric data we enter</div> <div> digits and perform different formulas on it. When we enter sentences or description of any item in</div> <div> a cell we can use text type. Some time we enter text and letters both in the computer terminology</div> <div> this type of data is called alphanumeric.</div> <div> 3. Entering data</div> <div> When we enter data in cells of spreadsheet we have to follow these steps:</div> <div> 1. First move cell pointer to the cell using mouse or keyboard.</div> <div> 2. Enter data (Text, Numbers etc) in a cell using keyboard.</div> <div> 3. After entering data finalize it, by pressing any arrow key.</div> <div> We can align data as well. By default Text data is left aligned and numeric data is right aligned.</div> <div> 4. Editing data</div> <div> When we edit enter data in cells of spreadsheet we use single click or double click.</div> <div> There are two methods to edit the data in excel sheet.</div> <div> 1. Select the cell; you want to edit, using arrow keys or mouse. Content of the active cell will</div> <div> be visible in formula bar. You can delete/overwrite or correct the text here.</div> <div> 2. Double click at the cell you want to edit. Text will be highlighted. Press any key to delete</div> <div> the text or overwrite it with new text.</div> <div> In edit mode you can edit and delete data. For deleting you can use delete button or backspace</div> <div> to delete.</div> <div> 5. Selecting cells</div> <div> Virtual University of Pakistan</div> <div> 72</div> <div> Computer Proficiency License (CS001) VU</div> <div> To work at more than one cell, entire row or column, you need to select it. Group of adjacent cells</div> <div> is called range. We can define range by writing starting and ending address like A1:A4 etc</div> <div> 6. Selecting rows</div> <div> In a worksheet you can select single or multiple rows. To select a single row you have to click its</div> <div> row number. By dragging mouse on multiple rows we can select multiple rows.</div> <div> 7. Selecting worksheet</div> <div> Using any of these methods we can select multiple columns or entire worksheet.</div> <div> 1. Click once at the name of the column to select it.</div> <div> 2. Select any column and press shift. Now select as many adjacent columns you want.</div> <div> To select entire worksheet click on the area, highlighted in</div> <div> the figure. It is called “Select All” button. You can also select</div> <div> an entire worksheet using keywords like Ctrl+A.</div> <div> 8. Summary</div> <div> In this lesson you have learnt:</div> <div> 􀁸 How to enter and edit different type of data in worksheets</div> <div> 􀁸 What is range and how to select cells, columns and rows in a worksheet</div> <div> 9. Exercise</div> <div> Complete each of the task in sequential order to review your excel skills to enter and edit data,</div> <div> select data, insert and delete columns and rows. You will also learn how to undo and redo</div> <div> changes, rearrange your worksheet, and fill ranges.</div> <div> In these exercises open any spreadsheet created earlier to practice these tasks.</div> <div> Task 1:</div> <div> Entering Data :</div> <div> Start a new spreadsheet. Click on cell A10 in worksheet. Type your name and press right</div> <div> arrow key of keyboard. Press up arrow to move to cell B10. Type any other name and</div> <div> press enter key. In the same way, type some data in cell C10 to H10.</div> <div> Task 2:</div> <div> Editing Data :</div> <div> Move to cell A10. Type a new name in the cell but do not press enter. Since you realize</div> <div> that you want to enter name in A11 cell, press Escape key of keyboard. Move to cell A11.</div> <div> Type Majid but do not press enter key. Press Backspace key twice to delete id. Then</div> <div> type eed to change name from Majid to Majeed and press enter key.</div> <div> Task 3:</div> <div> Selecting range of cells using keyboard :</div> <div> In order to select a range of cells from C4 to C10 first move cell pointer to cell C4. Hold</div> <div> the Shift key of keyboard and then press down arrow key to move to cell C10. Then</div> <div> release the shift key. The range C4:C10 is selected by using keyboard.</div> <div> Virtual University of Pakistan</div> <div> 73</div> <div> Computer Proficiency License (CS001) VU</div> <div> Task 4:</div> <div> Selecting nonadjacent rows :</div> <div> In order to select nonadjacent rows 2, 4 and 6 in this worksheet first select row 2. For</div> <div> this, click on row 2 heading when shape of mouse pointer is right pointing arrow. Then</div> <div> press and hold Ctrl key of keyboard and click on row 4 and row 6 heading when shape of</div> <div> mouse pointer is right pointing arrow. Non adjacent rows 2, 4 and 6 are selected.</div> <div> Task 5:</div> <div> Selecting multiple columns using keyboard shift key :</div> <div> In this worksheet select columns C, D and E using shift key of keyboard. For this first</div> <div> click on Column C heading when shape of mouse pointer is down pointing arrow. Hold</div> <div> the Shift key of keyboard and then press down arrow key of keyboard to move to column</div> <div> E heading. Then release the shift key. The columns C, D and E are selected by using</div> <div> keyboard.</div> <div> Virtual University of Pakistan</div> <div> 74</div> <div> Computer Proficiency License (CS001) VU</div> <div> Computer Proficiency License (CS-001)</div> <div> Lecture 27</div> <div> Working with cells</div> <div> Objective:</div> <div> In this Lecture you will learn about:</div> <div> 􀁸 How to insert blank cells, columns and rows in a worksheet?</div> <div> 􀁸 How to delete cells, columns and rows in a worksheet?</div> <div> 􀁸 How to change single or multiple column width and rows height?</div> <div> 􀁸 Use of undo and redo command</div> <div> 􀁸 How to copy and move worksheet data?</div> <div> 􀁸 What is purpose of find and replace command?</div> <div> 􀁸 Sorting of numbers and letters in ascending and descending order</div> <div> 1. Inserting rows, columns</div> <div> While entering data in a worksheet, it may be possible that some entry of row or column is</div> <div> missed. In this situation we can insert blank row or column in a worksheet by using insert row or</div> <div> insert column option.</div> <div> When row insert option is given, a blank row is inserted above the location of cell pointer. Row</div> <div> numbers are automatically adjusted after inserting new row. In the same way when insert column</div> <div> option is given, a blank column is inserted to the left of active column. We can also insert multiple</div> <div> columns.</div> <div> 2. Deleting rows, columns</div> <div> We can delete columns and rows by using edit option of delete.</div> <div> 3. Modifying column, row</div> <div> When a new spreadsheet is created all cells have default size called standard width. Sometimes</div> <div> entered data is too long that it is not visible in the cell. We will increase the length of column by</div> <div> dragging mouse on left side of column and same is with row.</div> <div> 4. Use the undo, redo command</div> <div> While using different options in a worksheet it is possible that you did not want to apply some</div> <div> options but applies them inadvertently. In this situation you can use undo or redo options of edit</div> <div> menu.</div> <div> Redo can be applied when you applied undo command.</div> <div> To undo any command, go to Edit<Undo</div> <div> To redo any command, go to Edit<Redo</div> <div> 5. Copy data</div> <div> Virtual University of Pakistan</div> <div> 75</div> <div> Computer Proficiency License (CS001) VU</div> <div> When you want to use same data on some other location in worksheet, you can copy this data</div> <div> instead of re-typing it. You can copy the data of cells, columns and rows from one location to any</div> <div> other location.</div> <div> To copy data</div> <div> 1. Go to Edit < copy</div> <div> 2. Select the cell, and press Ctrl+C.</div> <div> 6. Move data</div> <div> You can move data from one location to another in a spreadsheet called cut and paste. You can</div> <div> cut and paste the data of cells, columns and rows.</div> <div> We can use cut command by two ways:</div> <div> 1-Select data</div> <div> 2-Click on Edit < Cut or Press Ctrl+X.</div> <div> We can paste data by two ways:</div> <div> 1-Cut or Copy Data</div> <div> 2-Click on Edit < Paste or Ctrl+V.</div> <div> 7. Auto fill tool</div> <div> By using auto fill tool, you can copy data of single cell to the cell on the right side, left side,</div> <div> upward and downward. It means data can be copied in any direction. Sometimes you may want</div> <div> to create data in series like roll number, date, day, month etc. Auto fill tool is also used to</div> <div> generate these types of series.</div> <div> 8. Search and Replace</div> <div> It is very difficult to search any value or text in a worksheet when it contains a lot of data. When</div> <div> you have misspelled some text in a worksheet it becomes lengthy process to locate and correct</div> <div> these entries. To efficiently search and replace data in a worksheet we will use search and</div> <div> replace option.</div> <div> When you want to search some entry Click Edit < Find will open a dialogue box, enter data here</div> <div> to search.</div> <div> When you want to correct some entry you will use replace option Click Edit < Replace will open a</div> <div> dialogue box, enter data here to replace.</div> <div> 9. Sort data</div> <div> Sort means to arrange data. In spreadsheets we can sort data in alphabetical or numerical order.</div> <div> Alphabetical means data is sorted from A to Z and numerical order means to display numbers in</div> <div> sequence.</div> <div> Data can be sorted as following</div> <div> 1- Select the date, you need to sort.</div> <div> 2- Go to Data < sort</div> <div> This will open a dialogue box which shows some options for sorting data.</div> <div> Virtual University of Pakistan</div> <div> 76</div> <div> Computer Proficiency License (CS001) VU</div> <div> 10. Summary</div> <div> In this lesson you have learnt:</div> <div> 􀁸 How to insert blank cells, columns and rows in a worksheet?</div> <div> 􀁸 How to delete cells, columns and rows in a worksheet?</div> <div> 􀁸 How to change single or multiple column width and rows height?</div> <div> 􀁸 Use of undo and redo command</div> <div> 􀁸 How to copy and move worksheet data?</div> <div> 􀁸 What is purpose of find and replace command?</div> <div> 􀁸 Sorting of numbers and letters in ascending and descending order</div> <div> 11. Exercise</div> <div> Complete each of the task in sequential order to review your excel skills to enter and edit data,</div> <div> select data, insert and delete columns and rows. You will also learn how to undo and redo</div> <div> changes, rearrange your worksheet, and fill ranges.</div> <div> In these exercises open any spreadsheet created earlier to practice these tasks.</div> <div> Task 1:</div> <div> Selecting multiple columns using keyboard shift key :</div> <div> In this worksheet select columns C, D and E using shift key of keyboard. For this first</div> <div> click on Column C heading when shape of mouse pointer is down pointing arrow. Hold</div> <div> the Shift key of keyboard and then press down arrow key of keyboard to move to column</div> <div> E heading. Then release the shift key. The columns C, D and E are selected by using</div> <div> keyboard.</div> <div> Task 2:</div> <div> Deleting contents of row 5 and row 7 using keyboard Delete key :</div> <div> To delete contents of row 5 and 7 first select row 5 and row 7 by using Ctrl key and</div> <div> mouse as we discussed earlier. When row 5 and 7 are selected press delete key of</div> <div> keyboard. You will see that only the contents of row5 and row 7 are deleted, data is not</div> <div> shifted.</div> <div> Task 3:</div> <div> Reverse Changes :</div> <div> Add two blank rows before row 5. For this first select row 5 and row 6. Open Insert menu</div> <div> and click on rows option. After inserting these rows, you realize that you want to add two</div> <div> blank columns instead of rows. So press Ctrl + Z to reverse your changes. If you want to</div> <div> redo your changes press Ctrl + Y key of keyboard.</div> <div> Task 4:</div> <div> Copy Data :</div> <div> To copy contents of cells A1, C1 and F1 to cells A20, C20 and F20 first click on cell A1.</div> <div> Then press and hold Ctrl key of keyboard and click on cell C1 and F1. Cells A1, C1 and</div> <div> F1 are selected. Press Ctrl + C keys to copy data to clipboard. Move cell pointer to A20</div> <div> and press Ctrl + V keys to paste the copied data.</div> <div> Task 5:</div> <div> Modify columns width and rows height using column and rows option :</div> <div> To change width of columns C, E and F first select these columns by using Ctrl key and</div> <div> mouse. After selecting these columns, open Format menu and point to column option.</div> <div> Then click on width option in submenu. A window will be shown, type desired width in</div> <div> Virtual University of Pakistan</div> <div> 77</div> <div> Computer Proficiency License (CS001) VU</div> <div> window and click on ok button. Width of columns C, E and F will be different from other</div> <div> columns.</div> <div> Task 6:</div> <div> Using Series option dialog box to generate a series of date :</div> <div> In a worksheet type 1/1/2006 in cell A4. Then select cells A4 to A10. To generate a series</div> <div> of next dates with month increasing by 2 each time open Edit menu. Point to fill option</div> <div> and then click on Series option in submenu. In the dialog box, click on Date from series</div> <div> section. In step value type number 2. As you want to increment of 2 in months so click on</div> <div> Month in Date unit section. Finally click on OK button and see the series of date</div> <div> generated.</div> <div> Task 7:</div> <div> Using Series option dialog box to generate a series of multiplication type :</div> <div> In this activity type 2 in cell A4 of any worksheet. Select cells A4 to A8 to generate series</div> <div> 2,4,8,16,32. Then open Edit menu and Point to fill option and then click on Series option</div> <div> in submenu. In the dialog box click on Growth from Type section. In step value type</div> <div> number 2 to multiply each number by 2 in the series. Finally click on OK button and see</div> <div> the series of numbers generated.</div> <div> Task 8:</div> <div> Sorting :</div> <div> Open a new spreadsheet. Type numbers 1,4,2,1,3,2,4,2 in cells A1, A2, A3, A4, A5, A6,</div> <div> A7 and A8. Then type numbers 2, 4,6,1,4,5,2,3 in cells B1, B2, B3, B4, B5, B6, B7 and</div> <div> B8. Select these cells and open Data menu. Choose sort option from then menu. In sort</div> <div> by drop down list select column A. In then by drop down list select column B. Finally click</div> <div> on Ok button and you will see Column A and Column B in sorted order.</div> <div> Virtual University of Pakistan</div> <div> 78</div> <div> Computer Proficiency License (CS001) VU</div> <div> Computer Proficiency License (CS-001)</div> <div> Lecture 28</div> <div> Work sheets</div> <div> 1. Objectives</div> <div> The objective of this lecture is to provide information about</div> <div> 􀁸 Worksheets</div> <div> 􀁸 How to select worksheets?</div> <div> 􀁸 How to insert worksheet?</div> <div> 􀁸 How to rename worksheet?</div> <div> 􀁸 How to delete worksheet?</div> <div> 􀁸 How to duplicate worksheet?</div> <div> 􀁸 How to move worksheet?</div> <div> 2. Selecting work sheets</div> <div> Workbook consists of many worksheets. When a new spreadsheet is created we can work in</div> <div> three worksheets named as sheet1, sheet2, sheet3. You can store different but related data in a</div> <div> worksheet of spreadsheet like student morning session result in one sheet and evening session</div> <div> in other sheet. When you work in any of three sheets you can select it just by clicking sheet</div> <div> number and the selected worksheet will show in bold letters.</div> <div> You can select multiple worksheets at the same time by clicking on one sheet tab and then press</div> <div> Shift button and click on second sheet tab will select both sheets and shows their background as</div> <div> white instead of grey. When you want to deselect these selected sheets you just click on third</div> <div> sheet tab and you will find sheet1 and sheet2 will be deselected.</div> <div> 3. Inserting work sheet</div> <div> In a spreadsheet we can work on three worksheets simultaneously and it can be increased also.</div> <div> To insert a new worksheet:</div> <div> 1- Define the location</div> <div> 2- Click on Insert<worksheet</div> <div> You will see a new worksheet with a new name.</div> <div> To insert multiple worksheets 1) select them 2) Go to Insert < Worksheet</div> <div> It will insert desired sheets.</div> <div> 4. Renaming work sheet</div> <div> Default names of worksheets in any spreadsheets are sheet1, sheet2, sheet3.</div> <div> Naming rules while renaming any worksheet are:</div> <div> 1- Name should not be greater then 31 characters</div> <div> Virtual University of Pakistan</div> <div> 79</div> <div> Computer Proficiency License (CS001) VU</div> <div> 2- Name should not contain special characters</div> <div> 3- Any two worksheet names should not be same</div> <div> You can change worksheet name just by double click</div> <div> And rename it.</div> <div> 5. Deleting work sheet</div> <div> Just like inserting a new worksheet we can also delete a worksheet. It should be remember when</div> <div> you delete any worksheet you cannot undo this action.</div> <div> To delete a worksheet</div> <div> 1-Select the worksheet</div> <div> 2- Click Edit < Delete Sheet</div> <div> You will see selected sheet has deleted.</div> <div> Another way to delete a worksheet is:</div> <div> 1- Do a right click on the worksheet’s name.</div> <div> 2- Select Delete from the menu.</div> <div> 6. Duplicate a work sheet</div> <div> When we want to make another copy of worksheet we use duplicate</div> <div> worksheet.</div> <div> To duplicate a worksheet</div> <div> 1-Select worksheet by click on any cell</div> <div> 2- Click on Edit <Move or Copy Sheet. Will show you a dialogue box</div> <div> 3-Select the position for copy</div> <div> This will create a copy of worksheet 1 in the end of sheet3 by name</div> <div> sheet 1(2).</div> <div> 7. Move a work sheet</div> <div> We can move worksheet from one location to another. Move option is</div> <div> helpful when we want to arrange sheet numbers in sheet tab.</div> <div> To move a Worksheet:</div> <div> 1- Select worksheet.</div> <div> 2- Click on Edit < Move or Copy Sheet will show you dialogue box</div> <div> 3- Select position</div> <div> This will move sheet 4 in worksheet 1 at the end of sheet 3.</div> <div> Virtual University of Pakistan</div> <div> 80</div> <div> Computer Proficiency License (CS001) VU</div> <div> 8. Summary</div> <div> In this lesson you learnt:</div> <div> 􀁸 Worksheets</div> <div> 􀁸 How to select worksheets?</div> <div> 􀁸 How to insert worksheet?</div> <div> 􀁸 How to rename worksheet?</div> <div> 􀁸 How to delete worksheet?</div> <div> 􀁸 How to duplicate worksheet?</div> <div> 􀁸 How to move worksheet?</div> <div> 9. Exercise</div> <div> In coming exercise you will practice to select multiple worksheets, rename worksheet, insert and</div> <div> delete worksheets. You will also practice copying and moving worksheets</div> <div> Task 1:</div> <div> Selecting Noncontiguous Worksheets :</div> <div> Open any spreadsheet, to select noncontiguous worksheets sheet1 and sheet3 first click</div> <div> on sheet 1 tab. Press and hold Control key of keyboard and then click on sheet 3 tab.</div> <div> You will see that background color of Sheet 1 and Sheet 3 tabs are changed from gray to</div> <div> white. It means sheet1 and sheet3 are selected.</div> <div> Task 2:</div> <div> Inserting a new worksheet using keyboard :</div> <div> Open any spreadsheet and now we will add two new worksheets before sheet1 using</div> <div> keyboard. To do this, first select sheet 1 and sheet3. Click on sheet 1 tab and then press</div> <div> and hold the shift key and click on sheet 2 tab. Sheet1 and sheet2 are selected; now</div> <div> press Alt+ Shift+F1 keys of keyboard simultaneously. You will see that two new</div> <div> worksheets are inserted before sheet 1.</div> <div> Task 3:</div> <div> Rename a worksheet using format-sheet submenu :</div> <div> Let us change the name of sheet1 in a new spreadsheet. To do this first click on sheet1</div> <div> tab. Open format menu and point to sheet option. Select rename option from resulting</div> <div> submenu. Selected sheet name will be highlighted. Type any new name in sheet1 tab.</div> <div> Finally, to save this name press enter key of keyboard.</div> <div> Task 4:</div> <div> Affecting Multiple worksheets :</div> <div> To affect multiple worksheets at a time open a new spreadsheet. Select sheet 1 and</div> <div> sheet 2 in this spreadsheet. Click on sheet1 tab and type some data in column A and B of</div> <div> sheet 1. Then click on sheet 2 tab, it will also contain the same data in column A and</div> <div> column B which you entered in sheet1. Click on sheet 1 tab. Select row 4 and open insert</div> <div> menu. Choose rows from the menu. Blank row will be inserted before row 4. Click on</div> <div> sheet 2 tab. Blank row is also inserted before row 4 in sheet 2. To deselect sheet 1 and</div> <div> sheet 2, click on sheet 3.</div> <div> Task 5:</div> <div> Deleting Noncontiguous Worksheets :</div> <div> To remove sheet 1 and sheet 3 in a spreadsheet first select sheet 1. Press Control key of</div> <div> keyboard and click on sheet 3 tab. Open edit menu and choose Delete sheet option from</div> <div> menu. Sheet 1 and sheet 3 are deleted.</div> <div> Virtual University of Pakistan</div> <div> 81</div> <div> Computer Proficiency License (CS001) VU</div> <div> Task 6:</div> <div> Copying Worksheets using mouse :</div> <div> Let’s create a copy of sheet 1 in a new spreadsheet using mouse. To do this first click on</div> <div> sheet 1 tab. Hold down Control key of keyboard and Drag sheet 1 tab with mouse. Notice</div> <div> plus sign on the icon which is used to indicate that worksheet is copied. Drag this plus</div> <div> sign to last of sheet tab and then release the Control key of keyboard. A copy of sheet1 is</div> <div> created with name Sheet1(1) in last of sheet tab.</div> <div> Task 7:</div> <div> Moving a worksheet to another Spreadsheet using mouse :</div> <div> First open any two spreadsheets. To show both Spreadsheets open window menu and</div> <div> select arrange option. Click on vertical from dialog box so both spreadsheets are shown</div> <div> vertically. To move sheet 1 from first Spreadsheet to another first click on sheet 1 tab.</div> <div> Drag the sheet 1 tab and notice that an icon will also move with it. In this way, drag this</div> <div> icon to end of second Spreadsheet. You will notice that from first Spreadsheet sheet 1 is</div> <div> moved to second Spreadsheet.</div> <div> Task 8:</div> <div> Change sheet tab color :</div> <div> Let us change the color of sheet2 tab in a new spreadsheet. To do this first click on</div> <div> sheet1 tab. Open format menu and point to sheet option. Then choose tab color from</div> <div> resulting menu. A list of colors is shown. Select desired color and click on OK button.</div> <div> Virtual University of Pakistan</div> <div> 82</div> <div> Computer Proficiency License (CS001) VU</div> <div> Computer Proficiency License (CS-001)</div> <div> Lecture 29</div> <div> Formulas and Functions</div> <div> 1. Objectives</div> <div> The objective of this lecture is to provide information about</div> <div> 􀁸 Formula and how it is used in worksheets.</div> <div> 􀁸 How functions are used in worksheets?</div> <div> 􀁸 How to use If function?</div> <div> 􀁸 Difference between absolute, relative and mixed referencing?</div> <div> 􀁸 About error codes and which type of error codes are generated using formulas?</div> <div> 2. Generate formulas</div> <div> Formula is distinguishing feature of spreadsheet. In absence of formula, it is called a worksheet</div> <div> which contains text and numbers in tabular form. Formula contains numbers, cell addresses and</div> <div> operators to perform calculation on these numbers. To perform simple calculations like add,</div> <div> subtract, multiply etc we will use arithmetic operators.</div> <div> 3. Priority of operators</div> <div> When more than one operator is used in the formula, they are evaluated in some specific order.</div> <div> Precedence of operators is as follows:</div> <div> Operator/Symbol Order of</div> <div> precedence</div> <div> Operations</div> <div> () 1st Parenthesis</div> <div> ^ 2nd Exponentiation</div> <div> * and / 3rd Multiplication/division</div> <div> - and + 4th Addition and subtraction</div> <div> Operators having same precedence are calculated from left to right.</div> <div> 4. Working with functions</div> <div> When calculation is lengthy and complicated</div> <div> in spreadsheets we use functions.</div> <div> Format of function is:</div> <div> =FunctionName (List of Arguments)</div> <div> Function name sows the purpose of the</div> <div> function.</div> <div> Argument list can be numbers, cell</div> <div> addresses and any range.</div> <div> Formula can be entered using built-in</div> <div> functions and spreadsheet consists of many</div> <div> Virtual University of Pakistan</div> <div> 83</div> <div> Computer Proficiency License (CS001) VU</div> <div> functions like mathematical, statistical and logical etc.</div> <div> To enter function</div> <div> Go to Insert < Function</div> <div> This will show you a dialogue box from where you can choose your functions.</div> <div> 5. Generate formula using IF</div> <div> IF function is very useful logical function in spreadsheets. We use relational operator with logical</div> <div> operators.</div> <div> Relational operators: compares any two values that are greater, equal or not equal from each</div> <div> other. These are:</div> <div> =</div> <div> <></div> <div> <=</div> <div> >=</div> <div> <></div> <div> Format of If Function:</div> <div> =if (condition, value if true, value if false)</div> <div> 6. Absolute, relative, mixed cell reference</div> <div> When cell addresses are changed in copying a formula it is called relative cell referencing like</div> <div> = sum ( A1 , B1 ).</div> <div> When cell addresses are not changed in copying a formula it is called absolute cell referencing</div> <div> like = $ A $ 2 + $ B $ 2.</div> <div> When we do not want to make some value as absolute reference and some as relative then it is</div> <div> called mix cell reference.</div> <div> 7. Error associated with formulas</div> <div> It is possible when you are typing some formula you may make a mistake, due to these common</div> <div> mistakes error codes are shown in cells.</div> <div> Some of errors are:</div> <div> #Name: error is shown when any function or cell address is misspelled.</div> <div> #Div / 0: error is shown when any data is divided by zero or blank cell.</div> <div> #NULL: error is shown when more than one value are separated by spaces in function.</div> <div> #Value: error is shown when wrong data type is entered in formula of function.</div> <div> 8. Summary</div> <div> In this lesson we have learnt:</div> <div> 􀁸 What is formula and how it is used in worksheets?</div> <div> 􀁸 How functions are used in worksheets?</div> <div> 􀁸 How to use If function?</div> <div> 􀁸 Difference between absolute, relative and mixed referencing.</div> <div> 􀁸 About error codes and which type of error codes are generated using formulas.</div> <div> Virtual University of Pakistan</div> <div> 84</div> <div> Computer Proficiency License (CS001) VU</div> <div> 9. Exercise</div> <div> You will explore ways to create and copy formulas and functions, use of absolute, relative and</div> <div> mixed cell references. You will also learn how error codes are generated by using formulas and</div> <div> how to avoid from them.</div> <div> Task 1:</div> <div> Using AutoSum :</div> <div> Create a new Spreadsheet whose first column contains name of monthly expenses and</div> <div> second column contains amount of each expenses. To calculate total monthly expenses</div> <div> select the cells which contains amount of each expenses. On the toolbar click on Auto</div> <div> sum button (􀈈). You will see the sum of amount column in last cell.</div> <div> Task 2:</div> <div> Adding column values :</div> <div> Open a new spreadsheet and enter some numbers in Column A and Column B. To add</div> <div> values in Column A and B and then multiply by 2, first move cell pointer to cell C2.</div> <div> Type=A1+B1*2 in cell C2 and press Enter key of keyboard. You will see that number 2 is</div> <div> multiplied by value of B1 and then value of A1 is added in it. Now change formula and</div> <div> type= (A1+ B1) *2 in cell C3. You will notice that first values of A1 and B1 are added and</div> <div> then result is multiplied by 2.</div> <div> Task 3:</div> <div> Entering formula before entering values :</div> <div> Open a new spreadsheet and click on cell C1. Type =A1+B1 and press enter key. You</div> <div> will see value 0 in cell C1. Now enter value 4 in A1 cell and 6 in B1 cell. Value of C1 cell</div> <div> will be changed to 10. Click on cell C1. Press Ctrl + C keys and select cells C2 to C3.</div> <div> Press Ctrl + V keys. Type value 2 in cell A2 and 5 in cell B2. Value of C2 cell will be 7.</div> <div> Type value 6 in cell A3 and 9 in cell B3. C3 will be 15.</div> <div> Task 4:</div> <div> Modifying a formula :</div> <div> Open the Spreadsheet we used in previous exercise. Move cellpointer to C1. Press F2</div> <div> key of keyboard. Place cursor to plus sign by clicking on plus sign. Press delete key of</div> <div> keyboard. Type minus sign and press enter. Now formula used in cell C2 is recalculated.</div> <div> Task 5:</div> <div> Changing cell references to Absolute :</div> <div> Open spreadsheet, used in previous exercise, click on cell C1. In C1 cell formula, to</div> <div> make A1 and B1 from relative to absolute, first presses F2 key. Click before A1 in formula</div> <div> bar and press F4 key of keyboard. Then move cursor before B1 and press F4 key of</div> <div> keyboard. You will see a dollar sign before A1 and B1.</div> <div> Task 6:</div> <div> Use of sum function by dragging :</div> <div> In monthly expenses spreadsheet, we will calculate the total monthly expenses using</div> <div> sum function. Type = sum ( in cell C1 . Drag to select the range C2:C10. You will see</div> <div> this range in cell C1 = sum (C12: C10 ). Finally press “enter” key of keyboard. Excel will</div> <div> total the specified range.</div> <div> Task 7:</div> <div> Using Function Average :</div> <div> In this activity you'll use function to determine average expense of each item and total</div> <div> number of expense. Use same worksheet which we used in previous exercise. Move to</div> <div> Virtual University of Pakistan</div> <div> 85</div> <div> Computer Proficiency License (CS001) VU</div> <div> cell D1 and type Average Expense. Move to cell D2 and click on FX on formula bar. In</div> <div> the dialog box, open select a category drop down list and click statistical from the list.</div> <div> Then search for function Average under the select a function list. Click on average and</div> <div> then click on ok button. Select amount values column in worksheet. You will see that</div> <div> C1:C7 appears in front of number 1. Finally click on ok button. You will see average</div> <div> expense per item in cell D2.</div> <div> Task 8:</div> <div> Using Function Count :</div> <div> Open spreadsheet used in previous exercise, Type heading total number of items in</div> <div> cell B12, and click on C14. Type = sign and click function box arrow which is on left of</div> <div> cross button in formula bar. Click on count function and then select cells which contains</div> <div> amount. In dialog box, range c3: c7 will be added in front of number 1. Finally click on ok</div> <div> button; you will see total number of items in C14.</div> <div> Task 9:</div> <div> Using Function Date :</div> <div> Open spreadsheet used in previous exercise To enter date in cell E3, click on cell E3.</div> <div> Type = sign and click function box arrow which is on left of cross button in formula bar</div> <div> and click date. If date does not appear, click more functions. In paste functioned box</div> <div> open category drop down list and choose date and time function. Then choose date</div> <div> under select a function list and then click ok button. In date dialog box, enter 2006 for</div> <div> year, 8 for months and 3 for day, click ok. You will see date in cell E3. To enter current</div> <div> date in cell E4, click on cell E4. Click on FX on formula bar and open select a category</div> <div> drop down list and click date and time function. Then search for function Now () under the</div> <div> select a function list finally click on OK buttons and you will see current date in cell E4.</div> <div> Task 10:</div> <div> Calculating total on multiple Worksheets at simultaneously :</div> <div> Open a spreadsheet which contains monthly expenses for the month of January. Add</div> <div> monthly expenses for the month February in sheet 2. Select Sheet 1 and sheet 2. Now</div> <div> click on sheet1 tab and select values of monthly expenses of January. . Click on auto</div> <div> sum button on toolbar. Then click on sheet 3 to deselect sheet 1 and 2. Click on sheet 1</div> <div> and you will see total amount for month of January. Then click on sheet 2 and you will</div> <div> notice total expenses for month of February are also calculated.</div> <div> Virtual University of Pakistan</div> <div> 86</div> <div> Computer Proficiency License (CS001) VU</div> <div> Computer Proficiency License (CS-001)</div> <div> Lecture 30</div> <div> Formatting</div> <div> 1. Objectives</div> <div> The objective of this lecture is to provide information about</div> <div> 􀁸 What is formatting and number formatting?</div> <div> 􀁸 How to apply different formatting to cell contents?</div> <div> 􀁸 How to change foreground and background of cell contents?</div> <div> 􀁸 How to add border effects to a cell, cell range?</div> <div> 􀁸 How to set alignment of cell contents?</div> <div> 􀁸 How to change direction of cell contents?</div> <div> 􀁸 How to show data of single cell in multiple lines?</div> <div> 􀁸 How to center a title over a cell range?</div> <div> 􀁸 How to apply cell formatting from one location to another?</div> <div> 2. Worksheet Format</div> <div> Format means appearance of a thing and formatting</div> <div> means to change and improve appearance of a thing. We</div> <div> improve appearance of picture by formatting it. When we</div> <div> create something we try to improve its layout. We format t</div> <div> improve it presence and appearance.</div> <div> o</div> <div> ormats include commas, symbols and</div> <div> o apply number formatting:</div> <div> cell.</div> <div> This will open a dialogue box in which you can see different tabs. Number tab show you numeric</div> <div> . Currency Format</div> <div> this format a symbol is added in start of number.</div> <div> o apply currency format:</div> <div> ange</div> <div> Currency</div> <div> . Percent Format</div> <div> Worksheet formatting includes:</div> <div> 􀃆Number formatting</div> <div> 􀃆Text formatting</div> <div> 􀃆Date formatting</div> <div> 􀃎Number formatting: To change the appearance of</div> <div> numbers different numeric formats are available. Numeric f</div> <div> percent sign in numbers. Numeric format change only appearance of numbers.</div> <div> T</div> <div> 1- Select range or active</div> <div> 2- Click on Format < Cell</div> <div> format options.</div> <div> 3</div> <div> In</div> <div> T</div> <div> 1- Select number or r</div> <div> 2- Click on Format < Cell <</div> <div> 4</div> <div> Virtual University of Pakistan</div> <div> 87</div> <div> Computer Proficiency License (CS001) VU</div> <div> In this format number is multiplied by 100 and percent symbol is also shown.</div> <div> range</div> <div> Percentage</div> <div> . Change Font of cell contents</div> <div> Ariel and size is 10. you can change the font of</div> <div> o apply any font format:</div> <div> at < Cell < Font tab.</div> <div> . Apply cell formatting to cell contents</div> <div> Cell < Font tab < Font Style</div> <div> . Apply different color to cell</div> <div> und color of cell contents.</div> <div> o apply foreground color:</div> <div> at < Cell < Font tab < Color</div> <div> o apply background color:</div> <div> at < Cell < Pattern tab</div> <div> . Add border</div> <div> nd a cell or group of cells.</div> <div> ell < Border tab.</div> <div> ou can select border style from line option and color from color option.</div> <div> d numbers are aligned on right side.</div> <div> s to align left, right or center.</div> <div> 0. Adjust cell orientation</div> <div> nts can be changed.</div> <div> To apply percent format:</div> <div> 1- Select number or</div> <div> 2- Click On Format < Cell <</div> <div> 5</div> <div> Writing style of data is called font. Default text is</div> <div> data before and after entering the data.</div> <div> T</div> <div> 1- Select text</div> <div> 2- Click on Form</div> <div> 6</div> <div> To apply cell format</div> <div> 1- Select text</div> <div> 2- Click on Format <</div> <div> 7</div> <div> You can change background and foregro</div> <div> T</div> <div> 1- Select Cells</div> <div> 2- Click on Form</div> <div> T</div> <div> 1- Select Cells</div> <div> 2- Click on Form</div> <div> 8</div> <div> Border is a line arou</div> <div> To create border around cell:</div> <div> 1- Select cell or cells</div> <div> 2- Click on Format < C</div> <div> Y</div> <div> 9. Align contents to cell</div> <div> By default text is aligned on left side an</div> <div> To align cell contents:</div> <div> 1- Select cell or cells</div> <div> 2-Select tool bar option</div> <div> 1</div> <div> By using cell orientation direction of cell conte</div> <div> Virtual University of Pakistan</div> <div> 88</div> <div> Computer Proficiency License (CS001) VU</div> <div> To apply cell orientation:</div> <div> 1- Select text.</div> <div> at < Cell < Alignment tab < orientation</div> <div> 1. Apply text wrapping to cell contents</div> <div> o display text in multiple lines text wrap options is used.</div> <div> - Select text or cells</div> <div> ell < Alignment tab < Text control < Text Wrap</div> <div> 2. Center a title over a cell range</div> <div> e can also center a title over a cell range.</div> <div> - Select cell range</div> <div> Cell < Alignment tab < Text control < Merge Cell</div> <div> to align left, right or center.</div> <div> 2- Click on Form</div> <div> 1</div> <div> T</div> <div> To apply text wrap:</div> <div> 1</div> <div> 2- Click on Format < C</div> <div> 1</div> <div> W</div> <div> To apply cell title:</div> <div> 1</div> <div> 2- Click on Format <</div> <div> 3- Select Text</div> <div> 4-Select tool bar options</div> <div> 13. Copy Formatting</div> <div> e can also copy formatting like font, bold, border, color</div> <div> heet</div> <div> o paste formatting:</div> <div> -Select another sheet and move mouse pointer in any</div> <div> ck on Edit < Paste Special</div> <div> This will open a dialogue box from which you can select paste opti</div> <div> 4. Summary</div> <div> this lesson we have learnt:</div> <div> number formatting?</div> <div> ents?</div> <div> contents?</div> <div> cation to another?</div> <div> W</div> <div> etc from one location to another.</div> <div> To copy formatting:</div> <div> 1- Select works</div> <div> 2- Click on Edit < Copy</div> <div> T</div> <div> 1</div> <div> cell.</div> <div> 2- Cli</div> <div> ons.</div> <div> 1</div> <div> In</div> <div> 􀁸 What is formatting and</div> <div> 􀁸 How to apply different formatting to cell cont</div> <div> 􀁸 How to change foreground and background of cell</div> <div> 􀁸 How to add border effects to a cell, cell range?</div> <div> 􀁸 How to set alignment of cell contents?</div> <div> 􀁸 How to change direction of cell contents?</div> <div> 􀁸 How to show data of single cell in multiple lines?</div> <div> 􀁸 How to center a title over a cell range?</div> <div> 􀁸 How to apply cell formatting from one lo</div> <div> Virtual University of Pakistan</div> <div> 89</div> <div> Computer Proficiency License (CS001) VU</div> <div> 5. Exercise</div> <div> hile unformatted worksheets communicate information, a formatted worksheet adds interest</div> <div> ask 1:</div> <div> Numeric format :</div> <div> 1</div> <div> W</div> <div> and can highlight important data. In coming exercise explore how to apply numerous types of</div> <div> formatting to text and values such as changing font styles to bold, italic and underline. You will</div> <div> also practice adding symbols to numeric data and changing color of cell contents and the</div> <div> backgrounds of cells.</div> <div> T</div> <div> Apply</div> <div> Open a new spreadsheet. Select cells A1 to A5 with the mouse. Click on Format menu</div> <div> on menu bar and choose Cells option. In the dialog box click on Number tab and select</div> <div> Currency from category list and open drop down list of Symbol. Search for symbol €</div> <div> (Basque) in the list. In Decimal places section set value 0 and click on OK button. Type</div> <div> 123 in cell A1 and press Enter key. Ten type 123 in cell B1 and see the difference.</div> <div> pply Date format :</div> <div> Task 2:</div> <div> A</div> <div> t, select cells C1 to C5. Open Format menu and choose Cells</div> <div> Task 3:</div> <div> ge Font characteristics :</div> <div> In a new spreadshee</div> <div> option. In the dialog box click on Number tab and select Date from category list. Select</div> <div> second style from Type section and click on Ok button. Type 1/1/05 in cell C1 and press</div> <div> Enter key. See the style of date you entered.</div> <div> Chan</div> <div> s A1 to A5 in it. Click on Format menu on menu bar</div> <div> Task 4:</div> <div> conditional formatting :</div> <div> Open any spreadsheet and select cell</div> <div> and choose Cells option. In the dialog box click on Font tab and search for Verdana in</div> <div> style list under font section. Set size to 16 and then open drop down list of Underline</div> <div> section. Select Double from the list and then click on alignment tab. Open drop down list</div> <div> of horizontal section and choose center from it. Click on OK button and type some data in</div> <div> cells A1 to A5. See the format of entered data.</div> <div> Apply</div> <div> rksheet and open Format menu. Choose Conditional</div> <div> Task 5:</div> <div> Auto format :</div> <div> Select cells E1 to E5 in any wo</div> <div> formatting option from the list, a dialog box is shown. Click drop down list of second entry</div> <div> box and click on greater than. Type the value 10 in third entry box. Then Click on format</div> <div> button and choose Bold from Font style. Open color drop down list and choose red color.</div> <div> Click Pattern tab and choose violet color square (in third row and seventh column of color</div> <div> palette). Then click OK to close Format cells box and again click ok to close conditional</div> <div> formatting box. Type 25 in cell E1 and 10 in cell E2. See the effect of conditional</div> <div> formatting.</div> <div> Apply</div> <div> t which contains some data. Select the data in worksheet and click</div> <div> Task 6:</div> <div> Painter and Fill color :</div> <div> Open any spreadshee</div> <div> on format menu on menu bar. Choose Auto format option a dialog box is shown. Scroll</div> <div> the style list and click on colorful1 style from the list. Click on OK button and see the</div> <div> effect of auto format.</div> <div> Use Format</div> <div> ins data like A1 to A4. Select some cells which</div> <div> contain data and click on bold icon and italic icon. Click on format painter icon on toolbar,</div> <div> Open any spreadsheet which conta</div> <div> Virtual University of Pakistan</div> <div> 90</div> <div> Computer Proficiency License (CS001) VU</div> <div> shape of this icon is like a paint brush. Now select cells C1 to C4 which also contain</div> <div> some data and see how format of cells A1 to A5 is copied to cells C1 to C4.</div> <div> Task 7:</div> <div> Hide columns and rows :</div> <div> any spreadsheet, to select column E first click on column E heading. After selecting,</div> <div> ing and choose hide from the resulting menu. Now select row</div> <div> Task 8:</div> <div> eeze columns and rows :</div> <div> In</div> <div> right click on column E head</div> <div> 4 and 5 using mouse. Open format menu and move mouse pointer to row option and</div> <div> then click on hide option in submenu. Now column E, row 4 and 5 are hidden. To show</div> <div> column E, select columns D and F and right click on selection. Choose unhide from</div> <div> resulting menu. Similarly to show row 4 and 5, select row 3 and 6. Right click on selection</div> <div> and choose unhide option.</div> <div> Fr</div> <div> pen any spreadsheet and to freeze column A place cell pointer in cell B1. Open window</div> <div> es. Scroll to right until you can see column J. Notice that</div> <div> Task 9:</div> <div> pply different patterns to cells :</div> <div> O</div> <div> menu and choose freeze pan</div> <div> you can still see the column A. Then click unfreeze pane from window menu. To freeze</div> <div> row 1, place cell pointer in cell A2 and choose freeze pane from window menu. Scroll</div> <div> downward and you can still see row 1 although you are in row 30. Now select unfreeze</div> <div> pane from window menu. Finally to freeze row 1 and column a place cell pointer on cell</div> <div> B2. Choose freeze pane from window menu and notice that when you scroll to right you</div> <div> can see column a and when you scroll downward you can see row 1.</div> <div> A</div> <div> spreadsheet select column A. Open format menu and choose cells option. Click on</div> <div> of pattern section. Select any style and choose any</div> <div> Task 10</div> <div> nderstanding text formatting :</div> <div> In any</div> <div> Pattern tab and open drop down list</div> <div> color from the window. Click on border tab and choose inside and outline options from</div> <div> Preset section. Finally click on Ok button and see the style of column A.</div> <div> :U</div> <div> a spreadsheet, select cells C1 to C5. Open format menu and choose cells option From</div> <div> ory section. Click on Ok button and type 1 in cell A1.</div> <div> In</div> <div> Number tab chose Text from categ</div> <div> Then type 2 in cell B1. Finally type =A1+B1 in cell C1 and see the result. Formula is</div> <div> shown as you entered due to text format</div> <div> Virtual University of Pakistan</div> <div> 91</div> <div> Computer Proficiency License (CS001) VU</div> <div> Computer Proficiency License (CS-001)</div> <div> Lecture 31</div> <div> Charts and Graphs</div> <div> 1. Objectives</div> <div> The objective of this lecture is to provide information about:</div> <div> 􀁸 What are charts and its different types?</div> <div> 􀁸 How to create chart using chart wizard?</div> <div> 􀁸 How to add title, legend, and label to the chart?</div> <div> 􀁸 How to change chart type?</div> <div> 􀁸 How to change background color in chart?</div> <div> 􀁸 How to format title, legends, and data labels in chart?</div> <div> 􀁸 How to change bar, line, pie slice colors in chart?</div> <div> 􀁸 How to duplicate and move charts within a worksheet between spreadsheet?</div> <div> 2. Understanding chart types</div> <div> Pictorial representation of data is called graph or chart. Graphs are represented by horizontal and</div> <div> vertical axis, showing constant and values thereof respectively.</div> <div> Different types of charts are:</div> <div> 􀃎Column chart: Column chart contains vertical columns called bars which show values of item.</div> <div> This type is used when we want to create chart of multiple data series.</div> <div> 􀃎Bar Chart: Bar chart is represented horizontally.</div> <div> 􀃎Line Chart: In line chart, values are connected through lines and upward and downward</div> <div> trends are explained explicitly.</div> <div> 􀃎Pie Chart: When data is subdivided into parts, it is more appropriately shown by pie chart</div> <div> which is circular in shape.</div> <div> 􀃎XY Chart: In XY chart numeric vales are used at both the horizontal and vertical sides.</div> <div> 3. Creating simple chart</div> <div> To create chart:</div> <div> Go to Insert < Chart</div> <div> This chart wizard create chart in simple four</div> <div> steps.</div> <div> 1. Select chart type</div> <div> 2. Define range</div> <div> 3. Define features like title, legends</div> <div> 4. Define location in spreadsheet</div> <div> 4. Creating pie chart</div> <div> To create pie chart:</div> <div> 1-Select range</div> <div> 2-Click on Insert < chart</div> <div> 3. Select chart type</div> <div> 4. Define legends, labels etc</div> <div> Virtual University of Pakistan</div> <div> 92</div> <div> Computer Proficiency License (CS001) VU</div> <div> 5-Change the chart type</div> <div> To change existing chart</div> <div> 1-Select chart</div> <div> 2- Right click < chart type</div> <div> 3- Select chart type</div> <div> 6-Add/remove chart title, legends</div> <div> To change chart title</div> <div> 1-Select chart</div> <div> 2- Click on Chart < Chart option</div> <div> You can change chart title, axis, legends, and labels from</div> <div> here.</div> <div> 7-Change background color in chart</div> <div> To change background color in chart</div> <div> 1- select chart</div> <div> 2- Click on Format < selected chart area</div> <div> 8-Formatting chart</div> <div> We can change chart data, labels etc after making the chart .We can format chart data together</div> <div> or separately.</div> <div> To format the chart</div> <div> 1- Select chart.</div> <div> 2- Click on Format < selected chart area</div> <div> This will open a dialogue box from which we can change font, color, style etc.</div> <div> 9-Change pie slices, line, bar color</div> <div> Lines, bars, slices used in the chart are called data markers. We can also change color of data</div> <div> markers.</div> <div> To change color of pie chart slices are</div> <div> 1- Select chart.</div> <div> 2-Selec pie slice</div> <div> 3-Click right < Format data point</div> <div> This dialogue will open and you can choose any</div> <div> color for pie slices.</div> <div> 10-Move chart using mouse</div> <div> We can move chart in a worksheet. We can</div> <div> move chart using mouse or by using cut and paste option.</div> <div> Virtual University of Pakistan</div> <div> 93</div> <div> Computer Proficiency License (CS001) VU</div> <div> To move chart using mouse</div> <div> 1- Select chart.</div> <div> 2- Take mouse on the chart and press left button and by dragging change location of chart.</div> <div> 3- Release mouse button on desired location.</div> <div> 11-move/copy chart using cut/copy</div> <div> To copy chart</div> <div> 1-Select chart</div> <div> 2- Click on Edit < Cut or press Crl+X</div> <div> To paste Chart</div> <div> 1-Select chart</div> <div> 2- Click on Edit < Paste or press Crl+V</div> <div> 12-Resize/Delete charts</div> <div> After creating a chart we can also resize it.</div> <div> To resize chart</div> <div> 1-Select chart</div> <div> 2-Click on Selection handles to resize</div> <div> To delete chart</div> <div> 1-Select chart</div> <div> 2- Press delete</div> <div> 13-Summary</div> <div> In this lesson we have learnt:</div> <div> 􀁸 What are charts and its different types?</div> <div> 􀁸 How to create chart using chart wizard?</div> <div> 􀁸 How to add title, legend, and label to the chart?</div> <div> 􀁸 How to change chart type?</div> <div> 􀁸 How to change background color in chart?</div> <div> 􀁸 How to format title, legends, and data labels in chart?</div> <div> 􀁸 How to change bar, line, pie slice colors in chart?</div> <div> 􀁸 How to duplicate and move charts within a worksheet between spreadsheet?</div> <div> 14- Exercise</div> <div> While worksheet provides an effective way to organize information, charts are the best way to</div> <div> display numbers. In the coming exercise review your spreadsheet skills to create different types</div> <div> of chart, add different features and edit charts</div> <div> Task 1:</div> <div> Create a 3-D Visual effect bar chart:</div> <div> Create a worksheet and enter some items in column A with heading titles and their</div> <div> January expenses in column B with heading Jan expenses. Select Jan expenses and title</div> <div> columns. Open insert menu and click on chart option. Select Bar type from first step and</div> <div> Virtual University of Pakistan</div> <div> 94</div> <div> Computer Proficiency License (CS001) VU</div> <div> then select 3-D Visual effect from its subtype. Click on Next button and choose rows from</div> <div> series in section. Follow the steps of chart wizard and place chart as an object in</div> <div> worksheet.</div> <div> Task 2:</div> <div> Change Data series :</div> <div> In monthly expenses spreadsheet add a column named Feb Expense and enter some</div> <div> values in it. To change data series from January expense to February expense right click</div> <div> in chart area. Choose Data source from shortcut menu and click collapse icon at right</div> <div> end of data range box. Click on A1 cell and then select cells A1 to A6. Hold down control</div> <div> key and select cells C1 to C6 cells. Then click Expand icon in Source data-Data range</div> <div> box. Finally click on OK button and see the cart with new data series.</div> <div> Task 3:</div> <div> Create a default chart :</div> <div> Open Monthly expenses worksheet and select cells A1 to B6. Right click on any toolbar</div> <div> and if a tick mark is not shown in front of chart option then click on it. Search for Chart</div> <div> type icon on chart toolbar and click on its drop down arrow. Search for line chart icon</div> <div> which is on the start of fourth line. A line chart is shown on screen; drag the chart so that</div> <div> it is centered under worksheet area.</div> <div> Task 4:</div> <div> Apply a Chart Title and change font :</div> <div> Open monthly expenses worksheet with line chart on it. To add titles in the chart right</div> <div> click in chart area. Click chart options on shortcut menu. Then click titles tab and add</div> <div> headings in it. Click on OK button. To format these titles, again right on chart area and</div> <div> choose format chart area from menu. Select font tab from the dialog box and choose</div> <div> Arial font. Set size to 11 and click on color drop down list. Select green color and click on</div> <div> OK button</div> <div> Task 5:</div> <div> Change color of lines in Line graph :</div> <div> While monthly expenses still open with line chart, to change color of each line in line</div> <div> chart click on any line in line chart to select all lines. Then click on the desired line whose</div> <div> color you want to change. Right click on selected line and choose format data point from</div> <div> shortcut menu. From dialog box open color drop down list of line section. Click on yellow</div> <div> color. Then in Marker section, click on Background color and select green color. Click on</div> <div> Ok button and see the effect. To change weight of all lines and color of markers click on</div> <div> any line. Right click and choose Data series. Open drop down list of weight in line</div> <div> section. Select desired weight. Then click on Background color in Marker section and</div> <div> choose any color. Finally click on Ok button and see the effect.</div> <div> Task 6:</div> <div> Add an arrow and text box to a chart :</div> <div> Open monthly expenses worksheet and select line chart in it. Click arrow button on</div> <div> drawing toolbar and draw a line in front of third data marker by dragging the mouse.</div> <div> When you release the mouse pointer an arrow will appear. Click on text box button on</div> <div> drawing toolbar. Click under base of arrow in the chart to insert a text box. Type item</div> <div> name and select it. Change its font and size.</div> <div> Task 7:</div> <div> Insert and Move clip Art object :</div> <div> With monthly expenses spreadsheet still open and chart selected, click the insert menu.</div> <div> Point to Picture and click From ClipArt. Select any picture and close clipart window. Click</div> <div> Virtual University of Pakistan</div> <div> 95</div> <div> Computer Proficiency License (CS001) VU</div> <div> the upper right selection handle and drag to lower left corner until the image is</div> <div> approximately one inch wide. Click the object and drag it above the left side of the text</div> <div> box. Right click the object and click format picture on shortcut menu. Set different options</div> <div> to format the picture.</div> <div> Virtual University of Pakistan</div> <div> 96</div> <div> Computer Proficiency License (CS001) VU</div> <div> Computer Proficiency License (CS-001)</div> <div> Lecture 32</div> <div> Prepare Outputs</div> <div> 1. Objectives</div> <div> The objective of this lecture is to provide information about:</div> <div> 􀁸 How to change margin?</div> <div> 􀁸 How to change page orientation?</div> <div> 􀁸 How to add header and footer?</div> <div> 􀁸 How to add page number?</div> <div> 􀁸 What are different printing options?</div> <div> 2- Worksheet setup:</div> <div> When we start working in the worksheet we take care of some points like page size, page</div> <div> margins, page orientation etc. Letter and A4 are the standard page sizes. We can choose page</div> <div> size according to our need. When working in page we left some blank space on left and right side</div> <div> These are called margins. Margin size can also be varying. Page orientation can also be</div> <div> changed. Page orientation is of two types: landscape and portrait. We usually use portrait</div> <div> orientation.</div> <div> 3- Preview a worksheet:</div> <div> Whenever we want to take check our worksheet we use print preview option. By using print</div> <div> preview we can check how it is shown on the paper.</div> <div> To preview worksheet two methods are there:</div> <div> 1- Click on File < Print Preview</div> <div> 2. Click on button.</div> <div> 4- Change margins and Orientation:</div> <div> To set page margins:</div> <div> 1- Click on File < Page Setup < Margins</div> <div> To set page orientation:</div> <div> 2- Click on File < Page Setup < Page</div> <div> 5- Add/Remove header footer:</div> <div> A feature with which same information is not typed</div> <div> repeatedly called Header and Footer.</div> <div> Header: Information on top of every page is called</div> <div> header.</div> <div> Footer: information on bottom of every page is c</div> <div> footer.</div> <div> alled</div> <div> Virtual University of Pakistan</div> <div> 97</div> <div> Computer Proficiency License (CS001) VU</div> <div> To add header or footer:</div> <div> Click on View < Header and Footer</div> <div> 6-Type data in header footer</div> <div> To add text in header and footer:</div> <div> 1- Click on View < Header and Footer < Custom Header/Footer</div> <div> This dialogue box help you in entering data in left, right and center.</div> <div> 7-Turn on/off gridlines in printing:</div> <div> Horizontal and vertical lines in worksheet</div> <div> are called gridlines. We have options to print</div> <div> row numbers, column headings and</div> <div> gridlines.</div> <div> To use gridlines:</div> <div> Click on File < Page Setup < Sheet</div> <div> This dialogue box will help you in printing.</div> <div> 8-Printing:</div> <div> We can take print out of our worksheets</div> <div> prepared using spreadsheet software. File</div> <div> created using a software and saved in computer are called softcopy and print out of soft copy is</div> <div> called hard copy.</div> <div> Three methods are there for printing:</div> <div> 1- Click on File < Print</div> <div> 2- Press Ctrl+P</div> <div> 3- Press print button</div> <div> 9- Print charts in worksheet:</div> <div> We can take print out of charts with data and without data. If we print worksheet without selecting</div> <div> chart then data and chart both are printed.</div> <div> We can take print out charts only.</div> <div> To print charts:</div> <div> 1- Select chart</div> <div> 2- Click File < Print</div> <div> To print data of charts only:</div> <div> 1- Select chart</div> <div> 2- Right Click < Format chart area < Properties < Deselect Print object</div> <div> Virtual University of Pakistan</div> <div> 98</div> <div> Computer Proficiency License (CS001) VU</div> <div> 10-Summary:</div> <div> In this lesson we have learnt:</div> <div> 􀁸 How to change margin?</div> <div> 􀁸 How to change page orientation?</div> <div> 􀁸 How to add header and footer?</div> <div> 􀁸 How to add page number?</div> <div> 􀁸 What are different printing options?</div> <div> 11-Exercise</div> <div> In the coming exercise you can improve the appearance and usefulness of your printouts by</div> <div> changing the page margin, specifying a target print area, adding headers and footers. You will</div> <div> also learn how to take printout of your worksheets</div> <div> Task 1:</div> <div> Select a print range :</div> <div> In monthly expenses worksheet, select range from A1 to B6. Open file menu and point to</div> <div> print area and select click on Set Print Area on submenu. Click Print preview on toolbar to</div> <div> view the print range. Click on close button on print preview toolbar. To clear print range</div> <div> open file menu. Point to print area and click on Clear Print Area on submenu.</div> <div> Task 2:</div> <div> Insert and Remove Page breaks :</div> <div> With monthly expenses still open, to print items name on one page and expenses on</div> <div> other page select column B and C. Open Insert menu and select Page break. A dotted</div> <div> line is shown after column A. Click on print preview icon and you will see the names of</div> <div> items on page 1. Click on Next button on toolbar to view the next page. You will see</div> <div> expenses on the next page. Click close button on toolbar and open Insert menu. Choose</div> <div> Remove page break from the menu to clear the page breaks.</div> <div> Task 3:</div> <div> Setting orientation, Margins and center worksheet on a page :</div> <div> In monthly expenses worksheet, open file menu and click page setup option. Click on</div> <div> page tab and choose landscape from orientation section. Set print quality to highest</div> <div> option. Click Margin tab and set top margin and bottom margin to 1.25. Click horizontally</div> <div> and vertically options in center on page section of page setup dialog box. Click print</div> <div> preview button.</div> <div> Task.4:</div> <div> Create a header and footer :</div> <div> Open monthly expenses Worksheet and select sheet1 and sheet 2 tabs. Open view</div> <div> menu and choose the option header and footer. Click on customer header option and</div> <div> then click in center section. Click sheet icon from toolbar which is third last icon on</div> <div> toolbar. Then press ok button and then click on customer footer. Click in center section.</div> <div> Type page and click on # icon in toolbar, then type “of” and click on plus sign in toolbar.</div> <div> Click ok button and then click on print preview button. Sheet1 is shown on top and page 1</div> <div> at bottom, click on next icon on print preview toolbar and you will see sheet2 on top of</div> <div> page.</div> <div> Task.5:</div> <div> Applying and printing formula used in Cells :</div> <div> Virtual University of Pakistan</div> <div> 99</div> <div> Computer Proficiency License (CS001) VU</div> <div> Open any spreadsheet in which formulas are used. Click on tools menu and then on</div> <div> options. In dialog box, click view tab and then select formula option in windows options</div> <div> section. A checkmark will appear in front of formula and finally click ok button. You will</div> <div> see formula within the cells Click file menu and select page setup Click on landscape</div> <div> option in orientation section and fit in scaling section. Click print preview button, then click</div> <div> zoom button to adjust the view. Click print button and ok. Finally press Control + ~ keys</div> <div> to deselect formula option.</div> <div> Task.6:</div> <div> Previewing and printing multiple sheets :</div> <div> Open a spreadsheet in which sheet 1, sheet 2 and sheet 3 contains some data. To print</div> <div> all three sheets at once first click on sheet 1 tab. Hold the shift key and click on sheet 2</div> <div> and sheet 3 tab. Click print preview button. Click zoom button to magnify image. Click</div> <div> next button on toolbar two times to cycle through three selected sheets. Click print button</div> <div> in print preview window and then click ok.</div> <div> Task.7:</div> <div> Hide some columns and rows in WS :</div> <div> Open an already created spreadsheet. Since you want to print a report that does not</div> <div> include column C. Right click on column C heading and click hide. Click on print preview,</div> <div> column C is not shown so print the worksheet. To again display the hidden column C first</div> <div> select Col B and D. Right click on the selection and click unhide. Column C will be shown</div> <div> Virtual University of Pakistan</div> <div> 100</div> <div> Computer Proficiency License (CS001) VU</div> <div> Computer Proficiency License (CS-001)</div> <div> Lecture 33</div> <div> Advance Topics</div> <div> 1. Objectives</div> <div> The objective of this lecture is to provide information about</div> <div> 􀁸 What is pivot table?</div> <div> 􀁸 How to create pivot table?</div> <div> 􀁸 What is data consolidation and how to consolidate the data among worksheets?</div> <div> 2. Pivot tables</div> <div> Pivot tables are interactive tables which automatically extract, organize and summarize the data.</div> <div> Pivot tables are used to prepare summary reports.</div> <div> 3. How to create pivot tables</div> <div> 1. Open the workbook where you want to create the Pivot table report.</div> <div> o If you are basing the report on a report template, Office Data Connection file, or</div> <div> query file, retrieve the data into the workbook, and then click a cell in the</div> <div> Microsoft Excel list containing the retrieved data.</div> <div> If the retrieved data is from a database, or the Office Data Connection returns the</div> <div> data as a blank PivotTable report, continue with step 6 below.</div> <div> o If you are basing the report on an Excel list or database, click a cell in the list or</div> <div> database.</div> <div> 2. On the Data menu, click PivotTable and PivotChart Report.</div> <div> 3. In step 1 of the PivotTable and PivotChart Wizard, follow the instructions, and click</div> <div> PivotTable under What kind of report do you want to create?</div> <div> 4. Follow the instructions in step 2 of the wizard.</div> <div> 5. Follow the instructions in step 3 of the wizard, and then decide whether to lay out the</div> <div> report onscreen or in the wizard.</div> <div> 4. Worksheet consolidation</div> <div> 1. Examine your data and decide whether to consolidate it with 3-D references in formulas,</div> <div> by position, or by category.</div> <div> Formulas You can use 3-D references in formulas for any type or arrangement of data.</div> <div> This is the recommended method.</div> <div> Position If you're planning to combine data that's in the same cell in each of several</div> <div> ranges, you can consolidate by position.</div> <div> Virtual University of Pakistan</div> <div> 101</div> <div> Computer Proficiency License (CS001) VU</div> <div> Category If you have several ranges with different layouts, and you're planning to</div> <div> combine data from rows or columns that have matching labels, you can consolidate by</div> <div> category.</div> <div> 1. On the consolidation worksheet, copy or enter the labels you want for the</div> <div> consolidated data.</div> <div> 2. Click a cell that you want to contain consolidated data.</div> <div> 3. Type a formula that includes references to the source cells on each worksheet</div> <div> that contains data you want to consolidate.</div> <div> For example, to combine the data in cell B3 from worksheets Sheet 2 through</div> <div> Sheet 7 inclusive, you could type =SUM (Sheet2:Sheet7!B3). If the data to</div> <div> consolidate is in different cells on different worksheets, enter a formula such as</div> <div> this: =SUM (Sheet3!B4, Sheet4!A7, Sheet5!C5). To enter a reference such as</div> <div> Sheet3! B4 in a formula without typing, type the formula up to the point where</div> <div> you need the reference, click the worksheet tab, and then click the cell.</div> <div> 4. Set up the data to be consolidated.</div> <div> 􀂃 Make sure each range of data is in list format: each column has a label</div> <div> in the first row and contains similar facts, and there are no blank rows or</div> <div> columns within the list.</div> <div> 􀂃 Put each range on a separate worksheet. Don't put any of the ranges on</div> <div> the worksheet where you plan to put the consolidation.</div> <div> 􀂃 If you're consolidating by position, make sure each range has the same</div> <div> layout.</div> <div> If you're consolidating by category, make sure the labels for columns or</div> <div> rows that you want to combine have identical spelling and capitalization.</div> <div> 􀂃 Name each range: select the entire range, point to Name on the Insert</div> <div> menu, click Define, and type a name for the range.</div> <div> 5. Click the upper-left cell of the area where you want the consolidated data to</div> <div> appear.</div> <div> 6. On the Data menu, click Consolidate.</div> <div> 7. In the Function box, click the summary function you want Microsoft Excel to use</div> <div> to consolidate the data.</div> <div> 8. Click the Reference box, click the sheet tab of the first range to consolidate, type</div> <div> the name you gave the range, and then click Add. Repeat this step for each</div> <div> range.</div> <div> 9. If you want to update the consolidation table automatically whenever data in any</div> <div> of the source ranges changes, and you're sure you won't want to include different</div> <div> or additional ranges in the consolidation later on, select the Create links to</div> <div> source data check box.</div> <div> 10. If you're consolidating by position, leave the boxes under Use labels in blank.</div> <div> Microsoft Excel does not copy the row or column labels in the source ranges to</div> <div> the consolidation. If you want labels for the consolidated data, copy them from</div> <div> one of the source ranges or enter them manually.</div> <div> If you're consolidating by category, select the check boxes under Use labels in</div> <div> that indicate where the labels are located in the source ranges: either the top</div> <div> row, the left column, or both. Any labels that don't match up with labels in the</div> <div> other source areas result in separate rows or columns in the consolidation.</div> <div> Virtual University of Pakistan</div> <div> 102</div> <div> Computer Proficiency License (CS001) VU</div> <div> 5. Summary</div> <div> In this lesson, we have learnt</div> <div> 􀁸 What is pivot table?</div> <div> 􀁸 How to create pivot table?</div> <div> 􀁸 What is data consolidation?</div> <div> Exercise</div> <div> Task 1:</div> <div> Create a pivot table :</div> <div> Create a SS which contain sales figure of every product your company makes.</div> <div> Worksheet contains columns for year, type, salesperson, sale, units, and region. Open</div> <div> Data menu and click Pivot table and Pivot chart Report. From step 1 select Microsoft</div> <div> Excel and click on Next. In step 2 ranges is already selected for you click on Next. In third</div> <div> step New Worksheet is already selected click on finish button. Drag region icon from</div> <div> pivot table field list to row field section. Drag Type icon from pivot table field list to column</div> <div> field section. Drag Sales icon from pivot table field list to Data field section.</div> <div> Finally a Pivot table is created on the screen.</div> <div> Task 2:</div> <div> Add or remove field :</div> <div> To add or remove columns click on pivot table created in previous exercise. To remove</div> <div> region field from row section, click on region heading. Drag it to outside the pivot table</div> <div> report. To add columns in pivot table Click on show field list icon in pivot table toolbar,</div> <div> and drag sales person field icon from pivot field window to row section you will see</div> <div> names of salespersons in pivot table row section.</div> <div> Task 3:</div> <div> Show just the detail :</div> <div> To show selected field data in pivot table open pivot table created in previous exercise. In</div> <div> pivot table, click arrow besides any field heading. From the list deselect any item which</div> <div> you do not want to show. Click on Ok button and deselected items will not be shown in</div> <div> pivot table.</div> <div> Task 4:</div> <div> Data consolidation :</div> <div> Create a Spreadsheet whose sheet 1 contains monthly expenses of different items for</div> <div> month of January, Sheet 2 contains monthly expenses for month of February, and sheet</div> <div> 3 for month of March. In sheet 4 calculate average expense of each item. Add headings</div> <div> Items name and Average expenses in starting cells. Select cells under average expenses</div> <div> heading. Open Data menu and select consolidate option. Click function drop down list</div> <div> and choose function name average. Click icon of miniature spreadsheet in reference</div> <div> field. Next click on sheet 1 tab. Select values under amount column and again click on</div> <div> miniature spreadsheet icon. Click add button to save it, repeat this process and add</div> <div> sheet 2 and 3 data. Finally Click creates to link to save data box. Finally click on ok</div> <div> button.</div> <div> Virtual University of Pakistan</div> <div> 103</div> <div> Computer Proficiency License (CS001) VU</div> <div> Computer Proficiency License (CS-001)</div> <div> Lecture 34</div> <div> Introduction of Power Point</div> <div> 1. Objectives</div> <div> The objective of this lecture is to provide information about:</div> <div> 􀁸 Open and close presentation software.</div> <div> 􀁸 Open one, several presentations.</div> <div> 􀁸 Create a new presentation based on an available presentation.</div> <div> 􀁸 Save a presentation to a location on a drive.</div> <div> 􀁸 Save a presentation under another name.</div> <div> 􀁸 Switch between open presentations.</div> <div> 2. Open and Close Power point application</div> <div> To open the presentation file, first you need to start software.</div> <div> Go to start < All Programs < Microsoft Office < Microsoft Office PowerPoint l2003</div> <div> In the start a screen will appear for few seconds. This is called splash screen. A new presentation</div> <div> file will open, after this screen would disappear. The arrangement of toolbars panels and sheets</div> <div> is called default layout.</div> <div> 3. Screen Layout:</div> <div> 􀃎Title Bar:</div> <div> The most upper bar of window is called title bar. Its top left corner shows the document default</div> <div> name like “Microsoft PowerPoint presentation1“ shows document is of type Microsoft PowerPoint</div> <div> and its temporary name is presentation1.When we save the document we can give another name</div> <div> to document</div> <div> A file created by presentation software is called presentation. On the right side of title bar there</div> <div> are three buttons to minimize, restore and close the excel file.</div> <div> Minimize button is used to minimize the document. Restore is use to restore down and close</div> <div> button is use to close the document.</div> <div> 􀃎 Menu bar: There is another bar after the title bar is called menu bar. Menu bar contains</div> <div> different options to use features like file, edit, view etc</div> <div> For using any main menu we just move the mouse cursor over it and it will show submenu.</div> <div> 􀃎 Toolbar: The strip next to menu bar is toolbar. Toolbar is shortcut of menu bar sub options.</div> <div> We also called it standard toolbar because it has buttons to perform important tasks.</div> <div> Virtual University of Pakistan</div> <div> 104</div> <div> Computer Proficiency License (CS001) VU</div> <div> We can use these options by clicking icons. For knowing the purpose of these icons just take the</div> <div> mouse pointer over there and wait for a while you will see name of icon in form of label. This label</div> <div> is called tool tip text.</div> <div> 􀃎 Task pan: When you start the presentation software you will find on the right side a panel</div> <div> called task pan. On the top of task pan there is written by “Getting started” and you will find</div> <div> options to search from online help, to open recently opened presentation files and to create a new</div> <div> presentation etc.</div> <div> 􀃎 Slide area: In the center of presentation you see a white area called slide. Another area down</div> <div> to slide is notes area. We can add notes for explaining the matters discussed on the slide in notes</div> <div> area. On the left side of slide, index of all the slides in the presentation can be seen. We use this</div> <div> area to view several pages in the presentation.</div> <div> 􀃎Drawing toolbar: Bottom of page a bar called drawing toolbar, which is used for making</div> <div> different shapes.</div> <div> 4. Creating and saving new presentation</div> <div> To create a new presentation:</div> <div> 1-Click < File < New.</div> <div> The New Presentation Task Pane will appear on the</div> <div> right side of the window.</div> <div> 2-From the New Presentation Task Pane, click Blank</div> <div> Presentation.</div> <div> 􀃎Two ways to insert a new slide:</div> <div> 1- Click < Insert < New Slide.</div> <div> 2- Press Ctrl+M.</div> <div> 􀃎 To save a presentation:</div> <div> After creating the presentation the next step is to save them. We will use “SAVE” command of file</div> <div> menu to save presentation:</div> <div> Three ways to save a file:</div> <div> 1- Click < File < Save</div> <div> 2- Press Ctrl+S</div> <div> 3- Click on Save Icon in formatting toolbar</div> <div> 5. Run a presentation</div> <div> Three ways to run a presentation:</div> <div> Virtual University of Pakistan</div> <div> 105</div> <div> Computer Proficiency License (CS001) VU</div> <div> 1- Press F5 key</div> <div> 2- Click < Slide Show < View Show</div> <div> 3- Click view button</div> <div> 6. Save a presentation with another name</div> <div> When you want to make changes in existing file and to make another copy of existing file, we will</div> <div> use “SAVE AS” option of file menu.</div> <div> 7. Closing a presentation</div> <div> You can close a presentation at any time. Note that although this closes the presentation window,</div> <div> it does not exit PowerPoint.</div> <div> To close a presentation, follow these steps:</div> <div> 1- Click File < Close or</div> <div> 2- Click the presentation’s Close (X) button.</div> <div> 8. Open one, several presentations</div> <div> Files are saved on disk we can open it by any time.</div> <div> To open a presentation file there can be three ways:</div> <div> 1- Click File < open</div> <div> 2- Click on the Open icon</div> <div> 3- Double click left mouse button on the presentation file.</div> <div> 9. Switching among open presentations</div> <div> There can be two ways to switch among open files:</div> <div> 1- Click file name visible in the taskbar.</div> <div> 2- Press Alt+Tab.</div> <div> 10. Exercise</div> <div> Task 1:</div> <div> Creating Shortcut on the Desktop:</div> <div> Click on the Start button. Click on All Programs menu option. Locate Microsoft Power</div> <div> Point option. Now drag the icon of MS Power Point on the desktop. The shortcut of MS</div> <div> Power Point is now on the desktop.</div> <div> Task 2:</div> <div> Starting Microsoft Power Point:</div> <div> Click on Start button in the bottom left most corner of the screen. Now point to the All</div> <div> Program option. Now click on the Microsoft Office option. Locate Microsoft Power Point &</div> <div> left click on it. In this way Power point will get started.</div> <div> Task 3:</div> <div> Creating & Saving a new Presentation:</div> <div> First start the MS Power point. Click on File menu from Menu bar. Click on New option.</div> <div> The shortcut key for this purpose is Ctrl + N.</div> <div> Virtual University of Pakistan</div> <div> 106</div> <div> Computer Proficiency License (CS001) VU</div> <div> Now enter the some text in the text boxes of the presentation slide(s). Click on File menu</div> <div> from Menu bar. Click on Save option. A window titled Save As appears. Select the</div> <div> location where you want to save the presentation. Write the name you want to save file</div> <div> with. The shortcut key for this purpose is Ctrl + S. In this way we will create and save a</div> <div> power point presentation</div> <div> Task 4:</div> <div> Finding & Replacing Text in the Slide:</div> <div> Click on Edit menu from Menu bar. Click on Find option. A window appears titled Find.</div> <div> Write the text in the text box which you want to find. Click on Find Next button. If that</div> <div> particular text exist then it will be highlighted otherwise error message will be displayed. If</div> <div> you want to replace the found text then click on Replace button. Write the new text in the</div> <div> new text box appeared & click Replace or Replace All button according to the</div> <div> requirement. We can also restrict our search to “case sensitive” or “search complete</div> <div> word” by checking the check boxes Match Case and Find whole words only. The</div> <div> shortcut key for opening this Find window is Ctrl + F. The replacement can also be done</div> <div> by selecting the Replace option from the Edit menu. The shortcut key for this purpose is</div> <div> Ctrl + H</div> <div> Task 5:</div> <div> Changing of Font style:</div> <div> Select the text of which font style is to change. Select the particular font style from the</div> <div> dropdown Font style list located in formatting toolbar. In this way the font style of selected</div> <div> text will be changed.</div> <div> Task 6:</div> <div> Insert Table into the Presentation slides:</div> <div> Create / open the presentation slide. Click on the Insert menu from Menu bar. Now click</div> <div> on the table option from Insert menu. Enter the number of rows and columns required in</div> <div> the window appeared. Click OK button to create table.</div> <div> Virtual University of Pakistan</div> <div> 107</div> <div> Computer Proficiency License (CS001) VU</div> <div> Computer Proficiency License (CS-001)</div> <div> Lecture 35</div> <div> Developing a presentation</div> <div> 1. Objectives</div> <div> The objective of this lecture is to provide information about:</div> <div> 􀁸 How to view a presentation in different ways?</div> <div> 􀁸 What is slide layout and how to add slide in presentation?</div> <div> 􀁸 How can we use design template to improve a presentation?</div> <div> 􀁸 How to use slide master to manage a complete presentation?</div> <div> 2. Presentation views</div> <div> A view is a way of displaying and working with your</div> <div> presentation and it is possible to display a presentation in a</div> <div> number of different ways. Each view displays the slides in a</div> <div> different way and emphasizes a different aspect. PowerPoint</div> <div> has four different views which you can work in.</div> <div> Each of the different views can be selected from the View</div> <div> drop-down menu as:</div> <div> Normal – Displays your slides one at a time for easy editing.</div> <div> Slide Sorter – Displays slide thumbnails for all the slides in the presentation.</div> <div> Slide Show – Displays your slides one slide at a time filling the whole screen.</div> <div> Notes Page – Displays your slides one at a time with space for you to add additional notes.</div> <div> You can switch to a different view either by using the View drop-down</div> <div> menu or by using the buttons in the bottom left corner of the</div> <div> application window.</div> <div> 2.1 Normal view:</div> <div> This is the default view and opens automatically when PowerPoint is started. This is also referred</div> <div> as the tri-pane view.</div> <div> The large pane in the middle is the slide editing</div> <div> pane. This allows making the necessary f</div> <div> changes. In this view you can edit your slides one</div> <div> at a time</div> <div> ormatting</div> <div> This view lets you work with a combination of</div> <div> features simultaneously including editing the slide,</div> <div> outline/slides and the Notes pane. The pane on</div> <div> the left hand slide is called the Outline/Slides</div> <div> pane. The Notes pane is displayed at the bottom</div> <div> and the main pain is called the Slide Pane.</div> <div> You can adjust the sizes of the individual panes.</div> <div> Each of these panes has its own scroll bar so you can move around in the different panes</div> <div> independently.</div> <div> Virtual University of Pakistan</div> <div> 108</div> <div> Computer Proficiency License (CS001) VU</div> <div> 2.2 Slide Sorter view:</div> <div> This allows you to easily rearrange your slides</div> <div> by dragging the slide thumbnails. It also</div> <div> indicates any slide transitions, text animations</div> <div> and displays their times.</div> <div> The slide number is displayed below each</div> <div> slide and any transitions and animations are</div> <div> indicated. You can reorder, delete cut and</div> <div> paste slides, add animations, transitions and</div> <div> set timings in this view.</div> <div> 2.3 Slide Show:</div> <div> Display the slides as an on-screen presentation taking</div> <div> up the full screen. This runs your presentation from the</div> <div> first slide .This view displays any slide transitions and</div> <div> timings</div> <div> 2.4 Notes Page view:</div> <div> This displays your slide in the top part of the window and</div> <div> displays any notes in the bottom part. While the notes for</div> <div> each slide are available in the Normal view, this view</div> <div> displays the notes as they will be printed. These notes do</div> <div> not appear during a slide show.</div> <div> The Notes page will only be displayed if you print the</div> <div> Notes page from the printing options.</div> <div> 3. Adding new slides</div> <div> There are several ways you can insert a new slide into a</div> <div> presentation:</div> <div> 1) Selecting Insert > New Slide.</div> <div> 2) Using the New Slide button on the standard toolbar</div> <div> 3) Using the Slides shortcut menu.</div> <div> Virtual University of Pakistan</div> <div> 109</div> <div> Computer Proficiency License (CS001) VU</div> <div> 4) Using the Slide Sorter shortcut menu.</div> <div> 5) Using Outline view.</div> <div> 6) Use the shortcut key Ctrl + M.</div> <div> 7) New slides are always added after the currently displayed slide.</div> <div> 4. Using design template</div> <div> To change design of slide:</div> <div> 􀃎Click Format < Slide design. This will open a task pan on right side.</div> <div> There are several designs in this list that can be applied on our slides with a single click.</div> <div> 5. Using master slide</div> <div> We can create a new slide master to modifying the default slide master.</div> <div> To create slide master click View> Master > Slide Master</div> <div> Virtual University of Pakistan</div> <div> 110</div> <div> Computer Proficiency License (CS001) VU</div> <div> Then click the New Master icon (highlighted in the figure)</div> <div> A second slide master appears in the Slides pane. Modify this slide master to you’re your</div> <div> requirements.</div> <div> Applying a slide master</div> <div> 􀁸 To apply one of the slide masters to all slides in your presentation</div> <div> 􀃆 Click on it in the list.</div> <div> 􀁸 To apply a different slide master to one or more selected Slides:</div> <div> 1) In the Slide Pane, select the slides you want to change.</div> <div> 2) In the Tasks Pane, right-click on the slide master you want to apply to the selected</div> <div> slides, and click Apply to Selected Slides on the pop-up menu.</div> <div> Exercise</div> <div> Task 1:</div> <div> Creating a slide:</div> <div> Open the PowerPoint program. The PowerPoint dialog box appears. In the PowerPoint</div> <div> dialog box, click the Blank Presentation option button. The New Slide dialog box appears.</div> <div> It asks you to choose an Auto Layout format. Click the Title Slide layout. It's the first in the</div> <div> list. The name Title Slide appears in the preview box. Click OK. A Title Slide appears,</div> <div> ready for you to work with.</div> <div> Task 2:</div> <div> Adding text to a slide:</div> <div> The Title Slide layout contains text boxes for a title and a subtitle. Try typing text into</div> <div> these boxes. Click in the Title text box. A thick gray border appears around the text box</div> <div> indicating that it is selected. Type a title. Click the Subtitle text box and type a subtitle.</div> <div> Task 3:</div> <div> Adding another slide:</div> <div> Click the New Slide button on the Common Tasks toolbar. The Auto Layout dialog box</div> <div> will appear. Choose a layout for your next slide.</div> <div> Task 4:</div> <div> Moving from slide to slide:</div> <div> To move to a previous slide:</div> <div> Click the upper double-arrow button on the lower right corner of the PowerPoint</div> <div> window. The previous slide will appear. To move to the next slide: Click the lower doublearrow</div> <div> button on the lower right corner of the PowerPoint window.</div> <div> Task 5:</div> <div> Creating a presentation using templates:</div> <div> If you have just launched PowerPoint, click the Template option button in the PowerPoint</div> <div> dialog box to start a new presentation. If you are already working in PowerPoint, follow</div> <div> these steps: Click the File menu, then click New. The New Presentation dialog box</div> <div> appears. Click the Presentation Designs tab, and then click an appropriate template. The</div> <div> design will appear in the preview box. Click OK. The New Presentation dialog box will</div> <div> close.</div> <div> Virtual University of Pakistan</div> <div> 111</div> <div> Computer Proficiency License (CS001) VU</div> <div> Computer Proficiency License (CS-001)</div> <div> Lecture 36</div> <div> Formatting</div> <div> 1. Objectives</div> <div> The objective of this lecture is to provide information about:</div> <div> 􀁸 How to create text boxes and create texts in them?</div> <div> 􀁸 How to change font style, size and color of text in slide?</div> <div> 􀁸 How to apply bullets and numbering in a slide?</div> <div> 􀁸 How to add relevant pictures and adjust them?</div> <div> 􀁸 How to cut copy and paste in slides?</div> <div> 2. Adding Text:</div> <div> To add text to a title of a slide:</div> <div> 􀃆 Click in the box that says "click to add title" Just type in the text you want.</div> <div> 3. Adding New Text Box</div> <div> To insert a new textbox:</div> <div> 􀃆Select Insert > Text Box or use the button from the Drawing toolbar.</div> <div> The cursor will change to a cross, letting you to click where you want the new textbox and drag</div> <div> the mouse diagonally to create it. Type the text immediately, if the textbox is left blank and then</div> <div> de-selected the textbox will be deleted automatically.</div> <div> 4. Deleting Text Box</div> <div> 􀃆Click the border of the text box that you want to delete, and then press DELETE.</div> <div> Make sure that the pointer is not inside the text box, but rather on the border of the text box. If the</div> <div> pointer is not on the border, pressing DELETE will delete the text inside the text box and not the</div> <div> text box.</div> <div> 5. Rotating Text Box</div> <div> To rotate a text Box:</div> <div> 􀃆Select the text box you want to rotate.</div> <div> You find a green circle on the top of text box; it is actually a rotate tool of text box, when you take</div> <div> mouse over the circle its shape change to circle. Then rotate the text box as you want.</div> <div> 6. Border and Fill Color to Text Box</div> <div> 1-Right-click on the text box</div> <div> 2- Select Format Text Box or select Format menu > Text Box.</div> <div> You can select your desired fill color and border from this dialogue box.</div> <div> 7. Change Font Style and Size</div> <div> Virtual University of Pakistan</div> <div> 112</div> <div> Computer Proficiency License (CS001) VU</div> <div> We can also change font and font size.</div> <div> To change Font and font size:</div> <div> 􀃆Click Format > Font</div> <div> This dialogue box will appear, select text</div> <div> font and size.</div> <div> 8. Bold, Underline, Italic and</div> <div> Shadow</div> <div> To change font style:</div> <div> 1- Select text.</div> <div> 2- Click Format > Font > Font Style</div> <div> 9. Text Alignment</div> <div> Alignment means how we can display text on the slide. PowerPoint offers four types of paragraph</div> <div> alignment: Left, Right, Centre and Justify.</div> <div> To apply text alignment:</div> <div> 􀃆 C lick Format > Alignment</div> <div> 10. Bullets and Numbering</div> <div> We can add bullets and numbering by two ways:</div> <div> Bullets:</div> <div> 1- This button is a toggle. Press it once to add bullets and then press it again to remove the</div> <div> bullets.</div> <div> 2- Click Format > Bullets and numbering.</div> <div> Numbering:</div> <div> 1- This button is a toggle. Press it once to add numbering and then press it again to remove the</div> <div> numbering.</div> <div> 2- Click Format > Bullets and numbering.</div> <div> 11. Making Sub Points</div> <div> We can also make sub point by adding bullets and numbering.</div> <div> To make sub points:</div> <div> 1- Select text lines</div> <div> 2- Press Tab key.</div> <div> 12. Increasing and Decreasing Font Size</div> <div> We can change font size of any text</div> <div> Virtual University of Pakistan</div> <div> 113</div> <div> Computer Proficiency License (CS001) VU</div> <div> To increase Font size:</div> <div> 1- Select text</div> <div> 2- Press increase font size button.</div> <div> To increase Font size:</div> <div> 1-Select text</div> <div> 2- Press decrease font size button.</div> <div> 13. Changing Font Color</div> <div> We can also change font color .Any of two methods can be chosen:</div> <div> 1- Press this once to change the selecting text.</div> <div> 2- Click Format > Font > Font color</div> <div> 14. Adding Pictures</div> <div> We can add picture and images in slides.</div> <div> To insert picture:</div> <div> 1) Using a Clip Art Placeholder.</div> <div> 2) Using a Content placeholder.</div> <div> 3) Using the Clip Art Task Pane.</div> <div> 4) Using Insert > Picture > From File.</div> <div> 15. Copy and Paste Objects</div> <div> You can copy and paste data between different slides and presentations using the clipboard.</div> <div> To Copy Text:</div> <div> 1- Select Text</div> <div> 2- Click Edit < Copy or Press Ctrl+C</div> <div> To Paste Text:</div> <div> 1- Select Location to paste.</div> <div> 2- Click Edit < Paste or Press Ctrl+V</div> <div> 16. Cut and Paste Objects</div> <div> You can cut and paste data between different slides and presentations using the clipboard.</div> <div> To Cut Text:</div> <div> 3- Select Text</div> <div> 4- Click Edit < Cut or Press Ctrl+X</div> <div> To Paste Text:</div> <div> 3- Select Location to paste.</div> <div> 4- Click Edit < Paste or Press Ctrl+V</div> <div> Exercise</div> <div> Virtual University of Pakistan</div> <div> 114</div> <div> Computer Proficiency License (CS001) VU</div> <div> Task 1:</div> <div> Adding Text to the Presentation Slide:</div> <div> Open the new presentation. A slide will appear containing two text boxes. Each text box</div> <div> has some instructions written into it. Left click in the text box and add text which you want</div> <div> through keyboard.</div> <div> Task 2:</div> <div> Adding new Slide into the Presentation:</div> <div> Open the presentation in which you want to enter the new slide. Click on “New Slide”</div> <div> option from formatting toolbar. A new slide will be inserted into that presentation.</div> <div> Task 3:</div> <div> Adding Text Box to the Presentation Slide:</div> <div> Open the slide where you want to enter the text box. Click on the Insert menu from Menu</div> <div> bar. Click on Text box option from Insert menu list. The shape of mouse pointer will</div> <div> become like . Now drag this pointer where you want to insert the text box in the slide.</div> <div> The same option of text box can also be selected from “Drawing toolbar”.</div> <div> Task 4:</div> <div> Duplicating the Slide:</div> <div> Open the presentation. Select the slide which you want to make duplicate. Click on the</div> <div> Insert menu from menu bar. Click on option “Duplicate Slide” to create its duplicate.</div> <div> Task 5:</div> <div> Password Protection of Presentation:</div> <div> Open the presentation on which you want to apply password protection. Click on Tool</div> <div> menu from menu bar. Click on Options link. A widow will appear titled Options. Click on</div> <div> Security tab. Enter the password with which you want to open the presentation. Also</div> <div> enter the password for modifying the presentation. Click Ok button to implement these</div> <div> changes.</div> <div> Task 6:</div> <div> Automatically Save Presentation:</div> <div> Click the Tool menu from Menu bar. Now click on the option named Options. A window</div> <div> will appear titled Options. Click Save tab. Check the check box named “Save auto</div> <div> recover every” and then select the time after which you want to save the presentation.</div> <div> Click Ok button to implement the changes.</div> <div> Virtual University of Pakistan</div> <div> 115</div> <div> Computer Proficiency License (CS001) VU</div> <div> Computer Proficiency License (CS-001)</div> <div> Lecture 37</div> <div> Charts and Objects</div> <div> 1. Objectives</div> <div> The objective of this lecture is to provide information about:</div> <div> 􀁸 How to add graph in presentation?</div> <div> 􀁸 How to create and edit organizational chart?</div> <div> 􀁸 How to draw different objects and format them?</div> <div> 2. Creating charts and graphs</div> <div> One way to add a chart to a presentation is to apply a slide layout that contains a chart</div> <div> placeholder. There are several layouts on the Slide Layout task pane that can be used.</div> <div> 1) Use the Content Palette</div> <div> 2) Use the Chart Placeholder</div> <div> 3) Use Insert > Chart</div> <div> All these methods use the Microsoft Graph application to allow you to insert charts directly.</div> <div> 3. Editing charts</div> <div> We can change data values and labels at any time.</div> <div> To change a graph or chart just change its data values in data sheet.</div> <div> To delete a data, just select it and press delete will delete data from chart.</div> <div> 4. Formatting charts</div> <div> The lines on the edges of the chart are referred to as the axes. The X-axis is the line along the</div> <div> left edge of the chart. The x-axis usually indicates categories .The actual data values are plotted</div> <div> on the y-axis. Microsoft Graph will automatically provide labels for the axes but these can be</div> <div> changed manually.</div> <div> To format or change any portion of graph, double click on it with left mouse pointer. Formatting</div> <div> dialogue box related to particular portion will open up for making changes.</div> <div> We can change color, text, labels, font etc</div> <div> 5. Changing chart type</div> <div> To change chart type:</div> <div> 1-Right click on an empty white space of graph.</div> <div> 2- Click Chart Type</div> <div> A dialogue box named as “chart type” will open, select desired chart type.</div> <div> 6. Changing chart label</div> <div> To change chart labels</div> <div> Virtual University of Pakistan</div> <div> 116</div> <div> Computer Proficiency License (CS001) VU</div> <div> 1- Right click on empty white space of chart.</div> <div> 2- Click Chart Options</div> <div> The dialogue box show you chart options, you can change data labels, legends etc from here.</div> <div> 7. Organization chart</div> <div> A graphic representation of data of an organization is called organizational chart. We can also</div> <div> show structure of any project in the form of chart.</div> <div> To create organization chart:</div> <div> 1- select slide layout as organization chart</div> <div> 2- Apply layout with single click.</div> <div> 3- Double click on diagram.</div> <div> It will open a dialogue box, select appropriate diagram type.</div> <div> 8. Drawing Objects</div> <div> We can use and work with different objects on a slide. Anything created on a slide is called</div> <div> object. We can draw any object on empty slide. For drawing purpose, drawing tool bar is</div> <div> available to draw different shapes.</div> <div> 9. Drawing lines</div> <div> To draw a line:</div> <div> 􀃆 Select line tool from toolbar .</div> <div> 􀃆 Click left mouse button and drag the mouse to click a shape.</div> <div> 10. Drawing arrows</div> <div> To draw arrow:</div> <div> 􀃆 Select arrow tool from toolbar .</div> <div> 􀃆 Click left mouse button and drag the mouse to click a shape.</div> <div> 11. Drawing rectangle</div> <div> To draw rectangle</div> <div> 􀃆 Select rectangle tool from toolbar .</div> <div> 􀃆 Click left mouse button and drag the mouse pointer diagonally downward.</div> <div> 12. Changing orders</div> <div> We can place object over each other and also can changed their order.</div> <div> To Change order:</div> <div> 􀃆 Right Click > Order</div> <div> Virtual University of Pakistan</div> <div> 117</div> <div> Computer Proficiency License (CS001) VU</div> <div> It shows you further four options. Select them according to your need.</div> <div> 13. Summary</div> <div> In this lesson we have learnt:</div> <div> How to add graph in presentation</div> <div> How to create and edit organizational chart</div> <div> How to draw different objects and format them</div> <div> 13. Exercise</div> <div> Task 1:</div> <div> Adding a shape:</div> <div> PowerPoint lets you add a variety of shapes to the slides of your presentation. Try adding</div> <div> a star shape to your slide, using the AutoShape tool on the drawing toolbar. Click the</div> <div> AutoShapes button, point to Stars and Banners, and then click the 5-point star shape.</div> <div> The pointer will change into a cross. Click anywhere on the slide. A star of predefined</div> <div> size will be inserted. To make the shape larger (or smaller), drag a resizing handle. To</div> <div> resize the shape proportionally, hold down the SHIFT key as you drag.</div> <div> Task 2:</div> <div> Adding color and texture to a shape</div> <div> First, try adding the color yellow to the star. Click the star shape to select it. Click the</div> <div> arrow beside the Fill Color button, and then click More Fill Colors. A Colors dialog box</div> <div> appears. Click the Standard tab, then under Colors, click a shade of yellow. Click OK to</div> <div> close the Colors dialog box.</div> <div> Task 3:</div> <div> Adding a chart:</div> <div> To add a chart to any slide, click the Insert Chart button on the Standard Toolbar. When</div> <div> you insert a chart, a sample data sheet and corresponding bar chart will appear on your</div> <div> slide. PowerPoint has included some sample data in the first four columns. The bars in</div> <div> the chart are the graphical representation of the numbers in the data sheet. Notice how a</div> <div> higher number in the data sheet results in a taller corresponding bar. To create your own</div> <div> chart, you can replace the data in the sample data sheet with your own. Try adding a</div> <div> number to the chart to see how it changes the corresponding bar on the chart. On the</div> <div> data sheet, click in the first row of column A. Type in the number 50, then press Enter.</div> <div> The corresponding bar on the chart increases in height. Try adding other numbers into</div> <div> the data sheet to see how they affect the bars.</div> <div> Task 4:</div> <div> Adding and deleting information:</div> <div> The default chart has four sets of bars, and its data sheet has four columns of information</div> <div> filled in. What if your presentation requires more than four columns/bars? It's simple. Fill</div> <div> in additional columns on your data sheet. Go to the next empty column on the data sheet</div> <div> and click inside a cell. Type the numbers 50, 60, and 70 in the first three rows. Notice</div> <div> how a new set of bars appears in the chart.</div> <div> Virtual University of Pakistan</div> <div> 118</div> <div> Computer Proficiency License (CS001) VU</div> <div> Task 5:</div> <div> Changing the type of chart:</div> <div> The default chart in PowerPoint is a bar chart. If you think your information would be</div> <div> better as a different type of chart, you can change the chart type. The following steps</div> <div> show you how to convert the bar chart to a pie chart: Double-click the chart you want to</div> <div> change. A heavy border appears around the chart, and the data sheet appears. Click the</div> <div> Chart menu, and then click Chart Type. A Chart Type dialog box appears. In the Chart</div> <div> Type list, click Pie, and then click OK. The information in your data sheet will now be</div> <div> displayed in a pie chart.</div> <div> Virtual University of Pakistan</div> <div> 119</div> <div> Computer Proficiency License (CS001) VU</div> <div> Computer Proficiency License (CS-001)</div> <div> Lecture 38</div> <div> Animations</div> <div> 1. Objectives</div> <div> The objective of this lecture is to provide information about:</div> <div> 􀁸 How to apply animation scheme on presentation slides?</div> <div> 􀁸 What is animation and how is it related to presentation?</div> <div> 􀁸 What is purpose of slide transition?</div> <div> 􀁸 How to apply animations effect in slides?</div> <div> 2. Concepts</div> <div> Moving sequence of image is called animations. An animation is based on sequence of objects</div> <div> appearing quickly one after another. Examples of animations are cartoons. We can animate</div> <div> different objects in our slides. Using animation in our slides we can provide better control. We can</div> <div> also use mouse click or keys of keyboard to control the slides in our presentation.</div> <div> 3. Slide transition</div> <div> These are animations affect applied to the whole slide show. These effects are shown when we</div> <div> move from one slide to another.</div> <div> To add slide transition</div> <div> 􀃆Click Slide Show > Slide transition.</div> <div> 􀃆 Select transition style from the list</div> <div> 4. Animation scheme</div> <div> Slide transition only deals with the animations of the slides. It does not deal with the animation of</div> <div> objects on the slide.</div> <div> To apply animation on text box</div> <div> 􀃆 Click Slide Show < Animation scheme</div> <div> Select animation scheme from list.</div> <div> 5. Custom animation</div> <div> To apply custom animation</div> <div> 􀃆 Click Slideshow < Custom animation</div> <div> 􀃆 Select text or picture etc</div> <div> 􀃆 Apply transition</div> <div> 6. Changing order</div> <div> Virtual University of Pakistan</div> <div> 120</div> <div> Computer Proficiency License (CS001) VU</div> <div> When ever we apply animation to slide it numbered the transition effects. We can change order of</div> <div> the item presented in the list. This action will be done on mouse click.</div> <div> To change order:</div> <div> 􀃆 Select item</div> <div> 􀃆 Press “Reorder “button upward or downward according to need.</div> <div> 7. After Previous option</div> <div> You can animate list of things automatically without mouse click.</div> <div> 􀃆Click. Press Shift +item.</div> <div> 8. with previous effect</div> <div> With previous means object will start its motion along with its preceding object.</div> <div> 9. Summary:</div> <div> In this lesson we have learnt:</div> <div> 􀁸 How to apply animation scheme on presentation slides?</div> <div> 􀁸 What is animation and how is it related to presentation?</div> <div> 􀁸 What is purpose of slide transition?</div> <div> 􀁸 How to apply animations effect in slides?</div> <div> 10. Exercise</div> <div> Task 1:</div> <div> Change the Slide Design:</div> <div> Open the presentation for which you want to change the slide design. Click on Design</div> <div> option from the Formatting toolbar. A task pane containing a list of design templates will</div> <div> be opened. Click on the design template you want to implement particular design.</div> <div> Task 2:</div> <div> Apply Animation Scheme on the Presentation Slides:</div> <div> Open the presentation. Click on Design option from the Formatting toolbar. A window</div> <div> (task pane) will appear on the right side of the presentation slides. Click on “Animation</div> <div> Scheme” option. Now click on the animation from the animation list. Now click on the</div> <div> button “Apply to All”. Animation will be applied to all slides.</div> <div> Task 3:</div> <div> Disable Password Protection:</div> <div> Click on the Tools menu from Menu bar. Click on option named Options. A window will</div> <div> appear. Click on the Edit tab. Click on the check box named Password protection in the</div> <div> option list of Disable new features. Click Ok button to implement these changes.</div> <div> Task 4:</div> <div> Changing in Slide Design Color:</div> <div> Open the presentation for which you want to change the slide design color. Click on</div> <div> Design option from the Formatting toolbar. A task pane will be opened. Click on “Color</div> <div> Scheme option”. A list of color schemes will be opened. Click on the color scheme you</div> <div> want to apply on slide design.</div> <div> Task 5:</div> <div> Changing the Slide Layout:</div> <div> Virtual University of Pakistan</div> <div> 121</div> <div> Computer Proficiency License (CS001) VU</div> <div> Open the presentation slide. Click on Format menu from Menu Bar. Click on “Slide</div> <div> Layout” option. A task pane containing different layouts will appear. Click on the layout</div> <div> which you want to implement on the slide.</div> <div> Virtual University of Pakistan</div> <div> 122</div> <div> Computer Proficiency License (CS001) VU</div> <div> Computer Proficiency License (CS-001)</div> <div> Lecture 39</div> <div> Printing a Presentation</div> <div> 1.Objectives</div> <div> The objective of this lecture is to provide information about:</div> <div> 􀁸 How to remove spelling mistake from slides?</div> <div> 􀁸 How to add reference notes to our slides?</div> <div> 􀁸 How to hide and delete a slide?</div> <div> 􀁸 How to change page setup for printing presentation?</div> <div> 􀁸 How to take presentation and use different printing options?</div> <div> 2. Spelling Check</div> <div> There can be three ways to use spell check:</div> <div> 1-Go to the Tools menu and select Spelling.</div> <div> 2-By right click mouse button</div> <div> 3-using</div> <div> If a misspelled word is found:</div> <div> 􀃆Select Change to use PowerPoint's suggested spelling or to change the word to the spelling of</div> <div> your choice; type your own spelling into the window.</div> <div> 􀃆Select Add to add the word to your spell-check dictionary, so that PowerPoint won't think it's</div> <div> misspelled next time</div> <div> 3. Adding Notes</div> <div> We can add short text points on slide in</div> <div> notes area. The notes are not shown during</div> <div> the presentation. To use these notes we</div> <div> have to take their print out separately. We</div> <div> can view notes pages by clicking View <</div> <div> Notes Pages.</div> <div> To take print out of Notes pages:</div> <div> 1-Click File < Print Preview. This will open a</div> <div> window.</div> <div> 2-Select “Notes Pages” from Print What option.</div> <div> 3- Click Print Button</div> <div> 4. Hide and unhide slide</div> <div> After preparing presentation we can check its order and sequence. It is also possible that that you</div> <div> hide some slides for presentation.</div> <div> To hide a slide:</div> <div> 1- Select the slide in index area which you want to hide</div> <div> Virtual University of Pakistan</div> <div> 123</div> <div> Computer Proficiency License (CS001) VU</div> <div> 2-Right Click on slide and Select “Hide Slide” option or Click Edit < Hide Slide</div> <div> To unhide a slide:</div> <div> 1- Select the slide in index area which you want to unhide</div> <div> 2-Right Click on slide and Select “Hide Slide” option or Click Edit < Hide Slide</div> <div> 5. Page setup</div> <div> We can take the print out of our slides and</div> <div> notes but for this we have to change its</div> <div> page setup. Page setup can be landscape</div> <div> or portrait. Standard page is of portrait.</div> <div> To change page setup:</div> <div> 􀃆Click File < Page Setup</div> <div> This dialogue box will open, you can make changes according to your requirement.</div> <div> 6. Printing slides</div> <div> We can take print out of our slides prepared using Microsoft Power point. File created using a</div> <div> software and saved in computer are called softcopy and print out of soft copy is called hard copy.</div> <div> Three methods are there for printing:</div> <div> 4- Click on File < Print</div> <div> 5- Press Ctrl+P</div> <div> 6- Press print button</div> <div> 7. Summary</div> <div> In this lesson we have learnt:</div> <div> How to remove spelling mistake from slides</div> <div> How to add reference notes to our slides</div> <div> How to hide and delete a slide</div> <div> How to change page setup for printing presentation</div> <div> How to take presentation and use different printing options</div> <div> 8. Exercise</div> <div> Task 1:</div> <div> Checking your spelling:</div> <div> It's a good idea to check the spelling in your presentation before the audience sees it. Let</div> <div> PowerPoint's spelling checker check the presentation for you. When you activate the</div> <div> spelling checker, it checks the spelling in all of your slides. On the Standard toolbar, click</div> <div> the Spelling button. If a spelling error is detected a Spelling dialog box appears. The</div> <div> Spelling Checker suggests an alternative spelling in the Change To box. An additional list</div> <div> of suggestions may also appear below the box. If you want to continue without changing</div> <div> the spelling, click Ignore. If you want to change the spelling, enter one of the suggested</div> <div> alternatives in the Change to box, and then click Change.</div> <div> Task 2:</div> <div> Turning the automatic spelling checker off</div> <div> Virtual University of Pakistan</div> <div> 124</div> <div> Computer Proficiency License (CS001) VU</div> <div> Click the Tools menu, then click Options. The Options dialog box appears. Click the</div> <div> Spelling tab. Under Check spelling as you type, click the Spelling check box to deselect</div> <div> it. The check mark disappears. Click OK to close the Options dialog box. The automatic</div> <div> spelling checker is now deactivated.</div> <div> Task 3:</div> <div> Printing your presentation:</div> <div> Follow these steps to print your presentation. Click the File menu, and then click Print.</div> <div> The Print dialog box will open. To print all the slides in your presentation, click all. In the</div> <div> Print what list box; select what slide contents you want printed. In the Number of copies</div> <div> list box, enter the number of copies you want printed. Click OK to print the presentation</div> <div> Task 4:</div> <div> Selecting a new bullet style for points:</div> <div> Click anywhere in the bulleted text to select it. Click the Format menu, then click Bullet.</div> <div> The Bullet dialog box will appear. Click the square bullet in the symbol grid. If you want,</div> <div> select a new color for the bullet in the color list box. Click OK. The new bullet style will</div> <div> appear in your bulleted text.</div> <div> Task 5:</div> <div> Hiding and unhide Slide</div> <div> Right click on the slide in slide pane. Click hide slide in the opened menu. Slide will be</div> <div> hiding. To unhide the slide. Right Click slide in slide pane and click hide slide so slide will</div> <div> be unhide.</div> <div> Virtual University of Pakistan</div> <div> 125</div> <div> Computer Proficiency License (CS001) VU</div> <div> Computer Proficiency License (CS-001)</div> <div> Lecture 40</div> <div> Internet</div> <div> 1. Objectives</div> <div> The objective of this lecture is to provide information about:</div> <div> 􀁸 Difference between internet and www?</div> <div> 􀁸 What is webpage, web browser and website?</div> <div> 􀁸 What is meaning of search engine, ISP, FTP, HTTP and URL?</div> <div> 􀁸 How to open and close a web browser?</div> <div> 􀁸 How to change home page and open a web page in new window?</div> <div> 􀁸 What is the purpose of refresh, stop and history in the web page?</div> <div> 2. Internet and WWW</div> <div> WWW: stands for World Wide Web, It was introduced in 1991 and is the application of internet.</div> <div> World Wide Web means collection of online documents, which are stored in computers as</div> <div> services connected to internet and is the way to collect information from internet</div> <div> All of the websites in the world, taken together, make up the World Wide Web. We can get</div> <div> information from the World Wide Web through browsers.</div> <div> Internet: The Internet is the worldwide network of interconnected computers, including both web</div> <div> servers and computers like the one on your desk that run web browser software and share</div> <div> information, Instant messaging , email etc. The Internet also carries other kinds of network traffic</div> <div> unrelated to the web.</div> <div> 3. Web page, web site and web server</div> <div> Website: website is the way to get information on internet and it provide lot of information related</div> <div> to any topic. A website is a collection of web pages maintained by a single person or</div> <div> organization. A website has a distinct domain name, such as www.vu.edu.pk. Everything on</div> <div> www.vu.edu.pk, such as this page, is considered to be part of the www.vu.edu.pk website.</div> <div> Web Page: every website is made up of one or more web pages. Web page contains text with</div> <div> hyperlinks, tables, and other formatting and also contains images, sound, movies etc</div> <div> Web Server: web servers are the computers that actually run websites and are connected to</div> <div> internet. Each website has its own web server and it stores all web pages on server. web server</div> <div> control web site and it has special software to store collection of websites. The most common</div> <div> web server software is Apache, followed by Microsoft Internet Information Server.</div> <div> 4. Hyper text link: Hyper text was first introduced by Ted Nansen. In hypertext, text is not</div> <div> represented in sequence. It is non sequential writing. To connect non sequential pages links are</div> <div> created. Links are basically the connection to next pages or area. It means hyper link are links</div> <div> which lead us to next page on mouse click. Numerous type of material can be accessed by</div> <div> hyperlinks. When links are created on picture, graphics, and audio and video then these are</div> <div> called hypermedia links.</div> <div> 5. Web Browser: Browse means to see through some object or thing. When we visit some</div> <div> website it means we are browsing that site. To see some website on internet we need some</div> <div> Virtual University of Pakistan</div> <div> 126</div> <div> Computer Proficiency License (CS001) VU</div> <div> browser. Browsers are those programs that let you explore information on www or programs to</div> <div> view a website is called web browser. Many of web browser are available in the market like</div> <div> internet explorer, mosaic etc. purpose of all these browsers are only to browse WebPages but all</div> <div> the web browser provides different features along it like bookmark , history etc.</div> <div> 6. Http, Ftp and URL</div> <div> Data is transferred from one computer to other through some rules, these rules are called</div> <div> protocol. Different protocols are used on internet like HTTP, FTP and TCP/IP etc.</div> <div> HTTP: stands for hypertext transfer protocol. It is protocol to transfer WebPages from web server</div> <div> to web browser. Basic purpose of http is to transfer those pages which contain hyper text links. All</div> <div> web pages URL start with http. For example: http:// vu.edu.pk</div> <div> FTP: stands for file transfer protocol. Using this protocol we can access files from the ftpserver.</div> <div> Ftp server are those computers on internet which store different type of files. These servers are</div> <div> maintained by universities, college or agencies etc. Some files on the ftp can only be accessed by</div> <div> some specific users, to copy these types of files we have to enter their password. For anonymous</div> <div> ftp sites, files are accesses without any password. These file can have any extension like .doc,</div> <div> .jpeg, .txt etc.</div> <div> 7. Understand makeup & structure of URL</div> <div> URL stands for Uniform Resource Locator. A URL can be thought of as the "unique address" of a</div> <div> web page and is sometimes referred to informally as a "web address." URLs are used to write</div> <div> links linking one page to another; for an example, http:// vu.edu.pk.</div> <div> Structure of URL:</div> <div> A URL is made up of several parts.</div> <div> For example http:// vu.edu.pk/cgi-bin/neomail.pl</div> <div> The first part is the protocol, which tells the web browser what sort of server it will be talking to in</div> <div> order to fetch the URL. In this example, the protocol is http.</div> <div> The Second part is its name, which tells about the organization, it is associated like vu.edu.pk.</div> <div> The third part of the example URL is the path at which this particular web page is located on the</div> <div> web server. http:// vu.edu.pk/cgi-bin/neomail.pl</div> <div> 8. Search Engines</div> <div> Search means to find some thing. Search engines are program that searches documents for</div> <div> specified keywords and returns a list of the documents where the keywords were found. Like</div> <div> Google, AltaVista etc</div> <div> Search engines used software called spider to search documents on internet. Documents are</div> <div> sent to search indexing software. Indexing software extract information from documents storing in</div> <div> database, then database is search fro that documents that match to our word search. Search</div> <div> engines assembles web page that shows the result as hyper text link.</div> <div> Virtual University of Pakistan</div> <div> 127</div> <div> Computer Proficiency License (CS001) VU</div> <div> 9. ISP, How to connect internet</div> <div> ISP stands for internet service provider. ISP are always connected to internet, is basically a</div> <div> company or organization which facilitate user by taking some fee. User can connect to internet</div> <div> through ISP’s. Most of ISP’s let you connect to internet through by dialing a local phone number.</div> <div> To connect through internet we need computer, modem and telephone line. steps involved to</div> <div> connect internet are:</div> <div> 1-Connect telephone to computer through modem</div> <div> 2- Run software of internet to connect</div> <div> 3- Enter username, password and ISP number</div> <div> ISDN: stands for integrated service digital network. It is a digital phone line. Data transfer speed</div> <div> is faster than modem. Now a day we can connect to internet by cable, DSL etc.</div> <div> 10. First step with the web browser</div> <div> To open internet explorer:</div> <div> 􀃆 Click on Start < Programs < Internet Explorer or Click from desktop</div> <div> 11. Basic layout and closing a web browser</div> <div> All browser contain menu bar, title bar, tool bar, status bar, scroll bar etc. Basic component of</div> <div> Internet Explorer are title bar, menu bar, status bar, tool bar, scroll bar etc</div> <div> Tool Bar: The most upper bar of window is called title bar. On the right side of title bar there are</div> <div> three buttons to minimize, restore and close internet explorer.</div> <div> Minimize button is used to minimize the window. Restore is use to restore down and close button</div> <div> is use to close the internet explorer</div> <div> Menu bar: There is another bar after the title bar is called menu bar. Menu bar contains different</div> <div> options to use features like file, edit, view etc</div> <div> For using any main menu we just move the mouse cursor over it and it will show submenu.</div> <div> Toolbar: The strip next to menu bar is toolbar. Toolbar is shortcut of menu bar sub options.</div> <div> We also called it standard toolbar because it has buttons to perform important tasks.</div> <div> We can use these options by clicking icons. For knowing the purpose of these icons just take the</div> <div> mouse pointer over there and wait for a while you will see name of icon in form of label. This label</div> <div> is called tool tip text.</div> <div> Address bar: displays URL of open web page.</div> <div> Virtual University of Pakistan</div> <div> 128</div> <div> Computer Proficiency License (CS001) VU</div> <div> Status indicator: is basically a graphical icon which shows that status of internet explorer.</div> <div> Progress Bar: A standard Windows control that displays the percentage of completion of a</div> <div> particular process as a graphical bar</div> <div> Browser pan: The area in middle of screen shows some text, hyperlinks and graphics are called</div> <div> content area or browser pan.</div> <div> To close Browser there are several methods like</div> <div> 1- Click File < Close</div> <div> 2- Press Cross button (X) on title bar</div> <div> 12. How to change home page in web browser</div> <div> When we start internet explorer, the first page we see on the screen is called home page or start</div> <div> page.</div> <div> To change home page:</div> <div> 􀃆 Click Tools < Internet Options < General < Address</div> <div> 13. Display web page in new window</div> <div> We want to open web page without closing other or copy a web page then:</div> <div> 􀃆 Click File < New < Window</div> <div> 14. Stop a web page from downloading</div> <div> In many situations, we stop web page from opening for example when a web page take a lot of</div> <div> time to open, click on wrong link , some portion of web page open and we just stop for further</div> <div> processing.</div> <div> We can stop a web page either of two ways:</div> <div> 1- Click View < Stop</div> <div> 2- Click on Stop button</div> <div> 15. Refresh a web page</div> <div> Refresh means to view web page with latest changes. Using this option we do not have to enter</div> <div> URL in address bar again.</div> <div> We can refresh a page by three ways:</div> <div> 1- Press F5 key</div> <div> 2- Refresh button</div> <div> 3- Click View < Refresh</div> <div> 16. Display previously visited sites</div> <div> When we visit some sites in browser, the browser keep its address of sites which we opened</div> <div> before. Browser saves these sites in history.</div> <div> Virtual University of Pakistan</div> <div> 129</div> <div> Computer Proficiency License (CS001) VU</div> <div> To view history:</div> <div> 􀃆 Press Ctrl+H or Click Tool < History or History button</div> <div> 17. Changing number of days in history list</div> <div> We can set number of days that our history</div> <div> should be kept. To change history days:</div> <div> 􀃆Click Tools < Internet Options</div> <div> This dialogue box will open.</div> <div> Select history section to change days.</div> <div> 18. Deleting single entry, clear list</div> <div> of history</div> <div> It is possible to delete history item or history</div> <div> list.</div> <div> To delete single item:</div> <div> 1- Right Click on Item</div> <div> 2- Select delete</div> <div> To delete list:</div> <div> 1- Click Tools < Internet Options</div> <div> 2- Select History section to delete history</div> <div> 19. Summary:</div> <div> In this lesson we have learnt:</div> <div> 􀁸 Difference between internet and www</div> <div> 􀁸 What is webpage, web browser and website?</div> <div> 􀁸 What is meaning of search engine, ISP, FTP, HTTP and URL?</div> <div> 􀁸 How to open and close a web browser?</div> <div> 􀁸 How to change home page and open a web page in new window?</div> <div> 􀁸 What is the purpose of refresh, stop and history in the web page?</div> <div> 20. Exercise</div> <div> In the coming exercise review your Internet skills to start a browser, open any web page and</div> <div> close a browser</div> <div> Task 1:</div> <div> Starting browser:</div> <div> Start computer and Click on Launch internet explorer browser button on Quick Launch</div> <div> toolbar. If necessary click connect to dial up your ISP.</div> <div> Task 2:</div> <div> View a Web Page :</div> <div> Virtual University of Pakistan</div> <div> 130</div> <div> Computer Proficiency License (CS001) VU</div> <div> First of all connect internet and start browser. In address bar type web page address and</div> <div> click Go or press Enter. Another way is t click the address bar drop down arrow and</div> <div> selects a web page address you've opened in the current session.</div> <div> Task 3:</div> <div> Enter an Address using Auto complete :</div> <div> In the browser begin to type an address that you have recently entered. Auto complete</div> <div> remembers previously entered addresses and tries to complete the address for you.</div> <div> Task 4:</div> <div> Browse Folders and Open files from the Address bar:</div> <div> Type location of hard disk you want to open in the address bar like C:\ or d:\ or e:\. To</div> <div> open any folder of drive types like c:\ my documents etc. Then click Go on the address</div> <div> bar or press Enter. Menus and toolbar change to the ones used in windows explorer. If</div> <div> you want click Views button on toolbar and select the view option you want to use.</div> <div> Virtual University of Pakistan</div> <div> 131</div> <div> Computer Proficiency License (CS001) VU</div> <div> Computer Proficiency License (CS-001)</div> <div> Lecture 41</div> <div> Web Navigation</div> <div> 1. Objectives</div> <div> The objective of this lecture is to provide information about:</div> <div> 􀁸 How to go to any URL?</div> <div> 􀁸 How to activate a hyperlink/image link?</div> <div> 􀁸 How to move backward and forward in visited websites?</div> <div> 􀁸 How to place a bookmark on web page and how to view it?</div> <div> 􀁸 How to create a book mark folder and add web page in it?</div> <div> 􀁸 How to delete a book mark?</div> <div> 2. Go to a URL</div> <div> To visit any website, we should know its URL, URL is typed in</div> <div> address bar of browser.</div> <div> There are several ways to open a web page:</div> <div> 1-write URL in address bar</div> <div> 2-Click File < Open</div> <div> This will open a dialogue box, enter desired URL in it and</div> <div> press ok.</div> <div> 3- Press CTRL+O</div> <div> 3. Navigating backward and forward in a web page</div> <div> We can move backward and forward in any website.</div> <div> To move backward:</div> <div> 􀃆 Click Backward button</div> <div> To move forward:</div> <div> 􀃆 Click forward button</div> <div> To move home page:</div> <div> 􀃆 Click Home button</div> <div> We can also move to visited web pages by clicking View < Go < “site name”</div> <div> We can move backward and forward using key board e.g. ALT+LEFT and ALT+RIGHT</div> <div> 4. Activate a hyperlink</div> <div> When we click with mouse on hyper link it is activated means it moves you to next page you click.</div> <div> Some links bring to download a file, broadcast TV or radio.</div> <div> A web page can have three types of links:</div> <div> 1- Image maps links</div> <div> 2- Text links</div> <div> Virtual University of Pakistan</div> <div> 132</div> <div> Computer Proficiency License (CS001) VU</div> <div> 3 – Picture links</div> <div> Some links are opened in same window or some are in other window.</div> <div> To open link in other window:</div> <div> 􀃆 Right click on link</div> <div> 􀃆 Select open in new window</div> <div> 5. Book mark a web page</div> <div> When we visit some site and we like it, we can save it. For saving any site it mean we are making</div> <div> bookmark means we are putting mark on this site that we can open it again. We can make list of</div> <div> those sites which we like, some browser say it Book mark and some browser say it favorite.</div> <div> To put site in favorite, we can have several methods:</div> <div> 1- Click Favorite button from toolbar</div> <div> 2- Click on Favorite < Add to favorites</div> <div> 6. creating a book mark folder and add page in it</div> <div> When list of favorites grow long, we can make it short by</div> <div> making folder and also we can organize them.</div> <div> To organize:</div> <div> 1-Click on Favorite < Organize Favorite</div> <div> A dialogue box will open, Click on New Folder.</div> <div> This will create a folder.</div> <div> To add page in this folder:</div> <div> 1-Click Favorite < Add to Favorite</div> <div> A dialogue box will open.</div> <div> 2- Select Folder from Create in option.</div> <div> 3- Add page in it.</div> <div> 7. Delete a book mark</div> <div> We can delete web pages or folders from favorites list.</div> <div> To delete folder:</div> <div> 􀃆Click on favorite < organize favorites</div> <div> 􀃆Select Folder / page</div> <div> 􀃆 Select delete button to delete folder.</div> <div> 8. Display book marked page on toolbar</div> <div> To display favorites in tool bar as shortcut:</div> <div> 􀃆Click View < Toolbar < Links</div> <div> 9 Viewing favorite list on screen</div> <div> We can also see favorites item on the left side of screen.</div> <div> To view on left side of screen:</div> <div> 􀃆Click on Favorites button from toolbar.</div> <div> Virtual University of Pakistan</div> <div> 133</div> <div> Computer Proficiency License (CS001) VU</div> <div> 10. Summary:</div> <div> In this lesson we have learnt:</div> <div> 􀁸 How to go to any URL?</div> <div> 􀁸 How to activate a hyperlink/image link?</div> <div> 􀁸 How to move backward and forward in visited websites?</div> <div> 􀁸 How to place a bookmark on web page and how to view it?</div> <div> 􀁸 How to create a book mark folder and add web page in it?</div> <div> 􀁸 How to delete a book mark?</div> <div> 11. Exercise</div> <div> In the coming exercise you will learn how to retrace your steps and return to a web page. Also</div> <div> how to save your favorite web pages list separately</div> <div> Task 1:</div> <div> Move back in a browser :</div> <div> In a browser you can move to previous web page by clicking on Back icon on toolbar, by</div> <div> choosing Back from go menu within view menu, by pressing Alt + Left arrow of keyboard</div> <div> or pressing right mouse button and selecting back option</div> <div> Task 2:</div> <div> Create a favorite list :</div> <div> To add a web page in favorite first of all opens the desired web page in browser. Then</div> <div> right click anywhere in the background of a web page. Click Add to favorites on the</div> <div> shortcut menu. Type name for the site in dialog box Name section. If you want, click</div> <div> Create in to add the site to a folder within the favorite folders</div> <div> Task 3:</div> <div> Move a favorite to a folder :</div> <div> In the browser click favorite menu and then click organize favorites. Click the favorite you</div> <div> want to move to another folder. Click Move to folder. Click the folder where you want to</div> <div> move the favorite. Click Ok When you're done, click Close</div> <div> Task 4:</div> <div> View your hard disk and add a folder to your list of folders :</div> <div> Display contents of your hard disk by typing c:\ in address bar and then press enter. Then</div> <div> open view menu and move mouse pointer to explorer bar and select favorites to display</div> <div> favorite list in left pane. Drag a folder from right pane to favorite’s pane. Release your</div> <div> mouse button when folder icon is positioned correctly within favorite list. When you're</div> <div> done click close button.</div> <div> Virtual University of Pakistan</div> <div> 134</div> <div> Computer Proficiency License (CS001) VU</div> <div> Task 5:</div> <div> Setup a website for offline viewing :</div> <div> Open the website you want to add. Click favorite menu and click Add to favorite. Click to</div> <div> select the make available offline check box. Then click customize option and Next to</div> <div> configure your page for offline viewing. Click Yes option button to allow viewing of entire</div> <div> web site. Click Next to continue. Choose synchronization schedule option you want and</div> <div> then click Next to continue. Then if web site requires user authentication enter your user</div> <div> name and password and click finish. Finally choose folder and then click ok.</div> <div> Virtual University of Pakistan</div> <div> 135</div> <div> Computer Proficiency License (CS001) VU</div> <div> Computer Proficiency License (CS-001)</div> <div> Lecture 42</div> <div> Search Engines</div> <div> 1. Objectives</div> <div> The objective of this lecture is to provide information about:</div> <div> 􀁸 What are search engines and how to select a search engine?</div> <div> 􀁸 How to search a specific in formation with the help of keyword?</div> <div> 􀁸 How to use selection criteria in a search?</div> <div> 􀁸 How to copy image text or URL from a web page to the document?</div> <div> 􀁸 How to set page size, page orientation or margins in a web page?</div> <div> 􀁸 How to print web page or specific web pages or selected text etc?</div> <div> 2. Search Engines</div> <div> World wide web contain million of web pages that its difficult to tell their exact figure, so to find out</div> <div> required information is possible through search engines. Search engines help us to find</div> <div> information on the web and store the information about web pages. It usually search web pages</div> <div> according to any phrase or keyword. Search engines used software of Spider, it is called spider</div> <div> because spider visits many websites in parallel at the same time and also visit different web</div> <div> servers. When the Spider search Web server it make central repository to save related websites</div> <div> URLS’s. This repository of web server is called database or index. After specific intervals, spider</div> <div> store new and updated websites URLS’s in database.</div> <div> 3. How to use any search engine</div> <div> There are many search engines on net like Google, AltaVista and Ask etc</div> <div> To search any website:</div> <div> 􀃆 Write keyword in entry box</div> <div> Search Specific site:</div> <div> 􀃆 Write keyword in double quotations.</div> <div> When we search any web site, relevant websites are on front page.</div> <div> 4. Combine selection criteria in search</div> <div> With simple search, we can get variety of results. We can refine and narrow these results.</div> <div> To use selection criteria:</div> <div> 􀃆 Click on Advanced Search options.</div> <div> 􀃆 Use Boolean operators to search combine words.</div> <div> We ca also search Title, URL and Domain search of any website.</div> <div> 5. Different search engines</div> <div> AltaVista: is the most popular and biggest search engine. Its URL is www.altavista.com . We can</div> <div> use Boolean operators, domain search, title search and URL search. It is very useful engine for</div> <div> complicated search.</div> <div> Virtual University of Pakistan</div> <div> 136</div> <div> Computer Proficiency License (CS001) VU</div> <div> Google: Google gives most relevant results. We can perform simple as well as advanced search.</div> <div> Its URL is www.google.com .</div> <div> Excite: It is most comprehensive search engine. Its URL is www.excite.com .It has large</div> <div> database approximately 10 million sites can be stored.</div> <div> Lycos: It is also a comprehensive search engine. Its URL is www.lycos.com . It can search</div> <div> picture, city guides and road maps easily.</div> <div> Yahoo: it finds information on web quickly. It is better to use yahoo when your search term is</div> <div> large because yahoo add any website in database after great search.</div> <div> HotBOt and Lycos database is bigger than yahoo and search long terms is possible efficiently.</div> <div> There are some other search engines like WebCrawler, open text and galaxy.</div> <div> 6. Copy a text from a web page to a document</div> <div> Duplicate means to copy same data on different location. We can copy or duplicate any text or</div> <div> image data.</div> <div> To copy Data:</div> <div> 1- Select data</div> <div> 2- Click Edit < Copy or press Ctrl+C</div> <div> To paste Data:</div> <div> 1- Select target location</div> <div> 2- Click Edit < Paste or press Ctrl+V</div> <div> 7. Copy image from web page to a document</div> <div> To copy image:</div> <div> 3- Select image</div> <div> 4- Click Edit < Copy or press Ctrl+C</div> <div> To paste image:</div> <div> 3- Select target location</div> <div> 4- Click Edit < Paste or press Ctrl+V</div> <div> 8. Copy URL from web page to a document</div> <div> We can also copy URL from browser to a document.</div> <div> To copy URL:</div> <div> 5- Select URL from browser</div> <div> 6- Click Edit < Copy or press Ctrl+C</div> <div> To paste URL:</div> <div> 5- Select target location</div> <div> 6- Click Edit < Paste or press Ctrl+V</div> <div> 9. Save a web page on hard disk</div> <div> We can save a web page on hard disk. We can open web page data without connecting internet.</div> <div> To save a web page on hard disk:</div> <div> 1-Click File < Save As</div> <div> 2- Select target location on disk to save</div> <div> Virtual University of Pakistan</div> <div> 137</div> <div> Computer Proficiency License (CS001) VU</div> <div> 10. Save a graphic</div> <div> We can save a graphic as file.</div> <div> To save graphic:</div> <div> 1- Right Click on graphic</div> <div> 2-Select Save Picture As option</div> <div> 3- Select target location and Enter Name of graphic</div> <div> 11. Download text file, image</div> <div> Downloading is process of transferring file from remote computer to user computer.</div> <div> To download a file:</div> <div> 1- Select File</div> <div> 2- Right Click on file</div> <div> 3- Select Save Target As</div> <div> You can also save an image in the same way as file.</div> <div> 12. Web page orientation, margins, header, footer</div> <div> Web page may be wider than paper, so some text could be wrap. First save page to hard disk</div> <div> than take printout. We cam also use color printer to take colored printing.</div> <div> To set a web page orientation for printing:</div> <div> 1- Click File < Page Setup</div> <div> 2- Set Header and footer</div> <div> 3- Set page orientation</div> <div> 14. Printing web page</div> <div> To print a web page:</div> <div> 􀃆Click File < Print</div> <div> 15. Summary:</div> <div> In this lesson we have learnt:</div> <div> 􀁸 What are search engines and how to select a search engine?</div> <div> 􀁸 How to search a specific in formation with the help of keyword?</div> <div> 􀁸 How to use selection criteria in a search?</div> <div> 􀁸 How to copy image text or URL from a web page to the document?</div> <div> 􀁸 How to set page size, page orientation or margins in a web page?</div> <div> 􀁸 How to print web page or specific web pages or selected text etc?</div> <div> 16. Exercise</div> <div> In coming exercise you will learn how to search from a list of search engines for web sites that</div> <div> match your criteria and also learn how to print web pages</div> <div> Task 1:</div> <div> Search the Internet using the search button :</div> <div> Open the browser. Click search button on standard toolbar. Internet explorer chooses a</div> <div> search engine at random. Type the information you want to use for the search. Click the</div> <div> search, find or seek button as each search provider label its search button differently. If</div> <div> Virtual University of Pakistan</div> <div> 138</div> <div> Computer Proficiency License (CS001) VU</div> <div> you don't find the web site you want click the next button. To perform a new search, click</div> <div> the new button under the search heading on top. Finally click cross button to right of</div> <div> search heading or click search button on toolbar.</div> <div> Task 2:</div> <div> Download a file from a public ftp site :</div> <div> In address bar type the URL for public ftp site. If site offers it, double click the link to the</div> <div> Pub directories to display the list of files you can download. Right click the link for the file</div> <div> you want to down load, and then click copy to folder. Select the folder in which you want</div> <div> to save the file. Click Ok.</div> <div> Task 3:</div> <div> Create a style sheet :</div> <div> Open the web page you want to use as style sheet. Click tools menu and then click</div> <div> internet explorer. In general tab, click colors. Select colors to be used for text and</div> <div> background and for visited and unvisited links. Then click ok and click file menu, select</div> <div> save as to save web page to your local disk. Type file name and click webpage, html only</div> <div> from save as type drop down arrow. Finally, click “save”.</div> <div> Task 4:</div> <div> Print current page :</div> <div> Open desired page to print. First open file menu and click page setup option. From dialog</div> <div> box click size drop down arrow and select a paper size. Enter header like &w for window</div> <div> title and footer &u to print page address. Click portrait or landscape option. After clicking</div> <div> ok again open file menu and choose print. Set current page in this dialog box and finally</div> <div> click ok to print it.</div> <div> Virtual University of Pakistan</div> <div> 139</div> <div> Computer Proficiency License (CS001) VU</div> <div> Computer Proficiency License (CS-001)</div> <div> Lecture 43</div> <div> Electronic Mail</div> <div> 1. Objectives</div> <div> The objective of this lecture is to provide information about:</div> <div> 􀁸 What is email and what is structure of email address?</div> <div> 􀁸 How to open and close email application?</div> <div> 􀁸 How to open email inbox for specific user?</div> <div> 􀁸 How to open several mail messages at a time?</div> <div> 􀁸 How to close mail messages?</div> <div> 2. Concepts</div> <div> In ancient times, people use letter as way of communication and they send it through post offices</div> <div> but it took long time to reach destination. In modern days way of communication have been</div> <div> changed because of internet and new ways were adopted to send information quickly e.g.</div> <div> telegram, fax, telephone and email etc.</div> <div> Email is abbreviation of electronic mail. With the help of email we can exchange information</div> <div> around the world. Only difference between email and other letter is that email is written through</div> <div> key board and sends through internet while letter is written by hand and send through postoffice.</div> <div> It is the fastest way of communication than letters and it can be sending at any time when it is</div> <div> convenient.</div> <div> When we send email messages from one computer to another then email client SMTP and POP3</div> <div> are used. Email clients are those programs used for writing, sending, receiving and displaying</div> <div> email messages like yahoo mail, hotmail, and outlook express.</div> <div> SMTP: is simple mail transfer protocol and used to send and receive email messages.</div> <div> POP3: is post office protocol and used to receive email messages. Email client interacts with</div> <div> POP3 server to discover and download new email messages.</div> <div> 3. How email works</div> <div> First you compose a mail and send it. Message is sent to your internet service provider’s email</div> <div> server. Message is then sorted in recipient’s electronic mail box. To read message, log on to</div> <div> email server and retrieve message. To read message, first you have to enter password.</div> <div> 4. Email system using email client SMTP and POP3</div> <div> Steps to send email messages:</div> <div> 1- Message is prepared using email client.</div> <div> 2- Email client sent it to SMTP server( if receiver is local then mail goes to POP3)</div> <div> 3- Receiver computer picks it at his/her computer</div> <div> 4- If mail is sent to SMTP than SMTP server send it to local computers POP3 and receive it</div> <div> 5. Understanding the structure of email address</div> <div> Whenever we send any mail we should know the address of recipient.</div> <div> Virtual University of Pakistan</div> <div> 140</div> <div> Computer Proficiency License (CS001) VU</div> <div> Structure of Email address: Email address consists of two parts separated by “@ “symbol.</div> <div> First part identifies the name of user account and second part contains URL of persons account</div> <div> on internet like awais@yahoo.com</div> <div> 6. Open and close email application</div> <div> To open Email client Out Look Express:</div> <div> 􀃆 Click Start < All Programs < Microsoft Office < Microsoft Out Look Express</div> <div> To Close Out Look Express:</div> <div> 􀃆 Click File < Exit</div> <div> 7. Layout of email application</div> <div> Any email program contains components to write, send and receive email messages.</div> <div> 8. Create an email account</div> <div> To use an email program its important to have email</div> <div> account.</div> <div> To create an account on yahoo:</div> <div> 1- Type www.mail.yahoo.com in browser</div> <div> 2- Click on Sign Up</div> <div> 3-Fill the Form by entering user name and password and more</div> <div> 9. Open a mail box for specific user</div> <div> You can open email account which you have created before by user name and password. Enter</div> <div> User name and password and Click Sign In.</div> <div> 10. Open one and several messages</div> <div> When ever we got any email, it goes to our inbox .we can read and write mail here.</div> <div> To read mail:</div> <div> 􀃆 Click on Inbox</div> <div> 􀃆 Click on ay message to read</div> <div> To compose a mail:</div> <div> 􀃆 Click on Compose</div> <div> 􀃆 Write and send mail</div> <div> 11. Close a mail message</div> <div> To close a mail message:</div> <div> 􀃆 Click on Close (X) button of window</div> <div> 10-Summary:</div> <div> In this lesson we have learnt:</div> <div> 􀁸 What is email and what is structure of email address</div> <div> Virtual University of Pakistan</div> <div> 141</div> <div> Computer Proficiency License (CS001) VU</div> <div> 􀁸 How to open and close email application?</div> <div> 􀁸 How to open email inbox for specific user?</div> <div> 􀁸 How to open several mail messages at a time?</div> <div> 􀁸 How to close mail messages?</div> <div> 11-Exercise</div> <div> In the coming exercise you can improve the appearance and usefulness of your printouts by</div> <div> changing the page margin, specifying a target print area, adding headers and footers. You will</div> <div> also learn how to take printout of your worksheets</div> <div> Task 1:</div> <div> Select a print range :</div> <div> In monthly expenses worksheet, select range from A1 to B6. Open file menu and point to</div> <div> print area and select click on Set Print Area on submenu. Click Print preview on toolbar to</div> <div> view the print range. Click on close button on print preview toolbar. To clear print range</div> <div> open file menu. Point to print area and click on Clear Print Area on submenu.</div> <div> Task 2:</div> <div> Insert and Remove Page breaks :</div> <div> With monthly expenses still open, to print items name on one page and expenses on</div> <div> other page select column B and C. Open Insert menu and select Page break. A dotted</div> <div> line is shown after column A. Click on print preview icon and you will see the names of</div> <div> items on page 1. Click on Next button on toolbar to view the next page. You will see</div> <div> expenses on the next page. Click close button on toolbar and open Insert menu. Choose</div> <div> Remove page break from the menu to clear the page breaks.</div> <div> Task 3:</div> <div> Setting orientation, Margins and center worksheet on a page :</div> <div> In monthly expenses worksheet, open file menu and click page setup option. Click on</div> <div> page tab and choose landscape from orientation section. Set print quality to highest</div> <div> option. Click Margin tab and set top margin and bottom margin to 1.25. Click horizontally</div> <div> and vertically options in center on page section of page setup dialog box. Click print</div> <div> preview button.</div> <div> Task.4:</div> <div> Create a header and footer :</div> <div> Open monthly expenses Worksheet and select sheet1 and sheet 2 tabs. Open view</div> <div> menu and choose the option header and footer. Click on customer header option and</div> <div> then click in center section. Click sheet icon from toolbar which is third last icon on</div> <div> toolbar. Then press ok button and then click on customer footer. Click in center section.</div> <div> Type page and click on # icon in toolbar, then type “of” and click on plus sign in toolbar.</div> <div> Click ok button and then click on print preview button. Sheet1 is shown on top and page 1</div> <div> at bottom, click on next icon on print preview toolbar and you will see sheet2 on top of</div> <div> page.</div> <div> Task.5:</div> <div> Applying and printing formula used in Cells :</div> <div> Open any spreadsheet in which formulas are used. Click on tools menu and then on</div> <div> options. In dialog box, click view tab and then select formula option in windows options</div> <div> section. A checkmark will appear in front of formula and finally click ok button. You will</div> <div> see formula within the cells Click file menu and select page setup Click on landscape</div> <div> option in orientation section and fit in scaling section. Click print preview button, then click</div> <div> zoom button to adjust the view. Click print button and ok. Finally press Control + ~ keys</div> <div> to deselect formula option.</div> <div> Virtual University of Pakistan</div> <div> 142</div> <div> Computer Proficiency License (CS001) VU</div> <div> Task.6:</div> <div> Previewing and printing multiple sheets :</div> <div> Open a spreadsheet in which sheet 1, sheet 2 and sheet 3 contains some data. To print</div> <div> all three sheets at once first click on sheet 1 tab. Hold the shift key and click on sheet 2</div> <div> and sheet 3 tab. Click print preview button. Click zoom button to magnify image. Click</div> <div> next button on toolbar two times to cycle through three selected sheets. Click print button</div> <div> in print preview window and then click ok.</div> <div> Task.7:</div> <div> Hide some columns and rows in WS :</div> <div> Open an already created spreadsheet. Since you want to print a report that does not</div> <div> include column C. Right click on column C heading and click hide. Click on print preview,</div> <div> column C is not shown so print the worksheet. To again display the hidden column C first</div> <div> select Col B and D. Right click on the selection and click unhide. Column C will be shown</div> <div> Virtual University of Pakistan</div> <div> 143</div> <div> Computer Proficiency License (CS001) VU</div> <div> Computer Proficiency License (CS-001)</div> <div> Lecture 44</div> <div> Messaging</div> <div> 1. Objectives</div> <div> The objective of this lecture is to provide information about:</div> <div> 􀁸 What is a flag? How to flag a mail message and remove a flag message?</div> <div> 􀁸 How to mark a mail message as read or unread?</div> <div> 􀁸 How to open and save a file attachment in a local hard disk?</div> <div> 􀁸 How to create a new message and how to reply to more than one person?</div> <div> 􀁸 How to attach email with a message?</div> <div> 􀁸 How to copy, move and forward message?</div> <div> 2-Flag mail message</div> <div> After reading the mail you have two options. Some mails are replied urgently and some are</div> <div> replied late. It is possible we forgot to reply some urgent messages, so for this reason flag feature</div> <div> is introduced.</div> <div> To apply flag on the message of inbox folder:</div> <div> 1- select a message</div> <div> 2- Click On Actions < Follow Up < Red Flag</div> <div> To remove flag:</div> <div> 1- Right click on message</div> <div> 2- Select Clear Flag Option</div> <div> 3- Mark message as read/unread</div> <div> Messages which we have read called read messages and messages which we have not read are</div> <div> called unread. It is possible top make read messages as unread and unread messages as read.</div> <div> To make a message as read:</div> <div> 1- Select message</div> <div> 2- Right click on message</div> <div> 3- Select Mark as read</div> <div> If we marked a folder then all its messages are marked as read /unread</div> <div> 4- Open and save file attachment on hard disk</div> <div> Attachment is a file which is attached with mail and we can download this attached file. We can</div> <div> also attach data file with mail. We can also attach other files like audio, graphics etc</div> <div> To download a file:</div> <div> 1- open message</div> <div> 2- select attach file</div> <div> 3- right click on file</div> <div> 4- Select Save Target As(download on hard disk) or Select Open (to see in same</div> <div> application)</div> <div> 5- Use Reply/ Reply All</div> <div> Virtual University of Pakistan</div> <div> 144</div> <div> Computer Proficiency License (CS001) VU</div> <div> Reply means answering to one person but reply all mean answering multiple persons.</div> <div> To reply a message:</div> <div> 1- open message to reply</div> <div> 2- Select Reply Button</div> <div> 3- Than type/attach message and send</div> <div> 6- Reply with or without original message</div> <div> It is possible we send message with original message or</div> <div> erase that message.</div> <div> To send message without original message:</div> <div> 1- Click Tools < Options ( it will open a dialogue box)</div> <div> 2- Press Email Options button from email section</div> <div> 3- Select On Replies and forward section for adding</div> <div> and removing original message</div> <div> 7- Add a contact in list</div> <div> You can make a record of your email addresses.</div> <div> To add a contact:</div> <div> 1- Click on contact folder.</div> <div> 2- Click on new contact</div> <div> 3- Add related info</div> <div> 8- Create a new message</div> <div> To write a mail:</div> <div> 1-Click on New < Mail Messages</div> <div> 2- Write mail and send.</div> <div> 9- Insert a mail address in To field</div> <div> Whenever we send an email we insert address in To box. It is also possible we don’t write email</div> <div> address but add it from contact list.</div> <div> To add address from contact list:</div> <div> 􀃆Click on TO field</div> <div> 10- Carbon copy (CC), Blind Carbon Copy (BCC)</div> <div> CC: is abbreviation of carbon copy and from this option we can send email to more than one</div> <div> email address.</div> <div> BCC: is abbreviation of blind carbon copy and from this option we can send email copy to more</div> <div> than one person but the message will be secret message means email address of BCC is not</div> <div> shown to TO and CC addresses.</div> <div> 11- Use spells checking in email</div> <div> Email message window works same as word processor. Like word we can also use spell check in</div> <div> email messages.</div> <div> To spell check:</div> <div> 1-Select word</div> <div> Virtual University of Pakistan</div> <div> 145</div> <div> Computer Proficiency License (CS001) VU</div> <div> 2-Click on Tools < Spelling and Grammar</div> <div> 12- Forward message</div> <div> We can forward same message.</div> <div> To forward email message:</div> <div> 􀃆 Click on Forward button</div> <div> 13- Cut and copy text within or between messages</div> <div> We can copy text between messages.</div> <div> To copy:</div> <div> 1-Select text</div> <div> 2- Click Edit < Copy or Press Ctrl+C</div> <div> To paste:</div> <div> 1- Select target location</div> <div> 2- Click Edit < Paste or Press CTRL+V</div> <div> 14- Attach a file to a message</div> <div> We can attach a file with our email message and any type of file can be attached.</div> <div> To attach a file:</div> <div> 􀃆 Click on Attach button</div> <div> 15-Summary:</div> <div> In this lesson we have learnt:</div> <div> 􀁸 What is a flag? How to flag a mail message and remove a flag message?</div> <div> 􀁸 How to mark a mail message as read or unread?</div> <div> 􀁸 How to open and save a file attachment in a local hard disk?</div> <div> 􀁸 How to create a new message and how to reply to more than one person?</div> <div> 􀁸 How to attach email with a message?</div> <div> 􀁸 How to copy, move and forward message?</div> <div> 16-Exercise</div> <div> In the coming exercise you can improve the appearance and usefulness of your printouts by</div> <div> changing the page margin, specifying a target print area, adding headers and footers. You will</div> <div> also learn how to take printout of your worksheets</div> <div> Task 1:</div> <div> Select a print range :</div> <div> In monthly expenses worksheet, select range from A1 to B6. Open file menu and point to</div> <div> print area and select click on Set Print Area on submenu. Click Print preview on toolbar to</div> <div> view the print range. Click on close button on print preview toolbar. To clear print range</div> <div> open file menu. Point to print area and click on Clear Print Area on submenu.</div> <div> Task 2:</div> <div> Insert and Remove Page breaks :</div> <div> Virtual University of Pakistan</div> <div> 146</div> <div> Computer Proficiency License (CS001) VU</div> <div> With monthly expenses still open, to print items name on one page and expenses on</div> <div> other page select column B and C. Open Insert menu and select Page break. A dotted</div> <div> line is shown after column A. Click on print preview icon and you will see the names of</div> <div> items on page 1. Click on Next button on toolbar to view the next page. You will see</div> <div> expenses on the next page. Click close button on toolbar and open Insert menu. Choose</div> <div> Remove page break from the menu to clear the page breaks.</div> <div> Task 3:</div> <div> Setting orientation, Margins and center worksheet on a page :</div> <div> In monthly expenses worksheet, open file menu and click page setup option. Click on</div> <div> page tab and choose landscape from orientation section. Set print quality to highest</div> <div> option. Click Margin tab and set top margin and bottom margin to 1.25. Click horizontally</div> <div> and vertically options in center on page section of page setup dialog box. Click print</div> <div> preview button.</div> <div> Task.4:</div> <div> Create a header and footer :</div> <div> Open monthly expenses Worksheet and select sheet1 and sheet 2 tabs. Open view</div> <div> menu and choose the option header and footer. Click on customer header option and</div> <div> then click in center section. Click sheet icon from toolbar which is third last icon on</div> <div> toolbar. Then press ok button and then click on customer footer. Click in center section.</div> <div> Type page and click on # icon in toolbar, then type “of” and click on plus sign in toolbar.</div> <div> Click ok button and then click on print preview button. Sheet1 is shown on top and page 1</div> <div> at bottom, click on next icon on print preview toolbar and you will see sheet2 on top of</div> <div> page.</div> <div> Task.5:</div> <div> Applying and printing formula used in Cells :</div> <div> Open any spreadsheet in which formulas are used. Click on tools menu and then on</div> <div> options. In dialog box, click view tab and then select formula option in windows options</div> <div> section. A checkmark will appear in front of formula and finally click ok button. You will</div> <div> see formula within the cells Click file menu and select page setup Click on landscape</div> <div> option in orientation section and fit in scaling section. Click print preview button, then click</div> <div> zoom button to adjust the view. Click print button and ok. Finally press Control + ~ keys</div> <div> to deselect formula option.</div> <div> Task.6:</div> <div> Previewing and printing multiple sheets :</div> <div> Open a spreadsheet in which sheet 1, sheet 2 and sheet 3 contains some data. To print</div> <div> all three sheets at once first click on sheet 1 tab. Hold the shift key and click on sheet 2</div> <div> and sheet 3 tab. Click print preview button. Click zoom button to magnify image. Click</div> <div> next button on toolbar two times to cycle through three selected sheets. Click print button</div> <div> in print preview window and then click ok.</div> <div> Task.7:</div> <div> Hide some columns and rows in WS :</div> <div> Open an already created spreadsheet. Since you want to print a report that does not</div> <div> include column C. Right click on column C heading and click hide. Click on print preview,</div> <div> column C is not shown so print the worksheet. To again display the hidden column C first</div> <div> select Col B and D. Right click on the selection and click unhide. Column C will be shown</div> <div> Virtual University of Pakistan</div> <div> 147</div> <div> Computer Proficiency License (CS001) VU</div> <div> Computer Proficiency License (CS-001)</div> <div> Lecture 45</div> <div> Mail Management</div> <div> 1- Objectives</div> <div> The objective of this lecture is to provide information about:</div> <div> 􀁸 How to create a new address list and add or delete mail address in it?</div> <div> 􀁸 How to search a message by subject and a sender and mail contents?</div> <div> 􀁸 How to create a new folder and how to move messages to a new folder?</div> <div> 􀁸 How to sort and delete the messages?</div> <div> 􀁸 How to undelete the deleted messages and how to empty delete item folder?</div> <div> 2- Managing email</div> <div> When we receive many mail messages, it results into over abundance of email messages in</div> <div> inbox or sent email folder. As a good practice, these should be managed. To manage your email</div> <div> there can follow options.</div> <div> 1. Create new folders for messages</div> <div> 2. Save your messages in hard disk</div> <div> 3. Delete unwanted or read messages</div> <div> 3- Create an address book</div> <div> In real life, you can use diary to record the name and address of your friend. It is good to use</div> <div> diary to remember the details of your friends. It is difficult to remember to remember many email</div> <div> addresses. Email program makes life easy by providing a facility to record email ids of all</div> <div> contacts in address book. You can save name, phone number, email ids and some related</div> <div> information in an address book. Address book works like a diary.</div> <div> 4- Add a mail address to address list</div> <div> 1. Click on the contact tab in the right side of the MS Outlook.</div> <div> 2. Go to File < New < Contact</div> <div> 3. A new window will open. Enter name and email id of the contact and click on Save and</div> <div> Close button below the menu bar.</div> <div> 5- Delete a mail address to address list</div> <div> The way we have added the contact in address book, we can delete the contact with few clicks.</div> <div> 1. Select the email contact (s) from address book by single click.</div> <div> 2. Click on the Remove button or right click on the contact name and select delete from the</div> <div> drop down menu.</div> <div> 3. Contact(s) will be deleted.</div> <div> 6- Update an address book from incoming mail</div> <div> To save the email id from the inbox</div> <div> 1. Right click on the name of the sender of email in the inbox</div> <div> Virtual University of Pakistan</div> <div> 148</div> <div> Computer Proficiency License (CS001) VU</div> <div> 2. Click on the move to the folder</div> <div> 3. Select contacts from the list</div> <div> 4. Click on the contacts folder to view the newly added contact</div> <div> 7- Search message by sender, subject or mail contacts</div> <div> It is very difficult to search in the lengthy email messages. You can easily search messages in</div> <div> outlook using find option.</div> <div> Go to Tools < Find < Find or press Ctrl+E</div> <div> Select Inbox from the drop down menu of “Search In”</div> <div> In “Look for” we type the word we want to search</div> <div> Click on “Find Now”</div> <div> We can restrict our search to sender</div> <div> name, email subject or email id etc by</div> <div> using advance search option.</div> <div> Go to Tools < Find < Advanced find or</div> <div> press Ctrl + shift + F</div> <div> Enter the words you need to search</div> <div> for and restrict the search to the</div> <div> selected field from the drop down</div> <div> menu.</div> <div> 8- Create a folder</div> <div> It is good to organize messages in</div> <div> different folders. Email program usually save messages</div> <div> in separate folders. You can create as many folders you</div> <div> want.</div> <div> To create a new folder</div> <div> Go to File < New < Folder… or press Ctrl+Shift+E</div> <div> Enter the name of new folder</div> <div> Select the type of content folder will contain and</div> <div> location.</div> <div> 9- Move messages to folder</div> <div> To save a message in a new folder</div> <div> Select the message in the inbox</div> <div> Go to Edit < Move to folder or press Ctrl+Shift+V</div> <div> Select the folder where you want to move the message</div> <div> and click on the Ok button.</div> <div> Virtual University of Pakistan</div> <div> 149</div> <div> Computer Proficiency License (CS001) VU</div> <div> 10- Sort messages</div> <div> We can sort email message by date, subject and sender name. Let us sort these messages by</div> <div> date wise.</div> <div> Open inbox and go to View < Arrange by < Date</div> <div> Using from option we can sort email messages according to sender.</div> <div> Using To option we can we can arrange messages ascending to recipient’s name.</div> <div> We can sort email messages in ascending or descending.</div> <div> 11- Delete a message</div> <div> You can easily remove any message. Right click on the message you want to delete from inbox</div> <div> and select Delete from the menu. Email message will be deleted from inbox right away and sent</div> <div> to folder “Deleted items”.</div> <div> 12- Undelete a message from mail bin</div> <div> You may delete important message. When you delete a message, it is moved from inbox to</div> <div> deleted items folder. Open “Deleted items” folder and right click on the message you want to</div> <div> undelete. Select “Move to folder” option and select Inbox.</div> <div> 13- Empty mail bin</div> <div> Messages you delete are saved in Deleted items folder.</div> <div> To delete one message from the Delete items folder, select the message and click on the cross</div> <div> icon (Delete button)</div> <div> Message will ask for the confirmation for deleting the message. Click Ok to delete this message</div> <div> permanently.</div> <div> To empty the folder, right click on the “Deleted Item” folder and select “Empty Deleted Items”</div> <div> 14-Summary:</div> <div> In this lesson we have learnt:</div> <div> 􀁸 How to create a new address list and add or delete mail address in it?</div> <div> 􀁸 How to search a message by subject and a sender and mail contents?</div> <div> 􀁸 How to create a new folder and how to move messages to a new folder?</div> <div> 􀁸 How to sort and delete the messages?</div> <div> 􀁸 How to undelete the deleted messages and how to empty delete item folder?</div> <div> 15-Exercise</div> <div> In the coming exercise you can improve the appearance and usefulness of your printouts by</div> <div> changing the page margin, specifying a target print area, adding headers and footers. You will</div> <div> also learn how to take printout of your worksheets</div> <div> Task 1:</div> <div> Select a print range :</div> <div> In monthly expenses worksheet, select range from A1 to B6. Open file menu and point to</div> <div> print area and select click on Set Print Area on submenu. Click Print preview on toolbar to</div> <div> view the print range. Click on close button on print preview toolbar. To clear print range</div> <div> open file menu. Point to print area and click on Clear Print Area on submenu.</div> <div> Task 2:</div> <div> Virtual University of Pakistan</div> <div> 150</div> <div> Computer Proficiency License (CS001) VU</div> <div> Insert and Remove Page breaks :</div> <div> With monthly expenses still open, to print items name on one page and expenses on</div> <div> other page select column B and C. Open Insert menu and select Page break. A dotted</div> <div> line is shown after column A. Click on print preview icon and you will see the names of</div> <div> items on page 1. Click on Next button on toolbar to view the next page. You will see</div> <div> expenses on the next page. Click close button on toolbar and open Insert menu. Choose</div> <div> Remove page break from the menu to clear the page breaks.</div> <div> Task 3:</div> <div> Setting orientation, Margins and center worksheet on a page :</div> <div> In monthly expenses worksheet, open file menu and click page setup option. Click on</div> <div> page tab and choose landscape from orientation section. Set print quality to highest</div> <div> option. Click Margin tab and set top margin and bottom margin to 1.25. Click horizontally</div> <div> and vertically options in center on page section of page setup dialog box. Click print</div> <div> preview button.</div> <div> Task.4:</div> <div> Create a header and footer :</div> <div> Open monthly expenses Worksheet and select sheet1 and sheet 2 tabs. Open view</div> <div> menu and choose the option header and footer. Click on customer header option and</div> <div> then click in center section. Click sheet icon from toolbar which is third last icon on</div> <div> toolbar. Then press ok button and then click on customer footer. Click in center section.</div> <div> Type page and click on # icon in toolbar, then type “of” and click on plus sign in toolbar.</div> <div> Click ok button and then click on print preview button. Sheet1 is shown on top and page 1</div> <div> at bottom, click on next icon on print preview toolbar and you will see sheet2 on top of</div> <div> page.</div> <div> Task.5:</div> <div> Applying and printing formula used in Cells :</div> <div> Open any spreadsheet in which formulas are used. Click on tools menu and then on</div> <div> options. In dialog box, click view tab and then select formula option in windows options</div> <div> section. A checkmark will appear in front of formula and finally click ok button. You will</div> <div> see formula within the cells Click file menu and select page setup Click on landscape</div> <div> option in orientation section and fit in scaling section. Click print preview button, then click</div> <div> zoom button to adjust the view. Click print button and ok. Finally press Control + ~ keys</div> <div> to deselect formula option.</div> <div> Task.6:</div> <div> Previewing and printing multiple sheets :</div> <div> Open a spreadsheet in which sheet 1, sheet 2 and sheet 3 contains some data. To print</div> <div> all three sheets at once first click on sheet 1 tab. Hold the shift key and click on sheet 2</div> <div> and sheet 3 tab. Click print preview button. Click zoom button to magnify image. Click</div> <div> next button on toolbar two times to cycle through three selected sheets. Click print button</div> <div> in print preview window and then click ok.</div> <div> Task.7:</div> <div> Hide some columns and rows in WS :</div> <div> Open an already created spreadsheet. Since you want to print a report that does not</div> <div> include column C. Right click on column C heading and click hide. Click on print preview,</div> <div> column C is not shown so print the worksheet. To again display the hidden column C first</div> <div> select Col B and D. Right click on the selection and click unhide. Column C will be shown</div> <div> Virtual University of Pakistan</div> <div> 151</div> </div> <div> <br /></div> <div> <b><span style="font-size: large;"><a href="http://www.genrica.com/vustuff/CS001/CS001_handouts_1_45.pdf" target="_blank">Computer Proficiency License (CPL) CS001  book HANDOUTS in pdf</a></span></b></div>

Computer Proficiency License (CPL) CS001 book HANDOUTS in pdf

Computer Proficiency License (CPL) CS001  book HANDOUTS in pdf Handouts | Lectures | Contents | Books Computer Proficiency License (...

Read more »