GE Curriculum 2024-2028 PDF

Mon, Wed Tluy fal FOUR YEARUNDERGRADUATE PROGRAM (2024-28) DEPARTMENT OF COMPUTER APPLICATION CoURSE CURRICULUM PART- A: lntroduction Program: Barhelor in Computer App...

Mon, Wed Tluy fal FOUR YEARUNDERGRADUATE PROGRAM (2024-28) DEPARTMENT OF COMPUTER APPLICATION CoURSE CURRICULUM PART- A: lntroduction Program: Barhelor in Computer Applicalion Semesler-| Sessiop: 202 -2025 (Certificate /Diploma /DegreelHonors) Course Code CAGE-01T 2 Course Title Computer Fundamental and MS office Course Type DGE(Discipline Generic Electivc) Prercquisife |Asper progranm Afler Completing this course, students will be able to: Study and use of busic concepts and terminology of information technology. Organizc filcs and documents on storage devices. Course Learning Acquire knowledge of ICT and Internet applications. Qutcomes (CLO) Develop information technology solutions by evaluating user requirements: in advance trends of IT Acquire knowledge of MS-Excel, MS-PowerPoint and MS-Access. 6 i Credit \'alue 3 Credits Credit= 15 Hours - Learning & Observation 7 Total Marks Max. Marks: 100 Min Passing Marlks: 40 PART -B: Content of the Course Total No. of Teaching-Learning Periods (01 Hr. per period) 45 Periods (45 Hours) No. of Unit Topies (Course contents) Period Introduction to Computer: History of computer, Generations and Classification, Basic Analomy of Conputer: Block Diagram, Contral Processing Unit (CPU): Function of cach Unit, Memory: Primary, Cache, Flaslh, Soflware and its neecds, Types of S/W: Systcm Software and Applicalion Software, Types of Programming Language: Machine Language, Assembly Language, High Lovel Language their advantages and disadvantages, Language Processors/Translators: Assembler, Interpreter and Compiler, Fundamental of Information Technology: Data and Information, Concept of IT, 12 Application of lT, What is lCT?, Components of ICT, Impact of ICT in Society. Advanced Trends in T: Cloud Technology, Virtual LAN Technology, M-Comimerce, I Nanotechnology. Virtual Reality, 3-D Printing, Internet of Things (loT), Artificial Intelligence (Al). Machine Learning (ML), Cloud Computing, Quantum Computing, G Suite, Gol digital initiatives in higher education: SWAYAM,Swayam Prabha, National Academic Depository, National Digital Library of India, E-Sodh-Sindhu, Virtual labs, e-Yantra and NPTEL. MS-Word: Introduction to word processing software and its features, Creating new cdocument, Saving documents, Opening and Printing documents. Home Tab: Seting fonts, Paragraph settings, Various styles (Normal, No spacing, Headingl, Heading2, Titlc, Strong), Find & Replace, Format painter. Copy paste and paste Footer, Word specal. Insert Tab: Pages. Tables, Pictures, Clipart, Shapes, Header & ! Art. Equution and Symbols. Page Layout Tab: Page setup, Page Background, Paragraph Review ! Mail Merge. (indent and spacing). Mailing Tab: Create Envelops and Labels,document, View Tab: Tab: Snelling and Grammar check, New comiment, Protect Document views, Zoom, Window (New window, Split, Switch window). III MS-Excel: Introducing Exccl, Use of Excel sheet, creating new sheet, Saving, Opening, and and Printing workbook. Home Tab: Font, Alignment, Number, Styles and cells Table, Charts (column chart, Pie chart, Bar cliting, Condiional Formatting. Inscrt Tab: chart, Line chart) and Texts (hcader & footer, word art, signature linc). Page Layout Tab: 1a  scale). Formulas Tab: Auto sum (sum, Page setup options, Scale to fit (width, height,true, false), Math & Trig (sin, cos, tan, average, min, max), Logical (F, and, or, not, options, Data validation, Group and ceiling, floor, fact, mod, log), Sort and Filter workbook, and Share workbook. View Tab: ungroup. Review'Tab: Protect shect, Protect Split and hide. Pagebreaks, Page layout, Frcczing Panes, IV Working with PowerPoint and MS-Access presentation, Creating new PowerPoint: Introducing PowerPoint, Use of PowerPoint Layout, Reset, Delete, New slide, slides saving, Opening and printing. Home Tab: art, Drawing options. Insert Tab: Setting text direction, Align text, Convert to Smart chart, Movie and sound, Table, Picture, Clipart, Photo album, Smart art, Shapes and Hyperlink and action, Text box, Word art, Object. Design Tab: Page setup options, Slide style and formatting it. orientation, Applying various themes, Selecting backgroundemphasis, Applying slide Animations Tab: Custom animation for entrance, Exit and rehearse timing. Slideshow transition, Setting transition speed and sound, Animation on options. View tab: Presentation views, & View Tab: Start slide, Show options, and. Setup Colors and Window option. creating blank databases, MS-Access: Introduction to DBMS, features of DBMS, Crèating tables, creating Saving it in accdb format, Defining data type in MS Access, reports, query wizard. Technology (1CT), G-Suite, MS Word. Information Technology (IT), Information and Communication Keywords MS Excel, MS Power Point, MS-Açcess. Wamehd Signutyreof Convener& Members of CBoS: (gual Chelrwan PART-G: Learning Resources |Text Books. Reterence Books and Others Text Bovks Recomnended: Edition. Computer Fundanmentals, P.K. Sinha, BPB Publication, Sixth Fundamentals of lnformation Technology, Chetan Shrivastava, Kalyan Publishers. Fundamentals of Computers, V. Rajaraman, PHISixth Edition. Iterative International Computer Fundamentals and Office Automation, Dr. Santosh Kumar Miri, Publisher IIP. Age International Computer Fundamentals Architecture and Organization, B. Ram, New Publishers, Fifth Edition. Publication. Fundamentals of Information Technology, Alexis Leon and Mathews Leon, Vikash Reference Books Recommended: Introductionto Information Technology, V. Rajaraman, PHÈ publication. Fundamental of IT, Leon and Leon, Leon Tec world. Introduction to Information Technology, Aksoy and Denardis, Cengage learning. Computers Today, Suresh K. Basandra, Galgotia Publications. and Information Technology - The breaking wave, Dennis P.Curtin, Kim Foley, Kunai Sen Cathleen Morin, TMH. OFFICE 2013 in Simple Steps, Kogent Solution Inc., DremTech Press. Access 20 10 in Simple Steps by Kogent Learning Solutions ne.