Exercice MS Project – 2016/11

Quatre amis, Chris, Nagi, Hani et Joe, décident de lancer une application mobile sur le marché. Ils se proposent de commencer le 1er Décembre 2016.
Le tarif horaire des 4 partenaires est le suivant:

Chris: $100/heure

Nagi: $100/heure

Hani: $75/heure

Joe: $50/heure
Analyse et Réflexion:

Cahier de charge, Chris, 4 jours.
Schéma de l’application, suit la tâche Cahier de charge, 4 jours, Chris et Nagi.
Réunion des 4 partenaires, suit la tâche Schéma, durée 1 jour.
Réunion avec un expert des applications mobiles, suit la tâche Réunion des 4 partenaires, Chris et Nagi. Durée: 1 jour. L’expert touche $1500 par jour.
Placer un milestone après la réunion avec l’expert

Structure de la société (vient après l’étape Analyse et Réflexion):

Réunion avec l’avocat, 1 jour, l’avocat touche $3,000 par jour, Chris et Nagi.
Fondation de la société, une semaine après la réunion avec l’avocat, $20,000 (coût fixe), durée 2 jours.
Installation des locaux, commence après la réunion avec l’avocat, Chris et Nagi, durée 10 jours.
Ecriture du business plan, 3 jours, Chris, doit se terminer en même temps que l’installation des locaux.
Mettre un milestone qui a lieu lorsque la Fondation de la société ET l’écriture du business plan sont achevés.

Développement (après l’étape structure de la société):

Développement de l’app pour iPhone, Joe, 2 semaines. A cause des engagements de Joe, cette étape ne peut commencer avant le 25 décembre 2016 – Joe et Hani.
Développement de l’app pour Android, Nagi, 2 semaines, commence 1 semaine après le démarrage de la tâche “Développement de l’app pour iPhone”
Placer un milestone à la fin des deux étapes.
Il est demandé de:

Dessiner le Gantt Chart du projet
Déterminer le coût total du projet (le placer dans une note au niveau du dernier milestone)
Placer une deadline pour le dernier milestone pour le 30 janvier 2017. Ce deadline sera-t-il respecté?

Enregistrez vos travaux sur le desktop sous le nom GRH-TPC14-votre matricule.


Solution (étapes les plus importantes):

1. Passer en mode automatique:

1b

2. Dans Projet > Project Information, saisir la date de début:

2

3. Saisir le nom et les salaires des RH dans la page “Resources Sheet”:

3

4. Saisir les tâches et leurs spécificités dans le Gantt-Chart:

4

5. Double Cliquer sur la tâche “App iPhone” et saisir la contrainte:

5

6. Saisir la deadline de la dernière tâche:6

7. Allez dans Project > Project Information > Statistics pour déterminer le coût. Copiez ce coût dans les notes de la dernière tâche:

7


Solution au format MPP

Exercice MS Project 2 + Correction

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 :

EtapeNomConditionsRHDuréeParticularités
Préparation
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)
Rencontre
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

Sample_Excel_Data

Audacity Exercice Files and Link to Tutorials

Tutorials:

 

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

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

Portrait-blendLR

Adobe CC Lousy Support

I have been trying to purchase an Adobe CC subscription for a year. Have 5 Chat conversations saved. Five open unresolved cases (#0216387593, #0216537262, #0216098627, #0216098411, #0216098835) that have been open for months. Over an hour of useless phone conversation with Adobe Support. If you search for the error message below, you will find more than 170 pages of complaints.

Because Adobe Support s***, I have decided to post the transcript of my last chat:

 

Sangita: Hello! Welcome to Adobe Customer Service.

Sangita: Hello

nasri: Hello

Sangita: I understand that you want to update your credit card details, is that right?

nasri: not really. all my orders are getting rejected but we can try this. is there a way I can enter my cc first and then order?

Sangita: I understand that you are unable to place a new order, is that right?

nasri: all details follow:

nasri: I have been desperately trying to purchase an Adobe CC subscription for more than a year. I spent countless hours with an incompetent support team both at Adobe and Digital River on the phone, by email and online support (chat). I have subscription at Lynda.com, prezi & others. I pay with my credit cards for Facebook, Microsoft, Amazon, Apple, Play store and others. If you search for the below message at Google, you will find that many people in Lebanon and the MEA have the same problem. I am a teacher at the Saint-Joseph University in Beirut, Lebanon (USJ) and this is my last attempt to purchase a subscription for Adobe CC teacher’s edition before downloading a pirated version on the Internet. My id is: [hidden]@usj.edu.lb The error message follows also attached (by the way, I set the currency to USD and it reverts automatically to LBP. I set the language to English and it reverts to French???): Un problème est survenu lors du traitement de votre commande. Veuillez contacter le service clientèle pour obtenir de l’aide.Bahreïn: 80081097Egypte: 08000000447Jordanie / Koweït / Liban / Qatar / Yémen: Anglais +44 207 365 0735Jordanie / Koweït / Liban / Qatar / Yémen: Arabe / Français +44 203 564 4145Oman: 80077173Arabie Saoudite: 8008446638Tunisie, Maroc et Algérie: +33 157324642Emirats Arabes Unis: 80004443085

nasri: I have been trying to get help for more than a year!!!!

Sangita: I understand how frustrating it is when things do not work accordingly.

Sangita: I am sorry for the inconvenience caused to you.

Sangita: I will be glad to check and help with this regard.

Sangita: May I please have your email address registered with Adobe?

nasri: [hidden]@usj.edu.lb

Sangita: Thank you for confirming.

Sangita: May I have the exact error message you are getting while placing the order?

nasri: Un problème est survenu lors du traitement de votre commande. Veuillez contacter le service clientèle pour obtenir de l’aide.Bahreïn: 80081097Egypte: 08000000447Jordanie / Koweït / Liban / Qatar / Yémen: Anglais +44 207 365 0735Jordanie / Koweït / Liban / Qatar / Yémen: Arabe / Français +44 203 564 4145Oman: 80077173Arabie Saoudite: 8008446638Tunisie, Maroc et Algérie: +33 157324642Emirats Arabes Unis: 80004443085

Sangita: Thank you for the information.

Sangita: May I place you on hold for the next 2-3 minutes so that I can research on this issue?

nasri: ok

Sangita: Thank you for staying online.

Sangita: I am sorry for the delay.

Sangita: Please reach out to our Technical Support at United Kingdom: 0207 365 0735 |Ireland: 01 242 1552 |Belgium: 027119960 between Monday to Friday 9 AM to 5 PM GMT for assistance. You can find the support options on http://helpx.adobe.com/uk/support.html

Sangita: Sorry for the above typo.

Sangita: Please call our Sales Support at 0800 028 0148 Monday to Friday 9 AM to 5 PM Australian Time for assistance. You can also find the product catalog on http://www.adobe.com/uk/products/catalog.html

Sangita: Are we still connected?

nasri: I called support twice. spent more than 40 minutes on the phone. they didn’t help.

Sangita: In that case, you can try placing the order again with the below link.

nasri: They put the blame on the 4 banks I deal with and I am sure there is nothing wrong with my credit cards that I use with amazon, lynda, facebook, microsoft.

nasri: Also tried that.

Sangita: Click here

nasri: I already tried this link 10 times: previous chats.

Sangita: I am sorry, please reach the phone support number for further help as you are not able to place the order.

nasri: I have an open case no one is answering and you don’t have a representative in Lebanon and I can’t buy from the US store because I have an edu.lb (.lb=lebanon) account.

Sangita: Is there anything else I can help you with?

Sangita: I am sorry for the inconvenience caused to you.

nasri: Yes, you can send this chat to management and tell them I am going to download a pirated version of adobe CC.

info: Your chat transcript will be sent to [hidden]@usj.edu.lb at the end of your chat.

Sangita: Please reach the phone support number they will help you with the placing the new order.

nasri: I already tried this. and they didn’t help. what part of this message don’t you understand?

nasri: Do you have a customer complaint service?

Sangita: This may be a temporary issue, please try to reach them again.

nasri: I have been trying for a year.

Sangita: Yes, I understand.

nasri: I don’t want to talk to support anymore. Is there a way to send a complaint to someone who can do something about this?

Sangita: But there is nothing much I  can do about it.

Sangita: You can try reaching our phone support number  for further help.

Twitter double authentication and security via SMS

A few months ago, I posted two tutorials about login approvals via SMS on Facebook and two-step verification on Google.

In this walk through, you will find the steps required to do the same on Twitter. Once these steps are performed, a secret numeric code will be sent to your phone by text message (SMS) every time you or someone else tries to log in to your Twitter account. This code will be required with your password to authenticate you and allow you to log in and access your account.

1- Login to your Twitter Account

2- Go to Settings

1

3- Click on security and privacy on the menu (left). If you already have a phone linked to your account, skip to step 5. Otherwise, you should see an “add phone” link:

4

4- Click on add a phone and type your phone number. You should receive a code by sms to verify your phone number.

6

5- Once you have linked your phone number to your Twitter profile, check “send login verification requests to #your phone number#”. Note that you can also choose to send verification codes to your phone via the Twitter app (rather than by text messages / sms) if it’s already installed on your phone.

2