Lab 10: Excel - Analyzing and Reporting Data#

In this Lab, we will shift gears a bit and you will be working with Microsoft Excel to practice your data analysis skills.

Submission Instructions#

Once you are done with his lab, you will need to submit your repository for grading on Gradescope.

NOTE: If you make any changes to your GitHub repository, you MUST re-submit on Gradescope to make sure we grade the latest version of your repository. You may submit on Gradescope as many times as you like.

I have recorded a video with some instructions on how to submit your lab on Gradescope:

Click here to view the video in a new browser window.

Those same instructions are summarized here in text:

  1. Accept the GitHub Classroom assignment for thhis lab (likely already done)

  2. Commit and push your change to GitHub.

  3. Log in to your Canvas course, and click Gradescope in the left sidebar.

  4. You will be enrolled in the course and receive a confirmation email. Gradescope will also open in a new window/tab with your course dashboard and all active assignments.

  5. If this is your first time using Gradescope, you will need to set a password:

In the confirmation email you received from Gradescope, click the set your password link. Enter the same password in the password and password confirmation fields, and click Set Password.

  1. You can now access Gradescope through your Canvas course.

  2. When in Gradescope, click the course and you will see a list of assignments. Select the assignment you want to submit.

  3. Before you can start submitting work, you may see a dialog box telling you that your assignment will be timed. Read the information carefully, and click Start Assignment only when you’re ready for the countdown to begin.

  4. The first time you do this, you will need to sync your GitHub account with Gradescope, and GRANT permission to our GitHub organization.

  5. Once you log in and link your GitHub account, you should find the repository and submit it to Gradescope.

  6. Gradescope will email you a confirmation of your submitted work, with a link to the submission.

Note: If you make any future commits to this repository, you will need to re-submit on Gradescope. You may resubmit as many times as you like before the deadline + grace period, but you will not be able to commit after this time!

You are all done with this Lab!#

Please add your screenshots in the main directory (./) and they will automatically be imported into Gradescope. Any files added to the images directory will not be graded.

Congratulations!