This website uses third party cookies to improve your experience. If you continue browsing or close this notice, you will accept their use.

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 earn the 4 credits as "Other activities".

Course contents

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.

1st lecture

Getting acquainted with computers and software; some general information about Excel and other software. General notions about data formats and data entry.

2nd lecture

Using functions in Excel. Writing simple recursive tasks using 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, other applications, including related statistical theory.

8th lecture

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

9th lecture

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

Assessment method

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.

  DATE TIME ROOM
1

Monday, September 23, 2013

Lesson cancelled. To be rescheduled at a later date (TBD).

9 a.m. - 12 p.m. 209
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.
209
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