Indesign – Create your Poster – Exercice

1- Poster Design Recommendations: Berkeley (PDF)
2- Poster Design Templates: Illinois
3- Choose your colors: Adobe
4- Download Indesign Exercice 1 document files
5- Result:

To do:
1- Lock Object
2- Create text frames
3- Place Method text
4- Create a Drop Cap > Window > Type & Tables > Paragraph Panel
5- Continue text (link) in Results
6- Place USJ logo
7- Place girl
8- Wrap text around girl > Window > Text Wrap > Type: Alpha Channel > Alpha 1
9- Place IPM logo
7- Rotate IPM logo
8- Place Copyrights Image
9- Use Transparency > effects pannel > Transparency
10- Place Table
11- Fill Table
12- Change color and line of Conclusion Box
13- Place and rotate text in Conclusion Box
14- Place Superman – Wrap text around Superman’s frame
15- Flip Superman
16- Create Drop Shadow
17- Create bullet points in Aim
18- Draw Lines
19- Draw Stars > double click polygonal tool
20- Place Copyrights Image
23- Create Circle
24- Position Circle
25- Create Text on Path
26- Create Orange Image Box in Introduction
27- Round Corners
28- Place Image
29- Use Effets
30- Finalize



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

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


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:


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%)


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.