Labels

ICT (23) Theory (17) Practical (6) Software (6) Paper1 (5) Access (4) Components (4) Hardware (4) Paper 2 (4) Syllabus (4) Learning (3) Paper3 (3) Link (2) Database (1) Excel (1) Facebook (1) Interface (1) Powerpoint (1) Storage Devices (1) Twitter (1)

Sunday, February 20, 2011

Excel

When opening a .csv in an exam, save it as a non-.csv file as soon as possible. Save it as a Excel Workbook. SAVE AS EXCEL
SAVE AS EXCEL

1. Import .csv (comma separating value) standardized format for all computers
2. Absolute and relative cell references (A1 refers to that cell) formula changes to where you've copied from.
3. Names cells, named ranges.Changes the name of a cell/s to insure an absolute reference. Makes reading formulas easy.
4. Sum, average, maximum, minimum, integer, rounding, counting, if, lookup.
5. Perform searches (filter) using AND, OR, NOT, LIKE, >, <, =, <=, >= (cuts down the stuff you see).
6. Perform searches using wildcards (this is where you use a *). If you said *th, you'd get anything ending in 'th e.g: beTH. th* would give anything starting with 'th'. They broaden searches.
7. Sort data

All formulas have thier own name, start with =, and have brackets.
When naming a cell, press enter otherwise it won't work.

SAVE AS EXCEL

Thursday, February 17, 2011

Tuesday, February 15, 2011

This is a PDA or personal digital assistant <<<



               This is a palm Top^^^


<<<This is a mainframe computer

Wednesday, February 9, 2011

Hardware/software

Hardware: Physical component of the system (printer, mouse)
Software:  Non-physcial components. (control pannel, system preferences, programs)    3 Types = Utility, application, operating system.

Components: Input (magnetic character reader, keyboard, lightpen), CPU, RAM (random access memory (volatile/always changes)) / ROM (read only memory (non-vaolatile)), Secondary Storage (hardrive), Output (printer).
Pimary Memory is closest to the CPU, which is RAM/ROM. Secondary storeage is the hardrive.

Interface: One thing talking to another, allows communiction. Allowing you to talk to the machine.Types:  GUI (graphical user interface). GUIs are WIMPS (Windows, Icons, Menus, Pointers) Command Line Interface.