Following are the important question answer according to the latest syllabus and format specified by the CBSE for session 2019-2020.
Create table
Product
PART A: EMPLOYABILITY SKILLS (10
MARKS)
1. Use of abbreviations in a
communication leads to misinterpretation of messages is an example of
__________________________ barriers.
Answer – Language
2.Vacationing helps in
____________________individuals.
Answer – de-stressing
3.____________________ serves as
an interface between the user and computer.
Answer - Operating System
4.An __________ is a person who
establishes a business or a venture that generates some value to the customer
and proves to be profitable for him.
Answer – Entrepreneur
5.An economy is called Green
economy when it is based on the principles of _________.
Answer- sustainable development
6.Physical exercise in the form
of ____________, ___________________to relieve stress as they stabilize mood,
improve self-esteem and induce sleep.
Answer – walking, skipping
7.Explain any two 7Cs of
Communication.
Answer: The 7Cs of Communication
provide a checklist for making sure that your meetings, emails, conference
calls, reports, and presentations are well constructed and clear –so your
audience gets your message.
1. Be Clear - Begin every message
by asking the question, “What is the purpose of this communication?” This will
enable you to make the objective of your communication clear to the recipient.
Clarity is also about avoiding the use of complex words, sentences, and fuzzy
language. It is important that you clearly communicate the intended information
to the recipient. You must be able to explain a concept several ways and answer
clarifying questions about the topic.
2. Be concise - Make your message
brief and to the point. To help make your communications more concise, avoid
going over the same point several times, and avoid the use of filler words,
sentences, and over wordy expressions.
3. Be Concrete - Concrete
communication is about being specific and clear rather than vague, obscure, and
general. To be more concrete use sentences that cannot be misinterpreted.
Include supporting facts and figures to underscore your message, but don‟t
allow anything that detracts from the focus of your message.
4. Be Correct - Incorrect
information doesn‟t help anyone and it does your credibility no good. Ensure
that: Your message is typo-free; your facts and figures are correct and you are
using the right level of language. Being correct first time will both save you
time and boost your credibility. A correct message will also have a greater
impact on the recipient than an incorrect one.
5. Be Coherent - Does your
message make sense? Does it flow logically from one sentence to the next? To
ensure that your communication is coherent: Check that each sentence flows
logically from one to the next and check that you haven‟t tried to cover too
many points or been distracted by side issues.
6. Be Complete - Your message must
contain all the necessary information to achieve the desired response. To
ensure that your message is complete think about questions the receiver might
think of as they receive your message. Address these questions. Ensure you have
included a call to action so that your audience knows exactly what you expect
them to do next.
7. Be Courteous - Be polite.
You‟re more likely to get what you want from your communication if you are
courteous, as courtesy builds goodwill. Check that your message is polite, shows
respect for the feelings of the receiver, and is tactful. Make your message
brief and to the point.
(Any two can be explained)
8.How many origins can have
stress causal?
Answer: Mental, Physical, Social,
Financial.
9.Write down the steps to create
a folder in C drive with your name.
Answer:
1) Double-click the Computer
icon.
2) Double click on C drive in
which we have to create a folder.
3) Right-click anywhere in the
blank area of the right column. A shortcut menu appears.
Select New
Folder from the shortcut menu.
1) A new folder is created with
name New Folder highlighted and then type a name for the folder. Press Enter
key.
10.What are the myths about
Entrepreneurship? Explain any two
Answer- The myths about
Entrepreneurship are:
1. Entrepreneurs are high risk
takers.
They are neither high nor low
risk – takers. They always prefer situations which lead to generating profits.
2. Entrepreneurs become rich as
they start a new business.
Starting a business does not mean
that person will become rich overnight. A new business always needs a span of
year or two to become successful.
3. Entrepreneurs are Job hoppers.
They are not job hoppers. They
are the ones who create job opportunities for the people. They work for many
years and gain experience before starting any new venture.
4. Entrepreneurs have limited
dedication
Dedication is the key to success.
An entrepreneur can never be successful unless he is dedicated towards his
work.
11.List down any four factors
causing ecological imbalance.
Answer- (any four of the
following)
a. Destruction of forests
b. Industrialization
c. Urbanization
d. Large scale use of pesticides
e. Overgrazing
1. What is kept on ________ table
a. an b. the c. of d. a
Ans : the
2. The chemist shop is right next ____
the hospital. (for, to).
Ans : to
3. www stands for ________________ .
(a) Whole World Web
(b) World Wide Web
(c) World With Web
(d) Web Web Web
Ans : (b) World Wide Web
4. _____________ is
designed to help users with auditory impairments.
(a) Filter Key
(b) Toggle Keys
(c) Sound Sentry
(d) Serial Key
Ans : (c) Sound Sentry
5. Default tab stop position is
__________ .
Ans : 0.5”
6. _______________ can be used to break
continuous text to one or more sentences.
Ans : Paragraph
7. ______________ can be used for
inserting information at the top of each page automatically.
Ans : Header
8. AutoSum option is available in
_________________ group under the Home tab.
Ans : Editing
9. __________ are used for playing
sound files while making a presentation.
Ans : Audio clips
10. Selecting the__________
view shows calendar for a month.
Ans : Month
11. You can categorize appointments in
time management software by giving specific
__________ to appointments.
Ans : colours
12. A _________________ creates a
timeline of transactions that can be linked to a contact.
Ans
: Journal
PART B: SUBJECT SKILLS (40 MARKS)
12.__________is an accessibility
function that tells the keyboard to ignore brief or repeated keystrokes, making
typing easier for people with hand tremors.
Ans FilterKeys
13. Define DSL.
Ans DSL: Digital subscriber line
(DSL) provide Internet access by transmitting digital data over wires of a
local telephone network.
14.__________are text or image
included at the bottom of the page and may repeat in all pages of the document.
Ans Footers
15. Symbol option is available
under _________________ group in the Insert Tab in word document.
a. Illustrations
b. Symbols
c. Media
d. Text
Ans Symbols
16. _______ feature is used to
extract the data using some conditions on columns.
Ans Filter
17. A ________ is a graphical
representation of data, in which the data is represented by symbols, such as
bars.
Ans Chart
18. A _______________ is the
visual motion when one slide changes to the next during a presentation.
a. Slide transition
b. Animation
c. Sound
d. Movie Clip
Ans Slide transition
19. __________ helps to move,
rotate or resize multiple objects in a presentation.
a. Grouping
b. Charts
c. Table
d. Movie clip
Ans Grouping
20. ____________statement is used
to retrieve records in a database.
a) Alter
b) Update
c) Select
d) Create
Ans Select
21. A ___________ represents a
single, data item in a table.
a. Row
b. Column
c. Datatype
d. Primary Key
Ans Row
22. You can categorize
appointments in time management software by giving specific __________ to a apointments.
Ans Colors
23. Define Journal Entry.
Ans: A Journal entry creates a
timeline of transactions that can be linked to a contact. A transaction might
be an email, task, appointment etc.
Answer any 4 questions out of the
given 6 questions of 2 marks each:
24. State the purpose of creating
a Blog.
Ans : A blog is a discussion
style site used by non-technical (and technical users) users for creating
personal web pages. Blog is used to convey messages about events,
announcements, news, reviews, etc. Blogs are usually managed using a web
browser and this requires active internet connection.
25. Differentiate between Page
Break and Section Break options of a word document.
Ans: A page break can be inserted
anywhere in a document to force the end of a page and the beginning of a new
one.
A section break controls the
formatting of the document content that precedes it, until it reaches another
section break.
26. Explain Conditional
formatting with a help of suitable example.
Ans : Conditional formatting
allows to change the formatting (font color, border, shading) of the cells
based on the values in it. One or more cells can be selected, and create rules
(conditions) for when and how those cells are formatted. The conditions can be,
based on the selected cell's contents, or based on the contents of another
cell.
For example
Highlight the marks of the
students who got marks greater than 80 with green colored text
27. List the activities recorded
under Journal entry.
Ans : The following activities
can be automatically recorded under Journal entry:
Emails Sent & Received
Telephone calls
Meeting requests & responses
Office documents you manage
28. Differentiate between Flat
File and Relational Database.
Flat File: Data is stored in a
single table. Usually suitable for less amount of data.
Relational Database: Data is
stored in multiple tables and the tables are linked using a common field.
Relational is suitable for medium to large amount of data.
29. Mention two points stating
the effective use of animation in a presentation.
Ans:
It
helps focus audience attention on information.
It
controls the flow of information especially while explaining a diagram.
It
reveals concepts one by one.
(any two relevant points)
Answer any 4 questions out of the
given 6 questions of 3 marks each:
30. Sanya is working on Word
document. She has inserted graphics and wants to use Wrap text with graphics.
(i) Under which tab she can find
text wrapping?
(ii) List any two text wrapping
options available in a word processing software.
Ans: (i) Wrap Text option is
available under Text section of the Insert Tab.
(ii)Any two text wrapping options
from following
1. In Line with text
2. Square
3. Through
4. Top and Bottom
5. Behind Text
6. In Front of text
31. Explain any three character
formatting options in a word document.
Ans Change Case – It helps us to
change the text case to capital letters or small letters. You can also
capitalize each word in the sentence and capitalize the starting word of the
sentence using Change Case under Font Group.
Font Face It can be used to give
Font Name in the Font group to select the particular font style from the fonts
listed.
Text Highlight Colour: This
option can be used to change the background colour.
32. State the purpose of creating
Tables in a digital Presentation. Mention two ways to insert a table in a
presentation.
Ans: To represent the statistical
data meaningfully Tables .It can be used to present text and numerical data.
Data is shown in the grid format.
Tables can be inserted in two
ways
Using Insert tab
Using Title and Content Option
33. Define the following: Table ,
Primary Key, Foreign Key
Ans:
Table: A table is a collection of
related data held in a table format within a database. It consists of columns,
and rows.
Primary Key A primary key is a
unique value that identifies a row in a table. For example, Student Table
contains columns such as Admno, Name, DOB , Address, Phone and Admno can be
considered as Primary Key
Foreign Key: a foreign key is a
field or a column that is used to establish a link between two tables. In
simple words you can say that, a foreign key in one table used to point primary
key in another table.
34. Snehal works for an event
management company. She has prepared a presentation and while setting up the
Slide Show she is getting the following options, explain them briefly.
(i) Presented by a speaker
(ii) Browsed by an individual
(iii) Browsed at a Kiosk
Ans: (i) Presented by a speaker
(full screen) option can be used if the presentation is to be made to an
audience .
(ii) Browsed by an individual is
used when the presentation is to be made to an individual
(iii) Browsed at a Kiosk is used
when the presentation is to be given at Kiosk computer terminal.
35. What is DDL and DML? Give one
example of each.
Ans: Data Definition Language
(DDL)
A data definition language or
data description language (DDL) is a standard for commands that define the
different structures in a database. DDL statements create, modify, and remove
database objects such as tables, indexes, and users. Example CREATE, ALTER, and
DROP.
Data Manipulation Language (DML)
A data manipulation language
(DML) is a language that enables users to access and manipulate data in a
database. The goal is to provide efficient human interaction with the system.
For Example Insert, Update, Delete and Select
Answer any 2 questions out of the
given 4 questions of 5 marks each:
36. Rohan‟s Grandfather was
wondering that how does Rohan chat on web with his father posted in California,
Elaborate the steps involved while transferring data over internet.
Ans Steps followed while
transferring data are
The data is broken up into bits of same sized pieces called packets.
A
header is added to each packet explaining where the data has come from, where
it should end up and where it fits in with the rest of the packets.
Each packet is sent from computer
to computer until it finds its destination.
Each computer on the way decides where next to send the packet. All packets may
not take the same route.
At
the destination, the packets are examined. If any packets are missing or damaged, a
message is sent asking for them to be re-sent. This continues until all packets
have been received intact.
The packets are now reassembled into their original form.
37. Elaborate the five types of
Views available in a spreadsheet.
Ans.
Normal View: The default view of
the spreadsheet application is the Normal. It‟s a collection of cells arranged
in the work area.
Page Layout: It is to quickly
fine tune a worksheet that contains many charts or huge amounts of data and
achieve professional looking results.
Page Break Preview: This option
is similar to the Page Layout option except you can set the area that is to be
set as a page after inserting page break.
Custom Views: To view selected
areas of a document the custom view option can be used.
Full Screen: Selecting this
option makes the workbook cover the entire screen. All tabs are hidden from
view.
38. Write the points to be kept
in mind to make an effective presentation for the audience (Mention any 5
Points).
Ans.
1. Do prior research, know the
topic and collect the material of what you will talk about.
2. Highlight key points that are
necessary for the audience to remember. Keep the points as short as possible.
3. Avoid too much text Summarize
the content as bullet points. Use simple language and limit the number of
bullets to three or four per slide.
4. Limit the number of slides -
On average, one slide per minute is recommended.
5. Fancy fonts must be avoided.
6. Keep slide color scheme
consistent throughout the presentation.
7. Transitions and Animations
must be used carefully to avoid distractions.
8. Use a slide design template to
keep presentation look consistent.
39.
(a) Write a Query to create a
Table with the following structure
Ans:
(b) Consider the following Vendor table and
write the queries
(i) Write a Query to display all records
Ans Select * from Vendor;
(ii) Write a Query to add a new
row with the following details
(„V005‟, „Vadilal‟, „2010-03-20‟,
„Pune‟)
Ans Insert into Vendor values
(„V005‟, „Vadilal‟, „2010-03-20‟, „Pune‟);
(iii) Write a query to modify the
location of V003 from Kolkata to Gujrat
Update Vendor
Set location= „Gujrat‟
Where location= „Kolkata‟;
-------------------------
Very short Answer Questions (5X2=10)
13. Rohan’s father told him that they
need to attach a modem for internet connection on their
computer. Explain the meaning and
function of modem to Rohan.
Ans : A modem is a device that converts
digital computer signals into a form (analog signals)
that can travel over phone lines. It
also re-converts the analog signals back into digital signals.
The word modem is derived from its
function MOdulator/DEModulator.
14. What are document templates? State
the purpose of using document template. (2)
Ans : Templates or document templates
refer to a sample fill-in-the-blank document that can
help in saving time. Usually templates
are customized documents that may have sample content,
themes, etc. For example, if you want
to create a resume you can use a resume template and modify
only the sections that require changes.
15. What are Clip arts? List any two
websites that offer free clipart. (2)
Ans: Clip arts are pre-defined images
available for use in documents. Clip Art can help in making a document look colourful
and presentable.
Name of any two valid websites that offer
free clipart
16. Explain any two types of views
available in Spreadsheet (2)
Ans : five types of views are ;
Normal View: The default view of the spreadsheet
application is the Normal. It is a collection of cells arranged in the work area.
Page Layout: You can select the Page
Layout view in order to quickly fine tune a
worksheet that contains many charts or
huge amounts of data and achieve professional looking results.
Page Break Preview: This option is
similar to the Page Layout option except you can set the area that is to be set
as a page after inserting page break.
Custom Views: If you would like to view
selected areas of a document, you can use the custom view option. For example,
if you would like to point out certain row and column, you can add that to the Custom
view.
Full Screen: Selecting this option
makes the workbook cover the entire screen. All tabs are hidden from view. To
get back the tabs, click on File> Restore.
(Any two views)
17. Explain the purpose of grouping
objects in a Digital presentation. (2)
Ans: Grouping can help when you want to
move, rotate or resize multiple objects in a
presentation. You can group objects
such as pictures, clip art, shapes and text box; once grouped they appear as a
single object.
2 marks for any two valid points
Or
18. Differentiate between Animation and
Transition in Digital Presentation.
Ans : Animation is used for applying
effects on objects and text, Transition is used for applying animation effects
on slides
(2 marks for any two valid points of
difference)
19. Pulkit has got a proposal for a
meeting through Calendar. Suggest four types of responses
that are available under calendar
software.
Ans : Four types of responses for a
meeting are :
Accept,
Tentative,
Decline or
Propose New Time options
Short Answer Questions (5X3=15)
20. A stranger has helped your
grandfather and you want to appreciate him for the help extended by him. Write
any three lines to thank him.
Ans : Thanks a lot!
Thanks! You helped my grandfather.
Thanks! I really appreciate your help
(any three phrases).
21. You have recently visited a hill
station. Describe it using appropriate phrases.
Ans : Example: Nainital is a beautiful
hill-station in Uttarakhand.
1. Nainital is a beautiful
hill-station…
2. It is surrounded by…
3. …in Uttarakhand.
4. …above sea-level.
5. …high mountain peaks
6. Nainital is a very…
7. …especially during winter…
8. …popular tourist spot,
9. …when the snow falls.
(3 marks for 3 Sentences using any of
the above phrases)
22. List any three word wrapping
options available under Word Processing software.
Ans : Various word wrapping options are
:
- In line with text
- Square
- Tight
- Through
- Top and bottom
- Behind text
- In front of text
(3 marks for any of the three options)
Or
23. Write steps to insert shape in a
word document.
Ans : Steps to insert shapes are :-
1. Click on the Insert tab on the
Ribbon. Click on the option Shapes in the Illustrations group
2. Once you click the Shapes option a
dropdown list with pre-defined shapes such as box, circle, etc. appears.
3. Select the shape from the list of
shapes available and draw the shape by dragging the mouse with the left button
clicked. For example, if you like to insert a square, select the box shaped
item from the list, click and drag the shape to draw a square.
(3 marks for correct sequence of steps)
24. Yashika is preparing a Digital
Presentation for her project. Give any three basic guidelines to
be followed while making a digital
Presentation.
Ans : Do a thorough spell check across
all slides
- Perform a manual spell check for
terms that are not included during the standard spell
check in the presentation software; NOT
all terms (particularly technical terms such as
biological names, etc.) will be checked
- Remove irrelevant content such as
images or clip arts, terms, etc. if they are not required.
(any three valid guidelines)
(1 mark for each guideline)
Or
25. Ankush has to present monthly
report of his department to his managing committee. Suggest him with
appropriate tools to do the following in a digital presentation:
i. To show statistical data pictorially
for analysis.
Ans : Charts may be used
(1 mark)
ii. Two ways to insert movie in his
presentation.
Ans: You can insert a movie in two
ways:
Using Insert tab
Using Title and Content
Layout Option (1 mark)
iii. Which option he shall use to keep
guided text used by presenter
Ans : He should use Presenter View in
Slide Show Tab (1 mark)
26. Define the following terms
a. Tuple :
A row also called a record or tuple
represents a single, data item in a table
b. Foreign Key
The foreign key identifies a column or
set of columns in one (referencing) table that
refers to a column or set of columns in
another (referenced) table.
c. DBMS : Database Management System is
a software package with computer
programs that controls the creation,
maintenance, and use of a database
Section B
Long Answer Questions (5X3=15)
27. Ananya uses Internet for her School
Project. Suggest any five security measure to ensure
safety from online threats.
Ans : Five safety measures :
i) Use antivirus and antispyware
software
ii) Use strong passwords
iii) Backup your data:
iv) Use encryption software
v) Keeping your username and password
private
vi) Do not share personal information
vii) Secure transactions:
Or
28. Explain the following terms :
a. Internet : The Internet is a global
system of interconnected computer networks that use the standard Internet
protocol suite to serve billions of users worldwide
b. LAN : A local area network (LAN) is
one which connects computers and devices in a limited geographical area such as
home, school, computer laboratory, office building, or closely positioned group
of buildings
c. Instant Messaging: Instant messaging
(IM) is a form of communication over the Internet that offers an instantaneous
transmission of text-based messages from sender to receiver.
d. Blog : A blog is a discussion style
site used by non-technical (and technical users) users for creating personal
web pages.
e. P2P Architecture : Peer to Peer :
Networks in which all computers have an equal status are called peer to peer
networks.
29. Write command to create a table
named ‘BOOK’ with following fields:
Ans:
a. Identify the primary key of the
‘Book’ Table, also mention the suitable reason for choosing
it as a Primary Key
Ans : Book_id may be chosen as the
Primary key because every book has a unique id that may
be used to identify the book.
b. Differentiate between (i) char and
varchar datatype
Ans : char :
1. Stores exactly the length specified
by user in field definition.
2. Pads with trailing spaces for
shorter strings varchar:
1. It Stores up to the specified
length.
2. No padding with extra spaces
(ii) DDL and DML
DDL : A data definition language or
data description language (DDL) is a standard for
commands that define the different
structures in a database
DML : A data manipulation language
(DML) is a language that enables users to access and
manipulate data in a database.
OR
30. Write the SQL commands to answer
the queries based on Fabric table
a. To insert the following record
(“F005”, “Kurta”, “Woollen”,5)
Ans : insert into Fabric values
(‘F005’, ‘Kurta’, ‘Woollen’,5); (1 mark)
b. To display only those fabric whose
disc is more than 10
Ans : select * from Fabric where
Disc>10; (1 mark)
c. To display those record whose type
is ‘Woollen'
Ans : select * from Fabric where type =
‘Woollen’; (1 mark)
d. To modify the fabric shirt by
increasing discount by 10
Ans : update fabric set Disc =Disc + 10
where Fname = ‘Shirt’; (1 mark)
e. To delete the record of fabric F003
from table
Ans : delete from Fabric where FabricID
=‘F003’; (1 mark)
31. Given the Following Spreadsheet,
Write the appropriate Formula/ Expression/ Function to
be used for (a) to (e) (5)
a. Write formula to calculate the Total
Qty(C4:C7)) in cell C8
Ans : =sum(C4:C7) (1 mark)
b. Write the feature used for arranging
the Price from Highest to Lowest
Ans : Sort in ‘Sort and Filter’ group
under Data tab (1 mark)
c. To find the Maximum Price to be
written in Cell D10
Ans : = max(D4:D7) (1 mark)
d. To find the Average Qty to be
written in cell C9
Ans : = average( C4:C7) (1 mark)
e. Write formula to calculate the Total
Amount in cell E8
Ans
: = sum(E4: E7) (1 mark)
No comments:
Post a Comment