Posted: July 7th, 2015

information Technology for the work place project (practical application)

this assignment wants very high qualified writer who can use computer very well .. and know the statistics and how to calculate in Excel .. please this assignment contain 5 projects I want you to do all these accept the power point presentation in project 3 I will be able to do that.. when you do Google could you can use my username if you think the teacher will check for that.

save all the document as provided with the last name and after you submit the assignment I will rename them to my actual last name . and for the reflective report please do it in word decument

please read all the assignments detailed and the marking criteria carefully if you have any questions let me know. I will provide you with all information given in this unit and with the data needed for this assignment ..

please this is master assignment I really need someone who are able to provide and follow all the instruction carefully and can submit this order in high professional way .

TW(6587)/ITW(G) (8520)– WIT 2015
Assignment Project
Using Microsoft Office Productivity Suite
Due Date: Week 7 Friday 11.30 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 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 reflective report for each project. The report should include steps you have 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_LastName_Modified_ Newsletter.doc
• YourStudentID_LastName_WorkshopFlyer.doc
• YourStudentID_EventEntertainmentBudget.xls
• YourStudentID_LastName.ppt
• YourStudentID_LastName.mdb
• YourStudentID_LastName_GoogleCloud folder
• YourStudentID_Assign_ReflectiveReport either word or pdf
• YourStudentID_Assignment Cover Sheet (available in Moodle)
Project 1 (P1): Using Microsoft Word (8 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 schedules.
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.
1. Assign_P1_Company_NewsIetter
2. Assign_P1_Workshop_Text
You will save your files for Assignment 1 submission in Moodle as:
YourStudentID_LastName _Modified_ Newsletter
YourStudentID_LastName_ Modified_WorkshopFlyer
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 (8 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 worksheet.
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
Sheet 1:
Sheet 2:
Sheet 3:
Sheet 4:
Project 3: Using Microsoft PowerPoint (6 marks)
Refer Week 4 Tutorial/Lab for help
Job Focus: Sales Manager of a Sports Store called “Front Range Action Sports”
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 .
Project 4: Using Microsoft Access (8 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 (8 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.