Class : X                                                                                                                                                               Max.Marks:40

Subject : IT (402)                                                                                                                                                 Time: 1 ½ hr

Date : 21/12/2017

Section – A                                                         (1 X 8 = 8M)

1. Multiple Choice Questions

1) Gridlines

1. May be turned off for display but turned on for printing
2. May be turned on or off for printing
3. The be turned off for display and printing
4. a, b and c

2)  A function inside another function is called a ….. function.

1. Nested b.   Round                   c.   Sum           d.   Text

3)  In Microsoft PowerPoint two kinds of sound effects files that can be added to the presentation are__________

1. a) .Wav files and .mid files b)   .Wav files and .gif files
2. c) .Wav files and .jpg files d)  .jpg files and .gif files

4)  What is a motion path?

1. A type of animation entrance effect b. A method of advancing slides
2. A method of moving items on a slide d. All of the above

5)  Which of the following columns does not appear when you open the table in the Table

Design View?

1. Field Type b. Description             c. Field Name            d. Field Length

6)  Which of the following field properties ensures data validation in a data base?

1. Decimal places b. AutoValue c. Format example   d. Entry required

7) Which outlook function allows you to keep track of time spent on work?

1. Tasks b. Journal                   c. Notes                       d. Calendar

8) Which type of personal email account downloads email message to your computer?

1. Microsoft Outlook             b. POP3           c. IMAP                       d. HTTP

Section – B                            3 X 2 m = 6 m

1) Consider the following data in a spread sheet.

	A	B	C	D	E	F
1	SL No	Name	English	Maths	Science
2	1	Anita	26	54	67
3	2	John	43	65	78
4	3	Kerry	87	56	78
5	4	Smith	45	76	34
6	5	Risha	56	34	98
7

1. Write the formula to find the sum of all subjects of Kerry and Risha.
2. Write the formula to find average marks of John.
3. Write the formula to find highest mark in science.

 2) List the advantages of sharing calendar in Ms-outlook?

3) Specify the order of operations used for evaluating formulas in Ms-Excel?

Section-C                               3m x 2 = 6m

1) Consider the following table named Patient:

Patient ID	Patient Name	Patient Age	Patient Address	Patient Contact Number	Gender	Disease	Date of Admission
101	Shradha	20	Shalimar Bagh	9877777111	F	Malaria	12/06/2011
102	Sudhir	15	PreetVihar	8777718253	M	Pneumonia	02/03/2011
103	Parth	18	Surajmal Vi-har	9856432123	M	Asthma	15/05/2011
104	Geeta	25	JanakPuri	8675643255	F	Pneumonia	20/04/2011
105	Anita	20	Dwarka	9711777382	F	Whooping cough	08/06/2011
106	Adarsh	19	Anand Vihar	9811665432	M	Pneumonia	25/06/2011

 Answer the following questions:

1. Identify the primary key field.
2. Write a query to display patient’s information who suffers from Pneumonia.
3. Identify the fields that have the same data types.

2)  What are the different views in power point? Explain the purpose of each view.

Section D                               5m x 4 = 20 m

1) Write the steps to calculate the data across worksheets. How do you link the cells from different worksheets? (2m + 3m)

2) How do you group objects? What are its advantages? Write any six points on reviewing content in the presentation software. (2+ 1+3)

3) What are the two ways of scheduling an appointment? State the procedure to create a new appointment and also categorise it?(1 + 3+ 1)

4) What is RDBMS? In open office base, write the full syntax and an example for each of the following commands.

1. i) create ii) update iii) delete        iv) select         v) insert

——————————————————————————————————————–

 

Information Technology (402/462)

Class X – 2017 – 18

General Instructions:

1. Read the question paper carefully.
2. Question paper is divided into four sections:

Section A – Multiple choice questions                     (1 mark each)

  In this section

      Attempt any two from the first four questions.

      Attempt a total of six questions.

Section B – Very short answer                     (2 marks each)

 There are internal choices in this section with a total of 8 questions to be attempted.

Section C – Short Answer                             (3 marks each)

Section D – Long answer                              (5 marks each)

• All questions are compulsory from section C and D

1. The maximum time allowed is 2 hours.
2. Maximum marks is 50

Section A:                                                                                                               1 X 6 = 6 M

8. The dances are________________ the fight between good and evil. [ ]
9. a) about b) for c) around                     d) with
10. Beat eggs, water, salt and pepper in a small bowl until they are ___________[ ]
11. a) mixed b) combined               c) merged                   d) blended
12. Please get me __________glass of water. [ ]
13. a) an b) a c) the                           d) no article needed
14. We must reach the airport on time, or else ___________will miss the flight. [ ]
15. a) we b)us c) himself                    d) none
16. Cursor options is also an ____________________ feature that assists people with vision impairment. [           ]
17. a) feasibility b) accessibility                        c) formatting               d) editing
18. Which one of them is not an IM [ ]
19. a) Skype b) WhatsApp c) Google talk              d) Hotmail
20. The conditional formatting option is available under the ______________ group in the home tab.                                                                                              [           ]
21. a) Cells b) Styles c) Editing                     d) Clip board
22. Using filter you can extract data based on ____________________ [ ]
23. a) sort b) condition c) merge                     d) none of the given
24. Movie option is available in ____________group under the insert tab. [ ]
25. a) Illustrations b) links c) media clips              d) symbols
26. _____________appointments can be used for repetitive tasks. [ ]
27. a) Calendar b) Recurring c) Journal                    d) notes
28. Which of the following is not data base software? [ ]
29. a) Ms-Access b) Open-office base c) Open-Office impress          d) SQL

12._______ creates a timeline of transactions that can be linked to a contact.      [           ]

1. a) Journal entry b) notes c) tasks                                    d) none

Section – B  8 X 2 = 16 M

1) In an open letter to the citizens, on the eve of the republic day, the president has mentioned about ‘the winds of change’ blowing in the country.  What does the president mean? Give two examples.

2) Change the voice.

1. i) His grandmother looked after him.
2. ii) I was praised by the principal.

3) Apart from the regular fonts and sizes, the font dialogue box has some effects. List any four.

OR

Write down the steps to insert a school logo in the header of a document.

4) Suman wants to add speaker notes in his presentation. What are the key points should he keep in mind while preparing it?

OR

Define:   i) animation                  ii) transition

5) Write any two uses of DBMS?

6) State the relationship between primary key and foreign key with the help of an example?

7) What options will you find when you receive a meeting request in Ms-outlook?

8) Explicitly distinguish the use of connectors and conjunctions by providing an example for each.

 Section C                              6 x 3 = 18 M

1. List any three views available in Spreadsheets? How do you arrange multiple program windows in it?
2. Write any three advantages associated with the networking?
3. Name the text wrapping options available in word processing software.
4. While writing an essay on “School life”, Smita used the word principle instead of principal. She might have repeatedly committed the error while typing on the word processor. Help her to rectify the error by suggesting a feature of word and write the steps of the procedure.
5. Write down the steps to print handouts of a presentation.
6. Write the answers/commands based on the following table.

Table: Student

sno	sname	hobbies
101	Ram	Watching T.V
102	madhu	Reading story books
103	Revanth	Gardening
104	Shreyas	Surfing Internet

1. i) Write the create command for the given table “student”.
2. ii) Display the records whose hobby is ‘gardening’.

iii) Remove a record from the table whose name is ‘Ram’.

Section-D                                         2 X 5 = 10 M

2. Mr. Adithya has been asked to visit a school for visually impaired and enable them to use a computer. To overcome the challenges Adithya looks into accessibility options. What options would have Adithya explained to the students? What type of I/O device you will suggest for a person having difficulty using keyboard or mouse?
3. Write the spread sheet formula/expression/function to perform operations in the given table:

	A	B	C	D	E	F	G	H	I
1	S.No	Name	Eng	Maths	Hindi	Sci	Soc	Total	Average
2	1	Amar	97	90	90	80	60
3	3	Veer	85	100	84	91	68
4	5	Bharat	72	99	81	97	79
5	4	Vasanth	86	98	75	65	85
6	2	Sneha	93	89	93	77	94
7	6	Bhargav	80	75	75	92	98
8
9

1. Calculate the total marks obtained by a student.
2. Calculate the minimum marks in Hindi.
3. Calculate the average mark obtained by a student.
4. Calculate the highest mark in maths.
5. Name the feature used to arrange the data by student Number.