Description
The purpose of this course is that students understand the basic concepts of a computer system and its applications as well as their practical uses. Especially, through extensive exercises of MS Excel for data management and analysis and MS Porwerpoint for effective presentation, students will improve their ability of operating computer systems and applications, and increase the chance of achieving computer related certificates. Also, students will improve their problem solving skill with computational ways by familiarizing simple programming tools.
Instructor
Kyungbaek Kim
Office : Engineering Building #6, 715
Tel : +82-62-530-3438
Email : kyungbaekkim@jnu.ac.kr
Office Hours : Monday 15:00 ~ 16:00
Time and Location
Mon 13:00~15:00, Wed 13:00~15:00, University Computing Center, #109
Main Text
- 원리와 개념에 충실한 엑셀과 파워포인트 2013, 홍의경, 박종학 지음, 생능출판
Reference Text
- 회사에서 바로 통하는 엑셀 2013, 한은숙 지음,한빛미디어(주)
- 회사에서 바로 통하는 파워포인트 2013, 전상오 지음,한빛미디어(주)
Grading Policy
- Attendance : 15%
- Exercises and Assignments : 35%
- Midterm Exam : 25%
- Finalterm Exam : 25%
Lecture Notes
- 0.Syllabus
- 01.Excel basic
- 02.Worksheets and Data Inserting (exercise02)
- 03.Equations (exercise03)
- 04.Editing Worksheets (exercise04)
- 05.Functions (exercise05)
- 05-1.Functions-1 (exercise05-1)
- 06.Forms (exercise06)
- 07.Database and index (exercise07)
- 07-1.Database and index-1 (exercise07-1)
- 08.Charts (exercise08)
- 09.Printing (exercise09)
- 10.Pivot table (exercise10)
- 11.Analysis (exercise11)
- 12.Importing and Exporting (exercise12)
- 13.Macro (exercise13)
- 14.Extra (exercise14)
Lecture notes are accessible through the eClass of JNU portal.
Media Resources
All of the materials related to homeworks, quiz, midterm exam and final exam, including solutions, are accessible through the eClass of JNU portal.