There are several ways to convert a master curriculum to a class curriculum, but the most common of them is through pivot tables and Excel's slicer feature. Here are the steps:
Open Excel**, which contains the total curriculum data.
Select all the data for the master curriculum, and then select Data - PivotTable.
Drag the Class field to the filter area and the Day of the Week field to the row area.
In the filter, select the classes that you want to convert to each class curriculum.
In the row area, you can see that the class schedule is categorized by week.
If you need further action, you can select [Analyze] - [Insert Slicer], and then select the required field as the filter condition.
In the slicer, select the items that need to be filtered to get the class schedule for each class.
In addition, it can also realize the conversion of the total curriculum to the curriculum of each class through functions such as row and column conversion, two-dimensional to one-dimensional, etc. The specific steps are as follows:
Open the master curriculum data and select Merge Conversion - Row and Column Conversion.
In the dialog box that pops up, set the Row Title to the class, and then click OK.
In the dialog box that appears, enter the location of the cell where the converted data is stored, and then click OK.
Make a class schedule template and click on the cell where the data is stored.
Click Add Insert and select Insert drop-down menu to enter the class drop-down menu.
Enter the formula =iferror(lookup(2,0 ((ak:ak=ad2)*(aj:aj=ac3) (ai:ai=ab4)),al:al),""), and then populate the entire ** to enter the curriculum for the specified class.
The significance of converting the master curriculum to the class curriculum is as follows:
It is convenient for each class to view and manage its own class schedule. Each class can easily and quickly view and manage its own class schedule according to its own needs and schedule.
Improve management efficiency and management quality. By converting the general curriculum to a class curriculum, duplication of effort and unnecessary errors can be avoided, and management efficiency and management quality can be improved.
Enhance operability. By converting the general curriculum to the curriculum of each class, it can better adapt to different management needs and actual situations, and enhance operability.