Introduction to business application tools and introduction to basic computing concepts. Principles of spreadsheets and relational databases, covering their use for the generation of business plans, reports, financial statements, etc. Both the spreadsheet and database components incorporate an introduction to programming with visual basic for applications (VBA). The database component covers principles of database design. The business application software packages used in the unit are Microsoft Excel and Microsoft Access.
Minimum total expected workload equals 12 hours per week comprising:
(a.) Contact hours for on-campus students:
(b.) Additional requirements (all students):
See also Unit timetable information
BUS1010, CSE1720, GCO1851, MMS1401
Yen Cheung
Kimberley Soh, Consultation hours: TBC
Consultation hours: TBC
Peter Huynh
Consultation hours: TBC
Anthony Wong
Consultation hours: TBC
Monash is committed to excellence in education and regularly seeks feedback from students, employers and staff. One of the key formal ways students have to provide feedback is through the Student Evaluation of Teaching and Units (SETU) survey. The University’s student evaluation policy requires that every unit is evaluated each year. Students are strongly encouraged to complete the surveys. The feedback is anonymous and provides the Faculty with evidence of aspects that students are satisfied and areas for improvement.
For more information on Monash’s educational strategy, see:
www.monash.edu.au/about/monash-directions/ and on student evaluations, see: www.policy.monash.edu/policy-bank/academic/education/quality/student-evaluation-policy.html
Previous student feedback has highlighted that this is a very useful unit especially for the IBL students of the Faculty.
If you wish to view how previous students rated this unit, please go to
https://emuapps.monash.edu.au/unitevaluations/index.jsp
| Week | Activities | Assessment |
|---|---|---|
| 0 | No formal assessment or activities are undertaken in week 0. | |
| 1 | Introduction to unit; Excel: Calculating data with formulas and functions | Tutorials start in Week 2 |
| 2 | Excel Tables; Pivot Tables and Pivot Charts | Tutorial tasks and quizzes are due and assessed weekly from Week 2 to Week 11 |
| 3 | Advanced Excel functions | |
| 4 | Developing an Excel application | |
| 5 | Fundamentals of programming: Excel VBA | Assignment 1 due 28 August 2015 |
| 6 | Numeric variables and selection structures | |
| 7 | Date variables and repetition structures | |
| 8 | Class Test in lecture. | Class Test in lecture |
| 9 | Connecting to external data | |
| 10 | Access: creating a database; defining table relationships | |
| 11 | Querying a database; creating advanced queries | Assignment 2 due 16 October |
| 12 | Creating action queries and advanced table relationships; unit summary and review | |
| SWOT VAC | No formal assessment is undertaken in SWOT VAC | |
| Examination period | LINK to Assessment Policy: http://policy.monash.edu.au/policy-bank/ academic/education/assessment/ assessment-in-coursework-policy.html |
*Unit Schedule details will be maintained and communicated to you via your learning system.
Examination (2 hours): 60%; In-semester assessment: 40%
| Assessment Task | Value | Due Date |
|---|---|---|
| Assignment 1 | 7% | 28 August 2015 |
| Assignment 2 | 18% | 16 October 2015 |
| Class Test | 7% | Week 8 in lecture |
| Tutorials and Quizzes | 8% | During the relevant tutorial |
| Examination 1 | 60% | To be advised |
Faculty Policy - Unit Assessment Hurdles (http://intranet.monash.edu.au/infotech/resources/staff/edgov/policies/assessment-examinations/assessment-hurdles.html)
Academic Integrity - Please see resources and tutorials at http://www.monash.edu/library/skills/resources/tutorials/academic-integrity/
The assessment for this assignment will be based on your ability to:
Learning outcome 1 (use spreadsheets to report, analyse and model organisational data).
The assessment criteria will be based your ability to perform the following tasks:
Learning outcomes 1 and 3
Students will be required to demonstrate a thorough understanding of the materials presented in lectures and tutorials from Weeks 1 to 7 inclusive.
How well students complete the assigned tasks.
How well students demonstrate their understanding of the material presented in the lectures.
Monash Library Unit Reading List (if applicable to the unit)
http://readinglists.lib.monash.edu/index.html
Types of feedback you can expect to receive in this unit are:
Submission must be made by the due date otherwise penalties will be enforced.
You must negotiate any extensions formally with your campus unit leader via the in-semester special consideration process: http://www.monash.edu.au/exams/special-consideration.html
It is a University requirement (http://www.policy.monash.edu/policy-bank/academic/education/conduct/student-academic-integrity-managing-plagiarism-collusion-procedures.html) for students to submit an assignment coversheet for each assessment item. Faculty Assignment coversheets can be found at http://www.infotech.monash.edu.au/resources/student/forms/. Please check with your Lecturer on the submission method for your assignment coversheet (e.g. attach a file to the online assignment submission, hand-in a hard copy, or use an electronic submission). Please note that it is your responsibility to retain copies of your assessments.
If Electronic Submission has been approved for your unit, please submit your work via the learning system for this unit, which you can access via links in the my.monash portal.
Limited copies of prescribed texts are available for you to borrow in the library.
Parsons, Oja, Ageloff and Carey. (2014). Microsoft Excel 2013, New Perspectives Series, Comprehensive Edition. (First) Cengage Learning.
Adamski, Scollard and Finnegan. (2014). Microsoft Access 2013, New Perspectives Series, Comprehensive Edition. (First) Cengage Learning.
Microsoft Excel 2013 and Microsoft Access 2013
Monash has educational policies, procedures and guidelines, which are designed to ensure that staff and students are aware of the University’s academic standards, and to provide advice on how they might uphold them. You can find Monash’s Education Policies at: www.policy.monash.edu.au/policy-bank/academic/education/index.html
Important student resources including Faculty policies are located at http://intranet.monash.edu.au/infotech/resources/students/
The University provides many different kinds of support services for you. Contact your tutor if you need advice and see the range of services available at http://www.monash.edu.au/students. For Malaysia see http://www.monash.edu.my/Student-services, and for South Africa see http://www.monash.ac.za/current/.
The Monash University Library provides a range of services, resources and programs that enable you to save time and be more effective in your learning and research. Go to www.lib.monash.edu.au or the library tab in my.monash portal for more information. At Malaysia, visit the Library and Learning Commons at http://www.lib.monash.edu.my/. At South Africa visit http://www.lib.monash.ac.za/.