37685 - COMPUTATIONAL TOOLS (M-Z)

Anno Accademico 2019/2020

  • Modalità didattica: Convenzionale - Lezioni in presenza
  • Campus: Bologna
  • Corso: Laurea in Business and economics/economia e gestione di impresa (cod. 8965)

Conoscenze e abilità da conseguire

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.

Contenuti

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

Testi/Bibliografia

  • 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

Metodi didattici

Lectures will be held mainly in computer room

Modalità di verifica e valutazione dell'apprendimento

  • 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

Strumenti a supporto della didattica

Personal Computer in Computer Room

Orario di ricevimento

Consulta il sito web di Damiano Marino Somenzi