Data Analysis with Excel

 How do you create a link to your online lecture on the main menu? See the following:  1. Click on the add link, the '+' icon, on the upper right side of your page 2. From the list click on 'Tool link' 3. Fill in the open window for name 'Online lecture', for type choose 'Blackboard Collaborate Ultra', then tick on 'available to users', and finally press submit 4. The new link 'Online lecture' will be added at the end, and you can drag it to place up first.  

Install Python and its libraries for Windows users: 1. Install Python latest stable version from the following (click here  official website ). For example, you can use the x86-64 executable installer 2. Install all useful libraries (incl. scipy, pandas, numpy) in a single command:        a. Open your command prompt by typing 'cmd' on your Windows home screen      b. Copy and paste the following command line in your 'Command Prompt' and press enter.      python - m pip install -- user numpy scipy matplotlib ipython jupyter pandas sympy nose   3. As a text editor to type in your programs, you can install Notepad++ from (click here  its official website ). 4. To configure Notepad++ with Python you can watch the short Youtube video You are ready to GO!

Consider having the following raw data (on the left). How do you plot the average monthly salary of your employees based on gender, age, and function (plot on the right)? See the steps below. 1. You need to categorize your raw data into the following table:. To do that:      a. S ort your data according to age from smallest to largest,      b. Use pivot-table for each range of age (eg, 20-30, 30-40, etc.),       c. Copy and paste the averages into the table.    2. Select the previous table as a whole and click "Insert" from the menu. You may choose the bar chart to get the following plot: NB. To add a secondary axis to this plot see  Add-second-y-axis-to-right-of.html

 How to mark handwritten student papers? 1. Ask your students to submit a pdf file of their work. The mobile App "Tap Scanner" is easy to do that with. 2. Open the file in "Adobe Acrobat Reader DC" and click on "Comment" on the left side of the figure below. 3.  Click on 'Pen' and select the color and pen's sickness of preference (See 2 in Red)   4. Correct the exam using your mouse or a writing pad connected to your computer. Erase your written text if you like. Save the file (in Red) and send it back to your student for the feedback! 5. You can also type text by pressing the "T" on the menu.