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	2. Semester	1	2	0	3	3

Pre-requisite Course(s)
N/A

Course Language	English
Course Type	Service Courses Taken From Other Departments
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
Major Area Courses
Supportive Courses	X
Media and Managment Skills Courses
Transferable Skill Courses

The Relation Between Course Learning Competencies and Program Qualifications

#	Program Qualifications / Competencies	Level of Contribution
#	Program Qualifications / Competencies	1	2	3	4	5
1	Understanding and explaining the concepts regarding to the main fields of Management (Management, Production, Marketing, Accounting- Finance) and gaining the ability to apply these skills in management.
2	Gaining the ability to use technology required for buseiness administration					X
3	An ability to analyze the information and reports of the markets and businesses and setting goals with respect to results of the analysis.
4	An ability to trace and evaluate the global, local and/or regional developments related to businesses and making strategic decisions.
5	An ability to set a innovative business or an ability to use the knowledge in the operations of management(taking risk, finding resources, making market research, and preparing business plans etc.)
6	An ability to apply knowledge regarding functions of management.
7	An ability to have oral and written communication skills particular to management and use these skills effectively in professional relations
8	Compliance with rules of Socials and business ethics and to the principles of social responsibility
9	An ability to use life-long learning approach in order to adapt constantly changing environmental factors (technological, political ,economical, and socio cultural etc.)	X
10	An ability to conduct research on management and reporting the outcomes with the related parties.			X
11	Taking responsibility within the teamwork, thinking critically and taking initiative in problem solving.
12	Using professional English in written and verbal communication. ("European Language Portfolio Global Scale", Level B1)
13	Having knowledge about law required by management.

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