|
Subject: |
Applied information technologies |
|
Goal subject: |
To acquire applied skills in the advanced level of text editors and spreadsheets usage |
|
Date: |
11.2.2008 |
|
Semester: |
Summer |
|
Range: |
1 talk lesson (Lecture) 2 lessons of practical training (Seminar) |
|
End-subject: |
Exam |
|
Guarantee: |
Ing. Hana Šrámková, Ph.D. |
|
Teachers: |
Ing. Hana Šrámková, Ph.D. -Czech Ing. Hana Šafránková -Czech Ing. Karel Šrámek - English Mgr. Hana Rohrová - Czech |
|
Source information: |
Basic IT concepts (hardware, software, security, authors law) Basic operations with files (creating of folders, making copies, renaming, searching, …) Basic user skills in using text editors Basic user skills in using Internet and related services (e-mail, …) |
|
Contents subject: |
Working with large documents (set up of publications – e.g. theses) Writing with the outline display Content, index, list of pictures Bookmarks, titles, cross-references Annotations, footnotes Graphical tools of text editor WordArt, Drawing tool panel Team projects Planning of large documents Main document Nested documents Merging the documents Introduction to spreadsheets Data input and editing Formatting 3D connections Working with sheets and windows Names and overviews Lists (internal databases) Sorting the database (by one field, by more fields) Filtering (automatic, extended) Charts Data row, single data Making charts in the vizard Graphical sheets Editing of charts Formatting of charts Data transfer between applications Copying from other application Sharing of information OLE objects Text import |
|
Recommended literature: |
Microsoft Office Excel 2003 Bible, John Walkenbach, Wiley 2003 Microsoft Office Word 2003 Bible, Brent Heslo, David Angell, Peter Kent, Wiley 2003 |