Computers & ICT: Post your doubts here!

[Student of the year]

Sorry to bother you, but i really don't know why when i opened your answers from the spreadsheet N/A signs appear in the J8BUS workbook and in the automatic calendar days workbook #VALUE! appear. I also don't really know how to do the graph. I actually tried doing that question and i did the same thing like you did which was finding the destination, then the number of trips and the average minutes it was late, but then when i had to make the graph i used a scatter graph and i don't know why my horizontal axis are not correct so instead of having (Dive centre, tawara town centre,..) it has numbers and i don't know what to do. I'll also upload my file so it could be easier to understand what i mean.
Thank you, i really appreciate your help.

1. The N/A sign appears for routes which have the no 8,and that is because in the {table array of lookup} J8SEATS,there is no value for 8.
even the ms shows N/A for no 8.
2.( in the automatic calendar days workbook #VALUE! appear.) where is this?? I didnt get this.
3.I dont know how to make the no into text on the horizintal axis,
but one thing which I noticed was that its we should select such a chart type which shows only "Series value" in 'edit data series' and does not show "Series X value" & "Series Y value", like line,bar,column,pie,etc. And we have been given a choice to select the chart type.
{see the attachment to understand better}
I tried with all the chart types and came on this conclusion.
Because such charts show the exact text of the data.

Hope you understand,
and sorry I couldn`t help you much this time.

 

[Student of the year]

n hw must i do qn9 in qp2 s10?

s10_q9
1.You make a query, with only the customerId and the profit.
2.Then you create a report with this query.
i)in report wizard,select this query.
ii)then you add customerID as the grouping level.
iii)then before selecting next, you select grouping options---in that--in group intervals you select 1st letter-OK---then next
iv) now select summary options---and average.
v) then complete making the report.
vi)in the report delete the customerid column & the profit column.
vii)then format the report as per required.

Hope you understand my explanation, do reply.
And if you face any difficulty with formatting do ask.

 

[AAnsarii]

s10_q9
1.You make a query, with only the customerId and the profit.
2.Then you create a report with this query.
......Hope you understand my explanation, do reply.
And if you face any difficulty with formatting do ask.

Jazakillahu khairaa, may Allah bless you n help us all... aameen

all d best 4 ur exams btw, ur appearing 4 a levels or as?

 

[Student of the year]

Jazakillahu khairaa, may Allah bless you n help us all... aameen

all d best 4 ur exams btw, ur appearing 4 a levels or as?

Wayikum......Ameen.
And all the best to you too...
I`m apaering for As Level.
And I know its not that simple, So keep praying--For me as well.

 

[Student of the year]

Does someone have the source files for 9713_s12_qp2?
PLZ give me...I need it for practice.
Have my exams just the next week.
JazakAllah.

 

[AAnsarii]

Does someone have the source files for 9713_s12_qp2?
PLZ give me...I need it for practice.
Have my exams just the next week.
JazakAllah.

 

[Ibtizam]

hey
I need MS frontpage ??
any link (Pirate bay is not wrkng)
Plz ASAP

 

[Student of the year]

JazakAllah khair, bro/sis- AAnsarii

 

[AAnsarii]

JazakAllah khair, bro/sis- AAnsarii

wa iyyak, bro/sis Student of the year

 

[Ibtizam]

hey
I need MS frontpage ??
any link (Pirate bay is not wrkng)
Plz ASAP

Plz anyone who can help me with Front page^^^????

 

[Tkp]

FACING problem in oct nov 12 qp 15.i knw its cross tab and when i put forename as a value they r telling cannot have aggreagte function in order of clause

 

[Nathan Ford]

practicals??​

 

[maryam96abdelhady]

Hi, everyone
I don't really understand Q.9 from 2012 paper 2 June , can someone please help me.

 

[maryam96abdelhady]

What days are you all doing your ICT paper 2 AS exam on. Good luck to everyone

 

[AAnsarii]

plz help me wid dese ques!

24. tk a new excel sheet n enter d tbl so dat it looks similar 2 d 1 in d qp. dont add d values under d Route row, in d 3rd row. merge cells A1 to I1.
25. now in cell A3, u need 2 "count the number of buses that are 5 or more minutes late for each bus route". so 4 route 1, u'll go =COUNTIF({d minutes late column}, >=5)
26. {at least dis is hw i did it} copy each cell n paste it in its ryt plc 2 match d qp.
May Allah Help us all, n purify r intentions. Aameen
All d best

 

[Tkp]

i am trying to import all the data from the file of mj 09 album but it says Not all of ur data was successfully imported.Error descriptions with assocaited row numbers can be found in the microsoft office access table import error.cn any 1 help me

 

[fille spéciale]

What days are you all doing your ICT paper 2 AS exam on. Good luck to everyone

25th of march..good luck !

 

[maryam96abdelhady]

25th of march..good luck !

I'm doing it on the 24th of March inshallah, i hope it's not very hard

 

[AAnsarii]

i am trying to import all the data from the file of mj 09 album but it says Not all of ur data was successfully imported.Error descriptions with assocaited row numbers can be found in the microsoft office access table import error.cn any 1 help me

it must b containing "Date". if ur importing date, while importing, always 4mat it as Text, n after d tbl is imported, in design view, change d data type to "Date/Time"

May Allah help us all. aameen.

 

[AAnsarii]

s12, q11
http://papers.xtremepapers.com/CIE/Cambridge International A and AS Level/Applied Information and Communication Technology (9713)/9713_s12_qp_2.pdf
y isn't it =IF((I2/60)>5,INT(I2/300),1) and is =INT(1+I2/300)*G2 ??? Student of the year plz help if u can