- Messages
- 214
- Reaction score
- 32
- Points
- 38
We are currently struggling to cover the operational costs of Xtremepapers, as a result we might have to shut this website down. Please donate if we have helped you and help make a difference in other students' lives!
Click here to Donate Now (View Announcement)
Okay, I got it. Thanks.you shud have it like this. Check out the mark scheme for the 2011 paper (im not sure which one)
Do you have any idea how much marks the MS EXCEL portion was of ICT Practical Paper 31 M/J 12?Al-salam 3alekoum w ra7mat Allah w barakatoh
i made this thread with the purpose of helping people, i noticed that many people in my school, here in the community, have so many difficulties in solving ICT practicals, and also the Theory part, so if u got any probs, dont hesitate in posting it write here, u will find the solution soon
If anyone has a problem in solving a whole practical past paper ... i will solve it with him and i will use MSN for chatting with each other and another program called Teamviewer to interact with each other ... dont panic in contacting me at all ... i will be available at anytime ... i have the answer for each question u have my email is [email protected]
I just did this today. Follow this:please i need help with this question ( http://www.xtremepapers.com/papers/CIE/Cambridge IGCSE/Information and Communication Technology (0417)/0417_s09_qp_2.pdf )
# 46 )
___
Produce a new report which:• shows a summary of the week 37 sales onlyi places a 37 under criteria• uses only the Staff and Income fieldsonly tick those two fields• calculates the sum of the Income field for each member of Staffin the total row for income, select sum• counts the number of holidays sold by each member of Staffnow here , as what the access guide says, (http://www.igcseict.info/practical/dbase/index.html) at least one field must have group by, but we are only using two fields and both have a requirement so instead of keeping it as group by, must i just set it to count?HELP!!!
This method works for all kinds of summary questions. Remember:thank you!!! so can i use this whenever i wanna group / find the total sum?
got it! thanks ! =DThis method works for all kinds of summary questions. Remember:
1. You will have one field which you will not do group by. Eg: Staff field
2. You will have 2 or more fields where you will do the "group by" technique.
oh thanks that is much easierwat i did was copied the picture to powerpoint (yes, powerpoint). Then clicked the picture, went to format and then "recolour" and made it black and white. There u go~! then you right click, select the option "save as picture".
did u sort it properly?I have got another question. In MJ 10, q 41. I got a different answer from the mark scheme. You can see from the records of the Airush.
I repeat this step many times but I still got a different answer.
helloo i is in need of help
oh my lord i don't know what's going wrong here !
View attachment 7342
i'm doing question number 44 ( http://www.xtremepapers.com/papers/CIE/Cambridge IGCSE/Information and Communication Technology (0417)/0417_s09_qp_2.pdf )
annndd i did the sort and that's what's causing this error. frustrating
i tried removing the sort for staff and a whole lot of other things but i cant figure it out
*EDIT
i just tried changing the yes to -1 , it worked but it's not sorted properlyy =[
i only get the answer matching the marking scheme if i only sort date WITHOUT staff :O
i actually asked other people and they told me this solution is better than the other cuz some might get confused up with the code so the told me to do that step
EDIT
This way is the best and my other way is also correct but when i asked today again the Mr told me that they might not accept it so be on the safe side don't take a risk plz. Gregway, do this way way better !!!!!!!
wen typing Yes for the tour, dont put quotations and do the sorting when making the report, not in the query
The no repeat thing doesnt work for me. :/ It still tiles up.
I already formatted as DMY while importing it. It still didn't work. The final database is stillM/D/Y
How about checking the examiner report? They might have commented about that.
Where can I find the examiner's report?
thanks ! :O
but for the sort thing ,, same result happens as before :/ it's the other way around compared to ms, in ms the date is sorted but not the staff (http://www.xtremepapers.com/papers/CIE/Cambridge IGCSE/Information and Communication Technology (0417)/0417_s09_ms_2.pdf )
tnx a lot Gergawy
when we import a file in access, if there is a field like cost or price, then which data type do we select (while importing)? currency? numeric? or double?
btw what does double actually mean?
what does "flip the image" means? how to do it?
Gregawy, I got the method to change the format of the date.
Control Pannel -->Region and Language---> Change date format to English( United Kingdom)
its where all the other papers are and it has "er" in the file name.. here u go, this is what teh examiners said:
"Questions 38 and 39 – set up a database field structure and import data
The evidence of the field structure was generally provided and correct. The formatting for the Price field was
always checked on the relevant report to see that it was correctly applied in two decimal places. It was noted
that some regional settings would not (in a simple way) enable correct import of date data in the format
day/month/year if date format was expecting month/day/year. In this case dates past the twelfth of the
month would not be recognised or imported, leaving blank data in the date field for a large number of
records. To alleviate this difficulty, CIE prepared and made available, alternative source files in which the
data was formatted for month/day/year, notifying Centres of this arrangement. Some few candidates did
import the data with date errors and allowance was made for this when noted by an Examiner in the reports."
Sorry fo rteh late reply. Btw teh alternative source file is nbook1.
i really need hlp in doing IF function in Excel in oct/nov2011 session
ohh no they actually ask you to remove the yellow colour in such a way that the picture is white and black
what you have to do is set the saturation to -100 and then use the enhance colour option
wat i did was copied the picture to powerpoint (yes, powerpoint). Then clicked the picture, went to format and then "recolour" and made it black and white. There u go~! then you right click, select the option "save as picture".
Hey guys, in MJ 10 Paper 2 q4. It asked:
Save and print the entry in your address book. (This may be a screenshot to show that you have added the contact to your address book)
Is this the correct screenshot.
you shud have it like this. Check out the mark scheme for the 2011 paper (im not sure which one)
I have got another question. In MJ 10, q 41. I got a different answer from the mark scheme. You can see from the records of the Airush.
I repeat this step many times but I still got a different answer.
Do you have any idea how much marks the MS EXCEL portion was of ICT Practical Paper 31 M/J 12?
Thanks
please i need help with this question ( http://www.xtremepapers.com/papers/CIE/Cambridge IGCSE/Information and Communication Technology (0417)/0417_s09_qp_2.pdf )
# 46 )
___
Produce a new report which:• shows a summary of the week 37 sales onlyi places a 37 under criteria• uses only the Staff and Income fieldsonly tick those two fields• calculates the sum of the Income field for each member of Staffin the total row for income, select sum• counts the number of holidays sold by each member of Staffnow here , as what the access guide says, (http://www.igcseict.info/practical/dbase/index.html) at least one field must have group by, but we are only using two fields and both have a requirement so instead of keeping it as group by, must i just set it to count?HELP!!!
I just did this today. Follow this:
1. Make a new Query
2. Add the field Staff and Income field
3. Add the Week field, but make it not show. The criteria should be 37
4. Then do the group by method for Income. Choose SUM
5. To count the number of holidays, add the field "Number" then make it COUNT.
6. Run the query, you shall get the correct query.
thank you!!! so can i use this whenever i wanna group / find the total sum?
This method works for all kinds of summary questions. Remember:
1. You will have one field which you will not do group by. Eg: Staff field
2. You will have 2 or more fields where you will do the "group by" technique.
got it! thanks ! =D
When making a label. how can I display the field names for each label?
oh thanks that is much easier
how to prevent the background from tiling????
Yo bro how to prevent tilting??
did u sort it properly?
I have written paper 2-----but i have no idea of any program on paper 3 (excel, HTML and power point) i will appreciate if someone can volunteer to help me-i have paper 3 exams on 2nd may......please help
this is very urgent i really hope someone can help me o/n 2011 p3 excel the last step please
http://www.xtremepapers.com/papers/CIE/Cambridge IGCSE/Information and Communication Technology (0417)/0417_w11_qp_3.pdf
For almost 10 years, the site XtremePapers has been trying very hard to serve its users.
However, we are now struggling to cover its operational costs due to unforeseen circumstances. If we helped you in any way, kindly contribute and be the part of this effort. No act of kindness, no matter how small, is ever wasted.
Click here to Donate Now