aims to introduce you to the principles and techniques of spreadsheet modeling and to enable you to acquire the skills to apply these in an accounting context.

INSTRUCTIONS TO CANDIDATES

ANSWER ALL QUESTIONS

1 Module overview

Introduction

We have introduced UWLFlex – our new, online, flexible learning platform.

UWLFlex has been designed to complement face-to-face learning and build on our reputation for excellence in teaching, learning, and student support. We will be able to deliver a University experience that is more collaborative, active, and relevant for an increasingly digital world thus enabling us to provide you with an improved student experience. UWLFlex will provide you with an enhanced range of online tools, to help facilitate your learning whether this takes place primarily on-site or online.

Module summary content and aims

Welcome to this Level 4 module: Computer Skills for Accountants! This is a core module for the BA (Hons) Accounting and Finance, which is an ACCA-accredited course.

Aims of the module:

This module aims to introduce you to the principles and techniques of spreadsheet modeling and to enable you to acquire the skills to apply these in an accounting context. You will also be introduced to the principles of business information systems and basics of computerised accounting software.

This module would form the basis for the L6 optional module of Financial Modelling.

Topics covered:

1. Principles of spreadsheet design and modelling 

2. Screen components 

3. Entering and editing data

4. Formatting 

5. Formulas and functions 

6. Charts

7. Cell referencing (relative, absolute, mixed) 

8. Data tables 

9. Principles of business information systems

10. Introduction to computerised accounting software

Expectations

What to expect from your tutor

1. Guidance and support

Your tutor will provide you with academic guidance and will help you reflect on your academic progress so that you get the most out of your studies. Your tutor and student support team will also provide advice on the wider network of specialist student support services at the University to help you have the best possible experience during your studies.

2. Confidentiality

Some information may be sensitive. Although it may be necessary to consult colleagues, University staff will treat such information as confidential and will limit disclosures to the minimum necessary.

3. Assessment marks and summative feedback

Assessment marks and summative feedback will be given within 3 working weeks from the assessment submission deadline.

What is expected of you as a tutee?

1. Engagement

You are expected to attend all the classes and seminars and be punctual. You will get the most out of your support by working in partnership with your tutor and student support team. This is a two-way process and by taking part in it fully you will gain more benefits from your experience at the

University. You are therefore, expected to actively participate and engage in class activities and inform the tutor by e-mail when and if you are unable to attend any classes.

2. Preparation

You are expected to read any preparation material / attempt any practice questions prior to lectures/seminars as per instructions given.

3. Professional conduct

You are expected to behave professionally in classes and not cause any disruption that might affect other students’ learning. You are also expected to communicate with your tutors in a professional manner.

4. Attempt all assessments

You are expected to attempt all assessments by the submission deadline unless there are extenuating circumstances (in which case please contact your Course Leader for extension request or mitigation claim prior to the assessment deadline).

Learning outcomes to be assessed

LO1. Demonstrate a detailed knowledge and understanding of the Microsoft Excel spreadsheet package.

LO2. Create robust and flexible spreadsheet models from basic financial information provided. LO3a Extract relevant and significant information from models and present it clearly.

LO3b Interpret such information correctly to demonstrate understanding.

LO4. Set up a company on a computerised accounting package and record a range of transactions.

LO5. Produce appropriate reports using a computerised accounting package.

LO6. Demonstrate an understanding of the costs and benefits of a computerised accounting package for a small business.

LO7 Demonstrate knowledge of the principles of business information systems.

Attachments:

Related Questions

. The fundamental operations of create, read, update, and delete (CRUD) in either Python or Java

CS 340 Milestone One Guidelines and Rubric  Overview: For this assignment, you will implement the fundamental operations of create, read, update,

. Develop a program to emulate a purchase transaction at a retail store. This  program will have two classes, a LineItem class and a Transaction class

Retail Transaction Programming Project  Project Requirements:  Develop a program to emulate a purchase transaction at a retail store. This

. The following program contains five errors. Identify the errors and fix them

7COM1028   Secure Systems Programming   Referral Coursework: Secure

. Accepts the following from a user: Item Name Item Quantity Item Price Allows the user to create a file to store the sales receipt contents

Create a GUI program that:Accepts the following from a user:Item NameItem QuantityItem PriceAllows the user to create a file to store the sales receip

. The final project will encompass developing a web service using a software stack and implementing an industry-standard interface. Regardless of whether you choose to pursue application development goals as a pure developer or as a software engineer

CS 340 Final Project Guidelines and Rubric  Overview The final project will encompass developing a web service using a software stack and impleme