Portale di Ateneo - En.Unibs.it

Part I - OFFICE AUTOMATION:
Basic features of an office automation software. Main office automation suites and their components. Office automation WEB APPS: Microsoft Office Online, iCloud and Google Docs. Intuitive concepts of WEB APPLICATION. CLOUD Disk Management via WEB or Operating System Interface (virtual disk).

Parte II - VIRTUALIZATION:
Machine language and high level programming languages. The role of APIs in Software Development. The layered model in operating systems. The HARDWARE VIRTUALIZATION: definition of a hardware emulator. Software incompatibility on different operating systems. Hardware Virtualization on the network: the Terminal Server. The business impact of Virtualization. The SOFTWARE VIRTUALIZATION: virtual machine and bit code. The Benefits of source code reuse: "Write once, run anywhere". CLOUD VIRTUALIZATION: Browsers as a Virtual Machine.

Parte III - APPLICATION PARADIGMS:
Standalone, Mainframe, File Server, Client/Server (Application Server, Terminal Server, WEB-based application). CLOUD Application: Wan Extension of Client/Server paradigm.

Parte IV - HARDWARE:
Main components, architecture and operations of a typical computer. High level architecture (VON NEUMANN and HARVARD) of a simple computing system. Basic input/output devices, hard disk, central memory, central unit processor (structure and how it operates), machine language and assembler language (at a very introductory level). The computer as an executor of algorithms.

Parte V - REPRESENTATION OF INFORMATION:
Binary numbers and basic operations. Representation of logical values and logical operators. Boolean algebra. Representation of chars, graphic elements, images, movies, sounds (at very introductory level).

Parte VI - COMPUTER NETWORKS AND PROTOCOLS:
Main network models and structures with examples. Types of communications channels. Implementing the Cabling Infrastructure: cable cabinets and racks. Network Device: Switch, Bridge, Router, Proxy, Gateway and Firewall. The purpose of a DMZ. The 7 Layers of the OSI Model. TCP/IP Model Layers. IP address classes. Dynamic and Static IP, Private and Public IP Addresses. Naming Conventions and DNS. Internet Domain Names registration.

Parte VII - SPREADSHEET MACROS AND FORMULAS:
Spreadsheets: getting started. Intuitive concepts of algorithm. Understanding most useful Excel macros. User Interface: Form controls and ActiveX Controls. Spreadsheet data management. Sequential search algorithm. Binary search Algorithm. Import data from external sources. Common interchange format: delimited, fixed-width and XML. PIVOT table.

Parte VIII - COMPUTER PROGRAMMING:
High level programming languages. Compilers and interpreters. VBA Programming environment. Introduction to VBA programming: general features of the VBA language. General structure of a VBA program. Basic data types. Input/output instructions. Basic operators and expressions with variables. Basic control structures (conditional instructions and loops). Vectors and matrices. Scope of variables. Creating User Defined Functions. Example: using VBA to control a LED with Arduino. Sorting algorithms. TOP-DOWN and BOTTOM-UP design. Recursion. Linear and non-linear Recursion. Recursion and iteration (looping) are equally powerful.