Information Technology and Computer Literacy

The course is not on the list Without time-table

Code	Completion	Credits	Range	Language
51ITP	Z,ZK	4	0P+3C	Czech

Garant předmětu:

Lecturer:

Tutor:

Supervisor:

Institute of Pedagogical and Psychological Studies

Synopsis:

Students will learn how to adjust MS Excel user interface, to create, edit and format tables, enter basic as well as advanced formulas and functions (with economic and managerial applications); to understand and apply absolute / relative cell references, create and format charts. They will learn to work with databases in Excel and learn how to use the functions for searching, sorting data, using conditional formatting. Students will become familiar with multiple consolidation ranges, analyze external data source, as well as large spreadsheets or databases to create more complex types of graphs, create a PivotTable and graphs.

Requirements:

Syllabus of lectures:

1. Introduction to basic concepts of computer science, information infrastucture at CTU in Prague, Computer History, Information Society (e-learning, content distribution to the target users), the current paradigm of IT

2. Generation of computers, architecture, hardware

3. Software (SW)

4. Operating systems, installation, personification, work with OS Windows, system utilities (maintenance, backup and recovery), remote desktop, virtual private network (VPN); virtualization

5. Effectiveness of Information System, Cloud computing (development, distribution, application, examples)

6. Time management from the perspective of information technology (GTD, scheduling, sharing, workflow)

Syllabus of tutorials:

1.Basic of MS Excel 2010, User Interface

2.Conditional Formatting

3.Formulas and Functions in MS Excel 2010

4.Data Validation

5.Working with Charts

6.Working with Databases

7.Developer

8.PivotTables, PivotCharts

9.What-If Analysis, Solver

Study Objective:

The goal of the course is to provide students with the basic overview of the world of information technologies. Succesfull graduates will get basic overview of the world of hardware, as well. Furhtermore, they will be able to work independently with MS Office Excel and use basic functions to create, tables, graph and analyze data.

Study materials:

Basic reading:

Lambert J. Cox J. MOS 2010 Study Guide for Microsoft Excel, Microsoft Press 2011.