UEC 02 – Computer Skills & Programming Concepts II

Course lecturer :

Assistant Prof. Dr. Mona Abou-Of

Course assistant :

Eng. Mohamed Ahmed Taha
Eng. Maher Habashy
Eng. Angy Saleh
Eng. Yasser Abd El Aziz
Eng. Reham Refaat
Eng. Nehal Essam
Eng. Amany Adel
Eng. Doaa Goda
Eng. Hend Mohamed
Eng. Soha Essam
Eng. Amany Ibrahim
Eng. Islam Farid Mustafa
Eng. Sarah Ahmed Morsy
Eng. Samah Elnagar
Eng. Maha Ali
Eng. Islam Adel
Eng. Shereen Alaa
Eng. Heba Elsayied
Eng. Neamaa Mihamed
Eng. Asmaa Mohamed
Eng. Hend Abd Elmoniem
Eng. Sarah Ahmed Abd Elhamed
Eng. Osama Mustafa
Eng. Alshimaa Samy
Eng. Soha Mahmoud
Eng. Elham Magdy

Course objectives :

1- Upon completing the course, Student will learn:
– Spreadsheet
Manual versus electronic spreadsheet, What is Excel tool?, Exploring Microsoft excel, Basic workbook skills, Formatting and customizing data, Formulas, functions and named ranges, Referencing, Editing multiple worksheets, Sorting, Page properties and printing, What-If analysis, Charts.
– Databases
Introduction to database concepts and access, Access concepts, Terminology and usage, Database design and table operations, Table formatting, Relationships, Querying a database, Forms, Reports.
– Hypertext Markup Language
HTML elements, HTML document structure, HTML document naming scheme, Basic of inline and Block-level tags, List and character entities, Images and links, Tables, Search engines.
2- Student will be able to:
• How to enter and format the three types of spreadsheet data: numbers, text, and formula.
• Edit text, values, formulas, and pictures and move and copy data.
• Work with absolute and relative references, and work with ranges, rows, and columns.
• Work with simple functions, basic formatting techniques, and printing.
• Create and modify charts, and learn how to manage large workbooks.
• Perform “what-if” analysis.
• Design and create databases
• Work with tables, fields, and records, sort and filter data
• Create table relationships to efficiently retrieve data from multiple tables
• Create queries to find and locate data by using query criteria.
• Design forms to manipulate data, and develop reports to display data in attractive and useful layouts.
• Combine basic HTML elements to create Web pages.
• Understand how to use HTML tags and tag attributes to control a Web page’s appearance.

Course description :

– This course tends to introduce Year 1 students of all university’s faculties to the concepts and terminologies of spreadsheet, database, database management systems, and the concept of hypertext markup language (HTML).
– It practices some computer applications in the laboratory such as Microsoft Excel, Microsoft Access, and HTML.
– It gives students a practical experience on developing projects related to the specialty of each faculty.

Course assessment :

• Practical Assignments &Quizzes: 40%
• Final Practical: 30%
• Midterm Exam : 10%
• Final Exam : 20%

Recommended text books :

– H.L. Capron – J.A.Johnson , “Computer : Tools for an Information Age” 8th Edition, 2011.
– Deborah Morley, and Charles S. Parker, “Understanding Computers: Today and Tomorrow “, Thomson Course Technology, 10th Edition, 2004.
– ECDL Foundation Approved Courseware, Module 4,5 : Excel,Access, 2008.

Recommended refrences :

– David Reed, “A Balanced Introduction to Computer Science”, 2nd Edition, Pearson Prentice Hall, 2008.

Why did you go to PUA for student exchange?

The chance to visit Africa, and more specific an Arab country with so much history as Egypt has, made the decision very easy. PUA offered the necessities and quality needed for my bachelor thesis to be conducted.

How long was the exchange period?

The exchange lasted 8 weeks in total.

How have you been chosen for the exchange?

Prof. Andrew Martin from KTH scouted for students to participate in a collaboration with PUA and KTH, me and my colleagues applied and were accepted.

What do you think are the differences between studying at PUA and KTH?

The difference is a more direct contact or line of communication in PUA compared to KTH. The relationships between pupils and professors are more personal than in KTH. Moreover, the learning is more of a practical character in PUA than in KTH, where the approach is often more theoretical and is conducted to bring discussion.

Did PUA staff, professors, researcher and others that you met been helpful and easy to communicate, discuss and cooperate

They have been excellent in supporting all causes, the communication line is very clear and everyone, including students, are very generous and show great hospitality. Our Egyptian colleagues, whom we collaborate with, have excellent knowledge in their field and are easy to discuss with.

Read More

Why did you go to (KTH Royal Institute of Technology) for staff exchange?

The main objectives of this mobility are:
- Explore the master program in Electrical Engineering in KTH.
- Investigate the availability of joint undergraduate projects submission.
- Acquire new teaching and learning skills from KTH.
- Reinforcement the cooperation between KTH and PUA.

How long was the exchange period?

A month.

How have you been chosen to this visit?

Through a presentation in front of the vice president and the international relations coordinator of PUA University. The presentation includes my goals to this grant of the Erasmus+ staff mobility program and this is done after the submission of the motivation letter and my CV to them.

Read More

Why did you go to the School of Pharmacy, University of Eastern Finland for staff exchange?

I consider the visit to the School of Pharmacy, UEF, as a lifetime experience that I believe it is a milestone in my career. It is a significant opportunity to discover innovative and different teaching and research techniques as well as to explore new foreign culture that is definitely motivational and very inspirational to my career

How long was the exchange period?

The exchange period was 8 days

How have you been chosen to this visit?

The journey started after my motivation letter was selected by Prof. Dr. Maged ElGhazouly, Dean of the Faculty of Pharmacy and Drug Manufacturing. I was one of 5 lecturers who were chosen to present their motivations to contribute in such exchange program in front of Prof. Dr. Mahmoud Mohey ElDin, President of Pharos University in Alexandria and Prof. Dr. Nourhan Fanaky, Vice President for Education and Students Affairs.

How do studies and researches at School of Pharmacy, University of Eastern Finland differ in comparison to your previous experience?

I think they are different in the time and resources available for their research. In addition, most of them are working as a multidisciplinary team which collaborate together for successful publications

Read More

Why did you go to KTH for staff exchange?

To gain more experience about teaching methods, to get introduced to a new culture, to widen my professional network, to know more about the curriculum of the courses in the KTH and compare it to ours in PUA. My main mission was about the BIM courses to transfer the way of teaching and to know all the courses that are taught in the KTH as PUA is starting to teach this new technology.

How long was the exchange period?

It was one month.

How have you been chosen to this visit?

I have been chosen through a process that started by a call to all the staff members for whoever wants to submit a motivation letter to be chosen. Then there was an interview with the faculty of engineering dean and head of departments. Then there was an interview with the head of international relations and the representatives of university’s president.

How do studies and researches at KTH differ in comparison to your previous experience?

It differs a lot as the number of years for the university education at the KTH are 3 for bachelor degree and most of the students there continue post graduate studies for 2 years to complete their master’s degree. One of the great differences is that all the master or PhD thesis are concerned with the industry to solve problems or to renovate the technology of construction.

Read More

Why did you go to (Royal Institue of Technology KTH) for staff exchange?

My trip was part of a grant of the Erasmus+ Staff Mobility Program. The main purpose of the trip was to adopt new teaching methods, interactive learning methods and assessment methods. In addition, visit the laboratories and workshops. Another personal purpose was to network with people interested in the field of my PhD research and exchange knowledge with them.

How long was the exchange period?

The exchange period was for 10 days.

How have you been chosen to this visit?

I applied for it at the PUA. The application included a motivation letter, my CV and a valid IELTS certificate. Then I have done a presentation on the purpose of my application to this visit. The attendees of the presentation were the Vice President of the PUA and the International Relations Coordinator at the PUA.

Read More

Why did you go to (KTH)for staff exchange?

I went there as a part of ICM program among the agreement between KTH and PUA

How long was the exchange period?

10 days

How do studies and researches at (KTH) differ in comparison to your previous experience?

There educaltional system consists of 3-years program BSc and 2 years Msc. The computer and electrical engineering are merged in one schoo;

Did (KTH) staff, professors, researcher and others that you met been helpful and easy to communicate, discuss and cooperate

Yes,

Could you describe a regular day as a student or teacher at (KTH)?

Student : attend lectures and lab sessions Teacher : give lectures, participate in meetings related to research projects

What was the best part of your experience at (KTH)?

Meeting with master programs directors and advanced abs

Read More

What made you chose PUA to study?

Being best authentic private university in Alexandria with highly qualified cooperative Teaching staff from professors to demonstrators is reason enough for anyone to join your University.

Why did you go to (University of Eastern Finland) for student exchange?

In my opinion, the university announced for scholarship was a great opportunity to discover their teaching methods and facilities whilst still student in PUA, as well as experience first-hand the European scandanavian culture.

How long was the exchange period?

About four months since 3rd/sept/2018 to 20th/dec/2018

How have you been chosen for the exchange?

By assessing applicant English proficiency, recommendation letter from my professors, motivation letter and interviews was also done to assess student social and academic background as well as their overall character.

Read More

What made you chose PUA to study?

I choose Pharos University because it is one of the top 10 universities in the Republic of Egypt and its close relationship between other international universities, especially the Royal Institute of Technology (KTH)

Why did you go to (KTH) for student exchange?

To gain experience of travel without parents and self-reliance and to see the cultures of other countries

How long was the exchange period?

It was 3 months

How have you been chosen for the exchange?

I think because I worked hard to study architecture and got the highest grades and excelled at the University of Pharos

Read More

What made you chose PUA to study?

Because of the excellent educational level offered by pharos university.

Why did you go to (KTH) for student exchange?

To gain a new experience and knew the difference between education in Egypt and abroad.

How long was the exchange period?

3 months

How have you been chosen for the exchange?

I was nominated by my department then I have passed the language test and an interview with university administration.

What do you think are the differences between studying at PUA and (KTH)?

The biggest difference is that students there depend on themselves a lot in the education.

Read More

What made you chose PUA to study?

I choose Pharos University to study because I knew about the agreement dual bachelor degree from both KTH and PUA which gives international exposure. Also its one of the best University for the education perspectives.

Why did you go to KTH for student exchange?

To gain experience, knowledge. Also to explore different cultures and know the least technology and trend in architecture.

How long was the exchange period?

3 months

How have you been chosen for the exchange?

First I have been writing my CV and motivation letter. Second I have been through 2 interviews and English test.

Read More

What made you chose PUA to study? 

 I choose Pharos University to study because it is one of the universities that help on producing good generations.

 Why did you go to (KTH) for student exchange?

To gain experience and knowledge from other countries that could help me in my future sake concerning the Architecture Engineering. 

How long was the exchange period? 

3 months 

How have you been chosen for the exchange? 

 By owning high grades, good communication skills and language.

Read More

Why did you go to PUA for student exchange? 

  I heard about the transportation project from my teacher at KTH. I chose PUA for exhange to write my bachelor thesis.

How long was the exchange period?  

3 months. 

 How have you been chosen for the exchange?

By my teacher at KTH. 

What do you think are the differences between studying at PUA and (KTH)? 

  I have nit participated in any courses but otherwise, there are differences such as school rules, computer lab.

Did PUA staff, professors, researcher and others that you met been helpful and easy to communicate, discuss and cooperate.  

Yes, they have been helpful all the period and it was easy to communicate with them.  

Read More

What made you chose PUA to study?

Because it is one of best universities in Alexandria.

Why did you go to KTH Royal Institute of Technology in Stockholm for student exchange?

It was a good chance to gain experience.

How long was the exchange period?

Three months.

How have you been chosen for the exchange?

I have been chosen by my professors.

What do you think are the differences between studying at PUA and KTH Royal Institute of Technology in Stockholm?

The students at KTH is more independent.

Read More

What made you chose PUA to study?

As Pharos is one from the best universities in Egypt, it was recommended for me.

Why did you go to (KTH) for student exchange?

It was the best chance ever to learn a lot about everything, their way of studying, their work during their lectures and tutorial.

How long was the exchange period?

It was for 3 months.

How have you been chosen for the exchange?

I was able to get the highest grades so that I could get my professors' nomination and I worked hard on it

Read More