BSC Computer
BSC Computer
1
Indira Gandhi University, Meerpur, Rewari
Scheme of Examination for Undergraduate Programmes
Skill Enhancement Courses (Computer Science)
According to Curriculum Framework for Undergraduate Programmes
as per NEP 2020 (Multiple Entry-Exit, Internships and Choice Based Credit System)
Sem Course Course Nomenclature of Credits Contact Internal End Total Duration of
Type Code paper hours marks term Marks exam (Hrs)
Marks T+P
I SEC 24L4.5- Office and 2 2 15 35 50 3
SEC- Spreadsheet Tools
CSE-101 Learning
Practical 1 2 5 20 25 3
SEC 24L4.5- Advance Spreadsheet 2 2 15 35 50 3
SEC- Tools
CSE-102
Practical 1 2 5 20 25 3
SEC 24L4.5- Basic IT Tools 2 2 15 35 50 3
SEC-
CSE-103 Practical 1 2 5 20 25 3
SEC 24L4.5- Essentials of Python 2 2 15 35 50 3
SEC-
CSE-104 Practical 1 2 5 20 25 3
2
Indira Gandhi University Meerpur, Rewari
(A State University established under Haryana Act No.29 of 2013)
Recognized u/s 12 (b) & 2(f) of UGC Act, 1956
3
DEPARTMENT OF COMPUTER SCIENCE & ENGINEERING
INDIRA GANDHI UNIVERSITY, MEERPUR, REWARI
Session: 2024-25
Part A - Introduction
Subject COMPUTER SCIENCE
Semester I
Name of the Course Office and spreadsheet Tools Learning
Course Code 24L4.5-SEC-CSE-101
4
Unit Topics Contact
Hours
I Operating System - Definition, Functions, Types of Operating 8
System, Basics of Popular Operating Systems, The User Interface,
Exploring Computer, Icons, taskbar, desktop, Using Menu and Menu-
selection, managing files and folders, Control panel – display
properties, add/remove software and hardware, Common utilities.
II Word Processing - Introduction to Word Processing, Menus, 7
Creating, Editing & Formatting Document, Spell Checking, Printing,
Views, Tables, Word Art, Mail Merge, Macros, Inserting hyperlinks,
Searching for text, Modifying page setup, Applying document
themes, Applying document style sets, Inserting headers and footers.
III Spread Sheet: Elements of Electronics Spread Sheet, Applications, 8
Creating and Opening of Spread Sheet, Menus, Manipulation of cells:
Enter texts numbers and dates, Cell Height and Widths, Copying of
cells, Mathematical, Statistical and Financial function, Drawing
different types of charts, Sort and Filter Data.
IV Presentation Software: Creating, Modifying and enhancing a 7
presentation, Type of presentation views, Using sound, Animation,
Working with Objects, Printing.
V* Practicum: 30
Operating System:
Starting with basics of Operating Systems and its functionali-
ties
Word Processing:
Create and format word documents.
Use tables, word Art and other features in your documents.
Use macros to simplify the tasks in a document.
Use mail merge to write once for many.
Spread Sheet:
Use spreadsheet for basic data handling
Apply formulas to sheet for automation.
Use Charts & Shapes for better visualization of the data.
Use sorting and filtering of the data
Presentation Software:
Prepare and format presentations.
Apply slide transitions, animations and sequencing for slides.
Apply different formatting and insert options to make presen-
tation better.
Appling sound and animation.
Suggested Evaluation Methods
Internal Assessment: End Term
➢ Theory Examination:
Class Participation: 5 A three hour
Seminar/presentation/assignment/quiz/class test etc.: 5 exam for both
Mid-Term Exam: 5 theory and
5
➢ Practicum practicum.
Class Participation: -
Seminar/Demonstration/Viva-voce/Lab records etc.: 5
Mid-Term Exam: NA
6
DEPARTMENT OF COMPUTER SCIENCE & ENGINEERING
INDIRA GANDHI UNIVERSITY, MEERPUR, REWARI
Session: 2024-25
Part A - Introduction
Subject COMPUTER SCIENCE
Semester I
Name of the Course Advance Spreadsheet Tools
Course Code 24L4.5-SEC-CSE-102
CourseType: SEC
(CC/MCC/MDC/CC-
M/DSEC/VOC/DSE/PC/AEC/VAC)
Level of the course (As per Annex-
ure-I
Pre-requisite for the course (if
any)
Course Learning Outcomes(CLO): After completing this course, the learner will be able to:
1. create and format spreadsheets
2. create and format tables and applying formulas in a
spreadsheet
3. create charts and protect worksheets
4. create and use pivot charts and tables
7
Unit Topics Contact
Hours
I Manage Workbook Options and Settings: Create Worksheets and 8
Workbooks, navigate in Worksheets and Workbooks, Format
Worksheets and Workbooks, Customize Options and Views for
Worksheets and Workbooks, Configure Worksheets and Workbooks
for Distribution
Apply Custom Data Formats and Layouts: Apply Custom Data
Formats and Validation, Apply Advanced Conditional Formatting and
Filtering, Create and Modify Custom Workbook Elements
II Create Tables: Create and Manage Tables, Manage Table Styles and 7
Options, Filter and Sort a Table
Perform Operations with Formulas and Functions: Summarize Data
by using Functions, Perform Conditional Operations by using
Functions, Format and Modify Text by using Functions.
III Create Charts and Objects: Create Charts, Format Charts, Insert and 8
Format Objects
Manage Workbook Options and Settings: Manage Workbooks,
Manage Workbook Review Restrict editing
IV Create Advanced Formulas: Apply Functions in Formulas, Look up 7
data by using Functions, Apply Advanced Date and Time Functions,
Perform Data Analysis and Business Intelligence, Define Named
Ranges and Objects,
Create Advanced Charts and Tables: Create and Manage PivotTables,
Create and Manage Pivot Charts
V* Practicum: 30
Spread Sheet:
Use spreadsheet for basic data handling
Apply formulas to sheet for automation.
Use if-else to make certain decisions in a sheet.
Use Charts & Shapes for better visualization of data.
Use filters and data validation controls for control of data
Formatting data and spreadsheets
Creating and managing tables
Use Pivot table and charts
Use what-if analysis along with goal seek and scenarios
Suggested Evaluation Methods
Internal Assessment: End Term
➢ Theory Examination:
Class Participation: 5 A three hour
Seminar/presentation/assignment/quiz/class test etc.:5 exam for both
theory and
Mid-Term Exam: 5
practicum.
➢ Practicum
Class Participation: -
8
Seminar/Demonstration/Viva-voce/Lab records etc.:5
Mid-Term Exam: NA
Part C-Learning Resources
Recommended Books/e-resources/LMS:
Help files from Apache Open Office, [Link]
Channelle Andy, “Beginning OpenOffice 3: From Novice to Professional”, aPress
Publications
Beginning OpenOffice 3: From Novice to Professional, Andichannele, Apress.
Microsoft Office 2016 Step by Step: MS Office 2016 Step by Step, By Joan Lambert,
Curtis Frye
Getting Started with LibreOffice 5.0, Friends of OpenDocuments Inc.,
Http://[Link]
Documentation from LibreOffice, [Link]
documentation/
Walter Holland, Microsoft Office 2013 Digital Classroom
Wayne L. Winston, Data Analysis and Business Modeling
9
DEPARTMENT OF COMPUTER SCIENCE & ENGINEERING
INDIRA GANDHI UNIVERSITY, MEERPUR, REWARI
Session: 2024-25
Part A - Introduction
Subject COMPUTER SCIENCE
Semester I
Name of the Course Basic IT Tools
Course Code 24L4.5-SEC-CSE-103
10
Candidate will have to attempt five questions in all, selecting one question from each unit. First
question will be compulsory.
Practicum will be evaluated by an external and an internal examiner. Examination will be of three-
hour duration.
Unit Topics Contact
Hours
I Introduction to Computer: Computer and Latest IT gadgets, Evolution 8
of Computers & its applications, Basics of Hardware and Software,
Application Software, Systems Software, Utility Software. Central
Processing Unit, Input devices, Output devices, Computer Memory &
storage, Mobile Apps.
II Introduction to Operating System, Functions of the Operating system, 7
Operating Systems for Desktop and Laptop, Operating Systems for
Mobile Phone and Tablets, User Interface for Desktop and Laptop,
Task Bar, Icons & shortcuts, Running an Application, Operating
System Simple Setting, Changing System Date and Time, Changing
Display Properties, To Add or Remove Program and Features,
Adding, Removing & Sharing Printers, File and Folder Management.
III Introduction to Internet and World Wide Web, Basic of Computer 8
Networks, Local Area Network (LAN), Wide Area Network (WAN),
Network Topology, Internet, Applications of Internet, Website
Address and URL, Popular Web Browsers (Internet Explorer/Edge,
Chrome, Mozilla Firefox, Opera etc.), Popular Search Engines,
Searching on the Internet.
IV E-mail: Using E-mails, Opening Email account, Mailbox: Inbox and 7
Outbox, Creating and Sending a new E-mail, replying to an E-mail
message, forwarding an E-mail message, searching emails, Attaching
files with email, Email Signature. Social Networking: Facebook,
Twitter, LinkedIn, Instagram, Instant Messaging (WhatsApp,
Facebook Messenger, Telegram), Introduction to Blogs, Digital
Locker.
V* Practicum: 30
Identify the various parts of computer
Using computer/mobile software and hardware
Use of operating system for various tasks such as file creation,
directory creation, shortcut creation, using control panel, etc.
Using Internet & various browsers.
Identify the various hardware/software required for Internet
How to create and use e-mail account
Using Facebook, WhatsApp, Instagram, LinkedIn, Telegram
Writing blogs
Suggested Evaluation Methods
Internal Assessment: End Term
➢ Theory Examination:
A three hour ex-
11
Class Participation: 5 am for both
Seminar/presentation/assignment/quiz/class test etc.:5 theory and
Mid-Term Exam: 5 practicum.
➢ Practicum
Class Participation: -
Seminar/Demonstration/Viva-voce/Lab records etc.:5
Mid-Term Exam: NA
PartC-Learning Resources
Recommended Books/e-resources/LMS:
Sinha, P.K. & Sinha, Priti, Computer Fundamentals, BPB
Dromey, R.G., How to Solve it By Computer, PHI
Norton, Peter, Introduction to Computer, McGraw-Hill
Leon, Alexis & Leon, Mathews, Introduction to Computers, Leon Tech World
Rajaraman, V., Fundamentals of Computers, PHI
Ram, B., Computer Fundamentals, Architecture & Organization, New Age International
(P) Ltd.
12
DEPARTMENT OF COMPUTER SCIENCE & ENGINEERING
INDIRA GANDHI UNIVERSITY, MEERPUR, REWARI
Session: 2024-25
Part A - Introduction
Subject COMPUTER SCIENCE
Semester I
Name of the Course Essentials of Python
Course Code 24L4.5-SEC-CSE-104
13
three-hour duration.
Unit Topics Contact
Hours
I Keywords and Identifiers; Comments: Purpose/use of comments, 8
Single line comment/Multiline comment; Python Variables:
Declaration of Variables, Assign Values to Variables, Initializa-
tion, Reading, Variable naming restrictions, and Types of Python
Variables.
Python Data Types: Implicit Declaration of Data Types, Python
Numbers (Integers, floating-point numbers, and complex
numbers), Python Strings, Python Boolean data type;
II Operators: Arithmetic, Comparison/Relational Operators, 7
Increment Operators, Logical operators, Identity Operators, and
Operators Precedence.
Python Control Flow Statement, Decision Making: Simple If
Structure, if-else structure, if elif structure, and nested If Structure;
III Looping: Python Loop Statements. Python while loop, Python for 8
loop, Python range(), Python Nested Loop Structures, and
Inserting conditions in Loops and vice versa; Python Branching
Statements – break, continue, pass.
Python Lists: Create Python Lists, Update Python Lists, Delete
Elements from Python Lists, and Built-in Functions Methods for
Python Lists.
IV Tuples: create, update, join and methods; Sets: create, add/remove 7
items, join sets, set methods;
Dictionary: create, access, add/remove items, dictionary methods.
Manipulating
Strings - Working with Strings, Useful String Methods
Python Functions: defining function, arbitrary arguments,
keywords arguments, default parameter values, return value and
return statements; Lambda; Arrays: looping through array
elements, array methods;
V* Students are advised to do laboratory/practical practice not limited 30
to, but including the following types of problems:
Write a program to compute distance between two points
taking input from the user (Pythagorean Theorem).
Write a program [Link] that takes 2 numbers as command
line arguments and prints its sum.
Write a Program for checking whether the given number is
an even number or not.
Using for loop, write a program that prints out the decimal
equivalents of 1/2, 1/3, 1/4, ..1/10.
Create a list and perform the following methods
(a) insert() (b) remove() (c) append() (d) len()
(e) pop() (f) clear()
Create a dictionary and apply the followingmethods:
(a) Print the dictionary items (b) access items
14
(c) useget() (d) change values (e) use len()
Create a tuple and perform the following methods:
(a) Add items (b) len() (c) check for item in tuple
(d) Access items
Write a python program to print a number is posi-
tive/negative using if-else.
Write a python program to find largest number among
three numbers.
Write a python Program to read a number and display cor-
responding day using if_elif_else?
Write a program to create a menu with the following op-
tions:
(a) To perform addition
(b) To perform subtraction
(c) To perform multiplication
(d) To perform division
Accepts users input and perform the operation according-
ly. Use functions with arguments.
Write a python program to check whether the given string
is palindrome or not.
Write a python program to find factorial of a given num-
ber using functions
Write a Python function that takes two lists and returns
True if they are equal otherwise false.
Demonstrate a python code to print try, except and finally
block statements.
Write a Python script that prints prime numbers less than
20.
Write a python program to find factorial of a number.
Suggested Evaluation Methods
Internal Assessment: End Term
➢ Theory Examination:
Class Participation: 5 A three hour
Seminar/presentation/assignment/quiz/class test etc.:5 exam for both
Mid-Term Exam: 5 theory and
practicum.
➢ Practicum
Class Participation: -
Seminar/Demonstration/Viva-voce/Lab records etc.:5
Mid-Term Exam: NA
15
Charles R. Severance, “Python for Everybody: Exploring Data Using Python 3”,1st
Edition, Shroff Publishers, 2017. ISBN: 978-9352136278
16
DEPARTMENT OF COMPUTER SCIENCE & ENGINEERING
INDIRA GANDHI UNIVERSITY, MEERPUR, REWARI
Session: 2024-25
Part A - Introduction
Subject COMPUTER SCIENCE
Semester I
Name of the Course Introductory Course in R
Course Code 24L4.5-SEC-CSE-105
17
Unit Topics Contact
Hours
I Introducing to R, Installation of Libraries; Constants and 8
Variables; Numbers; R Data Structures, Help functions in R.
Vectors: Numeric Vectors, Scalars, Declarations
Vectorized operation: Using all and any, NA and NULL values,
Filtering, Vectorized if-then else, Vector Equality, Vector Element
names, Arithmetic and Boolean operations, conditional and loop
statement in R.
II Functions and Recursions in R, Packages in R; 7
Creating matrices, Matrix operations, Applying Functions to
Matrix Rows and Columns: Adding and deleting rows and
columns, Higher Dimensional arrays; Vector/Matrix Distinction;
Avoiding Dimension Reduction; Characters and Strings; String
vector; String operations and functions.
III List: Creating lists, General list operations, accessing list 8
components and values, applying functions to lists, recursive lists,
Different R operations using a List, matrix, Array;
Overview on Data Frames: Create it in scratch, Matrix-like
operations in frames, Merging Data Frames, Applying functions to
Data frames.
IV Factors and Tables: factors and levels, Common functions used 7
with factors, working with tables, Math and Simulations in R,
reading a datafile directly into a dataframe, EDA using R, Reading
different file formats.
Input/Output: reading and writing files, String Manipulation.
Statistical analysis: Basic Statistical function, Linear Model, R
functions for statistical analysis
V* Students are advised to do laboratory/practical practice not limited 30
to, but including the following types of problems:
Perform arithmetic operations in R.
Demonstrate the process of creating a user defined func-
tion in R.
Perform logical operations in R.
Implement Loops with different examples.
Learn the basics of functions in R and implement with ex-
amples.
Implement data frames in R. Write a program to join col-
umns and rows in a dataframe using cbind() and rbind() in
R.
Implement different String Manipulation functions in R.
Implement different data structures in R (Vectors, Lists,
Data Frames)
Write a program to read a csv file and analyze the data in
the file in R
Create a data set and do statistical analysis on the data us-
ing R
18
Suggested Evaluation Methods
Internal Assessment: End Term Exam-
➢ Theory ination:
Class Participation: 5 A three hour exam
Seminar/presentation/assignment/quiz/class test etc.:5 for both theory and
Mid-Term Exam: 5 practicum.
➢ Practicum
Class Participation: -
Seminar/Demonstration/Viva-voce/Lab records etc.:5
Mid-Term Exam: NA
19
DEPARTMENT OF COMPUTER SCIENCE & ENGINEERING
INDIRA GANDHI UNIVERSITY, MEERPUR, REWARI
Session: 2024-25
Part A - Introduction
Subject COMPUTER SCIENCE
Semester I
Name of the Course Computer Programming in C
Course Code 24L4.5-SEC-CSE-106
20
Practicum will be evaluated by an external and an internal examiner. Examination will be of
three-hour duration.
Unit Topics Contact
Hours
I Introduction to C: Data Types: Primitive Data types, Derived 8
Data types, User-Defined Data Types;
Operators: Different Types of Operators, Precedence of
Operators, Expression and Statements;
Token: Variables, Constants, Literals, Identifiers, Keyword,
Escape Sequence;
Types of Conversion: Typecasting, Conversion.
II Decision Control Statements: IF, IF-ELSE, Nested IF, IF- ELSE 7
ladder, Switch-case;
Iterative statements: FOR loop, WHILE loop, DO-WHILE loop;
Jump Statements: Break, Continue.
III Array: Declaration of an Array, Initialization of Array, Type of 8
Array: Single Dimension Array, Two-Dimensional Array; Address
Calculation of an Element in Array.
Character Array and Strings: Reading, writing, String Handling
Functions: strcat(), strcmp(), strcpy(), strlen().
IV Functions: User-Defined Functions; Function Declaration; Types 7
of Arguments: Actual Arguments, Formal Arguments; Function
Definition; Methods to Call a Function: Call by Value, Call by
Reference; Passing Arrays as Parameters.
Storage classes: Automatic, Register, Static, and External
Structures; Unions; Enumerations.
V* Students are advised to do laboratory/practical practice not limited 30
to, but including the following types of problems:
Given the values of the variables x, y and z, write a pro-
gram to rotate their values such that x has the value of y, y
has the value of z, and z has the value of x
The distance between two cities (in Km) is input through
the keyboard. Write a C program to convert and print this
distance in meter, feet, inches and centimeter.
If a five-digit number is input through the keyboard, write
a C program to calculate the sum of its digits without us-
ing loop.
If a four-digit number is input through the keyboard, write
a C program to obtain the sum of the first and last digit of
this number.
Program to find largest and smallest number from four
given number.
Program to find whether a year is leap or not.
Program to find out the grade of a student when the marks
of 5 subjects are given.
A library charges a fine for every book returned late. For
first 5 days the fine is 50 paise, for 6-10 days fine is one
21
rupee and above 10 days fine is 5 rupees. If you return the
book after 30 days your membership will be cancelled.
Write a program to access the number of days the member
is late to return the book and display the fine or the appro-
priate message.
Write a C program in which enter any number by the user
and perform the operation of Sum of digits of entered
number.
Write a C Program to convert Decimal number to Binary
number.
WAP to compute the sum of the first n terms of the fol-
lowing series S = 1+1/2+1/3+1/4+……
Write a C program to perform the factorial of given num-
ber.
Write a C program to count the number of positive, nega-
tive and zero number in the given list of numbers.
Suppose you need to generate a result table which consists
of student id, student name, marks of three subject and to-
tal marks. Write a program which takes input for ten stu-
dents and displays result table. Also display student in-
formation separately who got the highest total. USE
STUCTURES.
WAP to enter an integer array of size 10 and perform fol-
lowing operations on it.
a) Display the Elements.
b) Calculate the Sum and Average of Array.
c) Find largest element.
d) Find second largest element.
e) Find the Smallest element.
f) Display the Array in Reverse order.
g) Exit
WAP to display Fibonacci series (i)using recursion, (ii)
using iteration
Write a menu driven program to perform following opera-
tions on strings:
a. Show address of each character in string
b. Concatenate two strings without using strcat function.
c. Concatenate two strings using strcat function.
d. Compare two strings
e. Calculate length of the string (use pointers)
f. Convert all lowercase characters to uppercase
g. Convert all uppercase characters to lowercase
h. Calculate number of vowels
i. Reverse the string
Session:2025-26
Part A-Introduction
Subject COMPUTER SCIENCE
Semester III
Name of the Course Advance IT Skills
Course Code 24L4.5-SEC-CSE-305
Course Type: SEC
(CC/MCC/MDC/CC-
M/DSEC/VOC/DSE/PC/AEC/
VAC)
Level of the course (As per An-
nexure-I)
Pre-requisite for the course (if
any)
Course Learning Outcomes(CLO): After completing this course, the learner will be able to:
1. Use e-Governance applications; and use computer to
improve existing skills and learn new skills
2. Using internet for Digital Financial services
3. Understand the concept of Cyber security and
issues and challenges associated with it
4. Develop knowledge about Future Skills