Videos Available for Excel and Access Modules covered in Class
https://www.youtube.com/channel/UCDCvJ4rWrUEzgPQgAc-GevQ
This link will take you to a site that has videos for all of the Modules that we will cover in class.
To start - Select "Playlist". These playlists group the videos by the Module they cover and the device that
they are best formatted for. There are videos formatted to work with various screen resolutions and
also specific devices.
HD1080p format is designed to work with a screen resolution of 1920x1080.
HD720p format is designed to work with a screen resolution of 1280x720.
HD480p format is designed to work with a screen resolution of 640x480.
iPhone4 format is designed to work with the iPad and iPhone4.
iPhone5 format is designed to work with the iPad2 and iPhone5.
Each module is divided into multiple segments. This will allow you to pick the specific portions of the
modules that you would like to review and not have to watch the entire module if it is not needed.
These videos can be used to help you if you missed class or just need to review a topic that was covered.
You may want to try to play the video on your smartphone or a tablet (some device other than the laptop
you are using for excel). That will allow you to watch the video and practice the tasks in Excel on your
laptop at the same time.
The files that are being used in the Modules were all downloaded from the Q drive at the beginning of the
Wednesday, November 9, 2016
Wednesday, August 10, 2016
SAM Projects homework cases
When you do the SAM Projects homework, you will go to Canvas, Modules, SAM. There are 10 Excel cases, and 5 Access cases assigned for K201.
Before the class due (see daily schedule for your section) you need to finish and submit the assigned case. When you click on the assignment link .. you will click the Start button to get to the Instruction file, the start file, and the submission area. You can open this link as many times as you wish (the submission link is the only area limited to 5 attempts).
1. Click and open the instruction file (some students prefer to have a printed hard copy to work from)
2. Download a copy of the start file in step 2 by clicking on the link, and choosing Save As (it is wise to save it to the K201 Fall 2016\Excel 2016\Excel SAM Projects folder on your USB drive - so it's easy to find when you are ready to submit). Do NOT simply open... or it will be a temp file and your work will NOT be saved!!
3. Follow all the instructions in the step 1 instruction document, save your changes to the downloaded start file from step 2, and work until you believe all steps are correct. Then Save the changes... and return to SAM Projects, step 3 for that case... Browse for your saved work, and the Submit it for grading.
4. From Canvas, Modules, SAM Projects Reports, click the Reports button at the top, then the case link to see how you did. In the report select the Files icon to get specific feedback on each step (red x means you did not earn those points... and you can go back to your Excel file, make corrections to that step(s), save the changes and re-submit to SAM Projects again... up to 5 times per case ... or e-mail your instructor to reset some attempts if you need more tries). You do not need to start over to re-submit.
Remember the K201 Department paid tutors are available to help in the MAC lab... (see the Blog or Canvas Announcement for details of days/times).
Please let your instructor or Mrs. Nemeth (mnemeth@iupui.edu ) know if you have SAM account questions.
Before the class due (see daily schedule for your section) you need to finish and submit the assigned case. When you click on the assignment link .. you will click the Start button to get to the Instruction file, the start file, and the submission area. You can open this link as many times as you wish (the submission link is the only area limited to 5 attempts).
1. Click and open the instruction file (some students prefer to have a printed hard copy to work from)
2. Download a copy of the start file in step 2 by clicking on the link, and choosing Save As (it is wise to save it to the K201 Fall 2016\Excel 2016\Excel SAM Projects folder on your USB drive - so it's easy to find when you are ready to submit). Do NOT simply open... or it will be a temp file and your work will NOT be saved!!
3. Follow all the instructions in the step 1 instruction document, save your changes to the downloaded start file from step 2, and work until you believe all steps are correct. Then Save the changes... and return to SAM Projects, step 3 for that case... Browse for your saved work, and the Submit it for grading.
4. From Canvas, Modules, SAM Projects Reports, click the Reports button at the top, then the case link to see how you did. In the report select the Files icon to get specific feedback on each step (red x means you did not earn those points... and you can go back to your Excel file, make corrections to that step(s), save the changes and re-submit to SAM Projects again... up to 5 times per case ... or e-mail your instructor to reset some attempts if you need more tries). You do not need to start over to re-submit.
Remember the K201 Department paid tutors are available to help in the MAC lab... (see the Blog or Canvas Announcement for details of days/times).
Please let your instructor or Mrs. Nemeth (mnemeth@iupui.edu ) know if you have SAM account questions.
Tuesday, May 24, 2016
Wednesday, January 6, 2016
Excel and Access 2013 Podcasts
https://www.youtube.com/channel/UCDCvJ4rWrUEzgPQgAc-GevQ
This link will take you to a site that has videos for all of the Tutorials that we will cover in class.
To start - Select "Playlist". These playlists group the videos by the Tutorial they cover and the device that they are best formatted for. There are videos formatted to work best on smartphones, tablets, and laptops.
Each tutorial is divided into multiple segments. This will allow you to pick the specific portions of the chapter that you need additional review of.
Enjoy!
This link will take you to a site that has videos for all of the Tutorials that we will cover in class.
To start - Select "Playlist". These playlists group the videos by the Tutorial they cover and the device that they are best formatted for. There are videos formatted to work best on smartphones, tablets, and laptops.
Each tutorial is divided into multiple segments. This will allow you to pick the specific portions of the chapter that you need additional review of.
Enjoy!
Subscribe to:
Posts (Atom)