The course aims to provide students with the knowledge of the concepts and methods related to the knowledge of the network, the software programming and the ability to use and create tools for the realization of programs either stand-alone or within Microsoft Office applications with particular regard to the Excel package.

The program is structured as follows:

1. OFFICE AT ECDL ADVANCED LEVEL
Advanced usage of the platform Office (Word, PowerPoint, Excel and Access) with particular reference to instruments Excel and Access;
2. SQL LANGUAGE FOR DATABASE
Structure of the language. All Query types, select, append, edit, delete etc.;
3. INTRODUCTION TO PROGRAMMING
Macro in Excel and Access. Functional programming for objects;
4. THEORETICAL PROGRAMMING
Algorithms. Theoretical solution of problems. Semantics;
5. PROGRAMMING With VB, VBA, ASP.
Development environment, structure of a VB project, language elements, construction of sample programs "stand alone" and fill them in. Language extension with additional components. Access to external databases. The Excel and Word object model. Creation of applications within Excel and Word. Interface to Access databases;
6. INTEGRATION OF DATA PROCESSING SOFTWARE
Reading and writing to a Database from leading OFFICE products in an integrated manner, including the web part through ODBC.

Gestione Informatica dei Dati Aziendali.

• Knowledge and understanding: at the end of the course the students must have acquired knowledge and understanding of the issues developed in the classroom. In particular they must know and understand the functioning of the network, services and programming. Didactic working methods by which such results will be achieved will consist of: lectures, laboratory exercises and home and workshops.
• Knowledge and understanding: students must be able to apply the knowledge gained in an appropriate way and flexible to analyze, understand and solve problems both analytical method. Didactic working methods by which such results will be achieved will consist of: lectures, analysis and discussion on some topics, exercises and seminars.
• Autonomy of judgement: students must have the ability to hook into integrated schemes and Unitarian knowledge acquired during the course and to confront complex problems independently and with its own judgement. Didactic working methods by which such results will be achieved will consist of: lectures, analysis and discussion of some issues, in-depth exercises.
• Communication skills: students must acquire an ability to communicate clearly and effectively, thanks to a good mastery of the vocabulary related to the topics covered during the course. Didactic working methods by which such results will be achieved will consist of: lectures and elaborate display.
• Ability to learn: students must have developed good learning skills, which enable them to deepen the knowledge acquired during the course and to put them into practice by developing models. Didactic working methods by which such results will be achieved will consist of: lectures, laboratory exercises and home, work groups and workshops, elaborate production.

The teaching material prepared by the lecturer in addition to recommended textbooks (such as for instance slides, lecture notes, exercises, bibliography) and communications from the lecturer specific to the course can be found inside the Moodle platform › blended.uniurb.it

Course materials made available by the teacher can be found, together with other support activities, within the Moodle platform › http://blended.uniurb.it

Teaching

The course includes the use of different didactic methods:

• Lectures;
• Laboratory exercises at the Computing Center of Department DESP;
• Tutorials at home;
• Development of themes proposed by students;
• Educational seminars on particular topics of interest.

Attendance

None

Course books

Course materials made available by the teacher can be found, together with other support activities, within the Moodle platform › http://blended.uniurb.it

Assessment

The examination consists of a practical test in the laboratory in which shows the scores for each correct answer:

• The scores will be identified in the range 0-30;
• The test duration is two hours;
• Will be passed the test with a score > = 18;
• You can still support the oral to achieve eligibility for those students who have achieved a score > = 14 in the written test.

Disabilità e DSA

Le studentesse e gli studenti che hanno registrato la certificazione di disabilità o la certificazione di DSA presso l'Ufficio Inclusione e diritto allo studio, possono chiedere di utilizzare le mappe concettuali (per parole chiave) durante la prova di esame.

A tal fine, è necessario inviare le mappe, due settimane prima dell’appello di esame, alla o al docente del corso, che ne verificherà la coerenza con le indicazioni delle linee guida di ateneo e potrà chiederne la modifica.

Teaching

Downloadable material will be provided to the teacher's web page on http://blended.uniurb.it

Attendance

None

Course books

Course materials made available by the teacher can be found, together with other support activities, within the Moodle platform › http://blended.uniurb.it

Assessment

The examination consists of a practical test in the laboratory in which shows the scores for each correct answer:

• The scores will be identified in the range 0-30;
• The test duration is two hours;
• Will be passed the test with a score > = 18;
• You can still support the oral to achieve eligibility for those students who have achieved a score > = 14 in the written test.

Disabilità e DSA

Le studentesse e gli studenti che hanno registrato la certificazione di disabilità o la certificazione di DSA presso l'Ufficio Inclusione e diritto allo studio, possono chiedere di utilizzare le mappe concettuali (per parole chiave) durante la prova di esame.

A tal fine, è necessario inviare le mappe, due settimane prima dell’appello di esame, alla o al docente del corso, che ne verificherà la coerenza con le indicazioni delle linee guida di ateneo e potrà chiederne la modifica.

The student can request to sit the final exam in english.