COMPUTATIONAL TOOLS FOR MANAGEMENT

Academic year
2021/2022 Syllabus of previous years
Official course title
STRUMENTI COMPUTAZIONALI PER IL MANAGEMENT
Course code
ET2103 (AF:358460 AR:189865)
Modality
On campus classes
ECTS credits
6
Subdivision
Surnames A-Di
Degree level
Bachelor's Degree Programme
Educational sector code
MAT/09
Period
4th Term
Course year
1
Where
VENEZIA
Moodle
Go to Moodle page
The course, together with the other mathematics courses of the Business Administration and Management degree program, allows students to gain knowledge and understanding of the key mathematical concepts used in management disciplines and their application in real-world management decision problems.
The course objective is to provide students with a general understanding of financial mathematics and data management as well as skills in using spreadsheets and databases to solve basic operational problems that arise in the economic and business fields such as: the evaluation of investments/mortgages/loans, the analysis of data on sales/inventories/human resources/production, the support to operational decisions. Spreadsheets and databases will be used as information tools that enable structuring, processing and analyzing data, and communicating information.
At the end of the course students will have acquired basic knowledge of financial mathematics and will know how to use spreadsheets and databases, eg, to evaluate basic investments/mortgages/loans (hereafter referred to as basic investments and financial instruments), to analyze and process data on sales/inventories/human resources/production, to support operational decisions. Specifically, students should achieve the following:
1. Knowledge and understanding
- know the terminology and basic concepts of financial mathematics.
- understand the strengths and limitations of mathematical models and of software tools in supporting management decisions.
- know the basic principles of data management and, in particular, of relational database theory and queries.
2. Ability to apply knowledge and understanding
- understand the main aspects of contracts governing basic investments and financial instruments.
- know how to determine the values of different characteristics (eg, installments, interests, returns) of basic investments and financial instruments.
- know how to extract data of interest from a relational database.
3. Making judgements
- be able to critically assess under which circumstances basic investments and financial instruments may yield a good performance.
- be able to assess which data in a database are most valuable to support simple business decisions.
4. Communication
- know how to present, discuss and prove the mathematical correctness and the economic viability of basic investments and financial instruments.
- know how to interact with database designers and managers.
- know how to argue simple business decisions from the quantitative perspective by making use of spreadsheets or of the results of database queries.
5. (Lifelong) learning skills
- be able to critically consult reference books and online material in the fields of financial mathematics and data management to support decisions.
Being clear of OFA requirements.
Students should have knowledge of basic concepts introduced in the courses of MATHEMATICS - 1 and MATHEMATICS - 2.
Specifically, students should know: systems of linear equalities and inequalities,matrix algebra, interest rates, minima and maxima of functions.
Students should also have a basic knowledge of set theory.
1. The decision-making process:
- steps in a decision-making process and data-driven decision making
- defining objectives, identifying constraints, determining and validating solutions
- potential and limitations of mathematical models and the use of software tools to support management decisions
2. Making management decisions with spreadsheets:
- importing of data, basic mathematical functions and logical functions
- Excel’s main financial functions and their mathematical structure
- evaluation of investments/mortgages/loans
- data analysis with filters and pivot tables
3. Making management decisions with databases:
- concepts of data, information and knowledge
- reasons to collect and manage data and associated costs
- introduction to databases
- relational databases
- normal forms
- Microsoft Access
- interrogation of a Microsoft Access database
- query by example
- advanced queries
4. Case studies.
Notes, slides, exercises, videos, and other material necessary to follow lectures and to attain the intended learning outcomes are downloadable from the e-learning platform moodle.unive.it.

Additional readings
- A. Basso, P. Pianca, Introduzione alla matematica finanziaria, Cedam (students interested in financial mathematics)
- F. Borazzo, R. Candiotto, Applicazioni aziendali con Excel, Apogeo (students interested in business and management applications of Excel)
- any Excel and Access manual (students interested in deepening their knowledge of Excel and Access)
The assessment of the students' learning occurs in two phases: during the course and at the end of the course.
During the course, students are encouraged to self-assess their learning by answering the exercises and tests proposed on the e-learning platform.
At the end of the course students will have to take the final exam.
The exam consists of an oral/practical test that lasts about 45 minutes to verify that the students have acquired the concepts and are familiar with the software presented during classes.
In the final exam students are required to solve two financial or management problems (max 15 points for each problem) similar to the ones introduced during classes using spreadsheets and a database on a computer. Students will be asked to explain the methods that they have used for solving the problems.
For example, students may be asked:
- to explain the financial mathematics and data management concepts behind the solution methods they have used
- to justify the hypotheses that they assume to hold true
- to prove the correctness of the results obtained
- to discuss the economic effectiveness of the operations analyzed

Problems similar to ones proposed during the final exam can be found on the university e-learning platform.
Face-to-face classes and study material on the university e-learning platform moodle.unive.it. This material includes case studies that students are invited to solve. This material also includes the solutions (possibly presented through videos) of the case studies to allow students to compare their solutions with the ones proposed by the instructor or used in the real word.

During the course, the instructor also introduces and solves some case studies with the help of software packages.
In doing so he encourages thought and discussion about the considered cases. In particular, he
- stresses the systemic approach that he uses to tackle considered problems and the mathematical concepts that lie behind the possible solution methods
- discusses the inherent difficulties of modeling a real-world problem, such as data collection,
- shows how to use the results provided by the mathematical model, eg, to negotiate a loan in the light of typical characteristic of a contract
- presents situations in which software tools may fail to return a correct answer and explains how to react to these difficulties

1) Students should register for the course on the related page (Strumenti Computazionali per il Management/Computational Tools for Management) of the university e-learning platform moodle.unive.it

2) Accessibility, Disability and Inclusion
Accommodation and support services for students with disabilities and students with specific learning impairments

Ca’ Foscari abides by Italian Law (Law 17/1999; Law 170/2010) regarding support services and accommodation available to students with disabilities. This includes students with mobility, visual, hearing and other disabilities (Law 17/1999), and specific learning impairments (Law 170/2010). If you have a disability or impairment that requires accommodations (i.e., alternate testing, readers, note takers or interpreters) please contact the Disability and Accessibility Offices in Student Services: disabilita@unive.it.
written and oral
Definitive programme.
Last update of the programme: 24/02/2021