Applications Software Lessons

Applications Software Lessons (11)

Most of often we don't know whether this background sounds we used in our video has its own copyright and after doing and uploading our video to YouTube we see that its can’t be monetize due to these kinds of background music.

In this video tutorial you can learn all about Online Database Management Systems developed by KDKTEC.

When you walk around the place where you live, most of the times, you feel pretty safe and comfortable, right? Now imagine if there were land mines buried right here, scattered around, and you'd never know when you might step on one.

This formula will find Dropout, Vacated and Graduated status according to number of months trainees attended to the Vocational Training Centre
Example Data used are as follows;
 
Click here to download sample data Excel file.
 
Conditions are as follows;
1. If trainee is in Baker (BEK) course and attendance are lower than 1.5 months he or she will be marked as "Dropout"

2. If trainee is in Computer (COM) course and attendance are lower than 1.5 months he or she will be marked as "Dropout"
 

3. If trainee is in Automobile Mechanics (MOM) course and attendance are lower than 3 months he or she will be marked as "Dropout"

4. If trainee is in Electric (ELT) course and attendance are lower than 3 months he or she will be marked as "Dropout"

5. If trainee is in Carpenter (CAR) course and attendance are lower than 3 months he or she will be marked as "Dropout"

6. If trainee is in Welder (WEL) course and attendance are lower than 3 months he or she will be marked as "Dropout"

7. If trainees are attended lower than 9 months they are marked as "Vacated" and if not, that mean if they are attended greater than 9 months they are calculated as graduated.
 
8. If trainee received the NVQ certificate and marked as “Yes” in NVQ Graduated column, they are marked as “NVQ Graduated”

Full formula:

Yellow colored part of the formula will hide all the #NUM! Errors and show 0 instead of #NUM!. This #NUM! value will be displayed when either “Admission date” or “Departure Date” cells are empty.

Join Our YouTube Channel

පරිගණක විද්‍යාව ගැන, හැකින් ගැන, මනෝවිද්‍යාත්මක කරුණු වගේම මුල්‍ය ශාක්ෂරතාවය පිළිබඳ වීඩියෝ පාඩම් සිංහලෙන්ම ඉගෙන ගන්න ඔබත් අදම මේ දැන්ම මගේ YouTube නාලිකාවත් සමඟ එකතු වෙන්න. එන්න පහත ලින්ක් එකට ගිහින් Subscribe කරන්න.
Link: https://www.youtube.com/c/KDKTECICTProfessionalsInSriLanka 

Articles Archive

Articles Calendar

« August 2019 »
Mon Tue Wed Thu Fri Sat Sun
      1 2 3 4
5 6 7 8 9 10 11
12 13 14 15 16 17 18
19 20 21 22 23 24 25
26 27 28 29 30 31  
002918069
Today
Yesterday
This Week
Last Week
This Month
Last Month
All days
2920
9467
37627
2355258
102260
212608
2918069
Your IP: 18.232.53.231
2019-08-22 08:02

Video Of The Day

Subscribe to PC WORLD Magazine

Joomla forms builder by JoomlaShine
Go to top