Unit 3 Controlled Assessment - The School Trip....
Recap from last term...
1. Listen to the Tudor House. If it does not work right click then save target as (from Internet Explorer then treat mp3 file like any othe music file to play). In a Word document, list what tasks could be attempted using a Word Processor, Spreadsheet & Database. Read the AQA booklet (<@KES only or via your email). Everyone should select a different trip. The trip is for one day only but can be from any part of the North road site school. It could be a departmental trip you went on in the past or one that is planned for year 11 or the sixth form. Everyone must have a unique trip. Consider the "sequence" of the planning activities. What comes first - Lists of names from the school database or will they be typed in, letters home (with a reply / data capture form to update the database) or a model of the accounts or a promotional entry on the school's website / poster around the school? Try to speak to a teacher who runs the trip and ask them for details of what they do? It might be worth taking a mp3 recorder to record it - does your mobile phone do this - ask the teacher first though!
2. Planning and Skills - What skills do you need that you do not presently have? Mailmerge to send the letters home? What else? Are there "lessons" on this site to help you? Is there a demo that you need? As for Planning where will you get all the costs from, the pupil details the promotional information etc. Try to create "Prototypes" of your solution - This will help to complete the formal design at the start of next term.Homework: To help you can download an "extract" (watch the lesson) of details from the main "school" database - Why is this data false? What data is missing that might be helpful to you? Optional subjects for Y9 and above? There is an updated testdata file with optional subjects that you may use. Is there anything else needed?
3. With reference to the AQA booklet (<@KES only & via email) and Milestones and Risks. Write your own plans for Milestones and Risks, some of the earlier documents can be cut and pasted into this more formal write up document. You are urged to use the table method as in the example. Continue experimenting (Prototyping) with potential "Methods" and Solutions for all of your tasks. Watch the 2003 version of mailmerge...Part 1 & Part 2.
Autumn 1: Recap of Unit2 Results - based on 2011 old spec. Y10 Coursework > Y11 Final grade... all A or A*'s end up with a A* - All B's ended up with an A grade There were no C's, but the 2 D grades went on to a C and a B! This is not automatic, but a sign of how realistic it is to raise your standard and set your target in Y11! Time Management is the Key factor - which you experienced with the Y10 Controlled Assessment!
Watch and then setup your file, folder and backup strategy - Watch and attempt a Mailmerge in Office 2010.Homework: To ensure you have completed both of these tasks.
You will be given a wallet folder with dividers. You should printout all of your work (including "blank files with Header details" and organise it into your Wallet folder. The dividers are to help you, but as they have been provided they cannot be submitted - you should have at least 1 piece of paper after every divider! If you want dividers to be submitted then you should add your own. The "dividers" provided will be used for comments by your teacher - you should add a date and filename to the reverse side every time you make a change, with a small comment about the "new" version! For Section 1d produce a screenshot of you files within every folder before printing. Homework: To ensure you have all pages printed and submitted.
i. You should now follow through part 2 in the order of your own "Milestones". The first is 2a (Collection of Information). For each Milestone, write what information you need to successfully progress. This maybe lists of ??? with even the fields of information stated, Images for...., even the "raw" text for any emails or letters or other paper based documents that you will need to create. Once you have listed all that you need to collect actually gather the information and store it. Update 1d on Managing you files including and Update and backup of your files which you should now do at the end of every lesson! You also need to keep a log of what you are doing in the 1c section on Progress - start this. You will be asked periodically to update the printouts in the folders. Have a look at the grade C sample on section 1. Homework: Spend the allotted time on adding to the sections above, but ensuring you have printouts to add to you wallet folder before next lesson.
ii. Extend section 2a (Collect Information) so that you describe and clearly explain alternative ways of "Collecting the Information", for all milestones in order to gain higher marks. If you need a list of details, either for working out accounts or contacting to send information. Does the list already exist or not? If not then you will need a questionaire or reply form. If it does exist is it on paper, from which it could be typed in or already exists in an electronic form such as a Word processed table or a spreadsheet list or a company database. It might have more information than you need. The same will be true of any graphics - do they exist, are they on the internet or will you need to take your own - could you use a scanner or digital camera? Homework: Collect the information for each milestone and store it. Update your screenshots for Managing Storage (1d). Update 1c - your Progess log. There is now an updated testdata file with optional subjects that you may use.
iii. 2b - That is "Select Information" for every Milestone! You have looked at a range of ways to collect information for each task in the section above. Now you must clearly explain alternative ways of selecting information effectively. If it is a list (database) then you might delete surplus fields all together or omit unecessary fields from Queries and Reports. What about surplus Records... Do you delete them or use a query to filter them out? Suppose you want to send an email to all those in a school who have a cooked meal at lunch time. It is probably not a good idea to delete the other pupils. You may have collected a range of images for a poster - how will you narrow these down - quality of picture, shape (Square to wide screen), appropriateness. Homework: Complete for most of your milestones and update your progress log (1c). This will be completed and printed next lesson.
iv. 2c - Format Information. How will you format your output, both on screen and paper? That is describe and explain your choices of page layout.. the text / tables / images / numbers for every piece of output. This is best achieved through a labelled sketch. The sketch can be hand drawn or electronic (as long as it is NOT the implmented version! See pages 24-32 of the Old Sample Project If you hand draw - scan the image and add it to your file. Do add a written description (not in sample) of why you have done this - the mark scheme requires a meaning and purpose! "I have designed the title in 36pt Sans Serif font so that the reader knows what this page is about. The main text is in 10 pt serif font which is easier to read and allows me to fit all the text onto asingle page of A4 without the images to be too small. The border is there to make the certificate look more appealing." < a rough example! See also the standard letter layout and the OSA4 sample.
Much time has so far been spent planning one of the many tasks. Between now and half term carryout at least one of your Milestones (this includes homeworks).
You should continue creating Solns to your various Milestones- whilst creating take at least 5, but not many more screenshots. Describe all you have done to progress from the design Plan to the first screenshot and the development there after. Printout this commentary and your solution for each milestone. Keep the commentary in a seperate file for now - You will be advised later where to place it in your folder.
v. 2d - Modelling with Data. Not for every milestone, but at least 1 - possibly an estimate of the costs based on variable numbers! See the Grade C sample.
Target: You should aim to have all Milestones (apart from the database) complete by the start of next term. That is your cost model, advertising and letters / emails to pupils parents or the destination of the trip. Next term the focus will be to develop the database to handle all the return forms and produce whatever lists the teacher needs.
vi. 2e-
vii. 2f- The Report. Have a look at the Grade C sample.
Theory Work
Nov 3: Skim read ICT for you pages 1-14. Carefully read the hardware classification and types you are less familair with, for example Types of Computer & Sensors) - The list will vary depending on your existing knowledge.
Nov 7/8: Skim read ICT for you pages 14-22. Spend more time on the devices you are less familar with. Think who might find each device useful. Teachers / Office workers / Professional (Doctors / Designers / Publishers) / Scientists / Supermarket workers / Personal use). Some output and memory devices come in many forms such as Printers and Memory Storage.
Nov 15/17: Read pages 83-90 Validation. Apply to Unit 3 Spreadsheet Model and Database Tables. Watch Excel 2007b lesson 7 and Lesson 8 - Go back to your Unit 3 Model and add in Validation checks to both your Design and Implmentation. If complete you can add Validation checks to the tables & forms of your database. Complete for Homework.
Nov 21/24: Read Pages 101-107 Processing Data (through a database).Read 01 Data Collection and 02 Data Entry
Dec1: Read 03 Virus &
04 Data v Info
Dec 5/6/8: This week you need to read these three documents. 1 per lesson... 05 OS 06 GUI / Apps 07 Networks
Dec 13: 08 System Life Cycle
Old AQA Project-Unit 3
Sample End User Questions Evaluation User Guide Proforma User Guide: Example 1 Example 2
An Improvement Checklist
Testing: You must test both Data Entry and Processes... Tests should be grouped....
Example Data Entry (Validation / field lengths): Test of frmItem / tblItem
Into every Form entry box/field I will enter three types of data. The three types will come from my table design. As an example I will test the field date with Normal (22/08/10), Erroneous (such as a date in the future) and one on the border of acceptance (ie today’s date).
Example Process: Calculating an invoice...
Start with the Data to be used (2 examples per process) One example might be... Person's name and address, 4 of Item1(60p each) + 2 of Item2 (£1 Each) + 1 of Item3 (£7). Produce the answers and any breakdown ie £2.40 + £2 + £7 = £11.40 + VAT at 20%. The VAT comes to £2.28 so the Total is £13.68. Then add the delivery cost which is 50p per item. There are 7 Items which comes to £3.50 bringing the grand total to £17.18
Example Process 2: Test Report list of all residents of the Thornhill Estate aged over 65 in alphabetical surname order. List about 20 Start / Test records. List the expected results possibly only 3 or 4. Your Test Plan should state a pre calculated answer.
Outcomes / PC's.... Look for the following words... must / need / want / will / include / should / contain. There are numerous examples in this file.
Final Trial 2009 Analysis Master Word Document AQA-Set 2009 Assignment 2009 Analysis Answer
You can look at the AQA-set 2010 Assignment as an extension exercise.
Xmas break: Any outstanding work on the first piece of Coursework (The Database System Project) and the second piece (AQA Set Assignment). Revise weaker theory parts from the end of Year 10 Exam.
|
