GOVERNMENT POLYTECHNIC, AHMEDABAD

COMPUTER ENGINEERING DEPARTMENT

CERTIFICATE

This is to certify that Mr. / Miss

_____________________________________________

Of Diploma in Computer Engineering, Semester _______ Enrollment No. _________________

has satisfactorily completed his/her term work in

________________________________________

For the term ending in _____________________.

Date of Submission: -
(Course in Charge) Head of the Department

Sr Practical’s Page No.

No.
1 Basics of Computer System (Practical_1_to_4) 3_to_35

2 MS-Word (Practical_5_to_9) 36_to_44

3 MS-Excel (Practical_10_to_14) 45_to_49

4 Power point (Practical_15_to_18) 50_to_60

5 HTML (Practical_19_to_26) 61_to_73

 What is Software and
Hardware? Explain Types of
Software with Example

Software:
Software, commonly known as
programs or apps, consists of all the
instructions that tell the hardware how
to perform a task. These instructions
come from a software developer in the
form that will be accepted by the
platform (operating system + CPU) that
they are based on. For example, a
program that is designed for the
Windows operating system will only work
for that specific operating system.
Compatibility of software will vary as the
design of the software and the operating
system differ. Software that is designed
for Windows XP may experience a
compatibility issue when running under
Windows 2000 or NT.

Software is capable of performing many

tasks, as opposed to hardware which can
only perform mechanical tasks that they
are designed for. Software provides the
means for accomplishing many different
tasks with the same basic hardware.
Practical computer systems divide
software systems into two major classes:

 System software: Helps run the

computer hardware and computer
system itself. System software
includes operating systems, device
drivers, diagnostic tools and more.
System software is almost always
pre-installed on your computer.
  Application software: Allows users to
accomplish one or more tasks. It
includes word processing, web
browsing and almost any other task
for which you might install software.
(Some application software is pre-
installed on most computer systems.)
Software is generally created (written) in
a high-level programming language, one
that is (more or less) readable by people.
These high-level instructions are
converted into "machine language"
instructions, represented in binary code,
before the hardware can "run the code".
When you install software, it is generally
already in this machine language, binary,
form.
Hardware:
Hardware refers to the physical
elements of a computer. This is also
sometime called the machinery or the
equipment of the computer. Examples
of hardware in a computer are the
keyboard, the monitor, the mouse and
the central processing unit. However,
most of a computer's hardware cannot
be seen; in other words, it is not an
external element of the computer, but
rather an internal one, surrounded by
the computer's casing (tower). A
computer's hardware is comprised of
many different parts, but perhaps the
most important of these is the
motherboard. The motherboard is made
up of even more parts that power and
control the computer.

In contrast to software, hardware is a

physical entity. Hardware and software
are interconnected, without software,
the hardware of a computer would have
no function. However, without the
creation of hardware to perform tasks
directed by software via the central
processing unit, software would be
useless.

Hardware is limited to specifically

designed tasks that are, taken
independently, very simple. Software
implements algorithms (problem
solutions) that allow the computer to
complete much more complex tasks.
 Explain Functioning of CU,
ALU and memory unit

CU:
A CU or control unit is circuitry that
directs operations within a computer's
processor. It lets the computer's logic
unit, memory, as well as both input and
output devices know how to respond to
instructions received from a program.
Examples of devices that utilize control
units include CPUs and GPUs.
ALU:
ALU or Arithmetic Logic Unit is
responsible to perform the operation in
the computer. The basic operations are
implemented in hardware level. ALU is
having collection of two types of
operations:
 I. Arithmetic operations
II. Logic operations
Consider an ALU having 4 arithmetic
operations and 4 logical operation. To
identify any one of these four logical
operations or four arithmetic operations,
two control lines are needed. Also to
identify the any one of these two
groups- arithmetic or logical, another
control line is needed. So, with the help
of three control lines, any one of these
eight operations can be identified.
Memory:
Memory is part of a computer
that stores data and/or instructions that
are to be executed. This memory has a
finite size which is measured in bytes,
with modern systems using the derivative
unit gigabyte (one billion bytes,
abbreviated as GB). A typical high-end
system nowadays can have from 8 to
32GB of memory, which is usually
referred to as RAM in the context of
computing.

The processor (CPU) handles the task of

executing a program. Basically, a
program can be summed up as a long list
of instructions for the CPU to execute
(such as adding 2 numbers together,
multiplication, jumping to another
instruction, etc). The processor will
execute these sequentially, in the order
they are present in the program.

A simple diagram that shows how a

computing architecture works:
An input device can refer to anything
that provides data or instructions. This
can be a keyboard, a punch tape reader,
a cassette drive, a simple hard
drive/SSD, etc.

An output device in this case can refer

to anything that a computer can use to
print out the results of a program when
done, this can be the traditional
screen/monitor, but the definition also
includes “dumb” terminal display, LEDs,
printers, speakers, etc.

The memory contains the

instructions/data for a program.
The Central Processing Unit is typically
referred to as the “brain” of a
computer. It takes the instructions out
of memory, executes them and writes
the result back to memory.
 Classify various types of
Printers

“A printer is an external output device that takes data

from a computer and generates output in the form of
graphics / text on a paper”.

1. Impact Printers
An impact printer makes contact with the
paper. It usually forms the print image
by pressing an inked ribbon against the
paper using a hammer or pins. Following
are some examples of impact printers.
The dot-matrix printer uses print heads
containing from 9 to 24 pins. These pins
produce patterns of dots on the paper to
form the individual characters. The 24-
pin dot-matrix printer produces more
dots that a 9-pin dot-matrix printer,
which results in much better quality and
clearer characters. The general rule is:
the more pins, the clearer the letters on
the paper. The pins strike the ribbon
individually as the print mechanism moves
across the entire print line in both
directions, I-e, from left to right, then
right to left, and so on. The user can
produce a colour output with a dot-
matrix printer (the user will change the
black ribbon with a ribbon that has
colour stripes). Dot-matrix printers are
inexpensive and typically print at speeds
of 100-600 characters per second.
In order to get the quality of type found
on typewriters, a daisy-wheel impact
printer can be used. It is called daisy-
wheel printer because the print
mechanism looks like a daisy; at the end
of each “Petal” is a fully formed
character which produces solid-line print.
A hammer strikes a “petal” containing a
character against the ribbon, and the
character prints on the paper. Its speed
is slow typically 25-55 characters per
second.

In business where enormous amount of

material are printed, the character-at-
a-time printers are too slow; therefore,
these users need line-at-a-time
printers. Line printers, or line-at-a-time
printers, use special mechanism that can
print a whole line at once; they can
typically print the range of 1,200 to
6,000 lines per minute. Drum, chain, and
band printers are line-at-a-time
printers.

A drum printer consists of a solid,

cylindrical drum that has raised
characters in bands on its surface. The
number of print positions across the
drum equals the number available on the
page. This number typically ranges from
80-132 print positions. The drum rotates
at a rapid speed. For each possible print
position there is a print hammer located
behind the paper. These hammers strike
the paper, along the ink ribbon, against
the proper character on the drum as it
passes. One revolution of the drum is
required to print each line. This means
that all characters on the line are not
printed at exactly the same time, but
the time required to print the entire line
is fast enough to call them line printers.
Typical speeds of drum printers are in
the range of 300 to 2000 lines per
minute.

A chain printer uses a chain of print

characters wrapped around two pulleys.
Like the drum printer, there is one
hammer for each print position. Circuitry
inside the printer detects when the
correct character appears at the desired
print location on the page. The hammer
then strikes the page, pressing the paper
against a ribbon and the character
located at the desired print position. An
impression of the character is left on
the page. The chain keeps rotating until
all the required print positions on the line
have filled. Then the page moves up to
print the next line. Speeds of chain
printers range from 400 to 2500
characters per minute.

A band printer operates similar to chain

printer except it uses a band instead of
a chain and has fewer hammers. Band
printer has a steel band divided into five
sections of 48 characters each. The
hammers on a band printer are mounted
on a cartridge that moves across the
paper to the appropriate positions.
Characters are rotated into place and
struck by the hammers. Font styles can
easily be changed by replacing a band or
chain.

2. Non-Impact Printers
Non-impact printers do not use a striking
device to produce characters on the
paper; and because these printers do not
hammer against the paper they are much
quieter. Following are some non-impacted
printers.
Ink-jet printers work in the same
fashion as dot-matrix printers in the
form images or characters with little
dots. However, the dots are formed by
tiny droplets of ink. Ink-jet printers
form characters on paper by spraying ink
from tiny nozzles through an electrical
field that arranges the charged ink
particles into characters at the rate of
approximately 250 characters per
second. The ink is absorbed into the
paper and dries instantly. Various colours
of ink can also be used.
One or more nozzles in the print head
emit a steady stream of ink drops.
Droplets of ink are electrically charged
after leaving the nozzle. The droplets
are then guided to the paper by
electrically charged deflecting plates
[one plate has positive charge (upper
plate) and the other has negative charge
(lover plate)]. A nozzle for black ink may
be all that’s needed to print text, but
full-colour printing is also possible with
the addition of needed to print text, but
full-colour printing is also possible with
the addition three extra nozzles for the
cyan, magenta, and yellow primary
colours. If a droplet isn’t needed for the
character or image being formed, it is
recycled back to its input nozzle.
Several manufacturers produce colour
ink-jet printer. Some of these printers
come with all their colour inks in a
cartridge; if you want to replace on
colour, you must replace all the colours.
Other colour ink-jet printers allow you to
replace ink individually. These printers
are a better choice if user uses one
colour more than other colours. These
printers produce less noise and print in
better quality with greater speed.

A laser printer works like a photocopy

machine. Laser printers produce images
on paper by directing a laser beam at a
mirror which bounces the beam onto a
drum. The drum has a special coating on
it to which toner (an ink powder) sticks.
Using patterns of small dots, a laser
beam conveys information from the
computer to a positively charged drum to
become neutralized. From all those areas
of drum which become neutralized, the
toner detaches. As the paper rolls by
the drum, the toner is transferred to
the paper printing the letters or other
graphics on the paper. A hot roller bonds
the toner to the paper.

Laser printers use buffers that store an

entire page at a time. When a whole
page is loaded, it will be printed. The
speed of laser printers is high and they
print quietly without producing much
noise. Many home-use laser printers can
print eight pages per minute, but faster
and print approximately 21,000 lines per
minute, or 437 pages per minute if each
page contains 48 lines. When high speed
laser printers were introduced they were
expensive. Developments in the last few
years have provided relatively low-cost
laser printers for use in small businesses.

 The main advantage of Laser printer

is its speed & efficiency at which it
prints high-quality quality graphics &
text.
 Laser printers produce high-quality
output as compared to other printers.
 Laser printers are quite and does not
produce disturbing sounds.
 They are also capable to produce
colour prints.

 The main disadvantage of Laser

printer is its cost, they are relatively
costly as compared to other printers.
 The maintenance, repair & servicing
charges are also high of these
printers.
 Laser printers emit small amount of
ozone and are hazardous to health
and the atmosphere.
 What is need of OS? Also
demonstrate various
operations related to Files
and Folder

Essentially an Operating System is an

abstraction layer between the electronic
hardware and another layer of software.
So, the OS is basically a collection of
software that contains a kernel and a
load of software libraries to provide the
software layer between the hardware,
and the applications you wish to run.

The operating system manages input and

output, as well as memory allocation,
reallocation and scheduling of processing
resources. At its simplest level; all
“computers”, from (many [see #Note
below]) micro-controllers, to cellular
phones, to video game consoles, to
desktop computers, to web servers and
supercomputers; require an OS.

A PC desktop OS often includes a suite

of GUI (Graphical User Interface)
applications often called a “Desktop
Environment”. E.g., “Gnome” or “KDE” on
Linux, “Aero” on Windows (since Vista;
“Luna” on XP) and “Aqua” on MacOS.

The desktop environment provides users

with a graphical environment which aims
to be intuitive and easy to use.
Generally, this suite of GUI software
tools provide support for mouse and
keyboard input and a visual
representation of resources (e.g.,
facility to show separate applications in
separate “windows”). The GUI may be
considered part of an OS, though it’s not
required.

#Note: The definition of what an

“Operating System” is, can start to
break down once we move away from
looking at what most would consider a
“computer”. Whilst a micro-controller
could be considered a “computer”,
whether or not is requires an “Operating
System” is somewhat arguable.

A micro-controller still needs some sort

of layer between the hardware and the
program you wish to run on it, so in that
sense it does have an OS. OTOH the
libraries it uses are generally quite
specific to the hardware and the line
between these core libraries and the
application(s) running is not quite so
clear. These core software libraries
don’t always do all the things that most
users would consider the hallmarks of an
OS (in the common sense of the term).
Some may instead suggest that micro-
controllers merely have a set of core
software libraries that fulfil some of
(but not all) the functions normally
required of an OS.

FILE AND FOLDER OPERATIONS

From within any file browsing application,

it will be essential to know to select
individual files / folders and groups of
files / folders. A single file or folder can
be selected by hovering the mouse
pointer over the prospective object and
making a single Left-Click with the
mouse. Selecting a group of files and
folders is a bit more difficult. To do so,
hold down the left mouse button within
the empty space of a Windows Explorer
window and then drag your mouse over
the objects you want to select. Finally,
release the left mouse button. You may
also use the Shift key to select a group
of files by holding down Shift and left
clicking over the files you want to group
together. To group together multiple
files which are not consecutive one may
hold down the Control key (Ctrl) and
manually click on all the files you wish to
group together.

You can copy files, folders, subfolders,

sub-subfolders, etc. Copying of file and
folders creates a duplicate of the
original

In the same folder with a different name

In a different folder with the same name

In a different folder with a different
name

The original remains in the same location

unchanged.

Copying files and folders can be done like

this:

Open Windows Explorer and select the

objects you wish to copy.

Right-Click and then click on Copy when

the pop-up menu appears.

Navigate to the location in which you

would like to paste the copies. Once
there, Right-Click and select Paste. If
everything worked correctly you should
be able to find the files and folders you
copied in both locations.

The main step in developing a good

system of file management on your
computer would be to organize your files
and folders logically. This often requires
the movement of files and folders to new
locations. To move a single file follows
these steps:

Left-Click once on the file that you

desire to move and hold down the left
mouse button. While keeping the left
mouse button pressed, drag the file to
folder in which you would like to deposit
it.
Drag the file on top the folder you want
to put it in. Then your file will now be
found within the folder you placed it.

To select multiple files or folders that

are listed contiguously, left-click on the
first one, then shift-left-click on the
last one. They will all be selected.

We can change the name of a file or

folder at any time. But we must be
careful not to change the file extension.
There are several ways to do this. We
can rename the file or folder by Right-
clicking on the file or folder you want to
rename and Choosing Rename from the
context-sensitive menu. File names may
not contain any of the following
characters: / : * ? ” < > or |.

Often, our computers get cluttered with

junk and useless files which are not
needed any more. If these files have no
purpose and are doing nothing more than
taking up hard drive space, a simple way
to dispose of these files would be to
delete them. To delete the file or folder
Left-click on the file or folder you want
to delete to highlight it and then Press
the DELETE key. Normally, deleted files
or folders are sent to the Recycle Bin.
If you delete a file by mistake, you can
restore it from the Recycle Bin.
1)Create word Document enter Text and
Apply Formatting features.

Personal computer: a small, single-user

computer based on a microprocessor. In
addition to the microprocessor, a personal
computer has a keyboard for entering data, a
monitor for displaying information, and a
storage device for saving data.
Workstation: a powerful, single-user
computer. A workstation is like a personal
computer, but it has a more powerful
microprocessor and a higher-quality monitor.
Minicomputer: a multi-user computer capable
of supporting from 10 to hundreds of users
simultaneously.
Mainframe: a powerful multi-user computer
capable of supporting many hundreds or
thousands of users simultaneously.
Supercomputer: an extremely fast computer
that can perform hundreds of millions of
instructions per second.
2) Create Word Document, enter text and
apply features like bullets, numbering, insert
images.
Computer Knowledge

Full form of Computer:

 C – Commonly
 O – Operated
 M – Machine
 P – Particularly
 U – Used for
 T – Technical
 E-Education
 R – Research
3) CREATE BUSINESS CARDS USING
SHAPES, TEXT, AND COLORS.

Dhruvik Tank +91 8000006273

Director

Krishna Computer
Laptop Desktop

Printer Service

3, Second Floor, C.G. Complex,

Ahmedabad

4) Create and Design Admission (Sample Given)

Using Different Menus of Ms Word.
 Krishna Vidhyalaya
School Address
City, State, Zip Code
Phone: xxxxxxxxx
Fax: xxxxxxxx
Email: abc@example.com
Website: www.schoolwebsite.com

Application for Admission

Section 1: CHILD’S PERSONAL DETAILS
Family Name Father’s Name
Date of Birth Place of Birth
Nationality Male Female

Address

Mobile
Parent’s Telephone
Residence
Numbers Office:

Name and classes of any brother(s)/sister(s) already attending the school _____________________
__________________________________________________________________________________________
__________________________________________________________________________________________
__________________________________________________________________________________________

Language(s) commonly spoken at home: (1): ________________________ (2): ______________________

5)PREPARE MINI PROJECT
1. HOW TO MOTIVATE EMPLOYEES WHEN
THEY DON’T WANT TO PUT IN THE WORK
Everybody is motivated by different things. We all have our own dreams,
aspirations and beliefs that drive us. Never think for a second that
money drives all motivation. It’s simply not true.
People are in the game for multiple reasons and the only way for you to
understand that is to listen. Once you understand then you can set them
up to be in a place for them to deliver on it. And that gives them
incentive to always work their hardest for you, because you did it for
them. Get it?

So you need to use your ears and listen to your employees. You need to
sit down with them and understand where they want to take their
careers. What’s their ambition? What do they want to do with their life?
By sitting down with people and actually listening, you’ll be able to set up
your employees for success while also motivating them to work hard and
fast.

Also, it makes you a good boss. So there’s that.

2. IS THE CUSTOMER REALLY ALWAYS
RIGHT?
When I have an angry customer, the very first thing I want to know is if
they are right. I talk to the parties involved, and I get all the information
possible that I can. In the end, someone has to make a call, and as the
boss, that is probably going to have to be you.

Nobody likes a boss who passes the buck.

If the customer is 100% right, you apply something that everyone in sales
or customer service needs: empathy. You come in with nothing but
empathy. I ask questions and I listen before trying to fix it. I’ve talked in
the past about how great leaders are listeners. This applies just as much
to this situation as well.
3. MEETING CLIENT DEMANDS AND
AGENCY CAPABILITIES
As I’ve been building my agency VaynerMedia over the last six years,
there is something I often hear from clients, which is this: “Well, you do
social, not digital. So we are going to go with _____.”

I believe that the top seven people are what make any company tick. Now
if those top people picked up and went to a new company, that new
company would start to like the place they all came from. Think about it.
What about sports teams? There is no “The Lakers are great.” It’s Kobe
and Jack playing on a team, so the Lakers become good. It’s not the
Knicks winning when the Knicks have Willis Reed and Clyde Frasier. It’s
the people who make up the team.

Get where I am going with this?

If you’re a decision maker at an agency, or running a company yourself,

and you’re disappointed because you’re not as good as some other
company, or you’re jealous that they are doing something you’re
not…stop it. Stop being jealous of their capabilities and go out and hire
for your client’s needs. Find the people that are doing it and make them
part of your team.
4. CULTURE COMES FROM THE TOP,
INCLUDING BAD CULTURE
I’ve talked a lot about how everything stems from the top when it comes
to company culture. The way you act and behave in your company
dictates a huge amount of how the culture will be.

Don’t like how some of your leadership is acting? It’s on you. Talk to
them. Set an example.

Want to establish a casual dress code? It starts with you.

Think the company needs to have less meetings? Once again, you need to
start having less meetings.

Everyone will be looking to you to dictate the situation. Don’t forget that
in your day to day around the office.
5. CREATE SPEED BY GIVING TRUST
The reason that so many companies and teams go slow is because first
time managers struggle to trust their employees.

So many people talk about how “trust is earned.” I think that’s slow and
egotistical. There comes a time when you have to let your kid “swing the
bat.” There comes a time when you have to throw them in the water and
let them swim.

That’s what I do from the start.

A lot of managers withhold trust because they fear the ramifications.

They fear the anxiety that comes with losing. They’re afraid of what will
happen when an employee messes up, or when mistakes happen.

When you’re afraid of losing in the short-term, you make people earn
your trust. Ultimately, that makes you go slower in the long term and it
hurts your chances of success.

I do the opposite — instead of putting restrictions around my employees

to start, I give them free reign. If and when they do something to lose my
trust, I’ll put restrictions around them.

Most managers do the reverse — they’ll put restrictions and barriers

around employees from the start, and remove them as they “prove”
themselves.

This is why so many managers tend to “micro-manage” up front. This is

especially the case when a manager is new to the role — because they’d
still be in that “execution” mindset that they had before they got to their
role and they’d find it difficult to hand everything over to someone else.
 1. Prepare Student mark Sheet using Edit Menu ,
Format Menu in Excel Sheet.
=
Class : 10th Session : 2016-17 Seat No. : A7009292
Gujarat Secondary & Higher Secondary Education Board , Gandhinagar
Marksheet of 10th Class

Name Dhruvik Tank Date of Birth 22-10-2001

Marks Obtained In Marks Obtained In

Subjects External Board School Evaluation
Passing Marks Total

Gujarati 42 21 33 63
Social Science 32 21 33 53
Science & Techno. 29 22 33 51
Mathematics 43 23 33 66
English 48 21 33 69
Sanskrit 25 24 33 49
Total
Total Total
219 132 Passing 198
Marks Marks
Marks

Grand Total of Marks Obtained 351

Percentage 58.50%
Result Pass
 2. Prepare Pay Sleep of Employee and also
make us Number tab , Alignment tab and
Formatting Sheets in Excel.
=

R.K. Industries Pvt. Ltd.

Industrial Phase 3 Ahmedabad - 123456
Monthly Salary Slip

Employee ID 7201963 Employee Name Dhruvik Tank

Designation Supervisor Month & Year Dec-20

Earnings Deductions
Basic 15000 Provident Fund 1500
Overtime 5000 E.S.I. 250
Conveyance 200 Loan 0
Extra income 2000 Tax 580.62
Total Addition 22200 Total Deducation 2330.62
Net Salary 19869.38

Signature of the Employee_____________________

Director____________________________________

R.K. Industries Pvt. Ltd.

Employee ID Employee Name Designation Month & Year Basic Overtime Amt. Conveyance Provident Fund Loan Tax Net Salary
A101 Shyam singh Grinder Operator Dec-20 35000 5000 500 1500 0 452 38548
A102 Ram singh Grinder Operator Dec-20 32000 5500 500 1500 0 540 35960
A103 Moham kumar Grinder Operator Dec-20 32000 4300 500 1300 0 260 35240
A104 Ravi varma Grinder Operator Dec-20 26000 1150 500 1200 6000 450 20000
A105 Satyam kumar Grinder Operator Dec-20 35000 0 500 1150 0 160 34190
A106 Sahil patel Helper Dec-20 12000 2000 300 480 0 120 13700
A107 Raj kishore Helper Dec-20 13000 1200 300 520 0 130 13850
A108 Shivam sharma Helper Dec-20 12000 200 300 460 0 56 11984
A109 Arpit shah Helper Dec-20 9000 1800 300 460 0 48 10592
A110 Nilesh shah Helper Dec-20 10000 600 300 520 0 160 10220
 3. Prepare Result analysis of class and
perform Sorting of Data , Inserting and
deleting cells , Cell Formating Moving
worksheets in excel.
=
S No. Name Maths Science Social & Sci. English Gujarati Sanskrit Total Percentage Result
1 Tirth Shah 76 82 65 70 85 62 440 73.33 Pass
2 Rahul Jethava 55 54 62 42 71 45 329 54.83 Pass
3 Yogesh Kakadiya 82 56 62 75 78 64 417 69.50 Pass
4 Shyam Patel 95 84 73 69 75 65 461 76.83 Pass
5 Arjun Rajput 62 76 68 56 63 57 382 63.67 Pass
6 Kuntal Shah 25 36 33 40 55 39 228 38.00 Fail
7 Dhara Tank 98 89 82 85 92 79 525 87.50 Pass
8 Sameer Patel 45 59 46 61 38 35 284 47.33 Pass
9 Maulik Vyas 68 75 71 68 82 41 405 67.50 Pass
10 Shruti Thakkar 86 79 67 62 0 76 370 61.67 Fail

120

100

80

60

40

20

0
1 2 3 4 5 6 7 8 9 10

Maths Science Social & Sci. English Gujarati Sanskrit

 4. Prepare GTU result analysis of student and
show using chart in excel.
=

Gujarat Technological University , Ahmedabad

Session : 2020-21
S No. Enrollment No. Name FCA FDE CP ECHM Mathematics English Result
1 D652 Dhruvik Tank AA AB BB BC AB AB Pass
2 D653 Dax Patel CC FF BC CA BA FF Fail
3 D654 Ved Bhaliya BB CC AB AC AA BC Pass
4 D655 Jay Sangani BC AB CC BA AA AC Pass
5 D656 Meet Dobariya AC BA AA AB CA BB Pass
6 D657 Harsh Shah CC FF CA FF FF CB Fail
7 D658 Dhara Tank AA BB AB AC BA CC Pass
8 D659 Shruti Yadav CC BA BA CC BC BB Pass
9 D660 Akshay Vyas AB AC BB CA BA AC Pass
10 D661 Rudra Sapariya CC CC BC FF BB FF Fail

FCA FDE CP ECHM Mathematics English

Total Student 10 10 10 10 10 10
Pass 10 8 10 8 9 8
Fail 0 2 0 2 1 2

Chart Title

English

Mathematics

ECHM

CP

FDE

FCA

0 2 4 6 8 10 12

Fail Pass Total Student

 5. Prepare Result analysis sheet with
conditional formatting.
=

J.P. International School

S No. Roll No. Name Physics Chemistry Biology English Sanskrit Total Percentage Result
1 D-157 Meet 45 56 59 36 41 237 39.50% Pass
2 D-158 Rahul 86 95 79 80 71 411 68.50% Pass
3 D-159 Smeet 76 52 63 56 60 307 51.17% Pass
4 D-160 Sahil 56 68 71 59 45 299 49.83% Pass
5 D-161 Harsh 33 56 12 15 29 145 24.17% Fail
6 D-162 Dhruvik 15 36 34 57 49 191 31.83% Fail
7 D-163 Ved 100 91 95 86 90 462 77.00% Pass
8 D-164 Divyesh 36 48 35 52 41 212 35.33% Pass
9 D-165 Jay 96 89 56 76 80 397 66.17% Pass
10 D-166 Yash 59 45 65 78 39 286 47.67% Pass
 19. Explain basic terms used in internet like

internet, WWW, browser, URL, HTTP, webpage,

website, search engine.

INTERNET:

The history of the Internet has its origin in the efforts to build

and interconnect computer networks that arose from research

and development in the United States and involved

international collaboration, particularly with researchers in

the United Kingdom and France.

WWW:

The World Wide Web (WWW) is a network of online content

that is formatted in HTML and accessed via HTTP. The term

refers to all the interlinked HTML pages that can be accessed

over the Internet. … The World Wide Web is most often

referred to simply as “the Web.”

Browser:

A web browser (commonly referred to as a browser) is a

software application for accessing information on the World

Wide Web. When a user requests a web page from a

particular website, the web browser retrieves the necessary

content from a web server and then displays the page on the

user’s device.

URL:

URL stands for Uniform Resource Locator. A URL is nothing

more than the address of a given unique resource on the Web.

… As the resource represented by the URL and the URL itself

are handled by the Web server, it is up to the owner of the

web server to carefully manage that resource and its

associated URL.

HTTP:

Stands for “Hypertext Transfer Protocol.” HTTP is the protocol

used to transfer data over the web. It is part of the Internet

protocol suite and defines commands and services used for

transmitting webpage data. HTTP uses a server-client model.

Webpage:

A web page or webpage is a document, commonly written in

HTML, that is viewed in an Internet browser. A web page can

be accessed by entering a URL address into a browser’s

address bar. A web page may contain text, graphics, and

hyperlinks to other web pages and files.

Website:

A website (also written as web site) is a collection of web

pages and related content that is identified by a common

domain name and published on at least one web server.

Notable examples are wikipedia.org, google.com, and

amazon.com. All publicly accessible websites collectively

constitute the World Wide Web.

Search engine:

A search engine is a website through which users can search

internet content. To do this, users enter the desired search

term into the search field. The search engine then looks

through its index for relevant websites and displays them in

the form of a list.

 20. Study basic of HTML, its use, basic structure of

HTML file. List of commonly used tags in HTML.

Study basic of HTML & It’s use:

HTML (Hypertext Mark-up Language) is the code that is used to

structure a web page and its content. For example, content

could be structured within a set of paragraphs, a list of bulleted

points, or using images and data tables.

Structure of HTML file:

The basic structure of any HTML document consists of the

following sections or elements: … The main container (html

element). The head section (head element). The body section (

body element).

List of commonly used tags in HTML.

<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

 21. Design HTML page for Bio-data and apply, formatting html

tag like bold, italic, underline, predefine headings tags,

paragraph, comments, fonts and colours.

CODE :

<!DOCTYPE html>
<html>
<body>
<head>
<title>Bio Data</title>
</head>
<p><h3><font color=”purple”><li><b>NAME: Dhruvik Rajeshbhai Tank
</h1></p></font></b></li>
<p><h3><font color=”green”><li>ADDRESS: B-
13, Sapna Appartment, Jyoti Jagruti ni same,
Thakkar nagar Approch, Ahmedabad-382345.
</li> </font></h1></p>
<p><h3><font color=”purple”><li>COURSE: diploma(computer)
engineering</li></font></h1></p>
<p><h3><font color=”blue”><li>INSTITUTE; Government polytechnic
Ahmedabad</li></font></h1></p>
<p><h3><font color=”orange”><li> Enorllment number : 206170307025
</li></font></h1></p>
<p><h3><font color=”pink”><li> habits : Music, Chess, Reading.
</li></font></h1></p>
<p><h3><font color=”gold”><li> birth date : 22-10-2001
</li></font></h1></p>
</body>
</html>
OUTPUT :
 22. Create a static webpage for your class time table using table tags of HTML.

CODE:

<!DOCTYPE html>
<html>
<head>
<title><h1>TIME TABLE</h1></title>
<body>
<table border=”1”>
<tr>
<th>day</th>
<th>10:00 to 11:00</th>
<th>11:00 to 12:00</th>
<th>12 ;00 to 1:00</th>
<th>1:00 to 1:30</th>
<th>1:30 to 2 :30</th>
<th>2:30 to 3 :30</th>
<th>3:30 to 4:30</th>
<th>4:30 to 5:30</th>
</tr>
<tr>
<th>Monday </th>
<th>Maths</th>
<th>ECHM</th>
<th>English</th>
<th>break</th>
<th> Maths</th>
<th> FCA lab</th>
<th>FCA lab </th>
<th>-</th>
</tr>
<tr>
<th>Tuesday</th>
<th>ECHM</th>
<th>Maths</th>
<th>CP</th>
<th>break</th>
<th>ECHM</th>
<th>FDE</th>
<th>FCA lab </th>
<th>FCA lab</th>
</tr>
<tr>
<th>Wednesday</th>
 <th> English </th>
<th> ECHM</th>
<th> CP </th>
<th> break</th>
<th> sport</th>
<th> FCA pab</th>
<th> FCA lab</th>
<th> - </th>
</tr>
<tr>
<th> Thursday</th>
<th> CP lab </th>
<th> FDE Lab </th>
<th> CP </th>
<th> break </th>
<th> Maths </th>
<th> English </th>
<th> CP lab </th>
<th> FDE lab </th>
</tr>
<tr>
<th> Friday </th>
<th> FCA lab </th>
<th> FDE </th>
<th > ECHM</th>
<th> break</th>
<th> CP </th>
<th> Maths </th>
<th> -</th>
<th> - </th>
</tr>
<tr>
<th>Saturday, Sunday public holiday</th>
</body>
</html>

OUTPUT :
 23.Prepare list of items using Ordered and unordered lists.

CODE:

<!DOCTYPE html>
<html>
<head>
<body>
<title>Order list</title><br>
<h1>Fruits</h1><br>
<ol>
<li>apple</li><br>
<li>mango</li><br>
<li>graphs</li><br>
<li>cherry</li><br>
<li>banana</li><br>
</ol>
<title>Unorder list</title>
<h1>Vegetables</h1><br>
<ul>
<li>Tomato</li><br>
<li>Cabbage</li><br>
<li>Matter</li><br>
<li>Garlic</li><br>
<li>Onion</li><br>
</ul>
</body>
</head>
</html>
OUTPUT :
 24. Design HTML page which contains images and create link for navigation in
different pages.

CODE :

<!DOCTYPE html>
<html>
<head>
<body>
<img src="/storage/emulated/0/Pictures/Screenshots/Screenshot_20210221-
190904.jpeg">
</body>
</head>
</html>
OUTPUT :
 25. Create a few HTML documents each explaining about district of your state.
The list of districts must appear in a frame. When we click on a district the details
must appear in another frame.

CODE :

<!DOCTYPE html>
<html>
<head>
<title>Gujarat State</title>
<h1>District</h1>
<a href=”ahemdabad.html”target=”f3”>Ahemdabad</a>
<br>
<a href=”surat.html”target=”f3”>Surat</a>
<br>
<a href=”vadodra.html”target=”f3”>Vadodra</a>
<br>
<a href=”ghandhinagar.html”target=”f3”>Ghandhinagar</a>
<br>
<a href=”bhavnagar.html”target=”f3”>Bhavnagar</a><br>
</head>
</html>
<html>
<head>
<h1>Surat</h1>
<body>
Surat is a large city beside the Tapi River in the west Indian state of
Gujarat. Once known for silk weaving, Surat remains a commercial
center for textiles, and the New Textile Market area is lined with fabric
shops. Overlooking the river, Surat Castle was built in the 1500s to
defend the city against Portuguese colonists.
<br>
</body>
</head>
</html>
Ahemdabad:
<html>
<head>
<h1>Ahemdabad</h1>
<body>
Ahmedabad, in western India, is the largest city in the state of Gujarat.
The Sabarmati River runs through its center. On the western bank is the
Gandhi Ashram at Sabarmati, which displays the spiritual leader’s living
quarters and artifacts.
</body>
</head>
</html>
Vadodara:
<html>
<head>
<h1>vadodra</h1>
<body>
Vadodara also known as Baroda, is the 3rd largest city in the Indian state
of Gujarat. It is the administrative headquarters of Vadodara District
and is located on the banks of the Vishwamitri river, 141 kilometres
from the state capital Gandhinagar.
</body>
</head>
</html>
Ghandhinagar:
<html>
<head>
<h1>Ghandhinagar</h1>
<body>
Gandhinagar is a planned city in the western Indian state of Gujarat.
The Akshardham is a massive Hindu temple with ornate carvings and
sculpted pillars, plus a water show in its sprawling gardens. Dandi Kutir
museum traces the life of leader Mahatma Gandhi, who was born in
Gujarat. South, along the Sabarmati River, the Indroda Nature Park has
a zoo and botanical gardens, plus an adjacent dinosaur and fossil park.
</body>
</head>
</html>
Bhavnagar:
<html>
<head>
<h1>Bhavnagar</h1>
<body>
Bhavnagar is a city in the Bhavnagar district of the Saurashtra region of
Gujarat, a state of India. It was founded in 1724 by Bhavsinhji Gohil. It
was the capital of Bhavnagar State, which was a princely state before it
was merged into the Indian Union in 1948.
</body>
</head>
</html>
OUTPUT :
 26. Design HTML file which contains Multimedia Objects like Video and sound file.

CODE :

<!DOCTYPE html>
<html>
<head>
<h1>vedio</h1>
<body>
<vedio src=”/storage/emulated/0/vediofile.mp4”>
</vedio>
</body>
</head>
</html>
OUTPUT :