Hello, if you have any need, please feel free to consult us, this is my wechat: wx91due
MSc in Management
Excel Tools Workshop
Course Code: 5A1D06 Academic Year: 2024-2025
1. COURSE SPECIFICATIONS*
|
TEACHING LANGUAGE |
MAIN DISCIPLINE |
ECTS CREDITS
|
CAMPUS |
LEVEL |
|
English |
Data science and analytics |
0 |
Lyon |
Beginner |
Program rules applyAccess to the final quiz will only be possible for students who have obtained at least 75% at each of the three levels of the e-learning course.
The Disability Unit
- Take into account your needs and ensure the best possible progress of your education and your integration student life
- Offer you specific arrangements and deal with any obstacles by setting up individualized educational monitoring (part-time work, absences for medical reasons, exam arrangements, etc.)
- Assist you in your administrative and pedagogical procedures and act as an interface with the various departments of the school
2. COURSE DESCRIPTION*
3. SUSTAINABLE DEVELOPMENT OBJECTIVE(S)
|
ERS Family & Competencies |
Level |
|
Non applicable |
00 Not applicable |
4. PROGRAMME COMPETENCY GOALS AND OBJECTIVES*
4.1. Programme Competency Goals
M-CG1.In-depth knowledge appropriation in management and connected disciplines
M-CG2.In-depth understanding of evolutions and challenges that companies and Society are facing, and ability to think critically about one's own development and future professional practice
M-CG3.Creative mindset and ability to make ideas happen
M-CG4.Responsible team management and leadership, with full consideration of diversity, equity and inclusion
4.2 Learning objectives of the program to which the course contributes the most*
LO2.Graduates are able to conduct, mesure and improve the economical, social and environnemental performance of an organization or a specialized activity area
5. LEARNING HOURS*
|
TYPE OF LEARNING HOURS |
DISTRIBUTION (HOURS) |
|
Synchronous Face-to-Face Learning |
65:00 |
|
Synchronous Distance Learning |
|
|
Asynchronous Learning |
|
|
Personal Work |
|
|
Group Work |
|
|
Exams |
1:00 |
6. LEARNING OBJECTIVES OF THE COURSE*
6.1 Academic and Professional Objectives
6.1.1. Concepts and theories to which participants are exposed during
6.1.2. Knowledge acquired during the course*
Use of Microsoft Excel
6.1.3. Competencies acquired during the course*
After this course, participants are able to
- Create tables and format them
- Automate calculations
- Create charts and visualizations
- Use advanced software tools
6.2. Experts met during the course
7. ASSESSMENT OF LEARNING OBJECTIVES*
|
Assessment
Method
|
Knowledge and Competencies |
Format |
Type |
Final
Weight(%)
|
|
Final Exam |
Create tables and format them
Automate calculations
Create charts and visualizations
Use advanced software tools
|
Individual |
Written |
|
|
Report/Assignment/Document (file)/Dissertation
|
Create tables and format them
Automate calculations
Create charts and visualizations
Use advanced software tools
|
Individual |
Written |
|
Description of Assessments
8. SEQUENCES DESCRIPTION, LEARNING ACTIVITIES AND ASSIGNMENTS*
|
SEQUENCE
NUMBER
|
PEDAGOGICAL
SEQUENCE
|
SEQUENCE DESCRIPTION |
|
1 |
eni Level 1 |
Presentation of Microsoft Excel
First calculations
Data presentation
Printing and layout
Tab management
|
|
2 |
eni Level 2
|
Creation of complex tables
Graphics
Data lists
Pivot tables
|
|
3 |
eni Level 3 |
lmprove your efficiency
Advanced calculation functions
Solver
Scenario Manager
Security concerns
Ribbon management
|