SKILL DEVELOPMENT AT ASE

EXCEL WORKSHOP SESSION 1

EXCEL WORKSHOP CONDUCTED BY THE PLACEMENT CELL OF ASE

The Placement Cell of Amity School of Economics conducted its first skill development workshop for the academic year 2017-18 on 21st July 2017 on The Basics of Microsoft Excel. In today’s exceedingly competitive state of affairs especially when it comes to job attainment, a hands-on knowledge of practical software has become extremely imperative. Additionally, students of Economics are now expected to have at least a basic knowledge of MS Excel and software such as SPSS, STATA, R when they sit for their placement interviews.

placements

The workshop was conducted primarily by Shilpi Gupta, a Masters student and the Head of the Placement Committee. Keeping in mind that a practical knowledge and experience of software shall augment the employable potential of students, the placement committee conducted this workshop for students from M.A Economics. During the session, essential features such as basic and conditional formatting were revised, and an overview of key features such as Grouping, Sorting of Data, and Error Checking was delivered. A systematic review of the functions used was provided, with a special emphasis on Logical Functions of ‘IF’ and ‘Nested IF’.

The workshop was attended by over forty students and feedback was collected. All the students were pleased with what they viewed as a great start to the year, as their general belief was that workshops of this nature shall help them irrespective of the professional field they pursue.

placements
placements

One of the Master’s students, Neha Thureja was asked about her experience after the session. She remarked, “I have always been afraid of working with data even though my theoretical concepts are strong. I had to seek help when it came to data analysis, but after attending this session I think I will not need help anymore. I am grateful to the placement team for conducting workshops which give students confidence to do things independently.”

After receiving immensely positive feedback, the Placement Cell of ASE shall be replicating such sessions for Bachelors students as well in upcoming future. The Committee also plans to conduct a series of workshops over this year so that when at the end of the year students from ASE sit for the placement interviews, there is nothing that holds them back from getting their dream jobs.


EXCEL WORKSHOP SESSION 2

DATE: August 3, 2017

TIME: 2:30-4:30

VENUE: Room 404 B block

Session began with a group of 25 students of masters of economics final year. A brief recap of previous session and introduction of current session and its agenda was discussed.

Different functions were introduced paste special, random numbers, random numbers in a range, v look up, h look up, match, index, combination of index and match functions, concatenate function and alternate formula for same, trim and length. All doubts were attended well and sorted. How to retrieve data set from RBI website was shown and how to operate upon it was explained.

The feedback forms outcome analysis depicted a positive response at part of the participants. Some students really appreciated the teams coordination. They were satisfied with the query handing.

placements

placements

EXCEL WORKSHOP SESSION 3

DATE: August 4, 2017

TIME: 2:30-4:30

VENUE: Room 404 B block

Session began with a group of 15 students of m.a. Economics final year. Abrief recap of previous session and introduction of current session and its agenda.

Different functions were introduced offset, count, count a, count blank, average, standard deviation, correl, combination function for percentage change in data. Various ways of using all formulas in the real huge data set was discussed.

On analysis of feedback forms filled by participants depicted a positive response at part of the participants. Some students really appreciated the teams coordination. They were satisfied with the query handing and they expressed their willingness to attend it further in future.

placements

placements

EXCEL WORKSHOP SESSION 4

Amity School of Economics Placement Cell conducted its fourth excel workshop as a part of the skill development drive. After the positive responses from students for the previous session, this session continued to aim at development of advance excel skills among the budding economists.

This session was themed as the charting techniques used for data analysis. Charting plays an important role in the work of analysts and researchers as it helps in representation of big data sets. The session aimed at making students acquaint with the basis of charting techniques, utility of different types of charts and analysis and interpretation of the same. The data set circulated in the assignment to students pertained to Reserve Bank of India's time series data.

placements

Initially in the session, the importance of labelling and alignment of axis of charts was stressed upon, as it forms the foundation of a good chart.

Next, the students practiced charting different types of charts including line charts, bubble charts and area charts on the RBI data set. The students were explained the mechanism working behind these charts and how it complied with the economic theory.

Further, the concept of ratio analysis was explained to students which can help them make formulas out of the given data sets. This practice was also conducted on the RBI data set including variables like currency in circulation, reserve money and deposits.

placements

While the students were practicing the excel techniques discussed in the session, their individual queries were catered to, by the core member of the committee. This was down to ensure that everyone was at pace with the charting and analysis techniques taught in the session.

The workshop was attended by more than 20 students. Post workshop their feedbacks were collected and analysed. There reposes at part of students was positive as they remarked the session helped them understand the foundation and utility of charting. They were now able to improve their presentation by incorporating the appropriate charts that represented the underlying data of the study. The workshop not only equipped the students with the knowledge of how to create charts but also how to interpret and analyse them. Thus, the objective of the session was successfully fulfilled.