B.A. (CA) / B Com (CA) / B.Sc. (CA)
Domain Subject: Commerce
Semester-wise Syllabus under CBCS(w.e.f. 2020-21 Admitted Batch)
I Year B Com (CA), Semester- I
Discipline: COMPUTER APPLICATIONS
COURSE 1C:INFORMATION TECHNOLOGY
Model Outcomes:
At the end of the course, the students is expected to DEMONSTRATE the following cognitive abilities (thinking skill) and psychomotor skills.
- Remembers and states in a systematic way (Knowledge)
- Describe the fundamental hardware components that make up a computer’s hardware and the role of each of these components
- understand the difference between an operating system and an application program, and what each is used for in a computer
- Use technology ethically, safely, securely, and legally
- Use systems development, word-processing, spreadsheet, and presentation software to solve basic information systems problems
- Explains (Understanding)
- Apply standard statistical inference procedures to draw conclusions from data
- Retrieve information and create reports from databases
- Interpret, produce, and present work-related documents and information effectively and accurately
- Critically examines, using data and figures (Analysis and Evaluation**)
- Analyze compression techniques and file formats to determine effective ways of securing, managing, and transferring data
- Identify and analyze user needs and to take them into account in the selection, creation, integration, evaluation, and administration of computing based
- Analyze a complex computing problem and to apply principles of computing and other relevant disciplines to identify
- Identify and analyze computer hardware, software
- Working in ‘Outside Syllabus Area’ under a Co-curricular Activity(Creativity)
Design, implement, and evaluate a computing-based solution to meet a given set of computing requirements in the context of the program’s discipline.
- Efficiently learn and use Microsoft Office
SYLLABUS
COURSE 1C : INFORMATION TECHNOLOGY
(Five units with each unit having 12 hours of class work)
Unit -I Introduction:
Computer Definition – Characteristics and Limitations of Computer, Generations of Computer, Classification of Computers, Applications of Computer, Hardware — Basic organization of Computer – Input and Output Devices
Unit- II Memories:
primary, secondary and cache memory, Software: types of software, system software, Application software, commercial software, open source software, domain software and free ware software, Programming Languages: Introduction to Programming Languages – Generations of Programming Languages
Unit- III MS word:
Features of MS Word – Parts of Word Window – Creating, Saving, Opening document, Printing, Formatting: Formatting of Text and Paragraph – Bullets and Numbering – Editing – Moving and Copying – Find and Replace Text –Tables: Creating tables, inserting and deleting rows and columns, Insertion of pictures – Insertion of clipart – Mail Merge
Unit-IV MS Excel:
Features of Excel, Parts of Excel window, Workbooks, Creating, Opening and Saving a Workbook, Worksheets, rows, columns, Inserting and Deleting rows and columns, cells, Entering labels, values, and formulas in worksheet, Formatting: Adjusting row height and column width – Formatting cell values, Formulas and Functions: operators used in formula, cell references in formula, Mathematical, Statistical, Logical and Text functions, Charts: Different types of charts, Creating a chart
Unit-V MS Power point:
Features of PowerPoint, Parts of PowerPoint window, creating, saving and opening presentation, working with slides: Inserting, deleting, copying slides, editing text, formatting text, Formatting and Modifying Presentations: Applying transition and animation to the slides, inserting music or sound on a slide, viewing slide show
Learning Resources (Course 1C:Information Technology)
References:
- Mohan computer fundamentals- HimalayaPublications.
- K.Sharma and Shashi K Gupta, Computer Fundamentals – Kalyani Publications
- Fundamentals of Computers ByBalagurusamy, Mcgraw Hill
- Fundamentals of Computers Rajaraman V Adabala N
- MS-Office S. Shrivastava
- Microsoft Office 2007 Fundamentals, 1st Edition By Laura Story, Dawna Walls
Online Resources:
https://support.office.com/en-us/office-training-center https://www.skillshare.com/browse/microsoft-office https://www.tutorialspoint.com/computer_fundamentals/index.htm https://www.javatpoint.com/computer-fundamentalstutorial https://edu.gcfglobal.org/en/subjects/office/
https://www.microsoft.com/en-us/learning/training.aspx
Practical Component: @ 2 hours/week/batch
- MS word creation of documents letters invitations etc,
- Create tables in MS-WORD
- Perform mail merge using MS Word
- MS Excel performing different formulas
- creating charts in Excel
- create presentation in power point
- inserting, deleting slides in Power Point
- Illustrate Animation in presentation
RECOMMENDED CO-CURRICULAR ACTIVITIES:
(Co-curricular activities shall not promote copying from textbook or from others work and shall encourage self/independent and group learning)
Measurable
- Assignments (in writing and doing forms on the aspects of syllabus content and outside the syllabus content. Shall be individual and challenging)
- Student seminars (on topics of the syllabus and related aspects (individual activity)
- Quiz (on topics where the content can be compiled by smaller aspects and data (Individuals or groups as teams))
- Field studies (individual observations and recordings as per syllabus content and related areas (Individual or team activity)
- Study projects (by very small groups of students on selected local real-time problems pertaining to syllabus or related areas. The individual participation and contribution of students shall be ensured (team activity))
General
- Group Discussion
- Visit to Software Technology parks / industries
RECOMMENDED CONTINUOUS ASSESSMENT METHODS:
Some of the following suggested assessment methodologies could be adopted;
- The oral and written examinations (Scheduled and surprise tests),
- Closed-book and open-book tests,
- Coding exercises,
- Practical assignments and laboratory reports,
- Observation of practical skills,
- Individual and group project reports,
- Efficient delivery using seminar presentations,
- Viva voce
- Computerized adaptive testing, literature surveys and evaluations,
- Peers and self-assessment, outputs form individual and collaborative work