ICT Lab

Paper Code: 
25CBCA102
Credits: 
03
Periods/week: 
06
Max. Marks: 
90.00
Objective: 

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 Outcomes: 

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

 

Unit I: 

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 series fill 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, SQRT, 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.

 

ESSENTIAL READINGS: 

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.

 

REFERENCES: 

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

 

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/

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

 

Academic Year: 
2025-26
  • Printer-friendly version