|
|
Main menu for Browse IS/STAG
Course info
KID / YATET
:
Course description
Department/Unit / Abbreviation
|
KID
/
YATET
|
Academic Year
|
2023/2024
|
Academic Year
|
2023/2024
|
Title
|
Text Editors and Spreadsheet Processors
|
Form of course completion
|
Examination
|
Form of course completion
|
Examination
|
Accredited / Credits
|
Yes,
4
Cred.
|
Type of completion
|
Combined
|
Type of completion
|
Combined
|
Time requirements
|
Seminar
20
[Hours/Semester]
|
Course credit prior to examination
|
No
|
Course credit prior to examination
|
No
|
Automatic acceptance of credit before examination
|
No
|
Included in study average
|
YES
|
Language of instruction
|
Czech
|
Occ/max
|
|
|
|
Automatic acceptance of credit before examination
|
No
|
Summer semester
|
0 / -
|
0 / -
|
0 / -
|
Included in study average
|
YES
|
Winter semester
|
50 / -
|
0 / -
|
0 / -
|
Repeated registration
|
NO
|
Repeated registration
|
NO
|
Timetable
|
Yes
|
Semester taught
|
Winter semester
|
Semester taught
|
Winter semester
|
Minimum (B + C) students
|
not determined
|
Optional course |
Yes
|
Optional course
|
Yes
|
Language of instruction
|
Czech
|
Internship duration
|
0
|
No. of hours of on-premise lessons |
0
|
Evaluation scale |
A|B|C|D|E|F |
Periodicity |
každý rok
|
Periodicita upřesnění |
|
Fundamental theoretical course |
No
|
Fundamental course |
No
|
Fundamental theoretical course |
No
|
Evaluation scale |
A|B|C|D|E|F |
Substituted course
|
None
|
Preclusive courses
|
KID/XATET and KID/XCTET and KID/YCTET
|
Prerequisite courses
|
N/A
|
Informally recommended courses
|
N/A
|
Courses depending on this Course
|
N/A
|
Histogram of students' grades over the years:
Graphic PNG
,
XLS
|
Course objectives:
|
The main goal of the discipline is to familiarise students with the advanced methods of creating documents with text editor MS Word, and working and analyzing data with spreadsheet MS Excel.
|
Requirements on student
|
Process of the exam and other information see document available from the information system STAG.
|
Content
|
Introduction to the Word editor. Basic document formatting.
Styles and templates. Page setup, document sections.
Tables. Using fields.
Working with graphics.
Cross-references, captions, bookmarks. Tables of contents, index, and tables of figures.
Equation editor. Mail merge. Sharing information with other users.
Introduction to the Excel. Formulas, functions.
Working with workbook and worksheet. Circular reference. Validating cell entries.
Charts and graphics.
Using lists, filtering and sorting data.
PivotTable and PivotChart reports.
Analyzing data. Solver, what-if analysis, scenarios, statistical analysis tools.
Forms, workbook and worksheet protection, data sharing. Macros.
|
Activities
|
|
Fields of study
|
|
Guarantors and lecturers
|
|
Literature
|
|
Prerequisites - other information about course preconditions |
Basic knowledge of Microsoft Windows, Word and Excel is assumed. |
Competences acquired |
After finishing this course student knows most of features of text editor Microsoft Word and spreadsheet Microsoft Excel in addition to programming in Visual Basic language. |
Teaching methods |
- Monologic (reading, lecture, briefing)
- Demonstration
- Projection
- Skills training
|
Assessment methods |
|
|
|
|