Modern ICT

module: modern ict
Syllabus > Initial survey > Tasks > Lectures&practices > Results

 

Aim, competences
The aim of the course is to provide modern information and communication technologies (MICT) basic knowledge (including MICT conception, principles, models, methodologies and research results) and develop their practical usage skills under constantly renewable modern ICT conditions. To develop the skills to create, publish and maintain an interactive personal website and to build up professional work with a set of office applications – text, presentations, spreadsheets, database management systems (DBMS) and other programs.
Various studying techniques are combined – lectures, seminars, practices, consultations and individual work. In all stages of the study – both during the selection and formulation of tasks, as well as presenting results for the audience and publishing them in a personal website – student problematic attitude, teamwork, independence is promoting.

Learning outcomes
Understanding of modern web technologies and their peculiarities. Ability to create, improve and publish a personal website on the base of modern ICT. The ability to analyze modern ICT, to evaluate their relevance and perspectivity under extremely rapid renewal of modern technologies. Understanding the pecularities of database management systems and be able to solve problems, connected with modelling and realization of relational database. Be aware of data analysis capabilities using spreadsheets technology and be able to use them.

Study methods Involving lectures, problem based teaching, examples analysis, independent work. Evaluation methods Colloquium, exam tests (closed-ended questions). Tasks results (published online).

Assessment
I colloquium [beg. of march][test, moodle]
II colloquium [beg. of may][test, moodle]
Cummulative score [end of may]
The assessment takes into account the ability to give meaning, optimize and convincingly defend the results and ability to use emerging ICT for professional purposes. The cumulative score principle is used.
Accumulative score formula:
the cummulative score = 0.5*knowledge + 0.5* skills
(knowledge – colloquiums results mean; skills – mean of published online and defended results)
Exam: Examination could be carried out only after initial quiz and colloquiums are passed and all tasks results are presented, published and evaluated positively.
End-point formula: final score = 0.6*cumulative score + 0.4*exam score.

lectures

  1. Introduction to the course. [2+1 acad. hours]
    Modern information and communication technologies (MICT). Study process ans evaluation peculiarities.
    Literature and online sources, etc.

    • Individual tasks.
      Course initial survey. Acquaintance with the course description, preparing for discussion. Studies sources finding.
  2. Web technologies. [4+2 acad. hours]
    HTML versions. Website source code, it’s structure and basic peculiarities. HTML code examples. Simple website creation and publishing peculiarities.

    • Individual tasks.
      HTML code examples analysis. Settling on the web: simple website creation and publishing.
  3. Web technologies. [6+3 acad. hours]
    Website formatting peculiarities. Cascading style sheets (CSS) technology. CSS code examples. Browser scripting technologies and their importance for websites flexibility.

    • Individual tasks.
      Website development using CSS and browser scripting technologies. Selected MICT actuality (theme selection, sources finding and analysis).
  4. Web technologies. [4+2 acad. hours]
    Interactive web technologies (server scenarios). Simple PHP code examples analysis. Website validation, etc.

    • Individual tasks.
      Website development using interactive technologies (user’s counter, questbook, etc.). Selected MICT actuality (sources analysis, presentation). Preparing for the first colloquium.
  5. Office technologies. [4 acad. hours]
    Office software as modern ICT (including mobile, cloud computing and other emerging technologies). Microsoft Office, Office 365, Google docs, Open Office, etc., actual features analysis and demonstration.

    • Individual tasks.
      Selected MICT actuality presentation and publishing (online). Selected problem solving using Office ICT,  actual modern ICT features demo.
  6. Office DBMS technologies. [8+4 acad. hours]
    Database management systems (DBMS). Database planning (DB needs identification and analysis, conceptual modeling, converting to relational model) and realization with Office DBMS (e.g. with MS Access).

    • Individual tasks.
      Database project.
      Selected data management problem solving and DBMS technology possibilities demo (theme selection, DB needs collection and analysis, conceptual model, relational model, realization).
      Results presentation and publication (online).
      Preparing for second colloquium.
  7. Data analysis. [4+2 acad. hours]
    Data analysis problematics and technologies. Spread sheets technology and it’s pecularities.

    • Individual tasks.
      Data analysis project.
      Selected data analysis problem solving and spreadsheets technology possibilities demo.
      Results presentation and publication (online).

      • criteria for solution
        • user friendly
          • handy
          • with context
          • help, menu, visual, etc.
        • safe
          • e.g., non destroyable
        • technologically correct
        • spreadsheets main possibilities demo
          • calculations
          • formulas
          • macros
          • etc.
        • context for evaluation