UNIT–I: Computer System Concepts, Application area, advantage & disadvantage, Components of a computer system - Control unit, ALU, Input/Output, Memory, Mother Board, Generations of computers, Configurations of Computer system, Types of PCs- Desktop, Laptop, Notebook, Palmtop, Supercomputers Characteristics and area of Uses, Primary Vs Secondary Memory, RAM, ROM, EPROM, PROM. Various Storage Devices- Hard Disk Drives, Zip Drive, Blue Ray Disc, Flash drives SD/MMC Memory cards, Solid-State Drive (SSD). UNIT–II: Input Devices: Keyboard, Mouse, Trackball, Joystick, Scanners, Digitizing tablet, Digital Camera, MICR, OCR, OMR, Light pen, Barcode & Barcode Reader, Quick Response Code (QR Code), Voice Recognition, Touch Screen. Output Devices: Monitors- Characteristics and types of Monitor, Size, Digital, Analog, Resolution, Refresh Rate, Interlaced/Non-Interlaced, Dot Pitch, Video Standard- VGA, SVGA, XGA etc. Printers and its Types Impact and Non-Impact printer, Dot Matrix, Inkjet, Laser, Plotter, 3D Printers, Sound Card and Speakers, UNIT–III: Software and its Need, Types of Software- System Software, Application Software, System Software- Operating System– definition & function, Device Drivers & Utility Programs, Introduction to DOS, Windows, Linux, Mac, Android Operating System. Introduction to Programming LanguagesMachine, Assembly, High Level, 4GL, Their Merits and Demerits, Introduction to Assemblers, Compilers and Interpreter. Introduction to Word Processing, Spreadsheet, Presentation Graphics, Data Base Management, Desktop Publishing, Graphics & Multimedia, Business Accounting, MIS, Gaming and ERP Software etc. Computer coding system-ASCII, ISCII and Unicode, Number system of computers- Binary, Octal, Decimal, Hexadecimal their conversion. UNIT–IV: Use of communication and IT, Communication Process, Component of communication– sender, receiver, Transmission Medium & Protocol, Communication types- Simplex, Half Duplex, Full Duplex. Communication Channels- Twisted, Coaxial, Fiber Optic, Modem-Working and characteristics. Types of network- client/server and peer-to-peer networks, Types of connectionsDialup, Leased Lines, ISDN, DSL, RF, Broad band uses, advantages & disadvantages. Types of Network- LAN, WAN, MAN, Internet, VPN etc., Topologies of LAN- Ring, Bus, Star, Mesh and Tree topologies- structure, uses, advantages & disadvantages. Components of LAN- Media, NIC, NOS, Network devices - Bridges, HUB, Routers, Repeater, Gateways uses, advantages & disadvantages. UNIT–V: Introduction to AI, History, Definition, and Applications of AI, Types of AI, Definition, Scope, and Goals of AI, History and Evolution of Artificial Intelligence, Advantages and Limitations of AI. Exploring AI-powered devices (e.g., smart assistants, image recognition tools). Introduction to Machine Learning and its Relationship with AI. AI in the Internet World: Search Optimization, Chatbots, Recommender Systems, Virtual Assistants, Modern AI Applications: Chatbots, SelfDriving Cars, Voice Assistants. Overview of (Microsoft Copilot, Windows AI). Reference Books:  Fundamentals of Computers, Paperback by Reema Thareja, Oxford University Press.  Computer Fundamentals- 6th Edition by Pradeep K. Sinha, Priti Sinha, BPB Publications.  Computers Today, A. Ravichandran, Khanna Book Publishing. DCA Syllabus-2026 ____________________________________________________________________________________________ ____________________________________________________________________________________________ Department of Computer Science and Applications, MCU, Bhopal 6  Handbook of Computer Fundamentals by Nasib Singh Gill, Khanna Publishers.  https://cbseacademic.nic.in/web_material/Curriculum25/publication/srsec/843_AI_Studen t_HandbookXI.pdf DCA Syllabus-2026 ____________________________________________________________________________________________ ____________________________________________________________________________________________ Department of Computer Science and Applications, MCU, Bhopal 7 SEMESTER-I 1DCA2 – PC Packages and AI Office Tools Detail Syllabus: UNIT–I: Operating System (Windows): Overview of Windows Operating System, Basic OperationsHow to Start a computer, login, logoff, hibernate, shutdown. Personalizing Desktop-Desktop Background, Screen Saver, Themes, Setting date & time, Task bar, Files & Folders, Create, Copy, Rename, Moving & Delete Files & Folders, Create & Using Shortcuts, Recycle Bin. Accessories-MS Paint, Notepad, WordPad, Windows Media Player, Calculator, Games, Math Input Panel, Language Settings-How to set other languages on computer Using Control Panel to add, remove or configuring new or existing devices, software programs and fonts, Enhance the performance of computer- using Disk Clean-up, using Disk Defragmenter. Using Internet in Windows: Basic Operations using Internet Browser-Working with browsers, Know about WWW, URL, Search Engines,Google Maps, Online Ticket Booking, Apply for PAN Card/Passport /Aadhar Card online, Pay electricity bill and Service tax online, Downloading eBooks. Introduction to AI and its relevance in daily computing tasks, Overview of AI Productivity Tools (ChatGPT, Copilot, Gemini, Notion AI) UNIT–II: Modern office activities and their software requirements, Introduction to Office Automation Suit, Elements of office suit & area of use. Word-processing, Spreadsheet, Presentation graphics, Database, Introduction and comparison of various office suites like Apache OpenOffice, Libre Office, WPS office, Google Docs & Microsoft office. MS Word Basics: Introduction to MS Office(2013), Introduction to MS Word, Features & Area of use. Various versions of MS Office and their requirements, Working with MS Word, Menus & Commands, Ribbon, Toolbars & Buttons, Shortcut Menus, Wizards & Templates, Creating a New Document, Different Page Views and layouts, Applying various Text Enhancements- Fonts, Styles, Text Attributes, Formatting Your Text and Documents: Auto format, Paragraph and Page Formatting, Line spacing, Margins, Borders and Shading, Tabs and Indents, Text Editing using various features, Bullets, Numbering, Working with Styles, Printing & various print options, Spell Check Working with Headers and Footers. Tables: Creating a simple table, Creating a table using the Table Menu, Entering and editing text in a table, selecting in table, adding rows, changing row heights, Deleting rows, Inserting columns, Deleting columns, changing column width, conversion to and from text. Introduction to Google Docs, Smart Compose, AI Summarizer. UNIT–III: Graphics in MS-word: Importing graphics, Clipart, insert picture, Using Clip Art, Shapes and SmartArt in documents, using drawing features, drawing objects, text in drawing. Taking and inserting Screenshots in Documents, Using WordArt and Drop Cap features in documents. Templates: Template types, using templates, exploring templates, modifying templates. Mail Merge in MS Word, Mail Merge concept, Envelops & Mailing Labels, Importing and exporting to and from various formats, Macros in MS Word: Macro introduction and their use, recording macros, editing macros, running a macro. Creating Professional Reports with AI-generated Templates, Using AI tools for grammar checking and content suggestions, DCA Syllabus-2026 ____________________________________________________________________________________________ ____________________________________________________________________________________________ Department of Computer Science and Applications, MCU, Bhopal 8 UNIT–IV: MS Excel Spreadsheet Basics & features, concepts of Workbook & Worksheets, Getting started, Creating a new worksheet, Using Wizards, Various Data Types, Selecting cells, Entering and editing text, Entering and editing Numbers, Removing & Resizing of Columns & Rows, entering and editing Formulas, Referencing cells, moving cells, copying cells, sorting cell data, inserting rows, inserting columns, Inserting cells, Deleting parts of a worksheet, clearing parts of a worksheet, Different Views of Worksheets. Formatting: Cell Formatting, changing column widths and Row heights, auto format, changing font sizes and Attributes, centering text across columns, using border buttons and Commands, changing colors and shading, hiding rows and columns, Working with Data & Ranges, Column Freezing, Labels, Hiding, Splitting, merging etc. Charts in Excel: Chart parts and terminology, chart wizard, different types of charts, printing charts, deleting charts, Overview of AI-powered features in Windows (e.g., Copilot) Using AI in Excel: Data Insights, Trend Prediction, Using AI features like “Analyze Data” and ChatGPT for formula generation. UNIT–V: MS PowerPoint: Introduction & area of use, Working with MS PowerPoint, Creating a New Presentation, Working with Presentation, Using Wizards; Slides & its different views, Inserting, Deleting and Copying of Slides; Working with Notes, Handouts, Columns & Lists, Adding Graphics, shapes, screenshots, Smart Art and charts in presentation, Sounds and Movies to a Slide; Working with PowerPoint Objects, Designing & Presentation of a Slide Show, change Slide backgrounds, Change Slide Size, Using Animation and Transitions in presentation, Advanced Slide optionsManual & Automatic, Printing Presentations, Notes, Handouts with print options, Slide Master, Handout Master and Notes Master. AI Tools for Presentation Creation (Beautiful.ai, Tome, Canva AI), Generate an AI-based presentation using online tools Books and References:  Windows 8.1 In Depth, by Knittel, PEARSON  Windows 8.1 Plain and Simple by Joli Ballew, Nancy Muir, PHI  MCSA Microsoft Windows 8.1 Complete Study Guide: Exams 70-687, 70-688, Jeffrey R. Shapiro, Darril Gibson, Wiley India  Windows 8.1 For Dummies By Andy Rathbone, Wiley India  Office 2013 in Simple Steps, Kogent Learning Solutions Inc., Wiley India  Microsoft Office:2013 Edition Inside Out, Bott Ed, Siechert, Carl, Prentice Hall Of India (PHI)  Learning Microsoft Office 2013, Paperback by Ramesh Bangia, Khanna Book Publishing  Microsoft Office 2013 : Digital Classroom, Paperback by Walter Holland, ACI Creative Team, WILEY  Microsoft Learn Portal: AI Features in Microsoft 365  https://cbseacademic.nic.in/web_material/Curriculum25/publication/srsec/843_AI_Studen t_HandbookXI.pdf Practical Questions: Q. Load Microsoft Word & type the following text and do the following tasks: Television How does television affect our lives? It can be very helpful to people who carefully choose the shows that they watch. Television can increase our knowledge of the outside world, there are high quality DCA Syllabus-2026 ____________________________________________________________________________________________ ____________________________________________________________________________________________ Department of Computer Science and Applications, MCU, Bhopal 9 programmers that helps us to understand many fields of study, science, medicine, the arts and so on. Moreover, television benefits very old people, who can't often leave the house as well as patients in hospitals. It also offers non native speakers the advantage of daily informal language practice. They can increase their vocabulary and practice listening. On the other hand, there are several serious disadvantages of television. Of course, it provides us with a pleasant way to relax and spend our free time, but in some countries, people watch the 'blood tube' for an average of six hours or more a day. Many children stare at a television screen for more hours each day than they do anything else including studying & sleeping. It's clear that the tube has a powerful influence on their lives and that its influence if often negative. 1. Save your work as “Television” on Desktop. 2. Set the heading : Font Times New Roman Size 18, align Centre & Bold, 3. Set the remaining text with font Calibri & size 12 4. Underline the heading & change all letters to uppercase 5. Run the spell checker. 6. Apply indentation to the first line of the second paragraph 7. Change the line spacing of the paragraphs to 1.5. 8. Replace the word “screen” with monitor. 9. Apply a 6pt width page border to the document 10.Change the Page orientation to Landscape Q. Type the given text in similar format using list in the word: 1. Select the first, then hold CTRL whilst selecting the rest  Right click on them  Double click on them  Use the TAB button 2. How do you get capital letters using just one finger?  Use the SHIFT LOCK key  Use the TAB key  Use the ESCAPE key  Use the CTRL key 3. What is the short cut for copying data to the clipboard?  CTRL + C  CTRL + X  CTRL + Z  CTRL + V