{"id":26371,"date":"2020-07-24T00:49:47","date_gmt":"2020-07-24T00:49:47","guid":{"rendered":"https:\/\/www.inspirenignite.com\/jntuh\/18ccp304c-concepts-of-spread-sheets-and-database-syllabus-for-commercial-computer-practice-3rd-sem-c18-curriculum-tssbtet\/"},"modified":"2020-07-24T00:49:47","modified_gmt":"2020-07-24T00:49:47","slug":"18ccp304c-concepts-of-spread-sheets-and-database-syllabus-for-commercial-computer-practice-3rd-sem-c18-curriculum-tssbtet","status":"publish","type":"post","link":"https:\/\/www.inspirenignite.com\/jntuh\/18ccp304c-concepts-of-spread-sheets-and-database-syllabus-for-commercial-computer-practice-3rd-sem-c18-curriculum-tssbtet\/","title":{"rendered":"18CCP-304C: Concepts of Spread Sheets and Database Syllabus for Commercial & Computer Practice 3rd Sem C18 Curriculum TSSBTET"},"content":{"rendered":"

Concepts of Spread Sheets and Database detailed Syllabus for Commercial & Computer Practice (DCCP), C18 curriculum has been taken from the TSSBTET<\/a> 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. <\/p>\n

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<\/a>. The detailed Syllabus for concepts of spread sheets and database is as follows. <\/p>\n

Prerequisites:<\/h4>\n

For the complete Syllabus, results, class timetable, and many other features kindly download the iStudy App<\/a>
It is a lightweight, easy to use, no images, and no pdfs platform to make students’s lives easier.<\/b>
\"Get<\/a>. <\/p>\n

Course Outcome:<\/h4>\n
    \n
  1. Know the features of spread sheet and excel and Identifying various commands, groups, tabs and ribbon layout<\/li>\n
  2. Building up Spread Sheet<\/li>\n
  3. Building up Charts and database in EXCEL<\/li>\n
  4. Understand Data base concepts and Data Base Management in ACCESS<\/li>\n
  5. Printing of a worksheet, Create Forms and Queries in MS-ACCESS<\/li>\n
  6. Filters and Create Reports in MS-ACCESS<\/li>\n<\/ol>\n

    Course Contents:<\/h4>\n

    Unit-1 Introduction To Ms -Excel<\/h4>\n

    For the complete Syllabus, results, class timetable, and many other features kindly download the iStudy App<\/a>
    It is a lightweight, easy to use, no images, and no pdfs platform to make students’s lives easier.<\/b>
    \"Get<\/a>. <\/p>\n

    Unit-2 Building Up Spread Sheet<\/h4>\n

    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.<\/p>\n

    Unit-3 Building Up Charts and Database in Excel<\/h4>\n

    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.<\/p>\n

    Unit-4 Data Base Concepts and Data Base Management in Access<\/h4>\n

    For the complete Syllabus, results, class timetable, and many other features kindly download the iStudy App<\/a>
    It is a lightweight, easy to use, no images, and no pdfs platform to make students’s lives easier.<\/b>
    \"Get<\/a>. <\/p>\n

    Unit-5 Printing of a Work Sheet, Forms and Queries in Ms-Access<\/h4>\n

    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 –<\/p>\n

    Unit-6 Filters and Reports in Ms-Access<\/h4>\n

    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<\/p>\n

    Specific Learning Outcomes<\/h4>\n

    For the complete Syllabus, results, class timetable, and many other features kindly download the iStudy App<\/a>
    It is a lightweight, easy to use, no images, and no pdfs platform to make students’s lives easier.<\/b>
    \"Get<\/a>. <\/p>\n

    Suggested Student Activities<\/h4>\n
      \n
    1. Student prepare excel worksheets<\/li>\n
    2. Student will use different formulas and functions to calculate<\/li>\n
    3. Create graphs\/charts<\/li>\n
    4. Create data base in access<\/li>\n<\/ol>\n

      Recommended Books<\/h4>\n
        \n
      1. MS Office, BPB Publications.<\/li>\n
      2. Rapidex computer course, Rapidex publications<\/li>\n<\/ol>\n

        Student E-Learning References<\/h4>\n
          \n
        1. https:\/\/www.tutorialspoint.com\/excel<\/li>\n
        2. http:\/\/www.online-tech-tips.com<\/li>\n<\/ol>\n

          Course Outcome:<\/h4>\n
            \n
          1. Know the features of spread sheet and excel and Identifying various commands, groups, tabs and ribbon layout<\/li>\n
          2. Building up Spread Sheet<\/li>\n
          3. Building up Charts and database in EXCEL<\/li>\n
          4. Understand Data base concepts and Data Base Management in ACCESS<\/li>\n
          5. Printing of a worksheet, Create Forms and Queries in MS-ACCESS<\/li>\n
          6. Filters and Create Reports in MS-ACCESS<\/li>\n<\/ol>\n

            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<\/a>.<\/p>\n

            For all Commercial & Computer Practice results, visit TSSBTET DCCP all semester results<\/a> direct links.<\/p>\n","protected":false},"excerpt":{"rendered":"

            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. […]<\/p>\n","protected":false},"author":2344,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"footnotes":""},"categories":[128,132],"tags":[],"class_list":["post-26371","post","type-post","status-publish","format-standard","hentry","category-3rd-sem","category-dccp"],"_links":{"self":[{"href":"https:\/\/www.inspirenignite.com\/jntuh\/wp-json\/wp\/v2\/posts\/26371","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.inspirenignite.com\/jntuh\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.inspirenignite.com\/jntuh\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.inspirenignite.com\/jntuh\/wp-json\/wp\/v2\/users\/2344"}],"replies":[{"embeddable":true,"href":"https:\/\/www.inspirenignite.com\/jntuh\/wp-json\/wp\/v2\/comments?post=26371"}],"version-history":[{"count":0,"href":"https:\/\/www.inspirenignite.com\/jntuh\/wp-json\/wp\/v2\/posts\/26371\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.inspirenignite.com\/jntuh\/wp-json\/wp\/v2\/media?parent=26371"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.inspirenignite.com\/jntuh\/wp-json\/wp\/v2\/categories?post=26371"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.inspirenignite.com\/jntuh\/wp-json\/wp\/v2\/tags?post=26371"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}