3rd prep ch.2

3rd prep Ch.2

1st prep - Computers in everyday life

Computers in our everyday life, 

for 1st prep language section

Welcome my Friends

 Best back to school with GLS Open Courseware

any questions write it down in the comments

3rd prep Lecture - Problem solving

New academic Year 2014 / 2015

new start ... new challenge 

Are you ready?

3rd prep Lec no.1 #ProblemSolving in computer science

GLS IT Academy

GLS IT Academy

Register Now to guarantee a better summer and much more entertainment 

taking you to another level of knowledge and fun

This is GLS Academy

 

register now @ School

Gohar Language Schools

+201123926902

amr.abdulaziz@Outlook.com

Summer program from GLS Open Courseware

Apply now and enjoy your summer with GLS Open Courseware team at Gohar Association, Cairo

-> Robotics

  -> Web Design

    -> Soft skills

First lecture Monday 11:00 AM at Hall[A], Gohar Educational association  

GLS summer program

Enjoy learning
it's a long road... but totally worth it
start your training and enjoy summer programs with GLS OCW team
professional and high-quality training programs in the summer

2nd prep Model Answers

2nd prep model answers

Ch.9 page: 7

Q1.

1- spreadsheet 

2- Del 

3- Function bar

4- charts

Q2. 

1- Worksheets

2- Row, and column

3- 25, Col 16

4- Column alphabet, row number

5- Value

6- Select, F2

7- 18:00 "24-hour clock system"

Q3- steps will be found in the sheet

Q4.

FALSE, FALSE, FALSE, TRUE, FALSE, FALSE{Worksheets}, False

Ch.10 page: 13

Q1. 

sheft cells down option from insert menu to shift other rows to add 3 times

Q2. 

1- rename

2- SHIFT

3- Shift cell down and leave the current cells empty 

4- empty the current row

5- CTRL, click over column or row headers

6- 66536, 265

7-CELL

Q3- 

1- Select the whole worksheet button

2- insert menu

3- the arrow button on worksheet tab

Ch.12 page: 21

Q1- 

X: to cancel the function bar editing

Green Checkmark: to accept the editing[function bar editing too]

Q2.

1- built in , predefined

2- Operators precednce

3- = [equal sign]

4- sum of integers/their number example: 200/6 such that those numbers are: 100, 20, 25, 5, 35, 15

5- updated results

6- calculate or to mentor non-empty cells [all cells that have values]

7- sum function

8- 7.5

9- function bar

10- the changing values will make the formula generate updated results

11- formatting

12- auto fill method

13-max, min, sum, countA and average[AVG]

14- MIN Function

Q3- 

FALSE, FALSE, FALSE, FALSE, TRUE, TRUE

Ch.13 page: 26

Q1.

1- graphical representation of worksheet data

2- 2D, 3D Charts

3- chart, insert menu

4- charts toolbar

5- display an example of chart 

Q2. 

1- TRUE

2- true

3- DELETE

4- in other sheets too not only the current worksheet

5- false 2 types 2d and 3d 

GLS IT Academy

Great opportunity for All students in the Summer
Subscribe now
First month for free
stay tuned for the available courses

GLS -> HAVING FUN...While we Learn

1st prep final revision

1st prep Final revision 

Happy for Pharell Williams is the only song that can describe the pleasure and hard work we combined together today 

Study hard for the final Exam 

and congratulations for those who won prizes in today's quiz

AGAIN: I 'm proud of you ! 

Keep the good spirit  

"Watch the video... then browse the pics"

2nd prep Smartsheet

and Finally after a pretty long yearGLS Course ware introduces its SMART SHEET for 2nd prep to help you revise the most tricky parts in Excel program before the final exam

-> Click Hereand launches the final Model Exam //for practice not the really final exam to help you practice and solve more questions related to the course syllabus

-> Click Here

and any questions email me or comment here "add comment"

additional Exams

Stay tuned for model B, C and D Final exam models to be uploaded tomorrow or maximum Saturday morning 

any questions: 

Email @ :amr.abdulaziz@outlook.com

SkypeID :amr2008840 

or write down your questions as comments on this article

2nd prep IT graduation ceremony

Note:
GLS open Course Ware project has not been created to make shows or propaganda, we just celebrate much more months of efforts and hard work from you, finally I 'm proud of being your instructor
Keep up your work and raise your talents

-> stay tuned for some answers for the sheet   

Eventually, Congratulations for 2nd prep students as they have concluded the IT Course for this academic YEAR 2013/2014  

It’s a revolutionary new learning model/system that we have created together and we Hope that you found it great

Enjoy your summer time OUT of our crowded CAIRO ! :)

amr.abdulaziz@outlook.com

mob: 01123926902

2nd prep Final Quiz

2nd prep Final Quiz

********

*****

**

*

-> Click Here

1st prep graduation ceremony

1st prep graduation ceremony 

GLS Open Course Ware

Congratulations for 1st prep students as they have concluded the IT Course for this semester, and I just want to say that I 'm proud of being your instructor and proud of ALL of you despite the obstacles we faced during the course time.

-> best wishes and have a great summer time out of our crowded Cairo

2nd prep practical model Exams

2nd prep practical model Exams

here's the full complete final version of your practical model exams that will be on next Sunday morning [by god's willing] 

-> Don't forget to study more harder

-> Click Here

and here are some pictures you can browse to help you understand

[1]

 [2]

 [3]

@Amr_Abdulaziz 

amr.abdulaziz@outlook.com

1st prep practical models

1st prep practical model exams is now available Download it using the following link:Click this -> 

1st prep Practical

GLS OpenCourse ware team

1st prep lecture 5

Using Graphics

              [Part 1]

stay tuned for the other parts to be uploaded tomorrow morning 

Good Luck

Amr Abdel-Aziz

GLS Open Courseware Team 

Having fun... while we learn 

2nd prep lecture 4 notes

Welcome 

IT Course [language section] @ G.L.S is Taught to be as a Flipped Classroom

The Flipped Classroom is a learning model where students first learn core concepts through video and audio training.  This way they can learn at their own pace and review the materials as much as they like.  Then the students work with the instructor *one-on-one and in small groups improve the way they sound.  It’s like getting the lecture at home and doing the homework in class.  It’s a revolutionary new learning model that works great.

and now get ready for the homework 

lecture 4 notesFunctions

+ today's written HomeWork

  

Click Here

Don't forget to prepare it with your quiz next lecture

Mid-Term grades

Mid-Term Grades

2nd prep Grades

*******

*****

**

*

1- Ahmed Soliman Abdul-Hameed [18]

2- Ahmed Magdy Abdul-Hameed   [19]

3- Ahmed Mostafa Ibraheem     [17]

4- Omar Gehad Hamdy           [17]

5- Omar Mesallam              [20]

6- Mohammed Tareq             [15]

7- Yousef Khaled Helmy        [20]

8- Toqa Mohammed              [20]

9- Rana Said Hatem            [20]

10-Reem Ahmed shawky          [20]

11-Reham Khaled Abdul-Lateef  [20]

12-Sandra George              [19]

13-Sohila Ibrahim Mohammed    [16]

14-Alyaa Ashraf Mohammed      [15]

15-Haidi Nasr Abdullah        [20]

16-Haidi Yassein              [20]

1st prep Grades

*******

*****

**

*

1- Ahmed Mohammed Ali      [8.5 ]

2- Anas Abdul-Raoof         [13]

3- Hazem Samir             [10.5]

4- Abdel-Rahman Mohammed    [11]

5- Omar Ashraf             [15.5]

6- Omar Samy               [13.5]

7- Mohammed Amr             [12]

8- Mohammed Hassan          [14]

9- Mohammed Nasser          [12]

10- Mostafa Mahmoud         [16]

11- Yehia Mohammed          [14]

12- Yousef Ahmed Kamel      [14]

special thanks for those who got the full marks and stay tuned for the prize 

Photo Gallery

congratulations ! 

Mid-Term exam grades will be published here Sunday morning

Such an Exam is not the only thing that proves you are brilliant and we are here to prove that 

your instructor is proud of all of you and stay tuned for the prize

GlS Open Course ware Team wishes you permanent success and best wishes 

Amr Abdel-Aziz  

@amr_abdulaziz 

2nd prep Combo [Quiz]

GLS Open Course ware

IT Course – spring 2014

2^nd prep quiz no. 1

" الكويز نزل دلوقتى دوس  ع اللينك اللى ف أخر صوره :) "

keep in mind that by solving this quiz you 'll be able to implement 40 % of your monthly grades

Click Here on this image NOW

***

**

*

Formulas and functions

2nd prep Lecture no. 3

spreadsheet technology

Part 1

Part 2 [new]

Part 3 [new]

For the first time ... your lecture video records is out now ... :)

Click Here to Download lecture no.3

announcement:

IT's mid term exam will be on 1/4/2014

[next Tuesday]

weekly grades are based on

5 degrees for the note

2 [lab workshop training]

3 for the quiz which 

will be uploaded here TODAY morning

stay tuned 

1st Prep - Word processing 

Microsoft office word

Lecture no.1,2 and 3

 GLS Open Courseware

 " حمل من هنا" Click Here to Download lecture no.1

& 

 " حمل من هنا" Click Here to Download lecture no.2, 3

for the quiz 

Click Here

Good Luck all 

2nd Prep - insertion and deletion In MS office Excel

2nd preplecture no. 2[Insertion & deletion in MS Excel]

In this lecture, we 'll get exposed to insertion and deletion (entering data) in spreadsheets using mouse and keyboard ! 

 Click Here to display or download lecture 2 presentation

the Home Work and additional quiz will added tomorrow morning

If you face any problem dealing with the website or downloading the lecture contact you instructor through the QR code or comment down here 

2nd prep lecture

2nd prep first lecture

welcome to the next semester, please don't forget to check other website pages
this is just the beginning of our complete integrated [GLS Open Courseware] system
stay tuned for our upcoming news
don't forget to download the first lecture attached within this article 

    Click Here to download the introductory lecture