Anadolu Info Package Anadolu Info Package
  • Info on the Institution
  • Info on Degree Programmes
  • Info for Students
  • Turkish
    • Turkish Turkish
    • English English
Profile of the Programme Specific Admission Requirements Qualification Requirements and Regulations Recognition of Prior Learning Educational Staff Programme Director & ECTS Coord. Field Qualifications Key Learning Outcomes Course Structure Diagram with Credits Matrix of Program Outcomes&Field Qualifications Matrix of Course& Program Qualifications Examination Regulations, Assessment and Grading Graduation Requirements Access to Further Studies Occupational Profiles of Graduates
  • Eskişehir Vocational School
  • Dep. Of Office Management and Secretarial Training
  • Program in Bureau Administration and Admin.Ass.
  • Course Structure Diagram with Credits
  • Spreadsheets
  • Learning Outcomes
  • Description
  • Content
  • Learning Outcomes
  • Learning Activities and Teaching Methods
  • Course's Contribution to Prog.
  • Assessment Methods

  • Creates workbook and works with data
  • Recognizes the spreadsheet program Interface.
  • Knows the use of Title bar, Tabs, Address Bar, Formula Bar, Scroll Bars, Gridlines, Status Bar.
  • Creates new workbook, saves, closes, opens saved workbooks.
  • Can add pages, rename pages, hide pages, delete pages, move and copy pages
  • Can use formulas to analyze data.
  • Changes data, Knows different selection techniques, Can delete data and cells, move and copy.
  • Understands the causes of formula errors
  • Understands the usage of ready-made functions in Excel
  • Applies mathematical, financial and IF functions on examples
  • Can work with worksheets and windows.
  • Print preview with Page settings and printing in Excel
  • Understands Split and Freeze Windows, Arrange and Hide Windows
  • Can draw graphs in Excel
  • Has knowledge of Chart types, Chart options, Chart formatting.
  • Analyzes data in Excel.
  • Sorts, filters data
  • Can sort, filter, subtotal by more than one field.
  • Knows advanced filtering methods
  • Quickly lists data that meets multiple conditions
  • Creates data validation rule with formula
  • Uses the Add Function option.
  • Performs operations on Sum, Average, If functions
  • Searches and references with Add Function
  • Recognizes financial functions.
  • Knows the use of some Statistical functions
  • Creates a pivot table
  • Can create pivot table for more than 3 fields
  • Can create pivot charts and scenarios

  • Info on the Institution
  • Name and Adress
  • Academic Calendar
  • Academic Authorities
  • General Description
  • List of Programmes Offered
  • General Admission Requirements
  • Recognition of Prior Learning
  • Registration Procedures
  • ECTS Credit Allocation
  • Academic Guidance
  • Info on Degree Programmes
  • Doctorate Degree / Proficieny in Arts
  • Master's Degree
  • Bachelor's Degree
  • Associate Degree
  • Open&Distance Education
  • Info for Students
  • Cost of living
  • Accommodation
  • Meals
  • Medical Facilities
  • Facilities for Special Needs Students
  • Insurance
  • Financial Support for Students
  • Student Affairs Office
  • Info for Students
  • Learning Facilities
  • International Programmes
  • Practical Information for Mobile Students
  • Language courses
  • Internships
  • Sports and Leisure Facilities
  • Student Associations