Mumbai University

Ms-Windows and Ms-office

UNIT 1

1. Difference between the DOS and the Ms-WINDOWS user interface. In distinguish between the DOS command driven interface and the Ms-Windows GUI/WIMP interface.

2. MS-Windows Basics.
2.1 The password dialog box.
2.2 The Ms-Windows Desktop. Changing background, Screen saver, Settings and Appearance.
2.3 The Taskbar Repositioning the Taskbar, Changing the Taskbar properties.
2.4 Ms-Windows standard icons. My Computer, Network Neighbourhood, Inbox Recycle Bin, My Briefcase.
2.5 Ms-Windows navigation, Different parts of Windows, Minimize, Maximize, Restore and Close a Window, Moving and Sizing Windows, Opening multiple Windows, Proportional Scrollbars, the File, Edit Menu options in Windows.
2.6 The start menu, Running Programs, Opening previously opened documents, Finding files and Folders, Using MS-Windows Help.

3. Managing files in Ms-Windows. Using My Computer as well as Explorer. File naming conventions and long file names. The explorer two pane view. Expanding and contracting the tree in the left pane. Sorting the files in the explorer. The explorer menus and toolbars. Navigating the Ms-Windows hierarchy. Moving, Copying, Renaming, Deleting and Recovering Files. Using undo and redo features. Operations with multiple files creating new Folders.

4. Creating Shortcuts on desktop - of files, Folders and Drives.

5. Checking the properties of a drive.

6. Ms-Office common features
6.1 The Ms-Office interface.
6.2 Creating a new file, opening an existing file, Deleting and Renaming documents.
6.3 Print preview and printing documents.
6.4 The insertion points, making corrections, spell checks.
6.5 Selecting, Moving and Copying Values.
6.6 Fonts and Format.

UNIT 2

7. MS-WORD BASICS.
7.1 The Ms-Word Windows.
7.2 Entering, Moving, Selecting and Copying text.
7.3 Applying fonts and font styles.
7.4 Creating, Numbering and Bullets.
7.5 Finding and Replacing text.
7.6 Spelling, Grammar and Thesaurus.
7.7 Page formatting, print previewing and printing text.
7.8 Creating headers and footers.
7.9 Constructing tables in Ms-Word.
7.10 Ms-Word Mail Merge.

UNIT 3

8. Introductory Ms-Excel skills
8.1 Entering and Editing cell entries.
8.2 Working with numbers.
8.3 Changing the worksheet layout.
8.4 Formatting Texts, Borders, and Color.
8.5 Printing in Ms-Excel.
8.6 Using functions and references.
8.7 Naming ranges.

9. Charting in Ms-Excel
9.1 Creating Charts.
9.2 Editing and Formatting Charts.

10. Advanced Excel.
10.1 Ms-Excel Financial and Statistical functions.
10.2 Sorting and Creating an Ms-Excel database.
10.3 Creating subtotals in Ms-Excel.
10.4 Using a dataform.
10.5 Creating Pivot tables.
10.6 Using and creating Ms-Excel templates.
10.7 Linking Workbooks.
10.8 Formulas between worksheets.

11. Creating Ms-PowerPoint presentation.

Related pages

Introduction to Computers

Basic computing concepts (software-hardware, classification of computers, input-output, on-line and real-time processing, generations of computers, operating system), networking (LAN, WAN, MAN), DBMS, computer viruses, information system (concept, application, MS Office). .....

Operating Systems

Unit-I: 1.1 Operating System Overview Operating Systems objectives & functions, the evolution of operating Systems, Major Achievements, Examples of Operating systems. WS: Chap.2.1 to 2.5 1.2 Process Description & Control Process states, Process Description, Process Control, Processes & Threads, Examples of Process Description & Control. WS: Chap. 3.1 to 3.6 1.3 .....

THE LINUX OPERATING SYSTEM

Unit-IV: 4.1. Operating Systems & LINUX, History of LINUX& UNIX, LINUX Overview, Shell: Bourne, Kron & C-shell, File structure: Directories & files, Utilities: Editors, Filters & Communications. RP: Chap.1 Pages: 3 to 11. Installing LINUX: Hardware & Software Requirements, Creating LINUX partition, creating Install Disks, Installing Open LINUX System, Network .....

Web Technologies

UNIT-I 1.1 HTML & Graphics: HTML 4.0 Tag Reference, Global Attributes, Event Handlers, Document Structure Tags, Formatting Tags, List Tags, Hyperlinks, Image & Image map, Table Tags, Form Tags, Frame Tags, Executable Content Tags. 1.2 Image Maps, Advanced Graphics, Tables, Frames, forms & Style Sheets. ELJO: Chapter 2. UNIT-II XML: Introduction .....

Event drive programming using Visual Basic

UNIT 1 1. Visual Basic fundamentals. 1.1 Development of environment. Menu Bar, Toolbar, Toolbox, Properties, Windows etc. 1.2 Customisation of environment. 1.3 Introduction to event driven programming. 2. The Visual Basics language. 2.1 Data types, Variables, Constants, and Arrays. 2.2 Collections. 2.3 Procedures, Subroutines, Functions. 2.4 Flow Control Statements. UNIT 2 3. Visual Basics forms. 3.1 Appearance of .....

Advanced Java - I

Unit I Explanation of the statement: "Java: A simple, object-oriented, network-savvy, interpreted, robust, secure, architecture-neutral, portable, high performance, multithreaded dynamic language". Explanation (at the overview level) of the following terms: Plug-ins, Java API's, jdk, J2SE, J2EE, J2ME, JVM, Java Hotspot, JRE, HotJava, JAR, AWT, Swing, Applets, Servlets, JSP, Lava Beans, EJB, .....

B.Sc. (Home Science)

Bachelor of Science (Home Science) B.Sc. (Home Science) Duration: Three years Minimum Admission Requirement Eligibility: A candidate for being eligible for admission to the first Year B.Sc. examination in Home Science. a) Must have passed the First Year examination in Science of this University or an examination of another University or .....

DIGITAL SIGNAL PROCESSING

DIGITAL SIGNAL PROCESSING Discrete Time Signals and Systems: Discrete time signal sequences, Linear Shift Invariant system, Stability, Linear Constant Coefficient difference equations, Frequency domain representation of discrete time systems and signals, symmetry properties of Fourier Transform, Sampling of continuous time signal, Two dimensional sequences and system. Z Transform: Z-transform, Inverse .....

OPERATING SYSTEMS

OPERATING SYSTEMS Introduction to history of operating systems : Early batch systems, multiprogramming, timesharing, distributed O.S and multiprocessor O.S. Basic concepts: Processes, files, system calls, shell, layered structure v/s monolithic structure of O.S. Processes : Process model, process states, process hierarchies, implementation of processes, data structures used such as process .....

Web Designing

PRINCIPLES OF WEB DESIGN Unit-I: 1.1 What is web-design? Web Design Pyramid, Building Web-sites, User perspective, Content focus, Evaluation of a web-site. TP: Chap.1 1.2 The Web Design Process: Basic Web Process Model, Goals & Problems, Audience and User Profiling, The site plan, Design, implementation & Testing, Release & beyond. .....

Recently Visited Pages

• BUSINESS DATA PROCESSING
  BUSINESS DATA PROCESSING Introduction to Business Organization : Need , Structure and nature of Information Systems – data processing activities-Management Information Systems .Introduction to structured (.....)
• International Marketing
  Theories of international trade, globalisation, WTO, ecology and environment, ethical issues, foreign MNC's, Indian MNC's, competitive strategies, international marketing concepts, international advertising, studying the environment (.....)
• HINDI
  Courses Available: M.A. (Pt. I) M.A. (Pt. II) M.Phil. Ph.D. Intake Capacity: M.A. (Pt. I): 200 (.....)
• Foundations of Human Skill-I
  Basics of human nature, influence of heredity and enviroment, intelligence, abilities, basic dimensions of individual interactions in society, characteristics of groups and their behaviour, nature (.....)
• Finance and Cost Accounting
  Introduction to accountancy, preparation of final statements of accounts with adjustments, importance and advantages of cost accounting, elements of cost, cost classification, preparation of cost (.....)
• M.A. Degree Course: History
  M.A. & M.Phil. degree courses in History conducted by : University Department of History, Vidyanagari Campus, Kalina, Santacruz (East), Mumbai – 400 098. Phone (.....)
• Diploma in Computerised Data Processing and Management information System
  Information about this course is coming soon. (.....)
• APPLIED MATHEMATICS V
  APPLIED MATHEMATICS V Probability and topics in Statistics: Statistical experiments with random outcomes, Sample space, probability defined on the basis of sample space and on (.....)
• Diploma in Analytical Instrumentation
  Information about this course is coming soon. (.....)
• Bachelor of Commerce
  Information about this course is coming soon. (.....)
• COMPUTER PROGRAMMING I
  COMPUTER PROGRAMMING I Basic Anatomy of Computers: Components of computer systems, IBM compatible PC Introduction to operating systems: Need for an operating system, internal commands (.....)
• M.Sc. Degree Course: Home Science
  M.Sc. degree course in Home Science: College enrolling students for the said course: 1. College of Social Work, Nirmala Niketan, 38, New Marin Lines, (.....)
• COMPUTER SCIENCE
  Courses Available: M.Sc.(Pt.I) M.Sc.(Pt.II) Ph.D. Dip.in Computer Software Techniques Dip.in Computer Programming Dip.in Computer Science & Application Intake Capacity: M.Sc.(Pt.I): 20 (.....)
• Certificate course in Yoga
  Certificate course in Yoga (conducted by department of philosophy Duration: One year (Part-time) Minimum Admission Requirement A candidate for being eligible for admission to the course for the Certificate (.....)
• M.A. Degree Course : Gujarati
  M.A. degree Course in Gujarati conducted by: University Department of Gujarati,Vidyanagari Campus, Kalina, Santacruz (East), Mumbai – 400 098. Phone: 2652 6091 (.....)