Subject Code: ISM 2112 - Introduction to Computer 1

 

ASSIGNMENT 2

LIST OF GROUPING: (G02)

LIST OF GROUPING: (G15)

INSTRUCTION FOR ASSIGNMENT 2
FOR GROUP 02 AND GROUP 15 ISM2112

All groups are required to create a 10-minutes presentation slides. You can create as many slides as you want but your presentation MUST finish within 10 minutes.
You can choose any topic that related to ISLAMIC TEACHINGS especially topics from FKM subjects. Please MAKE SURE your topic is not redundant with others' topic. Therefore, during our LAB SESSION (19/05/2005 FOR GROUP 02 AND 24/05/2005 FOR GROUP 15), please SUBMIT your topics to me.
I WILL REJECT ANY LATE SUBMISSION!
In your presentation, you MUST include features of Microsoft PowerPoint: Action Buttons, Clip Art, Pictures, Custom Animation, Slide Transition and text. Not all group members are necessarily involved in the presentation. The presentation day will be on 1/06/2005, venue at Lecture Hall B (for Group 02) and 2/6/2005, venue at Seminar Room (for Group 15) at 8.00pm. (for both groups).
The total mark for this assignment is 30 marks.

Back to top

INSTRUCTION FOR ASSIGNMENT 3

Download

Assignment 3 (Grouping) : Excel

Determining Profit on Items Sold

Purpose: To demonstrate the ability to enter and copy formulas, modify background and font colors, and apply formatting to a worksheet.

Problem: You are an accountant for an automotive parts supply company. You specialize in parts for Ford and Jaguar automobiles. You are trying to determine the amount profit made on a recent sale. You know the quantity of items sold, the original purchase price, and the price that each item was sold for during the sale.

Instructions: Perform the following tasks to create the worksheet shown in Figure A-1:

1. Enter the worksheet titles, F-J Auto Supply and Profit on Items Sold, in cells A1 and A2. Enter the column headings in row 3, the item numbers in column A, and the data in columns B through D, as shown in Table A-1. You will enter formulas for columns E, F, and G and for rows 12 through 17.
2. Use the following formulas to determine the Total Initial Item Cost, Total Gross Sales, and Total Profit:
(a) Total Initial Item Cost = Quantity Sold * Initial Item Cost
(b) Total Gross Sales = Quantity Sold * Item Sale Price
(c) Total Item Profit = Total Gross Sales – Total Initial Item Cost
3. In cell B12, determine the Totals Sales by finding the sum of Total Gross Sales. In cell B13, determine the Total Cost by finding the sum of Total Initial Costs. In cell B14, find the Total Profit by subtracting the Total Cost from the Total Sales. In cell B15 find the Percent of Profit by dividing the Total Profit by the Total Cost. In cell B16 use the MAX function to find the greatest Total Item Profit. In cell B17 use the MIN function to find the least Total Item Profit.
4. Apply the following formatting to the worksheet titles in cells A1 and A2:
a. change the font to bold;
b. change the font to Times New Roman (if not already in that font);
c. increase the font size of cell A1 to 24 points and of cell A2 to 18 points;
d. center the titles across columns A through G;
e. change the background color to dark green (column 4, row 2 of the Color palette) and the text to light yellow (column 3, row 5 of Color palette); and
f. draw a bold outline around the range A1:G11.
5. Using the buttons on the Formatting toolbar, apply Currency style format with two decimal places to the ranges C4:G4, B12:B14, and B16:B17. Apply the Comma style format with two decimal places to the range C5:G11. Apply percent style format with just one decimal place to cell B15.
6. Bold, italicize, and center the column titles and draw a bold border under them in the range A3:G3. Change the background color for the same range to yellow (column 3, row 4 of the Color palette), and change the text color to blue (column 6, row 2 of the Color palette).
7. In the Total Profit column, change the background color to gray-50% (column 8, row 2 of the Color palette). Draw a bold outline around the values in column G.
8. Bold the item numbers and summary headings (range A4:A17), and change the font to MS Sans Serif or a similar font (if not already in that font). Widen column A to 17 points. Change the background color of the range A12:B17 to yellow (column 3, row 4 of the Color palette).
9. Change the height of row 1 to 39.00 points. Change the height of row 12 to 21.00 points and the width of columns C through G to 10.00 points.
10. Rename the worksheet tab from Sheet 1 to Sales Profits and check the spelling on the entire worksheet.
11. Enter group members’ name and matric no. in cell A20. In the next row, date, and instructor's name.
12. Save the workbook on your disk using the file name Assignment3-Your Group-Class Group (e.g. Assignment3-Group1-G15)
13. Save the workbook a second time.
14. Change the display from value version to formula version.
15. All groups MUST submit the assignment before or on 5th June 2005 (Sunday). The total mark is 30.

Back to top