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.

EXCEL WORKSHOP SESSION 5

An “Excel” workshop was conducted on Thursday by Amity School of Economics, Placement Cell. This was its 5th Excel session and was held on 14th September 2017. It was held as a part of the skill development drive and aimed at enhancing and improving the skills and knowledge among the students of Microsoft excel.

The session was conducted for both Masters and Bachelors course students. It was conducted by a fellow student of M.A economic course who had the knowledge of excel and wanted to share it with others. The session started with an introduction of “Sumif, Averageif, Countif” function which are categorised as a “statistical function”. Excel provides an extensive range of statistical functions, that perform calculations from basic mean, median, and mode to more complex statistical distribution and probability tests. These functions in excel also serves the same purpose.

placements

The session began with their detailed explanations where the person conducting the session that is Mahir defined them. He explained that how these function plays an important in easily handling of data in companies and in a researcher’s life. The sumif – adds value if a condition is met, averageif- conditionally averages values. He explained the difference between the two functions, their syntaxes and their usage. Further clarity was brought in the minds of the students with the help of examples and problem solving.

The session concluded with filling up of feedback forms and their collection for future improvements.

EXCEL WORKSHOP SESSION 6, 2017

Amity School of Economics, Placement Cell, conducted its 6th excel session on 12th October 2017.After the positive responses from students from previous sessions. It was held as a part of the skill development drive and aimed at improving the skills and knowledge among the students of excel.

placements

The session was conducted by Mahir Pasrija of M.A economic department semester II. In this session the-“COUNTIF” function which is categorised as a “statistical function” was introduced and taught. The COUNTIF function in excel counts the number of cells in a range, that meets a given criteria. In plain English it can be explained as a function or a formula that can be used for counting the number of cells that fulfil a condition, within a predefined range.

This function plays an important role in the offices, schools, universities and practically everywhere where, a record is to be maintained. As it helps in sorting and in maintaining records etc. In this session, first the difference between COUNT and COUNTIF was explained by Mahir and then its formula along with syntax. Later on, in class the students were explained the techniques of using this function with the help of examples.

Some questions were then given to the class to solve themselves and while they were trying to solve the questions their doubts were also simultaneously addressed. This was done to ensure that all are at pace. The basics were quiet clear to the students, but it was made crystal clear with the efforts put in by Mahir.

The workshop was attended by master’s students. Post workshop further doubts were answered, an assignment was given and their feedback forms were collected for analysis. On the whole, the session was a successful one.

EXCEL WORKSHOP SESSION 7, 2018

Amity School of Economics, Placement Cell, conducted its seventh excel session on 25th January 2018.It was held as a part of the skill development drive and aimed at improving the skills and knowledge among the students of excel. The session was held in room no 306 post classes.

placements

The session was conducted by Mahir Pasrija of M.A economic department semester II and was on logical functions. He began by explaining that there are four logical functions: AND, OR, IF and NOT and one can use these functions when has to carry out more than one comparison. He defined Logical functions as those features that allow us to introduce decision-making when executing formulas and functions. These Functions are used to: Check if a condition is true or false. Combine multiple conditions together etc.

This function plays an important role in the work of analysts and researchers as it helps in sorting and in maintaining records etc. In this session “if” and “and” along with “or” function was taught to the students. These are known as “single” logical functions. The students were first explained about the functions then the respective formulas associated with each function were taught to them. Later on, they were made to solve certain examples in class, based on which they were given a few questions to solve. While the students were practicing the excel techniques their individual queries were addressed and discussed. This was done to ensure that all are at pace with the logical functions.

The workshop was attended by master’s students. Post workshop their feedback forms were collected and analysed. The responses were positive as they remarked it helped them in further understanding the techniques of advanced filter in excel and so, the objective of the session was successfully fulfilled.

EXCEL WORKSHOP VDE EDUCATIONAL SERVICES

Placement Team Of AMITY SCHOOL OF ECONOMICS organized an excel workshop with VDE Educational Services . It was organised on 23rd February 2018 i.e Thursday . Venue of the workshop was Conference hall and started at 9:00 am. The student strength of workshop was approximately 60.

The conference started on a motivational note. The two experts who work with Quality Council of India briefed us about the importance of MS Excel in data handing. These expert who have hands on data handling also enlightened students about how MS excel tools and techniques can be adopted by a budding economist for data analysis and handling. Workshop also include discussion on data management techniques that one can use for working efficiently and effectively.

These motivational lines gave students the energy to sit throughout the workshop. Then they started with the basic excel functions which can be applied in huge data sets. Some of the functions were sum, average, max, min etc . These functions give incite into descriptive statistics of data. Then they moved on to complex functions such as logical functions. Students were explained how to use HLOOKUP , VLOOKUP, pivots and their charting etc and their importance.

The workshop was very inciteful and meaningful for strengthening the basic foundation . It was ended on a good note by giving them the vote of thanks.

placements
placements
placements
placements