dah38-blog

[dah38-blog]

Work Week

Overall Tasks - Made changes to design doc twice and diagrams because SVN software removed the first copy - Created and assigned duties to members of team - Stepped through test document with Tom and decided what needs to be changed. - Merged test documents 3-5 to create new and final test doc. - Started Final report - Debugging and testing with Mark and David - Test document with Tom - Went through slide 17-7 of the user design and added tests to the testing doc. - Created sanitization code for submission of creating a quiz/edit - Developed test document with Tom - All review reports done

[dah38-blog]

Week: 2nd- 18th April 2017

The first week I looked into what we need to do and allocated the group work. However, while having another assignment ongoing and exams approaching not a lot of work has been done the past week or so. I will be picking up the work as of tuesday 20th. I knew I’d have this assignment so I spent a lot of time doing work in term time so I would have the time to complete my assignement.

[dah38-blog]

Week: 27th March- 2nd April 2017

CS22220 – Group Project Blog – Daniel Joshua Hulme

Week: 27th March- 2nd April 2017

——————– Assigned tasks ——————–

-1- Ensure booking of appropriate room for thursday is on repeat -2- Carry on DB work -3- description of each table on the DB overview -4- Finish appropriately assigned work on github -5- Data types - discussion -6- Bar Charts -7- change values to $variablename on the SQL syntax

——————– Other notes ——————–

——————– Tasks ——————–

-1- Created a meeting slot for thursday.

-2- Not much to do besides alter the data types slightly.

-3- Completed in full as of last meeting.

-4- Had lots of assigned work, hence not much progress has been made.

-5- I had to discuss the each datatype for each tuple in reach relation. This didn’t take a lot of time; about an hour.

-6- I need access to everyones blogs before I can complete these and I don’t yet.

-7- Again, this took minutes as it was a copy and paste job.

[dah38-blog]

Week: 19th - 26th March 2017

CS22220 – Group Project Blog – Daniel Joshua Hulme

Week: 19th - 26th March 2017

——————– Assigned tasks ——————–

-1- Ensure booking of appropriate room for thursday is on repeat -2- add appendix A data to the database for testing purposes -3- finish appropriate design document work for tuesday (DB section)

——————– Other notes ——————–

——————– Tasks ——————–

-1- Created a meeting slot for thursday. -2- Written the code to insert it now I just have to add it to the database. Will be done tonight. This took me about 1.5 hours.

-3- Will be continuing with it tonight and it will be completed before Tuesday’s session. I have spent about 3 hours on an offline copy.

[dah38-blog]

Week: 7th - 19th March 2017

CS22220 – Group Project Blog – Daniel Joshua Hulme

Week: 7th - 19th March 2017

——————– Assigned tasks ——————–

-1- Ensure booking is repetitive -2- Continue with database work -3- Make corrections to specified parts of the test document

——————– Other notes ——————–

——————– Tasks ——————–

-1- Again there is a meeting in that time slot so I cannot make it repetitive yet.  -2- I had to mess around with the workings of the database and add test data to it. I was troubleshooting database queries and problems with Mark this week.

-3- Completed. I have done my corrections for the test document in full. We will be looking at it today (Monday) to ensure I have completed the work. These corrections follow on from a review meeting we had on Thursday afternoon. I had to do some more changes after the review meeting as I needed to include some more. 

——————– Summary ——————–

Overall, this week has been productive. I have worked further on the database and made amendments to the test document.

[dah38-blog]

Week: 6th - 12th March 2017

CS22220 -- Group Project Blog -- Daniel Joshua Hulme

Week: 6th - 12th March 2017

-------------------- Assigned tasks --------------------

-1- Ensure booking is repetative -2- Continue with database work -3- Make corrections to specified parts of the test document

-------------------- Other notes --------------------

-------------------- Tasks --------------------

-1- Tried to do this but there was a meeting in the same slot for next Thursday, so I will try next week. -2- There isn't much to do right now. This week was slow for database work. I will be moving to PHP when the prototype resumes.

-3- I will continue with this. I have done most of it but I won't submit it to the SVN until I am sure the corrections are accurate and correct. This deadline is for next Thursday's meeting.

-------------------- Summary --------------------

Overall, I have been working on my other assignments in conjunction to the group work. We met on Thursday and assigned tasks to each group member to ammend parts of the documents (UI and testing). I have been working on my ammendments and I will show them in the meeting on Tuesday so I know they are good corrections.

[dah38-blog]

Week: 27th February - 5th March 2017

CS22220 -- Group Project Blog -- Daniel Joshua Hulme

Week: 27th February - 5th March 2017

-------------------- Assigned tasks --------------------

-1- Add quiz_name on the quiz table -2- check types across the whole database -3- create code to pull info from DB -4- ask Sam about coding standards document -5- book the hugh owen meeting room for each week

-------------------- Other notes --------------------

-------------------- Tasks --------------------

-1- Completed - took me about 30 mins. -2- Completed - This took a while as I had to change a lot of datatypes from strings to chars and varchars. This was fine but I realised I needed to match the test specifications to the database (restricted datatypes). I also had to adjust the UML diagram and the draft excel spreadsheet each time. This took me about 2-2.5hrs

-3- Semi-completed - I created the SELECT code for the database and I tasked Owain (who is on the database with me) to do the INSERTION code but he hasn't completed that yet. Hence, I may be creating this tomorrow (Monday). So far this took me 3 hours.

Completed - but this added another hour onto my work as Owain couldn’t complete it.

-4- Completed - awaiting a reply from Chris for further information

-5- Completed - will block book next week as I didn't see the option.

-------------------- Summary --------------------

Overall, this week has been very productive. I will be meeting Mark tomorrow to get some more coding done for the website. We have a working UI now and will hope to have the INSERT code completed tomorrow by Owain. If not I will write it and then use it in my meeting with Mark.

EDIT - Owain informed me that he couldn’t compelte the INSERT code so I completed that. I then met Mark for a programming session and we managed to get a lot done. Unfortunatley we couldn’t get it inserting into the database but I realised something that we weren’t doing. So we will meet again tomorrow and finish it.

[dah38-blog]

Week: 19th - 26th February 2017

CS22220 -- Group Project Blog -- Daniel Joshua Hulme

Week: 19th - 26th February 2017

-------------------- Assigned tasks --------------------

1- Help sort out test spec testing tables. 2- Continue with database

-------------------- Other notes --------------------

-------------------- Tasks --------------------

-1- I have been adding tests to the document. I will continue to do this but this has taken me about 2 hours already.

-2- I had trouble connecting to the database but I can now. I was going to implement my design onto the group database but I couldn't do this as I have been helping getting the test  spec up to scratch for the review meeting. On monday night I will implement my database design, before the tutorial.

-------------------- Summary --------------------

We had out review meeting on Friday because Tom didn't show to the Thursday one and as Mark (QA manager) couldn't make it and the deputy (Tom) didn't show we couldn't do the intial review.

The review meeting highlighted a few issues which I have delegated various people to fix. The biggest problem is the test spec document which has a fair few things to do.

[dah38-blog]

Week: 13th - 19th February 2017

CS22220 -- Group Project Blog -- Daniel Joshua Hulme

Week: 13th - 19th February 2017

-------------------- Assigned tasks --------------------

1- Dan to ask Chris if we need credentials for the quizmaster or just use a link to log in as Quizmaster 2- (Non official) Create code for the database and implement a local database to test the design.

-------------------- Other notes --------------------

-------------------- Tasks --------------------

-1- I have emailed the client (Chris) to get an answer but I am awaiting a response.

-2- I have written most of the code and will be implementing the design later on. This was the longest part of the this week as I had to write all the code for the database in MySQL as I am running a local MySQL one. There aren't many differences between the two types. This took me about three hours. 

UPDATE: I tried to implement my design into the group database but I couldn’t due to some weird errors I will discuss tomorrow.

-Other- I have added all my files to the SVN repository.

We have been discussing when to do the review of the documents. I have asked for the documents to be up to a good standard by the next session (Tuesday) and we will review them on Thursday.

We need to elect a deputy project leader and a deputy QA manager.

[dah38-blog]

Week: 6th - 12th February 2017

CS22220 -- Group Project Blog -- Daniel Joshua Hulme

Week: 6th - 12th February 2017

-------------------- Assigned tasks (as of Tuesday 7th and Thursday 9th February 2017 --------------------

1- Change assesment ramge and make it available for everyone. 2- To take minutes next week. 3- Create a UML diagram for the database. 4- Determine what I want to do in the group.

-------------------- Other notes --------------------

Reminder: 17th February is the deadline for the Test Spec and the User Interface document. -- Delayed by a few days. -- Hand in before 21st

-------------------- Tasks --------------------

-1- I have changed the assessment range for the database. I will gain feedback in this at the next meeting. I have created a google doc for the qhole group to see that has the new excel database design on it. This process took about 50-60 mins with changing the assessment range and getting the google doc set up.

-2- We met on Thursday 9th of February 2017 and I took the minutes for that meeting. Owain will take the minutes for the next meeting.

-3- I started to create the UML diagram on Friday the 10th of February and will complete it tonight(Sunday)/Monday night. So far I have spent about 2-3 hours on this.

-4- I feel like I am strong with databases and no one in the group particularly wants to do it so I will stick with this. I would also like to be project manager, I will dicuss this further with the group in the next meeting.

UPDATE - I have finished the UML diagram (Monday evening). The UML diagram is a intial draft of the database. If the database changes or is incorrect and/or the diagram is wrong I will update the diagram.

[dah38-blog]

Monday 6th February

I have checked the database design and the normalisation of it and believe it to be in order. I will present it to the group in tomorrow and gain feedback from them. I re read the minutes to ensure I had completed everything and I believe I have. I started a Architecture Discussion document and I think that is all I had to do on that front.

My UI is completed with sketches and labels.

Overall the database was the part that took the longest as I had to come up with what would go in the database, how it would be represented and what the best way to represent it was. The better the databse design the easier it is for the PHP to work and the easier it is for team members to come up with algorthms that work with my design. Like I said I will gain feedback from them and improve the design if it is required. I spent about 4-5 hours on the database design as I wanted to ensure it was done correctly.

[dah38-blog]

Saturday 4th February

I have completed the intial design for the database and I will present it to my team in the next meeting. There are some points I need to raise with them about the implementation. If they can point out any errors in my design, that will be immensely helpful.

I now need to add one more diagram to my UI design.

Update - I have completed my UI diagrams.

[dah38-blog]

Saturday 4th February

I asked the group what to do to solve the problem of storing the question order in the database. Mark came up with a good idea, so I could use his or I use the one I will present at the next meeting. I decided it might be best to assign values to the answers (which the quiz master will decide) and use these values to order the questions. I will proceed to convert the database I designed into 3NF.

[dah38-blog]

CS22220 - Group Project Blog - Daniel Joshua Hulme

Week: 30th - 5th January 2017

-------------- Assigned tasks (as of Tuesday 31st January 2017) --------------

1 -- Start a Google Document for the Project Architecture discussion

2 -- Start coming up with ideas of what the database will look like, and present it next week

3 -- Everyone to create a blog (or assign someone to create a group blog) and make sure Sam can access it by the end of the week.

4 -- Everyone to read QA04, and come up with some ideas and diagrams of possible user interfaces to discuss next week.

5 -- Read QA documents 1-3, these describe general QA practices including how the project is run.

6 -- Consider the pros and cons of using Object Orientated approaches for backend.

-------------------- Other notes --------------------

Reminder: 17th February is the deadline for the Test Spec and the User Interface document.

-------------------- Tasks --------------------

-- 1 --

Completed on Tuesday 31st January 2017. Didn't take any time at all. I wrote a brief introduction in the document.

I realised that I had to change a few things in the document so I went back and compeleted this.

-- 2 -- This was started on the evening of Friday 3rd of Febuary 2017. This was a hard thing to think through. I believe I have produced an accurate UNF diagram. This was the longest part. I had to put a lot of thought into how the database would look. I populated it with some data where necessary.

So far my understanding of what needs to go in the database is:

id - Each quiz must have an id number other wise duplicate quiz's will cause trouble in the database. Auto generate?

quiz - The quiz has a name.

questions - Each quiz has questions

answers - Each quiz has to have 2 or more possible answers

marks - Relative marks for each answer for every question

intro text - The quiz has introduction text

assessment range - The quiz has an associated assessment range for the questions

question order - Each quiz has to order the questions. Done by giving a question ID? And that ID being used to order them.

I will continue to work on this throughout the weekend.

-- 3 --

Started and completed on Tuesday 31st January 2017.

-- 4 --

Started on 1st Wednesday of February night. Completed on Thursday evening. This took a while as I had to read the documents allocated with this and formulate UI designs.

Summary of requirements:

A -- Button to create a new quiz B -- Button to load an old quiz

--A--

- Specify new quiz title and text containing information about the quiz. - Add questions to the new quiz - Specify a questions with two or more answers - marks given for each answer (behind the scenes?) - Should be able to change the title, intro text, question order, all detials of the question and the assessment range for a quiz - Save and exit the quiz at any point

--B--

- Add new questions to an existing quiz - Should be able to change the title, intro text, question order, all detials of the - question and the assessment range for a quiz - Save and exit the quiz at any point

--O--

- Should calculate the maximum mark for a quiz and give an assessment range. - Upon completion of a quiz, thre should be a link provided so the quiz can be completed. - Upon the web link being entered into a browser, it should present the title and intro text; then ask the questions in the specified order. - Results should be displyed along with the assessment range.

I have produced hand drawn UI diagrams to show the group in the next group meeting.

-- 5 -- Started on 1st Wednesday of February and completed on Saturday 4th Febuary 2017. I realised that the blog needs to be updated each time work is done on the project so in future I will do that instead of one long blog post at the end of the week.

-- 6 --

Allows objects to be passed into the database easily. Can easily pass those objects into the database. Makes it easier to sanitise code?

Might be harder as we were only introduced to it breifly by a lecturer last semester.

-- Other --

As I said, I realised that the better way to do this blog is to post whenever I work on the project. So from here on I will follow this method. But this is a summary of all the work I have done for the group project as of Saturday 4th February 2017