• 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. T-Total Maths coursework

    = 9 = 7x9 = 63 I now have enough data to prove that my formula works 5N - 7G = 10 + 63 = 73 So my Formula works because T = 73. The formula has worked for the 9x9 grid.

  2. Magic E Coursework

    I now need to find a formula for the top row using this information. To do this I need to find out the sum of the numbers added onto the each e along the top row. I will write this down twice, with one on top of the other.

  1. Urban Settlements have much greater accessibility than rural settlements. Is this so?

    Towards Bexley... Cars: Vans: Buses: Motorbikes: Pushbikes: ||||||||||||||||||||||||||||||||||||||||||||||| |||| | | Total: 47 Total: 4 Total: 1 Total: 1 Total: 0 Overall Bexley has a high traffic density. South Darenth: First count performed in Holmesdale Rd at 14:15 on Sunday.

  2. T-Shapes Coursework

    is the top-right number in the "T", because it is always "1 more" than n; (n - 1) is the top-left number in the "T", because it is always "1 less" than n; (n + g) is the tail, because it is always "g more" than n.

  1. T-Shapes Coursework

    Using Algebraic Numbers to Find a Formula In the Horizontal I will express these T-Shapes in algebraic form, using the nth term, and see if I can find a pattern that applies to all of the T-shapes. I will express the T-Number as 'n'.

  2. Maths Coursework T-Totals

    79 80 81 The T-Total for this T-Shape is 187 (31 + 32 + 33 + 41 + 50), in relation to v these are; v-(9-1) v-9 v-(9+1) v v+9 If we simplify this, we can generate a formula for a relation between v and t on a grid a

  1. T-Total Coursework

    I also found another formula of finding out the T-Total. This formula would be: T = N + (N - 9) + (N - 17) + (N - 18) + (N - 19) 31 32 33 41 50 This formula can be used, too because the distance between the numbers in a T-Shape never changes.

  2. Maths coursework

    at the base of the t-shape N- 9: this is the number above N and in each case, to get back to N you have to minus 9 N- 19: this is the number left of N - 18 and in each case, to get back to N you have

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