CCS 2

• City of Good Character
• Writer/Illustrator

  Maricel M. Fajardo
• TLE-Information and Communication Technology
• Department of Education
• This module was designed and written with you in mind. It is here to help you develop knowledge, skills, and attitudes in the performance of Contact Center Services tasks. The scope of this module permits it to be used in many different learning situations. The language used recognizes the diverse vocabulary level of students. The lessons are arranged to follow the standard sequence of the course. But the order in which you read them can be changed to correspond with the textbook you are now using.
• This module is the continuation of Lesson 2 in Module 1 which is all about Perform Basic Computer Software Operations and Internet Navigations.
• After going through this module, you are expected to:

  • Identify the basic computer software and its functions such as Operating System, Word Processor, Spreadsheet, and Presentation Software
  • Make use of the different basic computer software to create files
  • Develop a product or service using basic computer programs
  • Apply creativity and innovative techniques to deliver quality outputs
• Cell references


  Used to change values at any time
• Figure 1 shows numbers entered on cells A1, A2, and A3. These numbers were added on cell A4 using their cell references.
• Figure 2 shows the final result on cell A4 after pressing Enter key.
• Because we are using cell references for A1, A2, and A3, these values can be changed at any time and A4 will still show an accurate result.
• All formulas in Excel return a result, even when the result is an error.
• Below a formula is used to compute for the given discount of an item and will return the discounted price. The formula returns a correct result in cells D3 to D4 but returns a #NAME? error in D5, because the formula has a missing number of the cell:
• Function


  A formula with a special name according to its purpose. Most functions require inputs to return a result. These inputs are called "arguments".
• Excel Functions

  • SUM function - returns the sum of given references
  • AVERAGE function - returns the average of given references
  • MIN and MAX functions - return minimum and maximum values, respectively
• How to enter a function

  1. Enter equals sign (=) and start typing. Excel will list of matching functions based as you type

  2. Click the Tab key in the keyboard to accept a function. Excel will complete the function

  3. Fill in required arguments by highlighting the required cells

  4. Press Enter key to confirm formula
• Order of operations

  Sequence Excel follows when solving a formula: Parentheses, Exponents, Multiplication and Division, Addition and Subtraction, Concatenation, Logical operators
• Presentation Software


  Desktop or cloud-based application that allows the user to present information to an audience using a sequence of multimedia formats, such as images, video, audio and text
• Choose a theme in PowerPoint


  On the File tab of the Ribbon, select New, and then choose a theme. PowerPoint shows you a preview of the theme, with four color variations to choose from on the right side. Click Create, or pick a color variation and then click Create.
• Insert a new slide in PowerPoint

  On the Home tab, click the bottom half of the New Slide, and pick a slide layout.
• Save your presentation in PowerPoint

  On the File tab, choose Save. Pick or browse to a folder. In the File name box, type a name for your presentation, and then choose Save.
• Format your text in PowerPoint


  Select the text. Under Drawing Tools, choose Format. To change the color of your text, choose Text Fill, and then choose a color. To change the outline color of your text, choose Text Outline, and then choose a color. To apply a shadow, reflection, glow, bevel, 3-D rotation, a transform, choose Text Effects, and then choose the effect you want.
• Add pictures in PowerPoint

  On the Insert tab, to insert a picture that is saved on your local drive or an internal server, choose Pictures, browse for the picture, and then choose Insert. To insert a picture from the web, choose Online Pictures, and use the search box to find a picture. Choose a picture, and then click Insert.
• Add shapes in PowerPoint


  On the Insert tab, select Shapes, and then select a shape from the menu that appears. In the slide area, click and drag to draw the shape. Select the Format or Shape Format tab on the ribbon. Open the Shape Styles gallery to quickly add a color and style (including shading) to the selected shape.
• Present your presentation in PowerPoint

  On the Slide Show tab, to start the presentation at the first slide, in the Start Slide Show group, click From Beginning. If you're not at the first slide and want to start from where you are, click From Current Slide.
• To get out of the Slide Show view at any time, on the keyboard, press Esc.
• Tips for creating an effective presentation

  • Less is more. Minimize the number of slides.
  • Choose an audience-friendly font size. The audience must be able to read your slides from a distance. Generally speaking, a font size smaller than 30 might be too difficult for the audience to see.
  • Keep your slide text simple. You want your audience to listen to you present your information, instead of reading the screen. Use bullets or short sentences and try to keep each item to one line.
  • Use visuals to help express your message. Pictures, charts, graphs, and SmartArt graphics provide visual cues for your audience to remember. Add meaningful art to complement the text and messaging on your slides. As with text, however, avoid including too many visual aids on your slide.
  • Make labels for charts and graphs understandable
  • Apply subtle, consistent slide backgrounds. Choose an appealing, consistent template or theme that is not too eye-catching. You don't want the background or design to detract from your message. However, you also want to provide a contrast between the background color and text color. The built-in themes in PowerPoint set the contrast between a light background with dark colored text or dark background with light colored text.
  • Check the spelling and grammar. To earn and maintain the respect of your audience, always check the spelling and grammar in your presentation.
• Web Browser


  Software program that allows a user to locate, access, and display web pages. Translates web pages and websites delivered using Hypertext Transfer Protocol (HTTP) into human-readable content.
• Web browser


  Usually shortened to "browser"
• Web browsers

  • Used primarily for displaying and accessing websites on the internet, as well as other content created using languages such as Hypertext Markup Language (HTML) and Extensible Markup Language (XML)
  • Translate web pages and websites delivered using Hypertext Transfer Protocol (HTTP) into human-readable content
• Examples of browsers

  • Early web browsers Microsoft Internet Explorer, Mozilla Firefox, Apple's Safari and Google Chrome
• Her boss asked Micah to present the annual accomplishments of the company at the upcoming company summit

  • Application software that could help her present effectively
• Rodrick is a fresh graduate applying for a job


  • Program that could help him create a resume
• Ingrid needs to search for the differences in history and cultures of Asian countries as part of her assignment in Social Studies

  • Software she needs
• Micah wanted to monitor the monthly sales of her milktea business


  • Program that could help her to easily track it
• Web browsers are used primarily for displaying and accessing websites on the internet, as well as other content created using languages such as Hypertext Markup Language (HTML) and Extensible Markup Language (XML)
• Browsers translate web pages and websites delivered using Hypertext Transfer Protocol (HTTP) into human-readable content
• Some examples of browsers are Early web browsers Microsoft Internet Explorer, Mozilla Firefox, Apple's Safari and Google Chrome