Lab Manual

CSC101- Introduction to Computing

CUI Department of Computer Science

Islamabad Campus
Lab Contents:
Introduction to MS Word; Introduction to MS PowerPoint; Introduction to MS Excel; Introduction to MS Access; and
Intoduction to HTML
Student Outcomes (SO)
Sr.# Description
Create, select, adapt and apply appropriate techniques, resources, and modern computing tools
4
to complex computing activities, with an understanding of the limitations.
Intended Learning Outcomes
Blooms Taxonomy
Sr.# Description SO
Learning Level
Demonstrate the usage of productivity software, and web technology by
CLO -4 Applying 4
performing appropriate tasks.
Lab Assessment Policy
The lab work done by the student is evaluated using rubrics defined by the course instructor, viva-voce, project
work/performance. Marks distribution is as follows:
Lab Mid Term Lab Terminal
Assignments Total
Exam Exam
25 25 50 100
Note: Midterm and Final term exams must be computer based.
 List of Labs
Table of Contents
Lab 1 – Introduction to Computers, Windows OS and its Basic Usage
Lab 2 - Introduction to MS-Word
Lab 3 - Character formatting
Lab 4 –Paragraph formatting and Tables
Lab 5 – Microsoft PowerPoint
Lab 6 – Microsoft PowerPoint
Lab 7 – Creating Workbook in MSExcel
Lab 8 – MS Excel Filtering, sorting, Charts and applying formulas
Lab 9 – MS Excel Formula, Formatting and conditionally formatting data
Lab 10 Midterm Exam
Lab 11 – Database in MS Access
Lab 12 – MS Acess Filter and Sorting and Report Generation
Lab 13 – MS Access Creating Table Relationship
Lab 14 – HTM
Lab 15 – HTML Tags and links
 Lab 01

Introduction to Computers, Windows OS and its Basic Usage

Objectives
This lab will provide understanding of Computer System, Hardware and Software, basic skills required to use a
desktop computer.

Activity Outcomes:
The lab will teach students to about Hardware and Software components of a computer system.
The students will be able to:
• Dismantling the system unit , recognize all major components inside a PC ,describe function of each
component and define the relationship of internal components.
Demonstrate the the usage of computer.

Instructor Note:
As a lab activity, read “Window OS”official site for guilines.
1) Useful concepts:
Computer Basics introduces general computer use and terminology. It describes the basic hardware components of
a PC and introduces basic skills for using software programs in a windows environment. This course will address
hardware and peripheral components of the computer and how to use them correctly.

Figure 1.1

A computer is an electronic device that has the ability to store, retrieve, and process data, and can
be programmed with instructions that it remembers. The physical parts that make up a computer
(the central processing unit, input, output, and memory) are called hardware. Programs that tell a
computer what to do are called software. A set of instructions that perform a particular task is
called a program, software program, or software. Peripherals are any hardware device
connected to a computer, any part of the computer outside the CPU and working memory. Some
examples of peripherals are keyboards, the mouse, monitors, printers, scanners, disk and tape
drives, microphones, speakers, joysticks, plotters, and cameras.

1. Examples:
Below we will discuss some major components of the computer system.

1.1 Monitor
The computer monitor is an output device that displays input on a screen and is very similar to
a television monitor. When the computer wants to display something, it calculates how it needs
to change the color and brightness of the different pixels, and changes the values in the video
memory.

Page 4 of 102
 COMSATS Institute of Information Technology (CIIT)
Islamabad

Monitor Resolution refers to the number of dots on the screen or pixels. It is expressed as a
pair of numbers that give the number of dots on a line (horizontal) and the number of lines
(vertical). Four resolutions commonly used today:

▪ 640 x 480 PIXELS (VGA) (SVGA) -- images are larger for visually impaired students.
▪ 800 x 600 PIXELS (SVGA) – most web sites are designed to be viewed at this setting.
▪ 1024 x 768 PIXELS (SVGA)
▪ 1280 x 1024 PIXELS (SVGA)-- images are smaller, but more information can be
displayed.

The smaller the pixels, the clearer and sharper the picture appears on the monitor. Most
monitors come with a .28 dot pitch. This is the standard for monitors. Do not buy a monitor if
the dot pitch is more than .28. The smaller the dot pitch, the better the monitor.

1.2 Computer
The computer is a machine that processes data according to a set of instructions that are stored
internally either temporarily or permanently. The computer has either external or internal
peripherals attached to it. The picture below displays two internal devices—the floppy disk
drive and CD ROM drive.

Figure 1.2
1. POWER SWITCH -- Turns the computer on and off. Whenever the computer is turned
off, always wait at least 60 seconds before turning it back on again.

2. POWER INDICATOR -- Located in the center of the power switch. A green light
indicates the computer is on.

3. RESET BUTTON -- Allows you to reboot (restart) your system without having to power
down the entire computer. Rebooting the system in this manner reduces stress on
the system components. This button is used ONLY when the computer has “frozen”
and will not accept any commands.

4. HARD DISK DRIVE ACCESS INDICATOR -- Turns green when the computer is
accessing your hard drive, either retrieving or storing information.
 COMSATS Institute of Information Technology (CIIT)
Islamabad

5. DISKETTE DRIVE INDICATOR -- Turns green when the computer is accessing your
floppy disk drive, either retrieving or storing information. If this light is green, you
should NEVER attempt to eject the floppy disk.

6. FLOPPY DISK DRIVE -- Storage device that holds, reads and writes to floppy disks,
usually called Drive A.

7. CD-DRIVE -- Player or reader that reads data from a CD ROM disk.

1.3 Internal Components Of A Computer

Figure 1.3

1.4 Back Panel And Cables

The ports that connect the peripherals to the computer are located on the back panel of the
computer. Newer computers have ports that are color-coded with their appropriate cables.
Speaker cables plug into headphone jacks on the back panel and are also color-coded. The back
panel may have small icons on the ports showing the correct cables (example --monitor for
monitor cable). It is important that all cables are inserted completely and securely in their port
(pins screwed in all the way) or the peripheral will not function properly. Once all peripherals
have been connected to the computer, it may be useful to label each cable and it's appropriate
port. When the computer is stored for the summer it will be very easy to reconnect cables in
the fall. Two successful methods used to code cables and ports include
 COMSATS Institute of Information Technology (CIIT)
Islamabad

Figure 1.4
colored dots using nail polish (red mouse cable, red dot on mouse port, pink printer cable, pink
dot on printer port, etc.) and numbering cables and ports (1 & 1, 2 & 2, etc.).

When attaching or removing cables from the computer it is important to be very careful. The
cables are connected with "pins" that can easily be bent or broken. Don't try to remove cables
by "wiggling" from side to side. Pull cables directly out to avoid damaging the pins.

1.5 Storage Devices

When working on the computer, all work is entered into the computer's memory. In order to
store your work for future retrieval, you must “save” your work to a storage device before
turning the computer off. When your work is saved it creates a computer “file”. The most
common storage devices are hard

USB/Flash Drive (Jump/Thumb Drive) - is a plug-and-play portable storage device that uses
flash memory and is lightweight enough to attach to a key chain. A keychain drive can be used
in place of a floppy disk, Zip drive disk, or CD. When the user plugs the device into their USB
port, the computer's operating system recognizes the device as a removable drive. Unlike most
removable drives, a keychain drive does not require rebooting after it's attached, does not
require batteries or an external power supply, and is not platform dependent. Several keychain
drive manufacturers offer additional features such as password protection, and downloadable
drivers that allow the keychain drive to be compatible with older systems that do not have USB
ports. Keychain drives are available in capacities ranging from 8 MB to 2 gigabytes, depending
on manufacturer, in a corresponding range of prices.
 COMSATS Institute of Information Technology (CIIT)
Islamabad

Figure 1.5

1.6 Input Devices

1. Mouse – The mouse is a pointing device attached to the computer that controls
the movement of the cursor on the screen. It allows the user to execute
commands using point & click and click & drag techniques. As the user moves the
mouse across the pad, the cursor moves across the screen. The mouse should
always be used with a mouse pad to provide a smooth surface for mouse
movement and to help keep the mouse from damage. If you "run out of room" on
the pad, simply pick up the mouse and move it to the opposite edge and continue
movement.

Figure 1.6
 COMSATS Institute of Information Technology (CIIT)
Islamabad

The PC mouse has two buttons (left and right) and newer mice have a scroll wheel between the
two. Mouse commands are executed by "clicking". The term “click” refers to the left mouse
button.

2. Keyboard -- The computer receives most of its input from the user via the
keyboard that is very similar to the typewriter keyboard. The keyboard is
connected by a cable to the keyboard port on the back of the computer. There are
extra keys on the computer's keyboard that are not found on a normal typewriter.
Following is an explanation of the function of these keys. The exact manner in
which the keys function depends on the software program.

Figure 1.7
BACKSPACE KEY-- Deletes the character just to the left of the cursor (or insertion point) and
moves the cursor to that position.

DELETE KEY-- Sometimes labeled Del, deletes the character at the current cursor position or to
the right of the insertion point, or deletes the selected object, but does not move the cursor.

ARROW KEYS -- four arrow keys for moving the cursor or insertion point right, left, up, or down.
Moving the arrow keys does not delete any characters on the screen.

CAPS LOCK KEY -- A toggle key that, when activated, causes all alphabetic characters to be
uppercase.

HOME -- moves the cursor to the top left corner of the screen or to the beginning of the file, but it
can have other meanings depending on which program is running.

END -- moves the cursor to the end of the line, the end of the page, or the end of the file depending
where the cursor is located on the page and on which program is running.

ENTER -- Used to enter commands or to move the cursor to the beginning of the next line.
Sometimes labeled Return instead of Enter.

RETURN KEY -- Another name for the Enter key.

ESC -- Short for Escape, this key is used to send special codes to devices and to exit (or escape)
from programs and tasks.
 COMSATS Institute of Information Technology (CIIT)
Islamabad

FUNCTION KEYS -- Special keys labeled F1 to Fx, x being the number of function keys on the
keyboard. These keys have different meanings depending on which program is running.

CTRL KEY -- Short for Control, this key is used in conjunction with other keys to produce control
characters. The meaning of each control character depends on which program is running.

ALT KEY -- Short for Alternate, this key is like a second Control key

PAGE UP and PAGE DOWN -- moves the cursor up or down a set number of lines usually one
page or screen at a time. Often abbreviated PgUp and PgDn.

NUMERIC KEYPAD -- A separate set of keys on some keyboards that contain the numbers 0
through 9 and a decimal point arranged as on an adding machine. Numeric keypads make it easier
to enter large amounts of numeric data. For the keypad to function as numbers, the NUM LOCK
must be on (Num Lock light is green).

INSERT -- Changes between insert mode and overstrike mode in word processing programs. In
insert mode, all characters typed are placed at the cursor position (or to the right of the insertion
point). With each new insertion, characters to the right of the cursor are pushed to the right of the
insertion point to make room for the new characters. If insert mode is turned off, typing then
overwrites existing characters instead of inserting the new ones before the old ones. This is often
called overwrite mode. Most PC keyboards have an Ins or Insert key that lets you switch back and
forth between insert and overwrite modes.

1.7 Output Devices

Output devices are computer devices that display or output information. The monitor is a
common example of an output device. Other output devices are:
▪ Printers—take information from the CPU and transfer it to paper, provides a hard
copy. There are a number of different printer technologies available: Dot Matrix,
Ink Jet, Laser.
▪ Plotters—produces high-quality line drawing graphic output (used for blueprints).
▪ Video projector, Scan Converter or LCD overhead projector—projects the image onto
a wall screen for greater view by large groups.
▪ Speaker(s)—provides output of sound or speech.

2. Lab Tasks
2.1 Under the supervision of instructor have a look inside the system box, understand the
role and usage of ports present at the back panel.

2.2 Make yourself familiar with Windows and its Components

The main components of Windows when you start your computer are the Desktop, My
Computer, Recycle Bin, Start Button, Taskbar, and shortcuts to applications. After opening an
application, you will also have a window with an active application which will appear in your
desktop and taskbar
 COMSATS Institute of Information Technology (CIIT)
Islamabad

2.3 Use Windows Explorer to understand the directory structure of different drives
present.
2.4 Practice making new folders, copy/ cut pasting of files.
2.5 Learn how to set new password for Login.
2.6 Try to change the wallpaper and screen saver.
2.7 Explore various applications installed in the Accessories tab present in the start
menu/ button.

Figure 1.8

3. Home Tasks

6.1. Try to search and download application of your choice from the internet.
6.2. Install the downloaded application.
6.3. Try to remove newly installed application, from add/ remove applications
option present in the control panel.
6.4. Swap the left and right mouse button, try to change the sensitivity of mouse
pointer and double click speed.
6.5. Change the picture used for Login purpose.
6.6. Place multiple copies of a file in various folders/ subfolders and then use
search option to search the file present at all locations.
6.7. Delete some file and try to restore from the recycle bin.
6.8. If you have a printer available at home, try to add the printer and make a test print.
 6.9. Learn how to create another user (another Login) for the same computer. What
are the options you can set for the new user?
6.10. Practice the following Windows common shortcuts (Fig. 9).

Figure 1.9

0
`
 Lab 02-04
Introduction to MS Word
Objective:
This lab will provide a hands-on experience of MS Word. Word is used for documentation. MS word is helpful
in ceartion of official docuemts, letters, and other similar materials.

Activity Outcomes:
The lab will teach students to prepare different text documents.
The students will be able to:
• Create a formal text document with different formatting
• Use different merging tools
• Inserting tables and images in text documents.

Instructor Note:
As a lab activity, read “MicroSoft ”official site for guilines.

1
`
2) Useful concepts:
Microsoft Word is very helpful tool to create a wide variety of professional documents quickly and easily. This
combination of ease of use and robust features makes it the go-to word processor in both homes and offices
today. It’s now also available for the Mac operating system as well as a web-based version through an Office
365 subscription.
You can also find templates to help you create the following:

• letter
• report or paper
• proposal
• newsletter
• brochure
• catalog
• poster
• flyer
• postcard
• sign
• banner
• resume
• business card
• invoice
• receipt
• product packaging
• mailing label

3) Solved Lab Activites

Sr.No Allocated Time Level of Complexity CLO Mapping
1 15 Low CLO-6
2 15 Low CLO-6
3 15 Low CLO-6
4 15 Low CLO-6

Activity 1:
Exploring MS Word document

Solution:

Title Bar
1. Note the title bar section which has window controls at the right end, as in other Windows programs.
2. Note that a blank document opens with a default file name of Document 1.

2
`
Quick Access Toolbar
The Quick Access Toolbar is located all the way to the left on the title Save Undo Customize
bar. It contains frequently used commands and can be customized
using the drop-down menu.
1. Point to each small icon to view its ScreenTip.
2. Be aware that the Undo button is not located anywhere else in the
application except for the Quick Access Toolbar.

3. Click the Customize Quick Access Toolbar button, click New Redo/Repeat
on the menu, and see the command get added to the Quick Access
Toolbar.

4. Click the Customize Quick Access Toolbar button again, and

click
Show Below the Ribbon. Click Show Above the Ribbon to move
the Quick Access Toolbar back again.

Ribbon
The ribbon contains all of the tools that you use to interact with your Microsoft Word file. It is located towards
the top of the window underneath the title bar. All of the programs in the Microsoft Office suite have one.
The ribbon has a number of tabs, each of which contains buttons, which are organized into groups. Depending
on the object you have selected in the document, several contextual tabs may appear, which provide additional
formatting options for the selected object.
Try clicking on other tabs to view their buttons (do not click the File tab yet), and
then return to Home tab. Switch to Word
Active Tab
By default, Word will open with the Home tab active on the ribbon. Note how the Active tab has a white
background and blue letters, and the Inactive tabs have the opposite.

Contextual Tab
Contextual tabs are displayed when certain objects, such as an images and text boxes, are selected. They contain
additional options for modifying the object. Contextual tabs stand out because they are darker in color and are
located to the right of all the other tabs. As soon as we start being productive in the program, we will see
contextual tabs appear.

3
`
Groups and Buttons
On each Tab, the Buttons (a.k.a. commands or tools) are organized into Groups. The groups have names,
but the names are not clickable.
Hover over some of the buttons on the Home tab to observe the ScreenTips. The ScreenTip displays the
name of the button, along with a short description of what the button does.

Buttons with Arrows

Note that some buttons have images on them and some have images and an arrow. The arrow indicates that
more information is needed to carry out the function of the button. Some arrowed buttons have two parts: the
button proper and the list arrow.
• A one-part arrowed button, called a menu button, will darken completely when you point to it:
1. In the Font group, point to the Text Effects and Typography button.
2. Note there is no difference in shading between the left and right of the button when you
point to each section.

• On a two-part arrowed button, called a split button, only one section at a time will darken when
you point to it.

1. In the Paragraph group, point to the left part of the Shading button. This is the
“button proper” section of the button. Note how it is darkened separately from the
arrow portion of the button.

2. Point to the right portion, the section with the arrow. This is the “list arrow” section
of the button. Note how it is darkened separately from the left portion.

3. The button proper is the section of a two-part button that will carry out the default
option or the last used option.

4. The list arrow section will open an options menu.

4
`
Dialogue Box Launcher

On some groups there is a launcher icon which will open a dialogue box or a side panel with related but
less common commands.
Click any Dialogue Box Launcher icon, and then close the dialogue box or side panel.

Ribbon Display Options button

This button provides options that will hide the Ribbon from view. The main benefit to this is that it allows
your document to take up more of the screen.
1. Locate the Ribbon Display Options button (to the left of the window control buttons).

2. Click on it. Three options appear.

3. Click Auto-hide Ribbon. This option essentially makes Word go into “full screen” mode. It hides not
only the ribbon, but also the Quick Access Toolbar, title bar, and Window Controls.

4. To get the ribbon to show after Auto-hiding it:

a. Point to the top-center of the screen and click. (Clicking the three dots does the same thing.)
The full ribbon can be seen and used. However, as as soon as the body of the document is clicked
it will hide again.

5
`
 b. Click in the middle of the document. Notice how the ribbon hides again.
5. To get a partial display of the ribbon to stay in view:
a. Click the “mini” Ribbon Display Options button on the top right.

b. Click Show Tabs. Note this option has brought back our Quick Access Toolbar, title bar,
Window Controls, and part of the ribbon; only the Tabs are visible. The buttons are not.
c. Click the Home tab. Notice how the buttons come into view.
d. Click in the middle of the document. Notice how the buttons disappear again.

Note: A shortcut for changing to the “Show Tabs” view is to double-click the Active Tab. If the
buttons in the ribbon suddenly disappear, then you may have done this by accident.

6. To get the entire ribbon to stay in view:

a. Click Ribbon Display Options
b. Click Show Tabs and Commands. This option keeps entire ribbon visible at all times. It is
the default option. We will keep this option selected for the remainder of class.
Dynamic Resizing
If you use Word on other computers, be aware that the button placement on the ribbon might look slightly
different. For instance, a button might be a different size or be positioned in a slightly different place. The
reason for this is that the ribbon auto-adjusts itself based on the size of the Word window.
1. On the Home tab notice what the buttons in the Editing group currently look like.

2. Click Restore Down to shrink the size of the Word window.

6
`
3. Notice how the group looks different now. The entire group was collapsed into a single button. Click
on the button to reveal the contents of the group.

4. Click Maximize to bring the window back to full screen.

File Tab
The File tab provides a Backstage view of your document. The Backstage view exposes information and
metadata about the currently active document, lists recently opened documents, and provides a variety of user
options, such as opening, saving, and printing. Instead of just a menu, it is a full-page view, which makes it
easier to work with.
1. Click on the File tab.

2. Notice that the ribbon and the document are no longer in view. Note the commands, listed on the left
side of the screen, are ones you would use to perform actions TO a document rather than IN a document.

3. Other things you can do in the Backstage view:

a. Click the Info tab. The Info section of the Backstage view offers an easy to use interface for
inspecting documents for hidden properties or personal information.

b. Click the New tab. In this section you can create a new Blank document, or choose from a large
selection of Templates.

c. Click the Open tab. The Open section is used to open existing files on your computer.
i. It immediately presents you with a list of documents that you have recently opened, so
you can quickly find and open them again. (This is disabled in the computer lab.)

ii. Clicking Browse opens a File Explorer dialogue, which allows you to find the file on
your computer. We will be using this option in class.

d. Click the Save As tab. This section allows you to save your file.
4. To return to the document from the Backstage view, click the large, left pointing arrow in the top-
left corner of the screen.

7
`
Workspace
Underneath the ribbon is the workspace.
1. Note the rulers and margin settings.
2. Note the scroll bar on the right side of the screen.
a. If the scroll bar is not visible, move the mouse and it will come into view.
3. Note the blinking cursor/insertion point, which is where new input will display when entered.
a. If the insertion point is not blinking, move the mouse and it will start blinking.
4. Point somewhere on the blank page and note the mouse cursor with the I-beam shape, appropriate for a
text environment.

Status Bar
The Status bar is located below the document window area.

Current Information
The left end displays a variety of information about the document, such as the page number, how many total
words are in the document, and whether there are any spelling errors.
Views
At the right end are shortcuts to the different views that are available. Each view displays the document in
a different way, allowing you to carry out various tasks more efficiently.
Displays the document full-screen, making it easier to read. You cannot
Read Mode edit the document in this view.

Shows what the document looks like when it’s printed. This is overall the
Print Layout best view for editing documents. It is selected by default.

Shows what the document would look like if it were saved as a webpage.
Web Layout

Zoom Slider
Also at the right end of the Status bar is the Zoom Slider. This allows you to adjust how large the document
is displayed on the screen. It does not adjust the actual size of the document—just how big or small it is
displayed on the screen (like moving a newspaper away from or closer to your eyes).

Customization
The Status bar can be customized.

1. Right-click on the Status bar to bring up the customize menu. Options that are enabled have
a checkmark next to them.

2. Click on “Line Number” to enable this option.

3. Notice how the menu didn’t disappear. Click in a clear space to dismiss the menu.
4. Notice how “Line: 1” appears in the Status bar.

8
`
 9
`
 Creating a document
1. When Word opens, it will display a blank document ready for you to type in. The words that you
type and the formatting that you use become your document.

2. Type “My first document”.

3. Each document you create is temporary unless you save it as a file with a unique name and
location.

Preparing a Save to Location – a USB Device

Note: Home students can skip this section.

When we save a Word document, all the data in that document is collected and saved as a file.
Normally files are saved on a computer’s hard drive, but due to security restrictions on computer lab
machines, files must be saved on removable storage devices.

2. Fit the connector into the port and push it in gently.

3. At this point, you may get a notice that the computer is installing a device driver – wait until the

Show Slide 4
message disappears.

4. A notification may appear in the bottom-right corner of the screen, asking what you want to do with
the flash drive. Close it by pointing to it and clicking its Close button.

You are now ready to begin saving your file.

Saving the File

1. Click the File tab.

2. Click Save As. We use “Save As” instead of “Save” the first time we save a file because we
need to tell the computer where to put the file (the file doesn’t have a “home” yet).

10
`
 “Save” assumes you’ve saved it before.
3. Click Browse.

4. Notice that a smaller window appears in front of our work. This small window is called a
dialogue box. Because the computer needs to know more than just “OK, save,” the dialogue box
is where we tell it how we want to save our work.

Address field

Dialogue Box
Title
Will be either “Save
As” or “Open”

Navigation Pane
Content Pane

The default
save location is
“Documents”
“ Save ” or “ Open ” Button

File Name Field

5. When it comes to saving, there are two important things to identify for the computer:

1. The location where the file is going to be saved to.

2. What name you want to give the file.
6. The location where it will be saved is displayed for us in the Address field. In this case, note
that the Documents directory is the default save location, but we want to save our file to the
flash drive.

7. Notice other available folders and devices can be seen in the left pane, called the Navigation
pane. If we wanted to save to one of these alternate locations, we would have to click on it.

8. Find the location labeled KINGSTON (E:) and click it. Kingston is the name of the company
that created our flash drive.

Note: If you are taking this class from home and do not have a
flash drive, use “Documents” as the location to save your files.

9. Your address field should now read This PC > KINGSTON (E:).

11
`
10. Now we need to name our file. Notice that the file name field is towards the bottom of the
dialogue box. By default, Word names the file after the first few words that were typed into the
document.

11. Click into this box and the words will be highlighted. Then type the word first to name your
file
‘first’.
12. Once we have given the computer a file name and a save location, we are ready to save. At this
point, your Save As dialogue box should look like the image below. To save, you will click
Save.

13. Your Word window will still be open but notice the title bar will now show the file name
first.docx.

Activity 2:
Controlling the Appearance of your Document

12
`
Solution:
Changing Page Margins
1. Click the Layout tab to access tools to change the appearance of your document.
2. In the Page Setup group, click Margins. A list will appear that will have your current settings
highlighted. Click Wide to see how it will affect your document.

3. Click Margins again and click Custom Margins at the bottom of the list.
a. When the Page Setup dialogue box opens, on the Margins tab, in the Margins
section click the arrows to change the top, left, bottom and right margins to 0.8”.

b. The Gutter setting is an extra margin that is only used if you want to bind your
printed pages together in some way (such as with a three-hole-punch). Leave this
at 0”. c. Click OK.

4. In the Page Setup group, click Margins again and notice how the margin list has now populated
with your customization.

Page Breaks
1. Place your insertion point at the end of the blue paragraph.
2. On the Insert tab, find the Pages group and click Page Break.

3. Notice how the lines below are now on the next page.
4. Notice how Word has inserted some blank space at the top of the next page.

5. Tap the Delete key to remove this extra space.

Good stopping point for Session 1.

Close “Internet Policy.docx” and save the changes.

13
`
 Describe how the Exercise is organized: The parts in
parentheses are hints concerning how to complete each
step.

Headers and Footers

A header is text that appears at the top of every page in your document. Similarly, a footer is text
that appears at the bottom of every page.
1. First, let’s insert a header.
a. Open Internet Policy.docx.

b. Tap Ctrl + Home to get to the top of the document.

c. Click the Insert tab. In the Header & Footer group, click Header to open a list of
different header options.

d. Scroll down the menu to view all the options and click Blank.
e. Notice that a new contextual ribbon has opened called Header & Footer Tools. It has
one tab - Design.

f. Notice how Word is calling out the header section with a dotted-line.
g. Notice the words “Type here” enclosed in brackets on the left. This is a placeholder
for an area of the header into which we can enter content. It is colored gray, which
means it is already selected and ready for us to populate it with content.

h. Type “Internet Policy”.

2. Close header. This can be done in two ways:

a. On the Header & Footer Tools contextual ribbon, on the Design tab, click Close
Header and Footer.

b. By double-clicking anywhere within the body of the document. (We’ll try this in a
minute)

3. Scroll down and notice that “Internet Policy” appears at the top of every page.

4. Also notice that the font color of the text in the header is light gray. This is not the actual font
color. Microsoft Word makes the header text display in light grey to show that the header is not
currently active.

5. Double-click on the header to make it active. Notice how the font color has changed to its real
color (black) and the document body text is now dimmed. Again, this is to show that the
header/footer is active, and the document body is not active.

6. Next, let’s insert a footer.

a. Note that, when the header is active, the footer is active as well. Scroll down to the
bottom of the current page and notice that there is a Footer section called-out with a
dotted-line.

14
`
 b. On the Header & Footer Tools contextual ribbon, on the Design tab, locate the Header
& Footer group. Click Footer to open a list of different footer options.

c. Again, scroll down the list to view all the options and then click Blank (Three
Columns).

d. What we’re going to do is, put our name in the left placeholder, the current date in the
center placeholder, and the page number in the right placeholder. There are tools on the
Header & Footer Tools contextual ribbon to facilitate this.

e. Click on the left placeholder to select it and type your name. Do not tap Enter .

f. Let’s make our name bold. How would we do this? Because there is no Bold button
visible, we have to switch to another ribbon. Click the Home tab, locate the Font group
and click
Bold. (no need to highlight the name)
g. Note how our Header & Footer Tools contextual ribbon is no longer active since we
switched to the Home tab. To bring the Header & Footer Tools contextual ribbon back,
click on its Design tab.

h. Click on the middle placeholder in the footer to select it. On the Header & Footer Tools
ribbon, locate the Insert group and click Date & Time. When the dialogue box opens,
click any date format you wish under the Available Formats in the left pane.

i. Note the empty checkbox that says “Update automatically”. This would need to be
checked if you want the inserted date to change to the current date every time you open
this document.

ii. Click OK.

i. Click on the right placeholder. On the Header & Footer Tools ribbon, locate the
Header & Footer group and click Page Number. A list of options will be shown about
where you want to insert the page numbers (see table below).

Top of Page Puts the page number in the header.

Warning: This will replace your entire header with
a new header!

Warning: This will replace your entire footer with

a new footer!

Page Margins Puts the page number in the left or right margins.

Current Position Puts the page number wherever your insertion point is.

Bottom of Page Puts the page number in the footer.

j. Move your pointer to Current Position and a list of options will open. Scroll down the
list to the “Page X of Y” section and click Bold Numbers.

15
`
 k. Double-click in the body of the document to close the Header and Footer Tools.
Adding Visual Interest
1. Changing the Page Background:
a. On the Design tab, in the Page Background group, click Page Color to display a palette
of colors.

b. Mouse-over the colors and observe Live Preview changes to your document.
c. Click a color that is fairly dark (fourth row of Theme Colors).

Tip : The document’s text color

automatically changes to white when
a dark background color is select.

2. Adding a Watermark:
a. On the Design tab, in the Page Background group, click Watermark to see a list of
semi-transparent messages that can be added to your document. Click on one of the
messages and note it’s insertion into the document. These messages will be printed
should you print the document.

b. You can also customize the watermark text. Click Watermark again and click “Custom
Watermark”. In the Printed Watermark dialogue box, find the Text field, click into it,
delete the existing text, and type some different text. Click OK.

16
`
 What’s the difference between the
“Apply” and “OK” buttons?

Apply will commit your changes

and keep the dialogue box open .
OK will commit your changes and
close the dialogue box.

3. Adding a Page Border:

a. To place a border around your document, on the Design tab, in the Page Background
group, click Page Borders. A Borders and Shading Dialogue Box will open.

b. In the Borders and Shading Dialogue Box, on the Page Border tab, there are options
for customizing a border. As you click on different settings, styles, colors, etc. in the left
and center panes, note a preview in the right pane.

c. In the Borders and Shading Dialogue Box, on the Page Border tab, in the left pane,
click on the Box setting.

d. In the Borders and Shading Dialogue Box, on the Page Border tab, in the center pane,
in the Art drop-down list box, click the drop-down arrow. Scroll down and click a border
style that you like. Click OK to add the border.

e. Note that, depending on how large the border is, it may cover up your header and/or
footer. To fix this, you can adjust the distance between the edge of the page and the
header/footer.

i. Double-click on the header to make it active.

17
`
 ii. On the Header & Footer Tools contextual ribbon, on the Design tab, in the Position
group, there are two text boxes:
1. The top one controls the distance between the header and the edge of
the page.

2. The bottom one controls the distance between the footer and the edge
of the page.

iii. Increase the values in both of these text boxes until you can see your header and
footer. Note – you will need to click into the footer before you adjust the bottom
control.

Save the document and then close Word.

Activity 3:
Inserting Online Pictures, Shapes, Text Boxes, and Other Pictures:

Solution:
The insertion of specialized objects into a document can add visual interest. We will explore a few
different types of objects in this section and also learn how to format the objects.

Online Pictures
The former name for this type of object was Clip Art. Clip art are small pictures and symbols made
available for computer users to add to their documents. They can be used to enhance a narrative.
Inserting Online Pictures

1. Click in a clear area underneath the table to move your insertion point off of the table.

Teacher’s note:
If the student’s table is too far down the page, the cursor will get stuck above the table. If this
happens, the student can double-click below the table to place their insertion point there.

2. On the Insert tab, in the Illustrations group, click Online Pictures.

3. A dialogue box opens that prompts us to enter a search term.

18
`
4. Note the words Bing Image Search. Microsoft Word will search the Internet for images using
its search engine, Bing (it is a competitor to Google).

5. Type helmet in the search field and tap . Enter

6. Note the gray checkbox labeled “Creative Commons only”. Word has filtered the search results
to only show images that are licensed under Creative Commons licenses.

a. What is Creative Commons? It is a type of copyright license that is frequently used on

the internet. In general, it is a liberal license that gives you permission to use the image
for free.

b. HOWEVER, Creative Commons allows content creators to add “gotchas” such as

“cannot use for commercial purposes” or “must provide attribution to the original
author”. MICROSOFT WORD DOES NOT SHOW YOU THESE. So, at the end of
the day, it is up to you to verify that you are abiding by the author’s SPECIFIC license
terms—and finding the specific license terms is not always an easy task.

c. For this reason, if you are planning to use clip art for any professional purpose, we
recommend using a clip art website that contains only public use images. One such
website is pixabay.com. Public use images give you complete control over how you
may use them. Later in the lesson we will learn how to insert a picture from pixabay.com
into a Word document.

d. Another alternative is to purchase clipart (also called “stock images”). This is how
businesses typically obtain clip art.

7. Find a picture you like.

8. Point to the image.
9. Click on the three dots in the bottom-right corner of the image. A screen tip appears above the
image containing additional information about the image, including its pixel dimensions and
Internet URL.

19
`
 10. Click in a clear space to dismi ss the screen tip.

11. Now, we will insert the image into our document.

a. Click on the picture to select it.
b. Notice the checkmark that appears in the top-right corner of the picture.
c. Notice how the Insert button indicates that one picture is selected. d. Click Insert (1).

Resizing Inserted Objects

Objects can be resized by using “handles” that appear around a selected object.

20
`
 Rotate

Layout Options

Resize proportionally

Adjust the width only

Adjust the height only

1. If you cannot already see a border and small circles around your picture, click on the picture to
select it.

2. Point your mouse to one of the circles. These circles are called resizing handles. Notice the
pointer shape changes to a white arrow with two ends. As we learned before, this is a resizing
cursor.

3. Using one of the corner circles, click and drag towards the center of the picture and note it
resizes the picture proportionately. This does not always work with other types of objects. Other
objects require you to hold down while resizing to retain the original proportions.
Shift

Warning: Increasing the size of an online picture can result in a distorted look when
printed. To avoid this, try not to make an online picture any larger than it was when
you originally inserted it into the document.

4. Click and drag from one of the side circles and note the change in shape of the picture. These
circles do not resize the picture proportionally. Click Undo.

5. Click and drag the circular arrow icon above the picture note how the picture rotates. Click
Undo to get it back to its original rotation.

6. Using the rulers on the top and left edges of document as a reference, resize the object
proportionally to approximately 1 ½” square.

7. Deselect the object by clicking in a blank area.

Applying Wrapping Styles
“Objects can be placed in your document in two ways: either inline or floating. Inline objects are
those that reside on the same layer as your text and are positioned within the stream of text that
surrounds the object. Floating objects are those that are placed on a layer over the text”. –Allen Wyatt
This positioning of objects is called the text wrapping style. The wrapping style can affect how
difficult it is to move an object on the page. If it seems difficult to move an object where you want to,
then you may need to change the wrapping style:

21
`
1. Select the picture object and move your pointer around on it until you see a Move cursor shape.
2. When you see this cursor, click and drag. You should notice that it is hard to move the object.
We need to change the wrapping style so it is easier to move. The default wrapping style for
pictures is In Line with Text, which means that only text can move it around. This can be very
restricting.

3. Click Layout Options to the right of the selected object.

a. It presents you with a set of icons, each of which represent a wrapping style.
b. You can get an idea of what each wrapping style does by looking at the icons. The blue,
horizontal lines represent your document’s text, and the gray arch represents the image.

c. Point to the icons to see a ScreenTip containing their names. Click In Front of Text.

4. Notice the small “anchor” symbol that has appeared after we changed the wrapping style to a
“floating” style. This is called an object anchor and it indicates where a floating object is located
in relation to the text in your document. If we were to insert multiple lines of text somewhere in
our document above the anchor, it would cause our object to get “bumped” down, even though it
is floating.

5. Using the move cursor, move your object slightly to the left. You should see a green line appear.
This green line helps you to align your object against the left margin of the document.

6. Move the object so it is on top of the last column in your table.

7. Notice how there are now two contextual ribbons: Table Tools and Picture Tools. This is
because our picture object is selected and it is on top of the table.

a. Picture Tools has one tab: Format

b. Table Tools has two tabs: Design and Layout

22
`
Applying Formatting to Pictures

1. Click the picture to select it if it is not already selected.

2. On the Picture Tools contextual ribbon, click the Format tab and, in the Picture Styles group,
move your pointer over the predefined Picture Styles thumbnails to see a Live Preview of their
effects.

3. Click the More button to see more predefined styles. As you point to the different styles note the
ScreenTips that appear which contain the name of the style. Click on the Metal Oval style.

4. In the Picture Styles group, click on Picture Border and click on any color that you like.
5. Deselect the picture.

Shapes
A shape is another type of object that can be inserted into a Word document.

Let’s insert an arrow shape into our document.

1. On the Insert tab, in the Illustrations group, click Shapes. A menu of shapes will open. The
shapes are organized by type of shape.

2. In the Line section, mouse over the line shapes until you see a ScreenTip that says Double Arrow
. Click the shape.

3. Find your mouse cursor in the document and note that it is shaped like a crosshair .

4. We are going to “draw” an arrow from our helmet picture to the word “Monday” in our table.
a. Point to the helmet picture.

b. Click and drag to the word Monday.

23
`
 c. Let go of the mouse button.
5. Note the arrow is selected. You can tell by the resize handles at the ends.

6. With the arrow still selected, note the Drawing Tools contextual ribbon. It has one tab:
Format. Click the Format tab.

7. In the Shape Styles group, click Shape Outline. Point to Weight and, on the sub-menu, click 6
pt.

8. Click Shape Outline again. Mouse over the colors to see a live preview on your arrow. Click a
color to select it.

9. Point your mouse at the body of the arrow until you see a Move cursor. Click and drag to move
the arrow to another place.

10. Deselect your arrow.

11. Insert your cursor beneath the table.

Tip: To change the default line styling that is used when you create a new line, right-
click on the line whose style you want to make the default and click “Set as Default
Line”.

Next, we will insert a star shape.

1. On the Insert tab, in the Illustrations group, click Shapes.

2. In the Stars and Banners section, mouse over the shapes until you see 5-point Star and
click it.

3. Find your cursor in the document and note that it is shaped like a crosshair .

4. Click next to the insertion point and drag diagonally down and to the right. Don’t let go of the
mouse until the star until it is about 3” square (use the document rulers as a guide). Let go of the
mouse button when you finish dragging.

5. Remember that as long as you don’t let go of the mouse button, you have full control over the
size and shape of the drawing.

Tip: Using the corner resize handles on a shape will NOT resize the shape proportionally,
like with clipart. To resize a shape proportionally, you must hold down Shift while
resizing.

5. Find the move cursor on the star object and move the star to the .Use right side of the document
the green line to align it to the right margin of the document.
6. On the Drawing Tools contextual ribbon, on the Format tab, in the Shape Styles group, click
More to see a gallery shape styles that could be used. Mouse over these Quick Styles to see a
live preview of the different styles. Scroll down the gallery and click a quick style in the last
row.

24
`
Clicking between objects may make tabs inactive

1. Click on the helmet object again. Note that your star shape object has become deselected and the
Drawing Tools contextual ribbon associated with it has disappeared.
2. Note that two contextual ribbons now appear; one associated with the online picture object
(Picture Tools) and one with the table (Table Tools). However, none of the tabs on either
contextual ribbon are active.

3. Click on the Design tab and note the background color of the tab is white. This is how you can
tell it is active.

4. Click on the star object again. Note that while the Drawing Tools contextual ribbon may appear,
its Format tab might not be active. If you don’t see the tools you expected to see, you may have
to click on the tab to activate the tool selection.

Text Boxes
A text box is a freestanding object that can contain words. Let’s insert a text box.
1. Deselect the star object.
2. Click on the Insert tab. In the Text group, click Text Box. A menu of Built-in text box styles
will appear. However, to have more control over format, placement and size, we will draw our
own text box. Click Draw Text Box.

3. Click into your document where you want the text box to start and drag diagonally and to the
right to where you want it to end.

4. The insertion point within the text box indicates that what you type will be inserted there. Type
your name.

5. Resize the text box to just fit around your name.

6. To move your text box, make sure it is selected, then move your pointer to the edge of the box
until a move cursor appears . Then click and drag your text box to the center of the star
shape.

7. Note that the text box has a black border and it is also filled with white color.
8. You can change formatting of the text box by using tools on the Drawing Tools contextual
ribbon.

a. With the text box selected, on the Drawing Tools contextual ribbon, click the Format
tab. In the Shape Styles group, click Shape Outline, and click No Outline.

25
`
 b. Next, In the Shape Styles group, click Shape Fill and click No Fill. Deselect the text
box.

Other Pictures
In addition to inserting pictures via Online Pictures, you can also insert images of your own into a
document. These images can be ones that you’ve made yourself (like photos taken with a camera) or
ones that you’ve downloaded from the Internet. We have placed a couple of pictures on the flash drive
for you to use in this section.
Inserting a Picture

1. Open a new blank Word document.

2. Click the Insert tab. In the Illustrations group, click Pictures.
3. In the Insert Picture dialogue box, navigate to the flash drive and click Orchid.jpg.

4. In the dialogue box, click Insert.

Color Effects and Artistic Effects

1. To prep for this section, let’s move our picture to the right side of the page. See if you can
remember how to do this. This is an important thing to know!

a. Change the Text wrapping style to “In front of text”.

b. Click and drag your picture to the right side of your document.
2. On the Picture Tools contextual ribbon, on the Format tab, find the Adjust group, and click on
Color. Mouse over the coloring effects that could be applied to your picture.

3. Click on the title bar to dismiss the gallery.

4. In the Adjust group, click on Artistic Effects and mouse over the artistic effects that could be
applied to your picture.

5. Click on the title bar to dismiss the gallery.

Remove Background Effect

1. To prep for this section, we are going add a dark background color to the document.
a. Click on the Design tab, and in the Page Background group, click on Page
Color. b. Click a dark color.

Note: By default, Word will not print a page’s

background color because of the amount of ink
required.

2. On the Picture Tools contextual ribbon, click the Format tab and, in the Adjust group, click
Remove Background. Your picture will look like the picture below. Also, a new contextual tab
named Background Removal will open.

26
`
3. On the Background Removal tab, in the Refine group, click Mark Areas to Keep.
4. The pointer will change to the shape of a pencil when you point to the picture. Use the tip of
the pencil to “click away” the bright pink sections.

5. In the Close group, click Keep changes.

6. Deselect your picture.
Crop Picture Effect

1. Open a new blank Word document.

2. Insert another picture from your flash drive. It is named red-roses-photo.jpg.

3. On the Picture Tools contextual ribbon, on the Format tab, find the Size group and click on the
list arrow part of the Crop split button.
4. Point to Crop to Shape. In the Basic Shapes section of the Shapes menu, click Heart .

Format Painter
The Format Painter is used to copy the formatting of a piece of text or picture and apply it to
something else. For instance, in the case of text, the formatting would be the font face, size, and color.
We will use the Format Painter to apply the formatting of one object to another.
1. Deselect the red roses object which we just cropped to a heart shape (click the right margin).
2. Insert the Orchid.jpg picture from your flash drive again.
3. Resize each object proportionally (use the corner handles) until they appear side by side. (make
them about 3” wide).

4. Select the red roses object.

5. Click the Home tab and in the Clipboard group, click Format Painter.

27
`
6. Move the mouse pointer around the screen. Notice how the mouse cursor has changed to an
arrow with a paintbrush next to it.

7. Click on the orchid object that you just inserted. Notice how it now has the same cropped shape
as the red roses object.

8. Deselect the orchid object and note your cursor shape has returned to an I-beam shape.
Double-clicking Format Painter makes it possible to apply a format to more than one object. Let’s
try it.
1. Insert your cursor to the right of the orchid object and tap . Enter

2. Search for Online Pictures pictures using the search term flowers.
3. In the search results, locate two pictures of flowers that do not have white backgrounds. Since
the search dialogue allows the insertion of multiple objects at one time, click each of the two
pictures and then click Insert.

4. Resize each image so they are each about 3” in width.

5. Click one of the objects that is formatted with a heart shape.
6. Double-click Format Painter.
7. Click on one of the flower objects and notice it adopts the heart-
shaped format.

8. Deselect the flower object and notice that the cursor does not
change back to an I-beam.

9. Click on the second flower object and notice it adopts the heart-
shaped format.

10. In order to “turn off” the Format Painter, single-click on its button in the Home ribbon.

28
`
Inserting a Picture from a Webpage
You can also insert images from a webpage into your document. However, be aware that many
images on the internet are protected by copyright. When you find an image you like, you should
read the website’s fine print to determine if you can use the image or not. This is especially important
if you are making a presentation for commercial purposes (for example, as part of your job).
1. Open a new, blank document.
2. Using the Start Menu, open Firefox.
3. Click into the address bar at the top of the screen and type www.pixabay.com. Pixabay is a
website that contains images that you can download and use for free, without restriction.

4. Type “healthy food” into the search box and tap . Enter

5. Click on an image you like (except for the ones in the first row—those cost money).

6. On the next screen, notice the copyright notice on the right. It says “CC0 Creative Commons”.
This means you can use the image however you want. You don’t even have to give the original
author credit.

7. Right-click in the middle of the image and select Copy Image.

Tip: If you’re planning on printing the document, it’s best to use a high-resolution version
of the image. To do this, click the green “Free Download” button on the right. This will
download an image file to your hard drive. Then, follow the instructions found in the
“Inserting a Picture” section to insert the image file into the presentation.

8. Using the taskbar, switch back to Word.

9. In the Home tab, in the Clipboard group, click the Paste button proper.
10. Close Firefox.

Activity 4:

29
`
Using of Mail Merger:

Solution:
Mail merge is a feature of Word processing programs that enables you to generate form letters. Form
letters are sent out en masse to people where much of the letter is the same for each recipient. What
changes in the letter are the recipient’s name, address, and maybe certain other items specific to each
recipient.
To use a mail-merge system, you would first create a data file with a set of information, like a list of
names and addresses. In a Word document, you would create a sample letter, substituting special
symbols in place of names and addresses (or whatever other information will come from the first file).
Through a series of small steps, you can create form letters that are personalized for each recipient.
The data file can be created with various programs such as Word, Excel, or Access. The beauty of the
mail merge feature is that, while you can create your own data source in Word, if you already have a
spreadsheet of data created in Excel or some other program, it makes sense to use that.

Steps to Create a Mail Merge Document

1. To save time, we have already created a data file in Excel and a sample letter in Word and placed
them on your flash drive.

a. Insert your flash drive.

b. Use File Explorer to open Donations List.xlsx.

c. Use File Explorer to open merge letter.docx.

2. Before we start the mail merge process, let’s look at the donations list that was created in Excel.

a. Notice that the list is on the worksheet named Sheet 1.

b. Notice that the first row of the worksheet contains headings.

c. Close Donations List.xlsx

3. In merge letter.docx, notice that the address of the establishment, the body of the letter and the
closing are all in place. We will use mail merge to personalize each letter with an address block,
a salutation, and a donation amount for each person in our list.

4. Click the Mailings tab.

5. Find the Start Mail Merge group. Click Start Mail Merge and then click Step-by-Step Mail
Merge Wizard.

6. A Mail Merge pane will open on the right that will take you through the mail merge process in
6 steps.

30
`
7. Step 1 - Notice Select document type prompt. By default, the radio button for letters is checked,
which is what we want. Click on Next: Starting Document at the bottom of the Mail Merge
pane.

8. Step 2 - Notice the Select starting document prompt. Since we will be using this letter, do not
change the default selection of use the current document. Click on Next: Select Recipients at
the bottom of the Mail Merge pane.

9. Step 3 - Notice the Select recipients prompt

a. The default selection, Use an existing list is the one we need. To find the list, click on
the Browse button.

b. A Select Data Source dialogue box will open. Navigate to your flash drive and open
Donations List.xlsx

c. A Select Table dialogue box will open. We need to provide some information about our
document.

i. Notice that by default, Sheet 1 is selected.

ii. Remember that when we examined our Excel file our data was on the
Worksheet entitled Sheet 1.

iii. Also be sure that the check box before First row of data contains column
headers is checked.

iv. Click OK.

d. A Mail Merge Recipients dialogue box will open which will allow you to review, delete
or change your list. Since we are not making any changes, click OK.

e. Click Next: Write your letter at the bottom of the Mail Merge pane.

31
`
10. Step 4 - Notice the Write your letter prompt. Since we are using an existing letter, we merely
have to click into a location within the letter to insert different items.

a. Place your insertion point below the return address for the Animal Shelter, then click
Address block in the Mail Merge pane.

b. An Insert Address Block Dialogue box will appear with a preview of how your address
block will look in the letter. If you select a different format, your preview will change.
Make no changes. Click OK.

c. Notice how the text «AddressBlock» has appeared. This will be replaced with an actual
address when we complete the mail merge.

d. Place your insertion point below the address block and click Greeting Line in the Mail
Merge Pane.

e. An Insert Greeting Line dialogue box will appear to allow you to control the way you
want your greeting to appear.

i. Click on the list arrow next to the box that reads “Mr . Randall” and click
“Joshua”. This will use the person’s first name as the greeting.

ii. Click OK.

f. Within the body of the letter, place your insertion point immediately after the words
contribution of in the first sentence. Click on More items in the Mail Merge pane.

g. An Insert Merge Field dialogue box will appear.

i. Click donation

ii. Click Insert.

32
`
 iii. Click Close.

h. Be sure that there is a space before and after «donation».

i. Click Next: Preview your letters at the bottom of the Mail Merge pane.

11. Step 5 – Notice the Preview your letters prompt.

a. The letter to the first person on your list will appear.

b. Use the arrows to scroll through each succeeding letter.

c. Notice how the addresses and greeting are all clumped together. Let’s insert some blank
lines to separate them. Even though only one person’s letter is showing, these changes
will affect each letter.

i. Click at the end of the first zip code of the first address and press Enter

. ii. Click after the second zip code and press . Enter

d. Notice that there is no $ before the donation amount in your letter. Place your insertion
point directly before the donation amount, and type a $. This change will affect each
letter.

33
`
 e. Click Next: Complete the merge at the bottom of the Mail Merge pane.

12. Step 6 – Notice the choices on the Complete the merge prompt.
a. Click on the Edit individuals letters choice.

b. This will open a Merge to New Document dialogue which allow us to merge all our
records into a specific new document, separate and apart from the merge letter.docx,
rather than just printing the letters out, so that in future we can have a record of to whom
we sent letters. Click OK.

c. A new document called “Letters1” opens with each letter on a separate page.

d. Scroll down the document to see the other pages.

e. Save your file as Fall Thank You Letters. Close the file.

f. Click Print in the Mail Merge pane. The Merge to Printer dialogue box will open
allowing you to select which records you wish to print letter for. Be warned: This option
sends the records directly to the printer without showing you a print preview.

g. We will not be printing. Click Cancel.

h. Close Word. Do not save changes to merge letter.docx.

Steps to Use Mail Merge for Address Labels

1. To save time, we will use Donations List.xlsx again.

2. Open a new Word document

3. Click the Mailings tab.

4. Find the Start Mail Merge group. Click Start Mail Merge to open the menu and then click
Step-byStep Mail Merge Wizard.

5. A Mail Merge pane will open on the right that will take you through the mail merge process in 6
steps.

6. Step 1 - Notice Select document type prompt. By default, the radio button for letters is checked,
check the radio button next to Labels. Click on Next: Starting Document at the bottom of the
Mail Merge pane.

7. Step 2 - Notice the Select starting document prompt. Accept the default selection of Change
document layout. Click Label Options.

a. A dialogue box will open allowing you to select the type of printer (dot matrix or laser), the
type of label product (such as Avery), and the product number.

b. Click Avery US Letter and product number 15513 for this lesson.
c. Click OK. (If you are using a custom label, click Details, and then type the size of the
label.)

34
`
 d. Click on Next: Select Recipients at the bottom of the Mail Merge pane.
8. Step 3 – Select recipients prompt

a. The default selection, Use an existing list is the one we need. To find the list, click Browse.
b. A Select Data Source dialogue box will open. Navigate to your flash drive and open
DonationsList.xlsx

c. A Select Table dialogue box will open. We need to provide some information about our
document. Notice that by default, Sheet 1 is selected. Remember that when we examined
our Excel file our data was on the Worksheet entitled Sheet 1. Also be sure that the check
box before First row of data contains column headers is selected. Click OK.

i. A Mail Merge Recipients dialogue box will open which will allow you to review, delete
or change your list. Since we are not making any changes, click OK.

d. You will now see that the first label is blank and every other label has «Next Record». This
is because the first label begins on the first record. The other labels must be instructed to
move on to the next record.

e. Click Next: Arrange your labels at the bottom of the Mail Merge pane

35
`
9. Step 4 – Arrange your labels prompt

a. Scroll to the left and notice the insertion point is in the first label.
b. Since these are address labels, click Address block.
c. An insert address block dialogue box will appear allowing you to make the same kinds of
choices as is the merge letter above. Click OK.

d. Notice how «Address» gets inserted into only the first label.
e. Under the Replicate labels prompt, click Update all labels. This causes the address block
to propagate into the other labels.

f. Click Next: Preview your labels at the bottom of the Mail Merge pane
10. Step 5 – Notice the Preview your labels prompt
a. Check your labels
b. Click Next: Complete the merge at the bottom of the Mail Merge pane.
11. Step 6 – Notice the choices on the Complete the merge prompt.
a. The same options apply as for Merge letters above.

Steps to Use Mail Merge for Envelopes

1. To save time, we will use Donations List.xlsx again.
2. Open a new Word document
3. On the ribbon, click on the Mailings tab.

4. Find the Start Mail Merge group. Click Start Mail Merge to open the menu and then click Step-
byStep Mail Merge Wizard.

5. A Mail Merge pane will open on the right that will take you through the mail merge process in 6
steps.

6. Step 1 - Notice Select document type prompt. By default, the radio button for letters is checked,
check the radio button next to Envelopes. Click on Next: Starting Document at the bottom of
the Mail Merge pane.

36
`
7. Step 2 - Select starting document prompt. Accept the default selection of Change document
layout. Click on Envelope Options.

a. A dialogue box will open allowing you to select the envelope size, the type of font and
position. Select Size 10 (the default setting) for this lesson. Click OK.

b. Click on Next: Select Recipients at the bottom of the Mail Merge pane.
8. Step 3 – Notice the Select recipients prompt
a. The default selection, Use an existing list is the one we need. To find the list, click Browse.
b. A Select Data Source dialogue box will open. Navigate to your flash drive and open
Donations List.xlsx

c. A Select Table dialogue box will open. We need to provide some information about our
document. Notice that by default, Sheet 1 is selected. Remember that when we examined
our Excel file our data was on the Worksheet entitled Sheet 1. Also be sure that the check
box before First row of data contains column headers is selected. Click OK.

j. A Mail Merge Recipients dialogue box will open which will allow you to review, delete
or change your list. Since we are not making any changes, click OK.

37
`
 d. Click on Next: Arrange Your Envelope at the bottom of the Mail Merge pane.
9. Step 4 – Notice the Arrange your Envelope prompt
a. The insertion point will be located where a return address should be placed. Most
businesses will have preprinted envelopes. If yours do not, type your return address.

b. Click around in the center of the envelope towards the bottom until a text box appears.
c. Click Address block in the Mail Merge pane.
d. An insert address block dialogue box will appear allowing you to make the same kinds of
choices as in the merge letter above. Click OK.

e. Click Next: Preview your envelopes at the bottom of the Mail Merge pane.

10. Step 5 – Notice the Preview your envelopes prompt

a. Check your envelopes.
b. Click Next: Complete the merge at the bottom of the Mail Merge pane.
11. Step 6 – Notice the choices on the Complete the merge prompt.

4) Graded Lab Tasks:

Note: The instructor can design graded lab activities according to the level of difficulty and
complexity of the solved lab activities. The lab tasks assigned by the instructor should be evaluated
in the same lab.

Lab Task 1
Create a short report on topic of your choice which includes the following:
• Title page
• Table of Content

38
`
 • Bibliograpghy and referencing.
• Tables/Figures with captions.

Lab Task 2
A flyer is a pamphlet, which is a form of paper advertisement intended for wide distribution in a public
place, handed out to individuals or sent through the mail. Consider you work at a company. Your boss
has asked you to prepare a flyer that advertises company’s major products and/or services.

39
`
 Lab 05-06
Introduction to Power Point
Objective:
In this lab the students will be able to combine text, graphics, and predesigned backgrounds to create
professional presentations.
Activity Outcomes:
The students will be able to:
• Prepare a professional Presentation
• Add animations and sounds to the slides.

Instructor Note:
As a pre-lab activity, read “MicroSoft” official site for detail guidance.

1) Useful Concepts
MS PowerPoint is a program that is included in the Microsoft Office suite. It is used to make
presentations for personal and professional purposes.

In this manual, we shall discuss in detail the functions and features of a PowerPoint presentation.

The following elements can be added to a Powerpoint slide:

• Clip Art
• Graphs
• Tables
• Photographs
• Charts
• Media Clips
• Videos

2) Solved Lab Activites

Sr.No Allocated Time Level of Complexity CLO Mapping
1 30 Medium CLO-6
2 30 Medium CLO-6

Activity 1:
Making Presentation Slides

Solution:
Slides in a presentation are similar to pages in a word processing document. All slides and graphics
are saved in one file (example: keys.xppt). Use the PowerPoint file to present the information in the
following ways:

40
`
 • On-screen slide show: The keys.xppt file displays the slide show on a monitor or
computerprojected large screen.
• Web pages: The keys.xppt file can be saved as Web page and then published on the Web.
• Overhead transparencies: The keys.xppt file can be printed as transparencies (Important:
Make sure the appropriate transparencies are used for your printer model. The wrong type of
transparencies can melt inside your printer.).
• Handouts: The keys.xppt file can print two to nine mini slides per page.

Create Slide Presentation:

This section will teach the basics of opening PowerPoint and beginning a presentation.
When PowerPoint is launched the Presentation window will appear.

When creating a new presentation, you have choices about how to proceed. PowerPoint gives you
a range of ways with which to start creating a presentation. You can start your presentation with:

• Blank: Slides that are unformatted and have no color scheme.

• Design: Slide Themes that have design concepts, fonts, and color schemes.

41
`
 • Template on Microsoft.com: Microsoft Office Templates and Theme Gallery which are
arranged according to type (Click on the File tab, select the New option, and then click
on PowerPoint presentations and slides from the Available Templates and Themes.).

This workshop section will focus on using a Design Theme.

A. Design Theme

A Theme gives your slides a consistent appearance throughout your presentation. Themes contain
color schemes with custom formatting, styled fonts, and layouts. When you apply a design
template to your presentation, the slide master and color scheme of the template replaces the
original blank slide.

1. Select the Design tab, then on the Theme group, click on the drop-down arrow next to
the last Theme.

2. The All Themes window will appear with available presentation Themes.

3. Hover the mouse pointer over a Theme to preview it.

4. Click on a Theme of your choice.

Note: You can change the Theme during or after the creation of your PowerPoint file.

42
`
 B. Add Text

The template for the design Theme you select will determine the font type and text alignment.
PowerPoint places all information (text and graphics) contained on a slide in separate
Placeholders. Placeholders are designated by dotted lines; they appear on a slide as guides, but
they will not appear on the finished presentation. In order to edit text, click once inside of the
Text Placeholder and the insertion point will appear; then begin to type your text.

1. Click in the Title Placeholder and type the text title below.

2. Click in the Subtitle Placeholder.

3. Type the text below (You will need to press the Enter key after each line of text.).

4. Save the presentation. Click on the File tab and then click on Save As. The Save As
window will open. In the File name box, type Keys to Success for the presentation name.
The instructor will indicate where to save the file. Click on the Save button.

Add New Slide

43
`
A slide layout defines the placement of text, pictures, tables, and graphs. If you change the layout of a
slide, the text and graphics remain intact. You can resize text and graphic boxes to conform to the new
layout

1. On the Home ribbon, located in the Slides group, click on the New Slide drop-down
arrow. The Office Theme panel will appear with multiple slide layouts. Select your
desired slide layout.

2. For this exercise, click on the second Layout (Title and Content) in the first row.

3. In the Title Placeholder, type the text Agenda as seen above.

4. In the Text Placeholder, type the bulleted text as seen above (You will need to press
Enter after each line of text.).

5. Add another new slide.

44
`
 6. On the Home ribbon, click on the New Slide drop-down arrow and then select the Two
Content slide layout (This slide contains a title, text, and clip art placeholders.).

7. Click inside the Title and Text Placeholders and type the text shown above.

8. On the Quick Access Toolbar, click on the Save button to save your presentation
changes.

Activity 2:
Editing Techniques
Solution:
This section will teach you basic techniques for editing slides.

View Modes for Editing

The Normal, Slide Sorter, Reading, and Slide Show Views allow you to type, edit, and view
your presentation. To switch between views, click the View Options buttons
at the lower right-hand side of the PowerPoint window.

Normal View
Normal View is the main editing View, which you use to
write and design your presentation. The View has three
working areas: on the left, tabs that alternate between an
outline of your slide text (Outline tab), and your slides
displayed as thumbnails (Slides tab); on the right, the slide
pane, which displays a large view of the current slide; and
on the bottom, the notes pane.

45
`
 Slide Sorter View

Slide Sorter View is an exclusive view of your slides in

thumbnail form. When you are finished creating and
editing your presentation, Slide Sorter gives you an overall
picture of it — making it easy to reorder, add, or delete
slides, and preview your transition and animation effects.

Reading View
Reading View is new in PowerPoint 2013. It is similar to
Slide Show View. The difference between the two Views
is that while Slide Show View takes over the whole screen,
the slide in Reading View is shown in full screen, but you
will see the PowerPoint title band at the top of the screen.
The PowerPoint status bar and the Windows task bar are
also displayed at the bottom of the screen.

Slide Show View

Slide Show View takes up the full computer screen, like
an actual slide show presentation. In this full-screen View,
you see your presentation the way your audience will. You
can see how your graphics, timings, movies, transition
effects, and animation elements will look in the actual
show.

B. Edit Bulleted List

Typing text in PowerPoint is similar to typing in other applications. However, since PowerPoint
deals with bulleted lists, a few keystrokes will be identified to help in typing multiple lines.

1. Confirm you are on slide three.

2. In Normal View, edit the bulleted list to include the circled text above. Place the Insertion
bar after each line of the bulleted text and then press the Enter key.

46
`
 3. To add a sub-bullet, click on the Increase Indent button, located on the Home ribbon.
The Tab key can also be used to indent text.

4. Type the text and if additional sub-bullets lines are needed press the Enter key, after your
line of text.

Note: Pressing Enter after any text returns the cursor to the same indent (paragraph) level for the
next line. The Tab key is also used before typing to indent text to the next indent level (sub-bullet
point) and pressing Shift+Tab before typing to return to the previous indent level.

C. Add Pictures

Online Pictures are any type of computerized images such as artwork and photos. You can make
your presentation more eye-catching and entertaining by adding Pictures.

1. Confirm you are on slide three.

2. Click on the Online Picture button in the Illustration box, located in the Text
Placeholder.

3. The Bing Image Search window will appear.

47
`
 4. In the Search box, type the word Classroom, and then press the Enter key. A variety
of online images associated with your search will appear.

5. Scroll through the Pictures window to find your desired image.

6. To insert the image, place the mouse pointer on the image and then click on the left mouse
button twice.

3) Graded Lab Tasks

Note: The instructor can design graded lab activities according to the level of difficulty and
complexity of the solved lab activities. The lab tasks assigned by the instructor should be evaluated
in the same lab.

Lab Task 1
Make a presentation(15 slides) on different Input/Output devices (Chapters 2 and 3 of textbook). Use
different effects, animations, transitions and a custom Master Slide.

Note: this should be a formal presentation. Take care of font size, font color, font names, and other
styles and animations accordingly.

48
`
 Lab 07-09
Introduction to MS Excel
Objective:
It will enable students to understand and use MS Excel. How to create MS Excel document, use rows
and columns.

Activity Outcomes:
The students will be able to:
• Create Spread Sheets .
• Making reports.
• To filtration the data

Instructor Note:
As a pre-lab activity, read “MicroSoft” official site for detail guidelines.

1) Useful Concepts
MS Excel is a commonly used Microsoft Office application. It is a spreadsheet program which is used
to save and analyse numerical data. Excel is typically used to organize data and perform financial
analysis. It is used across all business functions and at companies from small to large.

The main uses of Excel include:

• Data entry
• Data management
• Accounting
• Financial analysis
• Charting and graphing
• Programming
• Time management
• Task management
• Financial modeling
• Customer relationship management (CRM)
• Almost anything that needs to be organized!

2) Solved Lab Activites

Sr.No Allocated Time Level of Complexity CLO Mapping
1 10 Low CLO-6
2 25 Medium CLO-6
3 25 Medium CLO-6

49
`
 Activity 1:
Conditional Formatting

Solution:
Conditional formatting allows you to change the appearance of a cell, based on criteria that you
define, using predetermined rules in Excel.

Highlight Cells Rules

Using the highlight cells rules, you can highlight cells in your data that are greater or less than
a value, between or equal to a value or contain a specified or duplicate value.

Greater Than
To highlight cells which contain data greater than a specific value:
1. Highlight the data range.

2. Select the Conditional Formatting tool

3. Hover over Highlight Cells Rules to reveal the menu of different rules.

4. Select Greater Than from the menu to open the Greater Than dialogue box:

5. Enter the value that you want to set as your lower limit for the Greater Than condition.

50
`
 6. Select the type of formatting from the dropdown menu.
7. Select Ok.

The cells which contain a value greater than the value you specified will now appear with the
cell formatting which you selected.

Less Than
To highlight cells that contain data less than a specific value:
1. Highlight the data range.
2. S elect Conditional Formatting .

3. Hover over Highlight Cell Rules.

4. Select Less Than to open the Less Than dialogue box.

5. Enter the value that you want to set as your upper limit for the Less Than condition
6. Select Ok.

The cells which contain a value less than the value you specified will now appear with the cell
formatting which you selected.

Between
To highlight cells between two specific values:
1. H ighlight the data range.
2. S elect Condition al Formatting .

3. Hover over Highlight Cells Rules to reveal the menu of different rules.
4. Select Between to open the Between dialogue box.

51
`
 5. Enter the lower limit in the first box and the upper limit in the second box.
6. Select the cell formatting.
7. Select Ok.

The cells which contain a value between the two specified values will now appear with the cell
formatting which you selected.

Equal To
To highlight cells equal to a specific value:
1. Highlight the data range.
2. Select Conditional Formatting.

3. Hover over Highlight Cells Rules.

4. Select Equal To to open the Equal To dialogue box.

5. Enter the value that you’re looking for.

6. Select the type of cell formatting you wish to use.
7. Select Ok.

The cells which contain the specified value will now appear with the cell formatting which you
selected.

Text That Contains

To highlight cells that contain a certain character(s):

52
`
 1. H ighlight the data range.
2. S elect Conditional Formatting .

3. Hover over the Highlight Cells Rules.

4. Select Text That Contains to open the Text That Contains dialogue box.

5. Enter the character(s) you’re looking for.

6. Select the type of cell formatting you wish to use.
7. Select Ok.

The cells which contain the specified character(s) will now appear with the cell formatting
which you selected.

A Date Occurring
To highlight cells that contain a certain date or date range:
1. Highlight the data range.
2. S elect Conditional Formatting .

3. Hover over the Highlight Cells Rules.

4. Select A Date Occurring to open the Date Occurring dialogue box.

5. Select the date or date range that you’re looking for.

6. Select the type of cell formatting.
7. Select Ok.

53
`
 The cells which contain the specified date or date range will now appear with the cell formatting
which you selected.

Duplicate Values
To highlight cells that contain either duplicate or unique values:
1. Highlight the data range.
2. S elect Conditional Formatting .

3. Hover over Highlight Cells Rules.

4. Select Duplicate Values to open the Duplicate Values dialogue box.

5. Select either Duplicate or Unique from the drop down menu.

6. Select the type of cell formatting you wish to use.
7. Select Ok.

The cells which contain either duplicate or unique values will now appear with the cell
formatting which you selected.

Top/Bottom Rules

Top and bottom rules can be used to highlight cells that are the top or bottom ten items or the
top or bottom ten percent. They can also be used to identify items above or below the average.

54
`
Activity 2:
Separating Text within a Cell
Solution:
When data is combined within a cell, such as a first and last name, Excel is able to separate this data
into two cells.

To separate data within a cell:

1. Insert a blank column to the right of the column containing the merged data.
2. Highlight the column of full names.
3. Select the Data tab.
4. Select Text to Columns .

The Convert Text to Columns Wizard dialogue box will.

5. Choose the appropriate data type.

To separate a column based on punctuation characters, select Delimited.

To separate a column based on spaces between each field, select Fixed Width.

For this example we will select Delimited.

6. Select Next.

7. Choose your delimiters for the text separation.

For this example select Space.

8. Select Next.

9. Select the data format for each column.

For this example select General.

55
`
 10. Select Finish.

Data will be displayed as separate columns

.

Activity 3:
Use of Functions and Formulas
Solution:
Excel has many different functions and formulas which can be used to manipulate data in a
variety of ways, such as sums, subtotals, averages, number counts, maximums, and minimums.

Sums: One of the most commonly used functions of Excel is summation. If you have a data
table for a single student with amounts and dates of payment, to find the sum of all payments,
you would use the summation function.

To add numbers in a column:

56
`
1. S elect the cell directly beneaththe last entry.
2. S elect Auto Sum located on the Formulas tab.

3. Select the AutoSum button

4. This will select all items within the column
5. Click the Enter key on your keyboard to calculate the sum of all fields.
Other functions are available by selecting the AutoSum dropdown

Other functions include: averaging the numbers in a column, counting the numbers in a column
and finding the minimum and/or maximum numbers in the column.

Additionally, there is an AutoSum button and dropdown menu also located on the Home toolbar.

Subtotaling

The Subtotal tool is used sum data by group. Subtotaling data eliminates the need to manually
insert a row and perform a summation.

Below is a sample data sheet for which we need to calculate the total amount paid for each
semester.

One Level Subtotals

To Subtotal a data sheet:

57
`
 1. Select the Subtotal button located on the Data toolbar.

The Subtotal dialogue box will open

To subtotal this data sheet by semester:

1. Choose Semester for the At Each Change In dropdown.
2. Select Sum for the Use Function dropdown.
3. Choose Amount Paid for the Add Subtotal To field.
4. Click Ok.

Subtotals will automatically be added to your data.

58
`
 The subtotal hierarchy located to the left of the spreadsheet can be used to hide some of the data
within the spreadsheet.
To view only the grand total, select column 1
To view the total for each subsection,
select column 2 To view all data, select
column 3.

Nested Level Subtotals

Nested Level Subtotals are used to subtotal more than one level of data.
For this example our list of data contains individual payers and semesters

1. Select any cell within your range of data

2. Select Subtotal on the Data tab.

The Subtotal dialogue box will open.

3. For the At Each Change in dropdown menu, select Semester.

4. Choose to Use Function, Sum.
5. Choose to Add Subtotal To, Amount Paid.

59
`
 6. Click Ok.

The first level of subtotal will be added to the data.

To add an additional level of subtotals:

1. Select Subtotal
2. For the At Each Change in dropdown menu, select Last Name.
3. Choose to Use Function, Sum.
4. Choose to Add Subtotal To, Amount Paid.
5. Ensure the checkbox Replace Current Subtotals is unchecked.

60
`
 6. Click Ok.
The second level of subtotals will be added to the data range:

Removing Subtotals
To remove subtotals from a data sheet:

61
`
 1. Select the Subtotal tool
The Subtotal Dialogue box will appear.

2. Select Remove All to remove all subtotals.

Average

To find the average of a select range of data:

1. Select the cell directly beneath the range of data

3.
2. Select the Auto Sum dropdown on the Formulas tab.

Choose Average from the Auto Sum dropdown:

62
`
 4. Select the range of cells to calculate
5. Click Enter on your keyboard

Count Numbers

To count the number of items in a range of data:

1. Select the cell directly beneath the range of data.

2. Select the Auto Sum dropdown.

3. Select Count Numbers.

4. Select the range of cells to calculate.

63
`
 5. Click Enter on your keyboard.

Maximum and Minimum

To calculate the Maximum or Minimum for a range of data:

1. Select the cell directly beneath the range of data.

2. Select the Auto Sum dropdown.

3. Select Max or Min to calculate the maximum or minimum values

6. Select the range of cells to calculate.

7. Click Enter on your keyboard to calculate the value.

3) Graded Lab Tasks

Note: The instructor can design graded lab activities according to the level of difficulty and
complexity of the solved lab activities. The lab tasks assigned by the instructor should be evaluated
in the same lab.

64
`
Lab Task 1
The Sales Invoice

Use the template below and create your own invoice for purchased products. You can sell any product
at any price, but you must include General sales tax, discount percentages and at least four items in
your invoice. Do all formulas required. Format the invoice for clarity.

Item Quantity List Price Discount Your Price Total

Lays 10 9 0.5 8.5 85

Subtotal

G. Sales Tax(GST @17% of the price)

Amount Due

Lab Task 2
The CSC101 Grade Book
Recreate the table shown below. Determine the average for each student’s final grade. Alphabetize
the list. Using the IF statements, calculate the letter grade for each student whereby anything over 90
is an A, 80 is a B, 70 is a C, 60 is a D and anything lower is an F. Chart the final grades in a bar chart.

Name Exam 1 Exam 2 Exam 3 Final Final Grade Letter Grade

Asad 80 88 87 94
Amir 99 92 96 100
Atique 85 99 82 95
Ayesha 56 76 74 70
Khurram 45 35 56 60
Rizwan 100 90 95 100
Nusrat 75 88 97 89
Salman 90 90 85 89

Lab Task 3
Class Make-up
Create a chart for each:
▪ There are 28 students in a class. 10 are freshmen, 8 sophomores, 4 juniors, and 1 senior.
5 people did not answer the question;

65
`
 ▪ There are 11 men and 17 women – do a pie chart for this.
▪ If only 23 of the students did the homework assignment, what percent of the class is that?
Another pie chart.

LAB Task 4
Vacation Budget
Before you create the worksheet in Excel, explain where you want to go and what kind of
activities you would like to do while you are there in a Word Document. What is your proposed
budget? Set up your worksheet for transportation costs (airfare, car rental, trains, etc.),
accommodations, food, sightseeing and shopping. Include any other activities you might enjoy.
Include a 10% contingency plan for emergencies.

66
`
 Lab 11-13
Introduction to MS Access
Objective:
This lab will introduce Microsoft Access database management system (DBMS) that combines the
relational Microsoft Jet Database Engine with a graphical user interface and software-development
tools.

Activity Outcomes:
The activities provide hands - on practice on
• How to create database
• How to create ghaphical view

Instructor Note:
As pre-lab activity, read “Microsoft” official site for detail guidelines.

1) Useful Concepts
Microsoft Access is a Database Management System (DBMS) from Microsoft that combines the
relational Microsoft Jet Database Engine with a graphical user interface and software-development
tools. It is a member of the Microsoft Office suite of applications, included in the professional and
higher editions.

Microsoft Access is just one part of Microsoft’s overall data management product strategy.It stores data
in its own format based on the Access Jet Database Engine.Like relational databases, Microsoft
Access also allows you to link related information easily. For example, customer and order data.
However, Access 2013 also complements other database products because it has several powerful
connectivity features.

It can also import or link directly to data stored in other applications and databases. As its name implies,
Access can work directly with data from other sources, including many popular PC database programs,
with many SQL (Structured Query Language) databases on the desktop, on servers, on minicomputers,
or on mainframes, and with data stored on Internet or intranet web servers.

Access can also understand and use a wide variety of other data formats, including many other database
file structures.

You can export data to and import data from word processing files, spreadsheets, or database files
directly.

Access can work with most popular databases that support the Open Database Connectivity (ODBC)
standard, including SQL Server, Oracle, and DB2. Software developers can use Microsoft Access to
develop application software.

67
`
2) Solved Lab Activites
Sr.No Allocated Time Level of Complexity CLO Mapping
1 20 Low CLO-6
2 40 Medium CLO-6

Activity 1:
Create a Blank Database.

Solution:

Step 1: Let us now start by opening MS Access.

Step 2: Select Blank desktop database. Enter the name and click the Create button.

Step 3: Access will create a new blank database and will open up the table which is also completely
blank.

68
`
Activity 2:

Creating Tables..

Solution:
When you create a database, you store your data in tables. Because other database objects depend so heavily
on tables, you should always start your design of a database by creating all of its tables and then creating
any other object. Before you create tables, carefully consider your requirements and determine all the tables
that you need.
Let us try and create the first table that will store the basic contact information concerning the employees
as shown in the following table:

Field Name Data Type

EmployeelD AutoNumber

FirstName Short Text

LastName Short Text

Address1 Short Text

Address2 Short Text

City Short Text

State Short Text

Zip Short Text

Phone Short Text

PhoneType Short Text

Let us now have short text as the data type for all these fields and open a blank database in Access.
This is where we left things off. We created the database and then Access automatically opened up this
table-one-datasheet view for a table.

Let us now go to the Field tab and you will see that it is also automatically created. The ID which is an
AutoNumber field acts as our unique identifier and is the primary key for this table. The ID field has
already been created and we now want to rename it to suit our conditions. This is an Employee table and
this will be the unique identifier for our employees.

70
Click on the Name & Caption option in the Ribbon and you will see the following dialog box.

Change the name of this field to EmployeeID to make it more specific to this table. Enter the other optional
information if you want and click Ok.

71
We now have our employee ID field with the caption Employee ID. This is automatically set to auto number
so we don't really need to change the data type.
Let us now add some more fields by clicking on click to add.

Choose Short Text as the field. When you choose short text, Access will then highlight that field name
automatically and all you have to do is type the field name.

72
Type FirstName as the field name. Similarly, add all the required fields as shown in the following
screenshot.

Once all the fields are added, click the Save icon.

You will now see the Save As dialog box, where you can enter a table name for the table.

Enter the name of your table in the Table Name field. Here the tbl prefix stands for table.
Let us click Ok and you will see your table in the navigation pane.

73
In the tables group, click on Table and you can see this looks completely different from the Datasheet View.
In this view, you can see the field name and data type side by side.

We now need to make ProjectID a primary key for this table, so let us select ProjectID and click on
Primary Key option in the ribbon.

74
You can now see a little key icon that will show up next to that field. This shows that the field is part of the
table’s primary key.
Let us save this table and give this table a name.

75
Click Ok and you can now see what this table looks like in the Datasheet View. If you ever want to make
changes to this table or any specific field, you don't always have to go back to the Design View to change
it. You can also change it from the Datasheet View. Let us update the PStatus field as shown in the following
screenshot.

Click Ok and you will see the changes.

76
3) Graded Lab Task
Note: The instructor can design graded lab activities according to the level of difficulty and complexity
of the solved lab activities. The lab tasks assigned by the instructor should be evaluated in the same lab.

Lab Task 1
Create database of your lab project. Create tables for each activity. Apply the following queries on
the tables:

• Insert data in the tables.

• Retriew data from the tables.
• Update the data.
• Create forms for all the activites.

77
 Lab 14
HTML Basics
Objective:
• After this lab the students should be able to understand the use of markup language “HTML” and
its basic tags.

Activity Outcomes:
The activities provide hands-on practice with the following topics
• Design basic web page using HTML Tags
• Add text formatting tags
• Add lists to web pages
• Add images and videos to the web pages

Instructor Note:
As pre-lab activity, read Chapter 1, 2 from the textbook “Web Design Playground: HTML & CSS the
Interactive Way 1st Edition, April 2019 by Paul McFedries”.

5) Useful Concepts
TAG Description

<!DOCTYPE> Defines the document type

<html> Defines an HTML document

<head> Contains metadata/information for the document

<title> Defines a title for the document

<body> Defines the document's body

<h1> to <h6> Defines HTML headings

<p> Defines a paragraph

<br> Inserts a single line break

<hr> Defines a thematic change in the content

<!--...--> Defines a comment

78
 Inserts an image
<img src=”abc.jpg”>
<video
Inserts Video
src=”abc.mp4”>
Order list
<ol></ol>
Adding list items
<li> </li>
Unoredered list
<ul>
tag defines a description list.
<dl>
defines terms/names
<dt>
describes each term/name
<dd>
An inline frame is used to embed another document within the current HTML
document.
<iframe>

HTML Basic Structure

<html>
<head>
<title> Page Title Goes Here </title>
</head>
<body>
content goes here
</body>
</html>

Adding audio,image and video files:

<html>
<head>
<title>adding video</title>
</head>
<body>
<img src=”abc.jpg”>
<video src=”abc.mp4”>
</body>
</html>

How To Create basic web page

1. Open Notepad
2. Click on File -> Save as…
3. In the File name pull-down box, type in webpage.html

79
4. Click on Save
5. Type in content for your file
6. Once you finished the content, click on File -> Save

6) Solved Lab Activities

Sr. No Allocated Time Level of Complexity CLO Mapping
Activity 1 30 Minutes Low CLO-6
Activity 2 30 Minutes Low CLO-6

Activity 1

• Create a basic page of COMSATS University as given below

• Add text about COMSATS and apply text formatting Solution:

Solution

<html>
<head>
<title>Home</title>
</head>
<body bgcolor="#98E0F0">
<h1><font color="#1322D6"> COMSATS University Islamabad</font>
</h1>
<hr width="100%" color="#030303" size="4" />

<Center><p><h2><b><pre> Home Department Admissions Academics

Exams</pre></b></h2> </p> </center>
<hr width="100%" color="#030303" size="4" />
<br />

<p> <h2><font color="#1322D6"> Historic Perspective:</font> </h2>

</p>

<a href="lol.html"> click here </a><!-- Write your comments here -->

<p>WWF's goal is to: <q>Build a future where people live in harmony

with nature.</q></p>

</body>
</html>

80
Output:

Activity 2:
Add list of topics, images and videos to your website

Solution
<html>
<head>
<title>Home</title>
</head>
<body bgcolor="#98E0F0">
<h1><font color="#1322D6"> COMSATS University Islamabad </font>
</h1>
<hr width="100%" color="#030303" size="4" />
<Center><p><h2><b><pre> Home Department Admissions Academics
Exams</pre></b></h2> </p> </center>
<hr width="100%" color="#030303" size="4" />
<ol type="I" start="4">
<li> computer </li>
<li> mouse </li>
<li> keyboard </li>

81
 </ol>
<br />
<dl>
<dt>Coffee</dt>
<dd>- black hot drink</dd>
<dt>Milk</dt>

<dd>- white cold drink</dd>

</dl>
<img src="akweb.jpg" alt="Mountain View farrrr"
style="width:304px;height:228px;">
<iframe width="420" height="315" src="https://www.youtube.com/embed/
joriayTNmwQ?autoplay=1">
</iframe>
</body> </html>

Output

7) Graded Lab Tasks

Note: The instructor can design graded lab activities according to the level of difficult and complexity of
the solved lab activities. The lab tasks assigned by the instructor should be evaluated in the same lab.

Lab Task 1
Learn and try different tags and formatting options on your webpage of Comsats.

Lab Task 2

82
Create a webpage for Comsats library. Add lists and apply text formatting to your page. use videos and
images of the library and then add them to your page.

Lab Task 3
Use inline styling to make the webpage created in lab task 2, more aesthetic.

Lab 15
Working with HTML Links and tables

Objective:
After this lab the students should be able to add linking information, creating multiple pages, and navigating
in a website and add tables in web pages.

Activity Outcomes:
To familiarize the students with
• Internal links
• External links
• In-page references
• use of tables in a web page

Instructor Note:
As pre-lab activity, read Chapter 3 from the textbook “Web Design Playground: HTML & CSS the
Interactive Way 1st Edition, April 2019 by Paul McFedries”.

1) Useful Concepts
TAG Description

The <a> tag defines a hyperlink, which is used to

<a> link from one page to another

The href attribute specifies the URL of the page the

href link goes to

HTML tables allow web developers to arrange data into

<table> rows and columns

83
 The <tr> HTML element defines a row of cells in a
<tr> table

<th> The <th> tag defines a header cell in an HTML table.

The <td> tag defines a standard data cell in an HTML

<td> table.

The <thead> tag is used to group header content

<thead> in an HTML table

The <tbody> tag is used to group the body content

<tbody> in an HTML table

The <tfoot> tag is used to group footer content

<tfoot> in an HTML table.

2) Solved Lab Activities

Sr. No Allocated Time Level of Complexity CLO Mapping
Activity 1 20 Minutes Low CLO-6
Activity 2 20 Minutes Low CLO-6
Activity 3 20 Minutes Low CLO-6

Activity 1:
Use the page you created in the first lab and add the following linking information

• Create links to home, departments, admission and exams pages of CUI Islamabad campus

Solution:

<html>
<head>
<title>Home</title>
</head>
<body bgcolor="#98E0F0">
<h1><font color="#1322D6"> COMSATS University Islamabad </font>
</h1>
<hr width="100%" color="#030303" size="4" />

<a href="home.html"> click here</a>

84
 <a href="departments.html"> click here</a>
<a href="admissions.html"> click here</a>
<a href="exam page.html"> click here</a>
<Center><p><h2><b><pre> Home Department Admissions Academics
Exams</pre></b></h2> </p> </center>
<hr width="100%" color="#030303" size="4" />
<br />
<p> <h2><font color="#1322D6"> Historic Perspective:</font> </h2>
</p>
<a href="lol.html"> click here </a><!-- Write your comments here -->
<p>WWF's goal is to: <q>Build a future where people live in harmony
with nature.</q></p>
</body>
</html>

Output

Activity 2:
Create a table to add the add basic html table including the details of Company, Contact, and Country.

Solution:

<!DOCTYPE html>
<html>
<style>

85
 table, th, td {
border:1px solid black;
}
</style>
<body>

<h2>A basic HTML table</h2>

<table style="width:100%">
<tr>
<th>Company</th>
<th>Contact</th>
<th>Country</th>
</tr>
<tr>
<td>Alfreds Futterkiste</td>
<td>Maria Anders</td>
<td>Germany</td>
</tr>
<tr>
<td>Centro comercial Moctezuma</td>
<td>Francisco Chang</td>
<td>Mexico</td>
</tr>
</table>

</body>
</html>

Output

Activity 3:
Create a table as shown in the figure given below:

86
Solution:

<table>
<thead>
<tr>
<th colspan="2">October</th>
<th colspan="2">November</th>
</tr>
</thead>

<tbody>
<tr>
<td>Sales</td>
<td>Profit</td>
<td>Sales</td>
<td>Profit</td>
</tr>
<tr>
<td>$200,00</td>
<td>$50,00</td>
<td>$300,000</td>
<td>$70,000</td>
</tr>
</tbody>

<tfoot>

87
 <tr>
<th colspan= "4">November was more produstive</th>
</tr>
</tfoot>
</table>

Output

3) Graded Lab Tasks

Note: The instructor can design graded lab activities according to the level of difficult and complexity of
the solved lab activities. The lab tasks assigned by the instructor should be evaluated in the same lab.

Lab Task 1
Create in-page reference to the list created in the body and marks the locations accordingly.

Add tables to department and admission pages.

Lab Task 2
Use tables to create a page layout given below that displays your profile (Persional Homepage)

88
89