Welcome, Haringey Staudents! Notice: SOON, YOU NEED TO LOG IN TO USE THIS SITE.
Lesson 1 Complete all Ps in THREE weeks
Introduce Pivot table (all necessary content have been covered and more.)
Hand in asap and the deadline is 18th November 3pm.
Halfterm
Lesson 7 - P1 & P2
- Design the menu.
- Start the compilation of evidence!
Lesson 6 Create the Overall Sheet and Menu
- The marking process - core units and total points then grade from a lookup table
- Linking cells
- Hyperlink and Macro
- Customisztion and automation
- Testing plan and test result
- By now the model should have been built
- Discussion of marking criteria of the unit, then start collecting evidence
Lesson 5 Create One Sheet for Each Unit of the Course
- Prior to this, you must have
- Used functions (IF, Count, counta, countif, sum, lookup) and AND operator
- Used named cells or absolute cell erference
- Included pie chart and a summary table, (labels edited correctly)
- The sheet must have been checked by teacher for inclusion of name, P criteria, M criteria and D criteria tasks, intermediate grades, and final grade. te final point. Thelayout must be clear and fit for purpose.
- Copy the entire sheet and past it to 16 other sheets
- Name the tabs correctly
- Adjust the P, M & D tasks (the number of them will differ between units)
- Add a new sheet and name suitably for the final overall course result.
- Discuss the content of the overall sheet and its likely layout
Lesson 4 Formatting and More advanced features
- Today’s lesson, (by the end of the lesson, demonstrate the following features in your work)
- Ensure all the functions to work for intermediate grades, the final grade, the final points for the unit.
- To ensure accuracy of the work, Validation, conditional formatting, countA for number of students, countA for number of awards, countif for DMPU distribution, count for number of numbers.
- Copy down, absolute cell reference, named cells.
- Protect the sheet and unlock certain cells.
- Pie chart, editing pie chart – to ensure the chart is up to standard – title, data labels
Lesson 3 Client Requirements and Design
Who is your client? What are the requirements for this solution - grade tracking model ?
How many units? What are their titles? Which ones are core units? How are core units considered in the grading process?
Consideration for the OVERALL sheet. linking sheets for input, core units, total points, grade boundaries, final grade.
Statistics and charts: Max, Average, Min,
Lesson 2 More Functions Applied
Logic operator: AND, OR, NOT
=AND(is he under 19?, has he got 4 or more GCSE A*-C?) --- the result will be TRUE only if the answer is "YES" to both questions. Otherwise the result will be "FALSE"
=IF(AND(is he under 19?, has he got 4 or more GCSE A*-C?), "ENROL him", "Reject him") - enrollment decision
Name the range - the dictionary should be named as L3Grid
Activity: Design a sheet to record the progress of a BTEC student doing "Unit 24 Computer Graphics". Work out the result for one student. Show the intermediate stages of working (show result for P, M and D) before showing the final grade.
Example:
Lesson 1 Know Advanced Features of Spreadsheet
Quick review of the basic features
Formatting; Calculating; Charting & Graphing; Validating and Advanced Functions
Advanced Features Demonstration
Formual vs Function
=A1 + A2 --- a formula
=SUM(A1:A2) --- a function - code to carry out a task. Call its name to get it done.
=SUM(range) --- range = BeginningCell : EndCell
=CountIF(range, "Yes") - to count how many Yes there are in the range.
=Lookup(value, array) - if you see a new word and want to learn its meaning, you would take the "word" to look up in a dictionary. Here "value" is the word to learn; "array" is the dictionary - a range of cells in the spreadsheet.
=IF(comparison, yesOption, noOption) -
example =IF(your hair colour = "red", "do nothing", "dye it red")
Mathematical operators +, -, *, /, ( )