WJEC MOCK MADE FROM COMPLIATION OF PAST PAPERS
Section A[Jan 10]1. Data is often coded before being entered into a computer. This saves time typing in the data.a) Give two other advantages of encoding data before entering it into a computer. [2]…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..
(b) Encoding value judgements from a questionnaire can often lead to inaccurate results. Explain with the use of two appropriate examples why this may happen. [2x2]…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..
[jun 10]2. (a) The performance of a company has been improved by having up-to-date, accurate and complete information.Other than by aiding the decision making process, describe, using different examples, two ways in which good quality information can add value to the company. [2×2]…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..
(b) Describe two of the costs in terms of money, time and human resources in obtaining good quality information. Use a suitable, different example to illustrate your answer in each case. [2×2]…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..
[Jan 11]3. Good quality information is needed to make informed decisions. Other than accuracy, describe three characteristics of good quality information, illustrating each characteristic with an appropriate distinct example. [6]…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..
[Jun 12]4. (a) Web pages are now being produced by lots of people at home. Explain the following terms in relation to web authoring, giving suitable examples in each case: (i) Hyperlinks, (ii) Frame. [4] …………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..
b) Discuss the benefits of using HTML to design web pages. [2]…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..
[Jun 13]5. (a) Validation is very important in modern data processing systems. (i) Define what is meant by the term ‘validation’. [1]…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..
(ii) Using an example, name and describe, a validation method that could be used in a student record keeping system. [3]…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..
(b) Other than the data itself, describe four factors that could affect the efficiency of data processing systems. [4]…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..
[jun 14]6. People and organisations are very concerned about the increasing use of computers for criminal purposes. Name two Acts and for each describe a concern and how the legislation has been used to try and address it. [2×3]…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..
[jan 13]7. Expert Systems are widely used in medicine. State the three main components of every expert system and describe the advantages and disadvantages of using an expert system in medicine. [8] …………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..
[jan 14]8. Describe four distinctly different uses of ICT for home entertainment. For each, describe specific advantages and disadvantages. [18]…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..
Section B[jan 14]9. A design company uses spreadsheet software for financial modelling. Give two advantages to the company of using spreadsheets for financial modelling and illustrate each with a specific use. [2×2]…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..YOU MUST REFER TO YOUR OWN SPREADSHEET TO ANSWER THE FOLLOWING QUESTION. IF NO SPREADSHEET EVIDENCE IS SUBMITTED THEN NO MARKS CAN BE AWARDED. MAKE SURE THAT YOU SHOW IN YOUR ANSWER WHERE THE PROCESSES, FUNCTIONS/FORMULAS CAN BE FOUND IN YOUR SPREADSHEET. FOR EXAMPLE PAGE 6 CELL D4.[jun 14]10. (a) Describe the purpose or function of one formula from list A and two different formulas from list B, which you have used in your spreadsheet. [6]A: SUM, COUNT, MAX, MIN, AVERAGE, RANDB: Single IF, Multiple IF, DATE, ROUND…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..
[jun 15](b) Describe one macro you used in your spreadsheet, stating why you used it. [2]…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..
[jun 15](c) Describe two methods of simplifying data entry you used in your spreadsheet. [2×2]…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..…………………………………………………………………………………………………………………………………………………………..