- Docente: Francesco Bergamaschi
- Credits: 3
- Language: English
- Teaching Mode: Traditional lectures
- Campus: Forli
- Corso: First cycle degree programme (L) in Economics and business (cod. 9202)
Learning outcomes
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.
Course contents
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.
Readings/Bibliography
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)Teaching methods
Lectures with slides and practical applications in laboratory.
Assessment methods
Written applied exam in laboratory and two open theory questions.
Teaching tools
Blackboard, slides, practical applications in laboratory.
Office hours
See the website of Francesco Bergamaschi