Data Processing tools for business II

Code 470AA
Credits 6

Learning outcomes

Educational goals
This course is aimed to enhance knowledge and skills required for using IT productivity tools in business environment. Namely, it is meant:
- to develop the ability of interactive uses, with special regard to the ability of autonomous work;
- to bring to a knowledge of features and characteristics, good enough to:
o design and implement a feasible solution of a simple problem or a feasible automation of a simple procedure;
o in case of higher complexity, to effectively interact with probable suppliers of IT solutions, being able to give appropriate specifications and to verify functionalities and services.

Contents

Spreadsheets management systems, database management systems, Internet.
Features and functionalities for interactive use.
Free software vs proprietary software.
Query language for Databases.
Macros: features, use, recording, recall.
Elements of procedural programming.
Programming or modifying macros for spreadsheets.
Exemplifications in business environment.