A2 Ict Coursework Wjec

WJEC AS/A2 Information and Communication Technology Level 3

What you'll study

You will learn to use both software and hardware applications. You will study the following::

AS Level

  • Information systems (IT1)
  • Presenting information (IT2)

A Level

  • Use and impact of ICT (IT3)
  • Relational databases (IT4)

The AS and A Level ICT courses, normally delivered as part of a full time programme of study, are offered during the daytime, spread over three days. They are therefore, also suitable for those who wish to take a single subject and are able to attend at varied times during the week.

What's expected of you

Full commitment to attendance is required. Respect for others, enthusiasm for the subject and self motivation are the essential qualities we expect to see in all our learners. You will be continually assessed and there is an expectation that you will continue your studies and coursework during your own time.

What qualifications you'll achieve

  • AS Level Information and Communication Technology
  • A Level Information and Communication Technology
  • Skills activities
  • English and Maths

How you'll be assessed

The course is a combination of written papers and coursework.

What you can do next

The course provides useful skills and knowledge to complement a wide range of subjects. However, students who wish to proceed to higher education to study computing or computer science are recommended to study A Level Computing.

Entry requirements

Minimum of 5 GCSEs at grade C or above including English

Where can I study WJEC AS/A2 Information and Communication Technology Level 3?

Call 01495 333 777 to apply today

EPAS0128A1

Blaenau Gwent Learning Zone
(Part Time Day)

Start Date: 03/09/2018

Start Time: 09:15

End Time: 16:30

Call 01495 333 777 to apply today

CFAS0128A1

Crosskeys Campus
(Full Time)

WJEC have produced an updated (26.03.09) Teachers’ Guide for AS and A Level.  I’ve lifted out part of the the section clarifying the spreadsheet work from Unit 1:

The context for the task in 2009/2010 is ‘business modelling’.  Care must be taken to ensure an appropriately demanding task is undertaken which addresses the features listed below.

Candidates will be given credit when providing practical evidence from their task to support their answers in the written examination. Candidates should produce a spreadsheet workbook which contains evidence of;

• worksheets showing labels, data, formula

• multiple sheets and the use of 3D referencing between them

• lookup or vlookup or hlookup tables

                drop down list boxes

                spinners for data entry

                logical True or False or Tick Boxes or Option boxes

• startup user interface

• validation techniques and error messages produced

• sorting techniques

• Search for specific criteria

• Control buttons should be used to initiate macros.

• Appropriate use of graphs such as bar or column graphs, line graphs, pie charts, scatter graphs, pictographs

Candidates should be familiar with the following formulas / standard functions:

A

B

SUM
COUNT
MAX
MIN
AVERAGE
RAND
SINGLE IF
MULTIPLE IF
DATE
ROUND

and should include evidence of at least two formulas or standard functions from list A and two from list B in their workbook.

Simulation Modelling

Candidates should understand and be able to discuss the following;

• Definition of a simulation model.

• Uses of simulation modelling for weather forecasting, car crash analysis and financial forecasting.

• Advantages and disadvantages of using simulation models.

• Issues relating to hardware used for simulation modelling, including parallel and distributed processing.

Page 15 of the Teachers Guidance focuses on the type of questions which could be asked of the Spreadsheet Modelling task and Pages 16 – 22 shows an example of the evidence students should produce.  Today in class, we are going to look at this exemplar and check off all the elements which your completed projects should include.

Filed under: AS ICT | Tagged: modelling, Spreadsheets | Leave a comment »

0 thoughts on “A2 Ict Coursework Wjec

Leave a Reply

Your email address will not be published. Required fields are marked *