- 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 earn the 4 credits as "Other activities".
Introduction to Excel and data computation. The aim of this seminar series is to make students proficient in the use of Excel for data management and analysis, for simple calculations and programming tasks. It is strongly recommended that students bring their own laptops or notebooks with them, 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.
Getting acquainted with computers and software; some general information about Excel and other software. General notions about data formats and data entry.
Using functions in Excel. Writing simple recursive tasks using the Fill function.
How to organize data and computations using worksheets.
How to write an Excel spreadsheet to calculate mortgage plans.
Data analysis with Excel. Notions of basic data analysis and statistics.
Data analysis with Excel. How to use statistical functions and graphics.
Data analysis with Excel. How to use statistical functions and graphics, other applications, including related statistical theory.
A numerical application, solving a simple system of differential equation systems describing information or rumors spread in a population.
Using random numbers to simulate variability and some interesting probability problems.
There will be a final test in the computer room at the end of the seminar series. The test will involve simple tasks using 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, practice and experience are more effective. As an introduction to how Excel works, one can, for example, take a look at "Excel basics in 30 Minutes" by Ian Lamont, The Digital Media Machine 2013 (the easiest way to get it is via Amazon). However, any other book about Excel could also work.
Calendar of lectures
Lectures are held on Mondays, from 9:00 a.m. to 12:00 p.m., according to the following schedule.
Lesson cancelled. To be rescheduled at a later date (TBD).
|2||Monday, September 30, 2013||9 a.m. - 12 p.m.||209|
|3||Monday, October 7, 2013||9 a.m. - 12 p.m.||209|
|4||Monday, October 14, 2013||9 a.m. - 12 p.m.||209|
|5||Monday, October 21, 2013||9 a.m. - 12 p.m.||209|
|6||Monday, October 28, 2013||9 a.m. - 12 p.m.||209|
|7||Monday, November 4, 2013||9 a.m. - 12 p.m.
|8||Monday, November 18, 2013||9 a.m. - 12 p.m.||209|
|9||Monday, December 2, 2013||9 a.m. - 12 p.m.||306 aula INFO|