Scribd
Upload
9 views1 page

PhD Research Methodology & Excel Guide

The document outlines the PhD coursework for the January 2025 batch, focusing on research methodology and computer applications. It includes an assignment with questions covering hypothesis testing, MS Excel features, and various indexing systems. The course is coordinated by Dr. Kriti Shrivastava.

Uploaded by

ankatwar.gajanan
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
9 views1 page

PhD Research Methodology & Excel Guide

The document outlines the PhD coursework for the January 2025 batch, focusing on research methodology and computer applications. It includes an assignment with questions covering hypothesis testing, MS Excel features, and various indexing systems. The course is coordinated by Dr. Kriti Shrivastava.

Uploaded by

ankatwar.gajanan
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

PhD Coursework- Jan 2025 Batch

Research Methodology & Computer Application (PPD-101)


(Common for Ph.D. Scholars)
Assignment-4
Unit.6 Testing of Hypothesis, Unit.7 Introduction to MS Excel, Unit.8 Introduction to
UGCinfonet, INFLIBNET & ERNET
Q.1 What do you mean by hypothesis? Compare null and alternate hypothesis.
Q.2 What is a hypothesis test? Why do we perform it?
Q.3 Discuss different steps involved in hypothesis testing with examples.
Q.4 Elaborate Type-I and Type-II errors in the hypothesis test.
Q.5 Discuss various factors affecting hypothesis testing and necessary precautions during the hypothesis
test.
Q,6 Discuss various steps in test of significance.
Q.7 What are the key features of MS Excel, and how is it used in different industries?
Q.8 Explain the difference between a worksheet and a workbook in MS Excel.
Q.9 How do you use the AutoFill feature in Excel? Provide examples of its applications.
Q.10 What are the different types of data formats available in Excel, and when should each be used?
Q.11 What is the purpose of the IF function in Excel? Explain with an example.
Q.12 Describe the process of creating and formatting charts in MS Excel.
Q.13 How does Conditional Formatting work in Excel? Provide practical use cases.
Q.14 What are Excel Tables, and how do they improve data management?
Q.15 Explain the concept of PivotTables and how they help in data analysis.
Q.16 What is Power Query in Excel, and how can it be used to transform and clean data?
Q.17 Write descriptive note and give suitable examples wherever required:
(i) UGCinfonet
(ii) INFLIBNET
(iii) ERNET
(iv) SCOPUS indexing
(v) WOS indexing
(vi) TR indexing
(vii) SCI indexing
(viii) Arts & Humanities citation index
(ix) Social Science Citation index

Course Coordinator
Dr. Kriti Shrivastava

You might also like