Issue link: https://www.e-digitaleditions.com/i/856285
Course Listings 2017-2018 313 ISP120AB 72 Clock Hours Microsoft Access®: Basic/Intermediate Using Microsoft Access, students learn to create and build a database; define table relationships; maintain and query a database; create forms and reports. Students learn to create advanced queries; enhance table designs; use form tools; and create custom forms and reports. Students learn to share, integrate, and analyze data. Prerequisite: None. ISP126 144 Clock Hours Microsoft Excel® Using Microsoft Excel, students learn to create spreadsheets; design, edit and format worksheets; create and edit charts. They learn to use formulas and functions to automatically sum totals and perform common business-related mathematical functions on data to manage workbooks. Students work with Excel tables, PivotTables, and Pivot Charts; manage multiple worksheets and workbooks; develop an Excel application; work with advanced functions; automate worksheet tasks; and filter and sort lists. Students explore financial tools and functions; perform What-If analyses; connect with external data and collaborate on a shared workbook. Prerequisite: None. ISP126A 42 Clock Hours Microsoft Excel®: Basic Using Microsoft Excel, students learn to create spreadsheets; design, edit and format worksheets; create and edit charts. They learn to use formulas and functions to automatically sum totals and perform common business-related mathematical functions on data to manage workbooks. Prerequisite: None. ISP126AB 72 Clock Hours Microsoft Excel®: Basic/Intermediate Using Microsoft Excel, students learn to create spreadsheets; design, edit and format worksheets; create and edit charts. They learn to use formulas and functions to automatically sum totals and perform common business-related mathematical functions on data to manage workbooks. Students work with Excel tables, PivotTables, and Pivot Charts; manage multiple worksheets and workbooks; develop an Excel application; work with advanced functions; automate worksheet tasks; and filter and sort lists. Prerequisite: None. ISP142 72 Clock Hours Microsoft PowerPoint® Using Microsoft PowerPoint, students learn how to plan, develop, and give a presentation. Students create a presentation and add media and special effects. Students learn to apply advanced formatting and animation to objects and to distribute presentations. Students learn to integrate PowerPoint with other programs, customize presentation, and customize the PowerPoint environment. Students create projects that reflect their creativity and incorporate the skills and techniques needed to share these presentations in the today's office setting. Prerequisite: None. ISP142A 42 Clock Hours Microsoft PowerPoint®: Basic Using Microsoft PowerPoint, students learn how to plan, develop, and give a presentation. Students create a presentation and add media and special effects. Students create projects that reflect their creativity and incorporate the skills and techniques needed to share these presentations in the today's office setting. Prerequisite: None. ISP152 144 Clock Hours Microsoft Word® Using the Microsoft Word, students learn to create, edit, navigate and format documents; create tables and multi-page reports; plus enhance design and layout of documents. Students work with templates, themes, and styles to create a summary report; use mail merge by creating a form letter, labels, and a telephone directory. Students collaborate with others and integrate data. Next, students learn to customize Word and automate their work; create online forms using advanced table techniques and manage long documents. Prerequisite: None.