In this unit a scenario will be put forward regarding setting up a school dating agency - and then information collected, interrogated and appropriately presented. A focus will be the accurate and efficient collection and processing of data.
I have produced ……
I have explained …….
I have shown that I ……
A questionnaire suitable for collecting data.
A set of accurate data, using a variety of techniques to check for errors.
Documentation suitable for a given audience.
An evaluation of the project.
How my questionnaire has been designed to be accurate and efficient.
The techniques used to check the data for possible errors.
The key points in making my invitation suitable for a teenage audience.
The advantages of using ICT and possible improvements in my work or system.
Can select the information I need for different purposes, check its accuracy and organise it in a form suitable for processing.
Can interrogate data using a variety of techniques to present the information in different forms for specific purposes.
A data collection system that uses validation techniques.
Results from interrogating the data using complex searches.
The validation techniques used and how they limit errors.
The techniques used to produce my evidence.
Can use complex searches
Use a range of ICT tools in an integrated and efficient manner.
Some pupils may have worked very independently and reached this stage. They will typically have worked well in advance of other pupils, showed a level of innovation by using software independently (creating on-line forms, using new software), completed extension activities and used feedback to refine and improve their work.
Some may have produced a similar project within another subject area but followed a similar process proving their capability to work independently.
Some pupils may not have completed the full project but have shown that they are aware of the need for accuracy, understand the need for care when framing questions, can find some relevant information from data sets, can present their findings with some awareness of audience and can compare the use of ICT within this project with ‘pen and pencil’ methods.
Complete the Data Protection Act Worksheet (below)
Data Protection Act
The use of computers for storing and processing information has brought many advantages for organisations that work with data eg.Doctors, Police and the Tax Office.
Your privacy might be affected by the use of a computer to store information about you.Imagine - if all of the information stored about you by different companies could be put together to form a complete portfolio about you - how much money you earn, what health problems you have, who your friends are, what clubs you are members of, if you have ever failed to pay any bills or if you have ever been in trouble with the Police.They could also sell this information to other people.It may be easier for unauthorised people to gain access to this information when it is stored on a computer, unless it is being kept securely.To protect our privacy a law called the Data Protection Act (1998) was introduced.
There are 8 principles of Data Protection.These are:
The data must be collected and used fairly and lawfully.
The data must be collected only for lawful purposes.
The data must be used only for the registered purpose.
The data stored must be relevant to the purpose for which it was collected.
The data stored must be kept accurate and up to date.
The data stored must be kept no longer than necessary.
The data must be kept secure.
The data must not be transferred to countries that do not have suitable data protection laws.
Sometimes data is exempt from the Act - it doesn’t apply.The exemptions are:
·Personal data held for home use or recreational purposes.
·Information which can not be disclosed for reasons of national security.
·Information relating to a crime
·Information regarding taxation
1.Do you think anyone should be able to keep a data file about you and your family? Why?
2.Do you think that your school would keep the same details as the hospital or the membership file at a fan club you belong to? Why?
3.Name ONE of the data protection principles
4.Copy the table below and write down 4 places where you think data is held about yourself on a computer.List the kinds of information that might be held, eg. name, address.
Find a selection of flyers that are aimed at a specific target audience. They can be for any purpose (takeaways, double glazing etc.). For each, please state the design elements used, as we as the intended audience.
Created By Mr Rochford(SSS1_R.J.Rochford)
Find a selection of advertisements for hardware products that are aimed at a specific target audience. This can be in print (newspapers, magazines, etc) or online. For each, please state the features highlighted and the implied benefits, as well as the intended audience.
Created By Mr Rochford(SSS1_R.J.Rochford)
Week 1-Complete the 'System Overview' that was started in lesson.
Week 3-Design your Field Structure Tables for the 3 tables using the template below:
Week 5-Design the 'Patient Search' & 'Staff Search' queries on paper or using word processing software. Please ensure that you include all relevant field names and the search criteria.
Week 7-Complete a list of 5 items that you would like the Medical Centre staff to be able to search for using the database. (Example: A search for patients who have an allergy and live in the BL1 postcode area).
Week 9-Design the User Interface (Main Menu) of the database on plain paper. Please ensure you include the purpose of each command button.
Week 11-Define the following keywords in the context of databases: Table, Query, Form, Report, Field, Validation, Input Mask.
Week 13-Self-evaluate your database by writing an extended piece of writing (at least 200 words) on how you have createdyour system (include screenshots where necessary).