Cottonian Shield Seniors Finals -2013

Ever Loyal Old Boys

 

 

 

Junior Finals

 

 

School Captain and the Former Cricket Team Captain

 

Class 7 - Excel (revision)

 

1. To get the answer after adding the given numbers 

 

you could use

•  autosum
• =sum(E4:E6)
• =E4+E5+E6
• =sum(45,69,28)

Same way other functions can be used.
2. Difference between today( ) and now( )

3. The following are the different types of errors.

Find the reason for the above errors.



 4. Autosum

It is one of the widely used functions. If you have many numbers to add, don't bother to write the formula for addition, just select the range and select autosum button in the Home menu. Bingo...
If you want select non adjacent cells, press Ctrl key and select the cells you want.    

5. Cell Referencing
 By now   you must be knowing each cell has a unique address or a cell reference. The cell address is nothing but the column letter followed by the row number.

• Relative Reference

           This is the widely used reference. Here excel adjusts and changes the cell address for the new location , when you copy a formula.

    

In the above picture the values at cells A1 and A2 are added using sum function. If you copy the formula and paste it at c3, the cell address in the formula automatically changes to C1 and C2.

• Absolute Reference

      Sometimes we do not want the cell address to change, when we copy the formula. So we need to make it absolute cell reference.
This is done by adding a $ before the column letter and row number. To make C20 an absolute reference, introduce a $ symbol. Then it will be $C$20.

The second answer should be 900 if I copy the formula in cell A3 and paste in C3. But there is a twist in the story, I do not want the second value to change, so I introduce $ symbol in the second cell address making it fixed. 

 

• Mixed Reference

       In mixed reference either the column or the row remain fixed. So the formula would be $L2 or L$2.

In $F46 , the row number is allowed to change not the column.

In E$70, the column is allowed to change not the row.

 

 

 

Class 7 -MS Excel

Functions :
One of the useful things in excel is built in functions. we just need to select our data and enter the function.. simple.

Each function contains two parts namely

• Function name
• Arguments

e.g :

=sum(A1:A10)
here sum is the function name and A1 : A10 the argument.

1. SUM ( )
It adds all the numbers in the given range. Both the formula and function should start with an equal symbol.

• =Sum(C5 : C25)
• = Sum(12,34,97)
• =Sum(A1,250)

All the above methods are valid.

2. PRODUCT ( )
It multiplies all the numbers in the given range.

=Product(C5 : C25)

= Product(12,31)

=Product(G11,250)

3.AVERAGE( )
It finds the average of the given numbers in the range.

• =Average(C5 : C25)
• = Average(122,31,56,78,40)

4. MAX( )
It finds the maximum number in the given range

5. MIN( )
It finds the minimum number in the given range

6.NOW( )
Displays the current date and time. There is no argument here.
7.TODAY( )
Displays the current date.

Class 6 - Macromedia Flash

We are going to learn Animation. yes real animation. You don't have to be an artist, just little bit of creativity and lots of interest are enough.  Its going to be exciting . So first the basics......

The intersecting horizontal and vertical lines on the stage is called a Grid. If you select show grid your stage will look like this

 

Tool Box

Toolbox  is divided into 4 sections.

•  Tools : It contains basic drawing and editing tools.

• View : Hand tool and zoom tool help the user to view the stage clearly.

 

Hand tool moves the stage , zoom tool enlarges the stage.



 



• Colors : The border color and fill color can be selected from this section.

• Options : It contains the modifiers. They are used to change the properties of the selected tool.
• Property inspector : The height, width, color etc can be changed here.
• Timeline : It is used to set the timing of the animation. Has two parts namely Frames and Layers.
  

  

  
  

 

 

 

 

Class 6 - Binary to Decimal

 Number System

 

1. Binary Number System

Only 0 and 1 are allowed in binary number system. So the base is 2(only two numbers)

e.g:

 (101)₂

2. Decimal Number System

0,1,2......9 are allowed in decimal number system. So the base is 10( 0 to 9,totally 10 numbers)
e.g:
(25)₁₀

The base is written along with the number to identify the number system.
Conversion from binary to decimal :
2⁰=1
2¹=2
2²=4 (2 x 2)
2³=8(2 x 2x 2)
2⁴=16(2 x 2x 2 x 2)
 and so on.......

 

2. (110)₂

1   1   0

 = 1 x 2 ² + 1 x 2 ¹+ 0 x 2 ⁰ 

 = 4 + 2 + 0
= 6

Answer = (6) ₁₀

3. (111)₂
 = 1 x 2 ² + 1 x   2 ¹   + 1 x   2 ⁰
= 4 + 2+ 1
= 7

4. (1011)₂
=1 x   2 ³  + 0 x 2 ² + 1 x   2 ¹   + 1 x   2 ⁰

= 8+0 + 2+ 1
= 11

5. (1101)₂
=1 x   2 ³  + 1 x 2 ² + 0 x   2 ¹   + 1 x   2 ⁰

= 8+4 + 0+ 1
= 13

Conversion from decimal to binary

This involves repeated division of the quotient by two, the remainder forms the part of the answer.
1. (4)₁₀

4 / 2 = 2  remainder = 0
2/2 = 1    remainder = 0

You cannot divide 1 by 2, so stop now. Therefore the answer is
=(100)₂

2. (7)₁₀

7 / 2 = 3 remainder = 1
3 / 2 = 1 remainder = 1

= (111)₂


3. (13)₁₀

13 / 2 = 6 remainder = 1
6 / 2 = 3   remainder = 0
3 / 2 = 1   remainder = 1
= (1101)₂

Cottonian Shield - Juniors

 26th July 2013, a memorable one for me as a class teacher. Because not every day you would see 4 of your own playing for the school team and part of the Cottonian shield finals.

The team played extremely well in the league phase, but couldn't win the finals. Neverthless it was a very good match.



Class X - Assignment I

1. Using if else statement write a program in Java to calculate the grade as per the given criteria:
      % of marks                                                     Grade
       75 - 100                                             passed with star
       60 - 74                                               1st division
       40 - 59                                               2nd division
       Less than 40                                      Failed
2. Write a program to find the sum of the series:

3. Write a program to input a number n, output the results of the following evaluation based on the number entered by the user.

• Absolute value of the number
• Square root of the number
• Power of the number

4. Write a program to input a character and check if it is a vowel. If not print an appropriate message. Use switch case statement.
5. Write a program to input the number of days for issuing the library book. Calculate the charges according to the following criteria.
            Days                                            Charges
            < 5                                                 Re. 1.00
            5 and <8                                        Rs. 2.00
            8 and above                                   Rs. 3.50
  The program should work for n people.
6. Using an overloaded function add () , write a program to take an int array argument and find sum of all the elements. When a second argument ' O ' or ' E ' is passed with the int array, the program should return the sum of the odd numbers or even numbers respectively. If any other character is passed as the second argument, the function will return 0.
7. Write a program to accept two strings. Display the new string by taking each character of the first string from left to right and of the second string from right to left. The letters should be taken alternatively from each string. Assume that the length of both the strings are same.
eg :
First string       :  HISTORY
Second String  :  SCIENCE

New String   : HEICSNTEOIRCYS
8. Write a program to enter a string , display the

• Total number of two letter words
• Total number of three letter words
• Total number of four letter words

eg :
Sample Input     :  He that is down needs fear no fall
Sample Output  :
                 Number of two letter words = 3
                 Number of three letter words = 0
                 Number of four letter words = 4
9. Kesar Travels Pvt Ltd gives the following discount to its customers.
          Ticket amount in Rs.                     Discount
          Above 70000                                     18%
          55001 to 70000                                  16%
          35001 to 55000                                  12%
          25001 to 35000                                  10%
        Less than 25001                                   2%
10. Write a program to input the name and ticket amount for the customers and calculate the discount amount and the net amount to be paid. Display the output in the following format for each customer. The program should work as long as the user wishes to do so.
Sl. No        Ticket chargers               Discount             Net amount

11. The annual examination results of 50 students in a class is tabulated
         Roll no             Subject A    Subject B    Subject C
Write a program to read the data into different arrays, calculate and display the following :

• average mark obtained by each student
• print the roll number of the students whose average marks is above 85.
• print the roll number of the students whose average marks is below 45.