Qualification > Math
EXTREMLY IMPORTANT PLEASE PLEASE OPEN
ikh:
Well thanks guys for taking in the interest and hopefully you will be able to help me out. :)
Nobody:
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..
ikh:
@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:
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:
--- Quote from: ikh on March 23, 2010, 07:18:58 am ---@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
--- End quote ---
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
Navigation
[0] Message Index
[#] Next page
[*] Previous page
Go to full version