$(1)$ Sorting: Sort the data first in descending order of workload, and for those with the same workload, sort them in descending order of professional titles.

$(2)$ Automatic filtering: Filter out professors with a workload exceeding $400($including $400)$

$(2)$ Advanced screening: Select female computer science teachers aged between $30$ and $50$ and male professors of any age group

$(4)$ Simple classification summary: Summarize the total workload completed by teachers by department

$(5)$ Nested classification summary: Based on $(4),$ summarize the number of male and female teachers in each department

$(6)$ Pivot table: statistics on the number of male and female teachers in various professional titles in various departments and colleges

Experimental Report$4$

Excel

$2010(2)$

$$ Experimental Purpose $$

Master the methods of simple sorting and multiple sorting;

Master the methods of automatic and advanced filtering;

Master the method of classification and summary;

Master the creation and formatting of charts;

Understand the basic composition of charts and the role of some options.

$[$Experimental content and steps$]$

Refer to Figure $4-1$ "Teacher Workload Accounting Table" to create a spreadsheet of data, complete the following operations and write down the steps:

$\backslash$table$[[],[,,,,,,],[1,,,41,,,360],[2,,,43,,,420],[3,,,53,,,482],[4,,,58,\backslash$table$[[]],,414],[5,,,33,,,213],[6,,,45,,,230],[7,,,34,,,160],[8,,,51,\backslash$table$[[]],,120],[9,,,53,,,465],[10,,,41,,,400],[11,,,42,,,320],[12,,,45,,,489],[13,,,43,,,180],[14,,,40,,,289],[15,,,34,,,387],[16,,,44,,,260],[17,,,28,,,160],[18,,,40,,,460],[19,,,49,,,350]]$

Figure $4-1$ Teacher workload accounting table