PagePagePAGE8of7 CAIS191ComputerConcepts(MicrosoftOfficeApplications)UniversityofBridgeport,Fall2013CourseDescriptionCAIS191isdesignedtopreparestudentstoperformacademicworkatUniversityofBridgeport,aswellasworktheywillfindinthebusinssandprofessinalworld,usingtheMicrosoftOfficesuiteofapplications(primarilyWord,Excel,andPowerPoint).Additionally,thiscoursewilladdressbasiccompuercompetencyandinformationliteracyneededtocompletepapersandprojectsthatstudentswillencounterthroughouttheiracademiccareersandmovingintoadultlife,bethoseneedsbusinessorpersonl.CourseGoalsBasiccomputercompetenciesUnderstandngandoperationsofWndowsoperatingsystemsProperprocedureforsartupandshutdownofthecomputerHowtoopenandcloseapplications(i.e.,computerprograms)WorkingwithfilesandfoldersandunderstandingtheirfunctonBackingupandprotectingyourfilesUnderstandngdifferentfiletypes(pdf,gif,jpeg,jpg,html,doc,xls,mdb,xml)SecurityandprivacyissuesUnderstandngfeaturesofallpopularwebbrowserclientsImportingofdocumentsfromoneapplicationtoanother Performingweb-basedresearchandevaluatingthecredibilityofinteractivemediasourcsMicrosoftWordUsingofspellcheck/grammarcheck Editingandformattinghowdocumentslook(e.g.,boldingoftitlesorinsertingofalinktoawebsite)WritingandproperlyformattingseveraltypesofacademicpapersCreatinganoutlineforaresearchpaperCreatingarésuméusngaMicrosoftOfficetemplateasaguideMicrosoftExcelWorkingwithcharts,frmulas,andfunctionsManagingworkbooksAutomatingworksheettasksUsinglistsandanalyzinglistdataUsing“what-if”analysisAnalyzingdatawithpivottables ExchangingdatawithotherprogramsCustomizngExcel/advancedworksheetmanagementMicrosoftPowerPointUnderstandnghowtocreateapresentationEdit,format,changehowyourpresentationlooksPresentationdesigncompetencies(designandcontentguidelines)InstructorInformationHughMcNally,M.A.Adjunctprofessor/InstructionalDesigner,CenrforExcelleneinLearningandTeachingUniversityofBridgeportE-mail:hmcnally@Voice:203-576-2362Office:Wahlstrom510/518Hours:Byappointment(IamoncampusMonday-Fridayfrom9a-5p)Résumé/furtherinfrmation:/in/hcnallyIworkattheCenterforExcellenceinLearningandTeachingattheUniversity,andmyofficeisnthefifthfloorofWahlstromLibrary(Wahlstrom510/518).Iamoncampuseverybusinessday,MondaythroughFriday,duringnoralbusinesshours(9a-5p).IhavedutiesasaUBstaffmember,butmyscheduleisflexibleenoughtomeetyourneedsifyouwanttomeetwithme.Ifyoudesireanin-persononsultationwithme,pleasejustask—we'llfigureoutagoodtime.Communication/ContactPoliciesItisvitalthatyoucheckyourUniversiyofBridgeporte-mailaccountonadaily,ormorefrequent,basis.E-mailisthebackboneofcommunicationinthiscourse,asitisinbusinesstoday.YoualsoneedtobeabletosignintoCanvas,theUnivesiy’slearnngmanagementsystem.Asarule,yourassignmentswillbesubmittedviaCanvas,andothercommunicationwithmewillhappenthroughe-ail.Whenusinge-mail,contactmeviaUniversityofBridgeporte-mailonbothends.Thismeans,“useyourUBe-ailaccounttosendmesagestomyUBe-mailaccount.”Idon’twanttoknowyourGMailaddress,norwillIkeeptrackofanythingbutyourUB-providede-mailaccunt.Idon’tcarethatyouneverlokatyourUBe-mail:ifthatistrue,yourbehaviorneedstochangeforthiscoursefroutosuccedinit.TheonlyreasonnottouseyourUBe-mailaccount(ormine)shouldbeatechnicalemergency,notconvnience.DonotattempttocommunicatewithmethroughFacebook,Twitter,LinkdIn,Instagram,oranyothersocialmediaservice.Iwillnotconsider“riendrequests”fromyouviaFacebookorothersocialmediaservicsuntlyouhavereceivedyourfinalgradeinthiscourse.PleasebeawarethatIamanactiveuserofallsocialmediaservicsand,ifyoumakepubliccommentsaboutthiscourse(oryself)usingtheseservices,youriskmereadingthem.Textbook/MaterialsTheresnoassignedtextbookforthiscourse.AlreadingandreferncematerialswillbeprovidedthroughCanvsaseitherlnkstowebsitesorviadownload(PDFs,Worddocuments,etc.)andarefreelyavailableontheweb.Ifyouneedprintedmaterialstoreferto,thebrieflaminatedreferenecardsthatcanbefoundatofficesuplystores(Staples,OfficeMax,etc.)areworthwhileandinexpensive.HrearelinkstoAmazonfor3ofthem:eachcostlessthan$4.Wordcheatsheet/Microsoft-Introduction-Reference-Instructions-Shortcuts/dp/1936220156/Excelcheatsheet)/Microsoft-Introduction-Reference-Instructions-Shortcuts/dp/193622013X/PowerPointcheatsheet)/Microsoft-PowerPoint-Introduction-Reference-Instructions/dp/1936220873/Technicalrquirement:OwnershipforaccessoacomputerrunningarecentversinofMicrosftOffice(Office2013,Office2010orOffice2007ontheWindowsoperatingsystem;Office2011orOffice2008onMacintoshOSX).GoogleDocs,GoogleDrive,orotherwork-alikeapplicationsareNOTacceptablesubstitutes.NOTE:MicrsoftOfficeHomeandStudentEdition”isavailableatagreatlydiscountedpricetostudents(usuallyaround$120-$150).Detailsareavailableathttp://office.microsoft.om/en-us/home-and-student/.Thispackageisusuallyavailableforpurchasetmostplacesthatsellcomputersoftware,likeStaples,Costco,andAppleretailstores.Assignments:PoliciesandProcedureAllassignmntswillbeaccessedviaCanvas(you’llseethisduringthefirstnightofclass).Courserequrementsincudeclassparticipation,homework,amid-termquiz,andanend-termquiz.YourassignmentswillhaveduedateslistedonCanvas.EvrthingyousubmitasanassignmentshouldbeYOURWORDSANDWORK,nota“copy-and-paste”fromanothersourceorsimplerepetitionofthematerialsinatext.Theoverallgoalofassignmentsisforyoutopracticethetechniquesescribedbothinclassandinthereadings.Thiswillenhanceyourlearningandpracticalapplicationofthecoursework.AssignmentsmustbesubmittedthroughCanvas.ThisnsuresthatIknowyou’vesubmittedthework,andavoidsanytechnicalglitchesorexcussthatcomewithattachingfilestoe-mail.Donote-mailmeassignmentfilsunlsstechnicalmattersforceyoutodoso(suchasCanvasbeingdown),orunlessIaskyutodoso.ToenterCnvas,vsitandlookforalinktoit.Homeworksubmittedlateorincompletewillreceivethefollwingpenalties:o10%offforeachdaylate(upto6days)oNoassignmentwillbeacceptedafterthethday.ClassroomexpectationsandattendancepolicyIexpectyoutobepreparedforeachclass.Thisincludesdoingreadingassignmentsndhomework.Yourinabilitytoparticipateinclassdiscussionsuetoalackofpreparednesshasanegativeimpactonyourgrade.Homeworkisgradedandischeckedtoensuresudentsarecompletingrequiredworkinatimelymannerandunderstandthematerials.Thisalsopromptsstudentstobringquestionsaboutmaterialtotheclassmeetings.Iexpectyoutoattendallclasses.Pleasenotifymebye-mailorphonepriortoclassifanemergency(flattire,deadcat,openwound,etc.)requiresyutomissaclass.“I’mtird,”“Iforgot,”“myfavoriteshw/sportsteamisonTV,”etc.,arenotemergencies.Ifyouareillandcontagious,pleaseletmeknowsoyoucanbeexcusedfromattending.Ireservetherighttorequestformedicalverificationofanysicknessoumayexperiencethatcausesyouomissclass(inotherwords,Imightaskforadoctor’snote).Anyunexusedabsencefromclassrskssevrepenaltyinyourfinalgrade.Ifyouhave3ormoreunexcusedabsences,Iwillgiveyouan“F.”Thisisnotnegotiable.Iwillnotoffera"bigproject"orsmilaralternateassignmentattheendsothatyoucanachieveapassinggrade.Ifthereisacompellingreasonforyurexcessiveabsences(prolongedseriusillness,dathinthefamily,orsimilartrauma),IwillworkwithyouandUniversityadministrationtoachieveahumaneandfairoutcomeinthisregard.Ifyoumissaclass,itisourrespnsibilitytopickupnotes,etc.fromanotherstudentandvisittheclassonCanvasasneeded.Latenessislsonotacceptable.Repeatedtardinesswillalsohaveanegativeimpactonfinalgrades.I’montime,andIexpectyoutobeontime,too.ClassroomDecorumandBehaviorYou'reanadult,andI'maskingyoutoactlikeone.Respectyourfellowsudents,andme,inclass.Noorderingpizzabytext—actually…Notextingorcallsinclass,periodNopersonalphonecalls—that'swhatvoicemailisfor.Allphnesaretobeonvibratemode,unlessyouhavesomefantasticringtneyouthinkwillbeofusetousall.Noquickglancesatyourphone'sstatusscreentoseewhosecall/text/Tweet/Facebookstatusyou’vejustmissed.Pleasetellmeifyounedtouseyourcellphone,etc.tocheckonanemergencyifcalleduponduringclass.Anemergencymeans,"mysisterishavingahearttransplant"not"I’mbuyingsomethingoneBay"or“Ineedtoknowwhat’shappeningonInstagram.”IfIfindyou'rebeingparticularlydisruptiveorimpoliteinanymanner,Iwillaskyoutoleavetheclassroomandwillmarkyouabsentfortheclass.Iconsidersurfingthewebandlookingatpicturesofntertainingthings(unreltedtoclass)tobedisruptiveandimpolite.EvaluationProceduresClassparticipationisimportant.Itwillbefactoredintoyourfinalgrade,butitisimportanttoensureyouunderstandconceptsdiscussedandcanconveythoseconceptstoothers.Itisalsoimportanttodevelopskillandunderstandingthroughclasswork,participation,andpayingattention.Classparticpationisnotsimplyarrivingforclass.Toscorefulpointsforlassparticipation,youshouldactivelyparticipateindiscussionsnclass,askingquestionsandofferingyourpinionsaboutthetopicsdiscussed.Gradingisbasedonexaminationscores,homeworkassignments,finalprojectpresentationsandasubjectiverviewofyourpreparednessforandcntributiontoclassdiscussonsandactivities.CompnentWeightInClassssgnments25%RegularAttendanceandActiveParticipation25%Mid-termquiz10%End-termquz10%HomeworkAssignments30%Ireservetherighttomodifyanyaspectofthiscurseasneeedtoservetheneedsoftheclass.Everyeffortwillbemadetoadheretothissyllabussostudntscaneffectivelyandefficientlybudgettheirpreparationtime.Everyeffortwillbemadetocommunicateandadvise,andtoconsultwithstudentsintheeventachangeisanticipated.Ifyouhaveanyproblemswiththiscurse,therequirementsofthecourse,rotherissues,pleasecontactmeimmediately.Ifyoudonot,Iwillassumeyouunderstandandacceptthepoliciessetforthhre.AcademicIntegrity/Plagiarism/CopyingtheWorkofOthersNote:TheUniversityofBridgeportStudentHandbookisavailableat/life/student-services/key-ub-student-handbook/Tobebluntandclear:ifIfindanystudentsubmittingthesameexactfileasanyotherstudentinthisorapreviousversionofthiscourse(foranythingotherthanagroupproject),,IwillFAILthatstudentfortheentirecourse,andwewillhaveadiscussionwiththeDeanconcerningyourfuureattheUniversity.Itakethisvryseriously,andtherewillbenonegotiation(e.g.,“Iwasstudyingwithmyroommate/cousin/[fill-in-he-blank]”)abouttheinfracion.AllmembersoftheUnivrsitycommunity,students,facultyandstaffalike,areexpectedtocommitthemselvestopersonalandacademicintegrityandtothesefundamentalvalues:Beinghonestinwhattheysay,don'tsay,do,anddon'tdoTrustingothrsandbeingworthyoftrustActingrespnsiblyandexpectingresponsiblebehaviorfromthers Treatingothermembersofthecommunityfairly,andexpectingfairconsequenceswhenmistakesaremade Treatingothermembersofthecommunityandtheeducationalprocesswithrespect,andexpectingrespectforoneself,onesviews,andone'sabilitiesInkeepingwiththesevalues,theUniversityexpectsitscommunitymemberstocomplywiththeusualexpectationsforhnestacademicwork.Inthisclassasthers,you…MaynotcheatonanyworkMustnottransgresscopyrightlawMustproperlycitesourcesinallpapersandonlinecontentproductionMaynotprovideorprocureunuthorizedassistanceonanyassignmentortestMaynotfalsifyoralteruniversitydocuments,testsorassignmentsMaynotimpedeanyotherstudentinhisorhrcursework MaynotdoanyotherthingthatviolatesorallowsanotherpersontoviolatetheacceptedstandardsofacademicintegrityStudents,faulty,andstaffalsoshudpromoteintegrityby:EducatingeachotherDiscussngintegrityintherclassesReportingviolationswhentheyoccurOfspecialote:AssumethatEVERYTHINGONTHEINTERNETISCOPYRIGHTEDunlessexplicitlyexpressedotherwisebyitsauthor,eiherthrughasimplestatement("Youcanusemypictureonyourblog")orthroughaCreativeCommonslicense(seecreativecommonsorgforfurtherinformation).Useofcopyrightedmaterialinthiscoursesnotacceptable,evenifyouonsiderit“foracademicpurposes.”ClassesBeginMonday,8/26ClassesBeginMonday,8/26NoClasses-LaborDayMonday,9/2Mid-SemesterExaminatinWeekMonday-Friday,10/14-10/18ThanksgivingRecess-NoClassesWed.-Sun.,11/27-12/1LastDayofClassesFriday,12/6FinalExamiationWeekMonday-Friday,12/9-12/13FinalGradesDue(Undergraduate/Graduate)Monday,12/16PreliminaryclassscheduleThisscheduleissubjecttochangebaseduponthedynamicoftheclassandanyexternalfactors,suchasUniversityclosureduetoweather,etc.,thatmayoccurduringthesemester.StudentsarerequiredtorefertoCanvasatalltimes,especiallyintheeventofsuchsituations,forupdatesonassignments.WeekClassdescriptionHomeworkAlwaysseeCanvasfordetils/changes1Overviewofcourseands