0. We will meet in the blue lab (3rd floor library) for the next 6 Thursdays. I will not be taking attendance and am here to help you complete the labs. If you do them on your own, that’s fine.
** EXCEPTION –
I have to go out of town so on Tuesday Feb 18th you should do the 1st lab on your own
I will do the lecture on Appendix A on Thursday Feb 20th in the regular classroom
1. Signup for simnet at UMB.SIMNETONLINE.COM
(use code, or signup for courtesy access) Bring headphones to Lab. Be sure to choose “Frankel” section
2. Work through Simbook – Excel Lab 1
(show me, guide me, let me try)
–> the LET ME TRY is graded part!
– Use chrome, safari or firefox for best results in lessons
– if you run into trouble, don’t worry.
3. Work through Project – Excel Lab 1 Skills Review
– Practice only (not graded)
– Save your work to desktop / flash drive
4. Work through Project – Excel Lab 1 SUBMIT Challenge
– Counts! But only highest grade so resubmit if needed
– Save your work to desktop
(email if you don’t finish it)
– A tricky concept this week is the difference between absolute and relative addressing. Absolute addressing is used to make copy/paste work properly when using formulas where one of the variable cells is a “constant” somewhere in the workbook. I will demonstrate this in class if you can’t figure it out.
– if you have a mac, there is no “quick analysis” tool. This is just a shortcut for doing sums.
Ignore due dates in simnet – all 5 excel labs are due April 6th. As a guideline, complete lab 1 this week, lab 2 next week, etc.. don’t get too far behind.
You can work on this from home, either on your own computer or with Office365 (available from within UMB email) or via UMass’ virtual computer (see below). If you work on it on your own computer or mac, you will need to save the file on an Excel 2021 machine before submitting.
All UMB students can download a free version of Excel via webmail!! From your email, click the “Office 365” link (top left), and then “Install Office Apps” (top right). Note you may need to upgrade your Mac Operating System to get this to run. I can help a little here, but I’m not really a Mac expert. The IT helpdesk (3rd floor of library) is a great resource.
Virtual computer Instructions:
– go to https://www.umb.edu/it/cloudpc
– enter your current UMB id & PW (twice actually)
– Click on the “general desktop” and Voila! You can now run office 2019 from the Virtual session.
– You will need to deal with onedrive to work on your projects. Personally, I hate onedrive – it’s cumbersome but does work.