Method for performing data format conversion on question-doing records of students by using Stata
A data format conversion and data recording technology, which is applied in electrical digital data processing, natural language data processing, instruments, etc., can solve the problem that long data format cannot be directly used as input
Pending Publication Date: 2021-05-28
SHANGHAI SQUIRREL CLASSROOM ARTIFICIAL INTELLIGENCE TECH CO LTD
View PDF0 Cites 0 Cited by
- Summary
- Abstract
- Description
- Claims
- Application Information
AI Technical Summary
Problems solved by technology
Some data analysis in the field of education and parameter training in the data modeling process often require students' historical test data as input, but the long data format often cannot be directly used as input
Method used
the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View moreImage
Smart Image Click on the blue labels to locate them in the text.
Smart ImageViewing Examples
Examples
Experimental program
Comparison scheme
Effect test
Embodiment Construction
[0054] Such as figure 1 As shown, the method of using Stata to convert the data format of the students' record of the questions includes the following steps:
[0055] Step 1, use Stata software to open the long data format to do the record data (dta format);
[0056] Specifically, operate on the panel of Stata software: File>Open>"File_Name.dta";
[0057] After opening, some of the test record data are shown in Table 1:
[0058]
[0059] Table 1
[0060] In Table 1, account_id is the student ID number, question_id is the question number, and user_score is the score of a specific student on a specific question. This is the most basic question-making record, and the core information is only user_score.
[0061] Step 2. Screen out the abnormal data in the question-making record data; for example, for the question-making record data shown in Table 1, it is necessary to filter out the abnormal situation in which the same student answers the same question and the answer result ...
the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More PUM
Login to View More Abstract
The invention discloses a method for carrying out data format conversion on question-doing records of students by using Stata. The method comprises the following steps of: 1, opening question-doing record data in a long data format by using Stata software; 2, removing abnormal data in the question doing record data; 3, converting the question-doing record data in the long data format into the question-doing record data in the wide data format; 4, screening the question-doing record data in the wide data format, screening useless data in the question-doing record data, and cleaning the useless data; and 5, exporting the question doing record data in the wide data format. According to the method, format conversion of student question-answering record data is realized by using a reshape program in Stata software, and a matrix type student question-answering history is formed. According to the method, the applicable scene of a reshape program is expanded, the method is not limited to processing a data set containing time dimensions, and meanwhile, a conventional question-doing record table form is changed, so that the data format meets the requirements of scenes such as data analysis and parameter training in the data modeling process in the education field.
Description
technical field [0001] The invention belongs to the technical field of online education, and in particular relates to a method for converting data formats of students' test records by using Stata. Background technique [0002] Statistical software Stata (a set of complete and integrated statistical software that provides its users with data analysis, data management, and drawing professional charts) is a program that converts length and width data to each other. It is generally used in longitudinal data analysis. Longitudinal data analysis It refers to data that considers the time dimension and records the process of other variables changing over time. The corresponding analysis that only considers data at a single time point is cross-sectional data analysis. specifically, [0003] Long-format data: There is no clearer subdivision of the variables in the data set, and at least one variable has repeated cycles of values (classifiable). Because there are few variables and ...
Claims
the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More Application Information
Patent Timeline
Login to View More Patent Type & Authority Applications(China)
IPC IPC(8): G06F40/151
CPCG06F40/151
Inventor 崔炜
Owner SHANGHAI SQUIRREL CLASSROOM ARTIFICIAL INTELLIGENCE TECH CO LTD