Course Outcomes (COs):
Learning outcome (at course level) |
Learning and teaching strategies |
Assessment Strategies |
---|---|---|
On completion of this course, the students will be able to; CO 105:Create well formatted documents using various features of word processor tool CO 106:Design spreadsheets; apply basic functions to analyze data. CO 107:Infer the features of presentation software and design effective presentation. CO 108:Creating tables, forms, queries and reports using MS-Access CO 109:Apply the concepts of storing and accessing files and folders on the cloud and demonstrate the ability to work on Google drive. |
Class lectures Tutorials Group discussions and Workshops Question preparation |
Quiz, Poster Presentations, Semester End Examination |
• Introduction to word processing: Working with formatted documents, Shortcut keys. Finding & replacing text, Go To command. Selecting text, changing cases,
• Paragraph and page formatting. Header & footer, proofing text, inserting pictures, Mail merging.
• Spread sheets: Creating a Table, formatting of table, auto fill series, Basic Functions (SUM, AVERAGE, COUNT, MAX, MIN), Sorting and filtering, Cell referencing, Importing external data, basic charts (bar, column charts)
• Data management using MS-ACESS (creating tables, forms, queries and reports), importing and exporting data.
• Presentation Software: using templates and wizards, creating presentation using blank presentation, Adding objects and action buttons. Various presentation views,
• Working in slide sorter view, adding transition and animations to slide show, printing slides, adding master-slide.
• Cloud based Office Tools (Google drive, Google docs, Google sheets, Google slides. Sharing and creating files, uploading and downloading files and folders. Creating and designing forms using Google forms.
• Introduction to office365 and its applications)
• Mastering Word 2000 – Mansfield &Olsen
• Mastering Excel 2000 – Martin, Hansen, Klingher& Beth
• Mastering Power Point 2000 – Murray
• Dr. Leena Bhatia & Dr. Bindu Jain, Elementary Computer Application
• ShubhiLall, Elementary Computer Application
• Mastering DOS – Robbins
• Mastering Windows 98 – Robert & Cowart
E-RESOURCES:
• https://www.excel-easy.com/
• https://support.microsoft.com/
• https://www.tutorialspoint.com/
JOURNALS:
• https://journal-bcs.springeropen.com/
• https://jisajournal.springeropen.com/