ID:
511158
Duration (hours):
30
CFU:
3
SSD:
SISTEMI DI ELABORAZIONE DELLE INFORMAZIONI
Year:
2025
Overview
Date/time interval
Primo Semestre (22/09/2025 - 19/12/2025)
Syllabus
Course Objectives
The goal is to focus on using MS Excel, a well-known spreadsheet software, starting from the basics and delving into aspects related to mathematics, finance, and data analysis.
Knowledge and Understanding:
Knowing the functions of Excel, remembering formulas and commands, understanding how to use data for advanced analysis.
Applied Knowledge and Understanding:
Applying formulas for complex calculations, being able to perform data analysis using pivot tables and charts.
Judgment Autonomy:
Being able to analyze data to identify trends and anomalies, evaluating the accuracy of entered data, and critiquing data collection methods to improve them.
Learning Ability:
Being able to work using Excel, adapting actions based on new requirements or tools, self-assessing skills, and identifying areas for improvement.
Knowledge and Understanding:
Knowing the functions of Excel, remembering formulas and commands, understanding how to use data for advanced analysis.
Applied Knowledge and Understanding:
Applying formulas for complex calculations, being able to perform data analysis using pivot tables and charts.
Judgment Autonomy:
Being able to analyze data to identify trends and anomalies, evaluating the accuracy of entered data, and critiquing data collection methods to improve them.
Learning Ability:
Being able to work using Excel, adapting actions based on new requirements or tools, self-assessing skills, and identifying areas for improvement.
Course Prerequisites
Basic computer skills.
Teaching Methods
During the lessons, we will explore the features and functionalities of the reference software. For this purpose, it is necessary to carry out special example exercises. Others are available in the e-learning platform.
It is advisable to bring a personal computer or tablet adequately equipped to replicate the actions performed during the class.
Assessment Methods
The exam is graded on a scale of thirty. No exemptions related to possessing ICT certifications are allowed.
Computer or tablet connected to the Internet is necessary. Using the Questbase platform, a multiple-choice questionnaire will be implemented. Registered exam participants will receive an email with specific instructions. Students will have a web address and access password. Questions and answers are automatically managed by the system. It is a website, and as such, it operates. Test management, transitioning between questions, and vertical scrolling are at the discretion of the student. Questions will be randomly drawn for each student from a predefined pool of 30 questions. Time available: 38 minutes. Each question always has only one correct answer. 1 point is awarded for each correct answer, 0 for all other cases. Answering is not mandatory. No penalties apply. During the test, the use of other electronic devices and supporting materials is not allowed. Results are based on test submission. Correction and evaluation are immediate, a process not otherwise possible without computer assistance. No installation is required by students. Afterward, the browser can be closed, and the session abandoned. Press the ‘Submit’ button at the bottom of the page to transmit answers and view results. If time does not allow submission, the test will still be considered valid and evaluated by the system based on progress up to that point
Texts
Teacher has made available handouts and video recordings of training activities already provided. No specific reference texts are recommended. Everyone can use additional materials available online, considering the extensive documentation already produced, especially on the internet.
Contents
The program is the same for all students, whether attending or not.
COURSE PROGRAM:
Introduction to Microsoft Excel (2 hours)
What is a spreadsheet
General Excel interface: workspace areas, rows, columns, cells, menus, scroll bars, and zoom
Excel Fundamentals (6 hours)
Creating and formatting worksheets
Data entry and modification
Basic formula usage (addition, subtraction, multiplication, division)
Cell and table management
Advanced Formulas and Functions (10 hours)
External references and data selection
Named ranges usage
Creating complex formulas
Dynamic functions (auto lists, sorting, transposing, filtered lists)
Conditional Formatting and Data Visualization (6 hours)
Creating conditional formatting rules
Using heat maps, icons, and data bars
Applying conditional formatting to large areas
Pivot Tables and Data Analysis (6 hours)
Creating and managing pivot tables
Data analysis through pivot tables
Using filters and grouping
Automation with Macros (4 hours)
Introduction to macros
Recording and editing macros
Executing macros to automate repetitive tasks
Course Language
Italian
More information
The course “Conoscenze Informatiche” for Economics consists of 34 hours distributed during the first semester of the academic year 2024-2025, as indicated in the e-learning platform’s calendar.
The MS Office 365 suite is available for free to students at the web address Microsoft Office for Education. There’s no restriction against using older versions of the product, especially if they are already installed on slightly older devices. At least until any significant discrepancies that might affect proper learning are identified.
The instructor is available for virtual office hours via video conferencing, arranged through email (prof.sergio.moriani@universitadipavia.it).
Students, not enrolled in the first year of the course”, who have not yet taken the Informatics Knowledge exam can consider an alternative mode. For relevant information, please refer to the webpage at the following address https://elearning.unipv.it/course/view.php?id=2618
Degrees
Degrees (3)
BUSINESS ADMINISTRATION AND GOVERNANCE
Bachelor’s Degree
3 years
BUSINESS MANAGEMENT
Bachelor’s Degree
3 years
ECONOMICS
Bachelor’s Degree
3 years
No Results Found
People
People
Teaching staff
No Results Found