Research Output of Thiagarajar College of Engineering, Madurai during 2014- 2018: A Scientometric Analysis using Excel Sheet

This study examined the research publications of the faculty of Thiagarajar College of Engineering (TCE), Madurai, Tamilnadu, India. Data for this study have been collected from the Scopus and web of science databases for 2014-2018. Among 1270 papers published and indexed in the Scopus for five years and 437 papers published and indexed in the web of science. This paper shows how to use an excel sheet for calculating the h-index, i-10 index, average citation per year, cited rate, percentage of cited and non-cited paper, real average citation, etc.. Apart from the above analysis, this paper finds the overlap publications of Scopus and Web of Science.


Introduction
Scientometric is an analysis of scientific publication on various authorship patterns, document type, number of citations, top-cited paper, average citation per year, subject area, research growth of any Topic or institutions, etc. This study attempted to know the research output of the faculty of Thiagarajar College of Engineering (TCE), Madurai, using Bibliometric / scientometric techniques. The data for this study is retrieved from Scopus and web of science indexing database. Also, this paper shows the easy method of analyzing the research data by using MS Excel. This paper provides you the formula used for this study with a simple example. It is observed that to know the research growth; it is to analyze a minimum of five-year data. It takes for the last five years to know the growth of research publication of TCE, Madurai. The data collected in the excel separately for both Scopus and WoS and used relevant formulas for analysis.

Methodology
Data retrieved on 10.09.2019 from the Scopus database by using affiliation id "60033058" and affiliation name "Thiagarajar College of Engineering" and also filter further the year from 2014-2018 using advance searches. Web of Science data is retrieved on 11.10.2019 by using the advance search option "OG=Thiagarajar College of Engineering" and "Timespan=2014-2018". OG stands for Organisation enhanced in Web of Science search.. The above table shows the publication count of Scopus indexed is more than Web of Science indexed. Also it observed that fewer than 437 publications of Web of Science 390 publications are available in Scopus also. So it is observed that Scopus has indexing wide range of publications than the Web of Science. At the same time Web of Science has restricted with Journals also it seems the quality of the database. The above table shows that the coverage of conference proceedings is more in Scopus than the Web of Science; also Scopus covers book chapters, review, editorial etc. Also it is observed that most of IET, IEEE, NPEC, i-PACT conferences are not indexed in Web of Science whereas it is indexed in Scopus database.  The above results are analyzed with a simple excel sheet using the formula below given. This formula is provided with an example of Web of Science data during 2014 given in the above table 4.

H-index:
Sort the data of each year from higher citation to lower in one row. In another row from one to number of papers. Eg. In 2014 91 paper in WOS for us, here our h-index is 20. it shows that our 20th paper got 20 citation and more.

I-10 index:
Sort the data of each year from higher citation to lower in one row. And found how many of the paper have 10 and above citation is called i10 index. Eg. In 2014 we have more than 33 papers out of 91 have received 10 and above citation. % of non-cited paper: How many paper not citied in that year divided by total publications of the year in to 100. Eg. In 2014 we have 10 non-cited paper out of 91. so (10/91) *100 is the non-cited rate.

Real Average citation
Total citation divided by total real cited paper count. Eg. In 2014 we have total citation of 1152 divided by 81 which is no. of cited paper per year.
Cited and not cited paper can be easily found by sorting the list of each year publications with citations row. So that it is easy to find how many papers are having citation and how many or not having citations in each year. Table 5 Year Scopus Web of Science The above table shows that the Scopus has more publications than the Web of Science, but if we consider the citation count, h-index, and i10 index of both Scopus and Web of Science, it is found that Web of Science is more visible than the Scopus. E.g., In 2014, for Scopus, we have 274 publications with 1690 citations. But For Web of Science, in the same year, we have 1152 citations for only 91 publications. The average citation rate is higher in Web of Science than the scopus. E.g., In 2014, we have 6.17 average citation rates in Scopus and 12.66 in Web of Science (refer to Table 3 and 4).

Figure 1: Year wise Publication of Scopus and Web of Science of TCE
Here in the above figure, series 1 is Web of Science publications, and Series 2 is Scopus publications. The above figure interrupts that the publications in the Web of Science are more or less the same every year, but publications in Scopus has more variations. Also, it shows that the TCE faculty is continuously publishing the papers and concentrating on the research. The above table 6 shows that publishing any journal in both indexing database can get more citations for an author. It also shows that Google Scholar is also helping to get more citations through an open-source platform.

Figure 2: Country wise Collaboration
The above figure 2 shows that the faculty of TCE is collaborating Globally for the research. The above figure is retrieved from Web of Science on 11.10.2019 for TCE with a limit to 2014-2018 publications.

Conclusion
Here it is to conclude that Scopus is covering more Journals and conference papers than the web of science. But Web of Science is restricted mostly to Journals and covers only a few Conferences. Scopus is focusing on the researchers in the engineering stream, whereas the Web of Science is focusing on the arts and science stream. The researcher can publish papers in both Scopus and Web of Science indexing Journals based on the subject area. Both Scopus and Web of Science indexing Journals are taken by UGC approved journal list. Also, this paper provides simple techniques of scientometric study for future research. There is no special tool required for analysis of the research data of our institution. This simple approach also provides you the insight into the research pattern of any organization. The paper shows how to analyze the simple research data of any organization without much investment of tools or technical knowledge.