
	Trending ▼ ICSE CBSE 10th ISC CBSE 12th CTET GATE UGC NET Vestibulares ResFinder

CBSE Class X Sample Question Paper 2017 : e-PUBLISHING & e-OFFICE (with Marking Scheme / Solutions)

3 pages, 19 questions, 0 questions with responses, 0 total responses,

CBSE 10
Kendriya Vidyalaya (KV), Kamla Nehru Nagar, Ghaziabad

+Fave Message

Profile Timeline Uploads Q & A

Home > CBSE - main folder > SAMPLE / MOCK Question Papers : CBSE Board Class 10 >

Instantly get Model Answers to questions on this ResPaper. Try now!
NEW ResPaper Exclusive!

Formatting page ...

Sample Question Paper Summative Assessment-II-2016-17 Class X E-Publishing & E-Office Subject Code no: 354/454 Max. Marks: 30 Time: 2 hours (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? 1 3. (a) In a worksheet column A, B and C are showing the quantity of an item in 3 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 B C D 1 Roll no Name Marks Result 2 1001 Amit 73 3 1002 Riya 27 4 1003 Sunita 53 5 1004 Radha 39 6 1005 Mohan 83 1+1+2=4 (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? 2 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. 1x3=3 Define: (a) cookies (b) cyber law (c) firewall (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 -0-0-0- Marking Scheme Summative Assessment-II Class X Code no: 354/454 E-Publishing & E-Office Max Marks: 30 Time: 2 hours (Section A) 1 2 3 4 5.a 5.b 5.c 6 7 8 9 10 11(a) 11(b) 11(c) 12 13 F11 Pie chart a) =sum(A1:C1) (or) =sum(A1,B1,C1) (or) =a1+b1+c1 b) D1 any rows may be used such as A2:c2 Formula menu Logical category I sert for ula =if >= , Pass , fail i D Drag the cell D2 to the cells below D2 =if >= , Pass , Fail yes, = if .7 , erit , if C >= , Pass , Fail (Section B) Shear tool is used to shift one part of an image Perspective tool is used to change the perspective of the image / distort the image (a) Resize tool (b) Flip tool Using cage tool (1 marks for answer + 1 mark for definition) Points or nodes on a path used to drag Color Balance tool brief any one - shadows, midtones, highlights, RGB, CMY Select the child using the free hand tool Apply inverse selection Apply color change (Section C) Data se t fro a we site a d stored o the users rowser Law handles the legal issues related to the use of Internet A program or device used to prevent from unauthorized access (Section D) 4 GB improve efficiency in government process and service delivery mechanisms. sync with the needs of a modern Government and has been conceived as the instrument for the Next Generation Government. improve productivity, quality, resource management, turnaround time and increase transparency of government department platform for personalized, role based, secure access to internal information for the employees or any valid points -0-0-0- 1 1 2 2 2 1 1 2 2 2 2 4 1 1 1 1 4

Formatting page ...

Tags : CBSE Board Examinations : Class X Previous Year Question Papers Class 10 Sample / Model Papers - with Solutions, INDIA - OUTSIDE DELHI, cbse class x, cbse 10, cbse 10th standard, cbse papers, cbse sample papers, cbse books, portal for cbse india, cbse question bank, central board of secondary education, cbse question papers with answers, prelims preliminary exams, pre board exam papers, cbse model test papers, solved board question papers of cbse last year, previous years solved question papers, free online cbse solved question paper, cbse syllabus, india cbse board sample questions papers, last 10 years cbse papers, cbse question papers 2017, cbse guess sample questions papers, cbse important questions, specimen / mock papers 2018.

cbse10 chat

Horizontal lines at:
Guest Horizontal lines at:
AutoRM Data:
Box geometries: