Home » 10th Class » Information Technology 402 CBSE Class 10 previous year Solved Paper, NSQF Information Technology Class 10

Information Technology 402 CBSE Class 10 previous year Solved Paper, NSQF Information Technology Class 10

Information Technology 402 CBSE Class 10 previous year Solved Paper

Marking scheme

Information Technology (402)

CBSE

 

 

Open Question Paper of Information Technology (402) Year 2018

Section A

(Attempt any 2)

  1. (b) around
  2. (b) to
  3. (a) very
  4. (a) some

(Attempt any 4)

1 mark each

  1. (b) Vertical)
  2. (a) styles
  3. (b) Create
  4. (b) Meeting
  5. (b) Packet
  6. (b) Notes
  7. (a) Local Area Network
  8. (d) Slide Transition

Section B (2 marks each)

Any 4 points from the following

Q.13       Mention four points that should be included in your resume or Curriculum Vitae.

Ans.  Your details: name, address, phone number, email address

  1. personal statement: a paragraph about your skills, objectives
  2. Work experience
  3. Education
  4. skills
  5. hobbies & interests
  6. References
  1. (Any 4 points)

Q.14       You are planning a day out with your friends. Make a list of at least 4 Points which you will take care of to make your trip memorable.

Ans. Day, time and place that suits every one, Camera, favourite Food to pack for a day trip water, snacks),

Q.15       You have recently attended a Cyber Safety workshop in your school. You are excited to share the information with your mother. How would you describe the event?

Ans. Cyber Safety workshop was held on Monday in my school. It was very interesting and knowledgeable. Cyber Safety workshop covered the basic of internet security, the things that can potentially go wrong and the simple steps you can take to avoid them

Q.16       Write Steps to print Handouts/Notes page of a Presentation.

Ans.

  1. Open Print Preview: Click the Microsoft Office Button and run your mouse over the Print button. The Print Menu will appear to the right. From this menu, click the Print Preview button. Once you open Print Preview, a ribbon with Heading Print Preview appears.
  2. View the Print Options: Under the Print Setup heading, click the arrow to open the menu under the option Print What:. In this menu, your print options will show up. These options include: Slides, Handouts, Notes Pages and Outline View.
  3. Printing Handouts: With the Handouts option, you have the choice of printing 1-9 slides per page. Printing Notes Pages: The Notes Pages option will print out each slide with your personal notes

Or

Q.16A    Write steps to create Table in a Presentation Software.

Ans.

Select the slide that you want to add a table to.

On the Insert tab, select Table

In the Insert Table dialog box, do one of the following:

Use the mouse to select the number of rows and columns that you want.

Select Insert Table, and then enter a number in the Number of columns and Number of rows lists.

To add text to the table cells, click a cell, and then enter your text. After you enter your text, click outside the table

Q.17       Illustrate the use of Header and Footer in your document.

Ans.  The header is a section of the document that appears in the top margin, while the footer is a section of the document that appears in the bottom margin. Headers and footers generally contain information such as the page number, date, and document name, an author name, a graphic, a draft or revision number they appear on every page of the document with same value or related changes like page number etc which help at the time of printing documents.

OR

Q.17B    List any four types of Tab Alignment available in a Word Processor.

Ans.  Left align Right Align, Center Align, Decimal and Bar align ( any 4)

Q.18       What is DDL? Mention any Two DDL Statements.

Ans.  DDL: DDL refers to “Data Definition Language”, is a standard for commands that define the different structures in a database typically by creating, deleting, or modifying schema objects such as databases, tables, and views DDL statements are CREATE, DROP ALTER (any 2)

Q.19       Write SQL Query to create the table flight with the following structure:

Field Type
Flight_ID Char(4)
Flight_Name Varchar(25)
Source Varchar(30)
Destination Varchar(30)

 

Ans.  CREATE TABLE FLIGHT ( Flight_ID char(4), Flight_Name Varchar(25), Source Varchar(30), Destination Varchar(30));

Q.20       Write two features of calendar software of an email messaging software.

Ans.   Calendaring software will contain one or more of the following features: (any 2)

Calendar – a calendar showing dates and days of the week.

Address book-a list of contacts with information to enable the user to communicate with the contacts

Appointment attachments – This feature allow users to attach a file to an appointment. If the appointment includes other participants, the attachment is shared with them.

Appointment calendar – a list of appointments and the attendees for the appointments.

Appointment reminders – Automatically reminds participants of an upcoming Meetings.

Availability sharing – this feature allows users to share their availability with others

Availability and capacity checking – Check the availability of all other employee and resource calendars in the group.

Calendar publishing – some calendaring tools allow the user to publish select calendar information on a public link

Calendar exporting – Users are allowed to export selected calendars into various file formats, including Calendar standard.

Collaborative scheduling – the capability of the software to check schedules and propose meeting times to all of the participants.

Customization – This feature allow users to customize several available features such as: email appointment remainders, calendar.viewing default, workweek and work hours display, etc.

E-mail – an electronic mail communication system. This can be tied into the appointment calendar to send reminders and notify the participants of issues arising with scheduled meetings.

SECTION C (3 marks each)

Q.21       What is an advantage of using document template? Write steps to use a document template.

Ans.  Advantages of Document Template

  1. Perfect format styles
  2. Can be repeat with in many document creation
  3. More Efficient Use of Time
  4. Simplified Document Creation

Steps to use a Document template

  1. Click on Office Button and select New
  2. From the New Document Dialog box select My templates for using your own templates or Installed templates for using Microsoft inbuilt templates.
  3. After your selection click on create to work on selected templates.

Q.22       What are Clip Arts? Differentiate between Linking and Embedding an object.

Ans.  Clip Arts –

Clip art is a collection of pictures or images that can be imported into a document or another program. The images may be either raster graphics or vector graphics. Most clip art is royalty free, meaning you can use the images without paying royalties to the creators of the images.

Difference –

Embedding an object in the media item places a copy of the original object (Word document, image file, etc.) into the database. When the original document/object have some changed it never effects the Embedded Contents.

Linking to an object-

In Linking, when adding a media object adds a path to the original object, instead of embedding a copy of the object in the database. When the original document/object have some changed it directly effects the Linked Contents

Q.23       Aadya is working on a spreadsheet. Help her with the solutions for the following:

  1. Identity the following symbol/toolbar: Ƹ
  2. Renaming a worksheet from sheet 1 to Cost Sheet
  3. To keep the headings constant/visible even if she scrolls down.

Ans.  (a) Ƹ symbol(AUTOSUM) default perform sum of the selected range. The drop down attached with it contains other function of the excel(sum, average, count, max etc)

(b) from the WORKSHEET TAB Right click on SHEET 1 and select RENAME, type COST SHEET and press enter to confirm the changes

(c) Use FREEZE PANE on the next row of the heading which need to appear constantly

Q.24       Ridhan is preparing a digital presentation. Help him with the solutions for the following tasks:

  1. Which option he shall use to make the presentation dynamic and add graphics and text to it?
  2. He wants to move all the images/objects together on the same slide.
  3. Which option he shall use to keep guided text used by presenter? These notes should not appear to the audience during presentation.

 

Ans.   (1) ANIMATIONS is the option for dynamic presentation on graphics and text of slides

(ii) GROUP

(iii)SPEAKER NOTES

Q.25       Consider the following table and answer the following :

ID Department OPD_DAYS Doctor_Name
H201 ENT MWF Akaash Arora
H308 Oncology TTS Dharma Sharma
H907 Paediatrics MWF Sanjay Singh
  1. Identify suitable Primary Key from the above table.
  2. Add a new record with the following data

                                (‘H608’, ‘Cardiology’, ‘TTS’, ‘Vinita Wahi’)

  1. Write a select query to display records of those Doctors whose OPD_DAYS are ‘MWF’.

Ans.  (a) Primary key = ID

(b)INSERT INTO <tablename> VALUES(‘h608’, ‘cardiology’,’TTS’, ‘Vinita Wahi’);

(c) SELECT * FROM <tablename> WHERE OPD DAYS = ‘MWF’;

Q.26       Mention three Features of Instant Messaging Service.

Messaging features

Ans.  Text Chat, Offline Messages, Chat History, User Status Visibility,

Group chat messaging features

Chat Rooms, Broadcast Message, Text Conference, Tabbed Chat

Data Transfer Features

Unlimited Size File Transfer, Co-browsing, Screen Shot, Screen-sharing,

Chat Features

Voice Chat, Video Chat, Whiteboard,

Supplementary Messaging Features

Compatibility. Antivirus, Spell check, Updates

 

SECTION D (5 marks each)

Q.27.     Riya uses Internet for her School Project. She is unaware of possible online threats. Mention two online threats and three measures she shall take to ensure safety from online threats.

Ans.   Online Threats : (any 2) Spam, Adware, Trojan, Virus, Worms, Phishing, Spyware, Rogue Security Software Safety Measures : (any 3)

Stick to private online communities.

Block hackers and intruders with a firewall

Keep computer viruses and spyware out

Be careful when opening email and attachments

Be selective about what you download and from which sites

Choose complex passwords don’t let your web browser remember your personal information

Update Internet Security software to new versions

Q.28       Given the following Spreadsheet, write the appropriate Formula/Expression/Function tobe used for (a) to (e):

A B C D E F G
Player ID Name Points Bonus Rank Total  
1 Jaideep Singh 1300 200 4    
2 Ananya Grover 1800 150 1    
3 Mihir Sharma 1600 100 3    
4 Varsha Pandey 1200 100 5    
5 Sandeep Singh 1700 200 2    
             

 

  1. a) Write formula to calculate the Total points (Sum of Points + Bonus) of each player in Cell F2-F6.
  2. b) Write the feature used for arranging the Rank from Highest to Lowest.
  3. c) To find the Player the Maximum TOTAL to be written to Cell F7.
  4. d) To find the Average of Points to be written in cell C7.
  5. e) To change the Orientation of the Page from Landscape to Portrait.

 

Ans.

(a) F2=C2+D2, F3=C3+D3, F4-C4+D4, F5-65+DS, F6=C6+D6

(B) sort(z to a)

(C) F7= MAX(F2:F6)

(D) C7= AVERAGE(C2:06)

(E) From PAGE LAYOUT Ribbon.goto PAGESETUP group click on ORIENTATION drop down and select PORTRAIT

About

The main objective of this website is to provide quality study material to all students (from 1st to 12th class of any board) irrespective of their background as our motto is “Education for Everyone”. It is also a very good platform for teachers who want to share their valuable knowledge.

commentscomments

  1. Pawan singh says:

    Thanks life saver yaar
    Today is my IT exam
    Thanks again

  2. Pawan singh says:

    Thanks life saver yaar
    Today is my exam

  3. Ritesh says:

    Thank you sir you are the great

  4. ishita rathore... says:

    thanks also to me yrr tomorrow will also my exam… i think it will very helpful to me… thanks again yrr☺☺

  5. Shridhan says:

    It is helpful

  6. Machifa- YouTube channel says:

    What is Text wrapping?
    Please answer.

  7. harshita says:

    Thanku sir. …all the best for boards to all

  8. Bhumi says:

    I don’t know that this will help me or not??

  9. Yashasvi Arya says:

    Thank you 😊
    It was a bit of helpful..
    And all the best to all my dear colleagues who are gonna appear for boards this time..☺️☺️

  10. Hitesh says:

    Thank You

  11. Satya prakash says:

    Thanks a lot sir for providing solution of question paper

  12. Kiran says:

    thanku sir for this answers

Leave a Reply

Your email address will not be published. Required fields are marked *