Syllabus: MB-107, WCM

PUNJAB TECHNICAL UNIVERSITY

WORKSHOP ON COMPUTERS FOR MANAGEMENT (MB-107)

Max. Marks: 100

Internal Assessment: 100

Unit I

• Introduction to Computers: Block structure of a computer, Components of a computer system.
  
• Introduction to Problem Analysis, Flow Chart and Algorithm.
  
• Introduction to High Level and Low Level Languages.
  
• Software: System s/w, Application s/w.
  
• Basic concepts of operating systems.
  
• Internet access:
  
  • Introduction to www, Internet and intranet
    
  • Creation of E-mail address
    
  • Send & receive messages
    
  • Use of search engines
    
  • Delivering information with Microsoft Mail.
    
  • Use of MS – Outlook/Outlook Express
    

Unit II

MS-Office (Contemporary version):

• Word processing:
  

• MS-Word, word basics, creating a new word document, page-setup, Editing document, cut, copy, paste, paste special, paste as hyperlink.
• Different views of document, tool bar customization, formatting text and documents, working with header and footer, footnotes, endnotes, tables and sorting, graphics, mail merge and macros.
• Insert page break, column break, section break, paragraph, change cases, borders and shading.
• Spelling and grammar checking, Auto correct, Track changes, Inserting, deleting, selecting table, Insert rows and columns, Table auto format, formulas, split table.

Unit III

• Power Point:
  

• Basics, working with texts and graphics in Power Point,
• Adding animation, sound, pictures and video.
• Creating new slide, inserting new slide, background setting, auto layout, apply design templates.
• Inserting header and footer, Slide from file, Clip art.
• Different view of slide, duplicates, delete slide, slide sorter, Master slide. Animation setting, slide transition, custom show.

Unit IV

• MS Excel:
  

• Spreadsheets and their uses in business,
• Excel basics, Creating a new worksheet, rearranging worksheets, excel formatting techniques, using functions and working with graphics in excel. Cut, Copy, Paste, Paste special,
• Auto fill, Delete Sheet, Clear. Page break preview, Custom View, Header and footer.
• Inserting Row, Column, Worksheet, Function, Object, Hyperlink.
• Formatting row and column.
• Protection, goal seeks scenarios, Customize, option, sort, filter, form, and subtotal.
• Validation, table, consolidate, pivot table and chart, get external data.

Text Books:
Sr. Author Title Publisher
1 P.K.Sinha Fundamental of Computers BPB
2 Leon & Leon Internet for Everyone Leon Tech World
3 Curtin, Foley, Sen Information Technology Tata MCGraw Hill
& Martin
4 Ron Masfield MS-Office Tech Publication
5.Download Power Point Presentation here: http://www.scribd.com/home