NCC013 02 - Advanced Health Care Spreadsheets

Week 1 Overview

Get help using 'Week 1 Overview'
This week we will learn how to modify an existing macro to do additional things.  You are encouraged to read the lecture notes while watching the video tutorials and carrying out the steps simultaneously.  You will also practice these steps in the corresponding homework assignment, then view the homework video and evaluate your own performance.

Lecture Notes and Data Sets

Get help using 'Lecture Notes and Data Sets'

  • Lecture Notes and Data Sets

    I encourage you to open the data set and carryout the steps in the lesson while following the notes and watching the video (pausing as needed).
    1 More Macros - Notes
    Required
    1 More Macros.pdf
    1 More Macros - Data Set
    Required
    1 More Macros.xls
    While focused on a reorder icon, press the Enter key or spacebar to "select" the icon. While a reorder icon is selected, pressing the up and down arrows will change the order of the selected item within the list. Pressing Enter key or spacebar again will drop the selected item at that location in the list.
While focused on a reorder icon, press the Enter key or spacebar to "select" the icon. While a reorder icon is selected, pressing the up and down arrows will change the order of the selected item within the list. Pressing Enter key or spacebar again will drop the selected item at that location in the list.
Edit the following settings for all selected Resources.
Select a start and end date and time
Start: Start:
End: End:

Lecture Video Tutorials

Get help using 'Lecture Video Tutorials'

1 More with Macros - Video Tutorial

I encourage you to carry out the steps in the lectures while following the notes and pausing the video as needed.
 
 
 
    Note: Toolbars in Windows 2007 (windows calls it the ribbon) cannot be customized as they can be with Mac computers.  This video has been converted if you wish to view the process.

Assignment

Get help using 'Assignment'

  • 1 More Macros

    Name Description Status Source
    1 More Macros Assignment
    - Modify the existing macro to use a green font and a light red fill (use the color index provided in the notes - or - below in cells N12 and N13).
    - Apply the macro to format both first and last names for those with a last name starting with B.
    - After completion, save the excel file as YourName Week1 Assignment, and submit via the appropriate dropbox located under the 'Coursework' tab located at the left of the course page.
         		Required 1 More Macros.xls Edit 1 More Macros Assignment Delete 1 More Macros Assignment
    Self Evaluation
    Review the homework "solution" tutorial, complete the self evaluation, save the file as YourName Week1 Evaluation and submit via the appropriate dropbox under the 'Coursework' tab located at the left of the course page.
    Note: each self evaluation is the same, so if you keep the blank file somewhere accessible, you do not need to download it after every assignment. 
         		Required Self Evaluation.xlsx Edit Self Evaluation Delete Self Evaluation
    While focused on a reorder icon, press the Enter key or spacebar to "select" the icon. While a reorder icon is selected, pressing the up and down arrows will change the order of the selected item within the list. Pressing Enter key or spacebar again will drop the selected item at that location in the list.
While focused on a reorder icon, press the Enter key or spacebar to "select" the icon. While a reorder icon is selected, pressing the up and down arrows will change the order of the selected item within the list. Pressing Enter key or spacebar again will drop the selected item at that location in the list.
Edit the following settings for all selected Resources.
Select a start and end date and time
Start: Start:
End: End:

Homework Solutions

Get help using 'Homework Solutions'
It is  strongly  encouraged that you attempt the entire assignment before viewing the solution video.