Computer Fundamentals and Applications - Syllabus
Embark on a profound academic exploration as you delve into the Computer Fundamentals and Applications course (CFA) within the distinguished Tribhuvan university's BCA department. Aligned with the BCA Curriculum, this course (CACS101) seamlessly merges theoretical frameworks with practical sessions, ensuring a comprehensive understanding of the subject. Rigorous assessment based on a 60 + 20 + 20 marks system, coupled with a challenging passing threshold of , propels students to strive for excellence, fostering a deeper grasp of the course content.
This 4 credit-hour journey unfolds as a holistic learning experience, bridging theory and application. Beyond theoretical comprehension, students actively engage in practical sessions, acquiring valuable skills for real-world scenarios. Immerse yourself in this well-structured course, where each element, from the course description to interactive sessions, is meticulously crafted to shape a well-rounded and insightful academic experience.
Course Description
This course offers fundamental concepts of computer and computing which includes introduction to computer system, computer software & database management system, operating system, data communication & computer network and contemporary technologies. It also aims at helping students convert theoretical concept into practical skill through the use of different application packages including word processor, spreadsheet package, presentation package and photo editing graphical package.
Course Objectives
The general objectives of this course are to provide fundamental concepts of information and communication technology and to make students capable of using different application packages in their personal as well as professional life.
Units
Key Topics
-
Introduction to Computers
IN-01An overview of computers and their significance in today's world. This topic sets the stage for understanding the basics of computers.
-
Digital and Analog Computers
IN-02Understanding the difference between digital and analog computers, their characteristics, and applications.
-
Characteristics of Computers
IN-03Exploring the key characteristics of computers, including input, processing, storage, and output.
-
History of Computers
IN-04A brief history of computers, from their inception to the present day, highlighting key milestones and developments.
-
Generations of Computers
IN-05Understanding the different generations of computers, including their features, advantages, and limitations.
-
Classification of Computers
IN-06Categorizing computers based on their size, functionality, and application, including desktops, laptops, and mobile devices.
-
The Computer System
IN-07An in-depth look at the components of a computer system, including hardware and software.
-
Applications of Computers
IN-08Exploring the various applications of computers in different fields, including business, education, and healthcare.
-
Overview of Electronic Transaction Act of Nepal
IN-10Understanding the legal framework governing E-commerce in Nepal.
-
Application Areas
IN-09This topic explores the various application areas of simulation, including engineering, economics, and healthcare.
-
Software Engineering Ethics
IN-11Ethical considerations and principles in software engineering, including accountability, privacy, and intellectual property.
Key Topics
-
Basic Logic Gates
CO-01This topic covers the fundamental logic gates NOT, OR, and AND, including their symbols, truth tables, and applications.
-
Universal Logic Gates
CO-02This topic explores the universal logic gates NOR and NAND, their properties, and how they can be used to implement other logic gates.
-
EX-OR and EX-NOR Gates
CO-03This topic discusses the EX-OR and EX-NOR gates, their truth tables, and applications in digital circuits.
-
Boolean Algebra
CO-04This topic introduces Boolean algebra, including postulates, theorems, and canonical forms, and how they are used to simplify logic functions.
Key Topics
-
Search Engine Optimization
OP-1Understanding how to optimize e-commerce systems for search engines to improve visibility and drive traffic. This includes understanding how search engines work and techniques to improve search engine rankings.
-
Working Mechanism of Search Engines
OP-2In-depth understanding of how search engines crawl, index, and retrieve data to provide search results. This topic covers the inner workings of search engines.
-
On Page SEO
OP-3Optimizing individual web pages to improve search engine rankings. This includes techniques such as keyword optimization, meta tags, and content optimization.
-
Off Page SEO
OP-4Building a website's reputation and authority through external factors such as backlinks, social media, and online reputation management.
Key Topics
-
Introduction to DBMS
DA-01Introduction to Database Management Systems (DBMS), including its definition, importance, and evolution. This topic covers the basics of DBMS and its role in managing data.
-
Database Models
DA-02Database models refer to the conceptual representation of data organization and structure. This topic covers different database models such as hierarchical, network, and relational models.
-
SQL
DA-03Structured Query Language (SQL) is a standard language for managing relational databases. This topic covers the basics of SQL, including data definition, data manipulation, and data control languages.
-
Database Design and Data Security
DA-04Database design involves designing an efficient and secure database system. This topic covers database design principles, data security threats, and security measures to protect databases.
-
Data Warehouse
DA-05A data warehouse is a centralized repository that stores data from various sources. This topic covers the concept of data warehousing, its architecture, and its applications.
-
Data Mining
DA-06Data mining involves extracting useful patterns and knowledge from large datasets. This topic covers data mining techniques, including data preprocessing, pattern evaluation, and knowledge representation.
-
Database Administrator
DA-07A database administrator (DBA) is responsible for designing, implementing, and maintaining a database system. This topic covers the roles and responsibilities of a DBA, including database performance tuning and troubleshooting.
Key Topics
-
Introduction to Databases
DA-1Introduction to databases, including examples and basic concepts.
-
Database Management System
DA-2Introduction to Database Management Systems (DBMS), including advantages and examples.
-
Database Users
DA-3Types of database users, including actors on the scene and workers behind the scene.
-
Benefits of Databases
DA-4Advantages and benefits of using databases.
-
Data Models
DA-5Types of data models, including hierarchical, network, ER, relational, and object models.
-
Three-Schema Architecture
DA-6Three-schema architecture, including internal, conceptual, and external views.
-
Data Independence
DA-7Data independence, including logical and physical independence.
-
Database Languages
DA-8Types of database languages, including DDL, DML, SDL, and VDL.
-
Database Interfaces
DA-9Types of database interfaces, including menu-based, mobile apps, form-based, and GUI.
-
Database System Environment
DA-10The database system environment, including DBMS component modules, utilities, tools, and communications facilities.
Key Topics
-
Introduction to E-commerce
IN-1Overview of E-commerce and its significance in the digital age.
-
E-business vs E-commerce
IN-2Understanding the differences between E-business and E-commerce.
-
Features of E-commerce
IN-3Key characteristics and benefits of E-commerce.
-
Pure vs Partial E-commerce
IN-4Types of E-commerce models and their applications.
-
History of E-commerce
IN-5Evolution and development of E-commerce over time.
-
E-commerce Framework
IN-6Understanding the components of E-commerce framework including People, Public Policy, Marketing and Advertisement, Support Services, and Business Partnerships.
-
Types of E-commerce
IN-7Overview of different types of E-commerce including B2C, B2B, C2B, C2C, M-Commerce, U-commerce, Social-Ecommerce, and Local E-commerce.
-
Challenges in E-commerce
IN-8Common obstacles and difficulties faced in E-commerce.
-
Status of E-commerce in Nepal
IN-9Current state and trends of E-commerce in Nepal.
-
Overview of Electronic Transaction Act of Nepal
IN-10Understanding the legal framework governing E-commerce in Nepal.
-
Software Engineering Ethics
IN-11Ethical considerations and principles in software engineering, including accountability, privacy, and intellectual property.
-
Distributed Computing in Grid and Cloud
IN-12Exploring the role of distributed computing in grid and cloud environments, including its applications and benefits.
Key Topics
-
Basic Logic Gates
CO-01This topic covers the fundamental logic gates NOT, OR, and AND, including their symbols, truth tables, and applications.
-
Universal Logic Gates
CO-02This topic explores the universal logic gates NOR and NAND, their properties, and how they can be used to implement other logic gates.
-
EX-OR and EX-NOR Gates
CO-03This topic discusses the EX-OR and EX-NOR gates, their truth tables, and applications in digital circuits.
-
Boolean Algebra
CO-04This topic introduces Boolean algebra, including postulates, theorems, and canonical forms, and how they are used to simplify logic functions.
-
Simplification of Logic Functions Using Karnaugh Map
CO-05This topic covers the use of Karnaugh maps to simplify logic functions, including analysis of SOP and POS expressions.
-
Implementation of Combinational Logic Functions
CO-06This topic explores the implementation of combinational logic functions using encoders, decoders, half adders, and full adders.
-
Implementation of Data Processing Circuits
CO-07This topic covers the implementation of data processing circuits, including multiplexers, de-multiplexers, parallel adders, and parity generators/checkers.
-
Basic Concepts of Programmable Logic
CO-08This topic introduces the basic concepts of programmable logic, including PROM, EPROM, PAL, and PLA.
-
Programmable Logic Array (PLA)
CO-09A type of digital integrated circuit that can be programmed to perform a specific digital function.
-
Programmable Array Logic (PAL)
CO-10A type of digital integrated circuit that can be programmed to perform a specific digital function, similar to PLA but with some differences.
-
Optical Disk
CO-11A type of secondary storage that uses light to read and write data, including CDs, DVDs, and Blu-ray discs.
-
Magneto-Optical Disk
CO-12A type of secondary storage that uses a combination of magnetic and optical technologies to store data.
-
How the Computer uses its Memory
CO-13The process of how a computer uses its memory to execute instructions and perform tasks.