EMPLOYABILITY SKILLS – PRACTICAL FILE

 🌟 EMPLOYABILITY SKILLS – PRACTICAL FILE

---

S. No. Title of Practical / Activity

1. Preparation of a Professional Resume in Proper Format

2. Writing an Application for Scholarship with Correct Structure

3. Performing a SWOT Analysis (Strengths, Weaknesses, Opportunities, Threats)

4. Understanding and Writing SMART Goals (Specific, Measurable, Achievable, Relevant, Time-Bound)

5. Drafting an Application for Employment to the HR Manager

6. Setting Long-Term and Short-Term Career Goals

7. Creating a Table in MS Excel and Applying SUM, AVERAGE, MAX, MIN Functions with Stepwise Screenshots

---

⭐ 1. RESUME WRITING

Aim:

To learn how to prepare a professional resume.

Sample Resume:

Name: Riya Sharma

Address: Faridabad, Haryana

Phone: 98XXXXXX45

Email: riyasharma@example.com

Career Objective:

To obtain a position where I can use my skills to contribute to the growth of the organisation.

Educational Qualification:

Class School Board Year Percentage

12th Govt. Sr. Sec School CBSE 2024 87%

10th Govt. Sr. Sec School CBSE 2022 91%

Skills:

• Communication Skills

• Basic Computer Knowledge

• MS Word, Excel, PowerPoint

• Teamwork & Leadership

Hobbies:

Reading, Drawing, Dancing

Declaration:

I hereby declare that the information provided above is true.

Signature

Riya Sharma

---

⭐ 2. SCHOLARSHIP APPLICATION

Aim:

To learn how to write an application for scholarship.

Application:

To,

The Principal,

Govt. Sr. Sec School,

Faridabad.

Subject: Application for scholarship.

Respected Sir/Madam,

I, Riya Sharma of Class 12, request you to kindly grant me a scholarship. I belong to a financially weak family, and this scholarship will help me continue my studies.

I shall be thankful to you.

Thanking you,

Yours sincerely,

Riya Sharma

Class 12

---

⭐ 3. SWOT ANALYSIS

Aim:

To analyze personal strengths, weaknesses, opportunities, and threats.

Strengths Weaknesses

Good communication Shy in public speaking

Hardworking Slow decision-making

Good computer skills Less confidence

Opportunities Threats

Scholarships High competition

Skill development courses Financial issues

Result: SWOT Analysis completed successfully.

---

⭐ 4. SMART GOALS

Aim:

To set goals using the SMART rule.

SMART Format:

S – Specific

M – Measurable

A – Achievable

R – Relevant

T – Time-Bound

Example SMART Goal:

Goal: “I will improve my English vocabulary by learning 10 new words daily for 3 months.”

Specific – Learn new words

Measurable – 10 words per day

Achievable – Yes

Relevant – Helps in career

Time-bound – 3 months

---

⭐ 5. APPLICATION FOR EMPLOYMENT TO HR

Aim:

To write a professional job application.

Application:

To,

The HR Manager,

ABC Pvt. Ltd.,

New Delhi.

Subject: Application for the post of Office Assistant.

Respected Sir/Madam,

I am writing to apply for the position of Office Assistant. I have completed my Senior Secondary education and possess good communication and computer skills. I assure you of my hard work and sincerity.

Kindly consider my application.

Thanking you,

Yours faithfully,

Riya Sharma

Phone: 98XXXXXX45

---

⭐ 6. SHORT-TERM AND LONG-TERM GOALS

Aim:

To understand the difference between short-term and long-term goals.

Short-Term Goals (0–6 months):

• Improve English speaking

• Learn MS Excel & PowerPoint

• Score above 85% in exams

Long-Term Goals (1–5 years):

• Become financially independent

• Get a stable job

• Complete higher education

Result: Student understood how to set goals.

---

⭐ 7. EXCEL TABLE WITH FORMULAS (SUM, MAX, MIN, AVERAGE)

Aim:

To learn how to use Excel formulas.

---

Excel Data Table

Employee Salary Bonus Total Working Days

Aman 25000 2000 26

Riya 30000 2500 24

Mohit 28000 1800 25

Sanya 35000 3000 26

Karan 22000 1500 23

Assume:

Salary = Column B

Bonus = Column C

Working Days = Column D

---

Formulas Applied

✔ 1. SUM (Total Salary Paid)

=SUM(B2:B6)

✔ 2. AVERAGE (Average Bonus)

=AVERAGE(C2:C6)

✔ 3. MAX (Highest Salary)

=MAX(B2:B6)

✔ 4. MIN (Minimum Working Days)

=MIN(D2:D6)

---

⭐ Steps to Do This in Excel (Write these in file)

1. Open MS Excel.

2. Enter data in columns A, B, C, D.

3. Select the cell where result is needed.

4. Type formula (SUM, AVERAGE, MAX, MIN).

5. Press Enter.

6. Excel will show the result.

7. Save the file.

8. Take screenshot and paste in practical file.

---

⭐ 8. Screenshots

(You will take screenshots after creating the Excel sheet and paste here.)