• 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
  • Level: GCSE
  • Subject: ICT
  • Word count: 1147

ICT implementation report

Extracts from this document...

Introduction

1. Range of data This is my data, which offers all the different cars and the details about them. The table is set out in and sorted by the specifications of the cars and also includes their prices. 2. Creating order sheet 3. Customer details of order sheet This is the top part of my order sheet, which are the customer's details and the company logo on the top right hand side of the page. 4. Setting up combo boxes I have created combo boxes so that customers can choose what they wish from my data of cars. Each combo-box category has 5 cars and an empty space left encase the customer chooses not to choose a car from a certain category. This selection is linked to the cell next to it as each car has a preset number and the number is what makes the cell named "cars" change to what is selected in the combo box. 5. Spinners The quantity is done using spinners. ...read more.

Middle

However this time the cell C28 will display either 1 or 2 which represent YES or NO. From this the IF statement in I24 can be done. If cell C28 is displaying 1 then a �6.99 charge will be put on the totals if number 2 is being displayed then cell I24 will come up as blank as there is no Delivery charge. 10. Tick box and IF statement Claims Bonus Discount This is the Claims Bonus discount tick box which is linked to the cell next to it as you can see above. As the box is ticked and un-ticked the cell next to it will change to TRUE or FALSE this enable me to create an IF statement formula that links to this cell in order to give discount or not. 11. Sub-Total This is a sum formula which adds all the prices which are displayed in the selected columns. 12. Working out VAT% Simply input the percentage I wanted as my VAT into cell H26. ...read more.

Conclusion

19. Logos, company details and picture This print scheme shows the company logo and the colour scheme which is matching throughout the project and the picture in order to make the project more attractive. Part of the logo is the company details that are merged with it. 20. Invoice number and date. Located below the logo, this is one of the essentials for the receipt, however there is no formula or calendar option used so the date has to be manually changed every day and the invoice number every time the invoice is being saved and printed. 21. Order details These details are automatically pasted from the order sheet using the Add Macros. Therefore the titles are set in that order according to the data sheet and the font has been set to be changed as part of the processes of the add macro. 22. Customer details on the invoice. These formulas simply display the information/details which the end-user would fill out at the top of the order sheet. 23. Calculation formulas on invoice The print screen above shows all the formulas used I order to calculate the grand total. ...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

    ' ' mcrchart Macro ' Macro recorded 16/01/2007 by 21bor2413j ' ' Sheets("Pivot Table A").Select ActiveSheet.PivotTables("PivotTable3").RefreshTable Sheets("Chart summary").Select End Sub Testing chart sheet Test Jonas Before adding a test mark After adding a test mark to archive, the chart refresh.

  2. ICT Report 2b: ICT in Organisations

    This variant of the mouse resembled an inverted trackball and became the predominant form used with personal computers throughout the 1980s and 1990s. The ball mouse utilises two rollers rolling against two sides of the ball. One roller detects the horizontal motion of the mouse and other the vertical motion.

  1. GCSE Excel Project ICT

    There are no windows in this building apart from a 3 ft x 4 ft pane at the front of the shop. The computer itself will be bolted to the table and the table respectively will be bolted to the floor. On the computer itself, the administrators account (system administrator)

  2. a level ict project

    A shortened copied version of this sheet, which includes the name of the employee, the customer details, date and the car repairing details is given to the customer as a receipt. Victor's garage copy is then kept on file for later reference if needed.

  1. The end user of my program is for the people applying for the insurance ...

    and calculator and table of insurance ratings in order to assign quotes. They have no computer system at the moment that will enable them to store customers paper accounts on computer there fore they have to calculate the paper bills by hand using a calculator.

  2. System administration report

    - How is the necessity of training assessed? - How are the benefits of training assessed? - What are the costs of carrying out the training scheme? - What type training is used in the hotel? Security Issues - What different levels of security are there in the hotel?

  1. Excel report - ICT.

    The Analysis There are many ways to solve this problem for the school, and here is an adequate example; I could use the alternative of graphical representation. I would store the information in a word processing package, and the results would be hand-written in graph form, on paper.

  2. Master Prints I.C.T. Project

    The name and address must be in a suitable place for window envelopes to be used. 4. Easy to use system The office staff do not have many IT skills and will need menus or icons to help them use the system to carry out items 1 to 3 above.

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