Course Objectives:
The course will enable the students to
1. Familiar with MS-DOS: basic external and internal commands.
2. Use productivity software like Word, Excel, Power Point and Access.
3. Use of Google Drive to save, store,share and access files and folders from anywhere.
Course | Learning Outcome (at course level) | Learning and teachingstrategies | Assessment Strategies | |
Course Code | Course Title | |||
25CBCA 102 |
ICT Lab (Practical) | CO7. Create well formatted documents using various features of word processor tool. CO8. Design spreadsheets, apply basic functions and charts to analyse data. CO9. Create visually appealing slides to effectively communicate information and ideas. CO10. Execute commands and navigate the file system using the internal commands of MS-DOS, enabling efficient interaction with the operating system. CO11. Apply the concepts of storing and accessing files and folders on the cloud and demonstrate the ability to work on google drive. CO12. Contribute effectively in course-specific interaction. | Approach in teaching: Interactive Lectures, Discussion, Demonstration, Learning activities for the students: Self-learning assignments, Practical questions | Class test, Semester end examinations, Quiz, Presentation, Individual and group Assignments |
• MS-DOS: Overview, Internal Commands (DIR, CD, MD, RD, COPY, COPY CON, DEL, REN, DATE, TIME, VER, CLS, TYPE, PROMPT, PATH) and External Commands (TREE, DELTREE, EDIT).
• Word Processor: Features of Word processors, Shortcut keys, formatting documents: Selecting text, Copying & moving data, formatting characters, changing cases, Paragraph formatting, Indents, Drop Caps, using format painter, Page formatting, Header & footer, Bullets & numbering, Tabs, Creating tables styles and templates. Finding & replacing text, GoTo (F5) command, Text Proofing features, Macros, Inserting pictures, Hyperlinks, Mail merge, Printing.
• Spreadsheet Software: workbooks and worksheets, working with single and multiple workbook cell entries (numbers, labels, and formulas), Filling seriesfill with drag, data sort, formatting worksheet, cell referencing (Relative, Absolute, Mixed).
• Some useful Functions in excel: If Function, Date & Time: DATE, DAY, MINUTE, HOUR, NOW, SECOND. Statistical: AVERAGE, COUNT, MAX, MIN. Text: CHAR, CONCATENATE, EXACT, LEFT, LEN, LOWER, MID, REPLACE, RIGHT, SEARCH, TEXT, TRIM, UPPER. Math & Trig: CEILING, FACT, FLOOR, INT, ROUND, S QRT, SUM.
• Introduction to charts: types of charts, creation of chart from adjacent data/ nonadjacent data, formatting charts. Printing worksheets, OLE (importing & exporting data), Hyper linking, data sort and filters, Macros.
• Introduction to Presentation Software: Presentation tips, components of slide, slide templates, master slide, header and footer, images and auto shapes, presentation views, transition and animations, inserting audio, video, action buttons and hyperlinks, rehearse timings, printing slides.
• Use of Google Drive to save, store, share and access files and folders, Google Docs, Sheets.
1. Norton Peter, “Introduction to Computers”, 7th Edition. TMH, 2017.
2. P. K. Sinha & Priti Sinha, “Computer Fundamentals”, 6th Edition, BPB Publications, 2017.
3. M.L.Young, “Internet Complete Reference”, 2nd Edition”, TMH Publishing Co. Ltd, 2002.
SUGGESTED READINGS:
1. J. Simon, “Excel Data Analysis: Your Visual Blueprint for Creating and Analyzing Data, Charts and PivotTables”, Wiley, 3rd Edition 2011.
2. Cloud Computing: Concepts, Technology & Architecture,” Pearson Education India; 1st edition ,1 January 2014.
3. V. Rajaraman, “Fundamentals of Computers”, 6th Edition, Prentice Hall India Pvt. Limited, 2015.
4. Bob Boiko,” Content Management Bible (2nd Edition)”, 2nd Edition, Wiley; November 26, 2004.
5. Bing Liu,” Web Data Mining”, 2nd Edition, Springer, July 2011.
JOURNALS:
1. https://journal-bcs.springeropen.com/
2. https://jisajournal.springeropen.com/
3. https://www.sciencedirect.com/journal/thinking-skills-and-creativity [2]
e -RESOURCES:
1. https://home.csulb.edu/~murdock/dosindex.html
2. https://support.microsoft.com/en-us/office/basic-tasks-for-creating-a-powerpoint- presentationefbbc1cd-c5f1-4264-b48e-c8a7b0334e36
3. https://www.excel-easy.com/ [3]
4. https://support.microsoft.com/en-us/office/Analyse-data-in-excel-3223aab8-f543- 4fda-85ed76bb0295ffc4
5. https://edu.gcfglobal.org/en/googledriveanddocs/
6. https://support.google.com/a/users/answer/9282958?hl=en
Links:
[1] https://csit.iisuniv.ac.in/courses/subjects/ict-lab-8
[2] http://www.sciencedirect.com/journal/thinking-skills-and-creativity
[3] http://www.excel-easy.com/
[4] https://csit.iisuniv.ac.in/academic-year/2025-26