DOWNLOAD EFFECTIVE DAY ANALYSIS APPLICATION

We made this application for the Analysis of the Effective Day of Semester 2 for the 2020/2021 Academic Year we made using Microsoft Excel which is very easy to use, this application has been adjusted to the 2021 Year Calendar and the 2020/2021 Academic Year Calendar, so it is very suitable for use by every teacher starting from Pre-school, SD / MI, SMP / MTS and SMA / MA / SMK levels, can be used by all subjects.

On the sheet (CONTENT DATA HERE), all we need to do is fill in the data in the yellow column, starting from the school name data, lesson and class names, try to use all CAPITAL LETTERS and for class use ROMANIC LETTERS), then fill in the name of the school principal and NIP, Name of Subject Teacher and NIP, Place and Date and information for Semester 2 of the 2020/2021 school year.

In this sheet, if the initial steps have been taken, the school name data will automatically be filled in and we continue to fill in the data for the year, with the Year 2021, just fill in the yellow one and the results are as shown above, and for the column as well as on Monday - Saturday is filled based on the year 2021 calendar and adjusted to the educational calendar.

On this sheet, if the first and second steps have been filled in, we only need to fill in the Orange and yellow columns, the orange column is filled with the number of hours we teach in one lesson per week, for example Mathematics 5 JP / MG, then the orange column is filled in with 5, then with other subjects filled in according to their JP / MG. as for the yellow color is appropriate or tailored to the needs

If steps 1 to 3 have been filled in correctly, then on this Sheet we only need to fill in the JP / MG information on the day we teach, so it would be better if when we fill out this application we already have a lesson schedule, so we know what day we are teaching and in which class and how many hours in that class.

friends, we have provided the application download link, you just have to click the link and the analysis application will be automatically saved on your device (SAVE APPLICATION) Thanks