Visit to National Physical Laboratory
November 4, 2019
Visit of Students of Dronacharya College Gurgaon
November 4, 2019

Title: Short:-Term Course on Advanced Microsoft Excel
Date(s):– 23rd September’19 – 27th September’19
Faculty In-charges: Dr. Deepika Garg and Dr. Smita Sood
Total no. of participants: 36
External participants: 6
Internal Participant: 30
Total no. of sessions: 9
Total Revenue Generated and Expenditure:

Total Participants Total Revenue Generated Total Expenditure Balance
36 (6 External+30 Internal) 27,000 /- 23760/- 3240/-

Detail Report Background:

Microsoft Excel is a spread sheet developed by Microsoft for Windows, mac OS, Android. It features calculation, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications. It has been a very widely applied spread sheet for these platforms, especially since version 5 in 1993, and it has replaced Lotus 1-2-3 as the industry standard for spread sheets. Excel forms part of the Microsoft Office suite of software.

Among the computer programs which exist, Microsoft Excel is one of the most important because of the key role it plays in many sectors. It is the most used spread sheet program in many business activities, classwork and even personal data organisation. Excel was first released in the year 1985. Since then, it has played a vital role in performing formula based arithmetic and calculations, and other activities that may require mathematical calculations. Many businesses, personal and institutional enterprises have embraced the use of Excel because of its utility and the ability to serve as a visual basic for different applications. The importance of MS Excel can be seen in the different departmental units it is used in Graphing, Data organisation, Programming.

  • To help the students analyse large amount of data to discover trends.
  • To summarize the data in the form of graphs and charts.
  • To enable the participants to solve complex mathematical problems by simple mathematical functions.

 
Expected Outcomes: After the completion of the course the participants will be able to:

  • Make inferences and present data in a meaningful and effective manner using excel.
  • Understand the concept of data visualization using excel.
  • Access and manipulate data using the database functions of excel.

 
Participation:
The workshop was well attended by 36 participants from different universities across the country. The workshop was planned for 30 participants but due to overwhelming response the number of seats could only be increased to 35 because of unavailability of the lab.

Out of 36 participants, 6 were from different universities like Jamia Milia Islamia, DPG, Dronacharya, Guru Jambeshwar University of Science and technology and 30 were from different schools of GD Goenka University.

Total Revenue Generated and Expenditure:

Total Participants Total Revenue Generated Total Expenditure Balance
36 (6 External+30 Internal) 27,000 /- 23760/- 3240/-

Proceedings:

Day # 1 [23/09/19]

On 23rd September’19, the registration for the workshop started at 10:00 a.m. After registration the workshop was formally inaugurated by Prof. R.K. Thakur, Dean, SoBAS. Prof. R.K. Thakur, Dean, SoBAS also addressed the audience. The first technical session was conducted by Dr. Mainak Basu after the tea break. The session started with acquainting the participants with the Excel environment and giving them basics of Excel.

The topics included are listed as follows:

  • Entering and formatting data, Numbers and tables.
  • Basic Maths Functions
  • Freeze panes
  • Creating Headers, Footers, and Page Numbers
  • Adjusting Page Margins and Orientation
  • Adding Print Titles and Gridlines, rows to repeat at top of each page

Day # 2 [24/09/19]

On the second day, activities were divided into three technical sessions including before tea, post tea and again continuing after lunch break. All the sessions were conducted by Dr Renu Chaudhary. The first session started with Switching Between Sheets in a Workbook. After tea break session on splitting and freezing a window in Excel was conducted.

The topics included were as follows:

  • Switching Between Sheets in a Workbook
  • Inserting and Deleting Worksheets
  • Renaming and Moving Worksheets
  • Protecting a Workbook
  • Hiding Columns, Rows and Sheets
  • Entering Date Values and using AutoComplete
  • Using the Paste Special Command
  • Inserting Page Breaks
  • Finding and Replacing Information
  • Inserting Cell Comments

 
Day # 3 [25/09/19]

On 25th September 2019, the sessions were delivered by Dr Naresh Sharma. First session focussed on Sorting and Filtering data in Excel. In the second session the emphasis was given on Data Analysis & Pivot Tables. In the third and the last session of the day starting after lunch break, covered creating a PivotTable specifying the Data.

The topics included were as follows:

  • Sorting, Subtotalling & Filtering Data
  • Creating a PivotTable
  • Specifying the Data a PivotTable Analyses
  • Changing a PivotTable’s Calculation
  • Selecting What Appears in a PivotTable
  • Grouping Dates in a PivotTable
  • Updating a PivotTable
  • Formatting and Charting a PivotTable CountIFS, SumIF, SumIfS)

 
Day # 4 [26/09/19]
On 26thSeptember 2019, the technical sessions were conducted by Dr Renu Singh. The session started with introduction to Creating a Chart, Moving and Resizing a Chart. Participants were told about formatting and editing objects in a chart, changing a chart’s source data.

The topics included are listed as follows:

  • Changing a Chart Type and Working with Pie Charts
  • Adding Titles, Gridlines, and a Data Table
  • Formatting a Data Series and Chart Axis
  • Annotating a Chart
  • Working with 3-D Charts
  • Selecting and Saving a Custom Chart
  • Using Fill Effects
  • Mapping Data
  • Modifying a Map

 
Day # 5 [27/06/19]

Last day of the workshop started with Recording a Macro. Participants were taught about playing a macro and assigning macro a shortcut key. The last session was dedicated to modifying an Inserted Excel Worksheet.

The topics included are listed as follows:

  • Playing a Macro and Assigning a Macro a Shortcut Key
  • Adding a Macro to a Toolbar
  • Inserting an Excel Worksheet into a Word Document

All the sessions were interactive, and the speakers answered many queries raised by the participants. The entire programme was well co-ordinated with the support of the Dean, SoBAS, faculty members and Ph.D. research scholars of School of Basic and Applied Sciences.

Feedback:
After analysing the feedback forms filled by participant it was concluded that students like the course content, speakers of the workshop. They admired the hospitality provided from GDGU. All the participants expressed their gratitude to staff of School of Basic and Applied Sciences for conducting Short-Term course on Advanced Microsoft Excel.

Outcomes of the Course:
Participants got familiar with Microsoft Excel. They appreciated the importance of Excel in various fields. They were able to access and manipulate data using the database functions of Excel. Participants exchanged ideas on the topics of importance along with the thought-provoking technical sessions.

Future Perspectives:
The Department of Mathematics, SoBAS is looking forward to organizing many such Short-Term Courses in different fields of Mathematics.

Glimpse of the workshop:

Leave a Reply

Your email address will not be published. Required fields are marked *

Application Form