IGCSE/GCSE/O & A Level/IB/University Student Forum
Qualification => Subject Doubts => GCE AS & A2 Level => Math => Topic started by: ikh on March 20, 2010, 03:25:30 am
-
I am doing A level CIE AICT privately and i am stuck with Access question in paper 4. Please could someone put a step by step guide for the paper 4 or could someone post solved paper files please. The marking scheme for paper 4 is extremly unhelpful. Please please help me i have got the board exam next month.
Thanks in advance
-
Isnt anyone just anyone doing Cie aict ??? ???
-
Well at least some moderators should help come on :-[ please
-
yep... i will try!!! SURE!
-
Sorry mate....I'm not doing AICT so i won't be able to help really...
I guess ima_shah is......I'll send him a msg and find out
-
Well thanks guys for taking in the interest and hopefully you will be able to help me out. :)
-
which year??
put the full file name of the paper you are solving..
Like
9713_s08_qp4 OR 9713_s09_qp4 or any other paper..
-
@Nobody
Well 9713_s08_qp_4 mainly, i will be glad if you could do the other paper 4 as well (oct 08, may 09, oct 09). For oct 08, may 09, oct 09 if you do just the word part of it like just mail merge and you skip the excel and access that also fine because my weakness is mainly mail merge.
Also i have 2 qs
1. in May/june o9 paper 4 qs 6
"Prepare a report for this search.
Include the Region, Boat Model, HireP/W, Company and Guests fields grouped by
Region then Company and sorted into ascending order of Guests then into ascending
order of HireP/W
Ensure that:
• all labels and data are fully visible
• the report has the heading Region and Guests
• your name, Centre number and candidate number are in the footer of the report.
Run the report for the Balearic region for 8 passengers.
Print the report. "
In this what do they mean by labels and data are fully visible ? is it that i have to make labels or is that i fields are referred to as labels and by the way the marking scheme does not mention anything about the labels
2. in nov 08 paper 4 qs 5
"Format the Charge column and the Cost column into Euros (€) with 2 decimal places."
How do i do this because in qs 4
"Enter formulae into cells B3 to B9 that will look up the customer details from the file
CUSTOMERS.CSV using a Customer id entered in cell B2.
Paste link the hire costs from the file CHARGES.CSV into the cells A15 to C24.
Enter formulae in cells E15 to E24 to calculate the cost of the furniture ordered using the
Charge and Order values.
Enter a formula into cell E25 to calculate the subtotal of the costs.
Enter a formula into cell D26 that will look up the Discount code for the customer from the
file CUSTOMERS.CSV
Enter a formula into cell E26 that will calculate the amount that will be discounted from the
Subtotal in cell E25 based on the discount rate
. The discount rate is based upon the
Discount Code in cell D26 where:
• a = no discount
• b = 10% discount
• c = 15% discount
Enter a formula into cell E27 to calculate the Total
after the discount has been taken into
account. "
i have been asked to paste link which i did by copying the cells in the charges.csv file and then by paste special i selected paste link. So when i need to format the charge column should do it in the charges.csv or the file into which i have copied the stuff into. doing it either way doesnot work by the way at least for me i cannot do anyformatting whatsoever on the charge column be it just to change the number of decimal places e.Take Care. my teacher said i will have to format it manually but i am think there might be some other method... if you do know let me know please.
THanks in advance
-
Hey There,
I would be glad to help. As i just completed these papers recently.
In this what do they mean by labels and data are fully visible ? is it that i have to make labels or is that i fields are referred to as labels and by the way the marking scheme does not mention anything about the labels
AS to this, they just mean that when you open the report, all the information in it is fully available, like Headings and Columns do not over lap each other and such. You can do this by going to the design view of the report and adjusting the "labels" (headings) so that they are fully visible.
i have been asked to paste link which i did by copying the cells in the charges.csv file and then by paste special i selected paste link. So when i need to format the charge column should do it in the charges.csv or the file into which i have copied the stuff into. doing it either way doesnot work by the way at least for me i cannot do anyformatting whatsoever on the charge column be it just to change the number of decimal places e.Take Care. my teacher said i will have to format it manually but i am think there might be some other method... if you do know let me know please.
You will have to Change format of the cells of the file to which you have copied the stuff to. The method i know is the one in which you select one of the cells of the Charge column and Right Click on it. Click on format cell and select Currency. Select Euro from the drag down list. After the one cell is formatted, drag the cell to Convert the rest of values to Euro.
Hope that you find this helpful.
-
@Nobody
Well 9713_s08_qp_4 mainly, i will be glad if you could do the other paper 4 as well (oct 08, may 09, oct 09). For oct 08, may 09, oct 09 if you do just the word part of it like just mail merge and you skip the excel and access that also fine because my weakness is mainly mail merge.
Also i have 2 qs
1. in May/june o9 paper 4 qs 6
"Prepare a report for this search.
Include the Region, Boat Model, HireP/W, Company and Guests fields grouped by
Region then Company and sorted into ascending order of Guests then into ascending
order of HireP/W
Ensure that:
• all labels and data are fully visible
• the report has the heading Region and Guests
• your name, Centre number and candidate number are in the footer of the report.
Run the report for the Balearic region for 8 passengers.
Print the report. "
In this what do they mean by labels and data are fully visible ? is it that i have to make labels or is that i fields are referred to as labels and by the way the marking scheme does not mention anything about the labels
2. in nov 08 paper 4 qs 5
"Format the Charge column and the Cost column into Euros (€) with 2 decimal places."
How do i do this because in qs 4
"Enter formulae into cells B3 to B9 that will look up the customer details from the file
CUSTOMERS.CSV using a Customer id entered in cell B2.
Paste link the hire costs from the file CHARGES.CSV into the cells A15 to C24.
Enter formulae in cells E15 to E24 to calculate the cost of the furniture ordered using the
Charge and Order values.
Enter a formula into cell E25 to calculate the subtotal of the costs.
Enter a formula into cell D26 that will look up the Discount code for the customer from the
file CUSTOMERS.CSV
Enter a formula into cell E26 that will calculate the amount that will be discounted from the
Subtotal in cell E25 based on the discount rate
. The discount rate is based upon the
Discount Code in cell D26 where:
• a = no discount
• b = 10% discount
• c = 15% discount
Enter a formula into cell E27 to calculate the Total
after the discount has been taken into
account. "
i have been asked to paste link which i did by copying the cells in the charges.csv file and then by paste special i selected paste link. So when i need to format the charge column should do it in the charges.csv or the file into which i have copied the stuff into. doing it either way doesnot work by the way at least for me i cannot do anyformatting whatsoever on the charge column be it just to change the number of decimal places e.Take Care. my teacher said i will have to format it manually but i am think there might be some other method... if you do know let me know please.
THanks in advance
logical has already done my job...thanks logical..
But still i'll answer..
Q.1 As logical said..you have to make sure that every word in the report is seen in the printout. Even if a word overlaps another....your marks will be deducted.
Q.2 what i suggest is select the cell, Right click it, go to format cells, use ACCOUNTING not any other.....
because in accounting you can select ANY currency that you want. Normally the computer will have default currency like $ or £ or ¥.
But if are told to put some other currency.. you can...
i also provided a example.... 8) 8) 8) ;D ;D
-
THanks a lot NObody and logical ;D ;D
Anywayz where are u guys from and which school are you in ???
Could you also help me out summer 08 paper 4 mail merge part
thanks
-
@logical
as you are done with the papers could you please post it (p4s of 08,09)
thanks :P
-
guys mail merge help please
it been a long time since i started this post :-\ :-\ :-\
-
what in mail merge?? post the question if possible.!! ;D ;D ;D ;D
-
what in mail merge?? post the question if possible.!! ;D ;D ;D ;D
well the following qs
1) jun 08 q11 - q13
2) nov 08 q11 - q15
3) jun 09 q9 - q11
4) nov 09 q8 and q10
and guys please hurry up time is running out
;)
-
@nobody
i didnt copy paste the qs as they were long and also they were linked up to other parts....
-
please bear with me
I have pasted the qs where i need help and the part are in bold and underlined.you could help me by putting up the steps .
Also if someone has completed the paper 4s of CIE AICT please post it over here
IN JUN 08
[/size][/color]
11 Using a suitable software package and the file ACKNOW.RTF prepare letters for customers
who have not yet received an acknowledgement of their booking. Only produce a letter if the
AckSent field is False.
Save and print this document showing merge and field codes. Make sure your Centre
number, candidate number and name are shown in the footer of the page.
Provide evidence of the selection method used and place this in your evidence document.
Merge the selected records to a document
and save it as ACKMERGE.RTF
Print this document.
[13]
You are going to create a system to print letters to customers who have ordered furniture that is
unavailable, apologising and suggesting alternatives.
12 Before the acknowledgement letters are sent, it is decided that between the dates of 2nd and
9th August inclusive, the white dining chairs (code wd) are to be withdrawn for repair.
You should make sure that only the customers who have already been sent
acknowledgement letters receive the apology.
Use APOLOGY.RTF as a template.
Insert, where indicated, fields that will require keyboard input when the merge is created.
Use unavailable item and replacement item as the text for relevant prompts.
Save and print this source document showing the merge and field codes. Make sure your
Centre number, candidate number and name are shown in the footer of the page.
You are required to merge letters to the customers who have:
• received an acknowledgement
• ordered the white dining chairs (code wd)
• made a booking between 2nd and 9th August inclusive.
Enter white dining chairs when prompted for the unavailable item and gilt dining chairs
when prompted for the replacement item.
Provide evidence of the selection method used and place this in your evidence document.
Merge the selected records to a document.
Print this document.
[25]
You are going to create a menu system using hyperlinks within a word processed document.
13 Use the file MENUBLANK.RTF as a template to create this menu.
For each menu item, create a hyperlink from the text Click here to open the relevant file.
For each menu item add text to explain to the user what the menu item does.
Place the image MILLSIDE.JPG in the top right corner of the menu so that it is 14
centimetres from the left side of the page and 2 centimetres from the top of the page. Move
the title down so that it is below the image.
Create a hyperlink from this image to the URL http://www.hothouse-design.co.uk
Place your Centre number, candidate number and name in the footer.
Save the menu with the filename MILLSMENU
Print this menu.
Provide evidence of the links, paths and filenames used and place this in your evidence
document.
IN NOV 08
[/size][/color]
You are now going to create a system to print letters to customers. The letters will inform them of the
full product range and offer them discounts.
11 Use the UPD.RTF file as a template. Paste link the Item and Charge columns from
CHARGES.CSV into this document.
Adjust column widths to make sure that Item and Charge data for each product fit on a
single line.
Use CUSTOMERS.CSV as the data source for a mail merge to all customers.
Insert, where indicated, a field that will automatically add text as the merge is carried out.
Use 5% discount as the default text and an
extra 5% discount if the discount code for
the customer is b or c.
Save this source document showing the merge and field codes as UPDMAIN in a format
that keeps the merge code information.
Provide screenshots or other evidence of all the fields you inserted and place these in the
evidence document which you created at Step 2.
[12]
12 Merge letters to only the customers with an address in Doddsey Business Park
Provide evidence of the selection method used and place this in your evidence document.
Merge the selected records to a document. Make sure your Centre number, candidate
number and name are printed in the footer of the page. Print the document.
[2]
13 Use the file LABELS.RTF as a template. Use CUSTOMERS.CSV as the data source.
The labels should display the address as follows:
Contact
Company
Add1
Add2
Add3
County
Post_code
Save this source document showing the merge and field codes as LABELMAIN in a
format that keeps the merge code information.
Merge the labels for customers with an address in Millside Industrial Centre only.
Place your Centre number, candidate number and name in the footer of the page. Print
the document.
Provide evidence of the selection method used and place this in your evidence document.
[10]
You are going to create a menu system.
14 The menu should include options to:
• calculate costs using the file ORDERS
• produce letters using the file UPDMAIN
• prepare address labels using the file LABELMAIN
• open the data source CHARGES.CSV
• open the data source CUSTOMERS.CSV
Each menu item should be accompanied by some explanatory text.
Save the menu as MillsMenu
Include evidence of the links, paths and filenames in your evidence document.
[15]
15 Create a document that automatically generates a full set of labels when it is opened.
Save the document as Autolabels in the format your applications provides.
Provide screenshots or other evidence that shows the methods you used in your evidence
document.
Create another menu item in the file MillsMenu to select the Autolabels. Accompany this
item with some explanatory text.
Save the updated menu as MillsMenu2.
Include evidence of the the links, paths and filenames in the evidence document that you
created at Step 2.
[16]
IN JUN 09
[/color]
9) Automate the production of a letter to customers enquiring about cruises.
Create a macro or procedure to do the following:
• prompt for the customer’s address to be inserted
• insert 3 blank lines
• insert Dear as the beginning of the salutation
• prompt for the customer’s name
• insert 2 blank lines
• insert the text I have pleasure in providing the information you requested
• insert 2 blank lines
• add the company logo PB.JPG to the top right of the page.
Include screen shot(s) or listing(s) of your code or macro in your evidence document.
10 Using the file IONIAN10.RTF run the macro or procedure to produce a quotation for:
Name: Mr D. Liver
Address: 14 Portnoy Place
Rothesay
A20 7NH
Include the closure Yours sincerely after the text of the report.
Ensure the letter fits on a single page and your name, candidate number and Centre number
are moved to the footer of the page.
Print the document.
11 A customer requires a boat in the Ionian region with a crew and air-conditioning.
Use the file AVAILABILITYREQ.RTF to mail merge a letter to cruise companies asking
whether these boats are available.
Show evidence of your selection method in your evidence document.
Ensure your name, candidate number and Centre number is included in the footer of the
document.
Print the letters.
IN NOV 09
[/color]
8 Create a menu to make all three reports available to a user.
Give each menu option an appropriate label and ensure that the reports open in preview
mode.
Include a screen shot of your menu in your evidence document.
Include screen shot(s) of your code, macro or switchboard items table in your evidence
document.
10 Using the file ENQUIRYREPLY.RTF as a mail merge template, prepare a letter to be sent
to each customer with details of the cruise they requested.
Where the customer has requested jet skis the following text should automatically be
inserted Please note that due to new regulations jet skis are no longer available.
Ensure your name, candidate number and Centre number are included in the footer of the
document.
Print a copy of the document showing the field codes.
Merge the letters to a new document and print the letters.
PLEASE BEAR WITH ME
AND HELP ME OUT SOON AS TIME IS RUNNING OUT :)
-
guys dont be lazy answer my qs.
Anywazzs one more qs in nov 08 q14 for the menu system should we use the word or access to make it and please justify as well..
-
Nobody takes AICT....NObody is the name of the member ::)
I shall ask him
-
Also in nov 08 q15 how do you create an automated set of labels (how do you make the macro open up with the file)
and in jun 09 i created the macro but i had two problems
a) while recording the macro i couldnt move the picture (PB.jpg)
b) and after recording the macro and running it the prompts where not working ( i had used the fillin because the marking scheme said so )
please help me soon
-
PLEASE ANSWER GUYS
-
i''l answer....wait give me some time!!!
-
i am waiting Nobody
-
If you are waiting for nobody....
nobody will com and answer.....
But Nobody will surely answer your post :P :P ( got that pun?)
-
@Nobody
got the pun but plz plz plz hurry up i have my it board very soon
-
If you are waiting for nobody....
nobody will com and answer.....
But Nobody will surely answer your post :P :P ( got that pun?)
Nonody plz help me soon
-
@ Nobody
i have made it easy, the following p4s where i had issues
in jun 08
1) The marking scheme says “Use of Doc "fillin" field” and “Use of "fillin" default values” for q12, what does this mean?
in nov 08
2) In q14 where menu systems are to be used which software should we use word/access?
3) In q15 how do we automate the opening of the macro with the file “Create a document that automatically generates a full set of labels when it is opened”? How do we do this?
in jun 09
1) For q9 how do we do the macro part? For this part “prompt for the customer’s address to be inserted” marking scheme says fillin is to be used but using fillin doesn’t work, when the macro is run the fillin doesn’t appear. Solution??
2) Also in the same part there is a problem that the image also has to be placed but what happens is that the image can be copied to the document but moving it isn’t possible.
3) In q10 how can I run the macro with the file IONIAN10.rtf as it is a report and how do I select the name and address because my macro doesn’t show it? And also where should the image appear on the page?
in nov 09
1) In q1 when importing the file BOATSPECS.CSV there is an error because the Hire P/W column has values with comma in it due to which it is displayed as a separate column, how should we solve the problem?
in spec 08
1) In q16 how can we distinguish between first and subsequent tests? Marking scheme says “if then else” to be used but what criteria should we specify for it?
-
If you are waiting for nobody....
nobody will com and answer.....
But Nobody will surely answer your post :P :P ( got that pun?)
still waiting bro
-
he..ikh.... i was busy these days... because i had my exams but now..i am free...i will tell you soon....
no worry..... ;) ;) be happy....
And that day on chat (if you remember...) I told you that i will answer it tomorrow 99%..because i was going to solve.it...but then i didn't do it...
Are you taking As or A2 this May-June...???
I'll solve it later.....as today we had another test .......hope you understand... :(
It's not that I don't want to help you ....it's just that i don't get enough time...and whenever you see me online...it's only few RARE moments which i get on internet......and nobody would link to miss internet hours....(at least no me..)
-
he..ikh.... i was busy these days... because i had my exams but now..i am free...i will tell you soon....
no worry..... ;) ;) be happy....
And that day on chat (if you remember...) I told you that i will answer it tomorrow 99%..because i was going to solve.it...but then i didn't do it...
Are you taking As or A2 this May-June...???
I'll solve it later.....as today we had another test .......hope you understand... :(
It's not that I don't want to help you ....it's just that i don't get enough time...and whenever you see me online...it's only few RARE moments which i get on internet......and nobody would link to miss internet hours....(at least no me..)
i am taking as and a2 this may june
-
okay...ikh...
since it's all A2 i don't think i know it all..still
and i am really SORRY because my answers are not op to the mark..
"in jun 08
1) The marking scheme says “Use of Doc "fillin" field” and “Use of "fillin" default values” for q12, what does this mean?"
it means you have to do the fill-in option ...in office 2007 go where i showed you in the picture... :)
The FILLIN field prompts you to enter text. Your response is printed in place of the field
"in nov 08
2) In q14 where menu systems are to be used which software should we use word/access?"
in this case..you use access...not word..
"3) In q15 how do we automate the opening of the macro with the file “Create a document that automatically generates a full set of labels when it is opened”? How do we do this?"
to do macro..you need to learn from the text book..
by the way...what text book do you use..????
-
okay...ikh...
since it's all A2 i don't think i know it all..still
and i am really SORRY because my answers are not op to the mark..
"in jun 08
1) The marking scheme says “Use of Doc "fillin" field” and “Use of "fillin" default values” for q12, what does this mean?"
it means you have to do the fill-in option ...in office 2007 go where i showed you in the picture... :)
The FILLIN field prompts you to enter text. Your response is printed in place of the field
"in nov 08
2) In q14 where menu systems are to be used which software should we use word/access?"
in this case..you use access...not word..
"3) In q15 how do we automate the opening of the macro with the file “Create a document that automatically generates a full set of labels when it is opened”? How do we do this?"
to do macro..you need to learn from the text book..
by the way...what text book do you use..????
Well i use the brian txt book.
ANd dude no problem as long as u attempted.... ;)
-
Hey....ikh?.....whats your name?........Well i Have my final in about four days time and i know it must have been frustrating to wait and all for solutions.....well i hope its not to late..........
Q.The marking scheme says “Use of Doc "fillin" field” and “Use of "fillin" default values” for q12, what does this mean?
Ans. Well at the end of the question they tell you what default values you should insert, so the MS is referring to that."Enter white dining chairs when prompted for the unavailable item and gilt dining chairs
when prompted for the replacement item"
1) For q9 how do we do the macro part? For this part “prompt for the customer’s address to be inserted” marking scheme says fillin is to be used but using fillin doesn’t work, when the macro is run the fillin doesn’t appear. Solution??
2) Also in the same part there is a problem that the image also has to be placed but what happens is that the image can be copied to the document but moving it isn’t possible.
1.Well You have to start wid a blank document......Start recording the macro after you have the data source.
2. Well it doesn't work for me also.....but as in that question there is only one record to print. You better pause the macro then import it.
3) In q10 how can I run the macro with the file IONIAN10.rtf as it is a report and how do I select the name and address because my macro doesn’t show it? And also where should the image appear on the page?
3.Well it definitely should.The image should come right hand top corner.
1) In q1 when importing the file BOATSPECS.CSV there is an error because the Hire P/W column has values with comma in it due to which it is displayed as a separate column, how should we solve the problem?
1. Its actually CharterCost Open CharterCost.CSV File in excel. Select the records under Hire PW, and select General.You shouldnt have problems importing after that.
Well I Havent done the Specimen so unfortunately I cannot help you there. Hope you found it Helpful.
-
Hey....ikh?.....whats your name?........Well i Have my final in about four days time and i know it must have been frustrating to wait and all for solutions.....well i hope its not to late..........
Q.The marking scheme says “Use of Doc "fillin" field” and “Use of "fillin" default values” for q12, what does this mean?
Ans. Well at the end of the question they tell you what default values you should insert, so the MS is referring to that."Enter white dining chairs when prompted for the unavailable item and gilt dining chairs
when prompted for the replacement item"
1) For q9 how do we do the macro part? For this part “prompt for the customer’s address to be inserted” marking scheme says fillin is to be used but using fillin doesn’t work, when the macro is run the fillin doesn’t appear. Solution??
2) Also in the same part there is a problem that the image also has to be placed but what happens is that the image can be copied to the document but moving it isn’t possible.
1.Well You have to start wid a blank document......Start recording the macro after you have the data source.
2. Well it doesn't work for me also.....but as in that question there is only one record to print. You better pause the macro then import it.
3) In q10 how can I run the macro with the file IONIAN10.rtf as it is a report and how do I select the name and address because my macro doesn’t show it? And also where should the image appear on the page?
3.Well it definitely should.The image should come right hand top corner.
1) In q1 when importing the file BOATSPECS.CSV there is an error because the Hire P/W column has values with comma in it due to which it is displayed as a separate column, how should we solve the problem?
1. Its actually CharterCost Open CharterCost.CSV File in excel. Select the records under Hire PW, and select General.You shouldnt have problems importing after that.
Well I Havent done the Specimen so unfortunately I cannot help you there. Hope you found it Helpful.
Well dude for the fillin issue i do use a blank page and while i record the macro and select filin the prompt and everything appears but when i stop recoridng the macro and close the file and open it again and run the macro the fillin thing doesnt appear so the place where i did put up the fillin in the page i right click and then press the toggle i can see fillin but the fillin doesnt pop up asking what to do and even whe i can se the toggle view i cant really enter a value for it...plz advice
and i also send u a PM plz check
And i am surely glad of ur help considering the fact that u have 2 posts(so far) and both on my topic :D