Count of CARRER CARRER

NAME Sum of CUET SCORE RESULT NAME CORPORATE

ASHU 636 PASS ASHU 1
HARMAN 578 FAIL HARMAN 1
HURSIMRAN 611 PASS HURSIMRAN
ISHA 720 PASS ISHA
JAMEET KAUR 567 FAIL JAMEET KAUR
LAVANYA 655 PASS LAVANYA
MANSI 654 PASS MANSI
PREET 731 PASS PREET
RITIK 711 PASS RITIK
SHIVAM 701 PASS SHIVAM
SIMRAN 634 PASS SIMRAN 1
SNEHDEEP KAUR 656 PASS SNEHDEEP KAUR
YASH 535 FAIL YASH 1
Total Result 8389 Total Result 4
Table a Table B

REPORT
Thereafter, the results have been shown using the
The IF function allowed us to make a logical comparison between a value and wh
and returning a result, if pass or fail, i.e,
IF|@ B4:B16 < 600," FAIL",
""PASS")
if students have scored marks <600 they have been declared f
In table 3
again, the rows depicts the names of the students, columns representing their ca
their career .
we have used the COUNTIF function
From this the number of people optIng for the GOVERNMENT JOBS
To use COUNTIF, WE HAVE provide a range that contains cells we want to count, th
condition.
 CREATIVE GOVT TECHNICAL Total Result
1 5
1 5
1 1 5
1 1 5
1 1 5
1 1 4
1 1 3
1 1 3
1 1 2
1 1 2
1 1
1 1 1
1 0
2 5 2 13
B

PORT
een shown using the IF function
tween a value and what we expected by testing for a condition
sult, if pass or fail, i.e,
6 < 600," FAIL",
PASS")
have been declared failed in this example .
able 3
representing their career choices and values with the count of
career .
e COUNTIF function
GOVERNMENT JOBS is applied to the whole row .
we want to count, then provide the criteria needed to apply the
dition.
Count of WANT TO WORK ABROAD WANT TO WORK ABROAD
NAME MAYBE NO YES Total Result
ASHU 1 1
HARMAN 1 1
HURSIMRAN 1 1
ISHA 1 1
JAMEET KAUR 1 1
LAVANYA 1 1
MANSI 1 1
PREET 1 1
RITIK 1 1
SHIVAM 1 1
SIMRAN 1 1
SNEHDEEP KAUR 1 1
YASH 1 1
Total Result 4 6 3 13

Pivot Table 1
This pivot table shows the students names in the rows are the data as fol
with the data of students responding whether they want to work abroad o
with responses as
Maybe: 4
NO : 6
AND
Yes : 3
and completing a total number of 13 surveyees.
therefore ,
majority students are not willing to work aboroad
 pie chart of want to work abroad
ASHU
HARMAN
HURSIMRAN
ISHA
JAMEET KAUR
LAVANYA
MANSI
PREET
RITIK
SHIVAM
SIMRAN
SNEHDEEP KAUR
YASH
Total Result

rows are the data as follows

y want to work abroad or not

13 surveyees.

work aboroad
Count of IMPORTANCE OF JOB SECURITIMPORTANCE OF JOB SECURITY
NAME EXTREMELY IMPORTANT NOT IMPORTANT SOMEWHAT IMPORTANT
ASHU 1
HARMAN 1
HURSIMRAN 1
ISHA 1
JAMEET KAUR 1
LAVANYA 1
MANSI 1
PREET 1
RITIK 1
SHIVAM 1
SIMRAN 1
SNEHDEEP KAUR 1
YASH 1
(empty)
Total Result 9 1 3

ASHU
EXTREMELY IMPORTANT HARMAN
HURSIMRAN
ISHA
JAMEET KAUR
LAVANYA
MANSI
PREET
RITIK
SHIVAM
SIMRAN
SNEHDEEP KAUR
YASH
(empty)
Total Result

Here , we have depicted A piechart and Bargraph respe

In the data the 13 students have given their views on the

In the pivot table shows the job security with their Nam
imporyance in the columns and total count in the values

The students who believe job security is extremely impo

Here , we have depicted A piechart and Bargraph respe

In the data the 13 students have given their views on the

In the pivot table shows the job security with their Nam
imporyance in the columns and total count in the values

The students who believe job security is extremely impo

seriousness .
Then ,
Student who believe that its not important has a sole num
and ,
students who believe that its somewhat important are 1
Hence completing up a total number of 13 students

The pie chart shows that the majority of the students are

Next the bar graph

It shows the counts of challanges with their desired care
With 4 students believing the lack of resources to be the
Personal Limitations are majorly affecting the students
 Count of CHALANGES FOR DESIRED CAREERCHALANGES FOR DESIRED CAREER
(empty)Total Result NAME LACK OF RESOURCE
1 ASHU 1
1 HARMAN
1 HURSIMRAN
1 ISHA
1 JAMEET KAUR 1
1 LAVANYA
1 MANSI
1 PREET 1
1 RITIK
1 SHIVAM
1 SIMRAN
1 SNEHDEEP KAUR
1 YASH 1
Total Result 4
13

0
SI K t
HU AN N HA UR
A
N Y AN ET TI M AN UR SH ul
AS RM RA IS KA A RE RI IVA MR KA YA Re
s
M V M P
HA S I T LA SH SI EP ta
l
R EE DE To
HU JA
M E H
SN

rt and Bargraph respectively .

iven their views on the importance of the job securities for them .
curity with their Names in rows ,
otal count in the values

urity is extremely important are 9 , hence it shows that majority of students are aware about the
rt and Bargraph respectively .

iven their views on the importance of the job securities for them .
curity with their Names in rows ,
otal count in the values

urity is extremely important are 9 , hence it shows that majority of students are aware about the

mportant has a sole number 1.

what important are 13

ber of 13 students

ority of the students are believein job security to be most important .

with their desired career

of resources to be the main cause
affecting the students .
NGES FOR DESIRED CAREER
MARKET COMPETITIONPERSONAL LIMITATIONSTotal Result
1
1 1
1 1
1 1
1
1 1
1 1
1
1 1
1 1
1 1
1 1
1
4 5 13

CHALANGES FOR DESIRED CAREER LACK

OF RESOURCE
MARKET COMPETITION
PERSONAL LIMITATIONS

t
M AN UR SH s ul
IVA MR KA YA Re
H SI EP l
ta
HDE To
E
SN

ware about the

ware about the
NAME CLASS STREAM 12TH SCORE CUET SCORE CARRER
MANSI BAP ARTS 60-80 654 CREATIVE
SIMRAN BAP SCIENCE 90+ 634 CORPORATE
ISHA BAP SCIENCE 90+ 720 CREATIVE
RITIK BAP COMMERCE 60-80 711 TECHNICAL
YASH BAP ARTS 60-80 535 CORPORATE
PREET BCOM HONS. COMMERCE 90+ 731 GOVT
LAVANYA BCOM HONS. COMMERCE 90+ 655 GOVT
HURSIMRAN BCOM HONS. COMMERCE 60-80 611 TECHNICAL
ASHU BCOM PROG. COMMERCE 60-80 636 CORPORATE
SHIVAM BAP ARTS 90+ 701 GOVT
SNEHDEEP KAUR BCP COMMERCE 60-80 656 GOVT
JAMEET KAUR BCP COMMERCE 60-80 567 GOVT
HARMAN BCP COMMERCE 60-80 578 CORPORATE

THE SURVEY DATA

The following survey data shows the data of the students from the c
Subjects from SGNDK College giving their responses on various qu
them on the topics of Career Choices and Academics

This Data contains the names of 1 3 surveyees with their responses a

questions respectively .

A PivotTable is a powerful tool to used by us ro calculate, summariz

and see comparisons, patterns, and trends in this data of s
 IMPORTANCE OF JOB SECURITY WANT TO PURSUE FURHER EDUCATION
NOT IMPORTANT YES, IMMEDIATELY
EXTREMELY IMPORTANT YES BUT AFTER GAINING SKILLS
EXTREMELY IMPORTANT NO , NOT ANY FURTHER
SOMEWHAT IMPORTANT YES , IMMEDIATELY
EXTREMELY IMPORTANT NO , NOT ANY FURTHER
EXTREMELY IMPORTANT YES BUT AFTER GAINING SKILLS
EXTREMELY IMPORTANT YES BUT AFTER GAINING SKILLS
EXTREMELY IMPORTANT YES BUT AFTER GAINING SKILLS
EXTREMELY IMPORTANT NO , NOT ANY FURTHER
SOMEWHAT IMPORTANT YES , IMMEDIATELY
SOMEWHAT IMPORTANT YES , IMMEDIATELY
EXTREMELY IMPORTANT YES BUT AFTER GAINING SKILLS
EXTREMELY IMPORTANT NO , NOT ANY FURTHER

TA

udents from the courses of various

es on various questions asked from
s and Academics .

heir responses about a total of 12

ly .

ulate, summarize, and analyze data

n this data of students .
MAIN GOAL FOR 5 YEAR FROM NOW WANT TO WORK ABROAD
ESTABLISHING CAREER IN MY FIELD YES
GAINING VARIETY OF EXPERIENCE MAYBE
ESTABLISHING CAREER IN MY FIELD MAYBE
ESTABLISHING CAREER IN MY FIELD NO
ESTABLISHING CAREER IN MY FIELD YES
GAINING VARIETY OF EXPERIENCE NO
GAINING VARIETY OF EXPERIENCE NO
GAINING VARIETY OF EXPERIENCE MAYBE
ESTABLISHING CAREER IN MY FIELD MAYBE
ESTABLISHING CAREER IN MY FIELD NO
ESTABLISHING CAREER IN MY FIELD NO
PURSUING FURTHER EDUCATION NO
ESTABLISHING CAREER IN MY FIELD YES
IMPORTANCE OF WORK LIFE BALANCE SKILLS FOR DESIRED CAREER
IMPORTANT BUT NOT A DEALBREAKER CREATIVE SKILLS
NOT AS MUCH AS OTHER FACTORS CREATIVE SKILLS
IMPORTANT BUT NOT A DEALBREAKER CREATIVE SKILLS
NOT AS MUCH AS OTHER FACTORS CREATIVE SKILLS
EXTREMELY IMPORTANT TECHNICAL SKILLS
NOT AS MUCH AS OTHER FACTORS SOFTS SKILLS
EXTREMELY IMPORTANT SOFTS SKILLS
EXTREMELY IMPORTANT TECHNICAL SKILLS
NOT AS MUCH AS OTHER FACTORS SOFTS SKILLS
EXTREMELY IMPORTANT SOFTS SKILLS
EXTREMELY IMPORTANT SOFTS SKILLS
EXTREMELY IMPORTANT CREATIVE SKILLS
IMPORTANT BUT NOT A DEALBREAKER CREATIVE SKILLS
ROLE MODEL CHALANGES FOR DESIRED CAREER
VIRAT KOHLI PERSONAL LIMITATIONS
FATHER MARKET COMPETITION
TEACHER MARKET COMPETITION
ELON MUSK MARKET COMPETITION
NARENDRA MODI LACK OF RESOURCE
MICHELLE OBAMA LACK OF RESOURCE
APJ ABDUL KALAM PERSONAL LIMITATIONS
VIRAT KOHLI MARKET COMPETITION
MOTHER LACK OF RESOURCE
YOGI ADITYANATH PERSONAL LIMITATIONS
SHRUSHTI JAYANST DESHMUKH PERSONAL LIMITATIONS
VIRAT KOHLI LACK OF RESOURCE
RATAN TATA PERSONAL LIMITATIONS