CLASS_IX_CHAPTER- 11_ ANSWER

CHAPTER - 11 ANSWER

A. Tick (3) the correct answer.

a. (ii) Plagiarism

b. (iv) All of these

c. (ii) Self Plagiarism

d. (iii) Both (i) and (ii)

e. (i) Author’s collection of books

f. (iv) Privacy

g. (ii) Piracy

h. (iii) System analyst

B. Answer the following as True or False.

a. True

b. False

c. False

d. True

e. False

f. False

g. True

C. Fill in the Blanks:

a. Ghost writing

b. Potluck paper

c. Degree

d. Privacy

e. Copyrights

f. Industrial Property

g. 70

D. Very short answer type questions.

a. Plagiarism means stealing the ideas, thoughts or writings of some other person and using them by one’s own

name without the knowledge of actual writer or author.

b. The two types of plagiarism are: Ghost writing and Photocopying.

c. Using one’s own work in other format is called self plagiarism.

d. Privacy is the right of an individual to keep its information secret from others and revealing it only on the selective

basis.

e. Data Privacy can be defined as the relationship between the collection and sharing of data about one self.

f. Intellectual property can be categorised as:

● Industrial Property

● Copyrights

E. Short answer type questions.

a. Online plagiarism refers to downloading and using information from the online resources like World Wide Web.

b. Different types of plagiarism are:

Ghost writing: It refers to copying the entire work of someone else.

Photocopying: Using most of information from other sources along with some own work.

Potluck paper: Using information from different sources with little modifications.

Self plagiarism: In this a writer uses his own work to present it in a new format.

c. Different ways to plagiarism are:

● Acknowledging the source of information used.

● By taking prior permission from the actual writer.

● By reframing the contents in one’s own words.

● By enclosing such contents in quotations.

d. Difference between Data privacy and Personal privacy are:

Personal privacy refers to one’s personal information which includes the information about one’s location, health

or financial transactions. Whereas Data Privacy deals with as the relationship between the collection and sharing

of data about one self.

e. Copyright is the right of an author on his creative work or an artist on his artwork which protects them from its

unauthorized recreation or reproduction.

Subjects covered under the copyright includes are books, films, musical creations, computer software, electronic

data, drawings or sculptures and architectural designs.

f. Database Administrator (DBA) controls the database operations of an organization. His responsibilities include the

designing, implementation, modification and maintenance of the company’s database and to grant accessibility

rights to the various users.

g. ICT refers to the technology that provides access to the information through high speed communication like

Internet wireless network, cell phone and others.

The various benefits of ICT:

Education: Education has not been just restricted to classroom but one can learn anything and anywhere .

Health: Quality of healthcare system is improved a lot.

Governance: Government services are improved with the introduction of e-governance.

Virtual Schools: School which are using online services to provide education to the learners.

Economy: The world has termed to a global economy.

F. Long answer type questions.

a. Plagiarism can be of different types depending upon how the information is copied and used.

Ghost Writing: If someone copies the entire work of some other writer word by word without quoting the name

of original writer and uses it by one’s own name then such type of plagiarism is called ghost writing.

Photocopying: Sometimes a writer uses quite a good amount of information from some other source along

with his own work and that too without making any changes in it. This is called photocopying.

Potluck Paper: When a writer uses information from different sources and with few changes present it as its

own work, it is called potluck paper.

Self Plagiarism: In another type of plagiarism a writer uses his own previous work to present it in a new format

is called self plagiarism.

How to Avoid Plagiarism

Plagiarism can be avoided by keeping in mind certain points while using information from any other source like:

Acknowledging the Sources: If you want to use some information from a book or some website in your

work, always acknowledge the source along with such information from where it is taken.

Take Permission from the Author: If possible, take the written permission from the author of original work

for using his contents in your own work.

Read and Reframe: Do not just use the contents as it is from the source, but read from the various sources

and put them in your own words.

Use Quotations: Put everything that comes from some other source within quotes. This is also one of the ways

of avoiding plagiarism.

b. The steps required to be taken to protect such information from unauthorized access or damage are:

● Always use an upto-date antivirus software in your system to protect the information from virus attacks.

● Never disclose the confidential information like passwords or account numbers to any website or email.

● Always use password protection for the important information in the system.

● Keep the backup copy of the data sent to receiver it in case of some accidental damage.

● Encode your confidential information before sending it through emails or some other means.

c. The writer of second paragraph has used Potluck paper type plagiarism to create the writeup. To avoid such

situation he would have taken the prior permission from the original writer or he should have acknowledged the

source.

G. Application oriented questions.

a. She can use the web resources to create her project report and to avoid the situation of plagiarism. She can quote

the website name from where she is collecting the information.

b. Before starting the production, its better to get the product formulations patented so that it should not be used by

the other competitors.

c. Adding New Content

d. Web developer

Societal

CLASS_IX_CHAPTER- 10

CHAPTER - 10 ANSWER

A. Tick (3) the correct answer.

a. (ii) Spreadsheet

b. (iv) Worksheet

c. (i) Active cell

d. (iii) 3

e. (iii) Formula bar

f. (i) Left

g. (i) Ctrl

h. (i) F8

i. (iv) All of these

j. (iii) = sign

k. (ii) MIN( )

l. (i) Mixed reference

m. (iv) Area chart

B. Answer the following as True or False.

a. True

b. False

c. False

d. True

e. False

f. False

g. True

h. True

i. True

j. False

k. True

l. True

m. False

n. False

C. Fill in the Blanks:

a. Rows, Columns

b. Cell

c. Spreadsheet

d. Cell address

e. Right

f. 1,048,576 , 16,384

g. 8.43, 15

h. Function

i. Values, Cell address, Cell range

j. Chart

k. Embedded Chart

l. Legends

D. Very short answer type questions.

a. Microsoft Excel 2010 is used to organise, analyse and manipulate data electronically in the tabular form.

b. There are 3 sheets are there by default in a workbook.

c. The extension of files saved in Excel is .xlsx.

d. There are 1,048,576 rows and 16,384 columns in it.

e. Active Cell is the one which is pointed by the cell pointer to store, manipulate or format data in that cell.

f. We select the complete row by clicking in the row header to be selected.

g. The different cell addressing modes used in a formula are: Relative Reference, Absolute reference and Mixed

Reference.

h. The different types of data values can be entered in the Excel Worksheet are: Number, Text and Formula.

i. Pie chart represents only single data series.

j. ^ Exponent ,/ Division ,* Multiplication ,+ Addition ,– Subtraction arithmetic operators can be used for creating

formulas in a spreadsheet.

E. Short answer type questions.

a. An electronic spreadsheet allows storing large amount of data in a single worksheet. The data entered can be

easily manipulated or formatted as per need. It allows automatic calculations and to quickly convert the numeric

data into the graphical form called chart.

b. Workbook is a collection of multiple worksheets. Excel workbook is saved with the extension .xlsx. By default it

contains three worksheets with the default names as Sheet1, Sheet2 and Sheet3.

Worksheet is like an individual page of a workbook made up of cells formed by the intersection of rows and

columns. A single worksheet in Excel contains 1,048,576 rows and 16,384 columns in it.

c. A range is rectangular block of contiguous cells used to perform common operations on multiple cells. Multiple

non- contiguous ranges in a worksheet can be selected using Ctrl key without deselecting the previously selected

ranges.

d. AutoFill handle presents at the bottom right corner of the active cell or range is used to fill automatic series of

number or text in the consecutive cells across the rows or column.

e. The Different number formatting options available in Excel are:

Number: To display general format of number.

Currency: To show values in currency format.

Accounting: To line up the currency symbols and decimal points.

Date: To display date serial numbers as data value.

Time: To display time serial numbers as data value.

Percentage: Multiply the cell value with 100 and show % sign.

Fraction: To show fractional values.

Scientific: To show more precise fractions.

f. Formula is a mathematical expression made up of operators and operands which is used to perform calculating

e.g., =(4+5)*2 whereas Functions are the predefined formulas used to perform complex calculations on the

supplied arguments e.g., =SUM(4,5,6).

g. Making use of cell address in a formula to refer the value stored in that cell is called cell referencing.

There are three ways to refer the cell address in the formula. These are:

Relative Reference: This type of referencing causes the change in cell address used in the formula with

respect to the change in position of the formula when copied. e.g.,=A1:A2

Absolute Reference: In this, the cell address in the formula remains fixed irrespective of its change in position

when copied. e.g., =$A$1+$A$2

Mixed Reference: In this, the change in cell address is restricted to either row or column only when copied.

=A$1+$A2.

h. Charts are the graphical representation of data values stored in the worksheet. These are mainly used to quickly

analyse the data values by representing it in different formats. Some of the commonly used charts in Calc are:

Column chart, Bar chart, Pie chart, Line chart, Area chart, Scattered chart, etc.

i. (i) Line Chart: A Line Chart represents the changing trends of the data over the time at equal intervals.

Area Chart: Area Chart is also used to emphasise the magnitude of change in data over a period of time.

But in this each data series is plotted to show the relationship of a part to the whole.

(ii) Pie Chart: Unlike the other chart types, Pie Chart is used to plot just one data series to represent the

proportional size of one item to the sum of the items in the series. Each item is represented by one slice or

pie of the whole chart.

Doughnut Chart: Doughnut Chart is used to represent the relationship of a part to the whole. But unlike

pie chart, doughnut chart can represent more than one data series where in each series is plotted in the form

of concentric circles.

j. To Change the Data series:

● Click on the Chart to select it.

● Choose Select Data ( ) option in the Data group under the Design tab, to open Select Data

Source dialog box.

● Click on collapse button in the Chart data range box which is showing the current data range.

● Select the changed data values to be plotted.

● Expand the dialog box clicking the expand button and click OK button.

k. To Select the Entire Worksheet:

● Press Ctrl + A keyboard shortcut.

Or

● Click the Select All button at the intersection area of row and column header.

F. Long answer type questions.

a. (i) (a) =(B2+C2)*0.25

(ii) =(B2+C2+D2)-E2

(iii) =MAX (F2:F8)

(iv) =COUNT(B2:B8)

(v) IF(A1>75000,”not eligible for bonus “,” bonus “)and then copy this command to all cells.

(vi) Autofill feature

(vii) Bar chart

(viii) No, he need not to do the calculations again as the relative reference is used in all the formulas created in

the worksheet.

b. The basic components of electronic spreadsheet are:

Workbook: A basic Excel file, contains multiple worksheet in it.

Worksheet: Individual page of a workbook made with the intersection of rows and columns.

Rows: Horizontal sections of a worksheet used to store record values.

Columns: Vertical sections of worksheet used to store field values of the worksheet.

Cell: A small rectangular block formed by the intersection of row and column. These are used to store worksheet

data values.

Cell Pointer: Highlighted cell boundary which appears on currently active cell and is used to modify or format

the cell value.

c. To Rename a Worksheet:

● On the sheet tab area, right click on the sheet name you want to rename and choose Rename option from

the shortcut menu.

● Select the current name and then type the new name. Press Enter Key.

To Add a New Worksheet in the Workbook:

● Click and select the sheet using sheet tab before which you want to insert new sheet.

● Right click on it and choose Insert option from the shortcut menu. Insert dialog box will appear as shown in

figure.

● From the General tab in the dialog box, select Worksheet icon and click OK button to get a new blank

worksheet in the workbook.

To Delete a Sheet:

● Select the worksheet(s) to be deleted.

● On the Home tab in the Cells group, click Delete ( ) drop button and choose Delete Sheet option in it.

d. To fill standard data series in the Excel worksheet:

Using Autofill Handle: Enter the first two values of the series in two consecutive cells along the row or

column. Select these two cells to form a range. Click and hold Auto Fill handle drag across the row/column along

which series is to be filled. Release the mouse button when you reach to last number of the series.

Using Series Command: Select the range of empty cells along which you want to fill the series.

Home Editing Fill Series option.

● Enter the first value of the series in the first cell and select the range to be filled.

● On the Home tab in the Editing group click Fill ( ) and then click Series option in it. A Series dialog

box will appear.

● Under Type, click one of the option:

■ Linear: Series created by adding the values.

■ Growth: Series created by multiplying the values.

■ Date: To create series of date values.

■ AutoFill: Creating series like using fill handle.

● Enter the Step Value by which the series values are to be changed and the last value in the Stop Value

box. Click OK button.

● The range will be filled with the required series.

e. To insert functions in the Excel 2010 worksheet you can make use of function wizard as follows:

● Select the cell in the worksheet where function results are to be displayed.

● Click the Insert Function ( ) option on the Formulas tab.

Or

● Click Insert Function ( ) button on the Formula bar.

Or

● Press Shift + F3 keyboard shortcut.

● Insert Function dialog box will appear as shown in figure.

● Select the function category from the Select a category drop list. Function from the selected category will

appear in the Select a function list box.

● Click and select the function to be used from the list.

● Click OK button. Functions Arguments dialog box appear on the screen.

● Click in the argument box named Number1 and use collapse ( ) button to the right of it, if you want to

select argument list from the worksheet.

● Select the desired data range in the worksheet on which the function is to be performed. The selected range

will appear in the argument box. You can add more arguments if needed.

● Once finished with the arguments selection, press Enter key or click OK button. The result will appear in the

destination cell.

f. To create a Chart in Excel Worksheet:

● Select the data in the worksheet, to be plotted including the column headers.

● Click on Insert tab and in the Charts group click the specific chart category drop button and choose the

required chart from the expanded list.

● The chart plotted with the selected values will appear on the worksheet in default settings.

g. (i) 44 (ii) –40

(iii) =$B$3+D3 (iv) =$B3+D3

(v) =$B4+D$3

G. Application oriented questions.

a. (i) =SUM(C2:G2) (ii) =($H$1)*100

(iii) =AVERAGE(C3:C6) (iv) AutoFill feature

b. (i) Chart title- Quarter wise sales analysis

X-axis title- Region

Y-axis title –Sales(amount)

(ii) Bar chart (iii) Consistent

(iv) South (v) North

IX&VIII_CLASS_PROJECT SUBMIT_DETAILS

IX_PROJECTS

Class-VIII PROJECT

17/02/2019-Recently update

List of students who submit their project.

Class IX project

Topic :- Physical features of India 

• Create a presentation on this topic in MS PowerPoint.
• Submit hardcopy and softcopy on date 31/01/2019.
• You can send your project on this E-mail computerconcept60@gmail.com 

Code_402_handbook for IX student

https://drive.google.com/file/d/1cpdMZL7XZ78r-QYzvtgom3t7nDw1UMp1/view?usp=drivesdk

Class_IX_Term_1_Solved_Ques_Ans

• Class IX term 1 question link :https://drive.google.com/open?id=0B8Tbry5Qc3w9eEZaYTVjZ2llbkxVMkdOeng3TzVTZ1BxbjZF

• Class IX Term 1 Solved Ans :https://drive.google.com/open?id=0B8Tbry5Qc3w9V3N2UjNhQUc0cUttajFBREh2Tm1CMFM4RnJj

Class IX chapter 5

IX chapter-5

E. Short answer type questions.

            a. The main components of Word Window are:

● Title Bar: Title bar is displayed at the top of Word 2010 Window which shows the name of application i.e., Microsoft Word along with the name of the currently active document. The default name of Word document is Document1.

● File Tab: This tab appears at the top left corner of Word window which gives access to the various file-related operations like opening a new or an existing document, saving or printing the currently opened document, etc.

● Quick Access Toolbar:-This toolbar is present on the left side of title bar near the office button which contains the tool buttons to perform common operations like save, undo and redo.

● Ribbon: The toolbars and menus present in the previous versions of Microsoft Word have been replaced by Ribbon in Microsoft Word 2010, which is made up of Tabs and Groups. Each tab has a set of commands present in the shape of tool buttons. These buttons are then further categorized under various groups.

● Rulers: Word has a horizontal and a vertical ruler present across the top and left side of the document respectively, which tells the width and height of the page. It also shows the margins, indents or tab positions.

● Document Area: This is the largest area in Word window where the text is entered for processing. It has a blinking line at its top left margin, called cursor which is the insertion point from where the text entry starts on the page.

● Scroll Bars: The two scroll bars in the window help to navigate in a large-sized document. The horizontal scrollbar is helpful while moving from left to right and vertical scroll bar to move from top to bottom.

● Status Bar: This bar is located at the bottom that displays the information like current page number, the template in use, zoom percentage, overtype mode, selection mode, etc.

            b. To open a new blank document in Word:

● Click the File tab.

● Select New option from the first column of the backstage view.

● A New Document dialog box will appear as shown in the figure.

● Select the Blank Document option from the Blank and Recent Section.

● Click on the Create button.

c.  Find & Replace option is used to search specific text in the document and if needed it can be replaced with the new text using this option.

d.   Character formatting helps to emphasise the text to improve its readability and appearance. To change the font style of the existing text select Font group select the required font style.

e.   Copying means repeating the selected text at the new location without removing it from the original location, whereas moving means shifting the existing text to the new location.

f.    Headers and Footers are the standard information which appear at the top or at the bottom of each page in the document. To add them in the Word document use Header or Footer options in the Insert tab.     
g. To change the line spacing of the paragraph text:

● Select the paragraph whose spacing is to be changed.

● Open Paragraph dialog box by clicking the dialog box launcher at the lower right corner of  Paragraph group.

● Open Paragraph dialog box.

● Under the Spacing section on the Indents and Spacing tab choose the required line spacing from the drop box as needed.

            h. The difference between bulleted and numbered list are:

● In the numbered list, each item is marked with a unique number or alphabet whereas in the bulleted list each item is marked with the same symbol.

● In      the      numbered      list,      each   item     appears          at         a          specific         position          in         the      list       whereas         in         bulleted          list         there   is         no       specific          order   of         the      items   in         the      list.

            i. Page margins are the space between the page boundary and the text entered in it.

             To change margins in the Word document:

● Click            Page   Layout             Page Setup  Margins option.

● Select          the      margins          from    the      drop    down  list.

 j. Symbols option in Word is used to insert special symbols in the document which are not available on the keyboard.

             To insert the required symbols in your document:

● Select          the      Insert  tab       and     click    Symbol (  ) drop option on the Symbols group.

● Some           standard        symbols         will      appear            in         the      drop    list.         Click   the      one     you     want   to         use     and     the      selected         symbol           will      appear at the insertion point.

● If       you     want   to         use     some  other   special           symbols         which are         not      there   in         the      list,      click    More Symbols option in the drop list to open Symbol         dialog box      as        shown            in         figure.

● Choose       the      required         symbol           or         special           character       to         be        inserted          and     click    Insert button.

            F. Long answer type questions.

a.   (i) Left   (ii) Superscript

(iii) Bold,         centered,       underlined,   Font    color,  size

(iv) Find and replace

(v)  Numbered list

b.   Text editors are used to create unformatted text document i.e., a text editor does not provide the features like page settings, character formatting, etc. So it is mainly used for creating source code of the program whereas a word processing application provides many powerful features and tools for creating , editing and formatting sophisticated text documents like letters, reports, books, etc.

c.   Advantages of using word processing application over the traditional documentation system.

             Speed: Documentation is easier and quicker in word processing applications.

             Easy to Edit: Document editing is easier in word processing applications.

                   Character Formatting: This feature allows character formatting features to give attractive look to the document.

             Graphical Support: using this application, graphics can also be inserted in the text document.

  Storage: Document can be stored permanently into the storage device for later use and printed multiple times.

  Object-Linking and Embedding (OLE): This feature allows to add objects like a video clip, audio, chart, image, etc in the document.

  Useful Tools: There are many built-in tools like spelling and grammar checker, mail merge, print preview which are helpful in doing specialised job for correcting spelling or grammatical errors, viewing the document before printing or generating multiple individual letters using mail merge.

d.   The text editing features available in Word Processor are:

● Copying:     Using this      feature           the      text      entered          in         the      document         can     be        copied            to         different         locations        without           affecting the original text.

● Moving: This feature allows to move the selected text from one place to another.

● Find and Replace:            This    is         one     of         the      powerful        text      editing         features         which helps  to         search            specific          text      in         the         document and if needed it can be replaced quickly with new text.

● Undo and Redo:   Using these  editing            features         the      wrong actions           can         be        undone          easily  and     if          an       undone          action needed can be repeated again.

e.   Various character formatting tools are:

● Font Type:  Using this      tool      we       can     easily  change          the      font     face.

● Font Size: Size tool can be used to change the text size.

● Special formatting tools:  Three  special           formats           i.e.,      Bold,   Italics  and         Underline      can     also     be        applied           on       the      selected text.

● Aligning tools: Text alignment tools can be used to change the current text alignment as Left, right , center and      justified.

● Text color: This tool helps to change the colour of selected text.

f.    Page formatting help to change the page settings. The various page setting options are:

● Page Size: To select the proper page size on which the hard output is to be obtained. You can also select customized size by specifying height and width of the paper.

4

● Page orientation: the two types of orientations i.e., Portrait and Landscape are used to print height-wise or width-wise.

● Margins: Margins settings can be changed to set left, right, top or bottom margins.        g. (i) Add bold effect to the line title i.e., sub.

(ii)  By selecting        the      letter   body   text      and     clicking          Justify tool      button on      the      Paragraph group.

(iii) Click Home  Paragraph  Paragraph dialog box option to open paragraph dialog box and in it, using Line Spacing section on the Indents and Spacing tab.

(iv) Select       both    the      paragraphs    and     on       the      Indent and     spacing          tab      in         the      Paragraph     dialog box,     by        adding            first      line      indentation.

 G. Application oriented questions.

a.   Computerized

● Text can be edited and formatted as needed.

● Hard copy can be produced multiple times.

● New documents can be created using an existing document.

● Errors like spellings and grammar errors can be corrected easily.

● Supported by graphics.

             Manual

● The document can be printed directly. No need of printer.

● No    need   to         learn   the      use     of         any     computer       applications.

● Cost effective.

● No    storage           of         the      document.

● Graphical    objects            cannot            be        used.

                        Based on       the      above points,            we       can     easily  conclude       that      computerized            word   processing    is         much  more   beneficial      over the manual documentation.

b.   Rayan can use Header/Footer option in the Header & Footer group in the Insert tab to add such information which will automatically repeated on each page of the document.

c.   Mr. Sharma          can     use     Bullets            and     Numbering    feature           to         create a       bulleted          list       of         ingredients    which automatically arrange the items in an orderly manner.

d.  She can use Symbol option in the Insert tab which provides a set of characters that are not available on the keyboard.

e.   Mr Dhar can use subscript formatting feature of Word to show these characters below the normal baseline.

f.    Kunal can use Ctrl+U keyboard shortcut to underline the text.

g.   Equation of Symbols group in the Insert tab.

h.   Landscape