Plagiarism !!!! Check out the link below to know about it :

https://www.youtube.com/watch?v=Pmab92ghG0M&list=PL4aiVDH2DXq26cV7zU0JA5k4m1vnal3dg&t=25s&index=1

What google and facebook are hiding ? Find out more by clicking on the link below:

https://www.youtube.com/watch?v=dP3fsXAADAo&list=PL4aiVDH2DXq26cV7zU0JA5k4m1vnal3dg&index=3&t=191s

Class-9 - Chapter 13- Formulae and Functions in a Spreadsheet

Class-9 - Chapter 13- Formulae and Functions in a Spreadsheet

Fill in the blanks:

1. =

2. Concatenation

3. wide

4. relative

5. AutoSum

Multiple choice questions:

1. &

2. relative referencing

3. Absolute cell reference

4. B3+C3+D3

5. 5

Very Short answer questions:

1. C2= D2+E3

2. Max(B1:B5)

3. D4/D6 ( on clicking Percentage option in format cells)

4.(i) In Editing group on the Home tab

   (ii) In Function Library group on the Formulas tab

5. Yes it will remain the same. Output is 50

Short answer questions:

1. Page 303- The process of combining text values within formulae is called concatenation.

Write the example given under Text formulae

2. ^,*,/,+,-

3. A combination of relative and absolute referencing is called mixed referencing.

Page 305- write 3rd bullet.

4. Output- 9. Yes it will change. When a cell is deleted, the data gets deleted. Hence, in the formula we have only 4 numbers whose average has to be taken.

5. The IF function returns one value if a specified condition evaluates to TRUE, or another values if it evaluates to FALSE.

Long answer questions:

1. A formula is a sequence of values, cell references, functions, and/or operators that is contained in a cell and produces new values from existing values.

Date format is: DDMMYYYY

2. 3 types are: Relative, Absolute, Mixed referencing.

Describe them with example:

Relative- Page 304 (write completely with an example)

Absolute- Page 305 (Write completely -all paragraphs of it)

Mixed - Page 305 (Write till 3rd bullet)

3. By using SUM function or by using AutoSUM function

4. Page 307- Functions: Define it and write about Arguments and Structure only

5. Page 310- Printing a worksheet write only the 5 steps. No description required.

Application based questions:

1.

    (a) 40

    (b) -20
    (c) D3 = $A$3 + C3
    (D) D3 = $A3 + C3
    (E) D4 = $A3 + C$3

   

2.

    (a) D2 = 40% * C2

    (b) E2 = 45% * C2
    (C) F2 = 10% * C2
    (D) G2 = C2 + D2 + E2 - F2
    (E) H2 = IF (G2 > = 50000, "N","Y")
    (F) No, The manager will not have to do the changes again as excel automatically recalculates when data values are changes, all the corresponding values will also change. 

3.

    (a) A2, B2, C2, D2

    (b) =MAX(A3:E3)

    (c) =MIN(A3:E3)

4. It is circular reference warning. This is shown when formula contains a circular reference and may not calculate correctly. Here, the cell where total sum has to be displayed is also considered for adding up the result. But, this cell actually doesn't contain any value.

5.

    (a) D2=IF(C2<=40000, 10%*C2, 5%*C2)

    (b) Use AutoFill handle of the cell D2.

Class IX Chapter 14 Advanced Features of a Spreadsheet

Chapter 14- Advanced Features of a Spreadsheet

Fill in the blanks:

1. Sort

2. Conditional

3. Filter

4. Charts

5. Pie

Multiple choice questions:

1. Design Tab

2. Add Level

3. Doughnut

4. Chart label

5. All of these

Very short answer questions:

1. Convert to range

2. Either Delhi or Mumbai

3. Legend

4. Design, Layout, Format

5. Move chart

Short answer questions:

1. Sorting arranges the given data, which may be textual, numerical, or alphanumerical in a specified order.

   Filtering is a quick and easy way to find and work with parts of data in a range.The filter feature selectively blocks out the data you do not want to see.

2. Custom filtering is the process of filtering data on specific conditions.

    Click on Clear Filter option to remove custom filtering.

3. Conditional formatting is a feature in MS Excel that sets a cell's format according to the conditions that are specified. This feature can be used to display numbers in cells in a particular colour, depending on whether they are greater than, equal to, or less than a certain number.

4. Line chart-Page 327 (with diagram) , Area chart- Page 328 (with diagram)

5. Data series, X-axis, Y-axis, Chart title, Axis title, Chart area, Plot area, Legend, Grid lines, Data Label.

Long answer questions:

1. Page 319-write all 5 steps.

2. Sorting data on one column- page 321- all 4 steps.

    Sorting on more than one column- page 322- all 8 steps.

3. A pictorial representation of data is chart.Charts make it easier to understand large amounts of data.It helps to 'see' the relationship between different parts of the data.

Steps to create a chart- page 330- all 5 points.

4. Scatter chart- page 327 & 328 - with diagram

5. Page 331- changing the design of a chart- write first 2 points ( point 1 and 2)

Application based questions:

1.

   (a) Logical ability-filtered records- roll 4- chetna

        GK - filtered records- Roll 2- Ashish, Roll 3- Beena, Roll 6- Reema, Roll 8- Yogesh

   (b) Beena, Chetna, Yogesh, Bijoy, Reema, Biswas, Anu, Ashish

   (c) Beena, Chetna, Yogesh, Bijoy, Ashish, Biswas, Reema, Anu

   (d) Nil

   (e) Beena,Bijoy,Biswas

2.

   (a) Bar chart

   (b) Top-centre

   (c) X-axis-> Number of medals, Y-axis-> Country Name

   (d) USA

   (e) Japan and France

3.

  (a) Line chart

  (b) Bottom

  (c) Comparison of Profit

  (d) Company B

  (e) (i) Line chart

       (ii) Column or bar chart

4.

  (a) Column chart

  (b) Literacy rate in different states(in %)

  (c) X-axis-> States

       Y-axis-> Literacy (in %)

  (d) Yes, on right-hand side.

  (e) Highest-> Kerala, Lowest-> Tamil Nadu

  (f) Goa

5.

 (a) Pie

 (b) and (c) Not Attempted ( Image is not clear)

Class IX Chapter 12 ( Introduction to Spreadsheet)

Class IX (CH - 12 Introduction To Spreadsheet)

I. Objective Type questions

A. Fill in the blanks:

1. 3

2. AB

3. Formula

4.all

5. Auto Filled

B. Multiple Choice Question:

1. Active Cell

2. Name Box

3. F8

4.Merge and Center

5. Top

Descriptive:

A. Very short answers:

1. MS Excel.

2. Insert

3. E7

4. A1:E5

5. Auto fill

B. Short question answers:

1. Workbook is a collection of worksheets.

    Worksheets : Each page of the workbook containing a grid of rectangular cells made up of rows    and columns.

2. Numbers, Text, Formulae

3. It is used to cancel the data entry without pressing the DELETE key.

4. It refers to the position at which data is placed within the boundary of a cell.Numbers are always right-aligned and text is always left-aligned.

5. two ways are- in the CUSTOM Lists dialog box or by importing a list.

C. Long question answer:

1. A range is a rectangular block of contiguous cells, i.e. , cells that touch each other, especially along a line. The two methods of selecting a range of cells are;

      (i) Using Extend selection mode(Page 277 -write all 4 steps)

     (ii) Using Go To Command (Page 277 - write all 6 steps.)

2. Two ways of Editing cells are :

      (i) By overwriting (Page 278-Write the complete paragraph )

      (ii) By Partial Modification(Page 278- Write the complete paragraph)

3.  Page 281- Changing row height and column width- write all 4 steps.

4.  A custom list is list that has a series or a list already stored and can be used just like the Autofill    feature as and whenever necessary.

 Method of creating a custom list: Page 287- write 1st three steps(To add a list in custom list)

5. Page 286- first 2 steps.

Application based questions:

1

   (a) Centre Alignment

   (b) Merge and Centre

   (c)  Left

   (d) Fill colour

   (e) Bold

 

   (f) All borders

2.

   (a) A3- 5

        A4- 6

        A5- 7

    (b) B2-Mon, B3-Tue, B4-Wed, B5-Thus, B6-Fri, B7-Sat

    (c) C3-July, C4-Oct

3. Shift key, range of cells, last cell, shift key, activate, arrow

4.

   (a) Cut or copy

   

   (b) Either click outside the cell or click on 'Undo' or press 'Ctrl+Z'

   (c) Delete entire row

   (d) Ctrl+Z or Undo

5.

   (a) By dragging the column line

 

   (b) Formula Bar

   (c) Merge and centre

Class X chapter 11 ( XML)

CLASS X 

                                                      CHAPTER-11 XML 

I.

A. Fill ups:-

1. HTML,XML

2. Data

3. .xml

4. User

5. XML

B. True or False:-

1.True

2.False

3.True

4.False

5.True

C. MCQ:-

1.(d)both a and c.

2.(d)both a and c

3.(b)markup language

4.(c)<!--This is my comment-->

5.(c)the document should have a DTD

II.

A. Very short answers:-

1. Extensible Markup Language

2. The XML document structure is like a tree. It has a root element, which is the parent of all other elements. An element can have sub-elements or child elements.

3.'The white spaces are not truncated' is XML.

4.It is a sequence of characters used to represent other sequence of characters.

5.The two types of DTD are as follows:-

      a. Internal DTD

      b. External DTD

B. Short Answers:-

1. XML was created so that richly structured documents could be used over the web and to overcome the problems associated with HTML.

2.<!--It stores a record-->

3.An XML element is everything from the element's start tag to the element's end tag, including the start tag, end tag and the content.

4. DTD stands for Document Type Definition. It provides a list of the elements contained in an XML document and their relationships to one another.

5. XML Parser is a software that reads an XML document, identifies all the XML tags, and passes the data to various applications.

C. Long answers :-

1. Naming rules for XML are the following:

(a) Names can contain letters, numbers and other characters.

(b) Element names cannot start with a number or punctuation character.

(c) They cannot start with the letters xml (or Xml,XML,etc.)

(d) ELEMENT names cannot contain spaces.

2.

 DATA SEPARATION:- In HTML,the static text content is placed between tags and is never modified by any process.In XML, data is stored in a separate XML file and can be updated with a few lines of JAVA script.

DATA SHARING:- XML provides a way of sharing data that is independent of the software and hardware used. Such independence makes the data available to more users. In HTML data is a part of the .html document. It is not store separately and therefore such sharing of data is not possible.

DOCUMENT STRUCTURE:- The XML document structure is like a tree. It has a root element, which is the parent of all other elements. An element can have sub-elements or child elements.   In HTML, such a document structure is not present.

TAGS:-

In XML, tags are user-defined. In HTML, they are predefined.

In XML, every opening tag must have a corresponding closing tags. Tags are paired in HTML too, but in some cases pairing is optional.

In XML, a nested tag pair can't overlap with another tag. In HTML, tags may appear without satisfying the rules of proper nesting.

In XML tag names are case sensitive. In HTML tags are not case sensitive.

ATTRIBUTE:- In HTML, we can change the background color by BGCOLOR attribute, text color by TEXT attribute, link color by LINK attribute, visited link color by VLINK attribute, and active link color ALINK attribute. In XML, all elements can have associative attributes which specify their characteristics.

ATTRIBUTE VALUE:-In HTML, the attribute value can be written without quotes, with double quotes or  with single quotes. In XML, the attribute value should be surrounded by double quotes.

3. Requirements for well-formed XML document are:-

       (1) the root and child elements must be nested in a proper way.

       (2) each start tags must have a corresponding end tag.

       (3)  all empty tags must be enclosed properly.

4. The two types of DTD are: -

    A. Internal DTD - it is contained within the document. It defines the components of only 1 document, the one in which it is included.

       B. External DTD - it is a separate file that defines the elements and other document components of the current XML document.

5. The two types of XML Parser are: -

      (a) Non-validating XML Parser: it checks whether an XML document is well-formed, i.e., if the document is properly marked up according to XML syntax rules.

      (b) Validating XML Parser: it checks if an XML document is well-formed and also ensures that all elements in the document are exactly as specified in the DTD to which the document is bound.

D. Applications based questions: -

1.

a. <message>

b. <from>, <to>, <subject> and < body>

c.<name>, <telephone>and< residence>

2.

a. In this, <? xml version="1.0"?>. Is the processing instruction. A processing instruction gives instructions to the application.

b. <car ID ="S1">

<model color="Blue"> Santro CS </ model>

c. Yes.

3. <?xml version="1.0"?>

<!DOCTYPE salarydata

[

<! ELEMENT data (code, name, salary)>

<! ELEMENT code (# PCDATA)>

<! ELEMENT name ( # PCDATA)>

<! ELEMENT salary (# PCDATA)>

]>

<code>E001</code>

<name>Deepa Chugh</name>

<salary>19000</salary>

<code>E002</code>

<name>Parth Jain</name>

<salary>22500</salary>

4.   a.

                         Club

                             |

                        Member

   ______________|________________

   |                           |                                |

 No                   name                         charges

b.                                  

                                           hostel

                                               |

           __________________________________

         |                                                                     |

     groundfloor                                             firstfloor

          |                                                               |

____________                                      ________________

|                       |                                     |                               |

room            rent                                room                        rent

5. a. <clubdetails>

b. There is only one child element and it is <member>.

c. It signifies that atleast once or any time should appear.

d. Name ID has an attribute with it and that is REQUIRED.

e. The ',' sign signifies that the element should appear strictly in the order in which they are defined in the element declaration.

f. If you will change',' sign to '|' then, the elements first were strictly in order but now they may appear only once or more than once.

6. <?xml version="1.0"?>

<!DOCTYPE student[

<!ELEMENT student( lastname,firstname*,dob?,gender,(sc|st)?)>

<!ELEMENT lastname (#PCDATA)>

<!ELEMENT firstname (#PCDATA)>

<!ELEMENT dob (#PCDATA)>

<!ELEMENT gender (#PCDATA)>

<!ELEMENT sc (#PCDATA)>

<!ELEMENT st (#PCDATA)>

<lastname>Jaiswal</lastname>

<firstname>ram</firstname>

<firstname>madan</firstname>

<gender>male</gender>

<sc>SCHEDULED CASTE</sc>

Class X Chapter 12 Societal Impact of Information Technology

CHAPTER - 12(Class 10)

SOCIETAL IMPACT OF INFORMATION TECHNOLOGY

I.

A. Fill ups:-

1. Trojan Horse

2. Malware

3. Worm

4. Cybercrime

5. Encryption

B. True or False:-

1. True

2. True

3. True

4. True

5. True

C. Multiple Choice Questions:-

1. (b)Trojan Horse

2. (b)Spyware

3. (b)Typing Through Keyboard

4. (a)Online Backup

5. (b)Cracker

II.

A. Very Short Answers:-

1. Antivirus

2. Spam

3. E-commerce

4. When user downloads something from the internet.

5. Data Backup means to make copies of data in a removable, long term storage device.

B. Short Answers:-

1. Infomaniac has a habit of continuously responding to electronic communication such as e-mails, SMSs, etc.

2. A digital certificate is a kind of a digital code or credential that authenticates the identity of the server.

3. Malware is a generic term used for any program designed to infiltrate a computer without the user's consent.

4. A computer virus is a program that attaches itself to other programs in order to alter their behaviour, often in a harmful way.

 Two ways in which virus can spread into our computer system are as follows:-

      (a)    Sharing of infected files over a network, through infected CD-ROMs and through e-mails.

  (b) Downloading any applications from internet or any web sites.

5. HACKER: It is a term used for a computer enthusiast i.e. a person who enjoys learning programming languages and computer systems, and can often be considered an expert on the subjects.

   CRACKER: It is a term used to refer to an individual who gains unauthorized access to a computer system for the purpose of stealing and corrupting data

C. Long Answers:-

1. Antivirus Program is designed to detect and remove malicious programs.

It runs in the background all the times.

It is updated regularly so that it recognizes new versions of malicious programs.

2. Online Backup refers to copying of data to some other computer     on the internet for online storage.

Two advantages of online backup are:

(a) Data is stored safely at some remote location that is far away from the original data.

(b) Privacy and security of data are assured with encryption and password protection.

3. Spam refers to any unsolicited, unwanted e-mails.

  Ways of avoiding getting spam are as follows:

 Use the spam filter of your e-mail program to block unwanted e-mails.

Delete spam mails without reading them.

4. E-commerce takes place in the following ways:

 Suppose Alina wants to buy a portable music player online:

1. Alina's computer is connected to the internet. She opens a web browser and types the URL of the website in the address bar and press enter key.

2. The web server responds by sending its digital certificate, which includes its public key, to Alina's computer.

3. The browser verifies the digital certificate of the browser.

4. The browser will generate a one time, unique session key.

5. The web server decrypts the encrypted session key using the private key and gets the session key.

When Alina chooses the desired product and proceeds to buy it:

1. The URL of the website now starts with https: instead of http:.

2. A lock icon appears after the address bar of the browser, indicating that the browser is now in the secure mode. When the browser is running in the normal mode, this icon doesn't appear.

5. ICT is a broad term that signifies the integration of information technology tools broadcasting technology, audio and video processing equipment, and telecommunication equipment. 

Use of ICT in Healthcare:

a. It is used by the Government in controlling the spread of communicable diseases,

b. It is used to promote medical education and training.

Use of ICT in governance:

a. It helps the government to deliver services effectively

b. It maintains transparency in the system and keeps a check on malpractices.

D. Application based:

1.

a. Worm has affected the computer.

b. She should install antivirus.

c. She can install kaspersky Antivirus, Quick Heal to get rid of this situation.

d. Not regularly but should be updated over a period of time.

2.a.

 A password should have atleast 8-10 characters in length.

The password should have atleast one character of: lowercase alphabet letters, numbers, special characters and uppercase alphabet letters.

Do not duplicate your username, real name.

b.It is essential for the company to have workable backup strategy for data because their data is not secure and anyone can steal it.

c. The company should have:

Privacy

Authentication of sender and recipient

Integrity and non-repudiation

Public and private key encryption

Digital certificate

3.

a. SPAM

b. No, she should not open these emails.

c.to avoid SPAM:

 Do not give your email address to unknown people.

Use the SPAM filter.

Delete SPAM mails without reading.

4.a. The condition of Srikant's brothers is called INFOMANIA.

b. Infomania condition can affect people to such an extent that adults waste their productive time in the office, neglecting their duties, whereas students waste their study time by frequently checking emails, etc.

5.

a. BACKUP

b. He can use CD,DVD,USB flash drive or external hard drive.

c. Data loss can occur because of file corruption, fire, theft, hard disk crash, etc. If we regularly make backup copies of files on our hard disk and keep them at a separate place, we can get the lost data back if anything happens to the original files on our computer.