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.
2 hrs lectures/wk, 2 hrs laboratories/wk
Students will be expected to spend a total of 12 hours per week during semester on this unit as follows:
Weekly workload commitments are:
BUS1010, CSE1720, GCO1851, MMS1401
Examination (2 hours): 60%; In-semester assessment: 40%
|Assessment Task||Value||Due Date|
|Assignment 1||5%||11pm, 17 August 2012|
|Assignment 2||15%||11pm, 5 October 2012|
|Class Test||10%||Week 8 lecture, 2pm, 12 September 2012|
|Tutorial tasks||A maximum of 10% is awarded for the 12 weekly tutorials.||During the relevant tutorial|
|Examination 1||60%||To be advised|
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 SETU, Student Evaluation of Teacher and Unit. 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, and on student evaluations, see:
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
|0||Register for an FIT1013 lab - these start in week 1.||No formal assessment is undertaken in Week 0|
|1||Unit information. Excel: Working with formulas and functions. Working with Excel tables. Analysing data: working with Excel tables, Pivot tables, Pivot Charts, filters including advanced filters, etc.||Assessment task 4: Tutorial tasks are due and assessed weekly from week 1 - 12; Week 1: Unit intro. and Excel exercises.|
|2||More Excel functions: AND(), OR() and NOT(); Nested IF; VLookup(), Match(), Index(), IffError(), ISNA(), Choose(), Database functions. Excel: Range names, data validation, worksheet and workbook protection, macros - the macro recorder.||Assessment task 4: Week 2 onwards: tasks will be given during tutorial classes|
|3||Excel: More on Decision support: Goal Seek, Data tables, breakeven analysis, Scenario Manager. ActiveX controls to help develop an Excel application.|
|4||Fundamentals of VBA programming - string variables, string concatenation. The InputBox function, MsgBox prompt, Val function. Object variables in Excel VBA. The Set statement. VBA examples. Variable scope.||Assessment task 1: Assignment 1 due 17 August 2012 at 11pm|
|5||VBA: Numeric variables. VBA coding examples using a ListBox. Using the WorksheetFunction Object, using worksheet functions in VBA. VBA Control structures, Selection, Selection Case. Nested Selection. Comparison, Relation and logical operators. UCase and LCase functions. Debugging code.|
|6||VBA: Date variables. Date functions: DateDiff, DateAdd, DateValue, TimeValue, Offset property of the Range object. Control structures, repetition. Do loop control structures. For..Next statement. For Each..Next statement. MsgBox function - Buttons argument. Customising screen elements. Custom GUIs - Creating User Forms. Form design. AddItem method for ListBox. Array variables and string manipulation functions.|
|7||Relational Database concepts: field, record, table, relational database, primary key, and foreign key. Query, Form, Report wizards. Compacting and repairing. Creating a database, table relationships, referential integrity. Database inconsistencies, cascade update, cascade delete.|
|8||Class Test||Assessment task 3: Class Test in week 8 lecture - 12 September 2012 at 2pm|
|9||Introduction to queries, maintaining a database. Simple queries. The Expression builder. Calculated fields. Aggregate functions. More advanced queries: Pattern match. Like, In, Not operators. Parameter queries. Crosstab query. Find duplicates, find Unmatched, Top value queries. Lookup field Wizard. Input masks. Data validation.|
|10||Action queries, Indexes, Joins, SQL â Structured Query Language (brief). Joins. Indexes. Creating Custom Forms. Guest presenter.||Assessment task 2: Assignment 2 due 5 October 2012|
|11||Access macros, macro groups. Switchboards, command buttons. VBA for Access. Managing and securing a database.|
|12||Summary and revision.|
|SWOT VAC||No formal assessment is undertaken in SWOT VAC|
|Examination period||LINK to Assessment Policy: http://policy.monash.edu.au/policy-bank/
*Unit Schedule details will be maintained and communicated to you via your MUSO (Blackboard or Moodle) learning system.
Faculty Policy - Unit Assessment Hurdles (http://www.infotech.monash.edu.au/resources/staff/edgov/policies/assessment-examinations/unit-assessment-hurdles.html)
Academic Integrity - Please see the Demystifying Citing and Referencing tutorial at http://lib.monash.edu/tutorials/citing/
The assessment for this assignment will be based on your ability to:
Students will be required to demonstrate a thorough understanding of the materials presented in lectures and tutorials from weeks 1 to 7 inclusive.
It is a University requirement (http://www.policy.monash.edu/policy-bank/academic/education/conduct/plagiarism-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 online quiz).
You must negotiate any extensions formally with your campus unit leader via the in-semester special consideration process: http://www.infotech.monash.edu.au/resources/student/equity/special-consideration.html.
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:
Key educational policies include:
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 www.monash.edu.au/students. For Sunway 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 and resources that enable you to save time and be more effective in your learning and research. Go to http://www.lib.monash.edu.au or the library tab in my.monash portal for more information. At Sunway, visit the Library and Learning Commons at http://www.lib.monash.edu.my/. At South Africa visit http://www.lib.monash.ac.za/.
Academic support services may be available for students who have a disability or medical condition. Registration with the Disability Liaison Unit is required. Further information is available as follows: