Data Flow Diagram

This is the data flow diagram of my Markbook. I had it done, but I wasnt bothered to upload it.

Requirement Report

A bit delayed but it is here now:

Requirement Report

The purpose of this project is to create a Mark book using the program excel for teacher use. The Mark book is designed to store marks, record student names and classes and calculate grades and percentages of scores. The user of this system is a teacher, tutor or simply anyone that needs a record of names or scores.

Data such as names, student numbers, and scores will be entered into the database. An introductory page will be set up to establish the structure of the mark book. On that page a sample button will be used. When clicked the sample sheet is displayed. The data in the sample sheet is names, student identification, classes, and scores. Another button would display the instructions page. The purpose of this page is to produce a detailed overview of the mark book and instructions on how to run it. The next button is new class that creates a new sheet following the template sheet. This sheet can be edited and used by the user. The last button if time is left would be an exit button, when clicked it would automatically leave the mark book. Information outputs in mark book are the display of class information and student grades.

The Information Processes used are:

Collecting: Information on the students name, class, student number and mark have to be collected.
Organising: The data is then collected and sorted into columns. The columns can be arranged from ascending to descending order. All data is sorted out by the auto filters.
Analysing: V-Lookup assigns the grades to the correct percentage.
Storing and retrieving: Data entered in the information system is stored when saved. Any information retrieved is deduced by the formulas and from the given data present, for example, calculating percentages.
Display: Information is displayed in formatted cells, through the program excel. A computer monitor displays the information.

Overall the project itself is not very big. It is ideally used to display basic information on scores of students by teachers. Compared to other mark book projects this one is minor in expense and time usage.

Context Diagram

Here is my Context Diagram;

Gantt Chart

Here is my Gantt Chart:

IPT on TUESDAY!!!

We had IPT on Tuesday, I think. Well on that day I worked on my introductory page which kinda looks like this currently:

The first two buttons, work and that makes me happy. That's cause last year when we were doing Visual Basics, most of my codes that I found and kinda changed did work, but there was so many errors =.= with the rest of my stuff and ugh.

Anyway back to the project, the first button links with the sample page that I made as an example for anyone who is going to use my Markbook. On that page I was designing buttons, that make a message box pop up giving formulaes and codes for calculations. So far I have a message box but it isnt the one I want. The message box that pops up is like those you find on sites that wont let you copy their material. It would be great to use, except that it wont let you edit anything with out closing the pop up box. I have bad memory so I need to have the instructions next to me to indicate the next step. So what I want for the button is like what they have on those new pdf files. On those you have the little speech bubble tool that has a textbooks were you can place your comments and then minimise it again, instead of closing it completely. I want to add a feature like that except, preventying the person or user from editing whats within it. WELL TO sum it up a bit like a pop up help toolbar, that annyoing microsoft has when you click the question mark and it gives you step by step instructions.

This image shows the pdf messgae box that i sort of want, though without the user being able to edit what is in it already.

This is the message box that I have currently. I dont really want to use this one, but if I can't figure out the codes for the one that I wanna use, then this will be part of the final product.

This is the pop up box that I want to use for my Markbook.

Anyways the second link creates a new class. Credits to Jess Bee who helped explaining it to me. Also I designed the front page, making it simple, cause complex stuff are hard to follow.

Also it turned out that the assignement was due yesterday meaning everythinbg had to be done by Wednesday. Not possible with a class like our. So we got an extension, so its due sometime on the weekend, since most of it is on the computer and online. Also worked on a bit on my instructions page yesterday and thats about it. Now I have to work on my Journal entry for today. I'll do that in my free today.

My Markbook

Maxinne said the assignment/ individual project was due on Wednesday, which freaked me out cause I havent really done anything that significant, but today I did :D. Turns out the assignment is due in a couple of more weeks.
Today I made a button, to create a new class. The codes for that was found on our school site. I also made and introduction page containing the title of my Markbook and four buttons. One button was for the new class, help page, exit and sample. My friend Jessica Bee, whose like a genius with this IT stuff helped me. She gave me the code to show the sample page by just clicking a button. So thankyou heaps Jessica bee!!!! So now I have to start on some theory bits and and bit more on the project =.=. But thats alright cause I'm making some progress.