Events

IT User Education In Summer Vacation by KAIST IT Education Volunteers

13th July, 2015 ~ 8th August, 2015 (4 weeks)

Location: 

AAiT/AU and some primary schools in Addis Ababa

IT user education plan

Purpose: Exchange educations and students of the both Institutes of AAiT/AU and KAIST to promote mutual understanding and sharing knowledge

  1. Activities

  • IT user education for the AAiT and AU students for 3 weeks on 6 courses

  • Culture exchange between two countries on weekday after class 4 times

  • Voluntary service for the primary schools on weekend 3 times together with
    AAiT students

  • Ethiopian culture inquiry trip to historical places for 4 days and 3 nights guided by AAiT students


  1. The IT user education for 3 weeks on 6 courses will be served by the following instructors from KAIST students by each course;


Course name and id (from among the IT user
courses)

Instructors who are responsible for each
courses (KAIST IT education volunteer)

Basic course

Lee Soo Yun, Kim Seong On, Park Geun Cheol, Cho Hyei Min

Intermediate course one (IC1)

Song Dae Seob, Gu Whuey Jun, Kang Ho Chan, Jang Sun Woong

Intermediate course two (IC2)

Kim Bo Mi, Kim Soo Ji, Park Sun Jeong, Lee Ju Hee

Intermediate course three (IC3)

Bae Sang Beom, Park Han Sol, Kim Na Uen, Park Chan Hyeong

Intermediate course four (IC4)

Mo Hae Lee, Kim Geun Yeong, Lee Jong Eun, Lee Chang Hwan

Intermediate course seven (IC7)

Oh Se Woong, Park Soo Jin, Lim Yeong Hwan, Kim Soo Hyeon

* The exact spelling of each
instructor’s name will be corrected later


  1. The
    schedules of culture exchange between two countries on weekday are
    as followings;


Time Schedule

Contents

The 1st week (July 15th)

Wednesday, 5~7pm

-Introducing Korea, KAIST, and
Korean companies

-Recruiting those who are interested in learning K-POP dance
and start exercise

The 2nd week (July 22nd)

Wednesday, 5~7pm

-Making Fan with drawing pictures on it or decorating a short
T-shirt

The 3rd week (July 29th)

Wednesday, 5~7pm

-Watching Korean movies

The 4th week (August 4th)

Tuesday 10am~8pm

-Korea traditional play such as Jegi
Chagi, Biseok Chigi, Ssireum, TuHo, Ddangddameokki, Yutnori,
Gonggi etc.

-K-POP performance by the recruited
group in the beginning together with the KAIST IT volunteers

-Sharing and enjoy foods prepared by both countries’ students
participated in IT education of their each cultural foods


  1. The
    Voluntary service for the primary schools on weekend schedule will
    be completed by the end of the 5
    th
    June


  1. The
    Ethiopian culture inquiry trip to historical places also will be
    scheduled by the end of the 5
    th
    June


Attachment:

IT
USER COURSE
s



Purpose
– Educate and train the people who are interested in using IT for
study, business, daily life so that they can understand and make use
of IT during they study, work or their daily lives easily and
efficiently.

Target
– The primary target of this course is AAiT preschool students and
all the students who are in need to learn IT including AAU students,
and gradually could be opened to civilians outside of the school who
are interested in these courses.

Course
– Attendees can choose between two types of level, the basic course
or the intermediate course, according to their capability of using
IT. The basic course is composed of
computer
basics and basic functions of several office tools such as word
processor, presentation tool and spread sheet and the intermediate
courses are composed of detailed and sophisticated features of
various kinds of tools of office automation and data management,
including simple techniques being used to develop personnel blog and
café within internet website etc.

Basic Course
only one type is served

  • Target
    users – Basic IT runners or the novice in using computer

  • Objective
    – To have the learner understand IT and can handle computer as
    they need

  • Prerequisite
    - None

  • Duration
    – 60 hours (3 weeks)

  • Course
    composition - IT101 (for 1 week) + Basic functions* of IT102, IT103,
    IT104 (for 2 weeks)

* choose some basic functions
from IT102, IT103, IT104 for users to understand and can use simple
functions but are reasonable to teach within 2 weeks all together.

Intermediate
Course
– various types are
served according to the user’s preference

IC1: Intermediate
Course One
– Advanced OA
package user

  • Target
    users – Those who are interested in using the advanced functions
    of Word Processor, Power Point, and Excel

  • Objective
    – To have the learner trained in using OA package

  • Prerequisite
    – Those who have passed the basic course or admitted to have the
    equivalent level of knowledge asked to register this course

  • Duration
    – 60 hours (3 weeks)

  • Course
    composition – Advanced functions of IT102, IT103, IT104


IC2: Intermediate
Course Two
– Advanced Excel
user

  • Target
    users – Those who are interested in using deep functions of Excel

  • Objective
    – To have the learner trained and specialized in using Excel

  • Prerequisite
    – Those who have passed the basic course or admitted to have the
    equivalent level of knowledge asked to register this course

  • Duration
    – 60 hours (3 weeks)

  • Course
    composition – Advanced and specialized functions and of IT104 and
    IT 201

IC3: Intermediate
Course Three
– Data Manager

  • Target
    users – Those who are interested in using IT for their data
    management work

  • Objective
    – To have the learner trained in using Excel and Access

  • Prerequisite
    – Those who have passed the basic course or admitted to have the
    equivalent level of knowledge asked to register this course

  • Duration
    – 60 hours (3 weeks)

  • Course
    composition – Advanced and specialized functions and of IT104 and
    IT 202

IC4: Intermediate
Course Four
– Advanced Power
point and Photoshop user

  • Target
    users – Those who are interested in using advanced functions of
    Power point and Photoshop

  • Objective
    – To have the learner trained and specialized in using Power point
    and Photoshop

  • Prerequisite
    – Those who have passed the basic course or admitted to have the
    equivalent level of knowledge asked to register this course

  • Duration
    – 60 hours (3 weeks)

  • Course
    composition – Advanced functions and of IT103 and IT 203

IC5: Intermediate
Course Five
– Advanced Android
Smart Phone user

  • Target
    users – Those who are interested in using advanced functions of
    Smart Phone

  • Objective
    – To have the learner trained and specialized in using Smart Phone

  • Prerequisite
    – Those who have passed the basic course or admitted to have the
    equivalent level of knowledge asked to register this course

  • Duration
    – 60 hours (3 weeks)

  • Course
    composition – IT204 and other materials connected to Android Smart
    Phone

IC6: Intermediate
Course Six
– Advanced Blogger
and Café Manager

  • Target
    users – Those who are interested in develop and manage Blog and
    Cafe

  • Objective
    – To have the learner to develop and manage Blog and Cafe

  • Prerequisite
    – Those who have passed the basic course or admitted to have the
    equivalent level of knowledge asked to register this course

  • Duration
    – 60 hours (3 weeks)

  • Course
    composition – IT205 and other materials connected to develop and
    manage Blog and Cafe

IC7: Intermediate
Course Seven
– Advanced Computer
user

  • Target
    users – Those who are interested in using advanced and complicated
    functions of computer

  • Objective
    – To have the learner to be trained in using computer as he/she
    needed

  • Prerequisite
    – Those who have passed the basic course or admitted to have the
    equivalent level of knowledge asked to register this course

  • Duration
    – 60 hours (3 weeks)

  • Course
    composition – IT206 and other materials connected to the course


Course
table





Subject

Subject
Code

Topics to
be covered

Estimated
time

Computer basic

  1. IT101

  1. Windows

  1. Windows
    7,8,8.1 & 10 starting

  2. 2.
    File and directory handling

  3. 3.
    Supplement programs

  4. 4.
    Control panel

5.
System management

  1. Internet

  2. 1.
    Internet use

  3. 2.
    Using utilities

  4. 3. Using browsers –
    IE, Chrome

1 week

Word processor

IT102

1.
MS word understanding and starting

2.
Document handling using editor

3.
Systematic document management

4.
Using insert functions

5.
Using various object in editing

6.
Using table functions

7.
Using chart functions

8.
Using drawing functions

9.
Using design functions

10.
Using printing functions

11.
Using reference features

12.
Using mailing functions

13.
Using view functions

14. Other
useful functions

2 weeks

Power
point

(2007,2010,2013)

IT103

1.
Starting Power point

2.
Title slide creating

3.
Slide editing

4.
Input character/symbol/others

5.
Draw slide creating

6.
Inserting picture/clipart/word art

7.
Office online clipart

8.
Inserting smartart

9.
Table/chart slide creating

10.
Inserting movie/sound/hyperlink

11.
Master slide creating

12.
Printing

13.
Slide show

14.
Animation effect

15. Applying screen change
effect

2 weeks

Excel
(basic)

(2007,2010,2013)

IT104

1.
Starting and closing Excel

2.
Data input and update

3.
Reduce errors by validation test

4.
Quick input using automatic filling

5.
Dealing cell and change cell format

6.
Dealing worksheet

7.
Changing style

8.
Learning various copy functions

9.
Learning various calculate functions

10.
Referencing absolute/relative address

11.
Statistical functions

12.
Mathematic/trigonometric functions

13.
Logical functions

14.
Search/reference functions

15.
Sort/filter functions

16. Printing
options

2 weeks

Excel
(2007,2010,2013)

IT201

1.
Data input cell working

2.
Integrated document management

3.
Report format type define for the better use

4.
Using of various practical functions

5.
Using various chart showing data in short

6.
Screen view and printing various type

7.
Data management and analysis

8.
Data protection and document security

9.
Virtual analysis and other useful functions

10.
Macro automating the repeating works

11.
Handling functions

12.
Membership management

13. Sales
detail analysis

2 weeks

Access
(2007,2010,2013)


IT202

1.
Create data base

2.
Summarizing

3.
Sorting

4.
Retrieving

5.
Querying

6.
Linked table management system

7.
Create Email and manage replies

8. Visual
Basic for Access

2 weeks

Photoshop
(CS5,CS6)

IT203

1.
Learning Photoshop basic functions

2.
Indicating domain using selection tool

3.
Move/copy/paste the selected image

4.
Investigate the layers

5.
Composing images

6.
Filling color

7.
Manipulating color/bright

8.
Manipulate personal looks

9.
Making personnel proof photo

10.
Making photo background effective

11.
Making photo frame

12.
Design font

13.
Drawing using pen-tool

14.
Making personal signature

15.
Effecting filter

16. Animation
developing

2 weeks

Using android smart phone

IT204

1.
Understanding smart phone

2.
Practicing the basic smart phone functions

3.
Utilizing Playstore

4.
Utilizing multimedia app

5.
Utilizing live convenient app

6.
Utilizing business related app

7.
Establishing smart phone security

8.
Personnel information management

9. Backup and
recovery of data

3 weeks

Blog &
cafe

IT205

Blog

1.
Becoming a member of a portal

2.
Create personnel Blog

3.
Decorating personnel profile

4.
Choosing skin

5.
Establishing items

6.
Create and management of category

7.
Writing post

8.
Neighbor management

9.
Managing reply/comment

10.
Scraping

11.
Sending to meta blog

12.
Analyzing visitors

Café

1.
Opening cafe

2.
Decorating café home

3.
Design my own title

4.
Create and management of category

5.
Writing café

6.
Managing posted writings

7.
Managing café membership

8.
Using tag

9. Using
Drive storage and cloud computing

2 weeks

Using my
computer 100 times

IT206

1.
Using user account and password

2.
Personnel folder and file protection

3.
Using web browser

4.
Protecting virus and malignant code

5.
Using zipped program

6.
Recovering deleted file

7.
Utilizing sound file

8.
Utilizing text and image

9.
Editing and utilizing multimedia data

10.
Information gathering and using knowhow

2 weeks

Image: