Spreadsheet: 89668d1289424572-sumproduct-formula-blake-7-sumproduct-for-forum
Sheet: AFS data sheet

Academy for Foundation Skills |  |  |  | Course Title | PROGRAMME AREA | Duration | Level | SSA | 2009/10: Lewisham College |  |  |  |  |  |  |  | 2008/09 National averages
Reference | Department Name | Status | Course Code |  |  |  |  |  | Starts (16-18) | Starts (adults) | Starts (total) | Completing | Achievements | [NAME] | Achievement % | Success % | [NAME] | Achievement % | Success %
AFS001 | Academy for Foundation Skills | FTMQ | CFLITXJA | Business & Finance L1 (Literacy qual) 16-18 (Nov Start) | FOUNDATION STUDIES | 1 | 1 | 14 | 16 |  |  | 14 | 12 |  |  |  |  |  |  | 100 | 89 | 82 | 73
AFS002 | Academy for Foundation Skills | FTAQ | IFFINDJA | Cert in Personal Finance | FOUNDATION STUDIES | 1 | 1 | 15 | 17 |  |  | 15 | 15 |  |  |  |  |  |  |  | 88 | 71 | 63
AFS003 | Academy for Foundation Skills | FTAQ | EFAWSDJA | [NAME] in WorkSkills (E3) | FOUNDATION STUDIES | 1 | 1 | 14 | 6 |  |  | 6 | 6 |  |  |  |  |  |  |  | 92 | 96 | 89
AFS005 | Academy for Foundation Skills | FTMQ | LFYOUXA | YEHE - Humanities Yr1 | HUMANITIES & SOCIAL SCIENCE | 1 | 2 | 11 | 23 |  |  | 21 | 21 |  |  |  |  |  |  |  | 71 | 91 | 65
AFS007 | Academy for Foundation Skills | FTMQ | LIYOUXA | YEHE - Humanities Yr2 | HUMANITIES & SOCIAL SCIENCE | 1 | 3 | 11 | 11 | 3 |  | 14 | 13 |  |  |  |  |  |  |  | 80 | 70 | 56
AFS009 | Academy for Foundation Skills | PTMQ | GCELAE0A | GCSE English (Eve) | BASIC SKILLS (INTERNAL) | 1 | 2 | 12 | 8 | 22 |  | 25 | 25 |  |  |  |  |  |  |  | 82 | 95 | 77
AFS010 | Academy for Foundation Skills | PTMQ | GCMATD0A | GCSE Maths (Day) | BASIC SKILLS (INTERNAL) | 1 | 2 | 2 | 4 | 19 |  | 14 | 14 |  |  |  |  |  |  |  | 85 | 94 | 81
AFS011 | Academy for Foundation Skills | PTMQ | GCMATD0B | GCSE Maths (Day) | 14-19 WRL and S4C | 1 | 2 | 2 | 5 | 13 |  | 14 | 11 |  |  |  |  |  |  |  | 85 | 94 | 81
AFS012 | Academy for Foundation Skills | PTMQ | GCMATE0A | GCSE Maths (Eve) | BASIC SKILLS (INTERNAL) | 1 | 2 | 2 | 7 | 23 |  | 24 | 23 |  |  |  |  |  |  |  | 85 | 94 | 81
AFS013 | Academy for Foundation Skills | PTMQ | GCMATE0B | GCSE Maths (Eve) | BASIC SKILLS (INTERNAL) | 1 | 2 | 2 | 14 | 15 |  | 20 | 19 |  |  |  |  |  |  |  | 85 | 94 | 81
AFS042 | Academy for Foundation Skills | PTMQ | BEABCDAA | Essential Skills Comms - Day L1 - Non Cert | BASIC SKILLS (INTERNAL) | S | 1 | 14 |  | 25 |  | 20 | 20 |  |  |  |  |  |  |  | 96 | 97 | 93
AFS043 | Academy for Foundation Skills | PTMQ | CFABCDJA | Essential Skills Comms - Day L1 (Prog From Above) | BASIC SKILLS (INTERNAL) | 1 | 1 | 14 |  | 18 |  | 18 | 15 |  |  |  |  |  |  |  | 89 | 82 | 73
AFS044 | Academy for Foundation Skills | PTMQ | BEABCDAB | Essential Skills Comms - Day L1 - Non Cert | BASIC SKILLS (INTERNAL) | S | 1 | 14 |  | 17 |  | 11 | 11 |  |  |  |  |  |  |  | 96 | 97 | 93
AFS045 | Academy for Foundation Skills | PTMQ | CFABCDJB | Essential Skills Comms - Day L1 (Prog From Above) | BASIC SKILLS (INTERNAL) | 1 | 1 | 14 |  | 10 |  | 10 | 8 |  |  |  |  |  |  |  | 86 | 84 | 72
AFS046 | Academy for Foundation Skills | PTMQ | CFABCDJC | Essential Skills Comms - Day E3 (Infill)
AFS047 | Academy for Foundation Skills | PTMQ | BEABCEAA | Essential Skills Comms - Evn L1 - Non Cert | BASIC SKILLS (INTERNAL) | S | 1 | 14 | 1 | 22 |  | 15 | 15 |  |  |  |  |  |  |  | 96 | 97 | 93
AFS048 | Academy for Foundation Skills | PTMQ | CFABCEJA | Essential Skills Comms - Evn L1 (Prog From Above) | BASIC SKILLS (INTERNAL) | 1 | 1 | 14 |  | 17 |  | 17 | 12 |  |  |  |  |  |  |  | 89 | 82 | 73
AFS049 | Academy for Foundation Skills | PTMQ | BEABCEAB | Essential Skills Comms - Evn L1 - Non Cert | BASIC SKILLS (INTERNAL) | S | 1 | 14 |  | 17 |  | 14 | 14 |  |  |  |  |  |  |  | 96 | 97 | 93
AFS050 | Academy for Foundation Skills | PTMQ | CFABCEJB | Essential Skills Comms - Evn L1 (Prog From Above) | BASIC SKILLS (INTERNAL) | S | 1 | 14 |  | 13 |  | 11 | 5 |  |  |  |  |  |  |  | 91 | 83 | 75
AFS051 | Academy for Foundation Skills | PTMQ | CFABCEJC | Essential Skills Comms - Eve E3 (Infill)
AFS052 | Academy for Foundation Skills | PTMQ | BEABCEAC | Essential Skills Comms - Evn L2 - Non Cert | BASIC SKILLS (INTERNAL) | S | 1 | 14 |  | 17 |  | 16 | 16 |  |  |  |  |  |  |  | 96 | 97 | 93
AFS053 | Academy for Foundation Skills | PTMQ | CFABCEJD | Essential Skills Comms - Evn L2 (Prog From Above) | BASIC SKILLS (INTERNAL) | 1 | 2 | 14 |  | 13 |  | 12 | 8 |  |  |  |  |  |  |  | 91 | 77 | 71
AFS054 | Academy for Foundation Skills | PTMQ | CFABCEJE | Essential Skills Comms - Eve L1 (Infill)
AFS055 | Academy for Foundation Skills | PTMQ | BELTEDAA | Literacy E1 (Non Cert)- Day | BASIC SKILLS (INTERNAL) | S | 1 | 14 |  | 16 |  | 15 | 15 |  |  |  |  |  |  |  | 96 | 97 | 93
AFS056 | Academy for Foundation Skills | PTMQ | BELTEDJA | Literacy E1- Day (Prog From Above) | BASIC SKILLS (INTERNAL) | 1 | 1 | 14 |  | 18 |  | 18 | 0 |  |  |  |  |  |  |  | 86 | 84 | 72
AFS057 | Academy for Foundation Skills | PTMQ | BELTEDAB | Literacy E2 (Non Cert) - Day | BASIC SKILLS (INTERNAL) | S | 1 | 14 |  | 16 |  | 12 | 12 |  |  |  |  |  |  |  | 96 | 97 | 93
AFS058 | Academy for Foundation Skills | PTMQ | BELTEDJB | Literacy E2 - Day (Prog From Above) | BASIC SKILLS (INTERNAL) | 1 | 1 | 14 |  | 12 |  | 11 | 11 |  |  |  |  |  |  |  | 86 | 84 | 72
AFS059 | Academy for Foundation Skills | PTMQ | BELTEDAC | Literacy E3 (Non Cert) - Day | BASIC SKILLS (INTERNAL) | S | 1 | 14 |  | 19 |  | 17 | 17 |  |  |  |  |  |  |  | 96 | 97 | 93
AFS060 | Academy for Foundation Skills | PTMQ | BELTEDJC | Literacy E3 - Day (Prog From Above) | BASIC SKILLS (INTERNAL) | 1 | 1 | 14 |  | 22 |  | 19 | 17 |  |  |  |  |  |  |  | 86 | 84 | 72
AFS061 | Academy for Foundation Skills | PTMQ | BELTEDFA | Literacy E3 (Non Cert) - Day (Feb start) | BASIC SKILLS (INTERNAL) | S | 1 | 14 |  | 5 |  | 3 | 3 |  |  |  |  |  |  |  | 96 | 97 | 93
AFS062 | Academy for Foundation Skills | PTMQ | BELTEDCA | Literacy E3 - Day (Prog From Above)
AFS063 | Academy for Foundation Skills | PTMQ | BELTEEAA | Literacy E3 (Non Cert) - Eve | BASIC SKILLS (INTERNAL) | S | 1 | 14 |  | 16 |  | 15 | 15 |  |  |  |  |  |  |  | 96 | 97 | 93
AFS064 | Academy for Foundation Skills | PTMQ | BELTEEJA | Literacy E3 - Eve (Prog From Above) | BASIC SKILLS (INTERNAL) | 1 | 1 | 14 |  | 12 |  | 12 | 8 |  |  |  |  |  |  |  | 86 | 84 | 72
AFS065 | Academy for Foundation Skills | PTMQ | BEABNEAA | Essential Skills Nums - Evn E3 - Non Cert | BASIC SKILLS (INTERNAL) | S | 1 | 14 |  | 18 |  | 16 | 16 |  |  |  |  |  |  |  | 95 | 97 | 92
AFS066 | Academy for Foundation Skills | PTMQ | CFABNEJA | Essential Skills Nums - Evn E3 (Prog From Above) | BASIC SKILLS (INTERNAL) | 1 | 1 | 14 |  | 9 |  | 9 | 7 |  |  |  |  |  |  |  | 88 | 86 | 76
AFS067 | Academy for Foundation Skills | PTMQ | CFABNEJD | Essential Skills Nums - Evn L1 |(Infill) | BASIC SKILLS (INTERNAL) | 1 | 1 | 14 |  | 1 |  | 1 | 1 |  |  |  |  |  |  |  | 89 | 84 | 75
AFS068 | Academy for Foundation Skills | PTMQ | BEABNEAB | Essential Skills Nums - Evn L1 - Non Cert | BASIC SKILLS (INTERNAL) | S | 1 | 14 |  | 20 |  | 17 | 17 |  |  |  |  |  |  |  | 95 | 97 | 92
AFS069 | Academy for Foundation Skills | PTMQ | CFABNEJB | Essential Skills Nums - Evn L1 (Prog From Above) | BASIC SKILLS (INTERNAL) | 1 | 1 | 14 |  | 17 |  | 15 | 13 |  |  |  |  |  |  |  | 88 | 86 | 76
AFS070 | Academy for Foundation Skills | PTMQ | CFABNEJE | Essential Skills Nums - Evn E3 |(Infill) | BASIC SKILLS (INTERNAL) | 1 | 1 | 14 |  | 2 |  | 1 | 1 |  |  |  |  |  |  |  | 88 | 86 | 76
AFS071 | Academy for Foundation Skills | PTMQ | [NAME] | [NAME] (Non Cert) - Eve | BASIC SKILLS (INTERNAL) | S | 1 | 14 | 1 | 17 |  | 11 | 11 |  |  |  |  |  |  |  | 95 | 97 | 92
AFS072 | Academy for Foundation Skills | PTMQ | BENM2EJA | [NAME] (Prog From Above) | BASIC SKILLS (INTERNAL) | 1 | 1 | 14 | 1 | 10 |  | 10 | 8 |  |  |  |  |  |  |  | 89 | 84 | 75
AFS073 | Academy for Foundation Skills | PTMQ | BENMADAA | Numeracy E3 (Non Cert) - Day | BASIC SKILLS (INTERNAL) | S | 1 | 14 |  | 16 |  | 12 | 12 |  |  |  |  |  |  |  | 95 | 97 | 92
AFS074 | Academy for Foundation Skills | PTMQ | BENMEDJA | Numeracy E3  -Day (Prog From Above) | BASIC SKILLS (INTERNAL) | 1 | 1 | 14 |  | 10 |  | 10 | 9 |  |  |  |  |  |  |  | 88 | 86 | 76
AFS075 | Academy for Foundation Skills | PTMQ | BENMADFA | Numeracy E3 (Non Cert) - Day (Feb start) | BASIC SKILLS (INTERNAL) | S | 1 | 14 |  | 5 |  | 5 | 5 |  |  |  |  |  |  |  | 95 | 97 | 92
AFS076 | Academy for Foundation Skills | PTMQ | BENMADCA | Numeracy E3  -Day (Prog From Above) | BASIC SKILLS (INTERNAL) | S | 1 | 14 |  | 4 |  | 3 | 2 |  |  |  |  |  |  |  | 92 | 86 | 79
AFS077 | Academy for Foundation Skills | FTMQ | [NAME] | Adult Learners (Foundation) Literacy CG E1/2 | BASIC SKILLS (INTERNAL) | S | 1 | 14 |  | 13 |  | 8 | 8 |  |  |  |  |  |  |  | 90 | 86 | 77
AFS078 | Academy for Foundation Skills | FTMQ | [NAME] | Adult Learners (Foundation) Literacy CG E1/E2 | BASIC SKILLS (INTERNAL) | 1 | 1 | 14 |  | 15 |  | 14 | 11 |  |  |  |  |  |  |  | 86 | 84 | 72
AFS079 | Academy for Foundation Skills | FTMQ | BEALCDSB | Adult Learners (Foundation) Literacy CG E3/L1 | BASIC SKILLS (INTERNAL) | S | 1 | 14 |  | 7 |  | 4 | 4 |  |  |  |  |  |  |  | 90 | 86 | 77
AFS080 | Academy for Foundation Skills | FTMQ | BEALCDFB | Adult Learners (Intermediate) Literacy CG E3/L1 | BASIC SKILLS (INTERNAL) | 1 | 1 | 14 |  | 20 |  | 19 | 6 |  |  |  |  |  |  |  | 86 | 84 | 72
AFS081 | Academy for Foundation Skills | FTMQ | BEALCDSC | [NAME] (Advanced) Literacy CG L2 | BASIC SKILLS (INTERNAL) | S | 2 | 14 |  | 4 |  | 0 | 0 |  |  |  |  |  |  |  | 95 | 85 | 80
AFS082 | Academy for Foundation Skills | FTMQ | BEALCDFC | [NAME] (Advanced) Literacy CG L2 | BASIC SKILLS (INTERNAL) | 1 | 2 | 14 |  | 20 |  | 18 | 9 |  |  |  |  |  |  |  | 91 | 77 | 71
AFS083 | Academy for Foundation Skills | FTMQ | BEALCDSD | Adult Learners (Foundation) Literacy CG E3/L1 | BASIC SKILLS (INTERNAL) | S | 1 | 14 |  | 7 |  | 2 | 0 |  |  |  |  |  |  |  | 90 | 86 | 77
AFS084 | Academy for Foundation Skills | FTMQ | BEALCDFD | Adult Learners (Foundation) Literacy CG E3/L1 | BASIC SKILLS (INTERNAL) | 1 | 1 | 14 |  | 14 |  | 14 | 10 |  |  |  |  |  |  |  | 86 | 84 | 72
AFS085 | Academy for Foundation Skills | PTMQ | APCDPE0A | Cert In British Sign Language CACDP | SIGN LANGUAGE | 1 | 1 | 12 | 2 | 11 |  | 9 | 3
AFS086 | Academy for Foundation Skills | PTMQ | APCDPE0B | Cert In British Sign Language CACDP | SIGN LANGUAGE | 1 | 1 | 12 | 4 | 12 |  | 15 | 12
AFS087 | Academy for Foundation Skills | PTMQ | BEDYSD0A | [NAME] (Skills Upgrade) | BASIC SKILLS (INTERNAL) | 1 | 1 | 14 |  | 11 |  | 9 | 9 |  |  |  |  |  |  |  | 94 | 98 | 91
Academy for Foundation Skills SUB TOTAL total:
Missing |  |  | BEICTD0A | BASIC IT ENTRY (FDN SKILLS) w=ABE | BASIC SKILLS (INTERNAL) | 1 | 1 | 6 | 2 |  | 2 | 2 | 2 |  |  |  |  |  |  |  | 93 | 88 | 81
 |  |  | BELITD0A | BASIC LIT CG ENTRY (FDN SKILLS) w=S4L | BASIC SKILLS (INTERNAL) | 1 | 1 | 14 | 6 |  | 6 | 6 | 6 |  |  |  |  |  |  |  | 86 | 84 | 72
 |  |  | BENUMD0A | BASIC NUM CG ENTRY (FDN SKILLS) w=S4L | BASIC SKILLS (INTERNAL) | 1 | 1 | 14 | 10 | 23 | 33 | 32 | 27 |  |  |  |  |  |  |  | 88 | 86 | 76
 |  |  | BESAAD01 | BASIC NUM EDEXCEL L1 (FDN SKILLS) w=S4L | BASIC SKILLS (INTERNAL) | 1 | 1 | 14 | 23 | 38 | 61 | 59 | 44 |  |  |  |  |  |  |  | 89 | 84 | 75
 |  |  | BESAAD02 | BASIC NUM EDEXCEL L2 (FDN SKILLS) w=S4L | BASIC SKILLS (INTERNAL) | 1 | 2 | 14 | 8 | 15 | 23 | 23 | 13 |  |  |  |  |  |  |  | 91 | 75 | 68
 |  |  | BESACD01 | BASIC LIT EDEXCEL L1 (FDN SKILLS) w=S4L | BASIC SKILLS (INTERNAL) | 1 | 1 | 14 | 21 | 12 | 33 | 32 | 22 |  |  |  |  |  |  |  | 89 | 82 | 73
 |  |  | BESACD02 | BASIC LIT EDEXCEL L2 (FDN SKILLS) w=S4L | BASIC SKILLS (INTERNAL) | 1 | 2 | 14 | 8 | 9 | 17 | 16 | 8 |  |  |  |  |  |  |  | 91 | 77 | 71
Academy for Foundation Skills GRAND total:
 |  |  | Count if |  | Starts (total) | Completing | Achievements
 |  |  |  | Business & Finance L1 (Literacy qual) 16-18 (Nov Start) | i would like the sumproduct for cell e75 from Col L3;L58 but for STARTS Col L | same but for col m M3;M58 | same but for col N N3;N58
 |  |  |  | Cert in Personal Finance | same as above but for cell e76 | same as above but for cell e77 | same as above but for cell e78
 |  |  |  | [NAME] in WorkSkills (E3)
 |  |  |  | YEHE - Humanities Yr1
 |  |  |  | YEHE - Humanities Yr2
 |  |  |  | GCSE English (Eve)
 |  |  |  | GCSE Maths (Day)
 |  |  |  | GCSE Maths (Eve)
 |  |  |  | Essential Skills Comms - Day L1 - Non Cert
 |  |  |  | Essential Skills Comms - Day L1 (Prog From Above)
 |  |  |  | Essential Skills Comms - Day E3 (Infill)
 |  |  |  | Essential Skills Comms - Evn L1 - Non Cert
 |  |  |  | Essential Skills Comms - Evn L1 (Prog From Above)
 |  |  |  | Essential Skills Comms - Eve E3 (Infill)
 |  |  |  | Essential Skills Comms - Evn L2 - Non Cert
 |  |  |  | Essential Skills Comms - Evn L2 (Prog From Above)
 |  |  |  | Essential Skills Comms - Eve L1 (Infill)
 |  |  |  | Literacy E1 (Non Cert)- Day
 |  |  |  | Literacy E1- Day (Prog From Above)
 |  |  |  | Literacy E2 (Non Cert) - Day
 |  |  |  | Literacy E2 - Day (Prog From Above)
 |  |  |  | Literacy E3 (Non Cert) - Day
 |  |  |  | Literacy E3 - Day (Prog From Above)
 |  |  |  | Literacy E3 (Non Cert) - Day (Feb start)
 |  |  |  | Literacy E3 (Non Cert) - Eve
 |  |  |  | Literacy E3 - Eve (Prog From Above)
 |  |  |  | Essential Skills Nums - Evn E3 - Non Cert
 |  |  |  | Essential Skills Nums - Evn E3 (Prog From Above)
 |  |  |  | Essential Skills Nums - Evn L1 |(Infill)
 |  |  |  | Essential Skills Nums - Evn L1 - Non Cert
 |  |  |  | Essential Skills Nums - Evn L1 (Prog From Above)
 |  |  |  | Essential Skills Nums - Evn E3 |(Infill)
 |  |  |  | [NAME] (Non Cert) - Eve
 |  |  |  | [NAME] (Prog From Above)
 |  |  |  | Numeracy E3 (Non Cert) - Day
 |  |  |  | Numeracy E3  -Day (Prog From Above)
 |  |  |  | Numeracy E3 (Non Cert) - Day (Feb start)
 |  |  |  | Adult Learners (Foundation) Literacy CG E1/2
 |  |  |  | Adult Learners (Foundation) Literacy CG E1/E2
 |  |  |  | Adult Learners (Foundation) Literacy CG E3/L1
 |  |  |  | Adult Learners (Intermediate) Literacy CG E3/L1
 |  |  |  | [NAME] (Advanced) Literacy CG L2
 |  |  |  | Cert In British Sign Language CACDP
 |  |  |  | [NAME] (Skills Upgrade)
 |  |  |  | BASIC IT ENTRY (FDN SKILLS) w=ABE
 |  |  |  | BASIC LIT CG ENTRY (FDN SKILLS) w=S4L
 |  |  |  | BASIC NUM CG ENTRY (FDN SKILLS) w=S4L
 |  |  |  | BASIC NUM EDEXCEL L1 (FDN SKILLS) w=S4L
 |  |  |  | BASIC NUM EDEXCEL L2 (FDN SKILLS) w=S4L
 |  |  |  | BASIC LIT EDEXCEL L1 (FDN SKILLS) w=S4L
 |  |  |  | BASIC LIT EDEXCEL L2 (FDN SKILLS) w=S4L