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.
Unit Contents
1. Introduction to Computer System : 16 hrs
Introduction to Computer, Characteristics of Computer, Applications of Computer, Classification of Computer, Mobile Computing , Anatomy of a Digital Computer, Computer Architecture, Memory & Its Classification, Input devices, Output Devices, Interfaces.
2. Computer Software : 3 hrs
Introduction to Software, Types of Software, Program vs. Software, Computer Virus and Antivirus.
3. Operating System : 4 hrs
Introduction to Operating System, Function of Operating System, Types of Operating System, Open Source Operating System.
4. Database Management System : 8 hrs
Introduction to DBMS, Database Models, SQL, Database Design and Data Security, Data Warehouse, Data Mining, Database Administrator.
5. Data Communication and Computer Network : 10 hrs
Introduction to communication system, Mode of Communication, Introduction to Computer Network, Types of Computer Network, LAN Topologies, Transmission Media, Network Devices, OSI Reference Model, Communication Protocols, Centralized vs. Distributed System.
6. Internet and WWW : 6 hrs
Internet: Introduction to Internet and its Applications, Connecting to the Internet, Client/Server Technology, Internet as a Client/Server Technology, Email, Video-Conferencing, Internet Service Providers, Domain Name Server, Internet Address, Internet Protocols, (IP, TCP, HTTP, FTP, SMTP, POP, Telnet, Gopher, WAIS), Introduction to Intranet, Internet vs. Intranet vs. Extranet, Advantages & Disadvantages of Intranet.
World Wide Web(WWW): World Wide Web and Its Evolution, Architecture of Web, Uniform Resource Locator(URL), Browsers: Internet Explorer, Netscape Navigator, Opera, Firefox, Chrome, Mozilla; Search Engine, Web Servers; Apache, IIS, Proxy Server; HTTP Protocol, FTP protocol.
7. Contemporary Technologies : 13 hrs
Multimedia, e-Commerce, e Learning, e Governance, e-Banking, Hypermedia, Geographical Information System, Virtual Reality, Augmented Reality, Artificial Intelligence, Robotics, Bit Coin.
LABORATORY WORKS
Laboratory works should cover all the units and topics mentioned below and a project work should be carried out by students individually implementing the concept and skill learnt in this course.
UNIT 1 OPERATING SYSTEM [10 HRS.]
GUI Based OS (5 Hrs.): Interface, GUI vs. CUI, Introduction to Windows, Features, Elements of Windows, Task Bar, Using Menus and Submenus, Opening a Program, Opening Multiple Program, Using Short Cuts, Using My Computer, Switching off the System, Desktop and Custom Wall Papers, Screen Saver, Using Help for Interactive Learning.
Using General Accessories: Notepad, Paint Tool, Clip Board, Character Map, Calculator etc.; Using Multimedia: Using CD/DVD/BD, Using Audio/Video; Using Explorer to Manage Files and Folders: Copy/Delete/Rename/Short Cuts; Recycle Bin and It Uses. Using Format, Scandisk and Disk Defragmenter, Windows Installation and Setting.
CUI Based OS (5 Hrs.): Introduction to DOS, DOS Internal Commands, DOS External Commands.
UNIT 2 WORD PROCESSOR [12 HRS.]
Introduction to Word Processor, Features of Word Processor, Elements of Word Window, Creating & Saving Document, Copy Paste and Cut Paste, Format Painter, Undo and Redo, Print Preview, Printing Documents, Fonts, Effect and Character Formatting, Paragraph Formatting, Styles, Finding, Replacing and Selection, Cover Page, Blank Page, Page Break, Working with Table, Inserting Picture, Clip Art, Shapes,
Smart Art and ‘hart, Hyperlink, Bookmarks. Cross- Referencing, Header, Footer, Page Number, Working with Text Box, Quick Parts, Word Art, Drop Cap, Signature Line, Date & Time, Object. Equation, Symbol, Working with Themes, Page Margins, Page Orientation, Page Size, Columns Handling, Hyphenation, Watermark, Page Color, Page Borders, Indentation, Arranging Objects, Table of Contents, Footnote and Endnote,
Citation and Bibliography, Captions, Inserting Index, Table of Authorities, Mail Merge, Spelling and Grammar, Thesaurus, Translation, Word Count, Comments, Tracking, Changes, Compare, Protecting Document, Document Views, Ruler, Gridlines, Document Map, Thumbnails, Zooming, Window Handling, Creating and Using Macro.
UNIT 3 SPREADSHEET PACKAGE [12 HRS.]
Introduction to Spreadsheet Package, Features of Spreadsheet Package, Introduction to Microsoft Excel, Elements of Excel Window, Cell Referencing in Excel: Relative, Absolute, and Mixed; Managing Workbooks, Worksheets, Windows, Working with Worksheet, Printing Worksheet, Using Formulas/functions; Formatting/Conditional Formatting Data & worksheet; Using Paste Special, Essential Worksheet Functions,
Using Templates, Protecting the File and Worksheet with Passwords; Working with Graphic Objects: Clip Art, Word Art, Map; Working with Charts, Working with Internal Database, Getting More Power from Worksheet Databases, Accessing External Databases, Loan Amortization Scheduling and Calculation; Data Validation, Consolidating and Outlining, Using What- if Analysis: Data Table, Goal Seek, Scenario Manager; Understanding Pivot Tables, Constructing and Analyzing Pivot Tables, Using Custom Controls on Worksheets, Effectively Using the Macro Recorder
UNIT 4 PRESENTATION PACKAGE [6 HRS.]
Introduction, Creating and Saving Presentation; Entering, Editing, and Enhancing Text; Editing in different views- Outline View, Slide Sorter View; Creating Graphs, Editing and Enhancing Graphs; Adding ClipArt in Slide, Editing Arts, Animating Charts and Art Objects, Adding Sound, Choosing Sound Effects-Transitional, From Other Sources; Adding Sounds to Animations and Sound Objects; Recording Sound and Narration;
Adding Movie in Slides, Playing and Editing Movie; Making Movie Poster and Icon; Slide Show, Setting Slide Transition, Speed and Slide Advancement; Rehearsing Slide Display Timing, Slide Notes and Comments; Editing Text Color, Creating Custom Color; Background and Schemes; Linking and Embedding Objects; Importing and Exporting Presentation; Printing Slides and Handouts
UNIT 5 PHOTO EDITING PACKAGE 20 HRS.
FUNDAMENTALS
Graphics Basics: Bitmap Vs. Vector-Based Graphics, Color/Bit Depth and linage Resolution, Graphic File Formats, Optimizing Web Graphics, Regular Text. Vs. Anti- Aliased Text, Pixel Resize Vs. Smart Resize, Regular Graphics Vs. Interlaced Graphics, Lossy Compression Vs. Lossless Compression, Dithered Graphics Vs. Non-Dithered Graphics, Standard Selection Vs. Floating Selection, Tolerance, Opacity.
Introduction to Color: Color Modes- RGB, CMYK, Grayscale, LAB, Bitmap; Hue, Saturation, and Brightness; Browser Safe Colors; Shadows, Highlights and Midtones of an Image.
INTERFACE, TOOLS AND OPTIONS:
Environment: About Photoshop, The Photoshop Interface, setting up a new Photoshop document, saving a new document, The Default Palettes, working with Photoshop Palettes, The Photoshop Toolbox and Options bar, Using Guides and Ruler,
Image and Color Basics: Supported import and export image formats, Opening an Image in Photoshop, Creating Images in Photoshop, Saving Images in Photoshop, Basic Image Editing, Changing Image Size, Cropping an Image, Changing Color/Bit Depth, Optimizing Images using Save for Web, Working with Color in Photoshop
Tools: Parts of the Toolbox, Toolbox Shortcuts, Tools Options, Marquees, Magic wand, Lassos, move tool, Crop tool, Slice tools, Pencil, Paintbrush, Eraser tools, History brushes, Clone Tamp-Pattern stamp, Healing brush tool, Retouch tool, Gradient, Paint bucket. Burn-Dodge-Sponge, Blur-SharpenSmudge. Shapes-line- rectangle-polygon-custom shapes, Path selection tool, Pen tool, Type tools, Notes Tool-Audio annotation, Eyedropper-Color Sampler-Measure tool, Hand-Zoom, Quick Mask-Screen modes, Jump to Image Ready, Back ground and Foreground.
Transforms__: Using Free transform, Move, Rotate, Scale, Skew, Distort, Perspective, Flip-vertical, horizontal, Invert, rotate 180°, Rotate 90° CW, Rotate 90° CCW.
LAYERS, CHANNELS AND ACTIONS
Photoshop Layers: About Layers-Fill and Adjustment Layers, The Layer Palette, Naming Layers, Creating Layers, Deleting Layers, Viewing Layers, Moving Layers, Layer Opacity, Locking Layers, Merging Layers, Layer Modes and Blending Options, Image Composting Using Layers.
Photoshop Channels: About Channels, The Channel Palette, Creating and Viewing Channels, Modifying Channels, Deleting Channels, Alpha Channels and Masks
Actions: Using the Action. Palettes; Recording Action, Playing Action, Editing Action, Loading a Saved Action.
RESTORING AND ENHANCING IMAGES
Restoration of Photos: Restoring Damaged Photos, Photo Retouching.
Photo Enhancement and Color Correction: Changing Levels, Changing Curves, Color Balance, Changing Brightness and Contrast, Changing Hue Saturation and Brightness, changing a Grayscale Image to a Colored Image, Histogram, Gradient Map, Desaturate, Invert, Color Replace, Selective Color, Equalize, Threshold, Channel Mixer, Posterize, Changing Background using Layer Composting
TEXT EDITING AND SPECIAL EFFECTS
Text Editing in Photoshop: About the Type Layer, Creating Vertical and Horizontal Types, Point and Paragraph Text Creation, Using Horizontal and Vertical Type Mask Tools, Using Character Palette for Text Editing, Choosing a Font, Changing the Type Color, Choosing a Type Size, Specifying Kerning and Tracking, Using Fractional Character Widths, Specifying Baseline Shift, Applying Underline and Strikethrough, Text Alignment and Justification, Specifying Anti-Aliasing, Creating Text Warp, Rasterizing Type, Converting Ty–pe to Shapes, Adding Effects to Text
Photoshop Special Effects and Filters: About Special Effects, Using Filters, Basic Filter Examples, Artistic Filters, Distorting Filters, Filter Combinations, Plug-in Filters.
WEB APPLICATION AND ANIMATION
Adobe Image Ready: About Image Ready, Opening Image Ready, The Image Ready Interface, Image Maps, Image Slicing, Basic Animation.
Photoshop for Building Web Interface: About the Interface
TEACHING METHODS
The teaching faculties are expected to create environment where students can update and upgrade themselves with the current scenario of computing and information technology with the help of topics listed in the syllabus. The general teaching pedagogy that can he followed by teaching faculties for this course includes class lectures, group discussions, case studies, guest lectures, research work, project work, assignments (theoretical and practical), and written and verbal examinations.
Text and Reference Books
## Text Books
1. Alexis Leon, Mathews Leon, _“Fundamentals of Information Technology,2/e”,_ Vikas Publishing **I** louse Pvt Limited, 2009, ISBN: 9788182092457
2. E Balagurusamy, _“Fundamentals of Computers,”_ Tata McGraw Hill Education PVT.Ltd., 2009, ISBN: 9780070141605
3. Peter Norton’s, _“Introduction to Computers”, 7th_ Edition, Tata McGraw-Hill, 2010, ISBN: 9780070671201
## Reference Books
1. Brad Davlev & DaNae Davley, _“Adobe Photoshop CS6 Bible”,_ Wiley Publishing Inc., 2012, ISBN: 978-1-118-12388-1
2. Faiths Wempen, _“Microsoft Office Power Point 2007 Bible (With CD)”,_ Wiley Publishing Inc., 2007, ISBN: 978-0470043684
3. Herb Tyson, _“Microsoft Office Word 2007 Bible (With CD)”,_ Wiley Publishing Inc., 2007
4. Jim Boyce, “Windows 7 _Bible “,_ Wiley Publishing Inc., 2009, ISBN: 978- 0470509098
5. John Walkenbach, _“Microsoft Office Excel 2007 Bible (With CD)”,_ Wiley Publishing Inc., 2007, ISBN: 978-0470044032
6. Pradeep Sinha and Priti Sinha, _“Computer Fundamentals (with C.D)”,_ 6th Edition, BPB Publications, 2003, ISBN: 9788176567527
7. Ramesh Rimal & et. al., _“Computer Science-4 Revised Edition”,_ Buddha Academic Publishers and Distributors Pvt. Ltd. Nepal, 2013
8. Ramesh Rimal & et. al., _“Computer Science-H, Revised Edition”,_ Buddha Academic Publishers and Distributors Pvt. Ltd. Nepal, 2013