CBSE Academic X STD E-Publishing & E-Office Sample Question Paper 2016-17

Name of the Board : CBSE Academic
Class : X STD
Document Type : Sample Question Paper
Subject : E-Publishing & E-Office
Year : 2016 – 2017

Website : http://cbseacademic.in/SQP_CLASSX_2016_17.html
Download Sample Question Paper : https://www.pdfquestion.in/uploads/10193-EPublishing17.pdf
Marking Scheme : https://www.pdfquestion.in/uploads/10193-EPublishingMS.pdf

CBSE Academic E-Publishing Question Paper

Sub Code : 354/454
Max. Marks : 30
Time : 2 hours

Related : CBSE Academic X STD Elements of Business Sample Question Paper : www.pdfquestion.in/10180.html

Section A

1. Which single shortcut key is used to insert/create chart for the selected cell in MS-excel. 1

2. My class teacher is having the result-sheet of entire class showing total marks for each student. She want me to help her in generating a summary report showing the following
Student scoring 90% & above.
Student scoring 75% & above.
Student scoring 60% & above.
Passed Students.
Fail students
Which chart should I use in ms-excel?

3. (a) In a worksheet column A, B and C are showing the quantity of an item in different departmental stores. If column D is to display the total quantity, write the formula statement.
(b) In Which cell should the above statement be written? 2

4. In order to insert a formula in an excel sheet, Which menu item is to be clicked? What is the category type of IF ()? 2

5. In an excel sheet as shown below, I want computer to automatically set the value for column D as Pass/fail based on the condition.
Marks >=33, Pass
Marks <33, Fail

(a) Write the steps to accomplish the same in ms-excel.
(b) Write the condition Statement for Sunita.
(c). Can we achieve more than two values for result?
For example if marks are more than 75; set result to merit, if marks are in the range of 33 to 74 set result as Pass else Fail. If yes, how?

Section B

6. What is the difference between shear & Perspective tool? 2

7. Identify the tools for the following
(a) Resize the layer.
(b) Create Mirror image. 2

8. How can we deform a user defined selection area from an image? What are anchor points? 2
9. Suggest a tool in GIMP to correct predominant Colors in digital photos. Briefly illustrate about any one adjust Option?

10. Sanjana has got a project work in which she has been given a colored image of a birthday party. She is asked to convert it into a black & white image leaving the birthday child as colored. How can the task be completed. 4

Section C

11. Define :
(a) cookies
(b) cyber law
(c) firewall 1×3=3

Section D :
12. What is the maximum size of a TIFF file? 1
13. What are the advantages of e-office and its application in e-governance? 4

Foundation of Information Technology

Max Time : 3 hours
Max Marks : 70
Section A :
Q1) Fill in the blanks: [5]
i) Viruses, worms and trojans are collectively named ________________.
ii) Cellspacing attribute is used with ______________ tag.
iii) _____________ is a program which makes you view the information on the World Wide Web.
iv) Collection of Web Pages is called _____________.
v) Columns of a table are specified using __________tag.

vi) _________ can replicate itself automatically .
vii)_________ attribute is used with <A> tag to specify the URL of link.
viii) ___________ is type of program that is installed on a user’s computer to collect information about user.
ix) XML attribute value should always be enclosed in _______________ .
x) ______________is a program that appears harmless but actually performs malicious functions.

Q2) State True or False: [5]
i) The World Wide Web Consortium was founded to develop common standards.
ii) An XML document can have any number of child elements.
iii) No value is specified with border attribute of <img> tag.

iv) COLSPAN attribute of <TD> tag is used to merge more than one column of table.
v) Unsolicited bulk emails are called spam.
vi) Malware is Antivirus software.

vii) Because each computer differs in terms of what fonts it can display, each individual browser determines how text is to be displayed.
viii) Xml is Extended MarkupLanguage
ix) Software piracy is crime.
x) A cracker is a malicious programmer who break into secure systems.

Q3) Short Answer Questions :
i. What does an anti-virus software do? [2]
ii. What is full form of HTTP and what is its use? [2]
iii. Write the HTML code to display links of a web page in yellow colour. [2]

iv. Write the full forms of: [2]
i) URL
ii) <LI>
iii) <TD>
iv) HTML

v. As life gets busier, it becomes difficult for everyone to keep a track with school & college friends, old colleagues, old neighbours and favourite teachers. It is important to keep in touch with all your near and dear ones. At times, people sitting miles away doing similar kind of activity or solving similar kind of problems can help you to achieve goals faster by sharing their experiences. Similarly people belonging to different socio-economic background can change your perspective and can enhance your understanding of various cultures. [2]

a. Suggest two real time tools that are suitable for the above-mentioned activities.
b. What is the generic name used for such tools?

Q4) Short Answer Questions :
i. Draw the XML tree for the code given below: [5]
<employees>
<employee>
<name>
<first>Harry</first>
<last>Potter</last>

iii. What is the meaning of backup and why the data backup is essential? Also name 4 devices to take data backup. [5]
iv. Write any two attributes for each tag: [3]
a) <img>
b) <Table>
c) <A>