ECTS - Computer and Information Systems

Computer and Information Systems (CMPE106) Course Detail

Course Name Course Code Season Lecture Hours Application Hours Lab Hours Credit ECTS
Computer and Information Systems CMPE106 1 2 0 3 3
Pre-requisite Course(s)
N/A
Course Language English
Course Type N/A
Course Level Bachelor’s Degree (First Cycle)
Mode of Delivery
Learning and Teaching Strategies Lecture.
Course Coordinator
Course Lecturer(s)
Course Assistants
Course Objectives Students will learn how to use Microsoft Excel and Frontpage. At the end of the course, students will have knowledge about creating workbooks, formulas and functions, use of financial, logical, mathematical and statistical functions, drawing graphs and charts and perform financial formulas. Learn how to develop a web site.
Course Learning Outcomes The students who succeeded in this course;
  • Acquire and develop skills in using productivity tools.
  • Format, analyze and manage data. Create workbooks and display data in graphical form. Creating and designing a web site.
  • Practical sessions and exercises are introduced to reinforce the understanding of concepts, and increase students’ involvement and participation.
Course Content Introduction to Microsoft Excel (create workbooks, spreadsheets, formulas, functions, formatting, graphs); introduction to HTML and web design (insert Text, graphics, templates and designing from blank pages, insert tables, hyperlink, creating, checking and manipulating forms, manipulating files and folders, navigation bars, themes, shared borders,

Weekly Subjects and Releated Preparation Studies

Week Subjects Preparation
1 Introduction to Microsoft Excel Spreadsheet Basics - Screen elements - Adding and renaming worksheets - The standard toolbar - opening, closing, saving, and more. Customizing Excel - Menus - Customize toolbars Computer and Information Systems Laboratory Manual, 2004 Pg. 50-57 and Other Sources
2 Sorting and Filling  Basic ascending and descending sorts  Complex sorts  Autofill  Alternating text and numbers with Autofill Page Properties and Printing  Page breaks  Page orientation  Margins  Headers, footers, and page numbers  Print Preview  Print Computer and Information Systems Laboratory Manual, 2004 Pg. 50-57 and Other Sources
3 Formatting and Enhancing Worksheet’s Appearance Modifying A Worksheet  Moving through cells  Adding worksheets, rows, and columns  Resizing rows and columns  Selecting cells  Moving and copying cells Formatting Cells  Formatting toolbar  Format Cells dialog box  Dates and times  Styles  AutoFormat Computer and Information Systems Laboratory Manual, 2004 Pg. 57-65 and Other Sources
4 Using Formulas and Built-in Functions Formulas and Functions  Formulas  Linking worksheets  Relative, absolute, and mixed referencing  Basic functions  Function Wizard Computer and Information Systems Laboratory Manual, 2004 Pg. 65-70 ve Diğer Kaynaklar
5 Using Formulas and Built-in Functions Formulas and Functions  Formulas  Linking worksheets  Relative, absolute, and mixed referencing  Basic functions  Function Wizard Computer and Information Systems Laboratory Manual, 2004 Pg. 65-70 and Other Sources
6 Use of Statistical Logical and Lookup Functions Built-in Functions (PMT, If, Countif CountA, Count, Lookup) Computer and Information Systems Laboratory Manual, 2004 Pg. 70-74, 83-89 and Other Sources
7 Graphs and Charts Charts  Chart Wizard  Resizing a chart  Moving a chart  Chart formatting toolbar  Copy a chart to Microsoft Word Computer and Information Systems Laboratory Manual, 2004 Pg. 79-83 and Other Sources
8 Graphs and Charts Charts  Chart Wizard  Resizing a chart  Moving a chart  Chart formatting toolbar  Copy a chart to Microsoft Word Computer and Information Systems Laboratory Manual, 2004 Pg. 79-83 and Other Sources
9 Introduction to Microsoft FrontPage  Definitions  Screen layout  Views  Create a web using the web wizard  Create a web page from a template  Report view  Open a web  Save a web Other Sources (Instructor’s web sites)
10 Page Properties  General properties  Themes  Removing a theme Text  Font properties  Headings  Converting text to tables Hyperlinks  Creating links  E-mail links  Bookmarks  Hotspots Other Sources (Instructor’s web sites)
11 Tables  Table uses  Creating a table  Table properties  Cell properties  Inserting rows and columns  Spanning cells Graphics and Pictures  Image types  Inserting a graphic  Picture properties Other Sources (Instructor’s web sites)
12 Modifying Themes  Colors  Graphics  Text  Saving a modified theme Other Sources (Instructor’s web sites)
13 Frames  What are frames?  Create a frames page  Frame properties  Linking in frames  No frames page Other Sources (Instructor’s web sites)
14 Forms  Form page wizard  Forms toolbar  Text box  Text area  Check box  Radio button  Drop-down menu Miscellaneous  Horizontal lines  Symbols  Comments Other Sources (Instructor’s web sites)

Sources

Course Book 1. Computer and Information Systems Laboratory Manual, 2004, Atılım University Publication, Department of Computer Engineering, Asst. Prof. Dr. Nevzat SEZER, Gül TOKDEMİR, Bülent G. EMİROĞLU, Meltem G. ERYILMAZ
Other Sources 2. Adım Adım Microsoft Excel 2000, Arkadaş Yayınevi
3. Bilişim Teknolojileri, ECDL + Microsoft Office, 2005, TOBB Ekonomi ve Teknoloji Üniversitesi Yayınları, Ali Yazıcı, Y. Murat Erten, Erdoğan Doğdu, Anıl Üstün
4. The O'Leary Series: Office XP, Volume I, Timothy J O'Leary, Linda I. O'Leary, McGraw-Hill/Irwin, 1st Edition, 2001.

Evaluation System

Requirements Number Percentage of Grade
Attendance/Participation 14 5
Laboratory - -
Application - -
Field Work - -
Special Course Internship - -
Quizzes/Studio Critics - -
Homework Assignments 2 10
Presentation - -
Project 1 20
Report - -
Seminar - -
Midterms Exams/Midterms Jury 1 30
Final Exam/Final Jury 1 35
Toplam 19 100
Percentage of Semester Work 60
Percentage of Final Work 40
Total 100

Course Category

Core Courses X
Major Area Courses
Supportive Courses
Media and Managment Skills Courses
Transferable Skill Courses

The Relation Between Course Learning Competencies and Program Qualifications

# Program Qualifications / Competencies Level of Contribution
1 2 3 4 5
1 Adequate knowledge in mathematics, science and subjects specific to the computer engineering discipline; the ability to apply theoretical and practical knowledge of these areas to complex engineering problems.
2 The ability to identify, define, formulate and solve complex engineering problems; selecting and applying proper analysis and modeling techniques for this purpose.
3 The ability to design a complex system, process, device or product under realistic constraints and conditions to meet specific requirements; the ability to apply modern design methods for this purpose.
4 The ability to develop, select and utilize modern techniques and tools essential for the analysis and determination of complex problems in computer engineering applications; the ability to utilize information technologies effectively.
5 The ability to design experiments, conduct experiments, gather data, analyze and interpret results for the investigation of complex engineering problems or research topics specific to the computer engineering discipline.
6 The ability to work effectively in inter/inner disciplinary teams; ability to work individually
7 Effective oral and writen communication skills in Turkish; the knowledge of at least one foreign language; the ability to write effective reports and comprehend written reports, to prepare design and production reports, to make effective presentations, to give and to receive clear and understandable instructions.
8 Recognition of the need for lifelong learning; the ability to access information, to follow recent developments in science and technology.
9 The ability to behave according to ethical principles, awareness of professional and ethical responsibility; knowledge of the standards utilized in computer engineering applications.
10 Knowledge on business practices such as project management, risk management and change management; awareness about entrepreneurship, innovation; knowledge on sustainable development.
11 Knowledge on the effects of computer engineering applications on the universal and social dimensions of health, environment and safety; awareness of the legal consequences of engineering solutions.
12 An ability to describe, analyze and design digital computing and representation systems.
13 An ability to use appropriate computer engineering concepts and programming languages in solving computing problems.

ECTS/Workload Table

Activities Number Duration (Hours) Total Workload
Course Hours (Including Exam Week: 16 x Total Hours) 16 3 48
Laboratory
Application
Special Course Internship
Field Work
Study Hours Out of Class 16 1 16
Presentation/Seminar Prepration
Project
Report
Homework Assignments 2 1 2
Quizzes/Studio Critics
Prepration of Midterm Exams/Midterm Jury 1 5 5
Prepration of Final Exams/Final Jury 1 6 6
Total Workload 77