CSE‌® Knowledge & Competence Requirements

Code	Assessment Component
1	Logic Building, Programming Fundamentals, and Debugging
Design flowcharts and pseudo code for various real-life scenarios Examine the programming process and the tools required for programming Develop code to understand the use of basic programming constructs and control flow statements Develop code to perform string manipulation and file handling operations Demonstrate code to give an understanding on object-oriented programming principles Identify the errors and exceptions and understand the ways to handle them
2	Data Structures and Algorithms
Outline the need of data structures and its types Prepare the data structure using arrays, lists, stacks, queues, and trees Choose appropriate algorithm according to the given problem Demonstrate an understanding of searching algorithms Demonstrate an understanding of sorting algorithms Infer the appropriate usage of searching and sorting algorithms Compare algorithms to determine their efficiency
3	RDBMS and SQL Concepts
Compare data storage approaches—file-oriented and database-oriented Describe DBMS types and its architecture Demonstrate an understanding of the fundamental concepts of RDBMS such as normalization and data integrity Design a database by understanding client’s requirements, translating requirements into business rules, and normalizing data for a given case study Give examples to understand the basic SQL statements and perform SQL operations Experiment with the advanced SQL concepts, such as joins, subqueries, views, constrains, functions, and stored Practice designing and executing SQL statements and queries on MySQL and MS Access Use indexes to optimize query performance Analyze various techniques to optimize query performance Use different methods to maintain and secure databases
4	Business Intelligence and Data Modeling
Compare OLTP and OLAP to understand their benefits and limitations Identify different types of multidimensional data and OLAP architectures Analyze different data models for OLTP and OLAP systems Describe Business Intelligence, its evolution, and the applications that use it Identify how to design a data model Analyze schemas for data modeling such as Star schema, Snowflake schema, and Fact Constellation schema Analyze the process of creating a data model for an organization with the help of a case study
5	Software Development Models, Testing, and Quality
Analyze the software development process models and their appropriate application Discover the software requirements and design the SRS document Interpret the software design and implementation issues such as modularity and coding Identify the need and importance of design and construction phase of software development Construct an ideal UI by understanding the appropriate implementation of the UI elements Demonstrate an understanding of the UI development lifecycle Demonstrate an understanding of the advanced SE concepts and their usage in real life Choose the appropriate software testing approaches such as unit testing and integration testing Recognize various software testing levels and approaches Demonstrate an understanding on quality control and how to ensure good quality software
6	Computer Operating Systems and Networking
Describe the different categories of operating systems such as parallel, real-time, and embedded systems Explain different process management concepts such as process model, state of a process, process and process scheduling, concurrency and process synchronization Describe thread system models, basic thread management, and deadlock handling Discuss the need for memory management and how memory is allocated to programs Identify the goals and objectives of securing an operating system and the different mechanisms used Identify different types of LANs, network topologies and access methods Describe the OSI model and switches Prepare communication subnetwork and upper OSI layers Demonstrate the implementation of IPv4 and IPv6 addressing Examine the network structure of an organization with the help of a case study
7	Emerging Trends in IT
Demonstrate an understanding of the layers of the Web architecture model, its need and implementation in real life Explain the role of Web 3.0, its concepts, and its technologies Develop HTML code to design Web pages including images, hyperlinks, and multimedia Experiment with HTML 5 tags to design the Web pages Describe the ways in which the cloud services can be provided to consumers, such as private, public, hybrid, or community cloud Illustrate the implementation of PaaS, IaaS, and SaaS by designing cloud applications Demonstrate the basics of technical communication Demonstrate an understanding of the types of technical documents and their elements Demonstrate the core features of Robohelp to create help files and why it is used as industry solution Develop the cloud application and host it on the server of the cloud service provider Identify the strengths and weaknesses of different development platforms Apply mobile computing fundamentals to develop mobile applications for the Android, iOS, and iPhone platforms Develop the code to implement the gaming fundamentals
8	Language, Soft Skills, and Recruitment Readiness
Demonstrate the role of language and how to build impressive personality in career development Demonstrate how to express thanks, gratitude, responses of sorry, thanks, apologize, deal with unpleasantness, mingle with people, refuse to do something, and return thanks Demonstrate how to prepare for the job interview by knowing its do’s and don’ts Demonstrate how to design resume, covering letter, and what needs to be avoided in the interview Demonstrate how to effectively communicate in the business environment Demonstrate the importance of workplace behavior, how workplace behavior affects team work, productivity, and public image
9	Technical Documentation
Demonstrate the basics of technical communication Demonstrate an understanding of the types of technical documents and their elements Demonstrate the core features of Robohelp to create help files and why it is used as industry solution Demonstrate the use of FrameMaker to create technical documents