How to use charts for educational information analysis
Use Excel VBA to automatically generate personalized charts in educational statistical analysis
2012-11-14 itspanther The source of the article is at Use Excel VBA to automatically generate personalized charts in educational statistical analysis
Author:
Source: China Education Informatization·Basic Education 2012 Issue 9
Font size: Large, Medium, Small
Display Chinese Pinyin
Abstract: The advantages of images are vivid images and large amounts of information. In terms of reflecting the changing trends of data, It has more obvious advantages. At present, Excel has been widely used in educational management and educational research, and mastering chart making methods has become a required content. However, in educational statistics management, sometimes we also want to interpret the data in a unique way and let personalized charts highlight the important information in the data. To this end, the article first introduces how to create Excel charts through manual operation, and then uses VBA programming to generate charts with fixed formats in the system. Finally, it focuses on using Excel VBA to automatically generate personalized charts to serve education management and research.
Keywords: statistical analysis; automatic generation; personalized charts
CLC classification number: TP319 Document identification code: A Article number: 1673—8454 (2012) 18—0068— 05
Due to the development of science and technology and the accelerated pace of life, we have entered the era of picture reading. We have this experience. We may not be able to remember a series of numbers, as well as the relationships and trends between them, but we can easily remember a picture or a curve. In educational statistical research, we need to discover new phenomena or patterns from a large amount of data as soon as possible in order to optimize management and guide work. In the analysis of "Jiangsu Province Primary and Secondary School Students' Academic Quality Test", a "box plot" is used to succinctly reflect the degree of dispersion of test scores and provide an intuitive method for educational evaluation, which is a good example.
At present, Excel has been widely used in educational management and educational research, and mastering chart making methods has become a required content. However, in educational statistics management, sometimes we also want to interpret the data in our own unique way, so that personalized charts can show changing trends, thereby highlighting important information in the data. This article first introduces how to create Excel charts through manual operation, and then uses VBA programming to generate fixed-format charts in the system. Finally, it focuses on using Excel VBA to automatically generate personalized charts to serve education management and research.
1. Manually create charts
Charts can be used to show certain correspondences between data. We generally use column charts to compare the relationship between data, line charts to reflect trend relationships between data, pie charts to show proportional distribution relationships between data, etc. The following takes making a "column chart" as an example to briefly introduce the method of making charts manually through Excel.
(2) Click the "Insert" menu, select "Column Chart" on the tab, and select "Two-dimensional Column Chart" in the column chart series. A chart and menu bar will appear. The "Design", "Layout" and "Format" menus appear.
(3) Under the "Design" menu, click "Switch Rows/Columns" and select the series to generate rows or columns as needed. You can select the style of the column chart through "Chart Style" ("Style 26" is selected in this example).
(4) Click the "Layout" menu, and through the tabs, you can perform operations such as "Title", "Legend", and "Axis". For example, in this example, select "Image Title", select "Above the Illustration" in the drop-down option, and enter "Second Survey Results Comparison".
3. Use Excel VBA to automatically generate personalized charts
Although Excel can generate various types of charts, the formats of these charts are fixed in the Excel system. In education management and research, sometimes we also want to interpret the data in our own unique way and let personalized charts highlight the important information in the data.
So, how can such a function be achieved?
The following takes making a "box chart" as an example to introduce how to make a personalized chart.
In educational measurement, we often use box plots to succinctly reflect the degree of dispersion of scores. Arrange the total scores of all students from low to high. The short line at the bottom means that about 5% of the students scored lower than the score corresponding to this line. The short line at the top means that about 5% of the students scored higher than the score corresponding to this line. score. The scores corresponding to the upper, middle, and lower lines of the box indicate that approximately 25%, 50%, and 75% of students scored higher than the scores corresponding to this line respectively. The middle line of the box chart describes the level of students' average performance. The height of the rectangular box in the box chart intuitively describes the degree of student performance dispersion to a certain extent, providing a convenient observation method for educational management.
2. How to implement the "basic elements" when generating personalized charts
(1) Draw line segments
Through the VBA program, draw the " Dotted lines, upper and lower short lines, vertical line segments, etc.
This can be achieved through the Shapes.AddLine method and used to draw lines.
Syntax: Expression.AddLine(BeginX, BeginY, EndX, EndY)
The arguments represent the starting point and end point coordinates of the line respectively.
The relationship between the spacing of the lines and the size of the fraction value is: 1 fraction value corresponds to n times the points.
(2) Draw a text box
Draw a "box" that represents the dispersion of grades, set the height and color of the box, draw a rectangular background, etc.
This can be achieved by creating a text box through the Shapes.AddTextbox method.
Syntax: Expression.AddTextbox (Orientation, Left, Top, Width, Height)
The arguments respectively represent the direction of the text box. The upper left corner of the text box is relative to the upper left corner of the file. The position of the top, as well as the width and height.
(3) Draw an ellipse
You can use the Shapes.AddShape method to draw an "ellipse" to represent equal division.
Syntax: Expression.AddShape (Type, Left, Top, Width, Height)
The arguments respectively represent the shape of the AutoShape (ellipse) and the upper left corner relative to the upper left corner of the file. , the position of the top, as well as the width and height. What kind of investment is needed for informatization of cadre education?
Wenbotong (Beijing) Technology Co., Ltd. can help you.
I. Cost investment
The cost of information construction includes software cost, hardware cost and operating cost. The hardware costs include computer equipment, network equipment, etc., which can be estimated based on market prices. Software costs are generally dominated by development costs. Nowadays, the calculation method of purchasing software package modules is generally used. Software development costs can be calculated based on modules, functions and secondary development, or secondary development costs can be included in the purchase cost of system software. Then there are the costs of system support and upgrades.
II. Choose mature products
At present, the price of hardware devices in the domestic market continues to decline, and most cadre training institutions also have a certain hardware device foundation and hardware infrastructure construction. There is less pressure on information costs, and the continuous innovation of software solutions is the core of information costs. The information construction of cadre training institutions should pay more attention to the improvement and sustainable development of software systems.
Choose mature information products. Based on the long-term development direction, systems such as liaison transaction processing, online analysis and processing, and data analysis and integration should be implemented in a purposeful and step-by-step manner. It can not only fully utilize the functions of existing devices, but also have the ability to continue to provide services for subsequent information systems, thereby maximizing the scope of early information functions.
Secondly, attention needs to be paid to the software’s maturity, completeness, compatibility, scalability, and whether it can meet the long-term planning needs of cadre training institutions. Therefore, choosing a mature and scalable information system is also the key to saving costs.
III. Choose high-performance products
Today, domestic software companies do not have a "price advantage", but a "price disadvantage". Ignoring the professionalism of the industry has led many organizations to choose information products regardless of cost, and instead try to reduce investment in the later implementation, maintenance, and service stages. This ultimately leads to an embarrassing situation for the project and increases the software cost of the information system. and operating costs.
Today's information technology is changing with each passing day. Information management and its applications have gone through three stages of development, from file systems to traditional database management systems, and then to data management application systems. Now they have entered into a diversified data structure. The era of storage heterogeneity and intelligent decision-making. Therefore, the choice of information products also depends on whether the manufacturer has the ability to develop in the long term, absorb new information technology, and innovate information technology. Only information systems with sustainable expansion kits can achieve maximum benefits in information construction. Discuss how to use SWOT analysis method to conduct information analysis
SWOT analysis method is an internal analysis method of the enterprise, that is, it analyzes the enterprise's own established internal conditions to find out the enterprise's strengths, weaknesses and core competitiveness. where. Among them, S represents strength, W represents weakness, O represents opportunity, and T represents threat. Among them, S and W are internal factors, and O and T are external factors. According to the complete concept of corporate competitive strategy, strategy should be an organic combination between what an enterprise "can do" (i.e., the organization's strengths and weaknesses) and "what it may do" (i.e., the opportunities and threats of the environment). The competition theory proposed by Michael Porter, a well-known competitive strategy expert, provides a thorough analysis and explanation of what an enterprise "may do" starting from the industrial structure, while management scientists from the capability school use the value chain to deconstruct the enterprise's value creation process. , focusing on the analysis of the company's resources and capabilities. SWOT analysis, based on the synthesis of the previous two, is represented by resource school scholars, and combines the company's internal analysis (that is, the research orientation focused on by management academic authorities in the mid-1980s, represented by the capability school) and industry The external analysis of the competitive environment (that is, the central theme of earlier strategic research, represented by Andrews and Michael Porter) was combined to form its own structured balanced system analysis system.
Compared with other analysis methods, SWOT analysis has significant structural and systematic characteristics from the beginning. As far as structuring is concerned, first of all, in form, SWOT analysis method is expressed as constructing a SWOT structure matrix and assigning different analytical meanings to different areas of the matrix; secondly, in terms of content, the main theoretical basis of SWOT analysis method also emphasizes starting from structural analysis. Analyze the company's external environment and internal resources. In addition, as early as the 1960s before the birth of SWOT, some people had already proposed the changing factors of internal strengths, weaknesses, external opportunities, and threats involved in SWOT analysis, but they were only analyzed in isolation. The important contribution of the SWOT method is to use systematic thinking to match these seemingly independent factors with each other for comprehensive analysis, making the formulation of corporate strategic plans more scientific and comprehensive.
Since its formation, the SWOT method has been widely used in corporate strategy research and competitive analysis, and has become an important analysis tool for strategic management and competitive intelligence. Intuitive analysis and simple use are its important advantages. Even without precise data support and more professional analysis tools, persuasive conclusions can be drawn. However, it is this intuitiveness and simplicity that makes SWOT inevitably have the defect of insufficient accuracy. For example, SWOT analysis uses a qualitative method to form a vague description of the company's competitive position by listing various manifestations of S, W, O, and T. Judgments based on this will inevitably involve a certain degree of subjective conjecture. Therefore, when using the SWOT method, you must pay attention to the limitations of the method. When listing the facts as the basis for judgment, you must try to be true, objective, and accurate, and provide certain quantitative data to make up for the shortcomings of SWOT qualitative analysis and build the basis for high-level qualitative analysis. .
Recently, SWOT analysis has been widely used in many fields, such as school self-analysis, personal ability self-analysis, etc.
For example, when using SWOT to analyze your career development, you can follow the following five steps:
The first step is to evaluate your strengths and weaknesses
Everyone has their own unique skills, talents and abilities. In today's environment of very fine division of labor, everyone is good at a certain area, but not proficient in everything. (Unless a genius, of course). For example, some people don't like sitting in an office all day, while others feel tingly and uneasy at the thought of having to interact with strangers. Please make a list of things you enjoy doing and where your strengths lie. Likewise, with a list, you can identify the things you don't really like to do and your weaknesses. Finding your weaknesses is as important as discovering your strengths, because you can make two choices based on your strengths and weaknesses; either work hard to correct normal mistakes and improve your skills, or give up on things that are not good for you. The skills required by the department. List the strengths and weaknesses that you think are important to you and the weaknesses that have an impact on your study choices. Then mark those strengths and weaknesses that you think are important to you.
The second step is to find out your career opportunities and threats
We know that different industries (including different companies in these industries) face different external opportunities and threats. Therefore, identifying these external factors will help you successfully find a job that suits you. It is very important for you to apply for a job, because these opportunities and threats will affect your first job and future career development. If the company is in an industry that is often affected by external adverse factors, it is natural that the career opportunities the company can provide will be few and there will be no opportunities for career advancement. On the contrary, an industry filled with many positive external factors will provide job seekers with great career prospects. List one or two industries that interest you, and then carefully evaluate the opportunities and threats facing those industries.
The third step is to outline your career goals in the next 3-5 years.
Carefully conduct a SWOT analysis and evaluation of yourself and list what you most want to achieve in the next 5 years. four to five career goals. These goals can include: what kind of career you want to pursue, how many people you will manage, or what salary level you want to be paid. Always remember: you must do your best to use your strengths to perfectly match the job opportunities available in the industry.
The fourth step is to outline a career action plan for the next 3-5 years
This step mainly involves some specific content. Please draw up an action plan to achieve each goal listed in step 3 above, and describe in detail everything you have to do to achieve each goal and when you will complete it. If you feel you need some outside help, please describe what kind of help you need and how you can get it. For example, your personal SWOT analysis may indicate that in order to achieve your desired career goals, you need to take more management courses, then your career action plan should indicate which courses to take, at what level and when. These courses and more. A detailed plan of action that you create will help you make decisions, just as a plan you make before going on a trip will serve as your guide.
The fifth step, seek professional help
It is not difficult to analyze the shortcomings in your own career development and behavioral habits, but it is difficult to change them in appropriate ways. I believe that your friends, superiors, and career counseling experts can all give you some help, especially because many times professional counseling will allow you to take shortcuts. External assistance and supervision will also allow you to achieve better results. Can the patent information analysis system carry out patent retrieval?
Yes, it is possible. I still know how much the poster has this idea. At present, except for what the poster said
Patent search includes three types of paper search, software search and Zhizhuxia intellectual property search.
Pre-R&D search: Before R&D, you can use the IncoPat technology innovation information platform to determine whether the technical idea has been patented by others or has obtained patent rights;
Novelty before patent application Patent search: You can determine whether the technical solution is novel before applying to determine whether the technical solution can file a patent application;
Infringement prevention search: You can use the search to exclude products manufactured or sold from falling into other people's patents The possibility of protecting the scope of the patent;
Evidence collection and retrieval in the invalidation proceedings: The previously disclosed technology retrieved can be used as evidence to challenge the novelty and creativity of the other party’s patent rights in the invalidation proceedings. How to educate a dog
Beating. . . Must be beaten. . . I had to beat him when I was a kid. . .
If it disobeys now.
Growing up will change things. . .
A little heavier. Just let it know it hurts. When it squeaks, it works.
If only I could beat him lightly. If you make a mistake this time, you will get beaten like this. He will dare to do it next time. . .
Let it be known. If you make a mistake, you will be punished. How teachers capture and effectively use educational information
You can consider these aspects:
1. Cultivate sensitivity to educational information
2. Seize education The timing of information flash
3. Grasp the status of educational information
4. Analyze and judge the value of educational information
5. Cleverly transform it into dynamic research resources .
However, there is no set method for teaching, and the classroom is constantly changing, which requires teachers to have strong classroom control capabilities and respond promptly to various changes that may occur in the classroom. On the one hand, they need to have strong basic teaching skills, and on the other hand, they need to have strong basic teaching skills. In terms of teaching, you need to actively summarize your daily experience, and in addition, you must humbly ask experienced teachers for advice. How to write educational information? Please answer
2. From the perspective of others, educational information serves as an opportunity for learning and education. 3. From the school perspective, educational information plays a communication function and promotes communication between schools. At the same time, it increases the school's visibility and enhances the school's educational taste. 4. From an administrative perspective, educational information provides necessary information for the work deployment of the Education Bureau.
2. The framework of educational information 1. Paragraph-type educational information generally consists of two or three paragraphs. In the first paragraph, briefly describe the three elements of the information: time, content, and location (school). The middle paragraph provides a specific (not detailed) description (narrative + explanation) of the information to be written, and names the educational function of the information. 2. The number of words should be around 250. Of course, as far as specific educational information is concerned, if the content is rich, you can write three to four hundred words.
3. Theme of educational information 1. Within a certain range and not limited by time. The scope can be one year or two years. For example, small class teaching is distinctive. The medium ones can last for one semester or one month, and are usually continuous activities. Primary and secondary schools provide information technology training to school teachers. 2. Limited by time. Generally, it is about writing about the school’s activities within a week. 3. The writing of educational information should still focus on teaching, and most topics should be selected from the school’s teaching activities.
4. Content of educational information 1. Speak in an orderly manner. Educational information contains a small amount of text, so it must be concise, orderly, and complete so that people can easily read the entire text in a short time. 2. What you say means something. The purpose of writing educational information must be clear, stick to the theme and expand it, and express a complete message. 3. It makes sense. The activities arranged by the school always have a certain purpose. When writing educational information, the educational purpose contained in the information must also be clear. For example, in order to improve students' legal awareness, a legal education report meeting was held. 4. Speak with intention. As an information officer, you should also see the profound meaning hidden in educational activities. For example, by watching safety education videos, students can understand better: obeying traffic rules means cherishing life. How does the reporting tool FineReport use charts to analyze data?
Charts are an increasingly used form of reports. Using charts has obvious advantages over general data display. The data is also analyzing the chart, which is a two-way interpretation.
At present, FineReport has implemented column charts (7 types), line charts (1 type), bar charts (7 types), pie charts (2 types), area charts (4 types), scatter charts Point chart (1 type), Bubble chart (1 type), Radar chart (1 type), Stock price chart (1 type), Dashboard (1 type), Range chart (1 type), Combination chart (1 type), There are a total of 16 styles and 37 charts including maps (4 types), Gantt charts (1 type), gis maps (2 types), donut charts (2 types), etc.
Among these 16 chart styles, the four basic types of charts most commonly used to analyze data are column charts, bar charts, line charts and pie charts. Special charts, such as maps, often have eye-catching effects if used well.
A histogram is a statistical chart that uses the length of a rectangle as a variable to express graphics. It uses vertical stripes to represent the distribution of data and is used to compare two or more values ??(at different times or under different conditions). , with only one variable, is usually utilized in the analysis of smaller data sets. It has a relatively good effect on comparing the specific changes and development trends of two or more data of the same nature.
Line charts can display data that changes over time, so line charts are suitable for analyzing changes in data when time intervals are of the same size. Generally, category data in a line chart is evenly distributed along the horizontal axis, and the specific data values ??of all information are evenly distributed along the vertical axis. Usually, it is better to use line charts and column charts together to analyze data. It allows comparison of specific values ??and overall development trends, taking into account both trivial matters and the overall situation.
A bar chart can be understood as a horizontal column chart, which is mainly used to analyze and compare the comparison between various projects. When the horizontal items of data that need to be analyzed using charts are relatively small and the vertical value span is relatively large, bar charts are needed.
For the rest of the chart analysis, you can follow fanruan./Related documents using the Internet system to conduct educational lectures
To take the qualification certificate, you can conduct training online according to your own time, as long as you get in , the effect is the same.
Advantages:
1 Online learning can be determined according to your own time, and the length of learning time can also be controlled, ensuring your own efficiency.
2. You can listen to the parts you don’t understand again and again, and it’s easy to take notes.
3. Online training courses are cheaper than registered classes, and you don’t have to make a special trip there to study, which is much more convenient.
Disadvantages:
You cannot communicate with the teacher in real time. When you have problems, you can only calm down by yourself, truly learn to solve problems independently, and analyze data using charts. When visualizing, how to judge which charts to use
EXCEL mainly includes common statistical charts such as line charts, radar charts, bar charts, and pie charts, but these charts such as word clouds are not available. However, EXCEL data It has powerful functions. Through functions, pivot tables and other functions, a lot of data analysis can be completed. In addition, EXCEL has some fixed analysis templates that users can use directly, which is convenient. BDP personal version has many analysis functions, such as high-level calculations such as comparison, retention rate, repetition rate, etc. It also has various charts, such as line charts, bar charts, dual-axis charts, pie charts, GIS maps, province maps, word clouds, Funnel charts, Sankey charts, etc.