ITW(6587)/ITW(G) (6587)– Semester 1 2015
Assignment 1
Using Microsoft Office Productivity Suite
Due Date: Week 7 Friday 11.30 pm
Submission and Assessment requirements:
This assignment will be marked out of 15 marks and carries 15% mark of the overall mark for the unit. Please check the unit outline for late penalties and resubmissions. This assignment is an individual assignment and not a group assignment.
For details of marking/grading for this assignment, please refer the marking guide available separately.
All submissions need to be electronic submissions through Moodle before the due date. Submission should be one single zip file (A1StudentIDLastName.zip) with saved files and a short report for each project. The report should include steps used to work on each of the project.
All submissions need to be electronic submissions through Moodle before the due date. Submission should be one single zip file (A1StudentIDLastName.zip) with following files in the zipped folder:
• YourStudentID_A1_P1_Report
• YourStudentID_A1_P1_Modified_ Newsletter
• YourStudentID_A1P1_ WorkshopFlyer
• ourStudentID_A1P1_Fax
• YourStudentID_A1P1_Personal_Resume
• YourStudentID_A1P2_ Annual Expenses.xls
• YourStudentID_Assignment Cover Sheet
Project 1: Using Microsoft Word
Problem Focus: Job of a Production Manager for a comic book publisher.
Imagine, you have taken up a new position, as a Production Manager for a comic book publisher, and one of the first project you are involved requires some of the things including: manage publishing schedules, create art and pictures for the comic book, coordinate designers and authors to ensure timely production of the books, select computers for the production team, and manage projects for your organization such as producing newsletters and setting schedules.
So for this assignment task, you will create and/or modify:
1. Microsoft word documents that you might encounter while working as a Production Manager for a comic book publisher.
2. A company newsletter, which includes company and industry news.
3. A flyer to promote an upcoming event for aspiring comic book writers, and a fax cover sheet using a template.
4. Finally, you will include your own personal resume.
For this project, you will need the following files available in Assign1Data.zip in Moodle in Week 2:
1. A1P1_Company_NewsIetter
2. A1P1_Workshop_Text
3. Equity Fax template from Word’s installed templates
4. New blank Word document
You will save your files for Assignment 1 submission in Moodle as:
YourStudentID_A1P1_Modified_ Newsletter
YourStudentID_A1P1_ WorkshopFlyer
YourStudentID_A1P1_Fax
YourStudentID_A1P1_Personal_Resume
The screenshots for the newsletter and workshop flyer are shown below. You can use any other style or images for newsletter and workshop flyer but for the text you need to use the same text provided in Assign1Data.zip in Moodle.
Figure 1: Newsletter screenshot
Figure 2: Woekshop Flyer Screenshot
Project 2: Using Microsoft Excel
Problem Focus: Job of a Marketing Executive for an Entertainment Company
In this job role, as a Marketing Executive for an entertainment company, some of the things you might do are: use Microsoft Excel to plan and track budgets for events, award shows, parties, and tours; plan and budget for computer systems to support marketing events and marketing team members; and use Microsoft Excel to maintain expense records for events and talent contracts. You will normally work with multiple worksheets and enter formulas and functions to calculate totals and other statistics that you might encounter as a Marketing executive for this entertainment company. You will also format cells, insert charts and sparklines, and use Goal Seek in the workbook.
So for this task, using the raw data sheet EventEntertainment.xls, you will develop a workbook that details the expenses you expect to incur during the current year. Using this raw data:
1. Create four worksheets, one for each quarter of the year, and enter your expenses by month.
2. For example, the Quarter l sheet will contain expense information for January, February, and March.
3. Some of these expenses might include, but are not limited to, Mortgage, Rent, Utilities, Phone, Food, Entertainment, Tuition, Childcare, Clothing, and Insurance.
4. Include monthly and quarterly totals for each category of expense.
5. Insert a worksheet that summarizes the total expenses for each quarter.
6. Format the worksheet by adjusting column width and wrapping text, and by applying appropriate financial number formatting and cell styles. Insert a footer with the file name and center the worksheet horizontally on the page.
1. Save your file as YourStudentID_A1P2_ Annual Expenses for Assignment 1 submission in Moodle
For this project, you will need the following files available in Assign1Data.zip in in Moodle in Week 2:
1. A1P2_EventEntertainment.xls
You will save your excel file for Assignment 1 submission in Moodle as: YourStudentID_A1P2_ Annual Expenses.xls.
The four sheets in this excel file need to contain the expenses as shown below:
Sheet 1:
Sheet 2:
Sheet 3:
Sheet 4: