Computers & ICT: Post your doubts here!

[aloha]

hey can anyone show me how to make the graph in specimen paper 2008.........plz .............i am stuck there..........

 

[Xenon]

hey can anyone show me how to make the graph in specimen paper 2008.........plz .............i am stuck there..........

wait a bit... solution is on its way

 

[aloha]

thank u so much!!!!!!!!

 

[Raiyan3]

Hey guys i will be doing AICT practicals in a few days..almost done with the past papers
But i would like to know if u guys tell any functions that are helpful and should know them..like i was new to the HLOOKUP function then i understood it.. Any information would be helpful ! and is it fine if we do the pastpapers from 2008-2011

 

[Raiyan3]

Can anyone help me with point number #13 .. i need the explanation helpp !!!(you can directly start with point #13 no need to start from the beginning) And here's the supporting files of AS AICT November 2011 with the question paper.

 

[Kernel95]

Can anyone help me with point number #13 .. i need the explanation helpp !!!(you can directly start with point #13 no need to start from the beginning) And here's the supporting files of AS AICT November 2011 with the question paper.

This one works at least Simple complicated IF formula

So in cell E4 you enter the formula

=IF((F3+H3) > 59, E3 + G3 + 1, E3 + G3)

and in cell F4 you enter

=IF((F3 + H3) > 59, F3 + H3 - 60, F3 + H3)

(See if all of the columns & rows match and if not, I believe you can see what you need to change


ps. For some reason I couldn't manage question 9 :/ could you send a screenshot of the table & formulae. Thanks

 

[Raiyan3]

There you go..its pretty hard thoughh..honestly 2011 has all new formulas and format !!

 

[Kernel95]

uhm... what do you mean with "new formulas"... I hope I can do everything using the 2003 version since my school doesnt even have 2007 even installed!

 

[Raiyan3]

By new formulas i meant that was the formulas used in session 2011 werent the same as the old sessions. Like for example Value(well i used value in some other session but cant remember) and the HLOOKUP function

 

[Xenon]

hey can anyone show me how to make the graph in specimen paper 2008.........plz .............i am stuck there..........

check the word document... I've shown here how to create the graph in access
alternatively you can do it in excel.... for that you'll need to export the query performed in excel... you might also be required to create a new table using countif and sumifs (if you are not sure how to create the organize the in excel, see the document forum graph(may2008))

hope it solves your problem

 

[aloha]

check the word document... I've shown here how to create the graph in access
alternatively you can do it in excel.... for that you'll need to export the query performed in excel... you might also be required to create a new table using countif and sumifs (if you are not sure how to create the organize the in excel, see the document forum graph(may2008))

hope it solves your problem

thank u so much!!!!!!!!!! BTW how did you know which table to use.........and the fields required???? and the graph shown in the markscheme is kinda different..................

 

[Daniel WInston]

Xenon, do you have/know any relevant websites or ebooks containing the materials/tutorial/guidance for Applied ICT 9713? Thanks..

 

[Student12]

Anyone has AICT october/ november 2011 paper 1 ?

 

[aloha]

Anyone has AICT october/ november 2011 paper 1 ?

 

[Raiyan3]

I have a doubt in this question paper that i have attached, i checked through the marking scheme but still didn't understand.

How do we do this question :
Q8) Add to this extract a new field called Days which is calculated at run time. This must calculate
the number of whole days for each of these holidays.

-About the last question which is question number 30.
Do we have to use the internet to search ? and can anyone give some ideas how such kind of questions can be done ?

HELP I HAVE MY EXAM ON SUNDAY !!! :O:

Hey man i know ur question is solved but i wanted to know how as ur exam..i believe u gave AS AICT??Help us out and can u please tell us what questions came and how was the format?

 

[Xenon]

Xenon, do you have/know any relevant websites or ebooks containing the materials/tutorial/guidance for Applied ICT 9713? Thanks..

Mostly I used the CIE endorsed book for both theory and practical. I also went through all the past papers to prepare for the practical exam and also did some experiments, like working with some unknown functions in excel...
as for on-line resource, these might help you:
http://www.excel-examples.com/00-excel-functions-sitemap.htm

http://www.alevelict.info/topics/index.html

http://www.igcseict.info/

 

[Xenon]

and the graph shown in the markscheme is kinda different..................

the graph given in mark scheme is wrong, the question asked for branch code greater than 4, Vellore's branch code is 3

 

[fah3355]

help plz with my practical summer 09 from 8 plz

 

[princess94]

hey ! can anybody help me in mj2011
step 14
Add to this extract a new field called Ave_Price
This is calculated at run-time and works out, for each album, the average of the three
prices. Format this numeric field as currency, in pounds (£) with 2 decimal places.
in this how we gonna find avg of all the three prices

 

[princess94]

and in oct nov 2009 step 27
In cell C2, enter a formula to add the total number of minutes late for each airline. Only
include flights that were more than 10 minutes late. You may need to add extra column/s to
your sheet/s to do this.
(formula???))