• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month
  1. 1
  2. 2
  3. 3
  4. 4
  5. 5
  6. 6
  7. 7
  8. 8
  9. 9
  10. 10
  11. 11
  12. 12
  13. 13
  14. 14
  15. 15
  16. 16
  17. 17
  • Level: GCSE
  • Subject: ICT
  • Word count: 3141

ICT Coursework Report: Spreadsheet System

Extracts from this document...


ICT Coursework-Spreadsheet Identify: Mr Smith, who is the owner of JC SPORTS, has discovered three main problems with his shop's basketball sales, these were due to... 1. The old-fashioned manual systems in his company. (Manual system). 2. The lack of interest for the latest new products on the market. (Marketing system). 3. The lack of a new hardware & software systems. (Computer system). Surprisingly, because of poor product handling, out of all the sales in his sports and design shop, the amount of basketball sports goods sold dropped massively over the past six months as seen here... Hyperlink to Sales.xls This is their table... JC Sports Sales in the last 6 months Goods Sales 6 months ago Sales now Football 99% 99% Rugby 90% 95% Athletics 90% 90% Golf 80% 70% Hockey 75% 70% Tennis 95% 97% Basketball 90% 50% Hyperlink to Sales1.xls At the time, I happened to assist Mr Smith as he was recording down his sales. Mr Smith was not very clever when it came to using computers. He needed a quite a lot of helping out. Due to the fact that I was one of his best customers, Mr Smith then showed me his most baffling results that he recently found out. The problem was that Mr Smith was pretty old fashioned and used the ancient, long gone manual technology like the typewriter to sort out his business instead of using the modern day computer software and technology such as the word processor and the spreadsheet. Since I was compiling this project, I offered to help him solve this very problem by myself doing a series of analysis on the sales, marketing and systems later on in that very same week. It was a challenge. Mr Smith was very much obliged and gave me his sales report immediately. I also advised him to shape up and use the latest up-to-date, business & industrial technology around him and not use his very old, former technology. ...read more.


we use a Spreadsheet document to organize text and numbers into rows and columns. Spreadsheets are particularly useful for entering numbers that you want to organize and analyse information. When you work with a spreadsheet document, you see the spreadsheet menus. The spreadsheet itself is a grid of rows (going across) and columns (going down). Key concepts: Each column is labelled with a letter at the top. Each row is labelled with a number at the left. The intersection of a row and column is called a cell. Each cell has a unique address, which consists of the column letter and row number (for example, D3). You enter a cell's contents using the entry bar at the top of the spreadsheet. You can enter text, numbers, or formulas into cells. Formulas are not actual values like text or numbers. Instead, formulas are a set of instructions that produces good a value for a cell. You see a cell's formula in the entry bar. The formula's result appears as the actual value in the spreadsheet cell. The spreadsheet always has one current (active) cell, and that cell has a heavy border. The contents of current cell, if any, appear in the entry bar. A block of adjacent cells is called a cell range. You identify a cell range by the addresses of the upper-left and lower-right cells in the block. In this spreadsheet... The upper-left cell is B2 and the lower-right cell addresses separated by two periods (for example, B2.C3). Formulas: Sum formula: Example: =sum (D4.G4) or =D4+E4, Average formula: Example: =average (D4.D12), multiply formula: Example: =D4* 4. 6. The new appropriate hardware and software will be used because Mr Smith had been using very old technology compared to what we use today. Also because it will definitely help & save Mr Smith's business. 7. The new appropriate hardware and software will be used gradually and when it is necessary in JC SPORTS. ...read more.


* Regular backups should be made of the data on the system using suitable backup storage. The main method used to back-up network data is the ancestral method. * Back-up files should be kept secure - ideally in locked fireproof rooms in a different location to the network. * Archiving means copying or moving a file somewhere for long-term storage. Design: This spreadsheet will contain the following five questions which all have been converted into Microsoft Excel. This was my progress... 1st- (FROM QUESTIONNAIRE SHEET) hyperlink Firstly, Mr Smith and I sent out the following questionnaire to the JC SPORTS customers. 1. What types of Sports goods do you like? 2. What types of Designer goods do you like? 3. What types of Sports goods do you hate? 4. What types of Designer goods do you hate? 5. What product should we enhance? * I entered into Microsoft Word * I typed the questionnaire in 'Times New Roman' font * I enlarged the font size to '36' to capture the whole page * The language was of course 'English (UK)' 2nd- (FROM POWERPOINT PRESENTATION) Hyperlink to Questionnaire.xls, Firstly.doc & Hyperlink to MS PowerPoint1.ppt The Table Implement: At last, finally it was a good job well done at the end of my project. Mr Smith was had all his products and goods analysed precisely. 1. We collected all information from the questionnaire 2. Results were computerised 3. All systems were updated 4. All human & computer error were diminished 5. All Customers sales were restored 6. The new system was supported by all customers Evaluate: In the end, all the objectives for my coursework and project were met and accomplished completely. Here is the evidence: 1. Mr Smith and his employees cooperated very well with the new system of work. 2. The sales questionnaire was fully word-processed. 3. All information was then sent to Microsoft Excel. 4. Customer sales boomed in the business for the first time in a long time. 5. Everyone became computer and PC literate. Created on 11/14/2003 11:26 AM By Emmanuel Yemi ...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 Hardware 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 Hardware essays

  1. Marked by a teacher

    Johns parents decided to buy a computer which can help John with his work ...

    3 star(s)

    I'm going to use the following products which are all given in the table above because John will need all of them which could help him with his work and interests. I advice that John's parents should buy all they need in http://www.pcworld.co.uk/ .

  2. An Introduction To Modern Storage Devices

    loss due to the heads contacting uneven spots on the surface of a platter. Smaller platters are easier to make than larger ones. * Mass Reduction: For performance reasons, hard disk spindles are increasing in speed. Smaller platters are easier to spin and require less-powerful motors.

  1. Computer Hardware, uses, advantages and disadvantages.

    Commands have to be typed in precisely, if there is a spelling error the command will fail. If you miss-type an instruction, it is often necessary to start all over again. The operating software that I am using is GUI (Graphical User Interface) because it is very easy to use.

  2. Ict - Unit 2B

    He also thinks that the main Software/program used by the marketing department is Corel Draw and Corel Draw photo shop. Both of these programs use a lot of memory space in the RAM and 512mb worth of memory may not be enough.

  1. A computer system consists of hardware and software.

    This is particularly useful in places such as warehouse. Drawbacks: * Low resolution- print quality is too poor to produce presentation documents. * Very slow- can be less than 100 characters per minute (cmp) * Very noisy- cannot be used near a phone ALTERNATIVE: Laser printer Laser printers work on the same principle as photocopiers.

  2. Designing a system for an IT user - He needs to have a good ...

    John can also use access to create tables about the amount of leaflets he has made. He can also use a database to record everything that goes on during the conservative party meetings. Adobe Photoshop Elements Adobe Photoshop is editing software used to edit pictures.

  1. Hardware Choices and Operating System.

    laser Printer 3 in 1 printer A 3 in 1 printer includes all of the functions, they are printing, scanning and photocopying. One of these functions may be replaced with a fax function. Having a 3 in 1 printer saves a lot of space because you only have one device instead of lots.

  2. Choosing hardware and input devices.

    If you use the mouse so often it can lead to injuries such as R.S.I. Keyboard Wireless Keyboard It uses Infrared (IR) signals or even a Bluetooth connection to send information to the computer. A receiver is the used to do this job.

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