Revision

Revision

1. Spreadsheets

   • IF statement
     • Is when you write out a statement to see if you can afford all the things you want to buy that are in your table.
   • Formula
     • Is when you add,subtract,times or divide the numbers by using a formula.
   • MIN
     • Is when you find the MIN number out of a set of numbers. An example of this formula is =MIN15:l11
   • Conditional formatting
     • Is when you can apply different formatting tools to cells, of example, you can set your cells to change from green (you can afford) to red (you can't afford) when you change any of the numbers in you spreadsheet.
   • Average
     • Is when you find the average(The most common number)of two or more numbers.
   • MAX
     • Is when you find the MAX(maxim) number out of the set of numbers you have.

2. Scratch and programming skills

   • Condition
     • Is when something has to be in a particular for it to work. In scratch if any of the statements start with "IF" "WHEN" or "UNTIL"then they have to be in the correct place for them to work.
   • Variables
     • Is a place holder for some of the values. Like when you have spaces to add in different variables for scratch to do something different.
   • Stage
     • Is a different name for the background.You can change it if you want to.
   • Sprite
     • Is another word for person,character that you are being. You can change you sprite if you want to.
   • Loop
     • In programming can contain multiple actions an they will continue to work on a loop till you tell it stop.
   • Script
     • Is when you line up all the actions you want your sprite to do, they will say lots of different things, each of them do different actions. Once you press the green flag the actions you have chose for your sprite to do will start to work.

3. computing devices

   • Input
     • Is a device that you can input things into your computer monitor. For example a key board is an INPUT device because when you press down on the keys it INPUTS the letters and words on to the monitor screen
   • Output
     • Is when a device outputs something, for example a printer OUTPUTS whatever you want it to print and speakers OUTPUT sound. The same with headphones.
   • Processing
     • Is when a device ,like a mother board, processes all the things in the computer.
   • Storage
     • Is when a device like a USB stick stores info and when it is plugged in to the computer it will appear in the files of the computer.