# Antonio Puglisi

Department of Management

## Useful contents

### Computational Tools 2015

Thrusday 26/03/2015

case study: http://campus.unibo.it/182257/

----------------------------------------------

Wednesday 25/03/2015

"Database design" - presentation: http://campus.unibo.it/182251/
iTunes export: http://campus.unibo.it/136089/

----------------------------------------------

Friday 20/03/2015

"Database introduction" - presentation http://campus.unibo.it/182028/

----------------------------------------------

Tuesday 10/03/2015

exercise: http://campus.unibo.it/179203/

----------------------------------------------

Friday 27/02/2015

N. Sandoli "Data Visualization" - presentation: http://campus.unibo.it/179201/

----------------------------------------------

Wednesday 03/03/2015

quick survey: http://bit.ly/1F8MTiY

----------------------------------------------

Tuesday 03/03/2015

EXERCISE
The workbook bookcase.xls contains metadata about a small set of books property of the aNobii web community: Title, Author, Type, Publisher, Pages, ISBN, Stars.

- exercise: http://bit.ly/1CowzNi
- exercise + solutions: http://bit.ly/1DPLL1x

In the Analysis worksheet:
1. Cells E3:E12 - find the corresponding number of pages for each book;
2. Cell E15 - using the proper function find the smallest number in the range E3:E12;
3. Cells F3:F12 - classify the book by inserting the value "Big" if the number of the pages is greater than 400, “Medium” if is included between 200 and 400, "Small" if is lower then 200;
4. Cell E:19 – calculate the average number of pages per book of the publisher Mondadori;

----------------------------------------------

Friday 27/02/2015

M. Vignocchi "Library services and bibliographic research" - presentation: http://campus.unibo.it/177751/

----------------------------------------------

Wednesday 25/02/2015

----------------------------------------------

Tuesday 17/02/2015

presentation: http://campus.unibo.it/175592/

kick-off little survey: http://bit.ly/ct2015_survey1

(easy) exercise: http://bit.ly/1yQB7ox

step 1
Set the following formats:
- percentage with two decimal places: cell D6
- 8 digit number: cells D9:D20
- accounting euro with 2 decimals: cells F9:G20
step 2
Calculate, for each row:
- VAT (amount  * VAT rate): cells G9:G20;
- total (amount * (1 + VAT rate)): cells H9: H20;
- calculate the sum and the averege of the values in the range cell H9:H20
step 3
- set a function to release the value "CAT A " where the amount of the total is greater than 1,500 €, otherwise  "CAT B" : cells I9:I20.
---

### Latest news

At the moment no news are available.