COMPUTER INFORMATION SYSTEMS

College of Alameda 2019-2020 CatalogCOMPUTER INFORMATION SYSTEMS (CIS) 133(CIS)Computer Information Systems discipline isthe integration of three dimensions: Technology,Organization, People (“TOP”).Technology (IT)dimension involves hardware, software, network,and database management. Organization dimensioninvolves politics (power distribution), policies (codesof conduct), and procedures (process methods). Peopledimension involves skills, training, ergonomics (manmachine synergy), and personalities (“STEP”).CIS discipline is dedicated to students seeking to developtheir technology skills.Bureau of Labor Statistics (BLS) in 2018 reports jobs forcomputer and information technology will grow 13 percentfrom 2016 to 2026, faster than the average for all occupations.CIS jobs are projected to add about 557,100 new openings.This growth in CIS industry stems from demands for cloudcomputing, information security, online storage and analysisof big data.The median annual wage for CIS occupations, which includemanagers, was 84.5K in May 2017, higher than the medianannual wage for all occupations of 37.7K. According toPayscale.com, the average annual pay for IT Specialists, whichexclude managers, is 55K within 36K to 96K range.Students should consider what we offer – CIS degree,CIS certificate of achievement, Desktop Help Techniciancertificate or Web Publishing certificate of proficiency.CIS 1Introduction to Computer Information Systems4 units, 3 hours lecture, 3 hours laboratory (GR)Eligible for credit by examinationAcceptable for credit: CSU, UCGeneral nature of computer hardware, software andsystems: Hands-on applications include introduction toword processing, spreadsheet, database managementand presentation software, and a brief introduction toweb browsing and e-mail. 0702.00AA/AS area 4c; CSU area ECIS 4IntroductionSystemstoGeographicalInformation4 units, 3 hours lecture, 3 hours lab (GR)Acceptable for credit: CSURecommended Preparation: CIS 1, CIS 5, CIS 40Introduction to Geographic Information Systems[GIS]: Fundamental concepts, cartographic principles,hardware and software requirements; Charts, graphs,and full map layouts; Data structures and sources;Spatial databases and analysis. 0702.00CIS 5Introduction to Computer Science5 units, 4 hours lecture, 3 hours laboratory (GR)Eligible for credit by examinationAcceptable for credit: CSU, UCIntroduction to computer science: Architecture of digitalcomputers, design of algorithms for solving variousproblems, and basic skills in computer programming.0706.00AA/AS area 4cCIS 6Introduction to Computer Programming5 units, 4 hours lecture, 3 hours laboratory (GR or P/NP)Recommended preparation: CIS 5Acceptable for credit: CSU, UCIntroduction to computer programming: Algorithmdesign, flow charting, and debugging; elements of goodprogramming style. Course may be instructed in anyprogramming language. 0707.10AA/AS area 4cCIS 23C# Programming4 units, 3 hours lecture, 3 hours laboratory (GR)Acceptable for credit: CSU, UCC# programming: Basic unified modeling language(UML) notation in object-oriented software design anddevelopment using the C# programming language ina .Net environment; focus on the program structure,syntax, constructs and keywords of the C# programminglanguage, concepts of intermediate languages (ILs), thecommon language runtime (CLR), and .Net standarddata types. 0707.10AA/AS area 4cDC EOSMCPRUI TP ET RI O INN FOOF SC YOSUTRESMESSCOMPUTER INFORMATION SYSTEMS

134 COMPUTER INFORMATION SYSTEMS (CIS)College of Alameda 2019-2020 CatalogDC EOSMCPRUI TP ET RI O INN FOOF SC YOSUTRESMESSCIS 25Object-Oriented Programming Using C CIS 70Introduction to Tableau AnalyticsCIS 40Database ManagementCIS 97AOracle SQL and PL/SQLCIS 42Spreadsheet ApplicationsCIS 201Introduction to Computer Hardware4 units, 3 hours lecture, 3 hours laboratory (GR)Recommended preparation: CIS 6 or 10 or 26Acceptable for credit: CSU, UCObject-oriented methods of software developmentusing C : Design and implementation of objects, classconstruction and destruction, encapsulation, inheritance,and polymorphism. 0707.10AA/AS area 4c4 units, 3 hours lecture, 3 hours laboratory (GR or P/NP)Recommended preparation: CIS 1 or 5Acceptable for credit: CSUDesign, implementation, and maintenance of databases:Analysis of user requirements; building tables, queries,forms, reports, and other topics. 0702.10AA/AS area 4c4 units, 3 hours lecture, 3 hours laboratory (GR or P/NP)Recommended preparation: CIS 1 or 5 or 200Not open for credit to students who have completed orare currently enrolled in CIS 42A and/or 42B.Acceptable for credit: CSUPrinciples of electronic spreadsheets using featuresavailable with current popular spreadsheet software:Worksheet creation, formatting and charting; enteringdata and formulas; functions; editing and printing;web queries; basic database functions of sorting andquerying; creating web pages; logical functions; lookuptables; Pivot Tables, Pivot Charts, and trendlines; graphicdesign for financial statements; creating templates; usingmacros. 0702.10AA/AS area 4cCIS 48AA-FZSelected Topics in Computer InformationSystems.5-9 units, 0-9 hours lecture, 0-27 hours laboratory(GR or P/NP)Acceptable for credit: CSUSee section on Selected Topics. 0702.00CIS 49Independent Study in Computer InformationSystems.5-5 units, .5-5 hours lecture (GR)Acceptable for credit: CSUSee section on Independent Study. 0702.002 units, 1.5 hours lecture, 1.5 hours laboratory (GR)Acceptable for credit: CSUIntroduction to Tableau desktop software applicationused for Big Data Analytics and Business Intelligence:various operations such as filters, calculations, creatingsets, charting data, and creating visuals; usage ofsoftware to help businesses gain insight into trends inorder to make informed decisions. 0702.104 units, 3 hours lecture, 3 hours laboratory (GR or P/NP)Prerequisite: CIS 1Acceptable for credit: CSUIntroduction to the design and development of multiuser relational database systems: Oracle SQL andfundamentals of PL/SQL programming. 0707.20AA/AS area 4c4 units, 3 hours lecture, 3 hours lab (GR or P/NP)Introduction to computer hardware: Maintaining andservicing computer equipment, fundamental conceptsand architecture, major computer subsystems andperipheral devices, common computer problems,troubleshooting techniques, repair procedures andpreventive maintenance; traditional, current andemerging computer technologies. 0708.20CIS 205Computer Literacy1 unit, 14 term hours lecture, 14 term hours laboratory(GR or P/NP)Also offered as Bus 219. Not open for credit to studentswho have completed or are currently enrolled inBusiness 219.Eligible for credit by examinationIntroduction to computers and information technologyfor people with no background in nor knowledge ofcomputers. 0701.00AA/AS area 4cCIS 209Introduction to Windows1 unit, .75 hours lecture, .75 hours laboratory(GR or P/NP)Recommended preparation: CIS 205Introduction to graphical user interfaces using MicrosoftWindows. 0702.00AA/AS area 4c

College of Alameda 2019-2020 Catalog1 unit, 13.5 term hours lecture, 13.5 term hours laboratory(GR or P/NP)Introduction to word processing using MicrosoftWord: Basic functions such as open, close, save, andprint; creating and editing documents, text and printformatting techniques, spell checking, assimilatinggraphs and tables in documents. 0702.10AA/AS area 4cCIS 223BIntroduction to Excel1 unit, 13.5 term hours lecture, 13.5 term hours laboratory(GR or P/NP)Introduction to computerized spreadsheets usingMicrosoft Excel: Basic functions such as open, close, saveand print; formulas and functions, creating charts, andformatting commands for setting up worksheets. 0702.10AA/AS area 4cCIS 223CIntroduction to Access1 unit, 13.5 term hours lecture, 13.5 term hours laboratory(GR or P/NP)Introduction to database management using MicrosoftAccess: Basic functions such as open, close, save andprint; creating, maintaining, organizing, sorting, andpresenting data using querying, forms and reportfunctions. 0702.10AA/AS area 4cCIS 223DIntroduction to PowerPoint1 unit, 13.5 term hours lecture, 13.5 term hours laboratory(GR or P/NP)Introduction to presentation graphics software: Basicconcepts such as creating on-screen slides using graphics,tables, charts, and formatted text. 0702.10AA/AS area 4cCIS 224Introduction to the Internet1 unit, .75 hours lecture, .75 hours laboratory(GR or P/NP)Introduction to the Internet for access to informationresources: Web browsers, web sites, web pages,electronic mail, and skills relevant to participating in anonline, hybrid, or web-enhanced course. 0709.00AA/AS area 4cCIS 226ADesktop Support Technician I3 units, 2 hours lecture, 3 hours lab (GR or P/NP)Windows Desktop applications: Configuring andtroubleshooting, access to resources, hardware devices,desktop and user environments, and network services.0708.20CIS 226BDesktop Support Technician II3 units, 2 hours lecture, 3 hours laboratory (GR or P/NP)Recommended preparation: CIS 1Windows desktop support: Supporting users andtroubleshooting applications. 0708.20AA/AS area 4cCIS 227Word Processing for Legal Professionals3 units, 2 hours lecture, 3 hours laboratory (GR or P/NP)Recommended preparation: Bus 230DEF (Self-Paced).Students should be able to type 25 words per minute.Also offered as BUS 227. Not open for credit to studentswho have completed or are currently enrolled in BUS227.Emphasis on the use of Microsoft Office WordApplication features to create legal-oriented documents:legal correspondence, legal pleadings, memorandumof points and authorities, table of contents, table ofauthorities, indexes, and forms. 0706.00AA/AS area 4cCIS 234AWorld Wide Web Publishing I2 units, 1.5 hours lecture, 1.5 hours laboratory(GR or P/NP)Recommended preparation: CIS 233 and Grart 112Creating and publishing Web pages over the Internetusing the Hypertext Markup Language (HTML). 0709.00AA/AS area 4cCIS 234BWorld Wide Web Publishing II2 units, 1.5 hours lecture, 1.5 hours laboratory(GR or P/NP)Prerequisite: CIS 233 and 234ARecommended preparation: Grart 112Continuation of CIS 234A: Emphasis on advancedHTML and layout techniques, client-side image maps,CGI scripting, introduction to cascading style sheets anddynamic scripting. 0709.00AA/AS area 4cDCEOSMCPRUI TP ET RI O INN FO OF SC YO SUTRESME SSCIS 223AIntroduction to WordCOMPUTER INFORMATION SYSTEMS (CIS) 135

136 COMPUTER INFORMATION SYSTEMS (CIS)COMPUTER INFO SYSTEMSCIS 234DWeb Authoring2 units, 1.5 hours lecture, 1.5 hours laboratory(GR or P/NP)Recommended preparation: CIS 234AArt of web design and the power of web authoring inwebsite content management and functionality: Websitetemplates, customization, layout tables, interactiveforms, frames, database interface, wizards, sourcecontrols, dynamic layers, instant updates, multimediacontent, subsite and website management. 0709.00AA/AS area 4cCIS 234ECreating an E-Commerce Web Site2 units, 1.5 hours lecture, 1.5 hours laboratory(GR or P/NP)Recommended preparation: CIS 234ABusiness strategies and programming techniques in thedesign and development of an electronic commerce webpresence: Banner ads, auto responders, product catalogs,shopping carts, cookies, electronic payment systems,online database and website security management.0709.00AA/AS area 4cCIS 239Help-Desk Tools and Techniques2 units, 1.5 hours lecture, 1.5 hours laboratory(GR or P/NP)Recommended preparation: CIS 1Help-desk tools and techniques: Troubleshootingproblems on computer systems, both networked andstand-alone; customer-service skills for success; use ofhelp-desk software. 0708.20AA/AS area 4cCIS 248AA-FZSelected Topics in Computer InformationSystems.5-9 units, 0-9 hours lecture, 0-27 hours laboratory(GR or P/NP)See section on Selected Topics. 0702.00College of Alameda 2019-2020 Catalog