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

GCSE Excel Project ICT

Extracts from this document...


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.


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.


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. Marked by a teacher

    The impact of ICT on the local community. I live in the borough of ...

    4 star(s)

    The method of sending the video feed captured on a video camera back to where it's being monitored is quite efficient in that it's effective and fast at sending the information back. This makes it easier to capture criminals as the system works in a speedy way.

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

    These games provide a more competitive nature towards the casual conversation between people on MSN. For example, a game of Minesweeper can turn quite intense. It provides a much more interesting side of MSN. This can entertain you with your friends and form a deeper bond by engaging in interactive acts with each other.

  1. ICT Project - Statement of the Problem

    There is a Supplier Orders and Payments All the supplies that need to be ordered will be ticked of on the order sheet. The order sheet will then be printed and sent of to the suppliers with a check. When the suppliers are delivered, it manager or assistant manager will then tick it off that it has been delivered.


    She is an average user, which means she does not understand most of the advanced features. Such as Vlookup, IF Statement, Macros, etc. Project Constraints Ms Gammon uses school standard PC that I will be using to calculate percentages and grades for the new system.

  1. GCSE Calculator Project

    Perform the basic arithmetic functions (of add, multiply, subtract and divide). 2. The font size should be big for people with peer eye sight. 3. The difference between the foreground and background colour should make it easy for the user to read.

  2. Creating a computer system for a video rental shop

    had had to collect my own user information on the requirements of the new system and what the problems were with the new system there are four techniques I could use these are: - 1. Interviewing staff at different levels about the present system and what they would like to see from the new system.

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

    Banks use the following systems MICR (Magnetic Ink Character Recognition), TPOS (Electronic Funds Transfer at Point of Sale), EDI (Electronic Data Interchange) , Credit Card Use, EFT (Electronic Fund Transfer) , Credit Card Fraud ,Smart Cards ,Cheque Clearing. MICR- Cheques have a unique code at the bottom which is written

  2. ICT Report 2b: ICT in Organisations

    These pixels react to electronic signals from the computer, "telling" it to display whatever image is required of the operator. TFT-LCD (Thin Film Transistor-Liquid Crystal Display) uses highly sophisticated technology to create sharper and brighter images and is capable of projecting images from flat panel displays.

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