Sunday, July 27, 2014

BCA - V (2014-15) ( PPT Given by Students)


1. Sample PPT By Manish Tiwari ( Teacher)
Title: Sample
Link: https://drive.google.com/file/d/0B8jRSAwhk8_yQ1puTDY1b2RyQ3M/edit?usp=sharing

Title: How to Make an effective Power Point Presentation
Link: http://www.speakingaboutpresenting.com/design/powerpoint-design-recommended-tips/

Title: Slide Share for  an effective Power Point Presentation
Link:  http://www.slideshare.net/vmargutti/how-to-prepare-a-ppt-presentation

2. Unit - 1:  PPT by Anshita and Group: 
Title: Evaluation and Objective of Data Warehouse
Link: https://drive.google.com/file/d/0B8jRSAwhk8_ycHItd3dvUHA1MWM/edit?usp=sharing


3. Unit - 1: PPT by Saurabh Mani and Group: 
Title: Meta Data and It's Type
Link: https://drive.google.com/file/d/0B8jRSAwhk8_yNWRzT0ZGcUdpaWc/edit?usp=sharing


4.  Unit - II: PPT by Merlin Robert, Shruti Dhagat on 23/08/2014
Title:  ER Diagram Model Vs Dimensional Model 
Link: https://drive.google.com/file/d/0B8jRSAwhk8_yVXNHbmFsNndWUm8/edit?usp=sharing

Comments By Manish Tiwari(Subject Teacher) 
1. Matter or Content was not Justified/Margins should be adjusted.
2. PPT Template should be same for pages.
3. During the presentation eye contact were lost.
4. Conclusion PPT is not included.
Question (Discussion): 
1. What is entity?
2. What is Data Dependency?


5. Unit - II: PPT by Anita Sittam, Ishpreet Kaur, Nikit Kesarwani  on 
Title: Data Granularity
Link: https://drive.google.com/file/d/0B8jRSAwhk8_yczJNQTJkSjZpcGs/edit?usp=sharing

Question By students:
Q.1 Finer Granularity example was not clear re-explanation required?
    Question By: Devender Kumar
    Feedback: Satisfied by answer
Q.2 How to implement finer granularity in the dimention modeling?
    Question By: Devender Kumar
    Feedback: Satisfied by answer
Q.3 Re explanation of example given for definition of Data Granularity
    Question By: Sumit Dubey
    Feedback: Satisfied by answer
Q.4 Re-Explanation of point - where you put data in the lowest grain
    Question By: Mukul Pandey
    Feedback: Satisfied by answer
Question from the Audience:
Rahul Gupta:  Good
Nikhil Radhwal:  Bad
Depanshu Jain:  Average
Ishpal: Very Bad
Pooja Gupta: Average
 Comments By Manish Tiwari (Subject Teacher)
1. Conclusion is missing.
2. Data should be properly aligned.
3. Margin should be manage.
4. Textual content must be manged with justified alignment.
5. Dual Granularity should be included.

 6. Unit - II: PPT by Deepanshu Jai, Saurabh Mani, Pooja Gupta, Alisha Mansoori
    Title: Star Schema


Question By students:

 Comments By Manish Tiwari (Subject Teacher)
--------------------------------------------------------------------------------------------------------------------------
Preliminary Result Data Ware House
First Topper:     Pooja Gupta
Second Topper: Devendra Kumar
Third Topper:   Sourabh Mani

Neat and Clean Copy Award Goes To:
Pooja Gupta, Merlin Robert, Deepanshu Jain, Devendra Kumar

Maximum Mark for any question award Goes To: Devendra Kumar
Highest in Objective Question Award goes To: Mohit Soni, Pooja Gupta.

Pass: 10
Fail: 33

1. Anand Tiwar - 36
2. Anita Sittam - 24
3. Anshita Singh - 43
4. Ankit Bajpai - 29
5. Alisha Mansoori - 32
6. Aman Jain - 46
7. Deepti Shrivastava - 39
8. Chandra Prakash Pandey - 35
9. Deepanshu Jain - 57
10. Devendra Kumar - 71
11. Devendra Aswani - 26
12. Unname(30376) - 14
13. Ishpreet Kaur - 16
14. Ishpal Singh - 17
15. Jagrati Thakur - 30
16. Kiran Kushwaha - 25
17. Km Anjali - 39
18. Mohit Soni - 36
19. Merline Robert - 45
20. Mukul Pandey - 40
21. Nikhil Radhawal - 34
22. Namrata Sharma - 23
23. Nikita Kesharwani – 23
24, Pratyanch Rajput - 18
25. Praveen Pal - 26
26. Pooja Singh - 28
27. Pooja Singh - 28
28. Priya Gupta - 35
29. Pranjali Choudhari  - 25
30. Priyank Jain - 22
31. Pooja Gupta - 73
32. Rahul Gupta - 32
33. Reshu Kushwaha - 15
34. Rishabh Parochi - 25
35. Sushama Kushwaha - 30
36. Sumit Dubey - 48
37. Saurabh Mani – 68
38. Surbhi Gupta - 16
39. Sourabh Kashyap - 31
40. Somya Singh - 24
41. Shubham Jaiswal – 17
42. Shruti Dhagat - 53
43. Zareena Khatoon – 46

-----------------------------------------------------------------------------------------------------------------
                                                                       CCE Marks

Anand  PrakashTiwari  - 13
Anita Sittam    -  15
Anshita Singh  - 15
Ankit Bajpai     - Absent
Alisha Mansoori – 18
Aman Jain          -  15
Deepti Shrivastava      - 17
Chandra Prakash Pandey – 17
Deepanshu Jain    - 18
Devendra Kumar  - 18
Devendra Aswani - 12

Ishpreet Kaur – 16
Ishpal Singh – 14
Jagrati Thakur – 13
Kiran Kushwaha - 14
Km Anjali – 12
Mohit Soni – 15
Merline Robert – 18
Mukul Pandey – 17
Nikhil Radhawal – 15
Namrata Sharma – 14
Nikita Kesharwani – 17
Pratyanch Rajput -  10
Praveen Pal – 14

Pooja Singh - 13
Priya Gupta - 14
Pranjali Choudhari  - 13
Priyank Jain – 15
Pooja Gupta – 18
Rahul Gupta – 15
Reshu Kushwaha - 15
Rishabh Parochi – 14
Sushama Kushwaha - 14
Sumit Dubey – 16
Saurabh Mani – 18
Surbhi Gupta – 13
Sourabh Kashyap -15
Somya Singh –  15
Shubham Jaiswal – 12
Shruti Dhagat –  17
Zareena Khatoon – 17
Surabhi Rajak - 13
Kiran Manjhi - 14



Financial Year Oracle PLSQL Program

 CREATE OR REPLACE function FINANCIAL_YEAR(p_date DATE) return varchar2 IS    v_first     varchar2(4);    v_second    varchar2(4);    v_year...