The new grading system explained in Edexcel International IGCSE. watch the following video
Monday, 2 October 2017
Sunday, 25 September 2016
Lecture note on Programming for 8th graders
Dear Students,
Here I have attached the presentation related to the basic concept of programming.
Programming Concpt (Power Point)
Here I have attached the presentation related to the basic concept of programming.
Programming Concpt (Power Point)
Saturday, 17 September 2016
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
You can get the lecture file on system analysis and design from the following links
Black & White
Colour
Friday, 6 December 2013
Wednesday, 20 November 2013
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 :-)
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 :-)
Tuesday, 12 March 2013
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
Click Here to Download RAR File
Click Here to Download ZIP File
:-)
Wednesday, 2 January 2013
ICT Terminal Exam results
You can get your ICT Results from the following link
http://ahsance.blogspot.com/p/terminal-exam-results.html
http://ahsance.blogspot.com/p/terminal-exam-results.html
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
In the above worksheet we have two columns. In one column names are given and another column the amonts belongs to them are given.
A
|
B
| ||||
1
|
Sheuli
|
212
| |||
2
|
Sheuli
|
22
| |||
3
|
Shefali
|
5
| |||
4
|
Chameli
|
56
| |||
5
|
If we want to know the amounts belong to Sheuli, we can use a SUMIFfunction
Sunday, 9 December 2012
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
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))
=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 timethis 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))
Tuesday, 4 December 2012
using IF function in excel
=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
Wednesday, 13 June 2012
Best Books of 2012
Sunday, 27 May 2012
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....
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
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" />
<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.
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.
Saturday, 31 December 2011
Wednesday, 28 December 2011
Final result of the first term (2011-2012)
Hello all. so far I've completed check all of your exam papers and prepared the results as well. The final Result statistics are given here
Class 6A Boys
Class Average 89
Highest Mark in the class 100
Lowest Mark in the class 76
Class Average 89
Highest Mark in the class 100
Lowest Mark in the class 76
Adding two or more cells in excel
Sometimes you may need to add two or more cells together in excel. for example, you want to add name and 
surname of people from your table given below .
Now in column C, I want to get them together as a title of Name-Surname. the formula is =A1&A2. through this you will get result is ChompaChameli, SheuliShefali ... If you want to leave a space between name & surname this time you have to use the formula =A1&" "&A2 and you will get the result like Chompa Chameli, Sheuli Shefali......
you can see the result of using the formula for the given table here.
surname of people from your table given below .Now in column C, I want to get them together as a title of Name-Surname. the formula is =A1&A2. through this you will get result is ChompaChameli, SheuliShefali ... If you want to leave a space between name & surname this time you have to use the formula =A1&" "&A2 and you will get the result like Chompa Chameli, Sheuli Shefali......
you can see the result of using the formula for the given table here.
Monday, 26 December 2011
Terminal Exam result of class 6 - Boys
Hello All. We have take an exam out of 66 marks, here i have converted the numbers as out of 100. so if you want to get your original mark, just multiply by 0.66. I have taken average, highest mark and lowest mark for the both sections together.
Subscribe to:
Posts (Atom)