Nasri Messarra

Exercice

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 :

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

• 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

Sample_Excel_Data

Tutorials:

• Audacity, mode d’emploi (other link)
• Official Tutorials
• Podcasters tutorial (videos)
• Podcaster tutorial (PDF)

Exercice:

• 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:

Exercice-1

• Open Wall
• Duplicate wall as new “displacement” document
• Gaussian blur the displacement (try 2 pixels)
• Distort and displace the flag (7×7 with repeat edge)
• Reduce opacity to 60%
• Make a copy of the wall
• Select the black color in the openings in the wall and turn it into a mask

Displacement files

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

Portrait-blendLR