Week 7(b) : Student Database

In this last Week of task division, we are required to plan the data structure for Student management information for each table. We are required to only use the student name in Student Table, and  not others.

The data structure's specification is as follows, we are required to create table in design view and it need to be separated into four different tables. The name of the tables should be student table, parent table, curriculum table and co-curriculum table all using student ID as a Primary key. The next step is to create relationships between tables by linking the student ID. This is why not to create student name for other tables except Student Table.

We need to use the Wizard to Create Form of:

o Student Form

o Parent Form

o Curriculum Form

o Co-curriculum Form

The steps after all above is to enter data using Form and we are not encouraged to use table for data entry. 

The last step will be to create several queries from the database and create reports based on the queries.

I find that the database system is very interesting and will come handy if there are activities to be done with students personal details and achievements. The database system makes a very good companion for teachers who need to enter details on their students. It could help save time and be statistically be more organised.

Week 7(a) : Spreadsheet

In week 7(a), we are entitled to the task named Assignment 8(a) and 8(b). The first task would be for us to plan, create and edit a simple one year personal financial management which includes my income and spending throughout the year. The spreadsheet is done using Open Office Calc. Among the steps that need to followed to create a perfect spreadsheet is by naming the sheet according to the month. (Aug11, Sept11 …. Jul12). Our next job upon completion of the first step is to create a formula to calculate a balance for each month which brings a simple calculation as an example (the balance of August will be added to the balance of September to accumulate total balance/saving at the end of the year). The formula should be linked between the sheets.

Assignment 8(b) also instructs us to plan, create and edit a spreadsheet of students score and grade analysis. we should use of all the function to define name for table of grade and score, VLOOKUP is used to refer to the grade of the score, STDEV and AVERAGE or the score while COUNTIF to calculate how many students for each grade. Finally, we need to create suitable and meaningful graph and sort to rank the highest to the lowest score for each subject after filtering to select based on certain queries.




Microsoft office Excel
o Define name
o Fill Series
o VLOOKUP
o STDEV
o AVERAGE
o COUNTIF
o Graph
o Sort
o Filter

Week 6: Powerpoint and Open Office Impress

OpenOffice Impress & Microsoft PowerPoint

This particular task is for us to enhance our creativity in using both the software above, i feel that it is better to create my own template that is suitable to my presentation/courseware. To do this I am required to start with a blank presentation which means I should not be using the available template in the software. Next, i would have to create my own theme by editing Slide master.

On the lesson and the task given on Week 6, we are required to do two presentations using Microsoft Power Point and Open Office Impress. Assignment 7a requires us to do a mini presentation using Impress based on the assignment that we have done earlier, Assignment 5. The presentation should be uploaded using Google document and shared with my course mates.

Assignment 7b requires more complex steps to be taken to be completed. First, we have to develop a multimedia course ware by  learning about the content that i had choose for assignment 1 using Power Point

The course ware should contain all multimedia elements which includes video which have to be edited in Windows Movie Maker, a layered graphic or image which is edited in GIMP and also custom animations that are too edited in GIMP. The audio that need to be uploaded and contained should again be done using a software Audacity. It should be recorded and edited using it.

Week 5 : Desktop Publishing Software & Word Processor Software

After a brief journal in week 4, we were given a whole different task from the previous one. Although the topic mentioned were the same as done before, but the applications and software meant to use in this task is very new. We were assigned to plan, design and create a brochure / leaflet using Microsoft Publisher . The content of this brochure is related the topic for assignment 1,4,5. This would be LEARNING ABOUT ICT as it was our topic of concern in previous assignments.  We had another task to be completed at the same time in this weekend which would be to plan, design and create a booklet using bookfold function in Word. The content is related the topic for assignment 1,4,5. The report in journal article format can be value added by inserting related graphic. We need to use the graphics/image created using any graphic editors mentioned above. Make a cover using of the booklet – using 2 Column