NCC011 10 - Introduction to Health Care Spreadsheets February 2017

Week 1 Overview

Get help using 'Week 1 Overview'
This week we will introduce what a spreadsheet is, as well as the basics of formatting spreadsheets.  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).
    Name Description Status Source
    1 What is a Spreadsheet? - Notes Required 1 What is a spreadsheet.pdf Edit 1 What is a Spreadsheet? - Notes Delete 1 What is a Spreadsheet? - Notes
    2 Formatting Basics - Notes Required 2 Formatting Basics.pdf Edit 2 Formatting Basics - Notes Delete 2 Formatting Basics - Notes
    2 Formatting Basics - Data Set ('Patients Rooms') Required Patients Rooms.xlsx Edit 2 Formatting Basics - Data Set ('Patients Rooms') Delete 2 Formatting Basics - Data Set ('Patients Rooms')
    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 What is a Spreadsheet? - Video Tutorial

I encourage you to carry out the steps in the lectures while following the notes and pausing the video as needed.
 

2 Formatting Basics - Video Tutorials

I encourage you to carry out the steps in the lectures while following the notes and pausing the video as needed.
 
If you click on the named link to the left and the video does not stream properly for you you may need to use the download link to the right to save the video file to your computer and then play it from the saved file. 
 
 
 
 
 
 
 

Assignments

Get help using 'Assignments'

  • 1 What is a Spreadsheet

    Name Description Status Source
    1 What is a Spreadsheet Assignment
    - Your assignment for the first lesson is to open a new spreadsheet, and recreate this document.
    - After completion, save the excel file as YourName Week1a Assignment, and submit via the appropriate dropbox located under the 'Coursework' tab located at the left of the course page. 
         		Required 1 What is a spreadsheet - Recreate this document.png Edit 1 What is a Spreadsheet Assignment Delete 1 What is a Spreadsheet Assignment
    Self Evaluation
    Review the homework "solution" tutorial, complete the self evaluation, save the file as YourName Week1a 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.

  • 2 Formatting Basics

    Name Description Status Source
    2 Formatting Basics Assignment
    - Format the data set to your level of satisfaction ~ 
    - Adjust the row height in the first row, and wrap the text in the cell C1 because there is so much.
    - Include borders, font adjustments, alignments, and merge the name cells together to form a single name heading.
    - Sort the data as you see fit, then include Dr. Evil into the data set, who was treated for 5 days.
    - Save the file as YourName Week1b Assignment and submit via the appropriate dropbox located under the 'Coursework' tab located at the left of the course page. 
         		Required 2 Tretment Length .xlsx Edit 2 Formatting Basics Assignment Delete 2 Formatting Basics Assignment
    Self Evaluation
    Review the homework "solution" tutorial, complete the self evaluation, save the file as YourName Week1b 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'