Computer Science

Syllabus

  • Website creation in HTML
  • OpenOffice.org: Writer, Impress, Drawing, Calc
  • Analysis of speech signal

Requirements

  • Website with HTML elements presented in class with web portfolio
  • OpenOffice document: OO Writer and OO Impress with figures created in OO Drawing and charts and tables created in OO Calc
  • Annotation of a speech file
  • Attendance in class (2 absences allowed)
  • Registration at USOS

Classes

  1. 2012-10-02 & 2012-10-04: HTML and website creation
  2. 2012-10-09 & 2012-10-11: HTML website creation: Uploading websites on a server
  3. 2012-10-16 & 2012-10-18: Forms and frames
  4. 2012-10-23 (cancelled) & 2012-10-25: Frames & introduction to CCS
    CSS Tutorial
    Over 150 CSS Examples
    CSS Demo
  5. 2012-10-30 & 2012-11-01 (All Saints' Day): Frames & CSS
  6. 2012-11-06 & 2012-11-08: Students' individual work - websites creation.

    Setting an image as a background image

    BEFORE AFTER

  7. 2012-11-13 & 2012-11-15: Introducing OpenOffice.org and LibreOffice - professional text formatting
    OpenOffice.org
    LibreOffice
    Homework - Read:

  8. 2012-11-20 & 2012-11-22: OpenOffice.org Writer - Text Formatting
  9. 2012-11-27 & 2012-11-29: Advanced functions in OpenOffice.org
    • professionally formatted styles
    • automatically numberred headings
    • lists
    • tables
    • figures
    • cross-references to tables and figures in the text
    • title page
    • Table of Contents, Index of Figures, Index of Tables, Alphabetical Index
    • automatically numberred pages
    • footnote
    • notes
    • sections
    • record/show changes
    • record macro & assign to keyboard shorcut
    • mathematical formulae
    • bibliography
  10. 2012-12-04 & 2012-12-06: OpenOffice.org Writer - bibliography database & students' individual work
  11. 2012-12-11: OpenOffice.org Impress
  12. 2012-12-13: OpenOffice.org Writer - students' individual work
  13. 2012-12-18: OpenOffice.org Impress- students' individual work
    Converting MP4 to WMV
    Cutting videos
  14. 2012-12-20: OpenOffice.org Calc & OpenOffice.org Draw
  15. 2013-01-01: NEW YEAR 2013!
  16. 2013-01-03: OpenOffice.org Impress
  17. 2013-01-08: OpenOffice.org Impress - students' presentations
  18. 2013-01-10: OpenOffice.org Impress - students' individual work
  19. 2013-01-15: OpenOffice.org Calc & OpenOffice.org Impress - students' presentations

    OpenOffice.org Calc

    • Using worksheets
    • Formatting cells - fonts & data types (text, numbers, currency, date, time, etc.)
    • Insert/Remove & Hide/Show Rows and Columns
    • Find & Replace functions
    • Paste special
    • Printing sheets - 'Define' ranges function
    • Sorting data
    • Filtering data
    • Remove duplicates
    • Creating and formatting charts: column, bar, line, pie and stock chart types
    • Creating calculations
    • The "IF" function
    • Relative vs. absolute addresses
    • Pivot table
  20. 2013-01-17: OpenOffice.org Impress - students' individual work
  21. 2013-03-04: OpenOffice.org Draw & Praat: doing phonetics by computer & SAMPA for Polish