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

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 ]]