Al fine di migliorare la tua esperienza di navigazione, questo sito utilizza i cookie di profilazione di terze parti. Chiudendo questo banner o accedendo ad un qualunque elemento sottostante acconsenti all’uso dei cookie.

Introduction to Excel and data computation

  • Academic year: 2013/2014
  • Prof.  Gianpaolo Scalia Tomba
  • Semester: first semester
  • Total lectures: 9

Students are required to attend at least 7 lectures out of 9 and to pass the final assessment test to have 4 CFU recognized as Other Activities.

Course contents

Introduction to Excel and data computation. The aim of the seminar series is to make attending students proficient in the use of Excel for data management and analysis, for simple calculations and programming tasks. Students are warmly recommended to bring with them their own laptops or notebooks, with Excel or equivalent freeware installed. Part of each seminar will be dedicated to exercises. In general, computers and software are available in LUISS computer rooms...

1st lecture

Acquaintance with computers and software; some generalities about Excel and other software. General notions about data formats and entry.

2nd lecture

Using functions in Excel. Writing simple recursive tasks with the Fill function.

3rd lecture

How to organize data and computations using worksheets.

4th lecture

How to write an Excel spreadsheet to calculate mortgage plans.

5th lecture

Data Analysis with Excel. Notions of basic data analysis and statistics.

6th lecture

Data Analysis with Excel. How to use statistical functions and graphics.

7th lecture

Data Analysis with Excel. How to use statistical functions and graphics, further applications, including related statistical theory.

8th lecture

A numerical application, solving a simple system of differential equation system describing information or rumour spread in a population.

9th lecture

Using random numbers to simulate variability and some interesting probability problems.

Assessment method

Final test in computer room, at the end of the seminar series. The test will involve simple tasks involving data and Excel. The test will be only be graded as Sufficient or Not Sufficient.

Suggested reference reading material

There are many books about Excel. However, personal practice and experience is better... As an introduction to how Excel works, one can e.g. have a look at "Excel basics in 30 Minutes" by Ian Lamont, The Digital Media Machine 2013 (easiest way to get it is via Amazon...). However, any other book about Excel might also work...

Calendario delle lezioni

Le lezioni si terranno il lunedì, dalle ore 9 alle 12, secondo il calendario che segue.

  DATA ORARIO AULA
1

lunedì 23 settembre 2013

Lezione annullata. Da recuperare a data da destinarsi

9-12 209
2 lunedì 30 settembre 2013 9-12 209
3 lunedì 7 ottobre 2013 9-12 209
4 lunedì 14 ottobre 2013 9-12 209
5 lunedì 21 ottobre 2013 9-12 209
6 lunedì 28 ottobre 2013 9-12 209
7 lunedì 4 novembre 2013 9-12 209
8 lunedì 18 novembre 2013 9-12 209
9 lunedì 2 dicembre 2013 9-12 306 aula INFO