COMPUTER SCIENCE APPLICATIONS
cod. 13538

Academic year 2007/08
1° year of course - First semester
Professor
Academic discipline
Informatica (INF/01)
Field
Abilità informatiche e relazionali
Type of training activity
More
32 hours
of face-to-face activities
4 credits
hub:
course unit
in - - -

Learning objectives

<br />the class goal is to make the student familiar with a spreadsheet<br />as a tool for managing, manipulating and exporing data<br /><br /><br />

Prerequisites

- - -

Course unit content

<br />The class is opened by an introductory stage focused on the <br />Personal Computers (PC), their components and technology. <br />This stage is performed upon demand by the students<br /><br />Microsoft Excel. <br /><br /> - User iteraction with the spreadsheet. Structure, properties and<br />logical organization of a XL workbook. <br />- Data representation, tables construction through automatic generation. <br />Functions, their properties and usage.<br />- Data import from external data formats.<br /><br />Elementary statistics of observed data, representation<br />through diagrams. Pivot Tables.<br /><br />

Full programme

- - -

Bibliography

<br />Any textbook about MS-Excel and other MS-Office applications

Teaching methods

The class is a practical one and the examination is<br />made upon a practical test where the student must<br />show his/her ability in the coping with the problems<br />that arise in the carrying out of an exercise.<br />During the lessons exercises are carried out and the<br />teacher helps each student on the every problem<br />that arises. During these sessions of common work<br />other topics related with computer technology and<br />networks are be explained.<br /><br />

Assessment methods and criteria

- - -

Other information

- - -