Antonio Puglisi

COMPUTATIONAL TOOLS - A.Y. 2018

WEDNESDAY 21 FEBRUARY 

• [presentation] http://campus.unibo.it/321948/
• [exercise 1] Simple invoice: http://campus.unibo.it/218721/
• [Tutorial] Data types: https://support.office.com/en-us/article/Data-types-in-Data-Models-E2388F62-6122-4E2B-BCAD-053E3DA9BA90
• [tutorial] Data calculations: https://support.office.com/en-us/article/Introduction-to-data-calculations-94e1b4cc-cd1c-49c2-80ec-90c9b9591f47

WEDNESDAY 28 FEBRUARY

• [presentation] http://campus.unibo.it/323951/
• [tutorial] Formulas & functions: https://support.office.com/en-us/article/Formulas-and-functions-294d9486-b332-48ed-b489-abe7d0f9eda9#ID0EAABAAA=Reference
• [exercise] 2: http://dati.comune.bologna.it/node/1998

WEDNESDAY 07 MARCH

• [solutions] exercise 2: https://docs.google.com/spreadsheets/d/1ODL8Ko6gJLFh7mKXBlEoZ4Z6tPp2FOry76U7PkECQZE/edit?usp=sharing
• [presentation] http://campus.unibo.it/325467/
• [exercise] 3: http://campus.unibo.it/268320/
• [tutorial] Get started with formulas: https://templates.office.com/en-us/Formula-tutorial-TM16400656
• [videos] Execl video training: https://support.office.com/en-us/article/excel-video-training-9bc05390-e94c-46af-a5b3-d7c22f6990bb?ui=en-US&rs=en-001&ad=US

THURSDAY 15 MARCH

• [tutorial] Make your first PivotTable: https://templates.office.com/en-us/PivotTable-tutorial-TM16400647
• [exercise] 4: https://data.world/graphhopper/2018-oscar-nominees
• [presentation] http://campus.unibo.it/327074/

THURSDAY 19 APRIL

• [exercise] 5: iTunes Library http://campus.unibo.it/id/eprint/221889

WEDNESDAY 2 MAY

• [presentation] Get started with database: http://campus.unibo.it/334840/

WEDNESDAY 9 MAY

• [exercise] 6: From iTunes Library to DB: http://campus.unibo.it/336371/

WEDNESDAY 16 MAY

• [exercise] 6 bis: From iTunes Library to DB: http://campus.unibo.it/337543/
• [exercise] 7: Sirio - Rita Bologna: http://campus.unibo.it/337583/