Introduction to Application Packages

1. Define application software.
2. Use Microsoft Word processing package.
3. Use Excel spreadsheet.
4. Use Microsoft PowerPoint for presentation.
5. Describe graphic packages.
6. Learn fundamentals of database development packages.

13 weeks, about 56 hours in total. Yours will differ.

1. Week 1Module 1: Definition and Description of Application Software

   • Unit 1: Introduction to Application Packages · 4 hours

     Understand the concept of application packages.. Explain versions, releases, and compatibility..

2. Week 2Module 1: Definition and Description of Application Software

   • Unit 2: Categories of Application Software · 4 hours

     Define entertainment, home/personal, education/reference, productivity, and specialty software.. Differentiate features of application software categories..

3. Week 3Module 1: Definition and Description of Application Software

   • Unit 3: Common Features of Software · 4 hours

     Explain basic features in a typical user interface.. Explain tutorials and documentation.. Define freeware, shareware, and proprietary software..

4. Week 4Module 2: Word Processing Package

   • Unit 1: Introduction to Microsoft Word Environment · 4 hours

     Understand the Microsoft Word environment.. Use the title bar, Ribbon, file tab, and backstage view.. Create, print, and save documents..

5. Week 5Module 2: Word Processing Package

   • Unit 2: Drawing Object, Page Background, Applying Bullets and Numbers · 4 hours

     Draw objects using insert shapes.. Use WordArt and format shapes.. Insert charts.. Apply watermarks and page borders..

6. Week 6Module 2: Word Processing Package

   • Unit 3: Document View and Basic Editing Skills · 4 hours

     Change document view.. Hide and show the ruler.. Zoom the document.. Work in a new document window.. Use basic proofing tools..

7. Week 7Module 3: Presentation Package: PowerPoint

   • Unit 1: Introduction to PowerPoint · 4 hours

     Understand the PowerPoint environment.. Use the file back view and the Ribbon.. Create a new presentation.. Insert new slides and share presentations..

8. Week 8Module 3: Presentation Package: PowerPoint

   • Unit 2 Using Text in PowerPoint and Using Pictures in PowerPoint · 4 hours

     Use text in PowerPoint.. Insert pictures saved on PC.. Use online pictures.. Use PowerPoint picture tools.. Print a PowerPoint presentation..

9. Week 9Module 4: Excel Spreadsheets

   • Unit 1: Introduction to Excel · 4 hours

     Understand what Excel is used for.. Familiarize with Microsoft Excel startup workbook.. Learn Excel interface/features/ribbon.. Understand structure of an Excel workbook..

10. Week 10Module 4: Excel Spreadsheets

    • Unit 2: Editing Text and Working with Formulas in Excel · 4 hours

      Create spreadsheet titles.. Work with SUM(), MIN(), AVERAGE(), and COUNT() functions..

11. Week 11Module 4: Excel Spreadsheets

    • Unit 3: Modifying, Inserting of Images, Shapes and Working with SmartArt and also Printing in Excel · 4 hours

      Move and copy data.. Insert and delete rows and columns.. Change cell width and length.. Format data as currency values.. Use conditional formatting..

12. Week 12Module 5: Graphics Design and Microsoft Access

    • Unit 1: Introduction to Graphics Design · 4 hours

      Define graphics design and its history.. Describe industry specializations.. Understand elements and principles of design..

13. Week 13Module 5: Graphics Design and Microsoft Access

    • Unit 2– Introduction to Adobe Photoshop · 4 hours

      Understand Adobe Photoshop as a bitmap application.. Navigate the Photoshop landscape.. Use Photoshop tools.. Adjust images in Photoshop..

    • Unit 3: Introduction to CorelDraw · 4 hours

      Define CorelDraw and its overview.. Work with paged documents.. Create basic shapes and apply transformations.. Work with text in CorelDraw..