Exercise 3 - Document template, word processing tools and spreadsheet basics

Open the document which you made in previous exercise and start editing that with following exercises.

  1. Define document page setup (finn. sivunasetus) as next:
  2. Insert page numbers in header (finn. ylätunniste on outer edge of page. Different identifier text for odd and even pages came on inner edge of the page. You can write your name as identifier text in even page and text "Macro viruses" in odd page. You can change header layout by using Header -style. Change header properties as following:

    Style looks like following on Word:

    Normal + Border: Bottom (Single solid line, 1/2 pt Line width),
    Tabs: 8,5cm centered, 17 cm right flush
    
    (suom. Normaali + Reuna: Alhaalla (Yksinkertainen, 1/2 pt Viivan leveys),
    Sarkaimet: 8,5cm Keskitetty, 17 cm Oikea tasaus)
    
  3. If you want you can divide document into sections (finn. osat) and define different text and page numbers into headers of different sections.
  4. Now you have good edited document which includes style settings and page settings. To maintain styles and page settings it is worth to make a template (finn. Asiakirjamalli from document. Save document as document template into ohjelmistot-directory in U-disk. Select document template *.dot (finn. Asiakirjapohja) as file type.
  5. Delete all text from document template which you don´t want with new documents based on document template. Save and close document template.
  6. Open a new document based on document template made by you and write some headings and text paragraphs into it. You can get document template as base for new documents from U -disk by double-clicking the icon of document template file in Windows Explorer (finn. Tiedostonhallinta). You can get document template as base for new document by selecting File | New (finn. Tiedosto Uusi) in normally but now the document is saved in other place. Save new document in U -disk with some name but don´t close the document.
  7. Go to get a complete document template kalvot.doc from next address. Or save the kalvot.doc which you made in previous bonus-exercise as document template like it is done is previous exercises. Copy or save kalvo.doc document template into ohjelmistot -directory in U -disk.

    <URL: http://appro.mit.jyu.fi/2001/kevat/ohjelmistot/demot/demo3/kalvo.dot>

  8. Next we change document template on base into another and update document styles corresponding to new document template. You can change the document template by selecting Tools | Templates and Add-Ins (suom. Työkalut | Mallit ja lisäosat). From the opened window you must define style update separately. It can be done by marking Automatically update document styles.
  9. If you like you can also try to change single styles with style organizer (suom. Arkistoinnin). Style organizer can be found by selecting Format | Style | Organizer (finn. Muotoile | Tyyli | Arkistointi). If you cannot remember how to use style organizer then you must refresh your memory from previous lecture notes.
  10. Save and close documents just modified by you.

Word processing tools

  1. Fetch little imperfect word-document from address <URL: http://appro.mit.jyu.fi/2001/kevat/ohjelmistot/demot/demo3/Viallinen.doc> . Save document in your computers hard drive to U:-disk. After that you can open the document into Word program and start doing following formatting into it. Use Replace (finn. Korvaa) -tool.

    Notice that you have to delete previous formatting of tool by No formatting (finn. Ei muotoiluja) button when you replace formatting.

  2. Other exercises included to word processing tools can be found from extra exercise section.

Spreadsheet elements

  1. Open Excel spreadsheet program. If an empty workbook won´t be opened automatically then open one. Save workbook as demot3.xls into ohjelmistot-directory in U -disk.
  2. Create a price table like in following picture. Don´t care about table layout or formatting of table at the beginning because the layout will be formatted by using styles.
    Tuotetaulukko
  3. Next we create some new styles by using and existing styles. You can edit and use styles by selecting Format | Style (finn. Muotoile | Tyyli).
  4. Total prices in D-cells are count by using B- and C-columns. Insert formulas in D-column which are used for counting total price for products by using information from B and C columns. You will get a formula which can be copied into other cells of D-column. Try function of formulas by changing values of B and C column.
  5. Insert a formula which counts a sum from total prices of products into cell D7. Formula can be followed by using spreadsheet function SUM (finn. summa).
  6. Next we develop product price blank little better. Change product price blank like in following picture by inserting some rows and columns into table.
    Tuotetaulukko
  7. Name discount percent cell as alepros. Change formulas in E column by using named cell instead of absolute reference. Notice that the reference into named cell is always absolute in Excel.
  8. Name total price information in D column (D4:D8) as kokonais, name discount information in E column (E4:E8) as alennus and discount price in F column (F4:F8) as alennettu. Use named spaces for sum information from columns D, E and F.

Extra exercises

  1. Try Mail Merge (finn. Yhdistämistoimintoa) function from Word by observing following guides.

    With mail merge function you can make personal form letters and add the name of the personal as partly of the letter. The idea of using mail merge is to paste addresses and letters. Next there is told merge points in detail.

  2. This exercise you practise how to merge two documents in one big. Newt there is told brief guides for merging documents.
http://appro.mit.jyu.fi/2002/kevat/ohjelmistot/english/demo3.html
© Petri Heinonen ()<URL: http://www.mit.jyu.fi/peheinon/>
2002-03- 5T15:16:31Z