Lecture note on system analysis and design

Dear Students,

You can get the lecture file on system analysis and design from the following links

Black & White
Colour

Assignment for 8th Graders

Hello Girls,
you can get the assignment from here

Sample Report Card for 7th Graders

Dear Students,
Here is the link for the report card you are going to prepare. This report card done only for 6 subjects and you have to add at least 4 more subjects to it.
to get it click here

Best of luck :-)

Solution of Activity 2 of 2011 IGCSE Exam

Hello.

As we are trying to solve the problem related with the Spread sheet.

surely some of you have already did without any mistakes. Even I am sending you the full solution with the question paper. 

see the solutions and correct your one.
Click Here to Download RAR File
Click Here to Download ZIP File

:-)

ICT Terminal Exam results

You can get your ICT Results from the following link
http://ahsance.blogspot.com/p/terminal-exam-results.html

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.