Concept Map Assignment

Order ID 4211189692
Subject Nursing
Topic Concept Map Assignment
Type Essay
Writer level College
Style APA
Sources / references 2
Language English(U.S.)
Description / paper instructions

Attached you will find the instruction paper for this assignment. Please be careful with the citation. I recently had a problem with some of the order that I placed here and I am currently being charged of plagiarism because the writers copy and paste information for web sites, That can not happen again because I am in 6 month probation. So pay attention to that. I selected 2 pages because of the word count, but everything must be done in one page. If you have any question, please contact me, and I will reply asap. Thank you for working in my assignment.


Exercise Ch10-5: Level 3- Daily List.

One of Kiola’s colleagues in HR uses an Excel worksheet to keep track of daily information regarding appointments and visitors expected at the company’s campus. Each morning this information is printed and distributed to each of the receptionists and administrative assistants. The receptionists are given one version and the administrative assistants another.


Kiola’s colleague would like your help in creating a macro to print out the worksheet in the two required formats. To make it easy for anyone to produce the appointment and visitor lists, HR would like the capability of launching the macro from a shortcut key sequence, a macro button on a custom ribbon tab, and a custom button directly on the worksheet.


  1. Open the workbook named xlsx located in the Chapter 10 folder, and save the file as

the macro-enabled workbook 10-5-DailyList-Monday-YourName.xlsx.

If the DEVELOPER tab is not already visible, add it to the ribbon.


TROUBLESHOOTING: In order to complete this step, the macro settings on your computer must be enabled. If you receive a Security Warning saying macros have been disabled or the file can’t be saved as a macro-enabled workbook, open the Trust Center to check the macro security settings. If you don’t have access to the Trust Center, contact your instructor or computer support person for assistance.


  1. Enter your name and current data in the cells highlighted in yellow.


  1. Plan the macro steps and then record the macro, naming it PrintText, and saving it in the current workbook. Assign the macro to the Ctrl+Shift+F shortcut key combination.


Enter a description for the macro. Perform the following steps while recording the macro: For the first printout, specify:


  • Custom header with Visitors – Admin List in the top center and page number on the top right
  • Landscape orientation
  • Print document to default printer (printer currently selected)

For the second printout and to reset the worksheet, make the following modifications:

  • Hide columns G and H
  • Change the custom header to Visitors – Receptionist List
  • Set the orientation to Portrait
  • Print the document to the default printer
  • Unhide columns G and H


  1. Run the macro to test it. If it doesn’t perform all the tasks you planned, re-record the macro using the same name.


(Hint: You must enter a new shortcut key because Ctrl+Shift+F has already been assigned to the first macro you recorded.)


  1. Add a custom button on the Monday worksheet with the label PRINT VISITOR LISTS to run the macro. Place it at the top of the worksheet around columns F and G.


  1. Add a macro button named Print Visitor List to a new ribbon tab named CUSTOM in a group called Macros. Place this new ribbon tab at the end of all existing tabs.


Add the command buttons to Hide Columns and to Unhide Columns in this ribbon group.





(Hint: Search for the commands Hide Columns and Unhide Columns from the All Commands list.)


  1. Save the workbook, and then test the macro buttons.


  1. View the code in the Visual Basic Editor. Copy the code starting from the beginning (Sub) until the first End With statement. (Hint: Select the code to highlight it and then use Ctrl+C to copy the code to the Clipboard.) Exit the VBA Editor, and then paste (press Ctrl+V) the code onto a new worksheet named code.


  1. Save and close the 10-5-DailyList-Monday-YourName.xlsx



Exercise Ch10-6: Level 3- Projected Sales and Commissions for CKG Auto.


You are working in CKG Auto’s Sales Department as an analyst. The sales manager, Leroy Mason, wants to automate the worksheet he uses to calculate monthly sales commissions so that others can use it. CKG Auto pays each salesperson a base salary plus a commission.


This commission value has changed so this value for all new entries should be 7% of the sales amount. Leroy asks for your help in ensuring users enter valid data and do not change or delete the sales data the workbook already contains. He also wants to include a chart comparing the total sales of each salesperson without revealing their names.


Complete the following:


  1. Open the workbook named xlsx located in the Chapter 10 folder, and then save the file as


the macro-enabled workbook 10-6-July-Sales-YourName.xlsx.


  1. Create a new worksheet named SalesRepSummary. On this new worksheet, list the name of each salesperson and summarize each salesperson’s total sales and total commissions based on the data listed on the SalesList


(Hint: Use a PivotTable or the Remove Duplicates button in the Data Tools group on the DATA tab to remove the duplicate names quickly.)


  1. Examine the SalesEntryForm worksheet and correct its formula error. Create validation rules so sales rep names appear in a drop-down list using the data on the SalesRepSummary worksheet, sales dates are limited to valid dates in 2016, and sales amounts must be positive values. Annotate the validation rules so users entering the data will know what data to enter and what is allowed.


  1. Create a macro named SubmitSales with shortcut key Ctrl+Shift+S, assigned to this workbook. The purpose of the macro is to automate the moving of the data entered in the sales entry form to the SalesList worksheet and then to clear the data in the sales entry form. Create a custom button on the SalesEntryForm worksheet with the label Record Sale that automatically launches this macro. For best results, use the following procedure:


  • Before recording the macro, assign range names to the following cells:








Apply the Use Relative References option to make sure that when recording your macro, the insertion point is relative to the active cell.


(Hint: The Use Relative References button in the Code group on the DEVELOPER tab toggles this feature on and off. Be sure the button is highlighted in green to indicate that the feature is on before you begin recording the macro.)


  • Enter some sample data into the sales entry form.


  • Start the macro, assigning the appropriate name and macro shortcut key. Enter a brief description.


  • Open the Go To box by pressing the F5 function key, and then select top in the list of range names to move the starting point on the SalesList worksheet to cell A5.
  • Press Ctrl+↓ to move the active cell to the bottom of the list. Then, using the arrow keys,

move the active cell down one row to the first empty cell. Type = Sales_Rep_Name. Move to the next column where the user will enter the sales date, and then type Sales_Date. Repeat this procedure to enter the sales amount and commission using their corresponding range names.

  • Copy the cells with the formulas you just entered, and then use the Paste Special – Values option to paste the cells in the same location. This past action removes the formulas, but keeps the values that appear in the data entry form.
  • Go to the Sales_Rep_Name range, and delete the entry. Move down one cell, and delete the sales date and sales amount. You must clear the input data to leave the cells ready for the next user to enter new data. Press the Esc key.
  • Stop recording.
  • Create a custom macro button called Record Sale on the SalesEntryForm worksheet that automatically launches this macro.
  • Remove the sample data from the SalesList worksheet that you used when writing the macro.
  1. Create a column chart on a separate worksheet named SalesChart that shows the sales by sales rep, but do not show the sales rep name. Excel will assign numbers to each column.
  2. Test the workbook formulas, macro, and chart to ensure they all work correctly. Be sure to try invalid values to be sure data validation is working correctly. Return the SalesList to its original state when testing is complete. Note the following:


  • Does the data on the SalesRepSummary worksheet update correctly?
  • Modify the formula ranges to accommodate up to 100 entries.
  • Place a comment in cell SalesList!A102 warning that to include this entry you will need to update formulas on the ValesRepSummary
  1. Insert a worksheet named Documentation. Enter your name and date as the user who created the workbook and the one who last updated it. Identify the purpose of the workbook, explain how the workbook should be used, identify and explain worksheets, and identify and explain the workbook macro.
  2. Protect the workbook so that users cannot add or delete worksheets. Protect the SalesEntryForm worksheet, allowing data entry for only the sales rep name, sales date, and sales amount. Do not use passwords.
  3. Add the following sales using the entry form, each time running the macro to copy the information to the sales list
  4. Save and close the 10-6-July-Sales-YourName.xlsx





The post Concept Map Assignment appeared first on UK Superior Essays.

We offer homework writing services with you in mind. Our homework help service is made to meet your demands, whatever the challenge. Every paper is written from scratch by experts in your field. You can order essays, discussion, article critique, coursework, projects, case study, term papers, research papers, reaction paper, movie review, research proposal, capstone project, speech/presentation, book report/review, annotated bibliography, and more.

Your Writing Help Service in a Nutshell