BS0090 Computer Lab

Code BS0090
Name Computer Lab
Status Compulsory/Courses of Limited Choice
Level and type Undergraduate Studies, Academic
Field of study Computer Studies
Faculty
Academic staff Ojārs Krūmiņš, Ronalds Cinks
Credit points 9.0
Parts 3
Annotation The study course offers hands-on experience and practical learning in fundamental software applications essential for modern professional environments. Through a pedagogically structured approach, students will develop proficiency in Microsoft Word, Excel, and PowerPoint, alongside introductory skills in SQL (Structured Query Language). Emphasizing experiential learning, the study course equips students with the necessary tools to navigate and utilize these software applications efficiently..
Contents
Content Full- and part-time intramural studies Part time extramural studies
Contact hours Independent work Contact hours Independent work
Document editing; Text and paragraph formatting; Document formatting; Merger. 6 6 0 0
Work with text styles; Working with the table of contents. 6 6 0 0
Creating and formatting tables, Charts; Work with emails. 6 6 0 0
Document illustration with Graphics, shapes, text box and WordArt Organizing objects, SmartArt graphics; Cooperation with colleagues. 6 6 0 0
Work with references. 6 6 0 0
Technical and oral presentation skills. 6 6 0 0
Main MS Excel workbook elements and visualization features; MS Excel settings; formula basics. 6 6 0 0
Navigation; Counting formulas; Calculation formulas; Locking cells. 6 6 0 0
Numbers in Excel; Conditional formulas & formatting; Charts. 4 4 0 0
Data validation; Indirect; Dynamic lists; Working with text; Date and time formulas. 6 6 0 0
Working with lookup and reference formulas. 4 4 0 0
Creating and formatting elements; Data table; Pivot table; Pivot chart. 6 6 0 0
Financial formulas; What-if Analysis Tools; Dashboards I; Dashboards II. 6 6 0 0
VBA Macros; Review of concepts for final exam. 4 4 0 0
Database concepts, database system significance for an IT solution and implementation options. 6 6 0 0
Data models; Relational data model; Implementation of the relational model; SQL DDL. 6 6 0 0
Design of the database from the business perspective, entities, and intended functionality of the database system. 6 6 0 0
Good and bad designs; Normal forms; Anomalies; Querying database with SQL. 10 10 0 0
Database system; Various database system objects. 4 4 0 0
Intro to data analytics with SQL; SQL for data analytics. 6 6 0 0
Future trends and opportunities in database systems. 4 4 0 0
Total: 120 120 0 0
Goals and objectives
of the course in terms
of competences and skills 		The goal of the study course is to develop skills in working with Microsoft Office and to introduce basic skills in SQL. The objectives of the study course: - to develop competence in creating, formatting and editing documents using Microsoft Word; - to teach to apply advanced formatting techniques and effectively use collaboration tools in Microsoft Word; - to teach how to use the Microsoft Excel programme for data entry, analysis and visualization using formulas, functions and diagrams; - to teach how to create dynamic and visually engaging presentations using Microsoft PowerPoint, including multimedia elements and animations; - to introduce the basic principles of databases and relational database management systems (RDBMS); - to introduce the importance of database solutions in information technology for business; - to teach different data organization models and the mathematical and logical basis of relational data models; - to teach how to apply SQL concepts to efficiently obtain, filter and sort data from databases.
Learning outcomes
and assessment 		Can utilizes Microsoft Excel for data entry, manipulation, analysis, and visualization using formulas, functions, and charts. - Practical work in class and homework.
Can create dynamic and visually engaging presentations using Microsoft PowerPoint, incorporating multimedia elements and animations. - Practical work in class and homework. Exam.
Understands the fundamentals of databases and relational database management systems (RDBMS). - Practical work in class and homework. Quiz.
Understands the significance of database solutions in information technology for business. - Practical work in class and homework.
Knows various data organization models and will know the mathematical and logical basis of relational data models. - Practical work in class and homework. Exam.
Can apply SQL concepts to extract, filter, and sort data from databases efficiently. - Practical work in class and homework. Quiz.
Evaluation criteria of study results
Practical work in class and homework - 30%
Quizzes - 30%
Exam - 40%
 
Course prerequisites No preconditions
Course planning
Part CP Hours Tests
Lectures Practical Lab. Test Exam Work
1 3.0 20.0 20.0 0.0 *
2 3.0 20.0 20.0 0.0 *
3 3.0 20.0 20.0 0.0 *