IGCSE ICT 0417 Oct / Nov 2015 P3 Data Analysis

 * Presentation – Complete video for teachers and learners on Data Analysis
 * IGCSE Practice Revision Exercise which covers all the related concepts required for students to unravel any IGCSE Exam Style Data Analysis Questions
 * Learner will be able to say authoritatively that, I can use:
 The TEXT Function. ...
 The VLOOKUP Function. ...
 The AVERAGE Function. ...
 The CONCATENATE Function
 LEN. ...
 COUNTA. ...
 DAYS/NETWORKDAYS. ...
 SUMIFS. ...
 AVERAGEIFS. ...
 HLOOKUP ….
 FIND/SEARCH.
 Create a payroll sheet in Excel?
 Review Payroll Excel Template & Edit for Your Business. ...
 Set Up Payroll Information for Each Employee. ...
 Set Up Employer Payroll Tax Information. ...
 Enter Hours Worked. ...
 Review Automatic Payroll Calculations.
 Apply the knowledge of linear Data Analysis in the various fields of study: business, economics, engineering...
 Also models life situation such as: transportation, energy, telecommunications, manufacturing…etc with my knowledge of Data Analysis