GEIT – 2101.1 Data Visualization and Management
Basic Course Details
- Course Information
- Course Code: GEIT 2101.1
- Course Name: Data Visualization and Management
- Language: English
- Number of Credits: 1 Credit
- Prerequisites: GEIT 1201.2
- Compulsory/Optional: Compulsory for all Students
- Marks Distribution
- Continuous Assessment: 40%
- Final Assessment: 60%
- Time Distribution
- Theory: 15 Hours
- Practical: 10 Hours
- Self Learn: 25 Hours
Course Introduction and Objectives
This compulsory course module aims to identify and learn advanced features of MS Excel to analyse, visualize and present data, learn how to integrate Excel and Access to manage data, learn basic features of Microsoft Access, learn to manage a small database using excel data and raw data, and then generate essential reports using the access database.
Intended Learning Outcomes
1.Examine database concepts and explore the Microsoft Office Access environment.
2. Design a simple database, build a new database with related tables, manage the data in a table.
3. Create and share compelling data visualizations.
4. Find and integrate data from multiple data sources in both Access and Power Bi applications.
5. Enrich data with calculations and other features available in Power BI.
Lecturer(s) in Charge
Lecturer (Probationary)
Department of ICT
BSc (Hons)(Comp. Sci.)(USJ), MBCS (UK),
MIEEE (USA)
Ms. Pasangi Perera
Lecturer (Contract)
Department of ICT
BSc (Hons)(Comp. Sci.)(USJ)
Assistant Lecturers/ Instructors
Miss. Isiri Indurangala
Temporary Assistant Lecturer
Department of ICT
BSc (Hons)(Comp.Sci.) NSBM
Instructor
CDEPD
BSc (Hons) (UoM)
