WordPress.com



2844165-1905000El-Shorouk Academy Acad. Year : 2014/2015Higher Institute for Computer & Term : FirstInformation Technology Department of Computer Science Course :Introduction to ComputersSection 6Application software programs that enable users to perform specific tasks on a computer, such as writing a letter or playing a game.Software license An agreement either included in a software package or displayed on the screen during installation, that specifies the conditions under which a buyer of the program can use it.Open source software Software programs whose source code is made available to the public. Commercial software Copyrighted software that is developed, usually by a commercial company, for sale to othersShareware Copyrighted software that is distributed on the honor system; consumers should either pay for it or uninstall it after the trial period.Freeware Copyrighted software that may be used free of charge.Public domain software Software that is not copyrighted and may be used without restriction.Installed software. Software that must be installed on a computer in order to be used. Web-based software. Software that is delivered on demand via the Web; also referred to as Software as a Service (SaaS) and cloudware.Software suite. A collection of software programs bundled together and sold as a single software package.Microsoft Office. One of the most widely used office software suites.Keyboard shortcut a combination of keyboard keys that are pressed in unison to issue a specific software command. Ribbon A feature found in recent versions of Microsoft Office that uses tabs to organize groups of related commandsEditing Changing the content of a document, such as inserting or deleting words. Insertion point An on-screen character that looks like a blinking vertical line; indicates the current location in a document, which is where the next change will be made.Formatting. Changing the appearance of a document, such as changing the margins or font size.Word processing. Using a computer and word processing software to create, edit, save, and print written documents, such as letters, contracts, and manuscripts. Word processing software. Application software used to create, edit, save, and print written documents.Word wrap. The feature in a word processing program that automatically returns the insertion point to the next line when the end of the screen line is reached.Spreadsheet A document containing a group of values and other data organized into rows and columns; also called a worksheet in a spreadsheet program.Spreadsheet software Application software used to create spreadsheets, which typically contain a great deal of numbers and mathematical computations organized into rows and columns. Worksheet a single spreadsheet document in a spreadsheet program. Workbook a collection of worksheets saved in a single spreadsheet file.Row In a spreadsheet program, a horizontal group of cells on a worksheet. Column In a spreadsheet program, a vertical group of cells on a worksheet. Cell The location at the intersection of a row and column on a worksheet into which data can be typed.Label A text-based entry in a worksheet cell that identifies data on the worksheet. Constant value A numerical entry in a worksheet cell.Formula An entry in a worksheet cell that performs computations on worksheet data and displays the results. Function. A named formula that can be entered into a worksheet cell to perform some type of calculation or to extract information from other cells in the worksheet.Database. A collection of related data that is stored in a manner enabling information to be retrieved as needed; in a relational database, a collection of related tables. Database software. Application software that allows the creation and manipulation of an electronic database. Field. A single category of data to be stored in a database, such as a person’s last name or telephone number. Also called a column. Column In a database, a field.Record a collection of related fields in a database. Also called a row. Row In a database program, a record.Table In a relational database, a collection of related records or rows.Presentation graphic An image, such as a graph or text chart, designed to visually enhance a presentation. Slide A one-page presentation graphic that can be displayed in a group with others to form an electronic slide show.Electronic slide show. A group of electronic slides that are displayed one after the other on a computer monitor or other display device.Presentation graphics software. Application software used to create presentation graphics and electronic slide shows.Graphics software. Application software used to create or modify images.Question1. Database a collection of related data that is stored in a manner enabling information to be retrieved as needed.2. Record a collection of related fields in a database. Also called a row.3. Workbook a collection of worksheets saved in a single spreadsheet file.4. Software license an agreement either included in a software package or displayed on the screen during installation that specifies the conditions under which a buyer of the program can use it.5. Formula An entry in a worksheet cell that performs computations on worksheet data and displays the results.6. Field a single category of data to be stored in a database, such as a person’s name or telephone number. Also called a column.7. Label a text-based entry in a worksheet cell that identifies data on the worksheet.8. Public domain software Copyrighted software that is distributed on the honor system; consumers should either pay for it or uninstall it after the trial period.9. Shareware Software that is not copyrighted and may be used without restriction.10. Cell the location at the intersection of a row and column on a worksheet into which data can be typed.Instructions1. T Microsoft Office is one example of a software suite.2. T Changing the font size in a document is an example of a formatting operation.3. F In a word processing document, the Enter key is always pressed at the end of each screen line to move down to the next line.4. F The formula =A2+B2 located in cell C2 would multiply the two cells to the left of cell C2.5. T Software can be installed on both personal computers and servers.6. With a(n) open source program, the source code for the program is made available to the publicand so can be modified by others.7. insertion point or cursor The blinking vertical line displayed on the screen that indicates the current location in a document, such as where the next change will be made to the document in a word processing program, is called the .8. A named formula (such as @SUM) in a spreadsheet program is called a(n) function .9. In a relational database, the database object that contains the actual data is the table.a. Media player Listening to a music CD. b. Personal publishing software creating a child’s birthday invitation. c. DVD authoring software Creating a home movie DVD. A. Excel Spreadsheet softwareB. Power point Presentation graphics softwareC. word Word processing softwareD. Access Database softwarea. B6 An absolute cell address b. $D$ A relative cell address c. =SUM (A1:A2) A function For a customer database containing 50 customers and recording data about the customer’s number,last name, street, city, state, ZIP code, and current balance, answer the following questions.a. How many records are in the database? 50b. How many fields are in the database? 7c. To display a list of all customers who live in Texas and have a current balance of less than$10, what database tool should be used? Access ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download