B.Sc. Computer Science - Allied Course I & II Office Automation Theory & Lab, Computer Organization

Aug 31, 2026

Upload by Miles

B.Sc. Computer Science allied syllabus covering Office Automation (Theory & Lab) and Computer Organization for the first academic year. Office Automation details Word fundamentals, document editing, formatting, page setup, tables, graphics, and mail merge, alongside Excel topics such as worksheet operations, formulas, cell editing, data alignment, and printing. Computer Organization addresses number systems and codes, digital logic, combinatorial and arithmetic circuits, CPU organization, instruction cycles, microprogrammed control, and I/O and memory organization, including CISC vs RISC and pipeline concepts.

LanguageEnglish

CategoryPaper Templates

FormatDOCX

Pages10

Reading Time4 min

AccessFree to download

I Year – I Semester

Allied Course - I: Office Automation (Theory & Lab)

Unit I

Unit II

Unit III

Unit IV

Unit V

I Year – II Semester

Allied Course - II: Computer Organization

Unit I

Unit II

Unit III

Unit IV

Unit V

I Year – I/II Semester

Allied Practical – I: Office Automation Lab (MS-Word)

B.Sc. COMPUTER SCIENCE I YEAR – I SEMESTER COURSE CODE: 7BCEA1 ALLIED COURSE - I – OFFICE AUTOMATION (THEORY& LAB) Unit I Word Introduction to Word Introduction to word processing – Advantages – Starting Word – Creating a Document – Saving the Document–Printing a Document–Resaving and closing a Document–Exiting word Editing a Document Opening a Document – Cursor Movement – Editing a Document – Selecting Text – Deleting Text – Replacing Text – Undoing and Redoing changes Move and Copy Text Moving text – Using copy to Repeat text – Cut and Paste – Quickly opening Recently used files – Copying Text to another file. Unit II Formatting Text and Paragraph Formatting Text – Using the Font Dialog Box – Using Bullets and Numbering. Finding and Replacing Text and Checking Spelling Moving to a specific page – Finding Text – Replace command – Checking Spelling and Grammar Enhancing a Document Page setup – Headers and Footers – Print Preview Unit III Tables Creating Tables – Formatting a Table Graphics Drawing Toolbar – Word Art – Inserting Graphics Mail Merge Mail Merge – Example of Mail Merge – Viewing and Printing Merged Letters Unit IV EXCEL Introduction to Electronic Worksheet – Advantages – Excel – Starting Excel – Excel Screen – Organisation of the Worksheet Area – Entering information in a worksheet – Entering numbers – Entering a Formula – Advantages of using a formula – Saving a work book. Editing cells and using commands and Functions Aligning Data in cells – Editing Data in a cell – Excel functions – Range – Using a range with sum– Resaving a workbook file – closing a workbook file – Exiting Excel. Unit V Moving and Copying, Inserting and Deleting Rows and Columns Opening an Existing workbook file – Moving Date – Copying Date to another Area – Filling up a cell – Copying a single cell to several cells – Using the mouse to copy Data – Undoing and Redoing actions – Inserting a Row in the worksheet – Inserting columns – Erasing part of a worksheet – Deleting Rows and Columns. Printing the workbook Printing the workbook – Using Print Preview – Setting Up Print Area – Using Math functions. Power Point Introduction – Creating a Presentation – PowerPoint views – Running a Slide Show – Printing a Presentation. Access Starting Access – Menus And Toolbars – Viewing Data – Sorting and Filtering Records – Creating and Printing Reports. Text Book 1) “PC SOFTWARE for Windows 98 Made Simple”, 2006, R.K.Taxali, TATA McGraw Hill Publishing Company Limited, New Delhi. UNIT I Chapters – 9, 10, 11 UNIT II Chapters – 12.1, 12.2, 12.4, 13.1 – 13.4, 15.1, 15.6, 15.7 UNIT III Chapters – 16.1, 16.2, 17.1 – 17.3, 18.1 – 18.3 UNIT IV Chapters – 20, 21, 22.1 – 22.5, 22.10, 22.11, 22.13 UNIT V Chapters – 23, 25.1 – 25.3, 28.5, Annexures – B 2) “Introduction to Computers with MS-Office 2000” 2001, Alexis Leno & Mathews Leon, TATA McGraw Hill Publishing Company Limited, New Delhi. Unit V Chapters – 18, 19 Book for Reference: 1) “Microsoft Office”, Gordon Padwick, Sue Plumley, Debbie walkowski, Prentice Hall of India Private Limited, New Delhi. ♣♣♣♣♣♣♣♣♣♣ I YEAR – II SEMESTER COURSE CODE: 7BCEA2 ALLIED COURSE - II – COMPUTER ORGANIZATION Unit I Number Systems and Codes: Binary Number system – Binary to decimal –decimal to binary – hexadecimal – ASCII code – Excess-3 Code – Gray code. Digital Logic: The Basic Gates – NOT, OR, AND - Universal Logic Gates – NOR, NAND. Unit II Combinatorial Logic Circuits: Boolean Laws and Theorems. - Sum of Products method - Truth table to Karnaugh Map – Pairs, Quads, Octets – Don’t Care Conditions- Product-of sums method -Product-of sums Simplifications. Data Processing Circuits: Multiplexers – Demultiplexers-1-of-16 Decoder – BDC-to-decimal Decoders – Seven-segment Decoders – Encoders – Exclusive-OR Gates- Parity Generators and Checkers. Unit III Arithmetic Circuits: Binary Addition- Binary Subtraction – 2’S Complement Representation - 2’S Complement Arithmetic – Arithmetic Building Blocks. Unit IV Basic Computer organ

FAQs

Office Automation (Theory & Lab) covers which core MS Word topics?

It covers Word introduction, creating and saving documents, printing, editing and cursor movement, selecting and replacing text, formatting text and paragraphs, bullets and numbering, tables, graphics, and mail merge including viewing and printing merged letters.

What Excel skills are included in the syllabus?

The syllabus includes starting Excel and understanding the worksheet area, entering numbers and formulas, saving workbooks, editing cells, aligning data, using functions and ranges (including sum), and printing with print preview and print-area setup.

What subjects are addressed under Computer Organization?

It covers number systems and codes, digital logic and basic gates, combinatorial and arithmetic circuits, instruction codes and stored-program organization, microprogrammed control, CPU organization with addressing modes, and input-output and memory hierarchy, along with CISC vs RISC and pipeline basics.

Aug 31, 2026

Upload by Miles