Learning Outcomes |
PO |
MME |
The students who succeeded in this course: |
|
|
LO-1 |
work with relational datas |
PO-21 Follows the innovations of own job and improves own career.
|
Examination |
LO-2 |
can be able to make e-mail operations |
PO-21 Follows the innovations of own job and improves own career.
|
Examination |
LO-3 |
have general information about internet |
PO-21 Follows the innovations of own job and improves own career.
|
Examination |
LO-4 |
have general information about web site desing |
PO-21 Follows the innovations of own job and improves own career.
|
Examination |
LO-5 |
have basic information about information systems and software projects |
PO-21 Follows the innovations of own job and improves own career.
|
Examination |
PO: Programme Outcomes MME:Method of measurement & Evaluation |
Course Contents |
Data and Database Systems. E-mail operations, Internet, Web Sites, Softwares |
Weekly Course Content |
Week |
Subject |
Learning Activities and Teaching Methods |
1 |
What is Database, Learning database structure and creating new database. Basics of Database Management Systems. |
Visual presentation, question - answer |
2 |
Introduction to MS Access. Creating Tables Primary key, data type, row, column, record concepts. Creating and running Queries |
Visual presentation, question - answer |
3 |
Creating forms on MS Access. Select, insert, update, delete operations on forms. Working with form components and introduction to visual programming |
Visual presentation, question - answer |
4 |
Creating Reports on MS Access. Adding filters to queries. Getting user defined parameters on Reports. Working with extensive queries |
Visual presentation, question - answer |
5 |
Creating e-mail accounts. Making e-mail settings. Introduction to MS Outlook. Sending and recieving e-mails. Grouping and archiving the e-mails. Contact management and creating contact lists. |
Visual presentation, question - answer |
6 |
Calendar and planning operations with MS Outlook. Task management, task assignment, accepting tasks, completing tasks. |
Visual presentation, question - answer |
7 |
Usage of other e-mail services. Sending files and documents via e-mails. |
Visual presentation, question - answer |
8 |
mid-term exam |
|
9 |
Basic concepts of Networks. TCP/IP, FTP, SMTP, HTTP, HTTPS, SSL etc.. |
Visual presentation, question - answer |
10 |
The concept of the Internet. History of the Internet. Use of the Internet and usage. Detailed information about Internet browser programs. |
Visual presentation, question - answer |
11 |
Web Site Design. HTML, CSS, Script coding. MS FrontPage, MS Publisher and Dreamviewer programs and web site design |
Visual presentation, question - answer |
12 |
Web Site Design. HTML, CSS, Script coding. MS FrontPage, MS Publisher and Dreamviewer programs and web site design |
Visual presentation, question - answer |
13 |
What is software? What is the software development life cycle? Basic information about the system development methods. |
Visual presentation, question - answer |
14 |
Web site development project. , the basic principles of the use of e-commerce and E-government systems |
Visual presentation, question - answer |
15 |
Web site development project. , the basic principles of the use of e-commerce and E-government systems |
Visual presentation, question - answer |
16 |
final exam |
|
Recommend Course Book / Supplementary Book/Reading |
1 |
İ. Sarı, Ö. Bağcı "Bilgisayar - II," Seçkin Yayınları 4. baskı, Eylül-2008 |
2 |
Ö. Bağcı "Bilgisayarın B'si Windows XP – Office 2003," Seçkin Yayınları 2. Baskı, Şubat-2006 |
Required Course instruments and materials |
Desktop Computer |