Jtdjzrfg

Only available on StudyMode
  • Topic: Management, Assessment, Organization
  • Pages : 7 (1305 words )
  • Download(s) : 61
  • Published : January 28, 2013
Open Document
Text Preview
GCSE
4332
INFORMATION AND COMMUNICATION TECHNOLOGY
Unit 2 Solving Problems with ICT
CONTROLLED ASSIGNMENT
For submission in May 2013 or May 2014

INSTRUCTIONS TO CANDIDATES
Read the given scenario.
You will have 22½ hours to complete these tasks. Research tasks can be carried out outside timed conditions.
It is important that you work independently from other candidates and make sure that what you hand in is your own unaided work.
Read the tasks carefully to make sure that you understand what is needed. Refer to the marking guidance for each task to help you.
Carry out all tasks and make sure that you check your work carefully to ensure that the work you produce is accurate and correct.
Save your work regularly.
INFORMATION FOR CANDIDATES
Teachers and students will be required to sign a declaration that all work presented is the work of the candidate alone. Failure to authenticate the work may result in grades being delayed or refused. The quality of written communication will be assessed in your evaluation.

Organising a charity fundraising day
A charity wants to raise awareness of its work and to raise funds. The charity is organising a fund raising day and wishes to advertise the event and get sponsorship from local organisations. The organisation which gives the most money will be given free tickets. The organisers want to develop an ICT based system to help them manage all aspects of the charity fundraising day. In order to prepare for this you have been asked to:

(i) produce a screen-based presentation to advertise the fundraising day which could be uploaded to a website or be displayed in a public place.
(ii) import a datafile with contact details of local organisations and add suitable extra fields in order for this data to be used in a mailmerged newsletter.
(iii) produce a mailmerged newsletter to send to local organisations asking for sponsorship. (iv) produce a model showing how computer software could be used to help in organising the charity fundraising day.

You must undertake the following tasks to research, design and implement an ICT system to enable organisers to manage the day.
MAKE SURE YOU REFER TO THE MARKING SCHEME FOR EACH TASK TO ENSURE YOU CAN GAIN AS MANY MARKS AS POSSIBLE.
Organise and store this information in a suitable folder structure (5 marks)
Task 1
You must organise your work so it is easy to find and use suitable folders and file names. Ensure your work is backed up appropriately.
Research
(6 marks)
Task 2
Collect information including pictures about the charity and about potential types of activities or performers who could help raise money on the day.
Keep a log and evidence of your sources of information and store this information in appropriate folders. You may use online and non electronic methods of collecting data. Data Handling
Task 3
(12 marks)
Create a data file of local organisations for the charity to contact. In order to do this you must complete the following:
(i)

import the ‘Organisations’ file your teacher will give you into a database.

(ii)

add a suitable key field.

(iii)

add up to four additional sensible fields with suitable varying data types (at least 2 other than text).

(iv)

add a suitable validation technique to at least one of the fields in this database.

(v)

add details of any two sensible records to the existing database.

2

Task 4
Use your data file to:
(i)

sort the database in ascending order of name to make it easier to find an organisation’s name.

(ii)

show the validation technique works.

(iii)

search for and save a list of all organisations in Cardiff, so the organiser can visit them in person.

(iv)

search for and save a list of organisations in Bridgend that have previously helped the charity in order to ask them to get involved in the event.

Task 5
Using advanced skills, implement four improvements to your database.

(4 marks)

Communicating information
(2...
tracking img