Data Handling & Using ICT

SOLUTION AT Australian Expert Writers

Module Study Guide
Academic Year 2020–2021
BA30589E – Data Handling & Using ICT
Level: 3
Credits: 20
Academic Partner: LSST, UKCBC
Table of contents
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
Mariet Geldenhuys
Subject Area & School/College
[email protected]
Academic Support Manager
Sobhi D’ Cruz
[email protected]
020 8518 4994
UKCBC Liverpool street Campus
Subject Librarian
[email protected]
020 8518 4994
Director QAED & In charge for UWL partnership provision
Naga Sai Dinavahi
[email protected]
020 8518 4994
The Course Coordinator overseeing this module is Ms Mariet Geldenhuys, and can be contacted at [email protected]
1.1      Introduction
The module is offered as a part of the level 3 Foundation programme through UKCBC-UWL partnership provision.
Welcome to the module. The weekly subjects can be found on the Ulearn and Blackboard VLE. The module aims to provide students with a conceptual understanding of business organisations in relation to their structure, operation, management and environment.
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.
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.
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.
Teaching Contact Hours
48 hours
Independent Study Hours
152 hours
Total Learning Hours
200 hours
Type of Assessment
Word Count or equivalent
Threshold (if Professional Body-PSRB applies)
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
Week 9
TurnItIn 15 Working Days after submission
Online Test(LO1, LO2, LO3, LO4)
30 minutes
Week 15
15 Working after the submission date
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.
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)
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:
The reading list for this module is available Blackboard and ULearn in the module area. and online by searching UKCBC library. You may also access UWL’s 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 are also available to help you find relevant information for assignments, with contact details of the Academic Support Librarian for students studying at UKCBC.
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, 3rd 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.
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 for an extension  before your deadline. A link for late submissions will be available on Blackboard. You have to make an application to your Module Coordinator for any extension requirements. 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 for further extension based on mitigation circumstances and you are required to provide relevant evidence to support such request.
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 Student support services offered by UKCBC Administration as well as Academic support teams. Please contact [email protected]
Every class will select their class and course representatives who would coordinate on any of your learning issues and support you in your learning, in addition to the formal and informal support provided by UKCBC and UWL.
You are expected to behave in line with UKCBC and 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.
There is a University-wide support framework, which encompasses the Module Leaders, Course Leader, the Subject Librarian, and your Course Administrator. For more information email [email protected] or you can visit our website to find out more about the support offered by UKCBC:
3.4      Student support
In addition to the support listed in the previous section, there is also more help offered by UKCBC Student Support Services. These offer drop-in sessions at UKCBC 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]
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.

Order from Australian Expert Writers
Best Australian Academic Writers