Jess.Bee.Happy! NA-NA-NA-NA-NA

MY MARKBOOK

Monday, June 1, 2009

9:06 PM

HELLO to view only my work for this Assessment just click on the label "Markbook Assessment" below this blog entry :)
--
My Final Mark book :)
An overview of my work :) -With Annotations

Click to see Larger :)

---- Evaluation
This assignment i found difficult at first. Maybe some more time where we work as a class to learn to basics of how to use spreadsheet (basic macro/VBA codes).
But once i got a little more help by my teachers and peers i understood what to do and used a bit of my knowledge from last year to create my macros (but most are found on the internet). The assessment task was easy to understand and straight forward on what we should have for our assignment. We usually get a Critera, but i couldn't find the one we needed for this assignment?

I learned that Visual basic was involved in excel (AHHH VB again) , learned some new codesthat might help me in future visual basic based assignments -.-

Labels: Markbook Assessment

[[ 0 comments ]]

Context Diagram

8:57 PM

So i looked at the due date of this assignment and almost died
so i started to try and finish everything :) cause i got a bit carried away with the online markbook
and realised this is due in 2 days :O!

okay so heres my context diagram, im not too sure if its right but ill put another one up thats more updated :)

CONTEXT DIAGRAM

HOPE ITS RIGHHTTT!

EDIT -
i double checked the assignment sheet to see if i've done everything
and it said context diagram and a dataflow
?? so i thought i needed both?

so i created a data flow one
i think its right
looks really similar to the context only has an extra box :)

DATA FLOW DIAGRAM

Labels: Markbook Assessment

[[ 0 comments ]]

Requirement Report

8:55 PM

Requirement Report

To Create a Teacher Mark book that can be used to record student’s names and their marks. The mark book will automatically give grades to the student’s assessment mark based on the Grade Key and have the averages, standard deviation and highest mark of the class.

The Data inputs for this system is the students information, this includes their First name, surnames, Assessment marks and Student’s Class. The Subject class is also inputted into the information system

The information processors involved in my teacher mark book include.
• Collecting – Collecting the students name, Class and Assessment scores.
• Organizing – Organize students names (alphabetical), classes and subjects
• Analyzing – Creates graphs using the data inputted.
• Storing and Retrieving – Mark book can be saved and accessed later.
• Transferring and Receiving – File can be sent to other computers (if computer as Microsoft excel)
• Processers - Can manipulate the assessment scores into their grade scores. Calculates class average.
• Display – Can be viewed on screen and can be printed out.

The Data output of the teacher mark book will be the Grades Automatically given when the assessment marks of the students are put into the system and provide assessment task averages, standard deviation and highest mark.

Labels: Markbook Assessment

[[ 0 comments ]]

Online Markbook?

8:32 PM

I was checking out some example of markbooks
and i came across a teacher who put up a noticed that he created his markbook so that others can see it.

ENGARD <-- the online markbook

It was an ONLINE MARKBOOK?

I thought it was a great idea as students,teachers and parents can view the markbook themselves and see the grades, marks and information of each student without printing it on paper. Its private so all information is safe as there is a password that is given to each student (each password is differnt for each student and the passwords are different for each student)

I was watching the demo and it was everything that we've been doing in class. The sign up page involved creating the markbook so you input what kinda of grade key you would like to use.

:) It looks really easy to use, you can put comments for each student, you can put class weighings, inputs students class progress (so what class work there done or haven't done so parents and students know whats missing), has a calander , the days there away, late or present to an exam or class and more :)

Its pretty reliable because even though its on the internet you can export the spreadsheet (into excel or other spreadsheets) and you can print out the markbook or an individual student

Anyways my markbook isn't anything like this one. But its working fine and no bugs :D! But i thought it was a great idea to create an online markbook that a teacher can use to communicate with students and parents when it comes to school work :D!

----
My Assignment?

well i've almost finished my Requiement report and my Context Diagram
but im not too sure if its correct so im getting it check my Sir tomorrow :)
Once again im ahead of time according to my Gantt Chart but i wanted to see if i could create a markbook with another program :)

Labels: Markbook Assessment

[[ 0 comments ]]

Ahead of things

Sunday, May 31, 2009

2:20 PM

Well im a little ahead things according to my Gantt Chart because im now working on my requirment report.

These are just the key things i need to work on
-Purpose of my System
-Data Outputs
-Information processors that are involved
-Outputs of the system

-----
As for my Markbook Program
it consist of a Introduction page, Instuctions, and a Sample page
It also has a hidden blank sheet which is when the user wants a new page.

The marco it has are
-New Class
-Worksheet Print outs
-Go to Instructions

It has an auto filter that can separate information with each other. For example I just want to see classes from 11MA2 i just need to click on the arrow then 11MA2 and it will show me all students from that class.

-----
Information Processors
just wanted to find out what processors i have for my system :)
COASTPD

Collecting - MY system collected data of the students that are inputted
Organizing - It can organize students in alphabetical order when they select the classes and press the acceding button
Analyzing - Can create graphs with the information. Gives grades to the students
Storing and retrieving - stores the information that can be used again
Transmitting and recieveing - the file can be sent to other people if they have microsoft excel
Processing - [not too sure] maybe the autofilters?
Displaying - on Screen and on Paper as it can be printed out.

Labels: Markbook Assessment

[[ 0 comments ]]

Markbook Updates

Saturday, May 30, 2009

8:42 PM

I decided to make a Gantt chart that looked like the one Sir showed us
because the other one didn't work out because of the dates format getting mixed up with a few things
so i tried another method almost the same thing and i used a youtube video to help me make this one :) http://www.youtube.com/watch?v=CW_wGSFavTc

okay heres my Better Gantt Chart

----
Markbook updates
-I added another macro that lets the user to print out the sheets they want
the only concern i have for this macro is that when i press print and tick the sheets i want, it prints immediately without letting me change the setting if i want to.
But on the dialog screen i will warn the user that it will print after pressing okay
-- New Class Button Error?
I've noticed that when i press 'cancel' to creating a class or i don't put a name theres an error saying to debug. So i went looking for a code and i found another one

This Code doesn't have a box saying debug when cancel is selected. But a new worksheet shows saying "false" meaning no title was given. If title is not given and okay is pressed it will still prompt the user the give a name.

I think my markbook is pretty much done for the moment
im going to work on the other task that need to be completed next lesson :)

byebye

Labels: Markbook Assessment

[[ 0 comments ]]

My Gantt Chart

Thursday, May 28, 2009

9:56 PM

I was suppose to do this earlier :S
but this is my progress so far

This looks a bit different to the one that Mr Cavill showed us in class. But i was looking around on the internet and found a really simple one. I actually lost the exact website. But i know its on the Microsoft Office Website.

I found this was more simple to understand as it shows whats completed already and what need to be completed :) The maroon areas shows what i have already completed. The yellow areas are what i am currently working on. The blue show i haven't started yet :|

Okay,
Produce Gantt Chart of the project containing appropriate stages during the design and production - COMPLETED :)

Labels: Markbook Assessment

[[ 0 comments ]]

Designing

4:58 PM

I have added a few macros in
I just realised its Visual Basic All over again :|
but its okay because i still remember some codes and how its set up :)

I have created a macro that goes to the sheet "instructions"
I have also included a macro that is a button and it creates a new class
(Thanks to Mr Cavill for the code)
I changed it a bit so i could copy a hidden worksheet so it looks more clean and professional
i had a few troubles with this
because on the hidden blank sheet i put "blanksheet.visble = false" meaning its not visible
and when i press new class it wasn't showing
and it was because i put that code
and my solution to this problem was to just set the sheet as hidden without codes on the sheet.

So far everything it working fine
---

i finished creating a instruction page ( a separate worksheet) which is in the begginning

---
http://www.angelfire.com/biz7/julian_s/julian/julians_macros.htm
i found this really good website that helped my understand visual basic and excel
they help you create macros which common and simple codes
which i believe are really good :)

Labels: Markbook Assessment

[[ 0 comments ]]

PLANNING - MARKBOOKS IDEAS

Wednesday, May 27, 2009

11:37 AM

Today we were told how we can improve our markbook
He suggested to use macros which will enable to fo functions such as:
-Creating a new class or putting more classes
-How many students in a class

----
Today im going to add the Auto Filters onto my prototype.
I am also going to start working on my VLOOKUP which im going to use for the grades students will get depending on what there marks were on each task.
http://phoenix.phys.clemson.edu/tutorials/excel/stats.html
----
-COMPLETED-

The VLOOKUP involed created some kind of key that involves a value that equals something
for my VLOOKUP it will involve allocating a grade depending on the mark that the student has.
mine looked like this
80-A
70-B
50-C
30-D
10-E

and if the marks range around the score (the numbers on the left) it will allocate the Grade on the right.

=VLOOKUP(E4,$J$5:$K$9,2,TRUE)

E4 being the cell that contained the score
J5:K9 being the Grade Key values

--
The Auto Filters were just selecting the area that you want to filter to be
then click on data ---> filters ---> auto filters

this allows the user to create a custom action that involves showing information the use would like to see
for example the user wants to view marks above 90
they will click on the arrow then click custom then put the option "greater than" then put 90
then it will show the marks over 90 :)

the only problem i have with this is when it view the marks of grades

----
i had time to add a 'conditional formatting' which involves highlighting what the use wants to see
So i highlighted that is a student gets a A or an E it will be highlighted
just because this marks are usually ones that teacher will want to look at
E being for the student need to improve
or A being student might have to do extension or Accelerated class :)

Labels: Markbook Assessment

[[ 0 comments ]]

What Exactly is a Macro in Excel

Thursday, May 21, 2009

10:39 AM

Definition:
An Excel macro is a set of instructions that can be triggered by a keyboard shortcut, toolbar button or an icon in a spreadsheets. Macros are used to eliminate the need to repeat the steps of common tasks over and over. Tasks such as adding or removing rows and columns, protecting or unprotecting worksheets, selecting a range of cells, or adding the current date to a spreadsheet.

---------------------

I want to create a markbook that will be able to manupulate the data (student records) So calculate the averages of students and then be able to show the highest to lowest marks.

Labels: Markbook Assessment

[[ 0 comments ]]

Mark Books

Wednesday, May 13, 2009

4:32 PM

today we talked about your upcoming assignment and we are to create a type of information system. We can use softwares such as excel, access or making a website.
I was thinking of a website
but im not 100% if i know what im doing
so im thinkning about starting with acess or excel to get me started

Mark Books can includes...
-Classroom rosters
-Report cards
-Attendance
-Progress
-Punctuality
-Achievements
-Scores
-Performance

Mark Books can involve...
-creating classroom rosters
-estimating students scores/marks
-importing and exporting class names and tests
-statistically accurate ways of combining, weighting and transforming student test and assignment marks

I looked through some programs that create MarkBooks include
-Markbook 2008
-Motorised Markbook

Labels: Markbook Assessment

[[ 0 comments ]]