Storage Example Questions

1. Explain why the following are used with PCs.

Pen drives- Portability for transferring files from one computer to another

Blu ray- Large amounts of storage (50GB), bigger than DVD's and HD movies 

Fixed hard disc drives- 

2. Students can use CDs or pen drives for storing their work. Give three reasons why students may prefer to use pen drives.

-

-

-

3. Ring two items which are storage media.

Flash memory card

OCR

Graph plotter

OMR

Magnetic disc

Touch pad

4. Ring two items which are output devices.

Blu-ray disc 
Optical mark reader 

Graph plotter 

Projector 

Web cam 

Graphics Tablet 

5. Complete the following sentences using the most suitable storage device or medium listed

below.

(a)memory stick

(b)fixed hard disk drive

(c)DVD R

A student taking his coursework home to develop would use a

A company selling copies of games would use a

An office worker who never took her work home would store her work on a

Backing Storage

Fixed hard disks are used in file servers and are online. Portable hard disks would be used for storing very large files that need to be transported from one device to another. Magnetic tapes are used for backups of file servers for computer networks. CD/DVD ROM are used because data can not be deleted off it whether it be accidental or on purpose. CD/ DVD R is used for the single burning of data. CD/DVD RW allows you to record over old data and update the information. DVD RAM is the same as DVD RW but allows for quicker access and can be overwritten more easily. Blu- ray has a capacity of about 50 GB, provides HD video and is used for storing films in high quality. Solid state backing storage is easily up datable and written and is more robust than other forms of storage. Pen drives can transport files and backup data from computer to computer. Flash memory cards are used in digital cameras, palmtops, mobile phones and MP3 players.

Microsoft Excel

1. import: .csv (comma seperated value file)- standardised format. Save as Excel Workbook! Open all files!
2. Absolute and relative cell references-Relative cell references are relative to where you are, the formula changes depending on where you copy and paste it and absolute means it will absolutely always refer to that cell.
3. Named cells (absolute reference), named ranges (automatic reference e.g. naming list of marks as marks). It makes reading formula's easy. Rather than a whole lost of numbers.
4. Sum, average, maximum, minimum, integer, rounding, counting, if, lookup
5. Filtering (cutting down the information), perform searches using AND, OR, NOT, LIKE
6. Perform searches using wildcards (*or anything)- Broadens searches
7. Sort data

Notes

• All formula's have equals sign, their name and brackets.
• Click enter when naming cells