IT 402 SAMPLE PAPER WITH ANSWER(V.V.I)

Sample Paper Class 10 (Information Technology) 2019-20(v.v.i)

       

1. Language

2. de-stressing

3. Operating System

4. Entrepreneur

5. sustainable development

6. walking, skipping

7.
8. Mental, Physical, Social, Financial.

9. 
10.

11. Factors causing ecological imbalance are as follows:
a. Destruction of forests
b. Industrialization
c. Urbanization
d. Large scale use of pesticides
e. Overgrazing

12. FilterKeys

13. Digital subscriber line(DSL) provide Internet access by transmitting digital data over wires of a local telephone network. DSL service is delivered along with wired telephone service on the same telephone line.

14. Footer

15. b) Symbols Groups

16. Filter

17. Chart

18. a) Slide transition

19. a) Grouping

20. c) Select

21. a) Row

22. Colors

23. Journal entry creates a timeline of transactions that can be linked to a contact. A transaction might be an email, task, appointment etc. 
The following activities can be automatically recorded: 
• Emails Sent & Received 
• Telephone calls 
• Meeting requests & responses 
• Office documents you manage

24. We can use a blog to convey messages about events, announcements, news, reviews, etc. Blogs are usually managed using a web browser and this requires active internet connection. You can also use offline blog software to create content first and later publish the content when an active internet connection is available. 
There are hundreds of websites that offer blog service for free. 
Some of the popular blogs include: 
• www.WordPress.com 
• www.blogger.com 
• www.blog.com 
• www.weebly.com 
• www.blogsome.com

25. PAGE BREAK

·       It simply separates content between pages. A page break starts a new page.

·       After the page break, the following text will always start at the beginning of the page.

·       Of this type there are three kinds: simple page breaks, column page breaks, and text wrapping page breaks.

SECTION BREAK
• It splits your document into sections.
• Each section can have its own header/footer formatting.
• Of this type there are four kinds: next page section breaks, continuous section breaks, even page section breaks, and odd page section breaks.

26.

Conditional Formatting (CF) is a tool that allows you to apply formats to a cell or range of cells, and have that formatting change depending on the value of the cell or the value of a formula.

 

For example, you can have a cell appear bold only when the value of the cell is greater than 100.  When the value of the cell meets the format condition, the format you select is applied to the cell.  If the value of the cell does not meet the format condition,  the cell's default formatting is used. (By "default formatting", I mean the formatting that you set up using the normal formatting tools, not necessarily the worksheet's default font and font size.)

27.
Journal entry creates a timeline of transactions that can be linked to a contact. A transaction might be an email, task, appointment etc. The following activities can be automatically recorded: 
• Emails Sent & Received 
• Telephone calls 
• Meeting requests & responses 
• Office documents you manage

28. 

Flat File: Data is stored in a single table. Usually suitable for less amount of data.

Relational: Data is stored in multiple tables and the tables are linked using a common field. Relational is suitable for medium to large amount of data.

29.  Effective uses of animation effects: 
• Helps focus audience attention on information. 
• Controls the flow of information especially while explaining a diagram. 
• Reveal concepts one by one.

30. 
i) Insert Tab
ii) Different Wrap Text options such as Square, Tight, Through, Top and Bottom, Behind Text, In Front of Text etc. and observe the changes made to the wrapping.

31. Different options to make changes to a character or word:-

1.     Font Face

2.     Font Size

3.     Grow Font -  to make font size larger than the current size by the specified point.

4.     Shrink Font -  to make font size smaller than the current size by the specified point.

5.     Strikethrough – to make a strike through the middle of the selected text.

6.     Subscript – to make the selected text lower than the normal text position.

7.     Superscript – to make the selected text higher than the normal text position.

8.     Clear Formatting – used to clear the character formatting.

9.     Text Highlight Colour -  used to change the background colour of the text.

10.           Font Colour – used to change the colour of the text.

11.           Change Case – helps us to change the text case to capital letters or small letter. Different change case options are :-

(i)               Sentence Case:- the first character in the First word of the selected sentence will be in Upper case and rest of characters will be in small case.

(ii)            Lowercase:-  selected text will be converted to small letters.

(iii)          Uppercase:- selected text will be converted to Capital letters.

(iv)          Capitalize Each Word:- the first character in all the words of the selected sentence will be converted to Capital letter.

(v)            tOGGLE cASE:- the small letters in the selected text will be converted to capital letters and capital letters will be converted to small letter.

32. 

33.

TABLE :- A table is a set of data elements that is organized using a model of vertical columns and horizontal rows. Each row is identified by a unique key index or the key field.

PRIMARY KEY:- A primary key is a unique value that identifies a row in a table. These keys are also indexed in the database, making it faster for the database to search a record.

FOREIGN KEY:- The foreign key identifies a column or set of columns in one (referencing) table that refers to a column or set of columns in another (referenced) table.

Note:- The “one” side of a relation is always the parent, and provides the PK(Primary Key) Attributes to be copied. The “many” side of a relation is always the child, into which the FK(Foreign Key) attributes are copied.

Memorize it : one, parent, PK (Primary Key) ; many, child , FK (Foreign Key)

34.

i) If the presentation is to be made to an audience, use the Presented by a speaker (full screen) option. 

ii) If the presentation is to be made to an individual, use Browsed by an individual (window) option. 

iii) If the presentation is to be made at Kiosks, use the Browser at a Kiosk (full screen) option.

KIOSK -If the presentation is to be made to an audience, use the Presented by a speaker (full screen) option. If the presentation is to be made to an individual, use Browsed by an individual (window) option. If the presentation is to be made at Kiosks, use the Browser at a Kiosk (full screen) option.

35.

DATA DEFINITION / DESCRIPTION LANGUAGE:- It is a standard for commands that define the different structures in a database. DDL statements create,modify and remove database objects such as tables, indexes and users.

Common DDL Statements are:-

1. Create :- Used to create database objects.

2. Alter :- Used to modify database objects.

3. Drop :- Used to delete database objects.

DATA MANIPULATION LANGUAGE:- It is a standard for commands that enables users to access and manipulate data in a database.

Common DML Statements are:-

1. SELECT :- Used for retrieval of information from the database.

2. INSERT :- Used for insertion of new information into the database.

3. DELETE :- Used for deletion of information in the database.

4. UPDATE :- Used for modification of information in the database.

36. 

• The three types of views available in spreadsheet are.
• 1) Normal view.
• 2) Page Layout view.
• 3) Page Break view.
• The normal view is the default view and used this view to build or to edit spreadsheet.
• In page break view, it displays the blue lines which mean page breaks

37.  

• Plan carefully.
• Do your research.
• Know your audience.
• Time your presentation.
• Speak comfortably and clearly.
• Check the spelling and grammar.

38.
(ANY TWO)

39. IT'S HOMEWORK AS I HAVE TO WRITE MY EXAM ALSO.

BEST OF LUCK .