638-0411/01 – Methods of Computer Technology (-)

Gurantor departmentDepartment of Automation and Computing in IndustryCredits4
Subject guarantordoc. Ing. Ivo Špička, Ph.D.Subject version guarantordoc. Ing. Ivo Špička, Ph.D.
Study levelundergraduate or graduateRequirementCompulsory
Year3Semesterwinter
Study languageCzech
Year of introduction2004/2005Year of cancellation2010/2011
Intended for the facultiesFMTIntended for study typesBachelor
Instruction secured by
LoginNameTuitorTeacher giving lectures
S1I28 doc. Ing. Ivo Špička, Ph.D.
ZIM018 Ing. Ondřej Zimný, Ph.D.
Extent of instruction for forms of study
Form of studyWay of compl.Extent
Full-time Credit and Examination 2+2
Combined Credit and Examination 14+0

Subject aims expressed by acquired skills and competences

Student will be able to - use more coplicated of office programs functions; - use spredscheets for numerical mathematic tasks solving; - to build a basic hypertext applications; - to build a basic database application.

Teaching methods

Summary

Course proposes students with software of personal computer as a tool for assistance of creative engineering work. It aquatints them with advanced work with word processor, spreadsheet, principles of work with graphics information, working with hypertext and using database systems

Compulsory literature:

SOBOTKA a kolektiv: Office 2000, Computer Press, Praha 2000 MĚSTECKÝ P. a kolektiv.: Microsoft Office 2000 a XP, 1. vydání, Computer Press, Praha 2002 HLAVENKA, J. aj.: Vytváříme WWW stránky a spravujeme moderní web. 1. vyd. Praha : Computer Press, 1997. MILDA, M.: HTML pro začátečníky. Kopp,České Budějovice, 2000.

Recommended literature:

HTML, XHTML and CSS All-In-One For Dummies, For Dummies; 2 edition (November 16, 2010), Language: English, ISBN-10: 0470537558 Effective Java. Joshua Bloch. Publisher: Prentice Hall; 2 edition (May 28, 2008). Language: English. ISBN-10: 9780321356680

Way of continuous check of knowledge in the course of semester

Individual projects for all parts.

E-learning

Další požadavky na studenta

Prerequisities

Subject has no prerequisities.

Co-requisities

Subject has no co-requisities.

Subject syllabus:

1 to 2 Advanced work with a text editor. Text formatting, paragraph styles, document formatting. Templates and guides, gallery style, creating and editing styles. Mail Merge automation with macros. 2 to 3 Advanced techniques for working with spreadsheets. Graphical presentation of data, views, publishing data in WWW. Lists, sorting data, filtering data form summaries. Contingency tables. Analytical tools, scenarios, searching of a solution, the solver. Macros and basics of programming in Visual Basic. Presentations building. Creating the appearance of the presentation, style checking, use the slide master, working with diagrams. Working in different views. Working with slides, adding and formatting text, formatting paragraphs. Drawing and working with objects. Work with formulas, tables and graphs. Starting and management of the presentations. 5th Theory of database systems, modeling of reality, data models, view of reality and relationships between entities. Types of data models. Conceptual diagram. ER model. Physical organization of data. 6th Microsoft Access database, run a program, create a new database, open an existing database, close the database, end programu.Access main window, use the mouse, the menu bar, toolbar, dialog box control wizards, database window, window object database. 7th Working in the table, the data sheet and move it, add a new record, edit an existing entry, data interference in the data sheet, data search, exchange, work with columns, set the appearance of cells. Edit the table structure, create additional tables, relationships between tables. 8th Forms, automatic form, Form Wizard, creating forms using Design view, change forms. Print data- reports, automatic report, Report Wizard, create a report using design view, edit and print reports. Selecting data filters and queries. 9th Fundamentals of language HyperText Markup Language (HTML). Page structure, paragraph writing. 10th Image formats, insert a picture. Uniform Resource Locator, Links on the Sites, a relative URL. Links to the document, the function of pages. 11th Formatting. Titles, website structure, numbered, bulleted list. A list of definitions, preformatted text. 12th Tables, cell attributes, line attributes and tables. Frames and their structure. Content of frames, mutual cooperation. Forms and their functions. Simple input elements, complex input elements. CGI output and input. 13th HTTP protocol. Question - answer, datakeepers, recycled connection. Animation Site, blinking, animated GIF, pseudoanimace HTTP, Java, Javascript. 14th Cascading style definitions, fonts, text properties, block and his friends, block features, formatting pages, working with the list. Navigation, links around the page, navigation bar, content.

Conditions for subject completion

Combined form (validity from: 1960/1961 Summer semester)
Task nameType of taskMax. number of points
(act. for subtasks)
Min. number of points
Exercises evaluation and Examination Credit and Examination 100 (100) 51
        Exercises evaluation Credit 35 (35) 0
                Project Project 20  0
                Other task type Other task type 15  0
        Examination Examination 65 (65) 0
                Written examination Written examination 25  0
                Oral Oral examination 40  0
Mandatory attendence parzicipation:

Show history

Occurrence in study plans

Academic yearProgrammeField of studySpec.FormStudy language Tut. centreYearWSType of duty
2009/2010 (B3922) Economics and Management of Industrial Systems (3902R040) Automation and Computing in Industry P Czech Ostrava 3 Compulsory study plan
2009/2010 (B3922) Economics and Management of Industrial Systems (3902R040) Automation and Computing in Industry K Czech Ostrava 3 Compulsory study plan
2009/2010 (B3922) Economics and Management of Industrial Systems (3902R040) Automation and Computing in Industry K Czech Třinec 3 Compulsory study plan
2008/2009 (B3922) Economics and Management of Industrial Systems (3902R040) Automation and Computing in Industry K Czech Ostrava 3 Compulsory study plan
2008/2009 (B3922) Economics and Management of Industrial Systems (3902R040) Automation and Computing in Industry K Czech Třinec 3 Compulsory study plan
2008/2009 (B3922) Economics and Management of Industrial Systems (3902R040) Automation and Computing in Industry P Czech Ostrava 3 Compulsory study plan
2007/2008 (B3922) Economics and Management of Industrial Systems (3902R040) Automation and Computing in Industry P Czech Ostrava 3 Compulsory study plan
2007/2008 (B3922) Economics and Management of Industrial Systems (3902R040) Automation and Computing in Industry K Czech Ostrava 3 Compulsory study plan
2007/2008 (B3922) Economics and Management of Industrial Systems (3902R040) Automation and Computing in Industry K Czech Třinec 3 Compulsory study plan
2006/2007 (B3922) Economics and Management of Industrial Systems (3902R040) Automation and Computing in Industry P Czech Ostrava 3 Compulsory study plan
2006/2007 (B3922) Economics and Management of Industrial Systems (3902R040) Automation and Computing in Industry K Czech Ostrava 3 Compulsory study plan
2006/2007 (B3922) Economics and Management of Industrial Systems (3902R040) Automation and Computing in Industry K Czech Třinec 3 Compulsory study plan
2005/2006 (B3922) Economics and Management of Industrial Systems (3902R040) Automation and Computing in Industry P Czech Ostrava 3 Compulsory study plan
2005/2006 (B3922) Economics and Management of Industrial Systems (3902R040) Automation and Computing in Industry K Czech Ostrava 3 Compulsory study plan
2005/2006 (B3922) Economics and Management of Industrial Systems (3902R040) Automation and Computing in Industry K Czech Třinec 3 Compulsory study plan

Occurrence in special blocks

Block nameAcademic yearForm of studyStudy language YearWSType of blockBlock owner