Class IX

Wednesday 28 December 2016

Winter Vacation HHW (FA4 Activity)

Dear Students

For your winter vacations, we have got some interesting home work for you.

Topic : Internet Security

Class IX: Make an App or Game or a video on the above topic on any platform.
You can use the website https://www.appsgeyser.com/. Its really easy and interesting to make it on them or make a game in Kudo or Minecraft. Upload your game or app online so that the link can be accessed by the teacher.


Class X: Make a website of atleast 3 pages interlinked on the above topic. HTML has to be used.
Your own creativity will be accessed.

Both IX and X can perform the above task individually or in groups. The group capacity cannot exceed 4 wherein each group member needs to justify their part in the work submitted.

This activity will be accessed for your FA4  activity as well.

Have a great time. Work a little. Find out new interesting technologies and surprise your classmates and teachers later.

For any queries, drop in a mail at aakanksha.kochhar@gmail.com

Keep coming back for new things posted on the blog. Be a regular visitor so you don't miss out on anything.


Happy New Year !!




Wednesday 21 December 2016

Sunday 27 November 2016

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>