37685 - Computational Tools (M-Z)

Learning outcomes

At the end of the Teaching Activities related to the course “Computational Tools”, students will be familiar with programming techniques, plus, they should have gathered a knowledge on basic instructive concepts that would help them accomplish an optimal research on resources like the internet (and other databases), develop an awareness to select, deploy and elaborate some bibliographical data, statistics, balance sheets, market data, benchmark, outcomes of working groups operating in the corporate/business fields, develop the ability to set-up and structure the information coming from financial support, from the management and from other different professions. This course is intended to complement the analytical skills of the student when it comes to: - perform a research on the internet, on scientific databases, identify data, select it, group them, assess it. - compute the data with the purpose of drafting summaries, documentation and other files that may be useful for the working group. - conducting simple numerical analysis of dynamic economic and accounting models on a spreadsheet - compute indicators and indexes and work them from a graphical standpoint, rely on the use of alternative models e display all outcomes, results and strategies knowing how to assemble all this information. - Evaluate and assess all the different options to reach a full automation of the firm.

Course contents

Acquire knowledge and competency to:

Use data as source of information and knowledge:

• Identify data sources on the Web
• Design and implement worksheets for data management
• Analysis of worksheets to ``provide'' information
• Design and implement small relational databases
• Extract from databases data and information
• Advanced techniques of data analysis

Acquire the operational skills aiming to work in complex professional environments

Readings/Bibliography

• Teaching material will be deployed weekly on Insegnamenti on Line, university repository site (ioL.unibo.it). The main goal of the teaching material is to write down theory, example and exercises shown and discussed in the lectures and labs, other than to offer more examples and exercise to practice
• Any book concerning with the advanced use of the Office worksheets and databases
• ECDL certification handbooks are suitable to acquire basic skills for an effective attendance of lessons and labs

Teaching methods

Lectures will be held mainly in computer room

Assessment methods

• Written (multiple choice and fill in the gap) and
  practical (operating with the applications)
• The assessment concern with abilities to analyse requisites,
  design and realise a coherent data model, other than to set
  up data analysis aiming to extract meaningful information
  for the business
• The exam will be held Online, based on Esami Online and Zoom platforms. Requirements: computer device equipped with webcam and microphone, Microsoft Excel and Access for Windows - alternatively - Microsoft Excel for Mac and LibreOffice Base for Mac
  

Teaching tools

Personal Computer in Computer Room

Office hours

See the website of Damiano Marino Somenzi