Coming soon
Computers Applications (Practical)
This course will enable the students to -
- To expose students to basic microeconomic concepts.
- To provide a method/ approach to help draw correct conclusions/ solve economic problems.
- To understand, explain and quantify the mechanism by which the total amount of resources possessed by society is allocated among alternative uses.
Course Outcomes (COs):
|
Courses |
Learning outcomes (at course level) |
Learning and teaching Strategies |
Assessment Strategies |
|
|---|---|---|---|---|
|
Course Code |
Course Title |
|||
|
FSD 124 |
Computers Applications (Practical) |
The students will be able to – CO19 Explain the fundamental concepts of computers. CO20 Analyse the use of office automation tools in daily work. CO21Create effective and well formatted documents. CO22 Design presentation using presentation tools and enhance presentation skills CO23 Explain the advantage of collaborative documents CO24 Apply internet knowledge for exploring research in the area of fashion & textiles
|
Approach in teaching : Interactive Lectures, Group Discussions, Power point presentations, Video Tutorials Learning Activities for the students: Self- learning assignments, Practice case studies and worksheets in Ms Word, Ms Excel and MS PowerPoint. |
Assessment task will include Class test, Semester end examinations, Student’s presentations and assignments. |
CONTENTS
I: Introduction to Computers 6 hrs
- Introduction to Computers (definition, characteristics & uses), Evolution of computers, System unit (memory, ALU & control unit), Input / Output devices, Storage devices (Memory- primary & secondary).
- Introduction to Software, its type (system, application & utility); Programming languages (machine, assembly & high-level), Language processors (assembler, compiler & interpreter), Generation of computers.
- Scanning of documents and pictures
II: Windows 6 hrs
- Windows explorer; Control panel, Setting wallpaper, screen saver, background. Creating a folder, Compressing/ Zipping files (WinZip), Virus & Antivirus.
III: Microsoft Word 20 hrs
- Introduction to Word Processor, Features & Shortcut keys of Word processors, Working with Documents, Editing Documents in Word, Formatting Documents, Formatting Paragraphs, Formatting Page Reference Concept
- Inserting pictures, Hyperlinks & Clip Art, Understanding & creating Tables and Lists, Using Header and Footers Styles, Proofing text (Spell check, Auto correct), Mail Merge, Using Templates, Managing page formatting tools.
IV: Microsoft Excel 24 hrs
- Introduction to Spreadsheets & workbooks, creating, saving, editing & formatting a workbook, Features & Shortcut keys of Microsoft Excel
- Filling series, fill with drag, data sort, cell referencing (Relative, Absolute, Mixed), What-if analysis Entering formula, Using Built-in Functions, Creation of List.
- Working with Graphs, Using Chart Wizard, Using Logical Functions, Use of Macros, PIVOT Table & Chart Generation
V: Microsoft PowerPoint 24 hrs
- Introduction, uses & features of Microsoft Powerpoint, Presentation tips, components of slide, using templates and wizards, choosing an auto layout, using outlines, adding subheadings, editing text, formatting text, using master slide. Adding slides, changing color scheme, changing background and shading, adding header and footer, adding clip arts and auto shapes.
- Various presentation, working in slide sorter view (deleting, duplicating, rearranging slides), adding transition and animations to slide show, inserting music or sound on a slide, inserting action buttons or hyperlinks for a presentation, set and rehearse slide timings, viewing slide show, Printing slides.
VI: Internet 10 hrs
- Internet Communication Protocols, Types of Internet Connections, ISPs, Domain Name System, Intranets, Email Concepts (receiving, sending, addressing, downloading, formatting, sending attachment).
- Sending & Receiving Secure Email, chatting, conferencing, Email mailing list, Newsgroup, IRC, ICQ, Video mail and Video Conferencing.
Examination Scheme
|
Continuous Assessment |
Distribution of Marks (Practical Record) |
Semester End Exam |
|||
|---|---|---|---|---|---|
|
Component |
Marks |
Component |
Marks |
Component |
Marks |
|
Practical Record |
20 |
Microsoft Word |
05 |
Submission |
20 |
|
Excel Sheet |
20 |
||||
|
Test |
05 |
Microsoft Excel |
10 |
Power point Presentation |
15 |
|
Attendance |
05 |
Microsoft Powerpoint |
05 |
Word Document |
10 |
|
Viva Voce |
05 |
||||
|
Total |
30 |
Total |
20 |
Total |
70 |
- Norton Peter, (2006), Introduction to Computers, (6th edition). TMH.
- Sinha, P. K. & Sinha, Priti, (2003), Foundations of Computing, (1st edition), BPB Publications.
- Ron Mansfield, R., Olsen,J. W.(1999) Mastering Word 2000
- Simon,J., (2000), Excel Data Analysis: Your Visual Blueprint for Creating and Analyzing Data, Charts and PivotTables, Wiley.
- Courter, Mastering Office 2000, BPB Publications.
- Bill Bruck, MS-Office 2000, TMH.
- Young,M.L., (2002).Internet Complete Reference, (2nd Edition), TMH Publishing Co. Ltd.
- Rajaraman,V., (2010), Fundamentals of Computers, (4th edition), Prentice Hall India Pvt. Limited.
- Content Development Group, Working with MS Office 2000, TMH.
- Mansfield & Olsen, Mastering Word 2000, BPB Publications.
- Martin, Hansen, Klingher& Beth, Mastering Excel 2000, BPB Publications.
- Murray, Mastering PowerPoint 2000, BPB Publications.
- Mahapatra& Sinha, Essentials of Information Technology, Dhanpat Rai Publishing.
- Leon, Alex &Leon, Mathews, (1999), Introduction to Computers, Vikas Publishing House.
E-Resources:
- https://cag.gov.in/uploads/media/introduction-to-computers-by-peter-norton-6th-ed-20210326115622.pdf
- https://ptgmedia.pearsoncmg.com/images/9780735699236/samplepages/9780735699236.pdf
- https://www.computer-pdf.com/office/
Journals:
- https://www.researchgate.net/
- https://www.sciencedirect.com/topics/engineering/central-processing-unit
- Journal of the Brazilian Computer Society, SpringerOpen
- Journal of Internet Services and Applications, SpringerOpen
