Chandigarh University’s Passion to Profession through Advanced Credit Program offers a unique pathway for bright and inquisitive young minds to develop their career by enjoying their passion. This specialized certification program is offered to UG and PG students seeking admission to Chandigarh University. Besides pursuing their passion, the students will earn University credits while developing the primordial knowledge and skills for the program to which they are interested in taking admission. This program comprises three distinct levels, each tailored to provide students with a progressive and comprehensive learning experience.
Obtaining credits in specific courses implies that a student has exhibited proficiency in those subjects. Consequently, they might be exempted from retaking those courses or have the opportunity to progress to more advanced levels directly. This minimizes the required number of courses, enabling them to concentrate on other subjects or explore additional courses. Advanced earned credits streamline a student's academic path, potentially reducing the duration needed to finish their degree or program. It lessens the student's time and energy commitments, allowing them to allocate those resources to other subjects and dedicate more time to prepare for job placements.
Nil
S. No. |
Day |
Activity |
Duration |
---|---|---|---|
1 |
Monday |
Introduction and Live Interaction |
1 Hour 30 Mins |
2 |
Tuesday |
Flipped Classroom |
1 Hour 30 Mins |
3 |
Wednesday |
Live Interaction, Query Session |
1 Hour 30 Mins |
4 |
Thursday |
Assignment Allotment, Assignment Preparation and Submission |
3 hours |
5 |
Friday |
||
6 |
Saturday |
Live Hands-on Practice/ Case Study |
1 Hour 30 Mins |
Quiz |
|||
Self Study |
6 Hours |
||
Total Engagement Hours |
15 Hours |
In case any query please mail on acp@cumail.in
The Level 2 of Passion to Profession through Advanced Credit Program is focussed on inculcating global values in the aspirants.
The course will improve aspirant’s morale. The aspirants will be able to bring in right conduct in their behaviour. The said values and ethics training program will aim at improving the professionalism and the effectiveness of individuals.
The aspirant will be engaged in series of lessons based on value inculcation which will earn them a values certificate.
Developing universally recognized spiritual, compassionate and dynamic minds with positive and ethical thought process through global values instillation & certification.
Nil
Days |
Topic to be Covered (1.5 Hour per Day) |
---|---|
Day 1 |
Live interaction on course |
Day 2 |
Lecture Series start…. |
Day 3 |
Lecture Series cont.… |
Day 4 |
Lecture Series cont.… |
Day 5 |
Lecture Series end.… |
Day 6 |
Live interactions, Doubt Sessions and Feedback |
Day 7 |
MCQ-based Quiz |
In case any query please mail on acp@cumail.in
Spreadsheet software remains one of the most unique software used in workplaces across the world. This software will add a highly valuable asset to student’s employability portfolio. To elucidate, research concludes that digital skills lead to higher income which reflects an increase employment opportunity. In the fast pace technology era, digital skill jobs are growing much faster than non-digital jobs, completing this course will give a competitive advantage. Excel is a powerful program that has an extraordinarily broad range of features and capabilities. In this course student will learn the Essentials of Microsoft Excel which will build a strong Beginner to develop more Proficient skills in upcoming semesters.
Data Analysis using Microsoft Excel Program will give deep understanding of the Proficient Excel formulas and functions that transform Excel from a basic spreadsheet program into dynamic and powerful analytics tool. This program is designed through hands-on, contextual examples to regurgitate functions and formula syntax which will empower students with key skills to create and edit worksheets, implement formulas and functions, sort and filter detail data with tables and slicers.
LEVEL No. |
Course Code: |
TITLE |
L |
T |
P |
S |
C |
CH |
Course Type* |
|
---|---|---|---|---|---|---|---|---|---|---|
1 |
Data Analysis using Microsoft Excel - 1 |
0 |
- |
2 |
- |
1 |
15 |
ACP |
||
Course Objectives |
i) To communicate clear and concise message through your charts ii) To create dynamic reports by mastering one of the most popular tools like PivotTables. iii) To automate tedious and time-consuming tasks using cell formulas and functions in Excel iv) To develop automated dashboards, scrolling charts and dynamic formats. |
|||||||||
PRE-REQUISITE |
Basic Understanding of Statistics |
|||||||||
Course Outcome |
i) To organise data by applying specified formatting only when certain conditions are met |
|||||||||
ii) To examine accuracy and quality of data before applying any statistical tool |
||||||||||
iii) To summarize and analyze large dataset in excel |
||||||||||
iv) To design charts that clarify and provide the right canvas for analysis |
||||||||||
v) To develop a basic financial model in excel |
||||||||||
Course Contents |
Level 1 – Beginner: Excel for Beginners i) Basic Formatting: Introduction to Excel, Basic Excel Formatting ii) Print Options & Settings in Excel iii) Excel Shortcuts iv) Personal Finance Tracker with Date & Time Functions v) Working with Data: Conditional Formatting, Removing Duplicates, Sorting, Filtering Data vi) Conditional Logic: OR, AND, NOT etc, |
Days |
Topic to be Covered (1.5 Hour per Day) |
---|---|
Day 1 |
· Basic Formatting: Introduction to Excel, Basic Excel Formatting · Print Options & Settings in Excel |
Day 2 |
Excel Shortcuts |
Day 3 |
Personal Finance Tracker with Date & Time Functions (Part 1) |
Day 4 |
Personal Finance Tracker with Date & Time Functions (Part 2) |
Day 5 |
Working with Data: Conditional Formatting, Removing Duplicates, Sorting, Filtering Data |
Day 6 |
Conditional Logic: OR, AND, NOT etc. (Part 1) |
Day 7 |
Conditional Logic: OR, AND, NOT etc. (Part 1) |
Name |
Mobile |
|
---|---|---|
Dr. Nikhil Kaushik |
9896314170 |
nikhil.e11022@cumail.in |