CISC 1050 Online: Introduction To Computer Applications .

A MAC cannot be used to submit projects or exams on ExcelChapter 5 or on any projects or exams in Access. Make sureto submit these on a PC.Blackboard is NOT being used for this course. Submit any questions totbaum@sci.brooklyn.cuny.edu. I will communicate to you via email.Assignments may not be submitted via Cloud. photo, DropBox,OneDrive or ChatBox or similar file wrappers; only within SAM as Word,Excel or PowerPoint files, or as Access databases.You must obtain the required custom textbook and access to SAM.When you order the textbook, you will automatically receive access toSAM. The book is sold in a loose-leaf format. Keep the pages of theentire book in their original order, within one or more loose-leaf binders,since you will need them for the open-book exams.Disclaimer: The instructor has no financial interest in the textbooks norin the SAM system. He does not receive any payment, commission orroyalties from sales of the books or the SAM system.Page10When you register for this course, please send an email (containingAssignment 1) to tbaum@sci.brooklyn.cuny.edu. Assignment 1 is dueby January 4. It does not require use of SAM or information from thetextbooks. One extra point is available each day that Assignment 1 issubmitted early (up to 10 extra points) and one point is deducted foreach day that Assignment 1 is late.10

Assignment 1a. Send me a brief email introducing yourself. Mention yourmajor, cuny id, hobbies and anything else interesting that youdon't mind sharing. You must include your major.b. Also, mention your prior knowledge of Office, if any, and whyyou are taking the course. Be sure to include the subject line thatincludes your name and the assignment number.c. Send me the email address that you will use as the SAMUsername (SAM is web-based software used in the course fortraining, projects and exams) and that is the best address for meto reach you.YOU MUST DO TWO THINGS IMMEDIATELY. THE FIRST IS TO SENDME ASSIGNMENT 1. THE SECOND IS TO ORDER CENGAGEUNLIMITED, REGISTER FOR SAM, AND OBTAIN THE TEXTBOOKS.Page11YOU CAN USE SAM FOR 14 DAYS UNDER A FREE GRACE PERIOD.11

TECHNOLOGY REQUIREMENTS (Repetition Of EarlierStatements)Students may use their own computers at home or computers at thecollege (Library, Computer Café, Web Building) that contain Office2013 or 2016. On campus, the best place to obtain all the features youneed is in the WEB building computer laboratory (the WEB building ison the Ocean Avenue side of the campus, past the West Quad.)Students must have access (on campus or off-campus) to: A PC using the Windows 7, 8.1 or 10 operating system or Office365.Microsoft Office 2016 (or 2013) (including MicrosoftAccess; many computers with Office 2013 or 2016 do notinclude Access, so make sure the computer you use hasAccess 2016.)Email, and access to the World Wide Web.A PC is preferred, but you can use a Mac, with reduced pointsfor Mac or Office 2013 features that are missing. You cannotuse a MAC for the second Excel project or for Access and forthe Word project.ASSIGNMENTSIt is essential that you submit Assignment 1 to me (not viaSAM) as early as possible, or the Registrar will assign agrade of WN (an administrative withdrawal) to you for thecourse. The earlier you submit Assignment 1, the better.As soon as you register for the course, submit Assignment1. Do not submit any assignments using email. photo,DropBox, OneDrive, ChatBox, Cloud, or any other filewrapper. Submit only Word files, Excel files, PowerPointfiles or Access databases through the instructions given inSAM. Do NOT submit assignments to me—only throughSAM. Keep a copy of anything you submit to SAM.)12Page 12The assignments are listed earlier in the this document and areaccessed from SAM and submitted to SAM. The assignments are all inthe SAM system (except for the first introductory Assignment 1), asnoted in the tables above. They should all (except for Assignment 1below) be submitted via SAM, not to me.

The assignments often need pre-existing data files. These canbe downloaded from the SAM specification of the assignment.GRADING: Projects (4 assignments) 30% Exams (3 Exams)30% Final Exam40%Your final grades may be curved based on performance of the entireclass. All regular assignments are due by the date listed above in theAssignment Schedules. 2-3 points will be deducted for every calendar date that anassignment is late and no assignment will be accepted past aspecified days after the due date. One point Extra Credit on the Final Exam for doing eachoptional training assignment (15 training assignments areavailable during the semester).HOW TO CONTACT MEStudents may contact me in person during office hours, or via email(tbaum@sci.brooklyn.cuny.edu) at any time. The subject of your emailmust contain the following:13PageMake sure your subject line is correct; if not, points may be removedfrom the current assignment and you may not receive a reply. Do notuse any quotes or special characters in the subject line, they are oftenmisinterpreted when the file is sent by email. If you have anyquestions, please feel free to see me during my scheduled office hoursor at any other time that I am available. If you need to communicatewith me, the ONLY guaranteed way to reach me is by email.13CIS 1050, your name, Assignment number or subject

Examination PolicySubject and final examinations will be given by SAM online. The datesand times for these four exams are given in the calendar above. You must take the exams online on Jan. 8 (WORD), Jan.16(EXCEL) and Jan. 18 (ACCESS), and the Final Exam onJanuary 23, (EXCEL, ACCESS, POWERPOINT), You may take the exam at 12-3PM or at 6-9PM, using thepassword “Afternoon” or “Evening”.The Final Exam will include a significant number of PowerPointquestions. Check your schedule NOW to determine that you can takethe exams and final online through SAM at the designatedtimes. Re-arrange your schedule if necessary. If you cannotmake the exams or final, you must drop the course.The examinations will be open-textbook. You may consult copiesof the text during the exam. During the exam periods, the rest ofSAM will be unavailable. You may also consult other software orelectronic sites.No make-up exams are allowed. If you are taking more than oneregular or online class, your exams and/or finals may conflict. It is yourresponsibility to resolve this conflict within the first week of thesemester, or else you must drop the course. Makeup final exams (incases of emergency only) will only be given in Spring 2018 before thedeadline for grade changes.To prepare for examinations, read the chapters (Modules) in the textand do the training assignments in SAM. All of the questions comedirectly from the reading material and from the training assignments.Review the examples in each section and short exercises after eachsection of the training applications on which you are being tested.The examinations consist of simulated Office 2016 actions and multiplechoice questions. Your grade on an exam or project will be availablein SAM the day after the exam or the due date for a project.Page14All submissions must be completed by January 23.14

How to Use SAMFirst, order Cengage Unlimited at www.cengage.com/unlimitedfor 130.You can then obtain SAM viawww.sam.cengage.com.The SAM Student Manual is located athttp://www.sci.brooklyn.cuny.edu/ tbaum/1050/sam.pdf. That free manualhas all the information on SAM for students, including images ofSAM screens, and is the reference book on how to use SAM.However, not every feature in the Manual is applicable to thiscourse.The following is an excerpt of that book (without screen images)that explain how to logon to SAM and how to access assignments,but does not describe how to do assignments. How to doassignments is explained in the SAM Student Manual. Thedescription below is tailored to the online Brooklyn Collegesection(s) taught by Prof. Aaron Tenenbaum. Information ondoing assignments and other expanded information are containedin the Manual.The tables earlier in this document specify reading assignmentsfrom the textbook, training, projects and exams. SAM reflectsthese schedules.You will not be pre-registered for SAM. It is yourresponsibility to register in SAM as soon as you obtainthe system.Use the following procedure to log into SAM:15Page2 Enter the email address you used to order Cengage Unlimited asthe username and enter a password you select.151 In your browser, enter http://sam.cengage.com in the Addressfield and press the Enter key.Result: The SAM Login page displays.

3 Click Login. Enter your SAM Key code at the prompt if you haveone. You may have received a SAM Key code with your purchaseof Cengage Unlimited. If you have not, try logging in again. If youare still excluded, contact Cengage Support. (See page 2.)Result: The SAM Terms and Conditions page displays.(The SAM Home page displays on subsequent logins.)4 When the SAM Terms and Conditions page displays, click I Agreeto accept the terms and conditions,5 Enter your secret question and secret answer. When finished,click Submit.6 Enter and confirm a new password if you wish. When finished,click Continue.Result: The Activity Calendar displaysProfile InformationEnter your profile information. The following provides formatinformation on each profile field:First name -- Maximum 50 characters and cannot contain any ofthe following: * “ % # ! \ / & ; : ,Middle initial (optional) -- Maximum 1 character and cannotcontain any of the following: * “ % # ! \ / & ; : ,16PageUsername/Email -- Enter the email address that is best forreaching you. The email address becomes your Username.Maximum 255 characters and cannot contain any of the following: *“ %#!\/ &;: ,NOTE: Your username cannot be changed once you save yourprofile.16Last name -- Maximum 50 characters and cannot contain any ofthe following: * “ % # ! \ / & ; : ,

Password--6 to 17 characters; use letters, numbers andunderscores only.Alias (optional) -- Minimum 6 characters; maximum 20 charactersand cannot contain any of the following: * “ % # ! \ / &; : , Although this field is officially optional, you should placeyour Brooklyn College class section code (Winter) here. This isdifferent than your SAM Section Code, which you enterelsewhere.ID# (optional)--Maximum 20 characters and cannot contain any ofthe following: * “ % # ! \ / & ; : , Although this field isgenerally optional, you should place your CUNY ID number here.Communication Email--Maximum 255 characters Enter yourusername here.Secret Question--Select a secret question from the drop-downmenu.Secret Answer--Enter an answer to the selected Secret Question.Cell Number--Maximum 15 digits.IMPORTANT: The username/email and password you enter alsobecome your login credentials for Cengage Brain(http://www.cengagebrain.com). If you have a Cengage Brainaccount, use that username and password when you register forSAM.Logging into SAM as a New User17Follow these steps when you log into SAM for the first time:Page1 In your browser, enter http://sam.cengage.com in the Addressfield and press the Enter key.17

2 Click the New User button.Result: The SAM Login page displays.3 Enter your school’s Institution Key. Brooklyn College’s institutionKey is T2181054.4 Click Submit.Result: A confirmation message displays to verify the institution’sidentity.5 The New User Profile page displays. (Fill it out as per step 6above.) Proceed to Step 8.8. Click Save to save your user information.Result: The Review and Confirm page displays.9 Click Revise if you want to change your profile information andthen click Save.10 Click Save on the New User Confirmation page.Result: The Terms and Conditions page displays.11 The End-User License Agreement may appear. If it does, Click IAgree.Result: The Activity Calendar displays.NOTE: A prompt to join a section displays. Click to join a section.When prompted, the section you should join is 1050 W19(Winter).Forgot Password18If you forgot your password, use this procedure to reset yourpassword.Page1 On the SAM Login page, click the Forgot password? button.18

Result: The Retrieve Your Password dialog box displays.2 Enter your username. Click Continue.3 In the dialog box that displays, enter the answer to the securityquestion and click Submit. NOTE: The answer is not casesensitive. If you don't remember your answer, click the ContactTech Support button.Result: SAM sends an email to your email address on record witha link to reset your password.4 Open the email and click the password reset link. Follow theinstructions to reset your password.Grace PeriodSome students have grace periods up to two weeks where theycan access SAM without providing an access code. This is onlyapplicable for students in an institution where they purchase KeyCodes to access SAM and have the Grace period option enabled.Page19In reading the SAM Student Manual, note that Brooklyn College isa key-code institution, not a site-licensed institution.19

Existing UsersIf you are an existing user (completed your initial login to SAM),use the following procedure to log in.1 In your browser, enter http://sam.cengage.com in the Addressfield and press the Enter key.Result: The SAM Login page displays.2 Enter your username and password.3 Click Login.Result: The Activity Calendar displays.AccountYou can change your account settings in the top right corner ofSAM.My AccountUse the following procedure to update your SAM account:1 Click on the button with your name on the upper-right side ofthe page.Result: A drop down menu displays.2 Click the My Account button.Result: Your account information displays.3 Review the information. Click Edit to make changes.Result: The My Account Details dialog box displays.20Page5 Select a Secret Question from the dropdown menu and enter aSecret Answer to set your security question.204 Edit the information as necessary. You cannot change grayedout field values. Name fields cannot contain any of the followingcharacters: * “ % # ! \ / & ; : ,

6 Click Save to save the changes to your account.NotificationsSystem messages display in the Notifications dropdown.Notifications include system downtime or failure to meet systemrequirements such as installing Adobe Flash player. Plan yourschedule accordingly if there are periods when SAM will not beavailable to you.HelpIf you require technical assistance, you can access documentationor visit Cengage Customer Technical Support's website from theHelp menu.To open the documentation, select the link to either the onlinehelp or the User Manual.If you need technical assistance, do the following:1 Click Help.2 Click Tech Support.Result: The Cengage Customer Technical Support page opens inanother tab.Logging OutOnce you are done using SAM, click the Logout button in theupper-right corner of the page. The SAM Login page displays.Page21Sections21

You can view the sections in which you enroll or you can enroll innew sections. You are either enrolled automatically or wait listeddepending on how the instructor set up the course. All studentsshould enroll in the SAM section name 1050 W18 (Winter).My SectionsView the sections in which you are enrolled using the followingprocedure:1 On the Navigation bar, click Sections.Result: The My Sections page displays and you see a list ofsections in which you are enrolled or wait listed.2 The My Sections page displays the sections in alphabetical order.To sort the sections, click a heading row to sort by it.3 To view section details:Click the section’s Name to view the section name, course name,term, instructor, textbook and status.Result: The Section Details window displays.Joining a SectionUse the following procedure to join a section. You can joinsections only if the instructor enables auto-enrollment. Autoenrollment has been enabled for our section.1 On the Navigation bar, click Sections.Result: The My Sections page displays. You can view a list ofsections in which you are enrolled.22Result: A list of availablesections displays.Page2 Click the Join a Section tab.22

3 Click the Join Section icon.Result: A confirmationmessage displays.NOTE: Depending on your instructor’s section settings, you maybe auto enrolled into the section 1050 W19 (Winter) or waitlisted.5 Click the Close icon.Result: You return to the Join a Section page. The course no longerdisplays in the Join a Section list.ACTIVITIESYou can view and take assignments from either the ActivityCalendar or Activity List view. You cannot do an Activity in SAMuntil it is made available. The Activity Calendar displaysassignment available and due dates on a calendar. The ActivityList displays assignment details in a list format. See the SAMStudent Manual for information on how to do assignments.NOTE: By default, the option box is selected for Set Calendar asdefault view. To change the default view to the Activity List,deselect the option box. The next time you log into SAM, theActivity List will display instead of the Calendar View.Activity CalendarBy default, the Activity Calendar displays when you log into SAM.The Activity Calendar displays activities that become available andwhen they are due in a calendar format.NOTE: The first time you log into SAM, no sections display.Register for a section in the Sections tab.Page23Action23

Set Calendar as default view. By default, the option box isselected for Set Activity Calendar as default view. To change thedefault view to the Activity List, deselect the option box. The nexttime you log into SAM, the Activity List will display instead of theCalendar View.Activity CalendarThe Activity Calendar displays Exams, Training, and Projects.Badges display next to the activity type. A gray badge indicatesthe assignment becomes available that day. A red badge meansthe assignment is due that day. The number in the badge refers tothe number of activities of that type. Hover over a badge todisplay the assignments and Due Dates. Click the hyperlink tobegin the assignment.Filter Activity Types -- Activity types that are checked display inthe Activity Calendar view. NOTE: Activity filters settings apply tothe Activity Calendar,Activity List and Reports pages.Sections filter -- Select a section from the dropdown menu. Allsections display by default. Enter text for partial searchfunctionality.Days -- Click a day to display the Daily Assignments dialog box.The dialog box displays additional assignment details, includingthe due date and time, number of attempts allowed and howmany times you attempted the assignment.PageBegin an assignment -- Select an assignme

Microsoft Word (word processor; part of Office) , . Many computers in industry today use Microsoft Office 2013 or Office 2016. The differences between these versions of Office are minimal, . me any screenshots. Although you can use the Office 2013 programs, you must use the custom Of