Nasri Messarra

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

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