1 / 19

Using Technology to ease the administration burden

Using Technology to ease the administration burden. CAPS Recording Mark Sheets. How does it work?. Will appear at the top of every page. Macro buttons – will not appear on printout. Data & raw results captured here. All calculations & formulae here. Cannot be changed or deleted. Comments.

troybates
Download Presentation

Using Technology to ease the administration burden

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Using Technology to ease the administration burden CAPS Recording Mark Sheets

  2. How does it work?

  3. Will appear at the top of every page Macro buttons – will not appear on printout Data & raw results captured here All calculations & formulae here. Cannot be changed or deleted

  4. Comments

  5. Comments

  6. Getting started

  7. Click on this First to Add Rows. You cannot paste in more names than there are rows! This must also be used IF you need to combine classes (See later on) Getting started

  8. Change grade and date if needed Type name of school Type name of subject educator / head Getting started

  9. How to quickly get Surname, Name in one column (if needed). • Open the spreadsheet containing Surname and Name in two columns, eg a classlist. • If needed, insert a column to the right of the Name column. • In the first cell of this column next to the name, type in the formula shown on the next slide. • Copy and paste the formula to all the other cells below. • Now copy all the combined names. • Open / switch to the mark sheet. • Click / position the cursor in the first row below the Surname, Name heading. • Click on Edit, Paste Special, choose Values, then OK. (NB! Do not simply use Paste – this will paste the formula and NOT the names!)

  10. Taken from a classlist =column and row of Surname cell Followed by&”, “&(space after comma) Then column and row of Name cell Press Enterwhen done Now Copy this formula and Paste it in cells D5 to D8 (in this example) Then Copy the combined Names (cells D4 to D8 in this example). Use Edit,PasteSpecial, Values to paste it in the Mark Sheet.

  11. How to combine 2 or more classes

  12. How to combine 2 or more classes • Open the files you wish to combine • Select ONLY the names and raw data captured, by highlighting them. • Now copy the information • Switch to the first worksheet and position the cursor immediately below the last name (no blank rows). • Click on Paste OR,if using a different program,Click on Edit, Paste Special, choose Values, OK.

  13. Common Issues 1 Funny ### appear when capturing marks. No Total mark captured!

  14. Common Issues 2 Used Copy & Paste from another sheet. (See FAQ 5) Different FONT. Alignment out. Borders different. Marks exceed max. Best to use the mark sheet to capture all names and marks. Different FONT

  15. FAQ Q1. Can I add names to the list afterwards? Yes. Type them at the bottom and click on “Sort”. Q2. Can I add extra columns in the mark sheet? No. The number of tasks is given by CAPS. Q3. How do I remove a learner(s) and his/her marks? Replace the name(s) of the learner(s) with “zzz”. Click Sort. Now select ONLY the “zzz” names and raw scores (not the number or calculations), press “delete” on keyboard. 16

  16. FAQ • Q4. Where can I record the informal assessment of learners? • A new worksheet can easily be inserted into the existing workbook, where this information can be recorded. • Q5. Why did the formatting change when I copied and pasted the information from another excel sheet? • In addition to the data, it also copied the FORMAT from the original location. Instead of using Paste, use Edit, Paste Special, choose Values, OK (Might need original sheet). 17

More Related