Scribd Logo
Upload

Welcome to Scribd!

  • 127 views

    MDE - IT Project Plan

    Uploaded by

    chuongnv
    The document provides instructions for using a simple Excel spreadsheet template to develop project plans. It describes the columns in the template for listing tasks, responsible parties, and timelines. The template includes up to 25 tasks that can be scheduled per page across multiple months. Additional pages can be added by copying existing pages. The document also provides an example project plan template that has been filled in as an illustration.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as XLS, PDF, TXT or read online from Scribd

    MDE - IT Project Plan

    Uploaded by

    chuongnv
    127 views7 pages
    The document provides instructions for using a simple Excel spreadsheet template to develop project plans. It describes the columns in the template for listing tasks, responsible parties, and timelines. The template includes up to 25 tasks that can be scheduled per page across multiple months. Additional pages can be added by copying existing pages. The document also provides an example project plan template that has been filled in as an illustration.

    Original Title

    MDE_IT Project Plan

    Copyright

    © Attribution Non-Commercial (BY-NC)

    Available Formats

    XLS, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document provides instructions for using a simple Excel spreadsheet template to develop project plans. It describes the columns in the template for listing tasks, responsible parties, and timelines. The template includes up to 25 tasks that can be scheduled per page across multiple months. Additional pages can be added by copying existing pages. The document also provides an example project plan template that has been filled in as an illustration.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as XLS, PDF, TXT or read online from Scribd
    Download as xls, pdf, or txt
    127 views7 pages

    MDE - IT Project Plan

    Uploaded by

    chuongnv
    The document provides instructions for using a simple Excel spreadsheet template to develop project plans. It describes the columns in the template for listing tasks, responsible parties, and timelines. The template includes up to 25 tasks that can be scheduled per page across multiple months. Additional pages can be added by copying existing pages. The document also provides an example project plan template that has been filled in as an illustration.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as XLS, PDF, TXT or read online from Scribd
    Download as xls, pdf, or txt
    You are on page 1of 7

    IT Project Plan INSTRUCTIONS

    MDE_IT Project Plan.xls

    Description: Use this simple Excel spreadsheet to help you develop a project plan. You don't
    have to be a Microsoft Project expert to develop great project plans. In fact, you may find this tool to be
    more acceptable to most of your clients that don't have M/S Project. I have used this template
    hundreds of times over that past 25 years, even before electronic spreadsheets were available.

    There are two blank templates in the Project tab and an example is included in the Example tab. If you want
    a more detailed plan example, refer to the IT Systems Conversion Plan tool in this ToolKit.
    Project management is discussed in much more detail in the IT Project Management book of the
    IT Manager Development Series. Additional information is at www.mde.net/cio.

    Instructions:
    The columns are:
    - Line Number (for reference as needed; there are up to 25 tasks per page)
    - Task (individual tasks to be completed. It helps to list them by major groups (Ordering, Training, etc.)
    - Responsibility (initials of the responsible party. This person is who the project team looks to for
    completing the task, not necessarily who actually completes the task)
    - Months
    - Five columns for every month in case of 5 weeks in the month
    - I use the Friday, week ending date - this helps me know what needs to be accomplished by the
    end of the work week.

    Project Plan - Initial Setup:


    1. Fill in the Project Name
    2. Fill in the Project Manager name and contact information (E-mail, phone number, etc.)
    3. Fill in the month at the top of the columns (JAN, FEB, AUG, etc.)
    4. Fill in the week ending dates for each weekly column. There are five columns to handle 5-week months.
    5. List the tasks and responsible person for each task.
    6. Place a slash mark "/" in the cell of the week that the task should be completed.
    7. List the resource participants and their initials at the bottom of the first page for reference.

    Project Plan - Update Steps:


    1. For each task that is completed, change the slash to an "X"; move the slash mark as needed if certain
    tasks need to move out.

    Other:
    - To add additional sheets, simply cut and paste an entire page.
    - Different printer models will print EXCEL spreadsheets differently. You may have to play with the
    spreadsheet a bit to get the entire page to print on a single 8x10 piece of paper
    Page 2
    MDE Enterprises
    8/18/2010
    Project: Month-1 Month-2 Month-3 Month-4
    Proj. Mgr.:

    ACTIVITY Resp.
    1
    2
    3
    4
    5
    6
    7
    8
    9
    10
    11
    12
    13
    14
    15
    16
    17
    18
    19
    20
    21
    22
    23
    24
    25

    REMARKS:

    IT manager tools to achieve more - www.mde.net/cio

    MDE Enterprises
    Page 3

    Project: Month-1 Month-2 Month-3 Month-4


    Proj. Mgr.:

    ACTIVITY Resp.
    1
    2
    3
    4
    5
    6
    7
    8
    9
    10
    11
    12
    13
    14
    15
    16
    17
    18
    19
    20
    21
    22
    23
    24
    25

    REMARKS:

    IT manager tools to achieve more - www.mde.net/cio


    Page 4

    th-4 Month-5

    1
    2
    3
    4
    5
    6
    7
    8
    9
    10
    11
    12
    13
    14
    15
    16
    17
    18
    19
    20
    21
    22
    23
    24
    25
    Page 5

    th-4 Month-5

    1
    2
    3
    4
    5
    6
    7
    8
    9
    10
    11
    12
    13
    14
    15
    16
    17
    18
    19
    20
    21
    22
    23
    24
    25
    Page 6
    MDE Enterprises
    8/18/2010 Example
    Project: New PC Setup (Project Example) JAN FEB MAR APR
    Proj. Mgr.: Roger Rabbit

    ACTIVITY Resp. 5 12 19 26 2 9 16 23 2 9 16 23 30 6 13 20 27
    1 I. Order
    2 A. Order PC, monitor, and printer BB X
    3 B. Order M/S Office & Marketing Database Software BB X
    4 C. Order paper, special forms, diskettes BB X
    5
    6 II. Installation
    7 A. Install PC & monitor YS X
    8 B. Load software YS X
    9 C. Install printer YS X
    10
    11 III. Training
    12 A. MS Office training RR /
    13 B. Marketing Database Software training MM /
    14
    15 IV. Client Prospect Database
    16 A. Create prospect database WC / --- /
    17 B. Test mass mail merge capabilities of database with MS WORD document WC /
    18 C. Create prospect letter WC /
    19 D. Create mass mail to top 1000 prospects WC /
    20
    21
    22
    23
    24
    25

    REMARKS:
    BB - Bugs Bunny
    YS - Yosemite Sam
    RR - Roger Rabbit
    WC - Wylie Coyote
    MM - Mickey Mouse (Outside Vendor of Marketing Software)

    IT manager tools to achieve more - www.mde.net/cio


    Page 7

    MAY

    4 11 18 25
    1
    2
    3
    4
    5
    6
    7
    8
    9
    10
    11
    12
    13
    14
    15
    16
    17
    18
    19
    20
    21
    22
    23
    24
    25

    You might also like