10th IT Periodic Test III (2018-19) VGS

10th IT Periodic Test III (2018-19)

School Name: Venkateshwar Global School, Sector 13, Rohini, Delhi 110085 India
Time: 2 hours
M.M: 50
Subject Code: 402
Class: X
Date: 16.01.2019

General Instructions:

• Question paper is divided into two sections: Sections – A and Section – B.
• Section – A:
  (i) Multiple choice question / Fill in the blanks / Direct Questions of 1 mark each. Answer any 10 questions out of the given 12 questions.
  (ii) Very Short Answer of 2 marks each. Answer any 5 questions from the given 7 questions.
  (iii). Short Answer of 3 marks each. Answer any 5 questions from the given 7 questions.
• Section – B: Long / Essay type questions of 5 marks each. Answer any 3 questions from the given 5 questions.
• All questions of a particular section must be attempted in the correct order.
• Please check that this question paper contains 31 questions out of which 23 questions are to be attempted.

Section A

Answer any 10 question out of the given 12 questions: [1]

Question: 1. Do not honk unnecessarily __________ traffic signals.
(a) across             (b) from                (c) under               (d) to

Question: 2. The shop is not far, it is just ___________ the road.
(a) across              (b) on                    (c) at                       (d) after

Question: 3. _________ option in Windows 7 is designed to assist people that have difficulty using a keyboard or a mouse.

Question: 4. A ______ is a discussion style site used by non-technical users for creating personal web pages.

Question: 5. After selecting the text, you need to click the _______ button in the Font group to make the font size larger than the current font size.

Question: 6. To see a section/page break, click on the _________ tab in MS Word.

Question: 7. When you ________ a row in Excel, row headers remain constant.

Question: 8. ________ are helpful way to make your slides look more dynamic.

Question: 9. Calendar software allows the user to ________ to other users’ meeting requests.

Question: 10. Temples refer to a _________ document.

Question: 11. We can categorize the appointments related to a task/project by using the _______ categories in MS Outlook.

Question: 12.  _________ are the building blocks of a database.

Very Short Questions: [2]

Answer any 5 questions out of the given 7 questions:

Question: 13. What is Clip Art? List any 2 websites that offer free clip arts.

Question: 14. Define the term ‘Network’. Given two advantages of computer networks.

Question: 15. What is conditional formatting? Write any 2 formatting effects we can apply using Conditional Formatting?

Question: 16. What do you mean by indentation? Explain the two ways of indenting a paragraph.

Question: 17. How do you insert a movie clip in Power Point? Explain any one method.

Question: 18. Mention the use of shapes and how to insert it in a MS Word document.

Question: 19. What is time management? Which feature of Microsoft Outlook acts as a time management tool?

Very Short Questions: [3]

Answer any 5 questions out of the given 7 questions:

Question: 20. Aman is preparing a Digital Presentation for his project. Give any three tips to be followed while making a digital Presentation.

Question: 21.

(a) Write the difference between Animation and Transition effects. [1](b) Ravi has to do the following in a digital presentation: [½ × 4 = 2](i). To show statistical data pictorially for analysis.
(ii). Write the keyboard shortcut to present a presentation.
(iii). Which option he shall use to keep guided text used by presenter.
(iv). Which option is used to print multiple slides on a page through the Print option?

Question: 22. What is OLE in Word Processor documents? Write the difference between Linking and Embedded objects?

Question: 23. Write the difference between Page Breaks and Section Breaks and also write two different options available in each.

Question: 24. 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.

Question: 25. You are planning a day out with your friends. Make a list of at least 3 points which you will take care of to make your trip memorable.

Question: 26. Define the following terms:
(a) Report            (b) Foreign Key              (c) DBMS

Section B

Long / Essay type questions: [5]

Answer any 3 questions out of the given 5 questions:

Question: 27. (a) What do you mean by data redundancy? [1]

Table: Employee

Field	Type
Emp_no	Chart (4)
Name	varchar (25)
Salary	Integer (5)
Department	varchar (15)

(b) Identify the primary key of the Employee table. Also mention the suitable reason for choosing it as a Primary Key. [2](c) Differentiate between DDL and DML commands. [2]

Question: 28. Amita uses Internet for her School Project. Suggest any five Security measure to ensure safety from online threats. [5]

Question: 29. (a) Explain the following terms: [1 × 3 = 3](i). Assistive Technology           (ii). IM             (iii). Wi-Fi
(b) Differentiate between LAN, WAN and MAN. [2]

Question: 30 Consider the following spreadsheet and answer the questions that follow: [1 × 5 = 5]

	A	B	C	D	E	F	G	H	I
1	R.No	Name	English 50	Maths 50	Science 50	Hindi 50	Total 200	Percentage	Remarks
2	1	Aaryan	48	49	40	49
3	2	Manas	35	40	45	46
4	3	Suman	40	42	35	43
5	4	Kabeer	42	40	45	42
6	5	Shradha	39	41	42	46

(a) Write a formula / function to calculate the Total in G2.
(b) Write the feature used for arranging the percentage in descending order.
(c) Write the formula to find the percentage in H2.
(d) To find the Average of total to be written in cell G7.
(e) Write the feature to display the record of the highest scorer in all subjects, only.

Question: 31. Explain the purpose of a blog. Mention any one free blog providing website. Also give any three guidelines for managing strong passwords.