Coordinator and Team: Dr Ramesh Sharma

Email of course coordinator: rcsharma@aud.ac.in

Pre-requisites It is desirable that the students have experience of simple mathematical operations, computer keyboard use, web browsing, using search engines and computer handling at the basic level.

1. No. of students to be admitted (with justification if lower than usual cohort size is proposed):

Usual cohort size

1. Course scheduling (semester; semester-long/half-semester course; workshop mode; seminar mode; any other – please specify):

Semester mode

Aim:

We deal with data on daily basis in our life. Be it for household tasks or office work or business purpose. We face numbers in one way or another. These numbers need to be processed in the form of simple calculations or complex statistics. We use this data for decision making, trends analysis and forecasts etc. In whatever career field we are, be it scientist, researcher, shopkeeper, vendor, teacher, or labourer, we need to play with numbers. Calculations and processing of numbers are integral to our life functions. We need visualisation to present our data. Such situations call for skills to deal with numbers processing. The course in Microsoft Excel helps in developing skills to make meaning of data and numbers and present them in text format of visually. Almost all businesses require creating detailed worksheets, invoices, charts, and complex formulas.

The course is designed for those with little or no functional knowledge of Excel, as well as those who regularly use Excel at a basic level, but wish to enhance their skills. From basic operations to an introduction to more advanced techniques, the students would gain the confidence to navigate the Excel interface, master essential spreadsheet functions, perform calculations and produce creative charts and graphs from the data, while building an aptitude for data analysis that is critical to the success of any organization.

Course learning outcomes:

At the end of the course, the students will be able to:

• Navigate the Excel user interface, entering, manipulating and formatting data.
• Use formulas and functions to perform calculations on data.
• Create easy-to-use spreadsheets, validate data, find and correct errors.
• Analyse tabular information using Pivot Table Wizard.
• Create charts and tables that effectively summarize raw data.
• Create visualization using processed data

Brief description of modules/ Main modules:

This course is organised in 10 modules. First module introduces structure of workbook, 2nd module provides information about inputting data and editing it. 3rd module deals with data calculation operators and precedence, 4th module demonstrates formatting a workbook. Next module 5 deals with processing and filtering data, 6th Module explains reordering and summarising the data. 7th Module explains how to combine data from multiple sources. Module 8 deals with creating data visualisations. Module 9 pertains

to creating Interactive Dashboard by using PivotTables. Module 10 demonstrates printing Worksheets, Charts and Visualisations.

Module-1: Significance of data in Social Sciences Module-2: Working with data and Excel tables Module-3: Data Calculations

Module-4: Managing Workbook appearance Module-5: Managing worksheet data Module-6: Reorder and summarize data

Module-7: Combine data from multiple sources Module-8: Creating Data Visualisations

Module-9: Creating Interactive Dashboard by using PivotTables Module-10: Printing Worksheets, Charts and Visualisations

Reading list

Using Microsoft Excel for Social Research, By Charlotte Brookfield · 2021 ISBN: 9781529753202, 1529753201

Publisher: SAGE Publications

Excel 2019 for Social Science Statistics: A Guide to Solving Practical Problems. By Thomas J. Quirk · 2021

ISBN: 9783030643331, 3030643336

Publisher: Springer International Publishing

Beginning Excel 2019 By Noreen Brown, Barbara Lave, & Julie Romey, Publisher: Open Oregon Educational Resources, freely available under CC BY-NC-SA licence at https://open.umn.edu/opentextbooks/textbooks/70

Data Visualization with Excel Dashboards and Reports By Dick Kusleika · 2021 ISBN: 9781119698739, 1119698731

Publisher: Wiley

Making Data Sexy: A Step-by-Step Visualization Guide for Microsoft Excel 2016 Windows. By Annie Cushing · 2019

ISBN: 9781733049108, 173304910X

Publisher: Pied Piper Interactive