GUIDELINESTOB.COM.CCF HONS.&MDCSEMESTER III STUDENTS FORPREPARATION OF‘COMPUTERISED ACCOUNTING AND INTRODUCTION TO DATA SCIENCE’ (CADS) PRACTICALNOTE BOOK Ø Students have to prepare three (3) copies of the Practical Note Book on the paper “COMPU
GUIDELINESTOB.COM.CCF HONS.&MDCSEMESTER III STUDENTS
FORPREPARATION OF‘COMPUTERISED ACCOUNTING AND INTRODUCTION TO DATA SCIENCE’ (CADS) PRACTICALNOTE BOOK
Ø Students have to prepare three (3) copies of the Practical Note Book on the paper “COMPUTERISED ACCOUNTING AND INTRODUCTION TO DATA SCIENCE” inspirally bounded A4 size pages
Ø SomeguidelinesaregivenbelowforpreparingtheCADS Practical Note Book:
1. Cover Page:It should contain the Practical Note Book’s Name, Student’s Name, Class, CU Roll No., CU Registration No., College Roll No., College Name, Name of the Supervisor.
Here Is a sample format of the cover page shown below:
Title of the Practical Note Book: COMPUTERISED ACCOUNTING AND INTRODUCTION TO DATA SCIENCE
Name of the Student:
Class: B.Com. 4-Year Honours / 3-Year MDC Semester III
CU Roll No.:
CU Registration No.:
College Roll No.:
Name of the College: Bangabasi Evening College
Supervised by: …………………………………… (Write the name of the Supervisor)
2. Next Page – Acknowledgement:It contains the organization/college and the individuals who have provided assistance and cooperation during the process of carrying out the study. Here Is an example of it:
ACKNOWLEDGEMENT
It is my great pleasure that I am presenting the Practical Note Book on the paper “COMPUTERISED ACCOUNTING AND INTRODUCTION TO DATA SCIENCE”. I would like to express my sincere gratitude to our respected Principal, Dr. Sanjib Chattopadhyay, for providing me the opportunity to work in this field. Additionally, I am grateful to our esteemed Head of the Department, Dr. Debarshi Bhattacharya, for his constant support and encouragement. I extend my heartfelt thanks to my supervisor, [Write Supervisor’s Name], for his/her invaluable guidance and assistance throughout the process of preparing this project. Finally, I am deeply thankful for the unwavering support of my family, friends, and others who cooperated with me during the project work.
Signature:
Name of the student:
3. Next Page – Student’s Declaration:A sample format of Student’s Declaration is given below:
Student’s Declaration
I hereby declare that the Practical Note Book on the paper“COMPUTERISED ACCOUNTING AND INTRODUCTION TO DATA SCIENCE” submitted by me for partial fulfilment of the degree of B.Com. Honours/ MDC in Accounting & Finance under the University of Calcutta is my original work and has not been submitted earlier to any other University /Institution for the fulfillment of the requirement for any course of study. I also declare that no chapter of this manuscript in whole or in part has been incorporated in this report from any earlier work done by others or by me. However, extracts of any literature, which has been used for this report, have been duly acknowledged providing details of such literature in the references.
Place: Kolkata Signature: …………………………….
Date: Name of the student:
Address:
CU Roll No.:
4. Next Page – Supervisor’s Certificate:A sample Supervisor’s Certificate is shown below:
Supervisor’s Certificate
This is to certify that Mr./Ms. ………………(write your name here)………………, a student of B.Com. Semester III Honours/ MDC in Accounting & Finance of Bangabasi Evening College under the University of Calcutta has worked under my supervision and guidance for the paper “COMPUTERISED ACCOUNTING AND INTRODUCTION TO DATA SCIENCE” and prepared a Practical Note Book on this paper which he/she is submitting is his/her genuine and original work to the best of my knowledge.
Place: Kolkata Signature of the Supervisor: …………………….
Date: Name of the Supervisor:
Designation: FacultyMember
Name of the College:Bangabasi Evening College
5. Next Page – Table of content:It contains the names of different chapters of the project along with their corresponding page numbers. Here is a sample format for the content page:
Table of Content
Chapter No.
|
Chapter Details
|
Page No.
|
I
|
Introduction
|
XX
|
II
|
Computerized Accounting
|
XX
|
III
|
Digitalization in India
|
XX
|
IV
|
Data Science
|
XX
|
V
|
Conclusion
|
XX
|
6. Next Page:ChapterI –Introduction
It should contain definition, feature and usefulness of COMPUTERISED ACCOUNTING AND INTRODUCTION TO DATA SCIENCE in business
7. Next Page:Chapter II –Computerized Accounting
Write the answer of the following questions:
A. What is Accounting Software?
B. Write any four features of Tally software.
C. How can you create a company in Tally?[ Hint: Open Tally>Gateway of Tally>PressF3>Select Create Company>Fill the Company Name and other details>Accept]
D. What do you mean by Tally vault?
E. Write the steps of Creating of a Single ledger in Tally. [Hint: Alt+G (Go To)>Create Master>Ledger) under Accounting Master)]
F. How can you create stock item (Single) In Tally?[Hint: Alt+G(Go To)>Create Master>Stock Item (under Inventory Master]
G. What is tail unit?
H. Write the steps of single Group Creation in Tally.[Hint: Alt+G(Go To)>Create Master>Group (under Accounting Master)]
I. What is the purpose of voucher types in Tally and how do you use them? [Hint: explain different voucher types like Payment,Receipt,Contra, Journal]
J. How do you enable GST in Tally? [Hint: write the steps to activate GST]
Note:Attaching photo is mandatory in case of question number 3,5 and 6
8. Next Page:ChapterIII – Digitalization in India
Write the answer of the following questions:
A. What are the key applications of e-services like e-PAN in India?[Hint: Discuss the process of applying for an e-PAN, its benefits, and its role in digital identity]
B. What is DigiLocker, and how does it contribute to digitalization in India?[Hint: Explain the purpose of DigiLocker, its features, and how it is used for storing digital documents]
C. How has online banking transformed the payment systems in India?[Hint: Discuss the advantages of online banking, various payment methods, and the role of UPI in digital payments]
D. What is the significance of M-Parivahan and Aadhaar-based services in digital governance?[Hint: Highlight how M-Parivahan helps in vehicle-related services and how Aadhaar-based services enhance accessibility and transparency]
E. What are the main challenges faced in the implementation of digitalization in India?[Hint: Discuss challenges such as digital literacy, internet accessibility, and data privacy concerns]
9. Next Page:ChapterIV –Data Science
Part1: Database Management System
A. What do you mean by Database Management System? State its Significance with the help of real-life examples.
B. Distinguish between Traditional file system approach and DBMS.
C. Make a table in MS Access containing details of 10 students. (Student ID, name, subject name, marks obtained in each subject)
(Hints: Create a database file in MS Access, Go to view > design view> give field name, data type (text, number etc.)>save. Again from view go to datasheet view> enter details of 10 students.) (Attach photo with detailed steps)
Part2: Advanced Data Management with Spread Sheet
A. What do you mean by functions in Excel?
B. Differentiate between built-in-functions and user defined functions.
C. Compute the amount that needs to be deposited at the beginning of 5 years
duration for accumulating an amount of Rs. 10,00,000 at the end provided
that a recurring deposit of Rs. 1,00,000 is made at the end of every year. The
prevailing interest rate is 8% p.a. [After writing above information in Excel
Sheet, Use = -PV (rate, nper (Number of paymentPeriods), -pmt (The paymentmade each period), [fv] (future value=10,00,000), [type] (here =0 i.e. at theend of the period))]. (Attach photo with detailed steps)
Part3: Tables and Formatting
A. Make the following table using MS-Excel:
SALES DATA
|
Product ID
|
Product Type
|
Units Sold
|
Per Unit Price
(₹)
|
Revenue (Unit sold x Price per unit)**
(₹)
|
% of revenue =(Revenue/Total revenue) × 100
|
P01
|
Solid
|
300
|
250
|
Calculate
|
Calculate
|
P02
|
Liquid
|
500
|
150
|
Calculate
|
Calculate
|
P03
|
Solid
|
750
|
250
|
Calculate
|
Calculate
|
P04
|
Solid
|
350
|
360
|
Calculate
|
Calculate
|
P05
|
Liquid
|
855
|
45
|
Calculate
|
Calculate
|
P06
|
Semi-Solid
|
1250
|
500
|
Calculate
|
Calculate
|
P07
|
Liquid
|
750
|
300
|
Calculate
|
Calculate
|
P08
|
Semi-Solid
|
368
|
800
|
Calculate
|
Calculate
|
P09
|
Semi-Solid
|
101
|
650
|
Calculate
|
Calculate
|
P10
|
Solid
|
560
|
700
|
Calculate
|
Calculate
|
P11
|
Liquid
|
500
|
800
|
Calculate
|
Calculate
|
P12
|
Semi-Solid
|
280
|
200
|
Calculate
|
Calculate
|
Total
|
|
Add above
cells with sum function
|
|
Add above cells with sum function
|
Add above cells with sum function
|
**Calculate Revenue using Multiplication formula in excel,i.e. (unit sold cell x per unit price cell).
Now make a Pie Chart of the above data.
(Hints:Select Product ID and Percentage of revenue or revenue table (except total cell) > Insert> Chart> Insert pie chart> Save) (Attach photo with detailed steps)
10.Last Page:ChapterV –Conclusion
It should contain your concluding observations, findings and suggestions based on your practical note book.
ImportantNotes:
1.Aftercompletionofthe CADS Practical Note Book based on above-mentionedinstructions,students are instructed to be present on the scheduled dates (will be given later) for checking of their CADS Practical Note Book by the concerned subject teachers(Prof. Bijoy Pal or Prof.Mousumi DeyRoy or Prof. Swatabdi Dey or Prof. Pratap Chandra Das).
2.Write the name of the Supervisor: Either Prof. Bijoy Pal or Prof. Mousumi Dey Roy or Prof. Swatabdi Dey or Prof. Pratap Chandra Das.