CSC Computer and Information Processing – Transportation Efficiency Analysis

Topic: The Road To Uitm: Commuting & Transportation Efficiency

Assignment Objective

This assignment aims to evaluate your fundamental digital skills using Microsoft Word and Microsoft Excel. Upon completion, you should be able to:

1. Produce a professional report using Microsoft Word.
2. Organize and analyze data using Microsoft Excel.
3. Integrate both applications into one cohesive project.
4. Manage transportation information systematically to evaluate cost-effectiveness.

Assignment Question

This assignment required you to demonstrate your skills in using the word processor and spreadsheet software. In addition, your knowledge of problem-solving is also required to finish this assignment successfully.

In this assignment, you are required to provide an expenses report for commuting to UITM for your studies. Based on the available transportation modes within the campus, analyze the costs and efficiency of reaching the campus. Using Word Processing, you need to prepare a report that consists of the following:

• Table of contents.
• Introduction
• Methodology
• Finding and Analysis
• Discussion
• Saving suggestion
• Conclusion

Report Structure & Requirements

Section 1 – Introduction

• Purpose: Describe the background and specific aim of your commuting study. You should address why choosing the right transport is essential for managing your salary or education fund.
• Skills Assessed:
• Create, edit, and format paragraphs with proper alignment.
• Set up the Header & Footer.
• Effective use of bold and italics for emphasis.

Section 2 – Methodology

• Purpose: Explain the workflow implemented to gather data (e.g., selecting modes like Bus, LRT, Grab, and Motorcycle and tracking them for five days).
• Skills Assessed:
• Insertion of icons and lists (bullets/numbering).
• Description of the Excel workflow and data logbook process.
• Use of Format Painter for consistent heading styles.

Section 3 – Findings & Analysis

• Purpose: Display the results using a table and chart exported from your Excel analysis.
• Skills Assessed:
• Create and format a spreadsheet showing weekly costs and average times.
• Apply Excel functions: SUM (Total Cost), AVERAGE (Travel Time), MAX (Highest Expense), and MIN (Shortest Time).
• Create a Pie Chart showing the percentage of the budget spent on each mode.
• Successful integration (copy/paste/embed) from Excel to Word.

Section 4 – Discussion

• Purpose: Critically interpret the trade-off between time and money based on your data.
• Skills Assessed:
• Insert and format SmartArt/Shapes to visualize transport priority levels.
• Application of Word Wrap and color formatting.

Section 5 – Saving Suggestions

• Purpose: Provide personal recommendations, such as using student discount cards or carpooling.
• Skills Assessed:
• Customization of bullets and numbering.
• Insertion of graphic elements/icons (e.g., 🚌, 🤝, ⏰).
• Proofreading using the Spelling & Grammar tool.

Section 6 – Conclusion

• Purpose: Summarize which transport mode remains the most efficient for your specific situation.
• Skills Assessed:
• Insert a line separator shape.
• Apply italics formatting for the final summary.
• Final professional page layout (spacing and alignment)

Experts Answer on Above Transportation Efficiency Analysis

Introduction

The main aim of this transportation efficiency analysis is to analyze the cost and efficiency of commuting to UiTM using four different Transportation modes including bus, LRT, Grab and motorcycle. The study is quite important because the implication of cost and time is significant on students as the transportation expenses can directly affect their monthly education budget. The objective is therefore to identify the cost effective and time efficient option available to the students in traveling to UiTM on a daily basis while maintaining a balance between affordability and convenience.

Methodology

The collection of data is performed over a period of five consecutive weekdays. The comparison was carried out with respect to four transportation modes including RapidKL bus, LRT, Grab and Motorcycle. In respect to each of these modes, the specific data collected was the daily travel cost in RM and average travel time in minutes. The collected data is analyzed using Microsoft Excel utilizing important metrics including sum, average, maximum and minimum functions.

Findings and Analysis

The data above indicates the daily cost across four different transportation modes, and they were converted into weekly cost considering five working days. The average travel time is also indicated in minutes. The calculation as performed indicates the average weekly cost at RM190 whereas the average travel time is 37.5 minutes. Grab is the costliest transportation mode as it amounts to R100 per week, but at the same time, it is the fastest mode, as it takes 25 minutes on an average.

Discussion

The analysis of findings clearly indicates the difference between the cost and travel time across four different modes, and it shows a clear trade-off between cost and travel time. It is discussed that the cheapest option available is bus as it costs RM20 per week, but at the same time, it takes the longest travel time of 55 minutes to reach UiTM. On the other hand, Grab is the fastest option available as it takes 25 minutes to reach using Grab, but it costs the maximum that is RM100 per week. In respect to LRT, it provides a balance between the cost and travel time, as it costs RM40 weekly with a 40 minutes average journey. Motorcycle on the other hand offers relatively low cost at RM30 per well and it has a shorter travel time of 30 minutes which makes it the most efficient.

It therefore implies that most of the UiTM students in Klang Valley can use motorcycles, as it provides the best balance between affordability and convenience.

Saving Suggestions

Students are already on budgets and it is important for them to utilise all the strategies that lead to minimum impact on their pocket. They can use student travel discounts by applying for a student concession card on public transport, or they can also consider carpooling with friends to share the cost. The strategy of traveling during off peak hours is also a good option along with utilizing transportation apps to compare fares and routes before traveling.

Conclusion

The entire analysis as carried out leads to the conclusion that the most efficient Transportation mode is motorcycle for a UiTM student. It allows for a proper trade off between the cost and travel time which is not possible in case of bus even though it is cheaper, as it takes more time to reach. Grab offers speed but at a substantially higher cost.

Want Detailed Answers with References?

The analysis of different transportation modes, weekly commuting expenses and the cost effective option for UiTM students revealed significant findings about the best possible option available to students. If you need a similar kind of analysis on transportation cost efficiency, consult our professional IT experts to get best assignment help in Malaysia.