Intermediate Computer Technology
Excel Assignment
Class Timed Typing List
The assignment:
This assignment’s layout is up to you as the designer to figure out what would be the best way to set up the spreadsheet. Save the assignment as timedtype_yourlast name. Add these titles on the spreadsheet pages: alpha list, top g.w.a.m., charts
Mrs. Vranesic wants to record the class 5-minute timed type that you did today. You will have to find a quiet way to go around and type in every student’s name (last name first), their g.w.a.m., and the errors. The spreadsheet must have room to add 3 more sessions of 5-minuge timed types.
Mrs. Vranesic also wants to see the class total g.w.a.m. and errors. The class average, class high, class low, and number of students recorded. Students will also need an average for of their timed types.
Make sure the layout clearly includes a descriptive title and heading. Use borders, font styles, and etc. to make the spreadsheet look professional.
Research/Use of Help Menu:
You will need to research how to do the following. Use your resources. The DDC book, the help menu, the Internet, your knowledgeable fellow student.
1. Use an "IF" statement/function to write somewhere on the student’s row the following: If the student has over 50 words a minute, write out "Great Job!" if not write out "Keep Practicing!"
2. Do two "sorts". One sort on the page you are working on should show the student timed type list in order by student’s last name. Put the second sort on the second worksheet (top g.w.a.m.). Sort by the highest g.w.a.m. to the lowest.
3. Make two different types of graphs that will show the class g.w.a.m. for this timed type. .Place them on the 3rd worksheet. Tell which graph does a better job showing the class g.w.a.m. and explain why. (Write this explanation on the graph page.)
