HOW TO DEVELOP AND MANAGE A PROJECT USING EXCEL
Syllabus
EN
IT
Learning Objectives
The course will provide students with a fundamental understanding of Excel, with a specific focus on its application for managing company data. It is designed for individuals looking to explore Excel as a tool for data management.
The curriculum will delve into various aspects of data processing, including data cleaning and storage. Additionally, it will cover the creation of informative graphs to visualize available data points. Furthermore, the course will briefly introduce tables and pivot tables, a powerful tool for consolidating and summarizing information.
Learning Outcomes
The course contributes to the achievement of the objectives of the degree course, in line with the professional profiles and employment outlets envisaged, providing students with notions useful for an in-depth and critical understanding of Microsoft Excel environment, including:
Course objectives are articulated for each student to:
Introduction to Excel: Start from the basics, ensuring that students understand the Excel interface, navigation, and essential terminology.
Creating and Formatting Spreadsheets: Learn how to create, modify, and format spreadsheets. From entering data to adjusting fonts and cell styles, to create polished, organized documents.
Formulas and Functions: Excel's true power lies in its ability to perform calculations and automate tasks. Showing students how to use formulas for simple calculations and data analysis.
Data Visualization: Transform dull data into compelling visuals. Discover how to create charts and graphs that convey a message effectively and make data analysis more insightful.
Data Management: Sorting and filtering data, creating tables, and managing large datasets.
KNOWLEDGE AND UNDERSTANDING:
The course provides tools to understand the use of Excel, its functions, and formulas. By the end of the lectures, students will consolidate their knowledge of the fundamental concepts of using the Excel program in data analysis and their ability to independently apply the acquired knowledge, leveraging advanced features of the software such as Pivot Tables and Excel's statistical functions for data analysis and interpretation.
APPLYING KNOWLEDGE AND UNDERSTANDING: The course provides tools to start to learn to use Microsoft Excel in data analisys. Following the lectures, students will consolidate their knowledge of the fundamental concepts of data analisys and their ability to independently apply the knowledge they have acquired to the srgument
MAKING JUDGEMENTS: the ability to draw independent development and analisys about raw transformation of raw data in information is stimulated by highlighting the connections between the concepts developed during the course, the notions acquired in previous courses and the links between these notions and the major contemporary economic problems.
COMMUNICATION SKILLS: By attending the course and interacting with the lecturers, students will develop their communication skills and their ability to organise and share articulate reasoning, combining notions of data analisys by using Excel
LEARNING SKILLS: Through the study of Microsoft Excel and Data Analisys the students will acquire the ability to independently analyse and investigate specific topics related to the course contents.
The curriculum will delve into various aspects of data processing, including data cleaning and storage. Additionally, it will cover the creation of informative graphs to visualize available data points. Furthermore, the course will briefly introduce tables and pivot tables, a powerful tool for consolidating and summarizing information.
Learning Outcomes
The course contributes to the achievement of the objectives of the degree course, in line with the professional profiles and employment outlets envisaged, providing students with notions useful for an in-depth and critical understanding of Microsoft Excel environment, including:
Course objectives are articulated for each student to:
Introduction to Excel: Start from the basics, ensuring that students understand the Excel interface, navigation, and essential terminology.
Creating and Formatting Spreadsheets: Learn how to create, modify, and format spreadsheets. From entering data to adjusting fonts and cell styles, to create polished, organized documents.
Formulas and Functions: Excel's true power lies in its ability to perform calculations and automate tasks. Showing students how to use formulas for simple calculations and data analysis.
Data Visualization: Transform dull data into compelling visuals. Discover how to create charts and graphs that convey a message effectively and make data analysis more insightful.
Data Management: Sorting and filtering data, creating tables, and managing large datasets.
KNOWLEDGE AND UNDERSTANDING:
The course provides tools to understand the use of Excel, its functions, and formulas. By the end of the lectures, students will consolidate their knowledge of the fundamental concepts of using the Excel program in data analysis and their ability to independently apply the acquired knowledge, leveraging advanced features of the software such as Pivot Tables and Excel's statistical functions for data analysis and interpretation.
APPLYING KNOWLEDGE AND UNDERSTANDING: The course provides tools to start to learn to use Microsoft Excel in data analisys. Following the lectures, students will consolidate their knowledge of the fundamental concepts of data analisys and their ability to independently apply the knowledge they have acquired to the srgument
MAKING JUDGEMENTS: the ability to draw independent development and analisys about raw transformation of raw data in information is stimulated by highlighting the connections between the concepts developed during the course, the notions acquired in previous courses and the links between these notions and the major contemporary economic problems.
COMMUNICATION SKILLS: By attending the course and interacting with the lecturers, students will develop their communication skills and their ability to organise and share articulate reasoning, combining notions of data analisys by using Excel
LEARNING SKILLS: Through the study of Microsoft Excel and Data Analisys the students will acquire the ability to independently analyse and investigate specific topics related to the course contents.
Prerequisites
No formal pre-requisites
Program
The course program is divided into interrelated parts as follows:
Topics
1. Getting Started with Excel
2. Data Entry, Data Editing, and Number Formatting
3. Data Formatting
4. Data Cleaning
5. Interaction between Excel, Word, and PowerPoint
6. Working with Cells and Ranges in Excel
7. Managing Worksheets
8. Introduction to Excel Tables
9. Auto-fill and Custom Lists
10. Excel Formula Basics
11. Logical Formulas in Excel
12. Math Formulas in Excel
13. Lookup and Reference Formulas in Excel
14. Statistical Formulas in Excel
15. Text Formulas in Excel
16. Date and Time Formulas in Excel
17. Introduction to Excel Charting
18. Overview of Excel Pivot Tables
19. Final Recap
During each lecture, the lecturer presents the planned content using PowerPoint presentations and encourages students to engage in critical reflection and dialogue.
Topics
1. Getting Started with Excel
2. Data Entry, Data Editing, and Number Formatting
3. Data Formatting
4. Data Cleaning
5. Interaction between Excel, Word, and PowerPoint
6. Working with Cells and Ranges in Excel
7. Managing Worksheets
8. Introduction to Excel Tables
9. Auto-fill and Custom Lists
10. Excel Formula Basics
11. Logical Formulas in Excel
12. Math Formulas in Excel
13. Lookup and Reference Formulas in Excel
14. Statistical Formulas in Excel
15. Text Formulas in Excel
16. Date and Time Formulas in Excel
17. Introduction to Excel Charting
18. Overview of Excel Pivot Tables
19. Final Recap
During each lecture, the lecturer presents the planned content using PowerPoint presentations and encourages students to engage in critical reflection and dialogue.
Books
Attending students:
1. Slides of the course.
2. Reading material distributed by the lecturers
Non attending students (below 80% attendance): will study on:
Microsoft Excel Step by Step (Office 2021 and Microsoft 365) (English Edition) Joan Lambert, Curtis Frye Microsoft Pr (6 gennaio 2022) 0137564279
1. Slides of the course.
2. Reading material distributed by the lecturers
Non attending students (below 80% attendance): will study on:
Microsoft Excel Step by Step (Office 2021 and Microsoft 365) (English Edition) Joan Lambert, Curtis Frye Microsoft Pr (6 gennaio 2022) 0137564279
Bibliography
Microsoft Excel Step by Step (Office 2021 and Microsoft 365) (English Edition) Joan Lambert, Curtis Frye Microsoft Pr (6 gennaio 2022) 0137564279
Teaching methods
The course combines different teaching methods: lectures; seminars; student presentations. The lectures will provide the students with the necessary information and reading guidelines on the phenomena under study, while seminars will see students critically engage with this knowledge and encourage/participate in class debates. Students are expected to attend each class, to come to class prepared and to participate in discussions.
Students will agree the topic of their presentations with the lecturers and give assessed Power-point presentations in which they will critically evaluate the content and argument of a chosen topic and introduce related questions for the class discussion.
Students will agree the topic of their presentations with the lecturers and give assessed Power-point presentations in which they will critically evaluate the content and argument of a chosen topic and introduce related questions for the class discussion.
Exam Rules
Course assessment
The (default )verification of learning takes place exclusively through a final examination which consists of an individual or group presentation as discussed below. The objective of the final examination is to verify the achievement of the course learning outcome. In particular, the examination assesses the student's overall preparation, ability to integrate knowledge of the different parts of the programme, consequentiality of reasoning, analytical ability and autonomy of judgement. In addition, ownership of language and clarity of exposition are assessed, in adherence with the Dublin descriptors.
Minimum score for passing the written test 18 out of 30.
After listening to the presentations, the lecturers communicate the results to the students registered for the examination via the Delphi system.
Students may take the examination on all available dates. there is no roll-call jump.
The examination will be assessed according to the following criteria:
• FAIL: important deficiencies and/or inaccuracies in the knowledge and understanding of the topics; limited ability to analyse and synthesise, frequent generalisations and limited critical and judgemental skills, the topics are set out inconsistently and with inappropriate language;
• 18-20: Barely sufficient knowledge and understanding of the topics with possible generalisations and imperfections; sufficient capacity for analysis, synthesis and autonomy of judgement, the topics are frequently exposed in an incoherent manner and with inappropriate/technical language;
• 21-23: Routine knowledge and understanding of topics; ability to analyse and synthesise correctly with sufficiently coherent logical argumentation and appropriate/technical language
• 24-26: Fair knowledge and understanding of the topics; Good analytical and synthetic skills with arguments expressed in a rigorous manner but with language that is not always appropriate/technical.
• 27-29: Comprehensive knowledge and understanding of the topics; considerable capacity for analysis and synthesis. Good autonomy of judgement. Arguments presented in a rigorous manner and with appropriate/technical language
• 30-30L: Excellent level of knowledge and thorough understanding of topics. Excellent analytical and synthetic skills and independent judgement. Arguments expressed in an original manner and with appropriate technical language.
Course evaluation for attending students:
• In-class presentations (100 %)
• Rules for the presentation: Students can work on their presentations alone or in groups. A group may comprise 2 to 4 students. The students agree on the topic of the presentations with the lecturers, individually or in groups. Each student/group prepares its presentation and emails it to the lecturers at least one day in advance of the day scheduled for class discussion. In the case of group presentations, each group member receives the same final grade.
Course evaluation for non-attending students:
• Final oral exam (100%).
• Rules for the oral exam: the final exam consists of an approximately 20-minute oral test with questions on one of the textbooks indicated above,
The (default )verification of learning takes place exclusively through a final examination which consists of an individual or group presentation as discussed below. The objective of the final examination is to verify the achievement of the course learning outcome. In particular, the examination assesses the student's overall preparation, ability to integrate knowledge of the different parts of the programme, consequentiality of reasoning, analytical ability and autonomy of judgement. In addition, ownership of language and clarity of exposition are assessed, in adherence with the Dublin descriptors.
Minimum score for passing the written test 18 out of 30.
After listening to the presentations, the lecturers communicate the results to the students registered for the examination via the Delphi system.
Students may take the examination on all available dates. there is no roll-call jump.
The examination will be assessed according to the following criteria:
• FAIL: important deficiencies and/or inaccuracies in the knowledge and understanding of the topics; limited ability to analyse and synthesise, frequent generalisations and limited critical and judgemental skills, the topics are set out inconsistently and with inappropriate language;
• 18-20: Barely sufficient knowledge and understanding of the topics with possible generalisations and imperfections; sufficient capacity for analysis, synthesis and autonomy of judgement, the topics are frequently exposed in an incoherent manner and with inappropriate/technical language;
• 21-23: Routine knowledge and understanding of topics; ability to analyse and synthesise correctly with sufficiently coherent logical argumentation and appropriate/technical language
• 24-26: Fair knowledge and understanding of the topics; Good analytical and synthetic skills with arguments expressed in a rigorous manner but with language that is not always appropriate/technical.
• 27-29: Comprehensive knowledge and understanding of the topics; considerable capacity for analysis and synthesis. Good autonomy of judgement. Arguments presented in a rigorous manner and with appropriate/technical language
• 30-30L: Excellent level of knowledge and thorough understanding of topics. Excellent analytical and synthetic skills and independent judgement. Arguments expressed in an original manner and with appropriate technical language.
Course evaluation for attending students:
• In-class presentations (100 %)
• Rules for the presentation: Students can work on their presentations alone or in groups. A group may comprise 2 to 4 students. The students agree on the topic of the presentations with the lecturers, individually or in groups. Each student/group prepares its presentation and emails it to the lecturers at least one day in advance of the day scheduled for class discussion. In the case of group presentations, each group member receives the same final grade.
Course evaluation for non-attending students:
• Final oral exam (100%).
• Rules for the oral exam: the final exam consists of an approximately 20-minute oral test with questions on one of the textbooks indicated above,