# data[].attributes.body
Digital Devices Gathering Information

- Unit 1 : Digital Devices
- Unit 2 : Connectivity
- Unit 3 : Operating Online
- Unit 4 : Online Goods and Services
- Unit 5 : Applying Information and Com Tech

# data[].attributes.body
-CPU
-RAM
-MOTHERBOARD
-POWER SUPPLY
-STORAGE DEVICES
-COOLER OR A FAN

# data[].attributes.body
- In the early days (1980's) these types of machine were called a micro-computer.
- We tend to call them a 'Desktop Personal Computer' or 'PC' if you want to be brief.
- The desktop PC has a central processing unit housed in a metal case (often a  'tower'). Along with a keyboard, mouse and monitor.
- Modern PCs are quite powerful, being able to carry out thousands of millions of calculations per second.

# data[].attributes.body
- Portable and very easy to carry around.
- Light to carry.
- Compact, can be easily stored.
-  Can replace almost all the functions of a Desktop PC.
-  Use of the same peripheral equipment as the desktop e.g. printers

# data[].attributes.body
USES:
Gas and Electricity suppliers - for Billing
Banks - for managing your accounts
Insurance companies - looking after your policies
Airlines - handling your tickets
Police - crime detection
Car companies - managing factories

# data[].attributes.body
Desktop PCs are not easily portable.  They are large and heavy.
They require a large amount of permanent office space.
They need a fan to prevent overheating.  Thus they can be noisy.
They can only be run on mains electricity and need to be situated near to a power point.
New advances in technology means that PCs get out of date very quickly

# data[].attributes.body
- They can be easily upgraded.
- They can be used for a very long periods of time.
- It is possible to create a custom-made machine.
- Monitors come in a range of sizes and qualities and can be chosen specifically to suit the user’s preferences.
- It is easy to replace an individual part if damaged.
- PCs can be used for many different tasks
- They can run a vast range of software, often simultaneously.

# data[].attributes.body
- Office applications such as word-processing, spreadsheets and databases.
- Engineering work - designing kitchens at a showroom
Video work - for handling your camcorder
Music - creating, playing and storing
- Entertainment, information, internet.

# data[].attributes.body
- Expensive to purchase
- Easily damaged if dropped
- Expensive to repair
- They cannot be modified or costumed.
- Battery life is often shorter
- The screen may be small if needed for detailed work
- The keyboards can be cramped if used for long periods of time

# data[].attributes.body
- Laptops are built as  relatively small one-piece units.  The monitor or display is permanently attached to the main box and cannot be removed.  When in use, it is swivelled up to reveal the keyboard.
- Laptops can be used in pretty much the same way as a Desktop PC and indeed many people prefer to use them
- They can have the same processing power and same memory as their larger counterparts.

# data[].attributes.body
1)Full forms
- RAM
- ROM
2) What is the unit for the speed of the CPU
3) Advantages and disadvantages  of desktop and laptops
4) Write a formula to calculate the average of the values.

# data[].attributes.body
- Mainframes are large machines that can carry out different tasks for many people at the same time.
- They execute billions of instructions per second and can process large volumes of data simultaneously.  They are usually connected to a large number of peripherals e.g. printers, disc drives, terminals and so on.
- Mainframe computers are often used to control an entire factory assembly line - recording the movement of materials, paying of bills, sending invoices and so on.

# data[].attributes.body
4 mark questions in the ICT test will ask you to recommend certain devices for 2 types of people. E.g. John is a student and he needs a device for school work only and Bill needs a device for content creation or gaming. Which one should get a laptop and which one should get a desktop and give reasons why?

# data[].attributes.attachment_link.title
Microsoft Excel #01: Introduction to Excel

# data[].attributes.body
This allows data to be easily visualised and organised in a spreadsheet.

# data[].attributes.body
Validation is an automatic computer check to ensure that the data entered is sensible and reasonable. It does not check the accuracy of data.

For example, a secondary school student is likely to be aged between 11 and 16. The computer can be programmed only to accept numbers between 11 and 16. This is a range check.

However, this does not guarantee that the number typed in is correct. For example, a student's age might be 14, but if 11 is entered it will be valid but incorrect.

# data[].attributes.attachment_link.title
Excel: Relative and Absolute Cell References

# data[].attributes.body
IF statements:

# data[].attributes.attachment_link.title
Excel IF Statement Explained - learn how to use Excel's IF

# data[].attributes.attachment_link.title
How to Do a VLOOKUP in Excel - Video Tutorial

# data[].attributes.body
Column: Vertical series of cells

Cell: An intersection between a column and a row

Row: Horizontal series of cells

Formula: An expression that calculates the value of a cell

Data: Information stored in cells

SUM: Adds all the given values

Label: Words describing the values of a row/column

Sort; Arranges the values in a certain sequence or order according to specific rules

Cell reference: Refers to a cell or a range of cells

Absolute cell referencing: Remains constant even if the spreadsheet is changed or the reference is copied/moved to another cell/sheet

Fill Handle: Allows the user to extend/fill any value to any number of cells

Validation: Helps to control what can be entered in your worksheet

Chart: Allows you to visually display data. Also called a graph

Formatting: Changes the appearance of a number without changing the actual number (%, $. decimal etc)

IF Statement: Checks whether a condition is met; returns one value if true and another one if false

AutoSUM: Inserts a formula that adds all the values

Average: A formula that adds all the values and divides it by how many values there are ie finding the average

Minimum: Returns the smallest value from the values provided

Maximum: Returns the largest value from the values provided