Scienze della Comunicazione | GENERAL INFORMATION TECHNOLOGY

cod. 0312200009

GENERAL INFORMATION TECHNOLOGY

	0312200009
	DIPARTIMENTO DI SCIENZE POLITICHE, SOCIALI E DELLA COMUNICAZIONE

	COMMUNICATION SCIENCES
	2014/2015

CURRICULUM COMUNICAZIONE D'IMPRESA E COMUNICAZIONE PUBBLICA

	OBBLIGATORIO
	YEAR OF COURSE 1
	YEAR OF DIDACTIC SYSTEM 2011
	ANNUALE

TEACHING UNITS

	SSD	CFU	HOURS	ACTIVITY	TYPE OF ACTIVITY
	INF/01	9	60	LESSONS	BASIC COMPULSORY SUBJECTS

	Objectives
	THE AIM OF THE COURSE IS TO GIVE AN INTRODUCTION TO CONCEPTS ("KNOWING") AND BASIC TECHNIQUES ("KNOW HOW") OF THE INFORMATION AND COMMUNICATION TECHNOLOGIES (ICT), WHICH ARE EDUCATIONAL AND WHICH MAY BE USEFUL TO THE STUDENT FOR HIS FUTURE WORK. AT THE END OF THE COURSE THE STUDENT WILL KNOW THE BASIC CONCEPTS OF INFORMATION TECHNOLOGY (ICT, MULTIMEDIA, OPERATING SYSTEMS, NETWORKS, ALGORITHMICS, PROGRAMMING, DATABASES) AND WILL BE ABLE TO PLAN AND USE A RELATIONAL DBMS - QUERY A RELATIONAL DBMS USING THE LANGUAGE SQL - PROGRAMMING (SO BASIC) A COMPUTER WITH A HIGH-LEVEL LANGUAGE. PARTICULAR EMPHASIS IS GIVEN TO THE APPEARANCE APPLICATION, WHICH IS A FUNDAMENTAL PART OF THE COURSE AND THE FINAL EVALUATION. THE RELATIONAL DBMS ARE PRESENT IN VIRTUALLY ALL APPLICATIONS, THEY ARE ALSO INCREASINGLY AT THE BASE OF WEB APPLICATIONS. THE SQL LANGUAGE IS A UNIVERSAL LANGUAGE THAT, ONCE LEARNED, CAN BE USED REGARDLESS OF THE DBMS AND WHATEVER PART OF THE WORLD IN WHICH YOU WORK. THE CHOSEN PROGRAMMING LANGUAGE IS PASCAL. THIS IS FOR A VARIETY OF REASONS, AND ONE OF THE MAIN ITS RIGOROUS APPROACH TO THE RULES OF GOOD PROGRAMMING AND ITS CONTEMPORARY SIMPLICITY OF LEARNING THAT ALLOWS THE TEACHER TO INTRODUCE THE PROGRAM WITH A SMALL NUMBER OF HOURS AVAILABLE. THIS CHOICE STILL ALLOWS THE STUDENT TO THE FUNDAMENTALS OF PROGRAMMING, WHICH, AS IS WELL KNOWN, ARE INDEPENDENT OF THE LANGUAGE USED. THESE CONCEPTS ARE THEN USED DIRECTLY IN OTHER LANGUAGES MORE TECHNICAL (C, JAVA, ETC..), WHICH CAN BE LEARNED AT A LATER DATE ALREADY STARTING FROM A BASE OF KNOWLEDGE THAT WILL FACILITATE THIS LEARNING .. ALL THIS IS ACCOMPANIED BY THE INTRODUCTION OF THE BASIC CONCEPTS OF ALGORITHMICS.

THE AIM OF THE COURSE IS TO GIVE AN INTRODUCTION TO CONCEPTS ("KNOWING") AND BASIC TECHNIQUES ("KNOW HOW") OF THE INFORMATION AND COMMUNICATION TECHNOLOGIES (ICT), WHICH ARE EDUCATIONAL AND WHICH MAY BE USEFUL TO THE STUDENT FOR HIS FUTURE WORK.
AT THE END OF THE COURSE THE STUDENT WILL KNOW THE BASIC CONCEPTS OF INFORMATION TECHNOLOGY (ICT, MULTIMEDIA, OPERATING SYSTEMS, NETWORKS, ALGORITHMICS, PROGRAMMING, DATABASES) AND WILL BE ABLE TO PLAN AND USE A RELATIONAL DBMS - QUERY A RELATIONAL DBMS USING THE LANGUAGE SQL - PROGRAMMING (SO BASIC) A COMPUTER WITH A HIGH-LEVEL LANGUAGE.
PARTICULAR EMPHASIS IS GIVEN TO THE APPEARANCE APPLICATION, WHICH IS A FUNDAMENTAL PART OF THE COURSE AND THE FINAL EVALUATION.

THE RELATIONAL DBMS ARE PRESENT IN VIRTUALLY ALL APPLICATIONS, THEY ARE ALSO INCREASINGLY AT THE BASE OF WEB APPLICATIONS. THE SQL LANGUAGE IS A UNIVERSAL LANGUAGE THAT, ONCE LEARNED, CAN BE USED REGARDLESS OF THE DBMS AND WHATEVER PART OF THE WORLD IN WHICH YOU WORK.

THE CHOSEN PROGRAMMING LANGUAGE IS PASCAL. THIS IS FOR A VARIETY OF REASONS, AND ONE OF THE MAIN ITS RIGOROUS APPROACH TO THE RULES OF GOOD PROGRAMMING AND ITS CONTEMPORARY SIMPLICITY OF LEARNING THAT ALLOWS THE TEACHER TO INTRODUCE THE PROGRAM WITH A SMALL NUMBER OF HOURS AVAILABLE. THIS CHOICE STILL ALLOWS THE STUDENT TO THE FUNDAMENTALS OF PROGRAMMING, WHICH, AS IS WELL KNOWN, ARE INDEPENDENT OF THE LANGUAGE USED. THESE CONCEPTS ARE THEN USED DIRECTLY IN OTHER LANGUAGES MORE TECHNICAL (C, JAVA, ETC..), WHICH CAN BE LEARNED AT A LATER DATE ALREADY STARTING FROM A BASE OF KNOWLEDGE THAT WILL FACILITATE THIS LEARNING .. ALL THIS IS ACCOMPANIED BY THE INTRODUCTION OF THE BASIC CONCEPTS OF ALGORITHMICS.

	Prerequisites
	NO ONE, EVEN IF IT IS DESIRABLE TO HAVE A KNOWLEDGE OF THE BASICS OF USING A COMPUTER (CORRESPONDING TO THE MODULES OF THE ECDL)

	Contents
	MODULE 1 BASIC CONCEPTS OF ICT COMPUTERS, COMPONENTS AND STRUCTURE OF A COMPUTER, TYPES OF COMPUTER - DIGITAL REPRESENTATION OF INFORMATION - DIGITAL REPRESENTATION OF MULTIMEDIA DATA - HARDWARE ARCHITECTURE OF A COMPUTER - SOFTWARE AND OPERATING SYSTEMS - COMPUTER NETWORKS MODULE 2 INFORMATION SYSTEMS AND DBMS BASIC CONCEPTS DBMS - LANGUAGE (SQL MANIPULATION STATEMENTS AND UPDATING DATA) MODULE 3 ALGORITHMS, DATA STRUCTURES AND PROGRAM BASIC CONCEPTS OF ALGORITHMS AND DATA STRUCTURES - HOW TO EVALUATE THE PERFORMANCE OF AN ALGORITHM - INTRINSIC COMPLEXITY OF A PROBLEM - CASE STUDY: SEARCHING FOR A WORD IN THE DICTIONARY - PROGRAMMING A COMPUTER WITH A HIGH-LEVEL LANGUAGE

Contents

MODULE 1 BASIC CONCEPTS OF ICT
COMPUTERS, COMPONENTS AND STRUCTURE OF A COMPUTER, TYPES OF COMPUTER - DIGITAL REPRESENTATION OF INFORMATION - DIGITAL REPRESENTATION OF MULTIMEDIA DATA - HARDWARE ARCHITECTURE OF A COMPUTER - SOFTWARE AND OPERATING SYSTEMS - COMPUTER NETWORKS
MODULE 2 INFORMATION SYSTEMS AND DBMS
BASIC CONCEPTS DBMS - LANGUAGE (SQL MANIPULATION STATEMENTS AND UPDATING DATA)
MODULE 3 ALGORITHMS, DATA STRUCTURES AND PROGRAM
BASIC CONCEPTS OF ALGORITHMS AND DATA STRUCTURES - HOW TO EVALUATE THE PERFORMANCE OF AN ALGORITHM - INTRINSIC COMPLEXITY OF A PROBLEM - CASE STUDY: SEARCHING FOR A WORD IN THE DICTIONARY - PROGRAMMING A COMPUTER WITH A HIGH-LEVEL LANGUAGE

	Teaching Methods
	LECTURES AND GUIDED EXERCISES. FREE EXERCISES WITH TRACES PROVIDED BY THE TEACHER THAT WILL BE DISCUSSED IN THE CLASSROOM. TRACKS AND TRANSPARENCIES OF THE LESSONS ARE AVAILABLE ON THE WEBSITE OF THE TEACHER (HTTP://WWW.UNISA.IT/DOCENTI/POSTIGLIONEA/INDEX).

	Verification of learning
	THE EXAMINATION TAKES PLACE AT THE LABORATORY OF MULTIMEDIA TEACHING FACULTY OF HUMANITIES. IT IS DIVIDED INTO THREE PARTS: • VERIFICATION OF KNOWLEDGE OF THE TOPICS "THEORETICAL" OF ALL 3 MODULES. • PRACTICAL TEST OF USING A DBMS: DEVELOPMENT OF AN APPLICATION INCLUDING CREATING TABLES, ENTERING DATA, CREATING FORMS AND REPORTS, MAKING QUERIES IN SQL • PROGRAMMING PRACTICE TEST IN A LANGUAGE HIGH LEVEL EACH PART HAS A THRESHOLD NOT EXCEEDING WHICH THE ENTIRE EXAM IS FAILED. THE FINAL GRADE IS THE SUM OF THE VOTES OF THE INDIVIDUAL PARTS

Verification of learning

THE EXAMINATION TAKES PLACE AT THE LABORATORY OF MULTIMEDIA TEACHING FACULTY OF HUMANITIES.
IT IS DIVIDED INTO THREE PARTS:
• VERIFICATION OF KNOWLEDGE OF THE TOPICS "THEORETICAL" OF ALL 3 MODULES.
• PRACTICAL TEST OF USING A DBMS: DEVELOPMENT OF AN APPLICATION INCLUDING CREATING TABLES, ENTERING DATA, CREATING FORMS AND REPORTS, MAKING QUERIES IN SQL
• PROGRAMMING PRACTICE TEST IN A LANGUAGE HIGH LEVEL
EACH PART HAS A THRESHOLD NOT EXCEEDING WHICH THE ENTIRE EXAM IS FAILED.
THE FINAL GRADE IS THE SUM OF THE VOTES OF THE INDIVIDUAL PARTS

	Texts
	CURTIN, FOLEY, SEN, MORIN "INFORMATICA DI BASE – V EDIZIONE“ - MC GRAW HILL, 2012 ATZENI, CERI, PARABOSCHI, TORLONE, - “BASI DI DATI - MODELLI E LINGUAGGI DI INTERROGAZIONE 3/ED” (CAP. 1, 2, 4.2 E 4.3) MCGRAW HILL, 2009 HANDOUTS AND ONLINE MATERIAL FOR MOD 3: (HTTP://WWW.UNISA.IT/DOCENTI/POSTIGLIONEA/INDEX ) SLIDES OF THE COURSE AND ADDITIONAL MATERIALS (EXERCISES, EXAMS, ...) TO DOWNLOAD FROM THE WEBSITE OF THE TEACHER: (HTTP://WWW.UNISA.IT/DOCENTI/POSTIGLIONEA/INDEX )

Texts

CURTIN, FOLEY, SEN, MORIN "INFORMATICA DI BASE – V EDIZIONE“ - MC GRAW HILL, 2012
ATZENI, CERI, PARABOSCHI, TORLONE, - “BASI DI DATI - MODELLI E LINGUAGGI DI INTERROGAZIONE 3/ED” (CAP. 1, 2, 4.2 E 4.3) MCGRAW HILL, 2009
HANDOUTS AND ONLINE MATERIAL FOR MOD 3: (HTTP://WWW.UNISA.IT/DOCENTI/POSTIGLIONEA/INDEX )
SLIDES OF THE COURSE AND ADDITIONAL MATERIALS (EXERCISES, EXAMS, ...) TO DOWNLOAD FROM THE WEBSITE OF THE TEACHER: (HTTP://WWW.UNISA.IT/DOCENTI/POSTIGLIONEA/INDEX )

	More Information
	COMPUTER EXERCISES THE COMPUTER EXERCISES, WHICH ARE ESSENTIAL IN ORDER TO UNDERSTAND EVEN THE HARDEST "THEORY" OF COURSE, CAN BE DONE BY THE STUDENT INDEPENDENTLY OR AT THE COMPUTER LAB OF THE FACULTY, FREELY ACCESSIBLE TO STUDENTS OF THE FACULTY OF HUMANITIES IN THE HOURS DEDICATED TO 'SELF-LEARNING. TEACHING MATERIALS FOR THEORETICAL ARGUMENTS: ON THE WEBSITE OF THE TEACHER, THE STUDENT WILL FIND THE SELF-ASSESSMENT TESTS TO BE CARRIED OUT ONLINE. TEACHING MATERIALS FOR LABORATORY EXERCISES ON THE DBMS: THE STUDENT MUST BE ABLE TO • CREATE AND POPULATE A RELATIONAL DBMS (IN PARTICULAR, HE MUST BE ABLE TO CORRECTLY DEFINE THE DATA TYPES, CHANGING THE STRUCTURE AND PROPERTIES OF TABLES, INSERT DATA IN TABLES, CREATE AND USE FORMS AND REPORTS) • QUERY A RELATIONAL DBMS USING SQL. THE LESSONS AND EXAMS TAKE PLACE USING THE DBMS MICROSOFT ACCESS. ON THE WEBSITE OF THE TEACHER, THE STUDENT WILL FIND MANY EXERCISES AND EXAMS. TEACHING MATERIALS FOR LABORATORY EXERCISES PROGRAMMING THE STUDENT MUST BE ABLE TO DESIGN ALGORITHMS (ELEMENTARY) AND IMPLEMENT ITS PROGRAMS IN THE PROGRAMMING LANGUAGE PASCAL. THE LESSONS AND EXAMS TAKE PLACE USING THE PROGRAMMING ENVIRONMENT (FREEWARE) DEVPASCAL 1.9.2 (WITH FREEPASCAL COMPILER) THAT CAN BE DOWNLOADED, FREE OF CHARGE, DIRECTLY TO THE SITE: HTTP://WWW.BLOODSHED.NET / DEV/DEVPAS192.EXE IT CAN BE USEFUL (BUT NOT REQUIRED) TO CONSULT A MANUAL ON HOW TO PROGRAM IN PASCAL. SOME MANUALS ARE AVAILABLE AT THE FOLLOWING WEB ADDRESSES: • WIKIPEDIA: HTTP://UPLOAD.WIKIMEDIA.ORG/WIKIBOOKS/IT/1/10/PASCAL.PDF • ESSENTIAL PASCAL (DELPHI VERSION) HTTP://WWW.MARCOCANTU.IT/EPASCAL/DEFAULT.HTM ON THE SITE OF THE TEACHER, THE STUDENT WILL FIND MANY PROGRAMMING EXERCISES.

More Information

COMPUTER EXERCISES
THE COMPUTER EXERCISES, WHICH ARE ESSENTIAL IN ORDER TO UNDERSTAND EVEN THE HARDEST "THEORY" OF COURSE, CAN BE DONE BY THE STUDENT INDEPENDENTLY OR AT THE COMPUTER LAB OF THE FACULTY, FREELY ACCESSIBLE TO STUDENTS OF THE FACULTY OF HUMANITIES IN THE HOURS DEDICATED TO 'SELF-LEARNING.

TEACHING MATERIALS FOR THEORETICAL ARGUMENTS:
ON THE WEBSITE OF THE TEACHER, THE STUDENT WILL FIND THE SELF-ASSESSMENT TESTS TO BE CARRIED OUT ONLINE.

TEACHING MATERIALS FOR LABORATORY EXERCISES ON THE DBMS:
THE STUDENT MUST BE ABLE TO
• CREATE AND POPULATE A RELATIONAL DBMS (IN PARTICULAR, HE MUST BE ABLE TO CORRECTLY DEFINE THE DATA TYPES, CHANGING THE STRUCTURE AND PROPERTIES OF TABLES, INSERT DATA IN TABLES, CREATE AND USE FORMS AND REPORTS)
• QUERY A RELATIONAL DBMS USING SQL. THE LESSONS AND EXAMS TAKE PLACE USING THE DBMS MICROSOFT ACCESS.
ON THE WEBSITE OF THE TEACHER, THE STUDENT WILL FIND MANY EXERCISES AND EXAMS.

TEACHING MATERIALS FOR LABORATORY EXERCISES PROGRAMMING
THE STUDENT MUST BE ABLE TO DESIGN ALGORITHMS (ELEMENTARY) AND IMPLEMENT ITS PROGRAMS IN THE PROGRAMMING LANGUAGE PASCAL.
THE LESSONS AND EXAMS TAKE PLACE USING THE PROGRAMMING ENVIRONMENT (FREEWARE) DEVPASCAL 1.9.2 (WITH FREEPASCAL COMPILER) THAT CAN BE DOWNLOADED, FREE OF CHARGE, DIRECTLY TO THE SITE: HTTP://WWW.BLOODSHED.NET / DEV/DEVPAS192.EXE
IT CAN BE USEFUL (BUT NOT REQUIRED) TO CONSULT A MANUAL ON HOW TO PROGRAM IN PASCAL. SOME MANUALS ARE AVAILABLE AT THE FOLLOWING WEB ADDRESSES:
• WIKIPEDIA: HTTP://UPLOAD.WIKIMEDIA.ORG/WIKIBOOKS/IT/1/10/PASCAL.PDF
• ESSENTIAL PASCAL (DELPHI VERSION) HTTP://WWW.MARCOCANTU.IT/EPASCAL/DEFAULT.HTM
ON THE SITE OF THE TEACHER, THE STUDENT WILL FIND MANY PROGRAMMING EXERCISES.

BETA VERSION Data source ESSE3 [Ultima Sincronizzazione: 2016-09-30]