kshitij info.tech project

7/27/2019 KSHITIJ Info.tech Project

1/39

INTRODUCTION TO IT

10219201712

BBA-1ST

- A

Lingayas Lalita Devi Institute of

Management & SciencesMANDI ROAD, MANDI, NEW DELHI

110047

Affiliated To

GURU GOBIND SINGH INDRAPRASTHA UNIVERSITY

Int roduct ion to IT

Lab Practical File

BBA - 113Semester 1

st

SUBMITTED TO: Ms. Sadhna Jha

NAME: KSHITIJ BISHT

ROLL NO. : 102 SECTION: A

BRANCH: BBA SESSION: 2012


2/39

INTRODUCTION TO IT

10219201712

BBA-1ST

- A

INDEX

S.No Topic Page No

1. Introduction to windows 1-4

2. Introduction to Microsoft word 5-13

3. Questions on Microsoft word 14-22

4. Question on Microsoft excel 23-34

5. Introduction on Microsoft power point 35-39

6.


3/39

INTRODUCTION TO IT

10219201712

BBA-1ST

- A


4/39

INTRODUCTION TO IT

10219201712

BBA-1ST

- A

WINDOWS

Windows is a personal computer operating system from Microsoftthat, together with some commonly used business applications

such as Microsoft Word and Excel, has become a de facto"standard" for individual users in most corporations as well as inmost homes. The original 1985 version of Windows introduced tohome and business PC users many of the graphical user interface(GUI) ideas that were developed at an experimental lab at Xerox andintroduced commercially by Apple's Lisa and Macintoshcomputers.

Contents

1 Versionso 1.1 Early versionso 1.2 Windows 3.0 and 3.1o 1.3 Windows 95, 98o 1.4 Windows XP, Vista and 71.5.1 64-bit operating systemso 1.5 Windows 8

2 History 3 Timeline of releases 4 Security

1. Write steps for :

Folder, Renaming, Coping and Deleting the Directory File Manipulation:

Creating a File, Deleting, Coping, Renaming a File In

ANSWER:

FOLDER

Following points will show how to create a folder;

Right click, the option bar will show up Select new. Select folder option. A new folder will be created.
http://en.wikipedia.org/wiki/Windows#Versionshttp://en.wikipedia.org/wiki/Windows#Early_versionshttp://en.wikipedia.org/wiki/Windows#Windows_3.0_and_3.1http://en.wikipedia.org/wiki/Windows#Windows_8http://en.wikipedia.org/wiki/Windows#Historyhttp://en.wikipedia.org/wiki/Windows#Timeline_of_releaseshttp://en.wikipedia.org/wiki/Windows#Timeline_of_releaseshttp://en.wikipedia.org/wiki/Windows#Historyhttp://en.wikipedia.org/wiki/Windows#Windows_8http://en.wikipedia.org/wiki/Windows#Windows_3.0_and_3.1http://en.wikipedia.org/wiki/Windows#Early_versionshttp://en.wikipedia.org/wiki/Windows#Versions


5/39

INTRODUCTION TO IT

10219201712

BBA-1ST

- A

RENAMING

Following points are used to rename the folder;

o Double click, on the name of the directory.

o In the text area insertion point or cursor will appear , after that type the nameyou want to give your directory.o After typing the name press enter button.

COPYING

To copy one should follow given points;

Select the data you want to copy . Right click, the option bar will show up .

Select copy option.

DELETING

Following points are required to delete data;

Select the data you want to delete. Right click, the option bar will show up. Select or click on delete option.

CREATING A FILE

Select the option file from the menu bar.1. From this menu, choose the potion new. The new dialog box will bedisplayed.

2. Click ok.

COPYING A FILE

I. Select the fileII. Right click on it

III. Option bar will appear. Select the copy option.

DELETING A FILE

A. Select the file.B. Right click on it.C. Option bar will appear. Select the delete option.

RENAMING A FILE

a. Double click, on the name of the directory.


6/39

INTRODUCTION TO IT

10219201712

BBA-1ST

- A

b. In the text area insertion point or cursor will appear, after that type the nameyou want to give your directory.

c. After typing the name press enter button.


7/39

INTRODUCTION TO IT

10219201712

BBA-1ST

- A


8/39

INTRODUCTION TO IT

10219201712

BBA-1ST

- A

MICROSOFT WORD

Microsoft word is a word processor designed by Microsoft. It was first released in

1983 under the name multi tool word for Xenix system. Microsoft word a full-

featured word processing program for windows and Mac from Microsoft. Availablestand-alone or as part of the Microsoft Office suite, word contain rudimentary

desktops publishing capabilities and is the most widely used word processing

program on market.

OR

Microsoft Office Word helps you produce professional-looking documents by

providing a comprehensive set of tools for creating and formatting your document in

the new Microsoft Office Fluent user interface. Rich review, commenting, and

comparison capabilities help you quickly gather and manage feedback fromcolleagues. Advanced data integration ensures that documents stay connected to

important sources of business information.

Feature of Microsoft word

New:

New command is use to open a new document. To open a New document click

on Office button then click on New and lastly click on Blank document and thenclick on Create button as given below.

Open:

From Open command we can open saved files. For example we have saved a fileby the name ofMicrosoft word and now we want to open it so firstly click on Office

button and then click on Open and lastly select your file and click open and we can

also open a file by the help of Shortcut key. To open a file by the help of shortcut keyclick Ctrl + O as given below.

Save:

This command is use to save a document. To save a file click Office button then

click Save command and type the name that in which name you want to save this

file. For example I want to save a file by the name ofMicrosoft notes and then I click

Save. The shortcut key forSave command is Ctrl+S.

Save As:


9/39

INTRODUCTION TO IT

10219201712

BBA-1ST

- A

Save As command is use to save a file by two or more than two names. What isdifference between Save and Save As command. Save command is use to savea document by only one name but In Save As command we can save a file by twoor more than two names. For example we have already saved a file by the name ofMicrosoft Word and now we want to save it by two names or more than two names

as given below. The shortcut key for Save As is F12.

Print:

To produce (a text, picture, etc.) by applying inked types, plates, blocks, or the like,

to paper or other material either by direct pressure or indirectly by offsetting an

image onto an intermediate roller.

Copy and paste:

The Microsoft Office Clipboard allows you to copy up to 24 multiple text and

graphical items from Office documents or other programs and paste them into

another Office document. For example, you can copy text from an e-mail message,

data from a workbook or datasheet, and a graphic from a presentation and then

paste them all into a document.

Print preview:

In word processing, print preview refers to formatting a document for the printer, but

then displaying it on the display screen instead of printing it. Print preview is more

commonly calledprevieworpreviewing.

Font:

A design for a set ofcharacters. A font is the combination oftypeface and other

qualities, such as size, pitch, and spacing. For example, Times Roman is a typeface

that defines the shape of each character. Within Times Roman, however, there aremany fonts to choose from -- different sizes, italic, bold, and so on. (The term fontisoften used incorrectly as a synonym fortypeface.)

Format Painter:
http://www.webopedia.com/TERM/P/word_processing.htmlhttp://www.webopedia.com/TERM/P/preview.htmlhttp://www.webopedia.com/TERM/P/preview.htmlhttp://www.webopedia.com/TERM/P/preview.htmlhttp://www.webopedia.com/TERM/P/preview.htmlhttp://www.webopedia.com/TERM/P/preview.htmlhttp://www.webopedia.com/TERM/P/preview.htmlhttp://www.webopedia.com/TERM/C/character.htmlhttp://www.webopedia.com/TERM/T/typeface.htmlhttp://www.webopedia.com/TERM/P/pitch.htmlhttp://www.webopedia.com/TERM/F/font.htmlhttp://www.webopedia.com/TERM/I/italic.htmlhttp://www.webopedia.com/TERM/B/boldface.htmlhttp://www.webopedia.com/TERM/B/boldface.htmlhttp://www.webopedia.com/TERM/I/italic.htmlhttp://www.webopedia.com/TERM/F/font.htmlhttp://www.webopedia.com/TERM/P/pitch.htmlhttp://www.webopedia.com/TERM/T/typeface.htmlhttp://www.webopedia.com/TERM/C/character.htmlhttp://www.webopedia.com/TERM/P/preview.htmlhttp://www.webopedia.com/TERM/P/preview.htmlhttp://www.webopedia.com/TERM/P/word_processing.html


10/39

INTRODUCTION TO IT

10219201712

BBA-1ST

- A

You can use the Format Painter on the Home tab to apply text formatting and some

basic graphics formatting, such as borders and fills. Select the text or graphic that

has the formatting that you want to copy. If you want to copy text formatting, select a

portion of a paragraph. If you want to copy text and paragraph formatting, select an

entire paragraph, including the paragraph mark. On the Home tab, in the Clipboardgroup, click Format Painter. The pointer changes to a paintbrush icon. Double-click

the Format Painter button if you want to change the format of multiple selections in

your document. Select the text or graphic that you want to format.

Paragraph:Indentation determines the distance of the paragraph from either the left or the right

margin. Within the margins, you can increase or decrease the indentation of a

paragraph or group of paragraphs. You can also create a negative indent (alsoknown as an outdent), which pulls the paragraph out toward the left margin. You canalso create a hanging indent, in which the first line of the paragraph is not indented.

Style:

A style is a set of formatting characteristics, such as font name, size, colour,

paragraph alignment and spacing. Some styles even include borders and shading.

For example, instead of taking three separate steps to format your heading as 16-

point, bold, Cambria, you can achieve the same result in one step by applying the

built-in Heading 1 style. You do not need to remember the characteristics of the

Heading 1 style. For each heading in your document, you just click in the heading

(you don't even need to select all the text), and then click Heading 1 in the gallery of

styles.

Mail Merge:

Mail merge when you want to create a set of documents, such as a form letter that is

sent to many customers. Each letter has the same kind of information, yet thecontent is unique. For example, in letters to your customers, each letter can be

personalized to address each customer by name. The unique information in eachletter comes from entries in a data source.


11/39

INTRODUCTION TO IT

10219201712

BBA-1ST

- A

Spell Check:

Spelling and grammar mistakes can distract readers from the work that you put intoyour documents, so you want to eliminate these mistakes. Even so, you probably

have your own preferences for how to use your Microsoft Office program to help you

do this. You might prefer to check spelling all at once when you finish a document.Or you might want to use automatic spelling and grammar checking (the wavy red,blue, and green lines) to keep mistakes to a minimum while you work.

Find and replace:

Find and replace text, formatting, paragraph breaks, page breaks, and other items.

You can also find and replace noun or adjective forms or verb tenses. You can

extend your search by using wildcards and codes to find words or phrases that

contain specific letters or combinations of letters.

Bullets:

Bullets in the Text pane corresponds to information that is used to arrange your

SmartArt graphic. Each SmartArt graphic defines its own mapping between the

bullets in the Text pane and the set of shapes in the SmartArt graphic. Depending on

the SmartArt graphic that you choose, each bullet in the Text pane will be

represented as either a new shape or a bullet inside a shape. A bullet inside a shapeindicates that the corresponding text is at a lower level than the text above it.

Hyperlink:

To link to an existing file or Web page, click Existing File or Web Page under Link to,

and then type the address that you want to link to in the Address box. If you don't

know the address for a file, click the arrow in the Look in list, and then navigate to

the file that you want.

Header and Footer:

You can insert or change text or graphics in headers and footers. For example, you

can add page numbers, the time and date, a company logo, the document title or file

name, or the author's name.
http://appendpopup%28this%2C%27601470644_1%27%29/http://appendpopup%28this%2C%27601470644_1%27%29/


12/39

INTRODUCTION TO IT

10219201712

BBA-1ST

- A

Page Number:

If your document has multiple pages, you can display the page number on each

page. In most documents, page numbers appear in either the header or the footer of

each page. Microsoft Office Word has many preformatted page number designs so

that you can quickly insert headers or footers that display the page number.

Page Background:

Multitasking computers are capable of executing several tasks, or programs, at the

same time. In some multitasking systems, one of the processes is called the

foregroundprocess , and the others are called background processes.

Symbols:

You can use the Symbol dialog box to insert symbols, such as and , or special

characters, such as an em dash () or ellipsis () that are not on your keyboard, as

well as Unicode characters. The types of symbols and characters that you can insert

depend on the font that you choose.

Outline:

An outline is the exterior border around each character of your text or WordArt.

When you change the outline of text, you can also adjust the colour, weight, and

style of the line.

Clip Art:

Clip art is a collection of pictures or images that can be imported into a document or

another program. The images may be either raster graphics or vector graphics. Clip

art galleries many contain anywhere from a few images to hundreds of thousands of

images.


13/39

INTRODUCTION TO IT

10219201712

BBA-1ST

- A

Drop Cap:

In desktop publishing, the first letter of a paragraph that is enlarged to "drop" downtwo or more lines, as in the next paragraph. Drop caps are often seen at the

beginning of novels, where the top of the first letter of the first word lines up with thetop of the first sentence and drops down to the four or fifth sentence.

Web Layout:

This view mode should be used when working with webpages in Microsoft Word.

Alignment of different elements will appear as they would display in a web browser.

Full screen:

Full Screen view hides most of the interface (toolbars, the menu, and the Status bar)

allowing your Word or Excel document to fill the screen. Simply choose Full Screen

from the View menu.

Print layout:

In this IMG activity, you define templates (layouts) with which you can print header

and operation data via Microsoft Word .Depending on the layout, one or more pages

can be printed per header or operation, which you select in the Engineering

Workbench.

Zoom:

You can zoom in to get a close-up view of your file or zoom out to see more of the

page at a reduced size. You can also save a particular zoom setting with a document

or template, presentation, or worksheet.

Page Background:


14/39

INTRODUCTION TO IT

10219201712

BBA-1ST

- A



foreground process , and the others are called background processes.

Page Setup:

There are several sizes or dimensions of paper available today on which a document

can be printed. Depending on the capabilities of your printer, you can print a

document on common paper sizes such as A4, Letter, Legal, Tabloid, etc, or you can

type dimensions forcustom paper sizes. The paper size you choose will also help

Word in calculating and leaving appropriate margins for the pages.


15/39

INTRODUCTION TO IT

10219201712

BBA-1ST

- A

WORD PRACTICAL QUESTIONS

Question 1. Insert an image from the clip art and wrap the text

around the image?

ANSWER:

STEPS

FIRST CLICK ON INSERT ON TOOLBAR

THEN CLICK ON THE OPTION OF INSERT PICTURE

THEN CLICK ON THE FORMAT OPTION

CLICK ON TEXT WRAPING OPTION

Information technology (IT) is concerned with the development, management,

and use of computer-based information systems. Humans have been storing,retrieving, manipulating and communicating information since theSumerians in Mesopotamia developed writing in about 3000 BC,but the term"information technology" in its modern sense first appeared in a 1958 articlepublished in theHarvard Business Review; authors Leavitt and Whisler commentedthat "the new technology does not yet have a singleestablished name. We shall call it informationtechnology (IT)." Based on the storage and processingtechnology employed, it is possible to distinguish fourdistinct phases of IT development: pre-mechanical (3000 BC 1450 AD), mechanical

(14501840), electromechanical (18401940) and electronic.[1]This article focuses on the latter of those periods, whichbegan in about 1940.

The Information Technology

Association of America has defined

information technology (IT) as "the

study, design, development,

application, implementation,

support or management of

computer- based information
http://en.wikipedia.org/wiki/Sumerhttp://en.wikipedia.org/wiki/Mesopotamiahttp://en.wikipedia.org/wiki/Cuneiformhttp://en.wikipedia.org/wiki/Harvard_Business_Reviewhttp://en.wikipedia.org/wiki/Harvard_Business_Reviewhttp://en.wikipedia.org/wiki/Harvard_Business_Reviewhttp://en.wikipedia.org/wiki/Information_technology#cite_note-Butler-1http://en.wikipedia.org/wiki/Information_technology#cite_note-Butler-1http://en.wikipedia.org/wiki/Information_technology#cite_note-Butler-1http://en.wikipedia.org/wiki/Information_Technology_Association_of_Americahttp://en.wikipedia.org/wiki/Information_Technology_Association_of_Americahttp://en.wikipedia.org/wiki/Information_Technology_Association_of_Americahttp://en.wikipedia.org/wiki/Information_Technology_Association_of_Americahttp://en.wikipedia.org/wiki/Information_Technology_Association_of_Americahttp://en.wikipedia.org/wiki/Information_Technology_Association_of_Americahttp://en.wikipedia.org/wiki/Information_technology#cite_note-Butler-1http://en.wikipedia.org/wiki/Harvard_Business_Reviewhttp://en.wikipedia.org/wiki/Cuneiformhttp://en.wikipedia.org/wiki/Mesopotamiahttp://en.wikipedia.org/wiki/Sumer


16/39

INTRODUCTION TO IT

10219201712

BBA-1ST

- A

systems", but the term has also been applied more narrowly to describe a branch of

engineering dealing with the use of computers andtelecommunications equipment to

store, retrieve, transmit and manipulate data. Although commonly used to refer to

computers and computer networks, IT encompasses other information-distribution

technologies such as television and telephones, a wider field more explicitly knownas information and communications technology.

Question 2. Create a snapshot of a newspaper with 3 columns and

news headings merging across 3 columns?

ANSWER:

STEPS

FIRST WRITE DOWN THE CONTENT. THEN SELECT THE DATA EXCLUDING HEADLINE. THEN CLICK ON THE PAGE LAYOUT. THEN CLICK ON THE COLUMN OPTION AND SELECT THE

NO. OF COLUMN YOU WANT.

Barack Obama's victory
http://en.wikipedia.org/wiki/Information_and_communications_technologyhttp://en.wikipedia.org/wiki/Information_and_communications_technologyhttp://en.wikipedia.org/wiki/Information_and_communications_technology


17/39

INTRODUCTION TO IT

10219201712

BBA-1ST

- A

Barack Hussein Obamawas re-electedpresident of the UnitedStates on Tuesday,overcoming powerful

economic headwinds, alock-step resistance tohis agenda byRepublicans inCongress and anunprecedented torrentof advertising as adivided nation voted togive him more time.In defeating MittRomney, the president

carried Colorado, Iowa,

Ohio, New Hampshire,Virginia and Wisconsin,a near sweep of thebattleground states,and was holding a

narrow advantage inFlorida. The path tovictory for Romneynarrowed as the nightwore along, withObama winning at least303 electoral votes.A cheer of jubilationsounded at the Obamacampaign headquartersin Chicago when the

television networks

began projecting himas the winner at 11:20p.m., even as theballots were still beingcounted in many

states where votershad waited in linewell into the night.The victory wasnarrower than hishistoric election fouryears ago, but itwas no lessdramatic.


18/39

INTRODUCTION TO IT

10219201712

BBA-1ST

- A

Question 3. Create a Time table.

ANSWER

STEPS

CLICK ON INSERT OPTION IN TOOLBAR. THEN CLICK ON THE TABLE OPTION. THEN CHOOSE COLUMNS AND ROWS ACCORDING TO

YOUR REQUIREMENT.

THEN WRITE DOWN THE TIMETABLE.

TIME TABLE

DAYS/PERIO

DS

I

(9-

9:55)

II

(9:55-

10:50)

III

(10:50-

11:45)

IV

(11:45-

12:40)

(12:4

0-

1:35)

V

(1:35-

2:30)

VI

(2:30-

3:25)

VII

(3:25-

4:00)

MONDAY PDCS POM IT MATHS L LAB BE LIB

TUESDAY PDCS FA IT MATHS U MATHS POM LAB

WEDNESDAY FA BE MATHS MATHS N PDCS POM FREE

THURSDAY BE POM FA MATHS C LAB LIB FREE

FRIDAY BE FA PDCS MATHS H LIB BE LIB


19/39

INTRODUCTION TO IT

10219201712

BBA-1ST

- A

Question 4. Create a list using different types of bullets & numbering feature.

Answer

STEPS

On the Edit menu, click Replace.

In the Find what box, enter the text that you want to search for.

In the Replace with box, enter the replacement text.

Select any other options that you want.

Click Find Next, Replace, orReplace All.

Text Using Numbers

FEATURES OF WORD PROCESSOR

Following points given below are some features of word processor;1. Fast; Typing text in the word processor becomes speedy as there

is no mechanical carriage movement associated.2. Editing features; Any type of correction like insertions, deletions,

modifications etc., can be made easily as and when required.3. Permanent storage; With word processors, documents can be saved as

long as desired. The saved document can be retrieved whenever desired.4. Formatting features; The typed text can be made to appear in any formor style (bold, italic, underlines, different fonts etc.) All this is possible dueto formatting features of word processors.

5. Graphics; Most modern word processors provide the facility ofincorporating drawings in the documents which enhances theirusefulness.

6. Spell check; Word processors not only are capable of checking spellingmistakes but also can suggest possible alternatives for incorrectly speltwords. Some word processor can check for grammatical mistakes andsuggest alternatives or improvements.

7. Mail merges; the mail merge facility enables you to print a largenumbers of letters /documents with more or less similar text.

Question 5. Give an example of mail-merge with proper steps.

ANSWER:

Steps

The three main components of the merging process are;

Main document


20/39

INTRODUCTION TO IT

10219201712

BBA-1ST

- A

Data sources

Merged document

Data sources

1. Select file menus new to open a new document.

2. Select insert table command from table drop down menu to insert a table.

3. Enter the data.

4. Save data source file.

MERGING SOURCE TO THE MAIN DOCUMENT

Make the main document the active document the active window, where you

want to write the letter.

Choose tools, mail merge to open the mail merge helper dialog box.

Click on create button, and choose the option from letters

Click on get data button and choose open data source option.

Select the name of your data source file.

Click on open

Click on edit main document.

To insert fields names in the main document by using the mail merge toolbar

Place the insertion point where you want your data to appear. Thenclick on

insert merge field button.

Choose the column you want to appear first and so on

Similarly you can insert other fields also at the place you want.

If you want to view the resultant merged data, then click on view merged data

button on mail merge tool bar. Te resultant merged document will be

displayed.

To,

HOD

Pranav mishra


21/39

INTRODUCTION TO IT

10219201712

BBA-1ST

- A

Subject: INVITATION OF INTERNATIONAL SEMINAR

Respected,

On 23november our college lldims is conducting a seminar regarding Information

technology. All the students and faculty members of very department is invited.

. The chief guest of this seminar is APJ ABDUL KALAM. Persons who want to attend

this seminar kindly submit their names to their respective HODs.

Thanking you

Yours faithfully

KSHITIJ

Coordinator

Question 6. Create your personal profile.

ANSWER:

NAME: KSHITIJ BISHT

E- Mail: [email protected] ADDRESSMobile No. : 9582315992 1206 laxmi bai nagar new delhi-110023

Educational Qualifications

S.no. Exam passed University Percentage/gradepoint

1 High school 70.00%

2

Extracurricular activities

playing cricket volleyball


22/39

INTRODUCTION TO IT

10219201712

BBA-1ST

- A

Languages known

English, Hindi

Interest Playing cricket Reading novels

Skills

Microsoft office(03,07) Microsoft excel Microsoft power point

Personal Attributes

Optimistic Goal oriented

Personal Data

Date of Birth - 03-06-1994Gender - Male

QUESTION7.GENERATE AN OUTPUR WITH GRAPHICS IN

BACKGROUND.

Answer:

Education in India is provided by the public sectoras well as the private sector, with

control and funding coming from three levels: central, state, and local. The Nalanda

University was the oldest university-system of education in the world. Western

education became ingrained into Indian society with the establishment of the British

Raj. Education in India falls under the control of both the Union Government and

the states, with some responsibilities lying with the Union and the states having

autonomy for others. The various articles of the Indian Constitution provide for

education as a fundamental right. Most universities in India are controlled by the
http://en.wikipedia.org/wiki/Public_sectorhttp://en.wikipedia.org/wiki/Private_sectorhttp://en.wikipedia.org/wiki/Government_of_Indiahttp://en.wikipedia.org/wiki/State_governmenthttp://en.wikipedia.org/wiki/Local_governmenthttp://en.wikipedia.org/wiki/Nalanda_Universityhttp://en.wikipedia.org/wiki/Nalanda_Universityhttp://en.wikipedia.org/wiki/British_Rajhttp://en.wikipedia.org/wiki/British_Rajhttp://en.wikipedia.org/wiki/Republic_of_Indiahttp://en.wikipedia.org/wiki/Government_of_Indiahttp://en.wikipedia.org/wiki/States_and_Territories_of_Indiahttp://en.wikipedia.org/wiki/Indian_Constitutionhttp://en.wikipedia.org/wiki/Indian_Constitutionhttp://en.wikipedia.org/wiki/States_and_Territories_of_Indiahttp://en.wikipedia.org/wiki/Government_of_Indiahttp://en.wikipedia.org/wiki/Republic_of_Indiahttp://en.wikipedia.org/wiki/British_Rajhttp://en.wikipedia.org/wiki/British_Rajhttp://en.wikipedia.org/wiki/Nalanda_Universityhttp://en.wikipedia.org/wiki/Nalanda_Universityhttp://en.wikipedia.org/wiki/Local_governmenthttp://en.wikipedia.org/wiki/State_governmenthttp://en.wikipedia.org/wiki/Government_of_Indiahttp://en.wikipedia.org/wiki/Private_sectorhttp://en.wikipedia.org/wiki/Public_sector


23/39

INTRODUCTION TO IT

10219201712

BBA-1ST

- A

Union or the State Government. India has made progress in terms of

increasing primary education attendance rate and expanding literacy to

approximately two thirds of the population. India's improved education system is

often cited as one of the main contributors to the economic rise of India. Much of the

progress especially in Higher education, Scientific research has been credited to

various public institutions. The private education market in India is merely 5%

although in terms of value is estimated to be worth $40 billion in 2008 and will

increase to $6870 billion by 2012.

QUESTION 8.CREATE FRONT STYLE OF DIFFERENT SIZE.

STEPS.

CLICK ON HOME. NOW SELECT FRONT, FRONT SIZE,COLOUR ETC. NOW TYPE THE DATA.

BBA I SEMESTER- MONOTYPE CURSIVABBA I SEMESTER-TIMES NEW ROMANBBA I SEMESTER COMICS SANS MS
http://en.wikipedia.org/wiki/Primary_educationhttp://en.wikipedia.org/wiki/Literacy_in_Indiahttp://en.wikipedia.org/wiki/Economic_development_in_Indiahttp://en.wikipedia.org/wiki/Economic_development_in_Indiahttp://en.wikipedia.org/wiki/Literacy_in_Indiahttp://en.wikipedia.org/wiki/Primary_education


24/39

INTRODUCTION TO IT

10219201712

BBA-1ST

- A


25/39

INTRODUCTION TO IT

10219201712

BBA-1ST

- A

MICROSOFT EXCEL

Microsoft Excel has the basic features of all spreadsheets, using a gridof cells arranged in numbered rows and letter-named columns to

organize data manipulations like arithmetic operations. It has a battery of

supplied functions to answer statistical, engineering and financial needs.

In addition, it can display data as line graphs, histograms and charts,

and with a very limited three-dimensional graphical display. It allows

sectioning of data to view its dependencies on various factors for

different perspectives (using pivot tables and the scenario manager). It

has a programming aspect, Visual Basic for Applications, allowing theuser to employ a wide variety of numerical methods, for example, for

solving differential equations of mathematical physics, and then

reporting the results back to the spreadsheet. An Excel application can

automatically poll external databases and measuring instruments using

an update schedule, analyse the results, make a Word report orPower

Point slide show, and e-mail these presentations on a regular basis to a

list of participants.

Ms-Excel

QUESTION
http://en.wikipedia.org/wiki/Pivot_tablehttp://en.wikipedia.org/wiki/Microsoft_Wordhttp://en.wikipedia.org/wiki/Microsoft_PowerPointhttp://en.wikipedia.org/wiki/Microsoft_PowerPointhttp://en.wikipedia.org/wiki/Microsoft_PowerPointhttp://en.wikipedia.org/wiki/Microsoft_PowerPointhttp://en.wikipedia.org/wiki/Microsoft_Wordhttp://en.wikipedia.org/wiki/Pivot_table


26/39

INTRODUCTION TO IT

10219201712

BBA-1ST

- A

1. Enter data in a worksheet as shown:

A B C D

1 PACE ICE CREAM PARLOUOR

2

3 FLAVOUR QUANTITY RATE AMOUNT

4

5 PISTA 14 7

6 VANILLA 20 12

7 TUTI 4 8

8 FROOTI 5 10

9 CASSATA 6 35

10 MANGO 7 15

11 KESAR 8 15

12

FIG 1

A B C D

1 PACE ICE CREAM PARLOUOR


27/39

INTRODUCTION TO IT

10219201712

BBA-1ST

- A

2

3 FLAVOUR QUANTITY RATE AMOUNT

4

5 PISTA 14 7 98

6 VANILLA 20 12 240

7 TUTI 4 8 32

8 FROOTI 5 10 50

9 CASSATA 6 35 210

10 MANGO 7 20 140

11 KESAR 8 15 120

12 Total Sales =855

FIG 2

A. Save the workbook as sales.xlsAnswer- Select the sheet option which is on scallop bar and right click on it

and rename it.B. Minimize the workbook sales.xls and then restore it to its original size.

Answer Select the option minimize which is on the toll bar.C. Calculate the total sales (Amount column in the worksheet) for each flavour by

multiplying the quantity and rate.Answer- To calculate the total sales multiply the Quantity and sales. Formula=If(B9*C9)

D. The management of Cream Parlour wishes to find out the total sales at the end ofthe day. Modify the sales.xls to fulfil the requirement. After calculating the total,the worksheet should look like the one in fig 2.

Answer. Total Sales =855

E. Change the rate of Kesar from 15 to 20. Observe that the formula getsrecalculated.

Save the workbook again.

Answer There is Change in the rate of Kesar 105to 140.

2. Given the following sales details for 4 salesmen. Calculate theircommission using the commission rate 10% for the total sales.


28/39

INTRODUCTION TO IT

10219201712

BBA-1ST

- A

Salesman No. Qtr1 Qtr2 Qtr3 Qtr4

501 3000 3000 4500 5500

502 4000 3500 4200 4300

503 4000 4000 4500 4500

504 6000 6000 5000 6000

Step

Select all the data and the select the option insert chart, pie chart and area.

0

50000

100000

150000

200000

250000

300000

1 2 3 4 5 6 7 8 9 10

QUATER4

QUATER3

QUATER2

QUATER1

SALESMEN


29/39

INTRODUCTION TO IT

10219201712

BBA-1ST

- A

0

10

20

30

40

50

60

70

80

90

1st Qtr 2nd Qtr 3rd Qtr 4th Qtr


30/39

INTRODUCTION TO IT

10219201712

BBA-1ST

- A

3. Enter the following data in the worksheet:A B C D E F

1 Roll No Name English Maths Science Total

2 001 Sachin 98 72 64

3 002 Sehwag 56 58 93

4 003 Sourav 58 96 94

5 004 Rahul 52 34 91

6 005 Seema 52 75 65

7 006 Sunita 47 26 89

8 007 Savita 69 90 74

9 008 Raju 20 82 87

10 009 Raman 96 86 90

11 010 Ritu 45 45 36

12 011 Meena 68 65 23

A. From the worksheet find out the average marks for the entire class.Answer Select all the marks of the all students and select the option formulawhich is on toll bar and then click on the option on average.

B. Now copy the range consisting of the mentioned data (including total, average &class average) to a new location. Find out whether the cell references change ornot.

Answer Select all the data and right click on it and select option copy andthen paste it by right click on new location. There is no change in the data.

C. Now move back the data range to a new location. Find out whether the cellreference change or not.

Answer Again select all the data and right click on it, select the option copyand paste it by right click on new option. There is no change in the data.

D. Again move back the data to its original position and make changes in themarks obtained by students. Notice total, average and class average. Whathappens?

Answer Select all data again and select option copy by right clicks it on and movesback the data on its original position. There is no change in the data.


31/39

INTRODUCTION TO IT

10219201712

BBA-1ST

- A

A B C D E F G

1 Roll

No

Name English Maths Science Total Average

2 1 Sachin 98 72 64 234 78

3 2 Sehwag 56 58 93 207 694 3 Sourav 58 96 94 248 82.66667

5 4 Rahul 52 34 91 177 59

6 5 Seema 52 75 65 192 64

7 6 Sunita 47 26 89 162 54

8 7 Savita 69 90 74 233 77.66667

9 8 Raju 20 82 87 189 63

10 9 Raman 96 86 90 272 90.66667

11 10 Ritu 45 45 36 126 42

12 11 Meena 68 65 23 156 52

4. Enter the following data in the Worksheet.Book Inventory Details

Product ID Title Publisher

Name

Date

Published

List

Price

Instock Amount

501 Ms-Word S.Jain 04.12.90 200 10

502 Ms-Excel P.K. Sinha 07.07.90 150 15

506 Java S.Jain 08.06.92 275 19

504 C++ V.K. Ohri 12.08.96 306 20

A. Calculate the amount.

Answer

Amount = List price multiply by in stock. Formula =if(c2*d2)=2000.B. Calculate the total books in the entire stock.Answer Select all the data of instock and select the option formula which ison toll bar on the excel and last select option sum,

C. Calculate Average price of books.AnswerSelect all the data of amount and select the option formula on thetool bar and select the average option.

D. Sort entire list in ascending or descending order of Product Ids.AnswerSelect all the data of Product ID and right click on it and select theoption sort and last click on ascending or descending option.

Book Inventory Details


32/39

INTRODUCTION TO IT

10219201712

BBA-1ST

- A

Product

ID

Title Publisher

Name

Date

Published

List

Price

Instock Amount

501 Ms-

Word

S.Jain 04.12.90 200 10 2000

502 Ms-

Excel

P.K.

Sinha

07.07.90 150 15 2250

506 Java S.Jain 08.06.92 275 19 5225

504 C++ V.K. Ohri 12.08.96 306 20 6120

total

books=64

Average

+3898.75


33/39

INTRODUCTION TO IT

10219201712

BBA-1ST

- A

5. Given the following worksheet.

A B C D E F G

1 Roll No Name English Maths Science Total Grade

2 001 Sachin 98 72 64

3 002 Sehwag 56 58 93

4 003 Sourav 58 96 94

5 004 Rahul 52 34 91

6 005 Seema 52 75 65

7 006 Sunita 47 26 89

8 007 Savita 69 90 74

9 008 Raju 20 82 87

10 009 Raman 96 86 90

11 010 Ritu 45 45 36

12 011 Meena 68 65 23

Calculate the grade of these students on the basis of following guidelines:

IF Marks Then Grade

>=80 A+

>=60=50=60,A,IF(C2>=50,B,F)))=(A+,A,B,F)

To calculate the amount selects all the marks of all the students and select the

option formula which is on tool bar and selects the option sum.

A B C D E F G

1 RollNo

Name English Maths Science Total Grade


34/39

INTRODUCTION TO IT

10219201712

BBA-1ST

- A

2 1 Sachin 98 72 64 234 A+

3 2 Sehwag 56 58 93 207 A+

4 3 Sourav 58 96 94 248 A+

5 4 Rahul 52 34 91 177 A

6 5 Seema 52 75 65 192 A7 6 Sunita 47 26 89 162 A

8 7 Savita 69 90 74 233 B

9 8 Raju 20 82 87 189 B

10 9 Raman 96 86 90 272 B

11 10 Ritu 45 45 36 126 F

12 11 Meena 68 65 23 156 F

6. Given the following worksheetSalesman No. Qtr1 (Sales

in Rs.)

Qtr2 (Sales

in Rs.)

Qtr3 (Sales

in Rs.)

Qtr4 (Sales

in Rs.)

Total Commission

501 30000 30000 45000 5500

502 40000 35000 42000 43000

503 40000 40000 45000 45000

504 60000 60000 50000 60000

Calculate the commission earned by these salesmen on the basis of the

following guidelines:

If total Sales Commission

20000 and 25000 and 30000 and =35000 11% of sales

ANSWERTo calculate the total select all the data of all Quarters and select the

option formula which is in tool bar of excel and select the option sum.


35/39

INTRODUCTION TO IT

10219201712

BBA-1ST

- A

To Calculate the

Commision=IF(F3>=350000,F3*0.11,IF(F3>=30000,F3*0.08,IF(F3>=250

00,F3*0.055,IF(F3>=20000,F3*0.04,0))))=(8840,12800,13600,18400)

SALESMAN

NO. QTR 1 QTR 2 QTR 3 QTR 4

TOTAL

SALES COMMISION

501 30000 30000 45000 5500 110500 8840

502 40000 35000 42000 43000 160000 12800

503 40000 40000 45000 45000 170000 13600

504 60000 60000 50000 60000 230000 18400


36/39

INTRODUCTION TO IT

10219201712

BBA-1ST

- A


37/39

INTRODUCTION TO IT

10219201712

BBA-1ST

- A

Microsoft power point

PowerPoint presentations consist of a number of individual pages or"slides". The "slide" analogy is a reference to the slide projector. A betteranalogy would be the "foils" (or transparencies/plastic sheets) that areshown with an overhead projector, although they are in decline now.Slides may contain text, graphics, sound, movies, and other objects,which may be arranged freely. The presentation can be printed,displayed live on a computer, or navigated through at the command ofthe presenter. For larger audiences the computer display is oftenprojected using a video projector. Slides can also form the basisofwebcasts.

Features of power point

Animation:

Custom Animation is a set of effects which can be applied to objects in PowerPointso that they will animate in the Slide Show. They can be added under the Custom

Animation function or through the use ofVisual Basic for Applications (VBA).

PowerPoint 2000 and earlier versions introduced basic effects such as Appear,

Dissolve, Fly In and so forth. In PowerPoint 2002/XP and later versions, the Custom

Animation feature was improved, adding new animation effects grouped into four

categories: Entrance, Emphasis, Exit, and Motion Paths.[1]The effects were later

modified in PowerPoint 2010. Transitions are effects similar to Custom Animation,

but are different in that they can only be applied singularly to individual slides as theychange from one slide to another and are limited in options. More slide transitions

were added to the selection in PowerPoint

Style:

A style is a set of formatting characteristics, such as font name, size, colour,

paragraph alignment and spacing. Some styles even include borders and shading.

For example, instead of taking three separate steps to format your heading as 16-
http://en.wikipedia.org/wiki/Slide_projectorhttp://en.wikipedia.org/wiki/Overhead_projectorhttp://en.wikipedia.org/wiki/Video_projectorhttp://en.wikipedia.org/wiki/Webcastshttp://en.wikipedia.org/wiki/Visual_Basic_for_Applicationshttp://en.wikipedia.org/wiki/PowerPoint_animation#cite_note-CustomAnimation-0http://en.wikipedia.org/wiki/PowerPoint_animation#cite_note-CustomAnimation-0http://en.wikipedia.org/wiki/PowerPoint_animation#cite_note-CustomAnimation-0http://en.wikipedia.org/wiki/Office_2010http://en.wikipedia.org/wiki/Film_transitionhttp://en.wikipedia.org/wiki/Film_transitionhttp://en.wikipedia.org/wiki/Office_2010http://en.wikipedia.org/wiki/PowerPoint_animation#cite_note-CustomAnimation-0http://en.wikipedia.org/wiki/Visual_Basic_for_Applicationshttp://en.wikipedia.org/wiki/Webcastshttp://en.wikipedia.org/wiki/Video_projectorhttp://en.wikipedia.org/wiki/Overhead_projectorhttp://en.wikipedia.org/wiki/Slide_projector


38/39

INTRODUCTION TO IT

10219201712

BBA-1ST

- A

point, bold, Cambria, you can achieve the same result in one step by applying the

built-in Heading 1 style. You do not need to remember the characteristics of the

Heading 1 style. For each heading in your document, you just click in the heading

(you don't even need to select all the text), and then click Heading 1 in the gallery of

styles.

Clip Art:

Clip art is a collection of pictures or images that can be imported into a document or

another program. The images may be either raster graphics or vector graphics. Clip

art galleries many contain anywhere from a few images to hundreds of thousands of

images.

Page Background:



foreground process , and the others are called backgroundprocesses.

Symbols:

You can use the Symbol dialog box to insert symbols, such as and , or special

characters, such as an em dash () or ellipsis () that are not on your keyboard, as

well as Unicode characters. The types of symbols and characters that you can insert

depend on the font that you choose.

Bullets:

Bullets in the Text pane corresponds to information that is used to arrange your

SmartArt graphic. Each SmartArt graphic defines its own mapping between the

bullets in the Text pane and the set of shapes in the SmartArt graphic. Depending on

the SmartArt graphic that you choose, each bullet in the Text pane will be

represented as either a new shape or a bullet inside a shape. A bullet inside a shape

indicates that the corresponding text is at a lower level than the text above it.


39/39

INTRODUCTION TO IT

Format Painter:

You can use the Format Painter on the Home tab to apply text formatting and some

basic graphics formatting, such as borders and fills. Select the text or graphic thathas the formatting that you want to copy. If you want to copy text formatting, select a

portion of a paragraph. If you want to copy text and paragraph formatting, select an

entire paragraph, including the paragraph mark. On the Home tab, in the Clipboard

group, click Format Painter. The pointer changes to a paintbrush icon. Double-click

the Format Painter button if you want to change the format of multiple selections in

your document. Select the text or graphic that you want to format.

Font:A design for a set ofcharacters. A font is the combination oftypeface and otherqualities, such as size, pitch, and spacing. For example, Times Roman is a typeface

that defines the shape of each character. Within Times Roman, however, there aremany fonts to choose from -- different sizes, italic, bold, and so on. (The term fontisoften used incorrectly as a synonym for typeface.)
http://www.webopedia.com/TERM/C/character.htmlhttp://www.webopedia.com/TERM/T/typeface.htmlhttp://www.webopedia.com/TERM/P/pitch.htmlhttp://www.webopedia.com/TERM/F/font.htmlhttp://www.webopedia.com/TERM/I/italic.htmlhttp://www.webopedia.com/TERM/B/boldface.htmlhttp://www.webopedia.com/TERM/B/boldface.htmlhttp://www.webopedia.com/TERM/I/italic.htmlhttp://www.webopedia.com/TERM/F/font.htmlhttp://www.webopedia.com/TERM/P/pitch.htmlhttp://www.webopedia.com/TERM/T/typeface.htmlhttp://www.webopedia.com/TERM/C/character.html

kshitij info.tech project

Documents