ICT August 2013 batch

[Ravichandran]

Dear ICT students of AUG 2013 batch under Dr.Ravichandran, I welcome you all this Web portal, which you will be using for your entire course. This http://as-computing.ning portal is were you will have to upload / post all the classroom based activities.

The CIE ICT task will have to be handed to be in person at the end of each CIE task class and the question paper/ CIE folder should not be take with you under any circumstances. That is, the folder should be given to me after your use in class once you complete your Cie task for that particular class.

For further doubts and queries please contact me or you can even send a message using this Web portal.

FROM NOW ON YOU WILL USE THIS WEB PORTAL. AND REMEMBER TO POST ONLY IN THE FORUM NAMED ICT JAN 2013 BATCH. NOT ON OTHER FORUMS WHICH IS MEANT FOR OTHER BATCHES.

WE WILL DO 5 TASKS OF CIE , WHICH MEANS YOU NEED TO COMPLETE, WORD, EXCEL, POWERPOINT, DATABASE AND HTML TO GET QUALIFIED FOR A DIPLOMA.

Regards,

Dr.Ravi

[Alyea binti Abdul Aziz]

We learned how to use animations in our power point presentation. The steps are :

1. Google swf files (eg. respiration: swf)

2. Choose the one that has "FLASH" label next to the link 

3. Click the 'Customize and Control' button on the top > save file as Shockwave Flash Object

4. Open PowerPoint > make sure the layout is blank  

5. click Developer > More controls > Shockwave Flash Object

6. Click the layout > right click > properties box

7. Click the swf file that you've saved > right click > properties > copy to the location > paste at the column next to movie > backslash > copy the name of the files > paste next to it 

8. View you animation 

[Chew Jian Li]

Hello, today in class I learnt how to embed .swf (shockwave flask object) files into powerpoint to insert an animation, without the hassle of the usual blocks associated with inserting animations into Powerpoint.

1) Search for an animation, i.e. "Respiratory System swf" (be sure to type in the word 'swf' after your search phrase), using either Google Chrome or Mozilla Firefox. (These browsers have in-built flash players, unlike Internet Explorer)

2) Once you have found your file, click "File - Save as". Ensure that the file is saved as an swf file. Save it in your desktop.

3) In PowerPoint, click the "Developer" button, then select the "hammer and screwdriver" button, which stands for "more options".

4) Then click "Shockwave Flash Object".

5) Under the movies column, cope and paste the location of the file, followed by a backstroke (\), the file name, then '.swf'. i.e. C:\Documents and Settings\ITLAB2-19\Desktop\Lungs Description Animation.swf

6) Simply click the "Slideshow" button on the bottom right-hand corner of the screen.

 

Viola! You have a working, smooth animation without the awkward freezes, long delays and sheer frustration normally associated with animations in PowerPoint.

 

Jian Li

[QURRATA AINI MOHAMMAD TINGGAL]

Again,today we have learned a new interesting skill in ict class on how to make a great presentation using Microsoft Powerpoint and swf.files.

1.search anything we want in Google , followed by <space> : swf .

2. click the link with the word FLASH  in front of it and save the page to the desktop.

3. run the powerpoint and leave the page blank.

4. click the developer option at the top of the page and press the hammer figure.

5. a box will appear and click the movie section.

6. fill in the detail from the properties and click ENTER.

7. press slide show. 

Done! 

[Elisa Naomi Tibok]

Today in class, Dr. Ravi taught us a bit about excel and its functions.

Using a particular set of data, we learnt how to quickly calculate its sum,average, min and max value by typing out the wanted formula on the formula bar on top of the spreadsheet. We then can replicate the formula by selecting the lower right corner of a cell and dragging in towards the next cell that we want the formula to be replicated on. 

We then can transfer the data we have calculated unto a graph or whatever by clicking the wanted graph.

I find this function very useful.

[nurul asnida binti aziz]

i learn about the m.excel which how to make a data related to mathematics..slowly, im become more aware about the usage of excel ...

[Amirah Hanoum binti Amin Ariff]

Today we learned how to use the excel. 

steps :

1. write down the headings(name, total etc) for each column and the details for each row (eg : name)

2.insert all the numbers (eg score)

3. Use the formula to find out the following 

=SUM(B2:E2)

=AVERAGE(B2:E2)

=MIN(B2:E2)

=MAX(B2:E2)

4. Click the end of the box until the cursor appears as + and drag it down so that all the rows will use the same formula. 

5.Click view formulas to view the formula.

6.Click insert and select any diagrams that you desire (eg bar chart, pie chart )

& you're done ! 

[Koh Yun Xin]

We learn about Microsoft Excel today.. The definition of an Excel is a worksheet used to create and quickly perform the " what-if" analysis of inter-related column in a workspace...By using some simple formulas, we can easily get many calculations done.. and any changes made to the raw data after that will affect the calculated data....we do not have to redo all the calculations... 

Formulas are always started with "="...Following are some examples:

=sum(b2:e2)

=average(b2:e2)

=min(b2:e2)

[Nabilah Binti Muhammad Najib]

Today, i learn how to use Excel which i found pretty easy and efficient

First type all the data,

then we can use add up the data by using several ways , ie; auto sum or by using formula

if you want to use formula, make sure you type the formulas correctly !

Thus is how you should key in your formula : to find sum of data : type " =SUM(B6-E6) "

You can also view your data in the form of chart, etc.

thank you dr ravi ! 

[Farah Nadia Abd Aziz]

Much gratitude to Dr. Ravi for stopping me doing Mathematics before and equipping me with yet another skill that is very useful for the time in the future :>

Now I'm aware of the real usage of Excel and profoundly master the knack to getting my work space neatly & effectively done in seconds. Till the next class!

[Fiona Yeoh Joe Sin]

An Excel is a worksheet used to create and quickly perform "what-if" analysis of interrelated column in a workspace.

Step 1 : Insert Names in Column A

Step 2 : In Row 1, insert all the X-axis variables (Eg Marks of Each Subject, Total, Average, Min, Max)

Step 3 : Insert the values for all marks in their respective cells

Step 4 : For Total, there are three ways to calculate it.

The first method is to highlight all the 'marks' column of a row together with the 'total', click "autosum" on the top right.

The second method is to click one 'total' cell and insert this in the formula box ; =Sum(B2:E2)

The third method is similar to the second but instead, we list all the columns ; =Sum(B2+C2+D2+E2)

*Note that the = sign is required.

Step 5: Move the cursor to the bottom left of the 'total' cell calculated and a black + sign will be shown. Drag it down the entire column and all the other 'total' cells will be automatically calculated. This step is used to replicate the formula in the same column.

Step 6: For average, min and max, second or third method of step 4 followed by step 5 can be used but replacing 'sum' with 'average, min, max' instead.

Step 7: To plot a graph, highlight all the rows and columns pertaining Name, Marks and Total. Click Insert-->Any graph of your choice.

And you're done! :)

[Wan Aemellia Elisha]

Today, I learn a new thing which I believe will definitely be useful for me. Thank You, Dr Ravi for teaching me how to make graph using Microsoft Excel.

Step 1: Type the details on the worksheet on Excel. Eg.(Name, mark for each subjet: Chemistry, History, Physics and Maths)

Step2: To total up the mark, type the formula, eg: sum(e2:b2) and then press enter. We can do it to find the average, min and max mark also without having to go through all the troubles doing it manually.

Step 3: Go to 'insert>graph.

done.

[Chew Jian Li]

Today in class we learnt some of the basics regarding Excel.

- Excel is a spreadsheet system used to calculate 'what-if' scanarios.

- To find the sum of data: type =sum(data start:data end)

- To find the average, type =average(data start: data end)

- And to find the minimum or maximum value, repeat the above with the headings =min() and =max()

- In order to find out what formulae are used, Select the data section, click "Formulas" and then click "Show Formulas" under the Formula Auditing section.

- Finally, to make a graph, select the target area of data, click "Insert" and proceed to choose the type of graph which is most suitable under the "Charts" table.

 

Jian Li 7297 (Block 4)