Mgts 7202 Mid Term Asssignment
ASSIGNMENT GUIDE – MGTS7202
SEMESTER 1, 2013
MGTS7202 ASSIGNMENT
MICROSOFT OFFICE 2010 – EXCEL & ACCESS
OVERVIEW
This assignment is designed to help students to learn the technological aspects of business information systems in general. Through this assignment, students will gain hands-on experience with software application essential for their future work. This assignment requires the creation of an integrative application using Microsoft Office 2010, in particular Microsoft Excel & Access. The purpose of this assignment is to test the students’ ability in operating and managing business data in both Access databases and Excel spreadsheets. Through the tutorials, students will be taught the basic skills to complete this assignment, and provided with practical exercises similar to those in the assignment. Therefore, it is essential that students attend each tutorial in order to be able to successfully complete the assignment. The assignment is worth 40 marks that equal to 40% of your overall grade achievable in this course. This assignment has been particularly designed to suit the workload of two students. It is therefore recommended that you work in groups of TWO students (maximum 2 students); however, you are able to work by yourself. This assignment requires no prior technical background. Moreover, it is designed for business students in general to appreciate basic IT applications. Prior familiarity with the software tools could be beneficial, but will not guarantee a significant advantage or higher marks.
CASE BACKGROUND AND SCENARIO
At the beginning of each semester, the University’s Campus Bookstore is always crowded because students search through the bookshelves to select the textbooks for their courses. Often there are long queues lined up at the cashiers. The crowdedness at peak times does not only hurt service quality and customer satisfaction, but also creates other issues such as staff scheduling problems and security concerns. As a
SEMESTER 1, 2013
MGTS7202 ASSIGNMENT
MICROSOFT OFFICE 2010 – EXCEL & ACCESS
OVERVIEW
This assignment is designed to help students to learn the technological aspects of business information systems in general. Through this assignment, students will gain hands-on experience with software application essential for their future work. This assignment requires the creation of an integrative application using Microsoft Office 2010, in particular Microsoft Excel & Access. The purpose of this assignment is to test the students’ ability in operating and managing business data in both Access databases and Excel spreadsheets. Through the tutorials, students will be taught the basic skills to complete this assignment, and provided with practical exercises similar to those in the assignment. Therefore, it is essential that students attend each tutorial in order to be able to successfully complete the assignment. The assignment is worth 40 marks that equal to 40% of your overall grade achievable in this course. This assignment has been particularly designed to suit the workload of two students. It is therefore recommended that you work in groups of TWO students (maximum 2 students); however, you are able to work by yourself. This assignment requires no prior technical background. Moreover, it is designed for business students in general to appreciate basic IT applications. Prior familiarity with the software tools could be beneficial, but will not guarantee a significant advantage or higher marks.
CASE BACKGROUND AND SCENARIO
At the beginning of each semester, the University’s Campus Bookstore is always crowded because students search through the bookshelves to select the textbooks for their courses. Often there are long queues lined up at the cashiers. The crowdedness at peak times does not only hurt service quality and customer satisfaction, but also creates other issues such as staff scheduling problems and security concerns. As a