Informatics for Engineers I

Code: mk3infea04rx17-en
ECTS Credit Points: 4
Evaluation: mid-semester grade
Year, Semester: 1st year, 1st semester
Its prerequisite(s): -
Further courses are built on it: Yes/No
Number of teaching hours/week (lecture + practice): 2+2

Topics:

History of computers, Number systems, number representations, bit, byte, ascii, unicode, hardware, cpu, i/o, Operating systems (bios, dos…), Network architectures (topologies, router, gateway, dns, IP address), Internet security (https, digital signature…), Databases (basic concepts, database model, dmbs …), Databases (sql) , Data structures (datatypes, array, list, stack, tree…), Algorithms (sorting, searching…), Computer programming (history of programming, programming languages, Pseudo code, flowchart, development models), Computer programming (variable declarations, datatypes (C), control structures, loops…)

Literature:
Compulsory:

  • Microsoft Excel 2016 Bible: The Comprehensive Tutorial Resource
  • Microsoft Access 2016 Bible: The Comprehensive Tutorial Resource
1st week 8th week
Registration week Excel test
2nd week 9th week

Lecture: History of computers
Practice: Excel 1.
Introducing Excel.
Basics concepts and functionalities:

  • Parts of the user interface (workbook, worksheet, cell, range…)
  • Entering and editing data, data types.
  • Fill a Range with Series.

Basic functions: sum, average, count, counta, countif, min, max

Trigonometric functions: sin, cos, tan, pi, radians

Logical functions: true, false, and, or

Lecture: Databases (basic concepts, database model,DBMS …)
Practice:

  • Database basics, relational database model
  • Tables, records, fields, keys, primary keys, indexes.
  • Relationship between tables, relationship types.
  • Design and create a database from a dataset
3rd week 10th week

Lecture: Number systems, number representations, bit, byte, ascii, unicode
Practice:

  • Formatting and editing Worksheet:
  • Font type and size.
  • Align Text.
  • Number Format.
  • Column With, Row Height.Borders.
  • Wrap Text.
  • AutoSum functionality.
  • Conditional formatting.

Lecture: Databases (Sql)
Practice: User interface of the software.
Database manipulation:

  • Create a new database.
  • Data types.
  • Create and import tables.

Insert, delete, update records, fields.
Create relation between tables, referential Integrity.
4th 11th week

Lecture: Hardware, cpu, i/o
Practice:

Formulas:

  • Building Formulas.
  • Move or copy a Formula.
  • Reference another Range in a Formula.
  • Naming groups of data.

Conditional and database functions:if,sumif,choose,vlookup, hlookup

Lecture: Data structures (datatypes, array, list, stack, tree…)
Practice:

Data manipulation:

  • Format. Input masks.
  • Fast finding, filtering, and sorting data.
  • Sql basics.

Select query: where, and, or, order by, group by
5th week 12th week

Lecture: Operating systems (bios,dos…)
Practice:

Analyzing data:

  • Ordering, summarizing, a range.
  • Filter a Range.
  • Summarize data with subtotals.

Lecture: Algorithms (sorting, searching…)
Practice: Queries:

  • Crosstab
  • Make table
  • Append
  • Update
  • Delete
  • Calculated fields.
  • Summarizing data.
6th week 13th week

Lecture: Network architectures (topologies, router, gateway, dns, ip address)
Practice: Graphical representation in Excel:

  • Creating Charts.
  • Chart types.
  • Chart Elements.
  • Format and customize Excel Charts.
 Lecture: Computer programming (history of programming, programming languages, Pseudo code, flowchart, development models )
Practice: Forms.
Reports.
7th week 14th week

Lecture: Internet security (https, digital signature…)
Practice: Practice for the test.

 Lecture: Computer programming (variable declarations, datatypes (C), control structures, loops…)
Practice: Practice for the test
15th week  
Acces test  

Requirements
A, for a signature:

  • participation on the practices
  • at least satisfactory result on both midterm tests

Requirements for the grade:

  • same as above
  • final grade = average of the two grades of the midterm tests
Last update: 2023. 10. 16. 15:11