Applied ict 9713 paper2 (post your doubts here)

[sma786]

Yea that one still intrigues me.

Even the one which they have set in the Marking scheme isn't totally valid.

I mean

"Workers who are paid monthly can earn between €1500 and €10000 a month (inclusive).
Workers who are paid hourly are paid between €8 and €20 an hour (inclusive). Add
appropriate validation"

The statement becomes

If PayType = M than RateOfPay is Between 1500 and 10000
OR
If PayType = H than RateOfPay is Between 8 and 20.

But since I guess that will become a little too complicated .. The answer for this question as far as i remember was.

(Between 8 And 20) OR (Between 1500 and 10000)

But imo this won't be a good check though .. since this way one can easily enter 1500euros for hourly or 20euro for monthly.

I tried it, ">=1500" And "<=10000" like this, dosent work

 

[sma786]

Yea that one still intrigues me.

Even the one which they have set in the Marking scheme isn't totally valid.

I mean

"Workers who are paid monthly can earn between €1500 and €10000 a month (inclusive).
Workers who are paid hourly are paid between €8 and €20 an hour (inclusive). Add
appropriate validation"

The statement becomes

If PayType = M than RateOfPay is Between 1500 and 10000
OR
If PayType = H than RateOfPay is Between 8 and 20.

But since I guess that will become a little too complicated .. The answer for this question as far as i remember was.

(Between 8 And 20) OR (Between 1500 and 10000)

But imo this won't be a good check though .. since this way one can easily enter 1500euros for hourly or 20euro for monthly.

ok so this comes as a complete shock, you have to type in letters like "between 1500 and 10000 or between 8 and 20" .. weird eh?
and bdw, your dp is soo weird

 

[syed1995]

ok so this comes as a complete shock, you have to type in letters like "between 1500 and 10000 or between 8 and 20" .. weird eh?
and bdw, your dp is soo weird

haha yeah.. i know right

 

[sma786]

haha yeah.. i know right

When is your paper bdw?

 

[syed1995]

I tried it, ">=1500" And "<=10000" like this, dosent work

the reason that isn't working is because of the " " (quotation marks)

The correct way with those would be.

(>=8 And <=20) Or (>=1500 And <=10000) so that the access understands that either one of the conditions should be met.

 

[sma786]

http://papers.xtremepapers.com/CIE/...unication Technology (9713)/9713_w12_qp_2.pdf

Question 15, where m i going to get the sales of staff from????

 

[salvatore]

http://papers.xtremepapers.com/CIE/...unication Technology (9713)/9713_s10_qp_2.pdf
Please please please help me with question 9.

I don't understand how to split the customerID into business and personal to produce a report.
Please help me ASAP.
Thanks

 

[sma786]

http://papers.xtremepapers.com/CIE/Cambridge International A and AS Level/Applied Information and Communication Technology (9713)/9713_s10_qp_2.pdf
Please please please help me with question 9.

I don't understand how to split the customerID into business and personal to produce a report.
Please help me ASAP.
Thanks

It says you need to take only Business customers, go to query's design view,
in the criteria for customerID, type " B????" thats it

 

[salvatore]

It says you need to take only Business customers, go to query's design view,
in the criteria for customerID, type " B????" thats it

I understand how to that. But the question is saying that we have to calculate the average profit for each.. what about this one?

 

[sma786]

I understand how to that. But the question is saying that we have to calculate the average profit for each.. what about this one?

While preparing report, at one step its written :Advanced, click it and select below Avg "CustomerID"

 

[Moonflower17]

http://papers.xtremepapers.com/CIE/Cambridge International A and AS Level/Applied Information and Communication Technology (9713)/9713_s10_qp_2.pdf
Please please please help me with question 9.

I don't understand how to split the customerID into business and personal to produce a report.
Please help me ASAP.
Thanks

This is how the query will look like hope it helps

 

[Enes]

Hi! Can somene help me with the question 15 in W12_P2??

 

[Arshman jutt]

i cant even text you?

i cant even text you?

it wil be a humble request from me PLEASEEEEE DO TELL ME THAT...WHAT WAS THE PRACTICLE ABOUT ACCESS OR EXCEL AND WHAT WERE THE MAIN QUESTIONS AND WHAT WERE THE DIFFICULTIES ???FaceBOOK: [email protected] .... your stranger help seeker

EMAIL: [email protected] thankssss

 

[Weezyminaj]

how do you do question 15 and 16 in oct/nov 2012

 

[iman noubani]

Hey guys! im terrified from the exam can anyone help please? :/

this is my account of facebook: https://www.facebook.com/noubzi

id appreciate any help ;/!

 

[Maya Refaat]

Hi can anyone please post the november '12 mark scheme? TIA.

 

[narry]

hi people i have my ict exam on 25th can you tell me what came in the exam ? plzz its urgeent ! and what past paper was similar to the exam thankss

 

[DanaOreo]

Can somebody help with may june 2009 number 11 ? asap please

 

[Student of the year]

Hi! Can somene help me with the question 15 in W12_P2??

how do you do question 15 and 16 in oct/nov 2012

http://papers.xtremepapers.com/CIE/...unication Technology (9713)/9713_w12_qp_2.pdf

Question 15, where m i going to get the sales of staff from????

see this reply...

Hey Friends,


Steps:
i)select query wizard, select the query of q14
ii)select only the fields--country,branchname & jobcode
iii)then in summary option, tick the side box saying-count the records
iv) in design view, add the criteia for country as Spain or Germany
v)only show the branchname, & cont of N12EMPLOYEE fields, untick the others
vi)save this & make a report as per the ques demmands.

hope it helps you...

 

[Student of the year]

Can somebody help with may june 2009 number 11 ? asap please

see reply ......

q11:

• go to query wizard, select from all the tables the required fields
• in design view put the criteria-->31/7/10 and <1/9/10----in the O_Date column {this is acc to the ms whereas acc to me this criteria should come in both H_Date & O_Date}
• then do q12, by adding an extra column--- Balance:[Cost]-[Pay]

.

Hope it helps....