data science using excel pyq 2025 3rd sem kuk bca

Examination Details Course: Basics of Data Science Using Excel. Total Marks: 50. Time Allotted: Three hours. Instructions: Students must attempt five questions in total. Question No. 1 is compulsory, and students must select exactly one question from each of the four units. All questions carry equal marks. Syllabus Coverage Compulsory Question: Covers the use of the Count function, data validation, differences between simple and multiple regression, histogram usage, and the purpose of Chi-square tests. Unit I: Focuses on the importance and applications of data science, basic mathematical functions in Excel, data sorting techniques (ascending/descending), and applying conditional formatting to datasets. Unit II: Addresses the 'Text-to-Columns' feature for splitting data, steps for creating bar charts, and the benefits and limitations of importing/exporting data across CSV, TXT, and Excel formats. Unit III: Requires explanations of standard deviation versus variance, the concept of hypothesis testing in inferential statistics, and simple linear regression including its equation, assumptions, and application in Excel. Unit IV: Examines the features of the Excel Data Analysis ToolPak and the process of creating, customizing, and interpreting PivotTables for data analysis.