• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

My final report - Spreadsheets.

Extracts from this document...

Introduction

My Final Report Throughout this project, I used a ranged of techniques in order to make my spreadsheets a success. The creating of the spreadsheets did indeed seem more difficult than expected, but I have finally come to a satisfying spreadsheet design. * How I created my spreadsheet. I mainly created my spreadsheet using 'Trial and Error' which proved to be reliable towards the end of the project. In each spreadsheet, I have included a range of columns each showing different information. The first column, is showing the numbers of orders hence the name 'Number'. The second column shows the item that is being ordered. Every item that 'Janet Fellow's' has to offer is shown in the column (named 'Item'). The following column is the most important in my point of view, as this piece of information is vital if we are to calculate the VAT price, the discount price, and the overall price. Below I have added a screenshot of a chosen spreadsheet. As you may have already noticed I have added the date to my spreadsheet. This will allow the user to keep track of when the sheet was created. This will cut out a large amount of confusion if the orders for kitchens become common. ...read more.

Middle

If I was to give the program a mark out of ten for ease of use, the mark would probably lie somewhere between 8 and 9. * Ease of setting up Again the spreadsheets were reasonably easy to set up, which I have mostly explained in the 'ease of use' section. As we all know, in order to enter the excel program, all you are required to do is double click on the logo and your in. The next stage is entering the needed data. This can cause some confusion if wrong digits are entered. However there are methods that can be used to detect these mistakes. With careful typing and regular checking of work, this process is reasonably easy. * My view of excel and its suitability From my point of view excel is a straightforward and user friendly program that is very well suited to this type of spreadsheet. The reasons for this, is the amount of options that 'excel' has to offer in order to make life a little bit easier for the user. However if you are not an experienced user, and there are no experienced users present at the time of use, then there are some complications that may arise. ...read more.

Conclusion

other relevant data values to change automatically in order for the spreadsheet to be correct, there are a number of steps that you must take. This caused me a large amount of confusion. Eventually however I corrected this problem. * Did my project do all the things that I set out to achieve. From my point of view, I have successfully completed the list of objectives and criteria in an appropriate and methodical way. I have taken care when creating spreadsheets in order to make the solution correct, and I have analysed them, and made any changes that I think relevant in order to improve the reliability of my final spreadsheet. Also, I now have a much clearer insight to what the 'excel' program involves and I now feel more experienced with using the program also. * Improvements that I feel may be possible in the future. Taking into account the amount of resources that we have, and the understanding of the program that we also have, I feel that there are no further improvements that we could have made to the project. There are no major stages of the project that I feel needed desperately changing, however there may be minor areas that I could find if I had a better and more experienced insight to what Excel involves. Adam Bowering 10.7 ...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 Software 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 Software essays

  1. The aim of my project is to make the task of the allocation of ...

    To correct this we simply click on the "increase decimal" button on the toolbar until we have the correct amount of decimal places. In the picture above, the formula in cell AJ29 is incorrectly configured so that the formula adds an incorrect cell, (coloured green)

  2. Reviewing different multimedia presentations.

    The pace of the multimedia product With this Multimedia Presentation there is no real pace to it as you have to navigate the Multimedia Presentation at your own pace. The pace in which you go through depends on how quick you are at reading as there is a lot of text in this Multimedia Presentation.

  1. Spreadsheet Technical report. My task was to produce a grade book for primary ...

    I then followed the previous steps again to calculate the min and average; only clicking either min or average from the drop down list. I then put a border around the table to show that it was separate from the "reading" table, and to make it stand out.

  2. AQA GCSE ICT Specification B

    12. Each button on the main menu must have a simple explanation. Open the main menu. Each button should have a simple explanation beside it. Testing Against The Test Plan Test 1, 2 + 12 Test 3, 7 Test 4 Test 5 Test 6, 10, 7 Failed (Test 6)

  1. Logo Report

    is a very simple software to use, and it is also capable of creating fantastic designs. The logos, which I have created by using the Fireworks Software, are listed below: I like this logo because it is simple, bold and looks good in black and white as well as colour.

  2. ICT BTEC UNIT 2 - REPORT

    this will ensure that you get as much as you can out of the packages you use. Another thing to remember is making sure that when your creating a video to be burnt on to disc you must remember what format it has to be and how much memory your

  1. Spreadsheet Report

    in the "Hirer Details" sheets the names of the limos changes, if I change the prices, registration number e.t.c then automatically on the other sheets all the details would change. Here is a screen shot of me changing the information and seeing the other sheet from which the details have

  2. Powerpoint review project

    Hyperlinks: These will enable the user to click on different links that link to other slides. Slide layouts: This will make the presentation more organised and better Timings: These will be used so that the slides will run at the correct time when flicking between them Word art: This will

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