UNDERGRADUATE PROGRAMMES KEY FACTS MODULE NAME

Download You need programming skills for use in your dissertation and possibly in your subsequent professional lives. This module is designed to int...

0 downloads 608 Views 17KB Size
MODULE SPECIFICATION – UNDERGRADUATE PROGRAMMES KEY FACTS Module name Module code School Department or equivalent

Introduction to Visual Basic IF1201 Cass Business School

UK credits

15 7.5 4

ECTS Level Delivery location (partnership programmes only)

UG Programme (Cass Business School)

MODULE SUMMARY Module outline and aims You need programming skills for use in your dissertation and possibly in your subsequent professional lives. This module is designed to introduce you to writing computer programmes in Visual Basic. Emphasis is on gaining hands-on programming experience and the application of visual basic in solving day to day business problems. Content outline - VB Environment, Subroutines - Data Variables, Declarations, Screen I/O - Arithmetic and Logical Operators and Expressions - Boolean Conditions and If-Then Statements - If-Then-Else and If-Then-ElseIf control structures - Control Structures: For-Next loops - Control Structures: While-Do loops - Arrays: one dimensional - Function Definitions and Calls, Parameter Passing - Visual basic model analysis and audit trail reporting Pre-requisite Skills Assessment Manager (SAM) online training programme, Excel Advanced 65% SAM 2013 (Skills Assessment Manager) is a web-based application that measures student proficiency in Microsoft Office software and technology-related topics. Details of how to access the application are sent out at the start of term. WHAT WILL I BE EXPECTED TO ACHIEVE? On successful completion of this module, you will be expected to be able to: Knowledge and understanding: - Formulate algorithmic solutions to numerical and data processing problems - Analyse visual basic models and write audit trail reports

Skills: - Write programming code in Visual Basic Values and attitudes: - Appreciate the importance of clean design and clarity as important attributes of good computer programmes HOW WILL I LEARN? All sessions will be held in computer labs and education is hands on i.e. learning by doing assignments in class - not so much lecture based. Additionally some demo examples and/or videos may be posted online for practice. Teaching component

Teaching type

Lab Session

Practical 22 classes and workshops 22

Totals

Contact hours

Selfdirected study hours 128

Placement Total student hours learning hours 0

150

128

0

150

WHAT TYPES OF ASSESSMENT AND FEEDBACK CAN I EXPECT? Assessments The computer-based assessments will require you to write computer programmes, enter them into the computer, use the software to check and remove errors and then report the output. To do well will require a good understanding of general theoretical concepts in computer programming, as well as grammar rules specific to Visual Basic, and a strong familiarity with the software used for editing, debugging and running Visual Basic programmes.

Assessment component Group Coursework Individual Coursework

Assessment Weighting Minimum Pass/Fail? type qualifying mark Practical 30% 40 N/A skills assessment Practical 70% 40 N/A skills assessment

Assessment criteria Assessment criteria are descriptions of the skills, knowledge or attributes you need to demonstrate in order to complete an assessment successfully and Grade-Related Criteria are descriptions of the skills, knowledge or attributes you need to demonstrate to achieve a certain grade or mark in an assessment. Assessment

Criteria and Grade-Related Criteria for module assessments will be made available to you prior to an assessment taking place. More information will be available in the UG Assessment Handbook and from the module leader. Feedback on assessment Following an assessment, you will be given your marks and feedback in line with the University’s Assessment Regulations and Policy. More information on the timing and type of feedback that will be provided for each assessment will be available from the module leader. Assessment Regulations The Pass mark for the module is 40%. Any minimum qualifying marks for specific assessments are listed in the table above. The weighting of the different components can also be found above. The Programme Specification contains information on what happens if you fail an assessment component or the module.

INDICATIVE READING LIST JACKSON, M. and STAUNTON, M. (2001) Advanced Modelling in Finance Using Excel and VBA (The Wiley Finance Series). London: John Wiley & Sons

Version: 3.0 Version date: March 2016 For use from: 2016-17

Appendix: see http://www.hesa.ac.uk/content/view/1805/296/ for the full list of JACS codes and descriptions

CODES HESA Code 133

Description Business and Management Studies

Price Group D

JACS Code I321

Description

Percentage (%) 100

Procedural Programming