All in One University Students' Course Contents

 

All in One University Students' Course

පාඨමාලා අන්තර්ගතයන් -

ICT Fundamentals

• Introduction to ICT

• Data vs Information

• Information and Communication Systems

• Basic tasks of Computer systems
  

• Types of Computers

• Parts of computer systems
  

• Peripheral Devices

• Usage of different types of computers in different fields

  
  

Microsoft Word Course Contents

• ·         MS Word Introduction
• ·         How to Open/New/Save documents
• ·         Basic Texting (Sinhala / English Typing)
• ·         Text Formatting
• ·         Paragraphs Formatting
• ·         Indents and Tabs
• ·         Tabs for creating table of contents
• ·         Find and Replace option
• ·         Bullets and Numbering
• ·         Page Layouts
• ·         Header Footer
• ·         Page Numbering
• ·         Picture Text Wrapping
• ·         Picture Formatting
• ·         Inserting Shapes
• ·         Inserting Tables
• ·         Inserting Charts
• ·         Smart Art Graphics
• ·         Inserting Text Box
• ·         Inserting Hyperlinks
• ·         Inserting Equations in MS Word
• ·         Align/ Arrange/ Group
• ·         Column Break and Page Break
• ·         Spelling Checker
• ·         Styles for Docs
• ·         Mail Merge
• ·         References tab ( Citation, Table of content, Table of figures)
• ·         Creating Professional Reports (Eg: Management Reports, University reports..)
• ·         Creating cover pages
• ·         Creating templates for
• Calendars
• Business letter
• Resumes (CV) and cover letters
• Newsletter
• Reports
• Invoices and bills
• Certificates
• ·         Word for artistic designing ( Eg: Birthday Card, Invitation cards…)
• ·         Word for Creative Designing (Eg: Brochures and flyers)
• ·         Creating layouts for books and Magazines
• ·         Macros in MS Word

 

 

Microsoft Excel Course Contents

• ·         Introduction to MS Excel
• ·         Basics of Cells
• ·         Modifying Columns Rows and Cells
• ·         Cell Formatting
• ·         Number Formats
• ·         Basics of Data Storing
• ·         Basics of Data Organizing
• ·         Start to Formulas
• ·         Complex Formulas
• ·         Relative and Absolute Reference
• ·         Excel Functions
• ·         Freezing Panes
• ·         Sorting Data
• ·         Filtering Data
• ·         Excel Tables
• ·         Excel Charts
• ·         Conditional Formatting
• ·         Pivot Tables
• ·         Sub Total
• ·         Range Names
• ·         Lookup Functions
• ·         The INDEX Function
• ·         The MATCH Function
• ·         Text Functions
• ·         Date Functions
• ·         Excel Financial Functions
• ·         Depreciation Functions
• ·         IF Analysis
• ·         The COUNTIF, COUNTIFS, COUNT,COUNTA, and COUNTBLANK Functions
• ·         The SUMIF, AVERAGEIF, SUMIFS and AVERAGEIFS Functions
• ·         Pivot Tables and Slicers to Describe Data
• ·         Data Validation
• ·         Summarizing Data
• ·         Consolidating Data
• ·         Reporting and Visualization of analyzed data
• ·         Macro Recorder
• ·         Creating Accounting models
• ·         Creating Dynamic Dashboards

 

Microsoft PowerPoint Course Contents

• ·         MS PowerPoint Introduction 
• -     Introduction to Presentations
• ·         Basics of Slides
• ·         Text Formatting
• ·         Paragraph Formatting
• ·         Designing Backgrounds
• ·         Designing customized themes for Slides
• ·         Slide Transitions
• ·         Slide Animations
• ·         Action Buttons and hyperlinks
• ·         Inserting Audio Files
• ·         Inserting Video Files
• ·         Inserting Tables
• ·         Inserting Charts
• ·         Inserting Smart Arts
• ·         Inserting Objects ( Eg: MS Excel Sheets, MS Word..)
• ·         Slide Show techniques
• ·         Recording and Rehearsing Slide Shows
• ·         Creating Lecture notes, Tutorials and Handouts
• ·         Creating Animation Videos for Advertising
• ·         Creating Templates for Professional presentations
• ·         Macros in PowerPoint
• ·         Protecting and Printing the Slide show
  

 

 SPSS Course Contents

• 
  - Introduction to SPSS
  
• - Data Management
• - Data Transformation
• - Graphs and Numerical Measures
• - Frequency analysis
• - Descriptive Analysis
• - Correlation analysis
• - Regression Analysis
• - Data Reduction and Scale Reliability
• - Performing Parametric Hypothesis Testing

 

Adobe Photoshop Course Contents

• ·         Introduction Graphic Designing
• ·         Special terms and applications in Graphic designing
• ·         Introduction to Photoshop/ History/ Workspace
• ·         Key Board practice - Shortcut keys & commands
• ·         Opening and Importing images, Creating Documents with different sizes
• ·         Full Review to toolbox in Photoshop - 70 Tools
• ·         Basic Tasks in Adobe Photoshop
• ·         Best Selection tools in Photoshop and easy ways to do Selections
• ·         Layers/Layer Merging/Layer Ordering/Layer Masks/Layer Styles/Adjustment Layers
• ·         Texting in Photoshop and Special effects on texts (Typography)
• ·         Creative designing (Flyers/ Broachers/ Posters/ Web Banners/ Logos etc.. )
• ·         Color theories and color psychology in Creative designing
• ·         How to use Photoshop for Advertising
• ·         Color and lighting corrections in Photos
• ·         Filters (effects) for any photograph.
• ·         Photographic Retouching
• ·         Photographic /Cloning/Healing
• ·         Photoshop Filters (effects) on Photographs
• ·         Special Tricks and effects on Photo editing and retouching
• ·         Pen tool for Drawing and Making selections
• ·         Brushes and different Brush presets
• ·         Custom shapes and Smart Objects
• ·         Photo Manipulations
• ·         Actions (Recorder) in Photoshop
• ·         Making Animations ( GIFs and Videos) in Photoshop