• 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 Excel Project ICT

    In addition, after the computer is built, the user can then stick the printout onto the customer's computer and use it as a label, to prevent confusion. 3. The user would like to have his customers view four static tables (where he can edit the prices)

  2. a level ict project

    A successful database will provide an automated data entry system complete with pre recorded field names, which the garage employee can respond to with customer/vehicle/job information. The advantages this system can provide include numerous validation as well as verification functions.

  1. Performance Charts - The aim of this task is to produce a simple chart ...

    * From this stage, the aesthetics of the chart can be changed. These are the things such as the colours, text sizes and proportions of the chart. By right clicking on a space on the page, a menu is brought down which allows you to change any options that you have entered into the wizard.

  2. GCSE Calculator Project

    This way saves money as you don't have to re produce the calculator and also saves time. An efficient way to change the interface of the calculator to correspond to the user needs can be done with very little hassle.

  1. This project is designed to help non-computerized library to easily keep track of their ...

    The address, the telephone number and the name of the supplier is written. As the demand of the members rises the new books are bought. To meet the demands of the member. THE BORROWING SYSTEM Equipments: Issuing tray: wooden trays for filling the books ticket and readers card, this contains thirty-one pockets.

  2. Different types of technology How I use ICT at home and at school

    Disadvantages (How it does not meet my needs) While it did have a massive price drop from the original PS3 to PS3 slim, this still kept its position of being the most expensive console out of the big three (Xbox 360 and Nintendo Wii).

  1. GCSE Book DataBase Project

    Alternative Solution The alternative to using ICT to solve this problem is the manual record system that ICT department is already using. They are finding this method difficult and time consuming. They are finding it hard to keep track of the condition of each book and are therefore loosing money no charges due.

  2. Database design for a farmers herd book.

    Advantages 1. Using keyword(s) will retrieve items containing new terms, distinctive words, or jargon. 2. If you do not know the appropriate subject heading, descriptor or identifier for your topic, you can conduct a keyword search first and look at a relevant item for the appropriate controlled vocabulary subject term.

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