CIS Information Systems

Current Location CIS105056VA016-1146-001 Intro To Info Syst Course-to-Course Navigation Week 8 Hide Course Menu Skip to Course Content Skip to Top Frame Tabs Menu Management Options Refresh Display Course Menu in a Window Folder View List View Course Menu: CIS105056VA016-1146-001 (Intro To Info Syst) Course Entry Page Course Home Student Center Mobile Learn Announcements Email Gradebook MS Office Wiki Class Introductions Week 1 Week 2 Week 3 Week 4 Week 5 Week 6 Week 7 Week 8 Week 9 CIS Tutoring Week 8 Skip to Course Menu Skip to Top Frame Tabs Content Week 8 Objectives Week 8 Course Learning Outcome Upon completion of this lesson, you will be able to: Use spreadsheet modeling techniques to create and format spreadsheets. Instructor Insights The discussion this week on spreadsheet modeling techniques usually causes a little concern because people are not familiar with this topic. Please spend some extra time this week reviewing your reading assignment (Chapter 15 and 16 in our text) and practicing in Excel to help you better understand the discussion question. Creating a user defined function: http://www.wikihow.com/Create-a-User-Defined-Function-in-Microsoft-Excel If you know Visual Basic: http://www.exceldigest.com/myblog/2011/04/23/how-to-create-a-user-defined-function-in-excel-2007-or-excel-2010/ Definition of user defined function: http://spreadsheets.about.com/od/f/g/function_def.htm Week 8 Lecture 1 Week 8 Lecture 1 Lectures require Flash enabled browsers. CourseMate Chapter 15 Click the link above to access the On Your Own, Beat the Clock, Flashcards, and Videos. Please note, these are non-graded supplemental resources. Week 8 Lecture 2 Week 8 Lecture 2 Lectures require Flash enabled browsers. CourseMate Chapter 16 Click the link above to access the On Your Own, Beat the Clock, Flashcards, and Videos. Please note, these are non-graded supplemental resources. Week 8 Discussion _______________ Week 8 Homework On Your Own 16-1 Week 8 Supplemental Instruction - Need Additional Help? If you are using the Blackboard Mobile Learn IOS App, please click "View in Browser." Click here to access additional help with this week's content through Supplemental Instruction. What is Supplemental Instruction? Click here to learn more about Supplemental Instruction. Important to Note Supplemental Instruction is an optional service students are encouraged to take advantage of. Students participating in the Supplemental Instruction sessions do not earn academic credit for this service and activity within the session does not satisfy any standard weekly attendance requirement for the course. Logging In When attempting to access the Supplemental Instruction, if you receive an error stating "Access Denied" then please do the following: Close the window session that you are currently in to go back to your course. Click on the "My Institution" tab. Look for the "Course Catalog" module (bottom of the page) and click on the "Supplemental Instruction" link. The supplemental instruction course will be displayed. Click on the chevron next to the course and click on "Enroll" Click on "Submit" and you will see a verification message of your enrollment. Click "OK" and you will be placed in the supplemental instruction course. Select the appropriate sessions you are planning to attend.