[go: up one dir, main page]

0% found this document useful (0 votes)
43 views16 pages

Index: S. No. Topics Signature

The document provides an index of 10 topics related to computer concepts and Microsoft Office features. The topics include types of computers and processors, flowcharts, algorithms, programming concepts, features in MS-Office like Quick Access Toolbar, Format Painter, Ribbon, and more. Questions are also provided after the index to explain various computer-related concepts in more detail.

Uploaded by

Chitpara
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
43 views16 pages

Index: S. No. Topics Signature

The document provides an index of 10 topics related to computer concepts and Microsoft Office features. The topics include types of computers and processors, flowcharts, algorithms, programming concepts, features in MS-Office like Quick Access Toolbar, Format Painter, Ribbon, and more. Questions are also provided after the index to explain various computer-related concepts in more detail.

Uploaded by

Chitpara
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 16

INDEX

S. No. TOPICS Signature

1. Types of Computers and Processors

2. Flowchart and Compute the Factorial

3. Algorithm to sort 10 names and compute roots


of a quadratic equation

4. Program to draw sine wave

5. Features in MS-Office: QAT, Format painter,


Ribbon, Document Properties, Bookmarks etc.

6. Create a report in Green Computing

7. Design a Power point Presentation In


‘Computer Networks’

8. Create a report card of students using MS Excel


and show students promoted or not. Show bar
chart.

9. Using access, create an employee database for


10 employees

10. Create Web Page


QUES.:- Explain various types of computers. Mention types of processors and its

Features.

ANS.:- There are various types of computers available:-

1. Personal Computer or PC – A PC is a computer that is used by someone for his


personal use. It is a complete system in itself and its convenient size, price and simple
functions make it easy for the end-user to work on it without any intervention from
computer operators.

2.Laptop or Notebook – A PC that can be moved around is called a laptop. It gets its
name from the fact that you can keep it on your lap and use it. It is also called a
notebook because you can carry the battery-operated device to classes or meetings
conveniently and store any notes or information in it. It integrates the monitor,
keyboard, pointing device, CPU, memory and hard drive in one system.

3.Workstation – This computer is a desktop which is larger, consists of a more powerful


processor, greater memory space and extra ability to do specific kind of work. Such a
computer is used by programmers, game developers, video or sound editors and
graphic designers.

4.Server – The server’s main purpose is to provide certain services to other computers
or a whole network of computers. It is much larger than any average computer and
generally a whole room is necessary to fit the whole server. It has powerful processors,
additional amount of memory and bigger hard drives.

5.Mainframe – Mainframe computers are used by large companies and organisations to


perform critical tasks that involve bulk data processing like transaction processing,
census information, statistical data and so on. They consist of extensive input and
output facilities, are very stable and dependable and handle millions of transactions
every day.

6.Supercomputer – This type of computer processes data much faster than a regular
system. It is the leader in processing capacity and costs millions of dollars. A
supercomputer is used for sensitive and calculation-intensive work such as scientific
research, physical simulation, climate studies, oil and natural gas exploration, weather
forecasting, quantum physics, to name a few.

7.PDA – A Personal Digital Assistant is a small, highly integrated computer usually


using flash memory for storage instead of a hard drive. It uses touchscreen technology
and doesn’t have a keyboard. Those which use a digital pen for input are called
handheld computers. It is light, portable, has good battery life and fits within your
palm, because of which it is also called a palmtop.
Various types of processors are:-

CISC processor:

1.CISC refers to Complex Instruction Set Computing.

2.It is prominent on hardware, that is depends more on hardware from its proper
functioning.

3.The instruction set contains large number of instructions.

4.More memory space and time is required due to many instruction cycles to perform
complex operations.

5.It has multi clock and fan required with the circuitry.

6.LOAD and STORE memory to memory registers are induced.

7.It has variable length instructions.

RISC processor:

1.It refers to Reduced Instruction Set Computing.

2.It is prominent on software and hence uses simpler hardware circuitry.

3.The instruction set is small with few instructions only.

4.It is good for simpler operations with lesser time requirement.

5.It requires single ckock pulse per second.

6.LOAD and STORE register to register are independent.

7.It has single clock.

8.It has fixed length instructions.

EPIC processor:

It uses three techniques

1.Explicit Parallelism- Compiler detects instructions that can be executed in parallel


form.
2.Predication- Processor executes instructions in all paths of branch exploiting
parallelism as possible. Then, it discovers the valid exploiting parallelism as
possible. Then, it discovers the valid result and uses path without further
processing.

3.Speculation- Piece of data is loaded from memory to processor before processor


executes previous instruction.

Multicore processor:

1.On a single chip, there are many core processor chips present. Each processor chip is
more efficient.

2.They enable computers with overall system performance.

3.Multicore processors consume less power and generate less heat than single core
single core processor chip.

4.As they can share memory, cost is lesser.

5.Signaling between core can e faster and use less electricity.

QUES.:- Explain various symbols used in flow charts. Draw the flow chart to
compute the factorial of a number using iterative method.

ANS:-

1. When you have a step in your process that has only one possible next step, you
use a process symbol.

2. Arrows connect up the symbols in your flowchart, guiding the reader through
the sequence of process steps. Flow moves in the direction in which the arrows
point.
3. A rectangle with rounded cap ends — called a terminator — gets used to start
and end each flowchart process path.

4. The decision symbol marks a branching point in your process, such as one that
requires a choice. At least two arrows should emerge from a decision symbol. If
your choice isn’t binary, add more than two arrows neatly.

Any time you have more than one arrow emerging from a symbol those arrows
need to be labeled for clarity.

5. The catchall input / output symbol stands in for input and output from your
process, regardless of the form it takes. If you want to be more specific about the
form, use one of the other I/O symbols.

6. The catchall input / output symbol stands in for input and output from your
process, regardless of the form it takes. If you want to be more specific about the
form, use one of the other I/O symbols.
FACTORIAL OF A GIVEN NUMBER:-

QUES.:-Define Algorithm. Write an algorithm (i) to sort 10 names of a class and (ii)
roots of a quadratic equation.

ANS.:-Algorithm is a step by step procedure of taking some values as input, processing


them and giving some value as output such that output follows input-output
relationship.

For any algorithm to be correct, it should halt and satisfy the relation.
Properties of Algorithm are:

1. Efficiency
2. Finiteness
3. Generality
4. Non-ambiguity

(i) Sorting 10 names in the class

#include<iostream>
#include<conio.h>
#include<string.h>
using namespace std;
int main()
{ char str[10][20], t[20];
int i, j;
cout<<"Enter any 10 string (name) : ";
for(i=0; i<10; i++)
cin>>str[i];
for(i=1; i<10; i++)
{ for(j=1; j<10; j++)
{ if(strcmp(str[j-1], str[j])>0)
{ strcpy(t, str[j-1]);
strcpy(str[j-1], str[j]);
strcpy(str[j], t);
}
}
}
cout<<"Strings (Names) in alphabetical order : \n";
for(i=0; i<10; i++)
cout<<str[i]<<"\n";
getch();
return 0;
}

2) Q-algorithm to find roots of quadratic equation


Step 1: Start
Step 2: Read A, B, C as integer
Step 3: Declare disc, deno, x1, x2 as float
Step 4: Assign disc = (B * B) - (4 * A * C)
Step 5: Assign deno = 2 * A;
Step 6: if( disc > 0 )
begin
Print “THE ROOTS ARE REAL ROOTS”
Assign x1 ← (-B / deno) + (sqrt(disc) / deno)
Assign x2 ← (-B / deno) - (sqrt(disc) / deno)
Print x1, x2
end
else if(disc = 0)
begin
Print “ THE ROOTS ARE REPEATED ROOTS"
Assign x1 ← -B / deno
Print x1
end
else Print “THE ROOTS ARE IMAGINARY ROOTS”
Step7: Stop

QUES.:-Explain the features of the following in MS office:


1.Quick access toolbar.
2.format painter.
3.Ribbon & customized ribbon
4.Documents properties
5.Book marks
6.Macros
7.Mail Merge

ANS.:-
Quick access toolbar:- The Quick Access Toolbar is a customizable toolbar that
contains a set of commands that are independent of the tab on the ribbon that is
currently displayed. You can move the Quick Access Toolbar from one of the two
possible locations, and you can add buttons that represent commands to the Quick
Access Toolbar.

Format painter:- Use the Format Painter on the Home tab to quickly apply the
same formatting, such as color, font style and size, and border style, to multiple pieces
of text or graphics. The format painter lets you copy all of the formatting from one
object and apply it to another one – think of it as copying and pasting for formatting.

Ribbon &customized ribbon:- A ribbon is a command bar that organizes a


program's features into a series of tabs at the top of a window. Using a ribbon increases
discoverability of features and functions, enables quicker learning of the program as a
whole, and makes users feel more in control of their experience with the program. A rib
on can replace both the traditional menu bar and toolbars.

Documents properties:- Documents of Microsoft Office application are having


some set of default properties, like title of the document, and author of the document.
User may give desired text values in these properties to arrange and find documents
easily. For example, in word document, a user can utilize the “Keywords” property to
add “customers” keyword to sales files and later can search for documents by that
name.

Book marks:- A bookmark identifies a specific word, section, or location in your


document that you name and identify for future reference. For example, you might
create a bookmark to identify text that you want to revise at a later time. Instead of
scrolling through the document to locate the text, you can quickly go to it by using a
bookmark.

Macros:- A macro is a series of commands and instructions that you group


together as a single command to accomplish a task automatically. To save time on tasks
you do often, bundle the steps into a macro. First, you record themacro. Then you can
run the macro by clicking a button on the Quick Access Toolbar or pressing a
combination of keys. It depends on how you set it.

Mail Merge:- Mail merge is used to create multiple documents at once. These
documents have identical layout, formatting, text, and graphics. Only specific sections
of each document varies and is personalized. The documents Word can create with mail
merge include bulk labels, letters, envelopes, and emails. There are three documents
involved in the mail merge process:
1.your main document.
2.your data source.
3.your merge document.
QUES.:-Assume there are four subjects in a class- English, Mathematics, Science, and
Social. Create a table for 20 students and mention the marks secured by each student
in each of the four subjects. The maximum mark of each subject 100 and the pass
mark is 50. Using excel, find the percentage of each student. If the student marks in
all subjects is more than 50 indicate PROMOTED else indicate “NOT PROMOTED”.
Calculate the aggregate pass and fail percentage of the class. Draw the respective bar
chart for each student and pie chart for the entire class.

Answer:
QUES.:-Using access, create an employee database for 10 employees in a company.
The employee records are : name,age,gender,designation,date of joining,
Basic pay,allowances,previous experience,address,phone number.

ANS:-
Ques: Design a Power Point Presentation on the topic of your interest.

Ans:
Ques: Program to draw sine wave

Ans:

#include <conio.h>
#include <math.h>
#include <graphics.h>
#include <dos.h>

int main() {
int gd = DETECT, gm;
int angle = 0;
double x, y;

initgraph(&gd, &gm, "C:\\TC\\BGI");

line(0, getmaxy() / 2, getmaxx(), getmaxy() / 2);


/* generate a sine wave */
for(x = 0; x < getmaxx(); x+=3) {

/* calculate y value given x */


y = 50*sin(angle*3.141/180);
y = getmaxy()/2 - y;

/* color a pixel at the given position */


putpixel(x, y, 15);
delay(100);

/* increment angle */
angle+=5;
}

getch();

/* deallocate memory allocated for graphics screen */


closegraph();

return 0;
}

You might also like