B.Sc Computer Science

Minor Course Syllabus

Minor A

KU1DSCCSC104

OFFICE AUTOMATION SOFTWARE

Module 1 Introduction to Word Processing

  • Getting Started with the Interface
  • Creating and Saving Documents
  • Text Formatting and Editing Tools
  • Paragraph Indentation
  • Bullets and Numbering
  • Line Spacing
  • Alignment
  • Change Case
  • Text Highlight Color
  • Font Color
  • Bold, Italics and Underline
  • Styles and Templates

Module 2 Advanced Word Processing Techniques

  • Working with Tables and Images
  • Creating Headers
  • Footers
  • Page Numbers
  • Mail Merge
  • Creating Form Letters
  • Document Security
  • Document Protection

Module 3 Introduction to Spreadsheets

  • Understanding Spreadsheets
  • Cells, Rows & Columns
  • Entering and Editing Data
  • Formatting Data
  • Creating Charts
  • Creating Graphs
  • Printing Spreadsheets
  • Sharing Spreadsheets

Module 4 Advanced Spreadsheet Techniques

  • Working with Large Datasets
  • Filtering and Sorting
  • SUM()
  • AVERAGE()
  • MAX()
  • MIN()
  • COUNT()
  • Arithmetic Operations (+,-,*,/)
  • Text Functions (CONCAT, UPPER, LOWER, PROPER)
  • Logical Functions (IF, AND, OR)
  • Lookup Functions (VLOOKUP, MATCH)
  • Date Functions (TODAY(), NOW(), DATE())
  • Statistical Functions (AVERAGE, MEDIAN, STDEV)
  • Pivot Tables
  • Creating Macros
  • Spreadsheet Automation

Teacher Specific Module

  1. Document creation using Word Processor.
  2. Create a banner for College Union Inauguration.
  3. Create a Biodata with photograph.
  4. Implement Mail Merge.
  5. Spreadsheet program using aggregate functions.
  6. Result Analysis using different charts.

Minor B

KU1DSCCSC105

INTRODUCTION TO WEB PROGRAMMING

Module 1 Introduction to Internet & WWW

  • Evolution of Internet
  • World Wide Web
  • Web Browsers
  • URL
  • HTTP Protocol
  • Static Web Pages
  • Dynamic Web Pages
  • Client Side Scripting
  • Server Side Scripting
  • World Wide Web Consortium (W3C)
  • Web Hosting
  • Types of Hosting
  • Free Hosting
  • Domain Name Registration

Module 2 HTML

  • Introduction to HTML
  • Creating HTML Documents
  • HTML Tags & Attributes
  • Starting & Ending Tags
  • HTML Structure
  • Paragraphs
  • Headings
  • Physical Style Tags
  • Fonts
  • Text Alignment
  • Hyperlinks
  • Image Tag
  • Comments
  • Line Breaks
  • Lists
  • Nested Lists

Module 3 HTML Tables & Forms

  • Create Tables
  • Table Tags & Attributes
  • Width & Height
  • Border
  • Padding
  • Spacing
  • Colspan & Rowspan
  • HTML Forms
  • Input Elements
  • Select
  • Textarea
  • Button
  • Datalist
  • Radio Button
  • Checkbox
  • Email Input
  • Date Input
  • Number Input
  • Required Attribute
  • Pattern Validation

Module 4 CSS

  • Introduction to CSS
  • Advantages of CSS
  • Inline CSS
  • Internal CSS
  • External CSS
  • CSS Colours
  • Fonts
  • Borders
  • Padding
  • Margin
  • Class Selector
  • ID Selector
  • Applying Styles

Teacher Specific Module

  1. HTML Program using basic tags.
  2. Heading Formatting.
  3. Image Tag Implementation.
  4. Different Types of Lists.
  5. Design Student Mark List using Table.
  6. Implement HTML Forms and Attributes.

MDC

KU1MDCCSC101

ESSENTIALS OF COMPUTING

Module 1 Basic Components of the Computer System

  • Introduction to Computers
  • Definition & Characteristics of Computers
  • History & Evolution of Computers
  • Computer System Overview
  • Input Devices
  • Output Devices
  • Processing Unit
  • Storage Devices
  • Central Processing Unit (CPU)
  • Arithmetic Logic Unit (ALU)
  • Registers
  • Control Unit
  • Primary Memory
  • RAM
  • ROM
  • Secondary Storage
  • Hard Disk
  • SSD
  • USB Drives
  • Cache Memory

Module 2 Data Representation

  • Decimal Number System
  • Binary Number System
  • Hexadecimal Number System
  • Octal Number System
  • Conversions between Number Systems
  • Binary Addition
  • Binary Subtraction
  • 1's Complement
  • 2's Complement
  • BCD Code
  • Gray Code
  • ASCII Code
  • Unicode

Module 3 Types of Software

  • Introduction to Software
  • Application Software
  • System Software
  • Operating Systems
  • Functions of Operating System
  • Examples of Operating Systems
  • Retail Software
  • OEM Software
  • Demo Software
  • Shareware
  • Freeware
  • Open Source Software
  • Programming Languages
  • Compiler
  • Interpreter
  • Assembler
  • Linker
  • Loader
  • Source Code
  • Object Code

Module 4 Basics of Computer Networks

  • Introduction to Networking
  • Data Communication
  • Components of Communication System
  • Advantages of Networking
  • Network Hardware
  • Transmission Modes
  • Simplex
  • Half Duplex
  • Full Duplex
  • LAN
  • MAN
  • WAN
  • Internet
  • Network Topologies
  • Bus Topology
  • Star Topology
  • Ring Topology
  • Mesh Topology
  • Internet Applications
  • World Wide Web
  • Web Browser
  • HTTP / HTTPS
  • URL
  • Domain Name

Teacher Specific Module

Provide suitable practical exercises, demonstrations, assignments and evaluation methodologies related to each module.