• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month
Page
  1. 1
    1
  2. 2
    2
  3. 3
    3
  4. 4
    4
  5. 5
    5
  6. 6
    6
  7. 7
    7
  8. 8
    8
  9. 9
    9
  10. 10
    10
  11. 11
    11
  12. 12
    12
  13. 13
    13
  14. 14
    14
  15. 15
    15
  16. 16
    16
  17. 17
    17
  • Level: GCSE
  • Subject: ICT
  • Word count: 2706

In this project I have to create an electronic mark book.

Extracts from this document...

Introduction

Time Sheet Week 1 - Plan time sheet and start planning the excel document e.g. what information and what order I should put on the document. Week 2 - Start to create the excel document and put in primary information also look more closely at the formulas deciding what formulae to use. I will make sure that I take screen shot of everything I do while making the excel document to use in my write up Week 3 - Finish creating the excel document and start looking at what graphs to use and what graphs go well with what data. Week 4 - Start creating the write up for the excel document. Week5 - Finish writing the write up and check for mistakes. Week6- Double check for mistakes and hand project in. In this project I have to create an electronic mark book. It will include information on the following in this order Surname, First name, Age, Attendance, 1st Test score, 2nd test score, 3rd Test score, Average Score, Percentage Score, Pass or fail and Grade It will also include 4 different types of formulae. They will be worked out using the Primary data given. Average - I will have 3 sets of raw scores and will use this to find out the average score of each pupil. Lookup Table - I will use this to find what grade each pupil has by comparing Grades to the Average score of the Pupil. Percentage - I'm going to combine my maths knowledge, to create a formula to work out the percentage of a Pupils Total Score. ...read more.

Middle

That's what I had to do for this formula I used the same principle to work out the percentage for it but because I want a percentage for the total amount of test results I had to add all the scores together. This is the formula I came up with. *Note- this is the formula I used in the markbook. A common mistake with writing formulas by hand is that people forget to put an equals (=) sign in. If this is not put in at the beginning Excel will not read it as a formula. If Formula An 'If' formula will look at data and give a separate answer whether it's true or false for example, I want to find out if someone has passed or failed a test, I would use this to look at the data of a pupils total test score and write Pass or Fail depending on how high the score was. This is the formula I used in the Mark book I started the formula off with an Equals Sign '=' then put the name of the formula 'IF' I then opened up some brackets '(' I then put in a logical test which is 'J4>80'. Now all I have to do is put in my Variables (Pass/Fail) I have to open Speech marks at the beginning and at the end of each variable and a comma in between the two. Like this "Pass","Fail" All I have to do now is close the brackets. ...read more.

Conclusion

Well after deciding what graph you would like to do, you begin to write in the data. You must do it with the two axis titles at the top and the information underneath, as shown below. In this project, as well as a scatter graph, I have also made a column chart. The chart is based on attendance It will open another window, which contains a list of graphs and charts as shown on the left, all you have to do is choose one- If you want to preview what the graph will look like before you make it, you would press the control which says 'Press and Hold to View Sample', it will then come up with a picture of the graph about be created. Then all you have to do is press finish. Evaluation In this project I have created an electronic mark book for a teacher. It includes 5 formulae they are: Average Rounding Percent If Lookup What I could have done better In this project I think I should have considered the layout of the excel document more carefully because when it came to making the graphs the information needed was inaccessible to highlight without highlighting other data as well. I have also learnt that I should save work every 15 minutes because at one point I had finished all my work but I hadn't saved it, so now I've started saving backups and saving my work every 15 minutes. I have learnt that most graphs do not work with most data and that I should have considered more carefully about what graphs I used in this project. Page 2 - Professor Dumbledors, mark book, write up ...read more.

The above preview is unformatted text

This student written piece of work is one of many that can be found in our GCSE ICT Systems and Application section.

Found what you're looking for?

  • Start learning 29% faster today
  • 150,000+ documents available
  • Just £6.99 a month

Not the one? Search for your essay title...
  • Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

See related essaysSee related essays

Related GCSE ICT Systems and Application essays

  1. GCSE Calculator Project

    The groups can be "Users" and "Admin". This is very complicated process .For the purpose of this calculator it's acceptable to simply hide the design options from the silver surfers. Design Initial Design User comments User comments on initial design I showed the calculator to a silver surfer and they wrote me a letter.

  2. ICT PROJECT

    When the marks are in numerical e.g.14 out of maximum mark 20, the percentage grade boundaries she used e.g. 85%+ is A*, 80%+ is A, 75%+ is B etc. There are 16 boys and 12 girls, which make overall of 28 students in her class.

  1. GCSE Excel Project ICT

    After data has been inserted into the spreadsheet function, mathematical functions can be created and with the results graphs or charts to display average data easily. In addition, there is a sub-operand called VLOOKUP, VLOOKUP stands for Vertical LOOKUP, which searches for a value in the first column of a

  2. Computer project Alevels

    Data type Validation Rule Validation Text DOCTOR ID Text Like "MCD###" Text you entered is invalid in the field DOCTOR_NO. The entry must be 6 characters long. The first letter must be the letter M, the second letter must be C, and the third letter must be D followed by 3 numbers.

  1. Ict Unit 2b

    Output devices > A printer outputs data that is seen on the computer screen. Most printers are used through a parallel port, but some newer ones use USB connections. USB is somewhat faster, but there's not much of a difference for printers.

  2. Database project

    * He wants to be able to enter new planes to the database and be able to edit them * He wants to be able to enter new rentals to the database and edit them. Output He would like, at any time, to be able to quickly and easily view and print out 1.

  1. Excel Project

    Microsoft Access is very popular among non-programmers who can create visually pleasing and relatively advanced solutions on their own. It is also easy to place a database on a network and have multiple users share and update data without overwriting each other's work.

  2. ICT Project 1A

    Hoffmann hired David Jost and Pat Benzner into the team of creators and authors, and had them give the children instruction on song writing and instrument playing. However, shortly before publication of the first album, Sony terminated their contract. In 2005, Universal Music Group took Tokio Hotel under contract and developed a marketing plan.

  • Over 160,000 pieces
    of student written work
  • Annotated by
    experienced teachers
  • Ideas and feedback to
    improve your own work