ICT Lab

Paper Code: 
24CBCA102
Credits: 
03
Periods/week: 
06
Max. Marks: 
100.00
Objective: 

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 teaching strategies

Assessment Strategies

Course

Code

Course

Title

24CBCA

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 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.  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: 
2024-25
  • Printer-friendly version