This case study analyzed student mark data from two classes using Microsoft Excel and Visual Basic scripting. The student data was collected and entered into an Excel spreadsheet. Formulas and functions were used to calculate statistics like mean, median, mode, standard deviation and variance for each subject. Charts were created to visually represent performance. Drop down lists and formulas converted subject names to numbers for analysis. The case study demonstrated how educational institutions can use data analytics to better understand student performance and inform strategies.
This case study analyzed student mark data from two classes using Microsoft Excel and Visual Basic scripting. The student data was collected and entered into an Excel spreadsheet. Formulas and functions were used to calculate statistics like mean, median, mode, standard deviation and variance for each subject. Charts were created to visually represent performance. Drop down lists and formulas converted subject names to numbers for analysis. The case study demonstrated how educational institutions can use data analytics to better understand student performance and inform strategies.
This case study analyzed student mark data from two classes using Microsoft Excel and Visual Basic scripting. The student data was collected and entered into an Excel spreadsheet. Formulas and functions were used to calculate statistics like mean, median, mode, standard deviation and variance for each subject. Charts were created to visually represent performance. Drop down lists and formulas converted subject names to numbers for analysis. The case study demonstrated how educational institutions can use data analytics to better understand student performance and inform strategies.
This case study analyzed student mark data from two classes using Microsoft Excel and Visual Basic scripting. The student data was collected and entered into an Excel spreadsheet. Formulas and functions were used to calculate statistics like mean, median, mode, standard deviation and variance for each subject. Charts were created to visually represent performance. Drop down lists and formulas converted subject names to numbers for analysis. The case study demonstrated how educational institutions can use data analytics to better understand student performance and inform strategies.
A case study is a research method to gain a better understanding of a subject or process.
Case studies involve in-depth research into a given subject, in order to understand its functionality and successes. A case study is an in-depth, detailed examination of a particular cases within a real-world context. In the realm of education, data analytics has emerged as a powerful tool for understanding, improving, and optimizing various aspects of the learning process. My case study was based on DATA ANALYTIC. During my case study, I got a chance to work on the school data to know about the data analytic methodologies. The case study is based on the student’s data. Here I collected the student’s data the I performed some functions on that. It is mend for analysis the performance of the students in their annual examinations for that I used Microsoft excel. In that data some tasks are assigned to me by my guide Dr. Jude Nirmal. They are, Find the mean, mood, median, standard deviation and variance values for each subject’s marks and along with that their graphical representation also. I am completing this case study using excel software and visual basic scripting language in an attempt to find the values and charts for student’s marks. I find the methods to analyze the data also. This expansive task was answered in spreadsheet. REVIEW OF THE CASE STUDY I had chosen my case study on data analytic area. Data analytics in the context of student marks involves a diverse range of techniques. This report explores into the fascinating world of student mark data analytics, offering a comprehensive exploration of how data-driven insights can enhance educational outcomes and inform educational strategies.
Every educational institution, from primary schools to universities, routinely collects
vast amounts of data on student performance and achievement. These data points include grades, test scores, attendance records, and more. However, these numbers often remain untapped reservoirs of valuable information. Student mark data analytics seeks to unlock the potential within these datasets, transforming them into actionable insights.
This report is dedicated to analyzing student mark data with the aim of extracting meaningful patterns, trends, and correlations. It explores the objectives of such analysis, which may include identifying at-risk students, evaluating the effectiveness of teaching methodologies, and optimizing curriculum. The scope encompasses various educational levels and institutions to provide a holistic perspective on the subject.
For that I was assigned to gather the information of the students. I collected the annual mark statements of the classes 9-A and 9-B from Punitha Arockia Annai Hr. Sec. School, Keeranur. I entered the 5 subjects annual mark data in the excel file. Then I did my tasks on the entered data. This report outlines the methodologies employed, which could include descriptive statistics and histogram. The choice of methodology depends on the specific objectives of the analysis and the available data.
Ultimately, the purpose of student mark data analytics is to enhance educational
outcomes. This report will explore how data-driven insights can be translated into actionable strategies. It will discuss the potential for personalized learning, early intervention for struggling students, and curriculum improvements that cater to diverse learning needs.
For data analysis, I used the Visual Basics Script language to get answer for some static formulas. I also used histogram to present the performance of the students in the annual examination for this I used drop down list tool and some formulas. MERITS AND DEMERITS Merits:
1. Accessibility: Excel is widely available and accessible, as it comes with Microsoft Office Suite and is commonly used in many organizations. This makes it easy for analysts to get started without the need for specialized software. 2. User-Friendly: Excel has a user-friendly interface with familiar rows and columns, making it approachable for those who may not have extensive technical or coding skills. 3. Data Visualization: Excel offers basic data visualization tools, including charts and graphs, which can help analysts quickly convey insights to non-technical stakeholders. 4. Formulas and Functions: Excel has a wide range of built-in formulas and functions that can be used for data manipulation, aggregation, and analysis. Users can also create custom formulas. 5. Data Cleaning: Excel provides tools for data cleaning and transformation, such as text-to- columns, find and replace, and data validation, which are useful for preparing data for analysis. Demerits:
1. Limited Capacity: Excel has limitations in handling large datasets. It can become slow and prone to crashing when dealing with extensive data, which can hinder complex analyses. 2. Version Control: Managing multiple versions of Excel files can be challenging, leading to version control issues and potential data discrepancies. 3. Data Security: Excel files can be vulnerable to data breaches if not properly secured. Sharing sensitive data through Excel files can be a security risk. 4. Reproducibility: Reproducing and documenting analyses in Excel can be challenging, as it lacks built-in version control, scripting, and the ability to create automated workflows. 5. Limited Collaboration: Collaborating on Excel files can be difficult, as simultaneous editing by multiple users can lead to conflicts and data integrity issues. 6. Difficulty with Unstructured Data: Excel is not well-suited for handling unstructured or semi-structured data, such as text, images, or JSON, which are increasingly common in modern data analytic. CODE BEHIND Private Sub Worksheet_Change(ByVal Target As Range) 'Updateby Extendoffice selectedNa = Target.Value If Target.Column = 15 Then selectedNum = Application.VLookup(selectedNa, ActiveSheet.Range("dropdown"), 2, False) If Not IsError(selectedNum) Then Target.Value = selectedNum End If End If selectedNa = Target.Value If Target.Column = 16 Then selectedNum = Application.VLookup(selectedNa, ActiveSheet.Range("dropdown1"), 2, False) If Not IsError(selectedNum) Then Target.Value = selectedNum End If End If selectedNa = Target.Value If Target.Column = 17 Then selectedNum = Application.VLookup(selectedNa, ActiveSheet.Range("dropdown2"), 2, False) If Not IsError(selectedNum) Then Target.Value = selectedNum End If End If selectedNa = Target.Value If Target.Column = 18 Then selectedNum = Application.VLookup(selectedNa, ActiveSheet.Range("dropdown3"), 2, False) If Not IsError(selectedNum) Then Target.Value = selectedNum End If End If selectedNa = Target.Value If Target.Column = 19 Then selectedNum = Application.VLookup(selectedNa, ActiveSheet.Range("dropdown4"), 2, False) If Not IsError(selectedNum) Then Target.Value = selectedNum End If End If End Sub CONCLUSION In conclusion, student mark data analytics is a transformative force in education. By harnessing the power of data, educators and institutions can better understand their students, tailor their approaches to teaching and learning, and ultimately improve academic outcomes. This report offers a window into the exciting and dynamic field of student mark data analytics, where data- driven decisions are shaping the future of education. REFERENCES
Kazi, Excel 10 tutorial, How to Create Drop Down List and Display Different Values in Excel. Retrieved from https://msexceltutorial.com/.
The Kenhal, India, Dynamic Chart with Drop-down - Advanced Excel.
Retrieved from https://www.youtube.com/@TheKenhal.
Tutorials Point India Private Limited, 4th Floor Incor9 Building, Kavuri Hills, Madhapur, Hyderabad, Telangana - 500081, INDIA, Data Analysis with Excel Retrieved from excel_data_analysis_tutorial.pdf (tutorialspoint.com)
