UEC 02 Terminology (Summer 2023-2024).pdf

Pharos University in Alexandria Computer Center Course Title: Computer Skills &Programming concepts II Level: General Course Code: UEC02 Semester: Summer Academic Year: 2023 - 2024 Terminology Week: 5...

Pharos University in Alexandria Computer Center Course Title: Computer Skills &Programming concepts II Level: General Course Code: UEC02 Semester: Summer Academic Year: 2023 - 2024 Terminology Week: 5 Lecture 1-4 Spreadsheets and Business Spreadsheets organize data in rows and columns is a computerized version of a paper Electronic Spreadsheet spreadsheet. Allows users to change one value and What-If Analysis have the results instantly recalculated, Very useful in financial forecasting. is a powerful electronic spreadsheet program that allows you to store, present, Microsoft Excel manipulate, and analyze a number of different types of data. is an electronic spreadsheet that is used for Worksheet entering, storing, and analyzing data in Excel. as individual pages within Excel. is an Excel file that serves as a container to Workbook store related Excel worksheets. is an instruction based on an action that can Commands be accessed. appear on the Ribbon as needed and contain Contextual tabs special commands depending on the selected object. Cell is the intersection of a row and a column. Cell is known by its address, Cell address Cell reference consists of column letter, followed by row number, for example C7. is the cell available to be edited at a given Active cell time. 1 Pharos University in Alexandria Computer Center Course Title: Computer Skills &Programming concepts II Level: General Course Code: UEC02 Semester: Summer Academic Year: 2023 - 2024 Terminology Week: 5 Value is a Numeric constants that do not Value change unless you edit the cell contents. Displayed value the computed value is displayed in the cell. A range is a group of cells that contains related data it is identified by a Range Cell Range reference consists of at least two cell references starting with top-leftmost and ends with bottom-rightmost cell ex: C2:F6 Mathematical equations used to perform calculations or data analysis, Formulas are Formulas dynamic, so the displayed value can change if you change the cell data "feeding" the formula. allows you to edit cell contents and select, Formula Bar navigate to, and view the contents of selected cells. Function is a named, pre-programmed formula. Sum Calculates the sum all values in a range. Max Find the Highest value in a range Min Find the Lowest value in a range Calculates the average of the values in a Average range. Supplies the values to be displayed if the If(conditional expression) conditional expression is true or if it is false. Now Insert the current date and time group contains a set of menus that organize Excel functions according to specific Function Library categories for ease of reference. 2 Pharos University in Alexandria Computer Center Course Title: Computer Skills &Programming concepts II Level: General Course Code: UEC02 Semester: Summer Academic Year: 2023 - 2024 Terminology Week: 5 is a cell or a range reference that will Relative References change when you move or copy a formula from one cell to another. They refer to particular cells and do not change Absolute References when you move or copy formulas to other cells. They are indicated by using the dollar sign ($) before the row and column header. The most common cause of this ##### Error error, is that a column is too narrow to display all cell content. #VALUE! Excel formula has encountered an unexpected value. #DIV/0! A formula is forcing Excel to divide a value by zero. This error indicates an invalid #REF! reference. One common cause is deleting a cell that a formula references. #NULL! You have reference the intersection of two ranges that do not actually intersect can be created as a wide column using merge Headings cells. You can use different fonts and different font Formatting Text sizes to change the appearance of the text and data. Controlling the placement of data within cells Alignment like center content with in a cell. Control how many decimal places are and how Formatting Number negative numbers are displayed. control how many decimal places are displayed, Currency display currency symbols, and how to displays negative numbers. 3 Pharos University in Alexandria Computer Center Course Title: Computer Skills &Programming concepts II Level: General Course Code: UEC02 Semester: Summer Academic Year: 2023 - 2024 Terminology Week: 5 Display dates by using a variety of long and short date formats. Dates and Times Add borders and change their width, color, and Decoration style, Add color, gradient shading, or patterns as cell backgrounds and Add clip art. Security Cells can be protected so the user doesn’t accidentally destroy complex formulas, using Password protection. is reordering the data in your worksheets based on some defined criteria, such as alphabetically Sorting or from highest value to lowest value, enables you to put data entries in a sequence that makes sense for a particular task. Makes data far easier to work with, removes Filtering from view any data entries that do not match the specified criteria. Graphics that represent data in a visual, easily Business Graphics understood format. Designed to help users analyze and understand specific data, Produce simple line, bar, and pie Analytical Graphics chart graphs, Offer relatively few formatting options. Let you produce charts, graphs, and other visual aid, Charts look as if they were prepared by Presentation Graphics professional graphic artist, Offer much more clarity and appeal than analytical graphics. Illustrate multiple comparisons, Data is plotted Line Graphs in plot area, then connected by a line. 4 Pharos University in Alexandria Computer Center Course Title: Computer Skills &Programming concepts II Level: General Course Code: UEC02 Semester: Summer Academic Year: 2023 - 2024 Terminology Week: 5 Used to illustrate multiple comparisons, Data is Bar Graphs plotted in plot area, then a rectangular bar is filled in from the x-axis to the data point. Pie Charts Show how each data point contributes to the total, the whole amount is represented as a circle, Each data point is represented as a slice of the circle. Vertical axis (y-axis) Represent values or amounts. Plot area The area where data is plotted. Data point Each dot or symbol on a line graph. Identify the axes. Labels Summarize the information in a graph. Titles View how your workbook pages will look once Print preview printed. Determine how much space there is between the Margins worksheet content and the edge of the paper. A page layout setting that determines whether Page Orientation pages should print in portrait orientation or landscape orientation. The page height is greater than page width. Portrait orientation The page width is greater than the page height Landscape orientation Lecture 5-7 Web Editing Is a document which can be displayed in a web Webpage browser such as Firefox, Google Chrome, Opera, Microsoft Internet Explorer or Edge, or Apple's 5 Pharos University in Alexandria Computer Center Course Title: Computer Skills &Programming concepts II Level: General Course Code: UEC02 Semester: Summer Academic Year: 2023 - 2024 Terminology Week: 5 Safari. These are also often called just pages with file extension.html or.htm. Is a collection of web pages which are grouped Website together and usually Connected together in various ways. Often called a "site." Is a computer that hosts a website on the Web server Internet. They are responsible for the look, layouts, information flow, templates, logos, illustrations, buttons, and other design elements with in a Web Designers web site, and everything else related to the visual aspects of the UI/UX (user interface and user experience). Means designing user interfaces, creating the visual appearance of each web page that users UI design are able to see on their screens and interact with. Provides positive user experience and user satisfaction while interacting with a web product. In order to create structural guidelines UX design of a website or app layout in the form of wireframes. Is a page –by- page process to visualize the Wireframe system as complete, smoothly operating whole. He is responsible for designing, coding and Web Developer modifying websites, from layout to function and according to a client's specifications. 6 Pharos University in Alexandria Computer Center Course Title: Computer Skills &Programming concepts II Level: General Course Code: UEC02 Semester: Summer Academic Year: 2023 - 2024 Terminology Week: 5 also known as client-side developer is the practice of producing HTML, CSS, JavaScript Front-end Developer and JQuery for a website or Web Application so that a user can see and interact with them directly. Also known as server-side developer use a wide range of different server-side languages such as PHP, Python and SQL to build Back-end Developer complicated programs. He manages and maintains websites, taking into account functionality, appearance, content, and performance. He can: Manage Website Infrastructure. Web Administrator Monitor Performance. Provide Technical Support Create (Add) and Update Web Pages Evaluate Structure and Content He analyzes the behavior of visitors to a Web site to attract more visitors, new customers for goods or services, or to increase the dollar volume each customer spends. Web Analyst He can:  Managing Complex Systems  Managing Software  Recording Web Log Files  It is a presentational language used for developing web pages.  It is a descriptive language used to HTML describe a document's layout, image position, font size, font color, etc. 7 Pharos University in Alexandria Computer Center Course Title: Computer Skills &Programming concepts II Level: General Course Code: UEC02 Semester: Summer Academic Year: 2023 - 2024 Terminology Week: 5 Is a command that tells the browser how and Tag what to do, or how to display the content. Are used in conjunction with tags to issue more Attributes specific commands to the browser. Is a collection of elements which provide information about the HTML document like: style sheet file names and paths, java script file Head names and paths, meta information like Page Title, Meta Description, Meta Keyword Tags, any other meta tag for the web page, etc. Section contains elements to be displayed in the web browser. Elements like: Headings Body etc., Paragraphs, Images, Lists, Menus etc. are grouped together in the Body section of the web page. To determine the start and the end of HTML Program. To insert the address of web page. To insert the title for windows of a web page. The section describes overall structure of the viewable portion of the page. They are a client–server computer program Web Applications which the client (including the user interface and client-side logic) runs in a web browser. Are visual editors for webpages used to generate Web editing Applications HTML codes. 8 Pharos University in Alexandria Computer Center Course Title: Computer Skills &Programming concepts II Level: General Course Code: UEC02 Semester: Summer Academic Year: 2023 - 2024 Terminology Week: 5 It is protocol which tells the web server what Text Transfer Protocol page and files associated with the page are (HTTP) requested It is the process of publishing original content on the Internet. is also known as online Web publishing publishing includes building and uploading websites, updating the associated webpages, and posting content to these webpages online. Can be a professional web design application like Dreamweaver or a straightforward web- Website development based content management system like software WordPress. To upload the content to the web server. An Internet connection smaller websites usually reside on shared servers Server to host that host an array of websites. Domain Name (web Is the identity that characterizes a website on address) the Internet. Is a service that allows organizations and Web Hosting individuals to post a website or web page onto the Internet. Provides technologies and services needed for A web hosting service the website or webpage to be viewed in the provider Internet. Free website hosting Is a free non-paid web hosting service 9 Pharos University in Alexandria Computer Center Course Title: Computer Skills &Programming concepts II Level: General Course Code: UEC02 Semester: Summer Academic Year: 2023 - 2024 Terminology Week: 5 In which web site doesn’t include any external site’s name, you must buy domain and then get Payable website hosting web hosting which is usually a paid service. Lecture 8-10 Database Management Systems A group of characters that has a specific meaning, the smallest meaningful unit of data Field It describes one characteristic of a person, place, or thing. The set of fields containing data about a person, Record place, or thing. A collection of related records. File Data redundancy Repetition of the same data values. Is a collection of related tables. Database Primary Key Is a field that uniquely identifies a record. Is a field in one table that is a primary key in Foreign Key another table. Arranges data in hierarchical “parent-child” Hierarchical Model relationship, each parent record can have many child records, each child record has only one 10 Pharos University in Alexandria Computer Center Course Title: Computer Skills &Programming concepts II Level: General Course Code: UEC02 Semester: Summer Academic Year: 2023 - 2024 Terminology Week: 5 parent record. Arranges data in hierarchical “parent-child” relationship, each parent record can have many Network Model child records, each child record have many parent records. Tables related by primary/foreign key Relational Model relationship. Designed to deal with complex data types such as maps, audio or video files, it represents Object-Oriented Model Properties (data) about that entity and the types of operations (actions) that change that entity. Refers to the degree to which data is accurate Data Integrity and reliable. Rules all data must follow. Integrity constraints Allows you to create a database and enter, Database Management modify, and retrieve data as needed. System (DBMS) Contains descriptive data. Character fields Contains numbers used for calculation Numeric fields Specify the number of decimal places. keep track of true/false or yes/no conditions. Logical fields 11 Pharos University in Alexandria Computer Center Course Title: Computer Skills &Programming concepts II Level: General Course Code: UEC02 Semester: Summer Academic Year: 2023 - 2024 Terminology Week: 5 Stores data about the tables and fields within the Data Dictionary database, Also called a catalog. Data Retrieval Involves extracting the desired data. Structured Query Language Uses English-like statements. (SQL) Uses a graphical interface to generate the SQL. Query-by-example (QBE) In a table-like grid where records are displayed Query Results as rows and fields displayed as columns. Provide a formatted presentation of data from Reports the database, allow you to group reports and total by group, if desired. Manages simultaneous database users, If several users tried to update the same record at the Concurrency Control same time, updates might not be processed correctly. Users can be required to enter a user ID and Security password. Permits the user to look at the data but not Read-only change it. Permits the user to make changes to the data. Update 12 Pharos University in Alexandria Computer Center Course Title: Computer Skills &Programming concepts II Level: General Course Code: UEC02 Semester: Summer Academic Year: 2023 - 2024 Terminology Week: 5 User cannot read or update the data. No privileges A copy of the database. Backup Replaces a damaged database with the good Recovery backup. Contain data that has been captured in company databases or gathered from external sources, It is a central repository of data Data Warehouses which is created by integrating data from one or more disparate sources. 13