Directory listing: 2019-Mannheim-Summer-School

Excel guidelines for melody modelling

I will go through this procedure with you in the next class, so please don't panic if it doesn't work for you.

To use the CSV file in Excel (please let me know whether this method works, and if you find another method):
  1. In Praat, select the interval for which you need the pitch listing.
  2. Under "Pitch" select "Pitch listing".
  3. Save the file with the file name "pitch.csv"
  4. Load the CSV file into Excel.
  5. Click on column A.
  6. Click on "Data" in the top menu.
  7. Select "Text to Columns" (or similar)
  8. Click on "Finish" (or similar) (otherwise select "Space")
  9. You may need to change the --undefined-- text (where Praat did not find any melody because of silence or a voiceless consonant) to 0.0 - you can do this by marking the whole Excel table and using the "Search and Replace" function.
  10. Then make a chart using the two columns.
Then it should be correctly formatted.
To create a diagram, select "Insert" in the top menu, select the arrow on the Diagram icon with crossing lines, select the top left option with lines.
That's it. And continue from there, perhaps with the help of internet search, but do let me know if it works / if you have found a better procedure / if it doesn't work. Thanks!
Sorry Excel is so much more obscure than LibreOffice Calc!
  1. Course description
  2. Sessions
    DateTopicMaterials (see also Section 4 below)Notes
    Fri 2019-06-13, 10:451. Speech and MusicClass01-1-Practicalities.pdf
    Introduction, organisation, basic concepts from language and music
    Tue 2019-06-18, 08:302. BasicsClass03-Phonetics-Overview.pdfBasics of speech sound production, transmission and perception (to be dealt with later)
    Tue 2019-06-18, 10:453. Practical workClass02-Phonetics-Praat-Intro.pdfVoice recording and editing with Audacity, voice annotation with Praat, annotation analysis with TGA
    Mon 2019-06-24, 15:304. Rhythm Class04-Rhythm.pdf
    Gibbon, Dafydd (2018). The Future of Prosody: It's about Time. Keynote address at Speech Prosody 9, Poznan. PDF
    Introduction; recording, annotation
    Wed 2019-06-26, 13:155. Measuring rhythmPraat, TGA, CRAFT analysis
    Fri 2019-06-28, 08:306. Melody Class06-Melody.pdf
    Gibbon, Dafydd (2017). Prosody: The Rhythms and Melodies of Speech. PDF
    Introduction; Praat analysis
    Fri 2019-06-28, 10:457. Measuring melodyPraat analysis and CRAFT analysis
    Tue 2019-07-02, 08:308. Project preparationFinal decisions on project topics, data, methods
    Tue 2019-07-02, 10:459. Project discussionPreliminary reports on projects; detailed work; discussion of technical issues
    Wed 2019-07-03, 15:3010. Project discussionPreliminary reports on projects; detailed work; discussion of presentation issues
    Thu 2019-07-04 13:1511. Project reports10 minute PPT, ODP etc. presentations with graphics and sound: introduction, data description, method description, results, conclusion
  3. Projects
    In Class 04 to Class 10 the topics will relate to your projects. In Class 11 you will present your project with your favourite presentation software (e.g. PowerPoint, LibreOffice Calc, ...).
    Some of you have already designed your own projects. If you are not yet sure about your project, one possibility would be the following:
    1. Choose a language text (for example, from the list of translations of "The North Wind and the Sun" below), or write your own text or dialogue (no more than about 120 words).
    2. Record the text or dialogue, making sure that the recording is of good quality with no clipping.
    3. Preprocess the recording with Audacity: cut silences at the beginning and the end to about 0.5s each, normalise the amplitude of the utterance to -0.2 dB.
    4. Add an annotation of the syllables to the recording, using Praat.
    5. Make screen-shots of
      • the waveform,
      • the intensity (to illustrate the syllable rhythm),
      • the fundamental frequency (to illustrate the melody),
    6. Use TGA to find rhythm-related properties:
      • the most frequent syllable
      • the average duration and average frequency (syllable rate) of the rhythm of the syllables,
      • the slope and nPVI values of the syllable sequence,
      • the Wagner quadrant plot of the relation between syllable pairs.
    7. You can optionally use Excel or LibreOffice Calc (or other suitable software) to do further statistical analyses (the end of the TGA output provides a suitable output format for this, which can be copied and pasted into a text editor, and saved as a CSV file).
    8. You can also use Excel, etc., to calculate properties of the fundamental frequency, which can be extracted using Praat.
    9. Finally, design and create your project presentation. Please note that the following aspects of the presentation should be taken into account (see also the Class 01 "Practicalities" materials above):
      • Working hypothesis / research question: Is there a clear working hypothesis? Is the result clearly demonstrated as confirmation or rejection of the working hypothesis?
      • Data: Are the criteria for choosing the data clearly described
      • Method: Is the method clearly presented and well illustrated with wellchosen graphics and sound?
      • Argumentation / discussion: Is the presentation just a list of points or is there interesting argumentation with premises / assumptions and consequences?
      • Are the results well documented?
      • Is there a clear conclusion / application / outlook?
  4. Materials

D. Gibbon, Sonntag, 30. September 2018 12:57:23 Uhr CEST