Home > Contenuti utili > Computational Tools 2015
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.
files to download:
- 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
spreadsheet exercise: http://bit.ly/ct_exercise_02
----------------------------------------------
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.
---
