CAT PAT TIPS | Phase 2 | Spreadsheet Formula Tips
If you do CAT as a subject in South Africa then you will be aware of the PAT that is an important component of our final mark for CAT. These videos are here to give you with tips and ideas that can help you not only complete your PAT but maximise the marks you can obtain. This video focuses on the formulas you need to complete for the Phase 2 Spreadsheet (Excel) component.
Other videos in the CAT PAT TIPS series
Phase 1 Tips before you get started –
Phase 2 Questionnaire Planning –
Phase 2 Spreadsheet Layout –
Phase 2 Spreadsheet Getting External Data –
Phase 2 Spreadsheet Formulas –
Phase 2 Spreadsheet Charts –
Phase 2 Database Tables –
Phase 2 Database Queries –
Phase 2 Database Reports –
Phase 3 Website Layout Tips –
Phase 3 Website Convert charts into images –
Phase 3 Website Special tags –
Phase 3 Website General Tips –
Also look at the following playlist from Claire Smuts for a step by step walkthrough to help complete your PAT.
#MrLongEducation #CAT #PAT
0:00 Introduction
2:00 Level 1 Formulas (MODE, AVERAGE)
4:25 Level 2 Formulas (COUNTIF)
7:15 Level 3 Formulas (COUNTIFS, DATE)
15:27 Level 4 Formulas (VLOOKUP)
Original Source Link
