Exploring Diversity in Question Types for 'USE OF ENGLISH I' Course Questions
Visualize the distribution of question types in the 'USE OF ENGLISH I' course.
We'll first inspect Sheet1 and Sheet2 to find the relevant data for visualizing the distribution of question types in the 'USE OF ENGLISH I' course.
Sheet1 contains data for the 'USE OF ENGLISH I' course, which is what we're interested in. We'll proceed with Sheet1 to visualize the distribution of question types.
It seems we need to further clean and organize the data to correctly identify and count the different question types. Let's proceed with that.
The analysis of the 'USE OF ENGLISH I' course questions from Sheet1 reveals a variety of question types, each occurring once in the dataset. This indicates a broad range of topics covered in the course, but it does not follow a typical distribution pattern that can be visualized effectively due to the unique occurrence of each type. Further cleaning and precise categorization of question types might be necessary for a more meaningful analysis.
Create a pie chart to visualize question types
Loaded data from CBT QUESTION.xlsx containing multiple sheets.
Identified Sheet1 as relevant for the 'USE OF ENGLISH I' course.
Cleaned and extracted question types from Sheet1.
Found a variety of question types, each occurring once, indicating a broad range of topics.
Created a pie chart visualizing the distribution of question types, showing each type's unique occurrence.