This course will enable the students to –
Learning outcomes (COs):
Course |
Learning outcomes (at course level) |
Learning and teaching strategies |
Assessment Strategies |
|
Paper Code |
Paper Title |
|||
JWT 203
|
Cost Assessment Techniques
|
The students will be able to –
CO30: Calculate the average cost of jewellery Product. CO31: Design jewellery product keeping cost in mind. CO32: Pricing Jewellery Product. CO33: Determine markup price for single and wholesale order jewellery.
|
Approach in teaching: Interactive Practical Sessions , problem solving exercises, Demonstrations ,Giving tasks, Field practical , Workshop , Laboratory industry visits, Group and Team work Learning activities for the students: Self-learning assignments, design development |
Class test, Semester end examinations, Assignments, Presentation, Individual and group projects |
Introduction, spreadsheet, workbooks, saving a file, opening an existing worksheet, Rows and columns, cell entries (numbers, labels, formulas),
Filling series, Functions and its parts, Some useful Functions in excel (SUM, AVERAGE, COUNT, MAX, MIN, IF) .Data sort, Renaming sheet, Printing worksheet.
Insert Picture, Rate of Metal & Gem stones, Labour, Wastage, Determination of Profit and selling price.
BOOKS RECOMMENDED: