PROJ587 Course Project - Amazon
unknown_person
Program_Communication_Matrix_Sample.xlsxInstructions
| COMMUNICATIONS MATRIX | |
| Column | Instructions For Completing This Document |
| Complete the program name, NC, program manager name, and program description fields. | |
| For each identified communication, complete the following. | |
| A | ID: This field should have a unique ID number used to identify the communication within the communication matrix. |
| B | Communication: This column should be populated with a description of the type of communication that will be conducted. |
| C | Target Audience: This field should be populated with a description of the target audience for this communication vehicle. |
| D | Description/Purpose: This field should be populated with a description of the purpose of the communication. |
| E | Frequency: This field should be populated with the frequency of which the communication will be distributed. |
| F | Owner: This field should be populated with the name of the owner of the communication. |
| G | Distribution Channel: This filed should be populated with the type of distribution vehicle that will be used to disseminate the communication. |
| H | Internal/External: This field should indicate if the communication is for internal, external, or both internal and external distribution. |
| I | Comments: This column should be populated with any additional comments. |
| Column | Instructions For Changing the Contents of Drop-Down Menus |
| E, F | Highlight the cell of which you wish to change the content of the drop down menu. From the file menu, click Data -> Validation and change the content of the source field. OR Click Format -> Sheet -> Unhide -> DropDown_Elements. Add/Change the appropriate values. Click Format -> Sheet -> Hide. |
| Column | Instructions For Filtering Data |
| Any | Highlight the header of the cell you wish to filter data on. From the file menu, click Date -> Filter ->Auto Filter. Then select your filter criteria from the drop-down menu that appears on your header cell. |
Communication_Plan
| COMMUNICATIONS MATRIX | ||||||||
| Program Name: | <optional> | |||||||
| Program Manager Name: | <required> | |||||||
| Program Description: | <required> | |||||||
| ID eze3: • ID: A unique ID number used to identify the communication within the communication matrix. | Communicaton
eze3: • Communication Vehicle: This column should be populated with a description of the type of communication that will be conducted | Target
Audience eze3: • Target Audience: This field should be populated with a description of the target audience for this communication vehicle. | Description/Purpose eze3: • Description/Purpose: This field should be populated with a description of the purpose of the communication. | Frequency eze3: • Frequency: This field should be populated with the frequency of which the communication will be distributed. | Sender eze3: • Owner: This field should be populated with the name of the owner of the communication. | Distribution
Channel e: Distribution Vehicle: This filed should be populated with the type of distribution vehicle that will be used to disseminate the communication. | Internal /
External? e: Internal/External: This field should indicate if the communication is for internal, external, or both internal and external distribution. | Comments eze3: • Comments: This column should be populated with any additional comments. |
| 0 | Weekly status report | Program team | Communicate updated Program status | Weekly | John Doe | Email attachment | Internal & external | |
&"Arial,Bold"&8UP Template Version:&"Arial,Regular" 11/30/06 &8Page &P of &N
DropDown_Elements
| Frequency | Internal_External | Distribution Channel | ||
| Daily | Internal Only | |||
| Weekly | External | Email Attachment | ||
| Bi-Weekly | Internal & External | Team Site Document Post | ||
| Monthly | Intranet Announcement | |||
| Bi-Monthly | Report on PMIS | |||
| Quarterly | Email Attachment & Post on PMIS | |||
| Semi-Annually | Newsletter | |||
| Annually | ||||
