Kamrul Ahsan: 2012

Tuesday 11 December 2012

Using SUMIF function in excel

The SUMIF Function takes 3 parameters

1. range: from where you are going to set your criteria

2. criteria: which elements you want to add/ what you want to add

3. sum_range: the numbers need for calculation


	A	B

1	Sheuli	212

2	Sheuli	22

3	Shefali	5

4	Chameli	56

5

In the above worksheet we have two columns. In one column names are given and another column the amonts belongs to them are given.

If we want to know the amounts belong to Sheuli, we can use a SUMIFfunction

New ITHS blog launched

Hello All. A new blog for International Turkish Hope School Senior Section (Boys') has launched. The previous blog for GCSE and A level (iths9to12.blogspot) also merged with this blog.

the link here

http://ithsseniorsectionboys.blogspot.com/

Using VLOOKUP function with IF function

Last time we were discussing about complex or nested if function by which we calculated the grades of students. now we can useVLOOKUP function in place of nested if with the grades.

Just use like this
=IF(logical_test,"TRUE",VLOOKUP(lookupvalue,table_array,column_index_no,range_lookup))

by this you can reduce complexity of the previous function we used last time
this time we can use a table like (M1:N7) here with the reference of the grades.
and the function will be like the following

=IF(OR(AND(B2<50,COUNT(B2)=1),AND(C2<50,COUNT(C2)=1),AND(D2<50,COUNT(D2)=1)),"F",VLOOKUP(E2,M1:N7,2,TRUE))

using IF function in excel

The IF function in Excel take three parameters. here is the general form of the function.
=IF(logical_test, value_if_true, value_if_false)
Now we are going to take an example to solve the function along with other functions if necessary

Here we have taken some students marks and you can see their average. If I want to specify the students who passed or who failed by considering their average we can set if function like this

Best Books of 2012

Hello. Its a great pleasure that my students have prepared nice books based on some topics related with their subjects they are studying in school. From all of the books I have selected three books are the best books of this year. They really did it with full of care. I will introduce the authors and their books introductions here.

ITHS Computer Club

Hello All,
Long time I couldn't get time to write to my blog. In girls' section we have started a computer club. whatever we are doing in this club, you can get all the things through the club blog site
http://ithsgscompclub.blogspot.com/

If you are interested, you can have a look....

Tuesday 14 February 2012

HTML tips

Simple html codes for a web page

<html>

<title> Welcome to My Site </title>

<table>

           <tr>
             <td> LOGO
            </td>

<td>

Welcome, Guest.

</td>

</tr>

</table>

</html>

You can see the view of the website like this

html- start and end tag for html code
title- web page title tag
table - table tag
tr- row tag
td - column(table data) tag.

whetever you are going to write inside the page it should come inside td tags. all the starting with <tag name> and end with </tag name>.

Inserting a picture: to insert picture inside a column the command is <img src=" the source and image names with their extensions" alt="when you want to see the definition of a picture at the time mouse over the picture" />

Tuesday 24 January 2012

Basic of Internet Technology

Internet is a network of networks where millions of compters are connected. To understand about the internet technology we should know the following terminologies
1. Network : A network is a group of two or more computer systems linked together.
Some important network types
i. local-area networks (LANs) : The computers are geographically close together (that is, in the same building).
ii. wide-area networks (WANs) : The computers are farther apart and are connected by telephone lines or radio waves.
iii. campus-area networks (CANs): The computers are within a limited geographic area, such as a campus or military base.
iv.metropolitan-area networks MANs): A data network designed for a town or city.
v.home-area networks (HANs): A network contained within a user's home that connects a person's digital devices.
2. Internet Service Provider(ISP): ISP is the company that provide access to the internet.

Kamrul Ahsan