Thursday, May 16, 2019

Computer Centrums South Africa.

16-May-2019 :- [ ] >< #program #update #statistics; {software}{info update} > uses: crt,statistics,printer; var: a,integer; #fileserver:\\My-Backup\; database: #dbo.schoolsinsa, #centreserver; networkstatus : true; > begin {GR1-GR12} clrscr; writeln(ans); readln(ans); if answer = true then do begin > Select all from #schoolsinsa where learners>0 and computersubject = 'pass' insert into results Select all from #schoolsinsa where #computercentre = 'true' and #computereducator = 'false' Select all from #computereducator where #computercentre = 'false' Select all from #computercentre where #computereducator = 'true' and #computercentre = 'true' Select all from results insert into #computerfile having learners = 9899000 Select * from #computereducator where #computerfile = 'true' having #schoolsinsa = 24000 Select * from Gr1-Gr12 where subject = #computersubject Select * from saschools having saschools = 24000 where computer file = 'true' and computereducator = 'true' Having learners = 9899000 where pass = 'true' divide passcount with learners; > write (' - The percentage of all learners pass of all learners with subject computers = 0,003% - The number of learners with computers = 5000 where the number of learners pass = 5000 - There are 24000 computereducators for 9899000 computerlearners. - There is 1 computereducator for every 412 learners - For every 2 computereducators there are 844 learners. - For every 3 computereducators there are 1236 learners. - The current number of computereducators is = 2 - The current number of computerlearners 4949500 for the current number per computereducator. - There are 468 computerconsultants, 168 computerstudents, 2 computereducators and 46 computerlearners per computer educator, consultant or student. - There is 1 computer per computerlearner. - There are 46 computers for 46 computerlearners. - There are 46 computers for every 412 learners and 1 computerconsultant, computerstudent or computereducator for every 412 learners and 46 computers. - There are 638 computerconsultants, computerstudents or computereducators for 24000 schools and 9899000 learners. > - 24 000x75 000 = 1800 000 000 - 75 000/500 = 150 - 412*150 = 61 800 = 48 600 > Fee Structure Primary and High = R113.50 to R150 p/learner with up to R20 discount per learner. - R80 per learner or R400 per computer. > Consultant Primary and High (3y) contract. (Salary) 11 000 - (13200) p/m - R40 per learner per month. > Consultant Salaries :- 316 800 000 Consultants :- 24 000 Centrums :- 24 000 Allocated :- 1800 000 000 > :-1483 200 000 > Management - xxx [ ] - pro services Software - xxx [ ] - updates Curriculum/Syllabys - xxx [ ] - updates > :- xxx); > end; [24000]x[412] [5000]/[9899000] readln; end; Assessment [6]to[1] - [1]to[6] Outcomes : [1-3] of 5 ... end.

Info Update

16-May-2019 :- [ ] >< #program #update #statistics; {software}{info update} > uses: crt,statistics,printer; var: a,integer; #fileserver:\\My-Backup\; database: #dbo.schoolsinsa, #centreserver; networkstatus : true; > begin {GR1-GR12} clrscr; writeln(ans); readln(ans); if answer = true then do begin > Select all from #schoolsinsa where learners>0 and computersubject = 'pass' insert into results Select all from #schoolsinsa where #computercentre = 'true' and #computereducator = 'false' Select all from #computereducator where #computercentre = 'false' Select all from #computercentre where #computereducator = 'true' and #computercentre = 'true' Select all from results insert into #computerfile having learners = 9899000 Select * from #computereducator where #computerfile = 'true' having #schoolsinsa = 24000 Select * from Gr1-Gr12 where subject = #computersubject Select * from saschools having saschools = 24000 where computer file = 'true' and computereducator = 'true' Having learners = 9899000 where pass = 'true' divide passcount with learners; > write (' - The percentage of all learners pass of all learners with subject computers = 0,003% - The number of learners with computers = 5000 where the number of learners pass = 5000 - There are 24000 computereducators for 9899000 computerlearners. - There is 1 computereducator for every 412 learners - For every 2 computereducators there are 844 learners. - For every 3 computereducators there are 1236 learners. - The current number of computereducators is = 2 - The current number of computerlearners 4949500 for the current number per computereducator. - There are 468 computerconsultants, 168 computerstudents, 2 computereducators and 46 computerlearners per computer educator, consultant or student. - There is 1 computer per computerlearner. - There are 46 computers for 46 computerlearners. - There are 46 computers for every 412 learners and 1 computerconsultant, computerstudent or computereducator for every 412 learners and 46 computers. - There are 638 computerconsultants, computerstudents or computereducators for 24000 schools and 9899000 learners. > - 24 000x75 000 = 1800 000 000 - 75 000/500 = 150 - 412*150 = 61 800 = 48 600 > Fee Structure Primary and High = R113.50 to R150 p/learner with up to R20 discount per learner. - R80 per learner or R400 per computer. > Consultant Primary and High (3y) contract. (Salary) 11 000 - (13200) p/m - R40 per learner per month. > Consultant Salaries :- 316 800 000 Consultants :- 24 000 Centrums :- 24 000 Allocated :- 1800 000 000 > :-1483 200 000 > Management - xxx [ ] - pro services Software - xxx [ ] - updates Curriculum/Syllabys - xxx [ ] - updates > :- xxx); > end; [24000]x[412] [5000]/[9899000] readln; end; Assessment [6]to[1] - [1]to[6] Outcomes : [1-3] of 5 ... end.

18 May

18-May-2019 :- [ ] >< #program #update #statistics; {software} > uses: crt,statistics,printer; var: a,integer; #fileserver:\\My-Backup\; database: #dbo.schoolsinsa, #centreserver; networkstatus : true; > begin clrscr; writeln(ans); readln(ans); if answer = true then do begin > Select all from #schoolsinsa where learners>0 and computersubject = 'pass' insert into results Select all from #schoolsinsa where #computercentre = 'true' and #computereducator = 'false' Select all from #computereducator where #computercentre = 'false' Select all from #computercentre where #computereducator = 'true' and #computercentre = 'true' Select all from results insert into #computerfile having learners = 9899000 Select * from #computereducator where #computerfile = 'true' having #schoolsinsa = 24000 Select * from Gr1-Gr12 where subject = #computersubject Select * from saschools having saschools = 24000 where computer file = 'true' and computereducator = 'true' Having learners = 9899000 where pass = 'true' divide passcount with learners; > write (' - The percentage of all learners pass of all learners with subject computers = 0,003% - The number of learners with computers = 5000 where the number of learners pass = 5000 - There are 24000 computereducators for 9899000 computerlearners. - There is 1 computereducator for every 412 learners - For every 2 computereducators there are 844 learners. - For every 3 computereducators there are 1236 learners. - The current number of computereducators is = 2 - The current number of computerlearners 4949500 for the current number per computereducator. - There are 468 computerconsultants, 168 computerstudents, 2 computereducators and 46 computerlearners per computer educator, consultant or student. - There is 1 computer per computerlearner. - There are 46 computers for 46 computerlearners. - There are 46 computers for every 412 learners and 1 computerconsultant, computerstudent or computereducator for every 412 learners and 46 computers. - There are 638 computerconsultants, computerstudents or computereducators for 24000 schools and 9899000 learners. > - 24 000x75 000 = 1800 000 000 - 75 000/500 = 150 - 412*150 = 61 800 = 48 600 > Fee Structure Primary and High = R113.50 to R150 p/learner with up to R20 discount per learner. - R80 per learner or R400 per computer. > Consultant Primary and High (3y) contract. (Salary) 11 000 - (13200) p/m - R40 per learner per month. > Consultant Salaries :- 316 800 000 Consultants :- 24 000 Centrums :- 24 000 Allocated :- 1800 000 000 > :-1483 200 000 > Management - xxx [ ] - pro services Software - xxx [ ] - updates Curriculum - xxx [ ] - updates > :- xxx); > end; [24000]x[412] [5000]/[9899000] readln; end; Assessment [6]to[1] - [1]to[6] Outcomes : [1-3] of 5 ... end.

Computer Classes ...

Dear follower - I provide the following Computer Classes in the following Computer Subjects : Computer Typing Word, Excel, PowerPoint, Access, Internet and Email. Price : R80 pm Place : Lichtenburg (Monday - Friday) Contact : Renier Knoetzen : 0788126420, rknoetzen@gmail.com

Current Summary ...

15-May-2019 :- [ ] >< #program #update #statistics; {software} > uses: crt,statistics,printer; var: a,integer; #fileserver:\\My-Backup\; database: #dbo.schoolsinsa, #centreserver; networkstatus : true; > begin clrscr; writeln(ans); readln(ans); if answer = true then do begin > Select all from #schoolsinsa where learners>0 and computersubject = 'pass' insert into results Select all from #schoolsinsa where #computercentre = 'true' and #computereducator = 'false' Select all from #computereducator where #computercentre = 'false' Select all from #computercentre where #computereducator = 'true' and #computercentre = 'true' Select all from results insert into #computerfile having learners = 9899000 Select * from #computereducator where #computerfile = 'true' having #schoolsinsa = 24000 Select * from Gr1-Gr12 where subject = #computersubject Select * from saschools having saschools = 24000 where computer file = 'true' and computereducator = 'true' Having learners = 9899000 where pass = 'true' divide passcount with learners; > write (' - The percentage of all learners pass of all learners with subject computers = 0,003% - The number of learners with computers = 5000 where the number of learners pass = 5000 - There are 24000 computereducators for 9899000 computerlearners. - There is 1 computereducator for every 412 learners - For every 2 computereducators there are 844 learners. - For every 3 computereducators there are 1236 learners. - The current number of computereducators is = 2 - The current number of computerlearners 4949500 for the current number per computereducator. - There are 468 computerconsultants, 168 computerstudents, 2 computereducators and 46 computerlearners per computer educator, consultant or student. - There is 1 computer per computerlearner. - There are 46 computers for 46 computerlearners. - There are 46 computers for every 412 learners and 1 computerconsultant, computerstudent or computereducator for every 412 learners and 46 computers. - There are 638 computerconsultants, computerstudents or computereducators for 24000 schools and 9899000 learners. > - 24 000x75 000 = 1800 000 000 - 75 000/500 = 150 - 412*150 = 61 800 = 48 600 > Fee Structure Primary and High = R113.50 to R150 p/learner with up to R20 discount per learner. - > Consultant Primary and High (3y) contract. (Salary) 11 000 - (13200) p/m - R40 per learner per month. > Consultant Salaries :- 316 800 000 Consultants :- 24 000 Centrums :- 24 000 Allocated :- 1800 000 000 > :-1483 200 000 > Management - xxx [ ] - pro services Software - xxx [ ] - updates Curriculum - xxx [ ] - updates > :- xxx); > end; [24000]x[412] [5000]/[9899000] readln; end; Assessment [6]to[1] - [1]to[6] Outcomes : [1-3] of 5 ... end.

Update ...

Select Insert Update Inner Join Truncate Grant Backup Update Statistics Backup Restore

Edu

9-May-2019 :- #Education :- #update #statistics P9 - National Co-Ordinator. (79k)/pm << P7 - District Co-Ordinator. P6 - Subject Advisor. (38k)/pm P5 - Principal or Deputy with Doctorate. P4 - Principal, Subject Advisor with Masters. P3 - HOD, Deputy or Principal. (38k)/pm P1 - Teacher. (19k)/pm - Consultant (13k) P0 - Student. (8k)/pm << #nationalcurriculum #dept #education #computersineducation . 2 policies in front of file ... 1. Rules of School. 2. Subject. 3. Lessons. #backuptoserver

Sql Commands

Select Insert Update Inner Join Truncate Grant Backup Update Statistics Backup Restore

Select

select all from computereducators inner join computereducators with consultants where salary = '13200' and learners>400 group by name

15 May

15-May-2019 :- [ ] >< #program #update #statistics; {software} > uses: crt,statistics,printer; var: a,integer; #fileserver:\\My-Backup\; database: #dbo.schoolsinsa, #centreserver; networkstatus : true; > begin clrscr; writeln(ans); readln(ans); if answer = true then do begin > Select all from #schoolsinsa where learners>0 and computersubject = 'pass' insert into results Select all from #schoolsinsa where #computercentre = 'true' and #computereducator = 'false' Select all from #computereducator where #computercentre = 'false' Select all from #computercentre where #computereducator = 'true' and #computercentre = 'true' Select all from results insert into #computerfile having learners = 9899000 Select * from #computereducator where #computerfile = 'true' having #schoolsinsa = 24000 Select * from Gr1-Gr12 where subject = #computersubject Select * from saschools having saschools = 24000 where computer file = 'true' and computereducator = 'true' Having learners = 9899000 where pass = 'true' divide passcount with learners; > write (' - The percentage of all learners pass of all learners with subject computers = 0,003% - The number of learners with computers = 5000 where the number of learners pass = 5000 - There are 24000 computereducators for 9899000 computerlearners. - There is 1 computereducator for every 412 learners - For every 2 computereducators there are 844 learners. - For every 3 computereducators there are 1236 learners. - The current number of computereducators is = 2 - The current number of computerlearners 4949500 for the current number per computereducator. - There are 468 computerconsultants, 168 computerstudents, 2 computereducators and 46 computerlearners per computer educator, consultant or student. - There is 1 computer per computerlearner. - There are 46 computers for 46 computerlearners. - There are 46 computers for every 412 learners and 1 computerconsultant, computerstudent or computereducator for every 412 learners and 46 computers. - There are 638 computerconsultants, computerstudents or computereducators for 24000 schools and 9899000 learners. > - 24 000x75 000 = 1800 000 000 - 75 000/500 = 150 - 412*150 = 61 800 = 48 600 > Fee Structure Primary and High = R113.50 to R150 p/learner with up to R20 discount per learner. - > Consultant Primary and High (3y) contract. (Salary) 11 000 - (13200) p/m - R40 per learner per month. > Consultant Salaries :- 316 800 000 Consultants :- 24 000 Centrums :- 24 000 Allocated :- 1800 000 000 > :-1483 200 000 > Management - xxx [ ] - pro services Software - xxx [ ] - updates Curriculum - xxx [ ] - updates > :- xxx); > end; [24000]x[412] [5000]/[9899000] readln; end; Assessment [6]to[1] - [1]to[6] Outcomes : [1-3] of 5 ... end.