She Codes TOo Data Analytics Program - Entry Test

Welcome to the SCT Data Analytics Program Entry Test! This test is designed to assess your basic skills in Excel, SQL and programming. Each question is straightforward and focuses on common tasks you’ll encounter in data analysis.

Instructions

1. Clone or download this repository.
2. Open the provided Excel file "SCT__Excel&SQL_test" to complete Q1, Q2 and Q3.
3. Open the provided TXT file "SCT__Programming_test" to compelte the programming questions.
4. Refer to the resources below if you need assistance with any question.
5. Once you’re done, submit your answers in the required format (e.g., upload the completed Excel file and a .txt file).

---

Questions and Resources

Excel

• https://support.microsoft.com/en-gb/office/create-a-simple-formula-in-excel-11a5f0e5-38a3-4115-85bc-f4a465f64a8a

SQL

• https://www.w3schools.com/sql/sql_syntax.asp
• https://www.freecodecamp.org/news/basic-sql-commands/

Programming with Python

• https://www.w3schools.com/python/python_arrays.asp
• https://www.geeksforgeeks.org/python-program-to-find-sum-of-array/

Or with JavaScript

• https://www.geeksforgeeks.org/how-to-find-the-sum-of-all-elements-of-a-given-array-in-javascript/

Submission

• Excel and SQL Questions (Q1 & Q2 & Q3): Complete your answers in the provided Excel file.

• The Programming Questions: Write your answer in the same provided file ( .txt file) or in seperate file using the proper extention

  Good luck, and we look forward to seeing your solutions!

  She Codes Too Team