• 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

    Table Relationships can be created to link data value together, once linked this information can be access from any of the tables. Queries enable to user to search for information or a data value with greater ease, however the initial file sizes can be large, when more information and data is inserted it makes it easier to use the information.

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

    AutoNumber fields can't be updated. For example Member ID BYTE: Used to input numbers without decimal or fraction. CURRENCY: Used to input Currency values and numeric data used in mathematical calculations involving data with one to four decimal places. For Example: $4.00. SHORT DATE: First then the day and than the year.

  1. a level ict project

    A maximum of 3 days training must be needed for a user to operate the fundamental features of the database Input - Process - Output of the Proposed System System flowchart of current system Design Possible solutions for the new system A potential solution to the problem presented to Victor,

  2. Ict Unit 2b

    Unlike its "floppy" counterparts, a hard disk can typically hold much more data and is much faster, but is non-removable, or "fixed" to your computer. This is typically where the computer's operating system and other software is installed. The terms "hard disk" and "hard drive" are often used interchangeably since

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

    Otherwise certain other things can easily be changed: * To change the font of any text, simply select the box around it, and choose the new font and size from the toolbar * For any other thing that you wish to change, such as the bar size/colour, gridlines, legend, data

  2. GCSE Calculator Project

    Perform the basic arithmetic functions (of add, multiply, subtract and divide). 2. The font size should be big for people with peer eye sight. 3. The difference between the foreground and background colour should make it easy for the user to read.

  1. Master Prints I.C.T. Project

    The fields Informed, Collected and Invoiced will allow easy-to-use mail merges to be set up. The database will be called MasterPrints and the table tblCustomer. (A list of what data needs to be stored and a full table design with details of each field (type, length, etc)

  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