• 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

    Development will be carried out partly on a school computer and partly done on my home computer, which is a standalone Pentium similar to the one described above. The school computers are PC's with 128MB of RAM attached to a suitable enough printers.

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

    Keeps a diary of all payments to be made. These payments are made and transferred between the banks on magnetic tape. Not many people have heard of BACS. Bankers' Automated Clearing Service Set up by larger banks to to deal with standing orders and direct debit payments.

  1. 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:

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

    by giving off the impression to the blocked person that you are offline. The 'appear offline' feature is also similar but more useful. If you wish to stop most people from talking to you but don't want to sign out as you'd like to talk to that certain someone, you can simply appear offline and still talk with them.

  1. Microsoft Excel and Microsoft Access

    Within the file, you divide your data into a table, which you can view, add, and update using online forms. You can find and retrieve just the data you want using queries; and analyse or print data in a specific layout using reports.

  2. Free essay

    security issue

    Spyware - Is a computer software that is secretly installed on to your computer and can take control over something's that you do on it. It can install software which you did not want on your computer also it can make you go on websites that you did not click

  1. The Advantages of Using ICT Over Manual Meethods. Using Paint and Access.

    For validation rules enter in ("Male" Or "Female") and for validation text enter in something like "PLEASE ENTER MALE OR FEMALE" Creating Queries Click on Queries. Create the Queries in 'Design View'. Then you select the button pointing downwards and select Table: Information.

  2. a level ict project

    Information on the customer, the cars problem and how it was solved, the price and the employee taking care of the job is recorded (written down). Information is then stored in the form of reports an archives. Calculations and other processes are made solely by the person inputting the information.

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