GROUP 1D: Class on Saturday 28 Feb

Please take note that the classes scheduled on Tuesday and Wednesday (24 and 25th February) must take place on Saturday 28th December 2008 from 8 to 12 am. For the class rep, please ensure that the lab has been booked.

See you on Saturday.

CHANGES OF LECTURE SCHEDULE II

Refer to the earlier schedule. Please ignore the schedule. The new schedule is as follows:

EXCEL TASKS NO. 2

For Excel 2 tasks, go to this website:https://sites.google.com/site/bklinks/excel-tasks/excel2task.pdf?attredirects=0. Print the file and bring it to the practical session. Understand the question before coming to class. It is advised that student will study the given task, and prepare a draft method of performing the calculation manually. A clear understanding of how to propose the cashflow will help in the completion of the task in class.

MARKS FOR MS WORDS Practical Task 2

Task submitted, and marked based on the following criteria: 1. Header with logo and lines, tables with right columns sizes and proper fonts usage, shading for the paragraph as shown, the use of proper fonts, the correct logo with proper placement and size, the line spacing as shown, the use of hand symbols with proportionate size, proper use footer with automatic paging number and finally the adjustment for time submitted. Each will be given maximum 5 marks, and total score is 45. The final score is converted to percentage.

For QS1D, the highest score is 91% and lowest is 44%. There are 6 students with 0 marks.
For QS1F, the highest score is 93% and lowest is 53%. There are 6 students with 0 marks.

Students with 0 marks may appeal the marks to be reviewed, provided that you have indicated that the works has been completed and sent to the right email address.


To view the marks, student may click on here.
Marks for GROUP 1D. Marks for Group 1F


To view comments made for the submission,

For Group 1D, Click here. (http://sites.google.com/site/bklinks/group-1d-word2-marks)
For Group 1F, Click here. (http://sites.google.com/site/bklinks/group-1f-word2-marks)

MS WORDS PRACT II submission

For Group 1D, students can view their works and comments made by the lecturer. To access the file view the submissions at http://sites.google.com/site/bklinks/group-1d-word2-marks

Changes of Lecture Schedule

My earlier lecture schedules may have to change due to some inevitable changes to my work place. By early March I may have to move to somewhere far, and it is not possible to commute to UiTM Perak. However, it is my intention to complete the syllabus before I leave. In order to do that, the following schedules will take effect from next week (commencing 16th February 2009).

MS WORD PRACTICAL 3

The aim of this practical task is to introduce students to the general concept of mailmerge. By understanding the features, student should be able to apply the skills and knowledge to their future assignments. In this exercise, students will prepare a letter based on mailmerge.pdf. Download sample letter files and print it, for ease of reference in class.

For the data files student should download the source data from bidder.xls. Save the file as bidder.xls in the appropriate folder.

Merge the documents into two categories of letter. One set of letters to be sent to Air conditioning supplier (where PROJ=AC) and another set to Computer suppliers (where PROJ=PC). To do that, student should apply IF...THEN...ELSE in merge documents.

After merging the documents, student should save the new merged information into a files named as STNO.doc where STNO is your last four digits of student's ID. Attach the file with your email and submit to QSD135+1X@gmail.com, where X is your group notation. Subject for the email is (STUDENT NO)+MAIL MERGE.

COURSEWORK MARKS

Students are reminded to submit their assignment with the following information in their email:

STUDENT'S NO
STUDENT'S NAME.

To update coursework marks already given, students have to perform the followings:

1. Check your emails.
2. Where I have given marks by stating so in the email, forward the email to this address: QSD135+1X@gmail.com. Please note that 'X' is to be REPLACED with your group. Eg. if you are from Group 1D, then replace X with D.
3. Put subject for your mail: and COURSEWORK MARKS.
4. This updating process to be done before 28th. February 2009. Any mail with the allocated marks received after the date will not be considered for the coursework marks.

Do not hesitate to ask me in class if you need further assistance on this matter.

Bring your photo to class

On Tuesday 10/2/09 (for Group 1D) and Wednesday (11/2/09) (for group 1F), student should bring a softcopy of their favourite photo to class. The photo must show at least their face, and must be descent for public viewing.

Practical Task 2 (MS Word)

For the session on Tuesday 10th and Wednesday 11th, students shall carry out the following tasks:

1. Print the Practical Task No. 2, and bring it to the class.
2. Type the page and format as shown.
3. Follow the instructions as written in blue.
4. Write an email to qsd135@gmail.com. The subject for the email is: Word Practical No. 2
5. Attach your completed tasks with the email.
6. The tasks should be completed in 30 minutes.

Practical Task 1

For practical task no. 1, please refer to the PDF files entitled "Microsoft Word - MS Words Skills.pdf". In the lab, perform the following tasks to produce the same document:

1. Set the page layout
2. Enter the text without the formatting
3. Create columns – 2 columns
4. Insert horizontal line below the title block
5. Change to outline level
6. Identify level 1 text
7. Identify normal text
8. Change back to print layout format
9. Choose list styles from Format  bullet and numbering
10. Mark the relevant text and click on the numbered list button
11. Set the correct indentation.