MGTS7202 Assignment Specification
ASSIGNMENT GUIDE – MGTS7202
SEMESTER 1, 2015
MGTS7202 ASSIGNMENT
M ICROSOFT O FFICE 2013 – A CCESS & E XCEL
UQ B USINESS S CHOOL M ERCHANDISE S TORE
WEIGHT 25%
DATE 10:00 Friday, 05 June 2015
DELIVERABLES 1. One electronic file must be submitted via the Blackboard Assignment
Submission Tool consisting of a ZIP archive containing:
a. an Access Database,
b. an Excel Workbook,
c. two PDF reports.
2. An assignment coversheet must be submitted to the BEL Faculty
Collaborative Learning Centre.
OVERVIEW
This assignment is designed to help students learn the technology aspects of Business Information Systems in general.
Through this assignment, students will gain hands-on experience with software applications essential for their future work. This assignment requires the creation of an interactive application using Microsoft Office 2013, in particular Microsoft
Access & Excel. 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, student 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 successful complete the assignment.
The assignment is worth 25% of your overall grade achievable in this course. This is an individual assignment and
MUST be done by each student.
The Access database and Excel template of the expected worksheets are available on the MGTS7202 Blackboard site.
The Excel template must be used as the basis for your workbook. You may change its visual formatting (colours, fonts, etc.) to provide a professional finished product.
The assignment requires no prior technical background. Moreover, it is designed for business students in general to appreciate basic IS applications. Prior familiarity with the software tools could be beneficial, but will not guarantee a
significant
SEMESTER 1, 2015
MGTS7202 ASSIGNMENT
M ICROSOFT O FFICE 2013 – A CCESS & E XCEL
UQ B USINESS S CHOOL M ERCHANDISE S TORE
WEIGHT 25%
DATE 10:00 Friday, 05 June 2015
DELIVERABLES 1. One electronic file must be submitted via the Blackboard Assignment
Submission Tool consisting of a ZIP archive containing:
a. an Access Database,
b. an Excel Workbook,
c. two PDF reports.
2. An assignment coversheet must be submitted to the BEL Faculty
Collaborative Learning Centre.
OVERVIEW
This assignment is designed to help students learn the technology aspects of Business Information Systems in general.
Through this assignment, students will gain hands-on experience with software applications essential for their future work. This assignment requires the creation of an interactive application using Microsoft Office 2013, in particular Microsoft
Access & Excel. 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, student 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 successful complete the assignment.
The assignment is worth 25% of your overall grade achievable in this course. This is an individual assignment and
MUST be done by each student.
The Access database and Excel template of the expected worksheets are available on the MGTS7202 Blackboard site.
The Excel template must be used as the basis for your workbook. You may change its visual formatting (colours, fonts, etc.) to provide a professional finished product.
The assignment requires no prior technical background. Moreover, it is designed for business students in general to appreciate basic IS applications. Prior familiarity with the software tools could be beneficial, but will not guarantee a
significant