Computer Skills — 15502

Track: CLEAI, CLEM, CLEMST, CLET.

Teaching Methods: E-learning course. The lessons are available on a Web site, and can be accessed anytime.

Language of instruction: Italian

Exam: Computer based tests on theory and practice.

Learning Outcomes: Use of personal productivity tools: word processor, spreadsheet, database. We will address several applications for each class.

Contents: Word processor: main applications and their basic functions. Main typographical objects managed by means of a word processor. Common commands available word processor applications; especially those related to document visualization. Page composition and accurate tuning of the resultant document. Among the others, page footer and header, notes, bulleted and numbered lists, syllabication. Some advanced features in typography, such as the keep properties, widows and orphans. Special tools to speedup the formatting of long text and to automate repetitive tasks.
Spreadsheet: presentation of the spreadsheet applications. The graph paper metaphor and basic operations. Addressing methods of cells, formulas to compute value, graph generation. Data management. Advanced tools to manage spreadsheets and 3-D graphs.
Database: data collection and acquisition. Data storing and archival. Data management. Data distribution and exchange. Data relational model. Query language SQL. Schema definition in an object oriented database. Data update. Database query.

Recommended Reading: http://a3.unibo.it

Lessons: The lessons are accessible any time by the Web. To gain access to the lessons it is mandatory a registration. To register send an e–mail to the teacher:

Office Hours: Wednesday 11 - 12. Or by e-mail to the teacher