डॉ. बी. आर. अम्बेडकर विश्वविद्यालय दिल्ली 
| Course Type | Course Code | No. Of Credits |
|---|---|---|
| Discipline Elective | NA | 4 |
Course coordinator and team: Dr Ramesh C Sharma (C)
- How does the course link with the vision of AUD?
Dr. B. R. Ambedkar University Delhi aspires to be a premier, globally recognized institution of higher learning with a focus on Liberal Arts, Humanities and Social Sciences. The University is committed to the promotion of education, research and extension work, combining academic excellence with access, equity and social justice. This course will create citizen who can process data and information effectively so that they can work effectively towards promoting access, equity and equality by taking appropriate and timely data driven decisions.
- How does the course link with the specific programme(s) where it is being offered?
The programmes and courses offered by SGA like BA in Global Studies, BA in Sustainable Urbanism, MA Urban Studies and MA Global Studies prepares students who have to observe, collect and process data. This course enables students to create databases in the form of spreadsheets, use formula to analyse the data and present it using visualisations.
- Does the course connect to, build on or overlap with any other courses offered in AUD?
Currently the School is not offering a course in Microsoft Excel. The course may connect with most of courses in AUD because learning to integrate spreadsheet skills in education has implications for effective mathematical and computations skills.
- Specific requirements on the part of students who can be admitted to this course:
(Pre-requisites; prior knowledge level; any others – please specify)
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.
- No. of students to be admitted (with justification if lower than usual cohort size is proposed):
Usual cohort size
- Course scheduling (semester; semester-long/half-semester course; workshop mode; seminar mode; any other – please specify):
Semester mode
- Course Details:
a. Rationale:
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.
- Summary:
Learning MS-Excel would be an investment in personal and professional life. This course is designed for anyone interested in developing numerical skills or dealing with numbers. The course teaches how to store and analyse the numerical data. This
course would enhance the employability of students as they would be able to organise data in a meaningful way, perform basic and advanced calculations and mathematical functions, do forecasting, and present the data in the form of graphs and charts etc. In this course, the students will have hands-on training on a range of formula and
functions supported by MS-Excel software. This training will enable students to understand the social and financial implications of data processing. The students would develop a foundational understanding of business data analysis.
- Objectives:
- Explaining Excel fundamentals.
- Carrying out data entry and editing using various formats.
- Write arithmetic formulas, including precedence of operators and the proper use of brackets
- Performing calculations using formulas and functions.
- How to format and optimize spreadsheets.
- How to manage spreadsheets using Filter and sort table data capabilities.
- Previewing and printing spreadsheets and charts.
- Effective data visualization using basic charts.
- Expected 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
- Skills the students will develop
- Creating Excel Spreadsheets
- Formatting Excel Spreadsheets
- Using Basic Formulas in Excel Spreadsheets
- Creating Charts and Graphs
- Creating Pivot Tables
- Creating data visualisations
- Overall structure (course organisation; rationale of organisation; brief module outlines):
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.
|
Topic / Module |
Duration |
|
Module-1: Set up a workbook Module-2: Working with data and Excel tables |
1 week |
|
Module-3: Data Calculations Module-4: Managing Workbook appearance |
3 weeks |
|
Module-5: Managing worksheet data Module-6: Reorder and summarize data Module-7: Combine data from multiple sources |
3 weeks |
|
Module-8: Creating Data Visualisations Module-9: Creating Interactive Dashboard by using PivotTables |
4 weeks |
|
Module-10: Printing Worksheets, Charts and Visualisations |
1 week |
Course contents detailed in (a) week-wise format (preferable), or (b) module-wise format:
(b) (i) Module-wise Format with following details for each module:
|
Week |
Plan/ Theme/ Topic |
Objectives |
Core Reading (with no. of pages) |
Additional Suggested Readings |
Assessment (weights, modes, scheduling) |
|
1 |
Module-1: Set up a workbook
Module-2: Working with data and Excel tables |
Upon completion of these modules, the students would be able to:
|
BY-NC-SA licence at https://open.umn.edu/opentextbook s/textbooks/70
|
Publisher: Jeevandeep Prakashan Pvt Ltd |
Refer to next section for the course assessment strategy |
|
2, 3 & 4 |
Module-3: Data Calculations |
Upon completion of these modules, the students would be able to: |
(1) Beginning Excel 2019 By Noreen Brown, Barbara Lave, & Julie |
library/view/excel-2013- |
|
|
|
Module-4: Managing Workbook appearance |
|
Romey, Publisher: Open Oregon Educational Resources, freely available under CC BY-NC-SA licence at https://open.umn.edu/opentextbooks/t extbooks/70 (2) Beginning Excel 2019 by Authors: Noreen Brown; Barbara Lave; Hallie Puncochar; Julie Romey; Mary Schatz; Art Schneider; and Diane Shingledecker, freely available under CC BY licence at https://openoregon.pressbooks.pub/b eginningexcel19/ |
the/9781449359492/ch0 1.html
Publisher: Jeevandeep Prakashan Pvt Ltd |
|
|
5, 6 & 7 |
Module-5: Managing worksheet data
Module-6: Reorder and summarize data
Module-7: Combine data from multiple sources |
Upon completion of these modules, the students would be able to:
|
|
817744235X, |
|
|
|
|
|
Publisher: Jeevandeep Prakashan Pvt Ltd |
|
|
|
8, 9, 10 & 11 |
Module-8: Creating Data Visualisations Module-9: Creating Interactive Dashboard by using PivotTables |
Upon completion of these modules, the students would be able to:
|
Data Visualization with Excel Dashboards and Reports By Dick Kusleika · 2021 ISBN: 9781119698739, 1119698731 Publisher: Wiley |
Data at Work: Best Practices for Creating Effective Charts and Information Graphics in Microsoft Excel. By Jorge Camões · 2016 ISBN: 9780134268781, 0134268784 Publisher: Pearson Education |
|
|
|
|
|
|
|
|
|
12 |
Module-10: Printing Worksheets, Charts and Visualisations |
Upon completion of these modules, the students would be able to:
|
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 |
Analyzing and Visualizing Data with Microsoft Excel. By Chris Sorensen · 2018 ISBN: 9781509308101, 1509308105 Publisher: Pearson Education |
|
- Assessment structure (modes and frequency of assessments)
The course will have three types of assessment situations.
-
- First assignments: Students submit practical assignments based on data processing using MS Excel and data visualisation at different points during the term. Assignment 1 will be from Module 1 to 5. [Total 30%]
- Mid-Term Examination: It will be from Module 6 to 10. [Total 30%]
- Term-end examination: Covering the entire course syllabus, focusing on the theoretical and practical aspects of a spreadsheet program. [40%]