IV0070 Computer Science (basic course)

Code IV0070
Name Computer Science (basic course)
Status Compulsory/Courses of Limited Choice
Level and type Undergraduate Studies, Academic
Field of study Computer Studies
Faculty Faculty of Engineering Economics and Management
Academic staff Jana Eriņa, Leonards Budņiks, Aleksandrs Fiļipovs, Vladislavs Minkevičs, Marija Dobkeviča, Jeļena Jevsjukova, Eduards Rēns, Lāsma Lēruma
Credit points 4.0
Parts 1
Annotation Fundamental concepts of information. Computers and their types. Text editors. Program Word. Logical functions. Concept and structural scheme of an algorithm. Use of algorithms in problem solving. Program MathCad. Mathematical calculations - statistical processing of data. Approximation, assessment of errors, forecast, optimization. Resolution of problems by applying MathCad. Presentation of the laboratory work using Powerpoint..
Contents
Content Full- and part-time intramural studies Part time extramural studies
Contact hours Independent work Contact hours Independent work
MS Word tools, FEEM formatting guidelines for study and graduate papers (theory) 4 4 2 8
MS Word tools, FEEM formatting guidelines for study and graduate papers (1st test) 4 4 2 8
Data input in tables, formulas (lab. work) 3 3 1 4
Charts and data visualization (lab. work) 3 3 1 4
Work with mathematical functions (lab. work) 3 3 1 4
Work with logical functions (lab. work) 3 3 1 4
Work with text, date and time functions (lab. work) 3 3 1 4
2nd test 3 3 1 4
Excel tables and basic lookup (lab. work) 3 3 1 4
Data lookup with INDEX, MATCH functions (lab. work) 3 3 1 4
Pivot Table tool. Basics (lab. work) 3 3 1 4
Pivot Table tool. Advanced reports (lab. work) 3 3 1 4
Programming in MS Excel environment I (lab.) 3 3 1 4
Programming in MS Excel environment II (lab.) 3 3 1 4
3rd Test 2 2 1 4
Data processing, data role in entrepreneurship, theoretical classes 14 14 7 28
Total: 60 60 24 96
Goals and objectives
of the course in terms
of competences and skills 		The goal of the subject is to teach students to use MS Office (MS Excel, MS Word, MS PowerPoint) in document creation and its formatting, processing and visualization, as well as its presentation.
Learning outcomes
and assessment 		Can use MS Word capabilities, are informed and understands FEEM formatting guidelines for study and graduate papers - 1st Test
Understands and can use basic Ms Excel features and functions - cell formatting, data types, mathematical, logical, date, time, text functions - 1st Test 2nd test Laboratory works 1 till 7
Understands and can build different reports using Ms Excel tools and functions - lookup functions, Pivot table tool. Can record a macro, edit macro, build user defined function and form - 3rd test Laboratory works 8 till 12
Evaluation criteria of study results
Laboratory works 1-12 - 40%
Tests 1-3 - 60%
 
Course prerequisites Mathematics and informatics at the secondary school level.
Course planning
Part CP Hours Tests
Lectures Practical Lab. Test Exam Work
1 4.0 20.0 0.0 40.0 *
[Extended course information PDF]