Research Methodology Lab

Aim: To understand the different types of research and to identify and formulate a research problem.

Theory: A research problem is a specific issue or gap that a researcher wants to study. Research may be basic, applied, exploratory or descriptive. A good problem is clear, specific, feasible, important and new. (Detailed theory: Research Methodology, Q2 and Q5.)

Procedure:

1. Choose a broad area of interest, such as social media and students.
2. Read news, reports and research papers to understand current issues in the area.
3. Narrow the area down to a specific, researchable problem.
4. Check feasibility – time, availability of data and cost.
5. Identify the type of research (descriptive, applied or exploratory).
6. Write a clear problem statement.

Result: Problem statement – "To study whether daily social media usage affects the semester marks of BCA students in Kolkata." Type of research – descriptive and applied.

Conclusion: A clear and feasible research problem was identified and its type of research was determined. This problem will guide the remaining experiments.

---

Aim: To search and review research papers using digital libraries such as Google Scholar, IEEE Xplore, SpringerLink and ACM Digital Library.

Theory: A literature review is a critical summary of earlier research on a topic. Digital libraries are online databases of research papers. Boolean operators (AND, OR, NOT) combine keywords to make searches more precise.

Procedure:

1. Identify keywords: "social media", "academic performance", "students".
2. Search using Boolean operators: "social media" AND "academic performance", students OR undergraduates, NOT "high school".
3. Apply filters – year range (last 5–10 years), document type (journal / conference), subject area.
4. Read titles and abstracts and select about 8–15 relevant papers.
5. Download full texts where available and note citation counts.
6. Prepare a literature review matrix:

7. Write a short review grouped by themes and state the research gap.

Result: A literature review matrix of selected papers was prepared, and a research gap was identified (for example, few studies on BCA students in Kolkata).

Conclusion: Relevant literature was searched and reviewed using digital libraries, and the research gap for the study was identified.

---

Aim: To develop research objectives, research questions and hypotheses for the chosen research problem.

Theory: Objectives state what the study aims to achieve, research questions state what the study will answer, and hypotheses are testable statements. Every hypothesis has a null hypothesis (H₀) – no relationship – and an alternative hypothesis (H₁) – a relationship exists. (Theory: Research Methodology, Q6 and Q13.)

Procedure:

1. Read the problem statement and research gap.
2. Write SMART objectives beginning with action verbs.
3. Convert each objective into a research question.
4. Frame H₀ and H₁ for each relationship to be tested.
5. Choose the statistical test for each hypothesis.

Result:

Objectives:

1. To find the average daily social media usage of BCA students.
2. To analyse the relationship between social media usage and semester marks.
3. To compare social media usage between male and female students.

Research questions:

1. How many hours per day do BCA students spend on social media?
2. Is social media usage related to marks?
3. Does usage differ by gender?

Hypotheses:

Conclusion: Clear objectives, research questions and testable hypotheses were formulated, along with suitable statistical tests.

---

Aim: To learn qualitative, quantitative and mixed research methods and select a suitable research design and sampling technique for the study.

Theory: Research design is the overall plan of a study. Research methods may be quantitative (numbers and statistics), qualitative (opinions and words) or mixed (both). Sampling selects a representative part of the population. (Theory: Research Methodology, Q12 and Q18–Q21.)

Procedure:

1. Study the objectives and decide the type of design.
2. Choose quantitative, qualitative or mixed methods.
3. Define the population and sampling frame.
4. Select a sampling method and decide the sample size.

Result:

1. Design: descriptive (quantitative) survey design, because usage is described and relationships are tested without manipulating variables.
2. Population: BCA students of colleges in Kolkata.
3. Sampling frame: class lists of selected colleges.
4. Sampling method: stratified random sampling by year of study (or convenience sampling if lists are unavailable, stated as a limitation).
5. Sample size: 120 students (30 from each year).

Conclusion: A descriptive survey design with stratified random sampling of 120 students was selected as suitable for the research objectives.

Aim: To create a structured questionnaire for data collection using Google Forms.

Theory: A questionnaire is a set of written questions answered by respondents. Google Forms is a free online tool for creating questionnaires; responses are collected automatically and can be exported to Google Sheets. Question types include short answer, multiple choice, checkboxes, dropdown and linear (Likert) scale. (Theory: Research Methodology, Q25.)

Procedure:

1. Open forms.google.com and click Blank form.
2. Enter the title and a short description (purpose, confidentiality assurance and consent statement).
3. Add questions using the + button and choose suitable types:
   • Short answer: age.
   • Multiple choice: gender, year of study.
   • Checkboxes: platforms used (Instagram, YouTube, WhatsApp).
   • Linear scale 1–5: Likert items.
   • Dropdown: marks range.
4. Mark important questions as Required.
5. Divide the form into sections: demographics → usage → academic performance.
6. In Settings, limit responses to one per person if needed.
7. Preview the form, pilot-test it with 5–10 people and revise.
8. Click Send and share the link; responses appear in the Responses tab and can be linked to Google Sheets.

Sample questions:

1. Gender: ○ Male ○ Female ○ Prefer not to say
2. Average daily hours on social media: ○ <1 ○ 1–2 ○ 2–3 ○ 3–4 ○ >4
3. "Social media distracts me during study time." 1 (Strongly disagree) – 5 (Strongly agree)
4. Last semester SGPA: ______

Result: A structured, pilot-tested questionnaire with three sections was created in Google Forms and a shareable link was generated.

Conclusion: Google Forms was successfully used to design a structured questionnaire suitable for collecting primary data.

---

Aim: To collect primary or secondary data and perform data cleaning (preprocessing).

Theory: Primary data is collected first-hand (survey responses); secondary data comes from existing sources (government portals, reports). Data cleaning removes duplicates, handles missing values, corrects errors and codes responses so that the data is ready for analysis.

Procedure:

A. Data collection

1. Share the Google Form link with the target respondents.
2. Collect the required number of responses (for example, 120).
3. Alternatively, download secondary data from a reliable source such as a government open data portal.

B. Data cleaning (in Excel / Google Sheets)

1. Export responses to a spreadsheet (CSV / Excel).
2. Remove duplicates: Data → Remove duplicates.
3. Handle missing values: delete incomplete responses or fill with mean / median / mode.
4. Correct errors: impossible values (SGPA = 15) or spelling variations ("male", "Male", "M").
5. Code responses: Male = 1, Female = 2; Strongly agree = 5.
6. Format columns consistently (numbers as numbers, dates as dates).
7. Save a clean copy and keep the raw data unchanged.

Useful Excel functions: =TRIM() (remove extra spaces), =PROPER() (fix capitalisation), =COUNTBLANK() (count missing cells), =IF() (coding), Find & Replace.

Result: A clean, coded dataset of valid responses was prepared, with duplicates and errors removed.

Conclusion: Data was collected and cleaned successfully, producing an accurate dataset ready for statistical analysis.

Aim: To compute descriptive statistics – mean, median, mode, standard deviation and variance – using MS Excel, SPSS or R.

Theory: Descriptive statistics summarise data. Mean, median and mode measure central tendency; standard deviation and variance measure dispersion. Software tools calculate these quickly and accurately. (Theory: Research Methodology, Q27–Q31.)

Procedure:

1. Open the cleaned dataset (assume daily hours are in cells B2:B121).
2. Enter the formulas below in Excel, or use the R / SPSS commands.
3. Alternatively, use Excel's Data Analysis → Descriptive Statistics for all values at once.

SPSS: Analyze → Descriptive Statistics → Frequencies or Descriptives → select variable → Options (mean, SD, variance) → OK.

Note: Enable Excel's Analysis ToolPak via File → Options → Add-ins → Analysis ToolPak → Go → tick → OK.

Result: A descriptive statistics table (mean, median, mode, SD, variance, minimum, maximum) was obtained for daily social media usage and SGPA.

Conclusion: Descriptive statistics were computed successfully using software, giving a clear summary of the collected data.

Viva point: STDEV.S is for a sample (divides by n − 1); STDEV.P is for the whole population (divides by n).

---

Aim: To generate charts, graphs and dashboards for interpreting research data.

Theory: Data visualisation presents data in graphical form so that patterns and comparisons are easy to see. Each chart type suits a different purpose. A dashboard combines several charts on one screen with interactive filters.

Procedure:

1. Select the data range in Excel.
2. Click Insert and choose the suitable chart type.
3. Add the chart title, axis titles, data labels and legend.
4. For a dashboard: Insert → PivotTable → PivotChart → Insert Slicer, and arrange several charts on one sheet.
5. In R: hist(data$SGPA)</code>, <code>barplot(table(data$Gender)), plot(data$Hours, data$SGPA).

Result: Pie, bar, histogram and scatter charts, and a simple dashboard filtered by year and gender, were created.

Conclusion: The data was visualised effectively, making patterns such as the relationship between usage hours and SGPA easy to interpret.

---

Aim: To test the research hypotheses using the t-test, chi-square test, ANOVA or correlation analysis on sample data.

Theory: Hypothesis testing decides whether to reject the null hypothesis using sample data. The choice of test depends on the type of data and the number of groups. Decision rule: if the p-value < 0.05, reject H₀ (the result is significant). (Theory: Research Methodology, Q37–Q41.)

Procedure:

1. State H₀ and H₁ for each hypothesis (from Experiment 3).
2. Choose the appropriate test for each.
3. Run the test in Excel, SPSS or R.
4. Note the test statistic and p-value.
5. Compare the p-value with 0.05 and decide whether to reject H₀.
6. Write the interpretation in plain words.

SPSS paths: Analyze → Compare Means → Independent-Samples T Test / One-Way ANOVA; Analyze → Descriptive Statistics → Crosstabs → Statistics → Chi-square; Analyze → Correlate → Bivariate.

Result (sample write-up): "The Pearson correlation between daily usage and SGPA was r = −0.42 (p = 0.001). Since p < 0.05, H₀ is rejected: higher social media usage is associated with lower SGPA." (Example values for illustration; use your own data.)

Conclusion: The hypotheses were tested using suitable statistical tests, and decisions were made based on p-values.

Aim: To use Zotero or Mendeley for managing citations and creating a bibliography in IEEE / APA format.

Theory: Reference management software stores sources, inserts citations into documents and creates bibliographies automatically in any style. It saves time, avoids formatting errors and helps prevent plagiarism caused by missed citations.

Procedure (Zotero):

1. Install Zotero desktop and the Zotero Connector browser extension.
2. While viewing a paper (for example, in Google Scholar), click the connector to save the reference (and PDF) to the library.
3. Organise references into collections (folders) and add tags or notes.
4. Install the Word plugin (included with Zotero).
5. In MS Word: Zotero tab → Add/Edit Citation → choose the style (IEEE or APA 7th) → insert the citation.
6. Click Add/Edit Bibliography to generate the reference list automatically.
7. Change the style at any time using Document Preferences; all citations update automatically.

Mendeley works in a similar way using Mendeley Reference Manager and the Mendeley Cite add-in for Word.

Result: Citations were inserted into the draft and an IEEE-style bibliography was generated automatically.

Conclusion: Zotero was used successfully to manage references, ensuring consistent and accurate citations.

---

Aim: To check the similarity of a research document using a plagiarism detection tool and to understand ethical research practices.

Theory: Plagiarism is using another person's work without acknowledgement. Plagiarism detection tools compare a document with published sources and produce a similarity report. Ethical research also requires informed consent, confidentiality and honest reporting. (Theory: Research Methodology, Q50–Q51.)

Procedure:

1. Prepare the draft report or paper.
2. Upload it to a plagiarism checker (such as Turnitin, iThenticate or Ouriginal provided by the institution, or a free online checker).
3. Read the similarity report – the overall percentage and highlighted matched sources.
4. Revise matched portions: paraphrase properly, add quotation marks for exact text, and add missing citations.
5. Re-check until the similarity is within the permitted limit.

UGC (India) similarity levels for academic work (2018 regulations): up to 10% – Level 0 (minor, no penalty); 10–40% – Level 1; 40–60% – Level 2; above 60% – Level 3. Quoted work with citation, references and common phrases are usually excluded.

Ethical practices followed: informed consent from respondents, confidentiality, honest reporting, no fabrication or falsification, and proper acknowledgement.

Result: The similarity index of the draft was checked and reduced to an acceptable level after revision.

Conclusion: The document was made original through plagiarism checking and revision, and ethical research practices were followed throughout the study.

---

Aim: To prepare a complete research paper including Abstract, Introduction, Methodology, Results, Conclusion and References in IEEE or APA format.

Theory: A research paper presents a study in a standard structure so that readers can understand and evaluate it. IEEE format is used in engineering and computer science; APA format is used in social sciences and management.

Key formatting features:

Procedure:

1. Download the official IEEE conference template (Word or LaTeX) or set up APA formatting.
2. Write the title, author names and affiliations.
3. Write each section using the results of earlier experiments:
   1. Abstract: purpose, sample of 120 BCA students, survey, correlation and t-test, main finding.
   2. Introduction: rise of social media, problem, objectives and hypotheses.
   3. Literature review: summary of 8–10 papers and the research gap.
   4. Methodology: descriptive design, stratified sampling, Google Forms questionnaire, Excel / SPSS analysis.
   5. Results: descriptive table, charts and test results with p-values.
   6. Discussion: interpretation, comparison with earlier studies and limitations.
   7. Conclusion: findings, recommendations and future scope.
   8. References: generated with Zotero in IEEE style.
4. Add index terms (keywords), number tables and figures, and check formatting.
5. Run a plagiarism check before final submission.

Result: A complete research paper in IEEE format was prepared.

Conclusion: The full research process – from problem identification to analysis – was documented as a properly formatted research paper.

---