GCSE ICT Extended Project Statement of Problem and Analysis[10 marks] Title and Background [ 2 marks] Analysis of Current system must include 2 of either questionnaire ,observation of system, review of documents or interview. You should also discuss how data is collected, stored ,accessed, what information is used for[4marks] Problems and Limitations [2 marks] Aims and Objectives[2 marks]
Design of Solution[12 marks] Alternative Methods ( discuss for each aimadvatage /disadvantage manual /computerised)[1 mark] Software to be used for each task and why[1 mark]
Database designs [3 marks] Data capture form - Word or Publiher [1 mark] Data structure ( field names, types and validation) [1 mark] Validation techniques must be 3 different example[range, presence,type etc[ 1 mark]
Spreadsheet designs [3 marks] Hand drawn sketches of spreadsheet showning all key formula and graphs(state purpose of graph) [2 marks] Explantion of formulas to be used [1 mark] Communicating Information designs [3marks] Hand drawn sketches of each of your designs for presentation, leaflet etc showing features and advanced features[3marks] Dataflow(Mail Merge)[1 mark] Draw designs for Mailmerge showing each document involved state reason for MM[1 mark]
Development of Solution[30 marks] Database Implementation [8 marks] Create database 15-20 records[2 marks] Variety of field types 3 different types [1 mark] Test Plan which carries out at least 6 tests (see test plan in extended project writing guide)[3 marks] Evidence of testing - screen shots of each test [2 marks]
Spreadsheet Implementation [8 marks] Print outs of spreadsheet in formula and data view [1 mark] Checked plausability of results , show you have checked results write on sheets[1 mark] Test Plan which carries out at least 6 tests (see test plan in extended project writing guide)[3 marks] Evidence of testing - screen shots of each test [3 marks]
Communicating Information [8marks] Evidence of producing first presentation (show good and basic ie with spelling mistake for Powerpoint show 2 electronic elements ie sound and image from internet plus 1 adanced feature eg transition[ 5 marks] Evidence of producing second publication (show good and basic ie with spelling mistake for Leaflet with 1 electronic element ie clip art and 1 advanced feature bullet point or table[ 3 marks] Dataflow Implementation[2 marks] Print out of mailmerge template with merge names [1 mark] Print out of merged document [1 mark]
User Documentation [4marks] Describe system yo need [1 mark] Describe security you have [ 1mark] Describe how to use each feature include Mailmerge description [2 marks]
Evaluation [8 Marks] Review of Objectives [1 mark] Review of Database [1 mark] Review of Spreadsheet [1 mark] Review of Communicating [1 mark] Improvements/Modification [2 mark]
Conclusions [2 marks]
Total Marks