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

Appropriate Software To do this project I am going to use excel because it has a number of different features that I can use. For example, I can use data validation, conditional formatting, protection and most important of all- formulae, which will enabl

Extracts from this document...

Introduction

Analysis Appropriate Software To do this project I am going to use excel because it has a number of different features that I can use. For example, I can use data validation, conditional formatting, protection and most important of all- formulae, which will enable me to manipulate different values which means I can easily see the effect certain prices will have on my profit/loss. The validation will ensure that incorrect values which could affect the profit/loss are not inserted as this could affect the sales. Conditional formatting is useful as it enables the important values on the spreadsheet to be easily read. Protection is another important feature of excel as it means I can protect my sheet from changes that anyone may make. For obvious reasons I feel that Excel is the appropriate software to use. Appropriate Hardware As far as the hardware is concerned the spreadsheet will be needed to be saved on a new computer as older ones may not have enough space on the hard disk. I would recommend a Dell computer as it has a large internal memory of 200GB and as it is especially designed for professional purposes such as ours. A wireless keyboard and mouse would be useful as well as this would reduce the amount of wires meaning the whole affaire will look more organised. A printer will be essential as printing spreadsheets and graphs will be a task which is undertaken often. ...read more.

Middle

Expenditure: This is calculated by multiplying the buying price by the sum of the units sold (which is the same as the no. of units bought) during the week. This is the money spent on buying a product from the distributor which is then sold at a higher price during the week. Total Expenditure of Products This is calculated by doing the sum of the expenditures for each of the individual products. This is the total money spent on buying products from the distributor which are then sold at a higher price during the week. Units Sold This is calculated by using the random feature which generates a value from a certain range. This is the number of products sold during the week. Outputs Sheet Name Printed/On screen Why? Sales Viewed on screen and printed It is viewed on screen so at the end of every week the sales sheet will be looked at, checking how much profit/loss is being made. Also, perhaps to see what prices the goods are being sold at. As far as the printed copy is concerned, this is so a permanent record can be kept and also because it can be handed out to the workers so they can have a look at the situation. Finances Viewed on screen and printed It is viewed on screen so at the end of every week, the finances sheet will be looked in order to check the expenditures and the costs. ...read more.

Conclusion

Backup and Security Security I will use protection on my spreadsheet which means there will be a User ID and password which will be needed to change and edit the spreadsheet. This information will be given to my end user Mr. Robert so he can update the spreadsheet as well as me. There may be some changes that will need to be applied to the spreadsheet quickly which means Mr. Robert can make those changes without consulting me as he will have the ID and password. I will use Mc Affee Anti-Virus 2008 in order to make the spreadsheet safe as well as a firewall. The end user will change the password every month and will notify me. He will keep a copy of the ID and password in a safe. By doing the above processes like using a password and anti-virus software I will be sticking to the Data Protection Act. Backup As far as the backup is concerned my end user will store the spreadsheet (which is approximately 30 KB) on my 1 GB memory stick. My end user will take the backup every time a sheet is updated and he will keep it in a locked drawer in his room which protected from burglary. It will probably take 2 minutes or so to perform the backup. This time includes logging on, loading Excel, accessing the spreadsheet and saving it on my 1GB memory stick. ?? ?? ?? ?? Arjun Bhatt 11T ...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. Design a spreadsheet that can be used by a school tuck shop.

    costs went up by �3 * If national insurance rose by 3% * If TAX rose by 5% * If certain stock doesn't sell * What happens when you add a new product to your spreadsheet? I tried and tested each of them and this was the outcome: IF VAT

  2. Selecting the best software for a theatre business.

    This will help Bob because they are easy to open making it efficient for Bob. 2. I have made extensive use of Excel formula capabilities, and found that pretty much anything I wanted to do, I could duplicate in Calc.

  1. Reviewing different multimedia presentations.

    There is space for the text on the right hand side of the Multimedia Presentation as this space is just being wasted at the moment. The pace of the multimedia product The pace of this Multimedia Presentation depends on what speed you want to work at because it has no set things which you have to look through.

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

    Once I had selected my specific range I clicked the square icon again, to maximise the box on the screen. In the criteria box, I typed in what I wanted it to count, in this case I wanted it to count all the percentage which were greater than or equal to 70%, so I typed in ">=70%" and pressed ok.

  1. IT GCSE Project 1: Software

    It reaches all the usual database specifications such as search which allows the staff to search a patient or dentist. The validation checks were very good, there was still possibilities for errors occurring but they were minor and can be handled.

  2. Analyse appropriate hardware and software needed.

    So they types in the calculation of weight time's height and the BMI is calculated and then given to the customer. Once this has been done the information will be seen on the monitor so can then be printed out if needed.

  1. Analyse appropriate hardware and software needed.

    Publisher does not have the features needed in order to create the Science presentation. Input The information that I will need for my presentation will be about the science department Data Type Collection Input Eg. What is Science all about.

  2. Questions and Answers on the Features of Presentation Software

    Cut 1. Dissolve 1. Wipe Left 15. Identify one thing that you need to consider when using slide transitions in a presentation The speed of the transition and whether or not you are going to include sound along with the transition, you also have to decide what transition style will benefit your presentation the best.

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