Coming soon
Computers Applications (Practical)
This course will enable students to understand basic microeconomic concepts, learn methods to draw accurate conclusions and solve economic problems, and comprehend how society allocates its total resources among various uses.
|
Courses |
Course outcomes (at course level) |
Learning and teaching strategies |
Assessment Strategies |
|
|---|---|---|---|---|
|
Course Code |
Course Title |
|||
|
24FSD124 |
Computers Applications (Practical) |
CO19 Analyze the use of excel sheet and automation tools in daily work. CO20 Design Power point Presentation using tools and enhance presentation skills. CO21 Explain the advantage of collaborative word document. CO 22 Compile comprehensive practical record and submission related to garment making CO 23 Cultivate verbal communication skills to converse effectively with examiners. CO 24 Contribute effectively in course-specific interaction |
Approach in teaching: Interactive Lectures and Power point presentation Class discussions with projected pictures depicting variety of Clothing styles
Learning Activities for the students: Self-learning assignments, Effective questions and presentation |
Assessment task will include Class test, Semester end examinations, Quiz, Solving problems in tutorials, Assignments, Presentation |
I: Introduction to Computers (6 Hours)
- 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 Hours)
- Windows explorer; Control panel, Setting wallpaper, screen saver, background. Creating a folder, Compressing/ Zipping files (WinZip), Virus & Antivirus.
III: Microsoft Word (20 Hours)
- 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 Hours)
- 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 Hours)
- Introduction, uses & features of Microsoft Power point, 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 colour 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 Hours)
- 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.
- 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.
Suggested Readings:
- 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:
1. https://cag.gov.in/uploads/media/introduction-to-computers-by-peter-norton-6th-ed-20210326115622.pdf
2. https://ptgmedia.pearsoncmg.com/images/9780735699236/samplepages/9780735699236.pdf
3. https://www.computer-pdf.com/office/
Reference Journals:
1. https://www.researchgate.net/
2. https://www.sciencedirect.com/topics/engineering/central-processing-unit
3. Journal of the Brazilian Computer Society, SpringerOpen
4. Journal of Internet Services and Applications, SpringerOpen
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 |
