Software

by

–2/”>a >DOCTYPE html PUBLIC “-//W3C//DTD XHTML 1.0 Transitional//EN” “http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd”>


<br />


and application of PC software packages: definition, Type of software and its Knowledge of Word processing, Spreadsheets and Power point presentation software packages

is a set of programs, which is designed to perform a well-defined function. A program is a sequence of instructions written to solve a particular problem.

There are two types of software −

System

Application

System

The system software is a collection of programs designed to operate, control, and extend the processing capabilities of the computer itself. System software is generally prepared by the computer manufacturers. These software products comprise of programs written in low-level languages, which interact with the hardware at a very basic level. System software serves as the interface between the hardware and the end users.

Some examples of system software are Operating System, Compilers, Interpreter, Assemblers, etc.

Application

Application software products are designed to satisfy a particular need of a particular Environment. All software applications prepared in the computer lab can come under the category of Application software.

Application software may consist of a single program, such as Microsoft's notepad for writing and editing a simple text. It may also consist of a collection of programs, often called a software package, which work together to accomplish a task, such as a spreadsheet package.

Examples of Application software are the following −

Payroll

Student Record

Inventory Management

Income tax

Railways Reservation

Microsoft Office Suite

Microsoft Word

Microsoft Excel

Microsoft PowerPoint

 

Word Processing, Spread sheet and Power presentation

  • WORD PROCESSING

A word processor is a software program that is used to create a document, store it electronically, display it on a screen, modify it using commands and characters, and print it on a printer. It also processes paragraph indentation, margin size, font type, font size, font color, and spacing within the document being created. Word processors have replaced typewriters since they allow the user to make a change anywhere in the document without having to retype the entire page. Word processors also come equipped with "spell-check" functions eliminating the need for multiple editors and provide an immediate tool for grammatical correction. Some common word processors include Microsoft Word, AbiWord, Word Perfect, and Open Office.

Three basic functions lay the foundation for most of the customization that is needed to create many word documents.

Character Formatting

Character formatting changes the appearance of individual characters and relates to the size, font, color, and overall style of the letters or numbers being used. Character formatting also involves underlining, italicizing, and making bold those characters being used. This is great for making a word stand out or for underlining book titles.

Paragraph Formatting

Paragraph formatting adjusts the spacing, alignment, and indentation of the paragraphs being formed. Spacing refers to the amount of lines left blank in between the lines being processed. A good example of this is double-spacing which is commonly used in an educational setting where a student has to write a paper for a specific instructor. Commonly double-spacing is used so that the instructor can make corrections to the document without having to mark over the actual words on the paper. Alignment refers to the way the paragraph is positioned in regards to the left and right margins. A left alignment is most commonly used when creating a word document and this setting aligns the words being formed to be flush with the left margin. A center alignment is usually used for titling a paper.

Page Formatting

Page formatting refers to the width of the margins, the size of the paper being used, and the orientation of the page. The standard margin is 1.25 inches on both the left and right but these can be customized to suit need and preference. The paper size Options reflect what can be used in the printer, and the orientation indicates whether the document will use the traditional or landscape positioning on that paper. Traditional orientation is 8.5 inches wide by 11 inches tall whereas landscape is the exact opposite at 11 inches wide by 8.5 inches tall.

 

 

 Word processing tools

 

Some of the basic tools that are employed in word processing programs that help to make the application more user friendly are tables, graphics, and templates. These tools allow for minimal effort and excellent results when adding features like these to a word document.

Tables

Tables are used for organizing information and are composed of rows and columns in which data is placed. This is great for comparing and contrasting information as it's condensed and presented in a straight forward fashion. Tables can also be used for laying out entire documents, such as a resume, where information is sectioned off from one another. In this example, the entire report is formulated to a table instead of a small section as mentioned earlier.

Graphics

Graphics are pictures, drawings, clip art, or other images that can be inserted into a document from other programs or from stored data on a computer. This makes for easy illustrations where a picture, or pictures, would suffice better than words or tables to highlight a point. Graphics tools also allow the user to manipulate the images that have been imported by changing the color, contrast, brightness, and size of the image, among other things. The customization process of these images in a word processor provide for an easy and quick avenue of explanation concerning the topics at hand.

Templates

Another useful tool are Templates. These are preprogrammed arrangements of ideas and/or illustrations that are known to serve a purpose and are already organized for the user to interact with. Most often this means "filling in the blanks" and some common templates that should be recognized are resumes, business cards, identification cards, fax cover sheets, memos, invoices, and newsletters

 

  • SPREADSHEETS

 

A spreadsheet is a group of values and other data organized into rows and columns similar to the ruled paper worksheets traditionally used by bookkeepers and accountants." The spreadsheet software is mandatory to create computerized spreadsheets. Microsoft Excel is a form of a spreadsheet. There are many terms one must have to know to create a spreadsheet. A worksheet is the single spreadsheet document. A workbook allows multiple worksheets to be saved together in a single spreadsheet file. Worksheets are divided into rows and columns. The intersection of a row is called a cell. One must enter content into the active cell, or current cell; it has a border around it to make it be easily identified. Data is entered directly into worksheet cells by clicking a cell to make it the active cell. Labels, constant values, formulas, and functions are the data that is entered into a cell. Before one enters a formula or function into a cell, one must begin with some type of mathematical symbol, usually the equal sign = Spreadsheets are used to organize and calculate data. There is a maximum number of rows and columns in a spreadsheet which varies depending on the version of software you have. It is essential to know how to use spreadsheets for school, work, Sports, or anything that requires data!

Tables, graphics, and templates are all available to a user with application software, such as Microsoft Word, Microsoft Excel, and PowerPoint. Tables are ways a user can organize data and information at their convenience. According to Microsoft Word, there are now many different available options for users who are looking for various kinds of tables. These different options include the following: the Graphic Grid, Insert Table, Draw Table, insert a new or existing Excel Spreadsheet table, and Quick Tables. The concept of using tables for data input is relatively simple. In order for a user to insert a table, the user must first open Microsoft Word. Once they have done this, they must click the "table" button to customize the table to achieve their needs. The overall format for a table consists of a large (or small) grid that can be altered by the amount of information the user has, ex. four columns five rows. Next, the user must insert the table into the word document by selecting "insert table" from the dropdown menu. Microsoft Excel contains pivot tables that are tables that include data from a spreadsheet with columns and rows that can be specifically selected.  Graphics in Microsoft Word are pictures, or clip art that are able to be inserted into a Microsoft Word document, Excel Spreadsheet, PowerPoint slide, or any other Office application. the most common graphic used in Excel is graphs. You can create graphs based on data taken from your spreadsheet. Graphics are inserted into these Office Applications to enhance the information presented in a Word Document, Excel worksheet, or PowerPoint slide. A user can insert their own picture through their office documents; add clip art, shapes, SmartArt, screenshot, or Word Art. Templates are pre-constructed document layouts whose primary use is to assist a user in creating a specific type of document in a convenient amount of time. The different options of templates vary, but a few of the following are common ones used every day: agendas, brochures, calendars, flyers, fax covers, and many more. Templates are used to save a user time, and confusion in creating their document.

Using of Spreadsheet

Chart

A chart can be created as its own object or embedded within the sheet itself. This is helpful when a user needs to analyze data or represent changing data. Some form of charts are: lines graphs, scatter plot charts, bar charts, Venn diagram charts, and the list goes on.

Function

A function is a pre-programmed mathematical formula to allow the user to make calculations based on the data input. The functions under spreadsheets are there to perform a simple calculation by using a certain value, called arguments. 

There are many different reasons to have functions on spreadsheets. One would be for arithmetic functions to process numerical data. The next would be statistical functions that use analysis tools and averaging tools. This would be useful for finding the Average of the numbers in a certain row/column on a spreadsheet. The next function is date that processes and converts dates. This function could be used to put the sequential dates in order on the spreadsheet. 

Formulas

A formula identifies the calculation needed to place the result in the cell it is contained within. This means a cell has two display components; the formula itself and the resulting value.https://en.wikibooks.org/wiki/Introduction_to_Computer_Information_Systems/Application_ Typically, a formula consists of five expressions: value, references, arithmetic operations, relation operations, and functions. By using these expressions, formulas can help to make tables, solve math problems, calculate a mortgage, figure out accounting tasks, and many other business-related tasks that use to be done tediously on paper

Cell Referencing

Cell referencing refers to the ability to utilize a cell or range of cells in a spreadsheet and is commonly used to create formulas to calculate data. Formulas can retrieve data from one cell in the worksheet, different areas of the worksheet, or different cells throughout an entire workbook. 

 

Pivot Tables

One the most powerful features available in the Microsoft Office spreadsheet program Excel, is pivot tables. Pivot tables allow you to manipulate large amounts of raw data. It makes it easy to analyze the data in different ways, with a simple click and drag. Vast quantities of data can be summarized in a variety of ways. Calculations can be performed by row or column. Data can be filtered or sorted automatically by any or all of the fields. Excel can even recommend a basic layout of a pivot table based on the type of data selected.

 

POWERPOINT

Powerpoint is a Microsoft Office software used to present information and work as a visual aide. Powerpoint make it easy to organize and present information in a visually appealing way such as charts, pictures, tables, video clips, and sounds. Various Designs and color themes come are built in the software and ready to use. The slides themselves come with several options of pre-loaded layouts, using features such as bullet points, pictures, captions, and titles – These are easy to drag and drop to make rearranging very easy. The idea of a digital visual is to help a presenter engage their audience and display their ideas in a more simple form. One feature that comes in handy is the ability to print the slides so either the presenter or audience can be informed ahead of time of what to expect. Powerpoint also has a notes feature in which you can input notes you may need for your presentation. The notes feature also allows you to print out the notes page with the slide show on it which is known as notes view. You can also adjust the size of the slide on the notes view so that all of your notes fit on the page and looks presentable. If all of your notes do not fit on the notes page provided, it will spill over to the next page. If you know their is a lot of wording, you can make a duplicate slide and hide it in the presentation, so you will have more room for your notes! Teachers, employers, and computer users all over the world have now become accustomed to using PowerPoint as their “go-to” visual aide. The image on the right shows a presenter using a powerpoint as a visual aide.

The PowerPoint presentation graphics program provides the user with several assortment tools and operations for creating and editing slides. With those tools, one is able to add new or delete old slides that are previewed in the slide thumbnail tab area, usually found on the left side of the screen. One is also able to switch to the slide outline tab, which contains only the title and the main text included in the slide. If desired, using the Insert tab, the user can perform additional operations like exporting images, along with adding formatted tables, shapes, symbols, charts, and much more to better express their message. Additionally, to customize the PowerPoint to make it even more dynamic and presentable, text can be animated, and a unique transition can be added to the slides. With animation, text can be set to appear in a specific way in the slide during a slide show. Tons of special effects are provided for the user, including animations to make the text to fly, dissolve, fly, float, or bounce in. Similarly, one is also able to apply special effects to specific slides to transition from one slide to another in a specific manner. Additionally, Microsoft PowerPoint allows recorded Narration to be played back as the slideshow is being presented, along with speaker notes. Furthermore, most presentation graphics programs also allow the user to print those speaker notes for the targeted audience’s convenience.

 



,

Software is a general term for the various kinds of programs used to operate computers and related devices. Software can be thought of as the “logic” that drives a computer. It is a collection of instructions that tell the computer what to do. Software can be divided into two main categories: application software and system software.

Application software is designed to perform specific tasks for users. Examples of application software include word processors, spreadsheets, and games. System software is responsible for managing the computer’s hardware and Resources. Examples of system software include the operating system, drivers, and utilities.

Software is created by software engineers. Software engineers use a variety of tools and techniques to develop software, including programming languages, compilers, and debuggers. Software engineering is a complex and challenging field, but it is also a very rewarding one.

Software is used in a wide variety of applications, including business, Education, entertainment, and government. It is an essential part of our modern world, and it is constantly evolving.

Here are some of the most common types of software:

  • Application software: This type of software is designed to perform specific tasks for users. Examples of application software include word processors, spreadsheets, and games.
  • System software: This type of software is responsible for managing the computer’s hardware and resources. Examples of system software include the operating system, drivers, and utilities.
  • Programming languages: These are the languages that software engineers use to write software. Examples of programming languages include C++, Java, and Python.
  • Compilers: These are programs that convert source code written in a programming language into machine code that can be executed by a computer.
  • Debuggers: These are programs that help software engineers find and fix errors in their code.
  • Software engineering: This is the field of study that deals with the design, development, and maintenance of software.
  • Business software: This type of software is used to manage businesses. Examples of business software include accounting software, customer relationship management (CRM) software, and enterprise resource planning (ERP) software.
  • Education software: This type of software is used to teach students. Examples of education software include Learning management systems (LMS), e-books, and educational games.
  • Entertainment software: This type of software is used for entertainment. Examples of entertainment software include video games, movies, and music.
  • Government software: This type of software is used by governments. Examples of government software include tax software, law enforcement software, and healthcare software.

Software is an essential part of our modern world. It is used in a wide variety of applications, including business, education, entertainment, and government. It is constantly evolving, and it is a very rewarding field to work in.

Here are some frequently asked questions and short answers about different topics:

  • What is the meaning of life?
    The meaning of life is a question that has been asked by philosophers and theologians for centuries. There is no one answer that everyone agrees on, but some possible answers include to find happiness, to make a difference in the world, or to simply live each day to the fullest.

  • What is the best way to learn a new language?
    There are many different ways to learn a new language. Some people prefer to take classes, while others prefer to use online resources or apps. There is no one right way to learn a new language, but the most important thing is to find a method that works for you and to be consistent with your studies.

  • What is the best way to lose weight?
    There is no one-size-fits-all answer to this question, as the best way to lose weight will vary depending on your individual circumstances. However, some general tips that may help include eating a healthy diet, exercising regularly, and getting enough sleep.

  • What is the best way to make Money?
    There are many different ways to make money. Some people choose to work a traditional job, while others start their own business or invest in stocks or real estate. There is no one right way to make money, but the most important thing is to find a way that you are passionate about and that you can stick with.

  • What is the best way to find a job?
    There are many different ways to find a job. Some people choose to use online job boards, while others prefer to Network with friends and family. There is no one right way to find a job, but the most important thing is to be persistent and to never give up.

  • What is the best way to improve your Health?
    There are many different ways to improve your health. Some general tips that may help include eating a healthy diet, exercising regularly, and getting enough sleep. You should also make sure to see your doctor for regular check-ups.

  • What is the best way to be happy?
    There is no one answer to this question, as happiness is a subjective experience. However, some general tips that may help include spending time with loved ones, doing things that you enjoy, and helping others.

  • What is the best way to be successful?
    There is no one answer to this question, as success is a subjective experience. However, some general tips that may help include setting goals, working hard, and never giving up.

  • What is the best way to make a difference in the world?
    There are many different ways to make a difference in the world. Some people choose to volunteer their time, while others donate money to charity. There is no one right way to make a difference, but the most important thing is to find a cause that you are passionate about and to get involved.

  • What is the best way to live a good life?
    There is no one answer to this question, as the meaning of a good life will vary depending on your individual circumstances. However, some general tips that may help include living in the present moment, being grateful for what you have, and helping others.

Sure, here are some MCQs without mentioning the topic Software:

  1. What is the name of the programming language that is used to create websites?
  2. What is the name of the operating system that is used on most personal computers?
  3. What is the name of the search engine that is used by most people?
  4. What is the name of the Social Media platform that is used by most people?
  5. What is the name of the email service that is used by most people?

Answers:
1. HTML
2. Windows
3. Google
4. Facebook
5. Gmail

Here are some more MCQs:

  1. What is the name of the cloud storage service that is used by most people?
  2. What is the name of the video streaming service that is used by most people?
  3. What is the name of the music streaming service that is used by most people?
  4. What is the name of the ride-hailing service that is used by most people?
  5. What is the name of the food delivery service that is used by most people?

Answers:
1. Google Drive
2. Netflix
3. Spotify
4. Uber
5. DoorDash

Here are some more MCQs:

  1. What is the name of the instant messaging service that is used by most people?
  2. What is the name of the photo sharing service that is used by most people?
  3. What is the name of the video game console that is used by most people?
  4. What is the name of the smartphone that is used by most people?
  5. What is the name of the tablet that is used by most people?

Answers:
1. WhatsApp
2. Instagram
3. PlayStation
4. iPhone
5. iPad

Here are some more MCQs:

  1. What is the name of the search engine that is used by most businesses?
  2. What is the name of the email service that is used by most businesses?
  3. What is the name of the cloud storage service that is used by most businesses?
  4. What is the name of the video conferencing service that is used by most businesses?
  5. What is the name of the project management software that is used by most businesses?

Answers:
1. Google
2. Gmail
3. Google Drive
4. Zoom
5. Asana

Here are some more MCQs:

  1. What is the name of the operating system that is used on most servers?
  2. What is the name of the Database management system that is used by most businesses?
  3. What is the name of the programming language that is used to create web applications?
  4. What is the name of the programming language that is used to create mobile applications?
  5. What is the name of the programming language that is used to create desktop applications?

Answers:
1. Linux
2. MySQL
3. Python
4. Java
5. C#