...CIS110 Midterm 1. In Word Document, explain how to merge cells. To merge the cells together you first need to make a table with columns and rows. To do this you need to click on the insert tab and then click on the table’s icon. Next you select the number of rows and columns that you need to have. Once you have inserted the table you can take your white pointer to the left side of the row that you are trying to merge together and highlight that row. Then you can go to the top of the page and click on the layout tab and then click on the merge icons tab located directly below the layout tab. 2. In Word document, explain how to create and modify a “Heading” by using Distinctive Style. To modify a heading using distinctive styling you need to go to the top of the screen and click on the little arrow icon in the bottom right hand corner of the styles box. The scroll over to heading 1 and right click and select modify. There you will make your changes to the specifications that you are given and once you have done all of your changes you can save them. Next you’re going to want to go back to the top of the screen and click on the Change Styles icon located at the top right corner of the windows screen. Click on the icon then scroll down to the style select and click on distinctive. Extra Credit Question #4. In Excel, Explain how to select a number of cells, and explain how to copy the content of a cell to other cells. First of all to select a number of cells what...
Words: 411 - Pages: 2
...Assignment #2: Give a short definition for each of the following terms: compound condition is formed by connecting two or more simple conditions using either And and Or. SQL is short for Structured Query Language CREATE TABLE is a command to create a table by describing its layout. computed field isa filed whose values are derived from existing fields. sub query A sub query is a query that’s inside another query. A sub query is evaluated first. SQL built-in functions Otherwise known as aggregate functions are used to calculate the number of entries, the sum of all of the entries,and the largest or smallest values in a column. Answer the following questions: 1. What is the simplest SQL retrieval? The SELECT-FROM-WHERE command. 2. What is the purpose of the Where clause when using SELECT? The purpose of this clause is to be able to list any conditions that are to be applied to the data retrieved. 3. What are data types and why are they important? 4. Provide an example of the GROUP by clause, when would you use this clause? You would use this clause if you wanted to organize your data for a particular record. 5. What is an aggregate function (provide 4)? How are they used? COUNT, SUM,AVG, MIN. Aggregate functions are the built in functions in SQL. They are used to count within the query. 6. Provide example using the COUNT() function SELECT COUNT(*) FROM Customer WHERE Class=’HW’ 7. How is a field name qualified? A Field...
Words: 369 - Pages: 2
...Name: Ariagna Briceno Date: 01/23/2012 CIS110 Smartlipo Smartlipo Laser Body Sculpting is a revolutionary, minimally invasive treatment that does something, no fitness routine in the world can: permanently destroy fat cells. Since your body has only a finite amount of these cells, no new fat cells come back. You can finally have that body you have always wanted. How does Laser Body Sculpting work? This laser-assisted lipolysis procedure is performed using a one millimeter cannula (or tube) inserted into the skin. A laserfiber inside of the cannula delivers energy directly to fat cells, causing them to rupture and drain away as liquid. Simultaneously, tissue around the area coagulates, resulting in overall tighter skin tissue. What areas of the body can be treated? Laser Body Sculpting is ideal for the neck, jaw line, arms, breasts, bra fat, abdomen, inner and outer thighs and knees. Who is a good candidate? A perfect candidate is in good health and of normal body weight. How does Laser Body Sculpting compare to conventional liposuction? Convention liposuction is meant to remove greater amounts of fat. However, since this can leave behind unsightly pockets of skin. Is there a recovery period? Laser Body Sculpting is a minimally invasive procedure which usually requires only local anesthesia. Some light trauma can occur, but you will be able to return to work in a couple of days and resume exercise after 2 weeks. How...
Words: 263 - Pages: 2
...1. What is the simplest SQL retrieval? The simplest versions of the most important SQL command are SELECT, FROM statement. Then if you need to limit the result you introduce the WHERE clause. In the WHERE clause you can use operators such as LIKE, AND, OR, EQUAL, BETWEEN and IN. 2. What is the purpose of the Where clause when using SELECT? The purpose of this clause is to be able to list any conditions that are to be applied to the data retrieved. 3. What are data types and why are they important? A data type is a classification identifying one of various types of data, they are important because assigning data types gives meaning to collections of information 4. Provide an example of the GROUP by clause, when would you use this clause? SELECT Salesperson, SUM(Revenue) AS ‘Total’, MIN(Revenue) AS ‘Smallest’, MAX(Revenue) AS ‘Largest’, AVG(Revenue) AS ‘Average’, COUNT(Revenue) AS ‘Number’ FROM Orders GROUP BY Salesperson You use this clause when you need to see the information in a certain order 5. What is an aggregate function (provide 4)? How are they used? An aggregate function is a function where the values of multiple rows are grouped together as input on certain criteria to form a single value of more significant meaning or measurement AVG() - Returns the average value (average) COUNT() - Returns the number of rows (count) FIRST() - Returns the first value LAST() - Returns the last value 6. Provide example using the COUNT()...
Words: 363 - Pages: 2
...CIS110-041 29 September 2014 A Long Way Gone Essay Questions 1. At the beginning of the novel, Ishmael describes war as too abstract for his mind to understand. He describes this as the mindset for all of the other people in his village as well. When Ishmael and his friends have nowhere to go, they roam nearby cities and what they see is unbearable to their young eyes. All of the destruction, dead bodies, and ransacked homes really put things in perspective for young Ishmael. I feel like this is the first time that Ishmael realizes what is really happening around him. When Ishmael is forced into the army, killing becomes his second nature. He is also on drugs such as cocaine, marijuana, and “brown brown” to help conceal his emotions. Dead bodies and carrying an AK-47 becomes a normal, every day thing for Ishmael. He completely loses sight of any sort of morals or self-respect that he had for himself as a young child. Ishmael had transformed from an innocent, unaware kid into a cold-blooded killer. Later on in the book, UNICEF rescues Ishmael and the other child soldiers that were in his army. UNICEF handed over Ishmael to the United Nations and they then entered him into rehab. After the rehab and all of the caring people, especially from one particular nurse named Esther, Ishmael is finally able to forgive himself. Being dehumanized was very easy for Ishmael, but reclaiming his humanity was extremely hard. 2. From previous years of studying about Africa and all the problems...
Words: 428 - Pages: 2
...Part 1: Check Your Understanding Instructions: Answer the questions below for more practice with key terms and concepts from Part 1. Visit www.pearsonhighered.com/techinaction to check your answers and to find other activities related to the chapter. Multiple Choice 1. Which is not an example of a smartphone operating system? a. iOS b. BlackBerry c. Android d. Linux 2. You are most likely to find a real-time operating system (RTOS) a. in your automobile b. on a laptop c. on a smartphone d. on an iPad 3. All of the following are key attributes of an operating system EXCEPT a. manages memory and storage b. provides a user interface c. manages the CPU d. tracks connections to external networks 4. Modern operating systems such as Windows and OS X use a _____________ interface. a. command-driven b. graphical user c. menu-driven d. text-based 5. If your computer can’t store all the required operating system data in RAM, it can use a temporary file on the hard drive to store data. This is known as a _________ file. a. Linux b. non-volatile c. swap d. thrash True–False _____ 1. Each device attached to your computer needs a device driver to communicate with the operating system. (True) _____ 2. The first step of the boot process is the Power-on self-test (POST). (False) Part 1: Critical Thinking 1. Market Dominance Microsoft and Apple are large corporations and have control of most of the OS market. Although there have been some innovative changes to...
Words: 1075 - Pages: 5
...Free eChapters (FALL 2012) eChapters offer students immediate access to the first few chapters of their textbooks while they are waiting for the print book to arrive. eChapters help students to keep up with required reading and assignments until they receive their course material, without having to pay expedited shipping costs. eChapters that are available from the publisher are attainable free of charge. How do students gain access to free eChapters? Not all courses or textbooks have eChapters available. For all courses where eChapters are available, the files are located in the student’s Blackboard course shell under the Student Center. Below is a list of courses with eChapters loaded into the course shells, giving students free access as of the first day of classes. * = eChapters are forthcoming Course ID ACC100 ACC206 ACC303 ACC304 ACC305 ACC306 Text Title Accounting Principles – 9th edition Accounting Principles – 9th edition Intermediate Accounting 14e Intermediate Accounting 14e Intermediate Accounting 14e Microcomputer Applications for Accounting Excel 2010 Microsoft® Excel 2010: A Case Approach, Complete, 1st Edition, copyright 2011 SOUTH WESTERN FEDERAL TAXATION 2012: COMPREHENSIVE, 36th ed. South-Western Federal Taxation 2013: Corporations, Partnerships, Estates and Trusts, 36th Edition Cost Accounting 13th 09 ed. Advanced Accounting 4th 10th ed. Auditing & Assurance Services 13th 10 ed. Core Concepts of Government and Not for Profit Accounting 2nd ed., 2011 ed ACC...
Words: 3676 - Pages: 15
...ALLIED AMERICAN UNIVERSITY Personalized. Flexible. Dedicated. Online Programs – Individual Support – Open Enrollment – Ease of Transfer Credits UNIVERSITY CATALOG 2013 Seventh Edition 22952 Alcalde Drive, Laguna Hills, CA 92653 Phone: (888) 384-0849 ∼ Fax: (949) 707-2978 7:00 A.M. – 5:00 P.M. (Monday – Friday) Email: info@allied.edu Website: www.allied.edu KEY STAFF AND FACULTY Charlotte Hislop, Ph.D. Candidate, President/CEO Bonny Nickle, Ed.D., Provost Eric Sharkey, M.Ed., Director of Education Bill Luton, Ph.D., Director of Assessment and Dean of Business Carlo Tannoury, Ph.D. Candidate, Dean of Computer Information Systems Patricia Drown, Ph.D., Dean of Criminal Justice and General Studies C.J. Bishop, M.B.A., Institutional Research Frank Vazquez, Operations Director Parrish Nicholls, J.D., Director of Compliance Lindsay Oglesby, Admissions Director Abby Dolan, B.A., Registrar Sasha Heard, M.B.A., Student Services Manager Barbara Jobin, B.S.B.A., Career Center Manager Hugo Aguilar, B.A., Chief Financial Officer Richard Madrigal, B.A., Financial Aid Officer As a prospective student at Allied American University, you are encouraged to review this catalog prior to signing an enrollment agreement. You are also encouraged to review the student performance fact sheet which must be provided to you prior to signing an enrollment agreement. This catalog is not a contract between the student, AAU, or any party or parties. Reasonable effort was made at the time this document...
Words: 52297 - Pages: 210