Computer Science

Schema della sezione

• Seleziona sezione Introduzione

  Minimizza Espandi

  Introduzione

  Minimizza tutto Espandi tutto

  • Seleziona attività Annunci

    

    Annunci Forum
• Seleziona sezione Textbook

  Minimizza Espandi

  Textbook

  • Seleziona attività Timetable Recommended Tex...

    Timetable	Recommended Textbook
    Tues. 11.15 - 12.45 Pc Lab	Microsoft Office Excel 2007 Bible
    Fri.      9.15 - 10.45 Pc Lab	John Walkenbach
    	Wiley, 2007

    
    
  • Seleziona attività Please, take note that from January 2010 the exam ...

    Please, take note that from January 2010 the exam will be in oral/practical form.
• Seleziona sezione Course program and outlines

  Minimizza Espandi

  Course program and outlines

  • Seleziona attività Course Program

    

    Course Program Pagina
  • Seleziona attività Course outlines

    

    Course outlines Pagina
• Seleziona sezione Two introductory Powerpoint presentations on Excel

  Minimizza Espandi

  Two introductory Powerpoint presentations on Excel

  Two introductory Powerpoint presentations on Excel

  Here you find two 'official' Microsoft presentations on Excel.
  After opening Excel, watch them and try to repeat the actions which are illustrated inside step by step.
  Data to reproduce the actions contained in the second lesson of the second presentation are contained in the Excel file below.
  In this way, you will learn some basic Excel functionalities and  become familiar with some fundamental Excel menus and commands.

  • Seleziona attività Create your first workbook

    

    Create your first workbook File
  • Seleziona attività Get up to speed

    

    Get up to speed File
  • Seleziona attività Data on products

    

    Data on products File
• Seleziona sezione An introductory exercise on formatting

  Minimizza Espandi

  An introductory exercise on formatting

  An introductory exercise on formatting

  • Seleziona attività Here below you find an Excel workbook containing s...

    Here below you find an Excel workbook containing some unformatted data and a Powerpoint presentation on some basic formatting Excel commands.

    Follow the instructions contained in the presentation to format the data in the workbook.

  • Seleziona attività Area and population data

    

    Area and population data File
  • Seleziona attività Formatting an Excel 2007 worksheet

    

    Formatting an Excel 2007 worksheet File
  • Seleziona attività The following Excel file contains some examples on...

    The following Excel file contains some examples on number formatting:
  • Seleziona attività Examples on number formatting

    

    Examples on number formatting File
• Seleziona sezione A new tool: Tables

  Minimizza Espandi

  A new tool: Tables

  A new tool: Tables

  • Seleziona attività Excel 2007 introduces a new tool to help the user ...

    Excel 2007 introduces a new tool to help the user to create and to manipulate tables of data, called 'Tables'.

    The following pdf document explains the main functionalities of this tool. Read it (the first six pages are enough) and do the previous exercise again, using Tables. 

  • Seleziona attività Excel 2007 Tables

    

    Excel 2007 Tables File
• Seleziona sezione Introductory exercises

  Minimizza Espandi

  Introductory exercises

  Introductory exercises

  • Seleziona attività Now, look at the following pdf files and try to re...

    Now, look at the following pdf files and try to reproduce their contents by means of Excel workbooks, using the notions that you learned before. (You can choose your own colours and numbers, if you like.)

  • Seleziona attività An introductory simple exercise

    

    An introductory simple exercise File
  • Seleziona attività Another introductory exercise

    

    Another introductory exercise File
• Seleziona sezione Formulas

  Minimizza Espandi

  Formulas

  Formulas

  • Seleziona attività Here you find an 'official' Microsoft presentati...

    Here you find an 'official' Microsoft presentation on Excel formulas.

    Remember that formulas are what make a spreadsheet program really useful. Formulas let the user calculate results from data stored in the spreadsheet. They usually refer to cells and changing data in these cells make formulas change dynamically.

    After opening Excel, watch the presentation and repeat the actions which are illustrated inside step by step. For this, feel free to use the Excel workbook provided below.

  • Seleziona attività Enter formulas

    

    Enter formulas File
  • Seleziona attività Data for the presentation on formulas

    

    Data for the presentation on formulas File
  • Seleziona attività The following Excel file presents some examples wh...

    The following Excel file presents some examples where some important Excel functions are employed. Examine the use of these functions very carefully.

  • Seleziona attività Some Excel functions

    

    Some Excel functions File
  • Seleziona attività Many other functions are available in Excel. The f...

    Many other functions are available in Excel. The following file contains a list of Excel functions and a brief description of their use.
  • Seleziona attività List of Excel functions

    

    List of Excel functions File
• Seleziona sezione Naming ranges and referring to data in Tables

  Minimizza Espandi

  Naming ranges and referring to data in Tables

  Naming ranges and referring to data in Tables

  • Seleziona attività A range is the term employed by Excel to define a ...

    A range is the term employed by Excel to define a group of cells.

    For instance, B1:D5 represents a group of 15 cells (B1, B2, B3, B4, B5, C1, C2, C3, C4, C5, D1, D2, D3, D4, D5).

    Many functions accept ranges as argument. For instance: SUM(B1:D5) returns the sum of the values contained in the 15 cells above.

    Ranges can be named. To discover the way to accomplish that, read the following pdf file.

  • Seleziona attività Naming ranges

    

    Naming ranges File
  • Seleziona attività The Excel file which follows contains an example w...

    The Excel file which follows contains an example where some named ranges are used.
  • Seleziona attività An example of named ranges

    

    An example of named ranges File
  • Seleziona attività Data in a table (i.e. data formatted as Table) can...

    Data in a table (i.e. data formatted as Table) can be referred to by using the table name and columns headers. An example is contained in the file which follows.
  • Seleziona attività Referring to data in Tables

    

    Referring to data in Tables File
• Seleziona sezione Exercise: calculating averages and percentages

  Minimizza Espandi

  Exercise: calculating averages and percentages

  Exercise: calculating averages and percentages

  • Seleziona attività The Excel workbook below contains the number of fo...

    The Excel workbook below contains the number of foreign students enrolled in Italian universities during the academic year 1999-2000.

  • Seleziona attività Foreign students in Italy 1999 - 2000

    

    Foreign students in Italy 1999 - 2000 File
  • Seleziona attività Modify the workbook according to the pdf files w...

    Modify the workbook according to the pdf files which follow (use for this three worksheets in the same workbook).

  • Seleziona attività Averages and percentages

    

    Averages and percentages File
  • Seleziona attività Percentages to total

    

    Percentages to total File
  • Seleziona attività Summary

    

    Summary File
• Seleziona sezione Exercise: using functions requiring criteria

  Minimizza Espandi

  Exercise: using functions requiring criteria

  Exercise: using functions requiring criteria

  • Seleziona attività In the Excel file wich follows you can find data a...

    In the Excel file wich follows you can find data about the urban population in Italy in various ages.
  • Seleziona attività Urban population in various ages

    

    Urban population in various ages File
  • Seleziona attività Try to reproduce the following worksheets by using...

    Try to reproduce the following worksheets by using the data contained in the previous file. A good knowledge of the syntax of functions like COUNTIF, SUMIF, COUNTIFS, SUMIFS, ..., is required.
  • Seleziona attività Analysis n.1 of urban population

    

    Analysis n.1 of urban population File
  • Seleziona attività Analysis n.2 of urban population

    

    Analysis n.2 of urban population File
• Seleziona sezione Charts

  Minimizza Espandi

  Charts

  Charts

  • Seleziona attività Watch the following 'official' Microsoft present...

    Watch the following 'official' Microsoft presentation on Excel charts.
  • Seleziona attività Create a chart

    

    Create a chart File
  • Seleziona attività After watching the presentation, do the followin...

    After watching the presentation, do the following exercise. You find the data in the Excel file below the exercise. 

  • Seleziona attività A worksheet for the head of your office

    

    A worksheet for the head of your office File
  • Seleziona attività Data for the exercise

    

    Data for the exercise File
• Seleziona sezione An analysis of customers' arrivals using charts

  Minimizza Espandi

  An analysis of customers' arrivals using charts

  An analysis of customers' arrivals using charts

  • Seleziona attività Experiment different (but reasonable) kinds of cha...

    Experiment different (but reasonable) kinds of charts doing the exercise which follows. (Hint: use the SUMIF function to build new tables with the data requested.)

  • Seleziona attività Analysing arrivals of customers

    

    Analysing arrivals of customers File
• Seleziona sezione Plotting functions

  Minimizza Espandi

  Plotting functions

  Plotting functions

  • Seleziona attività Plot the graph of the function f(x)=x2+1 in the in...

    Plot the graph of the function f(x)=x²+1 in the interval [-2,2]. (Hint: build a convenient table of values between -2 and 2...)
• Seleziona sezione Dates and time

  Minimizza Espandi

  Dates and time

  Dates and time

  • Seleziona attività Excel employs serial numbers to represent dates an...

    Excel employs serial numbers to represent dates and time. You find a brief description of this representation and some examples in the following documents.
  • Seleziona attività Dates and time in Excel

    

    Dates and time in Excel File
  • Seleziona attività Some examples on using dates and times in Excel

    

    Some examples on using dates and times in Excel File
  • Seleziona attività For a complete list of date and time functions i...

    For a complete list of date and time functions in Excel, see the Excel help or the following link:

  • Seleziona attività Tutorial on Microsoft Excel on www.bettersolutions.com

    

    Tutorial on Microsoft Excel on www.bettersolutions.com URL
  • Seleziona attività Now try to create a worksheet as suggested by th...

    Now try to create a worksheet as suggested by the following pdf file, by using convenient Excel functions. Try to discover them! (Some hints are given.)

    Notice that data contained in orange cells are typed by the user, whilst those in yellow cells are calculated by means of formulas.

  • Seleziona attività An exercise on date formulas in Excel

    

    An exercise on date formulas in Excel File
  • Seleziona attività You will probably find the following resource us...

    You will probably find the following resource useful:

  • Seleziona attività Calculating an age between two dates using the DATEDIF function

    

    Calculating an age between two dates using the DATEDIF function URL
  • Seleziona attività Notice also what happens in case of user's birt...

    Notice also what happens in case of user's birthday. (Hint: explore the use of logical functions (for instance IF and AND) in Excel.)

  • Seleziona attività It's your birthday today!

    

    It's your birthday today! File
• Seleziona sezione Exercises on dates and time

  Minimizza Espandi

  Exercises on dates and time

  Exercises on dates and time 

  • Seleziona attività Using the data that you find here

    Using the data that you find here
  • Seleziona attività Data for Exercise 1

    

    Data for Exercise 1 File
  • Seleziona attività Data for Exercise 2

    

    Data for Exercise 2 File
  • Seleziona attività try to reproduce the following tables

    try to reproduce the following tables
  • Seleziona attività Exercise 1

    

    Exercise 1 File
  • Seleziona attività Exercise 2

    

    Exercise 2 File
• Seleziona sezione Importing textual data

  Minimizza Espandi

  Importing textual data

  Importing textual data

  • Seleziona attività Data are often available as text. Excel is able to...

    Data are often available as text. Excel is able to import such kind of data, but some specific rules apply in order to convert them into a readable form. Read the following pdf file to understand the basic principles on this topic.

  • Seleziona attività Import text into Excel

    

    Import text into Excel File
  • Seleziona attività To try the Excel's functionalities in importing d...

    To try the Excel's functionalities in importing data, you can use the files which follow. They contain the proportion of population aged 15-24 years in the European countries, in plain text, CSV (Comma-Separated Values) and 'text separated by spaces' format respectively. Use the preview window of the Excel's importing procedure to verify that the data are correctly imported.
  • Seleziona attività Proportion of European population aged 15-24 (txt)

    

    Proportion of European population aged 15-24 (txt) File
  • Seleziona attività Proportion of European population aged 15-24 (csv)

    

    Proportion of European population aged 15-24 (csv) File
  • Seleziona attività Proportion of European population aged 15-24 (prn)

    

    Proportion of European population aged 15-24 (prn) File
• Seleziona sezione Using Excel functions to look up values

  Minimizza Espandi

  Using Excel functions to look up values

  Using Excel functions to look up values

  • Seleziona attività Excel supplies us with many functions to look up v...

    Excel supplies us with many functions to look up values in tables of data, for instance: VLOOKUP, HLOOKUP, LOOKUP, MATCH, INDEX, and others.

    A brief explanation on these functions, together with examples, can be found in the files which follow. You can also read the Excel help system.

  • Seleziona attività Information about functions that look up values

    

    Information about functions that look up values File
  • Seleziona attività Some lookup examples

    

    Some lookup examples File
  • Seleziona attività Using the right Excel functions, try to reproduce ...

    Using the right Excel functions, try to reproduce the Excel worksheet that is represented in the pdf document which follows.

  • Seleziona attività Were the Beatles good students?

    

    Were the Beatles good students? File
• Seleziona sezione The Goal Seek tool

  Minimizza Espandi

  The Goal Seek tool

  The Goal Seek tool

  • Seleziona attività Do the exercises that follow.

    Do the exercises that follow.
  • Seleziona attività Building a wall

    

    Building a wall Pagina
  • Seleziona attività How much can I spend?

    

    How much can I spend? Pagina
  • Seleziona attività After doing the exercises, read the following pdf ...

    After doing the exercises, read the following pdf document, which explains the Excel Goal Seek tool , and try to do the second exercise again, by using that tool.

  • Seleziona attività The Goal Seek tool

    

    The Goal Seek tool File
• Seleziona sezione Something magic: Pivot Tables

  Minimizza Espandi

  Something magic: Pivot Tables

  Something magic: Pivot Tables

  • Seleziona attività A pivot table is a dynamic and interactive summary...

    A pivot table is a dynamic and interactive summary report which is generated from data. With only a few mouse clicks, data can be presented and summarised in many different ways. Watch the following 'official' presentation on this powerful tool. Data to try are provided as well. 
  • Seleziona attività Get started with Pivot Tables

    

    Get started with Pivot Tables File
  • Seleziona attività Data for the Pivot Tables presentation

    

    Data for the Pivot Tables presentation File
  • Seleziona attività After watching the presentation, do exercise n. 13...

    After watching the presentation, do exercise n. 13 again, using Pivot Tables and Pivot Charts.
• Seleziona sezione Some exercises

  Minimizza Espandi

  Some exercises

  Some exercises

  • Seleziona attività Exercise n. 1 - Studying the European population

    

    Exercise n. 1 - Studying the European population Pagina
  • Seleziona attività Exercise n. 2 - U.S.A. president's popularity

    

    Exercise n. 2 - U.S.A. president's popularity Pagina
  • Seleziona attività Data for exercise n. 2 (UPDATED!)

    

    Data for exercise n. 2 (UPDATED!) File
  • Seleziona attività Exercise n. 3 - Analysing the population of Trieste

    

    Exercise n. 3 - Analysing the population of Trieste File
  • Seleziona attività You can find data for Excercise n. 3 in the text f...

    You can find data for Excercise n. 3 in the text files which follow.
  • Seleziona attività Data for Exercise n. 3 - Male population in Trieste

    

    Data for Exercise n. 3 - Male population in Trieste File
  • Seleziona attività Data for Exercise n. 3 - Female population in Trieste

    

    Data for Exercise n. 3 - Female population in Trieste File
  • Seleziona attività Exercise n. 4 - Travelling from London to Glasgow

    

    Exercise n. 4 - Travelling from London to Glasgow Pagina
• Seleziona sezione Exam - 08/01/2009

  Minimizza Espandi

  Exam - 08/01/2009

  Exam - 08/01/2009

  • Seleziona attività Instructions - 2009 01 08

    

    Instructions - 2009 01 08 File
  • Seleziona attività Assignment 2009 01 08

    

    Assignment 2009 01 08 File
  • Seleziona attività Data on USA car crashes

    

    Data on USA car crashes File
• Seleziona sezione Exam - 22/01/2009

  Minimizza Espandi

  Exam - 22/01/2009

  Exam - 22/01/2009

  • Seleziona attività Instructions - 2009 01 22

    

    Instructions - 2009 01 22 File
  • Seleziona attività Assignment - 2009 01 22

    

    Assignment - 2009 01 22 File
  • Seleziona attività Data on Italian Superenalotto lottery

    

    Data on Italian Superenalotto lottery File
• Seleziona sezione Exam - 05/02/2009

  Minimizza Espandi

  Exam - 05/02/2009

  Exam - 05/02/2009

  • Seleziona attività Instructions - 2009 02 05

    

    Instructions - 2009 02 05 File
  • Seleziona attività Assignment - 2009 02 05

    

    Assignment - 2009 02 05 File
  • Seleziona attività Data on employees

    

    Data on employees File
• Seleziona sezione Exam - 03/06/2009

  Minimizza Espandi

  Exam - 03/06/2009

  Exam - 03/06/2009

  • Seleziona attività Instructions - 2009 06 03

    

    Instructions - 2009 06 03 File
  • Seleziona attività Assignment - 2009 06 03

    

    Assignment - 2009 06 03 File
  • Seleziona attività Data on players

    

    Data on players File
• Seleziona sezione Exam - 17/06/2009

  Minimizza Espandi

  Exam - 17/06/2009

  Exam - 17/06/2009

  • Seleziona attività Instructions - 2009 06 17

    

    Instructions - 2009 06 17 File
  • Seleziona attività Assignment - Tables - 2009 06 17

    

    Assignment - Tables - 2009 06 17 File
  • Seleziona attività Assignment - Chart - 2009 06 17

    

    Assignment - Chart - 2009 06 17 File
  • Seleziona attività Data on teams

    

    Data on teams File
• Seleziona sezione Exam - 30/06/2009

  Minimizza Espandi

  Exam - 30/06/2009

  Exam - 30/06/2009

  • Seleziona attività Instructions - 2009 06 30

    

    Instructions - 2009 06 30 File
  • Seleziona attività Assignment - Tables - 2009 06 30

    

    Assignment - Tables - 2009 06 30 File
  • Seleziona attività Assignment - Chart - 2009 06 30

    

    Assignment - Chart - 2009 06 30 File
  • Seleziona attività Data on writers

    

    Data on writers File
• Seleziona sezione Exam - 09/09/2009

  Minimizza Espandi

  Exam - 09/09/2009

  Exam - 09/09/2009

  • Seleziona attività Instructions - 2009 09 09

    

    Instructions - 2009 09 09 File
  • Seleziona attività Data on teams

    

    Data on teams File