ITW(6587)/ITW(G) (8520)– S2 2015
ITW Assignment / Project
Due Date: Week 11 Friday 11.55 pm
Submission and Assessment requirements:
This assignment will be marked out of 40 marks and carries 40% 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
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 following files in
the zipped folder:
• YourStudentID_LastName_Modified_ Newsletter.doc
• YourStudentID_LastName_GoogleCloud folder
• YourStudentID_Assignment Cover Sheet (available in Moodle)
Project 1 (P1): Using Microsoft Word (4 marks)
Refer Week 2 Tutorial/Lab for help
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
So for this assignment task, you will create and/or modify Microsoft word documents that
you might encounter while working as a Production Manager for a comic book publisher. For
this assignment task, you will
1. Create a company newsletter, which includes company and industry news, and
2. Create a flyer to promote an upcoming event for aspiring comic book writers
For this project, you will need the following files available in Assign_P1_data folder in
Assign_Data.zip in Moodle.
You will save your files for Assignment 1 submission in Moodle as:
YourStudentID_LastName _Modified_ Newsletter
The screenshots for the newsletter and workshop flyer you will produce 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 AssignData.zip in Moodle.
Figure 1: Newsletter screenshot
Figure 2: Workshop Flyer Screenshot
Project 2: Using Microsoft Excel (4 marks)
Refer Week 3 Tutorial/Lab for help
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 Assign_P2_EventEntertainment.xls available in
Assign_P2_data folder, you will complete some of the following calculations and update the
1. Update the total expenses column which is a sum of expenses of all quarters.
2. Summarize the expenses for each quarter by updating the row 12 of the worksheet
3. Do other modifications by looking at the screenshots of each worksheet shown below.
4. 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.
5. Save your file as YourStudentID_EventEntertainmentBudget.xls for Assignment
submission in Moodle
Project 3: Using Microsoft PowerPoint (4 marks)
Refer Week 4 Tutorial/Lab for help
Job Focus: Sales Manager of a Sports Store called “Front Range Action
In this job, your role is to showcase the products of your store, the main events you have
sponsored, and partnering of charity events, and other products in your store. The text and
pictures you have to use is available in Assign_P3_data folder in Assign_Data.zip. Your
submission should be a PowerPoint presentation with 9-10 slides, using the data provided,
and named as YourStudentID_LastName.ppt. The screenshot of the sample slides is as shown
below. If the images in the data folder are not sufficient to obtain the slides shown below, you
can use any free images available or cite the reference from where you obtained the image.
Project 4: Using Microsoft Access (4 marks)
Refer Week 5 Tutorial/Lab for help
Job Focus: HR Manager of an Organisation.
In this job, your role is to maintain the database of all student employees of your organisation
in Microsoft Access Database and run queries and prepare reports for presenting it to Senior
Management on request. You will use the raw data available as two excel spreadsheets data,
in Assign_P4_data folder.
You need to run several queries and reports using the raw data in the folder, and details of
these queries are provided AccessProject_StudentInstructions.doc in the same raw data
folder. After completing all the queries and reports. Submit the Microsoft Access file as
YourStudentID_Lastname.mdb in Moodle.
Project 5: Cloud Computing using Google (4 marks)
Refer Week 6 Tutorial/Lab for help
Job Focus: Operations Manager of a Car Dealership Firm
In this job, your role is to co-ordinate different activities of the firm including maintenance
activities, food and beverage stocks etc. request. You will use the raw data (Assign_P5_data)
available as excel spreadsheet data, in Assign_P5_data folder.
You need to work with Google cloud tools, and details of the different operations you have to
do with the Google cloud tools are provided in GoogleCloudStudentInstructions.doc in the
same raw data folder. After completing all the activities, Submit the folder
YourStudentID_Lastname_GoogleCloud in Moodle.
Project 6: Lab Work Book (20 marks) (5+5+5+5)
In this part, you will submit all the lab activities from week7 to week 11 (Week7, Week 9,
Week 10, Week 11). Please refer to week 7, week 9, week 10, week 11 lab activities for
details on actual deliverables for the lab work book submission.