• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month
Page
  1. 1
    1
  2. 2
    2
  3. 3
    3
  4. 4
    4
  5. 5
    5
  6. 6
    6
  7. 7
    7
  8. 8
    8
  9. 9
    9
  10. 10
    10
  11. 11
    11
  12. 12
    12
  13. 13
    13
  14. 14
    14
  15. 15
    15
  16. 16
    16
  17. 17
    17
  18. 18
    18
  19. 19
    19
  20. 20
    20
  21. 21
    21
  22. 22
    22
  23. 23
    23
  24. 24
    24
  25. 25
    25
  26. 26
    26
  27. 27
    27
  28. 28
    28
  29. 29
    29
  30. 30
    30
  31. 31
    31
  32. 32
    32
  33. 33
    33
  34. 34
    34
  35. 35
    35
  36. 36
    36
  37. 37
    37
  38. 38
    38
  39. 39
    39
  40. 40
    40
  41. 41
    41
  42. 42
    42
  43. 43
    43
  44. 44
    44
  45. 45
    45
  46. 46
    46
  47. 47
    47
  48. 48
    48
  49. 49
    49
  50. 50
    50
  51. 51
    51
  52. 52
    52
  53. 53
    53
  54. 54
    54
  55. 55
    55
  56. 56
    56
  57. 57
    57
  58. 58
    58
  59. 59
    59
  60. 60
    60
  61. 61
    61
  62. 62
    62
  63. 63
    63
  64. 64
    64
  65. 65
    65
  66. 66
    66
  • Level: GCSE
  • Subject: ICT
  • Word count: 8465

GCSE Excel Project ICT

Extracts from this document...

Introduction

Checklist for Spreadsheet Project ALL THESE MUST BE USED AS HEADINGS IN THE PROJECT Title Page Jack Jones, Custom Made Computers and Parts by WARLORDTF using Microsoft Excel 2007. Identify (5 marks) Background Details, Identifying the user The user is the owner of a computer construction and maintenance shop, which runs under the name of WARLORDTF. WARLORDTF is a shop, which makes computers and performs maintenance on all computers whether they are Windows or Mackintosh. The Specialist, Alex Heather owns the shop and manages it on his own. Currently he has 5 business contracts for his computers and approximately 35 Private customers a week. When business purchases are made, they are treated almost like private purchases. He gives them a piece of paper with each of the specifications of all the components the person then specifies the components and then Alex checks his stock and checks what he has to order then informs the business customer that they will be in stock and then writes down the order and files it into his folder. The customer then pays for the product and informs Alex of times they are available to collect. After the customer has left and he has closed shop, Alex then checks his inbox and constructs the computers to the specifications to the inbox sheets after the computer has been built he moves the sheet of paper that was in the folder to the top of the pile. Next day, when the shop opens he checks his Folder and calls the customer to inform them that they must collect their computer. They collect the computer and the sheet that is currently in the folder is moved into an archive. The archive consists of another folder, which has all of the previous customers' orders. Statement of the problem Currently Alex is using a paper-based system where all the information is stored on paper and handwriting. ...read more.

Middle

in D7 Pass Warlordtf1 Go to sheet1 select insert value '11' in D7 Pass Warlordtf10 Go to sheet1 select insert value '13' in D7 Pass Warlordtf5 Go to sheet1 select insert value '12' in D7 Pass Warlordtf500 Go to sheet1 select insert value '9' in D7 Pass Warlordtf750 Go to sheet1 select insert value '10' in D7 Pass WarlordtfGC10 Go to sheet1 select insert value '6' in D13 Pass WarlordtfGC1TB Go to sheet1 select insert value '7' in D13 Pass WarlordtfGC1 Go to sheet1 select insert value '4' in D13 Pass WarlordtfGC2 Go to sheet1 select insert value '5' in D13 Pass WarlordtfGC5TB Go to sheet1 select insert value '8' in D13 Pass WarlordtfGC900 Go to sheet1 select insert value '3' in D13 Pass WarlordtfRAM10 Go to sheet1 select insert value '5' in D10 Pass WarlordtfRAM5 Go to sheet1 select insert value '4' in D10 Pass WarlordtfRAM5TB Go to sheet1 select insert value '6' in D10 Pass WarlordTFSP Go to sheet1 select insert value '4' in D4 Pass Drop Down Boxes Expected Result Predicted Result None Present Medusa Present XP Home Edition SP3 Present Vista Ultimate Present Vista Premium Present Vista Basic Present Mackintosh Present IF Formula Expected Result Predicted Result IF: None Produce: None Present IF: Medusa WarlordTF Present IF:XP Home Edition SP3 Produce: Microsoft Present IF: Vista Ultimate Produce: Microsoft Present IF: Vista Premium Produce: Microsoft Present IF: Vista Basic Produce: Microsoft Present IF: Mackintosh Produce: Apple Inc. Present IFERROR Formula Expected Result Predicted Result IF ERROR If the figures are appropriate then the calculus is done and if there is an error, returns an error. Present Calculus Expected Result Predicted Result Total E3+E4+E5+E6+E7+E8 = �16,765 Correct Objectives Expected Result Predicted Result Actual Result Objective 1 Backup Correct Objective 2 Print Off Correct Objective 3 Modify The FinalTBL Correct Implement (12 marks) Brief description of how the design was implemented explaining any changes that were made to the design First, the sheets are created, by right clicking the bottom taskbar and selecting ...read more.

Conclusion

this would enable the customer to view the product they are going to buy. Also, another issue I have found is unfortunately, because the computer uses office 2007 and the file is saved as a macro-enabled 2007 document, as commands and operands are added into Office 2007 are not functional with earlier versions and if this file was to be opened in 2007 many of the formulae would not work. User feedback in the form of a letter or questionnaire. The letter is inserted after this page. Jack Jones 44 Manor Road Walsall West Midlands WS2 9PU Friday, 24 April 2009 Dear Jack, I am writing this letter to thank you for your expert construction of the shops spreadsheet invoice. However, I feel there would be some improvement if some items were added. As my stock can fluctuate with production, supply and demand, I would like a stock number which can be updated as stock comes in and as a customer chooses the part the value decreases by one. Also, I may need to add operating systems as Microsoft are bringing out a new OS, Windows 7. Can I have a button which can add values to the drop-down box? Those are the only additions I feel are necessary at this stage. Many Thanks in Advance, Mr. Alexander Joseph Heather WARLORDTF Evidence that you understand the user's comments by making suggestions for future improvement The stock number would be hard to set but I could set a cell and forbid an item being selected if it were to cause the cell to go into negate figures. Also, a macro can be created to reset all of 'stock values' as Alex could maintain his stock at 20 and order accordingly (the figure 20 is approximate as I am not sure how components he may use). The macro for the drop down box I feasible as a macro can be recorded to take the text value from a cell and copy (or cut) it into the validation source box. ...read more.

The above preview is unformatted text

This student written piece of work is one of many that can be found in our GCSE ICT Systems and Application section.

Found what you're looking for?

  • Start learning 29% faster today
  • 150,000+ documents available
  • Just £6.99 a month

Not the one? Search for your essay title...
  • Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

See related essaysSee related essays

Related GCSE ICT Systems and Application essays

  1. ICT Project - Statement of the Problem

    Data Flow Diagram ( Level 1) The following diagrame illustrates in outline the process of documenting deliveries, invoices and payments. Objectives of the new system: The system must perform the following functions: * Allow staff details required to be changed and edited quickly and accurately; * Work out the not

  2. Different types of technology How I use ICT at home and at school

    The ability to share files is also extremely useful. If I really need a song and my friend has it, he can use MSN to send it to me. He can also send me other things such as photos, videos and games. If I'm having trouble with some work, he can send me an example in which would give me a clearer understanding.

  1. Creating a computer system for a video rental shop

    Going on my recommendation of a computerized system I now have to provide and recommend the hardware and software most suitable for the system. Hardware: The hardware of a machine is the physical machinery, which makes up the computer. In order to start to think about designing a system I

  2. The use of ict has changed the way in which people work. Explain the ...

    For Customers Like anonymous nature, machine cannot think if a cheque book is stolen or if they are over spending. 24 hour service is Ideal for people who work irregular hours. Parking available near some dispensers so process is quicker for customer.

  1. Mayhem Manor Project - ICT

    Wobble World, Charlie and the Chocolate FactoryTM: The Ride, Frog Hopper, Peugeot Driving School, Gallopers Carousel, Heave Ho!, Riverbank Eye Spy, Old MacDonald's Tractor Ride, There's Something in the Dung Heap, Berry Bish Bash, Doodle Doo Derby, Old MacDonald's Singing Barn and Sharkbait Reef by SEA LIFE.

  2. GCSE Calculator Project

    * The calculator is easy to use and they like the "Help" feature that I have included. * The people that use this calculator are, as we expected, beginners in the use of ICT * They all said that the text and buttons are big enough but said that the

  1. ICT PROJECT

    * Finally, the new system should not be used by anyone else except Ms Gammon, so I will make sure her system is safe by creating security code. Source Documents The source document that I have provided is a copy of marks book that Ms Gammon uses to record her student marks.

  2. Computer project Alevels

    Therefore it can be updated before the company run out of medicine items. 5.1.8.2. Macros I have used only one macro in my database. This macro is used in the login form. The design of the macro is shown below.

  • Over 160,000 pieces
    of student written work
  • Annotated by
    experienced teachers
  • Ideas and feedback to
    improve your own work