Assignment 1

 Desktop Publishing
1. What is Desktop Publishing?
Desktop publishing (DTP) is the creation of documents using page layout software on a personal
("desktop") computer. It was first used for print publications, but now it is used in the creation of
various forms of online content. Desktop publishing software can generate layouts and produce
typographic-quality text and images comparable to traditional typography and printing. Desktop
publishing is also the main reference for digital typography. This technology allows individuals,
businesses, and other organizations to self-publish a wide variety of content, from menus to
magazines to books, without the expense of commercial printing.

 Each software has its work.

Microsoft Word is used to Create Text Documents

Microsoft Excel is used to Create Reports

Microsoft Power Point is used to create Presentations

Adobe Photoshop is used to edit Photo

Adobe PageMaker is used to design page

Corel DRAW is used to create designs

2. Explain History of Desktop Publishing

 It Started in 1970

 Apple Macintosh Introduced in 1984

 Hawlett Packword Introduced Laserjet Printer in 1984

 In 1985 Adobe developed postscript for typing

 Aldus has developed PageMaker. It is first Desktop Publishing Application.

 Apple has produced first desktop laserprinter.

 In 1987 PageMaker developed for Window

3. What are Advantages of Desktop Publishing ?

 Speed
 Page formatting
 Changes
 Low Cost
 Various Tools
 a) Speed

Old days it will take time for Books.

Also, skilled persons required. But now a days due to this software speed is increased as well as we
can format text, Photo editing or delete image. We can make changes easily.

b) Page Formatting

All these software has number of tools for formatting like Text, Image, ClipArt, Border, and Symbol
etc.

By using this you can format page.

c) Low Cost

You can design & print documents in minimum cost.

d) Tools

 All these softwares have number of tools for spelling check or replace or find or delete /
Insert etc.

 By using these tools we can work easily

4. What are Uses of Desktop Publishing

 Books

 Business Card

 Bill Book

 Advertisement

 Magazine

 Letter Head

 News Paper

 Post Card

 Application Letter

 Calendar

 Invitation Card

 Office Notice

 Poster

 Boucher

 Menu card

 Boards etc.
  Fundamentals of Computer
1. What is Computer?
Computer is an advanced electronic device that takes raw data as input from the user and processes these
data under the control of set of instructions (called program) and gives the result (output) and saves output
for the future use. It can process both numerical and non-numerical (arithmetic and logical) calculations
A computer has four functions:
a. accepts data Input
b. processes data Processing
c. produces output
d. stores results Storage
Input (Data):
Input is the raw information entered into a computer from the input devices. It is the collection of letters,
numbers, images etc.
Process:
Process is the operation of data as per given instruction. It is totally internal process of the computer
system.
Output:
Output is the processed data given by computer after data processing. Output is also called as Result. We
can save these results in the storage devices for the future use.

2. Computer System

All of the components of a computer system can be summarized with the simple equations.
COMPUTER SYSTEM = HARDWARE + SOFTWARE+ USER
• Hardware = Internal Devices + Peripheral Devices All physical parts of the computer (or everything that
we can touch) are known as Hardware.
• Software = Programs Software gives "intelligence" to the computer.
• USER = Person, who operates computer.
3. Major parts of the Computer Input Devices
1. Mouse 2. Keyboard 3. Scanner 4. Digital Camera 5. Web Camera 6. Joysticks 7. Track Ball 8. Touch
Pad/ Screen 9. Light Pen 10. Bar Code Reader 11. Microphone 12. Graphics Tablets 13. Magnetic Ink
Character Reader (Used in Bank) 14. Optical Mark Reader (Used for AnswerSheet Marking Purpose) 15.
Magnetic Card Reader (Used in Shops, Colleges, Stations etc) 16. Biometric Devices 17. Bluetooth

4. Output Devices
1. Monitor
2. Printer (Dot Matrix)
3. Projector
4. Inkjet Printer
5. Plotter Laser
6. Speaker

5. Processor
CENTRAL PROCESSING UNIT (CPU) The main unit inside the computer is the CPU. This unit is
responsible for all events inside the computer. It controls all internal and external devices, performs
arithmetic and logic operations. The CPU (Central Processing Unit) is the device that interprets and
executes instructions.

6. Storage Devices
1. Primary memory (main memory) A. RAM (Random Access Memory/Read-Write Memory) B. ROM
(Read-only-memory) 2. Secondary memory (storage devices) A. Hard Disk (Local Disk) B. Optical Disks:
CD-R, CD-RW, DVD-R, DVD-RW C. Pen Drive D. Zip Drive E. Floppy Disks F. Memory Cards G.
External Hard Disk

7. Peripheral Devices
1. The Modem/ Internet Adapter 2. Switches/H ub 3. Router 4. TV Tuner Card

8. Internal Components
1. The Mother Board 2. Expansion Slots 3. CMOS Battery 4. Cooling Fan 5. Network Card 6. Graphics
Card 7. Power Supply Unit (SMPS) 8. Memory Slots

9. Software
Software, simply are the computer programs. The instructions given to the computer in the form of a
program is called Software. Software is the set of programs, which are used for different purposes. All the
programs used in computer to perform specific task is called Software.

10. Types of software

1. System software: a) Operating System Software DOS, Windows XP, Windows Vista, Unix/Linux,
MAC/OS X etc. b) Utility Software Windows Explorer (File/Folder Management), Windows Media
Player, AntiVirus Utilities, Disk Defragmentation, Disk Clean, BackUp, WinZip, WinRAR etc…
2. Application software:
a) Package Software Ms. Office 2003, Ms. Office 2007, Macromedia (Dreamweaver, Flash, Freehand),
Adobe (PageMaker, PhotoShop)
b) Tailored or Custom Software SAGE (Accounting), Galileo/Worldspan (Travel) etc.
11. Types of Computer
 On the basis of working principle
a) Analog Computer An analog computer (spelt analogue in British English) is a form of computer that uses
continuous physical phenomena such as electrical, mechanical, or hydraulic quantities to model the
problem being solved.
1. Thermometer 2. Speedometer 3. Petrol Pump Indicator 4. Multimeter
b) Digital Computer A computer that performs calculations and logical operations with quantities
represented as digits, usually in the binary number system.
c) Hybrid Computer (Analog + Digital) A combination of computers those are capable of inputting and
outputting in both digital and analog signals. A hybrid computer system setup offers a cost effective
method of performing complex simulations
 On the basis of Brand
a) IBM/IBM Compatible Computers
b) Apple/Macintosh
 On the basis of size
A. Super Computer The fastest type of computer.
B. Mainframe Computer A very large and expensive computer capable of supporting hundreds, or
even thousands, of users simultaneously.
C. Mini Computer A midsized computer. In size and power, minicomputers lie between workstations
and mainframes.
D. Micro Computer
i. Desktop Computer: a personal or micro-mini computer sufficient to fit on a desk.
ii. Laptop Computer: a portable computer complete with an integrated screen and keyboard. It is
generally smaller in size than a desktop computer and larger than a notebook computer.
iii. Palmtop Computer/Digital Diary /Notebook /PDAs: a hand-sized computer. Palmtops have no
keyboard but the screen serves both as an input and output device.

E. Workstations A terminal or desktop computer in a network. In this context, workstation is just a

generic term for a user's machine (client machine) in contrast to a "server" or "mainframe."
 Assignment 2
 MS Word

Q 1. Which formatting features can be added to the MS Word

document?

Ans. The common formatting features which are available on MS Word

include:


 Font Style, Size and Colour</li
 Header and Footer
 Insert Images
 Add tables and bulleted lists
 Set a page layout
 Add Word Art
The basic feature of why people choose MS Word over any other text editor is that it makes
the document more visually interactive and appealing.
Q2

Q 2. What is Microsoft Word used for??

Ans. MS Word can also help you organize and write documents more efficiently. When the
document is created in Word, the user can choose to start from a blank document or let a template
do much of the work for the user. From then on, the basic steps in creating and sharing documents
are the same.

Q 3. What are the basic functions of MS Word?

Ans. Given below are the basic functions of Microsoft Word:

 Creating text documents
 Editing and Formatting the existing documents
 Making a text document interactive with different features and tools
 Graphical documents, comprising images
 Used by Authors and Researchers
 Detect grammatical errors in a text document
Q 4. What is the extension of an MS Word file?
Ans. An MS Word file is always saved with the extension of .doc or .docx.
.

Q 5. What are the five basic fields of application for MS Word?

Ans. Using Microsoft Word, one can create resumes, reports, and write letters. Authors can use it to
write their books and researchers for writing a thesis. Apart from this, it can be used as a simple text
editor.

 MS Excel

Q 1. What is the definition of MS Excel?

Ans. MS Excel is a spreadsheet program where one can record data in the form of tables. This gives
the user a more systematic display of data.

Q 2. What are the main features of Microsoft Excel?

Ans. The main features of MS Excel include inserting a pivot table, sorting of tabulated data, adding
formulas to the sheet, and calculating large data.

Q 3. What are the common MS Excel formulas?

Ans. Given below are the common calculations which can be done using MS Excel:
 Addition
 Subtraction
 Average
 Maximum and Minimum
 Concatenate
 Count

Q 4. What is a cell in Microsoft Excel?

Ans. MS Excel comprises a spreadsheet is in the form of a table comprising rows and columns. The
rectangular box at the intersection point between rows and columns forms a cell.

Q 5. Can multiple sheets be added to a single spreadsheet?

Ans. Yes, MS Excel gives an option to add multiple worksheets to a single spreadsheet. The user can
rename each of these worksheets as per their requirements.
  MS PowerPoint

Q 1. What is MS PowerPoint?

Answer: PowerPoint (PPT) is a powerful, easy-to-use presentation graphics

software program that allows you to create professional-looking electronic slide shows.

The image given below shows the main page of MS PowerPoint, where a person lands when
the program is opened on a computer system:

Q 2. How to open MS PowerPoint on a personal computer?

Answer: Follow the steps below to open MS PowerPoint on a personal computer:

1. Click on the start button

2. Then choose “All Programs”
3. Next step is to select “MS Office”
4. Under MS Office, click on the “MS PowerPoint”

A blank presentation is open on the screen. According to the requirement, a person can
modify the template for a presentation and start using the program.

Q 3. What is a PowerPoint presentation or PPT?

Answer: A combination of various slides depicting a graphical and visual interpretation of

data, to present information in a more creative and interactive manner is called a PowerPoint
presentation or PPT.
Q 4. What is a slide show in a PowerPoint presentation?

Answer: When all the slides of a PowerPoint presentation are set in series and then presented
to a group of people, where each slide appears one after the other, is a set pattern, this is
known as a PowerPoint slide show.

Q 5. What all elements can be added to a slide?

Answer: The following elements can be added to a Powerpoint slide:

1. Clip Art
2. Graphs
3. Tables
4. Photographs
5. Charts
6. Media Clips
7. Videos

All these elements are mainly used to enhance presentation skills and make the slide more
interactive.

Q 6. What are the Uses of PowerPoint Presentation?

PowerPoint presentations are useful for both personal and professional usage. Given below
are a few of the major fields where PPT is extremely useful:

 Education – With e-learning and smart classes being chosen as a common mode of education
today, PowerPoint presentations can help in making education more interactive and attract
students towards the modified version of studying
 Marketing – In the field of marketing, PowerPoint presentations can be extremely important.
Using graphs and charts, numbers can be shown more evidently and clearly which may be ignored
by the viewer if being read
 Business – To invite investors or to show the increase or decrease in profits, MS PowerPoint can
be used
 Creating Resumes – Digital resumes can be formed using MS PowerPoint. Different patterns,
photograph, etc. can be added to the resume
 Depicting Growth – Since both graphics and text can be added in a presentation, depicting the
growth of a company, business, student’s marks, etc. is easier using PPT