Concepts of Spread Sheets and Database detailed Syllabus for Commercial & Computer Practice (DCCP), C18 curriculum has been taken from the TSSBTET official website and presented for the diploma students. For Course Code, Course Name, Lectures, Tutorial, Practical/Drawing, Internal Marks, Max Marks, Total Marks, Min Marks and other information, do visit full semester subjects post given below.
For all other Diploma in Commercial & Computer Practice (DCCP) Syllabus for 3rd Sem C18 Curriculum TSSBTET, do visit Diploma in Commercial & Computer Practice (DCCP) Syllabus for 3rd Sem C18 Curriculum TSSBTET Subjects. The detailed Syllabus for concepts of spread sheets and database is as follows.
Prerequisites:
For the complete Syllabus, results, class timetable, and many other features kindly download the iStudy App
It is a lightweight, easy to use, no images, and no pdfs platform to make students’s lives easier.
.
Course Outcome:
- Know the features of spread sheet and excel and Identifying various commands, groups, tabs and ribbon layout
- Building up Spread Sheet
- Building up Charts and database in EXCEL
- Understand Data base concepts and Data Base Management in ACCESS
- Printing of a worksheet, Create Forms and Queries in MS-ACCESS
- Filters and Create Reports in MS-ACCESS
Course Contents:
Unit-1 Introduction To Ms -Excel
For the complete Syllabus, results, class timetable, and many other features kindly download the iStudy App
It is a lightweight, easy to use, no images, and no pdfs platform to make students’s lives easier..
Unit-2 Building Up Spread Sheet
Building up Spread Sheet- EXCEL – Edit the contents of the cell-Format the number, text in the cells-Change the width and height of the cells-Definition of the formula- operators used in the formula-different types of function-Enter formulae with functions- Jump to different work books- Import worksheet from different workbooks- printing of a worksheet.
Unit-3 Building Up Charts and Database in Excel
Different types of charts – create chart-formatting features of charts- printing chart-features of data management-definition of Criteria range- criteria and extract the data- features of Forms in EXCEL-creation of a Form.
Unit-4 Data Base Concepts and Data Base Management in Access
For the complete Syllabus, results, class timetable, and many other features kindly download the iStudy App
It is a lightweight, easy to use, no images, and no pdfs platform to make students’s lives easier..
Unit-5 Printing of a Work Sheet, Forms and Queries in Ms-Access
Printing of a Table – Create forms using form tool, Forms Wizard and Custom Form – Adding new records through Form – Navigating and searching using Form- printing of forms – Define a query -Types of queries- Creation of different types of queries-print query filters –
Unit-6 Filters and Reports in Ms-Access
Define filter – Different types of filters – Filter by selection – Filter by form – Advance filter -Reports in MS-ACCESS- Define reports- Uses of a reports – different methods of reports-types of views- Creation of reports using labels/blank report/report wizard – create custom reports- Printing of reports
Specific Learning Outcomes
For the complete Syllabus, results, class timetable, and many other features kindly download the iStudy App
It is a lightweight, easy to use, no images, and no pdfs platform to make students’s lives easier..
Suggested Student Activities
- Student prepare excel worksheets
- Student will use different formulas and functions to calculate
- Create graphs/charts
- Create data base in access
Recommended Books
- MS Office, BPB Publications.
- Rapidex computer course, Rapidex publications
Student E-Learning References
- https://www.tutorialspoint.com/excel
- http://www.online-tech-tips.com
Course Outcome:
- Know the features of spread sheet and excel and Identifying various commands, groups, tabs and ribbon layout
- Building up Spread Sheet
- Building up Charts and database in EXCEL
- Understand Data base concepts and Data Base Management in ACCESS
- Printing of a worksheet, Create Forms and Queries in MS-ACCESS
- Filters and Create Reports in MS-ACCESS
For detail Syllabus of all other subjects of Commercial & Computer Practice, C18 curriculum do visit Diploma In Commercial & Computer Practice 3rd Sem Syllabus for C18 curriculum.
For all Commercial & Computer Practice results, visit TSSBTET DCCP all semester results direct links.