ICT Coursework Report: Spreadsheet System

Objectives for No.3 were to…

1. Introduce a computer system to help give accurate product handling.
2. State and identify the new appropriate hardware and software.
3. State what new appropriate hardware and software will be used for.
4. State where new appropriate hardware and software will be used.
5. State how new appropriate hardware and software will be used.
6. State why new appropriate hardware and software will be used.
7. State when new appropriate hardware and software will be used.
8. State who the new appropriate hardware and software will be used for.
9. State data inputs.
10. State data outputs.
11. State the data and spreadsheet manipulation.
12. State the ways in which how problems will be solved.
13. State and identify appropriate backup and security strategies.

Goals number 1 and 2 had clearly already been accomplished in time that same week by other means necessary. Focusing my attention on goal number 3, I afterwards devised the following analysis corresponding to goal number 3:

Input- I will require a keyboard for typing in data.

Output- I will also require a printer available considering that my document may be reacquired efficiently refraining from having to worry whether the computer is switched on or off.

1. The new computer system introduced was a spreadsheets programme.
2. The new appropriate hardware and software that I identified were of course some computers (the hardware) and Microsoft Excel (the software). These both supported the spreadsheets programme.                                                                                                                                                      Hardware=Computer Science. A computer and the associated physical equipment directly involved in the performance of data processing or communications functions.                                                                Software= Machines and other physical equipment directly involved in performing an industrial, technological, or military function.
3. The new appropriate hardware and software will be used for the marketing system of JC SPORTS. It will be used to boost the ability of good, explicit and precise product handling.
4. The new appropriate hardware and software will be used at JC SPORTS.
5. The new appropriate hardware and software will be used by… (Shown in these step-by-step explanations below: How to use Spreadsheet) 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.
8. The new appropriate hardware and software will be used personally and financially for the JC SPORTS business and its customers.
9. The input devices for the business of JC SPORTS will include Keyboards, mouse(s), Digital cameras, , , , , , , , Video digitisers, Microphones, Sensors, Touch-tone telephones, , , , , , , , , , ,  and . Stylus devices: , , , ,  and , ,  and .
10. The output devices for the business of JC SPORTS will include monitors, plotters, printers, speakers, projectors, Actuators, Alarms, Microfilms, Films, VDUs, Ink Jet printers, Laser printers and Dot matrix printers.
11. Data and spreadsheet manipulation- as I plotted all my data information using a few Microsoft programmes, these were the spreadsheet how-to steps that shows how I did in using these programmes. This is my progress on three points of Goal 2:

1. MS Word>

• I entered into MS Word (you click it)
• 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)’

2. MS Power point>

3. MS Excel> &

• I entered into Microsoft Excel
• Then highlighted the questions from  &
• And pasted them into  
• Made a table
• Then made a chart

12. Ways in which problems will be solved-

• Diminish Human and computer (PC) error.
• Save time and money.
• Save space.
• Boost the marketing.
• Helps business tactics
• Boost status
• Saves valuable energy

13. Back up and security strategies-

• Backup/Strategies:
• Hard Disks are the main Internal Backing Store
• Hard disks are usually found inside computers. They’re rigid circular plates that have been magnetised, and each hard drive usually contains several disks stacked on top of each other.
• Each disk contains lots of concentric tracks, and these tracks are divided into sectors. The data is stored in the sectors. Most disks can store data on both sides.
• The disk rotates at between 5400 and 7200 revolutions per minute (rpm), and read/write heads (one on either side) float just above the surface of the disk. They’re so close that a speck of dust would ruin the hard drive – so the disk drive is kept in a sealed unit.
• It is possible to connect an external hard drive if additional storage is needed.
• The main benefit of hard drive is that the hard drive is that they have a pretty large capacity – 20 gigabytes or more (1 gigabyte = 1024 megabytes) is now common in a desktop, and 8 gigabytes in a laptop.
• One potential problem is that the hard drive is usually housed inside the computer, so it’s not easy to use it on a different machine (though you can buy removable hard drives). Also, if there’s a problem with the hard drive, all of the data stored on it may be lost.
• Hard disks
• Compact Disks (CD)
• Floppy Disks
• CPU (Computer Processing Unit)
• Films
• Videos
• Files
• Cabinets
• Storage Units
• Documents
• Back up disks
• Folders
• Chips
• Backup Software
• Backup Hardware
• Backup Storage
• Backup Items

Floppy Disks are a Common External Backing Store

• The most common external backing store is a 3.5-inch floppy disk.
• A floppy disk is a circular piece of magnetised plastic, but being floppy it is easily damaged – this is why they have a protective hard plastic sleeve.
• They work in a pretty similar way to hard disks. The main difference is that the read/write heads access the disk through holes in the protective sleeve.
• They have a small tab, which can be slid down to make the disk read-only. This helps to reduce the chances of data being accidentally overwritten and lost.
• Since floppy disks are small and portable
• CD ROMs
• RAMs
• RAMs- Hold temporary memory
• ROMs
• ROMs- Hold permanent memory
• Magnetic tape
• Optical Disks
• ZIP Disks
• ZIP Files
• Almost any hardware available could be good for backup
• Security/Security Strategies
• Physical Security
• Access Security
• Data Security
• Reasonable Security
• Network Security 
• Serial Numbers- Keep record of all serial numbers, and mark the organisation’s name and postcode on all equipment – this help police to identify stolen property.
• Alarms- Computer rooms should be protected by burglar alarms.
• Doors should be locked when rooms are not in use.
• Fire protection- Use fireproof doors and smoke alarms. Also, automatic gas-flooding systems could be used to put out any fire to prevent water damaging the equipment.
• Lock windows to prevent access.
• Avoid putting computers on the ground floor buildings, where they can easily be seen from outside.
• Blinds or curtains should be closed at night, and monitors should be switched off, so the computers are less visible.
• All authorised users should be given usernames and given or create their own passwords. This will limit unauthorised access to the network.
• Users should change their password frequently.
• Individual users should be assigned access rights – for example network managers can be given access to the software that controls how the network is run. Other users can be limited to certain types of applications software such as word processors.
• Some software can be password-protected so that a password is needed to view and amend data.  
• Files can be made read-only, so that they cannot be altered or deleted. Other files may be hidden so that they are not visible to the user.
• 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)  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) ,  &

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.