Blogs

Windows and MS office basics

Hardware: Computer hardware is the collection of physical parts of a computer system. This includes the computer case, monitor, keyboard, and mouse. It also includes all the parts inside the computer case, such as the hard disk drive, motherboard, video card, and many others. Computer hardware is what you can physically touch.



Software: Set of machine-readable instructions that directs a computer's processor to perform specific operations.



TYPES OF SOFTWARE



1. Application software: uses computer system to perform useful work or provide entertainment functions beyond the basic operation of the computer itself. Eg. MS Word, Google Chrome, paint, library management system, VLC.



2. System software: Software used to manage and control the hardware components and which allow interaction between hardware and other types of software. Eg. Operating systems, BIOS.



SYSTEM SOFTWARE




  • BIOS/UEFI:(Basic Input Output System/Unified Extensible Firmware Interface): The program a processor uses to get the computer system started after you turn it on. It also manages data flow between the computer’s operating system and attached   devices.

  • Operating systems: OS provides a fundamental user interface for your computer and provides a set of services for the applications running on your computer.Eg. Windows 8, Ubuntu.

  • Utility software: Software which helps to maintain and protect the computer system but does not directly interface with hardware. Eg. Anti-virus, firewall, disk-defragmenters.

  • Drivers: Program that lets the OS communicate with specific computer hardware.



INTRODUCTION TO COMMAND PROMPT




  • Command line interpreter application.

  • Executes commands- can even automate tasks.

  • It is not MS-DOS.



TYPES OF MEMORY



Primary: Primary storage (main storage or memory), is the area in a computer in which data is stored for quick access by the computer's processor. The terms random access memory (RAM) and memory are often as synonyms for primary or main storage.



Secondary: Secondary memory is where programs and data are kept on a long-term basis. Common secondary storage devices are the hard disk and optical disks. The hard disk has enormous storage capacity compared to main memory.



FILE SYSTEMS: Data is stored as files in a computer system i.e data files and application files. Operating systems manage this data using file system.



`FAT-File Allocation Table




  • Keeps track of and provides quick access to file fragments.

  • Less secure



NTFS- New technology file system




  • Supported on new systems only.

  • More secure than FAT.

  • Supports large disk sizes.

  • Highly reliable.

  • Data safety due to bad-cluster mapping.



SOME FREQUENTLY USED WINDOWS FEATURES




  • Windows multi-user

  • Projector options



WINDOWS 10 special features:




  • Improved cmd(shortcut keys made usable)

  • Multiple desktop

  • Microsoft edge

  • Enhanced security features





‚ÄčMS OFFICE



Features and terms:




  • Tab

  • Ribbon

  • Groups

  • Note section (For power point)

  • Clipboard

  • Quick Access toolbar

  • Password protection



MS Word




  • Header and Footer

  • Watermark

  • Wrap and position

  • Ctrl+f1-Hide ribbon

  • Insert equation

  • Customize ribbon

  • Subscript superscript    



MS Excel                      




  • Autosum

  • Charts

  • Merge and center

  • Ctrl+f1-Hide ribbon

  • Insert equation

  • Customize ribbon



MS PowerPoint




  • Ppt to video

  • Note section

  • Hyperlink

  • Custom show per client


Recent Posts

Prev                                    Next

For Authors Only: