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

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

    4 star(s)

    certain location which happens by sending the footage to the corresponding office it is connected to where it is viewed by the security of that particular place. For example, they could be cameras showing footage of a school, a supermarket or any other office environments.

  2. 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.

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

  2. ICT PROJECT

    * It should be able to generate an automated report for students showing student performance. * Password (security) on file access. * It should automatically colour code student grades. User Skill Level Ms Gammon has used Microsoft Excel but does not use it to calculate percentage, and grades of her marks.

  1. GCSE Calculator Project

    In Access I could then import the image onto the button through the button's properties. This would enable me to use any colours that I wished. Evaluation of objectives These are the objectives I started with from the beginning when I started this project.

  2. Creating a computer system for a video rental shop

    Sending out questionnaires and analyzing results. 3. Observing current procedures with current system. 4. Examine current business and systems documents and outputs. Design The Feasibility of a Computer Based System: It has been required that I should produce a computer based system for the video libary.

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

    by a special ink, containing magnetic particles that are read by a MICR. It identifies the cheques unique number, the sort code for the account holders bank and the customers bank account number.EFTPOS are check out tills connected to a computer, with the bar code scanner and it can transfer

  2. ICT Report 2b: ICT in Organisations

    This screen is set in a grid of tiny squares called pixels. When an image is displayed, each individual pixel will illuminate a specific colour, and regarding that this is done to thousands of pixels on the monitor, it ultimately forms images that we can see before our eyes.

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