Processing Data (Grade 10 NSC Matric Computer Application Technology): Flashcards
📚Flashcards
Practise the cards
10 cards from this deck
ShowHide
Practise the cards
10 cards from this deck
Data manipulation definition
Data manipulation definition
Process where info is changed to make it easier to understand
Knowledge in data processing
Knowledge in data processing
Info collected for analysis; raw data and facts
Decision making/wisdom
Decision making/wisdom
Putting everything together and acting on the information
Four steps of data processing
Four steps of data processing
Group, Create hierarchies, Calculations, Using graphs
How Excel formulas must begin
How Excel formulas must begin
With an equals sign (=)
SUM function purpose
SUM function purpose
Calculates the total of a range of numbers
AVERAGE function purpose
AVERAGE function purpose
Gives the average of a range of values
MIN function purpose
MIN function purpose
Returns the minimum (smallest) value in a list
MAX function purpose
MAX function purpose
Returns the maximum (largest) value in a list
COUNTIF function purpose
COUNTIF function purpose
Counts how many times specific responses appear automatically