Data Analysis ICT 0417 May/June 2020 IGCSE

Teaching and learning, and many opportunities for its application have yet to be explored. Spreadsheet software is one of the most-used technologies for collecting, computing, and displaying data. Spreadsheets contain a rectangular array of cells in rows and columns that can hold data. Users can create business models, graphs and charts, and reports for financial, statistical, or other data. Most spreadsheet software allows a user to access real-time data from Web sites and to collaborate across teams and workgroups.
 * 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