Take this opportunity to practice your hands, and it can also be used as a work summary. In case someone comes back, just use it as a textbook. Don't be childish, gods.
First, the improvement and release of the curriculum.
This is the previous master schedule. Please allow me to do something to protect my privacy. Each color block cell has its own special meaning, and the red font is a kind of cancellation for some reason. Generally speaking, monks in Zhang Er seem to be confused? When I first took over, my predecessors said, "Don't you understand? Just get used to it. " A little. But I didn't feel the pressure at that time. Maybe I was born with color.
Then the problem is coming.
Q 1, red font grid is harmful to statistics.
However, when it is necessary to select cancelled classes and make statistics of effective classes for a week or a month, the problem comes-deleting them one by one-and copying them into another table for operation, because these cancelled classes also need to be kept because of the hidden information-and it often takes special time and energy to delete the grid, because the wrong point will cause data errors. The seniors said with a smile: Our computer either needs a mouse or needs to be deleted.
It doesn't matter if you spend hardware, hardware is used; But, no trouble? That's what predecessors did ... but what if they were wrong? -Check the original form again. That's why you copied it out ...
Q2。 The schedule to be published needs typesetting.
The class schedule for the next few days will be sent to the teacher at a fixed time every day. In view of the fact that several predecessors are Virgos or perfectionists, the class schedule sent out needs to have blank rating lines to distinguish time periods, and the borders of cells should be clear and there should be no spaces. "This step is also very simple," the seniors said, but you still need to copy it into another table-because you need to delete the past date column of the week that needs to be kept in the general curriculum, and at the same time, you need to reflect the time period column. -every day, it is also very complicated.
In connection with this, this "method" is the same, but you can't use * * *, just do more work (even more than once).
This is my improved master schedule. Just solving the above two "troubles" is a bit different.
A 1。 Cancelled classes will be immediately moved to the blank cell below each time period. One advantage of instant operation is that it saves time. Anyway, marking red means operating cells, not afraid of Dora. It's more troublesome than doing the work later.
After a week, move these red squares to the blank columns on the right (those columns are not needed anyway). It's refreshing to look at it, not to mention how convenient it is to count-just click the box in the lower right corner according to the time period (row group) or date (column) (this is the basic function of Excel, so don't say it). And by the way, I also counted the number of classes cancelled every week. It is convenient to calculate the ratio of effective class hours to invalid class hours. At the weekly meeting, the leader asked to cancel several classes, so you don't have to be embarrassed.
Then it is certainly easier to do weekly statistics-just take the left part. You don't have to delete the grid anymore. (covering his face)
A2。 It's easier said than done to release the timetable. There is no need to build another table at all. Just "hide" unnecessary columns (such as the past few weeks) and unnecessary rows (such as the row where the red cell of the font is located and the extra blank row), and then frame it as a screenshot. Just unhide the hidden rows and columns when the publication needs to be adjusted.
Second, the improvement of statistics.
Before: This is the previous monthly statistics. It looks quite refreshing. If you know the follow-up, you won't feel this way-use this as a template every month, change the time according to the total class schedule, add and subtract the student number, and modify the total number of students. God, no wonder the senior said that monthly statistics usually start in the middle of the month. Because you can add and subtract at any time, it is acceptable to share hundreds of thousands of class hours or at least ten days of work every day. Whoa, whoa, whoa Is there no more convenient way? -The senior replied: That's what the senior did. How can there be a quick way ... don't try to do things quickly, if you are prone to mistakes soon. ...
Why don't I believe in evil?
H: After such a tortuous journey, I finally feel a little relaxed now-I can't say finally. In the past, the typesetting of the general curriculum was also useful (or just to lay the foundation for it), and every week of a month was copied out and arranged in the same column.
Then use the "sorting" function of Excel. If the teacher's name comes first, then the teacher's statistics will follow the trend.
Of course, if you want to count students' monthly class hours, you can "divide" this cell in the class schedule (you can learn Excel books or search online for specific conditions and steps):
This can also be sorted by the second column, and students' statistics can be obtained naturally. (For the same reason, I won't demonstrate.)
Look, you can also do statistics that are almost the same as the previous monthly statistics format. But is this process a lot easier and more enjoyable? And it only needs to be done at the beginning of next month after the end of the month, which usually takes 1~2 days (of course, according to the total class hours and other workload). Efficiency is more than a big cut.
Third, summary.
In fact, there are statistics on campus, and then add them up ... once the foundation is laid, there will be no worries. "Ma Ma no longer has to worry about my monthly report!"
In fact, there are many ways to deal with a work item, even sometimes it is a very simple trick, just need lazy people to gather all the elves in their heads! Of course, if you are too lazy to do anything but act, and even the spirit of thought is unwilling to command, then you can only follow the "predecessors have done so." You are willing to be milled by an inefficient millstone. I just want to be sweet enough to go to bed early.
By the way, why don't I say "finally", because it will continue. (enthusiastic face)
No matter how full this job is, people who love it will always try their best to lose weight for it! In addition, the wheel of history always rolls forward and always advances in exploration. ...
PS: Nowadays people are obsessed with Excel, preferring to be a "cousin" rather than a fairy sister. Please advise!
PS2: The original activity is here. People who are lazy. Go poke it!