Computer Application 2 Use of Packages
Computer Application 2 Use of Packages
Computer Application 2 Use of Packages
(USE OF PACKAGES)
Chapter One
Software
System and Application Software
Types of Application Software
Chapter Two
Module One
Introduction to Windows
Understand Windows XP, Vista and Windows7……………………………
Module Two
Word Process
Microsoft World Process (MS2003, MS XP, MS 2007 and MS2010)
Module Three
Presentation
Microsoft PowerPoint (MS2003, MS XP, MS 2007 and MS2010)
Module Four
Spread Sheets
Microsoft Excel (MS2003, MS XP, MS 2007 and MS2010)
Module Five
Introduction to use of Internet
Browsers
Internet Explorer and any other
Email System
Appendix
Microsoft Applications Shortcuts
Some words and meaning
SOFTWARE
Computer – A computer can be define as a device that works under the control of
programs, automatically accepting, storing and processing data to produce information
that is the result of the processing.
User-written software tailors systems to meet the user's specific needs. User-written
software include spreadsheet templates, word processor macros, scientific simulations,
graphics and animation scripts. Even email filters are a kind of user software. Users
create this software themselves and often overlook how important it is.
Enterprise software addresses the needs of organization processes and data flow,
often in a large distributed environment. (Examples include Financial, Customer
Relationship Management, and Supply Chain Management). Note that
Departmental Software is a sub-type of Enterprise Software with a focus on
smaller organizations or groups within a large organization. (Examples include
Travel Expense Management, and IT Helpdesk)
Enterprise infrastructure software provides common capabilities needed to
support Enterprise Software systems. (Examples include Databases, Email
servers, and Network and Security Management)
Information worker software addresses the needs of individuals to create and
manage information, often for individual projects within a department, in contrast
to enterprise management. Examples include time management, resource
management, documentation tools, analytical, and collaborative. Word
processors, spreadsheets, email and blog clients, personal information system, and
individual media editors may aid in multiple information worker tasks.
Content access software is software used primarily to access content without
editing, but may include software that allows for content editing. Such software
addresses the needs of individuals and groups to consume digital entertainment
and published digital content. (Examples include Media Players, Web Browsers,
Help browsers, and Games)
Educational software is related to Media and Entertainment Software, but has
distinct requirements for delivering evaluations (tests) and tracking progress
through material. It is also related to collaboration software in that many
Educational Software systems include collaborative capabilities.
Simulation software are computer software for simulation of physical or abstract
systems for either research, training or entertainment purposes.
Media development software addresses the needs of individuals who generate
print and electronic media for others to consume, most often in a commercial or
educational setting. This includes Graphic Art software, Desktop Publishing
software, Multimedia Development software, HTML editors, Digital Animation
editors, Digital Audio and Video composition, and many others.
Product engineering software is used in developing hardware and software
products. This includes computer aided design (CAD), computer aided
engineering (CAE), computer language editing and compiling tools, Integrated
Development Environments, and Application Programmer Interfaces.
A software package is a bundle of one or more files that are either necessary for the
execution of a computer program or add to features to a program already installed on one
or more computers. Software packages can either be in a standardised package format to
be installed by a package management system integrated with the operating system, or by
a self-sufficient installer. This latter approach is commonly used by distributors of
commercial, proprietary software, particularly for installation on Microsoft Windows,
A software package can also be describe as a files that contain software, and written in a
particular format that enables the software to be easily installed and removed.
What is a window
A window is an area on your desktop within which all Windows-based programs run.
Windows XP, Vista or Windows7 is an Operation System that is a window based
programs.
Operating systems control the functions performed by a computer. For example, the
operating system on your computer controls the input from the keyboard and mouse to
your computer, the opening and closing of programs, the transfer of information to a
printer, the organization of the files on your computer, and the screen display. To
function, every computer must have an operating system. Windows XP and Windows
Vista is an operating system. Windows XP, Windows Vista or Windows7 comes in
several versions: Home Basic, Home Premium, Business, Ultimate, and Enterprise. The
features available to you depend on the version of Windows XP, Windows Vista or
Windows7 you have. You must note that there is a different between window and
windows operation system.
Control Box The control box provides a menu that enables you to restore, move, size,
minimize, maximize, or close a window.
Border The border separates the window from the desktop. You resize the window by
Title bar The title bar displays the name of the current file and the name of the current
program.
Minimize button Use the Minimize button to temporarily decrease the size of a window or
remove a window from view. While a window is minimized, its title appears
on the taskbar.
Maximize button Click the Maximize button and the window will fill the screen.
Restore button After you maximize a window, if you click the Restore button, the window
will return to its former size.
Close button Click the Close button to exit the window and close the program.
Menu bar The menu bar displays the program menu. You send commands to the
program by using the menu.
Toolbars Toolbars generally display right below the menu, but you can drag them and
display them along any of the window borders. You use the icons on the
toolbars to send commands to the program.
Work area The work area is located in the center of the window. You perform most of
your work in the work area.
Status bar The status bar provides you with information about the status of your
program.
What is a desktop
When you start your computer, the first thing you see is the desktop. The desktop is your
work area. If you are using Windows XP, Vista or Windows7, after you start your
computer the first thing you see is the desktop. The desktop is your work area.
Internet Explorer The Internet Explorer icon launches the Internet Explorer
browser.
The Recycle Bin When you delete an object, Windows XP or Windows Vista sends
it to the Recycle Bin. You can restore objects that are located in
the Recycle Bin or you can permanently delete them.
Shortcut icon Icons with an arrow in the lower left corner are shortcut icons.
Click the icon for quick access to the object they represent
(program, document, printer, and so on).
Program, folder, and Program, folder, and document icons do not have an arrow in the
document icons lower left corner. These icons represent the actual object and
provide direct access to the object. When you delete a program,
folder, or document icon, you are deleting the actual program,
folder, or document.
Sidebar The default placement for the Windows Vista sidebar is along the
right side of your desktop. You can use the sidebar to display
gadgets. Gadgets are small programs with which you can display
a clock, post notes, track stocks, or perform other miscellaneous
tasks.
If you have several windows open at the same time, the window on top is the window
with focus. You can only interact with the window with focus. To change windows, do
one of the following:
In many programs, if the contents of the work area do not fit in the window, scrollbars
will appear. A vertical scrollbar will appear at the right side of the window and a
horizontal scrollbar at the bottom of the window, depending on the fit. The vertical
scrollbar provides a way to move up and down. The horizontal scrollbar provides a way
to move from left to right.
The scroll box indicates where you are in your document. If the scroll box is at the top of
the scrollbar, you are at the top of the document. If the scroll box is in the center of the
scrollbar, you are in the center of the document.
What is an icon
An icon is a graphic image. Icons help you execute commands quickly. Commands tell
the computer what you want the computer to do. To execute a command by using an
icon, click the icon.
What is a menu
Menus provide a way for you to send commands to the computer (tell the computer what
you want the computer to do). When you open a window, menu options are listed from
left to right just below the title bar on the menu bar. When you click a menu item, a drop-
down menu appears. Select the command you want to execute from the drop-down menu.
An ellipsis after a drop-down menu item signifies that there are additional options; if you
select that option, a dialog box will appear.
You can use shortcut keys to execute a command quickly by pressing key combinations
instead of selecting the commands directly from the menu or clicking on an icon. When
you look at a menu, you will notice that most of the options have one letter underlined.
You can select a menu option by holding down the Alt key and pressing the underlined
letter. You can also make Alt-key selections from drop-down menus and dialog boxes.
What is a selection
A selection is a highlighted area on which you can perform a command. For example, if you are using a
word processing program, you can highlight a word and then execute the Underline command to underline
the highlighted word.
To make a selection
Task Action
To make a selection: 1. Left-click where you want to start your selection.
2. Hold down your left mouse button and drag the mouse until you have
highlighted the area you want.
Or
1. Left-click where you want to start your selection.
2. Hold down the Shift key while you use the arrow keys to highlight
the area that you want.
Note: Typing over highlighted text replaces the old text with the new text you type.
Task Action
To create a shortcut to an item located on the Start 1. Click Start. The Start menu will appear.
menu: 2. Locate the item to which you want to create
a shortcut. If the item is located on a
submenu, go to the submenu.
3. Click and drag the item to your desktop.
To create a shortcut to items visible in Windows 1. Open Windows Explorer.
Explorer: 2. Minimize the Windows Explorer window.
3. Locate in Windows Explorer the item to
which you want to create a shortcut.
4. Hold down the right mouse button and drag
the item onto the desktop.
5. Release the right mouse button. A context
menu will appear.
6. Click Create Shortcuts Here.
To turn a Web link into a desktop shortcut, click the link in your browser window
(usually underlined text) and drag it to the desktop. An icon will appear on your desktop.
When you click the icon, your browser will open and you will go directly to the Web
page.
1. Click the icon that precedes the URL on the address bar.
2. Drag the icon to your desk top. Vista creates the shortcut.
Now, when you click on the shortcut, the Web page will open.
The name of the desktop shortcut displays below its icon. For example, if you create a
shortcut to the program Microsoft Word, the name Microsoft Word displays below the
icon. To rename a shortcut:
Note: Not all icons can be changed. If you do not see the Change Icon button or if the
change icon button is dimmed, the icon cannot be changed.
Remember, shortcuts have an arrow in the lower-left corner. If the icon you delete does
not have an arrow in the lower-left corner, it is not a shortcut and deleting the icon deletes
the object.
The Cut, Copy, and Paste commands are nearly universal. These three functions are used
by almost every Windows program and perform more or less the same function in each of
them. You can cut, copy, and paste programs, disks, and text, to name just a few things.
Cut: When you cut something, it is deleted from its current location and saved to the
Clipboard. Information saved to the Clipboard stays there until new information is either
cut or copied. Each time you execute Cut or Copy, you replace the old information on the
Clipboard with whatever you just cut or copied. You can paste the same Clipboard
information as often as you like.
Copy: Copy is similar to Cut except the original item is not deleted. When you copy
something, a copy of the item is saved to the Clipboard. Information stored on the
Clipboard stays there until new information is either cut or copied. Each time you execute
Cut or Copy, you replace the old information on the Clipboard with whatever you just cut
or copied. You can paste Clipboard information as often as you like, until you replace it
with something else.
Clipboard: The Clipboard is the storage area for items that have been cut or copied.
Each time you execute Cut or Copy, you replace the old information on the Clipboard
with whatever you just cut or copied. You can paste Clipboard information as often as
you like, until you replace it with something else.
There are three major methods of cutting, copying, and pasting. The three methods are
using the menu, using keyboard shortcuts, and using icons. We will review all of them. In
most programs, they will work exactly as described here.
2. Click Edit, which is located 2. Click Edit. A drop-down 2. Click Edit, which is
on the menu bar. A drop- menu will appear. located on the
down menu will appear. menu bar. A drop-
down menu will
appear.
Using Icons:
Cut Paste Copy
1. Select what you want to 1. Place the cursor at the 1. Select what you
cut. point where you want to want to copy.
place the information that
is currently on the
Clipboard.
2. Click the Cut icon. 2. Click the Paste icon. 2. Click the Copy
icon.
We use the following convention to indicate a menu path: View > Toolbars. When you
see View > Toolbars, it means choose View from the menu bar and select Toolbars from
the drop-down menu. The following list applies to many, but not all programs. Check
each program's documentation for information specific to the program.
Ctrl-x Edit > Cut Cut (delete and place on Clipboard) the
current selection.
Ctrl-z Edit > Undo Reverse the most recent command. Place
the program in the state it was in before
executing the last command.
Ctrl-y Edit > Redo Reverse the last undo. Place the program
in the state it was in before executing
Undo.
Format > Font Set the size of the font for the current
selection.
1. Click File, which is located on the menu bar. A drop-down menu will appear.
2. Click Save. A dialog box similar to the one shown here will appear.
Field/Icon Entry
Save In field Click to open the menu-box and select the drive and folder to
which you want to save the file.
Up One Level icon Click this icon to move up one level in the folder hierarchy.
View Desktop icon Click this icon to move to the Desktop folder.
Create a New Folder icon Use the Create a New Folder icon to create a new folder:
List icon Your program displays files and folders in the center of the
dialog box. To have the files display without the size, type, and
Detail icon Your program displays files and folders in the center of the
dialog box. To have the files display with the size, type, and
date modified, click the Detail icon.
File/Folder box Your program displays files and folders in File/Folder box.
Click a folder to open the folder. Click a file if you want the
current file to write over (replace) that file.
File Name field Enter the name you want your file to have in this field.
Save As Type field Click to open the drop-down box and select a file type.
Cancel button Click the Cancel button if you have changed your mind and do
not wish to save your file.
The taskbar
The taskbar is a long bar that by default runs along the bottom of your desktop. The Start
button, Quick Launch toolbar, active program buttons, and the notification area are
You click the Start button to display the Start menu. You use the Start menu to open
programs and to perform other functions such as searching for files.
On the taskbar, right next to the Start button is the Quick Launch toolbar. Using the
Quick Launch toolbar, you can open a program or file simply by clicking its icon. To add
an icon to the Quick Launch toolbar:
When using XP, Vista or Windows7, each program, document, or other type of file opens
in its own window. You can have multiple programs, documents, and files open at a
given time. A button for each open program, file, or document window displays on the
taskbar. You can quickly move from one open file to another open file by clicking the
files button. If you have a large number of files open, Vista may group all files of a given
type together. For example, if you have several Microsoft Word documents open, Vista
may group them together. When you click the button for Microsoft Word, Vista displays
a menu of open Word files. You can click the document you want to open.
The notification area is located on the right side of the task bar. It displays several icons
and the current time. The icons that display depend on the way in which your computer is
configured. You can move your mouse pointer over an icon to see the current settings for
the option the icon represents. In many cases, you can click the icon to change the
settings. For example, the Volume icon is located in the notification area. When you
pause your over the Volume icon the volume setting for the speakers on your computer
appears. You can click the icon to adjust the volume.
Task Action
To do I restart my computer: 1. Click the Start button. The Start menu will
You may need to shut down and restart your appear.
computer after installing a new program or if your 2. Click Turn Off Computer. The Turn Off
system becomes unstable. To shut down and Computer dialog box will appear.
immediately restart your computer: 3. Click the Restart icon. Your computer will
restart.
What is Standby mode: 1. Click the Start button. The Start menu will
Windows XP enables you to quickly locate files and folders on your drives. The search
option provides you with four search options: Pictures, music, or video; Documents; All
files and folders; and Computers and people. To quickly find a file or folder:
4. Choose an option.
5. Enter your search criteria. Use the table that follows to
help you.
6. Click search. The results of your search will appear in
the right pane.
All or part of the file (document) name: Enter the filename, the first few letters of the
filename, or any letters found in the filename. Use
Computer name: the * as a wild card. For example, to find all of the
files that begin with r and end in the extension .doc,
enter r*.doc. To find files that begin with resume
and have any extension, enter resume.*.
A word or phrase in the file: If you are looking for a file that has a specific word
or phrase in the file, enter the word or phrase in this
field.
Between/During the Previous Specify the date search criteria you want to use.
Between allows you to search for files modified,
created, or accessed between two dates. During
allows you to search for files modified, created, or
accessed during the previous number of days or
months you specify.
Folders are used to organize the data stored on your drives. The files that make up a
program are stored together in their own set of folders. You will want to organize the
files you create in folders. You will want to store files of a like kind in a single folder.
1. Right-click the file or folder you want to delete. A context menu will appear.
2. Click Delete. Windows Explorer will ask, "Are sure you want to send this object to the recycle
bin?"
3. Click Yes.
1. Right-click the file or folder you want to copy. A context menu will appear.
2. Click Copy. The file or folder should now be on the Clipboard.
1. Right-click the file or folder you want to cut. A context menu will appear.
2. Click Cut. The file or folder should now be on the Clipboard.
Note: Cutting differs from deleting. When you cut a file, the file is placed on the
Clipboard. When you delete a file, the file is sent to the Recycle Bin.
1. After cutting or copying the file, right-click the object or right-click in the right pane of the folder
to which you want to paste. A context menu will appear.
2. Click Paste.
When you finish working with your computer, what should you do
When you click the Power button, Vista saves all of your
work, turns off the display screen, and puts your computer in
sleep mode. To indicate that your computer is in sleep mode, some of the lights on your
computer may blink and/or change color.
In sleep mode, your computer consumes very little electricity. When you need to use your
computer again, you can press your computer’s power-on switch to resume work quickly.
Instead of shutting your computer down when you are not using your computer, you
should put your computer in sleep mode.
To wake up my computer
What is a program?
You use programs, also referred to as software, to perform tasks when using a computer.
For example, if you want to use your computer to write a letter, you can use a word-
processing program such as Microsoft Word. If you want to keep accounting records, you
can use an accounting program such as QuickBooks.
To start a program
1. To start a program:
After you click the Start button, a search box appears just above it.
You can use the search box to locate programs or anything else that
is located on your computer, including documents that contain the
word you type. Type the name of the program, e-mail, file, or
whatever you are looking for in the Search box. Vista searches your
computer. The results of the search appear on the Start menu. When
you see the program you are looking for, you can click the program
name to open the program.
Note: You may not be able to view all of your programs on the screen at one time.
Click and drag the scrollbar up or down to change which programs are in view.
Excises
The main advantage of a word processor is that it provides a WYSIWYG (What You See
Is What You Get) interface, which helps you make changes quickly and easily to your
documents.
MS Word 2003, Word XP, or Word 2007 is a word processor that is part of the Microsoft
Office suite that is a powerful tool to create and formatting professional looking
documents. The new Microsoft Office Word 2007 helps you produce professional-
looking documents by providing a comprehensive set of tools for creating and formatting
your document in a new interface. Rich review, commenting, and comparison capabilities
help you quickly gather and manage feedback from colleagues. Advanced data
integration ensures that documents stay connected to important sources of business
information. Their two basic ways to start Microsoft
To begin, you can either choose the Microsoft Word icon in the Programs menu of the
Start menu, or start it by double-clicking on the Word icon on the desktop, or by double-
clicking on a .DOC document.
Starting MSWord
1. Double click on the Microsoft Word icon on the desktop (if available)
Or
Click on Start Programs Microsoft Office MS Word
(depending on where it appears which is different for different
installations)
The Word Window is displayed
Click the X in the upper right corner of the New Document pane to close the New
Document pane. Your screen will then look like the one shown here.
MSWord 2003/XP
This section will familiarize you with the Microsoft Word screen. We will start with the
Title bar, which is located at the very top of the screen. In MSWord 2007 its next to the
Quick Access toolbar. On the Title bar, Microsoft Word displays the name of the
document on which you are currently working. Word names the first new document you
open Document1. As you open additional new documents, Word names them
sequentially. When you save your document, you assign the document a new name. At
the top of your screen, you should see "Microsoft Word - Document1" or a similar name.
MSWord 2007
In the upper-right corner of the Word 2007 window is the Microsoft Office
button. When you click the button, a menu appears. You can use the menu to
create a new file, open an existing file, save a file, and perform many other
tasks.
Next to the Microsoft Office button is the Quick Access toolbar. The
Quick Access toolbar provides you with access to commands you frequently use. By
default Save, Undo, and Redo appear on the Quick Access toolbar. You can use Save to
save your file, Undo to rollback an action you have taken, and Redo to reapply an action
you have rolled back.
The Menu bar is generally found directly below the Title bar. The Menu bar displays the
menu. The Menu bar begins with the word File and continues with Edit, View, Insert,
Format, Tools, Table, Window, and Help. You use the menus to give instructions to the
software. Point with your mouse to a menu option and click the left mouse button to open
a drop-down menu. You can now use the left and right arrow keys on your keyboard to
move left and right across the Menu bar options. You can use the up and down arrow
keys to move up and down the drop-down menu.
You can customize your screen so that all of the menu options
display when you click a menu item. This tutorial assumes that
your menu is set to display all menu options. To customize your
menu to display all of the menu options:
Note: Your screen will probably not look exactly like the screen shown. In Word 2007, how a
window displays depends on the size of your window, the size of your monitor, and the resolution
to which your monitor is set. Resolution determines how much information your computer
monitor can display. If you use a low resolution, less information fits on your screen, but the size
of your text and images are larger. If you use a high resolution, more information fits on your
screen, but the size of the text and images are smaller. Also, Word 2007, Windows Vista, and
Windows XP have settings that allow you to change the color and style of your windows.
Toolbars
Toolbars provide shortcuts to menu commands. Toolbars are generally located just below
the Menu bar. Before proceeding with this lesson, make sure the toolbars you will use --
Standard and Formatting -- are available. Follow these steps:
The ruler is generally found below the main toolbars. The ruler is used to change the
format of your document quickly. The ruler is found below the Ribbon in MSWord 2007.
You can use the ruler to change the format of your document quickly. If your ruler is not
visible, follow the steps listed here:
Or
The Ribbon
You use commands to tell Microsoft Word what to do. In Microsoft Word 2007, you use
the Ribbon to issue commands. The Ribbon is located near the top of the screen, below
the Quick Access toolbar. At the top of the Ribbon are several tabs; clicking a tab
displays several related command groups. Within each group are related command
buttons. You click buttons to issue commands or to access menus and dialog boxes. You
may also find a dialog box launcher in the bottom-right corner of a group. Clicking the
dialog box launcher gives you access to additional commands via a dialog box.
The toolbars in Microsoft Word provide easy access and functionality to the user. There
are many shortcuts that can be taken by using the toolbar. First, make sure that the proper
toolbars are visible on the screen
Click View
Select Toolbars
Select Standard, Formatting, and Drawing
Other toolbars can be selected if you wish
Commonly used toolbars are: Standard Toolbar: This toolbar contains buttons for the frequently used
actions, such as opening files, saving files, and copying and pasting text
Formatting Toolbar: This toolbar provides various tools that help your
format the text in the document area. For example, changing the font size
or the style of text
Drawing Toolbar: Consists of various drawing tools - to draw different
shapes, arrows, and geometrical figures. You can modify these graphics
by adding colours and 3-D effects or by moving the graphics behind or in
front of the text. You can also insert preformatted text styles, text boxes,
and pictures.
Action Task
Create a document 1. Click Start Programs Microsoft Word (Word Window is displayed)
2. Click File New (New dialog box is displayed)
3. Click on the General tab
4. Select the Blank document option
5. Select the Document under the Create New section
6. Click OK
When you create official documents, you might want them to have a consistent look.
E.g., you might want all documents for internal communication to contain the logo and
the name of your company, you can use templates to give uniform structure to
documents. Word supplies several built-in templates, which you can use to create
documents, such as letters, faxes, memos, resumes .. One standard template that Word
provides is the Normal template
When you click the New button on the Standard toolbar, Word creates a blank
document based on the Normal template
The template settings are automatically applied to anything entered in this new
document. You can modify this template to change its default settings
Opening a Document
Action Task
Save a document 1. Click File Save As command (Save As dialog box appear)
2. Specify name and/or location where to save using the Save in drop-down list
3. In case you need to create a new folder to save the file, click the Create New
Folder button in the dialog box
4. This opens the New Folder dialog box, as shown below
Moving Text
Action Task
Moving 1. Select the required text (First you Cut, then you Paste)
Text 2. Select the Edit Cut command, OR
3. Right-click on the selected text and select the Cut option from the pop-up menu
4. To copy text to another document, open destination document
5. Position cursor at the location where the text is to be pasted.
6. Select the Edit Paste command to paste the text, OR
7. Right-click on the required location and select the Paste option from the pop-up menu.
8. To move text within the same document, you can also use the drag-and-drop method
Select the required text
Position the cursor anywhere on the selected text and press the left mouse button
Holding down the left mouse button, drag the mouse pointer to the desired location
Release the mouse button
Pasting Text
Action Task
Pasting Text Using 1. Smart tags are special buttons that appear when Word recognizes some special type of
Smart Tag action or data
Pasting Text Using 2. When you click on this smart tag, a list of choices is displayed
Clipboard 3. You can use smart paste list to specify the formatting of the pasted information. For
example, you can choose to keep the text formatting as it is or inherit the formatting
of the destination paragraph
4. When you cut or copy text, Word places the selected text on the Office Clipboard.
The Office Clipboard can hold up to 24 items. The collected items stay on the
clipboard until you close office
Searching Text
When you are working in a document with many pages it can be time-consuming to find
a specific word or words. Word provides features to find and replace text in a document.
The Find feature allows locating a specific word or phrase in the document. The Replace
feature allows replacing the searched text with new text
Action Task
Finding 1. Select Edit Find command to open the Find and Replace dialog box
Text 2. Type the word or phrase to be located
3. Click the Find Next button to find the
Replacing Text
Action Task
Replacing 1. Select Edit Find command to open the Find and Replace dialog box
Text
Action Task
Modifying/Formatting a Document
You can modify a document by using various formatting tools that help customize and
enhance the appearance of text. Enhancing a document with character formatting enables
you to draw attention to parts of the document and improve its readability. For example,
you can apply different font styles and font sizes to text, or you can underline and
italicize text.
Task: Identify the part of the document that needs to be modified in appearance and then
change the appearance of the text
Formatting Text
Formatting text allows you to:
Draw attention to different parts of the document
Improve readability
Modifying font
You can change the appearance of text by modifying the different characteristics of fonts
Definition of Font
A font is a formatting characteristic that defines the way in which text appears in a
document. It is the pattern applied to the characters in the document. Different fonts
contain different collection of characters and symbols. You can change the fonts by using
the Font dialog box, or by selecting required buttons from the Format toolbar
Select the text to be changed.
Select Format Font command (Font dialog box displayed)
Select the required text formats -font style, size, color & effects
Click the OK button to apply changes to the selected text
Font Type
Font type is the preformatted design for the letters in the font. E.g., the most commonly
used font types are Times New Roman and Arial
Action Task
Or press Shift + F3 to change any of the highlighted word or sentence to any case type
Action Task
Action Task
Definition of Alignment
Alignment is a way of organizing the text in a document. It refers to the position of the
text relative to page margins
Types of Alignment
Insert a line 1. Position the cursor at the beginning or end of the line and press the Enter key
before or after a 2. Then, press the top or bottom arrow key to move to the inserted line.
paragraph
Bulleted Text
Bulleted text is used to list down text, which is non-sequential.
Types of Bullets
Symbol Picture
Properties of Bullets
Distance between the bullet and the text
Font Properties of the bullet
Amount of indentation of text in bullets
Create the table 1. Position the cursor where you want to insert the table
2. Click Table Insert Table (Table dialog box appears)
3. Give your table dimensions
Applying Styles
A style is a collection of formatting characteristics that defines the way in which
text appears in a document
A paragraph style affects the appearance of the paragraph, such as its alignment,
line spacing, and tab settings
A text style affects the font style, size, or applies bold and italic formats to the text
in a paragraph.
Built-in styles provided by Word can be availed by using the Styles and
Formatting command in the Format menu.
Word also allows you to create new styles and copy these styles using Format
Painter.
Creating Tables
To create a table, you need to specify the number of rows & columns
You can add data (text or graphics) in each cell of a table
You can use the arrow keys to move between table cells.
By default, Word applies a border around the cells of a table
If you remove the table border, you will see gridlines which are not printable
Action Task
To create a table 1. Position the cursor at the location where the table needs to be inserted
2. Select the Table Insert Table command (Insert Table dialog box)
3. Make selections and click OK
Action Task
You use PowerPoint to create effective slide show presentations. The PowerPoint screen
has many elements.
What is a Presentation
A presentation is a collection of slides. A slide is like a frame in a presentation that
represents data. During a presentation, the slides are displayed one after the other and the
contents of the presentation are displayed through these slides on screen.
NAMES FUNCTION
Title bar Displays the name of the current presentation
Menu bar Consists of menus, such as File, Edit, and View
Each menu consists of commands that enable you to perform corresponding actions, e.g.,
Edit menu contains Copy command that enables you to copy text or images to the
clipboard
Toolbar Contains buttons that provide easy access to the commands and functions of PowerPoint
By default, PowerPoint displays the Standard, Formatting, and Drawing toolbars
To display or hide a toolbar, select the View Toolbars command from the Menu bar
and select the appropriate toolbar
To move a toolbar, place the cursor at the left-most corner of the toolbar and move the
cursor until it changes to a 4-headed arrow
Then, drag the toolbar to the position where you want to place the toolbar
Task Pane Located on the right side of the screen, the task pane changes depending on the current
status of presentation
This component provides shortcuts for performing commonly used commands, such as
creating new presentations or applying character formatting
For example, to display the New Presentation task pane, you can select the File New
command
Slide pane It is the workspace that is used to create slides.
Slides tab It enables you to display a miniature image of the presentation slides
Click the image to view the corresponding slide in the slide pane.
Outline tab It enables you to display an outline of the slide content.
Action Task
Opening an 2. In the Look in drop-down list, browse for the presentation file you
existing want to open
Presentation 3. Select the file that you want to open
4. Click the Open button to open the presentation file
Action Task
Open multiple 1. Select File Open command (open dialog box displayed)
presentation 2. In the Look in drop-down list, browse for the presentation files you want to open
files 3. Click the first file that you need to open
4. Hold down the Shift key and click the last presentation file to select multiple files that are in
succession
5. Release the Shift key
6. A block of files is selected. Click the Open button to open the selected presentation files
To select multiple presentation files randomly, select the File Open command.
Next, click the first file that you need to open. Hold down the Ctrl key while you
select the required files
Action Task
Create a new 1. Select File Open command (open dialog box displayed)
presentation 2. The New Presentation task pane is displayed on the right side of the PowerPoint window.
The New section of the New Presentation task pane contains the following options:
Creating a new 1. Click the Blank Presentation option in the New section. This displays the Slide
Presentation using Layout task pane
the Blank
Presentation
The Slide Layout task pane consists of different types of layouts. These layouts can be
used to organize placeholders on a slide. A placeholder is an area that contains text such
as the title of the slide or a bulleted list, content elements - pictures, charts, and tables.
The layout options are arranged in four areas. These are:
Text Layouts: area consists of layouts that provide placeholders for title, subtitle,
and text that can be added to the slide
Content Layouts: This area consists of layouts that provide a blank slide and title
and placeholders for the content elements.
Text and Content Layouts: This area consists of layouts that provide
placeholders for a title, a bulleted list, text and content.
Other Layouts: area consists of layouts that provide placeholders for a title and
objects - chart, media clip and combination of content elements
You can modify the layout of a slide, by selecting the slide and clicking the required
layout in the Apply slide layout task pane. PPT templates are predefined formats that
contain font styles and slide backgrounds. You can select a template depending on the
purpose and audience of the presentation. With Templates you can provide consistent
format and look to your presentation. When you apply a design template to an existing
presentation PowerPoint automatically updates the text styles and graphics, and color.
Creating a 1. Select From Design Template option from the New section in the New Presentation
Presentation task pane. This displays the Slide Design task pane
using 2. Select the required design template from the Available For Use section
templates 3. The selected design template is applied to all the slides
The following presentation window is displayed after you click the Finish button:
Saving a Presentation
You need to save your presentations to prevent data loss. The first time you save a presentation,
you must assign a file name and select a location or folder in which the presentation file needs to
be stored. You can either use existing folders or create folders to save your presentations
Action Task
To save a 1. Select File Save command. This opens the Save As dialog box
presentation 2. Specify the location where you want to save the document using the Save in drop-
in an existing down list
folder
To save a 1. In case you need to create a new folder, click the Create New Folder button
presentation in () in the dialog box. This opens the New Folder dialog box
an new folder
Action Task
To save a 2. Specify the required folder name click the OK button (A new folder is created at
presentation the required location)
in an new 3. Enter the file name in the File name box of the Save As dialog box
folder 4. Click the Save as type drop-down list. This displays a list of options that enable
you to save the presentation
5. Select the required file type from the Save as type drop-down list
6. In the File name box, type a name for the presentation
7. Click the Save button to save the presentation file
Closing a Presentation
Action Task
Inserting Text
In a presentation, text can be inserted in the place holders provided by PowerPoint
Action Task
To insert text 1. Click inside the text placeholder. The shape of the cursor changes to an I - bar
2. Type the required text
Similarly, you can insert text in the Click to add subtitle placeholder
Action Task
Delete a slide 1. Click the slide that needs to be deleted in the Slide Pane
Delete all slides 2. Select the Edit Delete Slide command to delete the slide
1. Select View Slide Sorter command
2. Click on any thumbnail image of the slide
3. Select Edit Select All command to select all the slides in the slide sorter view
4. Select the Edit Delete Slide command to delete the slide
Inserting Images
Power Point enables you to insert images in slides from:
A file
The Power Point ClipArt gallery
After inserting an image in a slide, it can be edited using the Format Picture
command from the pop-up menu.
To insert a Clip Art object in a document, do the following:
Position the cursor at the desired location
Select the Insert Picture Clip Art command
If you are selecting the Clip Art option for the first time, the Add Clips to Organizer
dialog box is displayed
1. Select the Insert Picture From File command. This displays the
Insert Picture dialog box.
2. Browse for the required file on the computer and click the Insert button to
insert the image in the slide.
You can duplicate an image on a slide. To do this, select the image and then, select the
Edit Duplicate command
After inserting an image in a slide, you can edit the image to modify its properties, such
as size, color, and layout. To edit a picture, right-click the image and select Format
Picture command from the pop-up menu (Format Picture dialog box displayed)
Action Task
Change the 1. Select the Format Background command (dialog box displayed)
background The Background dialog box contains the options for select the color and pattern that can be
of slide applied to the presentation from the drop-down list
2. Select the required options from the Background dialog box and click either the
Apply button or the Apply to All button to apply the selected color or pattern to one
slide or all slides respectively.
Change 1. Select the View Master Slide Master command (Slide Master panel is displayed see
layout of next slide)
slides 2. Place mouse pointer in the Click to edit Master title style area
using the The heading disappears and cursor is placed at that point
slide 3. Insert the required title
master 4. Similarly, you can add footer in the Footer Area
Click the Close Master View button on the Master toolbar changes are applied to all
the slides in the presentation
If you insert more slides in the presentation, those slides will also have the same format
as the Slide Master.
Views in PowerPoint
The different types of views in PowerPoint are:
Normal
Slide Sorter
Slide Show
Notes Page
Normal View
By default, Power Point displays the presentation in the Normal view. Select the View
Normal command, to display the presentation in Normal view as shown in next slide
It has three sections namely, tabs, Slide pane and Notes pane
It allows a user to view the content in the slide while the text is
being typed in the Outline tab or vice-versa
The Slide tab shows thumbnail images of slides, which helps in
navigation between slides
The Notes pane is used to add speaker notes. Speaker notes are
notes that a speaker refers to while conducting the presentation
Alternatively, you can display the presentation in Normal view by clicking the Normal
View ( )
Formatting Text
The appearance of text in a presentation can be enhanced by formatting the text.
Formatting involves:
Specifying the Font of Text in a Presentation
Changing Text Case
Modifying the Text Alignment
Applying Bullets and Numbering
Adjusting the Line Spacing
1. Select the Format Font command to open the Font dialog box (The
Font dialog box is displayed)
Animation refers to the movement of picture. It can also be stated as a creation of moving
illustrations that help a user to visualize a process
Introduction to Excel
Definition of a Spreadsheet
Advantages of a Spreadsheet
Components of Excel Window
Create a new workbook
Opening, creating, and saving a workbook
Enter and Edit data in a worksheet
Edit and format cells, rows and columns
Format numbers and apply style
Link data in the worksheet
Refer to cells in a formula
Importing and exporting data
Creating a web page
Placing interactive data on the web
View different sections of a worksheet
Insert a picture
Preview and print workbook/sheet
Creating and modifying graphics (charts)
Set a validation rule to enter data in a worksheet
Set a validation rule to enter data in a worksheet
Import data
Apply number formats
Apply a condition for formatting
Create names for ranges of cells
Apply the names in formulas
Locate the required data
Sort data
Calculate subtotals
Change the print settings of a workbook
Print a workbook
Perform what-if analysis
Create dynamic tables and charts to analyze data
Publish dynamic tables and charts in an interactive Web page
Definition of a Spreadsheet
A spreadsheet is a program that manipulates number and string data in rows and columns
Advantages of a Spreadsheet
Main advantage of using a spreadsheet program is that it enables you to
perform simple row-and-column arithmetic
Introduction to Excel
Excel is a spreadsheet program with various components
Rows-are referenced by the row number
1:1 is the reference to the first row
Columns-are referenced by the column name such as “A”
Cell-is an intersection of a row and a column
It can contain various types of data – numeric/character
A cell is referenced by the combination of a column and row
name. E.g., first cell A1 is in column A and row 1
Worksheet-contains rows and columns of cells. A sample worksheet is displayed
Components of the Excel Worksheet window is described in next slide
ITEMS MEANINGS
Rows Rows are referenced by the numbers.
Columns Columns are referenced by the alphabets.
Cell A cell is an intersection of a row and a column. Cells can contain various types of data. A
cell is referenced by the name of the column and row. For example, the first cell A1 is in
column A and row 1.
Worksheet A worksheet contains rows and columns and their intersection forms the cells. A worksheet
consists of 65,536 rows and 256 columns.
Workbook A workbook consists of worksheets. It is also referred to as an Excel file. A workbook can
be defined as a set of worksheets.
The Down Arrow You can use the down arrow key to move downward one cell at a time.
Key
The Up Arrow You can use the Up Arrow key to move upward one cell at a time.
Key
The Tab Key You can use the Tab key to move across the page to the right, one cell at a time.
Name box: A name box displays the name of a selected cell and a range of cells.
Task Pane A task pane serves as an additional navigation tool substituting the frequently used dialog
boxes. The task pane appears each time you start Excel.
Horizontal scroll A horizontal scroll bar serves as a tool to view the left or right part of the worksheet that is
bar not displayed on the screen.
Vertical scroll A vertical scroll bar serves as a tool to view the top or bottom part of the worksheet that is
bar not displayed on the screen.
Sheet Tab A sheet tab helps to navigate between worksheets in a workbook.
The Shift+Tab You can hold down the Shift key and then press the Tab key to move to the left, one cell at
Keys a time.
The Right and You can use the right and left arrow keys to move right or left one cell at a time.
Left Arrow Keys
Title bar: A title bar displays the name of the current workbook.
Menu bar: A menu bar consists of various menus, such as File, Edit, and View.
Toolbar: A toolbar contains buttons that provide easy access to the commands and
functions of Excel.
Formula bar: A formula bar contains tools for creating and editing formulas.
Creating a Workbook
Task 1: Identify the type of data to be inserted in the worksheet
Before you decide the type of data to be inserted in the worksheet you
should know about the methods of representing information in a
worksheet
Functions
Excel provides many functions - mathematical, statistical, logical, etc.
Mathematical functions
Sum(), Product()
E.g, to calculate the sum of values stored in cells C1 to C5, use
=SUM(C1:C5).
Statistical functions
Average(), Max(), Min(), Count(), Round()
Eg., to find the average of the values in cells C1 to C5, use
=AVERAGE(C1:C5).
Date and time functions
Now(), Today(), Date(), Time()
Eg., =TIME(9,0,0) returns 9:00 A.M and =TIME(20,15,30) returns 8:15
P.M.
Logical functions
If(), Not()
E.g., For the formula =If(B2>70, “A”, “B”), a grade A is displayed if
marks are above 70 and a grade B is displayed if marks are below or equal
to 70.
The original aim of ARPANET was to create a network that would allow
researchers working on computers at one university to connect to
computers at other universities
The World Wide Web (WWW) also called the Web is a subset of the Internet
The Web is a series of interconnected servers that support specially
formatted documents
Today, the Internet has become an important part of our day-to-day life
The Internet is used today in diverse field - business, entertainment,
education, communication, medicine, defence, engineering, and sports.
The WWW also called the Web is a subset of the Internet
The Internet and the World Wide Web are often used synonymously but they are
different.
The Web is a series of interconnected servers that support specially
formatted documents
This means you can switch from one document to another just by clicking
on marked text.
A server is a program or a computer that responds to requests from other programs and
delivers the requested documents
Web Terminology
Some of the most commonly used terms in the Web are:
Browser
This is a client software that allows the user to display and interact
with a hypertext document
Web Server
This is a program that responds to requests from Web browsers to
retrieve resources. It is also used to refer to the computer that runs
the server program
Web Site
This is a collection of related files. Each Web site contains a home
page, which is the first document that is displayed on the browser
A site might also contain additional documents and files. A site is
owned and managed by an individual, company or organization
Home Page
This is the first hypertext document (in HTML) that is displayed
when the user opens a Web site. It contains links to other pages or
other sites
HTML (Hypertext Markup Language)
This is the formatting language used to present a Web document.
HTTP (Hypertext Transfer Protocol)
This is the protocol used on the Web to transfer hypertext
documents.
URL (Uniform Resource Locator)
To Use
Before loading a Web site, you first need to connect to the Internet
To connect to the Internet, you need the following:
Access to a phone line
A modem
A modem is a device that helps the computers to communicate
using phone lines
Computers can interpret digital signals, and phone lines can
interpret analog signals
Modems convert the outgoing digital signals from a computer to
analog signals that can be transmitted via telephone cables
Modems also convert the analog signals from a phone line to
digital signals for a computer
The speed of a modem at which the data transfer is done is
measured in Kilo bits per second (Kbps)
Internet Service Provider (ISP)
An Internet account provided by an Internet Service Provider (ISP)
An ISP is an organization that provides users access to the Internet
and other related services, such as hosting a Web site and
providing space on the Web server to launch a Web site on the
Internet
ISP provides users with usernames and passwords, which are
required to connect to the Internet
Internet Browsers
A browser is an application that helps you display and interact with
the information on the Internet
A browser uses HTTP to display information from the Web server
Mosaic was the first commercially used Web browser
Today, Netscape Navigator and Internet Explorer are the most
popular Web browsers
Connecting to the Internet enables you to perform operations, such as accessing a
Web site, reading your email, navigating between Web sites, and printing Web
pages
Notice that the mouse pointer changes to a hand when it is moved on a hyperlink. You
can click on a text hyperlink or image hyperlink to display the linked URLs
Note that the search results show links on all protocols and not just routing
protocols
The search engine searches for Web pages that contain either the word
“Protocol” or “Routing” or “Routing Protocol” in the content
You can also search for Web pages that contain the exact phrase
Align paragraphs
To do this Press
To do this Press
Key Description
CTRL+SHIFT+$ Applies the Currency format with two decimal places (negative numbers in parentheses).
CTRL+SHIFT+^ Applies the Exponential number format with two decimal places.
CTRL+SHIFT+# Applies the Date format with the day, month, and year.
CTRL+SHIFT+@ Applies the Time format with the hour and minute, and AM or PM.
CTRL+SHIFT+! Applies the Number format with two decimal places, thousands separator, and minus sign
CTRL+SHIFT+* Selects the current region around the active cell (the data area enclosed by blank rows and
blank columns).
CTRL+SHIFT+" Copies the value from the cell above the active cell into the cell or the Formula Bar.
CTRL+Minus (-) Displays the Delete dialog box to delete the selected cells.
CTRL+` Alternates between displaying cell values and displaying formulas in the worksheet.
CTRL+' Copies a formula from the cell above the active cell into the cell or the Formula Bar.
CTRL+6 Alternates between hiding objects, displaying objects, and displaying placeholders for
objects.
If the worksheet contains data, CTRL+A selects the current region. Pressing CTRL+A a
second time selects the current region and its summary rows. Pressing CTRL+A a third
time selects the entire worksheet.
When the insertion point is to the right of a function name in a formula, displays the
Function Arguments dialog box.
CTRL+SHIFT+A inserts the argument names and parentheses when the insertion point is
to the right of a function name in a formula.
CTRL+D Uses the Fill Down command to copy the contents and format of the topmost cell of a
selected range into the cells below.
CTRL+F Displays the Find and Replace dialog box, with the Find tab selected.
SHIFT+F5 also displays this tab, while SHIFT+F4 repeats the last Find action.
CTRL+SHIFT+F opens the Format Cells dialog box with the Font tab selected.
CTRL+H Displays the Find and Replace dialog box, with the Replace tab selected.
CTRL+K Displays the Insert Hyperlink dialog box for new hyperlinks or the Edit Hyperlink
dialog box for selected existing hyperlinks.
CTRL+SHIFT+P opens the Format Cells dialog box with the Font tab selected.
CTRL+R Uses the Fill Right command to copy the contents and format of the leftmost cell of a
selected range into the cells to the right.
CTRL+S Saves the active file with its current file name, location, and file format.
CTRL+V Inserts the contents of the Clipboard at the insertion point and replaces any selection.
Available only after you have cut or copied an object, text, or cell contents.
CTRL+SHIFT+Z uses the Undo or Redo command to reverse or restore the last automatic
correction when AutoCorrect Smart Tags are displayed.
To do this Press
Switch between Slides and Outline tabs in the Outline and Slides pane in Normal view. CTRL+SHIFT+TAB
Work in an outline
To do this Press
Insert a shape
2. Use the arrow keys to move through the categories of shapes, and select the shape that you want.
Insert a box
Insert an object
Insert WordArt
2. Use the arrow keys to select the WordArt style that you want, and then press ENTER.
Select a shape
To select a single shape, press the TAB key to cycle forward (or SHIFT+TAB to cycle backward)
through the objects until sizing handles appear on the object that you want to select.
To group shapes, pictures, or WordArt objects, select the items that you want to group, and then press
CTRL+G.
To do this Press
1. Select the shape with the attributes that you want to copy.
If you select a shape with attached text, you copy the look and style of the text as well as the attributes of the
shape.
3. Press the TAB key or SHIFT+TAB to select the object that you want to copy the attributes to.
4. Press CTRL+SHIFT+V.
To do this Press
Select an object (with an object selected). TAB or SHIFT+TAB until the object you want is selected
To do this Press
To do this Press
Move to the next title or body text placeholder. If it is the last placeholder on a slide, this CTRL+ENTER
will insert a new slide with the same slide layout as the original slide.
To do this Press
Add a new row at the bottom of the table. TAB at the end of the last row
3. Press the DOWN ARROW to select Worksheet Object, and then to select Edit.
To do this Press
Open the Font dialog box to change the font size. CTRL+SHIFT+P
Open the Font dialog box to change the formatting of characters. CTRL+T
To do this Press
To do this Press
Run a presentation
You can use the following keyboard shortcuts while running your presentation in full screen mode.
To do this Press
Perform the next animation or advance to the next N, ENTER, PAGE DOWN, RIGHT ARROW, DOWN
Perform the previous animation or return to the P, PAGE UP, LEFT ARROW, UP ARROW, or
previous slide. BACKSPACE
Perform the "mouse click" behavior of the selected ENTER while a hyperlink is selected
hyperlink.