67059 - Data Processing (A-L)

Course Unit Page

SDGs

This teaching activity contributes to the achievement of the Sustainable Development Goals of the UN 2030 Agenda.

Quality education Affordable and clean energy Industry, innovation and infrastructure Sustainable cities

Academic Year 2022/2023

Learning outcomes

At the end of the course, the student will know the essential IT tools for the searching on Internet, the selection and processing of bibliographic, documentary, statistical, business and marketing data for the financial and management support in business and professional enterprises. In particular, the student will be able to: - search in Internet bibliographies, documents and data; select, locate and acquire them, - process data for the preparation of professional documents shared by a working group, - set up simple schemes of accounting spreadsheet - calculate indicators and represent them graphically, make simple simulations of alternative situations and present results and strategies derived from the data collection, - evaluate different options for the automation of the company.

Course contents

During the course students will acquire the knowledge of the main software applications that are used in the office automation and in business environments.

THEORY

Internal architecture of an electronic computer: microprocessor, memories, clock and input/output devices. Evolution of computing systems. Representation of information inside the computer. The numbering systems: binary, octal and hexadecimal. The operating system: kernel, file, memory and peripherals manager. Application software and licenses for the use. Algorithms and programming languages. Translators: compilers and interpreters. Data protection and antivirus. The computer networks. Network cards, MAC and network protocols. Types of networks: LAN, MAN and WAN. Internet and HTTP and TCP / IP protocols. Web services. Search engines. File sharing on the web and communication tools.

DESIGN AND PRODUCTION OF PROFESSIONAL DOCUMENTS

The main functions of a word processor. Advanced formatting on characters and paragraphs. Tab stops and indents. The regular and irregular tables. From text to hypermedia. Inserting graphic objects. The text boxes. Customized documents. Type letters and mail merge. Revision of documents. Importing data from an external database. Models and styles. Management of the summary and of the analytical index and of the images. Creating a graphical presentation. Formatting of slides. Transition and animation effects. Applications.

DESIGN AND MANAGEMENT OF ACCOUNTING SCHEMAS BY SPREADSHEET Spreadsheets. Advanced cell formatting. Absolute and relative references. Mathematical, statistical and financial functions. The logical functions AND, OR, NOT. The logical function = IF and the nested IF. The database functions: DB.max, DB.min, DB.media, DB.sum and the function = Sum.if. The selection criteria. Simple and advanced filters. The search functions. The subtotals. Data validation. The Pivot Tables. The graphs. Mathematical and commercial graphs. The Macros. Analysis of data and business indices. Creation of economic scenarios.

DESIGN AND MANAGEMENT OF DATABASES

The design and management of databases. Conceptual, logical and physical schemes. Relations. Relational databases. The main objects of a database: tables, queries, forms and reports. Creating a table. Records and fields. The unique code or key. Relationship between multiple tables. The queries: selection, update, create a new table, delete and cross-tab queries. The logical selection criteria AND and OR. Importing data contained in a spreadsheet into the database. The forms and reports. Corporate reports.

BIBLIOGRAPHIC AND DOCUMENTARY SEARCHING


Research of information, documents, publications and lows within the databases of the University Library System (SBA). Research of degree and doctoral theses, books, articles, laws and journals. Selection and processing of shared professional documents. The targeted bibliographic and documentary research.

Readings/Bibliography

The list of open source booklets and the slides on all the topics discussed in class, for the CLEA and CLAMM courses, are published on the Virtual platform.

 

Teaching methods

Interactive lessons. Slides. Use of the shared folder and of the Virtual platform. Laboratory exercises. Course materials on the Virtual moodle platform.

In consideration of the types of activities and teaching methods adopted, the attendance of this training activity requires the prior participation of all students, in e-learning mode, of modules 1 and 2 of the training on safety in the study areas [https://elearning-sicurezza.unibo.it/]

Assessment methods

Computer exam consisting of no. 15 questions/exercises on Theory, Word Processor and Graphic Presentations, Spreadsheet, Database Management and Bibliographic and Document Research.

At the beginning of the practical test, the text of the exercises and the attached files will be automatically displayed on the EOL platform. The delivery of the 4 files (Word, Powerpoint, Excel and Access) will be via EOL.

The eligibility is acquired if the minimum score of 9 is reached (no. 4 exact exercises on the topics of Theory, Word Processing, Graphic Presentations and Bibliographic and Document Research, no. 3 exact exercises of the Spreadsheet and no. 2 exact exercises Database Management).

Teaching tools

Computer network, Internet, EOL, Sharing of online documents, slides and lecture notes and exercises published on the Virtual moodle platform.

Office hours

See the website of Domenico Consoli