Outlining the topics and areas that are covered in the WJEC Computer Science Unit 1 book but condensed down for revision purposes. Gives an 'at a glance' outline of each topic area that can be used to top up pupils revision and jog their memories for last minute revision.

This is a completed spreadsheet model for WJEC Unit 2 Controlled Assignment Task 6 - Modelling example for the School Quiz, and the documentation to go with it. <br /> It contains all the the required processes and success criteria in terms of Basic and Advanced skills that pupils need to show according to the mark planner for this unit. Including:<br /> Modelling - Task 6 (14 Marks)<br /> 1. Create a spreadsheet model to enable the Head of Year to:<br /> ~ Store details of quiz members in year 7 and Year 8;<br /> ~ Store the answers given by each pupil to the quiz questions as a, b or c.<br /> 2. Your spreadsheet must be able to:<br /> ~ allocate the points awarded for each individual answer for each pupil;<br /> ~ add up the total points for each pupil;<br /> ~ add up the total points for pupils in each different year group.<br /> 3. You must produce a suitable sorted list of all pupils, with the total points in descending order.<br /> 3<br /> 4. You must produce a graph of total points for each pupil.<br /> 5. The spreadsheet should compare the total points for each year group and automatically output a message saying which year group had the most points, and won the competition.<br /> 6. Include any features you think will be helpful to the Head of Year in using the spreadsheet to calculate totals or display results.<br /> • Complete the spreadsheet using basic and advanced skills.<br /> • Check it for accuracy or implausible data.<br /> • Screenshot or printout the whole of your spreadsheet in data and formula view (Only for paper submissions).<br /> • Write an explanation of the data, formulas, functions or any other features you have used.<br /> Task 7 (2 marks)<br /> Use this spreadsheet to do at least two ‘what if’ investigations.<br /> (i) One of your ’what if’ investigations may just change an item of numerical data. You must describe the purpose of your investigation and what was the result of your investigation.<br /> (ii) The other ‘what if’ investigation must alter an existing formula. You must describe the purpose of your investigation and what was the result of your investigation.<br /> Communicating information (2 marks)

This resources is part of the Unit 2 coursework Databases section on Information Handling. There are 10 video guides with step by step instructions on each database technique pupils have to apply to achieve the marks for this section of the Unit and documentation which outlines the techniques needed and shows screenshots and commentary on the following:<br /> Importing Data from and external CSV file.<br /> Adding extra fields<br /> Use of logical operators and at least one wild card.<br /> Added validation technique<br /> Forms<br /> Reports<br /> Adding and Sorting<br /> Queries<br /> <br /> <br />