• 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
  • Level: GCSE
  • Subject: Maths
  • Word count: 2378

ICT Coursework: Data Management Systems

Extracts from this document...

Introduction

Sam Coley 11H

Identify

My mum is part of a company that sells cards.  She works from home.  At present, she only has hand written records, showing what she has bought from the company, and what she has sold to customers.  These records are very untidy, and are always getting lost, or muddled up.  She would like a better way to keep this information, and so I offered to make a spreadsheet on the computer, that would help her to do this.  However, she is not very good with computers, and can only do basic things, therefore, I need to keep it as simple and easy to use as possible.  The only other alternative solution to this is to continue making manual records, but to keep them in a filing cabinet.  This is not such a good idea though, as it is time consuming, and takes up a lot of room.  Using a computer is therefore the best way to store this information, as it saves a lot of time, and space, and keeps all records together where they can be accessed quickly and easily.  Even though my mum is not very good with computers, by keeping the spreadsheet easy to use, it will be easy to teach her to use it.  The result of this will mean that a lot of time is saved, and the business can run more efficiently.

...read more.

Middle

6

Include company logo with hyperlink to company website.

When you click on the company logo, the company website is loaded (on a pc connected to the internet).

7

Must be password protected.

Details in cells cannot be edited, unless password is entered.

Implementation

With the use of Microsoft excel, a spreadsheet package, I entered each individual card into a spreadsheet, with its code number, price sold for, price bought for, number bought, and number sold, as shown below:

image00.png

From this data, the profit per card, number left, and total profit per card can be calculated, as shown here:image00.png

This data is created using the following formulae:

image11.png

My first objectives were to produce a total for the number of cards bought, and the total number of cards sold.  I put this data on a fresh sheet in the spreadsheet, so that it is easy to view:

image18.pngimage19.png

Also, a total for the number of cards left in sock was asked for, and total profit, which is also calculated on this sheet, as seen above.

To be able to look up individual cards by code was the next objective.  For this I decided to use a V-lookup table, where data (i.e. the code) is entered into one cell, and then other information is shown in other cells.

...read more.

Conclusion

The user, my mum, sent this letter, giving her thoughts on the spreadsheet:

Dear Sam,

        I have been using the spreadsheet that you created for a week now, and I must say that it is a success.  All of the functions that I asked to be included are include in it, and they all work correctly.

Much time and energy is saved by using the spreadsheet, as I can access all the data that I need quickly and easily, meaning that the business can run much more efficiently.

I would like to thank you again for all the work that you have done for me.

Regards,

Mrs A C Coley

Now that I know this project has been successful, I can maybe improve it, or add additional features, to make it even better.  For example, the layout could be improved, and macros could be included to clear the contents of cell more easily.  I can also extend this project by making it automatically create graphs of monthly or weekly profits, so that the progress of the company can be monitored visually.  If the user, my mum, asked for any other features to be added in the future, I would also be able to include these.  My personal objective was to help my mums business run more efficiently, and I think that with this project, I have achieved my goal.

...read more.

This student written piece of work is one of many that can be found in our GCSE T-Total 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 T-Total essays

  1. Magic E Coursework

    When I reverse the second one, and add it to the first I will get twice the total. Then no matter what the width of the arm, I will always get the total of all the numbers added on after the e in the top row.

  2. T-Shapes Coursework

    48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97

  1. T-Shapes Coursework

    36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 1st T-Shape: T-Total 1

  2. T-Total Maths coursework

    N = 5 T = (5 x 5) + 56 = 25 + 56 = 81 Rotation of 2700 8 by 8 T-number and T-Total table T-number T-total 11 48 12 53 13 58 14 63 Here I have added a prediction of mine when I realized the pattern of the sequence, which goes up by 5 each time.

  1. Maths Coursework T-Totals

    Therefore, we can state that, As a T-Shape is translated vertically by +1 on a grid width (g) of 9 the T-Total (t) is +45 larger than the previous T-Total (t) (the origin) It is obvious we can also state that: As a T-Shape is translated vertically by -1 on a grid (g)

  2. T-Total Coursework

    I am going to use the grid with eleven numbers in a row: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37

  1. Maths coursework

    N = 26 T = (26 + 17 + 7 + 8 + 9) = 67 Therefore: 67 = (5 � 26) - 63 = 67 Therefore the formula of T = 5N - 63 is correct However this

  2. I am going to investigate how changing the number of tiles at the centre ...

    To get the +8 you subtract the difference of 4 from the original number of tiles you started with, 12. This will give you the equation, 12 - 4, which equals +8 and this is then added to give the pattern formula, 4N + 8.

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