zilongwang/ReadingBank huggingface dataset:
Joint Joint Type Movement Agonist Antagonist Type of Contraction Knee hinge flexion Hamstring/ rectus femoris et al Semimembranosus et al concentric [5] The figure below shows a netball player using the elbow joint during the execution phase of a shot Identify and complete the table below. Joint Joint Type Movement Agonist Antagonist Type of Contraction Plane of movement Elbow Hinge Extension Triceps brachia Bicep Brachia Concentric sagital The figure below shows an athlete during the take off phase of the long jump. Complete the joint analysis of the athlete’s left ankle joint. [5 marks]
Joint Type Movement Agonist Antagonist Type of Contraction Plane of movement extension Bicep brachia Triceps brachia eccentric sagittal Use Fig 2 to help you complete the following movement analysis of the spine during extension. (2 marks) Joint classification Movement Agonist Antagonist Type of Contraction Cartilaginous Extension Erector spina Rectus abdominals Flexion
How to answer exam questions: (1 mark questions): Usually definitions or examples that can be answered in one sentence. (2 mark questions): Usually definitions or examples that can be answered in two sentences. (3 mark questions): These questions come in three types: Type 1: State three ways a Christian may worship in the home. (3) This type requires an answer with three statements. E.g. “One way a Christian may worship in the home is through prayer. Another way is meditation. A final way is by listening to Christian music.” Type 2: Describe one reason a Christian might give for believing in God. (3) This type requires an answer with a P.E.E (Point Evidence Explain) paragraph. E.g. “One reasons a Christian might give for believing in God is the cosmological argument. St. Aquinas stated that the universe must have a cause, as everything does, and if we go back far enough we will uncover the uncaused cause – namely God. This is a reason that Christians believe in God because it states that God is the only being which could have caused the universe to exist as He is the only thing which can have no cause. Type 3: Describe how music is used to express beliefs about God. (3) This type requires an answer with a P.E.E paragraph OR an answer with three statements. E.g. “A Christian may say that music reflects beliefs about God’s omnipotence. An example of this would be the hymn ‘Our God’ which states ‘all will see how great is our God’. This hymn shows that God is all powerful as his greatness will be revealed to all people” OR E.g. “Some Christians would say music reveals God’s creative ability. Some Christians would suggest that music can reveal God’s
Client Date of Birth: Address: Key Tasks: Wash hands before and after care. Comply with Agency policy and procedures. Ensure medications are within use by dates before use and included in the medication order (if administering medications). Sign the medication record sheet or chart if you administer the medication. (This is not necessary if you are only prompting the medication = medication support.) Medication to be given (eg Blister Pack contents, inhaler, cream) Amount/Dose to be administered Specific route Time to be given Specific instructions regarding the medication (eg with food) Commencement of medication Cessation or review date of the medication
____ 13. This graph shows the linear relation . Write the ordered pair for point Q. a. (–3, b. –3) c. (2, –3) d. 3) ____ 14. Describe the relationship between the variables x and y in this graph. Graph of a. When x increases by 1, y increases by 2. b. When x increases by 1, y increases by 5. c. When x increases by 1, y increases by 7. d. When x increases by 2, y decreases by 5. Short Answer 15. Solve this equation. 16. Solve this equation. 17. Solve this equation. 18. Solve this equation. 19. Solve this equation.
33. The perimeter of a rectangle is 46 cm. The rectangle has length 13 cm. Write an equation to find the width, w, that involves the distributive property. Solve the equation. 34. Saja and 10 friends went to a fair. The cost of admission was $8 per person. They each bought an unlimited midway ride ticket. The total cost of admission and ride tickets for Saja and her friends was $319. What was the price of an unlimited ride ticket? a) Write an equation to model the problem. b) Solve the equation and answer the question. 35. Solve this equation: 4(x – 7) = 16 36. The equation of a linear relation is . What is the value of y when x = 2? 37. Make a table of values for the relation for x = –4, –3, –2, –1, 0.
38. Make a table of values for the relation for x = 0, 1, 2, 3, and 4. 39. Make a table of values for the relation for integer values of x from –3 to 3. 40. Iris has $240 in the bank and she withdraws $25 every week. An equation for this relation is , where c represents the amount of money, in dollars, in Iris’ account and w represents the number of weeks. How much does Iris have in her account after 4 weeks? 41. The price of a medium pizza is $15, plus $3 for each topping. An equation for this relation is , where t represents the number of toppings and c represents the cost of the pizza in dollars. a) Complete this table of values for the relation. Number of Toppings, t 0 2 4 6 8 Cost, c ($) b) Find the cost of a pizza with 8 toppings.
Age group % males % females 0 to 4 years 2.7 2.6 5 to 9 years 2.9 2.8 10 to 14 years 3.4 3.2 15 to 19 years 3.5 3.3 20 to 24 years 3.3 3.3 25 to 29 years 3.1 3.2 30 to 34 years 3.1 3.3 35 to 39 years 3.4 3.6 40 to 44 years 4.1 4.2 45 to 49 years 4.1 4.2 50 to 54 years 3.7 3.8 55 to 59 years 3.2 3.3 60 to 64 years 2.5 2.6 65 to 69 years 1.9 2.0 70 to 74 years 1.6 1.8 75 to 79 years 1.2 1.6 80 to 84 years 0.8 1.3 85 years and over 0.5 1.1 Do the calculations below: Remember! Birth Rate= (BPY/Total Pop) x 1000
PSY 3090: Human Violence and Individual Change PSY 3300: Psychology of Prejudice and Discrimination PSY 3620: Psychological and Psychosocial Development Stages in Maturity and Aging List all the service courses offered by the department (do not include GE and Major program courses) None. Describe your 5-year assessment plan for GE courses and outcomes for 2017-2021 (as applicable) (See Appendix B for a list of all GE Learning Outcomes) GE/Course Learning Outcome Academic year/semester when GELO is assessed What is your tentative plan for assessing this GELO? (For example, which assessments will be used, which courses will examined?) GELO1: Knowledge: Mastery of content and processes of inquiry (demonstrate understanding of race, ethnicity, gender, and socioeconomic class) 2017-2018, See plan above, this GE aligns with our PLO3 and is being assessed this year in our program. We are intentionally including the upper division GE course PSY 3300 in our assessment plan. GELO2: Proficiency: Intellectual skills (read, speak and write effectively) 2017-2018, See plan above, we will include GE courses in our plans for assessing writing and oral communication. GELO3: Place and Community: Urban and global mission 2017-2018, See above. GELO4: Transformation: Integrative learning Who conducts assessment activities (planning, data collection, etc.) for this program? (Please check all that apply) X faculty who teach courses in the program the program director or department chair X a department or program committee program staff students Other (please specify) ________________________________________________________ With whom do you share your assessment information? (Please check all that apply) X faculty in the department students in the program X campus administrators department alumni employers external community members Other (please specify) ________________________________________________________
(a) Why does A form a strong 1:1 complex with carboxylic acids (RCOOH) in CHCl3 but not in water? 19 Answer both parts of the question (a) Outline the derivation of the following equation for the deflection angle as a function of the impact parameter b and energy  for classical scattering of a particle by a potential V(R): [1] (b) For classical scattering by a potential V(R) = c/R2, where c > 0 is a constant, use the equation in part (i) to derive expressions for the impact parameter dependence of: [END OF PAPER]
SECTION VII. DATA FEED FUNCTIONALITY ACTIVATION OF THE DATA FEED FUNCTIONALITY SEE Link agrees to provide each Contracted Originating Broker with the Data Feed Functionality under the terms and conditions of the Operational Rules, this Agreement and the Membership Agreement that SEE Link has concluded with such Contracted Originating Broker. The Parties agree that SEE Link shall provide the Contracted Originating Broker with the Data through the Data Feed Functionality on behalf of the Executing Broker. The Parties agree that SEE Link shall provide the Data and the Data Feed Functionality to the Contracted Originating Brokers without imposing any charges to the Executing Broker therefore. SEE Link shall activate the Data Feed Functionality in the Contracted Originating Broker’s software under the same conditions under which SEE Link shall activate and make available the Service to the Executing Broker, as stipulated in Article 6 of this Agreement, and to the relevant Contracted Originating Broker, as applicable. The Executing Broker shall regulate the terms and conditions for use of the Data in the Inter-broker Agreement it has concluded with the relevant Contracted Executing Broker. However, the Executing Broker acknowledges and agrees that SEE Link shall be entitled to suspend or terminate the Data Feed Functionality in accordance with the terms of this Agreement, without incurring any liability therefore. AVAILIBILITY OF THE DATA FEED FUNCTIONALITY AND USE OF DATA SEE Link shall keep the Data Feed Functionality available to a Contracted Originating Broker and provide the Data through such Data Feed Functionality to a Contracted Originating Broker under the terms and conditions set out in the Operational Rules and in the Membership Agreement that SEE Link has concluded with such Contracted Originating Broker. SEE Link shall provide the Data through such Data Feed Functionality to a Contracted Originating Broker under the terms and conditions for use of such Data set out in the Operational Rules and in the Membership Agreement that SEE Link has concluded with such Contracted Originating Broker. TERMINATION OF THE DATA FEED FUNCTIONALITY; CONTRACTUAL PENALTY The Parties agree and acknowledge that any termination of the Service in accordance with Article 20 of this Agreement shall automatically lead to deactivation of the Data Feed Functionality with respect to the relevant Contracted Originating Broker. If an Inter-broker Agreement that the Executing Broker has concluded with a Contracted Originating Broker has been terminated for any reason and by any party to such agreement, Executing Broker shall be obliged to notify SEE Link of such
Exclusion zones Have appropriate exclusion zones been established around the excavation to prevent: workers or public from falling into the excavated area other plant and vehicle traffic from entering the excavated area collapse of the excavated area from other plant and vehicle traffic workers or public from entering any unsafe trenches or excavated areas workers in the excavation from being struck by falling objects. Yes No N/A Comments: Have all relevant workers and plant operators been informed and understand where exclusion zones are established? Consider: specific and clearly marked haul routes for mobile plant and trucks (traffic management plans) clearly marked access and egress ways for workers clear delineation zones between mobile plant and workers. Yes No N/A Comments: Installing and removing ground support systems If there is a ground support system installed, is there a safe system of work in place to minimise the risk of injury from people installing and removing the system? Consider: training, information and instructions to workers for installation methods installation is in accordance with manufacturer’s instructions and specifications work is supervised by a competent person components are assembled in the correct sequence specific lifting points are used for trench boxes correct tools and equipment are used personal protective equipment is being worn by workers. Yes No N/A Comments: Part five – working in the excavation safely Managing the risk of falls Is the risk of people falling into the excavation adequately controlled? Consider: physical control methods installed (trench box extensions, guard rails, scaffolding) backfilling as work progresses (safe system of work) providing clearly defined access and egress for workers (steps cut into the excavation) securing ladders into the excavation providing adequate barriers or barricades at a safe distance back from the excavation. Yes No Comments:
Managing the risk of being trapped by excavation collapse Is the risk of people being trapped from collapse adequately controlled for trenches at least 1.5 m deep? Consider: minimising the amount of time workers are required to be in the excavation (if at all) benching, battering or combination of both shoring or sheet piling trench shields or boxes geotechnical engineer providing signed advice or report including specific conditions and time periods for which the advice applies adequate barriers or barricades at a safe distance from the excavation to prevent mobile plant, vehicles or people from getting close to the edge (wheel stoppers for plant). Benching Battering Combination of benching and battering Yes No Comments: Managing the risk of falling objects Is the risk of people being struck by falling objects adequately controlled? Consider: erecting adequate barriers or barricades at a safe distance from the excavation ensuring adequate storage of materials and plant at a safe distance from the excavation providing clearly defined pedestrian access ways pre-starts conducted to identify any dislodgement of soil or rock providing containment or support to excavation sides for unstable material. Yes No Comments:
WARNING: Trenches over 5 feet deep will use a protective system. Excavations > 4 feet deep may be considered Confined Spaces. Follow Confined Space Entry Procedures. Protective System Used (Circle One)? Yes No If Yes, which type? Shielding (Box) Shoring Sloping Benching Other (describe): Excavation Competent Person: Sign: Date: Contractor/Project Safety Rep: Sign: Date: Registered Professional Engineer (if required, 29 CFR 1926 Subpart P ): Sign: Date: Permit Completion: I hereby declare that the work is completed/ suspended, all workers under my control have been withdrawn and the site restored to a safe condition. Excavation Competent Person: Sign: Date:
again, both online and hard copy. Develop a process so that 95% of new staff members are trained in the handling of hazardous materials within their first month, by Dec. 31 2016 Work with Human Resources to establish a process for accurately tracking new hires to the University (by September 2016). Create a format to accurately capture all colleagues who attend a training program on hazardous materials (by September 2016) Report numbers of training program attendees (Starting October 2016) Determine new staff that did not attend program and ensure they are booked into next available session (starting November 2016) Process developed so that 100% of new staff members were trained in the handling of hazardous materials within their first month (by December 2016). Key action steps were addressed within stated timelines. School/Department feedback was very positive towards initiative and deemed successful by key stakeholders. Communicate work goals for all staff within your team by September 30 2016 Build and confirm goals for your position with supervisor by July 31 2016 Establish and conduct meetings with all direct reports and Work goals communicated to all staff by August 31, 2016 Conducted formal coaching check-in meeting with all staff
share your goals with them to cascade goals to the next level by August 31 2016 Performance goals for all staff finalized by September 31, 2016 Provide ongoing coaching to staff members and conduct formal review meeting with staff on a quarterly basis throughout the year. in your team every 3 months. Staff indicated a deep understanding of department goals as evidenced in strong staff feedback on survey. Provide work-unit budget for upcoming year by January 31, 2016, and manage annual budget on a monthly basis so that it is within 10% of forecast by fiscal year end. Analyze current year budget results to determine upcoming year anticipated budget and resource needs by December 31, 2015 Share findings with Director and recommendations by January 31 2016 Monitor current year budget expenses on a monthly basis, and encourage team members to understand the budget and track expenses closely ongoing. If budget is tracking to come over forecast, Work unit budget for upcoming year was prepared ahead of schedule. Managed annual budget on a monthly basis to within 5% of forecast by fiscal year end.
Total Possible Points: 48 Possible Pts Your Pts Information Sheet: background Blue 1 Information Sheet: Cells B3”B5 white with borders around each cell 2 Information Sheet: Cell A1Heading Font of current theme, Font 36, font color : White, BOLD 2 Information Sheet: Cells A3:A5 font color: white, bold, 16pts 2 Glove Sales Sheet: Totals 6 Glove Sales Sheet: Cells A1:H1 merged & centered, Title cell style, font:26 3 Glove Sales Sheet: Cells A2:H2 merged & centered, Heading 4 cell style, font:16 3 Glove Sales Sheet: Cells A3:A16 merged & centered, Accent 1 cell style, font:18, BOLD, Middle Aligned, Text Vertical 6 Glove Sales Sheet: Cells A18:A31 and A33:A46 same as above 2 Glove Sales Sheet: Cells C3:H3 centered 1 Glove Sales Sheet: Cells C4:H16 thousand separator, no decimal places 1 Glove Sales Sheet: Cells C18:H31 & C33:H46, same as above 2 Glove Sales Sheet: Cells B3:H16, table with Table Style Medium 2 table style, Header Row and Banded Rows, First Column and Last Column, filter arrows removed 7 Glove Sales Sheet: Cells B16:H16, fill color Yellow 1 Glove Sales Sheet: Cells B18:H31 and B33:H46, same as above 2 Glove Sales Sheet: Page Orientation – Landscape 1 Glove Sales Sheet: manual page break, A18 & A33 2 Glove Sales Sheet: First 2 rows repeated for print 1 Glove Sales Sheet: Header correct 1 Glove Sales Sheet: Footer correct 1 Named & Saved correctly 1
Excel 2007 : Basic Topic-Level Outline Prerequisites: Windows XP: Basic or equivalent experience Unit 1 : Getting started Topic A: 0 Spreadsheet terminology A-1: Discussing spreadsheet terminology Topic B: 0 Exploring the Excel window B-1: Examining Excel window components Topic C: 0 Getting help C-1: Using Help Topic D: 0 Navigating workbooks D-1: Navigating a worksheet Unit 2 : Entering and editing data Topic A: 0 Entering and editing text and values A-1: Entering text and values A-2: Editing text A-3: Using AutoFill to fill a series Topic B: 0 Entering and editing formulas B-1: Entering a formula by typing B-2: Entering cell references with the mouse B-3: Editing a formula Topic C: 0 Working with pictures C-1: Inserting and modifying a picture Topic D: 0 Saving and updating workbooks D-1: Saving a workbook D-2: Changing and updating a workbook D-3: Using the Compatibility Checker Unit 3 : Modifying a worksheet Topic A: 0 Moving and copying data A-1: Moving data in a worksheet A-2: Copying data in a worksheet A-3: Moving and copying data by using drag-and-drop A-4: Copying data by using the Clipboard Topic B: 0 Moving and copying formulas B-1: Moving a formula B-2: Copying a formula B-3: Using AutoFill to copy a formula Topic C: 0 Absolute and relative references C-1: Observing the limitations of relative references C-2: Using absolute references Topic D: 0 Inserting and deleting ranges, rows, and columns
D-1: Inserting a range D-2: Inserting rows D-3: Deleting a range Unit 4 : Using functions Topic A: 0 Entering functions A-1: Entering a SUM function A-2: Using the mouse to enter a function argument A-3: Inserting a SUM function Topic B: 0 AutoSum B-1: Using the AutoSum button Topic C: 0 Other useful functions C-1: Using AVERAGE C-2: Using MIN C-3: Using MAX C-4: Using COUNT and COUNTA Unit 5 : Formatting worksheets Topic A: 0 Formatting text A-1: Using the Font group to format text A-2: Formatting non-contiguous ranges A-3: Using the Format Cells dialog box to format text Topic B: 0 Formatting rows and columns B-1: Changing column width and row height B-2: Applying color to a row B-3: Setting alignment B-4: Applying borders to ranges B-5: Using the border-drawing pencil B-6: Using the Paste Special option B-7: Removing a border Topic C: 0 Formatting numbers C-1: Using the Number group to format numbers C-2: Exploring the Number tab Topic D: 0 Conditional formatting D-1: Creating a conditional format D-2: Editing and deleting a conditional format Topic E: 0 Copying formats and applying table formats E-1: Copying formats E-2: Using AutoFill to copy a format E-3: Applying cell and table styles E-4: Using Find and Replace to change cell formats Unit 6 : Printing Topic A: 0 Preparing to print A-1: Checking spelling in a worksheet A-2: Using the Research task pane A-3: Finding and replacing text A-4: Previewing a worksheet Topic B: 0 Page Setup options
Project 7-3: Modify the Appearance of a Worksheet Albert, the CEO’s administrative assistant at A. Datum, asked you to help him prepare documents to email to board members. Albert wants to enhance the appearance of the A. Datum sales worksheet, which will be viewed onscreen and may be printed. GET READY. Launch Excel if it is not already running. 1. OPEN 07 ADatum Appearance from the data files for this lesson. 2. On the PAGE LAYOUT tab, in the Page Setup group, click the Background button. The Insert Pictures dialog box opens. 3. Next to From a file, click Browse. The Sheet Background dialog box opens. 4. Navigate to the student data files folder, select 07 confidential.png, and then click Insert. 5. On the PAGE LAYOUT tab, in the Sheet Options group, uncheck the Gridlines View check box. The gridlines disappear from the worksheet. 6. Check the Gridlines View check box to restore viewable gridlines. 7. On the PAGE LAYOUT tab, in the Page Setup group, click the Dialog Box Launcher. The Page Setup dialog box opens. 8. Click the Margins tab. 9. Check the Center on page Horizontally check box and the Vertically check box. 10. Click Print Preview. Verify that the content is centered horizontally and vertically, and then click the Back button to exit Print Preview. 11. SAVE the workbook as 07 ADatum Appearance Solution and CLOSE the file.
Move one cell left in a worksheet. Left Arrow key Move one cell right in a worksheet. Right Arrow key Move to the edge of the current data region in a worksheet. Ctrl+Arrow key Enter End mode, move to the next nonblank cell in the same column or row as the active cell, and turn off End mode. If the cells are blank, move to the last cell in the row or column. End, Arrow key Move to the last cell on a worksheet, to the lowest used row of the rightmost used column. Ctrl+End Extend the selection of cells to the last used cell on the worksheet (lower-right corner). Ctrl+Shift+End Move to the cell in the upper-left corner of the window when Scroll Lock is turned on. Home+Scroll Lock Move to the beginning of a row in a worksheet. Home Move to the beginning of a worksheet. Ctrl+Home Move one screen down in a worksheet. Page Down Move to the next sheet in a workbook. Ctrl+Page Down Move one screen to the right in a worksheet. Alt+Page Down Move one screen up in a worksheet. Page Up Move one screen to the left in a worksheet. Alt+Page Up Move to the previous sheet in a workbook. Ctrl+Page Up Move one cell to the right in a worksheet. Or, in a protected worksheet, move between unlocked cells. Tab Format in cells: keyboard shortcuts To do this Press Format a cell by using the Format Cells dialog box. Ctrl+1 Format fonts in the Format Cells dialog box. Ctrl+Shift+F or Ctrl+Shift+P Edit the active cell and put the insertion point at the end of its contents. Or, if editing is turned off for the cell, move the insertion point into the formula bar. If editing a formula, toggle Point mode off or on so you can use arrow keys to create a reference. F2 Add or edit a cell comment. Shift+F2 Insert blank cells with the Insert dialog box. Ctrl+Shift+Plus (+) Display the Delete dialog box to delete selected cells. Ctrl+Minus (-) Enter the current time. Ctrl+Shift+colon (:) Enter the current date. Ctrl+semi-colon (;)
Drag the cursor over the second column of data to add the second array. Type a comma. You now see “=ttest(A2:A10, B2:B10,” in the cell. Type “1” or “2” for the “tail” value, then type another comma. Note that t-test “tail” refers to the tails on a line graph if the data were charted in a graph. You can use the value “1” if you are only interested in the data in one tail of the graph or “2” if both tails are important. Type “1,” “2,” or “3” for the “type” value, then type a “)” to complete the function. Note that the t-test “type” refers to the type of t-test you want to perform. Use the value “1” to perform a paired test. Use the value “2” to use a homoscedastic t-test with a two-sample equal variance. Type the value “3” to use a heteroscedastic t-test with a two-sample unequal variance. Press “Enter.” The function is now replaced with a value representing the result of the t-test.
Excel Access Review [1131941] 1. Tom wants to convert all text to lowercase. Which function should he use? 2. Column D in a spreadsheet contains employee ID Numbers. Which formatting would be most appropriate for the data in column D? 3. Steve would like to print only the worksheet he is currently working on. What print option should he choose? 4. Which command is used to remove manual page breaks from a worksheet area? 5. Kenyon would like to convert the cell range A1:F20 to a Medium 19 style. Which formatting style should he select? 6. In Microsoft Excel, which feature makes an exact replica of the cell data and format while keeping the original cell intact? 7. Sharon’s spreadsheet contains information about the number of
82. Larry has created a spreadsheet containing student grades. Which function would he use to return the current date and time in cell A1? 83. Which group on the Formulas Ribbon enables a user to specify when a formula is computed? 84. What type of formatting appears only when the value in a cell meets conditions specified by a user?
97. Where is the command to apply a fill color to a cell or range of cells in a worksheet? 98. Which command on the Home Ribbon joins selected cells into one and centers that content into a larger single cell? 99. Which of the following would you use to enter, calculate, manipulate, and analyze data such as numbers and text in Excel? 100. What method is the most efficient way to copy five separate formulas to adjacent cells simultaneously?
136. Chad needs to remove a student from the FBLA database. Which option should he choose? 137. In a table, which is a way of exclusively identifying each record in the database? 138. What type of database contains multiple collections of data that are related to one another? 139. Hank wants to add color to the header section of his form. Which formatting option would he use?
Using Excel 2010 Functions Getting help about using functions TODAY DAY / MONTH / YEAR SUMIF ROUND COUNT COUNTA COUNTIF PROPER / UPPER / LOWER CONCATENATE FV NPV PMT PV RATE HLOOKUP VLOOKUP IF AND OR ISERROR DSUM DMIN DMAX DCOUNT Using nested functions USING DATA TABLES Using a one input Data Table Using a two input data table PIVOT TABLES Creating a Pivot table Arranging data in the Pivot table Refreshing the Pivot table Summarizing data Grouping data within a Pivot table Filtering and sorting Pivot tables Using the Show Pages option SCENARIOS Using the Scenario Manager Showing a scenario Tracing precedent cells Tracing the dependents of a cell Displaying all formulas within a worksheet Adding comments MACROS Displaying the Developer tab Recording and running simple macros Viewing the macro code (VBA) Recording a more complex macro Basic editing of VBA code Reusing VBA code Macro security levels Changing the Quick Access Toolbar Macro icon Viewing an alternative scenario Create a scenario summary
11.3.2.5 to 11.3.2.17 is not supported within the software environment, these requirement are not applicable. 11.3.2.3 Use of accessibility services Where the software provides a user interface it shall use the applicable documented platform accessibility services. If the documented platform accessibility services do not allow the software to meet the applicable requirements of clauses 11.3.2.5 to 11.3.2.17, then software that provides a user interface shall use other documented services to interoperate with assistive technology. See sections 11.3.2.5 through 11.3.2.17 11.3.2.4 Assistive technology Where the ICT is assistive technology it shall use the documented platform accessibility services. 11.3.2.5 Object information Where the software provides a user interface it shall, by using the services as described in clause 11.3.2.3, make the user interface elements’ role, state(s), boundary, name, and description programmatically determinable by assistive technologies. Supported With Exceptions Certain advanced formatting information for graphical objects such as embossing or shadows may not be available to assistive technologies. When viewing help/F1 content, the video player loses focus when playback starts. 11.3.2.6 Row, column, and headers Where the software provides a user interface it shall, by using the services as described in clause 11.3.2.3, make the row and column of each cell in a data table, including headers of the row and column if present, programmatically determinable by assistive technologies. Supported 11.3.2.7 Values Where the software provides a user interface, it shall, by using the services as described in clause 11.3.2.3, make the current value of a user interface element and any minimum or maximum values of the range, if the user interface element conveys information about a range of values, programmatically determinable by assistive technologies. Supported 11.3.2.8 Label relationships Where the software provides a user interface it shall expose the relationship that a user interface element has as a label for another element, or of being labelled by Supported
Workbooks Using multiple workbooks Linking worksheets with 3-D formulas Linking workbooks Managing workbooks Advanced Formatting Using special number formats Using functions to format text Working with styles Working with themes Other advanced formatting Outlining & Subtotals Outlining & consolidating data Creating & using names Managing names Tables Sorting & filtering data Advanced filtering Working with tables Advanced Charting Chart formatting options Combination charts Graphical elements Documenting & Auditing Auditing features Comments in cells & workbooks Changing application settings Using built-in templates Creating & managing templates PivotTables & PivotCharts Working with PivotTables Rearranging PivotTables Formatting PivotTables Using PivotCharts Creating subtotals Protection Workgroup collaboration
Table 6: Shoe prices and estimated sales volumes From your earlier analysis of material and labor costs, and with new information provided, you know the following about the original option: Material costs total $50.15 per shoe. Labor costs total $7.33 per shoe. Overhead costs are calculated as 25% of the direct labor costs. Selling expense is calculated at $10 per pair of shoes, or $5.00 per shoe. Organizing the Workbook With the necessary information in hand, how should you organize the new budget workbook? Consider the Options worksheet created earlier (Figure 16). In this worksheet, all the inputs and outputs for the three design options are displayed on the same worksheet. This layout is easy to read and implement because there are a limited number of options and relatively simple calculations. But what if each design option had a completely different set of data inputs, or the values of the inputs varied from option to option? In such a case, it might be easier to create separate worksheets for each design option, or put all the inputs together on one worksheet and the outputs together on another. For the budget workbook, you need to organize data for four quarters, with each quarter containing data for the three different pricing alternatives. If you placed all the data on one worksheet, it would contain 12 separate sets of calculations and inputs. Although this is possible, such an organization would make the worksheet cumbersome to manipulate. Figure 18 illustrates and compares several possible ways to organize the budget workbook. Note the following: The first organization places all the inputs on one worksheet and all the outputs on another. This is a simple organization but, again, might be difficult to work with and could cause confusion, because it would be difficult to ascertain which set of inputs are associated with a particular output. The second organization is by quarter. The inputs and outputs are placed on a single worksheet, with each worksheet containing all three pricing alternatives for a specific quarter. The third organization is by pricing alternative. The inputs and outputs are placed on a single worksheet, with each worksheet containing all four quarters for a specific pricing alternative. Figure 18: Possible workbook designs
Merge Combines multiple cells into one cell Title across the top of a worksheet; Merge & Center centers contents in the merged cell TABLE 2–1 Positioning data within a cell Aligning Text You can align the contents of a cell horizontally and vertically within the cell. Horizontal alignments are left, centered, or right. Vertical alignments are top, middle, or bottom, as shown in Figure 2–3. Excel left-aligns all text and right-aligns all numbers. All data is bottom-aligned. You can select a different horizontal and vertical alignment for any cell. FIGURE 2–3 Horizontal and vertical alignments To change the alignment of a cell, select the cell and then click an alignment button in the Alignment group on the Home tab of the Ribbon. For other alignment options, click the Format Cells: Alignment Dialog Box Launcher to display the Alignment tab in the Format Cells dialog box. In the Text alignment section, click the alignment you want in the Horizontal or Vertical boxes, and then click OK. Merging and Centering Data You can also center cell contents across several columns. Select the cells, and then click the Merge & Center button in the Alignment group on the Home tab of the Ribbon. The selected cells merge , or combine into one cell, and the contents from the upper-left cell are centered in the newly merged cell.
relative cell reference A cell reference that adjusts the cell identifier automatically if you insert or delete columns or rows, or if you copy the formula to another cell. scope The location within which Excel recognizes a named range, which is either a specific worksheet or the entire workbook. If you set the scope of a named range to Workbook, you can reference the named range on any sheet in the workbook. value A number, a cell address, a date, text, or Boolean data in Excel. Regarding formulas, it is usually a number or cell address. variable A symbol or name that represents something else; it can be a cell address, a range of cells, and so on. Solutions for Step-by-Step Exercises The Formula Practice Solution solution file is located in Solutions/Lesson04 folder and is referenced in the following step-by-step exercises: Display Formulas The Order of Operations Solution solution file is located in Solutions/Lesson04 folder and is referenced in the following step-by-step exercises: Understand Order of Operations The Budget Basic Formulas Solution solution file is located in Solutions/Lesson04 folder and is referenced in the following step-by-step exercises: Create a Formula that Performs Addition Create a Formula that Performs Subtraction Create a Formula that Performs Multiplication Create a Formula that Performs Division The Budget Cell References Solution solution file is located in Solutions/Lesson04 folder and is referenced in the following step-by-step exercises: Use Relative Cell References in a Formula Use an Absolute Cell Reference in a Formula Use a Mixed Cell Reference in a Formula Refer to Data in Another Worksheet Reference Data in Another Workbook The Budget Ranges Solution solution file is located in Solutions/Lesson04 folder and is referenced in the following step-by-step exercises:
MAX(number1,number2…) The largest number in the range MIN(number1,number2…) The smallest number in the range STDEV.P(number1,number2…) The estimated standard deviation of the numbers in the range VAR.P(number1,number2…) The estimated variance of the numbers in the range TABLE 5–2 Commonly used statistical functions Step-by-Step 5.3 1. Click cell B15. On the Formula Bar, click the Insert Function button . The Insert Function dialog box appears. You want to find the average of values in the range B3:B7. 2. Next to the Or select a category box, click the arrow, and then click Statistical. The Statistical functions appear in the Select a function box. 3. In the Select a function box, click AVERAGE, and then click OK. The Function Arguments dialog box appears. 4. Next to the Number1 box, click the Collapse Dialog Box button . The Function Arguments dialog box shrinks to its title bar and Number1 box. 5. In the worksheet, drag to select the range B3:B7. The range reference appears in the Number1 box, as shown in Figure 5–7. TIP
adding it, you can drag the new worksheet to the position you want. Another option is to click the sheet tab of the worksheet that will Bookmark the new sheet. On the Home tab of the Ribbon, in the Cells group, click the Insert button arrow, and then click Insert Sheet. A new worksheet is inserted to the right of the sheet you selected. TIP You can also right-click a sheet tab, click Delete on the shortcut menu, and then click Delete in the message box to delete a worksheet. Deleting a worksheet permanently removes it and all its contents from the workbook. You cannot undo the action. To delete a worksheet, click the sheet tab for the worksheet you want to remove. On the Home tab of the Ribbon, in the Cells group, click the Delete button arrow, and then click Delete Sheet. If the worksheet is blank, the worksheet is permanently removed from the workbook without confirmation. If the worksheet contains data, a dialog box appears to confirm that you want to delete the worksheet, as shown in Figure 7–6. Click Delete to continue the action, or click Cancel to leave the worksheet in the workbook. After clicking Delete, you cannot undo the action. FIGURE 7–6 Message that appears when deleting a worksheet Step-by-Step 7.2 1. Click and drag the Corporate sheet tab to the left until the arrow points to the left of the Western sheet tab, as shown in Figure 7–4. 2. Release the mouse button. The sheet tab for the Corporate worksheet is first. 3. Right-click the Northern sheet tab, and then click Hide on the shortcut menu. The Northern worksheet and its sheet tab are hidden. 4. Right-click any sheet tab, and then click Unhide on the shortcut menu. The Unhide dialog box appears, as shown in Figure 7–5, listing the name of the hidden worksheet in the workbook. 5. Click Northern, if it is not already selected, and then click OK. The Northern worksheet and its sheet tab reappear. 6. Make sure the Northern worksheet is the active sheet.
2.4.5 Multiple Ways: More than one way is available to locate a Web page within a set of Web pages except where the Web Page is the result of, or a step in, a process. Supported 2.4.6 Headings and Labels: Headings and labels describe topic or purpose. Supported 2.4.7 Focus Visible: Any keyboard operable user interface has a mode of operation where the keyboard focus indicator is visible. Supported Principle 3: Understandable Information and the operation of user interface must be understandable. Guideline 3.1 Readable Make text content readable and understandable. Criteria Supporting Feature Remarks and Explanations 3.1.1 Language of Page: The default human language of each Web page can be programmatically determined. Supported 3.1.2 Language of Parts: The human language of each passage or phrase in the content can be programmatically determined except for proper names, technical terms, words of indeterminate language, and words or phrases that have become part of the vernacular of the immediately surrounding text. Not Applicable Guideline 3.2 Predictable Make Web pages appear and operate in predictable ways. Criteria Supporting Feature Remarks and Explanations 3.2.1 On Focus: When any component receives focus, it does not initiate a change of context. Supported 3.2.2 On Input: Changing the setting of any user interface component does not automatically cause a change of Supported
402 Closed Functionality 402.1 General. ICT with closed functionality shall be operable without requiring the user to attach or install assistive technology other than personal headsets or other audio couplers, and shall conform to 402. Criteria Supporting Feature Remarks and Explanations 402.2 Speech-Output Enabled. ICT with a display screen shall be enabled for full and independent use by individuals with vision impairments. Not Applicable 402.2.1 Information Displayed Speech output shall be provided for all information displayed on-screen. Not Applicable 402.2.2 Transactional Outputs. Where transactional outputs are provided, the speech output shall audibly provide all information necessary to verify a transaction. Not Applicable 402.2.3 Speech Delivery Type and Coordination. Speech output shall be delivered through a mechanism that is readily available to all users, including, but not limited to, an industry standard connector or a telephone handset. Speech shall be recorded or digitized human, or synthesized. Speech output shall be coordinated with information displayed on the screen. Not Applicable 402.2.4 User Control. Speech output for any single function shall be automatically interrupted when a transaction is selected. Speech output shall be capable of being repeated and paused. Not Applicable 402.2.5 Braille Instructions. Where speech output is required by 402.2, braille instructions for initiating the speech mode of operation shall be provided. Not Applicable
shall be programmatically determinable. 502.3.7 Hierarchical Relationships. Any hierarchical (parent-child) relationship that a component has as a container for, or being contained by, another component shall be programmatically determinable. Supported 502.3.8 Text. The content of text objects, text attributes, and the boundary of text rendered to the screen, shall be programmatically determinable. Supported 502.3.9 Modification of Text. Text that can be set by the user shall be capable of being set programmatically, including through assistive technology. Supported 502.3.10 List of Actions. A list of all actions that can be executed on an object shall be programmatically determinable. Supported 502.3.11 Actions on Objects. Applications shall allow assistive technology to programmatically execute available actions on objects. Supported 502.3.12 Focus Cursor. Applications shall expose information and mechanisms necessary to track focus, text insertion point, and selection attributes of user interface components. Supported 502.3.13 Modification of Focus Cursor. Focus, text insertion point, and selection attributes that can be set by the user shall be capable of being set programmatically, including through the use of assistive technology. Supported 502.3.14 Event Notification. Notification of events relevant to user interactions, including but not limited to, changes in the component’s Supported
Exercise 51 Data validation If a user accidently enters the wrong data or data is missing we want to be able to set in place some rules of checking that information, this is known as validation. Navigate to the VBA Editor window we are going to set up the following validations. sets 2 values in the drop down list as soon as you start typing in to employee name. “select from list” Private Sub txt_employee_name_Change() txt_department.Value = "select from List" txt_job.Value = "select from List" End Sub Checks to see if there is text in Employee Name if not a message box is displayed , when you click ok on the message box, focus is placed back to the cell to re-enter the data Private Sub txt_employee_name_Exit(ByVal Cancel As MSForms.ReturnBoolean) If IsNumeric(txt_employee_name) = True Then MsgBox "text entry only" Cancel = True End If End Sub Checks to see if text in “Department” equals “select from list” if yes a message box is displayed “select from list” , when you click ok on the message box, focus is placed back to the cell to re-enter the data Private Sub txt_department_Exit(ByVal Cancel As MSForms.ReturnBoolean) If txt_department.Value = "select from List" Then MsgBox "Please select item from list" Cancel = True End If End Sub
the execution of the code Watch Window Monitor values of specified variables and expressions while the code is running Immediate Window Test your output by assigning different values to variables or expressions Locals Window Monitor all the declared variables of the procedure currently running Exercise 55 Debugging Break mode and Breakpoint Whenever a run time is detected in VBA the execution of the program pauses and the program enters what’s called break mode. At this point in time the line of code causing the problem is displayed and highlighted in yellow, this helps you trace and debug the error. When you’re in break mode you can examine also the variables and properties by pointing to them. You can set your own breakpoint in the code to pause at a specific place, when the executed code reaches the breakpoint VBA switches into break mode. Breakpoints are temporary markers and are not saved along with the code. To insert or remove a breakpoint place the insertion point in the code you want to insert the break point and use one of the following methods. Choose debug, toggle breakpoint Press F9 Click the toggle breakpoint button on the debug toolbar ( if not open then, view, toolbars, debug.
Range(Cells(1,1),Cell(10,5)) Range A1 to E10 Range(“A:A”) Column A [A:A] Column A Range(“5:5”) Row 5 [5:5] Row 5 Sheets(“Sheet1”) Sheet called Sheet1 Worksheets(“Sheet1”) Worksheets called Sheet1 Sheets(2) Second worksheet in workbook Worksheets(3) Third worksheet in workbook Worksheets(“Sheet1”).Range(“A1”) Cell A1 in Sheet1 [Sheet1].[A1] Cell A1 in Sheet1 ActiveSheet.Next The sheet after the active sheet Workbook(“Test”) Workbook file called Test.xls Navigation in a worksheet using Offset Sub MoveDown() ActiveCell.Offset(1, 0).Select End Sub Sub MoveUp() ActiveCell.Offset(-1, 0).Select