• We need your support!

    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)

Search results

  1. Xenon

    Nov 2011 AICT help!!

    the question number please... and I know it's feels disappointing when you have to use the mark scheme to do the stuffs, even I did, but the important thing is to learn how they did it so that you're prepared if something like this or close to this comes in your exam
  2. Xenon

    Computers & ICT: Post your doubts here!

    check the word document... I've shown here how to create the graph in access alternatively you can do it in excel.... for that you'll need to export the query performed in excel... you might also be required to create a new table using countif and sumifs (if you are not sure how to create the...
  3. Xenon

    Computers & ICT: Post your doubts here!

    wait a bit... solution is on its way
  4. Xenon

    Computers & ICT: Post your doubts here!

    as usual, I've uploaded the file... check out the query criteria you can do Q5 in two ways... the first method is easy which includes entering the simple text "Is Not Null" in the Company field while performing the query the next step is bit more advanced... in the design view, on an empty row...
  5. Xenon

    Computers & ICT: Post your doubts here!

    ah ok, first sort the Route column in ascending order then in the table created, use the function COUNTIF and then manually enter the formula, I mean... like Route 1 starts from row 6 to 14.. taking this information, the formula set is =COUNTIF(Sheet1!$E$6:$E$14,">=5"), column E is used since we...
  6. Xenon

    AS Applied ICT helppp?

    please post the question here once again mentioning the year and paper number :)
  7. Xenon

    8701 chemistry

    you are in the wrong section of the forum... there's no chemistry 8788 over here
  8. Xenon

    Computers & ICT: Post your doubts here!

    before MID use VALUE like =VALUE(MID(##,##,##)) enter formula like this way = vlookup(value(mid(a6,3,1), ............... ) and no need to reformat the Route column, just CONVERT IT using VALUE function
  9. Xenon

    Computers & ICT: Post your doubts here!

    Your lookup is correct... no problem with that. The problem lies in the ROUTE column. The data in the column are all in text format, if I'm correct. Anyways it's pretty easy to get around this problem... just put the formula like this: =VALUE(MID(A6,3,1))... the value function converts the text...
  10. Xenon

    Computers & ICT: Post your doubts here!

    both your questions are solved over here, there ain't much of anything to explain except just putting the formula.. to see the Function Argument box, just click the "fx" button in front of the formulas... now for the graph, see the other word document hope it'll help
  11. Xenon

    APLLIED ICT Practical HELP PLEASE

  12. Xenon

    Computers & ICT: Post your doubts here!

    Yes please...
  13. Xenon

    Need mole question explanation

    yes first change the cm3 to dm3 or vice versa.. then find the number of moles of CO2 that will be produced (24/24000 = 0.001 moles, I converted 24 cm3 to dm3)... since the acid is in excess or the CaCO3 is the limiting reagent, we will be taking into account only CaCO3 for calculations. Since...
  14. Xenon

    APLLIED ICT Practical HELP PLEASE

    see if you can understand what I did over here... and for the next question (26), first select the whole table just completed and then copy. Then again select the area A5 to B13 and then right click the mouse, select paste special and then transpose (at the bottom).
  15. Xenon

    Applied ICT: Which Microsoft Office version are you using?

    I did my one with MS 2007
  16. Xenon

    a little help in physics??

    1. If you go through recent papers (2002 onwards), you won't find any questions from A2 syllabus. You might find them if you go through topical redspots but still you'll be able to filter those out 2. It won't hurt you if you go through the whole syllabus again but when you revise the syllabus...
  17. Xenon

    as level english language

    getting an A depends on but I can say that you should have this CIE endorsed book: http://www.cambridge.org/gb/educati...evel/?site_locale=en_GB&currentProject=404859 ... it's well written with comprehensive guide line on both commenting, directed writting and essay part with ample examples.
  18. Xenon

    AS Applied ICT past paper Help

    I think you asked for this questio "7 Select ONLY the resort, hotel and dates of the flights out and home for all holidays where the hotel name contains the word Lodge" I've attached a picture for thi s
  19. Xenon

    AS Applied ICT past paper Help

    I have uploaded the steps here... hope it'll solve your problem
  20. Xenon

    ICT HELP NEEDED !! (June 2011 paper 3)

    hey there, this might help you: http://www.igcseict.info/practical/web/index.html
Top