10 Information Technology Pre-Board 2018-19

CBSE 10 Information Technology Pre-Board (2018-19)

School Name: Venkateshwar Global School, Sector 13, Rohini, Delhi 110085 India
Time: 2 hours
M.M: 50
Subject: Information Technology
Class: X
Date: 15/02/2019

General Instructions:

• Question paper is divided into two sections: Section 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 give 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 1o questions out of the given 12 questions: (1 mark each).

Question: 1. Could you get me ______  glass of milk?

1. a
2. the
3. an
4. to

Question: 2. I would to cancel ______ Mushroom Pizza I ordered.

1. a
2. an
3. the
4. to

Question: 3. Neha gave me a pen set as a return gift on ______ birthday.

1. herself
2. her
3. she
4. none

Question: 4. Which one of the following is in Present Continuous Tense?

1. Everybody will have a great time at the party.
2. Everybody is have a great time at the party.
3. Everybody have a great time at the party,
4. Everybody will be having a great time at the party.

Question: 5. _____ is not the type of wireless internet connectivity.

1. Wifi
2. DSL
3. 3G
4. WiMax

Question: 6. Which of the following is not a database software?

1. MS Access
2. SQL
3. Oracle
4. Opera

Question: 7. Autosum is used for ______ the values given in cells automatically without writing the formula the operation.

1. Multiplying
2. Adding
3. Comparing
4. Editing

Question: 8. Conditional Formatting is available under ______ group in the Home tab.

1. Editing
2. Cell
3. Styles
4. Number

Question: 9. Audio Clips are used for playing _______ while making presentations.

1. Slides
2. Animation
3. Sound
4. Movie

Question: 10. You can categorize appointments in time management software by giving specific ________ to appointments.

1. telephone calls
2. color
3. entry
4. time

Question: 11. A ______ is an appointment to which you invite people or reserve resources.

1. notes
2. meeting
3. journal
4. email

Question: 12. A / An ______ Statement is used to add records in a table.

1. Alter
2. Update
3. Select
4. Insert

Very Short Questions: (2 marks each)

Answer any 5 question out of the given 7 questions:

Question: 1. Identify the tense in the following sentence and convert them into present perfect tense:

1. I worked here for 3 years.
2. She will be doing he job well.

Question: 2. Explain any two terms and phrases for giving directions.

Question: 3. Different between header and footer. List and item that may be included each in header and footer.

Question: 4. Ramesh wants to given special effects while slide changes in a presentation. Suggest him an appropriate way to do so. Also, suggest an appropriate way to animate the slide objects in a slide.

Question: 5. Explain RDBMS and Data Servers.

Question: 6. Explain forms and reports with respect to databases.

Question: 7. In how many ways, you can insert a movie in the presentation? Mention them.

Short Questions: (3 marks each)

Answer any 5 questions out of the given 7 questions:

Question: 1. Explain the following terms:

1. WAN
2. WWW
3. MODEM

Question: 2. Explain following three terms:

1. Font shrink
2. Superscript
3. Toggle Case

Question: 3. Define the term ‘Network’. Give any two advantages of computer networks.

Question: 4. Explain following with respect to spreadsheets:

1. Page Break Preview
2. Conditional Formatting
3. Bar Chart

Question: 5. Kamakshi is preparing a Digital Presentation. Given her three tips for making an effective presentation.

Question: 6. State three features of Instant massaging Services.

Question: 7. Write answer based on the following table:

Table: Employee

a. Suggest a suitable data type for the field Empid and Name in the table Employee.

b. Write a query to display all the records of the table for deptid = 101.

c.  Add a new record with the following details:
(‘7’, ‘Chandan Malkhija’, 102, ‘MCA’, ‘M’)

Section B (Long / Essay Type Questions – 5 marks each)

Answer any 3 questions out of the given 5 questions:

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

Question: 2. Consider the following spreadsheet and answer the questions that follow:

1. Caculate the Total sale for the year 2008 in cell B6.
2. Write formula/expression to find difference in sales of Mumbai and Delhi for the year 2009 as sales of New Delhi-sales of Mumbai.
3. Write formula/expression to find the average sale of year 2010.
4. Write expression to find total sale for the year 2010 and 2011 in Mumbai in cell G3.
5. Name the chart that may be used to show the relationship of the changes in the data over a period of time.

Question: 3.

1. Write an SQL command to create a table ‘BOOK’: [1] BOOK ID Char (4)
   Bname Varchar (15)
   Author Varchar (20)
   Price Decimal
2. Identify the primary key of the Book Table, also mention the suitable reason for choosing it as a Primary Key. [2]
3. Differentiate between: [2] (i) char and varchar data type
   (ii) DDL and DML

Question: 4. Explain the following terms:

1. Internet
2. LAN
3. Webpage
4. Database
5. WiMax

Question: 5. Suggest any 5 security measure to ensure safety from online threats.