Please complete the following sentence: During the semester, I learned how to work excel and use shortcuts to get work done faster.

•   What did you expect to learn in this course?  Did you learn it?

   I expected tips & tricks to help me become more productive and I did. :)

•   Have you changed your opinions or views as a result of this course? Why or why not?

     My opinions changed in positive ways, in terms of using programs because at first it felt impossible to do things quicker; but as we practiced using programs my skills in computers progressed.

•   Complete the following sentences: One thing I was surprised to learn in this course is: Microsoft Excel. I was surprised to learn this because now I feel comfortable helping my mom at work and others using this program and making their jobs easier and organized.

•   If someone asked you, “What did you learn in Computing Fundamental class,” how would you respond? 

     My response would consist of explaining simple terms of computer(s) and basics on working programs.

•   If you could share one idea from this course with others, what would it be, and why? 

     I would share all computer/program terms and help teach them the basics of computers.

Homework 15.1

bar chart: a chart with bars whose lengths are proportional to quantities.
gridlines: On a datasheet, the lines that indicate the rows and columns. On a chart, the lines that start at and are perpendicular to the category.

landscape orientation: A page or layout that is wider than it is tall.

 

line chart: A line chart or line graph is a type of graph, which displays information as a series of data points connected by straight segments.

pie chart: A type of graph in which a circle is divided into sectors that each represent a proportion of the whole.

portrait orientation: A vertical-format page or screen, one higher than it is wide.

 

active cell : A spreadsheet or table can be divided into cells, which are the points where the rows and columns intersect (creating small squares or cells). An active cell is the cell that is currently highlighted (chosen) and ready to receive or manipulate data.

argument : An independent variable associated with a function and determining the value of the function. For example, in the expression y = F(x₁, x₂), the arguments of the function F are x₁ and x₂, and the value is y


cell reference : A spreadsheet is a computer application that simulates a paper, accounting worksheet. It displays multiple cells that together make up a grid consisting of rows and columns, each cell containing alphanumeric text, numeric values or formulas

circular reference : Occurs when a formula is created that relies on its own value. For example, if cell C10 contains =C5+C10, a circular reference occurs because cell C10 contains a reference to itself.

drag-and-fill : An operation that enables users to copy the content of a cell or a range of cells by dragging the fill handle over an adjacent cell or range of cells.

formula : The combination of constants, cell references, arithmetic operations, and/or functions displayed in a calculation that produce a calculated result.

formula bar : The area used to enter or edit cell contents.

functions : A preconstructed formula that makes difficult computations less complicated.

label : A label in a programming language is a sequence of characters that identifies a location within source code. In most languages labels take the form of an identifier, often followed by a punctuation character (e.g., a colon).

marquee : The marquee tag is a non-standard HTML element which causes text to scroll up, down, left or right automatically

range : A rectangular group of cells. A range may be as small as a single cell or as large as the entire worksheet.

value : Number entered in a cell that represent a quantity, an amount, a date, or time.

workbook : A collection of related worksheets contained within a single file.

worksheet : A single spreadsheet consisting of columns and rows that may contain formulas, functions, values, text, and graphics.

worksheet cell: The intersection of a column and row in a table or in a spreadsheet/worksheet.

·                bullet: A small solid circle printed just before a line of type, such as an item in a list, to emphasize it

·                cell: The local area covered by one of the short-range transmitters in a cellular telephone system.

·                centered text: text placed in the middle of an image area with an equal amount of space on the left and right or top and bottom or on all sides.

·                EndNote: A note is a string of text placed at the bottom of a page in a book or document or at the end of a text. The note can provide an author's comments on the main text or citations of a reference work in support of the text, or both.

·                font: A set of type of one particular face and size.

·                footnote: An additional piece of information printed at the bottom of a page.

·                format marks: The tab key on your keyboard.

·                hanging indent: Indentation of a paragraph in which all lines except the first are indented.

·                justified text: Justified text is text in which all the printed lines in a paragraph (except the final line) are made the same length by the adjustment of spacing between words.

·                leader: (Leaders) Single characters used to fill lines, usually to their end. So called because they “lead” the eye from one element of the page to another. For example, in the following (brief) Table of Contents, the periods (dots) are leaders. Foreword............... 2 Chapter 1.............. ..

·                left-aligned text: when the text is aligned to the right margin.

·                right-aligned text: when the text is aligned to the left margin.

·                style: (Styles) Shortcut for text and paragraph formatting options.

·                tab:  the key on a typewriter or a word processor that causes a tabulation.

·                table: A collection of data stored in memory as a series of records, each defined by a unique key stored with it.

·                text attributes: The color, weight, font, height, and width of text.

Homework 11.1

Application Default: the failure of an application(s) 

Auto Save: The main window for an application, which contains the application menu bar and workspace. An application window may contain multiple document windows

Commands : In computing, a command is a directive to a computer program acting as an interpreter of some kind, in order to perform a specific task. Most commonly a command is a directive to some kind of command line 

interface, such as a shell.

Contextual Tabs: A tab containing groups of buttons that represent commands for customizing and formatting the selected object

Dialog Box Launcher: A small icon in the bottom-right corner of a group, from which you can open a dialog box related to that group

Groups: In computing, the term group generally refers to a grouping of users. In principle, users may belong to none, one, or many groups (although in practice some systems place limits on this.) The primary purpose of user groups is to simplify access control to computer systems.

Keyboard Shortcut: In computing, a keyboard shortcut or hot key is a finite set of one or more keys that invoke a software or operating system operation

Menu Bar: A horizontal bar, typically located at the top of the screen below the title bar, containing drop-down menus.

Microsoft Office Button: A button that displays a menu listing commands related to managing PowerPoint and PowerPoint presentations as a whole

Quick Access Toolbar: Located on top of the Excel screen beside the Office Button

Ribbon: Windows 7 and Office 2007+:  Instead of the traditional menus and toolbar for an application like MS Word or Paint, the commands are on a ribbon, which combines buttons, drop lists, palettes, and dialogs to make commands easier to find and implement.

Scroll Bar: A long thin section at the edge of a computer display by which material can be scrolled using a mouse.

Status Bar: A horizontal bar, typically at the bottom of the screen or window, showing information about a document being edited or a program running.

Tabs: A navigation device that looks similar to tabs on a folder, and when clicked, provides immediate access to a new HTML page.

Toolbar Button: A button on the toolbar designed to provide quick access to a specific command or option.

Toolbars: (in a program with a graphical user interface) A strip of icons used to perform certain functions

Windows Application: Microsoft Windows is a series of software operating systems and graphical user interfaces produced by Microsoft.