Module Specifications.
Current Academic Year 2024 - 2025
All Module information is indicative, and this portal is an interim interface pending the full upgrade of Coursebuilder and subsequent integration to the new DCU Student Information System (DCU Key).
As such, this is a point in time view of data which will be refreshed periodically. Some fields/data may not yet be available pending the completion of the full Coursebuilder upgrade and integration project. We will post status updates as they become available. Thank you for your patience and understanding.
Date posted: September 2024
| |||||||||||||||||||||||||||||||||||||||||||||||||
|
Repeat the module |
|||||||||||||||||||||||||||||||||||||||||||||||||
|
Description The module aims to develop the relevant skills and knowledge to effectively use basic IT tools to manage and manipulate data and provide a basic IT data management ‘literacy’ that is now an essential feature of work in modern organisations. Online tools are used to provide students extensive training in MS EXCEL, an Introduction to Data Visualisation and Viulaisation Software (Power BI and Tableau) and support in developing their MS WORD, POWERPOINT and other IT skills that are needed to collect, critically assess, manipulate data to provide useful information for management. Students are also introduced to data types, data collection, data management and basic data analysis and given an introduction to Data Analytics and the growth of data and data driven functions in organisations. | |||||||||||||||||||||||||||||||||||||||||||||||||
|
Learning Outcomes 1. Will be able to describe the fundamental concepts of Data Literacy and Analytics, the key steps in the analytics process, and the applications and implications of data analytics. 2. Distinguish between different data types, choose the appropriate techniques for gathering reliable and valid primary data and identify and extract data from reliable secondary data sources. 3. Apply the basic principles of effectively communicating data visually using software applications, including MS EXCEL, POWER BI and TABLEAU. 4. Use the appropriate descriptive statistics techniques to effectively summarise a wide variety of data types. 5. Be proficient in the use of MS EXCEL spreadsheet software. | |||||||||||||||||||||||||||||||||||||||||||||||||
All module information is indicative and subject to change. For further information,students are advised to refer to the University's Marks and Standards and Programme Specific Regulations at: http://www.dcu.ie/registry/examinations/index.shtml |
|||||||||||||||||||||||||||||||||||||||||||||||||
|
Indicative Content and Learning Activities
Introduction to Data Analytics- What is Data Analytics - Evolution - Role in the OrganisationInformation Systems/Fundamentals of SoftwareIntroduction to Information Systems in organisations and how they are used to enable operations and strategySkills and Tools to Organise- Setup (download applications & setup accounts), Organise - Accessing online learning support tools, LOOP, Zotero, Library, ISS, etc. - Manage professional social media profile – LinkedIn profile etc. - Introduction to Kubicle (Online Learning Platform) - Report and Presentation (MS WORD and MS POWERPOINT) - Spreadsheets (Introduction to MS EXCEL) - Google Apps (Google Docs, Google Sheets, Google Forms)Introduction To Data Visualisation- What is Data Visualisation and Why is it important? - Introductions to Data Visualisation in MS EXCEL, Communicating using Visualisations - Choosing correct tools - Introduction to TABLEAU and POWER BISources of Data / Cleaning DataPrimary Data: Questionnaires (Using Google sheets and Qualtrics), Focus Groups, Interviews, Observation Secondary Data Sources, “Big Data” 5 Vs of Big Data, Data Types: Structured / Unstructured, Measurement Error, Cleaning DataBusiness Statistics 1: Descriptive StatisticsDescribing Data - Frequency Tables - Descriptive Statistics - Crosstabs - Data Visualisation (Patterns in Data)MS EXCEL - Data Manipulation and FormattingAdding, Editing and Deleting Cells, Essential Shortcuts in MS EXCEL, Inserting Rows and Columns, Adjusting Rows and Columns, Formatting Cells, Grouping and Hiding Cells, Sorting and Filtering CellsMS EXCEL - Formula and FunctionsBasic Arithmetic Functions, Conditional Arithmetic, Max, Min and Average Functions, Logical Operators, Naming and Anchoring Cells, Array Formulas, Conditional Arithmetic, Generating Random Numbers, Formula Auditing, Fill Commands, Information Functions, Rounding Numbers,MS EXCEL - Text, Time and DatesCombine Strings of Text, Search for Strings in Datasets, Covert Dates from Text into Values, Analyse Data by Day of Week, Combine Dates and Times, Add annd Subtract Times, Analyse Data within Time IntervalsMS EXCEL - Lookup and Database FunctionsFinding records with Vlookup, Naming Arrays, Lookups with INDEX and MATCH, Nested IF, Dropdown List, Ranking Data Records, Lookup Multiple Criteria, Database functions, Updating Formula with New Data,MS EXCEL - Pivot TablesBuilding Pivot Tables, Formatting Pivot Tables, Pivot Table Subtotals, Sorting Pivot Table, Data, Applying Filters, Pivot Table Slicers, Build Charts from Pivot Tables, Using Pivot Table Data in Formulae.MS EXCEL - Basic Statistics using MS EXCELMean, Median and Mode, Creating Databins, Variance and Standard Deviation, Finding Trends in Data, Correlation,MS EXCEL - Creating Charts in MS EXCELFormatting Charts, Adding Labels and Chart Titles, Legends and Data Tables, Actual vs Target Charts, Export Charts to MS WORD or POWERPOINT | |||||||||||||||||||||||||||||||||||||||||||||||||
| |||||||||||||||||||||||||||||||||||||||||||||||||
|
Indicative Reading List | |||||||||||||||||||||||||||||||||||||||||||||||||
|
Other Resources 59367, Online Training, Kubicle, 0, Online Analytics Training for Business, 59368, Book, Frye, Curtis., 2016, Microsoft Excel, Redmond, Washington, USA:, Microsoft Press, 59369, Ebook, Michael Alexander, Richard Kusleika, 2019, Excel 2016 Formulas, John Wiley & Sons, 59370, Website, 0, Microsoft Online Support, https://support.office.com/, 59371, Ebook, Justin Bateh and Bert G. Wachsmuth, 2016, Using Statistics for Better Business Decisions, Business Expert Press, 59372, EBook, Cole Nussbaumer Knaflic, 2015, Storytelling with Data : A Data Visualization Guide for Business Professionals,, John Wiley & Sons, 59373, Book, Tufte, Edward R., 2001, The Visual Display of Quantitative Information. 2nd edition., Graphics Press USA, 59374, EBook, EMC Education Services, 2015, Data science & big data analytics: discovering, analyzing, visualizing and presenting data, Indianapolis, Indiana, John Wiley, https://ebookcentral-proquest-com.dcu.idm.oclc.org/lib/DCU/detail.action?docID=1908952, 59375, Book, Bocij, Paul, Andrew Greasley, and Simon Hickie, 2014, Business Information Systems, 5th Edn: Technology, Development and Management for the E-Business, Harlow, England ;, Pearson, 59376, Ebook, Mark N. K. Saunders, Adrian Thornhill and Philip Lewis, 2017, Research Methods for Business Students, Pearson Education Limited, 59377, Ebook, Jaggia S, Kelly A., Lertwachara K. and Chen L., 2020, Business Analytics: Communicating with Numbers, McGraw Hill, | |||||||||||||||||||||||||||||||||||||||||||||||||