Assistive Menu

IT 120 - Spreadsheet Applications

Description:IT 120 presents the student with comprehensive spreadsheet techniques using MS Excel. Students learn to develop a professional workbook, work with formulas, charts and graphics, lists, outlines, sorting, filtering, subtotaling, 3-D references, advanced functions, conditional formatting, data validation, templates, data tables, scenario management, import and export data, audit formulas, create hyperlinks and a web page, work with large documents, and automate a worksheet with Visual Basic macros. This course is designed for those students pursuing training in office productivity software and/or MOS certificate preparation.
Credit hours:2-2-3
Prerequisite(s):CIS 110 or OT 116 or consent of full-time Information Technology instructor
Applicability towards graduation:
  • Certificate or degree - All Certificates, AAS, ALS
  • Group requirement - Not Applicable
  • Area of concentration - Not Applicable
Offered:Offered in Spring.

Spring 2010 Offerings

CourseSecBegEndDaysInstructorNotes
IT 1200111:00a12:50pM,WHarper
IT 120026:00p9:50pTStaff
IT 120898:59a9:44aM,T,W,Th,FMorrisey,J
  • This section begins on Jan 4 and ends on May 18.
  • Meets at Mt Zion H.S.
IT 120V1OnlineHarper

Information Technology Courses

NumberTitleHours
IT 105Information Technology Systems2-2-3
IT 115Windows Fundamentals2-2-3
IT 116Windows Client Operating Systems2-2-3
IT 120Spreadsheet Applications2-2-3
IT 130Word Processor Applications2-2-3
IT 131Programming Logic2-2-3
IT 141Networking Fundamentals2-4-4
IT 151Internet Techniques2-2-3
IT 153Web Development2-2-3
IT 173A+ Computer Technologies2-4-4
IT 205Help Desk Techniques2-2-3
IT 206Operating Systems Support2-2-3
IT 207Software Applications Support2-2-3
IT 210Presentation Graphic Applications2-2-3
IT 220Data Management Applications2-2-3
IT 221Database Design2-2-3
IT 222Structured Query Language2-2-3
IT 230Project Management2-2-3
IT 241Network Routing Technologies2-4-4
IT 242Wireless Networking2-2-3
IT 243Network Switching Technologies2-4-4
IT 244Wide Area Networks2-4-4
IT 245Network Security2-2-3
IT 246Voice Over IP Fundamentals2-2-3
IT 271Windows Server Operating Systems2-2-3
IT 273Managing Windows Networks2-2-3
IT 274Windows Active Directory2-2-3
IT 280Advanced Systems Development3-2-4
IT 282Dynamic Web Development2-2-3
IT 284Web Programming2-2-3
IT 285Systems Analysis and Design2-4-4
IT 290Work Experience Practicum1-1-3
IT 295Special Advanced Projects1-1-3
IT 297Emerging Technologies3-2-2