Portale di Ateneo - En.Unibs.it

- Introduction to computer science and computational thinking (2 hours)
Introduction to the course: objectives, topics and limitations. Introduction to computer science. Concepts of computational thinking: logical reasoning, decomposition, generalization, recurrent schemes, abstractions, evaluation. Techniques associated to the computational thinking: reflect, program, design, analyze, apply.

- The algorithm (8 hours)
Problems and solutions. Algorithm properties. Algorithms, computations and functions. The algorithmic solution of problems. Algorithms design: the process of problem resolution, from the analysis of a problem to the execution of a program, characteristics of an algorithm (instructions and data). Representation of algorithms. Block diagrams. Algorithms examples.

- The computer (4 hours)
The computer as universal algorithm executor. Macroscopic organization of the computer, the operating system, computer networks, Internet, the World Wide Web.

- The applications (6 hours)
Types of applications, Web applications, database management systems, personal productivity apps, business and office apps. Problems of security.

- Information encoding (8 hours)
Information and representations. Binary code. Encoding of numbers, texts, sounds, images, and videos.

- The databases (8 hours)
What is a database, bibliographic or full text databases, indexing, labels, keywords, thesaurus. Simple and advanced searches, chronological, source and thematic filters, limitation of results and refinement of the search. Exploration of the main databases for the building/construction and the sustainable agriculture sectors, their interfaces and features.

- The spreadsheets (24 hours) – Microsoft Excel will be used
Excel: what it is and how it looks. The structure of the spreadsheet (cells, rows, columns, sheets, folders). Inserting contents, content format, automatic filling. Tables, filters, sorting. Built-in functions,construction of functions, date / time functions, mathematics, statistics and text, conditional formatting. Absolute and cell-related references. Search functions. Charts. Pivot tables. Validation of data and error reporting.