Dear Students,
As promised, I've made a video tutorial on how to do the group assignment, both excel and how to write your report.
I've also attached hereby a detailed instruction on how to write your report. Read the pdf file carefully and answer the specific question in there and the numbers/outputs you get from Excel. Sample Report or Sample Report
A sample file of Excel is also attached hereby
Sample Excel file or Sample Excel file
I've got some problems uploading to Youtube, I hope Google to work it out before tomorrow. In the meantime, you can download the video tutorial from here (Right Click —> Save link/target as)
Video tutorial
So, what I suggest you to do is:
1. Start with looking at the pdf file. That's what your report is expected to look like. The basic structure is the same. Just add your comments, graphs, and numbers of your own. Remember, you comments and decisions are the most important in deciding your mark!!!
2. If you don't know how to do something in Excel, look at the video tutorials. If you still cannot do it, you can open the excel file to see the formula or something.
If you are still stuck, feel free to email me. I'll reply ASAP.
Good luck with your assignment.
Vinh Tran
Update: I've just managed to get the videos live on Youtube, you can view them here, divided into 3 parts due to the Google's stupid 10 minute limits.
