Computer Science PPE1

Computer Network

two or more computers are connected together to allow them to communicate

protocols

rule which must be followed so that data can pass from one computer to another 

wired connections

connects computers together using cables

wireless connection

uses radio signals to connecct computers together

network cable

these are used to connect the computers together

Hub

central device which allows the computer cables to connect

Server

some networks will have a server and these can be very useful for storing files

router

this device acts as a gate way and passes on messages from one computer to another. If you have wi-fi art home then you have a router.

cell

each box in a spreadsheet

Sum

to add numbers together

max

to find the highest amount

Min

to find the lowest amount

average

to find the average

cell referencing

when we change any values in a cell all calculations will be updated as well

Formatting spreadsheets

allows us to make information stand out

examples of formatting spreadsheets

changing colour of font, changing font size, merge and centre boxes