Portale di Ateneo - En.Unibs.it

Part I: OFFICE AUTOMATION: Basic functions 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 Operative System Interface (virtual disk).

Part 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.

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

Part 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, central memory, hard disk, central unit processor (structure and how it works), machine language and assembler language (at a very introductory level). The computer as an executor of algorithms.

Part V: The REPRESENTATION OF INFORMATION. Binary numbers and basic operations. Representation of logical values and logical operators. Boolean algebra. Representation of chars, tests, graphics, images, movies, sounds (at very introductory level).

Part VI: COMPUTER NETWORKS AND PROTOCOLS. Main network models and structures with examples. Types of communications channels. Implementing the Cabling Infrastructure: cable cabinets and cable end racks. Device used in computer networking: 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.

Part 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. The SOLVER.

Part 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. Building 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. Recursive Binary Search Algorithm. Recursion and iteration (looping) are equally powerful.