Computer Science



 
Sr. No Name of the course Duration Eligibility Intake Year
01 Office Automation 30 hrs 12th 20 2019-20
02 Introduction to Cloud computing 30 hrs 12th 20 2020-21
03 30 hrs 12th 20 2021-22
04 The Complete Internet of Things for Begineers 40 hrs 12th 20 2022-23

1) Office Automation

Course Objective :
 

    The course is designed to equip a student to use computers for professional as well as day to day use. It provides theoretical background as well as in depth knowledge of Software/packages. After completing the course the incumbent will be digitally literate and will be able to:

Acquire confidence in using computers in Office and General Life;
Will be able to identify the basic components of computers and terminology;
Understand file management;
Create documents using word processor, spreadsheet & presentation software;
Understand computer networks, and browse the internet, content search, email and collaborate with peers;
Use e-Governance applications; and use computer to improve existing skills and learn new skills
Understanding Social Networking platform

Learning Outcome :
 

    After completion of the course, students would be able to documents, spreadsheets, make small presentations and would be acquainted with internet.

Course Duration :
 

    30 Periods

Job Role :
 

    Computer Operator, Data Entry Operator and Social Media Operator

Outline of Course :
 

Sr.No. Chapter Name Course Outline
1 Chapter-1 Introduction to Computer Introduction Objectives
Computer and Latest IT gadgets and their applications
Basics of Hardware and Software
Hardware
Central Processing Unit
Input devices, Output devices
Computer Memory & storage
Software
Application Software, Systems Software
Utility Software, Mobile Apps
Open source and Proprietary Software
2 Chapter-2 Introduction to Operating System Introduction
Objectives, Operating System
Basics of Operating system
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
Using Mouse and Changing its Properties
Changing System Date and Time
Changing Display Properties
To Add or Remove Program and Features
Adding, Removing & Sharing Printers
File and Folder Management, Types of file Extensions
3. Chapter-3 WORD PROCESSING Introduction
Objective
Word Processing Basics
Opening Word Processing Package
Title Bar, Menu Bar, Toolbars & Sidebar
Creating a New Document
Opening and Closing Documents
Opening Documents, Save and Save As
Closing Document, Using The Help
Page Setup, Print Preview
Printing of Documents
PDF file and Saving a Document as PDF file
Text Creation and manipulation
Document Creation, Editing Text, Text Selection
Cut, Copy and Paste, Font, Color, Style and Size selection, Alignment of Text, Undo & Redo
AutoCorrect, Spelling & Grammar, Find and Replace, Formatting the Text, Paragraph Indentation, Bullets and Numbering, Change case, Header & Footer
Table Manipulation
Insert & Draw Table, Changing cell width and height, Alignment of Text in cell
Delete / Insertion of Row, Column and Merging & Splitting of Cells,
Border and Shading, Mail Merge, Shortcut Keys
4. Chapter-4 SPREAD SHEET Introduction
Objectives
Elements of Spread Sheet
Creating of Spread Sheet
Concept of Cell Address [Row and Column] and selecting a Cell
Entering Data [text, number, date] in Cells, Page Setup, Printing of Sheet
Saving Spreadsheet,
Opening and Closing
Manipulation of Cells & Sheet
Modifying / Editing Cell Content
Formatting Cell (Font, Alignment, Style ) Cut, Copy, Paste & Paste Special
Changing Cell Height and Width
Inserting and Deleting Rows, Column
AutoFill, Sorting & Filtering
Freezing panes
Formulas, Functions and Charts
Using Formulas for Numbers (Addition, Subtraction, Multiplication & Division)
AutoSum, Functions (Sum, Count, MAX, MIN, AVERAGE), Charts (Bar, Pie, Line)
5. Chapter-5 Presentation Introduction
Objectives
Creation of Presentation
Creating a Presentation Using a Template
Creating a Blank Presentation
Inserting & Editing Text on Slides
Inserting and Deleting Slides in a Presentation
Saving a Presentation, Manipulating Slides
Inserting Table, Adding ClipArt Pictures
Inserting Other Objects
Resizing and Scaling an Object
Creating & using Master Slide
Presentation of Slides
Choosing a Set Up for Presentation
Running a Slide Show
Transition and Slide Timings
Automating a Slide Show
Providing Aesthetics to Slides & Printing
Enhancing Text Presentation
Working with Color and Line Style
Adding Movie and Sound
Adding Headers, Footers and Notes
Printing Slides and Handouts
6. Chapter-6 INTRODUCTI ON TO INTERNET AND WWW Introduction
Objectives
Basic of Computer Networks
Network Topology
Internet
Concept of Internet & WWW
Applications of Internet
Website Address and URL
Introduction to IP Address
ISP and Role of ISP
Internet Protocol
Modes of Connecting Internet (Hotspot, Wi- Fi, LAN Cable, Broadband, USB Tethering)
Popular Web Browsers (Internet Explorer/Edge, Chrome, Mozilla Firefox, Opera etc.)
Exploring the Internet
Surfing the web
Popular Search Engines
Searching on Internet
Downloading Web Pages
Printing Web Pages

Examination :
 

    After completion of course, Department will conduct Theory (One Hour) and Practical (Three Hours) Examination for 100 Marks (Theory : 40 and Practical : 60).

Books recommended for reference and reading :
 

   Fundamentals of computers - V.Rajaraman - Prentice- Hall of india
   Computer Fundamentals - P. K. Sinha Publisher: BPB Publications
   Microsoft Office 2007 Bible - John Walkenbach,Herb Tyson,Faithe Wempen,cary N.Prague, Michael R.groh,Peter G.Aitken, and Lisa a.Bucki -Wiley India pvt.ltd.
   https://bosslinux.in/sites/default/files/BOSS4.0-Usermanual.pdf (For EduBOSS3.0)
   https://wiki.openoffice.org/wiki/Documentation
   http://windows.microsoft.com/en-in/windows/windows-basics-all-topics




2) Introduction to Cloud computing

Course Objective :
 

    Aimed at Up-skilling of undergraduate students those are keen to undergo a significant change in their career path. This course is also be offered to engineering students who want to pursuing his interns, apprentices and industrial training on Cloud Computing.

Learning Outcome :
 

    Initially, candidates can work as Virtualization Engineer/Programmer/Cloud and Virtualization Expert whose role would be to identify virtualization requirement and provide virtualized solution in Cloud to clients at service provider end. Later on, they can be Data Centre Architect whose job would be to setup Data Centre that provides various services like IaaS, SaaS and PaaS. This course also helps to prepare for the AWS Certified Cloud Practitioner and AWS Solution Architect exam Overview about virtualization and cloud computing.

Course Duration :
 

    30 Periods

Eligibility :
 

    Students undergoing under graduation programme under any university.

Prerequisite :
 

    Basic Knowledge of computer networking.

Hardware requirement :
 

    Laptop or Desktop with internet connectivity.

Syllabus :
 

   1. Introduction to Cloud computing

Understanding cloud fundamental
Pre-requisites for Cloud Computing (Networking, Security, Web services, Distributed computing).
Overview of Cloud & Architecture - Evolution of Cloud, Cloud Characteristics, Types and services, Cloud Architecture with Layers, Service & deployment model.

   2. Virtualization

Introduction & evaluation of Virtualization, Virtualization Approaches, Virtualization Types, Various Virtualization Tools (VT-X, Bare Metal provisioning, Type -I and Type-II hypervisors KVM, Hyper-V, Oracle Virtual Box, VMware Workstation Tools).
Configuring VMware/ Virtual Box
Setting Linux Container

   3. Basic Linux Commands

Linux File System
File Handling
Text Processing with gedit, nano, vim
Installing Software
Remote Access

   4. Deployment of Public Cloud on AWS
   A. Part – 01 (Theory)

Amazon EC2
Amazon Simple Storage Service (S3)
AWS Command Line Interface (CLI)
Amazon CloudFront
AWS Identity and Access Management (IAM)
Amazon RDS
AWS Lambda
Amazon VPC
Amazon LightSail
Others

   B. Part – 02 (Lab)

Launch & connect EC2 instance - Window Server/Linux Machine (using PuttY)
Hosting Static Website over IIS-Window Server & Apache-Linux.
Lab on creating Virtual Private Network (VPC) with Public & Private Subnets along with VPC peering in same/different region.
Lab on Setup a NAT Gateway in Public Subnet over VPC with VPC endpoint.
Lab on creation site to site secures VPN connection other application of VPN.
Lab on Elastic Load Balancers (ELB) with auto scaling - Application/Network/Classic
Lab on launch & access MySQL DB from window Server/Linux machine and MySQL multi-AZ.
Lab on AWS Dynamo DB, Route 53 & AWS Lambda
Other: lab

   5. Setting Private Cloud with Open-Source tool Free (OpenStack & its components)

Introduction to Private Cloud
Openstack Component
Keystone
Glance
Nova
Swift
Cinder
Neutron
Lab - Installation and configuration of Openstack (Controller, Compute & Storage)
Installation of Openstack and its Component (Keystone, Horizon, Nova, Cinder, Newton and others)
Lab- Security with Free and open-source tool (installation, configuration and working on application, data, network, Server)

   6. Laboratory of DevOps over Cloud

Introduction to Docker, ansible and Kubernetes
Installing and configuration of Docker & over AWS
Installing and configuration of Ansible over AWS

   7. Cloud Security

A. Access Control Types
B. Cryptography and Algorithm Analysis
C. Cloud Monitoring & Cloud Standards

   8. Mini Project Work

Reference Books & Links :
 

   Cloud Computing: Concepts, Technology & Architecture by Thomas Erl and Ricardo Puttini
   Cloud Computing For Dummies by Judith Hurwitz
   Cloud Computing: From Beginning to End by Mr Ray J Rafaels
   Cloud Computing by Sandeep Bhowmik
   Cloud Computing – An Introduction by Subu Sangameswar
   https://gacbe.ac.in/pdf/ematerial/18MCA43C-U1.pdf
   https://mu.ac.in/wp-content/uploads/2021/01/Cloud-Computing.pdf
   https://www.researchgate.net/publication/260038060_Cloud_Computing_A_Comprehensive_Introduction
   https://www.kth.se/social/files/554fa451f276544829be2e5e/9-cloud-computing.pdf
   https://studytm.files.wordpress.com/2014/03/hand-book-of-cloud-computing.pdf
   https://www.dialogic.com/~/media/products/docs/whitepapers/12023-cloud-computing-wp.pdf

Time Table :
 

Duration : 01/09/2020 to 31/12/2020 (30 Periods)

Month Date Time
September 2020 1, 2, 8, 9, 15, 16, 22, 23, 29, 30 Evening 4:30 to 5:30
October 2020 6, 7, 13, 14, 20, 21, 27, 28 Evening 4:30 to 5:30
November 2020 3, 4, 10, 11, 17, 18, 24, 25 Evening 4:30 to 5:30
December 2020 1, 2, 8, 9, 15, 16, 22, 23, 30 Evening 4:30 to 5:30




4) The Complete Internet of Things for Begineers

Objective of the Course :
 

    This Course focuses on hands-on IoT concepts such as sensing, actuation and communication. It covers the development of Internet of Things (IoT) prototypes- including devices for sensing, actuation, processing, and communication-to help you develop skills and experiences. The Internet of Things (IOT) is the next wave, world is going to witness. Today we live in an era of connected devices the future is of connected things.

Learning Outcome :
 

    After the completion of the course, the students will be able design some IOT based prototypes.

Course Duration :
 

    30 Periods

Minimum Eligibility Criteria :
 

    Pursuing/Passed BCA/B. Sc.

Course Outline:
 

    Basic Knowledge of computer networking.

Sr. No. Modules to be Covered
1 Introduction to IOT
2 Arduino Simulation Environment
3 Sensor & Actuators with Arduino
4 Basic Networking with ESP8266 Wi-Fi module
5 IoT Protocols
6 Cloud Platforms for IOT

Detailed Course Syllabus :
 

   1. Introduction to IOT

Understanding IoT fundamentals
IOT Architecture and protocols
Various Platforms for IoT
Real time Examples of IoT
Overview of IoT components and IoT Communication Technologies
Challenges in IOT

   2. Arduino Simulation Environment

Arduino Uno Architecture
Setup the IDE, Writing Arduino Software
Arduino Libraries
Basics of Embedded C programming for Arduino
Interfacing LED, push button and buzzer with Arduino
Interfacing Arduino with LCD

   3. Sensor & Actuators with Arduino

Overview of Sensors working
Analog and Digital Sensors
Interfacing of Temperature, Humidity, Motion, Light and Gas Sensor with Arduino
Interfacing of Actuators with Arduino.
Interfacing of Relay Switch and Servo Motor with Arduino

   4. Basic Networking with ESP8266

WiFi module Basics of Wireless Networking
Introduction to ESP8266 Wi-Fi Module
Various Wi-Fi library
Web server- introduction, installation, configuration
Posting sensor(s) data to web server

   5. IoT Protocols

M2M vs. IOT
Communication Protocols

   6. Cloud Platforms for IOT

Virtualization concepts and Cloud Architecture
Cloud computing, benefits
Cloud services -- SaaS, PaaS, IaaS
Cloud providers & offerings
Study of IOT Cloud platforms
ThingSpeak API and MQTT
Interfacing ESP8266 with Web services

Reference Books & Links :
 

  Getting Started with the Internet of Things by Cuno Pfister
   The Internet of Things” by Samuel Greengard
   Precision: Principles, Practices and Solutions for the Internet of Things” by Timothy Chou
   Building the Internet of Things by Maciej Kranz
   Everyware: The Dawning Age of Ubiquitous Computing” by Adam Greenfield
   https://mrcet.com/downloads/digital_notes/EEE/IoT%20&%20Applications%20D igital%20Notes.pdf
   https://www.tutorialspoint.com/internet_of_things/internet_of_things_tutorial.pdf
   https://freecomputerbooks.com/Internet-of-Things-in-5-days.html

Time Table :
 

Duration : 10/08/2022 to 30/09/2022 (40 Periods)

Month Date Time
August 2022 10, 11, 12, 13, 17, 18, 19, 19, 20, 22, 23, 24, 25, 26, 27, 29, 30 Evening 4:30 to 5:30
September 2022 1, 2, 3, 5, 6, 7, 8, 10, 12, 13, 14,15, 16, 19, 20, 21, 22, 23, 24, 26, 27, 28, 29, 29, 30 Evening 4:30 to 5:30