77095 - Computational Tools (B.A.)

Learning outcomes

At the end of the Teaching Activities related to the course “Computational Tools”, students will be familiar with programming techniques, plus, they should have gathered a knowledge on basic instructive concepts that would help them accomplish an optimal research on resources like the internet (and other databases), develop an awareness to select, deploy and elaborate some bibliographical data, statistics, balance sheets, market data, benchmark, outcomes of working groups operating in the corporate/business fields, develop the ability to set-up and structure the information coming from financial support, from the management and from other different professions. This course is intended to complement the analytical skills of the student when it comes to: - perform a research on the internet, on scientific databases, identify data, select it, group them, assess it. - compute the data with the purpose of drafting summaries, documentation and other files that may be useful for the working group. - conducting simple numerical analysis of dynamic economic and accounting models on a spreadsheet - compute indicators and indexes and work them from a graphical standpoint, rely on the use of alternative models e display all outcomes, results and strategies knowing how to assemble all this information. - Evaluate and assess all the different options to reach a full automation of the firm.

Course contents

Contents:

1. General concepts about software and hardware. Hardware components. Brief history of computer systems. Introduction to programming logic, symbology, flow diagram. Create a flowchart.

2. Computer and communication networks. Topologies. The ISO OSI model. Computer networks and communications hardware. Wired and wireless networks. The operation of the WiFi. Introduction to computer viruses and data security.

3. The word processor. Using Microsoft Word. Formats, spell checking, text with images. Exchange of documents. The PDF format. Design and management of pages and formats. Search and replacement. Fonts, install new fonts.

4. The spreadsheet. Generalities and history. Microsoft Excel. Use of data within the sheet. Relative and absolute references. Basic functions: sum, average, count, higher, lower, add.if, count.if.

5. The spreadsheet. Charts, chart types. Data management and graphic presentation. Advanced functions, search, search, import, filter, array.

6. The spreadsheet as a database manager. Specific functions. Dynamic tables.

7. ICTs and people. Computer systems in the professional career. Social networks. The future of communications. Cryptocurrencies. On Create a team project presentation using all resources.

8. Introduction to programming. Operating systems and development interfaces. HTML 5. Programming in html. On Create a small program with instructions.

Readings/Bibliography

Teaching documents generated by the Teacher itself.

Teaching methods

Theoretical content taught remotely.

Individual and group practical activities.

Written evaluations.

Assessment methods

Carrying out individual and group practical work.

Evaluations.

Teaching tools

Microsoft Teams.

Zoom.

Microsoft office.

HTML IDE.

Web pages.

Office hours

See the website of Federico Ariel Franic