Exercice MS Project 2 + Correction


On veut organiser une rencontre à partir du 10 Juin 2016.


L’équipe chargée des préparatifs est formée des personnes suivantes :

  • 3 administrateurs (A1, A2 et A3) à $50/heure
  • 2 ouvriers (O1 et O2) à $15/jour

Les étapes sont les suivantes :

AVider la salle, grosses œuvres A1, O1, O21 jour (j.)
BInstallation électrique/audioAprès AA3, O12 j.
CInstallation du décorAprès BA2, O21 j.
DTests sonorisation, multimédia, etc.Après A, B et CA1, O1½ j.(placer une deadline pour le 15 juin)
EDébutAprès DMilestoneCommence obligatoirement le 20 Juin
FPrésentation des équipesAprès EA21j.
GWorkshop 1Après FA1, A33j.
HWorkshop 2Commence un jour après GA3, A22j.
IDiscussionsSe termine avec G et HA1, A3, A21j.
JDéjeunerAprès I1h.Va coûter $50 par personne
KConclusionsAprès le déjeunerA1, A2, A3, O1, O21h.
Fin du projetAprès K Milestone


Questions (répondre dans les notes de la dernière tâche) :

  1. Coût du projet
  2. Date de fin du projet
  3. Y-a-il un suremploi ? pour quelles tâche(s) et pour quelle personne(s) ?
  4. Le deadline de la tâche D sera-t-il respecté ? Expliquer.

Corrigé au format MPP (Zip): corrige-ex2

Facebooktwitter Facebooktwitter

Excel Advanced – Exercice 1

  • Convert to table – rename TBLOrders
  • Calculate Sales = @orderquantity x @unitprice
  • Calculate productstotals = @sales * (1-@discount)
  • AfterShipping = products total + shipping cost
  • use Floor and Ceiling formulas
  • Go to tax sheet –> change color sheet to red
  • Convert to table TBLTax
  • Vlookup (@province, TBLTax, 2, False)
  • TTC = after shippint * (1+tax)
  • Rename cell in variables sheet VCoursUSD
  • TTCLBP = @ttc * VCoursUSD
  • Profit = products total – sales (1 – product base marging)
  • Go to sheet customers
  • convert to table TBLCustomers
  • Data > Remove Duplicates
  • Create Colum Sales = Sumif(tblorders[customer name], A2, TBLorder[Ttc])
  • Create a Total Row
  • In TBLOrders create a total row > Compare Values
  • Go to Tax Sheet
  • Sum of Tax in new cell = sum(tblOrders[tax])
  • Count of orders in a new cell = count(tblOrders[order id])
  • Filter TBLorders for Pat Farhout
  • Copy columns “order date”, sales person, sales
  • Create a new sheet “Pat Farhout”
  • Paste values
  • Convert to table TBLPatFarhout
  • insert a pivot table in cell
    • Area: TBLPatFarhout
  • check Order Date
  • Check Sales
  • Drag sales > value fields settings (create count and average)


  • Use columns/rows wide functions
  • Use sheet wide functions
  • Choose function
  • Match / iferror
  • Index
  • Index – Match combination


Facebooktwitter Facebooktwitter

Audacity Exercice Files and Link to Tutorials




  • Open Audio File
  • Play (use the selection tool)
  • Zoom in and out
  • Use the shift tool
  • Use the envelope tool
  • Select and Delete (delete key on Keyboard) or “cut” from the toolbar
  • Select, Edit > Clip Boundaries > Split and Split New
  • Edit > Remove special > Trim audio (removes all but selected)
  • Generate Silence (useful for effects such as echo), Noise or Tone
  • Effects > Amplify (negative or positive), Reverse,  Change pitch (F to A), Change Speed…
  • Add label track (ctrl+B), add labels (ctrl+B)
  • Silence track
  • Remove track (“x” to the left of the track’s name)
  • Export
  • Optional: Create a new track, record your voice

Exercice Files:


Facebooktwitter Facebooktwitter

Photoshop Blend Modes

Groups of blend modes:

  • Normal:
    • Normal
    • Dissolve: treats transparency as a pixel pattern and applies a diffusion dither pattern
  • Darken:
    • Darken: If the pixels of the selected layer are darker than the ones on the layers below, they are kept in the image.
    • Multiply (commonly used): Works by multiplying the luminance levels of the current layer’s pixels with the pixels in the layers below.
    • Color Burn: Darker than Multiply, with more highly saturated mid-tones and reduced highlights.
    • Linear Burn: Darker than Multiply, but less saturated than Color Burn.
    • Darker Color: Darkens on the composite channel, instead of separate RGB color channels.
  • Lighten:
    • Lighten: If the pixels of the selected layer are lighter than the ones on the layers below, they are kept in the image
    • Screen (commonly used): Brighter than “lighten” and removes more of the dark pixels, and results in smoother transitions.
    • Color Dodge: Results in intense high-contrast colors.
    • Linear Dodge (Add): Brighter than the Color Dodge blend mode, but less saturated and intense.
    • Lighter Color: Similar to the Lighten blend mode, but lightens on the composite channel, instead of separate color channels.
  • Contrast:
    • Overlay (commonly used): Uses a combination of the Screen blend mode on the lighter pixels, and the Multiply blend mode on the darker pixels.
    • Soft Light (commonly used): Uses a combination of half-strength application of Screen blend mode on the lighter pixels, and a half-strength application Multiply blend mode on the darker pixels
    • Hard Light: Uses a combination of the Linear Dodge blend mode on the lighter pixels, and the Linear Burn blend mode on the darker pixels.
    • Vivid Light: Uses a combination of the Color Dodge Mode on the lighter pixels, and the Color Burn blend mode on the darker pixels.
    • Linear Light: Uses a combination of the Linear Dodge blend mode on the lighter pixels, and the Linear Burn blend mode on the darker pixels
    • Pin Light: Uses a combination of the Lighten blend mode on the lighter pixels, and the Darken blend mode on the darker pixels
    • Hard Mix: Uses the Linear Light blend mode set to a threshold, so for each RGB color channel, pixels in each channel are converted to either all black or all white.
  • Inversion:
    • Difference: With this blend mode, similar colors cancel each other, and the resulting color is black.
    • Exclusion: Similar colors cancel each other, the resulting color is gray instead of black.
  • Cancellation:
    • Substract: Similar colors cancel each other, and the resulting color is black
    • Divide: Similar colors turn white, with the exception of blacks.
  • Component
    • Hue: You get the hue of the top level layer.
    • Saturation: Keeps the saturation of the top level layer.
    • Color: Same as hue but with the luminance of the lower layers.
    • Luminosity: Keeps the luminance of the active layer, and blends it with hue and saturation (the color) of the composite view of the layers below.

In Bold: modes that look different if fill or opacity is selected (other modes will look the same for e.g. opacity=50% or fill=50%)


Facebooktwitter Facebooktwitter

Facebook Friends Social Graph Using NetVizz and NodeXL

This post is available as a PDF document.


  • In Facebook, search for the NetVizz application or follow this link:1


  • Accept the permissions required to extract data from your timeline and pages


  • Select “personal network”:


  • Click on “start”:
  • Right click on “gdf file” and save it
  • Download and Install NetVizz to NodeXL converter
  • Run NetVizz to NodeXL converter
  • Select the Import from (GDF) and Export to (GraphML) files
  • 1
  • Make sure you have the right file names and click start
  • Open a new NodeXL file
  • From the NodeXL tab, select Import, select “from GraphML file” and select the file generated by NetVizz to NodeXL converter
  • 2
  • Generate the NodeXL graph.

Match IDs with Names in the Edges Sheet

NetVizz uses Facebook IDs instead of names. In order to create two columns. Use the following formulas to add lookup columns to the table:

– =VLOOKUP([@[Vertex 1]],Vertices[[Vertex]:[Label]],8,FALSE)

– =VLOOKUP([@[Vertex 2]],Vertices[[Vertex]:[Label]],8,FALSE)

Explanation: Look for the value of vertex 1 (or 2) in the first column (always) of the table Vertices (from column Vertex to Column Label) and get the value in the 8th column. False means that Excel should look for an exact match.





Facebooktwitter Facebooktwitter

Introduction to Social Graph and NodeXL

This post is available as a PDF document.

Why do we study social networks?

Definition from: http://en.wikipedia.org/wiki/Social_network: A social network is a social structure made up of a set of social actors (such as individuals or organizations) and a set of the dyadic ties between these actors. Social networks and the analysis of them is an inherently interdisciplinary academic field which emerged from social psychology, sociology, statistics, and graph theory.


From http://en.wikipedia.org/wiki/Sociometry: “Sociometric explorations reveal the hidden structures that give a group its form: the alliances, the subgroups, the hidden beliefs, the forbidden agendas, the ideological agreements, the ‘stars’ of the show”.


In social networks (like Facebook and Twitter), sociometry can help us understand the diffusion of information and how word-of-mouth works (virality).

Installing NODEXL (Microsoft Excel required)

NodeXL Template 2014


The SocialNetImporter extends the capabilities of NodeXL mainly with extracting data from the Facebook network. To install:

  • Download the latest version of the social importer plugins from http://socialnetimporter.codeplex.com
  • Open the Zip file and save the files into a directory you choose, e.g. c:\social
  • Open the NodeXL template (you can click on the Windows Start button and type its name to search for it)
  • Open the NodeXL tab, Import, Import Options (see screenshot below)


  • In the import dialog, type or browse for the directory where you saved your social importer files (screenshot below):



  • Close and open NodeXL again


For older Versions:

  • Visit http://nodexl.codeplex.com
  • Download the latest version of NodeXL
  • Unzip the files to a temporary folder
  • Close Excel if it’s open
  • Run setup.exe


  • Visit http://socialnetimporter.codeplex.com
  • Download the latest version of the socialnetimporter plug in
  • Extract the files and copy them to the NodeXL plugin direction. Defaults to C:\Program Files\Social Media Research Foundation\NodeXL Excel Template\PlugIns

First steps with NodeXL

The following table is a matrix showing trust within a group of 6 people. An “X” in a cell means that the person who’s name is in the cell’s row trusts the person who’s name is in the cell’s column


Because trust is not automatically reciprocated (Ann trusting Bob does not necessarily mean that Bob trusts Ann), the graph that we will build will be directed.


A directed graph implies that the edges (links) between two vertices (in our example, people) have a direction: A B. An example of a directional graph is Twitter. In Twitter, you can follow a person that does not follow you and vice-versa.


In an undirected graph, the edge is reciprocated. This means that, if you have a connection to a person, this person has the same connection towards you. An example of an undirected graph is Facebook: if A is a friend of B then, automatically, B is a friend of A.

Running NodeXL

  • In the Windows Start menu, click “All Programs”, then “NodeXL,” then “Excel Template.” (in Windows 8, open the tile menu and type “nodexl” to search and find the program)
  • Notice the new “NodeXL” tab in the Ribbon:


Drawing your first network graph

Open the vertices sheet and enter the name of the persons from the social matrix provided (above):


Go to the edges sheet and enter the name of the trusting person in the Vertex 1 column and the name of the trusted person in Vertex 2.


On the new NodeXL tab, define the graph as “directed”.


Click the “show graph” button for a visual representation of your graph:


Copy the names in the Label column and refresh your graph to have the names displayed next to the vertices:



To replace vertices with images, copy and paste photo links (from Facebook profile photos or elsewhere) into the image column and define the shape (in the shape column) as “Image”:


Refresh the graph:


Analyzing Data

To calculate the metrics from the graph, go to the NodeXL tab and click on “Graph Metrics”:


Click on the “Select All” button and “calculate metrics”:


Understanding Metrics

In the Vertices sheet, scroll the right to display the metrics columns:


  • In degree: most trusted person (Edna, Bob). It is a count for the number of “arrows” that link to the person (people who trust the vertex).
  • Out degree: most trustful (Edna, Fred, Claire). It is a count for the number of “arrows” that go out from this person (how many people are trusted by the vertex).
  • Prestige is a metric you can choose to calculate yourself, it is the number of links to the person divided by the total number of possible links (in this example, the maximum would be 5 links or 5 people trusting the 6th person). A prestige of 1 means that “everyone trusts the vertex”


  • Betweeness centrality (Centralité d’intermédiarité) : A high number means that the person is in a central position in the graph. This metrics is based on the shortest paths between all people in the graph. It measures how important a node is by counting the number of shortest paths that it is a part of.

how many pairs of individuals would have to go through the vertex in order to reach one another in the minimum number of hops?



  • Closeness Centrality (Centralité de proximité) : who has faster access to information (in case of information diffusion). This number is an evaluation of the average distance to all nodes in the network.

What if it is not so important to have many direct friends? or be “between” others. Yet, one still wants to be in the “middle” of things, not too far from the center.



  • Eigenvector Centrality (Centralité vectorielle) : Eigenvector centrality calculates the position of a node to all other nodes in the network by giving a weight based on the distance (La centralité vectorielle essaie de mesurer l’importante ou l’influence d’un nœud dans le réseau en donnant un poids relatif à chaque lien du réseau. L’idée étant que la centralité d’un nœud est égale à la centralité des liens auxquels il est rattaché. à on tient compte de l’importance des liens auquel il est attaché). It is different from betweeness centrality in the sense that it considers all paths between nodes, not only the shortest one.

Eigenvector Centrality measures the importance of a node by the importance of its neighbors.


Eigenvector centrality is a measure of the influence of a node in a network. It assigns relative scores to all nodes in the network based on the concept that connections to high-scoring nodes contribute more to the score of the node in question than equal connections to low-scoring nodes


  • Centralité de Katz and page rank: Alors que le degré de centralité mesure le nombre de liens adjacents, la centralité de Katz mesure tous les nœuds qui peuvent être connectés à travers un chemin en pénalisant les nœuds distants.


Katz and Page Rank Centrality are a median solution between degree centrality (shortest paths) and eigenvector centrality (all paths) as they measure the number of all nodes that can be connected through a path, while the contributions of distant nodes are penalized.


  • Clustering coefficient : The clustering coefficient is a measure of an “all-my-friends-know-each-other” property. If the value of the Clustering Coefficient is equal to 1, this means that each of my friends is friend with all the others.


  • Reciprocated vertex pair ratio: reciprocated vertex pair ratio: ratio between ingoing and outgoing connections (only valid in directed graphs).





Facebooktwitter Facebooktwitter

NetVizz to NodeXL converter

This is a small conversion tool I have developed to convert NetVizz files (GDF) to NodeXL files (GraphML).


This tool works on all versions of Windows and has been tested with the “personal network” friends list extraction option in NetVizz.


NetVizz is a free Facebook App located at https://apps.facebook.com/netvizz/. NetVizz extracts Facebook data from personal timelines and pages.


NodeXL is a free, open-source template for Microsoft® Excel® 2007, 2010 and 2013 that makes it easy to explore network graphs. It can be downloaded from nodexl.codeplex.com.


NetVizz (GDF) to NodeXL (GraphML) is freeware.

Current Version:

NetVizz2NodeXL 2.0 Setup file for Windows

– Extracts field titles from GDF file

– Now with a progress bar

Earlier Versions:

NetVizz2NodeXL 1.0 setup file for Windows


Facebooktwitter Facebooktwitter

Exercice 3 – Photoshop

Easy drawing effect
1- Gaussian Blur > Strong
2- Edit > fade Gaussian Blur
3- Filter> Artistic > Poster Edges

Particule dispersion effect
1- Extract Woman
2- Dup. layer
3- Filter > Liquidify
4- Create Masks for both layers
5- Black on first
6- White on second

Photo pop-up effect
1- create a small rectangle selection under the subject
2- create an empty layer “frame”
3- edit stroke – white – inside
4- edit > transform > perspective
5- fill in black outside the frame
6- select the subject
7- use

Caricature effect
1- Create a white layer
2- transparency of the white layer
3- create a transparent layer
4- draw on the transparent
5- fill the colors
6- use dodge and darken

Exercices – Fichier Zip

Facebooktwitter Facebooktwitter