Hey there! Sign in to join this conversationNew here? Join for free

CCEA GCE Applied ICT: Unit 2 Software Applications & Tools Exam 2016 Watch

    • Thread Starter
    Offline

    0
    ReputationRep:
    Hello,

    Wondering if anyone has completed this exam as schools who are doing CCEA GCE Applied ICT can choose any day this week to hold the exam and my school is doing it on Friday. If anyone has done the exam could you please tell me what is coming up on the four sections (Spreadsheet, Database, Word Processing and PowerPoint) of the exam, this would be a great help, e.g. Task SS1 is copying and pasting data into another sheet, Task SS2 is using VLOOKUP to show information on another sheet etc.

    Many Thanks.
    Offline

    0
    ReputationRep:
    Have heard that it is pretty straightforward. There is no IF statement apparently
    Offline

    0
    ReputationRep:
    Also doing it on Friday, any help would be great
    Offline

    0
    ReputationRep:
    Doing it tomorrow morning, any tips?
    • Thread Starter
    Offline

    0
    ReputationRep:
    I've actually heard from two reliable sources what is going to be asked on the paper.

    Database Questions:

    - There will be a one-to-many relationship involving the "Service" and "Type" table.
    - There will be a validation rule on "StartTime" within the "Consultation" table.
    - Form with a sub-form (with sort)
    - Query with totals

    Spreadsheet Questions:

    - Chart
    - Totals Formula
    - Tax with absolute cell referencing.

    Word Processing Questions:

    - A mail merge
    - Create a hierarchical diagram using SmartArt

    PowerPoint Questions:

    - 5 slide PowerPoint
    - Disk Defragmentation explanation
    - Date/Time needs to be included
    Offline

    0
    ReputationRep:
    The MM1 asks you to explain the importance of defragmentation, date and time however the other one I cannot remember
    Offline

    0
    ReputationRep:
    Please guys, if anyone sat this already could you tell me some of the questions and some tips? Im sitting it tomorrow, Thanks!
    Offline

    0
    ReputationRep:
    Anyone who has done the test, please could we have hints or tips? Would greatly appreciate
 
 
 
  • See more of what you like on The Student Room

    You can personalise what you see on TSR. Tell us a little about yourself to get started.

  • Poll
    Would you like to hibernate through the winter months?
  • See more of what you like on The Student Room

    You can personalise what you see on TSR. Tell us a little about yourself to get started.

  • The Student Room, Get Revising and Marked by Teachers are trading names of The Student Room Group Ltd.

    Register Number: 04666380 (England and Wales), VAT No. 806 8067 22 Registered Office: International House, Queens Road, Brighton, BN1 3XE

    Quick reply
    Reputation gems: You get these gems as you gain rep from other members for making good contributions and giving helpful advice.