Lingaya’s Vidyapeeth Students: First-Year Guide to a Light Data Analytics Internship

Yes, a first-year student can do a useful data analytics internship in 14 days, provided the goal is small and specific. Aim for clean spreadsheets, a handful of summary statistics and one honest chart rather than a full project. This guide gives you a skills ladder with realistic targets for Excel and basic statistics, a day-by-day plan, and a checklist of low-pressure tasks to request.

What a light analytics internship means in 14 days

A light internship is one where you practise the fundamentals on small, real-looking datasets and produce a few modest outputs. It is not a model-building sprint. In two weeks, with perhaps one to two hours on most days alongside classes, you can reasonably expect to:

• Clean a messy table so that it is usable.
• Calculate and explain averages, medians and spreads.
• Build a pivot table and two or three clear charts.
• Write a short note saying what the numbers do and do not show.

The free two-week online internship at CareerSwami is offered in 26 tracks, with a free offer letter and a free completion certificate after successful completion. It carries no stipend and no academic credit, so treat it as structured practice that gives you something concrete to talk about, not as a qualification.

Excel and basic statistics skills ladder for first-years

Climb one rung at a time. A first-year who is solid on rungs 1 to 4 after two weeks has done well. Rungs 5 and 6 are stretch targets, not expectations.

Statistics ideas worth understanding before formulas

• Median versus mean: a few very large values pull the mean up; the median resists them.
• Spread: two classes can share an average and still look very different.
• Sample size: a pattern in 12 rows is a hint, not a conclusion.
• Correlation: two columns moving together does not show one causes the other.

Checklist of low-pressure tasks to ask for instead of a full project

If a mentor or the programme asks what you would like to work on, these requests are small, finishable and easy to assess. Tick them off as you go.

• ☐ Clean one raw dataset of 100 to 500 rows and document each change you made.
• ☐ Remove duplicates and flag missing values rather than silently filling them.
• ☐ Standardise one messy text column (for example “Delhi”, “delhi “, “New Delhi”).
• ☐ Build a one-sheet summary of totals, averages and counts using formulas only.
• ☐ Compute the median and standard deviation for two numeric columns and explain them in a sentence each.
• ☐ Create one pivot table and answer a single question with it.
• ☐ Draw two charts and rewrite the titles so each states a finding.
• ☐ Spot-check ten rows by hand to confirm your formulas are right.
• ☐ Write a half-page note: what the data shows, what it cannot show, and one question you would ask next.
• ☐ Ask for written feedback on the cleaned file instead of a presentation.

A 14-day plan built around small wins

Worked illustration: analysing a small canteen sales sheet

This example is illustrative. The numbers are invented for teaching and were not produced from a real dataset or run in software.

Imagine a 200-row sheet of daily canteen sales with columns for date, item, quantity and price. Your three-day mini task is below.

1. Clean: You find “Samosa”, “samosa” and “Samosa ” as three items. You standardise them to one label and record the change in your log. Two rows have blank quantities; you highlight them instead of guessing.
2. Calculate: You add a revenue column as quantity multiplied by price. Suppose daily revenue is mostly between 4,000 and 6,000 rupees, but one festival day shows 19,000. The mean would be pulled upward, so you report the median alongside it.
3. Summarise: A pivot table shows revenue by item. You make one bar chart titled with the finding, such as “Two items account for most revenue” (only if your own pivot shows that).
4. Caveat: Your note says 200 rows cover a limited period, the festival day is an outlier, and two rows are missing quantities, so the totals are approximate.

That is a complete, honest piece of analysis for a first-year, and each step maps to a rung on the ladder above.

Lingaya’s Vidyapeeth first-years: fitting a light internship around the university’s own rules

Lingaya’s Vidyapeeth is described on the cover of its 2017-18 annual report as a Deemed to be University under Section 3 of the UGC Act 1956, with its campus placed at Nachauli on Old Faridabad–Jasana Road. The same report notes that the academic regulations, including promotion conditions to a higher semester for programmes of three or more years, are set through the university’s Academic Council and Board of Management. In practice, that means your internship questions are answered by the university’s own regulations, not by an outside affiliating body.

The report also describes a mandatory internship programme of six months meant to link the university with industry. That report is from 2018, so treat the six-month figure cautiously; it may have changed under later schemes, and the report does not say which programmes or which semester it applies to. As a first-year, you should not assume a 14-day online internship replaces, counts toward or relates to that requirement. Treat it as extra skill practice unless the university tells you otherwise in writing.

The same report’s staff list shows a Training & Placement Section, so that office is a sensible first contact for internship questions. Use these steps to verify the current position:

1. Ask your department office for the current internship regulation or scheme document that applies to your batch and programme, and note the year on it.
2. Email the Training & Placement Section asking in which semester the mandatory internship falls and whether short online internships are recognised, recorded or ignored.
3. Ask in writing whether a certificate from an external online internship can be submitted for any purpose, and in what format.
4. Check your academic calendar for exam weeks so the 14 days do not clash with assessments.
5. Ask your data-related faculty or mentor whether the university has a preferred way to list extra skill certificates on your record.
6. Keep the replies. A saved email is better evidence than a verbal answer.

How to pick a dataset that suits a first-year

• Size: 100 to 1,000 rows is plenty. Larger files slow you down without teaching more.
• Columns: five to ten, with a mix of text, dates and numbers.
• Familiar context: sales, attendance, cricket scores, hostel expenses or survey responses are easier to reason about.
• Some mess: a few blanks and inconsistent labels are useful because cleaning is the real skill.
• Privacy: do not use files that contain real people’s names, phone numbers or marks without permission.

Signs your internship week is drifting off course

• You are copying formulas from tutorials without being able to explain them.
• Your charts are decorated but the titles say nothing about the finding.
• You jumped to prediction or machine learning before you could explain a median.
• You cannot say how many rows you removed or changed and why.
• Every task is “almost done” but nothing is saved in a shareable state.

When you notice any of these, go back one rung on the ladder, finish a small piece, and move forward again.

Turning two weeks into something you can show

Assemble one workbook with these tabs: Raw Data, Cleaned Data, Change Log, Summary, Statistics, Pivot, Charts and Findings Note. Add a short README tab stating what the dataset is, where it came from, and what you did. Then write two or three honest bullet points for your resume or LinkedIn, such as “Cleaned and summarised a 200-row sales dataset in Excel using formulas, pivot tables and descriptive statistics.” Avoid claiming outcomes you cannot back up, and do not describe the internship as paid, credit-bearing or a job.

Frequently Asked Questions

Can I do a data analytics internship in my first year with no coding?

Yes. Excel and basic statistics are the right starting point, and many analysis tasks never need code. Coding in Python or SQL can come later once you understand what the numbers mean.

How many hours a day does a light 14-day internship need?

One to two focused hours on most days is a reasonable target for a first-year, with a longer block on a weekend if you want to catch up. Consistency matters more than long sessions.

Which Excel functions should I learn first?

Start with SUM, AVERAGE, MEDIAN, COUNT, COUNTIF and IF, then XLOOKUP or VLOOKUP, and then pivot tables. These cover most of what a beginner analysis needs.

Is median or mean better for a small dataset?

Neither is always better. Report both when values are skewed or when there are outliers, and say which one you trust more for the question at hand.

Will this internship count toward Lingaya’s Vidyapeeth’s internship requirement?

That is not something this guide can confirm. The 2017-18 annual report describes a six-month mandatory internship, but current rules may differ. Ask your department and the Training & Placement Section in writing before assuming anything.

Does the CareerSwami internship give a stipend or academic credit as a Lingaya’s Vidyapeeth student?

No. It is a free two-week online internship with a free offer letter and a free completion certificate after successful completion. It does not promise a stipend, credit, placement or a job.

What should I put in a findings note?

Write what question you asked, what the data shows, how many rows were cleaned or excluded, what the data cannot tell you, and one follow-up question. Keep it under one page.

How do I know whether my analysis is correct?

Spot-check at least ten rows by hand, compare totals from two different methods (for example a formula and a pivot table), and ask a mentor or classmate to review your logic. Agreement between methods is a good sign.

Related Data Analytics guides

• West Bengal State University Students: Structuring a GitHub Repository for Analytics Internship Work
• The Global University Students: Finding Remote Data Analytics Internships from Arunachal Pradesh
• ICT Mumbai Students: Applying Data Analytics to Lab and Process Data in an Internship
• All Data Analytics internship guides