Author Topic: EXTREMLY IMPORTANT PLEASE PLEASE OPEN  (Read 3813 times)

Offline ikh

  • SF Immigrant
  • **
  • Posts: 52
  • Reputation: 88
Re: EXTREMLY IMPORTANT PLEASE PLEASE OPEN
« Reply #15 on: March 27, 2010, 10:47:02 am »
@nobody
 i didnt copy paste the qs as they were long and also they were linked up to other parts....

Offline ikh

  • SF Immigrant
  • **
  • Posts: 52
  • Reputation: 88
Re: EXTREMLY IMPORTANT PLEASE PLEASE OPEN
« Reply #16 on: March 27, 2010, 11:25:21 am »
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  :)
 

« Last Edit: March 27, 2010, 11:53:15 am by ikh »

Offline ikh

  • SF Immigrant
  • **
  • Posts: 52
  • Reputation: 88
Re: EXTREMLY IMPORTANT PLEASE PLEASE OPEN
« Reply #17 on: March 29, 2010, 07:48:08 pm »
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..

nid404

  • Guest
Re: EXTREMLY IMPORTANT PLEASE PLEASE OPEN
« Reply #18 on: March 30, 2010, 06:51:58 am »
Nobody takes AICT....NObody is the name of the member ::)
I shall ask him

Offline ikh

  • SF Immigrant
  • **
  • Posts: 52
  • Reputation: 88
Re: EXTREMLY IMPORTANT PLEASE PLEASE OPEN
« Reply #19 on: March 30, 2010, 02:19:50 pm »
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

Offline ikh

  • SF Immigrant
  • **
  • Posts: 52
  • Reputation: 88
Re: EXTREMLY IMPORTANT PLEASE PLEASE OPEN
« Reply #20 on: April 02, 2010, 06:09:38 am »
PLEASE ANSWER GUYS

Offline Nobody

  • Global Moderator
  • SF V.I.P
  • *****
  • Posts: 5351
  • Reputation: 65535
  • Gender: Male
Re: EXTREMLY IMPORTANT PLEASE PLEASE OPEN
« Reply #21 on: April 02, 2010, 06:37:42 pm »
i''l answer....wait give me some time!!!
The most beautiful thing is to see a person smiling!
And even more beautiful is, knowing that you are the reason behind it.

Offline ikh

  • SF Immigrant
  • **
  • Posts: 52
  • Reputation: 88
Re: EXTREMLY IMPORTANT PLEASE PLEASE OPEN
« Reply #22 on: April 03, 2010, 01:37:24 pm »
i am waiting Nobody


Offline Nobody

  • Global Moderator
  • SF V.I.P
  • *****
  • Posts: 5351
  • Reputation: 65535
  • Gender: Male
Re: EXTREMLY IMPORTANT PLEASE PLEASE OPEN
« Reply #23 on: April 03, 2010, 08:31:50 pm »
If you are waiting for nobody....
nobody will com and answer.....
But  Nobody will surely answer your post  :P :P ( got that pun?)
The most beautiful thing is to see a person smiling!
And even more beautiful is, knowing that you are the reason behind it.

Offline ikh

  • SF Immigrant
  • **
  • Posts: 52
  • Reputation: 88
Re: EXTREMLY IMPORTANT PLEASE PLEASE OPEN
« Reply #24 on: April 04, 2010, 09:51:54 am »
@Nobody

got the pun but plz plz plz hurry up i have my it board very soon

Offline ikh

  • SF Immigrant
  • **
  • Posts: 52
  • Reputation: 88
Re: EXTREMLY IMPORTANT PLEASE PLEASE OPEN
« Reply #25 on: April 04, 2010, 10:15:10 am »
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

Offline ikh

  • SF Immigrant
  • **
  • Posts: 52
  • Reputation: 88
Re: EXTREMLY IMPORTANT PLEASE PLEASE OPEN
« Reply #26 on: April 04, 2010, 08:05:29 pm »
@ 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?


Offline ikh

  • SF Immigrant
  • **
  • Posts: 52
  • Reputation: 88
Re: EXTREMLY IMPORTANT PLEASE PLEASE OPEN
« Reply #27 on: April 07, 2010, 12:32:05 pm »
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

Offline Nobody

  • Global Moderator
  • SF V.I.P
  • *****
  • Posts: 5351
  • Reputation: 65535
  • Gender: Male
Re: EXTREMLY IMPORTANT PLEASE PLEASE OPEN
« Reply #28 on: April 07, 2010, 01:17:24 pm »
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..)
The most beautiful thing is to see a person smiling!
And even more beautiful is, knowing that you are the reason behind it.

Offline ikh

  • SF Immigrant
  • **
  • Posts: 52
  • Reputation: 88
Re: EXTREMLY IMPORTANT PLEASE PLEASE OPEN
« Reply #29 on: April 08, 2010, 11:46:24 am »
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