Module Study Guide

AssignmentTutorOnline

Academic Year 2020–2021

BA3LC89O – Data Handling & Using ICT

Level: 3

Credits: 20

Location: Elephant and Castle Campus – London

Table of contents

Key team contact details. 3

1 Module overview 5

1.1 Introduction.. 5

1.2 Module summary content and aims. 5

1.3 Learning outcomes to be assessed. 7

1.4 Indicative Contact Hours. 7

2 Assessment and feedback 8

2.1 Summative assessment grid. 8

2.2 Assessment brief including criteria mapped to learning outcomes. 9

2.3 Learning materials. 11

3 Things you need to know 12

3.1 Engagement 12

3.2 Need help, just ask. 12

3.3 Getting support for your studies. 13

3.4 Student support 13

3.5 Module evaluation – have your say! 13

Key team contact details

Module Leader	Khushnood Anwar
Subject Area & School/College	London School of Science and Technology (LSST)
Email	[email protected]
Phone	01216436774 Extension 267
Location	Aston Campus, Birmingham

Course Leader	Eniana Gobuzi
Email	[email protected]
Phone	+44 (0) 208 7953863 Extension: 535
Location	Memo House, Park Royal

Academic Support Librarian	Elephant and Castle Library
Email	[email protected]
Phone	+44(0) 2080174257 Extension: 615
Location	Elephant and Castle, London

Course Administrator	LSST Registry
Email	[email protected]
Phone	+44 (0) 208 7953863 Extension: 527
Location	Memo House, Park Royal

The Course Leader overseeing this module is Eniana Gobuzi, and can be contacted at [email protected]

The module leader responsible for this module is Khushnood Anwar and can be contacted at [email protected]

School/College/Dean of College responsible for this module is Dr George Panagiotou and can be contacted at [email protected]

1 Module overview

1.1 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.

1.2 Module summary content and aims

The aim of the module is to develop students’ skills and confidence in the use and application of numerical data and analysis, and to develop candidate’s skills in preparing, presenting and processing data using business software. This module is split into two learning themes: Numerical Skills, and Information Technology; both of which are essential skills for data handling and quantitative analysis in business.

Research has clearly demonstrated that both numeracy and ICT skills are the two of the most sought-after skillsets in the business sector; Numeracy is about the basic mathematical concepts that one needs to be able to understand the basic concepts and apply to real life such as managing personal or business finances, being able to perform simple, yet important arithmetic when at work such as mathematical concepts of averages – median, mean and so on – as well as frequency. ICT is leveraged to make the process more efficient in data handling.

This module will be run in either IT rooms and/or classrooms using various learning and teaching strategies, such as reflective learning, cooperative learning, inquiry-based instruction, differentiation, technology-based teaching, group discussions, peer assessment and so on.

The module deals with the simple arithmetic operations, fractions, decimals, percentage, ratios, indices, tables, charts, graph and applying Excel functions in various business scenario. The learning sessions will be available on the blackboard under learning materials section.

Expectations

Specific expectations students can have of tutors:

Pre-recorded lectures are provided at least one week in advance on the “Learning Material” of BlackBoard
Please e-mail for an online/phone appointment outside of normal class times for mutually convenient times
Refer to MSG (and all assignment guides/case studies) on BB
Formative feedback on their assessments

Specific expectations tutors will have of students:

and prepare answers to questions as per instructions given.
in class activities.
when not able to attend any classes.

It is important that you do at least 152 independent-study hours (referring to the Reading List) on related and relevant topics, which may not be necessarily covered during the lessons, but all will still be assessed.

1.3 Learning outcomes to be assessed

On successful completion of the module, students will have:

LO 1 Used and manipulated numerical data correctly, including fractions, percentages and decimals.

LO 2 Understood and used basic techniques of sampling and statistical summary.

LO 3 Processed and presented data using spread sheet software packages.

LO 4 Demonstrated the ability to use internet technology in retrieving and communicating data.

1.4 Indicative Contact Hours

Teaching Contact Hours	48 hours
Independent Study Hours	152 hours
Total Learning Hours	200 hours

2 Assessment and feedback

2.1 Summative assessment grid

Type of Assessment	Word Count or equivalent	Threshold (if Professional Body-PSRB applies)	Weighting	Pass Mark	Submission due-date & time	Method of Submission & Date of Feedback
Written Assignment MS Power Point/Excel task (LO1, LO2, LO3, LO4)	Strictly no more than 10 slides	N/A	50%	40%	Week 9	TurnItIn 15 Working Days after submission
Online Test (LO1, LO2, LO3, LO4)	30 minutes	N/A	50%	40%	Week 15	15 Working after the submission date

Assessment

Teaching Weeks in which Assessment Support Takes Place

Outline of Type and Form of Assessment Support to be Provided

Student Preparation Required Prior to or After the Support Session

How will the Support Session to be Delivered

A1: Written Assignment MS Power Point/Excel task	Week 7	Formative feedback to be provided on draft	Students to submit their A1 draft on PowerPoint on Turnitin submission link, and to make necessary adjustment based on any given feedback	Formative feedback given via TurnItIn
Week 8	Q&A from students	Students have submitted their A1 draft on PowerPoint on Turnitin submission link	Supporting workshop

A2: Online Test

Week 14 – 15

Online Self-assessments in the test condition, with answers provided immediately

Students to practice all the activities for each week

Online Self-assessments in the test condition, with answers provided immediately

2.2 Assessment brief including criteria mapped to learning outcomes

Assessment 1: Excel and Power Point tasks (LO1, LO2, LO3, LO4)

Weighting: 50%

Date/time/method of submission: Week 9

Based on a research topic, you are required to obtain the relevant raw data. You then use MS Excel to manipulate the data obtained and present the information using MS PowerPoint with strictly no-more than 10 slides, including your name and ID.

Tasks

Based on a research topic or case study, obtain/download the raw data for sampling
Use MS Excel to manipulate the raw data with various statistical techniques.
Communicate the information using visual representations.
Screen-capture all the important information onto MS PowerPoint slides (i.e. no more than 10 slides).

Assessment Criteria:

Topic of understanding (10%)
- Brief description on what this summary is about.
Raw Data Presentation (20%)
- Choose appropriate data for sampling.
- Present the raw data on the spreadsheet, using Excel function, such as auto-format
- Label the raw data accordingly.
Statistical Techniques (20%)
- Convert the raw data into meaningful information, using mean, median and mode.
Data Manipulation (30%)
- Using Excel functions such as

a) Auto-sum formula (Sum, Average, Count, Max and Min)

b) Percentage/Decimal/Fraction/Ratio (whichever is appropriate)

to manipulate the data

Communicate the information using Visual Representations. (10%)
- Present the data in appropriate types of chart(S)
Conclusions (10%)
- Discuss the conclusions by interpreting the obtained data using the above information.

Additional Notes (these apply to Assignment 2 and will cause marks to be given or deducted if not adhered to):

All relevant and important information (such as formulae, charts etc.,) obtained using MS Excel must be screen-captured onto the PowerPoint slides for marks to be awarded.
Spreadsheet must be produced using required formulas/feature and formulae must be evidenced.
Spreadsheet must be professionally designed with required formulas/features and formulae must be evidenced.
Labels of the columns and rows of Excel spreadsheet(s), must be clearly shown on the screen capture(s)
Table(s) must be professionally displayed.
Chart(s) must be clearly labelled with correct headings and legend.
Any commentary or analysis must be specific.
Number of pages must be adhered to.
Headings/Sub-heading must be used when appropriate.
Bulleted or numbered lists must be used to help organize your text in your slides, as this is not a report.
Advanced feature/functions of Excel used appropriately if required.

Assessment 2: In-class numeracy test (LO1, LO2)

Weighting:50%

Date/time/method of submission: Week 15

The in-class numeracy test will cover various numerical subjects covered during the sessions from Week 1 to Week 14.

The test can be in written and/or multiple-choice formats. It could also be run online.

Note: It is important that you do at least the 152 independent-study hours (referring to the Reading List) on related and relevant topics, which may not be necessarily covered during the lessons, but all will still be assessed in the in-class test.

For guidance on online submission of assignments, including how to submit and how to access online feedback, please refer to the UWL Blackboard student-help pages at: uwl.ac.uk/blackboardhelp

2.3 Learning materials

The reading list for this module is available on Blackboard in the module area and online by searching uwl.rl.talis.com. This shows real-time availability of books in the library and provides direct links to online resources, recommended by your lecturer.

Remember to log into Blackboard daily to receive all the latest news and support available at your module sites!

Subject guides (subject-guides-libguides) are also available to help you find relevant information for assignments, with contact details of the Academic Support Librarian for your School.

Essential reading :

1. Bancroft G & Fletcher M (1998) Improve Your Maths, England: Prentice Hall.

2. Harvey, G. (2015). Excel 2016 for dummies. Wiley: Indianapolis

3. Rumsey, J. (2016). Statistics For Dummies, 2nd Edition (For Dummies (Lifestyle)). Wiley: New York

Recommended reading:

1. Frye, C. (2015). Microsoft Excel 2016 Step by Step. Microsoft Press

2. Harvey, G. (2015). Excel 2016 All-In-One For Dummies. Wiley: Indianapolis

3. Bell J (2002) Doing Your Research Project, 3^rd Ed, Open University Press

4. Taylor S. (2007) Business Statistics: For Non-Mathematicians Revised 2nd Edn. Palgrave Macmillan: London

Further reading:

1. Julius E H (1992) Rapid Maths Tricks and Tips, Canada: John Wiley & Sons Inc.

3 Things you need to know

3.1 Engagement

Teaching at UWL during the academic year 2020-21 will be conducted using the UWLFlex model and may involve a range of on site and online teaching and learning activities. Whether you are engaging with teaching and learning activities on site or via the UWL Virtual Learning Environment, we expect the same level of commitment and engagement from you. If you are unable to attend scheduled on site or online activities or complete activities in the time frames set out, you should let your tutors know. You should aim to stick to assessment deadlines; if you are concerned that you will not be able to complete your assessments on time, you should talk to your tutors. Your engagement, whether online or on site, will be tracked and if we see that you are not engaging, we will get in contact with you. However, we encourage you to let us know if you are struggling so we can work with you to find solutions and get you back on track as soon as possible. Give yourself the best possible chance to succeed by engaging with the full range of learning and teaching activities available to you.

All students should refer to the Attendance and Engagement Monitoring Policy particularly if your course is accredited by a professional body, or if you are an International student on a Tier-4 visa, or a student on an Apprenticeship course which have additional requirements.

3.2 Need help, just ask

The University recognises that there are times when you may encounter difficulties during your course of study and provisions are made to help you. If you are struggling with meeting deadlines please talk to us, whether it’s your course/module leader, personal tutor or any member of staff, speak to them so they can get you the support you need to succeed. You can extend your deadline if you have a good reason why you are not able to submit a piece of coursework on time, apply online for an extension before your deadline. An extension will allow you an extra 10 working days. If an extension is not sufficient and circumstances beyond your control are preventing you from completing your assessment, then you can, apply online for mitigation.

Please remember late submission without extension or mitigation will result in penalties depending on how late it is, see University Academic Regulations.

You are reminded that the University applies penalties to students who commit an academic offence, in which case the Academic Offences Regulations will be used to deal with any cases of academic misconduct including examination offences, plagiarism and other means of cheating to obtain an advantage.

You are encouraged to seek advice from the Students’ Union Advice Service; UWLSU support you with all aspects of your academic experience by providing advice and guidance to ensure you are fully informed of the academic regulations set out by the University as well as advocate for student views.

You are expected to behave in line with UWL expectations, irrespective of whether your interactions with staff and other students are in person or online. As you will be engaging with others online and a range of online materials, it is important to consider how to stay safe online and ensure your communications are secure and appropriate. If you have any questions about how to manage your online UWL activities, please contact your module leader.

If you have an issue about the module, you should speak to your Module Leader or Course Leader informally in the first instance. Your Course Representative can also raise your concerns at Course Committees, which take place each semester. If you are unable to resolve it informally, you should refer to the Complaints Procedure which is outlined in the student handbook and consult the Students’ Union about it. The University aims to ensure that issues are resolved informally as quickly as possible to have minimum impact on your studies.

3.3 Getting support for your studies

Throughout your course of study, you will have access to a wide variety of sources of support depending on your individual circumstances and needs. Your first point of call for getting general academic support is your Personal Tutor. As well as approaching your Module Leader with any questions specifically related to your module and your Course Leader with questions on your Course, do contact your Personal Tutor or Apprenticeship Support Link Tutor for academic advice in relation to your studies and your academic development.

Apart from the University-wide support framework, which encompasses the Module Leaders, Course Leader, the Subject Librarian, and your Course Administrator, you will also have at your disposal the UWL Engagement Team. The Engagement Team offers One-to-One Academic Support opportunities and Academic Skills Workshops throughout the year, helping you to develop skills relevant to your degree. Workshops include for instance Essay Planning and Writing; Critical Thinking; Reflective Writing; Group Work and Presentation Skills. Maths Support and English Language Support opportunities are available too. For more information email or to register for weekly updates email [email protected] or you can visit our website to find out more about the support offered by the Engagement Team, such as Peer Mentoring or online academic skills resources at: uwl.ac.uk/current-students/support-current-students/academic-support

3.4 Student support

In addition to the support listed in the previous section, there is also more help offered by UWL Student Support Services. These are located in The Street at St Mary’s Road, Ealing campus, but offer drop-in sessions at all UWL sites. They offer a wide range of support and advice services consisting of Student Advice, and Funding & Immigration advice; Careers; Counselling; Disability/Mental Health; Inter-faith Advisor; Placement & Employment; Volunteering; Student Welfare; and Scholarships and Bursaries.

Contact Student Services (general) for more information at [email protected] or call 020 8231 2345.

3.5 Module evaluation – have your say!

Towards the end of the module you will be invited to provide some anonymous feedback to the Module Leader through an online survey. This is your opportunity to give some direct feedback about the module through a series of questions and free text. Your constructive feedback will help the Module Leader and teaching team to understand the module experience from your perspective and helps inform the development of the module. At the end of the survey period, a response to the survey will be available on Blackboard so that you can see exactly how your voice has been heard.