Class 2 Introduction to computer science
Basic tools - Word & Excel
The following links should be useful to complete the tasks:
— Mail merge in Word http://office.microsoft.com/training/training.
aspx?AssetID=RC011205671033&CTT=6&Origin=RP011205931033
— Import text files in Excel 2003 http://office.microsoft.com/training/
training.aspx?AssetID=RC011801181033&pid=CR061831141033
— Sorting data in Excel 2003 http://office.microsoft.com/pl-pl/excel/
HP052029541045.aspx
— Equations in Word 2003 http://office.microsoft.com/en-gb/word/
HP051902471033.aspx?pid=CH010504621033
Task 1 - Word + Excel (10 points) The aim of a task :
* Download http://www.staff.amu.edu.pl/~mw/DNIF/zajecia2cw.pdf.
* Create document which looks the same as the one You have just down- loaded (You can omit polish letters and change „ń” to „n”, „ł” to „l”,
„ó” to „o” and so on). In places where are the name and number of stu- dent card (which are: name:„Marcin”, surname:„Witkowski” and student number:„287046”) you should use a mail merge and input there data from the file http://www.staff.amu.edu.pl/~mw/DNIF/zajecia2EN.csv.
—
Font in my file is Times New Roman beside the big in the center which use Monotipe Corsiva. Choose size by yourself so it looks similar (not necesary exact but must looks quite similar). Notice that at the bottom-left paragraf there are empty lines of font size 4 between the lines so the gap is bigger than usual and smaller than when You push Enter twice.
At the bottom of the file there is a sentence „Udzielam Panu zgody.”.
„Pan” in polish means Mister, You must use a rule in mail merge which put in place of Pan the word Mr whenever person from data file is a men and Mrs whenever person in data is a women. You can do it adding simple rule on the name because in Polish every female name ends with an „a”. So it exact match a rule *a.
Final file after using mail merge should consist of 21 pages. Please send this file to my e-mail mw@amu.edu.pl.
Task 2 - Word + Excel (5 points)
Import to Excel data from the file http://www.staff.amu.edu.pl/~mw/
DNIF/zajecia2.txt so it looks in Excel just the same as in this text file (columns and rows should match). Create a chart of this data in 2 dimen- sion (month (in polish „miesiąc”) should be on the X-axis). Format the chart so it looks the same as in http://www.staff.amu.edu.pl/~mw/DNIF/
zajecia22.pdf (again omit the polish signs). Copy this chart into word.
Add an Equation to the word document as it is in http://www.staff.amu.
edu.pl/~mw/DNIF/zajecia22.pdf and add Your name instead of „Marcin Witkowski”. Convert the file to the PDF format (You may use a free website
1
Class 2 Introduction to computer science
http://www.pdfonline.com/convert-pdf/). Sen this PDF to my e-mail mw@amu.edu.pl.
Additional information
Deadline for this assignment is 10th of November 2009.
2
