Computers & ICT: Post your doubts here!

[fille spéciale]

I'm an ICT student in AS
I have a problem in the paper 2009 m/j p2 question 10
here is the question
10. Select from all the records only the customers that have booked more than one
holiday. Calculate for each of these customers the average price of their holidays.
Include within the report only the Forename, Surname and the summary data.
Group this data by the number of holidays booked. Sort the data within each group into
ascending order of Surname, then into ascending order of Forename. For each group
show the number of customers and the average cost of the holidays. Make sure that
the average costs are formatted into the same currency format as the cost field.
Add the title Customers with more than one holiday to the report. Make sure that the
report fits on a single page and that all data and labels are visible. Place your name,
Centre number and candidate number in the header of your report.

should i use query design or query wizard
iif you have solution to the question please answer me
thanksss

coincidently...today itself i solved this ppr...
use query wizard...

 

[Alool]

coincidently...today itself i solved this ppr...
use query wizard...

thank you so much !

 

[Shady Omar]

Guys I have a question
Step 28 In winter 2010 paper 2
The graph
how do i do it?
Please help

 

[fille spéciale]

plz help
Devilishangel:).....refer to dis !

 

[AAnsarii]

s09 qp2 q13
hw do u get d 4mat specified?

 

[AAnsarii]

I'm an ICT student in AS
I have a problem in the paper 2009 m/j p2 question 10
here is the question
10. Select from all the records only the customers that have booked more than..... header of your report.

should i use query design or query wizard
iif you have solution to the question please answer me
thanksss

In question 10 summer 09

create a select query add only customer and hols table because we need to find only those customers who have more then one booking and avg cost

• add forename, surname, custref, cost
• change the customer reference field to this No of booking:[custref]
• now press totals to group it
• now change the group by of no of booking to count
• change the group by of cost to Avg
• put the condition of >1 under no of booking
• format the average cost to the pound from properties

make a report on the query , question solved

hope it answer the question

by sir Navid Saqib

 

[Alool]

In question 10 summer 09

create a select query add only customer and hols table because we need to find only those customers who have more then one booking and avg cost

• add forename, surname, custref, cost
• change the customer reference field to this No of booking:[custref]
• now press totals to group it
• now change the group by of no of booking to count
• change the group by of cost to Avg
• put the condition of >1 under no of booking
• format the average cost to the pound from properties

make a report on the query , question solved


hope it answer the question

by sir Navid Saqib

Thank you so much!!

 

[Shady Omar]

please helpp

 

[workaholic]

Sir, when doing our computing projects do we only include errors the user may encounter in the troubleshooting section of the user guide or is there something else that we need to include as well???

 

[AAnsarii]

s10 p2 q9

 

[nadia samir]

heyy
anyone know where i can find the grade boundaries for practical and theory ( practical most important ) past papers?
CIE Applied ICT Internetional AS level 9713
Thanks xx

 

[AAnsarii]

heyy
anyone know where i can find the grade boundaries for practical and theory ( practical most important ) past papers?
CIE Applied ICT Internetional AS level 9713
Thanks xx

grade boundries meaning?
passing mks r 40%, n usually they give above 90 A* bt datz if u gt in both as n a2 lvl..n d rest r lyk 80>=A, 70>=B, etc.

 

[maryam96abdelhady]

Can someone please help me
I am really stuck on question 29 on the 2008 paper 2 June paper, and my exam is next Sunday.
Thank you so much

 

[InternationationalGuy]

In AICT the excel part formulas are quite confusing. Is there some way to make them easier to understand?? Thank you.

 

[AAnsarii]

In AICT the excel part formulas are quite confusing. Is there some way to make them easier to understand?? Thank you.

i noe of ony 1 way: ask 4 Allah's help, He really will get u things 4m wr u cannot imagine.
n also if u think itz 2 confusing, go wid d basics 1st, den if no ans found there, advance. dont 1stly search in d diff 1z.
All d best!
may Allah Help us all. aameen

 

[Student of the year]

Can someone please help me
I am really stuck on question 29 on the 2008 paper 2 June paper, and my exam is next Sunday.
Thank you so much

I`ve attached my solved ans for this question,
hope its of some help to you.
If you dont understand anything so ask me, i`ll give you the explaination.

 

[Student of the year]

Asak,
ALL THE BEST...............
to every student of AS Aict student for their practical exams.
Pray for all of us, badly in need of duas.
The papers seem to be quite challenging.
So once again,
ALL THE BEST guys.

 

[Student of the year]

http://papers.xtremepapers.com/CIE/Cambridge International A and AS Level/Applied Information and Communication Technology (9713)/9713_s08_qp_2.pdf q 32, hw do u get d graph properly, wid d Destination names appearing?
ps im getting 1,2,3 instead of Dive centre, Sailing...etc

plz help me wid dese ques!

See my reply

I`ve attached my solved ans for this question,
hope its of some help to you.
If you dont understand anything so ask me, i`ll give you the explaination.

Hope its of some help to you.

 

[InternationationalGuy]

i noe of ony 1 way: ask 4 Allah's help, He really will get u things 4m wr u cannot imagine.
n also if u think itz 2 confusing, go wid d basics 1st, den if no ans found there, advance. dont 1stly search in d diff 1z.
All d best!
may Allah Help us all. aameen

Ameen. Thanks for the tip.

 

[maryam96abdelhady]

I`ve attached my solved ans for this question,
hope its of some help to you.
If you dont understand anything so ask me, i`ll give you the explaination.

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.