• 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. Different types of technology How I use ICT at home and at school

    For someone like me who is just a big fan of helping others, it becomes extremely useful for me. I can help out people who can't follow the instructions I gave them. This feature allows me to go out of my own way and in my own generosity and kindness

  2. Mayhem Manor Project - ICT

    * Attractions include: Cloud Cuckoo Land, Mutiny Bay, Shows and Entertainments, Extraordinary Golf, Old MacDonald's Farmyard, The Gardens and The Towers. 3. Name of Park Ticket Price Special Offer Concession Barry Island Pleasure Park Single Ticket: �1 *This only includes the entry price Multi-Buy Tickets: 12 Tickets: �10 25 Tickets:

  1. ICT Project - Statement of the Problem

    When a customer calls in to book a table the booker fills in the sheet, which include the customers name, telephone number, and what table they will be sitting at. After filling out this sheet the booker then goes on to putting the information in the bookings for the day book.

  2. GCSE Database Project ICT

    2 CPU 6300 @ 1.86GHz (2 CPUs) Memory: 4066MB RAM Hard Drive: 200 GB Total Video Card: NVIDIA GeForce 7300 SE Monitor: SyncMaster 911N/920N/920Nx, SyncMaster Magic CX918N Sound Card: Realtek HD Audio output Speakers/Headphones: Realtek HD audio Keyboard: Terminal Server Keyboard Driver Mouse: Terminal Server Mouse Driver Operating System: Windows XP Home Edition (5.1, Build 2600)

  1. ICT Project 1A

    So I needed to make it stand out more. I added more contrast and made it a little darker. I also cropped it and the resized it. Here is the new picture that is to be placed onto my website.

  2. ICT PROJECT

    * Easy and clear to use. * It should automatically calculate percentages and grades from the inputted a student marks and maximum mark available for each test. * Cell, formulae protected to prevent accidental delation. * It should automatically work out a student's grade, based on overall percentage for all tests taken.

  1. ICT Report 2b: ICT in Organisations

    the mouse is moving and what is being typed by the keyboard. As information changes, the monitor can show it to the operator and the monitor is effective at displaying images from a computer. It is also vital to Boots because it adjustable tilt options can ensure a safe working

  2. This report I will be writing, will be on the way I do activities ...

    Thanks to e-mail I am able to send necessary files to myself so I can complete that work at home. Also my friends are able to send me files which can aid me in doing my homework via e-mail. I can also send my coursework files to relevant subject teachers

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