37685 - COMPUTATIONAL TOOLS

Anno Accademico 2018/2019

  • Modalità didattica: Convenzionale - Lezioni in presenza
  • Campus: Forli
  • Corso: Laurea in Economia e commercio (cod. 9202)

Conoscenze e abilità da conseguire

This course provides students with basic information technology notions, including: the use of a computer connected to the internet, spreadsheets, the Web and firm information systems. Considering both proprietary and open source technologies. At the end of the course, students are expected to have a basic skill for: (a) using personal computers and spreadsheets; (b) using the Web, search engines and communication mechanisms; (c) using firm information systems.

Contenuti

Important information: this course will take as given that students have previously attended the crash course Computational Tools, in which the basics of Excel spreadsheets (functions, pivoting, vlookup, primary keys) are introduced.

Internet and networks.

MS Access tables, queries and macros.

MS Excel Power Pivot advanced techniques.

Proprietary and open source technologies.

Overview of firms IT systems.

Testi/Bibliografia

Turban, Volonino, Wood / Information Technology for Management - International students version, Wiley, 2015 (10th edition).

Collie, Singh / Power Pivot and Power BI: The Excel User's Guide to DAX, Power Query, Power BI & Power Pivot in Excel 2010-2016, 2016 (2nd edition)

Metodi didattici

Lectures with slides and practical applications in laboratory.

Modalità di verifica e valutazione dell'apprendimento

Written applied exam in laboratory and two open theory questions.

Strumenti a supporto della didattica

Blackboard, slides, practical applications in laboratory.

Orario di ricevimento

Consulta il sito web di Francesco Bergamaschi