Experimental purpose and requirements: 1.Master the establishment method of database. 2.Master the basic editing methods of database. 3.Master the query and statistical methods such as filtering, classification and summary commonly used in database. 4.Master the basic usage of PivotTable. 5.Master the merging operation of data. Experimental conditions:Windows operating system and Office suite should be installed. Experiment 12:Excel data chart processing Experimental contents:the creation and editing of common data charts and pivottables,and the simulation operation of data. Experimental properties:verification and design Experimental hours:3 Experimental purpose and requirements: 1.Master the creation methods of common charts in Excel. 2.Master the basic editing methods of common charts in Excel 3.Master the basic usage of Excel pivotchart. 4.Master the basic usage of analog operation. Experimental conditions:Windows operating system and Office suite should be installed. Experiment 13:Comprehensive Application of Excel Experiment content:Making appropriate spreadsheet application examples by comprehensively applying various functions of Excel. Experimental nature:comprehensive Experimental hours:3 Experimental purpose and requirements:Exercise the ability to solve practical problems by using Excel comprehensively. Experimental conditions:Windows operating system and Office suite should be installed. Research and Thinking: 1.How to understand the word "electronic"in Excel spreadsheet software? 2.Are numeric data and date data two different types of data? 3.How to use the Knowledge of Excel to standardize their daily consumption and put an end to bad consumption behaviors? 77 Experimental purpose and requirements: 1. Master the establishment method of database. 2. Master the basic editing methods of database. 3. Master the query and statistical methods such as filtering, classification and summary commonly used in database. 4. Master the basic usage of PivotTable. 5. Master the merging operation of data. Experimental conditions: Windows operating system and Office suite should be installed. Experiment 12: Excel data chart processing Experimental contents: the creation and editing of common data charts and pivottables, and the simulation operation of data. Experimental properties: verification and design Experimental hours: 3 Experimental purpose and requirements: 1. Master the creation methods of common charts in Excel. 2. Master the basic editing methods of common charts in Excel. 3. Master the basic usage of Excel pivotchart. 4. Master the basic usage of analog operation. Experimental conditions: Windows operating system and Office suite should be installed. Experiment 13: Comprehensive Application of Excel Experiment content: Making appropriate spreadsheet application examples by comprehensively applying various functions of Excel. Experimental nature: comprehensive Experimental hours: 3 Experimental purpose and requirements: Exercise the ability to solve practical problems by using Excel comprehensively. Experimental conditions: Windows operating system and Office suite should be installed. Research and Thinking: 1. How to understand the word "electronic" in Excel spreadsheet software? 2. Are numeric data and date data two different types of data? 3. How to use the Knowledge of Excel to standardize their daily consumption and put an end to bad consumption behaviors?